class OrderByTest
Same name and namespace in other branches
- 11.x core/tests/Drupal/Tests/Core/Database/OrderByTest.php \Drupal\Tests\Core\Database\OrderByTest
- 10 core/tests/Drupal/Tests/Core/Database/OrderByTest.php \Drupal\Tests\Core\Database\OrderByTest
- 8.9.x core/tests/Drupal/Tests/Core/Database/OrderByTest.php \Drupal\Tests\Core\Database\OrderByTest
Tests the orderBy() method of select queries.
@group Database
Hierarchy
- class \Drupal\Tests\UnitTestCase uses \Drupal\Tests\Traits\PhpUnitWarnings, \Drupal\Tests\PhpUnitCompatibilityTrait, \Symfony\Bridge\PhpUnit\ExpectDeprecationTrait extends \PHPUnit\Framework\TestCase
- class \Drupal\Tests\Core\Database\OrderByTest extends \Drupal\Tests\UnitTestCase
Expanded class hierarchy of OrderByTest
File
-
core/
tests/ Drupal/ Tests/ Core/ Database/ OrderByTest.php, line 15
Namespace
Drupal\Tests\Core\DatabaseView source
class OrderByTest extends UnitTestCase {
/**
* The select query object to test.
*
* @var \Drupal\Core\Database\Query\Select
*/
protected $query;
/**
* {@inheritdoc}
*/
protected function setUp() : void {
$mockPdo = $this->createMock(StubPDO::class);
$connection = new StubConnection($mockPdo, []);
$this->query = new Select($connection, 'test', NULL);
}
/**
* Checks that invalid sort directions in ORDER BY get converted to ASC.
*/
public function testInvalidDirection() {
$this->query
->orderBy('test', 'invalid direction');
$order_bys = $this->query
->getOrderBy();
$this->assertEquals('ASC', $order_bys['test'], 'Invalid order by direction is converted to ASC.');
}
/**
* Tests that fields passed for ordering get escaped properly.
*/
public function testFieldEscaping() {
$this->query
->orderBy('x; DROP table node; --');
$sql = $this->query
->__toString();
$this->assertStringEndsWith('ORDER BY xDROPtablenode ASC', $sql, 'Order by field is escaped correctly.');
}
}
Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.