function RelationshipJoinInTest::testRelationshipInQuery

Tests the query result of a view with a relationship with an IN condition.

File

core/modules/views/tests/src/Kernel/Plugin/RelationshipJoinInTest.php, line 43

Class

RelationshipJoinInTest

Tests the base relationship handler.

Namespace

Code

public function testRelationshipInQuery() : void {
  // Update the first two Beatles to be authored by Kristiaan.
  $account_k = $this->createUser([], 'Kristiaan');
  $connection = Database::getConnection();
  $connection->update('views_test_data')
    ->fields([
    'uid' => $account_k->id(),
  ])
    ->condition('id', [
    1,
    2,
  ], 'IN')
    ->execute();
  // Update the other two Beatles to be authored by Django.
  $account_d = $this->createUser([], 'Django');
  $connection->update('views_test_data')
    ->fields([
    'uid' => $account_d->id(),
  ])
    ->condition('id', [
    3,
    4,
  ], 'IN')
    ->execute();
  // Update Meredith to be authored by Silvie.
  $account_s = $this->createUser([], 'Silvie');
  $connection->update('views_test_data')
    ->fields([
    'uid' => $account_s->id(),
  ])
    ->condition('id', 5)
    ->execute();
  $view = Views::getView('test_view');
  $view->setDisplay();
  $view->displayHandlers
    ->get('default')
    ->overrideOption('relationships', [
    'uid' => [
      'id' => 'uid',
      'table' => 'views_test_data',
      'field' => 'uid',
      'required' => TRUE,
    ],
  ]);
  $view->displayHandlers
    ->get('default')
    ->overrideOption('filters', [
    'uid' => [
      'id' => 'uid',
      'table' => 'users_field_data',
      'field' => 'uid',
      'relationship' => 'uid',
    ],
  ]);
  $fields = $view->displayHandlers
    ->get('default')
    ->getOption('fields');
  $view->displayHandlers
    ->get('default')
    ->overrideOption('fields', $fields + [
    'uid' => [
      'id' => 'uid',
      'table' => 'users_field_data',
      'field' => 'uid',
      'relationship' => 'uid',
    ],
  ]);
  // Check for all beatles created by Kristiaan.
  $view->initHandlers();
  $view->filter['uid']->value = [
    $account_k->id(),
  ];
  $this->executeView($view);
  $expected_result = [
    [
      'name' => 'John',
      'uid' => $account_k->id(),
    ],
    [
      'name' => 'George',
      'uid' => $account_k->id(),
    ],
  ];
  $this->assertIdenticalResultset($view, $expected_result, $this->columnMap);
  $view->destroy();
  // Check for all beatles created by Django. This should not return anything
  // as the 'extra' option on the join prohibits relating to any authors but
  // Kristiaan or Silvie.
  $view->initHandlers();
  $view->filter['uid']->value = [
    $account_d->id(),
  ];
  $this->executeView($view);
  $expected_result = [];
  $this->assertIdenticalResultset($view, $expected_result, $this->columnMap);
  $view->destroy();
  // Check for all people created by anyone.
  $view->initHandlers();
  $this->executeView($view);
  $expected_result = [
    [
      'name' => 'John',
      'uid' => $account_k->id(),
    ],
    [
      'name' => 'George',
      'uid' => $account_k->id(),
    ],
    [
      'name' => 'Meredith',
      'uid' => $account_s->id(),
    ],
  ];
  $this->assertIdenticalResultset($view, $expected_result, $this->columnMap);
  $view->destroy();
}