public function Schema::indexExists in Drupal 10
Same name in this branch
- 10 core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::indexExists()
- 10 core/modules/sqlite/src/Driver/Database/sqlite/Schema.php \Drupal\sqlite\Driver\Database\sqlite\Schema::indexExists()
- 10 core/modules/pgsql/src/Driver/Database/pgsql/Schema.php \Drupal\pgsql\Driver\Database\pgsql\Schema::indexExists()
- 10 core/modules/mysql/src/Driver/Database/mysql/Schema.php \Drupal\mysql\Driver\Database\mysql\Schema::indexExists()
- 10 core/tests/fixtures/database_drivers/module/corefake/src/Driver/Database/corefakeWithAllCustomClasses/Schema.php \Drupal\corefake\Driver\Database\corefakeWithAllCustomClasses\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/
modules/ pgsql/ src/ Driver/ Database/ pgsql/ Schema.php - Add an index.
- Schema::dropIndex in core/
modules/ pgsql/ src/ Driver/ Database/ pgsql/ Schema.php - Drop an index.
File
- core/
modules/ pgsql/ src/ Driver/ Database/ pgsql/ Schema.php, line 716
Class
- Schema
- PostgreSQL implementation of \Drupal\Core\Database\Schema.
Namespace
Drupal\pgsql\Driver\Database\pgsqlCode
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();
}