theSq3Lite 10.0
Loading...
Searching...
No Matches
cssq3lite.Sq3LiteC Class Reference

Sq3LiteC - the class known as sq3lite or Lite defined by Sq3LiteSMore...

+ Inheritance diagram for cssq3lite.Sq3LiteC:
+ Collaboration diagram for cssq3lite.Sq3LiteC:

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#: Sq3LiteC lite.Next() C-API
get next instance from linked-list of Sq3LiteS type
 
new Sq3LiteC Prev ()
  C#: Sq3LiteC lite.Prev() C-API
get previous instance from linked-list of Sq3LiteS type
 
void BusyTimeout (int ms)
  C#: sq3lite.BusyTimeout(int ms) C-API
Set A Busy Timeout …
 
void DeclareVtab (string zSQL)
  C#: sq3lite.DeclareVtab(string zSQL) C-API
Declare The Schema Of A Virtual Table …
 
void ExtendedResultCodes (int onoff)
  C#: sq3lite.ExtendedResultCodes(int onoff) C-API
Enable Or Disable Extended Result Codes …
 
void Limit (Sq3LimitE id, int newVal)
  C#: sq3lite.Limit(Sq3LimitE id, int newVal) C-API
Run-time Limits …
 
Sq3ErrorE ErrCode ()
  C#: Sq3ErrorE db.ErrCode() C-API
Error Codes And Messages …
 
string ErrMsg ()
  C#: string sq3lite.ErrMsg() C-API
Error Codes And Messages …
 
void ErrorOffset ()
  C#: db.ErrorOffset() C-API
Error Codes And Messages …
 
Sq3ExtendetResultCodesE ExtendetErrCode ()
  C#: Sq3ExtendetResultCodesE db.ExtendetErrCode() C-API
Error Codes And Messages …
 
void SystemErrno ()
  C#: sq3lite.SystemErrno() C-API
Low-level system error code …
 
void ExecV2 (string sql, Sq3LiteExecV2CCB callback=null)
  C#: sq3lite.ExecV2(string sql, Sq3LiteExecV2CCB|Sq3LiteExecV2IF callback = null) 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#: sq3lite.ExecV2(string sql, Sq3LiteExecV2CCB|Sq3LiteExecV2IF callback = null) 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#: sq3lite.Exec(string sql, Sq3LiteExecCCB|Sq3LiteExecIF callback_data = null) C-API
One-Step Query Execution Interface …
 
void Exec (string sql, Sq3LiteExecIF callback_data=null)
  C#: sq3lite.Exec(string sql, Sq3LiteExecCCB|Sq3LiteExecIF callback_data = null) C-API
One-Step Query Execution Interface …
 
int GetAutocommit ()
  C#: int sq3lite.GetAutocommit() C-API
Test For Auto-Commit Mode …
 
long LastInsertRowid ()
  C#: long sq3lite.LastInsertRowid() C-API
Last Insert Rowid …
 
void TxnState (string zSchema)
  C#: sq3lite.TxnState(string zSchema) C-API
Determine the transaction state of a database …
 
void VtabOnConflict ()
  C#: sq3lite.VtabOnConflict() C-API
Determine The Virtual Table Conflict Policy …
 
MkBufferListC DbStatusBFL (Sq3DbStatusE op, bool resetFlg)
  C#: MkBufferListC sq3lite.DbStatusBFL(Sq3DbStatusE op, bool resetFlg) C-API
Database Connection Status …
 
void DbCacheflush ()
  C#: sq3lite.DbCacheflush() C-API
Flush caches to disk mid-transaction …
 
string DbFilename (string zDbName)
  C#: string db.DbFilename(string zDbName) C-API
Return The Filename For A Database Connection …
 
string DbName (int N)
  C#: string db.DbName(int N) C-API
Return The Schema Name For A Database Connection …
 
void DbReadonly (string zDbName)
  C#: db.DbReadonly(string zDbName) C-API
Determine if a database is read-only …
 
void DbReleaseMemory ()
  C#: sq3lite.DbReleaseMemory() C-API
Free Memory Used By A Database Connection …
 
void Deserialize (string zSchema, byte[] pData, Sq3DeSerializeEF mFlags)
  C#: sq3lite.Deserialize(string zSchema, byte[] pData, Sq3DeSerializeEF mFlags) C-API
Deserialize a database …
 
void DropModules (MkBufferListC azKeepBfl)
  C#: sq3lite.DropModules(MkBufferListC azKeepBfl) C-API
Remove Unnecessary Virtual Table Implementations …
 
void OverloadFunction (string zFuncName, int nArg)
  C#: sq3lite.OverloadFunction(string zFuncName, int nArg) C-API
Overload A Function For A Virtual Table …
 
byte[] Serialize (string zSchema, Sq3SerializeE mFlags)
  C#: byte[] sq3lite.Serialize(string zSchema, Sq3SerializeE mFlags) C-API
Serialize a database …
 
List< object > DbStatus (Sq3DbStatusE op, bool resetFlg)
  C#: {pCur:int pHiwtr:int} sq3lite.DbStatus(Sq3DbStatusE op, bool resetFlg) C-API
Database Connection Status …
 
