Extending QSqlRelationalTableModel

[jsulm]

@Panoss Did you apply this change to the method definition in cpp file as well?

[Panoss]

jsulm you 're right, I hadn't.
Idid, and now my files are:

qsqlrelationaltablemodelb.h:

#ifndef QSQLRELATIONALTABLEMODELB_H
#define QSQLRELATIONALTABLEMODELB_H

#include <QtSql/qsqlrelationaltablemodel.h>

class QSqlRelationalTableModelB : public QSqlRelationalTableModel {
  Q_OBJECT
public:
  explicit QSqlRelationalTableModelB(QString text, QObject *parent = 0);

};

#endif // QSQLRELATIONALTABLEMODELB_H

qsqlrelationaltablemodelb.cpp:

#include "QSqlRelationalTableModelB.h"
#include "QDebug"

QSqlRelationalTableModelB::QSqlRelationalTableModelB(QString text, QObject *parent) :
  QSqlRelationalTableModel(parent)
{
    qDebug() << "QSqlRelationalTableModelB!!!"
}

But now I get the error:

repairdevices.obj:-1: error: LNK2019: unresolved external symbol "public: __thiscall QSqlRelationalTableModelB::QSqlRelationalTableModelB(class QString,class QObject *)" (??0QSqlRelationalTableModelB@@QAE@VQString@@PAVQObject@@@Z) referenced in function "public: __thiscall RepairDevices::RepairDevices(void)" (??0RepairDevices@@QAE@XZ)

[Panoss]

I deleted all files from the debug folder, rebuilt it and run fine!
I suppose it was some file in the debug folder.

[Panoss]

I took a look in the file qsqlrelationaltablemodel.
As you see, it 's the 5.0.2 version because I use Qt 5.0.2.
As you also see, it has 749 lines of code...
I 'm a little bit desperate...:)

[Panoss]

I 'm trying to override function setRelations.

.h:

#ifndef QSQLRELATIONALTABLEMODELB_H
#define QSQLRELATIONALTABLEMODELB_H

#include <QtSql/qsqlrelationaltablemodel.h>

class QSqlRelationalTableModelB : public QSqlRelationalTableModel {
    Q_OBJECT
public:
    explicit QSqlRelationalTableModelB(QString text, QObject *parent = 0);
    virtual void setRelation(int column, const QSqlRelation &relation);
};

#endif // QSQLRELATIONALTABLEMODELB_H

.cpp:

#include "QSqlRelationalTableModelB.h"
#include "QDebug"

QT_BEGIN_NAMESPACE

QSqlRelationalTableModelB::QSqlRelationalTableModelB(QString text, QObject *parent) :
  QSqlRelationalTableModel(parent)
{
    qDebug() << "QSqlRelationalTableModelB!!!";
}

void QSqlRelationalTableModelB::setRelation(int column, const QSqlRelation &relation)
{
    Q_D(QSqlRelationalTableModelB);
    if (column < 0)
        return;
    if (d->relations.size() <= column)
        d->relations.resize(column + 1);
    d->relations[column].init(this, relation);
}


QT_END_NAMESPACE

I get quite a few errors:

...\qsqlrelationaltablemodelb.cpp:14: error: C2065: 'QSqlRelationalTableModelBPrivate' : undeclared identifier

...\qsqlrelationaltablemodelb.cpp:14: error: C2059: syntax error : 'const'

...\qsqlrelationaltablemodelb.cpp:17: error: C2065: 'd' : undeclared identifier

And a few more...

[Panoss]

I think it has to do with Q_D(QSqlRelationalTableModelB).
I read some things here, but I can't say I understand much.

[kshegunov]

Q_D is the d-pointer expansion macro. Long story short, to use that with the private object of the relational table model Qt has, you need to create one additional class that inherits from QSqlRelationalTableModelPrivate (QT += sql-private) and implement a constructor that passes an instance from the inherited private class to the parent class, i.e. QSqlRelationTableModel. Now, that's hacking into the Qt's internals (which is not documented and breaks binary compatibility) and I'm not completely convinced you really need it. What exactly are you striving to accomplish?

