function SelectSubqueryTest::testConditionSubquerySelect

Tests that we can use a subquery with an IN operator in a WHERE clause.

File

core/tests/Drupal/KernelTests/Core/Database/SelectSubqueryTest.php, line 81

Class

SelectSubqueryTest

Tests the Select query builder.

Namespace

Code

public function testConditionSubquerySelect() : void {
    // Create a subquery, which is just a normal query object.
    $subquery = $this->connection
        ->select('test_task', 'tt');
    $subquery->addField('tt', 'pid', 'pid');
    $subquery->condition('tt.priority', 1);
    // Create another query that joins against the virtual table resulting
    // from the subquery.
    $select = $this->connection
        ->select('test_task', 'tt2');
    $select->addField('tt2', 'task');
    $select->condition('tt2.pid', $subquery, 'IN');
    // The resulting query should be equivalent to:
    // SELECT tt2.name
    // FROM test tt2
    // WHERE tt2.pid IN (SELECT tt.pid AS pid FROM test_task tt WHERE tt.priority=1)
    $people = $select->execute()
        ->fetchCol();
    $this->assertCount(5, $people, 'Returned the correct number of rows.');
}