Class tsqlite3connection

Unit

msesqlite3conn

Declaration

type tsqlite3connection = class(tcustomsqlconnection, idbcontroller, iblobconnection)

Description

Hierarchy

• tcustomsqlconnection
• tsqlite3connection

Overview

Methods

	procedure loaded; override;
	function getfloatdate: boolean; override;
	function getint64currency: boolean; override;
	function getassqltext(const field : tfield) : msestring; override;
	function getassqltext(const param : tparam) : msestring; override;
	procedure resetstatement(const astatement: psqlite3_stmt);
	procedure checkerror(const aerror: integer);
	function cantransaction: boolean;
	procedure DoInternalConnect; override;
	procedure DoInternalDisconnect; override;
	function GetHandle: pointer; override;
	Function AllocateTransactionHandle: TSQLHandle; override;
	procedure internalExecute(const cursor: TSQLCursor; const atransaction: tsqltransaction; const AParams : TmseParams; const autf8: boolean); override;
	function GetTransactionHandle(trans : TSQLHandle): pointer; override;
	function Commit(trans : TSQLHandle) : boolean; override;
	function RollBack(trans : TSQLHandle) : boolean; override;
	function StartdbTransaction(const trans : TSQLHandle; const aParams: tstringlist) : boolean; override;
	procedure internalCommitRetaining(trans : TSQLHandle); override;
	procedure internalRollBackRetaining(trans : TSQLHandle); override;
	function getblobdatasize: integer; override;
	function CreateBlobStream(const Field: TField; const Mode: TBlobStreamMode; const acursor: tsqlcursor): TStream; override;
	procedure execsql(const asql: string);
	procedure UpdateIndexDefs(var IndexDefs : TIndexDefs; const aTableName : string; const acursor: tsqlcursor); override;
	function getprimarykeyfield(const atablename: string; const acursor: tsqlcursor): string; override;
	procedure updateprimarykeyfield(const afield: tfield; const atransaction: tsqltransaction); override;
	procedure beginupdate; override;
	procedure endupdate; override;
	constructor create(aowner: tcomponent); override;
	Function AllocateCursorHandle(const aowner: icursorclient; const aname: ansistring) : TSQLCursor; override;
	Procedure DeAllocateCursorHandle(var cursor : TSQLCursor); override;
	procedure preparestatement(const cursor: tsqlcursor; const atransaction : tsqltransaction; const asql: msestring; const aparams : tmseparams); override;
	function Fetch(cursor : TSQLCursor) : boolean; override;
	procedure AddFieldDefs(const cursor: TSQLCursor; const FieldDefs : TfieldDefs); override;
	procedure UnPrepareStatement(cursor : TSQLCursor); override;
	procedure FreeFldBuffers(cursor : TSQLCursor); override;
	function loadfield(const cursor: tsqlcursor; const datatype: tfieldtype; const fieldnum: integer; const buffer: pointer; var bufsize: integer; const aisutf8: boolean): boolean; override;
	procedure updateutf8(var autf8: boolean); override;
	function getinsertid(const atransaction: tsqltransaction): int64; override;
	function fetchblob(const cursor: tsqlcursor; const fieldnum: integer): ansistring; override;
	function stringquery(const asql: string): stringarty;
	function stringsquery(const asql: string): stringararty;

Properties

	property lasterror: integer read flasterror;
	property lasterrormessage: msestring read flasterrormessage;
	property DatabaseName: filenamety read getdatabasename write setdatabasename;
	property Connected: boolean read getconnected write setconnected default false;
	property controller: tdbcontroller read fcontroller write setcontroller;
	property options: sqliteoptionsty read foptions write setoptions default [];
	property busytimeoutms: integer read fbusytimeoutms write setbusytimeoutms default 0;
	property Transaction;
	property transactionwrite;
	property afterconnect;
	property beforedisconnect;

Description

Methods

	procedure loaded; override;

	function getfloatdate: boolean; override;

	function getint64currency: boolean; override;

	function getassqltext(const field : tfield) : msestring; override;

	function getassqltext(const param : tparam) : msestring; override;

	procedure resetstatement(const astatement: psqlite3_stmt);

	procedure checkerror(const aerror: integer);

	function cantransaction: boolean;

	procedure DoInternalConnect; override;

	procedure DoInternalDisconnect; override;

	function GetHandle: pointer; override;

	Function AllocateTransactionHandle: TSQLHandle; override;

	procedure internalExecute(const cursor: TSQLCursor; const atransaction: tsqltransaction; const AParams : TmseParams; const autf8: boolean); override;

	function GetTransactionHandle(trans : TSQLHandle): pointer; override;

	function Commit(trans : TSQLHandle) : boolean; override;

	function RollBack(trans : TSQLHandle) : boolean; override;

	function StartdbTransaction(const trans : TSQLHandle; const aParams: tstringlist) : boolean; override;

	procedure internalCommitRetaining(trans : TSQLHandle); override;

	procedure internalRollBackRetaining(trans : TSQLHandle); override;

	function getblobdatasize: integer; override;

	function CreateBlobStream(const Field: TField; const Mode: TBlobStreamMode; const acursor: tsqlcursor): TStream; override;

	procedure execsql(const asql: string);

	procedure UpdateIndexDefs(var IndexDefs : TIndexDefs; const aTableName : string; const acursor: tsqlcursor); override;

	function getprimarykeyfield(const atablename: string; const acursor: tsqlcursor): string; override;

	procedure updateprimarykeyfield(const afield: tfield; const atransaction: tsqltransaction); override;

	procedure beginupdate; override;

	procedure endupdate; override;

	constructor create(aowner: tcomponent); override;

	Function AllocateCursorHandle(const aowner: icursorclient; const aname: ansistring) : TSQLCursor; override;

	Procedure DeAllocateCursorHandle(var cursor : TSQLCursor); override;

	procedure preparestatement(const cursor: tsqlcursor; const atransaction : tsqltransaction; const asql: msestring; const aparams : tmseparams); override;

	function Fetch(cursor : TSQLCursor) : boolean; override;

	procedure AddFieldDefs(const cursor: TSQLCursor; const FieldDefs : TfieldDefs); override;

	procedure UnPrepareStatement(cursor : TSQLCursor); override;

	procedure FreeFldBuffers(cursor : TSQLCursor); override;

	function loadfield(const cursor: tsqlcursor; const datatype: tfieldtype; const fieldnum: integer; const buffer: pointer; var bufsize: integer; const aisutf8: boolean): boolean; override;

	procedure updateutf8(var autf8: boolean); override;

	function getinsertid(const atransaction: tsqltransaction): int64; override;

	function fetchblob(const cursor: tsqlcursor; const fieldnum: integer): ansistring; override;

	function stringquery(const asql: string): stringarty;

	function stringsquery(const asql: string): stringararty;

Properties

	property lasterror: integer read flasterror;

	property lasterrormessage: msestring read flasterrormessage;

	property DatabaseName: filenamety read getdatabasename write setdatabasename;

	property Connected: boolean read getconnected write setconnected default false;

	property controller: tdbcontroller read fcontroller write setcontroller;

	property options: sqliteoptionsty read foptions write setoptions default [];

	property busytimeoutms: integer read fbusytimeoutms write setbusytimeoutms default 0;

	property Transaction;

	property transactionwrite;

	property afterconnect;

	property beforedisconnect;

---

Generated by PasDoc 0.16.0.