public function RelationshipTest::testRelationshipQuery

Tests the query result of a view with a relationship.

File

drupal/core/modules/views/lib/Drupal/views/Tests/Handler/RelationshipTest.php, line 97

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

Class

RelationshipTest

Tests the base relationship handler.

Namespace

Code

public function testRelationshipQuery() {

  // Set the first entry to have the admin as author.
  db_query("UPDATE {views_test_data} SET uid = 1 WHERE id = 1");
  db_query("UPDATE {views_test_data} SET uid = 2 WHERE id <> 1");
  $view = views_get_view('test_view');
  $view
    ->setDisplay();
  $view->displayHandlers['default']
    ->overrideOption('relationships', array(
    'uid' => array(
      'id' => 'uid',
      'table' => 'views_test_data',
      'field' => 'uid',
    ),
  ));
  $view->displayHandlers['default']
    ->overrideOption('filters', array(
    'uid' => array(
      'id' => 'uid',
      'table' => 'users',
      'field' => 'uid',
      'relationship' => 'uid',
    ),
  ));
  $fields = $view->displayHandlers['default']
    ->getOption('fields');
  $view->displayHandlers['default']
    ->overrideOption('fields', $fields + array(
    'uid' => array(
      'id' => 'uid',
      'table' => 'users',
      'field' => 'uid',
      'relationship' => 'uid',
    ),
  ));
  $view
    ->initHandlers();

  // Check for all beatles created by admin.
  $view->filter['uid']->value = array(
    1,
  );
  $this
    ->executeView($view);
  $expected_result = array(
    array(
      'name' => 'John',
      'uid' => 1,
    ),
  );
  $this
    ->assertIdenticalResultset($view, $expected_result, $this->columnMap);
  $view
    ->destroy();

  // Check for all beatles created by another user, which so doesn't exist.
  $view
    ->initHandlers();
  $view->filter['uid']->value = array(
    3,
  );
  $this
    ->executeView($view);
  $expected_result = array();
  $this
    ->assertIdenticalResultset($view, $expected_result, $this->columnMap);
  $view
    ->destroy();

  // Set the relationship to required, so only results authored by the admin
  // should return.
  $view
    ->initHandlers();
  $view->relationship['uid']->options['required'] = TRUE;
  $this
    ->executeView($view);
  $expected_result = array(
    array(
      'name' => 'John',
      'uid' => 1,
    ),
  );
  $this
    ->assertIdenticalResultset($view, $expected_result, $this->columnMap);
  $view
    ->destroy();

  // Set the relationship to optional should cause to return all beatles.
  $view
    ->initHandlers();
  $view->relationship['uid']->options['required'] = FALSE;
  $this
    ->executeView($view);
  $expected_result = $this
    ->dataSet();

  // Alter the expected result to contain the right uids.
  foreach ($expected_result as $key => &$row) {

    // Only John has an existing author.
    if ($row['name'] == 'John') {
      $row['uid'] = 1;
    }
    else {

      // The LEFT join should set an empty {users}.uid field.
      $row['uid'] = NULL;
    }
  }
  $this
    ->assertIdenticalResultset($view, $expected_result, $this->columnMap);
}