public function DatabaseSchema::fieldExists

1 schema.inc public DatabaseSchema::fieldExists($table, $column)

Check if a column exists in the given table.

Parameters

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

string $column: The name of the column.

Return value

bool: TRUE if the given column exists, otherwise FALSE.

5 calls to DatabaseSchema::fieldExists()

DatabaseSchema_mysql::addField in core/includes/database/mysql/schema.inc: Add a new field to a table.
DatabaseSchema_mysql::changeField in core/includes/database/mysql/schema.inc: Change a field definition.
DatabaseSchema_mysql::dropField in core/includes/database/mysql/schema.inc: Drop a field.
DatabaseSchema_mysql::fieldSetDefault in core/includes/database/mysql/schema.inc: Set the default value for a field.
DatabaseSchema_mysql::fieldSetNoDefault in core/includes/database/mysql/schema.inc: Set a field to have no default value.

File

core/includes/database/schema.inc, line 369: Generic Database schema code.

Class

DatabaseSchema: Base class for database schema definitions.

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 db_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();
}