function BatchBidSerialUpdateTest::testUpdate
Same name in other branches
- 11.x core/modules/system/tests/src/Functional/Update/BatchBidSerialUpdateTest.php \Drupal\Tests\system\Functional\Update\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
Drupal\Tests\system\Functional\UpdateCode
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());
}
Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.