public function JoinTest::testBasePlugin in Drupal 8

Same name and namespace in other branches
9 core/modules/views/tests/src/Kernel/Plugin/JoinTest.php \Drupal\Tests\views\Kernel\Plugin\JoinTest::testBasePlugin()
Tests the join plugin base.
File

core/modules/views/tests/src/Kernel/Plugin/JoinTest.php, line 74
Class

JoinTest: Tests the join plugin.
Namespace

Drupal\Tests\views\Kernel\Plugin
Code

public function testBasePlugin() {

  // 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('standard', $configuration);
  $this
    ->assertInstanceOf(JoinPluginBase::class, $join);
  $this
    ->assertNull($join->extra, 'The field extra was not overridden.');
  $this
    ->assertTrue($join->adjusted, 'The field adjusted was set correctly.');

  // Build the actual join values and read them back from the dbtng query
  // object.
  $query = Database::getConnection()
    ->select('views_test_data');
  $table = [
    'alias' => 'users_field_data',
  ];
  $join
    ->buildJoin($query, $table, $view->query);
  $tables = $query
    ->getTables();
  $join_info = $tables['users_field_data'];
  $this
    ->assertEqual($join_info['join type'], 'LEFT', 'Make sure the default join type is LEFT');
  $this
    ->assertEqual($join_info['table'], $configuration['table']);
  $this
    ->assertEqual($join_info['alias'], 'users_field_data');
  $this
    ->assertEqual($join_info['condition'], 'views_test_data.uid = users_field_data.uid');

  // Set a different alias and make sure table info is as expected.
  $join = $this->manager
    ->createInstance('standard', $configuration);
  $table = [
    'alias' => 'users1',
  ];
  $join
    ->buildJoin($query, $table, $view->query);
  $tables = $query
    ->getTables();
  $join_info = $tables['users1'];
  $this
    ->assertEqual($join_info['alias'], 'users1');

  // Set a different join type (INNER) and make sure it is used.
  $configuration['type'] = 'INNER';
  $join = $this->manager
    ->createInstance('standard', $configuration);
  $table = [
    'alias' => 'users2',
  ];
  $join
    ->buildJoin($query, $table, $view->query);
  $tables = $query
    ->getTables();
  $join_info = $tables['users2'];
  $this
    ->assertEqual($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 = $this->manager
    ->createInstance('standard', $configuration);
  $table = [
    'alias' => 'users3',
  ];
  $join
    ->buildJoin($query, $table, $view->query);
  $tables = $query
    ->getTables();
  $join_info = $tables['users3'];
  $this
    ->assertStringContainsString("views_test_data.uid = users3.uid", $join_info['condition'], 'Make sure the join condition appears in the query.');
  $this
    ->assertStringContainsString("users3.name = :views_join_condition_0", $join_info['condition'], 'Make sure the first extra join condition appears in the query and uses the first placeholder.');
  $this
    ->assertStringContainsString("users3.name <> :views_join_condition_1", $join_info['condition'], 'Make sure the second extra join condition appears in the query and uses the second placeholder.');
  $this
    ->assertEqual(array_values($join_info['arguments']), [
    $random_name_1,
    $random_name_2,
  ], 'Make sure the arguments are in the right order');

  // 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 = $this->manager
    ->createInstance('standard', $configuration);
  $table = [
    'alias' => 'users4',
  ];
  $join
    ->buildJoin($query, $table, $view->query);
  $tables = $query
    ->getTables();
  $join_info = $tables['users4'];
  $this
    ->assertStringContainsString("views_test_data.uid = users4.uid", $join_info['condition'], 'Make sure the join condition appears in the query.');
  $this
    ->assertStringContainsString("users4.name = :views_join_condition_2", $join_info['condition'], 'Make sure the first extra join condition appears in the query.');
  $this
    ->assertStringContainsString("users4.name IN ( :views_join_condition_3[] )", $join_info['condition'], 'The IN condition for the join is properly formed.');
  $this
    ->assertEqual($join_info['arguments'][':views_join_condition_3[]'], [
    $random_name_2,
    $random_name_3,
    $random_name_4,
  ], 'Make sure the IN arguments are still part of an array.');

  // Test that all the conditions are properly built.
  $configuration['extra'] = [
    [
      'field' => 'langcode',
      'value' => 'en',
    ],
    [
      'left_field' => 'status',
      'value' => 0,
      'numeric' => TRUE,
    ],
    [
      'field' => 'name',
      'left_field' => 'name',
    ],
  ];
  $join = $this->manager
    ->createInstance('standard', $configuration);
  $table = [
    'alias' => 'users5',
  ];
  $join
    ->buildJoin($query, $table, $view->query);
  $tables = $query
    ->getTables();
  $join_info = $tables['users5'];
  $this
    ->assertStringContainsString("views_test_data.uid = users5.uid", $join_info['condition'], 'Make sure the join condition appears in the query.');
  $this
    ->assertStringContainsString("users5.langcode = :views_join_condition_4", $join_info['condition'], 'Make sure the first extra join condition appears in the query.');
  $this
    ->assertStringContainsString("views_test_data.status = :views_join_condition_5", $join_info['condition'], 'Make sure the second extra join condition appears in the query.');
  $this
    ->assertStringContainsString("users5.name = views_test_data.name", $join_info['condition'], 'Make sure the third extra join condition appears in the query.');
  $this
    ->assertEqual(array_values($join_info['arguments']), [
    'en',
    0,
  ], 'Make sure the arguments are in the right order');

  // Test that joins using 'left_formula' are properly built.
  $configuration['left_formula'] = 'MAX(views_test_data.uid)';
  $join = $this->manager
    ->createInstance('standard', $configuration);
  $table = [
    'alias' => 'users6',
  ];
  $join
    ->buildJoin($query, $table, $view->query);
  $tables = $query
    ->getTables();
  $join_info = $tables['users6'];
  $this
    ->assertStringContainsString("MAX(views_test_data.uid) = users6.uid", $join_info['condition'], 'Make sure the join condition appears in the query.');
  $this
    ->assertStringContainsString("users6.langcode = :views_join_condition_7", $join_info['condition'], 'Make sure the first extra join condition appears in the query.');
  $this
    ->assertStringContainsString("views_test_data.status = :views_join_condition_8", $join_info['condition'], 'Make sure the second extra join condition appears in the query.');
  $this
    ->assertStringContainsString("users6.name = views_test_data.name", $join_info['condition'], 'Make sure the third extra join condition appears in the query.');
  $this
    ->assertEqual(array_values($join_info['arguments']), [
    'en',
    0,
  ], 'Make sure the arguments are in the right order');
}
You are here

public function JoinTest::testBasePlugin in Drupal 8

File

Class

Namespace

Code

API Navigation
