Description | Hierarchy | Fields | Methods | Properties |
type TSqlitePassEngine = class(TObject)
![]() |
Constructor Create(Database: TSqlitePassDatabase); |
![]() |
Destructor Destroy; override; |
![]() |
function CheckResult(Const i: Integer; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow): Integer; |
![]() |
function CreateFunction(FuncName: String; ArgCount: ShortInt; DefaultEncoding: Byte; UserData: Pointer; xFunc, xStep: TFuncHandler; xFinal: TFuncFinalizer): Boolean; |
![]() |
function ExecSQL(Const Sql: String; CallBackFunc: TSqlitePassExecCallBack = nil): Integer; |
![]() |
function GetChangesCount: Integer; |
![]() |
function GetLastInsertRowId: Int64; |
![]() |
function GetTotalChangesCount: Integer; |
![]() |
Function LoadSqliteLibrary(LibraryFile: String): Boolean; |
![]() |
function PrepareStmt(var Stmt: pointer; const sql: String; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow): Boolean; |
![]() |
function UnprepareStmt(var Stmt: pointer): Boolean; |
![]() |
procedure CloseDatabase; |
![]() |
procedure ExecQuery(Const Sql: String; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow); |
![]() |
procedure ExecQueryUTF16(Const Sql: UTF16WideString; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow); |
![]() |
procedure ExecQueryUTF8(Const Sql: UTF8String; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow); |
![]() |
Procedure FinalizePendingStmts; |
![]() |
procedure OpenDatabase(Const FullName: String; Const LibraryFile: String = DefaultSQLiteLibrary); |
![]() |
Procedure StartChrono; |
![]() |
Procedure StopChrono; |
![]() |
property Connection: Pointer read FConnectionHandle; |
![]() |
property ElapsedTime: Double read FElapsedTime; |
![]() |
property QueryTimeout: Integer Read FQueryTimeout Write FQueryTimeout; |
![]() |
property Transaction: TSqlitePassTransaction Read FTransaction Write FTransaction; |
![]() |
Constructor Create(Database: TSqlitePassDatabase); |
![]() |
Destructor Destroy; override; |
![]() |
function CheckResult(Const i: Integer; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow): Integer; |
![]() |
function CreateFunction(FuncName: String; ArgCount: ShortInt; DefaultEncoding: Byte; UserData: Pointer; xFunc, xStep: TFuncHandler; xFinal: TFuncFinalizer): Boolean; |
—— User Defined Functions —– |
![]() |
function ExecSQL(Const Sql: String; CallBackFunc: TSqlitePassExecCallBack = nil): Integer; |
—— SQL Exec —— |
![]() |
function GetChangesCount: Integer; |
![]() |
function GetLastInsertRowId: Int64; |
![]() |
function GetTotalChangesCount: Integer; |
![]() |
Function LoadSqliteLibrary(LibraryFile: String): Boolean; |
———— Library —————– |
![]() |
function PrepareStmt(var Stmt: pointer; const sql: String; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow): Boolean; |
—— SQL Statements —— |
![]() |
function UnprepareStmt(var Stmt: pointer): Boolean; |
![]() |
procedure CloseDatabase; |
![]() |
procedure ExecQuery(Const Sql: String; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow); |
![]() |
procedure ExecQueryUTF16(Const Sql: UTF16WideString; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow); |
![]() |
procedure ExecQueryUTF8(Const Sql: UTF8String; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow); |
![]() |
Procedure FinalizePendingStmts; |
![]() |
procedure OpenDatabase(Const FullName: String; Const LibraryFile: String = DefaultSQLiteLibrary); |
————- Database —————- |
![]() |
Procedure StartChrono; |
Chrono utility |
![]() |
Procedure StopChrono; |
![]() |
property Connection: Pointer read FConnectionHandle; |
![]() |
property ElapsedTime: Double read FElapsedTime; |
![]() |
property QueryTimeout: Integer Read FQueryTimeout Write FQueryTimeout; |
![]() |
property Transaction: TSqlitePassTransaction Read FTransaction Write FTransaction; |
Transactions. TODO : Rework on nested named transactions. Sqlite engine supports only one active |