COciSchema
鍖 | system.db.schema.oci |
---|---|
缁ф壙 | class COciSchema » CDbSchema » CComponent |
鐗堟湰 | $Id: COciSchema.php 3515 2011-12-28 12:29:24Z mdomba $ |
婧愮爜 | framework/db/schema/oci/COciSchema.php |
COciSchema鏄粠Oracle鏁版嵁搴撴绱㈠厓鏁版嵁淇℃伅鐨勭被銆
鍏叡灞炴
灞炴 | 绫诲瀷 | 鎻忚堪 | 瀹氫箟鍦 |
---|---|---|---|
columnTypes | array | 鏄犲皠鍒板疄浣撳垪绫诲瀷鐨勬娊璞″垪绫诲瀷銆 | COciSchema |
commandBuilder | CDbCommandBuilder | the SQL command builder for this connection. | CDbSchema |
dbConnection | CDbConnection | database connection. | CDbSchema |
defaultSchema | string | 榛樿schema銆 | COciSchema |
tableNames | array | Returns all table names in the database. | CDbSchema |
tables | array | Returns the metadata for all tables in the database. | CDbSchema |
鍏叡鏂规硶
鏂规硶 | 鎻忚堪 | 瀹氫箟鍦 |
---|---|---|
__call() | 濡傛灉绫讳腑娌℃湁璋冪殑鏂规硶鍚嶏紝鍒欒皟鐢ㄨ繖涓柟娉曘 | CComponent |
__construct() | Constructor. | CDbSchema |
__get() | 杩斿洖涓涓睘鎬у笺佷竴涓簨浠跺鐞嗙▼搴忓垪琛ㄦ垨涓涓涓哄悕绉般 | CComponent |
__isset() | 妫鏌ヤ竴涓睘鎬ф槸鍚︿负null銆 | CComponent |
__set() | 璁剧疆涓涓粍浠剁殑灞炴у笺 | CComponent |
__unset() | 璁剧疆涓涓粍浠剁殑灞炴т负null銆 | CComponent |
addColumn() | Builds a SQL statement for adding a new DB column. | CDbSchema |
addForeignKey() | Builds a SQL statement for adding a foreign key constraint to an existing table. | CDbSchema |
alterColumn() | 鏋勯犳敼鍙樺垪瀹氫箟鐨凷QL璇彞銆 | COciSchema |
asa() | 杩斿洖杩欎釜鍚嶅瓧鐨勮涓哄璞° | CComponent |
attachBehavior() | 闄勫姞涓涓涓哄埌缁勪欢銆 | CComponent |
attachBehaviors() | 闄勫姞涓涓涓哄垪琛ㄥ埌缁勪欢銆 | CComponent |
attachEventHandler() | 涓轰簨浠堕檮鍔犱竴涓簨浠跺鐞嗙▼搴忋 | CComponent |
canGetProperty() | 纭畾灞炴ф槸鍚﹀彲璇汇 | CComponent |
canSetProperty() | 纭畾灞炴ф槸鍚﹀彲鍐欍 | CComponent |
checkIntegrity() | Enables or disables integrity check. | CDbSchema |
compareTableNames() | Compares two table names. | CDbSchema |
createIndex() | Builds a SQL statement for creating a new index. | CDbSchema |
createTable() | Builds a SQL statement for creating a new DB table. | CDbSchema |
detachBehavior() | 浠庣粍浠朵腑鍒嗙涓涓涓恒 | CComponent |
detachBehaviors() | 浠庣粍浠朵腑鍒嗙鎵鏈夎涓恒 | CComponent |
detachEventHandler() | 鍒嗙涓涓瓨鍦ㄧ殑浜嬩欢澶勭悊绋嬪簭銆 | CComponent |
disableBehavior() | 绂佺敤涓涓檮鍔犺涓恒 | CComponent |
disableBehaviors() | 绂佺敤缁勪欢闄勫姞鐨勬墍鏈夎涓恒 | CComponent |
dropColumn() | Builds a SQL statement for dropping a DB column. | CDbSchema |
dropForeignKey() | Builds a SQL statement for dropping a foreign key constraint. | CDbSchema |
dropIndex() | 鏋勯犲垹闄ょ储寮曠殑SQL璇彞銆 | COciSchema |
dropTable() | Builds a SQL statement for dropping a DB table. | CDbSchema |
enableBehavior() | 鍚敤涓涓檮鍔犺涓恒 | CComponent |
enableBehaviors() | 鍚敤缁勪欢闄勫姞鐨勬墍鏈夎涓恒 | CComponent |
evaluateExpression() | 璁$畻涓涓狿HP琛ㄨ揪寮忥紝鎴栨牴鎹粍浠朵笂涓嬫枃鎵ц鍥炶皟銆 | CComponent |
getColumnType() | Converts an abstract column type into a physical column type. | CDbSchema |
getCommandBuilder() | 杩斿洖the SQL command builder for this connection. | CDbSchema |
getDbConnection() | 杩斿洖database connection. The connection is active. | CDbSchema |
getDefaultSchema() | 杩斿洖榛樿schema銆 | COciSchema |
getEventHandlers() | 杩斿洖涓涓簨浠剁殑闄勫姞澶勭悊绋嬪簭鍒楄〃銆 | CComponent |
getTable() | Obtains the metadata for the named table. | CDbSchema |
getTableNames() | Returns all table names in the database. | CDbSchema |
getTables() | Returns the metadata for all tables in the database. | CDbSchema |
hasEvent() | 纭畾涓涓簨浠舵槸鍚﹀畾涔夈 | CComponent |
hasEventHandler() | 妫鏌ヤ簨浠舵槸鍚︽湁闄勫姞鐨勫鐞嗙▼搴忋 | CComponent |
hasProperty() | 纭畾灞炴ф槸鍚﹁瀹氫箟銆 | CComponent |
quoteColumnName() | Quotes a column name for use in a query. | CDbSchema |
quoteSimpleColumnName() | 鐢ㄥ紩鍙峰紩鐢ㄥ垪鍚嶄互渚挎煡璇㈡椂浣跨敤銆 | COciSchema |
quoteSimpleTableName() | 鐢ㄥ紩鍙峰紩鐢ㄨ〃鍚嶄互渚挎煡璇㈡椂浣跨敤銆 | COciSchema |
quoteTableName() | Quotes a table name for use in a query. | CDbSchema |
raiseEvent() | 鍙戣捣涓涓簨浠躲 | CComponent |
refresh() | Refreshes the schema. | CDbSchema |
renameColumn() | Builds a SQL statement for renaming a column. | CDbSchema |
renameTable() | 鏋勯犻噸鍛藉悕鏁版嵁琛ㄧ殑SQL璇彞銆 | COciSchema |
resetSequence() | Resets the sequence value of a table's primary key. | CDbSchema |
setDefaultSchema() | 璁剧疆榛樿schema銆 | COciSchema |
truncateTable() | Builds a SQL statement for truncating a DB table. | CDbSchema |
鍙椾繚鎶ゆ柟娉
鏂规硶 | 鎻忚堪 | 瀹氫箟鍦 |
---|---|---|
createColumn() | 鍒涘缓涓涓垪銆 | COciSchema |
createCommandBuilder() | 涓烘暟鎹簱鍒涘缓鍛戒护鏋勫缓鍣ㄣ | COciSchema |
findColumns() | 鏀堕泦鍒楃殑鍏冩暟鎹 | COciSchema |
findConstraints() | 鏀堕泦缁欏畾琛ㄤ富閿垪鍜屽閿垪鐨勮缁嗕俊鎭 | COciSchema |
findTableNames() | 杩斿洖鎵鏈夋暟鎹簱閲岀殑琛ㄥ悕銆 | COciSchema |
getSchemaTableName() | 杩斿洖锛$schemaName锛$tableName锛夊舰寮忕殑鏁扮粍 | COciSchema |
loadTable() | 涓烘寚瀹氳〃杞藉叆鍏冩暟鎹 | COciSchema |
resolveTableNames() | 鐢熸垚鍚勭琛ㄥ悕銆 | COciSchema |
灞炴ц缁
columnTypes
灞炴
锛堝彲鐢ㄨ嚜 v1.1.6锛
public array $columnTypes;
鏄犲皠鍒板疄浣撳垪绫诲瀷鐨勬娊璞″垪绫诲瀷銆
defaultSchema
灞炴
榛樿schema銆
鏂规硶璇︾粏
alterColumn()
鏂规硶
锛堝彲鐢ㄨ嚜 v1.1.6锛
public string alterColumn(string $table, string $column, string $type)
| ||
$table | string | 瑕佹敼鍙樼殑鍒楁墍鍦ㄨ〃銆傝琛ㄥ悕浼氳鎸囧畾鏂规硶姝g‘寮曠敤銆 |
$column | string | 瑕佹敼鍙樼殑鍒楀悕銆傝鍒楀悕浼氳鎸囧畾鏂规硶姝g‘寮曠敤銆 |
$type | string | 鏂扮殑鍒楃被鍨嬨getColumnType鏂规硶浼氳璋冪敤鏉ュ皢铏氭嫙鍒楃被鍨嬶紙鑻ュ瓨鍦級 杞崲涓哄搴旂殑瀹炰綋鍒楃被鍨嬨備换浣曟湭琚瘑鍒负铏氭嫙绫诲瀷鐨勭被鍨嬩細琚繚鐣欏湪鐢熸垚鐨凷QL涓 渚嬪锛屸榮tring鈥欎細琚浆涓衡榲archar(255)鈥欙紝鑰屸榮tring not null鈥欎細琚浆涓衡榲archar(255) not null鈥欍 |
{return} | string | 鏀瑰彉鍒楀畾涔夌殑SQL璇彞銆 |
婧愮爜锛 framework/db/schema/oci/COciSchema.php#330 (鏄剧ず)
public function alterColumn($table, $column, $type)
{
$type=$this->getColumnType($type);
$sql='ALTER TABLE ' . $this->quoteTableName($table) . ' MODIFY '
. $this->quoteColumnName($column) . ' '
. $this->getColumnType($type);
return $sql;
}
鏋勯犳敼鍙樺垪瀹氫箟鐨凷QL璇彞銆
createColumn()
鏂规硶
protected CDbColumnSchema createColumn(array $column)
| ||
$column | array | 鍒楀厓鏁版嵁 |
{return} | CDbColumnSchema | 瑙勮寖鐨勫垪鍏冩暟鎹 |
婧愮爜锛 framework/db/schema/oci/COciSchema.php#225 (鏄剧ず)
protected function createColumn($column)
{
$c=new COciColumnSchema;
$c->name=$column['COLUMN_NAME'];
$c->rawName=$this->quoteColumnName($c->name);
$c->allowNull=$column['NULLABLE']==='Y';
$c->isPrimaryKey=strpos($column['KEY'],'P')!==false;
$c->isForeignKey=false;
$c->init($column['DATA_TYPE'],$column['DATA_DEFAULT']);
return $c;
}
鍒涘缓涓涓垪銆
createCommandBuilder()
鏂规硶
protected CDbCommandBuilder createCommandBuilder()
| ||
{return} | CDbCommandBuilder | 鍛戒护鏋勫缓鍣ㄥ疄渚 |
婧愮爜锛 framework/db/schema/oci/COciSchema.php#73 (鏄剧ず)
protected function createCommandBuilder()
{
return new COciCommandBuilder($this);
}
涓烘暟鎹簱鍒涘缓鍛戒护鏋勫缓鍣ㄣ 璇ユ柟娉曞彲浠ヨ瀛愮被閲嶅啓浠ュ垱寤轰竴涓寚瀹欴BMS鐨勫懡浠ゆ瀯寤哄櫒銆
dropIndex()
鏂规硶
锛堝彲鐢ㄨ嚜 v1.1.6锛
public string dropIndex(string $name, string $table)
| ||
$name | string | 瑕佸垹闄ょ殑绱㈠紩鍚嶃傝绱㈠紩鍚嶄細琚寚瀹氭柟娉曟纭紩鐢ㄣ |
$table | string | 瑕佸垹闄ょ殑绱㈠紩鎵鍦ㄨ〃銆傝琛ㄥ悕浼氳鎸囧畾鏂规硶姝g‘寮曠敤銆 |
{return} | string | 鍒犻櫎绱㈠紩鐨凷QL璇彞銆 |
婧愮爜锛 framework/db/schema/oci/COciSchema.php#346 (鏄剧ず)
public function dropIndex($name, $table)
{
return 'DROP INDEX '.$this->quoteTableName($name);
}
鏋勯犲垹闄ょ储寮曠殑SQL璇彞銆
findColumns()
鏂规硶
protected boolean findColumns(COciTableSchema $table)
| ||
$table | COciTableSchema | 琛ㄥ厓鏁版嵁 |
{return} | boolean | 琛ㄦ槸鍚﹀瓨鍦ㄤ簬鏁版嵁搴撻噷 |
婧愮爜锛 framework/db/schema/oci/COciSchema.php#161 (鏄剧ず)
protected function findColumns($table)
{
$schemaName=$table->schemaName;
$tableName=$table->name;
$sql=<<<EOD
SELECT a.column_name, a.data_type ||
case
when data_precision is not null
then '(' || a.data_precision ||
case when a.data_scale > 0 then ',' || a.data_scale else '' end
|| ')'
when data_type = 'DATE' then ''
when data_type = 'NUMBER' then ''
else '(' || to_char(a.data_length) || ')'
end as data_type,
a.nullable, a.data_default,
( SELECT D.constraint_type
FROM ALL_CONS_COLUMNS C
inner join ALL_constraints D on D.OWNER = C.OWNER and D.constraint_name = C.constraint_name
WHERE C.OWNER = B.OWNER
and C.table_name = B.object_name
and C.column_name = A.column_name
and D.constraint_type = 'P') as Key
FROM ALL_TAB_COLUMNS A
inner join ALL_OBJECTS B ON b.owner = a.owner and ltrim(B.OBJECT_NAME) = ltrim(A.TABLE_NAME)
WHERE
a.owner = '{$schemaName}'
and (b.object_type = 'TABLE' or b.object_type = 'VIEW')
and b.object_name = '{$tableName}'
ORDER by a.column_id
EOD;
$command=$this->getDbConnection()->createCommand($sql);
if(($columns=$command->queryAll())===array()){
return false;
}
foreach($columns as $column)
{
$c=$this->createColumn($column);
$table->columns[$c->name]=$c;
if($c->isPrimaryKey)
{
if($table->primaryKey===null)
$table->primaryKey=$c->name;
else if(is_string($table->primaryKey))
$table->primaryKey=array($table->primaryKey,$c->name);
else
$table->primaryKey[]=$c->name;
$table->sequenceName='';
$c->autoIncrement=true;
}
}
return true;
}
鏀堕泦鍒楃殑鍏冩暟鎹
findConstraints()
鏂规硶
protected void findConstraints(COciTableSchema $table)
| ||
$table | COciTableSchema | 琛ㄥ厓鏁版嵁 |
婧愮爜锛 framework/db/schema/oci/COciSchema.php#242 (鏄剧ず)
protected function findConstraints($table)
{
$sql=<<<EOD
SELECT D.constraint_type as CONSTRAINT_TYPE, C.COLUMN_NAME, C.position, D.r_constraint_name,
E.table_name as table_ref, f.column_name as column_ref,
C.table_name
FROM ALL_CONS_COLUMNS C
inner join ALL_constraints D on D.OWNER = C.OWNER and D.constraint_name = C.constraint_name
left join ALL_constraints E on E.OWNER = D.r_OWNER and E.constraint_name = D.r_constraint_name
left join ALL_cons_columns F on F.OWNER = E.OWNER and F.constraint_name = E.constraint_name and F.position = c.position
WHERE C.OWNER = '{$table->schemaName}'
and C.table_name = '{$table->name}'
and D.constraint_type <> 'P'
order by d.constraint_name, c.position
EOD;
$command=$this->getDbConnection()->createCommand($sql);
foreach($command->queryAll() as $row)
{
if($row['CONSTRAINT_TYPE']==='R') // foreign key
{
$name = $row["COLUMN_NAME"];
$table->foreignKeys[$name]=array($row["TABLE_REF"], $row["COLUMN_REF"]);
if(isset($table->columns[$name]))
$table->columns[$name]->isForeignKey=true;
}
}
}
鏀堕泦缁欏畾琛ㄤ富閿垪鍜屽閿垪鐨勮缁嗕俊鎭
findTableNames()
鏂规硶
protected array findTableNames(string $schema='')
| ||
$schema | string | 琛╯chema銆傞粯璁ゆ槸绌哄瓧绗︿覆锛屾剰鍛崇潃褰撳墠鎴栭粯璁chema銆 鑻ヤ负绌猴紝鍒欒繑鍥炵殑琛ㄥ悕浼氳鍔犱笂schema鍚嶅墠缂銆 |
{return} | array | 鏁版嵁搴撻噷鐨勬墍鏈夎〃鍚嶃 |
婧愮爜锛 framework/db/schema/oci/COciSchema.php#277 (鏄剧ず)
protected function findTableNames($schema='')
{
if($schema==='')
{
$sql=<<<EOD
SELECT table_name, '{$schema}' as table_schema FROM user_tables
EOD;
$command=$this->getDbConnection()->createCommand($sql);
}
else
{
$sql=<<<EOD
SELECT object_name as table_name, owner as table_schema FROM all_objects
WHERE object_type = 'TABLE' AND owner=:schema
EOD;
$command=$this->getDbConnection()->createCommand($sql);
$command->bindParam(':schema',$schema);
}
$rows=$command->queryAll();
$names=array();
foreach($rows as $row)
{
if($schema===$this->getDefaultSchema() || $schema==='')
$names[]=$row['TABLE_NAME'];
else
$names[]=$row['TABLE_SCHEMA'].'.'.$row['TABLE_NAME'];
}
return $names;
}
杩斿洖鎵鏈夋暟鎹簱閲岀殑琛ㄥ悕銆
getDefaultSchema()
鏂规硶
public string getDefaultSchema()
| ||
{return} | string | 榛樿schema銆 |
婧愮爜锛 framework/db/schema/oci/COciSchema.php#89 (鏄剧ず)
public function getDefaultSchema()
{
if (!strlen($this->_defaultSchema))
{
$this->setDefaultSchema(strtoupper($this->getDbConnection()->username));
}
return $this->_defaultSchema;
}
getSchemaTableName()
鏂规硶
protected array getSchemaTableName(string $table)
| ||
$table | string | 甯︽湁鍙塻chema鍚嶄綔涓哄墠缂鐨勮〃鍚嶏紝涓嶆彁渚涗娇鐢ㄩ粯璁chema鍚嶄綔涓哄墠缂鐨勮〃鍚嶃 |
{return} | array | 锛$schemaName锛$tableName锛夊舰寮忕殑鏁扮粍 |
婧愮爜锛 framework/db/schema/oci/COciSchema.php#103 (鏄剧ず)
protected function getSchemaTableName($table)
{
$table = strtoupper($table);
if(count($parts= explode('.', str_replace('"','',$table))) > 1)
return array($parts[0], $parts[1]);
else
return array($this->getDefaultSchema(),$parts[0]);
}
loadTable()
鏂规硶
protected CDbTableSchema loadTable(string $name)
| ||
$name | string | 琛ㄥ悕 |
{return} | CDbTableSchema | 鍙栧喅浜庤〃鍏冩暟鎹殑椹卞姩銆 |
婧愮爜锛 framework/db/schema/oci/COciSchema.php#117 (鏄剧ず)
protected function loadTable($name)
{
$table=new COciTableSchema;
$this->resolveTableNames($table,$name);
if(!$this->findColumns($table))
return null;
$this->findConstraints($table);
return $table;
}
涓烘寚瀹氳〃杞藉叆鍏冩暟鎹
quoteSimpleColumnName()
鏂规硶
锛堝彲鐢ㄨ嚜 v1.1.6锛
public string quoteSimpleColumnName(string $name)
| ||
$name | string | 鍒楀悕 |
{return} | string | 姝g‘寮曠敤鐨勫垪鍚 |
婧愮爜锛 framework/db/schema/oci/COciSchema.php#63 (鏄剧ず)
public function quoteSimpleColumnName($name)
{
return '"'.$name.'"';
}
鐢ㄥ紩鍙峰紩鐢ㄥ垪鍚嶄互渚挎煡璇㈡椂浣跨敤銆 涓涓笉鍖呮嫭鍓嶇紑鐨勭畝鍗曞垪鍚嶃
quoteSimpleTableName()
鏂规硶
锛堝彲鐢ㄨ嚜 v1.1.6锛
public string quoteSimpleTableName(string $name)
| ||
$name | string | 琛ㄥ悕 |
{return} | string | 姝g‘寮曠敤鐨勮〃鍚 |
婧愮爜锛 framework/db/schema/oci/COciSchema.php#51 (鏄剧ず)
public function quoteSimpleTableName($name)
{
return '"'.$name.'"';
}
鐢ㄥ紩鍙峰紩鐢ㄨ〃鍚嶄互渚挎煡璇㈡椂浣跨敤銆 涓涓笉鍖呮嫭鍓嶇紑鐨勭畝鍗曡〃鍚嶃
renameTable()
鏂规硶
锛堝彲鐢ㄨ嚜 v1.1.6锛
public string renameTable(string $table, string $newName)
| ||
$table | string | 瑕侀噸鍛藉悕鐨勮〃銆傝琛ㄥ悕浼氳鎸囧畾鏂规硶姝g‘寮曠敤銆 |
$newName | string | 鏂拌〃鍚嶃 璇ヨ〃鍚嶄細琚寚瀹氭柟娉曟纭紩鐢ㄣ |
{return} | string | 閲嶅懡鍚嶆暟鎹〃鐨凷QL璇彞銆 |
婧愮爜锛 framework/db/schema/oci/COciSchema.php#315 (鏄剧ず)
public function renameTable($table, $newName)
{
return 'ALTER TABLE ' . $this->quoteTableName($table) . ' RENAME TO ' . $this->quoteTableName($newName);
}
鏋勯犻噸鍛藉悕鏁版嵁琛ㄧ殑SQL璇彞銆
resolveTableNames()
鏂规硶
protected void resolveTableNames(COciTableSchema $table, string $name)
| ||
$table | COciTableSchema | 琛ㄥ厓鏁版嵁 |
$name | string | 鏈紩鐢ㄧ殑琛ㄥ悕 |
婧愮爜锛 framework/db/schema/oci/COciSchema.php#134 (鏄剧ず)
protected function resolveTableNames($table,$name)
{
$parts=explode('.',str_replace('"','',$name));
if(isset($parts[1]))
{
$schemaName=$parts[0];
$tableName=$parts[1];
}
else
{
$schemaName=$this->getDefaultSchema();
$tableName=$parts[0];
}
$table->name=$tableName;
$table->schemaName=$schemaName;
if($schemaName===$this->getDefaultSchema())
$table->rawName=$this->quoteTableName($tableName);
else
$table->rawName=$this->quoteTableName($schemaName).'.'.$this->quoteTableName($tableName);
}
鐢熸垚鍚勭琛ㄥ悕銆
setDefaultSchema()
鏂规硶
public void setDefaultSchema(string $schema)
| ||
$schema | string | 榛樿schema銆 |
婧愮爜锛 framework/db/schema/oci/COciSchema.php#81 (鏄剧ず)
public function setDefaultSchema($schema)
{
$this->_defaultSchema=$schema;
}