class SelectOrderedTest
Same name and namespace in other branches
- 11.x core/tests/Drupal/KernelTests/Core/Database/SelectOrderedTest.php \Drupal\KernelTests\Core\Database\SelectOrderedTest
- 10 core/tests/Drupal/KernelTests/Core/Database/SelectOrderedTest.php \Drupal\KernelTests\Core\Database\SelectOrderedTest
- 8.9.x core/tests/Drupal/KernelTests/Core/Database/SelectOrderedTest.php \Drupal\KernelTests\Core\Database\SelectOrderedTest
Tests the Select query builder.
@group Database
Hierarchy
- class \Drupal\KernelTests\KernelTestBase implements \Drupal\Core\DependencyInjection\ServiceProviderInterface uses \Drupal\KernelTests\AssertLegacyTrait, \Drupal\KernelTests\AssertContentTrait, \Drupal\Tests\RandomGeneratorTrait, \Drupal\Tests\ConfigTestTrait, \Drupal\Tests\ExtensionListTestTrait, \Drupal\Tests\TestRequirementsTrait, \Drupal\Tests\Traits\PhpUnitWarnings, \Drupal\Tests\PhpUnitCompatibilityTrait, \Symfony\Bridge\PhpUnit\ExpectDeprecationTrait extends \PHPUnit\Framework\TestCase
- class \Drupal\KernelTests\Core\Database\DatabaseTestBase uses \Drupal\KernelTests\Core\Database\DatabaseTestSchemaDataTrait, \Drupal\KernelTests\Core\Database\DatabaseTestSchemaInstallTrait extends \Drupal\KernelTests\KernelTestBase
- class \Drupal\KernelTests\Core\Database\SelectOrderedTest extends \Drupal\KernelTests\Core\Database\DatabaseTestBase
- class \Drupal\KernelTests\Core\Database\DatabaseTestBase uses \Drupal\KernelTests\Core\Database\DatabaseTestSchemaDataTrait, \Drupal\KernelTests\Core\Database\DatabaseTestSchemaInstallTrait extends \Drupal\KernelTests\KernelTestBase
Expanded class hierarchy of SelectOrderedTest
File
-
core/
tests/ Drupal/ KernelTests/ Core/ Database/ SelectOrderedTest.php, line 10
Namespace
Drupal\KernelTests\Core\DatabaseView source
class SelectOrderedTest extends DatabaseTestBase {
/**
* Tests basic ORDER BY.
*/
public function testSimpleSelectOrdered() {
$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.');
}
/**
* Tests multiple ORDER BY.
*/
public function testSimpleSelectMultiOrdered() {
$query = $this->connection
->select('test');
$query->addField('test', 'name');
$age_field = $query->addField('test', 'age', 'age');
$job_field = $query->addField('test', 'job');
$query->orderBy($job_field);
$query->orderBy($age_field);
$result = $query->execute();
$num_records = 0;
$expected = [
[
'Ringo',
28,
'Drummer',
],
[
'John',
25,
'Singer',
],
[
'George',
27,
'Singer',
],
[
'Paul',
26,
'Songwriter',
],
];
$results = $result->fetchAll(\PDO::FETCH_NUM);
foreach ($expected as $k => $record) {
$num_records++;
foreach ($record as $kk => $col) {
if ($expected[$k][$kk] != $results[$k][$kk]) {
$this->assertTrue(FALSE, 'Results returned in correct order.');
}
}
}
$this->assertEquals(4, $num_records, 'Returned the correct number of rows.');
}
/**
* Tests ORDER BY descending.
*/
public function testSimpleSelectOrderedDesc() {
$query = $this->connection
->select('test');
$query->addField('test', 'name');
$age_field = $query->addField('test', 'age', 'age');
$query->orderBy($age_field, 'DESC');
$result = $query->execute();
$num_records = 0;
$last_age = 100000000;
foreach ($result as $record) {
$num_records++;
// Verify that the results are returned in the correct order.
$this->assertLessThanOrEqual($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.