theSq3Lite 10.0
Loading...
Searching...
No Matches
Sq3LiteC_Misc_CS_API

Sq3LiteC - various functions to perform misc operations … More...

+ Collaboration diagram for Sq3LiteC_Misc_CS_API:

Functions

MkBufferListC cssq3lite.Sq3LiteC.DbStatusBFL (Sq3DbStatusE op, bool resetFlg)
  C#: MkBufferListC sq3lite.DbStatusBFL(Sq3DbStatusE op, bool resetFlg) C-API
Database Connection Status …
 
void cssq3lite.Sq3LiteC.DbCacheflush ()
  C#: sq3lite.DbCacheflush() C-API
Flush caches to disk mid-transaction …
 
string cssq3lite.Sq3LiteC.DbFilename (string zDbName)
  C#: string db.DbFilename(string zDbName) C-API
Return The Filename For A Database Connection …
 
string cssq3lite.Sq3LiteC.DbName (int N)
  C#: string db.DbName(int N) C-API
Return The Schema Name For A Database Connection …
 
void cssq3lite.Sq3LiteC.DbReadonly (string zDbName)
  C#: db.DbReadonly(string zDbName) C-API
Determine if a database is read-only …
 
void cssq3lite.Sq3LiteC.DbReleaseMemory ()
  C#: sq3lite.DbReleaseMemory() C-API
Free Memory Used By A Database Connection …
 
void cssq3lite.Sq3LiteC.Deserialize (string zSchema, byte[] pData, Sq3DeSerializeEF mFlags)
  C#: sq3lite.Deserialize(string zSchema, byte[] pData, Sq3DeSerializeEF mFlags) C-API
Deserialize a database …
 
void cssq3lite.Sq3LiteC.DropModules (MkBufferListC azKeepBfl)
  C#: sq3lite.DropModules(MkBufferListC azKeepBfl) C-API
Remove Unnecessary Virtual Table Implementations …
 
void cssq3lite.Sq3LiteC.OverloadFunction (string zFuncName, int nArg)
  C#: sq3lite.OverloadFunction(string zFuncName, int nArg) C-API
Overload A Function For A Virtual Table …
 
byte[] cssq3lite.Sq3LiteC.Serialize (string zSchema, Sq3SerializeE mFlags)
  C#: byte[] sq3lite.Serialize(string zSchema, Sq3SerializeE mFlags) C-API
Serialize a database …
 
List< object > cssq3lite.Sq3LiteC.DbStatus (Sq3DbStatusE op, bool resetFlg)
  C#: {pCur:int pHiwtr:int} sq3lite.DbStatus(Sq3DbStatusE op, bool resetFlg) C-API
Database Connection Status …
 
List< object > cssq3lite.Sq3LiteC.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 …
 

Detailed Description

Sq3LiteC - various functions to perform misc operations …

Function Documentation

◆ DbCacheflush()

void cssq3lite.Sq3LiteC.DbCacheflush ( )
inline

C#: sq3lite.DbCacheflush() C-API
Flush caches to disk mid-transaction …

Definition at line 357 of file Sq3LiteC_cs.cs.

357 {
358 MkErrorE errVal = Sq3.Sq3LiteDbCacheflush(hdl);
359 MkErrorC.Check(hdl, errVal);
360 }
static void Check(IntPtr ctx, MkErrorE err)
MkErrorE

◆ DbFilename()

string cssq3lite.Sq3LiteC.DbFilename ( string zDbName)
inline

C#: string db.DbFilename(string zDbName) C-API
Return The Filename For A Database Connection …

Definition at line 363 of file Sq3LiteC_cs.cs.

363 {
364 IntPtr zDbName_cstr = Marshal.StringToHGlobalAnsi(zDbName);
365 IntPtr __retVal__L = Sq3.Sq3LiteDbFilename(hdl, zDbName_cstr);
366 Marshal.FreeHGlobal(zDbName_cstr);
367 return Marshal.PtrToStringAnsi(__retVal__L);
368 }

◆ DbName()

string cssq3lite.Sq3LiteC.DbName ( int N)
inline

