class SelectLeastTest
Same name and namespace in other branches
- 11.x core/tests/Drupal/KernelTests/Core/Database/SelectLeastTest.php \Drupal\KernelTests\Core\Database\SelectLeastTest
Tests the SQL LEAST operator.
@group Database
Hierarchy
- class \Drupal\KernelTests\KernelTestBase extends \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 implements \PHPUnit\Framework\TestCase
- class \Drupal\KernelTests\Core\Database\DatabaseTestBase uses \Drupal\KernelTests\Core\Database\DatabaseTestSchemaDataTrait, \Drupal\KernelTests\Core\Database\DatabaseTestSchemaInstallTrait implements \Drupal\KernelTests\KernelTestBase
- class \Drupal\KernelTests\Core\Database\SelectLeastTest implements \Drupal\KernelTests\Core\Database\DatabaseTestBase
- class \Drupal\KernelTests\Core\Database\DatabaseTestBase uses \Drupal\KernelTests\Core\Database\DatabaseTestSchemaDataTrait, \Drupal\KernelTests\Core\Database\DatabaseTestSchemaInstallTrait implements \Drupal\KernelTests\KernelTestBase
Expanded class hierarchy of SelectLeastTest
File
-
core/
tests/ Drupal/ KernelTests/ Core/ Database/ SelectLeastTest.php, line 10
Namespace
Drupal\KernelTests\Core\DatabaseView source
class SelectLeastTest extends DatabaseTestBase {
/**
* Tests the SQL LEAST operator.
*
* @dataProvider selectLeastProvider
*/
public function testSelectLeast($values, $expected) {
$least = $this->connection
->query("SELECT LEAST(:values[])", [
':values[]' => $values,
])
->fetchField();
$this->assertEquals($expected, $least);
}
public function selectLeastProvider() {
return [
[
[
1,
2,
3,
4,
5,
6,
],
1,
],
[
[
'A',
'B',
'C',
'NULL',
'F',
],
'A',
],
[
[
'NULL',
'NULL',
],
'NULL',
],
[
[
'TRUE',
'FALSE',
],
'FALSE',
],
[
[
'A',
'B',
'C',
'NULL',
],
'A',
],
];
}
}Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.