PyQt Tableview background color based on numeric values?

Question

There is a nice example of how to achieve "PyQt Tableview background color based on text value" since I am not allowed to comment I have to open a new question.

How can I compare column "id" as integer numbers? e.g. if (id>103) and (id<106)?

Code line taken from link above:

if QSqlQueryModel.data(self, self.index(item.row(), 2), Qt.DisplayRole) == "Young":

seems to work fine for text, but

if QSqlQueryModel.data(self, self.index(item.row(), 0), Qt.DisplayRole) > "103":

would compare as text not as integer, and

if QSqlQueryModel.data(self, self.index(item.row(), 0), Qt.DisplayRole).toInt() > 103:

gives an AttributeError: 'QVariant' object has no attribute 'toInt'

How to compare cell values as integer, float, boolean, ...?

What version of PyQt5 are you using? – eyllanesc Jul 14 '18 at 06:11 — eyllanesc, Jul 14 '18 at 06:11
I am using PyQt5 version 5.10 on Win7 – theozh Jul 15 '18 at 14:09 — theozh, Jul 15 '18 at 14:09

score 2 · Accepted Answer · answered Jul 14 '18 at 07:29

2

You have to use the value() method of QVariant and if casting is necessary.

val = QSqlQueryModel.data(self, self.index(item.row(), 0), Qt.DisplayRole)
if int(val.value()) > 102:
    return QBrush(Qt.yellow)

answered Jul 14 '18 at 07:29

eyllanesc

thanks a lot @eyllanesc, I was mislead by the QVariant methods toInt(), toFloat(), toBool(), ... – theozh Jul 15 '18 at 13:57

1 Answers1