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

Parameters

$table_expression: An SQL expression, for example "simpletest%" (without the quotes). BEWARE: this is not prefixed, the caller should take care of that.

Return value

Array, both the keys and the values are the matching tables.

Overrides DatabaseSchema::findTables

File

includes/database/pgsql/schema.inc, line 431

Class

DatabaseSchema_pgsql

Code

public function findTables($table_expression) {
 $individually_prefixed_tables = $this->connection 
 ->getUnprefixedTablesMap ();
 $default_prefix = $this->connection 
 ->tablePrefix ();
 $default_prefix_length = strlen ($default_prefix);
 $tables = array();
 // 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", array(
 ':schema' => $this->defaultSchema ,
 ));
 foreach ($results as $table) {
 // Take into account tables that have an individual prefix.
 if (isset($individually_prefixed_tables[$table->tablename])) {
 $prefix_length = strlen ($this->connection 
 ->tablePrefix ($individually_prefixed_tables[$table->tablename]));
 }
 elseif ($default_prefix && substr ($table->tablename, 0, $default_prefix_length) !== $default_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;
 }
 else {
 $prefix_length = $default_prefix_length;
 }
 // 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;
 }
 }
 // Need to use strtolower on the table name as it was used previously by
 // DatabaseSchema_pgsql::buildTableNameCondition().
 // @see https://www.drupal.org/project/drupal/issues/3262341
 $table_expression = strtolower ($table_expression);
 // 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 (array(
 '%',
 '_',
 ), array(
 '.*?',
 '.',
 ), preg_quote ($table_expression, '/'));
 $tables = preg_grep ('/^' . $table_expression . '$/i', $tables);
 return $tables;
}

---