[PyQt] [Solved]Help displaying a table with QSqlTableModel

[Axel_Erfurt]

I think the database (or table) is not loaded at all.
The error may be somewhere in Constants, but only you know the content.

A simple test to load the db

from PyQt5.QtWidgets import QMainWindow, QApplication, QTableView
from PyQt5.QtSql import QSqlDatabase, QSqlTableModel


class TableTest(QMainWindow):
    def __init__(self, parent = None):
        super(TableTest, self).__init__(parent)
        
        self.db = QSqlDatabase.addDatabase('QSQLITE')
        self.db.setDatabaseName("inventory.db")
        self.model = QSqlTableModel()
     
        self.CategoryTableView = QTableView()
        self.CategoryTableView.setModel(self.model)
        self.setCentralWidget(self.CategoryTableView)
     
        self.model.setTable('items')
        self.model.select()   
        self.show()     

if __name__ == "__main__":
    import sys
    app = QApplication(sys.argv)
    ui = TableTest()
    sys.exit(app.exec_())