I think you actually want to use QSqlRelationalDelegate instead.

[Panoss]

I 'm trying this which I describe in my first post:

@Panoss said in Extending QSqlRelationalTableModel:

I 'm trying to extend QSqlRelationalTableModel, in order to try make some changes, e.g return two fields:

model->setRelation(clientIndex,
           QSqlRelation("clients", "id", "firstname,lastname"));

The above code returns only the first field.
I want to make it return both fieds, firstname and lastname.

[kshegunov]

@Panoss said in Extending QSqlRelationalTableModel:

I 'm trying this which I describe in my first post

Yes, I read it, but I didn't understand. Do you mind explaining further? What do you want to return both fields? How would this in your mind work (i.e. how is one relation going to be associated with two tables? And what code returns only the first field, it's just not clear.

[Panoss]

I have 2 tables:

1. devices (fields: id, brand, client_id). The 3nd is foreign key.
2. clients(with fields: id, firstname, lastname).
   They are connected with devices.client_id = client.id.

When a device is displayed, I want to be also displayed firstname and lastname from clients.

[SGaist]

Hi,

What about using a proxy model that would put these two fields together ?

[Panoss]

I don't know what a proxy model is.
Could you give me an example?

[SGaist]

QSortFilterProxyModel
QIdentityProxyModel

[Panoss]

I restart this topic (as I had been distracted by other parts of the code):
I 'm trying to make it with QSortFilterProxyModel (I hope this is the correct way).
Let me remind you what I'm trying to acomplish:

I have 2 tables:

1. devices (fields: id, brand, client_id). The 3nd is foreign key.
2. clients(with fields: id, firstname, lastname, address).
They are connected with devices.client_id = client.id.

This is how I make the model ('model' is the model for devices):

model = new QSqlRelationalTableModel(this);
model->setTable("devices");

When a device is displayed, I also display lastname from clients in a combo with this code:

QSqlTableModel *relClientModel = model->relationModel(clientIndex);
ui.client_id_cbo->setModel(relClientModel);
ui.client_id_cbo->setModelColumn(relClientModel->fieldIndex("lastname"));  

So, how can I display and firstname and address from clients in two textboxes?

Like a master/detail form, where master is 'devices' and detail is 'clients', showing one client only (while, usually, in detail we have a list).

[Panoss]

Finally, it was proved to be a lot simpler, using the model of the combo:

row = ui.client_id_cbo->currentIndex();    
QModelIndex idx = ui.client_id_cbo->model()->index(row, 0); // first column
QString client_firstname = idx.sibling(idx.row(), 1).data().toString();
QString client_address = idx.sibling(idx.row(), 3).data().toString();
ui.client_firstname_txt->setPlainText(client_firstname);
ui.client_address_txt->setPlainText(client_address);

[kkmspb]

@Panoss Hello! You ask right question.
If you need a new functionality of QSqlRelationalTableModel than you should change this class and rebuild qt sources.

[JonB]

@kkmspb said in Extending QSqlRelationalTableModel:

you should change this class and rebuild qt sources

? You should rather subclass QSqlRelationalTableModel and add whatever functionality. You should not change Qt source code for this.

[kkmspb]

@kkmspb

Maybe you can see our free Qt project (4.8.1, Windows).

This project contains several classes inherited from the base classes QSqlTableModel and QTableView.

The PblSqlRelationalTableModel class is inherited from QSqlTableModel.

The PblTableView class is inherited from QTableView.

As a result, a combining class PblTableDlg was created with the composition PblTableView and PblSqlRelationalTableModel.

The QTableView class contains full functionality for managing a database table: creating, copying, deleting rows.
There is a search, selection by value. Fields in the form of combobox, checkbox,...
External links and substitutions from other tabs work automatically.

Everything is configured simply in one configuration file config.cpp .

All three editing strategies are supported.