Class TMysqlMetaData
TMysqlMetaData loads Mysql version 4.1.x and 5.x database table and column information.
For Mysql version 4.1.x, PHP 5.1.3 or later is required. See http://netevil.org/node.php?nid=795&SC=1
Method Summary |
protected
TMysqlTableInfo
|
|
protected
TMysqlTableInfo
|
Get the column definitions for given table.
|
protected
array
|
Extract foreign key constraints by extracting the contraints from SHOW CREATE TABLE result.
|
protected
array
|
Gets the primary and foreign key column details for the given table.
|
protected
array
|
Gets foreign relationship constraint keys and table name
|
protected
boolean
|
getIsView
( string $schemaName, string $tableName)
For MySQL version 5.0.1 or later we can use SHOW FULL TABLES http://dev.mysql.com/doc/refman/5.0/en/show-tables.html
|
protected
array
|
|
protected
float
|
|
protected
string
|
|
protected
string
|
|
protected
boolean
|
|
protected
boolean
|
|
protected
boolean
|
|
protected
void
|
http://dev.mysql.com/doc/refman/5.0/en/identifiers.html
|
protected
void
|
|
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()
|
Method Details |
createNewTableInfo
Input |
string | $table | table schema name |
string | 1 | table name. |
Output |
Exception |
|
createTableInfo
Get the column definitions for given table.
Input |
string | $table | table name. |
Output |
TMysqlTableInfo
| table information. |
Exception |
|
findForeignConstraints
protected array findForeignConstraints |
(string $schemaName , string $tableName ) |
Extract foreign key constraints by extracting the contraints from SHOW CREATE TABLE result.
Input |
string | $schemaName | database name |
string | $tableName | table name |
Output |
array
| foreign relationship table name and keys. |
Exception |
|
getConstraintKeys
protected array getConstraintKeys |
(string $schemaName , string $tableName ) |
Gets the primary and foreign key column details for the given table.
Input |
string | $schemaName | schema name |
string | $tableName | table name. |
Output |
array
| tuple ($primary, $foreign) |
Exception |
|
getForeignConstraints
protected array getForeignConstraints |
(string $schemaName , string $tableName ) |
Gets foreign relationship constraint keys and table name
Input |
string | $schemaName | database name |
string | $tableName | table name |
Output |
array
| foreign relationship table name and keys. |
Exception |
|
getIsView
protected boolean getIsView |
(string $schemaName , string $tableName ) |
For MySQL version 5.0.1 or later we can use SHOW FULL TABLES http://dev.mysql.com/doc/refman/5.0/en/show-tables.html
For MySQL version 5.0.1 or ealier, this always return false.
Input |
string | $schemaName | database name, null to use default connection database. |
string | $tableName | table or view name. |
Output |
boolean
| true if is view, false otherwise. |
Exception |
throws | TDbException if table or view does not exist. |
|
getSchemaTableName
protected array getSchemaTableName |
(string $table ) |
Input |
string | $table | table name, may be quoted with back-ticks and may contain database name. |
Output |
array
| tuple ($schema,$table), $schema may be null. |
Exception |
throws | TDbException when table name contains invalid identifier bytes. |
|
getServerVersion
protected float getServerVersion |
() |
Output |
float
| server version. |
Exception |
|
getShowCreateTable
protected string getShowCreateTable |
(string $schemaName , string $tableName ) |
Input |
string | $schemaName | database name |
string | $tableName | table name |
Output |
string
| SQL command to create the table. |
Exception |
throws | TDbException if PHP version is less than 5.1.3 |
|
getTableInfoClass
protected string getTableInfoClass |
() |
Output |
string
| TDbTableInfo class name. |
Exception |
|
isEnumSetType
protected boolean isEnumSetType |
(mixed $type ) |
Input |
mixed | $type | |
Output |
boolean
| true if column type if "enum" or "set". |
Exception |
|
isForeignKeyColumn
protected boolean isForeignKeyColumn |
(string $columnId , TPgsqlTableInfo $tableInfo ) |
Input |
string | $columnId | column name. |
TPgsqlTableInfo | $tableInfo | table information. |
Output |
boolean
| true if column is a foreign key. |
Exception |
|
isPrecisionType
protected boolean isPrecisionType |
(mixed $type ) |
Input |
mixed | $type | |
Output |
boolean
| true if column type if "numeric", "interval" or begins with "time". |
Exception |
|
isValidIdentifier
protected void isValidIdentifier |
(string $name , boolean 1 ) |
http://dev.mysql.com/doc/refman/5.0/en/identifiers.html
Input |
string | $name | identifier name |
boolean | 1 | true if valid identifier. |
Output |
Exception |
|
processColumn
Input |
TMysqlTableInfo | $tableInfo | table information. |
array | $col | column information. |
Output |
Exception |
|
|