C#: string db.DbName(int N) C-API
Return The Schema Name For A Database Connection …

Definition at line 371 of file Sq3LiteC_cs.cs.

371 {
372 IntPtr __retVal__L = Sq3.Sq3LiteDbName(hdl, N);
373 return Marshal.PtrToStringAnsi(__retVal__L);
374 }

◆ DbReadonly()

void cssq3lite.Sq3LiteC.DbReadonly ( string zDbName)
inline

C#: db.DbReadonly(string zDbName) C-API
Determine if a database is read-only …

Definition at line 377 of file Sq3LiteC_cs.cs.

377 {
378 IntPtr zDbName_cstr = Marshal.StringToHGlobalAnsi(zDbName);
379 MkErrorE errVal = Sq3.Sq3LiteDbReadonly(hdl, zDbName_cstr);
380 Marshal.FreeHGlobal(zDbName_cstr);
381 MkErrorC.Check(hdl, errVal);
382 }

◆ DbReleaseMemory()

void cssq3lite.Sq3LiteC.DbReleaseMemory ( )
inline

C#: sq3lite.DbReleaseMemory() C-API
Free Memory Used By A Database Connection …

Definition at line 385 of file Sq3LiteC_cs.cs.

385 {
386 MkErrorE errVal = Sq3.Sq3LiteDbReleaseMemory(hdl);
387 MkErrorC.Check(hdl, errVal);
388 }

◆ DbStatus()

List< object > cssq3lite.Sq3LiteC.DbStatus ( Sq3DbStatusE op,
bool resetFlg )
inline

C#: {pCur:int pHiwtr:int} sq3lite.DbStatus(Sq3DbStatusE op, bool resetFlg) C-API
Database Connection Status …

Definition at line 433 of file Sq3LiteC_cs.cs.

433 {
434 Int32 pCur;
435 Int32 pHiwtr;
436 MkErrorE errVal = Sq3.Sq3LiteDbStatus(hdl, op, out pCur, out pHiwtr, resetFlg);
437 MkErrorC.Check(hdl, errVal);
438 List<object> __retVal__L = new List<object>();
439 __retVal__L.Add(pCur);
440 __retVal__L.Add(pHiwtr);
441 return __retVal__L;
442 }

◆ DbStatusBFL()

MkBufferListC cssq3lite.Sq3LiteC.DbStatusBFL ( Sq3DbStatusE op,
bool resetFlg )
inline

C#: MkBufferListC sq3lite.DbStatusBFL(Sq3DbStatusE op, bool resetFlg) C-API
Database Connection Status …

Definition at line 347 of file Sq3LiteC_cs.cs.

347 {
348 IntPtr val_out;
349 MkErrorE errVal = Sq3.Sq3LiteDbStatusBFL(mkrt, hdl, op, out val_out, resetFlg);
350 MkErrorC.Check(hdl, errVal);
351 return MkBufferListC.MkBufferListC_ObjNew(val_out);
352 }
static MkBufferListC MkBufferListC_ObjNew(IntPtr hdl)

◆ Deserialize()

void cssq3lite.Sq3LiteC.Deserialize ( string zSchema,
byte[] pData,
Sq3DeSerializeEF mFlags )
inline

C#: sq3lite.Deserialize(string zSchema, byte[] pData, Sq3DeSerializeEF mFlags) C-API
Deserialize a database …

Definition at line 391 of file Sq3LiteC_cs.cs.

391 {
392 IntPtr zSchema_cstr = Marshal.StringToHGlobalAnsi(zSchema);
393 var pData_size = Marshal.SizeOf(pData[0]) * pData.Length;
394 var pData_data = Marshal.AllocHGlobal(pData_size);
395 Marshal.Copy(pData,0,pData_data,pData_size);
396 Mk.MkBinaryR pData_ref = Mk.MkBinaryCreate(pData_size,pData_data);
397 MkErrorE errVal = Sq3.Sq3LiteDeserialize(mkrt, hdl, zSchema_cstr, pData_ref, mFlags);
398 Marshal.FreeHGlobal(zSchema_cstr);
399 MkErrorC.Check(hdl, errVal);
400 }
static Mk.MkBinaryR MkBinaryCreate(long size, IntPtr data)

