Qt wiki will be updated on October 12th 2023 starting at 11:30 AM (EEST) and the maintenance will last around 2-3 hours. During the maintenance the site will be unavailable.
QML and QSqlTableModel: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
[[Category:snippets]]<br />[[Category:Developing_with_Qt::Qt Quick::Tutorial]] | |||
= QML and QSqlTableModel = | |||
I wrote a simple class derived from QSqlRelationalTableModel to facilitate the use of such classes with QML, without manually defining the roles. | |||
The data method returns the value of the role used. If there is a relationship in the table, i search the column with relation and return the correct value.. Note that empty string is returned when the item is not found and not QVariant value, in order to have a correct visualization in < | If you want to understand why roles are so important when working with SQL table models and QML, have a look at "this explained code snippet&quot;:http://wiki.qt.io/How_to_use_a_QSqlQueryModel_in_QML | ||
<code> | |||
class QLSqlTableModel : public QSqlRelationalTableModel<br />{<br /> Q_OBJECT<br />private:<br /> QHash&lt;int, QByteArray&gt; roles; | |||
public:<br /> QLSqlTableModel(QObject *parent = 0);<br /> ~QLSqlTableModel();<br /> Q_INVOKABLE QVariant data(const QModelIndex &index, int role=Qt::DisplayRole ) const;<br /> void generateRoleNames();<br />#ifdef HAVE_QT5<br /> virtual QHash&lt;int, QByteArray&gt; roleNames() const{return roles;}<br />#endif<br />} | |||
QVariant QLSqlTableModel::data ( const QModelIndex & index, int role ) const<br />{<br /> if(index.row() >= rowCount())<br /> return QString("");<br /> }<br /> if(role < Qt::UserRole)<br /> {<br /> return QSqlQueryModel::data(index, role);<br /> }<br /> else {<br /> // search for relationships<br /> for (int i = 0; i < columnCount(); i+'') {<br /> if (this->relation(i).isValid()) {<br /> return record(index.row()).value(QString(roles.value(role)));<br /> }<br /> }<br /> // if no valid relationship was found<br /> return QSqlQueryModel::data(this->index(index.row(), role - Qt::UserRole - 1), Qt::DisplayRole);<br /> } | |||
<br /></code> | |||
<br />The data method returns the value of the role used. If there is a relationship in the table, i search the column with relation and return the correct value.. Note that empty string is returned when the item is not found and not QVariant value, in order to have a correct visualization in QML. | |||
<br /><code><br />void QLSqlTableModel::generateRoleNames()<br />{<br /> roles.clear();<br /> int nbCols = this->columnCount();<br /> for (int i = 0; i < nbCols; i) {<br /> roles[Qt::UserRole'' i + 1] = QVariant(this->headerData(i, Qt::Horizontal).toString()).toByteArray(); | |||
}<br />#ifndef HAVE_QT5<br /> setRoleNames(roles);<br />#endif<br />} | |||
</code> | |||
The generateRoleNames method creates the roles called as the table columns specified in the header. | The generateRoleNames method creates the roles called as the table columns specified in the header. | ||
| Line 12: | Line 27: | ||
Tables: | Tables: | ||
<code><br />query.exec&amp;#40;"create table IF NOT EXISTS items (id integer primary key autoincrement,<br />name varchar(15&amp;#41;, descr varchar(30))");<br /> query.exec&amp;#40;"create table IF NOT EXISTS lista (id integer primary key autoincrement,<br />qta varchar(30&amp;#41;, item INTEGER, FOREIGN KEY (item) REFERENCES items(id))");<br /></code> | |||
main.cpp | main.cpp | ||
<code><br />QLSqlTableModel *model = new QLSqlTableModel;<br /> QLSqlTableModel *modelLista = new QLSqlTableModel;<br /> model->setTable("items&quot;);<br /> model->generateRoleNames();<br /> model->select();<br /> modelList->setTable("lists&quot;);<br /> modelList->setRelation(2, QSqlRelation("items&quot;, "id&quot;, "name&quot;));<br /> modelList->select();<br /> modelList->generateRoleNames();<br /> QDeclarativeContext *ctxt = view.rootContext();<br /> ctxt->setContextProperty("modelListItems&quot;, model);<br /> ctxt->setContextProperty("modelList&quot;, modelLista); | |||
</code> | |||
In qml file<br /><code><br />Text {<br /> id: name<br /> text: model.name<br /> font.bold: true; font.pointSize: 16<br /> color: "white&quot;<br /> }<br /> Text {<br /> text: "Amount: " + model.qta<br /> font.pointSize: 16<br /> opacity: 1<br /> color: "white&quot;<br /> }<br /></code> | |||
----- | |||
Note1:<br />Nice post, however the performance can be tweaked. data() will be called very often. Most of the processing and object instantiation should be done only once. | |||
Note2:<br />I modified provided code according to "this working example&quot;:http://stackoverflow.com/questions/14613824/qsqltablemodel-inheritor-and-qtableview which was based on this wiki page | |||
Revision as of 14:44, 23 February 2015
QML and QSqlTableModel
I wrote a simple class derived from QSqlRelationalTableModel to facilitate the use of such classes with QML, without manually defining the roles.
If you want to understand why roles are so important when working with SQL table models and QML, have a look at "this explained code snippet":http://wiki.qt.io/How_to_use_a_QSqlQueryModel_in_QML
class QLSqlTableModel : public QSqlRelationalTableModel<br />{<br /> Q_OBJECT<br />private:<br /> QHash&lt;int, QByteArray&gt; roles;
public:<br /> QLSqlTableModel(QObject *parent = 0);<br /> ~QLSqlTableModel();<br /> Q_INVOKABLE QVariant data(const QModelIndex &index, int role=Qt::DisplayRole ) const;<br /> void generateRoleNames();<br />#ifdef HAVE_QT5<br /> virtual QHash&lt;int, QByteArray&gt; roleNames() const{return roles;}<br />#endif<br />}
QVariant QLSqlTableModel::data ( const QModelIndex & index, int role ) const<br />{<br /> if(index.row() >= rowCount())<br /> return QString("");<br /> }<br /> if(role < Qt::UserRole)<br /> {<br /> return QSqlQueryModel::data(index, role);<br /> }<br /> else {<br /> // search for relationships<br /> for (int i = 0; i < columnCount(); i+'') {<br /> if (this->relation(i).isValid()) {<br /> return record(index.row()).value(QString(roles.value(role)));<br /> }<br /> }<br /> // if no valid relationship was found<br /> return QSqlQueryModel::data(this->index(index.row(), role - Qt::UserRole - 1), Qt::DisplayRole);<br /> }
<br />
The data method returns the value of the role used. If there is a relationship in the table, i search the column with relation and return the correct value.. Note that empty string is returned when the item is not found and not QVariant value, in order to have a correct visualization in QML.
<br />void QLSqlTableModel::generateRoleNames()<br />{<br /> roles.clear();<br /> int nbCols = this->columnCount();<br /> for (int i = 0; i < nbCols; i) {<br /> roles[Qt::UserRole'' i + 1] = QVariant(this->headerData(i, Qt::Horizontal).toString()).toByteArray();
}<br />#ifndef HAVE_QT5<br /> setRoleNames(roles);<br />#endif<br />}
The generateRoleNames method creates the roles called as the table columns specified in the header.
Example:
Tables:
<br />query.exec&amp;#40;"create table IF NOT EXISTS items (id integer primary key autoincrement,<br />name varchar(15&amp;#41;, descr varchar(30))");<br /> query.exec&amp;#40;"create table IF NOT EXISTS lista (id integer primary key autoincrement,<br />qta varchar(30&amp;#41;, item INTEGER, FOREIGN KEY (item) REFERENCES items(id))");<br />
main.cpp
<br />QLSqlTableModel *model = new QLSqlTableModel;<br /> QLSqlTableModel *modelLista = new QLSqlTableModel;<br /> model->setTable("items&quot;);<br /> model->generateRoleNames();<br /> model->select();<br /> modelList->setTable("lists&quot;);<br /> modelList->setRelation(2, QSqlRelation("items&quot;, "id&quot;, "name&quot;));<br /> modelList->select();<br /> modelList->generateRoleNames();<br /> QDeclarativeContext *ctxt = view.rootContext();<br /> ctxt->setContextProperty("modelListItems&quot;, model);<br /> ctxt->setContextProperty("modelList&quot;, modelLista);
In qml file
<br />Text {<br /> id: name<br /> text: model.name<br /> font.bold: true; font.pointSize: 16<br /> color: "white&quot;<br /> }<br /> Text {<br /> text: "Amount: " + model.qta<br /> font.pointSize: 16<br /> opacity: 1<br /> color: "white&quot;<br /> }<br />
Note1:
Nice post, however the performance can be tweaked. data() will be called very often. Most of the processing and object instantiation should be done only once.
Note2:
I modified provided code according to "this working example":http://stackoverflow.com/questions/14613824/qsqltablemodel-inheritor-and-qtableview which was based on this wiki page