Метод | Описание | |
---|---|---|
findTableNames ( string $schema = 'public' ) : array | Returns all table names in the database. | |
getDefaultSchema ( ) : string | ||
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. | |
setDefaultSchema ( $schema ) |
Метод | Описание | |
---|---|---|
assertIdentifier ( $name ) : string | ||
createNewTableInfo ( $schemaName, $tableName ) : |
||
createTableInfo ( $table ) : |
Get the column definitions for given table. | |
getConstraintKeys ( $schemaName, $tableName ) : array | Gets the primary and foreign key column details for the given table. | |
getForeignKeys ( $src ) : array | Gets foreign relationship constraint keys and table name | |
getIsView ( $schemaName, $tableName ) : boolean | ||
getPrimaryKeys ( $tableName, $schemaName, $columnIndex ) : array | Gets the primary key field names | |
getSchemaTableName ( $table ) : array | ||
getSequenceName ( $tableInfo, $src ) : string | ||
getTableInfoClass ( ) : string | ||
isForeignKeyColumn ( $columnId, $tableInfo ) : boolean | ||
isPrecisionType ( $type ) : boolean | ||
processColumn ( $tableInfo, $col ) |
protected assertIdentifier ( $name ) : string | ||
Результат | string | a valid identifier. |
protected createNewTableInfo ( $schemaName, $tableName ) : |
||
Результат |
protected createTableInfo ( $table ) : |
||
Результат | table information. |
public findTableNames ( string $schema = 'public' ) : 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) |
public getDefaultSchema ( ) : string | ||
Результат | string | default schema. |
protected getForeignKeys ( $src ) : array | ||
Результат | array | foreign relationship table name and keys, null otherwise |
protected getPrimaryKeys ( $tableName, $schemaName, $columnIndex ) : array | ||
Результат | array | primary key field names. |
protected getSchemaTableName ( $table ) : array | ||
Результат | array | tuple as ($schemaName,$tableName) |
protected getSequenceName ( $tableInfo, $src ) : string | ||
Результат | string | serial name if found, null otherwise. |
protected getTableInfoClass ( ) : string | ||
Результат | string | TDbTableInfo class name. |
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". |
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 |