MigrateNodeCompleteTest.php

<?php

declare (strict_types=1);
namespace Drupal\Tests\node\Kernel\Migrate\d7;

use Drupal\Core\Database\Statement\FetchAs;
use Drupal\migrate\MigrateExecutable;
use Drupal\migrate_drupal\NodeMigrateType;
use Drupal\node\Entity\Node;
use Drupal\node\NodeInterface;
use Drupal\Tests\file\Kernel\Migrate\d7\FileMigrationSetupTrait;
use Drupal\Tests\migrate_drupal\Kernel\d7\MigrateDrupal7TestBase;
use Drupal\Tests\migrate_drupal\Traits\CreateTestContentEntitiesTrait;
use Drupal\Tests\migrate_drupal\Traits\NodeMigrateTypeTestTrait;
use PHPUnit\Framework\Attributes\Group;
use PHPUnit\Framework\Attributes\RunTestsInSeparateProcesses;

/**
 * Test class for a complete node migration for Drupal 7.
 */
class MigrateNodeCompleteTest extends MigrateDrupal7TestBase {
  use FileMigrationSetupTrait;
  use CreateTestContentEntitiesTrait;
  use NodeMigrateTypeTestTrait;
  
  /**
   * {@inheritdoc}
   */
  protected static $modules = [
    'content_translation',
    'comment',
    'datetime',
    'datetime_range',
    'image',
    'language',
    'link',
    'menu_ui',
    'node',
    'taxonomy',
    'telephone',
    'text',
  ];
  
  /**
   * The entity storage for node.
   *
   * @var \Drupal\Core\Entity\RevisionableStorageInterface
   */
  protected $nodeStorage;
  
  /**
   * {@inheritdoc}
   */
  protected function setUp() : void {
    parent::setUp();
    // Remove the classic node table made in setup.
    $this->removeNodeMigrateMapTable(NodeMigrateType::NODE_MIGRATE_TYPE_CLASSIC, '7');
    $this->fileMigrationSetup();
    $this->installEntitySchema('comment');
    $this->installEntitySchema('taxonomy_term');
    $this->installSchema('comment', [
      'comment_entity_statistics',
    ]);
    $this->installSchema('node', [
      'node_access',
    ]);
    $this->createContent();
    $this->nodeStorage = $this->container
      ->get('entity_type.manager')
      ->getStorage('node');
    $this->nodeStorage
      ->delete($this->nodeStorage
      ->loadMultiple());
    $this->migrateUsers();
    $this->migrateFields();
    $this->executeMigrations([
      'language',
      'd7_language_content_settings',
      'd7_comment_field',
      'd7_comment_field_instance',
      'd7_node_complete',
    ]);
    $this->nodeStorage = $this->container
      ->get('entity_type.manager')
      ->getStorage('node');
  }
  
  /**
   * {@inheritdoc}
   */
  protected function getFileMigrationInfo() : array {
    return [
      'path' => 'public://sites/default/files/cube.jpeg',
      'size' => 3620,
      'base_path' => 'public://',
      'plugin_id' => 'd7_file',
    ];
  }
  
