|
wxSQLite3
5.0.1
|
Classes | |
| class | Exception |
| SQL exception. More... | |
| class | StatementBuffer |
| SQL statement buffer for use with SQLite3's printf method. More... | |
| class | Logger |
| SQLite logging hook. More... | |
| class | FunctionContext |
| Context for user defined scalar or aggregate functions. More... | |
| class | ScalarFunction |
| Interface for user defined scalar functions. More... | |
| class | AggregateFunction |
| Interface for user defined aggregate functions. More... | |
| class | WindowFunction |
| Interface for user defined aggregate window functions. More... | |
| class | Authorizer |
| Interface for a user defined authorizer function. More... | |
| class | Cipher |
| Cipher base class. 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 | CipherChaCha20 |
| Cipher class representing ChaCha20 encryption with Poly1305 HMAC. More... | |
| class | CipherSQLCipher |
| Cipher class representing SQLCipher encryption (AES 256 bit in CBC mode with SHA1 HMAC). More... | |
| class | CipherRC4 |
| Cipher class representing RC4 encryption (System.Data.SQLite). More... | |
| class | CipherAscon128 |
| Cipher class representing Ascon-128 encryption with Ascon tag. More... | |
| class | CipherAegis |
| Cipher class representing Aegis encryption with Ascon tag. More... | |
| class | Hook |
| Interface for a user defined hook function. More... | |
| class | BackupProgress |
| Interface for a user defined backup progress function. More... | |
| class | Collation |
| Interface for a user defined collation sequence. More... | |
| class | ResultSet |
| Result set of a SQL query. More... | |
| class | Table |
| Holds the complete result set of a SQL query. More... | |
| class | Statement |
| Represents a prepared SQL statement. More... | |
| class | Blob |
| Represents a SQLite BLOB handle. More... | |
| class | NamedCollection |
| Represents a named collection. More... | |
| class | IntegerCollection |
| Represents a named integer value collection. More... | |
| class | StringCollection |
| Represents a named string value collection. More... | |
| class | Database |
| Represents a SQLite3 database object. More... | |
| class | Transaction |
| RAII class for managing transactions. More... | |
| class | RegExpOperator |
| User defined function for REGEXP operator. More... | |
Typedefs | |
| using | DatabaseHandlePtr = std::shared_ptr<DatabaseHandle> |
| using | StatementHandlePtr = std::shared_ptr<StatementHandle> |
| using | BlobHandlePtr = std::shared_ptr<BlobHandle> |
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 |
| using wxSQLite3::BlobHandlePtr = std::shared_ptr<BlobHandle> |
| using wxSQLite3::DatabaseHandlePtr = std::shared_ptr<DatabaseHandle> |
| using wxSQLite3::StatementHandlePtr = std::shared_ptr<StatementHandle> |
|
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.
|
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 |
|
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.
|
strong |
Enumeration of journal modes.
|
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.
|
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.
|
strong |
|
strong |
|
inline |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
| class WXDLLIMPEXP_FWD_SQLITE3 wxSQLite3::Database |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
Callback routine requested an abort.
|
constexpr |
|
constexpr |
Authorization denied.
|
constexpr |
|
constexpr |
The database file is locked.
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
Unable to open the database file.
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
Abort due to constraint violation.
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
The database disk image is malformed.
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
sqlite3_step() has finished executing
|
constexpr |
Internal use only.
|
constexpr |
Generic error.
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
Not useD.
|
constexpr |
Insertion failed because database is full.
|
constexpr |
Internal logic error in SQLite.
|
constexpr |
Operation terminated by sqlite3_interrupt().
|
constexpr |
Some kind of disk I/O error occurred.
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
A table in the database is locked.
|
constexpr |
|
constexpr |
|
constexpr |
Data type mismatch.
|
constexpr |
Library used incorrectly.
|
constexpr |
Uses OS features not supported on host.
|
constexpr |
A malloc() failed.
|
constexpr |
File opened that is not a database file.
|
constexpr |
Unknown opcode in sqlite3_file_control().
|
constexpr |
Notifications from sqlite3_log().
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
Successful result.
|
constexpr |
|
constexpr |
|
constexpr |
Access permission denied.
|
constexpr |
Database lock protocol error.
|
constexpr |
2nd parameter to sqlite3_bind out of range
|
constexpr |
Attempt to write a readonly database.
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
sqlite3_step() has another row ready
|
constexpr |
The database schema changed.
|
constexpr |
String or BLOB exceeds size limit.
|
constexpr |
Warnings from sqlite3_log().
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
|
constexpr |
Generic wxSQLite3 error.