Class yii\db\sqlite\Schema

public void setTransactionIsolationLevel ( $level )

public array $typeMap = ['tinyint' => self::TYPE_SMALLINT, 'bit' => self::TYPE_SMALLINT, 'boolean' => self::TYPE_BOOLEAN, 'bool' => self::TYPE_BOOLEAN, 'smallint' => self::TYPE_SMALLINT, 'mediumint' => self::TYPE_INTEGER, 'int' => self::TYPE_INTEGER, 'integer' => self::TYPE_INTEGER, 'bigint' => self::TYPE_BIGINT, 'float' => self::TYPE_FLOAT, 'double' => self::TYPE_DOUBLE, 'real' => self::TYPE_FLOAT, 'decimal' => self::TYPE_DECIMAL, 'numeric' => self::TYPE_DECIMAL, 'tinytext' => self::TYPE_TEXT, 'mediumtext' => self::TYPE_TEXT, 'longtext' => self::TYPE_TEXT, 'text' => self::TYPE_TEXT, 'varchar' => self::TYPE_STRING, 'string' => self::TYPE_STRING, 'char' => self::TYPE_CHAR, 'blob' => self::TYPE_BINARY, 'datetime' => self::TYPE_DATETIME, 'year' => self::TYPE_DATE, 'date' => self::TYPE_DATE, 'time' => self::TYPE_TIME, 'timestamp' => self::TYPE_TIMESTAMP, 'enum' => self::TYPE_STRING]

createColumnSchemaBuilder() public method

Create a column schema builder instance giving the type and value precision.

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

public yii\db\sqlite\ColumnSchemaBuilder createColumnSchemaBuilder ( $type, $length = null )
$type	string	Type of the column. See yii\db\sqlite\ColumnSchemaBuilder::$type.
$length	integer|string|array	Length or precision of the column. See yii\db\sqlite\ColumnSchemaBuilder::$length.
return	yii\db\sqlite\ColumnSchemaBuilder	Column schema builder instance

createQueryBuilder() public method

Creates a query builder for the MySQL database.

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

public yii\db\sqlite\QueryBuilder createQueryBuilder ( )
return	yii\db\sqlite\QueryBuilder	Query builder instance

findColumns() protected method

Collects the table column metadata.

protected boolean findColumns ( $table )
$table	yii\db\TableSchema	The table metadata
return	boolean	Whether the table exists in the database

findConstraints() protected method

Collects the foreign key column details for the given table.

protected void findConstraints ( $table )
$table	yii\db\TableSchema	The table metadata

findTableNames() protected method

Returns all table names in the database.

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

findUniqueIndexes() public method

Returns all unique indexes for the given table.

Each array element is of the following structure:

[
    'IndexName1' => ['col1' [, ...]],
    'IndexName2' => ['col2' [, ...]],
]

public array findUniqueIndexes ( $table )
$table	yii\db\TableSchema	The table metadata
return	array	All unique indexes for the given table.

loadColumnSchema() protected method

Loads the column information into a yii\db\ColumnSchema object.

protected yii\db\ColumnSchema loadColumnSchema ( $info )
$info	array	Column information
return	yii\db\ColumnSchema	The column schema object

loadTableSchema() protected method

Loads the metadata for the specified table.

protected yii\db\TableSchema loadTableSchema ( $name )
$name	string	Table name
return	yii\db\TableSchema	Driver dependent table metadata. Null if the table does not exist.

quoteSimpleColumnName() public method

Quotes a column name for use in a query.

A simple column name has no prefix.

public string quoteSimpleColumnName ( $name )
$name	string	Column name
return	string	The properly quoted column name

quoteSimpleTableName() public method

Quotes a table name for use in a query.

A simple table name has no schema prefix.

public string quoteSimpleTableName ( $name )
$name	string	Table name
return	string	The properly quoted table name

setTransactionIsolationLevel() public method

Sets the isolation level of the current transaction.

See also http://www.sqlite.org/pragma.html#pragma_read_uncommitted.

public void setTransactionIsolationLevel ( $level )
$level	string	The transaction isolation level to use for this transaction. This can be either yii\db\Transaction::READ_UNCOMMITTED or yii\db\Transaction::SERIALIZABLE.
throws	yii\base\NotSupportedException	when unsupported isolation levels are used. SQLite only supports SERIALIZABLE and READ UNCOMMITTED.