PHP Класс yii\db\sqlite\Schema

С версии: 2.0

Автор: Qiang Xue ([email protected])

Наследование: extends yii\db\Schema

Открытые свойства

Свойство	Тип	Описание
$typeMap		mapping from physical column types (keys) to abstract column types (values)

Метод	Описание
createColumnSchemaBuilder ( $type, $length = null ) : yii\db\sqlite\ColumnSchemaBuilder
createQueryBuilder ( ) : QueryBuilder	Creates a query builder for the MySQL database.
findUniqueIndexes ( yii\db\TableSchema $table ) : array	Returns all unique indexes for the given 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.
setTransactionIsolationLevel ( string $level )	Sets the isolation level of the current transaction.

Метод	Описание
findColumns ( yii\db\TableSchema $table ) : boolean	Collects the table column metadata.
findConstraints ( yii\db\TableSchema $table )	Collects the foreign key column details for the given table.
findTableNames ( string $schema = '' ) : array	Returns all table names in the database.
loadColumnSchema ( array $info ) : ColumnSchema	Loads the column information into a [[ColumnSchema]] object.
loadTableSchema ( string $name ) : yii\db\TableSchema	Loads the metadata for the specified table.

public createColumnSchemaBuilder ( $type, $length = null ) : yii\db\sqlite\ColumnSchemaBuilder
Результат	yii\db\sqlite\ColumnSchemaBuilder	column schema builder instance

This method may be overridden by child classes to create a DBMS-specific query builder.

public createQueryBuilder ( ) : QueryBuilder
Результат	QueryBuilder	query builder instance

Collects the table column metadata.

protected findColumns ( yii\db\TableSchema $table ) : boolean
$table	yii\db\TableSchema	the table metadata
Результат	boolean	whether the table exists in the database

Collects the foreign key column details for the given table.

protected findConstraints ( yii\db\TableSchema $table )
$table	yii\db\TableSchema	the table metadata

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.

Each array element is of the following structure: php [ 'IndexName1' => ['col1' [, ...]], 'IndexName2' => ['col2' [, ...]], ]

public findUniqueIndexes ( yii\db\TableSchema $table ) : array
$table	yii\db\TableSchema	the table metadata
Результат	array	all unique indexes for the given table.

Loads the column information into a [[ColumnSchema]] object.

protected loadColumnSchema ( array $info ) : ColumnSchema
$info	array	column information
Результат	yii\db\ColumnSchema	the column schema object

Loads the metadata for the specified table.

protected loadTableSchema ( string $name ) : yii\db\TableSchema
$name	string	table name
Результат	yii\db\TableSchema	driver dependent table metadata. Null if the table does not exist.

A simple column name has no prefix.

public quoteSimpleColumnName ( string $name ) : string
$name	string	column name
Результат	string	the properly quoted column name

A simple table name has no schema prefix.

public quoteSimpleTableName ( string $name ) : string
$name	string	table name
Результат	string	the properly quoted table name

Sets the isolation level of the current transaction.

См. также: http://www.sqlite.org/pragma.html#pragma_read_uncommitted

public setTransactionIsolationLevel ( string $level )
$level	string	The transaction isolation level to use for this transaction. This can be either [[Transaction::READ_UNCOMMITTED]] or [[Transaction::SERIALIZABLE]].

mapping from physical column types (keys) to abstract column types (values)

public $typeMap