QGIS API Documentation 3.40.0-Bratislava (b56115d8743)
|
Contains utilities for working with Sqlite data sources. More...
#include <qgssqliteutils.h>
Static Public Member Functions | |
static long long | nextSequenceValue (sqlite3 *connection, const QString &tableName, QString errorMessage) |
Increments and returns an SQLITE sequence of the table "sqlite_sequence" for tableName and returns it value, errorMessage is filled with the error message in case of errors. | |
static QString | quotedIdentifier (const QString &identifier) |
Returns a properly quoted version of identifier. | |
static QString | quotedString (const QString &value) |
Returns a quoted string value, surround by ' characters and with special characters correctly escaped. | |
static QString | quotedValue (const QVariant &value) |
Returns a properly quoted and escaped version of value for use in SQL strings. | |
static QStringList | systemTables () |
Returns a string list of SQLite (and spatialite) system tables. | |
static QSet< QString > | uniqueFields (sqlite3 *connection, const QString &tableName, QString &errorMessage) |
Returns a list of field names for connection and tableName having a UNIQUE constraint, fields that are part of a UNIQUE constraint that spans over multiple fields are not returned. | |
Contains utilities for working with Sqlite data sources.
Definition at line 170 of file qgssqliteutils.h.
|
static |
Increments and returns an SQLITE sequence of the table "sqlite_sequence" for tableName and returns it value, errorMessage is filled with the error message in case of errors.
Definition at line 207 of file qgssqliteutils.cpp.
|
static |
Returns a properly quoted version of identifier.
Definition at line 260 of file qgssqliteutils.cpp.
|
static |
Returns a quoted string value, surround by ' characters and with special characters correctly escaped.
Definition at line 250 of file qgssqliteutils.cpp.
|
static |
Returns a properly quoted and escaped version of value for use in SQL strings.
Definition at line 267 of file qgssqliteutils.cpp.
|
static |
Returns a string list of SQLite (and spatialite) system tables.
Definition at line 294 of file qgssqliteutils.cpp.
|
static |
Returns a list of field names for connection and tableName having a UNIQUE constraint, fields that are part of a UNIQUE constraint that spans over multiple fields are not returned.
Definition at line 125 of file qgssqliteutils.cpp.