function SchemaTest::checkSequenceRenaming

Check that the ID sequence gets renamed when the table is renamed.

Parameters

string $tableName: The table to rename.

Overrides DriverSpecificSchemaTestBase::checkSequenceRenaming

File

core/modules/pgsql/tests/src/Kernel/pgsql/SchemaTest.php, line 29

Class

SchemaTest

Tests schema API for the PostgreSQL driver.

Namespace

Code

protected function checkSequenceRenaming(string $tableName) : void {
  // For PostgreSQL, we also need to check that the sequence has been renamed.
  // The initial name of the sequence has been generated automatically by
  // PostgreSQL when the table was created, however, on subsequent table
  // renames the name is generated by Drupal and can not be easily
  // re-constructed. Hence we can only check that we still have a sequence on
  // the new table name.
  $sequenceExists = (bool) $this->connection
    ->query("SELECT pg_get_serial_sequence('{" . $tableName . "}', 'id')")
    ->fetchField();
  $this->assertTrue($sequenceExists, 'Sequence was renamed.');
  // Rename the table again and repeat the check.
  $anotherTableName = strtolower($this->getRandomGenerator()
    ->name(63 - strlen($this->getDatabasePrefix())));
  $this->schema
    ->renameTable($tableName, $anotherTableName);
  $sequenceExists = (bool) $this->connection
    ->query("SELECT pg_get_serial_sequence('{" . $anotherTableName . "}', 'id')")
    ->fetchField();
  $this->assertTrue($sequenceExists, 'Sequence was renamed.');
}