public function testSetSimpleLogger() { $this->connection->setSimpleLogger(); $logger = $this->connection->getLogger(); $this->connection->executeQuery("show tables"); $exception = false; try { $this->connection->executeQuery("no sql"); } catch (MysqltcsException $e) { $exception = true; } $this->assertTrue($exception); $logA = $logger->getLogArray(); //this way to keep the php 5.3 compatibility $this->assertEquals($logA[0], "show tables"); $this->assertEquals(substr($logA[1], 0, strlen("Mysql error")), "Mysql error"); }
public function testLogger() { $db = (require __DIR__ . "/config.php"); $mysqltcs = new Mysqltcs($db['host'], $db['user'], $db['psw'], $db['db']); $mysqltcs->setSimpleLogger(); $mysqltcs->setAutocommit(false); $logA = $mysqltcs->getLogger()->getLogArray(); $this->assertEquals("autocommit set to false", $logA[count($logA) - 1]); $mysqltcs->commit(); $logA = $mysqltcs->getLogger()->getLogArray(); $this->assertEquals("commit", $logA[count($logA) - 1]); $mysqltcs->rollBack(); $logA = $mysqltcs->getLogger()->getLogArray(); $this->assertEquals("rollback", $logA[count($logA) - 1]); }