protected function DatabaseSchema::buildTableNameCondition in Drupal 7

Build a condition to match a table name against a standard information_schema.

The information_schema is a SQL standard that provides information about the database server and the databases, schemas, tables, columns and users within it. This makes information_schema a useful tool to use across the drupal database drivers and is used by a few different functions. The function below describes the conditions to be meet when querying information_schema.tables for drupal tables or information associated with drupal tables. Even though this is the standard method, not all databases follow standards and so this method should be overwritten by a database driver if the database provider uses alternate methods. Because information_schema.tables is used in a few different functions, a database driver will only need to override this function to make all the others work. For example see includes/databases/mysql/schema.inc.

Parameters

$table_name: The name of the table in question.

$operator: The operator to apply on the 'table' part of the condition.

$add_prefix: Boolean to indicate whether the table name needs to be prefixed.

Return value

QueryConditionInterface A DatabaseCondition object.

4 calls to DatabaseSchema::buildTableNameCondition()

DatabaseSchema::fieldExists in includes/database/schema.inc

Check if a column exists in the given table.

DatabaseSchema::findTables in includes/database/schema.inc

Find all tables that are like the specified base table name.

DatabaseSchema::findTablesD8 in includes/database/schema.inc

Finds all tables that are like the specified base table name. This is a backport of the change made to findTables in Drupal 8 to work with virtual, un-prefixed table names. The original function is retained for Backwards Compatibility.

DatabaseSchema::tableExists in includes/database/schema.inc

Check if a table exists.

1 method overrides DatabaseSchema::buildTableNameCondition()

DatabaseSchema_mysql::buildTableNameCondition in includes/database/mysql/schema.inc

Build a condition to match a table name against a standard information_schema.

File

includes/database/schema.inc, line 299

Class

DatabaseSchema

Base class for database schema definitions.

Code

protected function buildTableNameCondition($table_name, $operator = '=', $add_prefix = TRUE) {
  $info = $this->connection
    ->getConnectionOptions();

  // Retrieve the table name and schema
  $table_info = $this
    ->getPrefixInfo($table_name, $add_prefix);
  $condition = new DatabaseCondition('AND');
  $condition
    ->condition('table_catalog', $info['database']);
  $condition
    ->condition('table_schema', $table_info['schema']);
  $condition
    ->condition('table_name', $table_info['table'], $operator);
  return $condition;
}