PHP 클래스 yii\db\mssql\Schema

부터: 2.0
저자: Timur Ruziev ([email protected])
상속: extends yii\db\Schema
파일 보기 프로젝트 열기: yiisoft/yii2

공개 프로퍼티들

프로퍼티 타입 설명
$defaultSchema the default schema used for the current session.
$typeMap mapping from physical column types (keys) to abstract column types (values)

공개 메소드들

메소드 설명
createQueryBuilder ( ) : QueryBuilder Creates a query builder for the MSSQL database.
createSavepoint ( $name )
findUniqueIndexes ( yii\db\mssql\TableSchema $table ) : array Returns all unique indexes for the given table.
loadTableSchema ( string $name ) : yii\db\mssql\TableSchema | null Loads the metadata for the specified table.
quoteSimpleColumnName ( string $name ) : string Quotes a column name for use in a query.
quoteSimpleTableName ( string $name ) : string Quotes a table name for use in a query.
releaseSavepoint ( $name )
rollBackSavepoint ( $name )

보호된 메소드들

메소드 설명
findColumns ( yii\db\mssql\TableSchema $table ) : boolean Collects the metadata of table columns.
findForeignKeys ( yii\db\mssql\TableSchema $table ) Collects the foreign key column details for the given table.
findPrimaryKeys ( yii\db\mssql\TableSchema $table ) Collects the primary key column details for the given table.
findTableConstraints ( yii\db\mssql\TableSchema $table, string $type ) : array Collects the constraint details for the given table and constraint type.
findTableNames ( string $schema = '' ) : array Returns all table names in the database.
loadColumnSchema ( array $info ) : ColumnSchema Loads the column information into a [[ColumnSchema]] object.
resolveTableNames ( yii\db\mssql\TableSchema $table, string $name ) Resolves the table name and schema name (if any).

메소드 상세

createQueryBuilder() 공개 메소드

Creates a query builder for the MSSQL database.
public createQueryBuilder ( ) : QueryBuilder
리턴 QueryBuilder query builder interface.

createSavepoint() 공개 메소드

public createSavepoint ( $name )

findColumns() 보호된 메소드

Collects the metadata of table columns.
protected findColumns ( yii\db\mssql\TableSchema $table ) : boolean
$table yii\db\mssql\TableSchema the table metadata
리턴 boolean whether the table exists in the database

findForeignKeys() 보호된 메소드

Collects the foreign key column details for the given table.
protected findForeignKeys ( yii\db\mssql\TableSchema $table )
$table yii\db\mssql\TableSchema the table metadata

findPrimaryKeys() 보호된 메소드

Collects the primary key column details for the given table.
protected findPrimaryKeys ( yii\db\mssql\TableSchema $table )
$table yii\db\mssql\TableSchema the table metadata

findTableConstraints() 보호된 메소드

Collects the constraint details for the given table and constraint type.
부터: 2.0.4
protected findTableConstraints ( yii\db\mssql\TableSchema $table, string $type ) : array
$table yii\db\mssql\TableSchema
$type string either PRIMARY KEY or UNIQUE
리턴 array each entry contains index_name and field_name

findTableNames() 보호된 메소드

Returns all table names in the database.
protected findTableNames ( string $schema = '' ) : array
$schema string the schema of the tables. Defaults to empty string, meaning the current or default schema.
리턴 array all table names in the database. The names have NO schema name prefix.

findUniqueIndexes() 공개 메소드

Each array element is of the following structure: php [ 'IndexName1' => ['col1' [, ...]], 'IndexName2' => ['col2' [, ...]], ]
부터: 2.0.4
public findUniqueIndexes ( yii\db\mssql\TableSchema $table ) : array
$table yii\db\mssql\TableSchema the table metadata
리턴 array all unique indexes for the given table.

loadColumnSchema() 보호된 메소드

Loads the column information into a [[ColumnSchema]] object.
protected loadColumnSchema ( array $info ) : ColumnSchema
$info array column information
리턴 yii\db\ColumnSchema the column schema object

loadTableSchema() 공개 메소드

Loads the metadata for the specified table.
public loadTableSchema ( string $name ) : yii\db\mssql\TableSchema | null
$name string table name
리턴 yii\db\mssql\TableSchema | null driver dependent table metadata. Null if the table does not exist.

quoteSimpleColumnName() 공개 메소드

A simple column name has no prefix.
public quoteSimpleColumnName ( string $name ) : string
$name string column name.
리턴 string the properly quoted column name.

quoteSimpleTableName() 공개 메소드

A simple table name has no schema prefix.
public quoteSimpleTableName ( string $name ) : string
$name string table name.
리턴 string the properly quoted table name.

releaseSavepoint() 공개 메소드

public releaseSavepoint ( $name )

resolveTableNames() 보호된 메소드

Resolves the table name and schema name (if any).
protected resolveTableNames ( yii\db\mssql\TableSchema $table, string $name )
$table yii\db\mssql\TableSchema the table metadata object
$name string the table name

rollBackSavepoint() 공개 메소드

public rollBackSavepoint ( $name )

프로퍼티 상세

$defaultSchema 공개적으로 프로퍼티

the default schema used for the current session.
public $defaultSchema

$typeMap 공개적으로 프로퍼티

mapping from physical column types (keys) to abstract column types (values)
public $typeMap