function BatchBidSerialUpdateTest::testUpdate

Tests the change of the {batch} table [bid] field to serial.

File

core/modules/system/tests/src/Functional/Update/BatchBidSerialUpdateTest.php, line 30

Class

BatchBidSerialUpdateTest

Tests system_update_10101() upgrade path.

Namespace

Code

public function testUpdate() : void {
    
    /** @var \Drupal\Core\Database\Connection $connection */
    $connection = \Drupal::service('database');
    // Before the update, inserting a record in the {batch} table without
    // passing a value for [bid] should fail, with the exception of the SQLite
    // database where a NOT NULL integer field that is the primary key is set
    // to automatic increment anyway.
    //
    // @see https://www.drupal.org/project/drupal/issues/2665216#comment-14885361
    try {
        $connection->insert('batch')
            ->fields([
            'timestamp' => \Drupal::time()->getRequestTime(),
            'token' => '',
            'batch' => NULL,
        ])
            ->execute();
        if ($connection->databaseType() !== 'sqlite') {
            $this->fail('Insert to {batch} without bid should have failed, but it did not');
        }
    } catch (\Exception $e) {
        $this->assertInstanceOf(IntegrityConstraintViolationException::class, $e);
    }
    $this->runUpdates();
    // $bid should be higher than one, since the update process would have
    // executed a batch already. We look at the records inserted to determine
    // the value of $bid, instead of relying on the value returned by the
    // INSERT, because in PostgreSql the test connection gets confused by the
    // ::changeField() executed in the SUT and keeps returning 0 instead of
    // lastId as result of the insert.
    $connection->insert('batch')
        ->fields([
        'timestamp' => \Drupal::time()->getRequestTime(),
        'token' => '',
        'batch' => NULL,
    ])
        ->execute();
    $bid = (int) $connection->query('SELECT MAX([bid]) FROM {batch}')
        ->fetchField();
    $this->assertGreaterThan(1, $bid);
    $connection->insert('batch')
        ->fields([
        'timestamp' => \Drupal::time()->getRequestTime(),
        'token' => '',
        'batch' => NULL,
    ])
        ->execute();
    $this->assertEquals($bid + 1, (int) $connection->query('SELECT MAX([bid]) FROM {batch}')
        ->fetchField());
}