wxSQLite3  5.0.1
Loading...
Searching...
No Matches
wxSQLite3 Namespace Reference

Classes

class  AggregateFunction
 Interface for user defined aggregate functions. More...
class  Authorizer
 Interface for a user defined authorizer function. More...
class  BackupProgress
 Interface for a user defined backup progress function. More...
class  Blob
 Represents a SQLite BLOB handle. More...
class  Cipher
 Cipher base class. More...
class  CipherAegis
 Cipher class representing Aegis encryption with Ascon tag. More...
class  CipherAes128
 Cipher class representing AES 128 bit encryption in CBC mode. More...
class  CipherAes256
 Cipher class representing AES 256 bit encryption in CBC mode. More...
class  CipherAscon128
 Cipher class representing Ascon-128 encryption with Ascon tag. More...
class  CipherChaCha20
 Cipher class representing ChaCha20 encryption with Poly1305 HMAC. More...
class  CipherRC4
 Cipher class representing RC4 encryption (System.Data.SQLite) More...
class  CipherSQLCipher
 Cipher class representing SQLCipher encryption (AES 256 bit in CBC mode with SHA1 HMAC) More...
class  Collation
 Interface for a user defined collation sequence. More...
class  Database
 Represents a SQLite3 database object. More...
class  Exception
 SQL exception. More...
class  FunctionContext
 Context for user defined scalar or aggregate functions. More...
class  Hook
 Interface for a user defined hook function. More...
class  IntegerCollection
 Represents a named integer value collection. More...
class  Logger
 SQLite logging hook. More...
class  NamedCollection
 Represents a named collection. More...
class  RegExpOperator
 User defined function for REGEXP operator. More...
class  ResultSet
 Result set of a SQL query. More...
class  ScalarFunction
 Interface for user defined scalar functions. More...
class  Statement
 Represents a prepared SQL statement. More...
class  StatementBuffer
 SQL statement buffer for use with SQLite3's printf method. More...
class  StringCollection
 Represents a named string value collection. More...
class  Table
 Holds the complete result set of a SQL query. More...
class  Transaction
 RAII class for managing transactions. More...
class  WindowFunction
 Interface for user defined aggregate window functions. More...

Typedefs

using DatabaseHandlePtr = std::shared_ptr<DatabaseHandle>
using StatementHandlePtr = std::shared_ptr<StatementHandle>
using BlobHandlePtr = std::shared_ptr<BlobHandle>

Enumerations

enum class  CipherType {
  UNKNOWN ,
  AES128 ,
  AES256 ,
  CHACHA20 ,
  SQLCIPHER ,
  RC4 ,
  ASCON128 ,
  AEGIS
}
 Enumeration of supported cipher types. More...
enum class  TransactionType {
  TRANSACTION_DEFAULT ,
  TRANSACTION_DEFERRED ,
  TRANSACTION_IMMEDIATE ,
  TRANSACTION_EXCLUSIVE
}
 Enumeration of transaction types. More...
enum class  TransactionState {
  TRANSACTION_INVALID ,
  TRANSACTION_NONE ,
  TRANSACTION_READ ,
  TRANSACTION_WRITE
}
 Enumeration of transaction states. More...
enum class  LimitType {
  LIMIT_LENGTH = 0 ,
  LIMIT_SQL_LENGTH = 1 ,
  LIMIT_COLUMN = 2 ,
  LIMIT_EXPR_DEPTH = 3 ,
  LIMIT_COMPOUND_SELECT = 4 ,
  LIMIT_VDBE_OP = 5 ,
  LIMIT_FUNCTION_ARG = 6 ,
  LIMIT_ATTACHED = 7 ,
  LIMIT_LIKE_PATTERN_LENGTH = 8 ,
  LIMIT_VARIABLE_NUMBER = 9 ,
  LIMIT_TRIGGER_DEPTH = 10 ,
  LIMIT_WORKER_THREADS = 11 ,
  LIMIT_PARSER_DEPTH = 12
}
 Enumeration of SQLite run-time limit categories. More...
enum class  JournalMode {
  JOURNALMODE_DELETE = 0 ,
  JOURNALMODE_PERSIST = 1 ,
  JOURNALMODE_OFF = 2 ,
  JOURNALMODE_TRUNCATE = 3 ,
  JOURNALMODE_MEMORY = 4 ,
  JOURNALMODE_WAL = 5
}
 Enumeration of journal modes. More...
enum class  StatementStatus {
  STMTSTATUS_FULLSCAN_STEP = 1 ,
  STMTSTATUS_SORT = 2 ,
  STMTSTATUS_AUTOINDEX = 3 ,
  STMTSTATUS_VM_STEP = 4 ,
  STMTSTATUS_REPREPARE = 5 ,
  STMTSTATUS_RUN = 6 ,
  STMTSTATUS_FILTER_MISS = 7 ,
  STMTSTATUS_FILTER_HIT = 8 ,
  STMTSTATUS_MEMUSED = 99
}
 Enumeration of statement status counters. More...
enum class  DbConfig {
  DBCONFIG_ENABLE_FKEY = 1002 ,
  DBCONFIG_ENABLE_TRIGGER = 1003 ,
  DBCONFIG_ENABLE_FTS3_TOKENIZER = 1004 ,
  DBCONFIG_ENABLE_LOAD_EXTENSION = 1005 ,
  DBCONFIG_NO_CKPT_ON_CLOSE = 1006 ,
  DBCONFIG_ENABLE_QPSG = 1007 ,
  DBCONFIG_TRIGGER_EQP = 1008 ,
  DBCONFIG_RESET_DATABASE = 1009 ,
  DBCONFIG_DEFENSIVE = 1010 ,
  DBCONFIG_WRITABLE_SCHEMA = 1011 ,
  DBCONFIG_LEGACY_ALTER_TABLE = 1012 ,
  DBCONFIG_DQS_DML = 1013 ,
  DBCONFIG_DQS_DDL = 1014 ,
  DBCONFIG_ENABLE_VIEW = 1015 ,
  DBCONFIG_LEGACY_FILE_FORMAT = 1016 ,
  DBCONFIG_TRUSTED_SCHEMA = 1017 ,
  DBCONFIG_STMT_SCANSTATUS = 1018 ,
  DBCONFIG_REVERSE_SCANORDER = 1019 ,
  DBCONFIG_ENABLE_ATTACH_CREATE = 1020 ,
  DBCONFIG_ENABLE_ATTACH_WRITE = 1021 ,
  DBCONFIG_ENABLE_COMMENTS = 1022 ,
  DBCONFIG_FP_DIGITS = 1023
}
 Enumeration of database configuration options. More...
