Put data in TableView after SQl query

Karoluss96

@NYBL You mean by SQL?
I can't because the database is big and keep sensitive data.
I make this code for an app for QGIS plug-in, in which every question is make after choosing current option in ComboBox

JonB

@Karoluss96
You should not be using QStandard... for records from a SQL database. You should use either QSqlTableModel or QSqlQueryModel for the database query and a QTableView with that as a model. Then it should display your received rows/columns. You will not need to use insertColumn() or appendRow() either. the query should fill the model and the view should display what is in the model.

Karoluss96

I'm trying by using your option:

 global model
        q= QSqlQueryModel()
        model = QTableView()
        res=QStandardItem()
        if con == Zest[0]:
           sql2 = "SELECT * FROM ZARZADZANIE.ZAMOWIENIA_WG_STATUS_V"#zapytanie nie działa :-(
           query.exec_(sql2)
           a=q.setQuery(sql2)
           self.dlg.tableView_5.setModel(a)
           while query.next():
               a=res.setQuery(q)
               b=res.insertColumns(a)
               model.appendRow(b)
           self.dlg.tableView_5.show()
        if con == Zest[1]:       
            plan22 = "SELECT * FROM ZARZADZANIE.ZAMOWIENIA where ROK_PLANOWANIA=2022"
            query.exec_(plan22)
            a=q.setQuery(plan22)
            self.dlg.tableView_5.setModel(a)
                        print (a)
                        while query.next():
                            a=model.setQuery(q)
                            b=res.insertColumns(a)
                            model.appendRow(b)
                        self.dlg.tableView_5.show()

but nothing appears in Table View. Sth should I make wrong?

jsulm

@Karoluss96 You should put more context - where is this code actually located? I guess some method?
The problem is probably that you are creating local variables which are destroyed as soon as they go out of scope.

Karoluss96

It's a part of function to put data from selected sql in combobox to table View.

Begins of it looks that:

 def zestawienia (self): #obsługa zakładki zestawień
        con= self.dlg.comboBox_6.currentText()
        global model
        q= QSqlQueryModel()
        model = QTableView()
        res=QStandardItem()
        if con == Zest[0]:
...

It vision is easy- from combo box show SQL's anwser in TableView below
na forum.PNG

jsulm

@Karoluss96 As I wrote: you are creating local variables, make them class members instead...

Karoluss96

You mean by put some variables in definition of function - next to (self) in brackets?
Or put eg. ..setquery and insertColumns at the beginning before if loop?

jsulm

@Karoluss96 For example:

self.model = QTableView()

Karoluss96

I've done:

 self.q= QSqlQueryModel()
 self.model = QTableView()
if con == Zest[0]:
           sql2 = "SELECT * FROM ZARZADZANIE.ZAMOWIENIA_WG_STATUS_V"#zapytanie nie działa :-(
           query.exec_(sql2)
           a=q.setQuery(sql2)
           self.dlg.tableView_5.setModel(a)

but i gains error in loof if: local variable 'q' referenced before assignment

jsulm

@Karoluss96 said in Put data in TableView after SQl query:

local variable 'q' referenced before assignment

it is self.q now, not just q...

Karoluss96

so where i have to put

self.model = QTableView()

as you suggested?

jsulm

@Karoluss96 In the code you already posted!

def zestawienia (self): #obsługa zakładki zestawień
        con= self.dlg.comboBox_6.currentText()
        global model
        self.q= QSqlQueryModel()
        self.model = QTableView()
        res=QStandardItem()
        if con == Zest[0]:

JonB

@Karoluss96
You need to understand about things like variable scopes as a part of Python not Qt. Just saying.

I see you still have a QStandardItem. I cannot imagine why. As I said, you simply fill your model from SQL and attach a QTableView to it, that's it.

And please do not name as model something which is a QTableView, it's incredibly confusing.

Karoluss96

I changed assigning QTableView from model to table.
Then I put it into

self.dlg.tableView_5.setModel(table)

but it makes an error

TypeError: setModel(self, QAbstractItemModel): argument 1 has unexpected type 'QTableView'

jsulm

@Karoluss96 said in Put data in TableView after SQl query:

but it makes an error

Would be nice if you would tell us what error it is...

Karoluss96

I put the text of error in a previous post /\

jsulm

@Karoluss96 The error is quite clear: you can't set QTableView (which is a view) as model...
What @JonB suggested is to use https://doc.qt.io/qt-6/qsqltablemodel.html or https://doc.qt.io/qt-6/qsqlquerymodel.html as model to get data from your SQL database and set that model in self.dlg.tableView_5

Karoluss96

OK, now I have at beginning:

q= QSqlQueryModel()
  table = QSqlTableModel()

JonB

@Karoluss96
Why do you have both a QSqlQueryModel and a QSqlTableModel? Why two models?

And you are assigning each of these to a function-local variable now. You will not be able to access these outside of this function, and they may be destroyed when they go out of scope.

Karoluss96

Both I catch in one funtion, so I needn't put them global.
Now I have that:

 q= QSqlQueryModel()
        table = QSqlTableModel()
        self.dlg.tableView_3.show()
        if con == Zest[0]:
           sql2 = "SELECT * FROM ZARZADZANIE.ZAMOWIENIA_WG_STATUS_V"
           q=query.exec_(sql2)
           a=table.setQuery(q)
           self.dlg.tableView_5.setModel(a)  
           print (a)

with an error: TypeError: setQuery(self, QSqlQuery): argument 1 has unexpected type 'bool'