You are here

function SelectSubqueryTest::testConditionSubquerySelect in Zircon Profile 8

Same name and namespace in other branches
  1. 8.0 core/modules/system/src/Tests/Database/SelectSubqueryTest.php \Drupal\system\Tests\Database\SelectSubqueryTest::testConditionSubquerySelect()

Tests that we can use a subquery in a WHERE clause.

File

core/modules/system/src/Tests/Database/SelectSubqueryTest.php, line 80
Contains \Drupal\system\Tests\Database\SelectSubqueryTest.

Class

SelectSubqueryTest
Tests the Select query builder.

Namespace

Drupal\system\Tests\Database

Code

function testConditionSubquerySelect() {

  // Create a subquery, which is just a normal query object.
  $subquery = db_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 = db_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
    ->assertEqual(count($people), 5, 'Returned the correct number of rows.');
}