enum class  AuthorizationCode {
  AUTH_COPY = 0 ,
  AUTH_CREATE_INDEX = 1 ,
  AUTH_CREATE_TABLE = 2 ,
  AUTH_CREATE_TEMP_INDEX = 3 ,
  AUTH_CREATE_TEMP_TABLE = 4 ,
  AUTH_CREATE_TEMP_TRIGGER = 5 ,
  AUTH_CREATE_TEMP_VIEW = 6 ,
  AUTH_CREATE_TRIGGER = 7 ,
  AUTH_CREATE_VIEW = 8 ,
  AUTH_DELETE = 9 ,
  AUTH_DROP_INDEX = 10 ,
  AUTH_DROP_TABLE = 11 ,
  AUTH_DROP_TEMP_INDEX = 12 ,
  AUTH_DROP_TEMP_TABLE = 13 ,
  AUTH_DROP_TEMP_TRIGGER = 14 ,
  AUTH_DROP_TEMP_VIEW = 15 ,
  AUTH_DROP_TRIGGER = 16 ,
  AUTH_DROP_VIEW = 17 ,
  AUTH_INSERT = 18 ,
  AUTH_PRAGMA = 19 ,
  AUTH_READ = 20 ,
  AUTH_SELECT = 21 ,
  AUTH_TRANSACTION = 22 ,
  AUTH_UPDATE = 23 ,
  AUTH_ATTACH = 24 ,
  AUTH_DETACH = 25 ,
  AUTH_ALTER_TABLE = 26 ,
  AUTH_REINDEX = 27 ,
  AUTH_ANALYZE = 28 ,
  AUTH_CREATE_VTABLE = 29 ,
  AUTH_DROP_VTABLE = 30 ,
  AUTH_FUNCTION = 31 ,
  AUTH_SAVEPOINT = 32 ,
  AUTH_RECURSIVE = 33 ,
  AUTH_MAX_CODE = AUTH_RECURSIVE
}
 Authorizer action codes. More...

Functions

void operator++ (LimitType &value)

Variables

constexpr int WXSQLITE_ERROR = 1000
 Generic wxSQLite3 error.
class WXDLLIMPEXP_FWD_SQLITE3 Database
Result codes

List of SQLite result codes and extended result codes

The return codes are based on the SQLite result codes. The names start with the prefix RC instead of SQLITE to avoid name clashes in case you decide to include the original SQLite header file. See the SQLite documentation for additional information about the meaning of the individual result codes, especially the extended result codes.

constexpr int RC_OK = 0
 Successful result.
constexpr int RC_ERROR = 1
 Generic error.
constexpr int RC_INTERNAL = 2
 Internal logic error in SQLite.
constexpr int RC_PERM = 3
 Access permission denied.
constexpr int RC_ABORT = 4
 Callback routine requested an abort.
constexpr int RC_BUSY = 5
 The database file is locked.
constexpr int RC_LOCKED = 6
 A table in the database is locked.
constexpr int RC_NOMEM = 7
 A malloc() failed.
constexpr int RC_READONLY = 8
 Attempt to write a readonly database.
constexpr int RC_INTERRUPT = 9
 Operation terminated by sqlite3_interrupt()
constexpr int RC_IOERR = 10
 Some kind of disk I/O error occurred.
constexpr int RC_CORRUPT = 11
 The database disk image is malformed.
constexpr int RC_NOTFOUND = 12
 Unknown opcode in sqlite3_file_control()
constexpr int RC_FULL = 13
 Insertion failed because database is full.
constexpr int RC_CANTOPEN = 14
 Unable to open the database file.
constexpr int RC_PROTOCOL = 15
 Database lock protocol error.
constexpr int RC_EMPTY = 16
 Internal use only.
constexpr int RC_SCHEMA = 17
 The database schema changed.
constexpr int RC_TOOBIG = 18
 String or BLOB exceeds size limit.
constexpr int RC_CONSTRAINT = 19
 Abort due to constraint violation.
constexpr int RC_MISMATCH = 20
 Data type mismatch.
constexpr int RC_MISUSE = 21
 Library used incorrectly.
constexpr int RC_NOLFS = 22
 Uses OS features not supported on host.
constexpr int RC_AUTH = 23
 Authorization denied.
constexpr int RC_FORMAT = 24
 Not useD.
constexpr int RC_RANGE = 25
 2nd parameter to sqlite3_bind out of range
constexpr int RC_NOTADB = 26
 File opened that is not a database file.
constexpr int RC_NOTICE = 27
 Notifications from sqlite3_log()
constexpr int RC_WARNING = 28
 Warnings from sqlite3_log()
constexpr int RC_ROW = 100
 sqlite3_step() has another row ready
constexpr int RC_DONE = 101
 sqlite3_step() has finished executing
