theSq3Lite 10.0
|
Sq3LiteC - the class known as sq3lite or Lite defined by Sq3LiteS … More...
Classes | |
struct | Sq3Call |
Public Member Functions | |
delegate void | Sq3LiteExecCCB (string[] vals, string[] cols) |
implements the cssq3lite API object: public version from LcConfigIncludeF as method | |
delegate void | Sq3LiteExecV2CCB (MkBufferListC vals, MkBufferListC cols) |
new Sq3LiteC | Next () |
C#: → C-API get next instance from linked-list of Sq3LiteS type | |
new Sq3LiteC | Prev () |
C#: → C-API get previous instance from linked-list of Sq3LiteS type | |
void | BusyTimeout (int ms) |
C#: → C-API Set A Busy Timeout … | |
void | DeclareVtab (string zSQL) |
C#: → C-API Declare The Schema Of A Virtual Table … | |
void | ExtendedResultCodes (int onoff) |
C#: → C-API Enable Or Disable Extended Result Codes … | |
void | Limit (Sq3LimitE id, int newVal) |
C#: → C-API Run-time Limits … | |
Sq3ErrorE | ErrCode () |
C#: → C-API Error Codes And Messages … | |
string | ErrMsg () |
C#: → C-API Error Codes And Messages … | |
void | ErrorOffset () |
C#: → C-API Error Codes And Messages … | |
Sq3ExtendetResultCodesE | ExtendetErrCode () |
C#: → C-API Error Codes And Messages … | |
void | SystemErrno () |
C#: → C-API Low-level system error code … | |
void | ExecV2 (string sql, Sq3LiteExecV2CCB callback=null) |
C#: → C-API The Sq3LiteExecV2() interface is a convenience wrapper around Sq3StmtPrepareV2(), Sq3StmtStep(), and Sq3StmtFinalize(), that allows an application to run multiple statements of SQL without having to use a lot of C code. | |
void | ExecV2 (string sql, Sq3LiteExecV2IF callback=null) |
C#: → C-API The Sq3LiteExecV2() interface is a convenience wrapper around Sq3StmtPrepareV2(), Sq3StmtStep(), and Sq3StmtFinalize(), that allows an application to run multiple statements of SQL without having to use a lot of C code. | |
void | Exec (string sql, Sq3LiteExecCCB callback_data=null) |
C#: → C-API One-Step Query Execution Interface … | |
void | Exec (string sql, Sq3LiteExecIF callback_data=null) |
C#: → C-API One-Step Query Execution Interface … | |
int | GetAutocommit () |
C#: → C-API Test For Auto-Commit Mode … | |
long | LastInsertRowid () |
C#: → C-API Last Insert Rowid … | |
void | TxnState (string zSchema) |
C#: → C-API Determine the transaction state of a database … | |
void | VtabOnConflict () |
C#: → C-API Determine The Virtual Table Conflict Policy … | |
MkBufferListC | DbStatusBFL (Sq3DbStatusE op, bool resetFlg) |
C#: → C-API Database Connection Status … | |
void | DbCacheflush () |
C#: → C-API Flush caches to disk mid-transaction … | |
string | DbFilename (string zDbName) |
C#: → C-API Return The Filename For A Database Connection … | |
string | DbName (int N) |
C#: → C-API Return The Schema Name For A Database Connection … | |
void | DbReadonly (string zDbName) |
C#: → C-API Determine if a database is read-only … | |
void | DbReleaseMemory () |
C#: → C-API Free Memory Used By A Database Connection … | |
void | Deserialize (string zSchema, byte[] pData, Sq3DeSerializeEF mFlags) |
C#: → C-API Deserialize a database … | |
void | DropModules (MkBufferListC azKeepBfl) |
C#: → C-API Remove Unnecessary Virtual Table Implementations … | |
void | OverloadFunction (string zFuncName, int nArg) |
C#: → C-API Overload A Function For A Virtual Table … | |
byte[] | Serialize (string zSchema, Sq3SerializeE mFlags) |
C#: → C-API Serialize a database … | |
List< object > | DbStatus (Sq3DbStatusE op, bool resetFlg) |
C#: → C-API Database Connection Status … | |
List< object > | TableColumnMetadata (string zDbName, string zTableName, string zColumnName) |
C#: → C-API Extract Metadata About A Column Of A Table … | |
void | WalAutocheckpoint (int N) |
C#: → C-API Configure an auto-checkpoint … | |
List< object > | WalCheckpointV2 (string zDb, int eMode) |
C#: → C-API Checkpoint a database … | |
void | Interrupt () |
C#: → C-API Interrupt A Long-Running Query … | |
bool | IsInterrupted () |
C#: → C-API Interrupt A Long-Running Query … | |
int | Changes () |
C#: → C-API Count The Number Of Rows Modified … | |
long | Changes64 () |
C#: → C-API Count The Number Of Rows Modified … | |
void | SetLastInsertRowid (long arg1) |
C#: → C-API Set the Last Insert Rowid value … | |
int | TotalChanges () |
C#: → C-API Total Number Of Rows Modified … | |
long | TotalChanges64 () |
C#: → C-API Total Number Of Rows Modified … | |
Sq3LiteC (string filename, Sq3OpenEF flags=Sq3OpenEF.READWRITE|Sq3OpenEF.CREATE, string zVfs=null) | |
CONSTRUCTOR. | |
Sq3StmtC | PrepareV2 (string zSql) |
C#: → C-API Compiling An SQL Statement … | |
void | CloseV2 () |
C#: → C-API Closing A Database Connection … | |
![]() | |
delegate void | MkObjectDeleteSCB (string typeName, int typeHdl, int objHdl) |
void | ErrorCheck (MkErrorE err) |
bool | Check () |
string | ToNameOfClass () |
void | HandleDelete () |
bool | HandleExists () |
Int32 | HandleGet () |
Int32 | HandleGetOfType () |
Int32 | HandleGetOr0 () |
MkObjectC | Next () |
MkObjectC | Prev () |
void | DbgDump (string message="var",[CallerMemberName]string callfunc=null) |
void | DbgL (string message, int debug=0,[CallerMemberName]string callfunc=null, int lvl=0) |
void | DbgLogC ([CallerMemberName]string callfunc=null) |
void | DbgO ([CallerMemberName]string callfunc=null) |
void | DbgSTACK (int skip=0, int num=-1,[CallerMemberName]string callfunc=null) |
void | LogC (string message, int debug=0,[CallerMemberName]string callfunc=null) |
void | LogHEX (string callfunc, byte[] data) |
void | Log (MkObjectC fmtobj=null, int debug=0,[CallerMemberName]string callfunc=null, int lvl=0) |
void | LogLong (MkObjectC fmtobj=null, int debug=0,[CallerMemberName]string callfunc=null, int lvl=0) |
void | LogShort (MkObjectC fmtobj=null, int debug=0,[CallerMemberName]string callfunc=null, int lvl=0) |
void | LogType (MkObjectC fmtobj=null, int debug=0,[CallerMemberName]string callfunc=null, int lvl=0) |
MkErrorC | ErrorCatch (Exception exception=null,[CallerMemberName]string callfunc=null) |
MkErrorC | ToError () |
bool | IsNull () |
string | ToName () |
string | ToNameOfType () |
override string | ToString () |
int | RefGet () |
void | SysKill (int pid, int signal) |
int | SysGetPid () |
void | Dispose () |
void | Delete () |
Static Public Member Functions | |
static Sq3LiteC | Sq3LiteC_ObjNew (IntPtr hdl) |
new static Sq3LiteC | HandleResolve (Int32 netHdl) |
C#: → C-API Handle-Resolve-Slot - return a Sq3LiteC from netHdl or null if invalid… | |
new static Sq3LiteC | Instances () |
C#: → C-API get head-instance from linked-list of Sq3LiteS type … | |
new static Sq3LiteC | GetNull () |
C#: → C-API Null-Slot - return a Sq3LiteC typed NULL instance … | |
static string | ErrStr (int arg0) |
C#: → C-API Error Codes And Messages … | |
static void | Sleep (int arg0) |
C#: → C-API Suspend Execution For A Short Time … | |
static Sq3LiteC | OpenV2 (string filename, Sq3OpenEF flags=Sq3OpenEF.READWRITE|Sq3OpenEF.CREATE, string zVfs=null) |
C#: → C-API Opening A New Database Connection … | |
![]() | |
static MkObjectC | MkObjectC_ObjNew (IntPtr hdl) |
static IntPtr | getOBJ (string cls, MkObjectC obj) |
static IntPtr | getOBJ_null_allow (MkObjectC obj) |
static MkObjectC | HandleResolve (Int32 netHdl) |
static void | HandleDeleteByNetHdl (Int32 netHdl) |
static MkObjectC | Instances () |
static MkObjectC | GetNull () |
static void | DbgM (string message, int debug=0,[CallerMemberName]string callfunc=null, int lvl=0) |
static int | SysHashI32 (string key, int length=-1) |
static string | SysHashSTR (string key, int length=-1) |
static void | DeleteCallbackCleanup (string ident) |
static void | DeleteCallbackSetup (string ident, MkObjectDeleteSCB callback=null, string filter=null) |
static int | getPId () |
static int | getTId () |
static string | getStackTrace (int level=2) |
static string | getCallerProc (int level=2) |
static int | getCallerLine (int level=2) |
static string | getCallerFile (int level=2) |
Static Protected Member Functions | |
static IntPtr | CTOR (string filename, Sq3OpenEF flags=Sq3OpenEF.READWRITE|Sq3OpenEF.CREATE, string zVfs=null) |
C#: → C-API Opening A New Database Connection … | |
![]() | |
static object | atomObjNew (Type type, ConstructorInfo ctor, IntPtr obj) |
static object | atomObjCreate (Type type, ConstructorInfo ctor, IntPtr obj) |
static IntPtr | atomSelfCreate (ConstructorInfo ctor, IntPtr obj, IntPtr env) |
static object | atomSelfNull (ConstructorInfo ctor) |
static void | atomSelfUnlink (IntPtr self, IntPtr env) |
static ConstructorInfo | getCtor (Type type) |
static string | Name (IntPtr mkrt, IntPtr obj) |
Additional Inherited Members | |
![]() | |
MkObjectC (IntPtr obj) | |
MkObjectC () | |
virtual void | Dispose (bool disposing) |
![]() | |
IntPtr | pmkrt |
![]() | |
IntPtr | hdl |
IntPtr | hdl_null_allow |
IntPtr | mkrt |
Sq3LiteC - the class known as sq3lite or Lite defined by Sq3LiteS …
Struct to represent the data of the Sq3LiteC …
Database Connection Handle …
Each open SQLite database is represented by a pointer to an instance of the opaque structure named "sqlite3". It is useful to think of an Sq3LiteC pointer as an object. The sqlite3_open (), sqlite3_open16 (), and Sq3LiteOpenV2 () interfaces are its constructors, and sqlite3_close () and Sq3LiteCloseV2 () are its destructors. There are many other interfaces (such as Sq3StmtPrepareV2 (), sqlite3_create_function (), and Sq3LiteBusyTimeout () to name but three) that are methods on an Sq3LiteC object.
Reference code from sqlite3:
Definition at line 570 of file Sq3LiteC_cs.cs.
|
inlinestatic |
Definition at line 38 of file Sq3LiteC_cs.cs.
delegate void cssq3lite.Sq3LiteC.Sq3LiteExecCCB | ( | string[] | vals, |
string[] | cols ) |
implements the cssq3lite API object: public version from LcConfigIncludeF as method
delegate void cssq3lite.Sq3LiteC.Sq3LiteExecV2CCB | ( | MkBufferListC | vals, |
MkBufferListC | cols ) |