|
Class TOracleMetaData
TOracleMetaData loads Oracle database table and column information.
-
TComponent
-
TDbMetaData
-
TOracleMetaData
Methods summary
protected
string
|
#
getTableInfoClass( )
Returns
string TDbTableInfo class name.
Overrides
|
public
|
#
setDefaultSchema( string $schema )
Parameters
- $schema
string default schema.
|
public
string
|
#
getDefaultSchema( )
Returns
string default schema.
|
protected
array
|
#
getSchemaTableName( string $table )
Parameters
- $table
string table name with optional schema name prefix, uses default schema name prefix is
not provided.
Returns
array tuple as ($schemaName,$tableName)
|
protected
TOracleTableInfo
|
#
createTableInfo( string $table )
Get the column definitions for given table.
Get the column definitions for given table.
Parameters
Returns
|
protected
TOracleTableInfo
|
#
createNewTableInfo( string $schemaName, string $tableName )
Parameters
- $schemaName
string table schema name
- $tableName
string table name.
Returns
|
protected
string
|
#
assertIdentifier( string $name )
Parameters
- $name
string table name, schema name or column name.
Returns
string a valid identifier.
Throws
|
protected
boolean
|
#
getIsView( string $schemaName, string $tableName )
Parameters
- $schemaName
string table schema name
- $tableName
string table name.
Returns
boolean true if the table is a view.
|
protected
|
|
protected
string
|
#
getSequenceName( mixed $tableInfo, mixed $src )
Returns
string serial name if found, null otherwise.
|
protected
boolean
|
#
isPrecisionType( mixed $type )
Returns
boolean true if column type if "numeric", "interval" or begins with "time".
|
protected
array
|
#
getConstraintKeys( string $schemaName, string $tableName )
Gets the primary and foreign key column details for the given table.
Gets the primary and foreign key column details for the given table.
Parameters
- $schemaName
string schema name
- $tableName
string table name.
Returns
array tuple ($primary, $foreign)
|
protected
array
|
#
getPrimaryKeys( string $src )
Gets the primary key field names
Gets the primary key field names
Parameters
- $src
string Oracle primary key definition
Returns
array primary key field names.
|
protected
array
|
#
getForeignKeys( string $src )
Gets foreign relationship constraint keys and table name
Gets foreign relationship constraint keys and table name
Parameters
- $src
string Oracle foreign key definition
Returns
array foreign relationship table name and keys, null otherwise
|
protected
boolean
|
#
isForeignKeyColumn( string $columnId, TOracleTableInfo $tableInfo )
Parameters
Returns
boolean true if column is a foreign key.
|
public
array
|
#
findTableNames( string $schema = '' )
Returns all table names in the database.
Returns all table names in the database.
Parameters
- $schema
string $schema the schema of the tables. Defaults to empty string, meaning the current
or default schema. If not empty, the returned table names will be prefixed with
the schema name.
Returns
array all table names in the database.
|
Methods inherited from TComponent
__call(),
__destruct(),
__get(),
__isset(),
__set(),
__sleep(),
__unset(),
__wakeup(),
addParsedObject(),
asa(),
attachBehavior(),
attachBehaviors(),
attachClassBehavior(),
attachEventHandler(),
canGetProperty(),
canSetProperty(),
clearBehaviors(),
createdOnTemplate(),
detachBehavior(),
detachBehaviors(),
detachClassBehavior(),
detachEventHandler(),
disableBehavior(),
disableBehaviors(),
enableBehavior(),
enableBehaviors(),
evaluateExpression(),
evaluateStatements(),
fxAttachClassBehavior(),
fxDetachClassBehavior(),
getAutoGlobalListen(),
getBehaviorsEnabled(),
getClassHierarchy(),
getEventHandlers(),
getListeningToGlobalEvents(),
getSubProperty(),
hasEvent(),
hasEventHandler(),
hasProperty(),
isa(),
listen(),
raiseEvent(),
setSubProperty(),
unlisten()
|
|