class OrderByTest
Same name in other branches
- 8.9.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
- 11.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 extends \PHPUnit\Framework\TestCase uses \Drupal\Tests\Traits\PhpUnitWarnings, \Drupal\Tests\PhpUnitCompatibilityTrait, \Symfony\Bridge\PhpUnit\ExpectDeprecationTrait
- 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.');
}
}
Members
Title Sort descending | Deprecated | Modifiers | Object type | Summary | Overriden Title | Overrides |
---|---|---|---|---|---|---|
OrderByTest::$query | protected | property | The select query object to test. | |||
OrderByTest::setUp | protected | function | Overrides UnitTestCase::setUp | |||
OrderByTest::testFieldEscaping | public | function | Tests that fields passed for ordering get escaped properly. | |||
OrderByTest::testInvalidDirection | public | function | Checks that invalid sort directions in ORDER BY get converted to ASC. | |||
PhpUnitWarnings::$deprecationWarnings | private static | property | Deprecation warnings from PHPUnit to raise with @trigger_error(). | |||
PhpUnitWarnings::addWarning | public | function | Converts PHPUnit deprecation warnings to E_USER_DEPRECATED. | |||
UnitTestCase::$randomGenerator | protected | property | The random generator. | |||
UnitTestCase::$root | protected | property | The app root. | 1 | ||
UnitTestCase::assertArrayEquals | Deprecated | protected | function | Asserts if two arrays are equal by sorting them first. | ||
UnitTestCase::getClassResolverStub | protected | function | Returns a stub class resolver. | |||
UnitTestCase::getConfigFactoryStub | public | function | Returns a stub config factory that behaves according to the passed array. | |||
UnitTestCase::getConfigStorageStub | public | function | Returns a stub config storage that returns the supplied configuration. | |||
UnitTestCase::getContainerWithCacheTagsInvalidator | protected | function | Sets up a container with a cache tags invalidator. | |||
UnitTestCase::getRandomGenerator | protected | function | Gets the random generator for the utility methods. | |||
UnitTestCase::getStringTranslationStub | public | function | Returns a stub translation manager that just returns the passed string. | |||
UnitTestCase::randomMachineName | public | function | Generates a unique random string containing letters and numbers. | |||
UnitTestCase::setUpBeforeClass | public static | function |
Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.