component/ZDatasetUtils.pas File Reference

Go to the source code of this file.

Functions

Boolean CompareDataFields (const TZVariantDynArray KeyValues, const TZVariantDynArray RowValues, Boolean PartialKey, Boolean CaseInsensitive)
 Compares row field values with the given ones.
Boolean CompareFieldsFromResultSet (const TObjectDynArray FieldRefs, const TZVariantDynArray KeyValues, IZResultSet ResultSet, Boolean PartialKey, Boolean CaseInsensitive)
 Compares row field values with the given ones.
Boolean CompareKeyFields (TField Field1, IZResultSet ResultSet, TField Field2)
 Compare values from two key fields.
TZSQLType ConvertDatasetToDbcType (TFieldType Value)
 Converts TDataset Field Type to DBC Field Type.
TFieldType ConvertDbcToDatasetType (TZSQLType Value)
 Converts DBC Field Type to TDataset Field Type.
TObjectList ConvertFieldsToColumnInfo (TFields Fields)
 Converts field definitions into column information objects.
 CopyDataFieldsToVars (const TObjectDynArray Fields, IZResultSet ResultSet, IZVariablesList Variables)
 Copy a set of specified field values to variables.
TIntegerDynArray CreateFieldsLookupTable (TFields Fields)
 Creates a fields lookup table to define fixed position of the field in dataset.
 DateTimeToNative (TFieldType DataType, TDateTime Data, Pointer Buffer)
 Converts datetime value into TDataset internal presentation.
Integer DefineFieldIndex (const TIntegerDynArray FieldsLookupTable, TField Field)
 Defines an original field index in the dataset.
TIntegerDynArray DefineFieldIndices (const TIntegerDynArray FieldsLookupTable, const TObjectDynArray FieldRefs)
 Defines an original field indices in the dataset.
TObjectDynArray DefineFields (TDataset DataSet, const string FieldNames, Boolean &OnlyDataFields)
 Defines fields indices for the specified dataset.
TObjectDynArray DefineFilterFields (TDataset DataSet, IZExpression Expression)
 Defins a indices of filter fields.
string DefineKeyFields (TFields Fields)
 Defines a list of key field names.
 DefineSortedFields (TDataset DataSet, const string SortedFields, TObjectDynArray &FieldRefs, TBooleanDynArray &FieldDirs, Boolean &OnlyDataFields)
 Defins a indices and directions for sorted fields.
 FetchFromResultSet (IZResultSet ResultSet, const TIntegerDynArray FieldsLookupTable, TFields Fields, TZRowAccessor RowAccessor)
 Fetches columns from specified resultset.
TDateTime NativeToDateTime (TFieldType DataType, Pointer Buffer)
 Converts date times from TDataset internal presentation into datetime value.
 PostToResultSet (IZResultSet ResultSet, const TIntegerDynArray FieldsLookupTable, TFields Fields, TZRowAccessor RowAccessor)
 Posts columns from specified resultset.
 PrepareValuesForComparison (const TObjectDynArray FieldRefs, TZVariantDynArray &DecodedKeyValues, IZResultSet ResultSet, Boolean PartialKey, Boolean CaseInsensitive)
 Prepares values for comparison by CompareFieldsFromResultSet.
 RetrieveDataFieldsFromResultSet (const TObjectDynArray FieldRefs, IZResultSet ResultSet, TZVariantDynArray &ResultValues)
 Retrieves a set of specified field values.
 RetrieveDataFieldsFromRowAccessor (const TObjectDynArray FieldRefs, const TIntegerDynArray FieldIndices, TZRowAccessor RowAccessor, TZVariantDynArray &ResultValues)
 Retrieves a set of specified field values.
 SplitQualifiedObjectName (string QualifiedName, string &Catalog, string &Schema, string &ObjectName)
 Splits up a qualified object name into pieces.

Variables

const IZTokenizer CommonTokenizer
 Common variables.


Function Documentation

Boolean CompareDataFields ( const TZVariantDynArray  KeyValues,
const TZVariantDynArray  RowValues,
Boolean  PartialKey,
Boolean  CaseInsensitive 
)

Compares row field values with the given ones.

Parameters:
KeyValues given values.
RowValues row field values.
PartialKey True if values should be started with the keys.
CaseInsensitive True if keys are case insensitive.
Returns:
if values are equal.

Definition at line 946 of file ZDatasetUtils.pas.

