OrderByTest.php in Zircon Profile 8
Same filename and directory in other branches
Contains \Drupal\Tests\Core\Database\OrderByTest.
Namespace
Drupal\Tests\Core\DatabaseFile
core/tests/Drupal/Tests/Core/Database/OrderByTest.phpView source
<?php
/**
* @file
* Contains \Drupal\Tests\Core\Database\OrderByTest.
*/
namespace Drupal\Tests\Core\Database;
use Drupal\Core\Database\Query\Select;
use Drupal\Tests\UnitTestCase;
/**
* Tests the orderBy() method of select queries.
*
* @group Database
*/
class OrderByTest extends UnitTestCase {
/**
* The select query object to test.
*
* @var \Drupal\Core\Database\Query\Select
*/
protected $query;
/**
* {@inheritdoc}
*/
protected function setUp() {
$connection = $this
->getMockBuilder('Drupal\\Core\\Database\\Connection')
->disableOriginalConstructor()
->getMockForAbstractClass();
$this->query = new Select('test', NULL, $connection);
}
/**
* 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($order_bys['test'], 'ASC', '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.');
}
}
Classes
Name | Description |
---|---|
OrderByTest | Tests the orderBy() method of select queries. |