DrupalAPI.de

1. drupal
   1. drupal7

Find out the schema of a table.

This function uses introspection methods provided by the database to create a schema array. This is useful, for example, during update when the old schema is not available.

see drupal_get_schema()

Übergabeparameter

$table Name of the table.

Rückgabewert

An array representing the schema, from drupal_get_schema().

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/sqlite/schema.inc, line 301

<?php
protected function introspectSchema($table) {
  $mapped_fields = array_flip($this->getFieldTypeMap());
  $schema = array();
  foreach (db_query("PRAGMA table_info('{" . $table . "}')") as $row) {
    if (preg_match('/^([^(]+)\((.*)\)$/', $row->type, $matches)) {
      $type = $matches[1];
      $length = $matches[2];
    }
    else {
      $type = $row->type;
      $length = NULL;
    }
    if (isset($mapped_fields[$type])) {
      list($type, $size) = explode(':', $mapped_fields[$type]);
      $schema['fields'][$row->name] = array(
          'type' => $type,
          'size' => $size,
          'not null' => !empty($row->notnull),
          'default' => trim($row->dflt_value, "'"),
        );
      if ($length) {
        $schema['fields'][$row->name]['length'] = $length;
      }
      if ($row->pk) {
        $schema['primary key'][] = $row->name;
      }
    }
    else {
      new Exception("Unable to parse the column type " . $row->type);
    }
  }
  $indexes = array();
  foreach (db_query("PRAGMA index_list('{" . $table . "}')") as $row) {
    if (strpos($row->name, 'sqlite_autoindex_') !== 0) {
      $indexes[] = array(
          'schema_key' => $row->unique ? 'unique keys' : 'indexes',
          'name' => $row->name,
        );
    }
  }
  $n = strlen($table) + 1;
  foreach ($indexes as $index) {
    $name = $index['name'];
    $index_name = substr($name, $n);
    foreach (db_query("PRAGMA index_info('$name')") as $row) {
      $schema[$index['schema_key']][$index_name][] = $row->name;
    }
  }
  return $schema;
}
?>