#include <tsqlquery.h>
|
static void | clearCachedQueries () |
|
static QString | escapeIdentifier (const QString &identifier, QSqlDriver::IdentifierType type=QSqlDriver::FieldName, int databaseId=0) |
|
static QString | escapeIdentifier (const QString &identifier, QSqlDriver::IdentifierType type, const QSqlDriver *driver) |
|
static QString | formatValue (const QVariant &val, const QMetaType &type, int databaseId=0) |
|
static QString | formatValue (const QVariant &val, const QMetaType &type, const QSqlDatabase &database) |
|
static QString | formatValue (const QVariant &val, const QMetaType &type, const QSqlDriver *driver) |
|
static QString | formatValue (const QVariant &val, const QSqlDriver *driver) |
|
static QString | formatValue (const QVariant &val, const QSqlDatabase &database) |
|
The TSqlQuery class provides a means of executing and manipulating SQL statements.
◆ TSqlQuery() [1/2]
TSqlQuery::TSqlQuery |
( |
int |
databaseId = 0 | ) |
|
Constructs a TSqlQuery object using the database databaseId.
◆ TSqlQuery() [2/2]
TSqlQuery::TSqlQuery |
( |
const QSqlDatabase & |
db | ) |
|
◆ addBind()
TSqlQuery & TSqlQuery::addBind |
( |
const QVariant & |
val | ) |
|
Adds the value val to the list of values when using positional value binding and returns the query object.
The order of the addBind() calls determines which placeholder a value will be bound to in the prepared query.
◆ bind() [1/2]
TSqlQuery & TSqlQuery::bind |
( |
const QString & |
placeholder, |
|
|
const QVariant & |
val |
|
) |
| |
Set the placeholder placeholder to be bound to value val in the prepared statement.
◆ bind() [2/2]
TSqlQuery & TSqlQuery::bind |
( |
int |
pos, |
|
|
const QVariant & |
val |
|
) |
| |
Set the placeholder in position pos to be bound to value val in the prepared statement.
Field numbering starts at 0.
◆ boundValue()
QVariant TSqlQuery::boundValue |
( |
int |
pos | ) |
const |
◆ boundValues()
QVariantList TSqlQuery::boundValues |
( |
| ) |
const |
◆ clearCachedQueries()
void TSqlQuery::clearCachedQueries |
( |
| ) |
|
|
static |
Clears currently cached SQL queries that are loaded by the load() function.
◆ escapeIdentifier() [1/2]
QString TSqlQuery::escapeIdentifier |
( |
const QString & |
identifier, |
|
|
QSqlDriver::IdentifierType |
type, |
|
|
const QSqlDriver * |
driver |
|
) |
| |
|
static |
Returns the identifier escaped according to the rules of the driver driver.
The identifier can either be a table name or field name, dependent on type.
◆ escapeIdentifier() [2/2]
QString TSqlQuery::escapeIdentifier |
( |
const QString & |
identifier, |
|
|
QSqlDriver::IdentifierType |
type = QSqlDriver::FieldName , |
|
|
int |
databaseId = 0 |
|
) |
| |
|
static |
Returns the identifier escaped according to the rules of the database databaseId.
The identifier can either be a table name or field name, dependent on type.
◆ exec() [1/2]
Executes a previously prepared SQL query.
Returns true if the query executed successfully; otherwise returns false.
◆ exec() [2/2]
bool TSqlQuery::exec |
( |
const QString & |
query | ) |
|
Executes the SQL in query.
Returns true and sets the query state to active if the query was successful; otherwise returns false.
◆ formatValue() [1/5]
QString TSqlQuery::formatValue |
( |
const QVariant & |
val, |
|
|
const QMetaType & |
type, |
|
|
const QSqlDatabase & |
database |
|
) |
| |
|
static |
◆ formatValue() [2/5]
QString TSqlQuery::formatValue |
( |
const QVariant & |
val, |
|
|
const QMetaType & |
type, |
|
|
const QSqlDriver * |
driver |
|
) |
| |
|
static |
Returns a string representation of the value val for the database database.
◆ formatValue() [3/5]
QString TSqlQuery::formatValue |
( |
const QVariant & |
val, |
|
|
const QMetaType & |
type, |
|
|
int |
databaseId = 0 |
|
) |
| |
|
static |
Returns a string representation of the value val for the database databaseId.
◆ formatValue() [4/5]
static QString TSqlQuery::formatValue |
( |
const QVariant & |
val, |
|
|
const QSqlDatabase & |
database |
|
) |
| |
|
inlinestatic |
◆ formatValue() [5/5]
QString TSqlQuery::formatValue |
( |
const QVariant & |
val, |
|
|
const QSqlDriver * |
driver |
|
) |
| |
|
static |
Returns a string representation of the value val for the database database.
◆ getNextValue()
QVariant TSqlQuery::getNextValue |
( |
| ) |
|
|
inline |
Returns the value of first field in the next object and advances the internal iterator by one position.
It can be used for a query returning at least one result, such as 'SELECT COUNT(*)'.
◆ load()
bool TSqlQuery::load |
( |
const QString & |
filename | ) |
|
Loads a query from the given file filename.
◆ loadPreparedQuery()
bool TSqlQuery::loadPreparedQuery |
( |
const QString & |
filename | ) |
|
|
inline |
◆ next()
Retrieves the next record in the result, if available, and positions the query on the retrieved record.
Note that the result must be in the active state and isSelect() must return true before calling this function or it will do nothing and return false.
◆ numRowsAffected()
int TSqlQuery::numRowsAffected |
( |
| ) |
const |
|
inline |
Returns the number of rows affected by the result's SQL statement, or -1 if it cannot be determined.
Note that for SELECT statements, the value is undefined; use size() instead. If the query is not active, -1 is returned.
◆ prepare()
TSqlQuery & TSqlQuery::prepare |
( |
const QString & |
query | ) |
|
Prepares the SQL query query for execution.
◆ queryDirPath()
QString TSqlQuery::queryDirPath |
( |
| ) |
const |
Returns the directory path for SQL query files, which is indicated by the value for application setting SqlQueriesStoredDirectory.
◆ size()
int TSqlQuery::size |
( |
| ) |
const |
|
inline |
Returns the size of the result (number of rows returned), or -1 if the size cannot be determined or if the database does not support reporting information about query sizes.
Note that for non-SELECT statements (isSelect() returns false), size() will return -1. If the query is not active (isActive() returns false), -1 is returned. To determine the number of rows affected by a non-SELECT statement, use numRowsAffected().
◆ value() [1/2]
QVariant TSqlQuery::value |
( |
const QString & |
name | ) |
const |
|
inline |
Returns the value of the field called name in the current record.
If field name does not exist an invalid variant is returned.
◆ value() [2/2]
QVariant TSqlQuery::value |
( |
int |
index | ) |
const |
|
inline |
Returns the value of field index in the current record.
The documentation for this class was generated from the following files: