CPgsqlSchema

包	system.db.schema.pgsql
继承	class CPgsqlSchema » CDbSchema » CComponent
可用自	1.0
源码	framework/db/schema/pgsql/CPgsqlSchema.php

属性详情

the abstract column types mapped to physical column types.

方法详情

public string addColumn(string $table, string $column, string $type)
$table	string	the table that the new column will be added to. The table name will be properly quoted by the method.
$column	string	the name of the new column. The name will be properly quoted by the method.
$type	string	the 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 adding a new column.

Builds a SQL statement for adding a new DB column.

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 CPgsqlCommandBuilder createCommandBuilder()
{return}	CPgsqlCommandBuilder	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(CPgsqlTableSchema $table)
$table	CPgsqlTableSchema	the table metadata
{return}	boolean	whether the table exists in the database

Collects the table column metadata.

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

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

protected void findForeignKey(CPgsqlTableSchema $table, string $src)
$table	CPgsqlTableSchema	the table metadata
$src	string	pgsql foreign key definition

Collects foreign key information.

protected void findPrimaryKey(CPgsqlTableSchema $table, string $indices)
$table	CPgsqlTableSchema	the table metadata
$indices	string	pgsql primary key index list

Collects primary key information.

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.

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

Loads the metadata for the specified table.

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).

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

Generates various kinds of table names.