public function testCache()
{
$_GET['testCache'] = 1;
// no-cache
$sql = "SELECT * FROM " . $this->tableName;
$result = $this->db->execSQL($sql, false);
if (count($result) > 0) {
$return = true;
} else {
$return = false;
}
self::assertEquals(true, $return);
// set cache
$sql = "SELECT * FROM " . $this->tableName;
$result = $this->db->execSQL($sql, true);
if (count($result) > 0) {
$return = true;
} else {
$return = false;
}
self::assertEquals(true, $return);
$queryCount = $this->db->query_count;
// use cache
$sql = "SELECT * FROM " . $this->tableName;
$result = $this->db->execSQL($sql, true);
if (count($result) > 0) {
$return = true;
} else {
$return = false;
}
self::assertEquals(true, $return);
// check cache
self::assertEquals($queryCount, $this->db->query_count);
}
