dbc/ZDbcMetadata.pas File Reference

Go to the source code of this file.

Classes

class  TZAbstractDatabaseMetadata
 Implements Abstract Database Metadata. More...
class  TZDefaultIdentifierConvertor
 Implements a default Case Sensitive/Unsensitive identifier convertor. More...
struct  TZMetadataColumnDef
 Defines a metadata resultset column definition. More...
class  TZVirtualResultSet
 Implements Virtual ResultSet. More...

Typedefs

typedef set< Char > TZWildcardsSet

Functions

String GetTablesMetaDataCacheKey (const String Catalog, const String SchemaPattern, const String TableNamePattern, const TStringDynArray Types)
 rerurns cache key for get tables metadata entry
 SetLength (TypeInfoColumnsDynArray, TypeInfoColumnCount)
 SetLength (CrossRefColumnsDynArray, CrossRefColumnCount)
 SetLength (edKeyColumnsDynArray, edKeyColumnCount)
 SetLength (ImportedKeyColumnsDynArray, ImportedKeyColumnCount)
 SetLength (PrimaryKeyColumnsDynArray, PrimaryKeyColumnCount)
 SetLength (TableColVerColumnsDynArray, TableColVerColumnCount)
 SetLength (BestRowIdentColumnsDynArray, BestRowIdentColumnCount)
 SetLength (TablePrivColumnsDynArray, TablePrivColumnCount)
 SetLength (TableColPrivColumnsDynArray, TableColPrivColumnCount)
 SetLength (TableColColumnsDynArray, TableColColumnCount)
 SetLength (TableTypeColumnsDynArray, TableTypeColumnCount)
 SetLength (CatalogColumnsDynArray, CatalogColumnCount)
 SetLength (SchemaColumnsDynArray, SchemaColumnCount)
Boolean SupportsDataDefinitionAndDataManipulationTransactions ()
 Are both data definition and data manipulation statements within a transaction supported?
Boolean SupportsDataManipulationTransactionsOnly ()
 Are only data manipulation statements within a transaction supported?

Variables

 __pad0__
IndexInfoColumnsDynArray __pad1__
SequenceColumnsDynArray __pad2__
UDTColumnsDynArray __pad3__
const TZMetadataColumnDefs BestRowIdentColumnsDynArray
const TZMetadataColumnDefs CatalogColumnsDynArray
const TZMetadataColumnDefs CrossRefColumnsDynArray
 deprecated
