class.ilGlobalCacheQueryWrapper.php

Go to the documentation of this file.

<?php
require_once('./Services/GlobalCache/classes/class.ilGlobalCache.php');

class ilGlobalCacheQueryWrapper
{
    const FETCH_TYPE_ASSOC = 1;
    const FETCH_TYPE_OBJECT = 2;
    const MODE_SINGLE = 1;
    const MODE_MULTIPLE = 2;
    protected $query = '';
    protected $cache_key = '';
    protected $fetch_type = self::FETCH_TYPE_OBJECT;
    protected $mode = self::MODE_SINGLE;


    public function __construct($cache_key, $query, $fetch_type = self::FETCH_TYPE_OBJECT, $mode = self::MODE_SINGLE)
    {
        $this->cache_key = $cache_key;
        $this->fetch_type = $fetch_type;
        $this->mode = $mode;
        $this->query = $query;
    }


    public function get()
    {
        $ilGlobalCache = ilGlobalCache::getInstance();
        if ($ilGlobalCache->isActive()) {
            $rec = $ilGlobalCache->get($this->cache_key);
            if (!$rec) {
                $rec = $this->getFromDb();
                $ilGlobalCache->set($this->cache_key, $rec, 600);
            }
        } else {
            $rec = $this->getFromDb();
        }

        return $rec;
    }


    protected function getFromDb()
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        $return = array();
        $res = $ilDB->query($this->query);
        switch ($this->getFetchType()) {
            case self::FETCH_TYPE_OBJECT:
                while ($rec = $ilDB->fetchObject($res)) {
                    $return[] = $rec;
                }
                break;
            case self::FETCH_TYPE_ASSOC:
                while ($rec = $ilDB->fetchAssoc($res)) {
                    $return[] = $rec;
                }
                break;
        }

        if ($this->getMode() == self::MODE_SINGLE) {
            return $return[0];
        } else {
            return $return;
        }
    }


    public function setFetchType($fetch_type)
    {
        $this->fetch_type = $fetch_type;
    }


    public function getFetchType()
    {
        return $this->fetch_type;
    }


    public function setMode($mode)
    {
        $this->mode = $mode;
    }


    public function getMode()
    {
        return $this->mode;
    }
}