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]);
}
