VimProject | All about my vim projects | Text Editor library

I've recently examined an example from Chapter 15 of “Rapid GUI Programming with Python and Qt” by Mark Summerfield which presents the use of SQL Database TableView modelling. In this original example, I found a little dysfunctionality which prevents the table views from refreshing combobox delegates (being QSqlRelation). Simply, the combobox delegates in the table view which represent the data of QSqlRelationalTableModel, are not updated once relational tables have been modified.

The original file name is chap15/assetmanager.pyw and can be find elsewhere. Below I provide a code snippet necessary to reproduce the problem.

In this example, a relation with QSqlTableModel (self.assetModel and self.logModel) is established for actions and categories (QSqlRelationalTableModel) which can be modified using the combobox delegates (LogDelegate or AssetDelegate). New actions or categories can be added through the ReferenceDataDlg dialog.

New record added in Categories

However, once the dialog ReferenceDataDlg is closed the newly created record does not appear in the combobox delegate even though the new records exist in the SQL table for actions or categories.

Combobox delegate not refreshed

How can I programmatically refresh the list of items in the combobox delegate in the table views: self.assetView and self.logView?