123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727 |
- <?php
- require_once dirname(__FILE__) . '/query.inc';
- abstract class DatabaseSchema implements QueryPlaceholderInterface {
- protected $connection;
-
- protected $placeholder = 0;
-
- protected $defaultSchema = 'public';
-
- protected $uniqueIdentifier;
- public function __construct($connection) {
- $this->uniqueIdentifier = uniqid('', TRUE);
- $this->connection = $connection;
- }
-
- public function __clone() {
- $this->uniqueIdentifier = uniqid('', TRUE);
- }
-
- public function uniqueIdentifier() {
- return $this->uniqueIdentifier;
- }
-
- public function nextPlaceholder() {
- return $this->placeholder++;
- }
-
- protected function getPrefixInfo($table = 'default', $add_prefix = TRUE) {
- $info = array(
- 'schema' => $this->defaultSchema,
- 'prefix' => $this->connection->tablePrefix($table),
- );
- if ($add_prefix) {
- $table = $info['prefix'] . $table;
- }
-
-
-
-
- if (($pos = strpos($table, '.')) !== FALSE) {
-
- $info['schema'] = substr($table, 0, $pos);
-
- $info['table'] = substr($table, ++$pos);
- }
- else {
- $info['table'] = $table;
- }
- return $info;
- }
-
- function prefixNonTable($table) {
- $args = func_get_args();
- $info = $this->getPrefixInfo($table);
- $args[0] = $info['table'];
- return implode('_', $args);
- }
-
- protected function buildTableNameCondition($table_name, $operator = '=', $add_prefix = TRUE) {
- $info = $this->connection->getConnectionOptions();
-
- $table_info = $this->getPrefixInfo($table_name, $add_prefix);
- $condition = new DatabaseCondition('AND');
- $condition->condition('table_catalog', $info['database']);
- $condition->condition('table_schema', $table_info['schema']);
- $condition->condition('table_name', $table_info['table'], $operator);
- return $condition;
- }
-
- public function tableExists($table) {
- $condition = $this->buildTableNameCondition($table);
- $condition->compile($this->connection, $this);
-
-
-
-
-
- return (bool) $this->connection->query("SELECT 1 FROM information_schema.tables WHERE " . (string) $condition, $condition->arguments())->fetchField();
- }
-
- public function findTables($table_expression) {
- $condition = $this->buildTableNameCondition($table_expression, 'LIKE', FALSE);
- $condition->compile($this->connection, $this);
-
-
-
-
-
- return $this->connection->query("SELECT table_name FROM information_schema.tables WHERE " . (string) $condition, $condition->arguments())->fetchAllKeyed(0, 0);
- }
-
- public function fieldExists($table, $column) {
- $condition = $this->buildTableNameCondition($table);
- $condition->condition('column_name', $column);
- $condition->compile($this->connection, $this);
-
-
-
-
-
- return (bool) $this->connection->query("SELECT 1 FROM information_schema.columns WHERE " . (string) $condition, $condition->arguments())->fetchField();
- }
-
- abstract public function getFieldTypeMap();
-
- abstract public function renameTable($table, $new_name);
-
- abstract public function dropTable($table);
-
- abstract public function addField($table, $field, $spec, $keys_new = array());
-
- abstract public function dropField($table, $field);
-
- abstract public function fieldSetDefault($table, $field, $default);
-
- abstract public function fieldSetNoDefault($table, $field);
-
- abstract public function indexExists($table, $name);
-
- abstract public function addPrimaryKey($table, $fields);
-
- abstract public function dropPrimaryKey($table);
-
- abstract public function addUniqueKey($table, $name, $fields);
-
- abstract public function dropUniqueKey($table, $name);
-
- abstract public function addIndex($table, $name, $fields);
-
- abstract public function dropIndex($table, $name);
-
- abstract public function changeField($table, $field, $field_new, $spec, $keys_new = array());
-
- public function createTable($name, $table) {
- if ($this->tableExists($name)) {
- throw new DatabaseSchemaObjectExistsException(t('Table @name already exists.', array('@name' => $name)));
- }
- $statements = $this->createTableSql($name, $table);
- foreach ($statements as $statement) {
- $this->connection->query($statement);
- }
- }
-
- public function fieldNames($fields) {
- $return = array();
- foreach ($fields as $field) {
- if (is_array($field)) {
- $return[] = $field[0];
- }
- else {
- $return[] = $field;
- }
- }
- return $return;
- }
-
- public function prepareComment($comment, $length = NULL) {
- return $this->connection->quote($comment);
- }
- }
- class DatabaseSchemaObjectExistsException extends Exception {}
- class DatabaseSchemaObjectDoesNotExistException extends Exception {}
|