  /**
   * Tests the complete node migration.
   */
  public function testNodeCompleteMigration() : void {
    // Confirm there are only complete node migration map tables. This shows
    // that only the complete migration ran.
    $results = $this->nodeMigrateMapTableCount('7');
    $this->assertSame(0, $results['node']);
    $this->assertSame(8, $results['node_complete']);
    $db = \Drupal::database();
    $this->assertEquals($this->expectedNodeFieldRevisionTable(), $db->select('node_field_revision', 'nr')
      ->fields('nr')
      ->orderBy('vid')
      ->orderBy('langcode')
      ->execute()
      ->fetchAll(FetchAs::Associative));
    $this->assertEquals($this->expectedNodeFieldDataTable(), $db->select('node_field_data', 'nr')
      ->fields('nr')
      ->orderBy('nid')
      ->orderBy('vid')
      ->orderBy('langcode')
      ->execute()
      ->fetchAll(FetchAs::Associative));
    // Load and test each revision.
    $data = $this->expectedRevisionEntityData()[0];
    foreach ($this->expectedNodeFieldRevisionTable() as $key => $revision) {
      $this->assertRevision($revision, $data[$key]);
    }
    // Test the migration of node and user reference fields.
    foreach ([
      2,
      3,
    ] as $revision_id) {
      $revision = $this->nodeStorage
        ->loadRevision($revision_id);
      $this->assertCount(1, $revision->field_node_reference);
      $this->assertSame('5', $revision->field_node_reference->target_id);
      $this->assertCount(1, $revision->field_user_reference);
      $this->assertSame('Bob', $revision->field_user_reference[0]->entity
        ->getAccountName());
    }
    // Test the translated node reference in the latest revision of node 2. This
    // references the legacy site node 4 instead of node 2. The reference is
    // fixed by the followup migrations, 'd7_entity_reference_translation' and
    // tested in \Drupal\Tests\migrate_drupal\Kernel\d7\FollowUpMigrationsTest.
    $node = Node::load(2);
    $this->assertSame('6', $node->get('field_reference_2')->target_id);
    $translation = $node->getTranslation('is');
    $this->assertSame('4', $translation->get('field_reference_2')->target_id);
    // Test the order in multi-value fields.
    $revision = $this->nodeStorage
      ->loadRevision(1);
    $this->assertSame([
      [
        'value' => 'default@example.com',
      ],
      [
        'value' => 'another@example.com',
      ],
    ], $revision->get('field_email')
      ->getValue());
    $this->assertSame([
      [
        'target_id' => '17',
      ],
      [
        'target_id' => '15',
      ],
    ], $revision->get('field_term_entityreference')
      ->getValue());
  }
  
  /**
   * Tests rollback of the complete node migration.
   */
  public function testRollbackNodeComplete() : void {
    $db = \Drupal::database();
    $node_types = [
      'article',
      'blog',
      'book',
      'forum',
      'page',
      'test_content_type',
    ];
    foreach ($node_types as $node_type) {
      // Execute the rollback.
      $this->migration = $this->getMigration("d7_node_complete:{$node_type}");
      (new MigrateExecutable($this->migration, $this))
        ->rollback();
      // Assert there are no nodes of node_type.
      $count = $db->select('node_field_data')
        ->condition('type', $node_type)
        ->countQuery()
        ->execute()
        ->fetchField();
      $this->assertSame($count, '0', "There are {$count} nodes of type {$node_type}");
    }
  }
  
  /**
   * Asserts various aspects of a node revision.
   *
   * @param array $revision
   *   An array of revision data matching a node_field_revision table row.
   * @param array $data
   *   An array of revision data.
   *
   * @internal
   */
  protected function assertRevision(array $revision, array $data) : void {
    /** @var  \Drupal\node\NodeInterface $actual */
    $actual = $this->nodeStorage
      ->loadRevision($revision['vid'])
      ->getTranslation($revision['langcode']);
    $this->assertInstanceOf(NodeInterface::class, $actual);
    $this->assertSame($revision['title'], $actual->getTitle(), sprintf("Title '%s' does not match actual '%s' for revision '%d' langcode '%s'", $revision['title'], $actual->getTitle(), $revision['vid'], $revision['langcode']));
    $this->assertSame($revision['revision_translation_affected'], $actual->get('revision_translation_affected')->value, sprintf("revision_translation_affected '%s' does not match actual '%s' for revision '%d' langcode '%s'", $revision['revision_translation_affected'], $actual->get('revision_translation_affected')->value, $revision['vid'], $revision['langcode']));
    $this->assertSame($data['revision_created'], $actual->getRevisionCreationTime(), sprintf("Creation time '%s' does not match actual '%s' for revision '%d' langcode '%s'", $data['revision_created'], $actual->getRevisionCreationTime(), $revision['vid'], $revision['langcode']));
    $this->assertSame($data['log'], $actual->getRevisionLogMessage(), sprintf("Revision log '%s' does not match actual '%s' for revision '%d' langcode '%s'", var_export($data['log'], TRUE), $actual->getRevisionLogMessage(), $revision['vid'], $revision['langcode']));
    if (isset($data['field_text_long_plain'])) {
      $this->assertSame($data['field_text_long_plain'], $actual->field_text_long_plain->value, sprintf("field_text_long_plain value '%s' does not match actual '%s' for revision '%d' langcode '%s'", var_export($data['field_text_long_plain'], TRUE), $actual->field_text_long_plain->value, $revision['vid'], $revision['langcode']));
    }
    if (isset($data['field_tree'])) {
      $this->assertSame($data['field_tree'], $actual->field_tree->value, sprintf("field_tree value '%s' does not match actual '%s' for revision '%d' langcode '%s'", var_export($data['field_tree'], TRUE), $actual->field_tree->value, $revision['vid'], $revision['langcode']));
    }
  }
  