Extended result codes
constexpr int RC_ERROR_MISSING_COLLSEQ = (RC_ERROR | (1 << 8))
constexpr int RC_ERROR_RETRY = (RC_ERROR | (2 << 8))
constexpr int RC_ERROR_SNAPSHOT = (RC_ERROR | (3 << 8))
constexpr int RC_ERROR_RESERVESIZE = (RC_ERROR | (4 << 8))
constexpr int RC_ERROR_KEY = (RC_ERROR | (5 << 8))
constexpr int RC_ERROR_UNABLE = (RC_ERROR | (6 << 8))
constexpr int RC_IOERR_READ = (RC_IOERR | (1 << 8))
constexpr int RC_IOERR_SHORT_READ = (RC_IOERR | (2 << 8))
constexpr int RC_IOERR_WRITE = (RC_IOERR | (3 << 8))
constexpr int RC_IOERR_FSYNC = (RC_IOERR | (4 << 8))
constexpr int RC_IOERR_DIR_FSYNC = (RC_IOERR | (5 << 8))
constexpr int RC_IOERR_TRUNCATE = (RC_IOERR | (6 << 8))
constexpr int RC_IOERR_FSTAT = (RC_IOERR | (7 << 8))
constexpr int RC_IOERR_UNLOCK = (RC_IOERR | (8 << 8))
constexpr int RC_IOERR_RDLOCK = (RC_IOERR | (9 << 8))
constexpr int RC_IOERR_DELETE = (RC_IOERR | (10 << 8))
constexpr int RC_IOERR_BLOCKED = (RC_IOERR | (11 << 8))
constexpr int RC_IOERR_NOMEM = (RC_IOERR | (12 << 8))
constexpr int RC_IOERR_ACCESS = (RC_IOERR | (13 << 8))
constexpr int RC_IOERR_CHECKRESERVEDLOCK = (RC_IOERR | (14 << 8))
constexpr int RC_IOERR_LOCK = (RC_IOERR | (15 << 8))
constexpr int RC_IOERR_CLOSE = (RC_IOERR | (16 << 8))
constexpr int RC_IOERR_DIR_CLOSE = (RC_IOERR | (17 << 8))
constexpr int RC_IOERR_SHMOPEN = (RC_IOERR | (18 << 8))
constexpr int RC_IOERR_SHMSIZE = (RC_IOERR | (19 << 8))
constexpr int RC_IOERR_SHMLOCK = (RC_IOERR | (20 << 8))
constexpr int RC_IOERR_SHMMAP = (RC_IOERR | (21 << 8))
constexpr int RC_IOERR_SEEK = (RC_IOERR | (22 << 8))
constexpr int RC_IOERR_DELETE_NOENT = (RC_IOERR | (23 << 8))
constexpr int RC_IOERR_MMAP = (RC_IOERR | (24 << 8))
constexpr int RC_IOERR_GETTEMPPATH = (RC_IOERR | (25 << 8))
constexpr int RC_IOERR_CONVPATH = (RC_IOERR | (26 << 8))
constexpr int RC_IOERR_VNODE = (RC_IOERR | (27 << 8))
constexpr int RC_IOERR_AUTH = (RC_IOERR | (28 << 8))
constexpr int RC_IOERR_BEGIN_ATOMIC = (RC_IOERR | (29 << 8))
constexpr int RC_IOERR_COMMIT_ATOMIC = (RC_IOERR | (30 << 8))
constexpr int RC_IOERR_ROLLBACK_ATOMIC = (RC_IOERR | (31 << 8))
constexpr int RC_IOERR_DATA = (RC_IOERR | (32 << 8))
constexpr int RC_IOERR_CORRUPTFS = (RC_IOERR | (33 << 8))
constexpr int RC_IOERR_IN_PAGE = (RC_IOERR | (34 << 8))
constexpr int RC_IOERR_BADKEY = (RC_IOERR | (35 << 8))
constexpr int RC_IOERR_CODEC = (RC_IOERR | (36 << 8))
constexpr int RC_LOCKED_SHAREDCACHE = (RC_LOCKED | (1 << 8))
constexpr int RC_LOCKED_VTAB = (RC_LOCKED | (2 << 8))
constexpr int RC_BUSY_RECOVERY = (RC_BUSY | (1 << 8))
constexpr int RC_BUSY_SNAPSHOT = (RC_BUSY | (2 << 8))
constexpr int RC_BUSY_TIMEOUT = (RC_BUSY | (3 << 8))
constexpr int RC_CANTOPEN_NOTEMPDIR = (RC_CANTOPEN | (1 << 8))
constexpr int RC_CANTOPEN_ISDIR = (RC_CANTOPEN | (2 << 8))
constexpr int RC_CANTOPEN_FULLPATH = (RC_CANTOPEN | (3 << 8))
constexpr int RC_CANTOPEN_CONVPATH = (RC_CANTOPEN | (4 << 8))
constexpr int RC_CANTOPEN_DIRTYWAL = (RC_CANTOPEN | (5 << 8))
constexpr int RC_CANTOPEN_SYMLINK = (RC_CANTOPEN | (6 << 8))
constexpr int RC_CORRUPT_VTAB = (RC_CORRUPT | (1 << 8))
constexpr int RC_CORRUPT_SEQUENCE = (RC_CORRUPT | (2 << 8))
constexpr int RC_CORRUPT_INDEX = (RC_CORRUPT | (3 << 8))
constexpr int RC_READONLY_RECOVERY = (RC_READONLY | (1 << 8))
constexpr int RC_READONLY_CANTLOCK = (RC_READONLY | (2 << 8))
constexpr int RC_READONLY_ROLLBACK = (RC_READONLY | (3 << 8))
constexpr int RC_READONLY_DBMOVED = (RC_READONLY | (4 << 8))
constexpr int RC_READONLY_CANTINIT = (RC_READONLY | (5 << 8))
constexpr int RC_READONLY_DIRECTORY = (RC_READONLY | (6 << 8))
constexpr int RC_ABORT_ROLLBACK = (RC_ABORT | (2 << 8))
constexpr int RC_CONSTRAINT_CHECK = (RC_CONSTRAINT | (1 << 8))
constexpr int RC_CONSTRAINT_COMMITHOOK = (RC_CONSTRAINT | (2 << 8))
constexpr int RC_CONSTRAINT_FOREIGNKEY = (RC_CONSTRAINT | (3 << 8))
constexpr int RC_CONSTRAINT_FUNCTION = (RC_CONSTRAINT | (4 << 8))
constexpr int RC_CONSTRAINT_NOTNULL = (RC_CONSTRAINT | (5 << 8))
constexpr int RC_CONSTRAINT_PRIMARYKEY = (RC_CONSTRAINT | (6 << 8))
constexpr int RC_CONSTRAINT_TRIGGER = (RC_CONSTRAINT | (7 << 8))
constexpr int RC_CONSTRAINT_UNIQUE = (RC_CONSTRAINT | (8 << 8))
constexpr int RC_CONSTRAINT_VTAB = (RC_CONSTRAINT | (9 << 8))
constexpr int RC_CONSTRAINT_ROWID = (RC_CONSTRAINT | (10 << 8))
constexpr int RC_CONSTRAINT_PINNED = (RC_CONSTRAINT | (11 << 8))
constexpr int RC_CONSTRAINT_DATATYPE = (RC_CONSTRAINT | (12 << 8))
constexpr int RC_NOTICE_RECOVER_WAL = (RC_NOTICE | (1 << 8))
constexpr int RC_NOTICE_RECOVER_ROLLBACK = (RC_NOTICE | (2 << 8))
constexpr int RC_NOTICE_RBU = (RC_NOTICE | (3 << 8))
constexpr int RC_WARNING_AUTOINDEX = (RC_WARNING | (1 << 8))
constexpr int RC_AUTH_USER = (RC_AUTH | (1 << 8))
constexpr int RC_OK_LOAD_PERMANENTLY = (RC_OK | (1 << 8))
constexpr int RC_OK_SYMLINK = (RC_OK | (2 << 8))
SQLite data types

