dbc/ZDbcASAUtils.pas File Reference

Go to the source code of this file.

Classes

struct  TZASADECLTYPE
class  TZASASQLDA

Typedefs

typedef interface IZASASQLDA[' '] AllocateSQLDA (Word NumVars)

Functions

 CheckASAError (IZASAPlainDriver PlainDriver, PZASASQLCA Handle, TZLoggingCategory LogCategory, string LogMessage= '')
 Checks for possible sql errors.
TZSQLType ConvertASAJDBCToSqlType (SmallInt FieldType)
 Converts an ODBC native types into ZDBC SQL types.
TZSQLType ConvertASATypeToSQLType (SmallInt SQLType)
 Converts a ASA native type into ZDBC SQL types.
String ConvertASATypeToString (SmallInt SQLType)
 Converts a ASA native type into String.
 DescribeCursor (IZASAConnection FASAConnection, IZASASQLDA FSQLData, String Cursor, String SQL)
 FreeSQLDA ()
Extended GetBigDecimal (const Integer Index)
Boolean GetBoolean (const Integer Index)
ShortInt GetByte (const Integer Index)
TByteDynArray GetBytes (const Integer Index)
IZResultSet GetCachedResultSet (string SQL, IZStatement Statement, IZResultSet NativeResultSet)
 Create CachedResultSet with using TZCachedResultSet and return it.
PASASQLDA GetData ()
TDateTime GetDate (const Integer Index)
Double GetDouble (const Integer Index)
Integer GetFieldCount ()
Word GetFieldIndex (const String Name)
Word GetFieldLength (const Word Index)
string GetFieldName (const Word Index)
integer GetFieldScale (const Word Index)
TZSQLType GetFieldSqlType (const Word Index)
Single GetFloat (const Integer Index)
Integer GetInt (const Integer Index)
Int64 GetLong (const Integer Index)
PChar GetPChar (const Integer Index)
SmallInt GetShort (const Integer Index)
string GetString (const Integer Index)
TDateTime GetTime (const Integer Index)
TDateTime GetTimestamp (const Integer Index)
Variant GetValue (const Word Index)
 InitFields ()
Boolean IsAssigned (const Integer Index)
boolean IsBlob (const Word Index)
Boolean IsNull (const Integer Index)
boolean IsNullable (const Word Index)
 Prepare (IZASAConnection FASAConnection, IZASASQLDA FSQLData, IZASASQLDA FParamsSQLData, const String SQL, PSmallInt StmtNum, Boolean &FPrepared, Boolean &FMoreResults)
 PrepareParameters (IZASAPlainDriver PlainDriver, TZVariantDynArray InParamValues, TZSQLTypeArray InParamTypes, Integer InParamCount, IZASASQLDA ParamSqlData)
string RandomString (integer Len)
 Generate specific length random string and return it.
 ReadBlobToMem (const Word Index, Pointer &Buffer, LongWord &Length)
 ReadBlobToStream (const Word Index, TStream Stream)
 ReadBlobToString (const Word Index, string &str)
 ReadBlobToVariant (const Word Index, Variant &Value)
 UpdateBigDecimal (const Integer Index, Extended Value)
 UpdateBoolean (const Integer Index, boolean Value)
 UpdateByte (const Integer Index, ShortInt Value)
 UpdateBytes (const Integer Index, TByteDynArray Value)
 UpdateDate (const Integer Index, TDateTime Value)
 UpdateDouble (const Integer Index, Double Value)
 UpdateFloat (const Integer Index, Single Value)
 UpdateInt (const Integer Index, Integer Value)
 UpdateLong (const Integer Index, Int64 Value)
 UpdateNull (const Integer Index, boolean Value)
 UpdatePChar (const Integer Index, PChar Value)
 UpdateShort (const Integer Index, SmallInt Value)
 UpdateString (const Integer Index, string Value)
 UpdateTime (const Integer Index, TDateTime Value)
 UpdateTimestamp (const Integer Index, TDateTime Value)
 UpdateValue (const Word Index, Variant Value)
 WriteBlob (const Integer Index, TStream Stream)

Variables

const BlockSize = 20
const MinBLOBSize = 256
const StdVars = 20


Typedef Documentation

typedef interface IZASASQLDA [' '] AllocateSQLDA(Word NumVars)

Definition at line 88 of file ZDbcASAUtils.pas.


Function Documentation

CheckASAError ( IZASAPlainDriver  PlainDriver,
PZASASQLCA  Handle,
TZLoggingCategory  LogCategory,
string  LogMessage = '' 
)

Checks for possible sql errors.

Parameters:
PlainDriver a MySQL plain driver.
Handle a MySQL connection handle.
LogCategory a logging category.
LogMessage a logging message.

Definition at line 2630 of file ZDbcASAUtils.pas.

TZSQLType ConvertASAJDBCToSqlType ( SmallInt  FieldType  ) 

Converts an ODBC native types into ZDBC SQL types.

Parameters:
FieldType dblibc native field type.
Returns:
a SQL undepended type.

Definition at line 2572 of file ZDbcASAUtils.pas.

TZSQLType ConvertASATypeToSQLType ( SmallInt  SQLType  ) 

Converts a ASA native type into ZDBC SQL types.

Converts a ASA native types into ZDBC SQL types.

