Visualising data from mysql table

[vrltwe]

For the purpose of visualizing data from a MySQL table, a QTableView is being used in conjunction with a QSqlTableModel. As the intention is not to edit the values then the QTableView is configured with:

ui->tbViewTmHistTk->setEditTriggers(QAbstractItemView::NoEditTriggers);

ui->tbViewTmHistTk->setEditTriggers(QAbstractItemView::NoEditTriggers);

To copy to clipboard, switch view to plain text mode 

Is this a good approach in order to prevent editing the data?

[ChrisW67]

Yes, but the model remains editable in any view that allows editing. QSqlQueryModel gives you a truly read-only model.

[vrltwe]

Ok, I understand.

I think QSqlTableModel was used because it enables changing the color of items, re-writing the data function.

QVariant SqlTableModelTk::data(const QModelIndex &index, int role) const
{
    QVariant value = QSqlTableModel::data(index, role);
    if ( role == Qt::TextColorRole )
        if(     (index.column(), index.row()) )
            return QVariant::fromValue(QColor(Qt::red));
    return value;
}

QVariant SqlTableModelTk::data(const QModelIndex &index, int role) const
{
    QVariant value = QSqlTableModel::data(index, role);
    if ( role == Qt::TextColorRole )
        if(     (index.column(), index.row()) )
            return QVariant::fromValue(QColor(Qt::red));
    return value;
}

To copy to clipboard, switch view to plain text mode 

As it doesn't exist a data function for QSqlQueryModel then I suppose I'm in the correct direction. Is there another approach which could be applied in order to attend both requirements, change item color and prevent editing the database?

Thanks for the attention.

[anda_skoa]

QSqlQueryModel is a subclass of QAbstractItemModel, so it has a data() method.

Cheers,
_