function DriverSpecificSchemaTestBase::testChangePrimaryKeyToSerial

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

File

core/tests/Drupal/KernelTests/Core/Database/DriverSpecificSchemaTestBase.php, line 693

Class

DriverSpecificSchemaTestBase

Tests table creation and modification via the schema API.

Namespace

Code

public function testChangePrimaryKeyToSerial() : void {
  // 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);
  $this->tryInsertExpectsIntegrityConstraintViolationException($table_name);
  // @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.
  // We use a >= assertion to allow non-core drivers, that may have specific
  // strategies on automatic incrementing, to run core tests. For example,
  // Oracle will allocate a 10 id with the previous insert that was meant to
  // fail; that id will be discarded, and the insert here will get a new 11
  // id instead.
  $id = $this->connection
    ->insert($table_name)
    ->fields([
    'test_field_string' => 'test',
  ])
    ->execute();
  $this->assertGreaterThanOrEqual(10, $id);
}