How to detect data changes in Widgets and transfer them to DB?

[zubr]

How to detect data changes in Widgets and to transfer them to DB? QDataWidgetMapper and QSqlTableModel are used.
Now changes are detect manually through connect textChanged(QString &) - for QLineEdit, editTextChanged(QString &) - for QComboBox, etc. It is possible to automate or make uniform detecting data changes?
Now changes are transfer through QSqlTableModel::setRecord(int,const QSqlRecord &). It is possible to make it through the delegate?

[vfernandez]

You may subclass QLineEdit, QComboBox, etc and implement a method where you store the data in the database and connect the textChanged(), activated(), etc signals to your method in the subclass. That way you'll only need to implement storing the data only once for each type of widget instead of for each widget instance. For instance:

mylineedit.h

class MyLineEdit : public QLineEdit {
 
    Q_OBJECT
 
public:
    MyLineEdit(QWidget *parent = 0);
 
    void setQuery(const QString& query);
 
public slots:
    void startQuery(const QString& text);
 
private:
    QString m_query;
};

class MyLineEdit : public QLineEdit {

    Q_OBJECT

public:
    MyLineEdit(QWidget *parent = 0);

    void setQuery(const QString& query);

public slots:
    void startQuery(const QString& text);

private:
    QString m_query;
};

To copy to clipboard, switch view to plain text mode 

mylineedit.cpp

MyLineEdit::MyLineEdit(QWidget *parent)
 : QLineEdit(parent) {
    connect(this, SIGNAL(textChanged(const QString&)), this, SLOT(startQuery(const QString&));
}
 
void MyLineEdit::setQuery(const QString& query)
{
    m_query = query;
}
 
void MyLineEdit::startQuery(const QString& text)
{
    QString q = m_query.arg(text);
    // execute the query stored in "q"
}

MyLineEdit::MyLineEdit(QWidget *parent)
 : QLineEdit(parent) {
    connect(this, SIGNAL(textChanged(const QString&)), this, SLOT(startQuery(const QString&));
}

void MyLineEdit::setQuery(const QString& query)
{
    m_query = query;
}

void MyLineEdit::startQuery(const QString& text)
{
    QString q = m_query.arg(text);
    // execute the query stored in "q"
}

To copy to clipboard, switch view to plain text mode 

to use:

MyLineEdit *lineEdit = new MyLineEdit(this);
lineEdit->setQuery("INSERT INTO table VALUES('%1');");

MyLineEdit *lineEdit = new MyLineEdit(this);
lineEdit->setQuery("INSERT INTO table VALUES('%1');");

To copy to clipboard, switch view to plain text mode 

Anyway, I wouldn't recommend you executing a SQL query directly from the GUI thread since it will block the GUI unless you're using it in a local network. Instead, better create a thread that handles the queries.