public function JoinTest::testBasePlugin in Views (for Drupal 7) 8.3

Tests the join plugin base.

File

lib/Drupal/views/Tests/Plugin/JoinTest.php, line 77

Definition of Drupal\views\Tests\Plugin\JoinTest.

Class

JoinTest

Tests a generic join plugin and the join plugin base.

Namespace

Drupal\views\Tests\Plugin

Code

public function testBasePlugin() {

  // Setup a simple join and test the result sql.
  $view = views_get_view('frontpage');
  $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' => 'node',
    'left_field' => 'uid',
    'table' => 'users',
    'field' => 'uid',
  );
  $join = $this->manager
    ->createInstance('standard', $configuration);
  $this
    ->assertTrue($join instanceof JoinPluginBase, 'The correct join class got loaded.');

  // Build the actual join values and read them back from the dbtng query
  // object.
  $query = db_select('node');
  $table = array(
    'alias' => 'users',
  );
  $join
    ->buildJoin($query, $table, $view->query);
  $tables = $query
    ->getTables();
  $join_info = $tables['users'];
  $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');
  $this
    ->assertEqual($join_info['condition'], 'node.uid = users.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
    ->randomName();
  $random_name_2 = $this
    ->randomName();
  $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'], "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');
}