Schema::queryFieldInformation

public Schema::queryFieldInformation($table, $field)

Fetch the list of CHECK constraints used on a field.

We introspect the database to collect the information required by field alteration.

Parameters

$table: The non-prefixed name of the table.

$field: The name of the field.

Return value

An array of all the checks for the field.

File

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

Class

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

Namespace

Drupal\Core\Database\Driver\pgsql

Code

public function queryFieldInformation($table, $field) {
  $prefixInfo = $this->getPrefixInfo($table, TRUE);
 
  // Split the key into schema and table for querying.
  $schema = $prefixInfo['schema'];
  $table_name = $prefixInfo['table'];
 
  $this->connection->addSavepoint();
 
  try {
    $checks = $this->connection->query("SELECT conname FROM pg_class cl INNER JOIN pg_constraint co ON co.conrelid = cl.oid INNER JOIN pg_attribute attr ON attr.attrelid = cl.oid AND attr.attnum = ANY (co.conkey) INNER JOIN pg_namespace ns ON cl.relnamespace = ns.oid WHERE co.contype = 'c' AND ns.nspname = :schema AND cl.relname = :table AND attr.attname = :column", array(
      ':schema' => $schema,
      ':table' => $table_name,
      ':column' => $field,
    ));
  }
  catch (\Exception $e) {
    $this->connection->rollbackSavepoint();
    throw $e;
  }
 
  $this->connection->releaseSavepoint();
 
  $field_information = $checks->fetchCol();
 
  return $field_information;
}

Links:

https://api.drupal.org/api/drupal/core%21lib%21Drupal%21Core%21Database%21Driver%21pgsql%21Schema.php/function/Schema%3A%3AqueryFieldInformation/8.2.x

doc_Drupal

2025-01-10 15:47:30

Comments