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"

Classes
class	wxSQLite3Exception
	SQL exception. More...

class	wxSQLite3StatementBuffer
	SQL statement buffer for use with SQLite3's printf method. More...

class	wxSQLite3Logger
	SQLite logging hook. More...

class	wxSQLite3FunctionContext
	Context for user defined scalar or aggregate functions. More...

class	wxSQLite3ScalarFunction
	Interface for user defined scalar functions. More...

class	wxSQLite3AggregateFunction
	Interface for user defined aggregate functions. More...

class	wxSQLite3WindowFunction
	Interface for user defined aggregate window functions. More...

class	wxSQLite3Authorizer
	Interface for a user defined authorizer function. More...

class	wxSQLite3Cipher
	Cipher base class. More...

class	wxSQLite3CipherAes128
	Cipher class representing AES 128 bit encryption in CBC mode. More...

class	wxSQLite3CipherAes256
	Cipher class representing AES 256 bit encryption in CBC mode. More...

class	wxSQLite3CipherChaCha20
	Cipher class representing ChaCha20 encryption with Poly1305 HMAC. More...

class	wxSQLite3CipherSQLCipher
	Cipher class representing SQLCipher encryption (AES 256 bit in CBC mode with SHA1 HMAC) More...

class	wxSQLite3CipherRC4
	Cipher class representing RC4 encryption (System.Data.SQLite) More...

class	wxSQLite3CipherAscon128
	Cipher class representing Ascon-128 encryption with Ascon tag. More...

class	wxSQLite3CipherAegis
	Cipher class representing Aegis encryption with Ascon tag. More...

class	wxSQLite3Hook
	Interface for a user defined hook function. More...

class	wxSQLite3BackupProgress
	Interface for a user defined backup progress function. More...

class	wxSQLite3Collation
	Interface for a user defined collation sequence. More...

class	wxSQLite3ResultSet
	Result set of a SQL query. More...

class	wxSQLite3Table
	Holds the complete result set of a SQL query. More...

class	wxSQLite3Statement
	Represents a prepared SQL statement. More...

class	wxSQLite3Blob
	Represents a SQLite BLOB handle. More...

class	wxSQLite3NamedCollection
	Represents a named collection. More...

class	wxSQLite3IntegerCollection
	Represents a named integer value collection. More...

class	wxSQLite3StringCollection
	Represents a named string value collection. More...

class	wxSQLite3Database
	Represents a SQLite3 database object. More...

class	wxSQLite3Transaction
	RAII class for managing transactions. More...

class	wxSQLite3RegExpOperator
	User defined function for REGEXP operator. More...

Macros
#define	wxSQLITE3_VERSION_STRING wxS(WXSQLITE3_VERSION_STRING)
	wxSQLite3 version string

#define	WXSQLITE_ERROR 1000

#define	WXSQLITE_INTEGER 1

#define	WXSQLITE_FLOAT 2

#define	WXSQLITE_TEXT 3

#define	WXSQLITE_BLOB 4

#define	WXSQLITE_NULL 5

#define	WXSQLITE_OPEN_READONLY 0x00000001

#define	WXSQLITE_OPEN_READWRITE 0x00000002

#define	WXSQLITE_OPEN_CREATE 0x00000004

#define	WXSQLITE_OPEN_URI 0x00000040

#define	WXSQLITE_OPEN_MEMORY 0x00000080

#define	WXSQLITE_OPEN_NOMUTEX 0x00008000

#define	WXSQLITE_OPEN_FULLMUTEX 0x00010000

#define	WXSQLITE_OPEN_SHAREDCACHE 0x00020000

#define	WXSQLITE_OPEN_PRIVATECACHE 0x00040000

#define	WXSQLITE_OPEN_NOFOLLOW 0x01000000

#define	WXSQLITE_CHECKPOINT_PASSIVE 0

#define	WXSQLITE_CHECKPOINT_FULL 1

#define	WXSQLITE_CHECKPOINT_RESTART 2

#define	WXSQLITE_CHECKPOINT_TRUNCATE 3

#define	WXSQLITE_DETERMINISTIC 0x000000800

#define	WXSQLITE_DIRECTONLY 0x000080000

#define	WXSQLITE_SUBTYPE 0x000100000

#define	WXSQLITE_INNOCUOUS 0x000200000

#define	WXSQLITE_RESULT_SUBTYPE 0x001000000

Typedefs
typedef long long int	wxsqlite_int64

