You are here

public function Schema::fieldExists in Drupal 10

Same name in this branch
  1. 10 core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::fieldExists()
  2. 10 core/modules/sqlite/src/Driver/Database/sqlite/Schema.php \Drupal\sqlite\Driver\Database\sqlite\Schema::fieldExists()
  3. 10 core/modules/pgsql/src/Driver/Database/pgsql/Schema.php \Drupal\pgsql\Driver\Database\pgsql\Schema::fieldExists()
Same name and namespace in other branches
  1. 8 core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::fieldExists()
  2. 9 core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::fieldExists()

Check if a column exists in the given table.

Parameters

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

string $column: The name of the column.

Return value

TRUE if the given column exists, otherwise FALSE.

3 calls to Schema::fieldExists()
Schema::addField in core/modules/mysql/src/Driver/Database/mysql/Schema.php
Add a new field to a table.
Schema::changeField in core/modules/mysql/src/Driver/Database/mysql/Schema.php
Change a field definition.
Schema::dropField in core/modules/mysql/src/Driver/Database/mysql/Schema.php
Drop a field.
2 methods override Schema::fieldExists()
Schema::fieldExists in core/modules/sqlite/src/Driver/Database/sqlite/Schema.php
Check if a column exists in the given table.
Schema::fieldExists in core/modules/pgsql/src/Driver/Database/pgsql/Schema.php
Check if a column exists in the given table.

File

core/lib/Drupal/Core/Database/Schema.php, line 246

Class

Schema
Provides a base implementation for Database Schema.

Namespace

Drupal\Core\Database

Code

public function fieldExists($table, $column) {
  $condition = $this
    ->buildTableNameCondition($table);
  $condition
    ->condition('column_name', $column);
  $condition
    ->compile($this->connection, $this);

  // Normally, we would heartily discourage the use of string
  // concatenation for conditionals like this however, we
  // couldn't use \Drupal::database()->select() here because it would prefix
  // information_schema.tables and the query would fail.
  // Don't use {} around information_schema.columns table.
  return (bool) $this->connection
    ->query("SELECT 1 FROM information_schema.columns WHERE " . (string) $condition, $condition
    ->arguments())
    ->fetchField();
}