List< object > TableColumnMetadata (string zDbName, string zTableName, string zColumnName)
  C#: {pzDataType:string pzCollSeq:string pNotNull:int pPrimaryKey:int pAutoinc:int} db.TableColumnMetadata(string zDbName, string zTableName, string zColumnName) C-API
Extract Metadata About A Column Of A Table …
 
void WalAutocheckpoint (int N)
  C#: db.WalAutocheckpoint(int N) C-API
Configure an auto-checkpoint …
 
List< object > WalCheckpointV2 (string zDb, int eMode)
  C#: {pnLog:int pnCkpt:int} db.WalCheckpointV2(string zDb, int eMode) C-API
Checkpoint a database …
 
void Interrupt ()
  C#: sq3lite.Interrupt() C-API
Interrupt A Long-Running Query …
 
bool IsInterrupted ()
  C#: bool sq3lite.IsInterrupted() C-API
Interrupt A Long-Running Query …
 
int Changes ()
  C#: int sq3lite.Changes() C-API
Count The Number Of Rows Modified …
 
long Changes64 ()
  C#: long sq3lite.Changes64() C-API
Count The Number Of Rows Modified …
 
void SetLastInsertRowid (long arg1)
  C#: sq3lite.SetLastInsertRowid(long arg1) C-API
Set the Last Insert Rowid value …
 
int TotalChanges ()
  C#: int sq3lite.TotalChanges() C-API
Total Number Of Rows Modified …
 
long TotalChanges64 ()
  C#: long sq3lite.TotalChanges64() 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#: [constructor] Sq3StmtC db.PrepareV2(string zSql) C-API
Compiling An SQL Statement …
 
void CloseV2 ()
  C#: [destructor] sq3lite.CloseV2() C-API
Closing A Database Connection …
 
- Public Member Functions inherited from csmkkernel::MkObjectC
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#: [static] Sq3LiteC Sq3LiteC.HandleResolve(Int32 netHdl) C-API
Handle-Resolve-Slot - return a Sq3LiteC from netHdl or null if invalid…
 
new static Sq3LiteC Instances ()
  C#: [static] Sq3LiteC Sq3LiteC.Instances() C-API
get head-instance from linked-list of Sq3LiteS type …
 
new static Sq3LiteC GetNull ()
  C#: [static] Sq3LiteC Sq3LiteC.GetNull() C-API
Null-Slot - return a Sq3LiteC typed NULL instance …
 
static string ErrStr (int arg0)
  C#: [static] string Sq3LiteC.ErrStr(int arg0) C-API
Error Codes And Messages …
 
static void Sleep (int arg0)
  C#: [static] Sq3LiteC.Sleep(int arg0) C-API
Suspend Execution For A Short Time …
 
static Sq3LiteC OpenV2 (string filename, Sq3OpenEF flags=Sq3OpenEF.READWRITE|Sq3OpenEF.CREATE, string zVfs=null)
  C#: [constructor,static] Sq3LiteC Sq3LiteC.OpenV2(string filename, Sq3OpenEF flags = SQ3_OPEN_READWRITE|SQ3_OPEN_CREATE, string zVfs = null) C-API
Opening A New Database Connection …
 
- Static Public Member Functions inherited from csmkkernel::MkObjectC
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#: [constructor,static] Sq3LiteC Sq3LiteC.OpenV2(string filename, Sq3OpenEF flags = SQ3_OPEN_READWRITE|SQ3_OPEN_CREATE, string zVfs = null) C-API
Opening A New Database Connection …
 
- Static Protected Member Functions inherited from csmkkernel::MkObjectC
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

- Protected Member Functions inherited from csmkkernel::MkObjectC
 MkObjectC (IntPtr obj)
 
 MkObjectC ()
 
virtual void Dispose (bool disposing)
 
- Protected Attributes inherited from csmkkernel::MkObjectC
IntPtr pmkrt
 
- Properties inherited from csmkkernel::MkObjectC
IntPtr hdl
 
IntPtr hdl_null_allow
 
IntPtr mkrt
 

Detailed Description

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:

typedef struct sqlite3 sqlite3;
struct sqlite3 sqlite3

Definition at line 570 of file Sq3LiteC_cs.cs.

Member Function Documentation

◆ Sq3LiteC_ObjNew()

static Sq3LiteC cssq3lite.Sq3LiteC.Sq3LiteC_ObjNew ( IntPtr hdl)
inlinestatic

Definition at line 38 of file Sq3LiteC_cs.cs.

38 {
39 return hdl != IntPtr.Zero ? (Sq3LiteC) atomObjNew(typeof(Sq3LiteC), ctor, hdl) : MK_NULL.Value;
40 }
static object atomObjNew(Type type, ConstructorInfo ctor, IntPtr obj)
+ Here is the caller graph for this function:

◆ Sq3LiteExecCCB()

delegate void cssq3lite.Sq3LiteC.Sq3LiteExecCCB ( string[] vals,
string[] cols )

implements the cssq3lite API object: public version from LcConfigIncludeF as method

◆ Sq3LiteExecV2CCB()

delegate void cssq3lite.Sq3LiteC.Sq3LiteExecV2CCB ( MkBufferListC vals,
MkBufferListC cols )

The documentation for this class was generated from the following files: