function SelectComplexTest::testDefaultJoin in Zircon Profile 8
Same name and namespace in other branches
- 8.0 core/modules/system/src/Tests/Database/SelectComplexTest.php \Drupal\system\Tests\Database\SelectComplexTest::testDefaultJoin()
Tests simple JOIN statements.
File
- core/
modules/ system/ src/ Tests/ Database/ SelectComplexTest.php, line 30 - Contains \Drupal\system\Tests\Database\SelectComplexTest.
Class
- SelectComplexTest
- Tests the Select query builder with more complex queries.
Namespace
Drupal\system\Tests\DatabaseCode
function testDefaultJoin() {
$query = db_select('test_task', 't');
$people_alias = $query
->join('test', 'p', 't.pid = p.id');
$name_field = $query
->addField($people_alias, 'name', 'name');
$query
->addField('t', 'task', 'task');
$priority_field = $query
->addField('t', 'priority', 'priority');
$query
->orderBy($priority_field);
$result = $query
->execute();
$num_records = 0;
$last_priority = 0;
foreach ($result as $record) {
$num_records++;
$this
->assertTrue($record->{$priority_field} >= $last_priority, 'Results returned in correct order.');
$this
->assertNotEqual($record->{$name_field}, 'Ringo', 'Taskless person not selected.');
$last_priority = $record->{$priority_field};
}
$this
->assertEqual($num_records, 7, 'Returned the correct number of rows.');
}