function EntityQueryTest::testCaseSensitivity

Test case sensitive and in-sensitive query conditions.

File

core/tests/Drupal/KernelTests/Core/Entity/EntityQueryTest.php, line 749

Class

EntityQueryTest

Tests Entity Query functionality.

Namespace

Code

public function testCaseSensitivity() {
    $bundle = $this->randomMachineName();
    $field_storage = FieldStorageConfig::create([
        'field_name' => 'field_ci',
        'entity_type' => 'entity_test_mulrev',
        'type' => 'string',
        'cardinality' => 1,
        'translatable' => FALSE,
        'settings' => [
            'case_sensitive' => FALSE,
        ],
    ]);
    $field_storage->save();
    FieldConfig::create([
        'field_storage' => $field_storage,
        'bundle' => $bundle,
    ])->save();
    $field_storage = FieldStorageConfig::create([
        'field_name' => 'field_cs',
        'entity_type' => 'entity_test_mulrev',
        'type' => 'string',
        'cardinality' => 1,
        'translatable' => FALSE,
        'settings' => [
            'case_sensitive' => TRUE,
        ],
    ]);
    $field_storage->save();
    FieldConfig::create([
        'field_storage' => $field_storage,
        'bundle' => $bundle,
    ])->save();
    $fixtures = [];
    for ($i = 0; $i < 2; $i++) {
        // If the last 4 of the string are all numbers, then there is no
        // difference between upper and lowercase and the case sensitive CONTAINS
        // test will fail. Ensure that can not happen by appending a non-numeric
        // character. See https://www.drupal.org/node/2397297.
        $string = $this->randomMachineName(7) . 'a';
        $fixtures[] = [
            'original' => $string,
            'uppercase' => mb_strtoupper($string),
            'lowercase' => mb_strtolower($string),
        ];
    }
    EntityTestMulRev::create([
        'type' => $bundle,
        'name' => $this->randomMachineName(),
        'langcode' => 'en',
        'field_ci' => $fixtures[0]['uppercase'] . $fixtures[1]['lowercase'],
        'field_cs' => $fixtures[0]['uppercase'] . $fixtures[1]['lowercase'],
    ])
        ->save();
    // Check the case insensitive field, = operator.
    $result = $this->storage
        ->getQuery()
        ->condition('field_ci', $fixtures[0]['lowercase'] . $fixtures[1]['lowercase'])
        ->execute();
    $this->assertCount(1, $result, 'Case insensitive, lowercase');
    $result = $this->storage
        ->getQuery()
        ->condition('field_ci', $fixtures[0]['uppercase'] . $fixtures[1]['uppercase'])
        ->execute();
    $this->assertCount(1, $result, 'Case insensitive, uppercase');
    $result = $this->storage
        ->getQuery()
        ->condition('field_ci', $fixtures[0]['uppercase'] . $fixtures[1]['lowercase'])
        ->execute();
    $this->assertCount(1, $result, 'Case insensitive, mixed.');
    // Check the case sensitive field, = operator.
    $result = $this->storage
        ->getQuery()
        ->condition('field_cs', $fixtures[0]['lowercase'] . $fixtures[1]['lowercase'])
        ->execute();
    $this->assertCount(0, $result, 'Case sensitive, lowercase.');
    $result = $this->storage
        ->getQuery()
        ->condition('field_cs', $fixtures[0]['uppercase'] . $fixtures[1]['uppercase'])
        ->execute();
    $this->assertCount(0, $result, 'Case sensitive, uppercase.');
    $result = $this->storage
        ->getQuery()
        ->condition('field_cs', $fixtures[0]['uppercase'] . $fixtures[1]['lowercase'])
        ->execute();
    $this->assertCount(1, $result, 'Case sensitive, exact match.');
    // Check the case insensitive field, IN operator.
    $result = $this->storage
        ->getQuery()
        ->condition('field_ci', [
        $fixtures[0]['lowercase'] . $fixtures[1]['lowercase'],
    ], 'IN')
        ->execute();
    $this->assertCount(1, $result, 'Case insensitive, lowercase');
    $result = $this->storage
        ->getQuery()
        ->condition('field_ci', [
        $fixtures[0]['uppercase'] . $fixtures[1]['uppercase'],
    ], 'IN')
        ->execute();
    $this->assertCount(1, $result, 'Case insensitive, uppercase');
    $result = $this->storage
        ->getQuery()
        ->condition('field_ci', [
        $fixtures[0]['uppercase'] . $fixtures[1]['lowercase'],
    ], 'IN')
        ->execute();
    $this->assertCount(1, $result, 'Case insensitive, mixed');
    // Check the case sensitive field, IN operator.
    $result = $this->storage
        ->getQuery()
        ->condition('field_cs', [
        $fixtures[0]['lowercase'] . $fixtures[1]['lowercase'],
    ], 'IN')
        ->execute();
    $this->assertCount(0, $result, 'Case sensitive, lowercase');
    $result = $this->storage
        ->getQuery()
        ->condition('field_cs', [
        $fixtures[0]['uppercase'] . $fixtures[1]['uppercase'],
    ], 'IN')
        ->execute();
    $this->assertCount(0, $result, 'Case sensitive, uppercase');
    $result = $this->storage
        ->getQuery()
        ->condition('field_cs', [
        $fixtures[0]['uppercase'] . $fixtures[1]['lowercase'],
    ], 'IN')
        ->execute();
    $this->assertCount(1, $result, 'Case sensitive, mixed');
    // Check the case insensitive field, STARTS_WITH operator.
    $result = $this->storage
        ->getQuery()
        ->condition('field_ci', $fixtures[0]['lowercase'], 'STARTS_WITH')
        ->execute();
    $this->assertCount(1, $result, 'Case sensitive, lowercase.');
    $result = $this->storage
        ->getQuery()
        ->condition('field_ci', $fixtures[0]['uppercase'], 'STARTS_WITH')
        ->execute();
    $this->assertCount(1, $result, 'Case sensitive, exact match.');
    // Check the case sensitive field, STARTS_WITH operator.
    $result = $this->storage
        ->getQuery()
        ->condition('field_cs', $fixtures[0]['lowercase'], 'STARTS_WITH')
        ->execute();
    $this->assertCount(0, $result, 'Case sensitive, lowercase.');
    $result = $this->storage
        ->getQuery()
        ->condition('field_cs', $fixtures[0]['uppercase'], 'STARTS_WITH')
        ->execute();
    $this->assertCount(1, $result, 'Case sensitive, exact match.');
    // Check the case insensitive field, ENDS_WITH operator.
    $result = $this->storage
        ->getQuery()
        ->condition('field_ci', $fixtures[1]['lowercase'], 'ENDS_WITH')
        ->execute();
    $this->assertCount(1, $result, 'Case sensitive, lowercase.');
    $result = $this->storage
        ->getQuery()
        ->condition('field_ci', $fixtures[1]['uppercase'], 'ENDS_WITH')
        ->execute();
    $this->assertCount(1, $result, 'Case sensitive, exact match.');
    // Check the case sensitive field, ENDS_WITH operator.
    $result = $this->storage
        ->getQuery()
        ->condition('field_cs', $fixtures[1]['lowercase'], 'ENDS_WITH')
        ->execute();
    $this->assertCount(1, $result, 'Case sensitive, lowercase.');
    $result = $this->storage
        ->getQuery()
        ->condition('field_cs', $fixtures[1]['uppercase'], 'ENDS_WITH')
        ->execute();
    $this->assertCount(0, $result, 'Case sensitive, exact match.');
    // Check the case insensitive field, CONTAINS operator, use the inner 8
    // characters of the uppercase and lowercase strings.
    $result = $this->storage
        ->getQuery()
        ->condition('field_ci', mb_substr($fixtures[0]['uppercase'] . $fixtures[1]['lowercase'], 4, 8), 'CONTAINS')
        ->execute();
    $this->assertCount(1, $result, 'Case sensitive, lowercase.');
    $result = $this->storage
        ->getQuery()
        ->condition('field_ci', mb_strtolower(mb_substr($fixtures[0]['uppercase'] . $fixtures[1]['lowercase'], 4, 8)), 'CONTAINS')
        ->execute();
    $this->assertCount(1, $result, 'Case sensitive, exact match.');
    // Check the case sensitive field, CONTAINS operator.
    $result = $this->storage
        ->getQuery()
        ->condition('field_cs', mb_substr($fixtures[0]['uppercase'] . $fixtures[1]['lowercase'], 4, 8), 'CONTAINS')
        ->execute();
    $this->assertCount(1, $result, 'Case sensitive, lowercase.');
    $result = $this->storage
        ->getQuery()
        ->condition('field_cs', mb_strtolower(mb_substr($fixtures[0]['uppercase'] . $fixtures[1]['lowercase'], 4, 8)), 'CONTAINS')
        ->execute();
    $this->assertCount(0, $result, 'Case sensitive, exact match.');
}