public function JoinTest::testBasePlugin in Zircon Profile 8
Same name and namespace in other branches
- 8.0 core/modules/views/src/Tests/Plugin/JoinTest.php \Drupal\views\Tests\Plugin\JoinTest::testBasePlugin()
Tests the join plugin base.
File
- core/
modules/ views/ src/ Tests/ Plugin/ JoinTest.php, line 79 - Contains \Drupal\views\Tests\Plugin\JoinTest.
Class
- JoinTest
- Tests the join plugin.
Namespace
Drupal\views\Tests\PluginCode
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 = array(
'left_table' => 'views_test_data',
'left_field' => 'uid',
'table' => 'users_field_data',
'field' => 'uid',
'adjusted' => TRUE,
);
$join = $this->manager
->createInstance('standard', $configuration);
$this
->assertTrue($join instanceof JoinPluginBase, 'The correct join class got loaded.');
$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 = db_select('views_test_data');
$table = array(
'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 = array(
'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 = array(
'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'] = array(
array(
'field' => 'name',
'value' => $random_name_1,
),
array(
'field' => 'name',
'value' => $random_name_2,
'operator' => '<>',
),
);
$join = $this->manager
->createInstance('standard', $configuration);
$table = array(
'alias' => 'users3',
);
$join
->buildJoin($query, $table, $view->query);
$tables = $query
->getTables();
$join_info = $tables['users3'];
$this
->assertTrue(strpos($join_info['condition'], "views_test_data.uid = users3.uid") !== FALSE, 'Make sure the join condition appears in the query.');
$this
->assertTrue(strpos($join_info['condition'], "users3.name = :views_join_condition_0") !== FALSE, 'Make sure the first extra join condition appears in the query and uses the first placeholder.');
$this
->assertTrue(strpos($join_info['condition'], "users3.name <> :views_join_condition_1") !== FALSE, 'Make sure the second extra join condition appears in the query and uses the second placeholder.');
$this
->assertEqual(array_values($join_info['arguments']), array(
$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'] = array(
array(
'field' => 'name',
'value' => $random_name_1,
),
array(
'field' => 'name',
'value' => array(
$random_name_2,
$random_name_3,
$random_name_4,
),
),
);
$join = $this->manager
->createInstance('standard', $configuration);
$table = array(
'alias' => 'users4',
);
$join
->buildJoin($query, $table, $view->query);
$tables = $query
->getTables();
$join_info = $tables['users4'];
$this
->assertTrue(strpos($join_info['condition'], "views_test_data.uid = users4.uid") !== FALSE, 'Make sure the join condition appears in the query.');
$this
->assertTrue(strpos($join_info['condition'], "users4.name = :views_join_condition_2") !== FALSE, 'Make sure the first extra join condition appears in the query.');
$this
->assertTrue(strpos($join_info['condition'], "users4.name IN ( :views_join_condition_3, :views_join_condition_4, :views_join_condition_5 )") !== FALSE, 'The IN condition for the join is properly formed.');
// Test that all the conditions are properly built.
$configuration['extra'] = array(
array(
'field' => 'langcode',
'value' => 'en',
),
array(
'left_field' => 'status',
'value' => 0,
'numeric' => TRUE,
),
array(
'field' => 'name',
'left_field' => 'name',
),
);
$join = $this->manager
->createInstance('standard', $configuration);
$table = array(
'alias' => 'users5',
);
$join
->buildJoin($query, $table, $view->query);
$tables = $query
->getTables();
$join_info = $tables['users5'];
$this
->assertTrue(strpos($join_info['condition'], "views_test_data.uid = users5.uid") !== FALSE, 'Make sure the join condition appears in the query.');
$this
->assertTrue(strpos($join_info['condition'], "users5.langcode = :views_join_condition_6") !== FALSE, 'Make sure the first extra join condition appears in the query.');
$this
->assertTrue(strpos($join_info['condition'], "views_test_data.status = :views_join_condition_7") !== FALSE, 'Make sure the second extra join condition appears in the query.');
$this
->assertTrue(strpos($join_info['condition'], "users5.name = views_test_data.name") !== FALSE, 'Make sure the third extra join condition appears in the query.');
$this
->assertEqual(array_values($join_info['arguments']), array(
'en',
0,
), 'Make sure the arguments are in the right order');
}