Class: QgsSqliteUtils

class qgis.core.QgsSqliteUtils

Bases: sip.wrapper

Contains utilities for working with Sqlite data sources.

New in version 3.4:

Methods

quotedIdentifier

Returns a properly quoted version of identifier.

quotedString

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

quotedValue

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

systemTables

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

quotedIdentifier(identifier: str) str

Returns a properly quoted version of identifier.

New in version 3.6.

Parameters

identifier (str) –

Return type

str

quotedString(value: str) str

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

Parameters

value (str) –

Return type

str

quotedValue(value: Any) str

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

New in version 3.6.

Parameters

value (Any) –

Return type

str

systemTables() List[str]

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

New in version 3.8.

Return type

List[str]