You are here

public function Schema::indexExists in Drupal 9

Same name in this branch
  1. 9 core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::indexExists()
  2. 9 core/lib/Drupal/Core/Database/Driver/sqlite/Schema.php \Drupal\Core\Database\Driver\sqlite\Schema::indexExists()
  3. 9 core/lib/Drupal/Core/Database/Driver/pgsql/Schema.php \Drupal\Core\Database\Driver\pgsql\Schema::indexExists()
  4. 9 core/lib/Drupal/Core/Database/Driver/mysql/Schema.php \Drupal\Core\Database\Driver\mysql\Schema::indexExists()
  5. 9 core/tests/fixtures/database_drivers/module/corefake/src/Driver/Database/corefakeWithAllCustomClasses/Schema.php \Drupal\corefake\Driver\Database\corefakeWithAllCustomClasses\Schema::indexExists()
Same name and namespace in other branches
  1. 8 core/lib/Drupal/Core/Database/Driver/pgsql/Schema.php \Drupal\Core\Database\Driver\pgsql\Schema::indexExists()

Checks if an index exists in the given table.

Parameters

$table: The name of the table in drupal (no prefixing).

$name: The name of the index in drupal (no prefixing).

Return value

TRUE if the given index exists, otherwise FALSE.

Overrides Schema::indexExists

2 calls to Schema::indexExists()
Schema::addIndex in core/lib/Drupal/Core/Database/Driver/pgsql/Schema.php
Add an index.
Schema::dropIndex in core/lib/Drupal/Core/Database/Driver/pgsql/Schema.php
Drop an index.

File

core/lib/Drupal/Core/Database/Driver/pgsql/Schema.php, line 724

Class

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

Namespace

Drupal\Core\Database\Driver\pgsql

Code

public function indexExists($table, $name) {

  // Details https://www.postgresql.org/docs/10/view-pg-indexes.html
  $index_name = $this
    ->ensureIdentifiersLength($table, $name, 'idx');

  // Remove leading and trailing quotes because the index name is in a WHERE
  // clause and not used as an identifier.
  $index_name = str_replace('"', '', $index_name);
  return (bool) $this->connection
    ->query("SELECT 1 FROM pg_indexes WHERE indexname = '{$index_name}'")
    ->fetchField();
}