Setting QSqlTableModel from c++ to .qml tableView

heczaco

I have a tableview on a qmlfile, I'm trying to set the model from c++.

The model I'm using is QSqlTableModel, if a create a new tableview and set the model from c++ it seems to work, but when I pass the model to the model property in the qmlfile it doesn't work and I can't figure out why...

the c++ model code is:
QSqlTableModel * SqlEventModel::getTableData(QString tableName, QTableView *item){

	const QString queryStr = "SELECT sql FROM sqlite_master WHERE tbl_name = '" + tableName +"' AND type = 'table'" ;
	QSqlQuery query(queryStr);
	if (!query.exec())
		qFatal("Query failed");


	QSqlDatabase db = QSqlDatabase::database(":memory:");

	QSqlTableModel *model = new QSqlTableModel(item, db);
	model->setTable(tableName);
	model->setEditStrategy(QSqlTableModel::OnManualSubmit);
	model->select();


	int i=0;
	while (query.next()){
		model->setHeaderData(i, Qt::Vertical, query.value(i).toString());
		i++;
	}

   return   model;

}

that returns a model which works if within c++ I create a tableview and assign the model but when I do this:

TableView{
	id: table;
	width: parent.width -100
	height: parent.height -200
	anchors.horizontalCenter: parent.horizontalCenter
	anchors.top: parent.top
	anchors.topMargin: 90
	model: SqlEventModel.getTableData(GData.tName,table)
}

it doesn't work, it just shows an empty table even though when I debug the tableview model is not empty...

if I add:

QTableView *view =  new QTableView();
view->setModel(model);
view->show();

just before the return on the c++ function I get a new window with a table which properly displays the table... I tried adding columns with the same rolename that I give in c++ and they won't populate either.... here's a screenshot of both tables

http://i.stack.imgur.com/gGzhu.png

SGaist

Hi and welcome to devnet,

To make models accessible to QML you have to do sum customization like described in the QtQuick Model Views Data documentation.

QSqlTableModel example here