class MultiCardinalitySpineTest

class MultiCardinalitySpineTest extends EntityKernelTestBase {
  
  /**
   * {@inheritdoc}
   */
  protected static $modules = [
    'language',
  ];
  
  /**
   * Creates three unlimited fields on entity_test_mulrev, two translatable.
   */
  protected function setUp() : void {
    parent::setUp();
    $this->installEntitySchema('entity_test_mulrev');
    ConfigurableLanguage::createFromLangcode('de')->save();
    foreach ([
      'a' => TRUE,
      'b' => TRUE,
      'c' => FALSE,
    ] as $name => $translatable) {
      FieldStorageConfig::create([
        'field_name' => "field_{$name}",
        'entity_type' => 'entity_test_mulrev',
        'type' => 'integer',
        'cardinality' => -1,
      ])->save();
      FieldConfig::create([
        'field_name' => "field_{$name}",
        'entity_type' => 'entity_test_mulrev',
        'bundle' => 'entity_test_mulrev',
        'translatable' => $translatable,
      ])->save();
    }
  }
  
  /**
   * Loads several multiple cardinality fields together.
   */
  public function testSpineLoad() : void {
    $entity = EntityTestMulRev::create([
      'langcode' => 'en',
      // Different counts per field would previously multiply into a cartesian
      // product of rows.
'field_a' => [
        10,
        11,
        12,
        13,
      ],
      'field_b' => [
        20,
      ],
      'field_c' => [
        30,
        31,
        32,
      ],
    ]);
    $entity->addTranslation('de', [
      'field_a' => [
        110,
        111,
      ],
      'field_b' => [
        120,
        121,
        122,
      ],
    ]);
    $entity->save();
    $id = $entity->id();
    // Introduce a sparse delta: delete the middle value of field_a directly in
    // the dedicated table, leaving deltas 0, 2, 3. The highest cardinality
    // field would not contain delta 1 as a spine.
    \Drupal::database()->delete('entity_test_mulrev__field_a')
      ->condition('entity_id', $id)
      ->condition('langcode', 'en')
      ->condition('delta', 1)
      ->execute();
    $this->container
      ->get('entity_type.manager')
      ->getStorage('entity_test_mulrev')
      ->resetCache();
    $loaded = EntityTestMulRev::load($id);
    $this->assertSame([
      '10',
      '12',
      '13',
    ], array_column($loaded->get('field_a')
      ->getValue(), 'value'));
    $this->assertSame([
      '20',
    ], array_column($loaded->get('field_b')
      ->getValue(), 'value'));
    $this->assertSame([
      '30',
      '31',
      '32',
    ], array_column($loaded->get('field_c')
      ->getValue(), 'value'));
    $de = $loaded->getTranslation('de');
    $this->assertSame([
      '110',
      '111',
    ], array_column($de->get('field_a')
      ->getValue(), 'value'));
    $this->assertSame([
      '120',
      '121',
      '122',
    ], array_column($de->get('field_b')
      ->getValue(), 'value'));
    // Non-translatable field shows the default translation values.
    $this->assertSame([
      '30',
      '31',
      '32',
    ], array_column($de->get('field_c')
      ->getValue(), 'value'));
  }

}