Enumerations
enum	wxSQLite3CipherType { WXSQLITE_CIPHER_UNKNOWN , WXSQLITE_CIPHER_AES128 , WXSQLITE_CIPHER_AES256 , WXSQLITE_CIPHER_CHACHA20 , WXSQLITE_CIPHER_SQLCIPHER , WXSQLITE_CIPHER_RC4 , WXSQLITE_CIPHER_ASCON128 , WXSQLITE_CIPHER_AEGIS }
	Enumeration of supported cipher types. More...

enum	wxSQLite3TransactionType { WXSQLITE_TRANSACTION_DEFAULT , WXSQLITE_TRANSACTION_DEFERRED , WXSQLITE_TRANSACTION_IMMEDIATE , WXSQLITE_TRANSACTION_EXCLUSIVE }
	Enumeration of transaction types. More...

enum	wxSQLite3TransactionState { WXSQLITE_TRANSACTION_INVALID , WXSQLITE_TRANSACTION_NONE , WXSQLITE_TRANSACTION_READ , WXSQLITE_TRANSACTION_WRITE }
	Enumeration of transaction state. More...

enum	wxSQLite3LimitType { WXSQLITE_LIMIT_LENGTH = 0 , WXSQLITE_LIMIT_SQL_LENGTH = 1 , WXSQLITE_LIMIT_COLUMN = 2 , WXSQLITE_LIMIT_EXPR_DEPTH = 3 , WXSQLITE_LIMIT_COMPOUND_SELECT = 4 , WXSQLITE_LIMIT_VDBE_OP = 5 , WXSQLITE_LIMIT_FUNCTION_ARG = 6 , WXSQLITE_LIMIT_ATTACHED = 7 , WXSQLITE_LIMIT_LIKE_PATTERN_LENGTH = 8 , WXSQLITE_LIMIT_VARIABLE_NUMBER = 9 , WXSQLITE_LIMIT_TRIGGER_DEPTH = 10 , WXSQLITE_LIMIT_WORKER_THREADS = 11 }
	Enumeration of SQLite limitation types. More...

enum	wxSQLite3JournalMode { WXSQLITE_JOURNALMODE_DELETE = 0 , WXSQLITE_JOURNALMODE_PERSIST = 1 , WXSQLITE_JOURNALMODE_OFF = 2 , WXSQLITE_JOURNALMODE_TRUNCATE = 3 , WXSQLITE_JOURNALMODE_MEMORY = 4 , WXSQLITE_JOURNALMODE_WAL = 5 }
	Enumeration of journal modes. More...

enum	wxSQLite3StatementStatus { WXSQLITE_STMTSTATUS_FULLSCAN_STEP = 1 , WXSQLITE_STMTSTATUS_SORT = 2 , WXSQLITE_STMTSTATUS_AUTOINDEX = 3 , WXSQLITE_STMTSTATUS_VM_STEP = 4 , WXSQLITE_STMTSTATUS_REPREPARE = 5 , WXSQLITE_STMTSTATUS_RUN = 6 , WXSQLITE_STMTSTATUS_MEMUSED = 99 }
	Enumeration of statement status counters. More...

enum	wxSQLite3DbConfig { WXSQLITE_DBCONFIG_ENABLE_FKEY = 1002 , WXSQLITE_DBCONFIG_ENABLE_TRIGGER = 1003 , WXSQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER = 1004 , WXSQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION = 1005 , WXSQLITE_DBCONFIG_NO_CKPT_ON_CLOSE = 1006 , WXSQLITE_DBCONFIG_ENABLE_QPSG = 1007 , WXSQLITE_DBCONFIG_TRIGGER_EQP = 1008 , WXSQLITE_DBCONFIG_RESET_DATABASE = 1009 , WXSQLITE_DBCONFIG_DEFENSIVE = 1010 , WXSQLITE_DBCONFIG_WRITABLE_SCHEMA = 1011 , WXSQLITE_DBCONFIG_LEGACY_ALTER_TABLE = 1012 , WXSQLITE_DBCONFIG_DQS_DML = 1013 , WXSQLITE_DBCONFIG_DQS_DDL = 1014 , WXSQLITE_DBCONFIG_ENABLE_VIEW = 1015 , WXSQLITE_DBCONFIG_LEGACY_FILE_FORMAT = 1016 , WXSQLITE_DBCONFIG_TRUSTED_SCHEMA = 1017 , WXSQLITE_DBCONFIG_STMT_SCANSTATUS = 1018 , WXSQLITE_DBCONFIG_REVERSE_SCANORDER = 1019 , WXSQLITE_DBCONFIG_ENABLE_ATTACH_CREATE = 1020 , WXSQLITE_DBCONFIG_ENABLE_ATTACH_WRITE = 1021 , WXSQLITE_DBCONFIG_ENABLE_COMMENTS = 1022 }
	Enumeration of statement status counters. More...

