W3cubDocs

/Drupal 8

public function Schema::findTables

public Schema::findTables($table_expression)

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

Parameters

string $table_expression: An SQL expression, for example "cache_%" (without the quotes).

Return value

array Both the keys and the values are the matching tables.

Overrides Schema::findTables

File

core/lib/Drupal/Core/Database/Driver/sqlite/Schema.php, line 704

Class

Schema
SQLite implementation of \Drupal\Core\Database\Schema.

Namespace

Drupal\Core\Database\Driver\sqlite

Code

public function findTables($table_expression) {
  $tables = [];

  // The SQLite implementation doesn't need to use the same filtering strategy
  // as the parent one because individually prefixed tables live in their own
  // schema (database), which means that neither the main database nor any
  // attached one will contain a prefixed table name, so we just need to loop
  // over all known schemas and filter by the user-supplied table expression.
  $attached_dbs = $this->connection->getAttachedDatabases();
  foreach ($attached_dbs as $schema) {
    // Can't use query placeholders for the schema because the query would
    // have to be :prefixsqlite_master, which does not work. We also need to
    // ignore the internal SQLite tables.
    $result = $this->connection->query("SELECT name FROM " . $schema . ".sqlite_master WHERE type = :type AND name LIKE :table_name AND name NOT LIKE :pattern", array(
      ':type' => 'table',
      ':table_name' => $table_expression,
      ':pattern' => 'sqlite_%',
    ));
    $tables += $result->fetchAllKeyed(0, 0);
  }

  return $tables;
}

© 2001–2016 by the original authors
Licensed under the GNU General Public License, version 2 and later.
Drupal is a registered trademark of Dries Buytaert.
https://api.drupal.org/api/drupal/core!lib!Drupal!Core!Database!Driver!sqlite!Schema.php/function/Schema::findTables/8.1.x