PHP Class Prado\Data\Common\Mssql\TMssqlMetaData

Since: 3.1
Inheritance: extends Prado\Data\Common\TDbMetaData
Afficher le fichier Open project: pradosoft/prado

Méthodes publiques

Méthode Description
findTableNames ( string $schema = 'dbo' ) : 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.

Méthodes protégées

Méthode Description
createNewTableInfo ( $col ) : TMssqlTableInfo
createTableInfo ( $table ) : TMssqlTableInfo Get the column definitions for given table.
getCatalogSchemaTableName ( $table ) : array
getConstraintKeys ( $col ) : array Gets the primary and foreign key column details for the given table.
getForeignConstraints ( $col ) : array Gets foreign relationship constraint keys and table name
getTableInfoClass ( ) : string
isForeignKeyColumn ( $columnId, $tableInfo ) : boolean
processColumn ( $tableInfo, $col )

Method Details

createNewTableInfo() protected méthode

protected createNewTableInfo ( $col ) : TMssqlTableInfo
Résultat TMssqlTableInfo

createTableInfo() protected méthode

Get the column definitions for given table.
protected createTableInfo ( $table ) : TMssqlTableInfo
Résultat TMssqlTableInfo table information.

findTableNames() public méthode

Returns all table names in the database.
public findTableNames ( string $schema = 'dbo' ) : 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.
Résultat array all table names in the database.

getCatalogSchemaTableName() protected méthode

protected getCatalogSchemaTableName ( $table ) : array
Résultat array tuple($catalogName,$schemaName,$tableName)

getConstraintKeys() protected méthode

Gets the primary and foreign key column details for the given table.
protected getConstraintKeys ( $col ) : array
Résultat array tuple ($primary, $foreign)

getForeignConstraints() protected méthode

Gets foreign relationship constraint keys and table name
protected getForeignConstraints ( $col ) : array
Résultat array foreign relationship table name and keys.

getTableInfoClass() protected méthode

protected getTableInfoClass ( ) : string
Résultat string TDbTableInfo class name.

isForeignKeyColumn() protected méthode

protected isForeignKeyColumn ( $columnId, $tableInfo ) : boolean
Résultat boolean true if column is a foreign key.

processColumn() protected méthode

protected processColumn ( $tableInfo, $col )

quoteColumnAlias() public méthode

Quotes a column alias for use in a query.
public quoteColumnAlias ( string $name ) : string
$name string column alias
Résultat string the properly quoted column alias

quoteColumnName() public méthode

Quotes a column name for use in a query.
public quoteColumnName ( string $name ) : string
$name string column name
Résultat string the properly quoted column name

quoteTableName() public méthode

Quotes a table name for use in a query.
public quoteTableName ( string $name ) : string
$name string table name
Résultat string the properly quoted table name