Boolean CompareFieldsFromResultSet ( const TObjectDynArray  FieldRefs,
const TZVariantDynArray  KeyValues,
IZResultSet  ResultSet,
Boolean  PartialKey,
Boolean  CaseInsensitive 
)

Compares row field values with the given ones.

Parameters:
FieldRefs an array with interested field object references.
KeyValues given values.
RowValues row field values.
PartialKey True if values should be started with the keys.
CaseInsensitive True if keys are case insensitive.
Returns:
if values are equal.
Parameters:
FieldRefs an array with interested field object references.
KeyValues given values.
ResultSet  a resultset to get field values.
PartialKey True if values should be started with the keys.
CaseInsensitive True if keys are case insensitive.
Returns:
if values are equal.

Definition at line 1093 of file ZDatasetUtils.pas.

Referenced by RetrieveDataFieldsFromRowAccessor().

Boolean CompareKeyFields ( TField  Field1,
IZResultSet  ResultSet,
TField  Field2 
)

Compare values from two key fields.

Parameters:
Field1 the first field object.
ResultSet the resultset to read the first field value.
Field2 the second field object.

TZSQLType ConvertDatasetToDbcType ( TFieldType  Value  ) 

Converts TDataset Field Type to DBC Field Type.

Parameters:
Value an initial TDataset field type.
Returns:
a converted DBC field type.

!!I do not know if it is a stUnicodeString or stUnicodeStream

Definition at line 422 of file ZDatasetUtils.pas.

TFieldType ConvertDbcToDatasetType ( TZSQLType  Value  ) 

Converts DBC Field Type to TDataset Field Type.

Parameters:
Value an initial DBC field type.
Returns:
a converted TDataset field type.

Definition at line 378 of file ZDatasetUtils.pas.

TObjectList ConvertFieldsToColumnInfo ( TFields  Fields  ) 

Converts field definitions into column information objects.

Parameters:
Fields a collection of field definitions.
Returns:
a collection of column information objects.

Definition at line 468 of file ZDatasetUtils.pas.

CopyDataFieldsToVars ( const TObjectDynArray  Fields,
IZResultSet  ResultSet,
IZVariablesList  Variables 
)

Copy a set of specified field values to variables.

Parameters:
Fields an array with interested field object references.
ResultSet an initial result set object.
Variables a list of variables.

Definition at line 888 of file ZDatasetUtils.pas.

TIntegerDynArray CreateFieldsLookupTable ( TFields  Fields  ) 

Creates a fields lookup table to define fixed position of the field in dataset.

Parameters:
Fields a collection of TDataset fields in initial order.
Returns:
a fields lookup table.

DateTimeToNative ( TFieldType  DataType,
TDateTime  Data,
Pointer  Buffer 
)

Converts datetime value into TDataset internal presentation.

Parameters:
DataType a type of date-time field.
Data a data which contains a value.
Buffer a field buffer pointer

Definition at line 1224 of file ZDatasetUtils.pas.

Integer DefineFieldIndex ( const TIntegerDynArray  FieldsLookupTable,
TField  Field 
)

Defines an original field index in the dataset.

Parameters:
FieldsLookupTable a lookup table to define original index.
Field a TDataset field object.
Returns:
an original fields index or -1 otherwise.

TIntegerDynArray DefineFieldIndices ( const TIntegerDynArray  FieldsLookupTable,
const TObjectDynArray  FieldRefs 
)

Defines an original field indices in the dataset.

Parameters:
FieldsLookupTable a lookup table to define original index.
FieldRefs a TDataset field object references.
Returns:
an array with original fields indices.

TObjectDynArray DefineFields ( TDataset  DataSet,
const string  FieldNames,
Boolean &  OnlyDataFields 
)

Defines fields indices for the specified dataset.

Parameters:
DataSet a dataset object.
FieldNames a list of field names.
OnlyDataFields True if only data fields selected.

Definition at line 674 of file ZDatasetUtils.pas.

TObjectDynArray DefineFilterFields ( TDataset  DataSet,
IZExpression  Expression 
)

Defins a indices of filter fields.

Parameters:
Dataset a dataset object.
Expression a expression calculator.
Returns:
an array with field object references.

Definition at line 736 of file ZDatasetUtils.pas.

string DefineKeyFields ( TFields  Fields  ) 

Defines a list of key field names.

Parameters:
Fields a collection of dataset fields.
Returns:
a list of key field names.

Definition at line 1192 of file ZDatasetUtils.pas.

DefineSortedFields ( TDataset  DataSet,
const string  SortedFields,
TObjectDynArray FieldRefs,
TBooleanDynArray &  FieldDirs,
Boolean &  OnlyDataFields 
)

