function EntityQueryTest::testToString

Tests __toString().

File

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

Class

EntityQueryTest

Tests Entity Query functionality.

Namespace

Code

public function testToString() {
    $query = $this->storage
        ->getQuery();
    $group_blue = $query->andConditionGroup()
        ->condition("{$this->figures}.color", [
        'blue',
    ], 'IN');
    $group_red = $query->andConditionGroup()
        ->condition("{$this->figures}.color", [
        'red',
    ], 'IN');
    $null_group = $query->andConditionGroup()
        ->notExists("{$this->figures}.color");
    $this->queryResults = $query->condition($group_blue)
        ->condition($group_red)
        ->condition($null_group)
        ->sort('id');
    $figures = $this->figures;
    // Matching the SQL statement against an hardcoded statement leads to
    // failures with database drivers that override the
    // Drupal\Core\Database\Query\Select class. We build a dynamic query via
    // the db API to check that its SQL matches the one generated by the
    // EntityQuery. This way we ensure that the database driver is free to
    // create its own comparable SQL statement.
    $connection = Database::getConnection();
    $expected = $connection->select("entity_test_mulrev", "base_table");
    $expected->addField("base_table", "revision_id", "revision_id");
    $expected->addField("base_table", "id", "id");
    $expected->join("entity_test_mulrev__{$figures}", "entity_test_mulrev__{$figures}", "entity_test_mulrev__{$figures}.entity_id = base_table.id");
    $expected->join("entity_test_mulrev__{$figures}", "entity_test_mulrev__{$figures}_2", "entity_test_mulrev__{$figures}_2.entity_id = base_table.id");
    $expected->addJoin("LEFT", "entity_test_mulrev__{$figures}", "entity_test_mulrev__{$figures}_3", "entity_test_mulrev__{$figures}_3.entity_id = base_table.id");
    $expected->condition("entity_test_mulrev__{$figures}.{$figures}_color", [
        "blue",
    ], "IN");
    $expected->condition("entity_test_mulrev__{$figures}_2.{$figures}_color", [
        "red",
    ], "IN");
    $expected->isNull("entity_test_mulrev__{$figures}_3.{$figures}_color");
    $expected->orderBy("base_table.id");
    // Apply table prefixes to the expected SQL.
    $expected_string = \Drupal::database()->prefixTables((string) $expected);
    // Resolve placeholders in the expected SQL to their values.
    $quoted = [];
    foreach ($expected->getArguments() as $key => $value) {
        $quoted[$key] = $connection->quote($value);
    }
    $expected_string = strtr($expected_string, $quoted);
    $this->assertSame($expected_string, (string) $query);
}