TZDBLibCachedResolver Class Reference

Implements a cached resolver with mssql and sybase specific functionality. More...

Inheritance diagram for TZDBLibCachedResolver:

TZGenericCachedResolver IZCachedResolver TInterfacedObject IZCachedResolver

List of all members.

Public Member Functions

 CalculateDefaults (IZCachedResultSet Sender, TZRowAccessor RowAccessor)
 Calculate default values for the fields.
string FormCalculateStatement (TObjectList Columns)
 Forms a where clause for SELECT statements to calculate default values.
string FormDeleteStatement (TObjectList Columns, TZRowAccessor OldRowAccessor)
 Forms a where clause for DELETE statements.
string FormInsertStatement (TObjectList Columns, TZRowAccessor NewRowAccessor)
 Forms a where clause for INSERT statements.
string FormUpdateStatement (TObjectList Columns, TZRowAccessor OldRowAccessor, TZRowAccessor NewRowAccessor)
 Forms a where clause for UPDATE statements.
string FormWhereClause (TObjectList Columns, TZRowAccessor OldRowAccessor)
 Forms a where clause for UPDATE or DELETE DML statements.
 PostUpdates (IZCachedResultSet Sender, TZRowUpdateType UpdateType, TZRowAccessor OldRowAccessor, TZRowAccessor NewRowAccessor)
 Posts updates to database.
 TZDBLibCachedResolver (IZStatement Statement, IZResultSetMetadata Metadata)
 Creates a DBLib specific cached resolver object.
 UpdateAutoIncrementFields (IZCachedResultSet Sender, TZRowUpdateType UpdateType, TZRowAccessor OldRowAccessor, TZRowAccessor NewRowAccessor, IZCachedResolver Resolver)

Protected Member Functions

Boolean CheckKeyColumn (Integer ColumnIndex)
 Checks is the specified column can be used in where clause.
string ComposeFullTableName (string Catalog, string Schema, string Table)
 Composes a fully quilified table name.
 CopyResolveParameters (TObjectList FromList, TObjectList ToList)
 Copies resolver parameters from source list to destination list.
 DefineCalcColumns (TObjectList Columns, TZRowAccessor RowAccessor)
 Gets a collection of data columns to initialize before INSERT statements.
 DefineInsertColumns (TObjectList Columns)
 Gets a collection of data columns for INSERT statements.
string DefineTableName ()
 Defines a table name from the select statement.
 DefineUpdateColumns (TObjectList Columns, TZRowAccessor OldRowAccessor, TZRowAccessor NewRowAccessor)
 Gets a collection of data columns for UPDATE statements.
 DefineWhereAllColumns (TObjectList Columns)
 Gets a collection of where all columns for DELETE or UPDATE DML statements.
 DefineWhereKeyColumns (TObjectList Columns)
 Gets a collection of where key columns for DELETE or UPDATE DML statements.
 FillStatement (IZPreparedStatement Statement, TObjectList Params, TZRowAccessor OldRowAccessor, TZRowAccessor NewRowAccessor)
 Fills the specified statement with stored or given parameters.

Protected Attributes

Boolean CalcDefaults
IZConnection Connection
IZDatabaseMetadata DatabaseMetadata
IZIdentifierConvertor IdentifierConvertor
TObjectList InsertColumns
IZResultSetMetadata Metadata
Boolean UpdateAll
TObjectList UpdateColumns
Boolean WhereAll
TObjectList WhereColumns

Private Attributes

Integer FAutoColumnIndex


Detailed Description

Implements a cached resolver with mssql and sybase specific functionality.

Definition at line 183 of file ZDbcDbLibResultSet.pas.


Constructor & Destructor Documentation

TZDBLibCachedResolver::TZDBLibCachedResolver ( IZStatement  Statement,
IZResultSetMetadata  Metadata 
)

Creates a DBLib specific cached resolver object.

Parameters:
PlainDriver a native DBLib plain driver.
Handle a DBLib specific query handle.
Statement a related SQL statement object.
Metadata a resultset metadata reference.

Definition at line 941 of file ZDbcDbLibResultSet.pas.


Member Function Documentation

TZGenericCachedResolver::CalculateDefaults ( IZCachedResultSet  Sender,
TZRowAccessor  RowAccessor 
) [inherited]