Constants representing SQLite data types

The data type codes are based on the fundamental SQLite type codes. The names start with the prefix TYPE instead of SQLITE to avoid name clashes in case you decide to include the original SQLite header file. See the SQLite documentation for additional information.

constexpr int TYPE_INTEGER = 1
constexpr int TYPE_FLOAT = 2
constexpr int TYPE_TEXT = 3
constexpr int TYPE_BLOB = 4
constexpr int TYPE_NULL = 5
Flags for file open operations

Flags for use on opening database connections

The flags are based on the corresponding SQLite flags. The names start without the SQLITE prefix to avoid name clashes in case you decide to include the original SQLite header file. See the SQLite documentation for additional information.

constexpr int OPEN_READONLY = 0x00000001
constexpr int OPEN_READWRITE = 0x00000002
constexpr int OPEN_CREATE = 0x00000004
constexpr int OPEN_URI = 0x00000040
constexpr int OPEN_MEMORY = 0x00000080
constexpr int OPEN_NOMUTEX = 0x00008000
constexpr int OPEN_FULLMUTEX = 0x00010000
constexpr int OPEN_SHAREDCACHE = 0x00020000
constexpr int OPEN_PRIVATECACHE = 0x00040000
constexpr int OPEN_NOFOLLOW = 0x01000000
Checkpoint mode values

Constants representing checkpoint mode values

The flags are based on the corresponding SQLite flags. The names start without the SQLITE prefix to avoid name clashes in case you decide to include the original SQLite header file. See the SQLite documentation for additional information.

constexpr int CHECKPOINT_PASSIVE = 0
constexpr int CHECKPOINT_FULL = 1
constexpr int CHECKPOINT_RESTART = 2
constexpr int CHECKPOINT_TRUNCATE = 3
Function flags

Constants representing SQLite function flags

The flags are based on the corresponding SQLite flags. The names start with the prefix FUNC instead of the prefix SQLITE to avoid name clashes in case you decide to include the original SQLite header file. See the SQLite documentation for additional information.

constexpr int FUNC_DETERMINISTIC = 0x00000800
constexpr int FUNC_DIRECTONLY = 0x00080000
constexpr int FUNC_SUBTYPE = 0x00100000
constexpr int FUNC_INNOCUOUS = 0x00200000
constexpr int FUNC_RESULT_SUBTYPE = 0x01000000
constexpr int FUNC_SELFORDER1 = 0x02000000

Typedef Documentation

◆ BlobHandlePtr

using wxSQLite3::BlobHandlePtr = std::shared_ptr<BlobHandle>

◆ DatabaseHandlePtr

using wxSQLite3::DatabaseHandlePtr = std::shared_ptr<DatabaseHandle>

◆ StatementHandlePtr

using wxSQLite3::StatementHandlePtr = std::shared_ptr<StatementHandle>

Enumeration Type Documentation

◆ AuthorizationCode

enum class wxSQLite3::AuthorizationCode
strong

Authorizer action codes.

The authorizer action codes are based on the corresponding SQLite authorizer action codes. The names start with the prefix AUTH instead of the prefix SQLITE to avoid name clashes in case you decide to include the original SQLite header file. See the SQLite documentation for additional information.

Enumerator
AUTH_COPY 
AUTH_CREATE_INDEX 
AUTH_CREATE_TABLE 
AUTH_CREATE_TEMP_INDEX 
AUTH_CREATE_TEMP_TABLE 
AUTH_CREATE_TEMP_TRIGGER 
AUTH_CREATE_TEMP_VIEW 
AUTH_CREATE_TRIGGER 
AUTH_CREATE_VIEW 
AUTH_DELETE 
AUTH_DROP_INDEX 10 
AUTH_DROP_TABLE 11 
AUTH_DROP_TEMP_INDEX 12 
AUTH_DROP_TEMP_TABLE 13 
AUTH_DROP_TEMP_TRIGGER 14 
AUTH_DROP_TEMP_VIEW 15 
AUTH_DROP_TRIGGER 16 
AUTH_DROP_VIEW 17 
AUTH_INSERT 18 
AUTH_PRAGMA 19 
AUTH_READ 20 
AUTH_SELECT 21 
AUTH_TRANSACTION 22 
AUTH_UPDATE 23 
AUTH_ATTACH 24 
AUTH_DETACH 25 
AUTH_ALTER_TABLE 26 
AUTH_REINDEX 27 
AUTH_ANALYZE 28 
AUTH_CREATE_VTABLE 29 
AUTH_DROP_VTABLE 30 
AUTH_FUNCTION 31 
AUTH_SAVEPOINT 32 
AUTH_RECURSIVE 33 
AUTH_MAX_CODE AUTH_RECURSIVE 

◆ CipherType

enum class wxSQLite3::CipherType
strong

Enumeration of supported cipher types.

Enumerator
UNKNOWN 

Unknown cipher.

AES128 

wxSQLite3 Cipher AES 128-Bit CBC

AES256 

wxSQLite3 Cipher AES 256-Bit CBC

CHACHA20 

Cipher ChaCha20-Poly1305 (sqleet)

SQLCIPHER 

Cipher SQLCipher (see SQLCipher website)

RC4 

Cipher RC4 as used in older versions of System.Data.SQLite

ASCON128 

Cipher Ascon-128

AEGIS 

Cipher AEGIS

◆ DbConfig

enum class wxSQLite3::DbConfig
strong

Enumeration of database configuration options.

The database configuration options are based on the SQLite database configuration options. The names start without the SQLITE prefix to avoid name clashes in case you decide to include the original SQLite header file. See the SQLite documentation for additional information.

