COciSchema

包	system.db.schema.oci
继承	class COciSchema » CDbSchema » CComponent
源码	framework/db/schema/oci/COciSchema.php

属性详情

the abstract column types mapped to physical column types.

default schema.

方法详情

public string alterColumn(string $table, string $column, string $type)
$table	string	the table whose column is to be changed. The table name will be properly quoted by the method.
$column	string	the name of the column to be changed. The name will be properly quoted by the method.
$type	string	the new column type. The getColumnType method will be invoked to convert abstract column type (if any) into the physical one. Anything that is not recognized as abstract type will be kept in the generated SQL. For example, 'string' will be turned into 'varchar(255)', while 'string not null' will become 'varchar(255) not null'.
{return}	string	the SQL statement for changing the definition of a column.

Builds a SQL statement for changing the definition of a column.

public void checkIntegrity(boolean $check=true, string $schema='')
$check	boolean	whether to turn on or off the integrity check.
$schema	string	the schema of the tables. Defaults to empty string, meaning the current or default schema.

Enables or disables integrity check.

protected CDbColumnSchema createColumn(array $column)
$column	array	column metadata
{return}	CDbColumnSchema	normalized column metadata

Creates a table column.

protected CDbCommandBuilder createCommandBuilder()
{return}	CDbCommandBuilder	command builder instance

Creates a command builder for the database. This method may be overridden by child classes to create a DBMS-specific command builder.

public string dropIndex(string $name, string $table)
$name	string	the name of the index to be dropped. The name will be properly quoted by the method.
$table	string	the table whose index is to be dropped. The name will be properly quoted by the method.
{return}	string	the SQL statement for dropping an index.

Builds a SQL statement for dropping an index.

protected boolean findColumns(COciTableSchema $table)
$table	COciTableSchema	the table metadata
{return}	boolean	whether the table exists in the database

Collects the table column metadata.

protected void findConstraints(COciTableSchema $table)
$table	COciTableSchema	the table metadata

Collects the primary and foreign key column details for the given table.

protected array findTableNames(string $schema='')
$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.
{return}	array	all table names in the database.

Returns all table names in the database.

public string getDefaultSchema()
{return}	string	default schema.

protected array getSchemaTableName(string $table)
$table	string	table name with optional schema name prefix, uses default schema name prefix is not provided.
{return}	array	tuple as ($schemaName,$tableName)

protected CDbTableSchema loadTable(string $name)
$name	string	table name
{return}	CDbTableSchema	driver dependent table metadata.

Loads the metadata for the specified table.

public string quoteSimpleColumnName(string $name)
$name	string	column name
{return}	string	the properly quoted column name

Quotes a column name for use in a query. A simple column name does not contain prefix.

public string quoteSimpleTableName(string $name)
$name	string	table name
{return}	string	the properly quoted table name

Quotes a table name for use in a query. A simple table name does not schema prefix.

public string renameTable(string $table, string $newName)
$table	string	the table to be renamed. The name will be properly quoted by the method.
$newName	string	the new table name. The name will be properly quoted by the method.
{return}	string	the SQL statement for renaming a DB table.

Builds a SQL statement for renaming a DB table.

public void resetSequence(CDbTableSchema $table, integer|null $value=NULL)
$table	CDbTableSchema	the table schema whose primary key sequence will be reset
$value	integer|null	the value for the primary key of the next new row inserted. If this is not set, the next new row's primary key will have the max value of a primary key plus one (i.e. sequence trimming).

Resets the sequence value of a table's primary key. The sequence will be reset such that the primary key of the next new row inserted will have the specified value or max value of a primary key plus one (i.e. sequence trimming).

Note, behavior of this method has changed since 1.1.14 release. Please refer to the following issue for more details: https://github.com/yiisoft/yii/issues/2241

protected void resolveTableNames(COciTableSchema $table, string $name)
$table	COciTableSchema	the table instance
$name	string	the unquoted table name

Generates various kinds of table names.

public void setDefaultSchema(string $schema)
$schema	string	default schema.