|
wxSQLite3
5.0.1
|
Interface of the wxSQLite3 class. More...
#include <wx/arrstr.h>#include <wx/datetime.h>#include <wx/dynarray.h>#include <wx/buffer.h>#include <wx/hashmap.h>#include <wx/regex.h>#include <wx/string.h>#include "wx/wxsqlite3def.h"#include "wx/wxsqlite3_version.h"#include <array>#include <cstdint>#include <exception>#include <memory>#include <string>#include <tuple>#include <type_traits>#include <utility>#include <optional>Classes | |
| struct | is_optional< T > |
| struct | is_optional< std::optional< T > > |
| class | wxSQLite3::Exception |
| SQL exception. More... | |
| class | wxSQLite3::StatementBuffer |
| SQL statement buffer for use with SQLite3's printf method. More... | |
| class | wxSQLite3::Logger |
| SQLite logging hook. More... | |
| class | wxSQLite3::FunctionContext |
| Context for user defined scalar or aggregate functions. More... | |
| class | wxSQLite3::ScalarFunction |
| Interface for user defined scalar functions. More... | |
| class | wxSQLite3::AggregateFunction |
| Interface for user defined aggregate functions. More... | |
| class | wxSQLite3::WindowFunction |
| Interface for user defined aggregate window functions. More... | |
| class | wxSQLite3::Authorizer |
| Interface for a user defined authorizer function. More... | |
| class | wxSQLite3::Cipher |
| Cipher base class. More... | |
| class | wxSQLite3::CipherAes128 |
| Cipher class representing AES 128 bit encryption in CBC mode. More... | |
| class | wxSQLite3::CipherAes256 |
| Cipher class representing AES 256 bit encryption in CBC mode. More... | |
| class | wxSQLite3::CipherChaCha20 |
| Cipher class representing ChaCha20 encryption with Poly1305 HMAC. More... | |
| class | wxSQLite3::CipherSQLCipher |
| Cipher class representing SQLCipher encryption (AES 256 bit in CBC mode with SHA1 HMAC) More... | |
| class | wxSQLite3::CipherRC4 |
| Cipher class representing RC4 encryption (System.Data.SQLite) More... | |
| class | wxSQLite3::CipherAscon128 |
| Cipher class representing Ascon-128 encryption with Ascon tag. More... | |
| class | wxSQLite3::CipherAegis |
| Cipher class representing Aegis encryption with Ascon tag. More... | |
| class | wxSQLite3::Hook |
| Interface for a user defined hook function. More... | |
| class | wxSQLite3::BackupProgress |
| Interface for a user defined backup progress function. More... | |
| class | wxSQLite3::Collation |
| Interface for a user defined collation sequence. More... | |
| class | wxSQLite3::ResultSet |
| Result set of a SQL query. More... | |
| class | wxSQLite3::ResultSet::Iterator |
| Iterator API. More... | |
| class | wxSQLite3::Table |
| Holds the complete result set of a SQL query. More... | |
| class | wxSQLite3::Statement |
| Represents a prepared SQL statement. More... | |
| class | wxSQLite3::Blob |
| Represents a SQLite BLOB handle. More... | |
| class | wxSQLite3::NamedCollection |
| Represents a named collection. More... | |
| class | wxSQLite3::IntegerCollection |
| Represents a named integer value collection. More... | |
| class | wxSQLite3::StringCollection |
| Represents a named string value collection. More... | |
| class | wxSQLite3::Database |
| Represents a SQLite3 database object. More... | |
| class | wxSQLite3::Transaction |
| RAII class for managing transactions. More... | |
| class | wxSQLite3::RegExpOperator |
| User defined function for REGEXP operator. More... | |
Namespaces | |
| namespace | wxSQLite3 |
Macros | |
| #define | wxSQLITE3_VERSION_STRING wxS(WXSQLITE3_VERSION_STRING) |
| wxSQLite3 version string | |
Typedefs | |
| using | wxsqlite_int64 = long long int |
| using | wxSQLite3::DatabaseHandlePtr = std::shared_ptr<DatabaseHandle> |
| using | wxSQLite3::StatementHandlePtr = std::shared_ptr<StatementHandle> |
| using | wxSQLite3::BlobHandlePtr = std::shared_ptr<BlobHandle> |
Functions | |
| void | wxSQLite3::operator++ (LimitType &value) |
Variables | |
| template<typename T> | |
| constexpr bool | is_optional_v = is_optional<T>::value |
| constexpr int | wxSQLite3::WXSQLITE_ERROR = 1000 |
| Generic wxSQLite3 error. | |
| class WXDLLIMPEXP_FWD_SQLITE3 | wxSQLite3::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 | wxSQLite3::RC_OK = 0 |
| Successful result. | |
| constexpr int | wxSQLite3::RC_ERROR = 1 |
| Generic error. | |
| constexpr int | wxSQLite3::RC_INTERNAL = 2 |
| Internal logic error in SQLite. | |
| constexpr int | wxSQLite3::RC_PERM = 3 |
| Access permission denied. | |
| constexpr int | wxSQLite3::RC_ABORT = 4 |
| Callback routine requested an abort. | |
| constexpr int | wxSQLite3::RC_BUSY = 5 |
| The database file is locked. | |
| constexpr int | wxSQLite3::RC_LOCKED = 6 |
| A table in the database is locked. | |
| constexpr int | wxSQLite3::RC_NOMEM = 7 |
| A malloc() failed. | |
| constexpr int | wxSQLite3::RC_READONLY = 8 |
| Attempt to write a readonly database. | |
| constexpr int | wxSQLite3::RC_INTERRUPT = 9 |
| Operation terminated by sqlite3_interrupt() | |
| constexpr int | wxSQLite3::RC_IOERR = 10 |
| Some kind of disk I/O error occurred. | |
| constexpr int | wxSQLite3::RC_CORRUPT = 11 |
| The database disk image is malformed. | |
| constexpr int | wxSQLite3::RC_NOTFOUND = 12 |
| Unknown opcode in sqlite3_file_control() | |
| constexpr int | wxSQLite3::RC_FULL = 13 |
| Insertion failed because database is full. | |
| constexpr int | wxSQLite3::RC_CANTOPEN = 14 |
| Unable to open the database file. | |
| constexpr int | wxSQLite3::RC_PROTOCOL = 15 |
| Database lock protocol error. | |
| constexpr int | wxSQLite3::RC_EMPTY = 16 |
| Internal use only. | |
| constexpr int | wxSQLite3::RC_SCHEMA = 17 |
| The database schema changed. | |
| constexpr int | wxSQLite3::RC_TOOBIG = 18 |
| String or BLOB exceeds size limit. | |
| constexpr int | wxSQLite3::RC_CONSTRAINT = 19 |
| Abort due to constraint violation. | |
| constexpr int | wxSQLite3::RC_MISMATCH = 20 |
| Data type mismatch. | |
| constexpr int | wxSQLite3::RC_MISUSE = 21 |
| Library used incorrectly. | |
| constexpr int | wxSQLite3::RC_NOLFS = 22 |
| Uses OS features not supported on host. | |
| constexpr int | wxSQLite3::RC_AUTH = 23 |
| Authorization denied. | |
| constexpr int | wxSQLite3::RC_FORMAT = 24 |
| Not useD. | |
| constexpr int | wxSQLite3::RC_RANGE = 25 |
| 2nd parameter to sqlite3_bind out of range | |
| constexpr int | wxSQLite3::RC_NOTADB = 26 |
| File opened that is not a database file. | |
| constexpr int | wxSQLite3::RC_NOTICE = 27 |
| Notifications from sqlite3_log() | |
| constexpr int | wxSQLite3::RC_WARNING = 28 |
| Warnings from sqlite3_log() | |
| constexpr int | wxSQLite3::RC_ROW = 100 |
| sqlite3_step() has another row ready | |
| constexpr int | wxSQLite3::RC_DONE = 101 |
| sqlite3_step() has finished executing | |
Extended result codes | |
| constexpr int | wxSQLite3::RC_ERROR_MISSING_COLLSEQ = (RC_ERROR | (1 << 8)) |
| constexpr int | wxSQLite3::RC_ERROR_RETRY = (RC_ERROR | (2 << 8)) |
| constexpr int | wxSQLite3::RC_ERROR_SNAPSHOT = (RC_ERROR | (3 << 8)) |
| constexpr int | wxSQLite3::RC_ERROR_RESERVESIZE = (RC_ERROR | (4 << 8)) |
| constexpr int | wxSQLite3::RC_ERROR_KEY = (RC_ERROR | (5 << 8)) |
| constexpr int | wxSQLite3::RC_ERROR_UNABLE = (RC_ERROR | (6 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_READ = (RC_IOERR | (1 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_SHORT_READ = (RC_IOERR | (2 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_WRITE = (RC_IOERR | (3 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_FSYNC = (RC_IOERR | (4 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_DIR_FSYNC = (RC_IOERR | (5 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_TRUNCATE = (RC_IOERR | (6 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_FSTAT = (RC_IOERR | (7 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_UNLOCK = (RC_IOERR | (8 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_RDLOCK = (RC_IOERR | (9 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_DELETE = (RC_IOERR | (10 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_BLOCKED = (RC_IOERR | (11 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_NOMEM = (RC_IOERR | (12 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_ACCESS = (RC_IOERR | (13 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_CHECKRESERVEDLOCK = (RC_IOERR | (14 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_LOCK = (RC_IOERR | (15 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_CLOSE = (RC_IOERR | (16 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_DIR_CLOSE = (RC_IOERR | (17 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_SHMOPEN = (RC_IOERR | (18 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_SHMSIZE = (RC_IOERR | (19 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_SHMLOCK = (RC_IOERR | (20 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_SHMMAP = (RC_IOERR | (21 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_SEEK = (RC_IOERR | (22 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_DELETE_NOENT = (RC_IOERR | (23 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_MMAP = (RC_IOERR | (24 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_GETTEMPPATH = (RC_IOERR | (25 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_CONVPATH = (RC_IOERR | (26 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_VNODE = (RC_IOERR | (27 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_AUTH = (RC_IOERR | (28 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_BEGIN_ATOMIC = (RC_IOERR | (29 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_COMMIT_ATOMIC = (RC_IOERR | (30 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_ROLLBACK_ATOMIC = (RC_IOERR | (31 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_DATA = (RC_IOERR | (32 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_CORRUPTFS = (RC_IOERR | (33 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_IN_PAGE = (RC_IOERR | (34 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_BADKEY = (RC_IOERR | (35 << 8)) |
| constexpr int | wxSQLite3::RC_IOERR_CODEC = (RC_IOERR | (36 << 8)) |
| constexpr int | wxSQLite3::RC_LOCKED_SHAREDCACHE = (RC_LOCKED | (1 << 8)) |
| constexpr int | wxSQLite3::RC_LOCKED_VTAB = (RC_LOCKED | (2 << 8)) |
| constexpr int | wxSQLite3::RC_BUSY_RECOVERY = (RC_BUSY | (1 << 8)) |
| constexpr int | wxSQLite3::RC_BUSY_SNAPSHOT = (RC_BUSY | (2 << 8)) |
| constexpr int | wxSQLite3::RC_BUSY_TIMEOUT = (RC_BUSY | (3 << 8)) |
| constexpr int | wxSQLite3::RC_CANTOPEN_NOTEMPDIR = (RC_CANTOPEN | (1 << 8)) |
| constexpr int | wxSQLite3::RC_CANTOPEN_ISDIR = (RC_CANTOPEN | (2 << 8)) |
| constexpr int | wxSQLite3::RC_CANTOPEN_FULLPATH = (RC_CANTOPEN | (3 << 8)) |
| constexpr int | wxSQLite3::RC_CANTOPEN_CONVPATH = (RC_CANTOPEN | (4 << 8)) |
| constexpr int | wxSQLite3::RC_CANTOPEN_DIRTYWAL = (RC_CANTOPEN | (5 << 8)) |
| constexpr int | wxSQLite3::RC_CANTOPEN_SYMLINK = (RC_CANTOPEN | (6 << 8)) |
| constexpr int | wxSQLite3::RC_CORRUPT_VTAB = (RC_CORRUPT | (1 << 8)) |
| constexpr int | wxSQLite3::RC_CORRUPT_SEQUENCE = (RC_CORRUPT | (2 << 8)) |
| constexpr int | wxSQLite3::RC_CORRUPT_INDEX = (RC_CORRUPT | (3 << 8)) |
| constexpr int | wxSQLite3::RC_READONLY_RECOVERY = (RC_READONLY | (1 << 8)) |
| constexpr int | wxSQLite3::RC_READONLY_CANTLOCK = (RC_READONLY | (2 << 8)) |
| constexpr int | wxSQLite3::RC_READONLY_ROLLBACK = (RC_READONLY | (3 << 8)) |
| constexpr int | wxSQLite3::RC_READONLY_DBMOVED = (RC_READONLY | (4 << 8)) |
| constexpr int | wxSQLite3::RC_READONLY_CANTINIT = (RC_READONLY | (5 << 8)) |
| constexpr int | wxSQLite3::RC_READONLY_DIRECTORY = (RC_READONLY | (6 << 8)) |
| constexpr int | wxSQLite3::RC_ABORT_ROLLBACK = (RC_ABORT | (2 << 8)) |
| constexpr int | wxSQLite3::RC_CONSTRAINT_CHECK = (RC_CONSTRAINT | (1 << 8)) |
| constexpr int | wxSQLite3::RC_CONSTRAINT_COMMITHOOK = (RC_CONSTRAINT | (2 << 8)) |
| constexpr int | wxSQLite3::RC_CONSTRAINT_FOREIGNKEY = (RC_CONSTRAINT | (3 << 8)) |
| constexpr int | wxSQLite3::RC_CONSTRAINT_FUNCTION = (RC_CONSTRAINT | (4 << 8)) |
| constexpr int | wxSQLite3::RC_CONSTRAINT_NOTNULL = (RC_CONSTRAINT | (5 << 8)) |
| constexpr int | wxSQLite3::RC_CONSTRAINT_PRIMARYKEY = (RC_CONSTRAINT | (6 << 8)) |
| constexpr int | wxSQLite3::RC_CONSTRAINT_TRIGGER = (RC_CONSTRAINT | (7 << 8)) |
| constexpr int | wxSQLite3::RC_CONSTRAINT_UNIQUE = (RC_CONSTRAINT | (8 << 8)) |
| constexpr int | wxSQLite3::RC_CONSTRAINT_VTAB = (RC_CONSTRAINT | (9 << 8)) |
| constexpr int | wxSQLite3::RC_CONSTRAINT_ROWID = (RC_CONSTRAINT | (10 << 8)) |
| constexpr int | wxSQLite3::RC_CONSTRAINT_PINNED = (RC_CONSTRAINT | (11 << 8)) |
| constexpr int | wxSQLite3::RC_CONSTRAINT_DATATYPE = (RC_CONSTRAINT | (12 << 8)) |
| constexpr int | wxSQLite3::RC_NOTICE_RECOVER_WAL = (RC_NOTICE | (1 << 8)) |
| constexpr int | wxSQLite3::RC_NOTICE_RECOVER_ROLLBACK = (RC_NOTICE | (2 << 8)) |
| constexpr int | wxSQLite3::RC_NOTICE_RBU = (RC_NOTICE | (3 << 8)) |
| constexpr int | wxSQLite3::RC_WARNING_AUTOINDEX = (RC_WARNING | (1 << 8)) |
| constexpr int | wxSQLite3::RC_AUTH_USER = (RC_AUTH | (1 << 8)) |
| constexpr int | wxSQLite3::RC_OK_LOAD_PERMANENTLY = (RC_OK | (1 << 8)) |
| constexpr int | wxSQLite3::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 | wxSQLite3::TYPE_INTEGER = 1 |
| constexpr int | wxSQLite3::TYPE_FLOAT = 2 |
| constexpr int | wxSQLite3::TYPE_TEXT = 3 |
| constexpr int | wxSQLite3::TYPE_BLOB = 4 |
| constexpr int | wxSQLite3::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 | wxSQLite3::OPEN_READONLY = 0x00000001 |
| constexpr int | wxSQLite3::OPEN_READWRITE = 0x00000002 |
| constexpr int | wxSQLite3::OPEN_CREATE = 0x00000004 |
| constexpr int | wxSQLite3::OPEN_URI = 0x00000040 |
| constexpr int | wxSQLite3::OPEN_MEMORY = 0x00000080 |
| constexpr int | wxSQLite3::OPEN_NOMUTEX = 0x00008000 |
| constexpr int | wxSQLite3::OPEN_FULLMUTEX = 0x00010000 |
| constexpr int | wxSQLite3::OPEN_SHAREDCACHE = 0x00020000 |
| constexpr int | wxSQLite3::OPEN_PRIVATECACHE = 0x00040000 |
| constexpr int | wxSQLite3::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 | wxSQLite3::CHECKPOINT_PASSIVE = 0 |
| constexpr int | wxSQLite3::CHECKPOINT_FULL = 1 |
| constexpr int | wxSQLite3::CHECKPOINT_RESTART = 2 |
| constexpr int | wxSQLite3::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 | wxSQLite3::FUNC_DETERMINISTIC = 0x00000800 |
| constexpr int | wxSQLite3::FUNC_DIRECTONLY = 0x00080000 |
| constexpr int | wxSQLite3::FUNC_SUBTYPE = 0x00100000 |
| constexpr int | wxSQLite3::FUNC_INNOCUOUS = 0x00200000 |
| constexpr int | wxSQLite3::FUNC_RESULT_SUBTYPE = 0x01000000 |
| constexpr int | wxSQLite3::FUNC_SELFORDER1 = 0x02000000 |
Interface of the wxSQLite3 class.
| #define wxSQLITE3_VERSION_STRING wxS(WXSQLITE3_VERSION_STRING) |
wxSQLite3 version string
| using wxsqlite_int64 = long long int |
|
inlineconstexpr |