const TZMetadataColumnDefs ExportedKeyColumnsDynArray
TZMetadataColumnDef(PROCEDURE_CAT
Name, stString SQLType,
PROCEDURE_SCHEM Length,
stString SQLType,
PROCEDURE_NAME Length,
stString SQLType, RESERVED1
Length, stString SQLType,
RESERVED2 Length, stString
SQLType, RESERVED3 Length,
stString SQLType, REMARKS
Length, stString SQLType,
PROCEDURE_TYPE Length, stShort
SQLType,
ProceduresColColumnCount
Length=13,
ProceduresColColumns=Name,
ProceduresColColumnCount=Name,
TZMetadataColumnDef=Name,
stString SQLType,
PROCEDURE_SCHEM Length,
stString SQLType,
PROCEDURE_NAME Length,
stString SQLType, COLUMN_NAME
Length, stString SQLType,
COLUMN_TYPE Length, stShort
SQLType, DATA_TYPE Length,
stShort SQLType, TYPE_NAME
Length, stString SQLType,
PRECISION Length, stInteger
SQLType, LENGTH Length,
stInteger SQLType, SCALE
Length, stShort SQLType, RADIX
Length, stShort SQLType,
NULLABLE Length, stShort
SQLType, REMARKS Length,
stString SQLType,
TableColumnCount Length=5,
TableColumns=Name,
TableColumnCount=Name,
TZMetadataColumnDef=Name,
stString SQLType, TABLE_SCHEM
Length, stString SQLType,
TABLE_NAME Length, stString
SQLType, TABLE_TYPE Length,
stString SQLType, REMARKS
Length, stString SQLType,
SchemaColumnCount Length=1,
SchemaColumns=Name,
SchemaColumnCount=Name,
TZMetadataColumnDef=Name,
stString SQLType,
CatalogColumnCount Length=1,
CatalogColumns=Name,
CatalogColumnCount=Name,
TZMetadataColumnDef=Name,
stString SQLType,
TableTypeColumnCount Length=1,
TableTypeColumns=Name,
TableTypeColumnCount=Name,
TZMetadataColumnDef=Name,
stString SQLType,
TableColColumnCount Length=24,
TableColColumns=Name,
TableColColumnCount=Name,
TZMetadataColumnDef=Name,
stString SQLType, TABLE_SCHEM
Length, stString SQLType,
TABLE_NAME Length, stString
SQLType, COLUMN_NAME Length,
stString SQLType, DATA_TYPE
Length, stShort SQLType,
TYPE_NAME Length, stString
SQLType, COLUMN_SIZE Length,
stInteger SQLType,
BUFFER_LENGTH Length,
stInteger SQLType,
DECIMAL_DIGITS Length,
stInteger SQLType,
NUM_PREC_RADIX Length,
stInteger SQLType, NULLABLE
Length, stInteger SQLType,
REMARKS Length, stString
SQLType, COLUMN_DEF Length,
stString SQLType,
SQL_DATA_TYPE Length,
stInteger SQLType,
SQL_DATETIME_SUB Length,
stInteger SQLType,
CHAR_OCTET_LENGTH Length,
stInteger SQLType,
ORDINAL_POSITION Length,
stInteger SQLType, IS_NULLABLE
Length, stString SQLType,
AUTO_INCREMENT Length,
stBoolean SQLType,
CASE_SENSITIVE Length,
stBoolean SQLType, SEARCHABLE
Length, stBoolean SQLType,
WRITABLE Length, stBoolean
SQLType, DEFINITELYWRITABLE
Length, stBoolean SQLType,
READONLY Length, stBoolean
SQLType,
TableColPrivColumnCount Length=8,
TableColPrivColumns=Name,
TableColPrivColumnCount=Name,
TZMetadataColumnDef=Name,
stString SQLType, TABLE_SCHEM
Length, stString SQLType,
TABLE_NAME Length, stString
SQLType, COLUMN_NAME Length,
stString SQLType, GRANTOR
Length, stString SQLType,
GRANTEE Length, stString
SQLType, PRIVILEGE Length,
stString SQLType, IS_GRANTABLE
Length, stString SQLType,
TablePrivColumnCount Length=7,
TablePrivColumns=Name,
TablePrivColumnCount=Name,
TZMetadataColumnDef=Name,
stString SQLType, TABLE_SCHEM
Length, stString SQLType,
TABLE_NAME Length, stString
SQLType, GRANTOR Length,
stString SQLType, GRANTEE
Length, stString SQLType,
PRIVILEGE Length, stString
SQLType, IS_GRANTABLE Length,
stString SQLType,
BestRowIdentColumnCount Length=8,
BestRowIdentColumns=Name,
BestRowIdentColumnCount=Name,
TZMetadataColumnDef=Name,
stShort SQLType, COLUMN_NAME
Length, stString SQLType,
DATA_TYPE Length, stShort
SQLType, TYPE_NAME Length,
stString SQLType, COLUMN_SIZE
Length, stInteger SQLType,
BUFFER_LENGTH Length,
stInteger SQLType,
DECIMAL_DIGITS Length, stShort
SQLType, PSEUDO_COLUMN Length,
stShort SQLType,
TableColVerColumnCount Length=8,
TableColVerColumns=Name,
TableColVerColumnCount=Name,
TZMetadataColumnDef=Name,
stShort SQLType, COLUMN_NAME
Length, stString SQLType,
DATA_TYPE Length, stShort
SQLType, TYPE_NAME Length,
stString SQLType, COLUMN_SIZE
Length, stInteger SQLType,
BUFFER_LENGTH Length,
stInteger SQLType,
DECIMAL_DIGITS Length, stShort
SQLType, PSEUDO_COLUMN Length,
stShort SQLType,
PrimaryKeyColumnCount Length=6,
PrimaryKeyColumns=Name,
PrimaryKeyColumnCount=Name,
TZMetadataColumnDef=Name,
stString SQLType, TABLE_SCHEM
Length, stString SQLType,
TABLE_NAME Length, stString
SQLType, COLUMN_NAME Length,
stString SQLType, KEY_SEQ
Length, stShort SQLType,
PK_NAME Length, stString
SQLType,
ImportedKeyColumnCount Length=14,
ImportedKeyColumns=Name,
ImportedKeyColumnCount=Name,
TZMetadataColumnDef=Name,
stString SQLType,
PKTABLE_SCHEM Length, stString
SQLType, PKTABLE_NAME Length,
stString SQLType,
PKCOLUMN_NAME Length, stString
SQLType, FKTABLE_CAT Length,
stString SQLType,
FKTABLE_SCHEM Length, stString
SQLType, FKTABLE_NAME Length,
stString SQLType,
FKCOLUMN_NAME Length, stString
SQLType, KEY_SEQ Length,
stShort SQLType, UPDATE_RULE
Length, stShort SQLType,
DELETE_RULE Length, stShort
SQLType, FK_NAME Length,
stString SQLType, PK_NAME
Length, stString SQLType,
DEFERRABILITY Length, stShort
SQLType,
ExportedKeyColumnCount Length=14,
ExportedKeyColumns=Name,
ExportedKeyColumnCount=Name,
TZMetadataColumnDef=Name,
stString SQLType,
PKTABLE_SCHEM Length, stString
SQLType, PKTABLE_NAME Length,
stString SQLType,
PKCOLUMN_NAME Length, stString
SQLType, FKTABLE_CAT Length,
stString SQLType,
FKTABLE_SCHEM Length, stString
SQLType, FKTABLE_NAME Length,
stString SQLType,
FKCOLUMN_NAME Length, stString
SQLType, KEY_SEQ Length,
stShort SQLType, UPDATE_RULE
Length, stShort SQLType,
DELETE_RULE Length, stShort
SQLType, FK_NAME Length,
stString SQLType, PK_NAME
Length, stString SQLType,
DEFERRABILITY Length, stShort
SQLType, CrossRefColumnCount
Length=14, CrossRefColumns=Name,
CrossRefColumnCount=Name,
TZMetadataColumnDef=Name,
stString SQLType,
PKTABLE_SCHEM Length, stString
SQLType, PKTABLE_NAME Length,
stString SQLType,
PKCOLUMN_NAME Length, stString
SQLType, FKTABLE_CAT Length,
stString SQLType,
FKTABLE_SCHEM Length, stString
SQLType, FKTABLE_NAME Length,
stString SQLType,
FKCOLUMN_NAME Length, stString
SQLType, KEY_SEQ Length,
stShort SQLType, UPDATE_RULE
Length, stShort SQLType,
DELETE_RULE Length, stShort
SQLType, FK_NAME Length,
stString SQLType, PK_NAME
Length, stString SQLType,
DEFERRABILITY Length, stShort
SQLType, TypeInfoColumnCount
Length=18, TypeInfoColumns=Name,
TypeInfoColumnCount=Name,
TZMetadataColumnDef=Name,
stString SQLType, DATA_TYPE
Length, stShort SQLType,
PRECISION Length, stInteger
SQLType, LITERAL_PREFIX Length,
stString SQLType,
LITERAL_SUFFIX Length,
stString SQLType,
CREATE_PARAMS Length, stString
SQLType, NULLABLE Length,
stShort SQLType,
CASE_SENSITIVE Length,
stBoolean SQLType, SEARCHABLE
Length, stShort SQLType,
UNSIGNED_ATTRIBUTE Length,
stBoolean SQLType,
FIXED_PREC_SCALE Length,
stBoolean SQLType,
AUTO_INCREMENT Length,
stBoolean SQLType,
LOCAL_TYPE_NAME Length,
stString SQLType,
MINIMUM_SCALE Length, stShort
SQLType, MAXIMUM_SCALE Length,
stShort SQLType, SQL_DATA_TYPE
Length, stInteger SQLType,
SQL_DATETIME_SUB Length,
stInteger SQLType,
NUM_PREC_RADIX Length,
stInteger SQLType,
IndexInfoColumnCount Length=13,
IndexInfoColumns=Name,
IndexInfoColumnCount=Name,
TZMetadataColumnDef=Name,
stString SQLType, TABLE_SCHEM
Length, stString SQLType,
TABLE_NAME Length, stString
SQLType, NON_UNIQUE Length,
stBoolean SQLType,
INDEX_QUALIFIER Length,
stString SQLType, INDEX_NAME
Length, stString SQLType, TYPE
Length, stShort SQLType,
ORDINAL_POSITION Length,
stShort SQLType, COLUMN_NAME
Length, stString SQLType,
ASC_OR_DESC Length, stString
SQLType, CARDINALITY Length,
stInteger SQLType, PAGES
Length, stInteger SQLType,
FILTER_CONDITION Length,
stString SQLType,
SequenceColumnCount Length=3,
SequenceColumns=Name,
SequenceColumnCount=Name,
TZMetadataColumnDef=Name,
stString SQLType,
SEQUENCE_SCHEM Length,
stString SQLType,
SEQUENCE_NAME Length, stString
SQLType, UDTColumnCount Length=6,
UDTColumns=Name,
UDTColumnCount=Name,
TZMetadataColumnDef=Name,
stString SQLType, TYPE_SCHEM
Length, stString SQLType,
TYPE_NAME Length, stString
SQLType, CLASS_NAME Length,
stString SQLType, DATA_TYPE
Length, stShort SQLType,
REMARKS Length, stString
SQLType, Integer Length,
Integer I, initialization,
SetLength,
ProceduresColumnsDynArray,
ProceduresColumnCount) for I
for 
I
const TZMetadataColumnDefs ImportedKeyColumnsDynArray
const TZMetadataColumnDefs PrimaryKeyColumnsDynArray
const procedureColumnIn = 1
const procedureColumnInOut = 2
const procedureColumnOut = 4
const procedureColumnResult = 3
const procedureColumnReturn = 5
const procedureColumnUnknown = 0
const procedureNoNulls = 0
const procedureNullable = 1
const procedureNullableUnknown = 2
const TZMetadataColumnDefs ProceduresColColumnsDynArray
const TZMetadataColumnDefs ProceduresColumnsDynArray
const TZMetadataColumnDefs SchemaColumnsDynArray
const TZMetadataColumnDefs TableColColumnsDynArray
const TZMetadataColumnDefs TableColPrivColumnsDynArray
const TZMetadataColumnDefs TableColumnsDynArray
const TZMetadataColumnDefs TableColVerColumnsDynArray
const TZMetadataColumnDefs TablePrivColumnsDynArray
const TZMetadataColumnDefs TableTypeColumnsDynArray


