function TransactionTest::testTransactionWithDdlStatement
Same name in other branches
- 8.9.x core/tests/Drupal/KernelTests/Core/Database/TransactionTest.php \Drupal\KernelTests\Core\Database\TransactionTest::testTransactionWithDdlStatement()
Tests the compatibility of transactions with DDL statements.
File
-
core/
tests/ Drupal/ KernelTests/ Core/ Database/ TransactionTest.php, line 189
Class
- TransactionTest
- Tests the transaction abstraction system.
Namespace
Drupal\KernelTests\Core\DatabaseCode
public function testTransactionWithDdlStatement() {
// First, test that a commit works normally, even with DDL statements.
$transaction = $this->connection
->startTransaction();
$this->insertRow('row');
$this->executeDDLStatement();
unset($transaction);
$this->assertRowPresent('row');
// Even in different order.
$this->cleanUp();
$transaction = $this->connection
->startTransaction();
$this->executeDDLStatement();
$this->insertRow('row');
unset($transaction);
$this->assertRowPresent('row');
// Even with stacking.
$this->cleanUp();
$transaction = $this->connection
->startTransaction();
$transaction2 = $this->connection
->startTransaction();
$this->executeDDLStatement();
unset($transaction2);
$transaction3 = $this->connection
->startTransaction();
$this->insertRow('row');
unset($transaction3);
unset($transaction);
$this->assertRowPresent('row');
// A transaction after a DDL statement should still work the same.
$this->cleanUp();
$transaction = $this->connection
->startTransaction();
$transaction2 = $this->connection
->startTransaction();
$this->executeDDLStatement();
unset($transaction2);
$transaction3 = $this->connection
->startTransaction();
$this->insertRow('row');
$transaction3->rollBack();
unset($transaction3);
unset($transaction);
$this->assertRowAbsent('row');
// The behavior of a rollback depends on the type of database server.
if ($this->connection
->supportsTransactionalDDL()) {
// For database servers that support transactional DDL, a rollback
// of a transaction including DDL statements should be possible.
$this->cleanUp();
$transaction = $this->connection
->startTransaction();
$this->insertRow('row');
$this->executeDDLStatement();
$transaction->rollBack();
unset($transaction);
$this->assertRowAbsent('row');
// Including with stacking.
$this->cleanUp();
$transaction = $this->connection
->startTransaction();
$transaction2 = $this->connection
->startTransaction();
$this->executeDDLStatement();
unset($transaction2);
$transaction3 = $this->connection
->startTransaction();
$this->insertRow('row');
unset($transaction3);
$transaction->rollBack();
unset($transaction);
$this->assertRowAbsent('row');
}
else {
// For database servers that do not support transactional DDL,
// the DDL statement should commit the transaction stack.
$this->cleanUp();
$transaction = $this->connection
->startTransaction();
$this->insertRow('row');
$this->executeDDLStatement();
try {
// Rollback the outer transaction.
$transaction->rollBack();
// @see \Drupal\mysql\Driver\Database\mysql\Connection::rollBack()
if (PHP_VERSION_ID >= 80000) {
$this->fail('Rolling back a transaction containing DDL should produce a warning.');
}
} catch (Warning $warning) {
$this->assertSame('Rollback attempted when there is no active transaction. This can cause data integrity issues.', $warning->getMessage());
}
unset($transaction);
$this->assertRowPresent('row');
}
}
Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.