protected function Schema::createFieldSql

Same name in this branch
  1. 8.x drupal/core/lib/Drupal/Core/Database/Driver/mysql/Schema.php \Drupal\Core\Database\Driver\mysql\Schema::createFieldSql()
  2. 8.x drupal/core/lib/Drupal/Core/Database/Driver/sqlite/Schema.php \Drupal\Core\Database\Driver\sqlite\Schema::createFieldSql()
  3. 8.x drupal/core/lib/Drupal/Core/Database/Driver/pgsql/Schema.php \Drupal\Core\Database\Driver\pgsql\Schema::createFieldSql()

Create an SQL string for a field to be used in table creation or alteration.

Before passing a field out of a schema definition into this function it has to be processed by _db_process_field().

Parameters

$name: Name of the field.

$spec: The field specification, as per the schema data structure format.

2 calls to Schema::createFieldSql()
Schema::addField in drupal/core/lib/Drupal/Core/Database/Driver/pgsql/Schema.php
Add a new field to a table.
Schema::createTableSql in drupal/core/lib/Drupal/Core/Database/Driver/pgsql/Schema.php
Generate SQL to create a new table from a Drupal schema definition.

File

drupal/core/lib/Drupal/Core/Database/Driver/pgsql/Schema.php, line 185
Definition of Drupal\Core\Database\Driver\pgsql\Schema

Class

Schema

Namespace

Drupal\Core\Database\Driver\pgsql

Code

protected function createFieldSql($name, $spec) {
  $sql = $name . ' ' . $spec['pgsql_type'];
  if (isset($spec['type']) && $spec['type'] == 'serial') {
    unset($spec['not null']);
  }
  if (in_array($spec['pgsql_type'], array(
    'varchar',
    'character',
    'text',
  )) && isset($spec['length'])) {
    $sql .= '(' . $spec['length'] . ')';
  }
  elseif (isset($spec['precision']) && isset($spec['scale'])) {
    $sql .= '(' . $spec['precision'] . ', ' . $spec['scale'] . ')';
  }
  if (!empty($spec['unsigned'])) {
    $sql .= " CHECK ({$name} >= 0)";
  }
  if (isset($spec['not null'])) {
    if ($spec['not null']) {
      $sql .= ' NOT NULL';
    }
    else {
      $sql .= ' NULL';
    }
  }
  if (isset($spec['default'])) {
    $default = is_string($spec['default']) ? "'" . $spec['default'] . "'" : $spec['default'];
    $sql .= " default {$default}";
  }
  return $sql;
}