QgsSqliteUtils Class Reference

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.

Detailed Description

Contains utilities for working with Sqlite data sources.

Since

QGIS 3.4

Definition at line 170 of file qgssqliteutils.h.

Member Function Documentation

nextSequenceValue()

long long QgsSqliteUtils::nextSequenceValue ( sqlite3 *  connection, const QString &  tableName, QString  errorMessage  )

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.

Returns

the next sequence value or -1 case of errors

Note

not available in Python bindings

Since

QGIS 3.14

Definition at line 207 of file qgssqliteutils.cpp.

quotedIdentifier()

QString QgsSqliteUtils::quotedIdentifier ( const QString &  identifier )

static

Returns a properly quoted version of identifier.

Since

QGIS 3.6

Definition at line 265 of file qgssqliteutils.cpp.

quotedString()

QString QgsSqliteUtils::quotedString ( const QString &  value )

static

Returns a quoted string value, surround by ' characters and with special characters correctly escaped.

Definition at line 255 of file qgssqliteutils.cpp.

quotedValue()

QString QgsSqliteUtils::quotedValue ( const QVariant &  value )

static

Returns a properly quoted and escaped version of value for use in SQL strings.

Since

QGIS 3.6

Definition at line 272 of file qgssqliteutils.cpp.

systemTables()

QStringList QgsSqliteUtils::systemTables ( )

static

Returns a string list of SQLite (and spatialite) system tables.

Since

QGIS 3.8

Definition at line 299 of file qgssqliteutils.cpp.

uniqueFields()

QSet< QString > QgsSqliteUtils::uniqueFields ( sqlite3 *  connection, const QString &  tableName, QString &  errorMessage  )

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.

Note

the implementation is the same of GDAL but the test coverage is much better in GDAL.

not available in Python bindings

Since

QGIS 3.14

Definition at line 125 of file qgssqliteutils.cpp.

---

The documentation for this class was generated from the following files:

• /build/qgis-3.41.0+git20241225+af5edcb665c+99sid/src/core/qgssqliteutils.h
• /build/qgis-3.41.0+git20241225+af5edcb665c+99sid/src/core/qgssqliteutils.cpp