chillerlan / php-database

		return hash('sha256', $sql.serialize($values));

	}

	public function rawCached(string $sql, string $index = null, bool $assoc = true){

		$result = $this->cacheGet($sql.$index);

		if(!$result){

			$result = $this->raw($sql, $index, $assoc);

			$this->cacheSet($sql.$index, [], $result);

		}

		return $result;

	}

	public function preparedCached(string $sql, array $values = [], string $index = null, bool $assoc = true){

		$result = $this->cacheGet($sql.$index, $values);

		return $result;

	}

	public function preparedCached(string $sql, array $values = [], string $index = null, bool $assoc = true){

		$result = $this->cacheGet($sql.$index, $values);

		if(!$result){

			$result = $this->prepared($sql, $values, $index, $assoc);

			$this->cacheSet($sql.$index, $values, $result);

		}

		return $result;

	}

}