Class tcustomsqlconnection

Description
Hierarchy
Fields
Methods
Properties

Unit

msqldb

Declaration

type tcustomsqlconnection = class(TmDatabase, idbcontroller, iactivatorclient)

Description

This item has no description.

Hierarchy

Overview

Fields

Protected FConnOptions: sqlconnoptionsty;
Protected fcontroller: tdbcontroller;

Methods

Protected function connectionmessage(atext: pchar): msestring;
Protected procedure finalizetransaction(const atransaction: tsqlhandle); virtual;
Protected procedure notification(acomponent: tcomponent; operation: toperation); override;
Protected function StrToStatementType(s : msestring) : TStatementType; virtual;
Protected procedure getcredentials(var ausername: msestring; var apassword: msestring);
Protected procedure freecredentials(var ausername: msestring; var apassword: msestring);
Protected procedure DoInternalConnect; override;
Protected procedure doafterinternalconnect; override;
Protected procedure dobeforeinternaldisconnect; override;
Protected procedure DoInternalDisconnect; override;
Protected function GetAsSQLText(const Field : TField) : msestring; overload; virtual;
Protected function GetAsSQLText(const Param : TParam) : msestring; overload; virtual;
Protected function GetHandle: pointer; virtual;
Protected procedure updateprimarykeyfield(const afield: tfield; const atransaction: tsqltransaction); virtual;
Protected Function AllocateTransactionHandle: TSQLHandle; virtual; abstract;
Protected procedure internalexecute(const cursor: tsqlcursor; const atransaction: tsqltransaction; const aparams : tmseparams; const autf8: boolean); virtual; abstract;
Protected procedure internalexecuteunprepared(const cursor: tsqlcursor; const atransaction: tsqltransaction; const asql: string; const origsql: msestring; const aparams: tmseparams); virtual;
Protected procedure Execute(const cursor: TSQLCursor; const atransaction: tsqltransaction; const AParams : TmseParams; const autf8: boolean);
Protected procedure Executeunprepared(const cursor: TSQLCursor; const atransaction: tsqltransaction; const AParams : TmseParams; const asql: msestring; const autf8: boolean);
Protected function GetTransactionHandle(trans : TSQLHandle): pointer; virtual; abstract;
Protected function Commit(trans : TSQLHandle) : boolean; virtual; abstract;
Protected function RollBack(trans : TSQLHandle) : boolean; virtual; abstract;
Protected function StartdbTransaction(const trans : TSQLHandle; const aParams: tstringlist) : boolean; virtual; abstract;
Protected procedure internalcommitretaining(trans : tsqlhandle); virtual; abstract;
Protected procedure internalrollbackretaining(trans : tsqlhandle); virtual; abstract;
Protected procedure CommitRetaining(trans : TSQLHandle); virtual;
Protected procedure RollBackRetaining(trans : TSQLHandle); virtual;
Protected function getblobdatasize: integer; virtual; abstract;
Protected function getnumboolean: boolean; virtual;
Protected function getfloatdate: boolean; virtual;
Protected function getint64currency: boolean; virtual;
Protected procedure UpdateIndexDefs(var IndexDefs : TIndexDefs; const aTableName : string; const acursor: tsqlcursor); virtual;
Protected function getprimarykeyfield(const atablename: string; const acursor: tsqlcursor): string; virtual;
Protected function GetSchemaInfoSQL(SchemaType : TSchemaType; SchemaObjectName, SchemaPattern : msestring) : msestring; virtual;
Protected function CreateBlobStream(const Field: TField; const Mode: TBlobStreamMode; const acursor: tsqlcursor): TStream; virtual;
Protected procedure closeds(out activeds: integerarty);
Protected procedure reopends(const activeds: integerarty);
Protected function identquotechar: msestring; virtual;
Protected procedure beginupdate; virtual;
Protected procedure endupdate; virtual;
Protected function internalExecuteDirect(const aSQL: mseString; ATransaction: TSQLTransaction; const aparams: tmseparams; aparamvars: array of variant; aisutf8: boolean; const noprepare: boolean): integer;
Protected procedure setinheritedconnected(const avalue: boolean);
Protected function readsequence(const sequencename: string): msestring; virtual;
Protected function sequencecurrvalue(const sequencename: string): msestring; virtual;
Protected function writesequence(const sequencename: string; const avalue: largeint): msestring; virtual;
Protected function blobscached: boolean;
Public constructor create(aowner: tcomponent); override;
Public destructor destroy; override;
Public procedure updateutf8(var autf8: boolean); virtual;
Public function isutf8: boolean;
Public function todbstring(const avalue: msestring): string;
Public function tomsestring(const avalue: string): msestring;
Public procedure FreeFldBuffers(cursor : TSQLCursor); virtual; abstract;
Public Function AllocateCursorHandle(const aowner: icursorclient; const aname: ansistring): TSQLCursor; virtual; abstract;
Public Procedure DeAllocateCursorHandle(var cursor : TSQLCursor); virtual; abstract;
Public procedure preparestatement(const cursor: tsqlcursor; const atransaction : tsqltransaction; const asql: msestring; const aparams : tmseparams); overload; virtual; abstract;
Public procedure UnPrepareStatement(cursor : TSQLCursor); virtual; abstract;
Public procedure AddFieldDefs(const cursor: TSQLCursor; const FieldDefs: TfieldDefs); virtual; abstract;
Public function Fetch(cursor : TSQLCursor) : boolean; virtual; abstract;
Public function loadfield(const cursor: tsqlcursor; const datatype: tfieldtype; const fieldnum: integer; const buffer: pointer; var bufsize: integer; const aisutf8: boolean): boolean; virtual; abstract;
Public function fetchblob(const cursor: tsqlcursor; const fieldnum: integer): ansistring; virtual;
Public procedure Close;
Public procedure Open;
Public procedure StartTransaction; override;
Public procedure EndTransaction; override;
Public function executedirect(const asql: msestring; const aisutf8: boolean = false): integer; overload;
Public function executedirect(const asql: msestring; atransaction: tsqltransaction; const aparams: tmseparams = nil; const aisutf8: boolean = false; const anoprepare: boolean = false): integer; overload;
Public function ExecuteDirect(const aSQL: mseString; ATransaction: TSQLTransaction; const aparams: array of variant; const aisutf8: boolean = false; const anoprepare: boolean = false): integer; overload;
Public procedure GetTableNames(out List: msestringarty; SystemTables: Boolean = false); virtual;
Public procedure GetProcedureNames(out List: msestringarty); virtual;
Public procedure GetFieldNames(const TableName: string; out List: msestringarty); virtual;
Public function getinsertid(const atransaction: tsqltransaction): int64; virtual;
Public function fieldtosql(const afield: tfield): msestring;
Public function fieldtooldsql(const afield: tfield): msestring;
Public function paramtosql(const aparam: tparam): msestring;

