123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181 |
- <?php
- /**
- * @file
- */
- /**
- * Basic test class for Views query builder tests.
- */
- /**
- *
- */
- class ViewsBasicTest extends ViewsSqlTest {
- public static function getInfo() {
- return array(
- 'name' => 'Basic query test',
- 'description' => 'A basic query test for Views.',
- 'group' => 'Views',
- );
- }
- /**
- * Tests a trivial result set.
- */
- public function testSimpleResultSet() {
- $view = $this->getBasicView();
- // Execute the view.
- $this->executeView($view);
- // Verify the result.
- $this->assertEqual(5, count($view->result), t('The number of returned rows match.'));
- $this->assertIdenticalResultset($view, $this->dataSet(), array(
- 'views_test_name' => 'name',
- 'views_test_age' => 'age',
- ));
- }
- /**
- * Tests filtering of the result set.
- */
- public function testSimpleFiltering() {
- $view = $this->getBasicView();
- // Add a filter.
- $view->display['default']->handler->override_option('filters', array(
- 'age' => array(
- 'operator' => '<',
- 'value' => array(
- 'value' => '28',
- 'min' => '',
- 'max' => '',
- ),
- 'group' => '0',
- 'exposed' => FALSE,
- 'expose' => array(
- 'operator' => FALSE,
- 'label' => '',
- ),
- 'id' => 'age',
- 'table' => 'views_test',
- 'field' => 'age',
- 'relationship' => 'none',
- ),
- ));
- // Execute the view.
- $this->executeView($view);
- // Build the expected result.
- $dataset = array(
- array(
- 'id' => 1,
- 'name' => 'John',
- 'age' => 25,
- ),
- array(
- 'id' => 2,
- 'name' => 'George',
- 'age' => 27,
- ),
- array(
- 'id' => 4,
- 'name' => 'Paul',
- 'age' => 26,
- ),
- );
- // Verify the result.
- $this->assertEqual(3, count($view->result), t('The number of returned rows match.'));
- $this->assertIdenticalResultSet($view, $dataset, array(
- 'views_test_name' => 'name',
- 'views_test_age' => 'age',
- ));
- }
- /**
- * Tests simple argument.
- */
- public function testSimpleArgument() {
- $view = $this->getBasicView();
- // Add a argument.
- $view->display['default']->handler->override_option('arguments', array(
- 'age' => array(
- 'default_action' => 'ignore',
- 'style_plugin' => 'default_summary',
- 'style_options' => array(),
- 'wildcard' => 'all',
- 'wildcard_substitution' => 'All',
- 'title' => '',
- 'breadcrumb' => '',
- 'default_argument_type' => 'fixed',
- 'default_argument' => '',
- 'validate_type' => 'none',
- 'validate_fail' => 'not found',
- 'break_phrase' => 0,
- 'not' => 0,
- 'id' => 'age',
- 'table' => 'views_test',
- 'field' => 'age',
- 'validate_user_argument_type' => 'uid',
- 'validate_user_roles' => array(
- '2' => 0,
- ),
- 'relationship' => 'none',
- 'default_options_div_prefix' => '',
- 'default_argument_user' => 0,
- 'default_argument_fixed' => '',
- 'default_argument_php' => '',
- 'validate_argument_node_type' => array(
- 'page' => 0,
- 'story' => 0,
- ),
- 'validate_argument_node_access' => 0,
- 'validate_argument_nid_type' => 'nid',
- 'validate_argument_vocabulary' => array(),
- 'validate_argument_type' => 'tid',
- 'validate_argument_transform' => 0,
- 'validate_user_restrict_roles' => 0,
- 'validate_argument_php' => '',
- ),
- ));
- $saved_view = clone $view;
- // Execute with a view.
- $view->set_arguments(array(27));
- $this->executeView($view);
- // Build the expected result.
- $dataset = array(
- array(
- 'id' => 2,
- 'name' => 'George',
- 'age' => 27,
- ),
- );
- // Verify the result.
- $this->assertEqual(1, count($view->result), t('The number of returned rows match.'));
- $this->assertIdenticalResultSet($view, $dataset, array(
- 'views_test_name' => 'name',
- 'views_test_age' => 'age',
- ));
- // Test "show all" if no argument is present.
- $view = $saved_view;
- $this->executeView($view);
- // Build the expected result.
- $dataset = $this->dataSet();
- $this->assertEqual(5, count($view->result), t('The number of returned rows match.'));
- $this->assertIdenticalResultSet($view, $dataset, array(
- 'views_test_name' => 'name',
- 'views_test_age' => 'age',
- ));
- }
- }
|