public function FilterNumericTest::testFilterNumericBetween

File

drupal/core/modules/views/lib/Drupal/views/Tests/Handler/FilterNumericTest.php, line 98

Definition of Drupal\views\Tests\Handler\FilterNumericTest.

Class

FilterNumericTest

Tests the numeric filter handler.

Namespace

Code

public function testFilterNumericBetween() {
  $view = views_get_view('test_view');
  $view
    ->setDisplay();

  // Change the filtering
  $view->displayHandlers['default']
    ->overrideOption('filters', array(
    'age' => array(
      'id' => 'age',
      'table' => 'views_test_data',
      '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
    ->destroy();
  $view
    ->setDisplay();

  // Change the filtering
  $view->displayHandlers['default']
    ->overrideOption('filters', array(
    'age' => array(
      'id' => 'age',
      'table' => 'views_test_data',
      '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);
}