public function SchemaTest::testSchemaAddFieldDefaultInitial in Drupal 9

Same name and namespace in other branches

1. 8 core/tests/Drupal/KernelTests/Core/Database/SchemaTest.php \Drupal\KernelTests\Core\Database\SchemaTest::testSchemaAddFieldDefaultInitial()

Tests adding columns to an existing table with default and initial value.

File

core/tests/Drupal/KernelTests/Core/Database/SchemaTest.php, line 590

Class

SchemaTest

Tests table creation and modification via the schema API.

Namespace

Drupal\KernelTests\Core\Database

Code

public function testSchemaAddFieldDefaultInitial() {

  // Test varchar types.
  foreach ([
    1,
    32,
    128,
    256,
    512,
  ] as $length) {
    $base_field_spec = [
      'type' => 'varchar',
      'length' => $length,
    ];
    $variations = [
      [
        'not null' => FALSE,
      ],
      [
        'not null' => FALSE,
        'default' => '7',
      ],
      [
        'not null' => FALSE,
        'default' => substr('"thing"', 0, $length),
      ],
      [
        'not null' => FALSE,
        'default' => substr("\"'hing", 0, $length),
      ],
      [
        'not null' => TRUE,
        'initial' => 'd',
      ],
      [
        'not null' => FALSE,
        'default' => NULL,
      ],
      [
        'not null' => TRUE,
        'initial' => 'd',
        'default' => '7',
      ],
    ];
    foreach ($variations as $variation) {
      $field_spec = $variation + $base_field_spec;
      $this
        ->assertFieldAdditionRemoval($field_spec);
    }
  }

  // Test int and float types.
  foreach ([
    'int',
    'float',
  ] as $type) {
    foreach ([
      'tiny',
      'small',
      'medium',
      'normal',
      'big',
    ] as $size) {
      $base_field_spec = [
        'type' => $type,
        'size' => $size,
      ];
      $variations = [
        [
          'not null' => FALSE,
        ],
        [
          'not null' => FALSE,
          'default' => 7,
        ],
        [
          'not null' => TRUE,
          'initial' => 1,
        ],
        [
          'not null' => TRUE,
          'initial' => 1,
          'default' => 7,
        ],
        [
          'not null' => TRUE,
          'initial_from_field' => 'serial_column',
        ],
        [
          'not null' => TRUE,
          'initial_from_field' => 'test_nullable_field',
          'initial' => 100,
        ],
      ];
      foreach ($variations as $variation) {
        $field_spec = $variation + $base_field_spec;
        $this
          ->assertFieldAdditionRemoval($field_spec);
      }
    }
  }

  // Test numeric types.
  foreach ([
    1,
    5,
    10,
    40,
    65,
  ] as $precision) {
    foreach ([
      0,
      2,
      10,
      30,
    ] as $scale) {

      // Skip combinations where precision is smaller than scale.
      if ($precision <= $scale) {
        continue;
      }
      $base_field_spec = [
        'type' => 'numeric',
        'scale' => $scale,
        'precision' => $precision,
      ];
      $variations = [
        [
          'not null' => FALSE,
        ],
        [
          'not null' => FALSE,
          'default' => 7,
        ],
        [
          'not null' => TRUE,
          'initial' => 1,
        ],
        [
          'not null' => TRUE,
          'initial' => 1,
          'default' => 7,
        ],
        [
          'not null' => TRUE,
          'initial_from_field' => 'serial_column',
        ],
      ];
      foreach ($variations as $variation) {
        $field_spec = $variation + $base_field_spec;
        $this
          ->assertFieldAdditionRemoval($field_spec);
      }
    }
  }
}