public static function Condition::translateCondition

public static Condition::translateCondition(&$condition, SelectInterface $sql_query, $case_sensitive)

Translates the string operators to SQL equivalents.

Parameters

array $condition: The condition array.

\Drupal\Core\Database\Query\SelectInterface $sql_query: Select query instance.

bool|null $case_sensitive: If the condition should be case sensitive or not, NULL if the field does not define it.

Overrides Condition::translateCondition

See also

\Drupal\Core\Database\Query\ConditionInterface::condition()

File

core/lib/Drupal/Core/Entity/Query/Sql/pgsql/Condition.php, line 16

Class

Condition

Implements entity query conditions for PostgreSQL databases.

Namespace

Drupal\Core\Entity\Query\Sql\pgsql

Code

public static function translateCondition(&$condition, SelectInterface $sql_query, $case_sensitive) {
  if (is_array($condition['value']) && $case_sensitive === FALSE) {
    $condition['where'] = 'LOWER(' . $sql_query->escapeField($condition['real_field']) . ') ' . $condition['operator'] . ' (';
    $condition['where_args'] = [];

    $n = 1;
    // Only use the array values in case an associative array is passed as an
    // argument following similar pattern in
    // \Drupal\Core\Database\Connection::expandArguments().
    foreach ($condition['value'] as $value) {
      $condition['where'] .= 'LOWER(:value' . $n . '),';
      $condition['where_args'][':value' . $n] = $value;
      $n++;
    }
    $condition['where'] = trim($condition['where'], ',');
    $condition['where'] .= ')';
    return;
  }
  parent::translateCondition($condition, $sql_query, $case_sensitive);
}