Exemplos de ActiveCollab\DatabaseConnection Connection::rollback em PHP

Exemplo n.º 1

Arquivo: TransactionsTest.php Projeto: activecollab/databaseconnection

 /**
  * Test rollback.
  */
 public function testRollback()
 {
     $this->assertEquals(3, $this->connection->executeFirstCell('SELECT COUNT(`id`) AS "row_count" FROM `writers`'));
     $this->connection->beginWork();
     $this->connection->execute('INSERT INTO `writers` (`name`, `birthday`) VALUES (?, ?)', 'Anton Chekhov', new DateTime('1860-01-29'));
     $this->connection->rollback();
     $this->assertEquals(3, $this->connection->executeFirstCell('SELECT COUNT(`id`) AS "row_count" FROM `writers`'));
 }