Can a QSqlModel be converted to a QStandardItemModel

[sgmurphy19]

Is there a more straightforward way to convert a QSqlModel to a QStandardItemModelOther than:

qstandarditemmodel->insertRows(0, qsqlmodel->rowCount());
qstandarditemmodel->insertColumns(0, qsqlmodel->columnCount());
for(int c=0; c<qsqlmodel->columnCount(); c++)
{
	qstandarditemmodel->setHeaderData(c, Qt::Horizontal, qsqlmodel->headerData(c, Qt::Horizontal));
	for(int r=0; r<qsqlmodel->rowCount(); r++)
	{
		qstandarditemmodel->setData(qstandarditemmodel->index(r, c), qsqlmodel->record(r).value(c));
	}
}

qstandarditemmodel->insertRows(0, qsqlmodel->rowCount());
qstandarditemmodel->insertColumns(0, qsqlmodel->columnCount());
for(int c=0; c<qsqlmodel->columnCount(); c++)
{
	qstandarditemmodel->setHeaderData(c, Qt::Horizontal, qsqlmodel->headerData(c, Qt::Horizontal));
	for(int r=0; r<qsqlmodel->rowCount(); r++)
	{
		qstandarditemmodel->setData(qstandarditemmodel->index(r, c), qsqlmodel->record(r).value(c));
	}
}

To copy to clipboard, switch view to plain text mode 

Thanks in advance

[wysota]

It might prove faster to subclass the sql model and add the functionality you need. What do you need the standard item model for?

[sgmurphy19]

I need to be able to update the cells directly. Basically I can't have it read only. Yet I can't use the relationship model because the table relationships are too complex.

[wysota]

Maybe you could just make a view in your database and use QSqlTableModel to operate on it?