Class TOracleMetaData

Description

TOracleMetaData loads Oracle database table and column information.

Located in /Data/Common/Oracle/TOracleMetaData.php (line 25)

TComponent
   |
   --TOracleMetaData
Method Summary
TOracleMetaData __construct (TDbConnection $conn)
string assertIdentifier (string $name)
TOracleTableInfo createNewTableInfo (string $schemaName, string $tableName)
array getConstraintKeys (string $schemaName, string $tableName)
string getDefaultSchema ()
array getForeignKeys (string $src)
boolean getIsView (string $schemaName, string $tableName)
array getPrimaryKeys (string $src)
array getSchemaTableName (string $table)
string getSequenceName (mixed $tableInfo, mixed $src)
TDbTableInfo getTableInfo ([string $tableName = null])
string getTableInfoClass ()
boolean isForeignKeyColumn (string $columnId, TOracleTableInfo $tableInfo)
boolean isPrecisionType (mixed $type)
void processColumn (TOracleTableInfo $tableInfo, array $col)
void setDefaultSchema (string $schema)
Methods
Constructor __construct (line 34)
  • access: public
TOracleMetaData __construct (TDbConnection $conn)
assertIdentifier (line 167)
  • return: a valid identifier.
  • access: protected
  • throws: TDbException when table name contains a double quote (").
string assertIdentifier (string $name)
  • string $name: table name, schema name or column name.
createNewTableInfo (line 151)
  • access: protected
TOracleTableInfo createNewTableInfo (string $schemaName, string $tableName)
  • string $schemaName: table schema name
  • string $tableName: table name.
createTableInfo (line 105)

Get the column definitions for given table.

  • return: table information.
  • access: protected
TOracleTableInfo createTableInfo (string $table)
  • string $table: table name.
getConstraintKeys (line 276)

Gets the primary and foreign key column details for the given table.

  • return: tuple ($primary, $foreign)
  • access: protected
array getConstraintKeys (string $schemaName, string $tableName)
  • string $schemaName: schema name
  • string $tableName: table name.
getDbConnection (line 42)
  • return: database connection.
  • access: public
TDbConnection getDbConnection ()
getDefaultSchema (line 66)
  • return: default schema.
  • access: public
string getDefaultSchema ()
getForeignKeys (line 337)

Gets foreign relationship constraint keys and table name

  • return: foreign relationship table name and keys, null otherwise
  • access: protected
array getForeignKeys (string $src)
  • string $src: Oracle foreign key definition
getIsView (line 182)
  • return: true if the table is a view.
  • access: protected
boolean getIsView (string $schemaName, string $tableName)
  • string $schemaName: table schema name
  • string $tableName: table name.
getPrimaryKeys (line 324)

Gets the primary key field names

  • return: primary key field names.
  • access: protected
array getPrimaryKeys (string $src)
  • string $src: Oracle primary key definition
getSchemaTableName (line 92)
  • return: tuple as ($schemaName,$tableName)
  • access: protected
array getSchemaTableName (string $table)
  • string $table: table name with optional schema name prefix, uses default schema name prefix is not provided.
getSequenceName (line 249)
  • return: serial name if found, null otherwise.
  • access: protected
string getSequenceName (mixed $tableInfo, mixed $src)
getTableInfo (line 76)

Obtains table meta data information for the current connection and given table name.

  • return: table information.
  • access: public
TDbTableInfo getTableInfo ([string $tableName = null])
  • string $tableName: table or view name
getTableInfoClass (line 50)
  • return: TDbTableInfo class name.
  • access: protected
string getTableInfoClass ()
isForeignKeyColumn (line 357)
  • return: true if column is a foreign key.
  • access: protected
boolean isForeignKeyColumn (string $columnId, TOracleTableInfo $tableInfo)
  • string $columnId: column name.
  • TOracleTableInfo $tableInfo: table information.
isPrecisionType (line 264)
  • return: true if column type if "numeric", "interval" or begins with "time".
  • access: protected
boolean isPrecisionType (mixed $type)
processColumn (line 202)
  • access: protected
void processColumn (TOracleTableInfo $tableInfo, array $col)
  • TOracleTableInfo $tableInfo: table information.
  • array $col: column information.
setDefaultSchema (line 58)
  • access: public
void setDefaultSchema (string $schema)
  • string $schema: default schema.

Inherited Methods

Inherited From TComponent

TComponent::addParsedObject()
TComponent::attachEventHandler()
TComponent::canGetProperty()
TComponent::canSetProperty()
TComponent::createdOnTemplate()
TComponent::detachEventHandler()
TComponent::evaluateExpression()
TComponent::evaluateStatements()
TComponent::getEventHandlers()
TComponent::getSubProperty()
TComponent::hasEvent()
TComponent::hasEventHandler()
TComponent::hasProperty()
TComponent::raiseEvent()
TComponent::setSubProperty()
TComponent::__get()
TComponent::__set()

Documentation generated on Mon, 21 Apr 2008 11:35:42 -0400 by phpDocumentor 1.3.0RC4