DrupalAPI.de

1. drupal
   1. drupal7

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().

Übergabeparameter

$name Name of the field.

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

Verwandte Themen

Schema API

A Drupal schema definition is an array structure representing one or more tables and their related keys and indexes. A schema is defined by hook_schema(), which usually lives in a modulename.install file.

Code

includes/database/mysql/schema.inc, line 105

<?php
protected function createFieldSql($name, $spec) {
  $sql = "`" . $name . "` " . $spec['mysql_type'];

  if (isset($spec['length'])) {
    $sql .= '(' . $spec['length'] . ')';
  }
  elseif (isset($spec['precision']) && isset($spec['scale'])) {
    $sql .= '(' . $spec['precision'] . ', ' . $spec['scale'] . ')';
  }

  if (!empty($spec['unsigned'])) {
    $sql .= ' unsigned';
  }

  if (!empty($spec['not null'])) {
    $sql .= ' NOT NULL';
  }

  if (!empty($spec['auto_increment'])) {
    $sql .= ' auto_increment';
  }

  // $spec['default'] can be NULL, so we explicitly check for the key here.
  if (array_key_exists('default', $spec)) {
    if (is_string($spec['default'])) {
      $spec['default'] = "'" . $spec['default'] . "'";
    }
    elseif (is_null($spec['default'])) {
      $spec['default'] = 'NULL';
    }
    $sql .= ' DEFAULT ' . $spec['default'];
  }

  if (empty($spec['not null']) && !isset($spec['default'])) {
    $sql .= ' DEFAULT NULL';
  }

  // Add column comment.
  if (!empty($spec['description'])) {
    $sql .= ' COMMENT ' . $this->prepareComment($spec['description'], self::COMMENT_MAX_COLUMN);
  }

  return $sql;
}
?>