Get content of cell from QTableView

JonB

@Karoluss96 said in Get content of cell from QTableView:

That the main reason for all this discussion- how to auto-change None to NULL?!

I can give you some suggestions to try. But first I know you are using Python but not which Python binding you are using for Qt. It could be any of: PySide2, PyQt5, PySide6, PyQt6. Which one?

Karoluss96

I suppose PyQt5

as at beginng appears a line:

from PyQt5.QtCore import QSettings

JonB

@Karoluss96
In place of the raise Exception(...) line try the following:

val = None. If this works it would be simplest! It means that binding a None, does result in a NULL, so you can remove the special case completely.
val = QVariant(). Try this next. You may find you need a from PyQt5.QtCore import QVariant statement at the head of the file near the other PyQt5 imports.

If #2 does not work I would be interested to know if you get an error message anywhere (e.g. perhaps on the query.exec_()) and what the message says.

Karoluss96

Well... that all makes (and maybe also you) me tired. My chef will help me with this...

If finally works I'll informe you!

JonB

@Karoluss96
Did you not just try those two? Having spent this much time I am keen to know now...!

Karoluss96

Well... I tried, but I won't to answer it's correct or not as the code with previous versions become messy.

I saw that you're solved a little problem here: https://forum.qt.io/topic/90363/inexplicable-qsqlquerymodel-handling-of-null-value/14

JonB

@Karoluss96
That is so long ago I barely remember! Except that I didn't feel I got much from the PyQt author/mailing list :(

In the last post there a guy says:

though Oracle treats empty strings as NULL

You seem to be using PLSQL. So another thing to try, if no joy from my previous two suggestions, might be val = "" for the None case if that really is true.

Karoluss96

Yes, but now I try by my chef's suggestions with a little returing for a starting point.
I'll answer if finally goes... or returning to your version if doesn't go

Karoluss96

After a long fight my chef find the working answer:

for col in range(model.columnCount()):
            rowData = [model.index(row, col).data() for col in range(model.columnCount()) ]
   
            letersBind = [':a',':bb',':bc',':bd',':be',':bf',':bg',':bh',':bi',':bj',':bk',':bl',':bm',':bn',':bo',':bp',':cba',':cbb',':cbc',':cbd',
                          ':cbe',':cbf',':cbg',':cbh',':cbi',':cbj',':cbk',':cbl',':cbn',':cbo',':cbp',':cca',':ccb',':ccc']    
            if rowData[col] is None:
                query.addBindValue('')
                print(col,' 1')
            else:
                query.bindValue(letersBind[col],rowData[col])
        
        query.exec_()
        print (query.lastError().text())
        while query.next():
            self.model4.insertRow(row)

I' don't from what come the letters, which exchange the ? singns in () for Values

JonB

@Karoluss96 said in Get content of cell from QTableView:

After a long fight my chef find the working answer:

        if rowData[col] is None:
            query.addBindValue('')

@JonB said in Get content of cell from QTableView:

You seem to be using PLSQL. So another thing to try, if no joy from my previous two suggestions, might be val = "" for the None case if that really is true.

Karoluss96

Thanks for all helping!