class RelationshipJoinInTest

Same name 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. 10 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.