QSqlRelationalTableModel, QSortFilterProxyModel and QDataWidgetMapper

by Martin Fitzpatrick Last updated PyQt5 FAQ
Heads up! You've already completed this tutorial.

friedhelm | 2021-04-20 15:05:30 UTC | #1

There are two tables with one to many relation companies and resources. The models above works fine with table views and combobox for the company names for the index in the second table. For an selected row the form will be correct filled via the the QDataWidgetMapper.

Now I extend the game and extend it with sorting for columns in the tables

self.proxyModel = QSortFilterProxyModel() self.proxyModel.setSourceModel(self.model) self.setSortingEnabled(True) self.setModel(self.proxyModel)

This gives two Side effects:

  • The combobox for the company names are not in the second table
  • If I sort one of the table and select a row for editing, I got an wrong rowid and as result a form for an wrong dataset

How can I fix the 'row' disaster?

Create GUI Applications with Python & Qt5 by Martin Fitzpatrick — (PyQt5 Edition) The hands-on guide to making apps with Python — Over 10,000 copies sold!

More info Get the book

Well done, you've finished this tutorial! Mark As Complete
[[ user.completed.length ]] completed [[ user.streak+1 ]] day streak

QSqlRelationalTableModel, QSortFilterProxyModel and QDataWidgetMapper was written by Martin Fitzpatrick .

Martin Fitzpatrick has been developing Python/Qt apps for 8 years. Building desktop applications to make data-analysis tools more user-friendly, Python was the obvious choice. Starting with Tk, later moving to wxWidgets and finally adopting PyQt.

QSqlRelationalTableModel, QSortFilterProxyModel and QDataWidgetMapper was published in faq on (updated ) . Feedback & Corrections welcome in our public issue tracker.

 pyqt5 pyqt qtableview python qt qt5