You are here

public function Schema::findTables in Drupal 10

Same name in this branch
  1. 10 core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::findTables()
  2. 10 core/modules/sqlite/src/Driver/Database/sqlite/Schema.php \Drupal\sqlite\Driver\Database\sqlite\Schema::findTables()
  3. 10 core/modules/pgsql/src/Driver/Database/pgsql/Schema.php \Drupal\pgsql\Driver\Database\pgsql\Schema::findTables()

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

Parameters

string $table_expression: A case-insensitive pattern against which table names are compared. Both '_' and '%' are treated like wildcards in MySQL 'LIKE' expressions, where '_' matches any single character and '%' matches an arbitrary number of characters (including zero characters). So 'foo%bar' matches table names like 'foobar', 'fooXBar', 'fooXBaR', or 'fooXxBar'; whereas 'foo_bar' matches 'fooXBar' and 'fooXBaR' but not 'fooBar' or 'fooXxxBar'.

Return value

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

Overrides Schema::findTables

File

core/modules/pgsql/src/Driver/Database/pgsql/Schema.php, line 513

Class

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

Namespace

Drupal\pgsql\Driver\Database\pgsql

Code

public function findTables($table_expression) {
  $prefix = $this->connection
    ->tablePrefix();
  $prefix_length = strlen($prefix);
  $tables = [];

  // Load all the tables up front in order to take into account per-table
  // prefixes. The actual matching is done at the bottom of the method.
  $results = $this->connection
    ->query("SELECT tablename FROM pg_tables WHERE schemaname = :schema", [
    ':schema' => $this->defaultSchema,
  ]);
  foreach ($results as $table) {
    if ($prefix && substr($table->tablename, 0, $prefix_length) !== $prefix) {

      // This table name does not start the default prefix, which means that
      // it is not managed by Drupal so it should be excluded from the result.
      continue;
    }

    // Remove the prefix from the returned tables.
    $unprefixed_table_name = substr($table->tablename, $prefix_length);

    // The pattern can match a table which is the same as the prefix. That
    // will become an empty string when we remove the prefix, which will
    // probably surprise the caller, besides not being a prefixed table. So
    // remove it.
    if (!empty($unprefixed_table_name)) {
      $tables[$unprefixed_table_name] = $unprefixed_table_name;
    }
  }

  // Convert the table expression from its SQL LIKE syntax to a regular
  // expression and escape the delimiter that will be used for matching.
  $table_expression = str_replace([
    '%',
    '_',
  ], [
    '.*?',
    '.',
  ], preg_quote($table_expression, '/'));
  $tables = preg_grep('/^' . $table_expression . '$/i', $tables);
  return $tables;
}