How to color a row of qSqlQueryModel where data of cell is smth

SimonaBolgradova

JonB

@SimonaBolgradova
So you do appear to set the value and your picture shows that you are indeed coloring the "Damage" cell yellow. In which case it seems to behaving as per your code, so what is your question?

Meanwhile you might prefer to try @Gojir4's suggestion of doing the background coloring from the data() method instead of a delegate. But I'm not sure that has anything to do with whatever your actual question is.

SimonaBolgradova

@JonB said in How to color a row of qSqlQueryModel where data of cell is smth:

So you do appear to set the value and your picture shows that you are indeed coloring the "Damage" cell yellow. In which case it seems to behaving as per your code, so what is your question?
Meanwhile you might prefer to try @Gojir4's suggestion of doing the background coloring from the data() method instead of a delegate. But I'm not sure that has anything to do with whatever your actual question is.

My question was why when I use alarmsSet in drawnBackgroung is empty set and how to color the whole row.

And could you show me some simple example with data()

VRonin

You are overcomplicating things, it's super straightforward:

class ColorDelegate: public QStyledItemDelegate{
    Q_OBJECT
public:
    using QStyledItemDelegate::QStyledItemDelegate;
    const QSet<QString>& alarms() const {return m_alarms;}
    void setAlarms(const QSet<QString>& alm) {m_alarms=alm;}
protected:
    void initStyleOption(QStyleOptionViewItem *option, const QModelIndex &index) const override{
        QStyledItemDelegate::initStyleOption(option,index);
        if(m_alarms.contains(index.data().toString())
            option->backgroundBrush = QBrush(Qt::yellow, Qt::SolidPattern);
    }
private:
    QSet<QString> m_alarms;
};

how to color the whole row.

Instead of index.data().toString() use index.sibling(index.row(),ColumnWithAlarms).data().toString()

P.S.
The data() solution is perfectly valid, I disagree with it only on a philosophical level (philosophy has hardly any place in programming anyway) as the color isn't data, it's a way to paint existing data. At the end of the day, use the solution you find easier

JonB

@SimonaBolgradova said in How to color a row of qSqlQueryModel where data of cell is smth:

and how to color the whole row.

I already answered this:

If you want all cells in a row to be drawn a certain way based on the content/value of one cell, you will have to get the other cells to look in that one cell in the row when it is their turn to be drawn in order to dictate how they themselves are to be drawn.

But you do not seem to have acknowledged this.

Note that if only the value in the Message column changes you want that to affect the color of all the other cells in that row. It is your responsibility to tell the view that those other cells have changed and need their color to be redrawn (else it will only do the Message column in the row), e.g. via a suitable dataChanged() signal. Although @VRonin mentions sibling() in his code he does not seem to have pointed out that you will need to cause the redraw in those columns?

VRonin

@JonB said in How to color a row of qSqlQueryModel where data of cell is smth:

does not seem to have pointed out that you will need to cause the redraw in those columns?

Excellent spot as always!

connect(model,QAbstractItemModel::dataChanged,view,[=](const QModelIndex &topLeft, const QModelIndex &bottomRight, const QList<int> &roles){
    if(!roles.isEmpty() && !roles.contains(Qt::DisplayRole))
        return;
    if(ColumnWithAlarms < topLeft.column() || ColumnWithAlarms > bottomRight.column())
        return;
    view->update();
});

SimonaBolgradova

@VRonin how to get alarms from my slot

private slots:
   void alarms(QSet<QString> set){
       setAlarms(set);
   }

Is it smth like that?
and why I have this error

JonB

@SimonaBolgradova said in How to color a row of qSqlQueryModel where data of cell is smth:

how to get alarms from my slot

Don't know what this means.

and why I have this error

Start with how can the method be const if it alters m_alarms? [ @VRonin ?? :) ]

VRonin

@JonB said in How to color a row of qSqlQueryModel where data of cell is smth:

Start with how can the method be const if it alters m_alarms? [ @VRonin ?? :) ]

Yep, corrected.

P.S.
In most use cases you don't need a slot. Using Qt5 connections you can connect directly to the setAlarms method

SimonaBolgradova

m_alarms keeps to be empty :(
I connected like that in another class named Controller

connect(
        s, &SQLQueries::alarms,
        d, &ColorDelegate::setAlarms
    );

Alarms signal will be emitted when I triggered action on and m_alarms get some values but then in initStyleOption m_alarms is empty.

VRonin

Can you show us the code where you set the delegate on the view?

SimonaBolgradova

@VRonin

void MainWindow::setTable(QSqlQueryModel * model)
{
   ui->tableView->setModel( model );
   ui->tableView->setItemDelegate(new ColorDelegate(ui->tableView));

   ui->tableView->resizeColumnsToContents();
}

VRonin

@SimonaBolgradova said in How to color a row of qSqlQueryModel where data of cell is smth:

ui->tableView->setItemDelegate(new ColorDelegate(ui->tableView));

Fire and forget pointer. The delegate you are connecting is not the one used by the view then. what is d in d, &ColorDelegate::setAlarms?

It should be something like:

auto alarmDelegate = new ColorDelegate(ui->tableView);
ui->tableView->setItemDelegate(alarmDelegate);
connect(s, &SQLQueries::alarms, alarmDelegate, &ColorDelegate::setAlarms);

SimonaBolgradova

@VRonin

Fire and forget pointer. The delegate you are connecting is not the one used by the view then. what is d in d, &ColorDelegate::setAlarms?

in controller.h

private:
ColorDelegate * d = new ColorDelegate();

It should be something like:

auto alarmDelegate = new ColorDelegate(ui->tableView);
ui->tableView->setItemDelegate(alarmDelegate);
connect(s, &SQLQueries::alarms, alarmDelegate, &ColorDelegate::setAlarms);

this doesn't work and all fields are empty in my QTableView

SimonaBolgradova

@SimonaBolgradova maybe the problem is that my connection was created in the Controller class. There I create an instance of ColorDelegate and m_alarms is still empty. But how could I connect two classes into another without creating an instance?

VRonin

What you are doing at the moment is int a=0; int b=3; and asking why a is 0 and not 3. They are the same type (int) but 2 different objects. You need to call setAlarms on the same object as the one used in the view.

But how could I connect two classes into another without creating an instance?

This question is asked weekly if not daily in this forum just search for "connecting to class". The short answer is that you should structure your app as a tree where the leaves are connected by the branches

SimonaBolgradova

@VRonin
Thank you very much for your time! Now the code is working properly. 😊