Typedef Documentation

typedef set<Char> TZWildcardsSet

Definition at line 90 of file ZDbcMetadata.pas.


Function Documentation

String GetTablesMetaDataCacheKey ( const String  Catalog,
const String  SchemaPattern,
const String  TableNamePattern,
const TStringDynArray  Types 
)

rerurns cache key for get tables metadata entry

Parameters:
Catalog catalog name
SchemaPattern schema pattern
TableNamePattern table name pattern
Types table types
Returns:
the cache key string
Deprecated:
use TZAbstractDatabaseMetadata.GetTablesCacheKey instead

Definition at line 5806 of file ZDbcMetadata.pas.

SetLength ( TypeInfoColumnsDynArray  ,
TypeInfoColumnCount   
)

SetLength ( CrossRefColumnsDynArray  ,
CrossRefColumnCount   
)

SetLength ( edKeyColumnsDynArray  ,
edKeyColumnCount   
)

SetLength ( ImportedKeyColumnsDynArray  ,
ImportedKeyColumnCount   
)

SetLength ( PrimaryKeyColumnsDynArray  ,
PrimaryKeyColumnCount   
)

SetLength ( TableColVerColumnsDynArray  ,
TableColVerColumnCount   
)

SetLength ( BestRowIdentColumnsDynArray  ,
BestRowIdentColumnCount   
)

