function Schema::introspectIndexSchema

Same name in this branch
  1. 8.9.x core/lib/Drupal/Core/Database/Driver/sqlite/Schema.php \Drupal\Core\Database\Driver\sqlite\Schema::introspectIndexSchema()
  2. 8.9.x core/lib/Drupal/Core/Database/Driver/pgsql/Schema.php \Drupal\Core\Database\Driver\pgsql\Schema::introspectIndexSchema()
  3. 8.9.x core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::introspectIndexSchema()
Same name and namespace in other branches
  1. 9 core/modules/sqlite/src/Driver/Database/sqlite/Schema.php \Drupal\sqlite\Driver\Database\sqlite\Schema::introspectIndexSchema()
  2. 9 core/modules/mysql/src/Driver/Database/mysql/Schema.php \Drupal\mysql\Driver\Database\mysql\Schema::introspectIndexSchema()
  3. 9 core/modules/pgsql/src/Driver/Database/pgsql/Schema.php \Drupal\pgsql\Driver\Database\pgsql\Schema::introspectIndexSchema()
  4. 9 core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::introspectIndexSchema()
  5. 10 core/modules/sqlite/src/Driver/Database/sqlite/Schema.php \Drupal\sqlite\Driver\Database\sqlite\Schema::introspectIndexSchema()
  6. 10 core/modules/mysql/src/Driver/Database/mysql/Schema.php \Drupal\mysql\Driver\Database\mysql\Schema::introspectIndexSchema()
  7. 10 core/modules/pgsql/src/Driver/Database/pgsql/Schema.php \Drupal\pgsql\Driver\Database\pgsql\Schema::introspectIndexSchema()
  8. 10 core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::introspectIndexSchema()
  9. 11.x core/modules/sqlite/src/Driver/Database/sqlite/Schema.php \Drupal\sqlite\Driver\Database\sqlite\Schema::introspectIndexSchema()
  10. 11.x core/modules/mysql/src/Driver/Database/mysql/Schema.php \Drupal\mysql\Driver\Database\mysql\Schema::introspectIndexSchema()
  11. 11.x core/modules/pgsql/src/Driver/Database/pgsql/Schema.php \Drupal\pgsql\Driver\Database\pgsql\Schema::introspectIndexSchema()
  12. 11.x core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::introspectIndexSchema()

Overrides Schema::introspectIndexSchema

File

core/lib/Drupal/Core/Database/Driver/mysql/Schema.php, line 618

Class

Schema
MySQL implementation of <a href="/api/drupal/core%21lib%21Drupal%21Core%21Database%21Schema.php/class/Schema/8.9.x" title="Provides a base implementation for Database Schema." class="local">\Drupal\Core\Database\Schema</a>.

Namespace

Drupal\Core\Database\Driver\mysql

Code

protected function introspectIndexSchema($table) {
    if (!$this->tableExists($table)) {
        throw new SchemaObjectDoesNotExistException("The table {$table} doesn't exist.");
    }
    $index_schema = [
        'primary key' => [],
        'unique keys' => [],
        'indexes' => [],
    ];
    $result = $this->connection
        ->query('SHOW INDEX FROM {' . $table . '}')
        ->fetchAll();
    foreach ($result as $row) {
        if ($row->Key_name === 'PRIMARY') {
            $index_schema['primary key'][] = $row->Column_name;
        }
        elseif ($row->Non_unique == 0) {
            $index_schema['unique keys'][$row->Key_name][] = $row->Column_name;
        }
        else {
            $index_schema['indexes'][$row->Key_name][] = $row->Column_name;
        }
    }
    return $index_schema;
}

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