public function testQuery()
{
// query - true
$sql = "INSERT INTO " . $this->tableName . "\n SET\n page_template = ?,\n page_type = ?\n ";
$return = $this->db->query($sql, array(1.1, 1));
self::assertEquals(true, $return);
// query - true
$sql = "INSERT INTO " . $this->tableName . "\n SET\n page_template = ?,\n page_type = ?\n ";
$tmpDate = new DateTime();
$tmpId = $this->db->query($sql, array('dateTest', $tmpDate));
self::assertEquals(true, $tmpId);
// select - true
$result = $this->db->select($this->tableName, "page_id = {$tmpId}");
$tmpPage = $result->fetchObject();
self::assertEquals($tmpDate->format('Y-m-d H:i:s'), $tmpPage->page_type);
// select - false
$result = new Result();
$tmpPage = $result->fetch();
self::assertEquals(false, $tmpPage);
$tmpPage = $result->fetchObject();
self::assertEquals(false, $tmpPage);
$tmpPage = $result->fetchArray();
self::assertEquals(false, $tmpPage);
// query - false
$sql = "INSERT INTO " . $this->tableName . "\n SET\n page_template = ?,\n page_type = ?\n ";
$return = $this->db->query($sql, array(true, array('test')));
// array('test') => null
self::assertEquals(false, $return);
// query - false
$sql = "INSERT INTO " . $this->tableName . "\n SET\n page_template_lall = ?,\n page_type = ?\n ";
$return = $this->db->query($sql, array('tpl_test_new15', 1));
self::assertEquals(false, $return);
// query - false
$return = $this->db->query('', array('tpl_test_new15', 1));
self::assertEquals(false, $return);
}
