class SqlEntityLoadingTest

class SqlEntityLoadingTest extends ViewsKernelTestBase {
  
  /**
   * {@inheritdoc}
   */
  protected static $modules = [
    'node',
    'user',
  ];
  
  /**
   * {@inheritdoc}
   */
  public static $testViews = [
    'base_and_revision',
  ];
  
  /**
   * {@inheritdoc}
   */
  protected function setUp($import_test_views = TRUE) : void {
    parent::setUp($import_test_views);
    $this->installEntitySchema('node');
    $this->installEntitySchema('user');
    $this->installSchema('node', 'node_access');
  }
  public function testViewWithNonDefaultPendingRevision() {
    $node_type = NodeType::create([
      'type' => 'page',
    ]);
    $node_type->save();
    $node = Node::create([
      'type' => 'page',
      'title' => 'test title',
    ]);
    $node->save();
    // Creates the first revision, which is set as default.
    $revision = clone $node;
    $revision->setNewRevision(TRUE);
    $revision->isDefaultRevision(TRUE);
    $revision->save();
    // Creates the second revision, which is not set as default.
    $revision2 = clone $node;
    $revision2->setNewRevision(TRUE);
    $revision2->isDefaultRevision(FALSE);
    $revision2->save();
    $view = Views::getView('base_and_revision');
    $view->execute();
    $expected = [
      [
        'nid' => $node->id(),
        // The default revision ID.
'vid_1' => $revision->getRevisionId(),
        // The latest revision ID.
'vid' => $revision2->getRevisionId(),
      ],
    ];
    $this->assertIdenticalResultset($view, $expected, [
      'node_field_data_node_field_revision_nid' => 'nid',
      'vid_1' => 'vid_1',
      'vid' => 'vid',
    ]);
  }

}