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());
}