/**
* @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']);
}