Functions
void	operator++ (wxSQLite3LimitType &value)

Variables
class WXDLLIMPEXP_FWD_SQLITE3	wxSQLite3Database

Detailed Description

Interface of the wxSQLite3 class.

Macro Definition Documentation

◆ wxSQLITE3_VERSION_STRING

#define wxSQLITE3_VERSION_STRING wxS(WXSQLITE3_VERSION_STRING)

wxSQLite3 version string

◆ WXSQLITE_BLOB

#define WXSQLITE_BLOB 4

◆ WXSQLITE_CHECKPOINT_FULL

#define WXSQLITE_CHECKPOINT_FULL 1

◆ WXSQLITE_CHECKPOINT_PASSIVE

#define WXSQLITE_CHECKPOINT_PASSIVE 0

◆ WXSQLITE_CHECKPOINT_RESTART

#define WXSQLITE_CHECKPOINT_RESTART 2

◆ WXSQLITE_CHECKPOINT_TRUNCATE

#define WXSQLITE_CHECKPOINT_TRUNCATE 3

◆ WXSQLITE_DETERMINISTIC

#define WXSQLITE_DETERMINISTIC 0x000000800

◆ WXSQLITE_DIRECTONLY

#define WXSQLITE_DIRECTONLY 0x000080000

◆ WXSQLITE_ERROR

#define WXSQLITE_ERROR 1000

◆ WXSQLITE_FLOAT

#define WXSQLITE_FLOAT 2

◆ WXSQLITE_INNOCUOUS

#define WXSQLITE_INNOCUOUS 0x000200000

◆ WXSQLITE_INTEGER

#define WXSQLITE_INTEGER 1

◆ WXSQLITE_NULL

#define WXSQLITE_NULL 5

◆ WXSQLITE_OPEN_CREATE

#define WXSQLITE_OPEN_CREATE 0x00000004

◆ WXSQLITE_OPEN_FULLMUTEX

#define WXSQLITE_OPEN_FULLMUTEX 0x00010000

◆ WXSQLITE_OPEN_MEMORY

#define WXSQLITE_OPEN_MEMORY 0x00000080

◆ WXSQLITE_OPEN_NOFOLLOW

#define WXSQLITE_OPEN_NOFOLLOW 0x01000000

◆ WXSQLITE_OPEN_NOMUTEX

#define WXSQLITE_OPEN_NOMUTEX 0x00008000

◆ WXSQLITE_OPEN_PRIVATECACHE

#define WXSQLITE_OPEN_PRIVATECACHE 0x00040000

◆ WXSQLITE_OPEN_READONLY

#define WXSQLITE_OPEN_READONLY 0x00000001

◆ WXSQLITE_OPEN_READWRITE

#define WXSQLITE_OPEN_READWRITE 0x00000002

◆ WXSQLITE_OPEN_SHAREDCACHE

#define WXSQLITE_OPEN_SHAREDCACHE 0x00020000

◆ WXSQLITE_OPEN_URI

#define WXSQLITE_OPEN_URI 0x00000040

◆ WXSQLITE_RESULT_SUBTYPE

#define WXSQLITE_RESULT_SUBTYPE 0x001000000

◆ WXSQLITE_SUBTYPE

#define WXSQLITE_SUBTYPE 0x000100000

◆ WXSQLITE_TEXT

#define WXSQLITE_TEXT 3

Typedef Documentation

◆ wxsqlite_int64

typedef long long int wxsqlite_int64

Enumeration Type Documentation

◆ wxSQLite3CipherType

enum wxSQLite3CipherType

Enumeration of supported cipher types.

Enumerator
WXSQLITE_CIPHER_UNKNOWN
WXSQLITE_CIPHER_AES128
WXSQLITE_CIPHER_AES256
WXSQLITE_CIPHER_CHACHA20
WXSQLITE_CIPHER_SQLCIPHER
WXSQLITE_CIPHER_RC4
WXSQLITE_CIPHER_ASCON128
WXSQLITE_CIPHER_AEGIS

