function RangeQueryTest::testRangeQuery

Confirms that range queries work and return the correct result.

File

core/tests/Drupal/KernelTests/Core/Database/RangeQueryTest.php, line 15

Class

RangeQueryTest

Tests the Range query functionality.

Namespace

Code

public function testRangeQuery() {
    // Test if return correct number of rows.
    $range_rows = $this->connection
        ->queryRange("SELECT name FROM {test} ORDER BY name", 1, 3)
        ->fetchAll();
    $this->assertCount(3, $range_rows, 'Range query work and return correct number of rows.');
    // Test if return target data.
    $raw_rows = $this->connection
        ->query('SELECT name FROM {test} ORDER BY name')
        ->fetchAll();
    $raw_rows = array_slice($raw_rows, 1, 3);
    $this->assertEqual($range_rows, $raw_rows);
}