RangeQueryTest.php in Zircon Profile 8.0
File
core/modules/system/src/Tests/Database/RangeQueryTest.php
View source
<?php
namespace Drupal\system\Tests\Database;
class RangeQueryTest extends DatabaseTestBase {
public static $modules = array(
'database_test',
);
function testRangeQuery() {
$range_rows = db_query_range("SELECT name FROM {test} ORDER BY name", 1, 3)
->fetchAll();
$this
->assertEqual(count($range_rows), 3, 'Range query work and return correct number of rows.');
$raw_rows = db_query('SELECT name FROM {test} ORDER BY name')
->fetchAll();
$raw_rows = array_slice($raw_rows, 1, 3);
$this
->assertEqual($range_rows, $raw_rows);
}
}