PHP 클래스 Prado\Data\Common\Pgsql\TPgsqlMetaData

부터: 3.1

상속: extends Prado\Data\Common\TDbMetaData

공개 메소드들

메소드	설명
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 ) : TPgsqlTableInfo
createTableInfo ( $table ) : TPgsqlTableInfo	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 )

메소드 상세

assertIdentifier() 보호된 메소드

protected assertIdentifier ( $name ) : string
리턴	string	a valid identifier.

createNewTableInfo() 보호된 메소드

protected createNewTableInfo ( $schemaName, $tableName ) : TPgsqlTableInfo
리턴	TPgsqlTableInfo

createTableInfo() 보호된 메소드

Get the column definitions for given table.

protected createTableInfo ( $table ) : TPgsqlTableInfo
리턴	TPgsqlTableInfo	table information.

findTableNames() 공개 메소드

Returns all table names in the database.

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.

getConstraintKeys() 보호된 메소드

Gets the primary and foreign key column details for the given table.

protected getConstraintKeys ( $schemaName, $tableName ) : array
리턴	array	tuple ($primary, $foreign)

getDefaultSchema() 공개 메소드

public getDefaultSchema ( ) : string
리턴	string	default schema.

getForeignKeys() 보호된 메소드

Gets foreign relationship constraint keys and table name

protected getForeignKeys ( $src ) : array
리턴	array	foreign relationship table name and keys, null otherwise

getIsView() 보호된 메소드

protected getIsView ( $schemaName, $tableName ) : boolean
리턴	boolean	true if the table is a view.

getPrimaryKeys() 보호된 메소드

Gets the primary key field names

protected getPrimaryKeys ( $tableName, $schemaName, $columnIndex ) : array
리턴	array	primary key field names.

getSchemaTableName() 보호된 메소드

protected getSchemaTableName ( $table ) : array
리턴	array	tuple as ($schemaName,$tableName)

getSequenceName() 보호된 메소드

protected getSequenceName ( $tableInfo, $src ) : string
리턴	string	serial name if found, null otherwise.

getTableInfoClass() 보호된 메소드

protected getTableInfoClass ( ) : string
리턴	string	TDbTableInfo class name.

isForeignKeyColumn() 보호된 메소드

protected isForeignKeyColumn ( $columnId, $tableInfo ) : boolean
리턴	boolean	true if column is a foreign key.

isPrecisionType() 보호된 메소드

protected isPrecisionType ( $type ) : boolean
리턴	boolean	true if column type if "numeric", "interval" or begins with "time".

processColumn() 보호된 메소드

protected processColumn ( $tableInfo, $col )

quoteColumnAlias() 공개 메소드

Quotes a column alias for use in a query.

public quoteColumnAlias ( string $name ) : string
$name	string	column alias
리턴	string	the properly quoted column alias

quoteColumnName() 공개 메소드

Quotes a column name for use in a query.

public quoteColumnName ( string $name ) : string
$name	string	column name
리턴	string	the properly quoted column name

quoteTableName() 공개 메소드

Quotes a table name for use in a query.

public quoteTableName ( string $name ) : string
$name	string	table name
리턴	string	the properly quoted table name

setDefaultSchema() 공개 메소드

public setDefaultSchema ( $schema )