Parameters:
FieldHandle a handler to field description structure.
Returns:
a SQL undepended type.
Parameters:
SQLType Field of TASASQLVar structure.
Returns:
a SQL undepended type.

Definition at line 2452 of file ZDbcASAUtils.pas.

String ConvertASATypeToString ( SmallInt  SQLType  ) 

Converts a ASA native type into String.

Parameters:
SQLType Field of TASASQLVar structure.
Returns:
type description.

Definition at line 2510 of file ZDbcASAUtils.pas.

DescribeCursor ( IZASAConnection  FASAConnection,
IZASASQLDA  FSQLData,
String  Cursor,
String  SQL 
)

Definition at line 2688 of file ZDbcASAUtils.pas.

FreeSQLDA (  ) 

Extended GetBigDecimal ( const Integer  Index  ) 

Boolean GetBoolean ( const Integer  Index  ) 

ShortInt GetByte ( const Integer  Index  ) 

TByteDynArray GetBytes ( const Integer  Index  ) 

IZResultSet GetCachedResultSet ( string  SQL,
IZStatement  Statement,
IZResultSet  NativeResultSet 
)

Create CachedResultSet with using TZCachedResultSet and return it.

Parameters:
SQL a sql query command
Statement a zeos statement object
NativeResultSet a native result set
Returns:
cached ResultSet

Definition at line 2663 of file ZDbcASAUtils.pas.

PASASQLDA GetData (  ) 

TDateTime GetDate ( const Integer  Index  ) 

Double GetDouble ( const Integer  Index  ) 

Integer GetFieldCount (  ) 

Word GetFieldIndex ( const String  Name  ) 

Word GetFieldLength ( const Word  Index  ) 

string GetFieldName ( const Word  Index  ) 

integer GetFieldScale ( const Word  Index  ) 

TZSQLType GetFieldSqlType ( const Word  Index  ) 

Single GetFloat ( const Integer  Index  ) 

Integer GetInt ( const Integer  Index  ) 

Int64 GetLong ( const Integer  Index  ) 

PChar GetPChar ( const Integer  Index  ) 

SmallInt GetShort ( const Integer  Index  ) 

string GetString ( const Integer  Index  ) 

TDateTime GetTime ( const Integer  Index  ) 

TDateTime GetTimestamp ( const Integer  Index  ) 

Variant GetValue ( const Word  Index  ) 

InitFields (  ) 

Boolean IsAssigned ( const Integer  Index  ) 

boolean IsBlob ( const Word  Index  ) 

Boolean IsNull ( const Integer  Index  ) 

boolean IsNullable ( const Word  Index  ) 

Prepare ( IZASAConnection  FASAConnection,
IZASASQLDA  FSQLData,
IZASASQLDA  FParamsSQLData,
const String  SQL,
PSmallInt  StmtNum,
Boolean &  FPrepared,
Boolean &  FMoreResults 
)

Definition at line 2712 of file ZDbcASAUtils.pas.

PrepareParameters ( IZASAPlainDriver  PlainDriver,
TZVariantDynArray  InParamValues,
TZSQLTypeArray  InParamTypes,
Integer  InParamCount,
IZASASQLDA  ParamSqlData 
)

Definition at line 2771 of file ZDbcASAUtils.pas.

string RandomString ( integer  Len  ) 

Generate specific length random string and return it.

Parameters:
Len a length result string
Returns:
random string

Definition at line 2862 of file ZDbcASAUtils.pas.

ReadBlobToMem ( const Word  Index,
Pointer &  Buffer,
LongWord &  Length 
)

ReadBlobToStream ( const Word  Index,
TStream  Stream 
)

ReadBlobToString ( const Word  Index,
string &  str 
)

ReadBlobToVariant ( const Word  Index,
Variant &  Value 
)

UpdateBigDecimal ( const Integer  Index,
Extended  Value 
)

UpdateBoolean ( const Integer  Index,
boolean  Value 
)

UpdateByte ( const Integer  Index,
ShortInt  Value 
)

UpdateBytes ( const Integer  Index,
TByteDynArray  Value 
)

UpdateDate ( const Integer  Index,
TDateTime  Value 
)

UpdateDouble ( const Integer  Index,
Double  Value 
)

UpdateFloat ( const Integer  Index,
Single  Value 
)

UpdateInt ( const Integer  Index,
Integer  Value 
)

UpdateLong ( const Integer  Index,
Int64  Value 
)

UpdateNull ( const Integer  Index,
boolean  Value 
)

UpdatePChar ( const Integer  Index,
PChar  Value 
)

UpdateShort ( const Integer  Index,
SmallInt  Value 
)

UpdateString ( const Integer  Index,
string  Value 
)

UpdateTime ( const Integer  Index,
TDateTime  Value 
)

UpdateTimestamp ( const Integer  Index,
TDateTime  Value 
)

UpdateValue ( const Word  Index,
Variant  Value 
)

WriteBlob ( const Integer  Index,
TStream  Stream 
)


Variable Documentation

const BlockSize = 20

Definition at line 68 of file ZDbcASAUtils.pas.

const MinBLOBSize = 256

Definition at line 67 of file ZDbcASAUtils.pas.

const StdVars = 20

Definition at line 66 of file ZDbcASAUtils.pas.


Generated on Wed Dec 30 08:42:41 2009 for zeoslib by  doxygen 1.5.7.1