class RelationshipJoinInTest

Same name and namespace in other branches
  1. 9 core/modules/views/tests/src/Kernel/Plugin/RelationshipJoinInTest.php \Drupal\Tests\views\Kernel\Plugin\RelationshipJoinInTest
  2. 8.9.x core/modules/views/tests/src/Kernel/Plugin/RelationshipJoinInTest.php \Drupal\Tests\views\Kernel\Plugin\RelationshipJoinInTest
  3. 11.x core/modules/views/tests/src/Kernel/Plugin/RelationshipJoinInTest.php \Drupal\Tests\views\Kernel\Plugin\RelationshipJoinInTest

Tests the base relationship handler.

@group views

Hierarchy

Expanded class hierarchy of RelationshipJoinInTest

See also

\Drupal\views\Plugin\views\relationship\RelationshipPluginBase

File

core/modules/views/tests/src/Kernel/Plugin/RelationshipJoinInTest.php, line 19

Namespace

Drupal\Tests\views\Kernel\Plugin
View source
class RelationshipJoinInTest extends RelationshipJoinTestBase {
  use UserCreationTrait;
  
  /**
   * Views used by this test.
   *
   * @var array
   */
  public static $testViews = [
    'test_view',
  ];
  
  /**
   * Maps between the key in the expected result and the query result.
   *
   * @var array
   */
  protected $columnMap = [
    'views_test_data_name' => 'name',
    'users_field_data_views_test_data_uid' => 'uid',
  ];
  
  /**
   * Tests the query result of a view with a relationship with an IN condition.
   */
  public function testRelationshipInQuery() : void {
    // Update the first two Beatles to be authored by Kristiaan.
    $account_k = $this->createUser([], 'Kristiaan');
    $connection = Database::getConnection();
    $connection->update('views_test_data')
      ->fields([
      'uid' => $account_k->id(),
    ])
      ->condition('id', [
      1,
      2,
    ], 'IN')
      ->execute();
    // Update the other two Beatles to be authored by Django.
    $account_d = $this->createUser([], 'Django');
    $connection->update('views_test_data')
      ->fields([
      'uid' => $account_d->id(),
    ])
      ->condition('id', [
      3,
      4,
    ], 'IN')
      ->execute();
    // Update Meredith to be authored by Silvie.
    $account_s = $this->createUser([], 'Silvie');
    $connection->update('views_test_data')
      ->fields([
      'uid' => $account_s->id(),
    ])
      ->condition('id', 5)
      ->execute();
    $view = Views::getView('test_view');
    $view->setDisplay();
    $view->displayHandlers
      ->get('default')
      ->overrideOption('relationships', [
      'uid' => [
        'id' => 'uid',
        'table' => 'views_test_data',
        'field' => 'uid',
        'required' => TRUE,
      ],
    ]);
    $view->displayHandlers
      ->get('default')
      ->overrideOption('filters', [
      'uid' => [
        'id' => 'uid',
        'table' => 'users_field_data',
        'field' => 'uid',
        'relationship' => 'uid',
      ],
    ]);
    $fields = $view->displayHandlers
      ->get('default')
      ->getOption('fields');
    $view->displayHandlers
      ->get('default')
      ->overrideOption('fields', $fields + [
      'uid' => [
        'id' => 'uid',
        'table' => 'users_field_data',
        'field' => 'uid',
        'relationship' => 'uid',
      ],
    ]);
    // Check for all beatles created by Kristiaan.
    $view->initHandlers();
    $view->filter['uid']->value = [
      $account_k->id(),
    ];
    $this->executeView($view);
    $expected_result = [
      [
        'name' => 'John',
        'uid' => $account_k->id(),
      ],
      [
        'name' => 'George',
        'uid' => $account_k->id(),
      ],
    ];
    $this->assertIdenticalResultset($view, $expected_result, $this->columnMap);
    $view->destroy();
    // Check for all beatles created by Django. This should not return anything
    // as the 'extra' option on the join prohibits relating to any authors but
    // Kristiaan or Silvie.
    $view->initHandlers();
    $view->filter['uid']->value = [
      $account_d->id(),
    ];
    $this->executeView($view);
    $expected_result = [];
    $this->assertIdenticalResultset($view, $expected_result, $this->columnMap);
    $view->destroy();
    // Check for all people created by anyone.
    $view->initHandlers();
    $this->executeView($view);
    $expected_result = [
      [
        'name' => 'John',
        'uid' => $account_k->id(),
      ],
      [
        'name' => 'George',
        'uid' => $account_k->id(),
      ],
      [
        'name' => 'Meredith',
        'uid' => $account_s->id(),
      ],
    ];
    $this->assertIdenticalResultset($view, $expected_result, $this->columnMap);
    $view->destroy();
  }
  
  /**
   * Adds an IN condition for the user name.
   */
  protected function viewsData() {
    $data = parent::viewsData();
    // Only relate if the author's name is Kristiaan or Silvie.
    $data['views_test_data']['uid']['relationship']['extra'][] = [
      'field' => 'name',
      'value' => [
        'Kristiaan',
        'Silvie',
      ],
    ];
    return $data;
  }

}

Members

Title Sort descending Modifiers Object type Summary Overriden Title
RelationshipJoinInTest::$columnMap protected property Maps between the key in the expected result and the query result.
RelationshipJoinInTest::$testViews public static property Views used by this test.
RelationshipJoinInTest::testRelationshipInQuery public function Tests the query result of a view with a relationship with an IN condition.
RelationshipJoinInTest::viewsData protected function Adds an IN condition for the user name. Overrides RelationshipJoinTestBase::viewsData
RelationshipJoinTestBase::$modules protected static property
RelationshipJoinTestBase::$rootUser protected property
RelationshipJoinTestBase::schemaDefinition protected function Overrides \Drupal\views\Tests\ViewTestBase::schemaDefinition().
RelationshipJoinTestBase::setUpFixtures protected function
UserCreationTrait::checkPermissions protected function Checks whether a given list of permission names is valid.
UserCreationTrait::createAdminRole protected function Creates an administrative role.
UserCreationTrait::createRole protected function Creates a role with specified permissions.
UserCreationTrait::createUser protected function Create a user with a given set of permissions.
UserCreationTrait::grantPermissions protected function Grant permissions to a user role.
UserCreationTrait::setCurrentUser protected function Switch the current logged in user.
UserCreationTrait::setUpCurrentUser protected function Creates a random user account and sets it as current user.

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.