PyQt4: My database displays empty cells

[Danny Hatt]

Hello everyone.

I am using the pyqt4 framework to do some displays for database forms. Unfortunately, I hit a snag while trying to filter and display my database by last name. Assume that the database connection works. Also assume that I have the correct amount of items in my tupleHeader since I use the same initializeModel method for other methods (like the search() function described below, and it works fine.

I call the display() function and it works perfectly fine, but when creating a proxyModel from the sourceModel, and trying to display the proxyModel with my search function, I have empty cells displayed. When I restrict my search so that it filters half my database, it shows that many cells (so most of this is working). But it will not display anything from the database itself.

Below is some of my code:

from PyQt4 import QtGui, QtCore, QtSql
 
    self.caseSensitivity = QtCore.Qt.CaseInsensitive
    self.syntax = QtCore.QRegExp.FixedString
 
    def initializeModel(self, model):
        model.setTable(self.table)
        #model.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit)
        b = 0
        for a in self.tupleHeader:
            model.setHeaderData(b, QtCore.Qt.Horizontal, QtGui.qApp.tr(a))
            b += 1
        model.select()
 
 
    def display(self):
        '''reads all row data and displays it on a tableview'''
        self.connectdb(self.db, self.localhost, self.dbname, self.username, self.password)
 
        model = QtSql.QSqlTableModel()
        self.initializeModel(model)
        self.view.setModel(model)
 
        self.disconnectdb(self.db)
 
 
    def search(self, searchQuery):
        '''queries database data, filters it, and displays it on a tableview'''      
        sourceModel = QtSql.QSqlTableModel()
        proxyModel = QtGui.QSortFilterProxyModel()
 
        self.initializeModel(sourceModel)
        proxyModel.setSourceModel(sourceModel) # allows to edit proxyModel without changing underying model
 
        #searchQuery contains the last name that I am filtering with
        regExp = QtCore.QRegExp(searchQuery, self.caseSensitivity, self.syntax)
        proxyModel.setFilterRegExp(regExp)
        proxyModel.setFilterKeyColumn(2) # this column holds the last names
 
         # self.view contains the table itemview my application uses to display the database
        self.view.setModel(proxyModel)

from PyQt4 import QtGui, QtCore, QtSql

    self.caseSensitivity = QtCore.Qt.CaseInsensitive
    self.syntax = QtCore.QRegExp.FixedString

    def initializeModel(self, model):
        model.setTable(self.table)
        #model.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit)
        b = 0
        for a in self.tupleHeader:
            model.setHeaderData(b, QtCore.Qt.Horizontal, QtGui.qApp.tr(a))
            b += 1
        model.select()

    
    def display(self):
        '''reads all row data and displays it on a tableview'''
        self.connectdb(self.db, self.localhost, self.dbname, self.username, self.password)

        model = QtSql.QSqlTableModel()
        self.initializeModel(model)
        self.view.setModel(model)
        
        self.disconnectdb(self.db)

    
    def search(self, searchQuery):
        '''queries database data, filters it, and displays it on a tableview'''      
        sourceModel = QtSql.QSqlTableModel()
        proxyModel = QtGui.QSortFilterProxyModel()
        
        self.initializeModel(sourceModel)
        proxyModel.setSourceModel(sourceModel) # allows to edit proxyModel without changing underying model
        
        #searchQuery contains the last name that I am filtering with
        regExp = QtCore.QRegExp(searchQuery, self.caseSensitivity, self.syntax)
        proxyModel.setFilterRegExp(regExp)
        proxyModel.setFilterKeyColumn(2) # this column holds the last names
        
         # self.view contains the table itemview my application uses to display the database
        self.view.setModel(proxyModel)

To copy to clipboard, switch view to plain text mode 

I am not interested in keeping this piece of code, I just want to know why allows the table to show the table's content instead of a bunch of empty cells

print self.proxyModel.filterAcceptsRow(2, self.sourceModel)

print self.proxyModel.filterAcceptsRow(2, self.sourceModel)

To copy to clipboard, switch view to plain text mode 

Also, if you put in this after the last statement ( self.view.setModel(proxyModel) ), it will show the table, even if it does send an error:

print self.proxyModel.filterAcceptsRow(2, self.sourceModel)
TypeError: QSortFilterProxyModel.filterAcceptsRow(int, QModelIndex): argument 2 has unexpected type 'QSqlTableModel'

It doesn't matter what the arguments are or whether I use filterAcceptsRow ro filterAcceptsColumn, it displays the table. Does this narrow down the problem some?

Thank you for your time searching for this coding error/bug, and happy hunting!

[Danny Hatt]

While I could not find the solution to my problem, it solved itself. I am not certain, but I think it was this code snippet that made it work.

self.dbmanip = CoreDB(self.userTableView, self.table)

This was put inside of the SetupUi() method created by the Qt4 Designer. I think either the dbmanip that contained the TableView lost the information from the proxyModel, or (more likely), I may have referenced the wrong table between the proxyModel and the original Model (that created the proxyModel), and then couldn't display because it was calling the cell structure from one table and the actual information from another.

These are all guesses though. Still, problem solved.