public function ViewsHandlerFilterNumericTest::testFilterNumericBetween

File

core/modules/views/tests/handlers/views_handler_filter_numeric.test, line 75

Definition of ViewsHandlerFilterNumericTest.

Class

ViewsHandlerFilterNumericTest

Tests the numeric filter handler.

Code

public function testFilterNumericBetween() {
  $view = $this->getBasicView();

  // Change the filtering
  $view->display['default']->handler->override_option('filters', array(
    'age' => array(
      'id' => 'age',
      'table' => 'views_test',
      'field' => 'age',
      'relationship' => 'none',
      'operator' => 'between',
      'value' => array(
        'min' => 26,
        'max' => 29,
      ),
    ),
  ));

  $this->executeView($view);
  $resultset = array(
    array(
      'name' => 'George',
      'age' => 27,
    ),
    array(
      'name' => 'Ringo',
      'age' => 28,
    ),
    array(
      'name' => 'Paul',
      'age' => 26,
    ),
  );
  $this->assertIdenticalResultset($view, $resultset, $this->column_map);

  // test not between
  $view->delete();
  $view = $this->getBasicView();

  // Change the filtering
  $view->display['default']->handler->override_option('filters', array(
    'age' => array(
      'id' => 'age',
      'table' => 'views_test',
      'field' => 'age',
      'relationship' => 'none',
      'operator' => 'not between',
      'value' => array(
        'min' => 26,
        'max' => 29,
      ),
    ),
  ));

  $this->executeView($view);
  $resultset = array(
    array(
      'name' => 'John',
      'age' => 25,
    ),
    array(
      'name' => 'Paul',
      'age' => 26,
    ),
    array(
      'name' => 'Meredith',
      'age' => 30,
    ),
  );
  $this->assertIdenticalResultset($view, $resultset, $this->column_map);
}