How to fill QSql row and columns with Color?

[Aquarius171]

from PyQt4.QtSql import *
from PyQt4.QtGui import *
from PyQt4.QtCore import *
import sys

app = QApplication(sys.argv)

db = QSqlDatabase.addDatabase("QMYSQL")

db.setHostName("localhost")
db.setDatabaseName("incoming_mac")
db.setUserName("root")
db.setPassword("admingelo")
db.open()

projectModel = QSqlQueryModel()
projectModel.setQuery("select * from incoming_mac_records",db)

projectView = QTableView()
projectView.setModel(projectModel)
projectView.resizeColumnsToContents()

projectView.show()
app.exec_()

[mrjj]

Hi
You can try
http://doc.qt.io/qt-5/qtablewidgetitem.html#setBackground
Sorry its a view.
http://www.qtcentre.org/threads/11247-how-to-color-a-cell-in-a-QTableView

So it seems the normal is to use a delegate or via model
http://stackoverflow.com/questions/28006382/how-to-control-qtableview-items-backgound-color