Calculate default values for the fields.

Parameters:
Sender a cached result set object.
RowAccessor an accessor object to column values.

Reimplemented from IZCachedResolver.

Definition at line 999 of file ZDbcGenericResolver.pas.

Boolean TZGenericCachedResolver::CheckKeyColumn ( Integer  ColumnIndex  )  [protected, inherited]

Checks is the specified column can be used in where clause.

Parameters:
ColumnIndex an index of the column.
Returns:
true if column can be included into where clause.

Reimplemented in TZPostgreSQLCachedResolver.

Definition at line 626 of file ZDbcGenericResolver.pas.

string TZGenericCachedResolver::ComposeFullTableName ( string  Catalog,
string  Schema,
string  Table 
) [protected, inherited]

Composes a fully quilified table name.

Parameters:
Catalog a table catalog name.
Schema a table schema name.
Table a table name.
Returns:
a fully qualified table name.

Definition at line 409 of file ZDbcGenericResolver.pas.

TZGenericCachedResolver::CopyResolveParameters ( TObjectList  FromList,
TObjectList  ToList 
) [protected, inherited]

Copies resolver parameters from source list to destination list.

Parameters:
FromList the source object list.
ToList the destination object list.

Definition at line 380 of file ZDbcGenericResolver.pas.

TZGenericCachedResolver::DefineCalcColumns ( TObjectList  Columns,
TZRowAccessor  RowAccessor 
) [protected, inherited]

Gets a collection of data columns to initialize before INSERT statements.

Parameters:
Columns a collection of columns.
RowAccessor an accessor object to column values.

Definition at line 644 of file ZDbcGenericResolver.pas.

TZGenericCachedResolver::DefineInsertColumns ( TObjectList  Columns  )  [protected, inherited]

Gets a collection of data columns for INSERT statements.

Parameters:
Columns a collection of columns.

Definition at line 458 of file ZDbcGenericResolver.pas.

string TZGenericCachedResolver::DefineTableName (  )  [protected, inherited]

Defines a table name from the select statement.

Definition at line 429 of file ZDbcGenericResolver.pas.

TZGenericCachedResolver::DefineUpdateColumns ( TObjectList  Columns,
TZRowAccessor  OldRowAccessor,
TZRowAccessor  NewRowAccessor 
) [protected, inherited]

Gets a collection of data columns for UPDATE statements.

Parameters:
Columns a collection of columns.
OldRowAccessor an accessor object to old column values.
NewRowAccessor an accessor object to new column values.

Definition at line 488 of file ZDbcGenericResolver.pas.

TZGenericCachedResolver::DefineWhereAllColumns ( TObjectList  Columns  )  [protected, inherited]

Gets a collection of where all columns for DELETE or UPDATE DML statements.

Parameters:
Columns a collection of key columns.

Definition at line 593 of file ZDbcGenericResolver.pas.

TZGenericCachedResolver::DefineWhereKeyColumns ( TObjectList  Columns  )  [protected, inherited]

Gets a collection of where key columns for DELETE or UPDATE DML statements.

Parameters:
Columns a collection of key columns.

Definition at line 536 of file ZDbcGenericResolver.pas.

TZGenericCachedResolver::FillStatement ( IZPreparedStatement  Statement,
TObjectList  Params,
TZRowAccessor  OldRowAccessor,
TZRowAccessor  NewRowAccessor 
) [protected, inherited]

Fills the specified statement with stored or given parameters.

Parameters:
ResultSet a source result set object.
Statement a DBC statement object.
Config an UpdateStatement configuration.
OldRowAccessor an accessor object to old column values.
NewRowAccessor an accessor object to new column values.

Definition at line 674 of file ZDbcGenericResolver.pas.

string TZGenericCachedResolver::FormCalculateStatement ( TObjectList  Columns  )  [inherited]

Forms a where clause for SELECT statements to calculate default values.

Parameters:
Columns a collection of key columns.
OldRowAccessor an accessor object to old column values.

Reimplemented in TZASACachedResolver, TZInterbase6CachedResolver, TZMySQLCachedResolver, TZOracleCachedResolver, and TZSQLiteCachedResolver.

Definition at line 906 of file ZDbcGenericResolver.pas.

string TZGenericCachedResolver::FormDeleteStatement ( TObjectList  Columns,
TZRowAccessor  OldRowAccessor 
) [inherited]

