views_basic.test

<?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',
        ));
    }

}