How to change row or cell color in TableView with SqlQueryModel

Mucip

Hi,
I have SqlQueryModel and read rows from query. I load this on TableView and want to change some rows or cells in TableView.?
There are many sample about Item Model but I couldn't see one about SqlQueryModel.
My code is below:

QSqlQueryModel *modelTableIhtiyac;

this->modelTableIhtiyac = new QSqlQueryModel(this); // ,db


modelTableIhtiyac->setQuery("select stok_kod, stok_ad, stok_tip, stok_miktar, stok_birim, birim_fiyat, toplam_fiyat, birim_agirlik, toplam_agirlik FROM uretim_listesi_2 WHERE gorunsun=1 ORDER BY stok_tip, stok_kod;",baglanti::mdb2());

//TvDetay is TableView...
    ui->tVDetay->setModel(modelTableIhtiyac);

How can I change some rows or cells in above code?...

Regards,
Mucip:)

SGaist

Hi,

QSqlQueryModel is read-only. Why not use QSqlTableModel ?

JonB

@Mucip
In addition to what @SGaist has suggested, do you actually want to change values in cells, or rather color shown as per your topic title?

SGaist

And to add to @JonB, if it's cosmetic change that won't alter the database content, QIdentityProxyModel is likely what your looking for.

JonB

@SGaist That sounds more like it! :)

JonB

@SGaist
Without changing to a table or other model, can't @Mucip change cell color just by overriding QSqlQueryModel::data() and dealing with Qt::BackgroundRole case with desired code, assuming that is indeed what he wants?

SGaist

That's another possibility yes. One thing to take into account is that if these customisation were to be "view specific", changing the base model would "propagate" them to all views showing the model data. The QIdentityProxyModel allows for more fine grained control in that regard.

Mucip

Dear @SGaist ,
I just want to show data not to modify. This is enaugh for me...

Regards,
Mucip:)

Mucip

Hi @JonB,
Yes. Just want to show data and change color of the desired rows.

Regards,
Mucip:)

Mucip

Dear @JonB,
Sonds good... Any sample about this?...

Regards,
Mucip:)

SGaist

What kind of sample are you looking for ?

Mucip

Dear @SGaist ,
You suggested QIdentityProxyModel. Is there any explenation or sample how to use this?
Regards,
Mucip:)

SGaist

Right in the documentation for the class that I already linked to earlier.

VRonin

You can use the RoleMaskProxyModel of this library.
I'm working on merging this into Qt 5.13: https://codereview.qt-project.org/245572 (at the time of writing it's marked as draft so private)

JonB

@Mucip said in How to change row or cell color in TableView with SqlQueryModel:

Hi @JonB,
Yes. Just want to show data and change color of the desired rows.

Regards,
Mucip:)

Sorry, I have been away for a few days. As I wrote earlier, if all you want to do is set background color of certain rows you could skip proxy models and just override QSqlQueryModel::data() to deal with Qt::BackgroundRole. It depends whether you can figure the color you want for whatever rows very simply in code, or whether you need something more sophisticated which a proxy model could provide.