public function FieldOrLanguageJoinTest::testBase in Drupal 8

Same name and namespace in other branches

1. 9 core/modules/views/tests/src/Kernel/Plugin/FieldOrLanguageJoinTest.php \Drupal\Tests\views\Kernel\Plugin\FieldOrLanguageJoinTest::testBase()

Tests base join functionality.

This duplicates parts of \Drupal\Tests\views\Kernel\Plugin\JoinTest::testBasePlugin() to ensure that no functionality provided by the base join plugin is broken.

File

core/modules/views/tests/src/Kernel/Plugin/FieldOrLanguageJoinTest.php, line 50

Class

FieldOrLanguageJoinTest

Tests the "field OR language" join plugin.

Namespace

Drupal\Tests\views\Kernel\Plugin

Code

public function testBase() {

  // Setup a simple join and test the result sql.
  $view = Views::getView('test_view');
  $view
    ->initDisplay();
  $view
    ->initQuery();

  // First define a simple join without an extra condition.
  // Set the various options on the join object.
  $configuration = [
    'left_table' => 'views_test_data',
    'left_field' => 'uid',
    'table' => 'users_field_data',
    'field' => 'uid',
    'adjusted' => TRUE,
  ];
  $join = $this->manager
    ->createInstance($this->pluginId, $configuration);
  $this
    ->assertInstanceOf(FieldOrLanguageJoin::class, $join);
  $this
    ->assertNull($join->extra);
  $this
    ->assertTrue($join->adjusted);
  $join_info = $this
    ->buildJoin($view, $configuration, 'users_field_data');
  $this
    ->assertSame($join_info['join type'], 'LEFT');
  $this
    ->assertSame($join_info['table'], $configuration['table']);
  $this
    ->assertSame($join_info['alias'], 'users_field_data');
  $this
    ->assertSame($join_info['condition'], 'views_test_data.uid = users_field_data.uid');

  // Set a different alias and make sure table info is as expected.
  $join_info = $this
    ->buildJoin($view, $configuration, 'users1');
  $this
    ->assertSame($join_info['alias'], 'users1');

  // Set a different join type (INNER) and make sure it is used.
  $configuration['type'] = 'INNER';
  $join_info = $this
    ->buildJoin($view, $configuration, 'users2');
  $this
    ->assertSame($join_info['join type'], 'INNER');

  // Setup addition conditions and make sure it is used.
  $random_name_1 = $this
    ->randomMachineName();
  $random_name_2 = $this
    ->randomMachineName();
  $configuration['extra'] = [
    [
      'field' => 'name',
      'value' => $random_name_1,
    ],
    [
      'field' => 'name',
      'value' => $random_name_2,
      'operator' => '<>',
    ],
  ];
  $join_info = $this
    ->buildJoin($view, $configuration, 'users3');
  $this
    ->assertStringContainsString('views_test_data.uid = users3.uid', $join_info['condition']);
  $this
    ->assertStringContainsString('users3.name = :views_join_condition_0', $join_info['condition']);
  $this
    ->assertStringContainsString('users3.name <> :views_join_condition_1', $join_info['condition']);
  $this
    ->assertSame(array_values($join_info['arguments']), [
    $random_name_1,
    $random_name_2,
  ]);

  // Test that 'IN' conditions are properly built.
  $random_name_1 = $this
    ->randomMachineName();
  $random_name_2 = $this
    ->randomMachineName();
  $random_name_3 = $this
    ->randomMachineName();
  $random_name_4 = $this
    ->randomMachineName();
  $configuration['extra'] = [
    [
      'field' => 'name',
      'value' => $random_name_1,
    ],
    [
      'field' => 'name',
      'value' => [
        $random_name_2,
        $random_name_3,
        $random_name_4,
      ],
    ],
  ];
  $join_info = $this
    ->buildJoin($view, $configuration, 'users4');
  $this
    ->assertStringContainsString('views_test_data.uid = users4.uid', $join_info['condition']);
  $this
    ->assertStringContainsString('users4.name = :views_join_condition_0', $join_info['condition']);
  $this
    ->assertStringContainsString('users4.name IN ( :views_join_condition_1[] )', $join_info['condition']);
  $this
    ->assertSame($join_info['arguments'][':views_join_condition_1[]'], [
    $random_name_2,
    $random_name_3,
    $random_name_4,
  ]);
}