Extend QSqlTableModel & Update model data;

[SGaist]

Hi and welcome to devnet,

Since it's computed from the database content then I'd go with the QSqlTableModel subclass.

When setData is called the index received contains both the row and column so you know exactly which cell has been modified. Just update the content of the computed column and emit the dataChanged signal with both parameters pointing your computed cell.

Hope it helps

[ginkgoguy]

@SGaist
Thanks for your help. If I inherit form QSqlTableModel and add an extra column which function I have to overwrite, only data, headerData and setData?
Yes of course, if I call setData with a specific QModelIndex the signal dataChanged knows the index of the updated cell, but my problem is the step before. I receive position updates every second. The update contains an id corresponding the primary key of an database object and an new position. Now I want to update the appropriate row in the model, so I need a mapping from the id to the row. Or it's possible build a model containing the whole object and connect the update signal to the object slot?

[SGaist]

Also columnCount, otherwise your column won't be shown.

AFAIK, you currently have to do that by hand e.g. using a QHash.

[ginkgoguy]

Thanks for your help.
I decide to inherit from QSortFilterProxyModel, extend it to add additional columns and set the sourceModel to QSqlTableModel .

class ExtraColumnProxyModel : public QSortFilterProxyModel
{
  Q_OBJECT
public:
  ExtraColumnProxyModel(QObject* parent = 0);

  Qt::ItemFlags flags(const QModelIndex &index) const;

  QVariant headerData( int section
                     , Qt::Orientation orientation
                     , int role = Qt::DisplayRole
                     ) const;

  QVariant data(const QModelIndex& index, int role = Qt::DisplayRole) const;

  int columnCount(const QModelIndex &parent = QModelIndex()) const;

  QModelIndex index( int row
                   , int column
                   , const QModelIndex& parent = QModelIndex()
                   ) const;

  void appendColumn(QString columnName);

  QHash<int, QByteArray> roleNames() const;

private:
  QHash<int, QByteArray> m_roles;
  QVector<QString> headerDataVector = QVector<QString>();
};

[SGaist]

So it's working like you wanted it ?

[ginkgoguy]

Yes, the model works correctly. Thanks.
If I want to access the data stored in the extraColumns and I the only thing I get is a identifier-string. I have to create a QHash<QString, QModelIndex> (update it on model change) to get the correct index and a QMap<QModelIndex, $Data> to store and access the values. Or is there a cleaner solution?

[SGaist]

Are you moving rows around ?

[ginkgoguy]

If not, is there a simpler solution?
I was thinking of filter and sort functionality.

[SGaist]

You could put that information at the same index using a custom role but it might be slower to get to the right index when searching for it.

[ginkgoguy]

Sounds like what I'm looking. Can you please describe in more detail what is to be done for or post a link to a describtion?

Best regards

[SGaist]

You can all setData from your model and change the last parameter to a custom value e.g. Qt::UserRole + 1. Define that value in your class so you can easily re-use it.

[ginkgoguy]

Sorry, I was looking for an example , but found nothing on the internet. Can you explain to me the usage of it by short example ?

[SGaist]

An example of myModel->setData(myCustomValue, Qt::UserRole + 1); ?