function WorkspaceViewsIntegrationTest::testViewsQueryAlter

Tests workspace query alter for views.

@covers \Drupal\workspaces\ViewsQueryAlter::alterQueryForEntityType
@covers \Drupal\workspaces\ViewsQueryAlter::getRevisionTableJoin

File

core/modules/workspaces/tests/src/Kernel/WorkspaceViewsIntegrationTest.php, line 106

Class

WorkspaceViewsIntegrationTest

Tests the views integration for workspaces.

Namespace

Code

public function testViewsQueryAlter() : void {
  // Create a test entity and two nodes.
  $test_entity = \Drupal::entityTypeManager()->getStorage('entity_test_mulrevpub')
    ->create([
    'name' => 'test entity - live',
  ]);
  $test_entity->save();
  $node_1 = $this->createNode([
    'title' => 'node - live - 1',
    'body' => 'node 1',
    'created' => $this->createdTimestamp++,
    'field_reference' => $test_entity->id(),
  ]);
  $node_2 = $this->createNode([
    'title' => 'node - live - 2',
    'body' => 'node 2',
    'created' => $this->createdTimestamp++,
  ]);
  // Create a new workspace and activate it.
  Workspace::create([
    'id' => 'stage',
    'label' => 'Stage',
  ])->save();
  $this->switchToWorkspace('stage');
  $view = Views::getView('frontpage');
  // Add a filter on a field that is stored in a dedicated table in order to
  // test field joins with extra conditions (e.g. 'deleted' and 'langcode').
  $view->setDisplay('page_1');
  $filters = $view->displayHandlers
    ->get('page_1')
    ->getOption('filters');
  $view->displayHandlers
    ->get('page_1')
    ->overrideOption('filters', $filters + [
    'body_value' => [
      'id' => 'body_value',
      'table' => 'node__body',
      'field' => 'body_value',
      'operator' => 'not empty',
      'plugin_id' => 'string',
    ],
  ]);
  $view->execute();
  $expected = [
    [
      'nid' => $node_2->id(),
    ],
    [
      'nid' => $node_1->id(),
    ],
  ];
  $this->assertIdenticalResultset($view, $expected, [
    'nid' => 'nid',
  ]);
  // Add a filter on a field from a relationship, in order to test field
  // joins with extra conditions (e.g. 'deleted' and 'langcode').
  $view->destroy();
  $view->setDisplay('page_1');
  $view->displayHandlers
    ->get('page_1')
    ->overrideOption('relationships', [
    'field_reference' => [
      'id' => 'field_reference',
      'table' => 'node__field_reference',
      'field' => 'field_reference',
      'required' => FALSE,
    ],
  ]);
  $view->displayHandlers
    ->get('page_1')
    ->overrideOption('filters', $filters + [
    'name' => [
      'id' => 'name',
      'table' => 'entity_test_mulrevpub_property_data',
      'field' => 'name',
      'operator' => 'not empty',
      'relationship' => 'field_reference',
    ],
  ]);
  $view->execute();
  $expected = [
    [
      'nid' => $node_1->id(),
    ],
  ];
  $this->assertIdenticalResultset($view, $expected, [
    'nid' => 'nid',
  ]);
}