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