function SelectOrderedTest::testSimpleSelectOrdered
Same name in other branches
- 9 core/tests/Drupal/KernelTests/Core/Database/SelectOrderedTest.php \Drupal\KernelTests\Core\Database\SelectOrderedTest::testSimpleSelectOrdered()
- 8.9.x core/tests/Drupal/KernelTests/Core/Database/SelectOrderedTest.php \Drupal\KernelTests\Core\Database\SelectOrderedTest::testSimpleSelectOrdered()
- 11.x core/tests/Drupal/KernelTests/Core/Database/SelectOrderedTest.php \Drupal\KernelTests\Core\Database\SelectOrderedTest::testSimpleSelectOrdered()
Tests basic ORDER BY.
File
-
core/
tests/ Drupal/ KernelTests/ Core/ Database/ SelectOrderedTest.php, line 17
Class
- SelectOrderedTest
- Tests the Select query builder.
Namespace
Drupal\KernelTests\Core\DatabaseCode
public function testSimpleSelectOrdered() : void {
$query = $this->connection
->select('test');
$query->addField('test', 'name');
$age_field = $query->addField('test', 'age', 'age');
$query->orderBy($age_field);
$result = $query->execute();
$num_records = 0;
$last_age = 0;
foreach ($result as $record) {
$num_records++;
// Verify that the results are returned in the correct order.
$this->assertGreaterThanOrEqual($last_age, $record->age);
$last_age = $record->age;
}
$this->assertEquals(4, $num_records, 'Returned the correct number of rows.');
}
Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.