Метод | Описание | |
---|---|---|
findTableNames ( string $schema = '' ) : array | Returns all table names in the database. | |
quoteColumnAlias ( string $name ) : string | Quotes a column alias for use in a query. | |
quoteColumnName ( string $name ) : string | Quotes a column name for use in a query. | |
quoteTableName ( string $name ) : string | Quotes a table name for use in a query. |
Метод | Описание | |
---|---|---|
createNewTableInfo ( $table ) : |
||
createTableInfo ( $table ) : |
Get the column definitions for given table. | |
findForeignConstraints ( $schemaName, $tableName ) : array | Extract foreign key constraints by extracting the contraints from SHOW CREATE TABLE result. | |
getConstraintKeys ( $schemaName, $tableName ) : array | Gets the primary and foreign key column details for the given table. | |
getForeignConstraints ( $schemaName, $tableName ) : array | Gets foreign relationship constraint keys and table name | |
getIsView ( $schemaName, $tableName ) : boolean | 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 | |
getSchemaTableName ( $table ) : array | ||
getServerVersion ( ) : float | ||
getShowCreateTable ( $schemaName, $tableName ) : string | ||
getTableInfoClass ( ) : string | ||
isEnumSetType ( $type ) : boolean | ||
isForeignKeyColumn ( $columnId, $tableInfo ) : boolean | ||
isPrecisionType ( $type ) : boolean | ||
isValidIdentifier ( $name ) | http://dev.mysql.com/doc/refman/5.0/en/identifiers.html | |
processColumn ( $tableInfo, $col ) |
protected createNewTableInfo ( $table ) : |
||
Результат |
protected createTableInfo ( $table ) : |
||
Результат | table information. |
protected findForeignConstraints ( $schemaName, $tableName ) : array | ||
Результат | array | foreign relationship table name and keys. |
public findTableNames ( string $schema = '' ) : array | ||
$schema | string | 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. |
Результат | array | all table names in the database. |
protected getConstraintKeys ( $schemaName, $tableName ) : array | ||
Результат | array | tuple ($primary, $foreign) |
protected getForeignConstraints ( $schemaName, $tableName ) : array | ||
Результат | array | foreign relationship table name and keys. |
protected getSchemaTableName ( $table ) : array | ||
Результат | array | tuple ($schema,$table), $schema may be null. |
protected getServerVersion ( ) : float | ||
Результат | float | server version. |
protected getShowCreateTable ( $schemaName, $tableName ) : string | ||
Результат | string | SQL command to create the table. |
protected getTableInfoClass ( ) : string | ||
Результат | string | TDbTableInfo class name. |
protected isEnumSetType ( $type ) : boolean | ||
Результат | boolean | true if column type if "enum" or "set". |
protected isForeignKeyColumn ( $columnId, $tableInfo ) : boolean | ||
Результат | boolean | true if column is a foreign key. |
protected isPrecisionType ( $type ) : boolean | ||
Результат | boolean | true if column type if "numeric", "interval" or begins with "time". |
protected isValidIdentifier ( $name ) |
public quoteColumnAlias ( string $name ) : string | ||
$name | string | column alias |
Результат | string | the properly quoted column alias |
public quoteColumnName ( string $name ) : string | ||
$name | string | column name |
Результат | string | the properly quoted column name |
public quoteTableName ( string $name ) : string | ||
$name | string | table name |
Результат | string | the properly quoted table name |