public function Schema::findTables in Zircon Profile 8
Same name in this branch
- 8 core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::findTables()
- 8 core/lib/Drupal/Core/Database/Driver/sqlite/Schema.php \Drupal\Core\Database\Driver\sqlite\Schema::findTables()
Same name and namespace in other branches
- 8.0 core/lib/Drupal/Core/Database/Driver/sqlite/Schema.php \Drupal\Core\Database\Driver\sqlite\Schema::findTables()
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 705 - Contains \Drupal\Core\Database\Driver\sqlite\Schema.
Class
- Schema
- SQLite implementation of \Drupal\Core\Database\Schema.
Namespace
Drupal\Core\Database\Driver\sqliteCode
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 = db_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;
}