SetLength ( TablePrivColumnsDynArray  ,
TablePrivColumnCount   
)

SetLength ( TableColPrivColumnsDynArray  ,
TableColPrivColumnCount   
)

SetLength ( TableColColumnsDynArray  ,
TableColColumnCount   
)

SetLength ( TableTypeColumnsDynArray  ,
TableTypeColumnCount   
)

SetLength ( CatalogColumnsDynArray  ,
CatalogColumnCount   
)

SetLength ( SchemaColumnsDynArray  ,
SchemaColumnCount   
)

Boolean SupportsDataDefinitionAndDataManipulationTransactions (  ) 

Are both data definition and data manipulation statements within a transaction supported?

Returns:
true if so; false otherwise

Definition at line 2847 of file ZDbcMetadata.pas.

Boolean SupportsDataManipulationTransactionsOnly (  ) 

Are only data manipulation statements within a transaction supported?

Returns:
true if so; false otherwise

Definition at line 2860 of file ZDbcMetadata.pas.


Variable Documentation

Definition at line 1071 of file ZDbcMetadata.pas.

IndexInfoColumnsDynArray __pad1__

Definition at line 1072 of file ZDbcMetadata.pas.

SequenceColumnsDynArray __pad2__

Definition at line 1073 of file ZDbcMetadata.pas.