Enumerator
DBCONFIG_ENABLE_FKEY 1002 
DBCONFIG_ENABLE_TRIGGER 1003 
DBCONFIG_ENABLE_FTS3_TOKENIZER 1004 
DBCONFIG_ENABLE_LOAD_EXTENSION 1005 
DBCONFIG_NO_CKPT_ON_CLOSE 1006 
DBCONFIG_ENABLE_QPSG 1007 
DBCONFIG_TRIGGER_EQP 1008 
DBCONFIG_RESET_DATABASE 1009 
DBCONFIG_DEFENSIVE 1010 
DBCONFIG_WRITABLE_SCHEMA 1011 
DBCONFIG_LEGACY_ALTER_TABLE 1012 
DBCONFIG_DQS_DML 1013 
DBCONFIG_DQS_DDL 1014 
DBCONFIG_ENABLE_VIEW 1015 
DBCONFIG_LEGACY_FILE_FORMAT 1016 
DBCONFIG_TRUSTED_SCHEMA 1017 
DBCONFIG_STMT_SCANSTATUS 1018 
DBCONFIG_REVERSE_SCANORDER 1019 
DBCONFIG_ENABLE_ATTACH_CREATE 1020 
DBCONFIG_ENABLE_ATTACH_WRITE 1021 
DBCONFIG_ENABLE_COMMENTS 1022 
DBCONFIG_FP_DIGITS 1023 

◆ JournalMode

enum class wxSQLite3::JournalMode
strong

Enumeration of journal modes.

Enumerator
JOURNALMODE_DELETE 

Commit by deleting journal file.

JOURNALMODE_PERSIST 

Commit by zeroing journal header.

JOURNALMODE_OFF 

Journal omitted.

JOURNALMODE_TRUNCATE 

Commit by truncating journal.

JOURNALMODE_MEMORY 

In-memory journal file.

JOURNALMODE_WAL 

Use write-ahead logging.

◆ LimitType

enum class wxSQLite3::LimitType
strong

Enumeration of SQLite run-time limit categories.

The limit categories are based on the SQLite limit categories. The names start without the SQLITE prefix to avoid name clashes in case you decide to include the original SQLite header file. See the SQLite documentation for additional information.

Enumerator
LIMIT_LENGTH 
LIMIT_SQL_LENGTH 
LIMIT_COLUMN 
LIMIT_EXPR_DEPTH 
LIMIT_COMPOUND_SELECT 
LIMIT_VDBE_OP 
LIMIT_FUNCTION_ARG 
LIMIT_ATTACHED 
LIMIT_LIKE_PATTERN_LENGTH 
LIMIT_VARIABLE_NUMBER 
LIMIT_TRIGGER_DEPTH 10 
LIMIT_WORKER_THREADS 11 
LIMIT_PARSER_DEPTH 12 

◆ StatementStatus

enum class wxSQLite3::StatementStatus
strong

Enumeration of statement status counters.

The statement status counters are based on the SQLite statement status counters. The names start without the SQLITE prefix to avoid name clashes in case you decide to include the original SQLite header file. See the SQLite documentation for additional information.

Enumerator
STMTSTATUS_FULLSCAN_STEP 
STMTSTATUS_SORT 
STMTSTATUS_AUTOINDEX 
STMTSTATUS_VM_STEP 
STMTSTATUS_REPREPARE 
STMTSTATUS_RUN 
STMTSTATUS_FILTER_MISS 
STMTSTATUS_FILTER_HIT 
STMTSTATUS_MEMUSED 99 

◆ TransactionState

enum class wxSQLite3::TransactionState
strong

Enumeration of transaction states.

Enumerator
TRANSACTION_INVALID 
TRANSACTION_NONE 
TRANSACTION_READ 
TRANSACTION_WRITE 

◆ TransactionType

enum class wxSQLite3::TransactionType
strong

Enumeration of transaction types.

Enumerator
TRANSACTION_DEFAULT 
TRANSACTION_DEFERRED 
TRANSACTION_IMMEDIATE 
TRANSACTION_EXCLUSIVE 

Function Documentation

◆ operator++()

void wxSQLite3::operator++ ( LimitType & value)
inline

Variable Documentation

◆ CHECKPOINT_FULL

int wxSQLite3::CHECKPOINT_FULL = 1
constexpr

◆ CHECKPOINT_PASSIVE

int wxSQLite3::CHECKPOINT_PASSIVE = 0
constexpr

◆ CHECKPOINT_RESTART

int wxSQLite3::CHECKPOINT_RESTART = 2
constexpr

◆ CHECKPOINT_TRUNCATE

int wxSQLite3::CHECKPOINT_TRUNCATE = 3
constexpr

◆ Database

class WXDLLIMPEXP_FWD_SQLITE3 wxSQLite3::Database

◆ FUNC_DETERMINISTIC

int wxSQLite3::FUNC_DETERMINISTIC = 0x00000800
constexpr

◆ FUNC_DIRECTONLY

int wxSQLite3::FUNC_DIRECTONLY = 0x00080000
constexpr

◆ FUNC_INNOCUOUS

int wxSQLite3::FUNC_INNOCUOUS = 0x00200000
constexpr

◆ FUNC_RESULT_SUBTYPE

int wxSQLite3::FUNC_RESULT_SUBTYPE = 0x01000000
constexpr

◆ FUNC_SELFORDER1

int wxSQLite3::FUNC_SELFORDER1 = 0x02000000
constexpr

◆ FUNC_SUBTYPE

int wxSQLite3::FUNC_SUBTYPE = 0x00100000
constexpr

◆ OPEN_CREATE

int wxSQLite3::OPEN_CREATE = 0x00000004
constexpr

◆ OPEN_FULLMUTEX

int wxSQLite3::OPEN_FULLMUTEX = 0x00010000
constexpr

◆ OPEN_MEMORY

int wxSQLite3::OPEN_MEMORY = 0x00000080
constexpr

◆ OPEN_NOFOLLOW

int wxSQLite3::OPEN_NOFOLLOW = 0x01000000
constexpr

◆ OPEN_NOMUTEX

int wxSQLite3::OPEN_NOMUTEX = 0x00008000
constexpr

◆ OPEN_PRIVATECACHE

int wxSQLite3::OPEN_PRIVATECACHE = 0x00040000
constexpr

