sqlite_cache.php

Ir a la documentación de este archivo.

<?php
class SqliteCache extends Cache
{

    protected $_db = null;

    public function __construct()
    {
        $this->_db = sqlite_open(APP_PATH . 'temp/cache.db');
        $result = sqlite_query($this->_db, "SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND tbl_name='cache' ");
        $count = sqlite_fetch_single($result);

        if (!$count) {
            sqlite_exec($this->_db, ' CREATE TABLE cache (id TEXT, "group" TEXT, value TEXT, lifetime TEXT) ');
        }

        return $this->_db;
    }

    public function get($id, $group='default')
    {
        $this->_id = $id;
        $this->_group = $group;

        $id = addslashes($id);
        $group = addslashes($group);

        $id = addslashes($id);
        $group = addslashes($group);
        $lifetime = time();

        $result = sqlite_query($this->_db, " SELECT value FROM cache WHERE id='$id' AND \"group\"='$group' AND lifetime>'$lifetime' OR lifetime='undefined' ");
        return sqlite_fetch_single($result);
    }

    public function save($value, $lifetime=null, $id=false, $group='default')
    {
        if (!$id) {
            $id = $this->_id;
            $group = $this->_group;
        }

        if ($lifetime) {
            $lifetime = strtotime($lifetime);
        } else {
            $lifetime = 'undefined';
        }

        $id = addslashes($id);
        $group = addslashes($group);
        $value = addslashes($value);

        $result = sqlite_query($this->_db, " SELECT COUNT(*) FROM cache WHERE id='$id' AND \"group\"='$group' ");
        $count = sqlite_fetch_single($result);


        // Ya existe el elemento cacheado
        if ($count) {
            return sqlite_exec($this->_db, " UPDATE cache SET value='$value', lifetime='$lifetime' WHERE id='$id' AND \"group\"='$group' ");
        }

        return sqlite_exec($this->_db, " INSERT INTO cache (id, \"group\", value, lifetime) VALUES ('$id','$group','$value','$lifetime') ");
    }

    public function clean($group=false)
    {
        if ($group) {
            $group = addslashes($group);
            return sqlite_exec($this->_db, " DELETE FROM cache WHERE \"group\"='$group' ");
        }
        return sqlite_exec($this->_db, " DELETE FROM cache ");
    }

    public function remove($id, $group='default')
    {
        $id = addslashes($id);
        $group = addslashes($group);

        return sqlite_exec($this->_db, " DELETE FROM cache WHERE id='$id' AND \"group\"='$group' ");
    }

}