Forms a where clause for DELETE statements.

Parameters:
Columns a collection of key columns.
OldRowAccessor an accessor object to old column values.

Definition at line 881 of file ZDbcGenericResolver.pas.

string TZGenericCachedResolver::FormInsertStatement ( TObjectList  Columns,
TZRowAccessor  NewRowAccessor 
) [inherited]

Forms a where clause for INSERT statements.

Parameters:
Columns a collection of key columns.
NewRowAccessor an accessor object to new column values.

Definition at line 797 of file ZDbcGenericResolver.pas.

string TZGenericCachedResolver::FormUpdateStatement ( TObjectList  Columns,
TZRowAccessor  OldRowAccessor,
TZRowAccessor  NewRowAccessor 
) [inherited]

Forms a where clause for UPDATE statements.

Parameters:
Columns a collection of key columns.
OldRowAccessor an accessor object to old column values.
NewRowAccessor an accessor object to new column values.

Definition at line 840 of file ZDbcGenericResolver.pas.

string TZGenericCachedResolver::FormWhereClause ( TObjectList  Columns,
TZRowAccessor  OldRowAccessor 
) [inherited]

Forms a where clause for UPDATE or DELETE DML statements.

Parameters:
Columns a collection of key columns.
OldRowAccessor an accessor object to old column values.

Definition at line 758 of file ZDbcGenericResolver.pas.

TZDBLibCachedResolver::PostUpdates ( IZCachedResultSet  Sender,
TZRowUpdateType  UpdateType,
TZRowAccessor  OldRowAccessor,
TZRowAccessor  NewRowAccessor 
)

Posts updates to database.

Parameters:
Sender a cached result set object.
UpdateType a type of updates.
OldRowAccessor an accessor object to old column values.
NewRowAccessor an accessor object to new column values.

Reimplemented from IZCachedResolver.

Definition at line 961 of file ZDbcDbLibResultSet.pas.

TZGenericCachedResolver::UpdateAutoIncrementFields ( IZCachedResultSet  Sender,
TZRowUpdateType  UpdateType,
TZRowAccessor  OldRowAccessor,
TZRowAccessor  NewRowAccessor,
IZCachedResolver  Resolver 
) [inherited]

Reimplemented from IZCachedResolver.

Reimplemented in TZMySQLCachedResolver.

Definition at line 1089 of file ZDbcGenericResolver.pas.


Member Data Documentation

Boolean TZGenericCachedResolver::CalcDefaults [protected, inherited]

See also:
FCalcDefaults For reading

FCalcDefaults For writing

Definition at line 224 of file ZDbcGenericResolver.pas.

See also:
FConnection For reading

FConnection For writing

Definition at line 199 of file ZDbcGenericResolver.pas.

See also:
FDatabaseMetadata For reading

FDatabaseMetadata For writing

Definition at line 206 of file ZDbcGenericResolver.pas.

Definition at line 188 of file ZDbcDbLibResultSet.pas.

See also:
FIdentifierConvertor For reading

FIdentifierConvertor For writing

Definition at line 210 of file ZDbcGenericResolver.pas.

TObjectList TZGenericCachedResolver::InsertColumns [protected, inherited]

See also:
FInsertColumns For reading

Definition at line 214 of file ZDbcGenericResolver.pas.

See also:
FMetadata For reading

FMetadata For writing

Definition at line 202 of file ZDbcGenericResolver.pas.

Boolean TZGenericCachedResolver::UpdateAll [protected, inherited]

See also:
FUpdateAll For reading

FUpdateAll For writing

Definition at line 230 of file ZDbcGenericResolver.pas.

TObjectList TZGenericCachedResolver::UpdateColumns [protected, inherited]

See also:
FUpdateColumns For reading

Definition at line 217 of file ZDbcGenericResolver.pas.

Boolean TZGenericCachedResolver::WhereAll [protected, inherited]

See also:
FWhereAll For reading

FWhereAll For writing

Definition at line 227 of file ZDbcGenericResolver.pas.

TObjectList TZGenericCachedResolver::WhereColumns [protected, inherited]

See also:
FWhereColumns For reading

Definition at line 220 of file ZDbcGenericResolver.pas.


The documentation for this class was generated from the following file:

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