1.20.x database_test.test DatabaseSelectPagerDefaultTestCase::testOddPagerQuery()

Confirm that a pager query returns the correct results.

Note that we have to make an HTTP request to a test page handler because the pager depends on GET parameters.

File

modules/simpletest/tests/database_test.test, line 2329
Database tests.

Class

DatabaseSelectPagerDefaultTestCase

Code

function testOddPagerQuery() {
  // To keep the test from being too brittle, we determine up front
  // what the page count should be dynamically, and pass the control
  // information forward to the actual query on the other side of the
  // HTTP request.
  $limit = 2;
  $count = db_query('SELECT COUNT(*) FROM {test_task}')->fetchField();

  $correct_number = $limit;
  $num_pages = floor($count / $limit);

  // If there is no remainder from rounding, subtract 1 since we index from 0.
  if (!($num_pages * $limit < $count)) {
    $num_pages--;
  }

  for ($page = 0; $page <= $num_pages; ++$page) {
    $this->backdropGet('database_test/pager_query_odd/' . $limit, array('query' => array('page' => $page)));
    $data = json_decode($this->backdropGetContent());

    if ($page == $num_pages) {
      $correct_number = $count - ($limit * $page);
    }

    $this->assertEqual(count($data->names), $correct_number, format_string('Correct number of records returned by pager: @number', array('@number' => $correct_number)));
  }
}