public function testTransactionWrapperFail()
{
$this->db->query("INSERT INTO test (id, code, price) VALUES (3004, '1', 1)");
$res = $this->db->transaction(function () {
$this->db->query("INSERT INTO test (id, code, price) VALUES (3004, '1', 1)");
});
$this->assertEquals(false, $res);
}
public function testExceptionData()
{
$query = '';
try {
$this->db->query("SELECTT 1");
} catch (Exception $e) {
$code = $e->getCode();
$message = $e->getMessage();
$query = $e->getQuery();
}
$this->assertEquals(1064, $code);
$this->assertEquals('Error 1064: "You have an error in your SQL syntax; check the manual that corresponds ' . 'to your MySQL server version for the right syntax to use near ' . '\'SELECTT 1\' at line 1"; Query = "SELECTT 1"', $message);
$this->assertEquals('SELECTT 1', $query);
}
public function testFetchRow()
{
$res = $this->db->query('SELECT code, name FROM test WHERE id = 1')->fetchRow();
$expect = ['001', 'Cup'];
$this->assertEquals($expect, $res);
}
public function tearDown()
{
$this->db->query('DROP TABLE IF EXISTS `test`');
$this->db->query('DROP TABLE IF EXISTS `test_no_ai`');
$this->db->query('DROP TABLE IF EXISTS `test``_ident`');
}
