MigrateNodeCompleteTest.php

<?php

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

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;

/**
 * Test class for a complete node migration for Drupal 7.
 *
 * @group migrate_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(\PDO::FETCH_ASSOC));
        $this->assertEquals($this->expectedNodeFieldDataTable(), $db->select('node_field_data', 'nr')
            ->fields('nr')
            ->orderBy('nid')
            ->orderBy('vid')
            ->orderBy('langcode')
            ->execute()
            ->fetchAll(\PDO::FETCH_ASSOC));
        // 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 [
            $revision_data = [
                // 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',
                ],
            ],
        ];
    }

}