function NodeAccessTest::testQueryWithBaseTableJoin

Tests node grants for queries with node access checks and base table join.

File

core/modules/node/tests/src/Kernel/NodeAccessTest.php, line 131

Class

NodeAccessTest

Tests basic node_access functionality.

Namespace

Code

public function testQueryWithBaseTableJoin() : void {
    $this->enableModules([
        'node_access_test_empty',
    ]);
    $this->drupalCreateNode([
        'type' => 'page',
    ]);
    $this->drupalCreateNode([
        'type' => 'page',
    ]);
    $container = \Drupal::getContainer();
    $container->get('current_user')
        ->setAccount($this->drupalCreateUser());
    $query = \Drupal::database()->select('node_field_data', 'n');
    // Intentionally add a left join of the base table on the base table with a
    // failing condition. This can, for example, happen in views with non
    // required relations.
    $query->leftJoin('node_field_data', 'nc', 'n.changed = nc.nid');
    $query->addTag('node_access');
    $this->assertEquals(2, $query->countQuery()
        ->execute()
        ->fetchField());
    $query = \Drupal::database()->select('node_field_data', 'n');
    // Use a Condition object to do the left join to test that this is handled
    // correctly.
    $join_cond = \Drupal::database()->condition('AND')
        ->where('[n].[changed] = [n].[changed]');
    $join_cond->compile(\Drupal::database(), $query);
    $query->leftJoin('node_field_data', 'nc', (string) $join_cond);
    $query->addTag('node_access');
    $this->assertEquals(4, $query->countQuery()
        ->execute()
        ->fetchField());
}