Inheritance | yii\db\cubrid\Schema » yii\db\Schema » yii\base\Object |
---|---|
Implements | yii\base\Configurable |
Available since version | 2.0 |
Source Code | https://github.com/yiisoft/yii2/blob/master/framework/db/cubrid/Schema.php |
Schema is the class for retrieving metadata from a CUBRID database (version 9.3.x and higher).
Property | Type | Description | Defined By |
---|---|---|---|
$columnSchemaClass | string | Column schema class | yii\db\Schema |
$db | yii\db\Connection | The database connection | yii\db\Schema |
$defaultSchema | string | The default schema name used for the current session. | yii\db\Schema |
$exceptionMap | array | Map of DB errors and corresponding exceptions If left part is found in DB error message exception class from the right part is used. | yii\db\cubrid\Schema |
$lastInsertID | string | The row ID of the last row inserted, or the last value retrieved from the sequence object | yii\db\Schema |
$queryBuilder | yii\db\QueryBuilder | The query builder for this connection. | yii\db\Schema |
$schemaNames | string[] | All schema names in the database, except system schemas. | yii\db\Schema |
$tableNames | string[] | All table names in the database. | yii\db\Schema |
$tableSchemas | yii\db\TableSchema[] | The metadata for all tables in the database. | yii\db\Schema |
$transactionIsolationLevel | string | The transaction isolation level to use for this transaction. | yii\db\cubrid\Schema |
$typeMap | array | Mapping from physical column types (keys) to abstract column types (values) Please refer to [CUBRID manual](http://www. | yii\db\cubrid\Schema |
Method | Description | Defined By |
---|---|---|
__call() | Calls the named method which is not a class method. | yii\base\Object |
__construct() | Constructor. | yii\base\Object |
__get() | Returns the value of an object property. | yii\base\Object |
__isset() | Checks if a property is set, i.e. defined and not null. | yii\base\Object |
__set() | Sets value of an object property. | yii\base\Object |
__unset() | Sets an object property to null. | yii\base\Object |
canGetProperty() | Returns a value indicating whether a property can be read. | yii\base\Object |
canSetProperty() | Returns a value indicating whether a property can be set. | yii\base\Object |
className() | Returns the fully qualified name of this class. | yii\base\Object |
convertException() | Converts a DB exception to a more concrete one if possible. | yii\db\Schema |
createColumnSchemaBuilder() | Create a column schema builder instance giving the type and value precision. | yii\db\cubrid\Schema |
createQueryBuilder() | Creates a query builder for the CUBRID database. | yii\db\cubrid\Schema |
createSavepoint() | Creates a new savepoint. | yii\db\Schema |
findUniqueIndexes() | Returns all unique indexes for the given table. | yii\db\Schema |
getLastInsertID() | Returns the ID of the last inserted row or sequence value. | yii\db\Schema |
getPdoType() | Determines the PDO type for the given PHP data value. | yii\db\cubrid\Schema |
getQueryBuilder() | yii\db\Schema | |
getRawTableName() | Returns the actual name of a given table name. | yii\db\Schema |
getSchemaNames() | Returns all schema names in the database, except system schemas. | yii\db\Schema |
getTableNames() | Returns all table names in the database. | yii\db\Schema |
getTableSchema() | Obtains the metadata for the named table. | yii\db\Schema |
getTableSchemas() | Returns the metadata for all tables in the database. | yii\db\Schema |
hasMethod() | Returns a value indicating whether a method is defined. | yii\base\Object |
hasProperty() | Returns a value indicating whether a property is defined. | yii\base\Object |
init() | Initializes the object. | yii\base\Object |
insert() | Executes the INSERT command, returning primary key values. | yii\db\Schema |
isReadQuery() | Returns a value indicating whether a SQL statement is for read purpose. | yii\db\Schema |
quoteColumnName() | Quotes a column name for use in a query. | yii\db\Schema |
quoteSimpleColumnName() | Quotes a column name for use in a query. | yii\db\cubrid\Schema |
quoteSimpleTableName() | Quotes a table name for use in a query. | yii\db\cubrid\Schema |
quoteTableName() | Quotes a table name for use in a query. | yii\db\Schema |
quoteValue() | Quotes a string value for use in a query. | yii\db\Schema |
refresh() | Refreshes the schema. | yii\db\Schema |
refreshTableSchema() | Refreshes the particular table schema. | yii\db\Schema |
releaseSavepoint() | Releases an existing savepoint. | yii\db\cubrid\Schema |
rollBackSavepoint() | Rolls back to a previously created savepoint. | yii\db\Schema |
setTransactionIsolationLevel() | Sets the isolation level of the current transaction. | yii\db\cubrid\Schema |
supportsSavepoint() | yii\db\Schema |
Method | Description | Defined By |
---|---|---|
createColumnSchema() | yii\db\Schema | |
findSchemaNames() | Returns all schema names in the database, including the default one but not system schemas. | yii\db\Schema |
findTableNames() | Returns all table names in the database. | yii\db\cubrid\Schema |
getCacheKey() | Returns the cache key for the specified table name. | yii\db\Schema |
getCacheTag() | Returns the cache tag name. | yii\db\Schema |
getColumnPhpType() | Extracts the PHP type from abstract DB type. | yii\db\Schema |
loadColumnSchema() | Loads the column information into a yii\db\ColumnSchema object. | yii\db\cubrid\Schema |
loadTableSchema() | Loads the metadata for the specified table. | yii\db\cubrid\Schema |
Constant | Value | Description | Defined By |
---|---|---|---|
TYPE_BIGINT | 'bigint' | yii\db\Schema | |
TYPE_BIGPK | 'bigpk' | yii\db\Schema | |
TYPE_BINARY | 'binary' | yii\db\Schema | |
TYPE_BOOLEAN | 'boolean' | yii\db\Schema | |
TYPE_CHAR | 'char' | yii\db\Schema | |
TYPE_DATE | 'date' | yii\db\Schema | |
TYPE_DATETIME | 'datetime' | yii\db\Schema | |
TYPE_DECIMAL | 'decimal' | yii\db\Schema | |
TYPE_DOUBLE | 'double' | yii\db\Schema | |
TYPE_FLOAT | 'float' | yii\db\Schema | |
TYPE_INTEGER | 'integer' | yii\db\Schema | |
TYPE_MONEY | 'money' | yii\db\Schema | |
TYPE_PK | 'pk' | yii\db\Schema | |
TYPE_SMALLINT | 'smallint' | yii\db\Schema | |
TYPE_STRING | 'string' | yii\db\Schema | |
TYPE_TEXT | 'text' | yii\db\Schema | |
TYPE_TIME | 'time' | yii\db\Schema | |
TYPE_TIMESTAMP | 'timestamp' | yii\db\Schema | |
TYPE_UBIGPK | 'ubigpk' | yii\db\Schema | |
TYPE_UPK | 'upk' | yii\db\Schema |
Map of DB errors and corresponding exceptions If left part is found in DB error message exception class from the right part is used.
public array $exceptionMap = ['Operation would have caused one or more unique constraint violations' => 'yii\db\IntegrityException']
The transaction isolation level to use for this transaction. This can be one of yii\db\Transaction::READ_UNCOMMITTED, yii\db\Transaction::READ_COMMITTED, yii\db\Transaction::REPEATABLE_READ and yii\db\Transaction::SERIALIZABLE but also a string containing DBMS specific syntax to be used after SET TRANSACTION ISOLATION LEVEL
.
public void setTransactionIsolationLevel ( $level )
Mapping from physical column types (keys) to abstract column types (values) Please refer to CUBRID manual for details on data types.
public array $typeMap = ['short' => self::TYPE_SMALLINT, 'smallint' => self::TYPE_SMALLINT, 'int' => self::TYPE_INTEGER, 'integer' => self::TYPE_INTEGER, 'bigint' => self::TYPE_BIGINT, 'numeric' => self::TYPE_DECIMAL, 'decimal' => self::TYPE_DECIMAL, 'float' => self::TYPE_FLOAT, 'real' => self::TYPE_FLOAT, 'double' => self::TYPE_DOUBLE, 'double precision' => self::TYPE_DOUBLE, 'monetary' => self::TYPE_MONEY, 'date' => self::TYPE_DATE, 'time' => self::TYPE_TIME, 'timestamp' => self::TYPE_TIMESTAMP, 'datetime' => self::TYPE_DATETIME, 'char' => self::TYPE_CHAR, 'varchar' => self::TYPE_STRING, 'char varying' => self::TYPE_STRING, 'nchar' => self::TYPE_CHAR, 'nchar varying' => self::TYPE_STRING, 'string' => self::TYPE_STRING, 'blob' => self::TYPE_BINARY, 'clob' => self::TYPE_BINARY, 'bit' => self::TYPE_INTEGER, 'bit varying' => self::TYPE_INTEGER, 'set' => self::TYPE_STRING, 'multiset' => self::TYPE_STRING, 'list' => self::TYPE_STRING, 'sequence' => self::TYPE_STRING, 'enum' => self::TYPE_STRING]
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\ColumnSchemaBuilder createColumnSchemaBuilder ( $type, $length = null ) | ||
---|---|---|
$type | string |
Type of the column. See yii\db\cubrid\ColumnSchemaBuilder::$type. |
$length | integer|string|array |
Length or precision of the column. See yii\db\cubrid\ColumnSchemaBuilder::$length. |
return | yii\db\ColumnSchemaBuilder |
Column schema builder instance |
Creates a query builder for the CUBRID database.
public yii\db\cubrid\QueryBuilder createQueryBuilder ( ) | ||
---|---|---|
return | yii\db\cubrid\QueryBuilder |
Query builder instance |
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. |
Determines the PDO type for the given PHP data value.
See also http://www.php.net/manual/en/pdo.constants.php.
public integer getPdoType ( $data ) | ||
---|---|---|
$data | mixed |
The data whose PDO type is to be determined |
return | integer |
The PDO type |
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 |
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. |
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 |
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 |
Releases an existing savepoint.
public void releaseSavepoint ( $name ) | ||
---|---|---|
$name | string |
The savepoint name |
Sets the isolation level of the current transaction.
See also http://www.cubrid.org/manual/91/en/sql/transaction.html#database-concurrency.
public void setTransactionIsolationLevel ( $level ) | ||
---|---|---|
$level | string |
The transaction isolation level to use for this transaction. This can be one of yii\db\Transaction::READ_UNCOMMITTED, yii\db\Transaction::READ_COMMITTED, yii\db\Transaction::REPEATABLE_READ and yii\db\Transaction::SERIALIZABLE but also a string containing DBMS specific syntax to be used after |
© 2008–2017 by Yii Software LLC
Licensed under the three clause BSD license.
http://www.yiiframework.com/doc-2.0/yii-db-cubrid-schema.html