Révision b4adf10d
Ajouté par Assos Assos il y a plus de 9 ans
| drupal7/includes/database/pgsql/schema.inc | ||
|---|---|---|
| 314 | 314 |
|
| 315 | 315 |
function renameTable($table, $new_name) {
|
| 316 | 316 |
if (!$this->tableExists($table)) {
|
| 317 |
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot rename %table to %table_new: table %table doesn't exist.", array('%table' => $table, '%table_new' => $new_name)));
|
|
| 317 |
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot rename @table to @table_new: table @table doesn't exist.", array('@table' => $table, '@table_new' => $new_name)));
|
|
| 318 | 318 |
} |
| 319 | 319 |
if ($this->tableExists($new_name)) {
|
| 320 |
throw new DatabaseSchemaObjectExistsException(t("Cannot rename %table to %table_new: table %table_new already exists.", array('%table' => $table, '%table_new' => $new_name)));
|
|
| 320 |
throw new DatabaseSchemaObjectExistsException(t("Cannot rename @table to @table_new: table @table_new already exists.", array('@table' => $table, '@table_new' => $new_name)));
|
|
| 321 | 321 |
} |
| 322 | 322 |
|
| 323 | 323 |
// Get the schema and tablename for the old table. |
| ... | ... | |
| 351 | 351 |
|
| 352 | 352 |
public function addField($table, $field, $spec, $new_keys = array()) {
|
| 353 | 353 |
if (!$this->tableExists($table)) {
|
| 354 |
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot add field %table.%field: table doesn't exist.", array('%field' => $field, '%table' => $table)));
|
|
| 354 |
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot add field @table.@field: table doesn't exist.", array('@field' => $field, '@table' => $table)));
|
|
| 355 | 355 |
} |
| 356 | 356 |
if ($this->fieldExists($table, $field)) {
|
| 357 |
throw new DatabaseSchemaObjectExistsException(t("Cannot add field %table.%field: field already exists.", array('%field' => $field, '%table' => $table)));
|
|
| 357 |
throw new DatabaseSchemaObjectExistsException(t("Cannot add field @table.@field: field already exists.", array('@field' => $field, '@table' => $table)));
|
|
| 358 | 358 |
} |
| 359 | 359 |
|
| 360 | 360 |
$fixnull = FALSE; |
| ... | ... | |
| 393 | 393 |
|
| 394 | 394 |
public function fieldSetDefault($table, $field, $default) {
|
| 395 | 395 |
if (!$this->fieldExists($table, $field)) {
|
| 396 |
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot set default value of field %table.%field: field doesn't exist.", array('%table' => $table, '%field' => $field)));
|
|
| 396 |
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot set default value of field @table.@field: field doesn't exist.", array('@table' => $table, '@field' => $field)));
|
|
| 397 | 397 |
} |
| 398 | 398 |
|
| 399 | 399 |
if (!isset($default)) {
|
| ... | ... | |
| 408 | 408 |
|
| 409 | 409 |
public function fieldSetNoDefault($table, $field) {
|
| 410 | 410 |
if (!$this->fieldExists($table, $field)) {
|
| 411 |
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot remove default value of field %table.%field: field doesn't exist.", array('%table' => $table, '%field' => $field)));
|
|
| 411 |
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot remove default value of field @table.@field: field doesn't exist.", array('@table' => $table, '@field' => $field)));
|
|
| 412 | 412 |
} |
| 413 | 413 |
|
| 414 | 414 |
$this->connection->query('ALTER TABLE {' . $table . '} ALTER COLUMN "' . $field . '" DROP DEFAULT');
|
| ... | ... | |
| 435 | 435 |
|
| 436 | 436 |
public function addPrimaryKey($table, $fields) {
|
| 437 | 437 |
if (!$this->tableExists($table)) {
|
| 438 |
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot add primary key to table %table: table doesn't exist.", array('%table' => $table)));
|
|
| 438 |
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot add primary key to table @table: table doesn't exist.", array('@table' => $table)));
|
|
| 439 | 439 |
} |
| 440 | 440 |
if ($this->constraintExists($table, 'pkey')) {
|
| 441 |
throw new DatabaseSchemaObjectExistsException(t("Cannot add primary key to table %table: primary key already exists.", array('%table' => $table)));
|
|
| 441 |
throw new DatabaseSchemaObjectExistsException(t("Cannot add primary key to table @table: primary key already exists.", array('@table' => $table)));
|
|
| 442 | 442 |
} |
| 443 | 443 |
|
| 444 | 444 |
$this->connection->query('ALTER TABLE {' . $table . '} ADD PRIMARY KEY (' . implode(',', $fields) . ')');
|
| ... | ... | |
| 455 | 455 |
|
| 456 | 456 |
function addUniqueKey($table, $name, $fields) {
|
| 457 | 457 |
if (!$this->tableExists($table)) {
|
| 458 |
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot add unique key %name to table %table: table doesn't exist.", array('%table' => $table, '%name' => $name)));
|
|
| 458 |
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot add unique key @name to table @table: table doesn't exist.", array('@table' => $table, '@name' => $name)));
|
|
| 459 | 459 |
} |
| 460 | 460 |
if ($this->constraintExists($table, $name . '_key')) {
|
| 461 |
throw new DatabaseSchemaObjectExistsException(t("Cannot add unique key %name to table %table: unique key already exists.", array('%table' => $table, '%name' => $name)));
|
|
| 461 |
throw new DatabaseSchemaObjectExistsException(t("Cannot add unique key @name to table @table: unique key already exists.", array('@table' => $table, '@name' => $name)));
|
|
| 462 | 462 |
} |
| 463 | 463 |
|
| 464 | 464 |
$this->connection->query('ALTER TABLE {' . $table . '} ADD CONSTRAINT "' . $this->prefixNonTable($table, $name, 'key') . '" UNIQUE (' . implode(',', $fields) . ')');
|
| ... | ... | |
| 475 | 475 |
|
| 476 | 476 |
public function addIndex($table, $name, $fields) {
|
| 477 | 477 |
if (!$this->tableExists($table)) {
|
| 478 |
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot add index %name to table %table: table doesn't exist.", array('%table' => $table, '%name' => $name)));
|
|
| 478 |
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot add index @name to table @table: table doesn't exist.", array('@table' => $table, '@name' => $name)));
|
|
| 479 | 479 |
} |
| 480 | 480 |
if ($this->indexExists($table, $name)) {
|
| 481 |
throw new DatabaseSchemaObjectExistsException(t("Cannot add index %name to table %table: index already exists.", array('%table' => $table, '%name' => $name)));
|
|
| 481 |
throw new DatabaseSchemaObjectExistsException(t("Cannot add index @name to table @table: index already exists.", array('@table' => $table, '@name' => $name)));
|
|
| 482 | 482 |
} |
| 483 | 483 |
|
| 484 | 484 |
$this->connection->query($this->_createIndexSql($table, $name, $fields)); |
| ... | ... | |
| 495 | 495 |
|
| 496 | 496 |
public function changeField($table, $field, $field_new, $spec, $new_keys = array()) {
|
| 497 | 497 |
if (!$this->fieldExists($table, $field)) {
|
| 498 |
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot change the definition of field %table.%name: field doesn't exist.", array('%table' => $table, '%name' => $field)));
|
|
| 498 |
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot change the definition of field @table.@name: field doesn't exist.", array('@table' => $table, '@name' => $field)));
|
|
| 499 | 499 |
} |
| 500 | 500 |
if (($field != $field_new) && $this->fieldExists($table, $field_new)) {
|
| 501 |
throw new DatabaseSchemaObjectExistsException(t("Cannot rename field %table.%name to %name_new: target field already exists.", array('%table' => $table, '%name' => $field, '%name_new' => $field_new)));
|
|
| 501 |
throw new DatabaseSchemaObjectExistsException(t("Cannot rename field @table.@name to @name_new: target field already exists.", array('@table' => $table, '@name' => $field, '@name_new' => $field_new)));
|
|
| 502 | 502 |
} |
| 503 | 503 |
|
| 504 | 504 |
$spec = $this->processField($spec); |
Formats disponibles : Unified diff
Udpate to 7.33