Runs a pager query and returns the results.
This function does care about the page GET parameter, as set by the simpletest HTTP call.
function database_test_even_pager_query($limit) {
$query = db_select('test', 't');
$query
->fields('t', array(
'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(array(
'names' => $names,
));
}