function DatabaseTestController::pagerQueryEven

Runs a pager query and returns the results.

This function does care about the page GET parameter, as set by the simpletest HTTP call.

Return value

\Symfony\Component\HttpFoundation\JsonResponse

File

core/modules/system/tests/modules/database_test/src/Controller/DatabaseTestController.php, line 66

Class

DatabaseTestController

Controller routines for database_test routes.

Namespace

Code

public function pagerQueryEven($limit) {
    $query = $this->connection
        ->select('test', 't');
    $query->fields('t', [
        'name',
    ])
        ->orderBy('age');
    // This should result in 2 pages of results.
    $query = $query->extend('Drupal\\Core\\Database\\Query\\PagerSelectExtender')
        ->limit($limit);
    $names = $query->execute()
        ->fetchCol();
    return new JsonResponse([
        'names' => $names,
    ]);
}