function DatabaseTestController::pagerQueryOdd

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 94

Class

DatabaseTestController

Controller routines for database_test routes.

Namespace

Code

public function pagerQueryOdd($limit) {
    $query = $this->connection
        ->select('test_task', 't');
    $query->fields('t', [
        'task',
    ])
        ->orderBy('pid');
    // This should result in 4 pages of results.
    $query = $query->extend(PagerSelectExtender::class)
        ->limit($limit);
    $names = $query->execute()
        ->fetchCol();
    return new JsonResponse([
        'names' => $names,
    ]);
}