You are here

public function Connection::prepareQuery in Drupal 8

Same name in this branch
  1. 8 core/lib/Drupal/Core/Database/Connection.php \Drupal\Core\Database\Connection::prepareQuery()
  2. 8 core/lib/Drupal/Core/Database/Driver/sqlite/Connection.php \Drupal\Core\Database\Driver\sqlite\Connection::prepareQuery()
  3. 8 core/lib/Drupal/Core/Database/Driver/pgsql/Connection.php \Drupal\Core\Database\Driver\pgsql\Connection::prepareQuery()

Prepares a query string and returns the prepared statement.

This method caches prepared statements, reusing them when possible. It also prefixes tables names enclosed in curly-braces.

Parameters

$query: The query string as SQL, with curly-braces surrounding the table names.

Return value

\Drupal\Core\Database\StatementInterface A PDO prepared statement ready for its execute() method.

Overrides Connection::prepareQuery

File

core/lib/Drupal/Core/Database/Driver/pgsql/Connection.php, line 208

Class

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

Namespace

Drupal\Core\Database\Driver\pgsql

Code

public function prepareQuery($query) {

  // mapConditionOperator converts some operations (LIKE, REGEXP, etc.) to
  // PostgreSQL equivalents (ILIKE, ~*, etc.). However PostgreSQL doesn't
  // automatically cast the fields to the right type for these operators,
  // so we need to alter the query and add the type-cast.
  return parent::prepareQuery(preg_replace('/ ([^ ]+) +(I*LIKE|NOT +I*LIKE|~\\*|!~\\*) /i', ' ${1}::text ${2} ', $query));
}