function EntityQueryTest::testEntityQuery

Test basic functionality.

File

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

Class

EntityQueryTest

Tests Entity Query functionality.

Namespace

Code

public function testEntityQuery() {
    $greetings = $this->greetings;
    $figures = $this->figures;
    $this->queryResults = $this->storage
        ->getQuery()
        ->exists($greetings, 'tr')
        ->condition("{$figures}.color", 'red')
        ->sort('id')
        ->execute();
    // As unit 0 was the red triangle and unit 2 was the turkish greeting,
    // bit 0 and bit 2 needs to be set.
    $this->assertResult(5, 7, 13, 15);
    $query = $this->storage
        ->getQuery('OR')
        ->exists($greetings, 'tr')
        ->condition("{$figures}.color", 'red')
        ->sort('id');
    $count_query = clone $query;
    $this->assertEqual(12, $count_query->count()
        ->execute());
    $this->queryResults = $query->execute();
    // Now bit 0 (1, 3, 5, 7, 9, 11, 13, 15) or bit 2 (4, 5, 6, 7, 12, 13, 14,
    // 15) needs to be set.
    $this->assertResult(1, 3, 4, 5, 6, 7, 9, 11, 12, 13, 14, 15);
    // Test cloning of query conditions.
    $query = $this->storage
        ->getQuery()
        ->condition("{$figures}.color", 'red')
        ->sort('id');
    $cloned_query = clone $query;
    $cloned_query->condition("{$figures}.shape", 'circle');
    // Bit 0 (1, 3, 5, 7, 9, 11, 13, 15) needs to be set.
    $this->queryResults = $query->execute();
    $this->assertResult(1, 3, 5, 7, 9, 11, 13, 15);
    // No red color has a circle shape.
    $this->queryResults = $cloned_query->execute();
    $this->assertResult();
    $query = $this->storage
        ->getQuery();
    $group = $query->orConditionGroup()
        ->exists($greetings, 'tr')
        ->condition("{$figures}.color", 'red');
    $this->queryResults = $query->condition($group)
        ->condition("{$greetings}.value", 'sie', 'STARTS_WITH')
        ->sort('revision_id')
        ->execute();
    // Bit 3 and (bit 0 or 2) -- the above 8 part of the above.
    $this->assertResult(9, 11, 12, 13, 14, 15);
    // No figure has both the colors blue and red at the same time.
    $this->queryResults = $this->storage
        ->getQuery()
        ->condition("{$figures}.color", 'blue')
        ->condition("{$figures}.color", 'red')
        ->sort('id')
        ->execute();
    $this->assertResult();
    // But an entity might have a red and a blue figure both.
    $query = $this->storage
        ->getQuery();
    $group_blue = $query->andConditionGroup()
        ->condition("{$figures}.color", 'blue');
    $group_red = $query->andConditionGroup()
        ->condition("{$figures}.color", 'red');
    $this->queryResults = $query->condition($group_blue)
        ->condition($group_red)
        ->sort('revision_id')
        ->execute();
    // Unit 0 and unit 1, so bits 0 1.
    $this->assertResult(3, 7, 11, 15);
    // Do the same test but with IN operator.
    $query = $this->storage
        ->getQuery();
    $group_blue = $query->andConditionGroup()
        ->condition("{$figures}.color", [
        'blue',
    ], 'IN');
    $group_red = $query->andConditionGroup()
        ->condition("{$figures}.color", [
        'red',
    ], 'IN');
    $this->queryResults = $query->condition($group_blue)
        ->condition($group_red)
        ->sort('id')
        ->execute();
    // Unit 0 and unit 1, so bits 0 1.
    $this->assertResult(3, 7, 11, 15);
    // An entity might have either red or blue figure.
    $this->queryResults = $this->storage
        ->getQuery()
        ->condition("{$figures}.color", [
        'blue',
        'red',
    ], 'IN')
        ->sort('id')
        ->execute();
    // Bit 0 or 1 is on.
    $this->assertResult(1, 2, 3, 5, 6, 7, 9, 10, 11, 13, 14, 15);
    $this->queryResults = $this->storage
        ->getQuery()
        ->exists("{$figures}.color")
        ->notExists("{$greetings}.value")
        ->sort('id')
        ->execute();
    // Bit 0 or 1 is on but 2 and 3 are not.
    $this->assertResult(1, 2, 3);
    // Now update the 'merhaba' string to xsiemax which is not a meaningful
    // word but allows us to test revisions and string operations.
    $ids = $this->storage
        ->getQuery()
        ->condition("{$greetings}.value", 'merhaba')
        ->sort('id')
        ->execute();
    $entities = EntityTestMulRev::loadMultiple($ids);
    $first_entity = reset($entities);
    $old_name = $first_entity->name->value;
    foreach ($entities as $entity) {
        $entity->setNewRevision();
        $entity->getTranslation('tr')->{$greetings}->value = 'xsiemax';
        $entity->name->value .= 'x';
        $entity->save();
    }
    // Test querying all revisions with a condition on the revision ID field.
    $this->queryResults = $this->storage
        ->getQuery()
        ->condition('revision_id', $first_entity->getRevisionId())
        ->allRevisions()
        ->execute();
    $this->assertCount(1, $this->queryResults);
    $this->assertEquals($first_entity->getRevisionId(), key($this->queryResults));
    // We changed the entity names, so the current revision should not match.
    $this->queryResults = $this->storage
        ->getQuery()
        ->condition('name.value', $old_name)
        ->execute();
    $this->assertResult();
    // Only if all revisions are queried, we find the old revision.
    $this->queryResults = $this->storage
        ->getQuery()
        ->condition('name.value', $old_name)
        ->allRevisions()
        ->sort('revision_id')
        ->execute();
    $this->assertRevisionResult([
        $first_entity->id(),
    ], [
        $first_entity->id(),
    ]);
    // When querying current revisions, this string is no longer found.
    $this->queryResults = $this->storage
        ->getQuery()
        ->condition("{$greetings}.value", 'merhaba')
        ->execute();
    $this->assertResult();
    $this->queryResults = $this->storage
        ->getQuery()
        ->condition("{$greetings}.value", 'merhaba')
        ->allRevisions()
        ->sort('revision_id')
        ->execute();
    // The query only matches the original revisions.
    $this->assertRevisionResult([
        4,
        5,
        6,
        7,
        12,
        13,
        14,
        15,
    ], [
        4,
        5,
        6,
        7,
        12,
        13,
        14,
        15,
    ]);
    $results = $this->storage
        ->getQuery()
        ->condition("{$greetings}.value", 'siema', 'CONTAINS')
        ->sort('id')
        ->execute();
    // This matches both the original and new current revisions, multiple
    // revisions are returned for some entities.
    $assert = [
        16 => '4',
        17 => '5',
        18 => '6',
        19 => '7',
        8 => '8',
        9 => '9',
        10 => '10',
        11 => '11',
        20 => '12',
        21 => '13',
        22 => '14',
        23 => '15',
    ];
    $this->assertIdentical($results, $assert);
    $results = $this->storage
        ->getQuery()
        ->condition("{$greetings}.value", 'siema', 'STARTS_WITH')
        ->sort('revision_id')
        ->execute();
    // Now we only get the ones that originally were siema, entity id 8 and
    // above.
    $this->assertIdentical($results, array_slice($assert, 4, 8, TRUE));
    $results = $this->storage
        ->getQuery()
        ->condition("{$greetings}.value", 'a', 'ENDS_WITH')
        ->sort('revision_id')
        ->execute();
    // It is very important that we do not get the ones which only have
    // xsiemax despite originally they were merhaba, ie. ended with a.
    $this->assertIdentical($results, array_slice($assert, 4, 8, TRUE));
    $results = $this->storage
        ->getQuery()
        ->condition("{$greetings}.value", 'a', 'ENDS_WITH')
        ->allRevisions()
        ->sort('id')
        ->sort('revision_id')
        ->execute();
    // Now we get everything.
    $assert = [
        4 => '4',
        5 => '5',
        6 => '6',
        7 => '7',
        8 => '8',
        9 => '9',
        10 => '10',
        11 => '11',
        12 => '12',
        20 => '12',
        13 => '13',
        21 => '13',
        14 => '14',
        22 => '14',
        15 => '15',
        23 => '15',
    ];
    $this->assertIdentical($results, $assert);
    // Check that a query on the latest revisions without any condition returns
    // the correct results.
    $results = $this->storage
        ->getQuery()
        ->latestRevision()
        ->sort('id')
        ->sort('revision_id')
        ->execute();
    $expected = [
        1 => '1',
        2 => '2',
        3 => '3',
        16 => '4',
        17 => '5',
        18 => '6',
        19 => '7',
        8 => '8',
        9 => '9',
        10 => '10',
        11 => '11',
        20 => '12',
        21 => '13',
        22 => '14',
        23 => '15',
    ];
    $this->assertSame($expected, $results);
}