Update related table in QSqlRelationalTableModel

Question

I have a QSqlRelationalTableModel like this:

rel_model = QSqlRelationalTableModel(self, connectDB)
rel_model.setTable("main_table")
rel_model.setRelation(1, QSqlRelation("linked_table", "id", "name"))
rel_model.select()

But now the data in the linked_table changed (e.g. a row is added). How can I update the relation to use the modified data of the linked_table.

Note: I don't want to use rel_model.select(), because some data in the main_table were modified too, and they would be discarded then. I am using a SQlite-Database.

Answer 1

Maybe you can look our open Qt project: github

This project contains a wrapper above QSqlTableModel + QTableView and realize PblTableDlg class with basic table functionaliy. We used a new variant of QSqlRelationalTableModel = PblSqlRelationalTableModel.