Properties

Public property Handle: Pointer read GetHandle;
Public property ConnOptions: sqlconnoptionsty read FConnOptions;
Public property Password : msestring read FPassword write FPassword;
Public property Transaction : TSQLTransaction read FTransaction write SetTransaction;
Public property transactionwrite : tsqltransaction read ftransactionwrite write settransactionwrite;
Public property UserName : msestring read FUserName write FUserName;
Public property CharSet : msestring read FCharSet write FCharSet;
Public property HostName : msestring Read FHostName Write FHostName;
Public property Connected: boolean read getconnected write setconnected default false;
Public property Role : msestring read FRole write FRole;
Public property afterconnect: tmsesqlscript read fafterconnect write setafteconnect;
Public property beforedisconnect: tmsesqlscript read fbeforedisconnect write setbeforedisconnect;
Public property controller: tdbcontroller read fcontroller write setcontroller;
Public property ongetcredentials: getcredentialseventty read fongetcredentials write fongetcredentials;

Description

Fields

Protected FConnOptions: sqlconnoptionsty;

This item has no description.

Protected fcontroller: tdbcontroller;

This item has no description.

Methods

Protected function connectionmessage(atext: pchar): msestring;

This item has no description.

Protected procedure finalizetransaction(const atransaction: tsqlhandle); virtual;

This item has no description.

Protected procedure notification(acomponent: tcomponent; operation: toperation); override;

