Class \Prado\Data\Common\Mysql\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

Class hierarchy

\Prado\Data\Common\Mysql\TMysqlMetaData

\Prado\Data\Common\TDbMetaData

\Prado\TComponent

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

Methods summary
`public`	`findTableNames([string $schema = '' ]) : array<string\|int, mixed>` Returns all table names in the database.
`public`	`quoteColumnAlias(string $name) : string` Quotes a column alias for use in a query.
`public`	`quoteColumnName(string $name) : string` Quotes a column name for use in a query.
`public`	`quoteTableName(string $name) : string` Quotes a table name for use in a query.
`protected`	`createNewTableInfo(string $table) : TMysqlTableInfo`
`protected`	`createTableInfo(string $table) : TMysqlTableInfo` Get the column definitions for given table.
`protected`	`findForeignConstraints(string $schemaName, string $tableName) : array<string\|int, mixed>` Extract foreign key constraints by extracting the contraints from SHOW CREATE TABLE result.
`protected`	`getConstraintKeys(string $schemaName, string $tableName) : array<string\|int, mixed>` Gets the primary and foreign key column details for the given table.
`protected`	`getForeignConstraints(string $schemaName, string $tableName) : array<string\|int, mixed>` Gets foreign relationship constraint keys and table name
`protected`	`getIsView(string $schemaName, string $tableName) : bool` 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 earlier, this always return false.
`protected`	`getSchemaTableName(string $table) : array<string\|int, mixed>`
`protected`	`getServerVersion() : float`
`protected`	`getShowCreateTable(string $schemaName, string $tableName) : string`
`protected`	`getTableColumnClass() : string`
`protected`	`getTableInfoClass() : string`
`protected`	`isEnumSetType(mixed $type) : bool`
`protected`	`isForeignKeyColumn(string $columnId, TMysqlTableInfo $tableInfo) : bool`
`protected`	`isPrecisionType(mixed $type) : bool`
`protected`	`isValidIdentifier(string $name) : bool` http://dev.mysql.com/doc/refman/5.0/en/identifiers.html
`protected`	`processColumn(TMysqlTableInfo $tableInfo, array<string\|int, mixed> $col) : mixed`

Inherited methods
__call, __callStatic, __clone, __construct, __destruct, __get, __isset, __set, __sleep, __unset, __wakeup, addParsedObject, asa, attachBehavior, attachBehaviors, attachClassBehavior, attachEventHandler, callBehaviorsMethod, canGetProperty, canSetProperty, clearBehaviors, createCommandBuilder, createdOnTemplate, detachBehavior, detachBehaviors, detachClassBehavior, detachEventHandler, disableBehavior, disableBehaviors, enableBehavior, enableBehaviors, evaluateExpression, evaluateStatements, findTableNames, fxAttachClassBehavior, fxDetachClassBehavior, getAutoGlobalListen, getBehaviors, getBehaviorsEnabled, getClassHierarchy, getDbConnection, getEventHandlers, getInstance, getListeningToGlobalEvents, getSubProperty, getTableInfo, hasEvent, hasEventHandler, hasMethod, hasProperty, isa, listen, quoteColumnAlias, quoteColumnName, quoteTableName, raiseEvent, setSubProperty, unlisten, _getZappableSleepProps, createTableInfo, getCallChain, getClassFxEvents, getTableInfoClass, instanceBehavior, filter_prado_fx

Inherited constants
`\Prado\TComponent::GLOBAL_RAISE_EVENT_LISTENER`

Classes

Interfaces

Traits

Search results

Class \Prado\Data\Common\Mysql\TMysqlMetaData

Class hierarchy