UDTColumnsDynArray __pad3__

Definition at line 1074 of file ZDbcMetadata.pas.

const TZMetadataColumnDefs BestRowIdentColumnsDynArray

Definition at line 1059 of file ZDbcMetadata.pas.

const TZMetadataColumnDefs CatalogColumnsDynArray

Definition at line 1049 of file ZDbcMetadata.pas.

const TZMetadataColumnDefs CrossRefColumnsDynArray

Definition at line 1069 of file ZDbcMetadata.pas.

Definition at line 1038 of file ZDbcMetadata.pas.

const TZMetadataColumnDefs ExportedKeyColumnsDynArray

Definition at line 1067 of file ZDbcMetadata.pas.

for I

Definition at line 6066 of file ZDbcMetadata.pas.

const TZMetadataColumnDefs ImportedKeyColumnsDynArray

Definition at line 1065 of file ZDbcMetadata.pas.

const TZMetadataColumnDefs PrimaryKeyColumnsDynArray

Definition at line 1063 of file ZDbcMetadata.pas.

const procedureColumnIn = 1

Definition at line 81 of file ZDbcMetadata.pas.

Definition at line 82 of file ZDbcMetadata.pas.

const procedureColumnOut = 4

Definition at line 83 of file ZDbcMetadata.pas.

Definition at line 85 of file ZDbcMetadata.pas.

Definition at line 84 of file ZDbcMetadata.pas.

Definition at line 80 of file ZDbcMetadata.pas.

const procedureNoNulls = 0

Definition at line 86 of file ZDbcMetadata.pas.

const procedureNullable = 1

Definition at line 87 of file ZDbcMetadata.pas.

Definition at line 88 of file ZDbcMetadata.pas.

const TZMetadataColumnDefs ProceduresColColumnsDynArray

Definition at line 1043 of file ZDbcMetadata.pas.

const TZMetadataColumnDefs ProceduresColumnsDynArray

Definition at line 1041 of file ZDbcMetadata.pas.

const TZMetadataColumnDefs SchemaColumnsDynArray

Definition at line 1047 of file ZDbcMetadata.pas.

const TZMetadataColumnDefs TableColColumnsDynArray

Definition at line 1053 of file ZDbcMetadata.pas.

const TZMetadataColumnDefs TableColPrivColumnsDynArray

Definition at line 1055 of file ZDbcMetadata.pas.

const TZMetadataColumnDefs TableColumnsDynArray

Definition at line 1045 of file ZDbcMetadata.pas.

const TZMetadataColumnDefs TableColVerColumnsDynArray

Definition at line 1061 of file ZDbcMetadata.pas.

const TZMetadataColumnDefs TablePrivColumnsDynArray

Definition at line 1057 of file ZDbcMetadata.pas.

const TZMetadataColumnDefs TableTypeColumnsDynArray

Definition at line 1051 of file ZDbcMetadata.pas.


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