  /**
   * Provides the expected node_field_data table.
   *
   * @return array
   *   The expected table rows.
   */
  protected function expectedNodeFieldDataTable() : array {
    return [
      0 => [
        'nid' => '1',
        'vid' => '1',
        'type' => 'test_content_type',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '2',
        'title' => 'An English Node',
        'created' => '1529615790',
        'changed' => '1529615790',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => '1',
        'content_translation_source' => NULL,
        'content_translation_outdated' => '0',
      ],
      1 => [
        'nid' => '2',
        'vid' => '12',
        'type' => 'article',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '2',
        'title' => 'The thing about Deep Space 9',
        'created' => '1441306772',
        'changed' => '1564543637',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => NULL,
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      2 => [
        'nid' => '2',
        'vid' => '12',
        'type' => 'article',
        'langcode' => 'is',
        'status' => '1',
        'uid' => '1',
        'title' => 'is - The thing about Deep Space 9',
        'created' => '1471428152',
        'changed' => '1564543706',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      3 => [
        'nid' => '4',
        'vid' => '14',
        'type' => 'article',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'en - The thing about Firefly',
        'created' => '1478755314',
        'changed' => '1564543929',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'is',
        'content_translation_outdated' => '0',
      ],
      4 => [
        'nid' => '4',
        'vid' => '14',
        'type' => 'article',
        'langcode' => 'is',
        'status' => '1',
        'uid' => '1',
        'title' => 'is - The thing about Firefly',
        'created' => '1478755274',
        'changed' => '1564543810',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => NULL,
        'content_translation_source' => 'is',
        'content_translation_outdated' => '0',
      ],
      5 => [
        'nid' => '6',
        'vid' => '6',
        'type' => 'forum',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'Comments are closed :-(',
        'created' => '1504715414',
        'changed' => '1504715414',
        'promote' => '0',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => '1',
        'content_translation_source' => NULL,
        'content_translation_outdated' => '0',
      ],
      6 => [
        'nid' => '7',
        'vid' => '7',
        'type' => 'forum',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'Comments are open :-)',
        'created' => '1504715432',
        'changed' => '1504715432',
        'promote' => '0',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => '1',
        'content_translation_source' => NULL,
        'content_translation_outdated' => '0',
      ],
      7 => [
        'nid' => '8',
        'vid' => '10',
        'type' => 'blog',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'The number 47',
        'created' => '1551000341',
        'changed' => '1552126247',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => NULL,
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      8 => [
        'nid' => '8',
        'vid' => '10',
        'type' => 'blog',
        'langcode' => 'fr',
        'status' => '1',
        'uid' => '1',
        'title' => 'fr - The number 47',
        'created' => '1552126296',
        'changed' => '1552126296',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => NULL,
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      9 => [
        'nid' => '8',
        'vid' => '10',
        'type' => 'blog',
        'langcode' => 'is',
        'status' => '1',
        'uid' => '1',
        'title' => 'is - The number 47',
        'created' => '1552126363',
        'changed' => '1552126363',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      10 => [
        'nid' => '11',
        'vid' => '18',
        'type' => 'et',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'Page one',
        'created' => '1568261523',
        'changed' => '1568261687',
        'promote' => '0',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => NULL,
        'content_translation_source' => '',
        'content_translation_outdated' => '0',
      ],
      11 => [
        'nid' => '11',
        'vid' => '18',
        'type' => 'et',
        'langcode' => 'fr',
        'status' => '1',
        'uid' => '1',
        'title' => 'Page one',
        'created' => '1568261721',
        'changed' => '1568261721',
        'promote' => '0',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      12 => [
        'nid' => '11',
        'vid' => '18',
        'type' => 'et',
        'langcode' => 'is',
        'status' => '1',
        'uid' => '1',
        'title' => 'Page one',
        'created' => '1568261548',
        'changed' => '1568261548',
        'promote' => '0',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => NULL,
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
    ];
  }
  
  /**
   * Provides the expected node_field_revision table.
   *
   * @return array
   *   The table.
   */
  protected function expectedNodeFieldRevisionTable() : array {
    return [
      0 => [
        'nid' => '1',
        'vid' => '1',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '2',
        'title' => 'An English Node',
        'created' => '1529615790',
        'changed' => '1529615790',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => '1',
        'content_translation_source' => NULL,
        'content_translation_outdated' => '0',
      ],
      1 => [
        'nid' => '2',
        'vid' => '2',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '2',
        'title' => 'The thing about Deep Space 9 (1st rev)',
        'created' => '1441306772',
        'changed' => '1564543588',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      2 => [
        'nid' => '2',
        'vid' => '3',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '2',
        'title' => 'The thing about Deep Space 9 (1st rev)',
        'created' => '1441306772',
        'changed' => '1564543588',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => NULL,
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      3 => [
        'nid' => '2',
        'vid' => '3',
        'langcode' => 'is',
        'status' => '1',
        'uid' => '1',
        'title' => 'is - The thing about Deep Space 9 (1st rev)',
        'created' => '1471428152',
        'changed' => '1564543677',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      4 => [
        'nid' => '4',
        'vid' => '4',
        'langcode' => 'is',
        'status' => '1',
        'uid' => '1',
        'title' => 'is - The thing about Firefly (1st rev)',
        'created' => '1478755274',
        'changed' => '1478755274',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'is',
        'content_translation_outdated' => '0',
      ],
      5 => [
        'nid' => '4',
        'vid' => '5',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'en - The thing about Firefly (1st rev)',
        'created' => '1478755314',
        'changed' => '1564543887',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'is',
        'content_translation_outdated' => '0',
      ],
      6 => [
        'nid' => '4',
        'vid' => '5',
        'langcode' => 'is',
        'status' => '1',
        'uid' => '1',
        'title' => 'is - The thing about Firefly (1st rev)',
        'created' => '1478755274',
        'changed' => '1478755274',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => NULL,
        'content_translation_source' => 'is',
        'content_translation_outdated' => '0',
      ],
      7 => [
        'nid' => '6',
        'vid' => '6',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'Comments are closed :-(',
        'created' => '1504715414',
        'changed' => '1504715414',
        'promote' => '0',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => '1',
        'content_translation_source' => NULL,
        'content_translation_outdated' => '0',
      ],
      8 => [
        'nid' => '7',
        'vid' => '7',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'Comments are open :-)',
        'created' => '1504715432',
        'changed' => '1504715432',
        'promote' => '0',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => '1',
        'content_translation_source' => NULL,
        'content_translation_outdated' => '0',
      ],
      9 => [
        'nid' => '8',
        'vid' => '8',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'The number 47',
        'created' => '1551000341',
        'changed' => '1552126247',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      10 => [
        'nid' => '8',
        'vid' => '9',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'The number 47',
        'created' => '1551000341',
        'changed' => '1552126247',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => NULL,
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      11 => [
        'nid' => '8',
        'vid' => '9',
        'langcode' => 'fr',
        'status' => '1',
        'uid' => '1',
        'title' => 'fr - The number 47',
        'created' => '1552126296',
        'changed' => '1552126296',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      12 => [
        'nid' => '8',
        'vid' => '10',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'The number 47',
        'created' => '1551000341',
        'changed' => '1552126247',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => NULL,
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      13 => [
        'nid' => '8',
        'vid' => '10',
        'langcode' => 'fr',
        'status' => '1',
        'uid' => '1',
        'title' => 'fr - The number 47',
        'created' => '1552126296',
        'changed' => '1552126296',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => NULL,
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      14 => [
        'nid' => '8',
        'vid' => '10',
        'langcode' => 'is',
        'status' => '1',
        'uid' => '1',
        'title' => 'is - The number 47',
        'created' => '1552126363',
        'changed' => '1552126363',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      15 => [
        'nid' => '2',
        'vid' => '11',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '2',
        'title' => 'The thing about Deep Space 9',
        'created' => '1441306772',
        'changed' => '1564543637',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      16 => [
        'nid' => '2',
        'vid' => '11',
        'langcode' => 'is',
        'status' => '1',
        'uid' => '1',
        'title' => 'is - The thing about Deep Space 9 (1st rev)',
        'created' => '1471428152',
        'changed' => '1564543637',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      17 => [
        'nid' => '2',
        'vid' => '12',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '2',
        'title' => 'The thing about Deep Space 9',
        'created' => '1441306772',
        'changed' => '1564543637',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => NULL,
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      18 => [
        'nid' => '2',
        'vid' => '12',
        'langcode' => 'is',
        'status' => '1',
        'uid' => '1',
        'title' => 'is - The thing about Deep Space 9',
        'created' => '1471428152',
        'changed' => '1564543706',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      19 => [
        'nid' => '4',
        'vid' => '13',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'en - The thing about Firefly (1st rev)',
        'created' => '1478755314',
        'changed' => '1564543887',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => NULL,
        'content_translation_source' => 'is',
        'content_translation_outdated' => '0',
      ],
      20 => [
        'nid' => '4',
        'vid' => '13',
        'langcode' => 'is',
        'status' => '1',
        'uid' => '1',
        'title' => 'is - The thing about Firefly',
        'created' => '1478755274',
        'changed' => '1564543810',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'is',
        'content_translation_outdated' => '0',
      ],
      21 => [
        'nid' => '4',
        'vid' => '14',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'en - The thing about Firefly',
        'created' => '1478755314',
        'changed' => '1564543929',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'is',
        'content_translation_outdated' => '0',
      ],
      22 => [
        'nid' => '4',
        'vid' => '14',
        'langcode' => 'is',
        'status' => '1',
        'uid' => '1',
        'title' => 'is - The thing about Firefly',
        'created' => '1478755274',
        'changed' => '1564543810',
        'promote' => '1',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => NULL,
        'content_translation_source' => 'is',
        'content_translation_outdated' => '0',
      ],
      23 => [
        'nid' => '11',
        'vid' => '15',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'Page one',
        'created' => '1568261523',
        'changed' => '1568261523',
        'promote' => '0',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => '1',
        'content_translation_source' => NULL,
        'content_translation_outdated' => '0',
      ],
      24 => [
        'nid' => '11',
        'vid' => '16',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'Page one',
        'created' => '1568261523',
        'changed' => '1568261523',
        'promote' => '0',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => NULL,
        'content_translation_source' => '',
        'content_translation_outdated' => '0',
      ],
      25 => [
        'nid' => '11',
        'vid' => '16',
        'langcode' => 'is',
        'status' => '1',
        'uid' => '1',
        'title' => 'Page one',
        'created' => '1568261548',
        'changed' => '1568261548',
        'promote' => '0',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      26 => [
        'nid' => '11',
        'vid' => '17',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'Page one',
        'created' => '1568261523',
        'changed' => '1568261687',
        'promote' => '0',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => NULL,
        'content_translation_source' => '',
        'content_translation_outdated' => '0',
      ],
      27 => [
        'nid' => '11',
        'vid' => '17',
        'langcode' => 'is',
        'status' => '1',
        'uid' => '1',
        'title' => 'Page one',
        'created' => '1568261548',
        'changed' => '1568261548',
        'promote' => '0',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => NULL,
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      28 => [
        'nid' => '11',
        'vid' => '18',
        'langcode' => 'en',
        'status' => '1',
        'uid' => '1',
        'title' => 'Page one',
        'created' => '1568261523',
        'changed' => '1568261687',
        'promote' => '0',
        'sticky' => '0',
        'default_langcode' => '1',
        'revision_translation_affected' => NULL,
        'content_translation_source' => '',
        'content_translation_outdated' => '0',
      ],
      29 => [
        'nid' => '11',
        'vid' => '18',
        'langcode' => 'fr',
        'status' => '1',
        'uid' => '1',
        'title' => 'Page one',
        'created' => '1568261721',
        'changed' => '1568261721',
        'promote' => '0',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => '1',
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
      30 => [
        'nid' => '11',
        'vid' => '18',
        'langcode' => 'is',
        'status' => '1',
        'uid' => '1',
        'title' => 'Page one',
        'created' => '1568261548',
        'changed' => '1568261548',
        'promote' => '0',
        'sticky' => '0',
        'default_langcode' => '0',
        'revision_translation_affected' => NULL,
        'content_translation_source' => 'en',
        'content_translation_outdated' => '0',
      ],
    ];
  }
  
  /**
   * Provides the expected node_field_revision table.
   *
   * @return array
   *   Selected properties and fields on the revision.
   */
  protected function expectedRevisionEntityData() : array {
    return [
      [
        // Node 1, revision 1, en.
0 => [
          'log' => NULL,
          'field_text_long_plain' => NULL,
          'revision_created' => '1529615790',
        ],
        // Node 2, revision 2, en.
1 => [
          'log' => 'DS9 1st rev',
          'field_text_long_plain' => 'DS9 1st rev',
          'revision_created' => '1564543588',
        ],
        // Node 2, revision 3, en.
2 => [
          'log' => 'is - DS9 1st rev',
          'field_text_long_plain' => 'DS9 1st rev',
          'revision_created' => '1564543677',
        ],
        // Node 2, revision 3, is.
3 => [
          'log' => 'is - DS9 1st rev',
          'field_text_long_plain' => 'is - DS9 1st rev',
          'revision_created' => '1564543677',
        ],
        // Node 4, revision 4, is.
4 => [
          'log' => 'is - Firefly 1st rev',
          'field_text_long_plain' => NULL,
          'revision_created' => '1478755274',
        ],
        // Node 4, revision 5, en.
5 => [
          'log' => 'Firefly 1st rev',
          'field_text_long_plain' => NULL,
          'revision_created' => '1564543887',
        ],
        // Node 4, revision 5, is.
6 => [
          'log' => 'Firefly 1st rev',
          'field_text_long_plain' => NULL,
          'revision_created' => '1564543887',
        ],
        // Node 6, revision 6, en.
7 => [
          'log' => NULL,
          'field_text_long_plain' => NULL,
          'revision_created' => '1504715414',
        ],
        // Node 7, revision 7, en.
8 => [
          'log' => NULL,
          'field_text_long_plain' => NULL,
          'revision_created' => '1504715432',
        ],
        // Node 8, revision 8, en.
9 => [
          'log' => NULL,
          'field_text_long_plain' => NULL,
          'revision_created' => '1552126247',
        ],
        // Node 8, revision 9, en.
10 => [
          'log' => NULL,
          'field_text_long_plain' => NULL,
          'revision_created' => '1552126296',
        ],
        // Node 8, revision 9, fr.
11 => [
          'log' => NULL,
          'field_text_long_plain' => NULL,
          'revision_created' => '1552126296',
        ],
        // Node 8, revision 10, en.
12 => [
          'log' => NULL,
          'field_text_long_plain' => NULL,
          'revision_created' => '1552126363',
        ],
        // Node 8, revision 10, fr.
13 => [
          'log' => NULL,
          'field_text_long_plain' => NULL,
          'revision_created' => '1552126363',
        ],
        // Node 8, revision 10, is.
14 => [
          'log' => NULL,
          'field_text_long_plain' => NULL,
          'revision_created' => '1552126363',
        ],
        // Node 2, revision 11, en.
15 => [
          'log' => 'DS9 2nd rev',
          'field_text_long_plain' => NULL,
          'revision_created' => '1564543637',
        ],
        // Node 2, revision 11, is.
16 => [
          'log' => 'DS9 2nd rev',
          'field_text_long_plain' => NULL,
          'revision_created' => '1564543637',
        ],
        // Node 2, revision 12, en.
17 => [
          'log' => 'is - DS9 2nd rev',
          'field_text_long_plain' => NULL,
          'revision_created' => '1564543706',
        ],
        // Node 2, revision 12, is.
18 => [
          'log' => 'is - DS9 2nd rev',
          'field_text_long_plain' => NULL,
          'revision_created' => '1564543706',
        ],
        // Node 4, revision 13, en.
19 => [
          'log' => 'is - Firefly 2nd rev',
          'field_text_long_plain' => NULL,
          'revision_created' => '1564543810',
        ],
        // Node 4, revision 13, is.
20 => [
          'log' => 'is - Firefly 2nd rev',
          'field_text_long_plain' => NULL,
          'revision_created' => '1564543810',
        ],
        // Node 4, revision 14, en.
21 => [
          'log' => 'Firefly 2nd rev',
          'field_text_long_plain' => NULL,
          'revision_created' => '1564543929',
        ],
        // Node 4, revision 14, is.
22 => [
          'log' => 'Firefly 2nd rev',
          'field_text_long_plain' => NULL,
          'revision_created' => '1564543929',
        ],
        // Node 11, revision 15, en.
23 => [
          'log' => NULL,
          'body' => '1st',
          'field_tree' => 'lancewood',
          'revision_created' => '1568261523',
        ],
        // Node 11, revision 16, en.
24 => [
          'log' => NULL,
          'body' => '1st',
          'field_tree' => 'lancewood',
          'revision_created' => '1568261548',
        ],
        // Node 11, revision 16, is.
25 => [
          'log' => NULL,
          'body' => '1st',
          'field_tree' => 'is - lancewood',
          'revision_created' => '1568261548',
        ],
        // Node 11, revision 17, en.
26 => [
          'log' => '2nd',
          'body' => '2nd',
          'field_tree' => 'lancewood',
          'revision_created' => '1568261548',
        ],
        // Node 11, revision 17, is.
27 => [
          'log' => '2nd',
          'body' => '2nd',
          'field_tree' => 'is - lancewood',
          'revision_created' => '1568261548',
        ],
        // Node 11, revision 18, en.
28 => [
          'log' => NULL,
          'body' => '2nd',
          'field_tree' => 'lancewood',
          'revision_created' => '1568261548',
        ],
        // Node 11, revision 18, f5.
29 => [
          'log' => NULL,
          'body' => '2nd',
          'field_tree' => 'fr - lancewood',
          'revision_created' => '1568261548',
        ],
        // Node 11, revision 18, is.
30 => [
          'log' => NULL,
          'body' => '2nd',
          'field_tree' => 'is - lancewood',
          'revision_created' => '1568261548',
        ],
      ],
    ];
  }

}