- Home
- About
- Testimonials
- Demos
- Download
- Documentation
- Blogs
- Forum
- Support

Packages:
default
System
System.Caching
System.Collections
System.Data
System.Data.ActiveRecord
System.Data.ActiveRecord.Relations
System.Data.ActiveRecord.Scaffold
System.Data.ActiveReecord.Scaffold.InputBuilder
System.Data.Commom.Sqlite
System.Data.Common
System.Data.Common.Mssql
System.Data.Common.Mysql
System.Data.Common.Oracle
System.Data.Common.Pgsql
System.Data.Common.Sqlite
System.Data.DataGateway
System.Data.SqlMap
System.Data.SqlMap.Configuration
System.Data.SqlMap.Statements
System.Exceptions
System.I18N
System.IO
System.Security
System.Util
System.Web
System.Web.Services
System.Web.UI
System.Web.UI.ActiveControls
System.Web.UI.WebControls
System.Web.UI.WebControls.assets
System.Xml
Classes:
TDbCommandBuilder
TDbMetaData
TDbTableColumn
TDbTableInfo
TMssqlCommandBuilder
TMysqlCommandBuilder
TOracleCommandBuilder
TOracleTableInfo
TPgsqlCommandBuilder
TSqliteCommandBuilder

Keyword

# Class TOracleTableInfo

    TComponent
       |
       --TOracleTableInfo

TDbTableInfo class describes the meta data of a database table.

Since: 3.1
Author: Wei Zhuo <weizho[at]gmail[dot]com>

Constructor Summary
public | __construct Array Sets the database table meta data information.

Method Summary
TDbCommandBuilder | createCommandBuilder ( TDbConnection $connection)
TDbTableColumn | getColumn ( string $name)
array | getColumnNames ( array 0)
TMap | getColumns ()
array | getForeignKeys ()
mixed | getInfo ( string $name, mixed $default)
boolean | getIsView ()
array | getLowerCaseColumnNames ()
string[] | getPrimaryKeys ()
string | getTableFullName ()
string | getTableName ()
protected void | setInfo ( string $name, mixed $value)

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()

Constructor Details

## __construct

public __construct | Array

Sets the database table meta data information.

Method Details

## createCommandBuilder

public TDbCommandBuilder createCommandBuilder | (TDbConnection $connection )

Input
TDbConnection | $connection | database connection.
Output
TDbCommandBuilder | new command builder
Exception

## getColumn

public TDbTableColumn getColumn | (string $name )

Input
string | $name | column id
Output
TDbTableColumn | column information.
Exception

## getColumnNames

public array getColumnNames | (array 0 )

Input
array | 0 | list of column Id, empty to get all columns.
Output
array | table column names (identifier quoted)
Exception

## getColumns

public TMap getColumns | ()

Output
TMap | TDbTableColumn column meta data.
Exception

## getForeignKeys

public array getForeignKeys | ()

Output
array | tuples of foreign table and column name.
Exception

## getInfo

public mixed getInfo | (string $name , mixed $default )

Input
string | $name | information array key name
mixed | $default | default value if information array value is null
Output
mixed | information array value.
Exception

## getIsView

public boolean getIsView | ()

Output
boolean | whether the table is a view, default is false.
Exception

## getLowerCaseColumnNames

public array getLowerCaseColumnNames | ()

Output
array | lowercased column key names mapped to normal column ids.
Exception

## getPrimaryKeys

public string[] getPrimaryKeys | ()

Output
string[] | names of primary key columns.
Exception

## getTableFullName

public string getTableFullName | ()

Output
string | full name of the table, database dependent.
Exception

## getTableName

public string getTableName | ()

Output
string | name of the table this column belongs to.
Exception

## setInfo

protected void setInfo | (string $name , mixed $value )

Input
string | $name | information array key name
mixed | $value | new information array value.
Output
Exception