Defins a indices and directions for sorted fields.

Parameters:
Dataset a dataset object.
SortedFields an encoded fields for sorting in the format <Field name>=""> [ASC | DESC] [, ...]
FieldRefs a decoded field object references.
FieldDirs a decoded field directions.
OnlyDataFields True if only data fields selected.

FetchFromResultSet ( IZResultSet  ResultSet,
const TIntegerDynArray  FieldsLookupTable,
TFields  Fields,
TZRowAccessor  RowAccessor 
)

Fetches columns from specified resultset.

Parameters:
ResultSet a source resultset.
FieldsLookupTable a lookup table to define original index.
Fields a collection of field definitions.
RowAccessor a destination row accessor.

Definition at line 508 of file ZDatasetUtils.pas.

TDateTime NativeToDateTime ( TFieldType  DataType,
Pointer  Buffer 
)

Converts date times from TDataset internal presentation into datetime value.

Parameters:
DataType a type of date-time field.
Buffer a field buffer pointer
Returns:
a data which contains a value.

Compare values from two key fields.

Parameters:
Field1 the first field object.
ResultSet the resultset to read the first field value.
Field2 the second field object.
Defins a indices and directions for sorted fields.
Parameters:
Dataset a dataset object.
SortedFields an encoded fields for sorting in the format <Field name>=""> [ASC | DESC] [, ...]
FieldRefs a decoded field object references.
FieldDirs a decoded field directions.
OnlyDataFields True if only data fields selected.
Creates a fields lookup table to define fixed position of the field in dataset.
Parameters:
Fields a collection of TDataset fields in initial order.
Returns:
a fields lookup table.
Defines an original field index in the dataset.
Parameters:
FieldsLookupTable a lookup table to define original index.
Field a TDataset field object.
Returns:
an original fields index or -1 otherwise.
Defines an original field indices in the dataset.
Parameters:
FieldsLookupTable a lookup table to define original index.
FieldRefs a TDataset field object references.
Returns:
an array with original fields indices.
Splits up a qualified object name into pieces. Catalog, schema and objectname.

Definition at line 1255 of file ZDatasetUtils.pas.

PostToResultSet ( IZResultSet  ResultSet,
const TIntegerDynArray  FieldsLookupTable,
TFields  Fields,
TZRowAccessor  RowAccessor 
)

Posts columns from specified resultset.

Parameters:
ResultSet a source resultset.
FieldsLookupTable a lookup table to define original index.
Fields a collection of field definitions.
RowAccessor a destination row accessor.

Definition at line 580 of file ZDatasetUtils.pas.

PrepareValuesForComparison ( const TObjectDynArray  FieldRefs,
TZVariantDynArray DecodedKeyValues,
IZResultSet  ResultSet,
Boolean  PartialKey,
Boolean  CaseInsensitive 
)

Prepares values for comparison by CompareFieldsFromResultSet.

Parameters:
FieldRefs an array with interested field object references.
DecodedKeyValues given values.
ResultSet a resultset to get field values.
PartialKey True if values should be started with the keys.
CaseInsensitive True if keys are case insensitive.

Definition at line 990 of file ZDatasetUtils.pas.

RetrieveDataFieldsFromResultSet ( const TObjectDynArray  FieldRefs,
IZResultSet  ResultSet,
TZVariantDynArray ResultValues 
)

Retrieves a set of specified field values.

Parameters:
FieldRefs an array with interested field object references.
ResultSet an initial result set object.
ResultValues a container for result values.
Returns:
an array with field values.

Definition at line 768 of file ZDatasetUtils.pas.

RetrieveDataFieldsFromRowAccessor ( const TObjectDynArray  FieldRefs,
const TIntegerDynArray  FieldIndices,
TZRowAccessor  RowAccessor,
TZVariantDynArray ResultValues 
)

Retrieves a set of specified field values.

Parameters:
FieldRefs an array with interested field object references.
FieldIndices an array with interested field indices.
RowAccessor a row accessor object.
ResultValues a container for result values.
Returns:
an array with field values.

Definition at line 827 of file ZDatasetUtils.pas.

References CompareFieldsFromResultSet().

SplitQualifiedObjectName ( string  QualifiedName,
string &  Catalog,
string &  Schema,
string &  ObjectName 
)

Splits up a qualified object name into pieces.

Catalog, schema and objectname.


Variable Documentation

Common variables.

Definition at line 363 of file ZDatasetUtils.pas.


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