/** * @test */ public function transactionCommit() { $updateSql = "UPDATE types SET title = 'transaction-test' WHERE id = 1"; $selectSql = "SELECT title FROM types WHERE id = 1"; $this->databaseConnection->startTransaction(); $this->databaseConnection->query($updateSql); $secondTestDatabaseConnection = Mysql\DataSource::getInstance($this->databaseConnectionData2); $record = $secondTestDatabaseConnection->getRow($selectSql); $this->assertEquals('none', $record['title']); $this->databaseConnection->commitTransaction(); $record = $secondTestDatabaseConnection->getRow($selectSql); $this->assertEquals('transaction-test', $record['title']); }