| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /nginx/html/Student/JimMartinson/Lab12/drupal/core/tests/Drupal/Tests/Core/Database/ |
Upload File : |
<?php
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.');
}
}