The QSqlRelationalTableModel class provides an editable data model for a single database table, with foreign key support. More...
Header: | #include <QSqlRelationalTableModel> |
qmake: | QT += sql |
Inherits: | QSqlTableModel |
enum | JoinMode { InnerJoin, LeftJoin } |
QSqlRelationalTableModel(QObject *parent = nullptr, QSqlDatabase db = QSqlDatabase()) | |
virtual | ~QSqlRelationalTableModel() |
QSqlRelation | relation(int column) const |
virtual QSqlTableModel * | relationModel(int column) const |
void | setJoinMode(QSqlRelationalTableModel::JoinMode joinMode) |
virtual void | setRelation(int column, const QSqlRelation &relation) |
virtual void | clear() override |
virtual QVariant | data(const QModelIndex &index, int role = Qt::DisplayRole) const override |
virtual bool | removeColumns(int column, int count, const QModelIndex &parent = QModelIndex()) override |
virtual bool | select() override |
virtual bool | setData(const QModelIndex &index, const QVariant &value, int role = Qt::EditRole) override |
virtual void | setTable(const QString &table) override |
virtual void | revertRow(int row) override |
virtual bool | insertRowIntoTable(const QSqlRecord &values) override |
virtual QString | orderByClause() const override |
virtual QString | selectStatement() const override |
virtual bool | updateRowInTable(int row, const QSqlRecord &values) override |
The QSqlRelationalTableModel class provides an editable data model for a single database table, with foreign key support.
QSqlRelationalTableModel acts like QSqlTableModel, but allows columns to be set as foreign keys into other database tables.
The screenshot on the left shows a plain QSqlTableModel in a QTableView. Foreign keys (city
and country
) aren't resolved to
human-readable values. The screenshot on the right shows a QSqlRelationalTableModel, with foreign keys resolved into human-readable text strings.
The following code snippet shows how the QSqlRelationalTableModel was set up:
model->setTable("employee"); model->setRelation(2, QSqlRelation("city", "id", "name")); model->setRelation(3, QSqlRelation("country", "id", "name"));
The setRelation() function calls establish a relationship between two tables. The first call specifies that column 2 in table employee
is a foreign key
that maps with field id
of table city
, and that the view should present the city
's name
field to the user. The second call does something similar with column 3.
If you use a read-write QSqlRelationalTableModel, you probably want to use QSqlRelationalDelegate on the view. Unlike the default delegate, QSqlRelationalDelegate provides a combobox for fields that are foreign keys into other tables. To use the class, simply call QAbstractItemView::setItemDelegate() on the view with an instance of QSqlRelationalDelegate:
QTableView *view = new QTableView; view->setModel(model); view->setItemDelegate(new QSqlRelationalDelegate(view));
The relationaltablemodel example illustrates how to use QSqlRelationalTableModel in conjunction with QSqlRelationalDelegate to provide tables with foreign key support.
Notes:
See also QSqlRelation, QSqlRelationalDelegate, and Relational Table Model Example.
Constant | Value | Description |
---|---|---|
QSqlRelationalTableModel::InnerJoin |
0 |
- Inner join mode, return rows when there is at least one match in both tables. |
QSqlRelationalTableModel::LeftJoin |
1 |
- Left join mode, returns all rows from the left table (table_name1), even if there are no matches in the right table (table_name2). |
This enum was introduced or modified in Qt 4.8.
See also QSqlRelationalTableModel::setJoinMode().
Creates an empty QSqlRelationalTableModel and sets the parent to parent and the database connection to db. If db is not valid, the default database connection will be used.
[virtual]
QSqlRelationalTableModel::~QSqlRelationalTableModel()Destroys the object and frees any allocated resources.
[override virtual]
void QSqlRelationalTableModel::clear()Reimplemented from QSqlTableModel::clear().
[override virtual]
QVariant QSqlRelationalTableModel::data(const
QModelIndex &index, int role = Qt::DisplayRole) constReimplemented from QSqlTableModel::data().
See also setData().
[override virtual protected]
bool QSqlRelationalTableModel::insertRowIntoTable(const QSqlRecord &values)Reimplemented from QSqlTableModel::insertRowIntoTable().
[override virtual protected]
QString QSqlRelationalTableModel::orderByClause() constReimplemented from QSqlTableModel::orderByClause().
Returns the relation for the column column, or an invalid relation if no relation is set.
See also setRelation() and QSqlRelation::isValid().
[virtual]
QSqlTableModel
*QSqlRelationalTableModel::relationModel(int column) constReturns a QSqlTableModel object for accessing the table for which column is a foreign key, or 0 if there is no relation for the given column.
The returned object is owned by the QSqlRelationalTableModel.
See also setRelation() and relation().
[override virtual]
bool QSqlRelationalTableModel::removeColumns(int column, int count, const QModelIndex &parent = QModelIndex())Reimplemented from QSqlTableModel::removeColumns().
[override virtual slot]
void QSqlRelationalTableModel::revertRow(int row)Reimplemented from QSqlTableModel::revertRow().
[override virtual]
bool QSqlRelationalTableModel::select()Reimplemented from QSqlTableModel::select().
[override virtual protected]
QString
QSqlRelationalTableModel::selectStatement() constReimplemented from QSqlTableModel::selectStatement().
[override virtual]
bool QSqlRelationalTableModel::setData(const QModelIndex &index, const QVariant &value, int role = Qt::EditRole)Reimplemented from QSqlTableModel::setData().
Sets the data for the role in the item with the specified index to the value given. Depending on the edit strategy, the value might be applied to the database at once, or it may be cached in the model.
Returns true
if the value could be set, or false on error (for example, if index is out of bounds).
For relational columns, value must be the index, not the display value. The index must also exist in the referenced table, otherwise the function returns false
.
See also editStrategy(), data(), submit(), and revertRow().
Sets the SQL joinMode to show or hide rows with NULL foreign keys. In InnerJoin mode (the default) these rows will not be shown: use the LeftJoin mode if you want to show them.
This function was introduced in Qt 4.8.
See also QSqlRelationalTableModel::JoinMode.
[virtual]
void QSqlRelationalTableModel::setRelation(int
column, const QSqlRelation &relation)Lets the specified column be a foreign index specified by relation.
Example:
model->setTable("employee"); model->setRelation(2, QSqlRelation("city", "id", "name"));
The setRelation() call specifies that column 2 in table employee
is a foreign key that maps with field id
of table city
, and that the view should present the city
's
name
field to the user.
Note: The table's primary key may not contain a relation to another table.
See also relation().
[override virtual]
void QSqlRelationalTableModel::setTable(const QString &table)Reimplemented from QSqlTableModel::setTable().
[override virtual protected]
bool QSqlRelationalTableModel::updateRowInTable(int row, const QSqlRecord &values)Reimplemented from QSqlTableModel::updateRowInTable().