function SchemaTest::testChangePrimaryKeyToSerial

Tests converting an int to a serial when the int column has data.

File

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

Class

SchemaTest

Tests table creation and modification via the schema API.

Namespace

Code

public function testChangePrimaryKeyToSerial() {
  // Test making an invalid field the primary key of the table upon creation.
  $table_name = 'test_table';
  $table_spec = [
    'fields' => [
      'test_field' => [
        'type' => 'int',
        'not null' => TRUE,
      ],
      'test_field_string' => [
        'type' => 'varchar',
        'length' => 20,
      ],
    ],
    'primary key' => [
      'test_field',
    ],
  ];
  $this->schema
    ->createTable($table_name, $table_spec);
  if ($this->connection
    ->databaseType() !== 'sqlite') {
    try {
      $this->connection
        ->insert($table_name)
        ->fields([
        'test_field_string' => 'test',
      ])
        ->execute();
      $this->fail('Expected IntegrityConstraintViolationException not thrown');
    } catch (IntegrityConstraintViolationException $e) {
    }
  }
  // @todo https://www.drupal.org/project/drupal/issues/3222127 Change the
  //   first item to 0 to test changing a field with 0 to a serial.
  // Create 8 rows in the table. Note that the 5 value is deliberately
  // omitted.
  foreach ([
    1,
    2,
    3,
    4,
    6,
    7,
    8,
    9,
  ] as $value) {
    $this->connection
      ->insert($table_name)
      ->fields([
      'test_field' => $value,
    ])
      ->execute();
  }
  $this->schema
    ->changeField($table_name, 'test_field', 'test_field', [
    'type' => 'serial',
    'not null' => TRUE,
  ]);
  $data = $this->connection
    ->select($table_name)
    ->fields($table_name, [
    'test_field',
  ])
    ->execute()
    ->fetchCol();
  $this->assertEquals([
    1,
    2,
    3,
    4,
    6,
    7,
    8,
    9,
  ], array_values($data));
  try {
    $this->connection
      ->insert($table_name)
      ->fields([
      'test_field' => 1,
    ])
      ->execute();
    $this->fail('Expected IntegrityConstraintViolationException not thrown');
  } catch (IntegrityConstraintViolationException $e) {
  }
  // Ensure auto numbering now works.
  $id = $this->connection
    ->insert($table_name)
    ->fields([
    'test_field_string' => 'test',
  ])
    ->execute();
  $this->assertEquals(10, $id);
}