◆ OPEN_READONLY

int wxSQLite3::OPEN_READONLY = 0x00000001
constexpr

◆ OPEN_READWRITE

int wxSQLite3::OPEN_READWRITE = 0x00000002
constexpr

◆ OPEN_SHAREDCACHE

int wxSQLite3::OPEN_SHAREDCACHE = 0x00020000
constexpr

◆ OPEN_URI

int wxSQLite3::OPEN_URI = 0x00000040
constexpr

◆ RC_ABORT

int wxSQLite3::RC_ABORT = 4
constexpr

Callback routine requested an abort.

◆ RC_ABORT_ROLLBACK

int wxSQLite3::RC_ABORT_ROLLBACK = (RC_ABORT | (2 << 8))
constexpr

◆ RC_AUTH

int wxSQLite3::RC_AUTH = 23
constexpr

Authorization denied.

◆ RC_AUTH_USER

int wxSQLite3::RC_AUTH_USER = (RC_AUTH | (1 << 8))
constexpr

◆ RC_BUSY

int wxSQLite3::RC_BUSY = 5
constexpr

The database file is locked.

◆ RC_BUSY_RECOVERY

int wxSQLite3::RC_BUSY_RECOVERY = (RC_BUSY | (1 << 8))
constexpr

◆ RC_BUSY_SNAPSHOT

int wxSQLite3::RC_BUSY_SNAPSHOT = (RC_BUSY | (2 << 8))
constexpr

◆ RC_BUSY_TIMEOUT

int wxSQLite3::RC_BUSY_TIMEOUT = (RC_BUSY | (3 << 8))
constexpr

◆ RC_CANTOPEN

int wxSQLite3::RC_CANTOPEN = 14
constexpr

Unable to open the database file.

◆ RC_CANTOPEN_CONVPATH

int wxSQLite3::RC_CANTOPEN_CONVPATH = (RC_CANTOPEN | (4 << 8))
constexpr

◆ RC_CANTOPEN_DIRTYWAL

int wxSQLite3::RC_CANTOPEN_DIRTYWAL = (RC_CANTOPEN | (5 << 8))
constexpr

◆ RC_CANTOPEN_FULLPATH

int wxSQLite3::RC_CANTOPEN_FULLPATH = (RC_CANTOPEN | (3 << 8))
constexpr

◆ RC_CANTOPEN_ISDIR

int wxSQLite3::RC_CANTOPEN_ISDIR = (RC_CANTOPEN | (2 << 8))
constexpr

◆ RC_CANTOPEN_NOTEMPDIR

int wxSQLite3::RC_CANTOPEN_NOTEMPDIR = (RC_CANTOPEN | (1 << 8))
constexpr

◆ RC_CANTOPEN_SYMLINK

int wxSQLite3::RC_CANTOPEN_SYMLINK = (RC_CANTOPEN | (6 << 8))
constexpr

◆ RC_CONSTRAINT

int wxSQLite3::RC_CONSTRAINT = 19
constexpr

Abort due to constraint violation.

◆ RC_CONSTRAINT_CHECK

int wxSQLite3::RC_CONSTRAINT_CHECK = (RC_CONSTRAINT | (1 << 8))
constexpr

◆ RC_CONSTRAINT_COMMITHOOK

int wxSQLite3::RC_CONSTRAINT_COMMITHOOK = (RC_CONSTRAINT | (2 << 8))
constexpr

◆ RC_CONSTRAINT_DATATYPE

int wxSQLite3::RC_CONSTRAINT_DATATYPE = (RC_CONSTRAINT | (12 << 8))
constexpr

◆ RC_CONSTRAINT_FOREIGNKEY

int wxSQLite3::RC_CONSTRAINT_FOREIGNKEY = (RC_CONSTRAINT | (3 << 8))
constexpr

◆ RC_CONSTRAINT_FUNCTION

int wxSQLite3::RC_CONSTRAINT_FUNCTION = (RC_CONSTRAINT | (4 << 8))
constexpr

◆ RC_CONSTRAINT_NOTNULL

int wxSQLite3::RC_CONSTRAINT_NOTNULL = (RC_CONSTRAINT | (5 << 8))
constexpr

◆ RC_CONSTRAINT_PINNED

int wxSQLite3::RC_CONSTRAINT_PINNED = (RC_CONSTRAINT | (11 << 8))
constexpr

◆ RC_CONSTRAINT_PRIMARYKEY

int wxSQLite3::RC_CONSTRAINT_PRIMARYKEY = (RC_CONSTRAINT | (6 << 8))
constexpr

◆ RC_CONSTRAINT_ROWID

int wxSQLite3::RC_CONSTRAINT_ROWID = (RC_CONSTRAINT | (10 << 8))
constexpr

◆ RC_CONSTRAINT_TRIGGER

int wxSQLite3::RC_CONSTRAINT_TRIGGER = (RC_CONSTRAINT | (7 << 8))
constexpr

◆ RC_CONSTRAINT_UNIQUE

int wxSQLite3::RC_CONSTRAINT_UNIQUE = (RC_CONSTRAINT | (8 << 8))
constexpr

◆ RC_CONSTRAINT_VTAB

int wxSQLite3::RC_CONSTRAINT_VTAB = (RC_CONSTRAINT | (9 << 8))
constexpr

◆ RC_CORRUPT

int wxSQLite3::RC_CORRUPT = 11
constexpr

The database disk image is malformed.

◆ RC_CORRUPT_INDEX

int wxSQLite3::RC_CORRUPT_INDEX = (RC_CORRUPT | (3 << 8))
constexpr

◆ RC_CORRUPT_SEQUENCE

int wxSQLite3::RC_CORRUPT_SEQUENCE = (RC_CORRUPT | (2 << 8))
constexpr

◆ RC_CORRUPT_VTAB

int wxSQLite3::RC_CORRUPT_VTAB = (RC_CORRUPT | (1 << 8))
constexpr

◆ RC_DONE

int wxSQLite3::RC_DONE = 101
constexpr

sqlite3_step() has finished executing

◆ RC_EMPTY

int wxSQLite3::RC_EMPTY = 16
constexpr

Internal use only.

◆ RC_ERROR

int wxSQLite3::RC_ERROR = 1
constexpr

Generic error.

◆ RC_ERROR_KEY