◆ wxSQLite3DbConfig

enum wxSQLite3DbConfig

Enumeration of statement status counters.

Enumerator
WXSQLITE_DBCONFIG_ENABLE_FKEY
WXSQLITE_DBCONFIG_ENABLE_TRIGGER
WXSQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
WXSQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION
WXSQLITE_DBCONFIG_NO_CKPT_ON_CLOSE
WXSQLITE_DBCONFIG_ENABLE_QPSG
WXSQLITE_DBCONFIG_TRIGGER_EQP
WXSQLITE_DBCONFIG_RESET_DATABASE
WXSQLITE_DBCONFIG_DEFENSIVE
WXSQLITE_DBCONFIG_WRITABLE_SCHEMA
WXSQLITE_DBCONFIG_LEGACY_ALTER_TABLE
WXSQLITE_DBCONFIG_DQS_DML
WXSQLITE_DBCONFIG_DQS_DDL
WXSQLITE_DBCONFIG_ENABLE_VIEW
WXSQLITE_DBCONFIG_LEGACY_FILE_FORMAT
WXSQLITE_DBCONFIG_TRUSTED_SCHEMA
WXSQLITE_DBCONFIG_STMT_SCANSTATUS
WXSQLITE_DBCONFIG_REVERSE_SCANORDER
WXSQLITE_DBCONFIG_ENABLE_ATTACH_CREATE
WXSQLITE_DBCONFIG_ENABLE_ATTACH_WRITE
WXSQLITE_DBCONFIG_ENABLE_COMMENTS

◆ wxSQLite3JournalMode

enum wxSQLite3JournalMode

Enumeration of journal modes.

Enumerator
WXSQLITE_JOURNALMODE_DELETE
WXSQLITE_JOURNALMODE_PERSIST
WXSQLITE_JOURNALMODE_OFF
WXSQLITE_JOURNALMODE_TRUNCATE
WXSQLITE_JOURNALMODE_MEMORY
WXSQLITE_JOURNALMODE_WAL

◆ wxSQLite3LimitType

enum wxSQLite3LimitType

Enumeration of SQLite limitation types.

Enumerator
WXSQLITE_LIMIT_LENGTH
WXSQLITE_LIMIT_SQL_LENGTH
WXSQLITE_LIMIT_COLUMN
WXSQLITE_LIMIT_EXPR_DEPTH
WXSQLITE_LIMIT_COMPOUND_SELECT
WXSQLITE_LIMIT_VDBE_OP
WXSQLITE_LIMIT_FUNCTION_ARG
WXSQLITE_LIMIT_ATTACHED
WXSQLITE_LIMIT_LIKE_PATTERN_LENGTH
WXSQLITE_LIMIT_VARIABLE_NUMBER
WXSQLITE_LIMIT_TRIGGER_DEPTH
WXSQLITE_LIMIT_WORKER_THREADS

◆ wxSQLite3StatementStatus

enum wxSQLite3StatementStatus

Enumeration of statement status counters.

Enumerator
WXSQLITE_STMTSTATUS_FULLSCAN_STEP
WXSQLITE_STMTSTATUS_SORT
WXSQLITE_STMTSTATUS_AUTOINDEX
WXSQLITE_STMTSTATUS_VM_STEP
WXSQLITE_STMTSTATUS_REPREPARE
WXSQLITE_STMTSTATUS_RUN
WXSQLITE_STMTSTATUS_MEMUSED

◆ wxSQLite3TransactionState

enum wxSQLite3TransactionState

Enumeration of transaction state.

Enumerator
WXSQLITE_TRANSACTION_INVALID
WXSQLITE_TRANSACTION_NONE
WXSQLITE_TRANSACTION_READ
WXSQLITE_TRANSACTION_WRITE

◆ wxSQLite3TransactionType

enum wxSQLite3TransactionType

Enumeration of transaction types.

Enumerator
WXSQLITE_TRANSACTION_DEFAULT
WXSQLITE_TRANSACTION_DEFERRED
WXSQLITE_TRANSACTION_IMMEDIATE
WXSQLITE_TRANSACTION_EXCLUSIVE

Function Documentation

◆ operator++()

void operator++ ( wxSQLite3LimitType & value )

inline

Variable Documentation

◆ wxSQLite3Database

class WXDLLIMPEXP_FWD_SQLITE3 wxSQLite3Database

Classes

Macros

Typedefs

Enumerations

Functions

Variables