QSqlQueryModel Class▲
-
Header: QSqlQueryModel
-
CMake:
find_package(Qt6 REQUIRED COMPONENTS Sql)
target_link_libraries(mytarget PRIVATE Qt6::Sql)
-
qmake: QT += sql
-
Inherits: https://
-
Inherited By: https://
-
Group: QSqlQueryModel is part of https://
Detailed Description▲
https:// is a high-level interface for executing SQL statements and traversing the result set. It is built on top of the lower-level https:// and can be used to provide data to view classes such as QTableView. For example:
QSqlQueryModel *model = new QSqlQueryModel;
model->setQuery("SELECT name, salary FROM employee");
model->setHeaderData(0, Qt::Horizontal, tr("Name"));
model->setHeaderData(1, Qt::Horizontal, tr("Salary"));
QTableView *view = new QTableView;
view->setModel(model);
view->show();We set the model's query, then we set up the labels displayed in the view header.
https:// can also be used to access a database programmatically, without binding it to a view:
QSqlQueryModel model;
model.setQuery("SELECT name, salary FROM employee");
int salary = model.record(4).value("salary").toInt();The code snippet above extracts the salary field from record 4 in the result set of the SELECT query. Since salary is the 2nd column (or column index 1), we can rewrite the last line as follows:
int salary = model.data(model.index(4, 1)).toInt();The model is read-only by default. To make it read-write, you must subclass it and reimplement https://() and https://(). Another option is to use https://, which provides a read-write model based on a single database table.
The https:// example illustrates how to use https:// to display the result of a query. It also shows how to subclass https:// to customize the contents of the data before showing it to the user, and how to create a read-write model based on https://.
If the database doesn't return the number of selected rows in a query, the model will fetch rows incrementally. See https://() for more information.
See Also▲
See also https://, https://, https://, https://, Query Model Example
Member Function Documentation▲
[explicit] QSqlQueryModel::QSqlQueryModel(QObject *parent = nullptr)▲
Creates an empty https:// with the given parent.
[virtual] QSqlQueryModel::~QSqlQueryModel()▲
[override virtual] bool QSqlQueryModel::canFetchMore(const QModelIndex &parent = QModelIndex()) const▲
Reimplements: https://.
Returns true if it is possible to read more rows from the database. This only affects databases that don't report back the size of a query (see https://()).
parent should always be an invalid https://.
See Also▲
See also https://()
[virtual] void QSqlQueryModel::clear()▲
Clears the model and releases any acquired resource.
[override virtual] int QSqlQueryModel::columnCount(const QModelIndex &index = QModelIndex()) const▲
Reimplements: https://.
[override virtual] QVariant QSqlQueryModel::data(const QModelIndex &item, int role = Qt::DisplayRole) const▲
Reimplements: https://.
Returns the value for the specified item and role.
If item is out of bounds or if an error occurred, an invalid https:// is returned.
See Also▲
See also https://()
[override virtual] void QSqlQueryModel::fetchMore(const QModelIndex &parent = QModelIndex())▲
Reimplements: https://.
Fetches more rows from a database. This only affects databases that don't report back the size of a query (see https://()).
To force fetching of the entire result set, you can use the following:
while (myModel->canFetchMore())
myModel->fetchMore();parent should always be an invalid https://.
See Also▲
See also https://()
[override virtual] QVariant QSqlQueryModel::headerData(int section, Qt::Orientation orientation, int role = Qt::DisplayRole) const▲
Reimplements: https://.
Returns the header data for the given role in the section of the header with the specified orientation.
See Also▲
See also https://()
[virtual protected] QModelIndex QSqlQueryModel::indexInQuery(const QModelIndex &item) const▲
Returns the index of the value in the database result set for the given item in the model.
The return value is identical to item if no columns or rows have been inserted, removed, or moved around.
Returns an invalid model index if item is out of bounds or if item does not point to a value in the result set.
See Also▲
See also https://(), https://(), https://()
[override virtual] bool QSqlQueryModel::insertColumns(int column, int count, const QModelIndex &parent = QModelIndex())▲
Reimplements: https://.
Inserts count columns into the model at position column. The parent parameter must always be an invalid https://, since the model does not support parent-child relationships.
Returns true if column is within bounds; otherwise returns false.
By default, inserted columns are empty. To fill them with data, reimplement https://() and handle any inserted column separately:
QVariant MyModel::data(const QModelIndex &item, int role) const
{
if (item.column() == m_specialColumnNo) {
// handle column separately
}
return QSqlQueryModel::data(item, role);
}See Also▲
See also https://()
QSqlError QSqlQueryModel::lastError() const▲
Returns information about the last error that occurred on the database.
See Also▲
See also https://(), https://()
QSqlQuery QSqlQueryModel::query() const▲
[virtual protected] void QSqlQueryModel::queryChange()▲
This virtual function is called whenever the query changes. The default implementation does nothing.
https://() returns the new query.
See Also▲
See also https://(), https://()
QSqlRecord QSqlQueryModel::record(int row) const▲
Returns the record containing information about the fields of the current query. If row is the index of a valid row, the record will be populated with values from that row.
If the model is not initialized, an empty record will be returned.
See Also▲
See also https://()
QSqlRecord QSqlQueryModel::record() const▲
This is an overloaded function.
Returns an empty record containing information about the fields of the current query.
If the model is not initialized, an empty record will be returned.
See Also▲
See also https://()
[override virtual] bool QSqlQueryModel::removeColumns(int column, int count, const QModelIndex &parent = QModelIndex())▲
Reimplements: https://.
Removes count columns from the model starting from position column. The parent parameter must always be an invalid https://, since the model does not support parent-child relationships.
Removing columns effectively hides them. It does not affect the underlying https://.
Returns true if the columns were removed; otherwise returns false.
[override virtual, since 5.10] QHash<int, QByteArray> QSqlQueryModel::roleNames() const▲
Reimplements: https://.
Returns the model's role names.
Qt defines only one role for the https://:
|
Qt Role |
QML Role Name |
|---|---|
|
https:// |
display |
This function was introduced in Qt 5.10.
[override virtual] int QSqlQueryModel::rowCount(const QModelIndex &parent = QModelIndex()) const▲
Reimplements: https://.
If the database supports returning the size of a query (see https://()), the number of rows of the current query is returned. Otherwise, returns the number of rows currently cached on the client.
parent should always be an invalid https://.
See Also▲
See also https://(), https://()
[override virtual] bool QSqlQueryModel::setHeaderData(int section, Qt::Orientation orientation, const QVariant &value, int role = Qt::EditRole)▲
Reimplements: https://.
Sets the caption for a horizontal header for the specified role to value. This is useful if the model is used to display data in a view (e.g., QTableView).
Returns true if orientation is https:// and the section refers to a valid section; otherwise returns false.
Note that this function cannot be used to modify values in the database since the model is read-only.
See Also▲
See also https://(), https://()
[protected] void QSqlQueryModel::setLastError(const QSqlError &error)▲
Protected function which allows derived classes to set the value of the last error that occurred on the database to error.
See Also▲
See also https://()
[since 6.2] void QSqlQueryModel::setQuery(QSqlQuery &&query)▲
Resets the model and sets the data provider to be the given query. Note that the query must be active and must not be isForwardOnly().
https://() can be used to retrieve verbose information if there was an error setting the query.
Calling setQuery() will remove any inserted columns.
This function was introduced in Qt 6.2.
See Also▲
See also https://(), https://(), https://(), https://()
void QSqlQueryModel::setQuery(const QString &query, const QSqlDatabase &db = QSqlDatabase())▲
This is an overloaded function.
Executes the query query for the given database connection db. If no database (or an invalid database) is specified, the default connection is used.
https://() can be used to retrieve verbose information if there was an error setting the query.
Example:
QSqlQueryModel model;
model.setQuery("select * from MyTable");
if (model.lastError().isValid())
qDebug() << model.lastError();See Also▲
See also https://(), https://(), https://()
Obsolete Members for QSqlQueryModel▲
The following members of class https:// are deprecated. We strongly advise against using them in new code.
Obsolete Member Function Documentation▲
void QSqlQueryModel::setQuery(const QSqlQuery &query)▲
This function is deprecated since 6.2. We strongly advise against using it in new code.
Use the setQuery(QSqlQuery &&query) overload instead.
This is an overloaded function.