QSqlTableModel ... is possible update data without QAbstractmodel?

[gfxx]

I use QSqlTableModel for show in gui a sqlite table of data. The data lines are continually added according to a ramdon pattern but about every 2-3 minutes. However, updates may take up to 0.5 to 2 seconds. So when the user looks at the QTableView, the data is added to the database, but the user does not see the change. Can SqlTableView update data in "real time" and wihout using QAbstractModel mechanism? I have a lot of tableview, and many different so the make very long my code.

these project run over ubuntu 14.04 64bit sqlite3 and qt5.6 c++.

regards
giorgio

[raven-worx]

@gfxx
what is a QSqlTableView?! At least not a class that is shipped within Qt packages.

[gfxx]

@raven-worx real sorry .... I correct the post.

[raven-worx]

@gfxx said in QSqlTableModel ... is possible update data without QAbstractmodel?:

Can SqlTableView update data in "real time" and wihout using QAbstractModel mechanism?

since the Qt item views are all based upon a common data source interface (QAbstractItemModel) ... no.

So my advice:

1. implement a common QAbstractItemModel class
2. fetch the SQL data in the background
3. update the cached data in your custom model implementation with the result from the query

Share the model across views as much as possible.

[gfxx]

@raven-worx I was hoping for some shortcuts .... but thanks the same

regards
giorgio