This item has no description.

Protected function StrToStatementType(s : msestring) : TStatementType; virtual;

This item has no description.

Protected procedure getcredentials(var ausername: msestring; var apassword: msestring);

This item has no description.

Protected procedure freecredentials(var ausername: msestring; var apassword: msestring);

This item has no description.

Protected procedure DoInternalConnect; override;

This item has no description.

Protected procedure doafterinternalconnect; override;

This item has no description.

Protected procedure dobeforeinternaldisconnect; override;

This item has no description.

Protected procedure DoInternalDisconnect; override;

This item has no description.

Protected function GetAsSQLText(const Field : TField) : msestring; overload; virtual;

This item has no description.

Protected function GetAsSQLText(const Param : TParam) : msestring; overload; virtual;

This item has no description.

Protected function GetHandle: pointer; virtual;

This item has no description.

Protected procedure updateprimarykeyfield(const afield: tfield; const atransaction: tsqltransaction); virtual;

This item has no description.

Protected Function AllocateTransactionHandle: TSQLHandle; virtual; abstract;

This item has no description.

Protected procedure internalexecute(const cursor: tsqlcursor; const atransaction: tsqltransaction; const aparams : tmseparams; const autf8: boolean); virtual; abstract;

This item has no description.

Protected procedure internalexecuteunprepared(const cursor: tsqlcursor; const atransaction: tsqltransaction; const asql: string; const origsql: msestring; const aparams: tmseparams); virtual;

This item has no description.

Protected procedure Execute(const cursor: TSQLCursor; const atransaction: tsqltransaction; const AParams : TmseParams; const autf8: boolean);

This item has no description.

Protected procedure Executeunprepared(const cursor: TSQLCursor; const atransaction: tsqltransaction; const AParams : TmseParams; const asql: msestring; const autf8: boolean);

This item has no description.

Protected function GetTransactionHandle(trans : TSQLHandle): pointer; virtual; abstract;

This item has no description.

Protected function Commit(trans : TSQLHandle) : boolean; virtual; abstract;

This item has no description.

Protected function RollBack(trans : TSQLHandle) : boolean; virtual; abstract;

This item has no description.

Protected function StartdbTransaction(const trans : TSQLHandle; const aParams: tstringlist) : boolean; virtual; abstract;

This item has no description.

Protected procedure internalcommitretaining(trans : tsqlhandle); virtual; abstract;

This item has no description.

Protected procedure internalrollbackretaining(trans : tsqlhandle); virtual; abstract;

This item has no description.

Protected procedure CommitRetaining(trans : TSQLHandle); virtual;

This item has no description.

Protected procedure RollBackRetaining(trans : TSQLHandle); virtual;

This item has no description.

Protected function getblobdatasize: integer; virtual; abstract;

This item has no description.

Protected function getnumboolean: boolean; virtual;

This item has no description.

Protected function getfloatdate: boolean; virtual;

This item has no description.

Protected function getint64currency: boolean; virtual;

This item has no description.

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

This item has no description.

Protected function getprimarykeyfield(const atablename: string; const acursor: tsqlcursor): string; virtual;

This item has no description.

Protected function GetSchemaInfoSQL(SchemaType : TSchemaType; SchemaObjectName, SchemaPattern : msestring) : msestring; virtual;

This item has no description.

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

This item has no description.

Protected procedure closeds(out activeds: integerarty);

This item has no description.

Protected procedure reopends(const activeds: integerarty);

This item has no description.

Protected function identquotechar: msestring; virtual;

This item has no description.

Protected procedure beginupdate; virtual;

This item has no description.

Protected procedure endupdate; virtual;

This item has no description.

Protected function internalExecuteDirect(const aSQL: mseString; ATransaction: TSQLTransaction; const aparams: tmseparams; aparamvars: array of variant; aisutf8: boolean; const noprepare: boolean): integer;

This item has no description.

Protected procedure setinheritedconnected(const avalue: boolean);

This item has no description.

Protected function readsequence(const sequencename: string): msestring; virtual;

This item has no description.

Protected function sequencecurrvalue(const sequencename: string): msestring; virtual;

This item has no description.

