Condition.php

Same filename in this branch
  1. 8.9.x core/lib/Drupal/Core/Config/Entity/Query/Condition.php
  2. 8.9.x core/lib/Drupal/Core/Database/Query/Condition.php
  3. 8.9.x core/lib/Drupal/Core/Entity/Query/Sql/Condition.php
  4. 8.9.x core/lib/Drupal/Core/Entity/Query/Null/Condition.php
  5. 8.9.x core/lib/Drupal/Core/Entity/KeyValueStore/Query/Condition.php
  6. 8.9.x core/lib/Drupal/Core/Condition/Annotation/Condition.php
Same filename in other branches
  1. 9 core/tests/fixtures/database_drivers/module/corefake/src/Driver/Database/corefakeWithAllCustomClasses/Condition.php
  2. 9 core/lib/Drupal/Core/Config/Entity/Query/Condition.php
  3. 9 core/lib/Drupal/Core/Database/Query/Condition.php
  4. 9 core/lib/Drupal/Core/Entity/Query/Sql/Condition.php
  5. 9 core/lib/Drupal/Core/Entity/Query/Sql/pgsql/Condition.php
  6. 9 core/lib/Drupal/Core/Entity/Query/Null/Condition.php
  7. 9 core/lib/Drupal/Core/Entity/KeyValueStore/Query/Condition.php
  8. 9 core/lib/Drupal/Core/Condition/Annotation/Condition.php
  9. 10 core/tests/fixtures/database_drivers/module/core_fake/src/Driver/Database/CoreFakeWithAllCustomClasses/Condition.php
  10. 10 core/lib/Drupal/Core/Config/Entity/Query/Condition.php
  11. 10 core/lib/Drupal/Core/Database/Query/Condition.php
  12. 10 core/lib/Drupal/Core/Entity/Query/Sql/Condition.php
  13. 10 core/lib/Drupal/Core/Entity/Query/Sql/pgsql/Condition.php
  14. 10 core/lib/Drupal/Core/Entity/Query/Null/Condition.php
  15. 10 core/lib/Drupal/Core/Entity/KeyValueStore/Query/Condition.php
  16. 10 core/lib/Drupal/Core/Condition/Attribute/Condition.php
  17. 10 core/lib/Drupal/Core/Condition/Annotation/Condition.php
  18. 11.x core/tests/fixtures/database_drivers/module/core_fake/src/Driver/Database/CoreFakeWithAllCustomClasses/Condition.php
  19. 11.x core/lib/Drupal/Core/Config/Entity/Query/Condition.php
  20. 11.x core/lib/Drupal/Core/Database/Query/Condition.php
  21. 11.x core/lib/Drupal/Core/Entity/Query/Sql/Condition.php
  22. 11.x core/lib/Drupal/Core/Entity/Query/Sql/pgsql/Condition.php
  23. 11.x core/lib/Drupal/Core/Entity/Query/Null/Condition.php
  24. 11.x core/lib/Drupal/Core/Entity/KeyValueStore/Query/Condition.php
  25. 11.x core/lib/Drupal/Core/Condition/Attribute/Condition.php
  26. 11.x core/lib/Drupal/Core/Condition/Annotation/Condition.php

Namespace

Drupal\Core\Entity\Query\Sql\pgsql

File

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

View source
<?php

namespace Drupal\Core\Entity\Query\Sql\pgsql;

use Drupal\Core\Database\Query\SelectInterface;
use Drupal\Core\Entity\Query\Sql\Condition as BaseCondition;

/**
 * Implements entity query conditions for PostgreSQL databases.
 */
class Condition extends BaseCondition {
    
    /**
     * {@inheritdoc}
     */
    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'] = [];
            // Only use the array values in case an associative array is passed as an
            // argument following similar pattern in
            // \Drupal\Core\Database\Connection::expandArguments().
            $where_prefix = str_replace('.', '_', $condition['real_field']);
            foreach ($condition['value'] as $key => $value) {
                $where_id = $where_prefix . $key;
                $condition['where'] .= 'LOWER(:' . $where_id . '),';
                $condition['where_args'][':' . $where_id] = $value;
            }
            $condition['where'] = trim($condition['where'], ',');
            $condition['where'] .= ')';
        }
        parent::translateCondition($condition, $sql_query, $case_sensitive);
    }

}

Classes

Title Deprecated Summary
Condition Implements entity query conditions for PostgreSQL databases.

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.