int wxSQLite3::RC_ERROR_KEY = (RC_ERROR | (5 << 8))
constexpr

◆ RC_ERROR_MISSING_COLLSEQ

int wxSQLite3::RC_ERROR_MISSING_COLLSEQ = (RC_ERROR | (1 << 8))
constexpr

◆ RC_ERROR_RESERVESIZE

int wxSQLite3::RC_ERROR_RESERVESIZE = (RC_ERROR | (4 << 8))
constexpr

◆ RC_ERROR_RETRY

int wxSQLite3::RC_ERROR_RETRY = (RC_ERROR | (2 << 8))
constexpr

◆ RC_ERROR_SNAPSHOT

int wxSQLite3::RC_ERROR_SNAPSHOT = (RC_ERROR | (3 << 8))
constexpr

◆ RC_ERROR_UNABLE

int wxSQLite3::RC_ERROR_UNABLE = (RC_ERROR | (6 << 8))
constexpr

◆ RC_FORMAT

int wxSQLite3::RC_FORMAT = 24
constexpr

Not useD.

◆ RC_FULL

int wxSQLite3::RC_FULL = 13
constexpr

Insertion failed because database is full.

◆ RC_INTERNAL

int wxSQLite3::RC_INTERNAL = 2
constexpr

Internal logic error in SQLite.

◆ RC_INTERRUPT

int wxSQLite3::RC_INTERRUPT = 9
constexpr

Operation terminated by sqlite3_interrupt()

◆ RC_IOERR

int wxSQLite3::RC_IOERR = 10
constexpr

Some kind of disk I/O error occurred.

◆ RC_IOERR_ACCESS

int wxSQLite3::RC_IOERR_ACCESS = (RC_IOERR | (13 << 8))
constexpr

◆ RC_IOERR_AUTH

int wxSQLite3::RC_IOERR_AUTH = (RC_IOERR | (28 << 8))
constexpr

◆ RC_IOERR_BADKEY

int wxSQLite3::RC_IOERR_BADKEY = (RC_IOERR | (35 << 8))
constexpr

◆ RC_IOERR_BEGIN_ATOMIC

int wxSQLite3::RC_IOERR_BEGIN_ATOMIC = (RC_IOERR | (29 << 8))
constexpr

◆ RC_IOERR_BLOCKED

int wxSQLite3::RC_IOERR_BLOCKED = (RC_IOERR | (11 << 8))
constexpr

◆ RC_IOERR_CHECKRESERVEDLOCK

int wxSQLite3::RC_IOERR_CHECKRESERVEDLOCK = (RC_IOERR | (14 << 8))
constexpr

◆ RC_IOERR_CLOSE

int wxSQLite3::RC_IOERR_CLOSE = (RC_IOERR | (16 << 8))
constexpr

◆ RC_IOERR_CODEC

int wxSQLite3::RC_IOERR_CODEC = (RC_IOERR | (36 << 8))
constexpr

◆ RC_IOERR_COMMIT_ATOMIC

int wxSQLite3::RC_IOERR_COMMIT_ATOMIC = (RC_IOERR | (30 << 8))
constexpr

◆ RC_IOERR_CONVPATH

int wxSQLite3::RC_IOERR_CONVPATH = (RC_IOERR | (26 << 8))
constexpr

◆ RC_IOERR_CORRUPTFS

int wxSQLite3::RC_IOERR_CORRUPTFS = (RC_IOERR | (33 << 8))
constexpr

◆ RC_IOERR_DATA

int wxSQLite3::RC_IOERR_DATA = (RC_IOERR | (32 << 8))
constexpr

◆ RC_IOERR_DELETE

int wxSQLite3::RC_IOERR_DELETE = (RC_IOERR | (10 << 8))
constexpr

◆ RC_IOERR_DELETE_NOENT

int wxSQLite3::RC_IOERR_DELETE_NOENT = (RC_IOERR | (23 << 8))
constexpr

◆ RC_IOERR_DIR_CLOSE

int wxSQLite3::RC_IOERR_DIR_CLOSE = (RC_IOERR | (17 << 8))
constexpr

◆ RC_IOERR_DIR_FSYNC

int wxSQLite3::RC_IOERR_DIR_FSYNC = (RC_IOERR | (5 << 8))
constexpr

◆ RC_IOERR_FSTAT

int wxSQLite3::RC_IOERR_FSTAT = (RC_IOERR | (7 << 8))
constexpr

◆ RC_IOERR_FSYNC

int wxSQLite3::RC_IOERR_FSYNC = (RC_IOERR | (4 << 8))
constexpr

◆ RC_IOERR_GETTEMPPATH

int wxSQLite3::RC_IOERR_GETTEMPPATH = (RC_IOERR | (25 << 8))
constexpr

◆ RC_IOERR_IN_PAGE

int wxSQLite3::RC_IOERR_IN_PAGE = (RC_IOERR | (34 << 8))
constexpr

◆ RC_IOERR_LOCK

int wxSQLite3::RC_IOERR_LOCK = (RC_IOERR | (15 << 8))
constexpr

◆ RC_IOERR_MMAP

int wxSQLite3::RC_IOERR_MMAP = (RC_IOERR | (24 << 8))
constexpr

◆ RC_IOERR_NOMEM

int wxSQLite3::RC_IOERR_NOMEM = (RC_IOERR | (12 << 8))
constexpr

◆ RC_IOERR_RDLOCK

int wxSQLite3::RC_IOERR_RDLOCK = (RC_IOERR | (9 << 8))
constexpr

◆ RC_IOERR_READ

int wxSQLite3::RC_IOERR_READ = (RC_IOERR | (1 << 8))
constexpr

◆ RC_IOERR_ROLLBACK_ATOMIC

int wxSQLite3::RC_IOERR_ROLLBACK_ATOMIC = (RC_IOERR | (31 << 8))
constexpr

◆ RC_IOERR_SEEK

int wxSQLite3::RC_IOERR_SEEK = (RC_IOERR | (22 << 8))
constexpr

◆ RC_IOERR_SHMLOCK

int wxSQLite3::RC_IOERR_SHMLOCK = (RC_IOERR | (20 << 8))
constexpr

◆ RC_IOERR_SHMMAP

int wxSQLite3::RC_IOERR_SHMMAP = (RC_IOERR | (21 << 8))
constexpr

