QComboBox - Delegate - QDataWidgetMapper - QSqlRelationalTableModel

[jorge.saridis]

Amazing, I found the answer myself digging in Qt examples. Here is the code:

model->setTable("centros_programas");
model->setRelation(1, QSqlRelation("provincias", "id_provincias", "nombre"));
 
model->setEditStrategy(QSqlTableModel::OnManualSubmit);
model->select();
 
model->setHeaderData(0, Qt::Horizontal, QObject::tr("Id"));
model->setHeaderData(1, Qt::Horizontal, QObject::tr("Provincia"));
model->setHeaderData(2, Qt::Horizontal, QObject::tr("Centro/Programa"));
model->setHeaderData(3, Qt::Horizontal, QObject::tr("Tipo"));
 
ui->comboBoxProvincia->setModel(model->relationModel(1) );
ui->comboBoxProvincia->setModelColumn(model->relationModel(1)->fieldIndex("nombre"));
 
ui->table->setModel(model);
ui->table->setColumnHidden(0, true);
 
ui->table->setItemDelegate( new QSqlRelationalDelegate( ui->table ));
 
mapper = new QDataWidgetMapper(this);
mapper->setModel(model);
mapper->setItemDelegate(new QSqlRelationalDelegate(this));
mapper->addMapping(ui->comboBoxProvincia, 1);
mapper->addMapping(ui->lineEditCentro, model->fieldIndex("nombre") );
mapper->addMapping(ui->lineEditTipo, model->fieldIndex("tipo") );
mapper->setSubmitPolicy(QDataWidgetMapper::ManualSubmit);
 
connect(ui->table->selectionModel(), SIGNAL( currentChanged(QModelIndex,QModelIndex) ), mapper, SLOT( setCurrentModelIndex(QModelIndex) ));
 
ui->table->setCurrentIndex(model->index(0, 0));

model->setTable("centros_programas");
model->setRelation(1, QSqlRelation("provincias", "id_provincias", "nombre"));

model->setEditStrategy(QSqlTableModel::OnManualSubmit);
model->select();

model->setHeaderData(0, Qt::Horizontal, QObject::tr("Id"));
model->setHeaderData(1, Qt::Horizontal, QObject::tr("Provincia"));
model->setHeaderData(2, Qt::Horizontal, QObject::tr("Centro/Programa"));
model->setHeaderData(3, Qt::Horizontal, QObject::tr("Tipo"));

ui->comboBoxProvincia->setModel(model->relationModel(1) );
ui->comboBoxProvincia->setModelColumn(model->relationModel(1)->fieldIndex("nombre"));

ui->table->setModel(model);
ui->table->setColumnHidden(0, true);

ui->table->setItemDelegate( new QSqlRelationalDelegate( ui->table ));

mapper = new QDataWidgetMapper(this);
mapper->setModel(model);
mapper->setItemDelegate(new QSqlRelationalDelegate(this));
mapper->addMapping(ui->comboBoxProvincia, 1);
mapper->addMapping(ui->lineEditCentro, model->fieldIndex("nombre") );
mapper->addMapping(ui->lineEditTipo, model->fieldIndex("tipo") );
mapper->setSubmitPolicy(QDataWidgetMapper::ManualSubmit);

connect(ui->table->selectionModel(), SIGNAL( currentChanged(QModelIndex,QModelIndex) ), mapper, SLOT( setCurrentModelIndex(QModelIndex) ));

ui->table->setCurrentIndex(model->index(0, 0));

To copy to clipboard, switch view to plain text mode 

I had to set a delegate in two places, the table view and the mapper.
These two lines:

ui->table->setItemDelegate( new QSqlRelationalDelegate( ui->table ));
 
mapper->setItemDelegate(new QSqlRelationalDelegate(this));

ui->table->setItemDelegate( new QSqlRelationalDelegate( ui->table ));

mapper->setItemDelegate(new QSqlRelationalDelegate(this));

To copy to clipboard, switch view to plain text mode 

I hope this can help.

[pcheng]

Hi, Jorge.

I tried to follow your code to fix my problem which seems to be similar to what you have.

Here is my code:

// Setup the model to use in the mapper
    model = new QSqlRelationalTableModel(this);
    model->setTable("Orders");
    //model->select();
    model->setRelation(7, QSqlRelation("customers", "CustomerNumber", "Name"));
    model->setRelation(5, QSqlRelation("employee", "EmployeeNumber", "UserName"));
 
    Qt::SortOrder order = Qt::AscendingOrder;
    model->sort(0, order);
 
    ui->customerComboBox->setModel(model->relationModel(7));
    ui->customerComboBox->setModelColumn(model->relationModel(7)->fieldIndex("Name"));
 
    ui->employeeComboBox->setModel(model->relationModel(5));
    ui->employeeComboBox->setModelColumn(model->relationModel(5)->fieldIndex("LastName"));
 
    // Setup the mapper for the order widgets
    mapper = new QDataWidgetMapper(this);
    mapper->setSubmitPolicy(QDataWidgetMapper::AutoSubmit);
    mapper->setModel(model);
    mapper->setItemDelegate(new QSqlRelationalDelegate(this));
    mapper->addMapping(ui->idLineEdit, 0);
    mapper->addMapping(ui->fullfilledCheckBox,1);
    mapper->addMapping(ui->fullfilledDateEdit, 2);
    mapper->addMapping(ui->orderDateEdit, 3);
    mapper->addMapping(ui->dueDateEdit, 4);
    mapper->addMapping(ui->employeeComboBox, model->fieldIndex("Employee_EmployeeNumber"), "currentIndex");
    mapper->addMapping(ui->dueTimeEdit, 6);
    mapper->addMapping(ui->customerComboBox, model->fieldIndex("customers_CustomerNumber"), "currentIndex");

// Setup the model to use in the mapper
    model = new QSqlRelationalTableModel(this);
    model->setTable("Orders");
    //model->select();
    model->setRelation(7, QSqlRelation("customers", "CustomerNumber", "Name"));
    model->setRelation(5, QSqlRelation("employee", "EmployeeNumber", "UserName"));

    Qt::SortOrder order = Qt::AscendingOrder;
    model->sort(0, order);

    ui->customerComboBox->setModel(model->relationModel(7));
    ui->customerComboBox->setModelColumn(model->relationModel(7)->fieldIndex("Name"));

    ui->employeeComboBox->setModel(model->relationModel(5));
    ui->employeeComboBox->setModelColumn(model->relationModel(5)->fieldIndex("LastName"));

    // Setup the mapper for the order widgets
    mapper = new QDataWidgetMapper(this);
    mapper->setSubmitPolicy(QDataWidgetMapper::AutoSubmit);
    mapper->setModel(model);
    mapper->setItemDelegate(new QSqlRelationalDelegate(this));
    mapper->addMapping(ui->idLineEdit, 0);
    mapper->addMapping(ui->fullfilledCheckBox,1);
    mapper->addMapping(ui->fullfilledDateEdit, 2);
    mapper->addMapping(ui->orderDateEdit, 3);
    mapper->addMapping(ui->dueDateEdit, 4);
    mapper->addMapping(ui->employeeComboBox, model->fieldIndex("Employee_EmployeeNumber"), "currentIndex");
    mapper->addMapping(ui->dueTimeEdit, 6);
    mapper->addMapping(ui->customerComboBox, model->fieldIndex("customers_CustomerNumber"), "currentIndex");

To copy to clipboard, switch view to plain text mode 

but my combo boxes do not synchronize with the database. I see the values in the combo boxes but when the mapper loads it shows the first item always. And if I change an item and save it does not change the item.

Any ideas where I am going wrong?

Pericles