function Schema::addField

Same name in this branch
  1. 10 core/modules/mysql/src/Driver/Database/mysql/Schema.php \Drupal\mysql\Driver\Database\mysql\Schema::addField()
  2. 10 core/modules/pgsql/src/Driver/Database/pgsql/Schema.php \Drupal\pgsql\Driver\Database\pgsql\Schema::addField()
  3. 10 core/tests/fixtures/database_drivers/module/core_fake/src/Driver/Database/CoreFakeWithAllCustomClasses/Schema.php \Drupal\core_fake\Driver\Database\CoreFakeWithAllCustomClasses\Schema::addField()
  4. 10 core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::addField()
Same name in other branches
  1. 9 core/modules/sqlite/src/Driver/Database/sqlite/Schema.php \Drupal\sqlite\Driver\Database\sqlite\Schema::addField()
  2. 9 core/modules/mysql/src/Driver/Database/mysql/Schema.php \Drupal\mysql\Driver\Database\mysql\Schema::addField()
  3. 9 core/modules/pgsql/src/Driver/Database/pgsql/Schema.php \Drupal\pgsql\Driver\Database\pgsql\Schema::addField()
  4. 9 core/tests/fixtures/database_drivers/module/corefake/src/Driver/Database/corefakeWithAllCustomClasses/Schema.php \Drupal\corefake\Driver\Database\corefakeWithAllCustomClasses\Schema::addField()
  5. 9 core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::addField()
  6. 8.9.x core/lib/Drupal/Core/Database/Driver/sqlite/Schema.php \Drupal\Core\Database\Driver\sqlite\Schema::addField()
  7. 8.9.x core/lib/Drupal/Core/Database/Driver/mysql/Schema.php \Drupal\Core\Database\Driver\mysql\Schema::addField()
  8. 8.9.x core/lib/Drupal/Core/Database/Driver/pgsql/Schema.php \Drupal\Core\Database\Driver\pgsql\Schema::addField()
  9. 8.9.x core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::addField()
  10. 11.x core/modules/sqlite/src/Driver/Database/sqlite/Schema.php \Drupal\sqlite\Driver\Database\sqlite\Schema::addField()
  11. 11.x core/modules/mysql/src/Driver/Database/mysql/Schema.php \Drupal\mysql\Driver\Database\mysql\Schema::addField()
  12. 11.x core/modules/pgsql/src/Driver/Database/pgsql/Schema.php \Drupal\pgsql\Driver\Database\pgsql\Schema::addField()
  13. 11.x core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::addField()

Overrides Schema::addField

File

core/modules/sqlite/src/Driver/Database/sqlite/Schema.php, line 311

Class

Schema
SQLite implementation of \Drupal\Core\Database\Schema.

Namespace

Drupal\sqlite\Driver\Database\sqlite

Code

public function addField($table, $field, $specification, $keys_new = []) {
    if (!$this->tableExists($table)) {
        throw new SchemaObjectDoesNotExistException("Cannot add field '{$table}.{$field}': table doesn't exist.");
    }
    if ($this->fieldExists($table, $field)) {
        throw new SchemaObjectExistsException("Cannot add field '{$table}.{$field}': field already exists.");
    }
    if (isset($keys_new['primary key']) && in_array($field, $keys_new['primary key'], TRUE)) {
        $this->ensureNotNullPrimaryKey($keys_new['primary key'], [
            $field => $specification,
        ]);
    }
    // SQLite doesn't have a full-featured ALTER TABLE statement. It only
    // supports adding new fields to a table, in some simple cases. In most
    // cases, we have to create a new table and copy the data over.
    if (empty($keys_new) && (empty($specification['not null']) || isset($specification['default']))) {
        // When we don't have to create new keys and we are not creating a
        // NOT NULL column without a default value, we can use the quicker version.
        $query = 'ALTER TABLE {' . $table . '} ADD ' . $this->createFieldSql($field, $this->processField($specification));
        $this->connection
            ->query($query);
        // Apply the initial value if set.
        if (isset($specification['initial_from_field'])) {
            if (isset($specification['initial'])) {
                $expression = 'COALESCE(' . $specification['initial_from_field'] . ', :default_initial_value)';
                $arguments = [
                    ':default_initial_value' => $specification['initial'],
                ];
            }
            else {
                $expression = $specification['initial_from_field'];
                $arguments = [];
            }
            $this->connection
                ->update($table)
                ->expression($field, $expression, $arguments)
                ->execute();
        }
        elseif (isset($specification['initial'])) {
            $this->connection
                ->update($table)
                ->fields([
                $field => $specification['initial'],
            ])
                ->execute();
        }
    }
    else {
        // We cannot add the field directly. Use the slower table alteration
        // method, starting from the old schema.
        $old_schema = $this->introspectSchema($table);
        $new_schema = $old_schema;
        // Add the new field.
        $new_schema['fields'][$field] = $specification;
        // Build the mapping between the old fields and the new fields.
        $mapping = [];
        if (isset($specification['initial_from_field'])) {
            // If we have an initial value, copy it over.
            if (isset($specification['initial'])) {
                $expression = 'COALESCE(' . $specification['initial_from_field'] . ', :default_initial_value)';
                $arguments = [
                    ':default_initial_value' => $specification['initial'],
                ];
            }
            else {
                $expression = $specification['initial_from_field'];
                $arguments = [];
            }
            $mapping[$field] = [
                'expression' => $expression,
                'arguments' => $arguments,
            ];
        }
        elseif (isset($specification['initial'])) {
            // If we have an initial value, copy it over.
            $mapping[$field] = [
                'expression' => ':newfieldinitial',
                'arguments' => [
                    ':newfieldinitial' => $specification['initial'],
                ],
            ];
        }
        else {
            // Else use the default of the field.
            $mapping[$field] = NULL;
        }
        // Add the new indexes.
        $new_schema = array_merge($new_schema, $keys_new);
        $this->alterTable($table, $old_schema, $new_schema, $mapping);
    }
}

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.