Club Drupal

<?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',

    ));

  }

}