Map multiple rows with multiple widgets

Mr. Kibu

Hi,

I have got a QSqlTableModel with multiple rows (e.g. 3 rows). Now I want to map the data with multiple widgets. Each row should map to one widget, the mapped widget should be placed horizontal side by side. It should look like this:

tree widgets

I create the widgets side by side like this:

    numberOfRows = model->rowCount();

    // add a widget for each row
    for (int i=0;i<numberOfRows;++i)
    {
        myWidget = new RowWidget();
        ui->QLayout->addWidget(myWidget);
    }

How do I map the data with the widgets, to show in one widget the data of one row (and if I edit the data in the widget the result will be submited to the database)

Thank you!

Franz

michelson

I would do it in the myWidget constructor, just add parameters for everything you need, assuming the link you provided constructor canlook like:

explicit  myWidget(QString row1, int row2, double row2, QWidget* parent = 0);

and than just bind data when creating them in for loop.

SGaist

Hi,

Looks like a job for QDataWidgetMapper

Mr. Kibu

Yes, I thought also in this direction. I have tried this:

    numberOfRows = model->rowCount();

    mapper = new QDataWidgetMapper(this);
    mapper->setModel(model);
    mapper->setItemDelegate(new QSqlRelationalDelegate(mapper));

    // add a widget for each row
    for (int i=0;i<numberOfRows;++i)
    {
        myWidget = new RowWidget();
        ui->QLayout->addWidget(myWidget);

        mapper->addMapping(myWidget->SpinBox,2);
        mapper->addMapping(myWidget->DoubleSpinBox,3);
    }

   mapper->toFirst();

But the code above did not worked correct (I have in every widget the data of the last row!!). How do I install the mapper to have in every widget the data of one row?

SGaist

Use one mapper per RowWidget.

One solution would be to have the mapper itself in RowWidget, have a setModel and a setRow method also in RowWidget so you can build them and change the row used by the mapper as you wish.

Mr. Kibu

I did it! I added the QDataWidgetMapper in the constructor of RowWidget. On creating the myWidget in the for loop, I commit the rowID of the row which is shown in the widget.

Thanks to all!

kshegunov

@Mr.-Kibu
Have in mind that QDataWidgetMapper has a known bug/deficiency when working with relational sql model and having a combo box for the foreign key.

Mr. Kibu

Thank you for the info, I don't know that. Where can I get more informations about this bug?

kshegunov

@Mr.-Kibu
Take a look at this thread.

EDIT: Also this bug report.