Protected function writesequence(const sequencename: string; const avalue: largeint): msestring; virtual;

This item has no description.

Protected function blobscached: boolean;

This item has no description.

Public constructor create(aowner: tcomponent); override;

This item has no description.

Public destructor destroy; override;

This item has no description.

Public procedure updateutf8(var autf8: boolean); virtual;

This item has no description.

Public function isutf8: boolean;

This item has no description.

Public function todbstring(const avalue: msestring): string;

This item has no description.

Public function tomsestring(const avalue: string): msestring;

This item has no description.

Public procedure FreeFldBuffers(cursor : TSQLCursor); virtual; abstract;

This item has no description.

Public Function AllocateCursorHandle(const aowner: icursorclient; const aname: ansistring): TSQLCursor; virtual; abstract;

This item has no description.

Public Procedure DeAllocateCursorHandle(var cursor : TSQLCursor); virtual; abstract;

This item has no description.

Public procedure preparestatement(const cursor: tsqlcursor; const atransaction : tsqltransaction; const asql: msestring; const aparams : tmseparams); overload; virtual; abstract;

This item has no description.

Public procedure UnPrepareStatement(cursor : TSQLCursor); virtual; abstract;

This item has no description.

Public procedure AddFieldDefs(const cursor: TSQLCursor; const FieldDefs: TfieldDefs); virtual; abstract;

This item has no description.

Public function Fetch(cursor : TSQLCursor) : boolean; virtual; abstract;

This item has no description.

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

This item has no description.

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

This item has no description.

Public procedure Close;

This item has no description.

Public procedure Open;

This item has no description.

Public procedure StartTransaction; override;

This item has no description.

Public procedure EndTransaction; override;

This item has no description.

Public function executedirect(const asql: msestring; const aisutf8: boolean = false): integer; overload;

This item has no description.

Public function executedirect(const asql: msestring; atransaction: tsqltransaction; const aparams: tmseparams = nil; const aisutf8: boolean = false; const anoprepare: boolean = false): integer; overload;

This item has no description.

Public function ExecuteDirect(const aSQL: mseString; ATransaction: TSQLTransaction; const aparams: array of variant; const aisutf8: boolean = false; const anoprepare: boolean = false): integer; overload;

This item has no description.

Public procedure GetTableNames(out List: msestringarty; SystemTables: Boolean = false); virtual;

This item has no description.

Public procedure GetProcedureNames(out List: msestringarty); virtual;

This item has no description.

Public procedure GetFieldNames(const TableName: string; out List: msestringarty); virtual;

This item has no description.

Public function getinsertid(const atransaction: tsqltransaction): int64; virtual;

This item has no description.

Public function fieldtosql(const afield: tfield): msestring;

This item has no description.

Public function fieldtooldsql(const afield: tfield): msestring;

This item has no description.

Public function paramtosql(const aparam: tparam): msestring;

This item has no description.

Properties

Public property Handle: Pointer read GetHandle;

This item has no description.

Public property ConnOptions: sqlconnoptionsty read FConnOptions;

This item has no description.

Public property Password : msestring read FPassword write FPassword;

This item has no description.

Public property Transaction : TSQLTransaction read FTransaction write SetTransaction;

This item has no description.

Public property transactionwrite : tsqltransaction read ftransactionwrite write settransactionwrite;

This item has no description.

Public property UserName : msestring read FUserName write FUserName;

This item has no description.

Public property CharSet : msestring read FCharSet write FCharSet;

This item has no description.

Public property HostName : msestring Read FHostName Write FHostName;

This item has no description.

Public property Connected: boolean read getconnected write setconnected default false;

This item has no description.

Public property Role : msestring read FRole write FRole;

This item has no description.

Public property afterconnect: tmsesqlscript read fafterconnect write setafteconnect;

This item has no description.

Public property beforedisconnect: tmsesqlscript read fbeforedisconnect write setbeforedisconnect;

This item has no description.

Public property controller: tdbcontroller read fcontroller write setcontroller;

This item has no description.

Public property ongetcredentials: getcredentialseventty read fongetcredentials write fongetcredentials;

This item has no description.

Generated by PasDoc 0.17.0.snapshot.