◆ RC_IOERR_SHMOPEN

int wxSQLite3::RC_IOERR_SHMOPEN = (RC_IOERR | (18 << 8))
constexpr

◆ RC_IOERR_SHMSIZE

int wxSQLite3::RC_IOERR_SHMSIZE = (RC_IOERR | (19 << 8))
constexpr

◆ RC_IOERR_SHORT_READ

int wxSQLite3::RC_IOERR_SHORT_READ = (RC_IOERR | (2 << 8))
constexpr

◆ RC_IOERR_TRUNCATE

int wxSQLite3::RC_IOERR_TRUNCATE = (RC_IOERR | (6 << 8))
constexpr

◆ RC_IOERR_UNLOCK

int wxSQLite3::RC_IOERR_UNLOCK = (RC_IOERR | (8 << 8))
constexpr

◆ RC_IOERR_VNODE

int wxSQLite3::RC_IOERR_VNODE = (RC_IOERR | (27 << 8))
constexpr

◆ RC_IOERR_WRITE

int wxSQLite3::RC_IOERR_WRITE = (RC_IOERR | (3 << 8))
constexpr

◆ RC_LOCKED

int wxSQLite3::RC_LOCKED = 6
constexpr

A table in the database is locked.

◆ RC_LOCKED_SHAREDCACHE

int wxSQLite3::RC_LOCKED_SHAREDCACHE = (RC_LOCKED | (1 << 8))
constexpr

◆ RC_LOCKED_VTAB

int wxSQLite3::RC_LOCKED_VTAB = (RC_LOCKED | (2 << 8))
constexpr

◆ RC_MISMATCH

int wxSQLite3::RC_MISMATCH = 20
constexpr

Data type mismatch.

◆ RC_MISUSE

int wxSQLite3::RC_MISUSE = 21
constexpr

Library used incorrectly.

◆ RC_NOLFS

int wxSQLite3::RC_NOLFS = 22
constexpr

Uses OS features not supported on host.

◆ RC_NOMEM

int wxSQLite3::RC_NOMEM = 7
constexpr

A malloc() failed.

◆ RC_NOTADB

int wxSQLite3::RC_NOTADB = 26
constexpr

File opened that is not a database file.

◆ RC_NOTFOUND

int wxSQLite3::RC_NOTFOUND = 12
constexpr

Unknown opcode in sqlite3_file_control()

◆ RC_NOTICE

int wxSQLite3::RC_NOTICE = 27
constexpr

Notifications from sqlite3_log()

◆ RC_NOTICE_RBU

int wxSQLite3::RC_NOTICE_RBU = (RC_NOTICE | (3 << 8))
constexpr

◆ RC_NOTICE_RECOVER_ROLLBACK

int wxSQLite3::RC_NOTICE_RECOVER_ROLLBACK = (RC_NOTICE | (2 << 8))
constexpr

◆ RC_NOTICE_RECOVER_WAL

int wxSQLite3::RC_NOTICE_RECOVER_WAL = (RC_NOTICE | (1 << 8))
constexpr

◆ RC_OK

int wxSQLite3::RC_OK = 0
constexpr

Successful result.

◆ RC_OK_LOAD_PERMANENTLY

int wxSQLite3::RC_OK_LOAD_PERMANENTLY = (RC_OK | (1 << 8))
constexpr

◆ RC_OK_SYMLINK

int wxSQLite3::RC_OK_SYMLINK = (RC_OK | (2 << 8))
constexpr

◆ RC_PERM

int wxSQLite3::RC_PERM = 3
constexpr

Access permission denied.

◆ RC_PROTOCOL

int wxSQLite3::RC_PROTOCOL = 15
constexpr

Database lock protocol error.

◆ RC_RANGE

int wxSQLite3::RC_RANGE = 25
constexpr

2nd parameter to sqlite3_bind out of range

◆ RC_READONLY

int wxSQLite3::RC_READONLY = 8
constexpr

Attempt to write a readonly database.

◆ RC_READONLY_CANTINIT

int wxSQLite3::RC_READONLY_CANTINIT = (RC_READONLY | (5 << 8))
constexpr

◆ RC_READONLY_CANTLOCK

int wxSQLite3::RC_READONLY_CANTLOCK = (RC_READONLY | (2 << 8))
constexpr

◆ RC_READONLY_DBMOVED

int wxSQLite3::RC_READONLY_DBMOVED = (RC_READONLY | (4 << 8))
constexpr

◆ RC_READONLY_DIRECTORY

int wxSQLite3::RC_READONLY_DIRECTORY = (RC_READONLY | (6 << 8))
constexpr

◆ RC_READONLY_RECOVERY

int wxSQLite3::RC_READONLY_RECOVERY = (RC_READONLY | (1 << 8))
constexpr

◆ RC_READONLY_ROLLBACK

int wxSQLite3::RC_READONLY_ROLLBACK = (RC_READONLY | (3 << 8))
constexpr

◆ RC_ROW

int wxSQLite3::RC_ROW = 100
constexpr

sqlite3_step() has another row ready

◆ RC_SCHEMA

int wxSQLite3::RC_SCHEMA = 17
constexpr

The database schema changed.

◆ RC_TOOBIG

int wxSQLite3::RC_TOOBIG = 18
constexpr

String or BLOB exceeds size limit.

◆ RC_WARNING

int wxSQLite3::RC_WARNING = 28
constexpr

Warnings from sqlite3_log()

◆ RC_WARNING_AUTOINDEX

int wxSQLite3::RC_WARNING_AUTOINDEX = (RC_WARNING | (1 << 8))
constexpr

◆ TYPE_BLOB

int wxSQLite3::TYPE_BLOB = 4
constexpr

◆ TYPE_FLOAT

int wxSQLite3::TYPE_FLOAT = 2
constexpr

◆ TYPE_INTEGER

int wxSQLite3::TYPE_INTEGER = 1
constexpr

◆ TYPE_NULL

int wxSQLite3::TYPE_NULL = 5
constexpr

◆ TYPE_TEXT

int wxSQLite3::TYPE_TEXT = 3
constexpr

◆ WXSQLITE_ERROR

int wxSQLite3::WXSQLITE_ERROR = 1000
constexpr

Generic wxSQLite3 error.