◆ DropModules()

void cssq3lite.Sq3LiteC.DropModules ( MkBufferListC azKeepBfl)
inline

C#: sq3lite.DropModules(MkBufferListC azKeepBfl) C-API
Remove Unnecessary Virtual Table Implementations …

Definition at line 403 of file Sq3LiteC_cs.cs.

403 {
404 IntPtr azKeepBfl_hdl = MkBufferListC.getOBJ("MkBufferListC",azKeepBfl);
405 MkErrorE errVal = Sq3.Sq3LiteDropModules(mkrt, hdl, azKeepBfl_hdl);
406 MkErrorC.Check(hdl, errVal);
407 }

◆ OverloadFunction()

void cssq3lite.Sq3LiteC.OverloadFunction ( string zFuncName,
int nArg )
inline

C#: sq3lite.OverloadFunction(string zFuncName, int nArg) C-API
Overload A Function For A Virtual Table …

Definition at line 412 of file Sq3LiteC_cs.cs.

412 {
413 IntPtr zFuncName_cstr = Marshal.StringToHGlobalAnsi(zFuncName);
414 MkErrorE errVal = Sq3.Sq3LiteOverloadFunction(hdl, zFuncName_cstr, nArg);
415 Marshal.FreeHGlobal(zFuncName_cstr);
416 MkErrorC.Check(hdl, errVal);
417 }

◆ Serialize()

byte[] cssq3lite.Sq3LiteC.Serialize ( string zSchema,
Sq3SerializeE mFlags )
inline

C#: byte[] sq3lite.Serialize(string zSchema, Sq3SerializeE mFlags) C-API
Serialize a database …

Definition at line 420 of file Sq3LiteC_cs.cs.

420 {
421 IntPtr zSchema_cstr = Marshal.StringToHGlobalAnsi(zSchema);
422 Mk.MkBinaryR __retVal__L = Sq3.Sq3LiteSerialize(hdl, zSchema_cstr, mFlags);
423 Marshal.FreeHGlobal(zSchema_cstr);
424 int __retVal__L_size = (int) __retVal__L.size;
425 byte[] ____retVal__L__S = new byte[__retVal__L_size];
426 Marshal.Copy(__retVal__L.data,____retVal__L__S,0,(int)__retVal__L_size);
427 return ____retVal__L__S;
428 }

◆ TableColumnMetadata()

List< object > cssq3lite.Sq3LiteC.TableColumnMetadata ( string zDbName,
string zTableName,
string zColumnName )
inline

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 …

Definition at line 445 of file Sq3LiteC_cs.cs.

445 {
446 IntPtr pzDataType;
447 IntPtr pzCollSeq;
448 Int32 pNotNull;
449 Int32 pPrimaryKey;
450 Int32 pAutoinc;
451 IntPtr zDbName_cstr = Marshal.StringToHGlobalAnsi(zDbName);
452 IntPtr zTableName_cstr = Marshal.StringToHGlobalAnsi(zTableName);
453 IntPtr zColumnName_cstr = Marshal.StringToHGlobalAnsi(zColumnName);
454 MkErrorE errVal = Sq3.Sq3LiteTableColumnMetadata(hdl, zDbName_cstr, zTableName_cstr, zColumnName_cstr, out pzDataType, out pzCollSeq, out pNotNull, out pPrimaryKey, out pAutoinc);
455 Marshal.FreeHGlobal(zDbName_cstr);
456 Marshal.FreeHGlobal(zTableName_cstr);
457 Marshal.FreeHGlobal(zColumnName_cstr);
458 MkErrorC.Check(hdl, errVal);
459 List<object> __retVal__L = new List<object>();
460 __retVal__L.Add(pzDataType);
461 __retVal__L.Add(pzCollSeq);
462 __retVal__L.Add(pNotNull);
463 __retVal__L.Add(pPrimaryKey);
464 __retVal__L.Add(pAutoinc);
465 return __retVal__L;
466 }