CloudControl\Cms\storage\Cache

Complexity

Total Complexity

14

Size/Duplication

Total Lines	138
Duplicated Lines	20.29 %

Coupling/Cohesion

Components	2
Dependencies	1

Importance

Changes	3
Bugs	1	Features	1

8 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	getInstance()	0	7	2
A	getCacheForPath()	7	19	2
A	clearCache()	7	16	2
A	setStoragePath()	0	4	1
A	getDbInstance()	7	7	2
A	init()	0	8	1
B	setCacheForPath()	7	25	3

<?php
/**
 * Created by jensk on 25-10-2017.
 */

namespace CloudControl\Cms\storage;


use CloudControl\Cms\components\CmsComponent;

class Cache

Since you have declared the constructor as private, maybe you should also declare the class as final.

{
    /**
     * @var Cache
     */
    private static $instance;

    /**
     * @var string
     */
    protected $storagePath;
    /**
     * @var \PDO
     */
    protected $dbHandle;

    private function __construct()
    {
        // Singleton, so private constructor
    }

    /**
     * @return Cache
     */
    public static function getInstance()
    {
        if (!self::$instance instanceof Cache) {
            self::$instance = new Cache();
        }
        return self::$instance;
    }

    /**
     * @param $path
     * @return \stdClass
     */
    public function getCacheForPath($path)
    {
        $dbInstace = $this->getDbInstance();
        $sql = '
            SELECT *
              FROM `cache`
             WHERE `path` = :path
             LIMIT 1
        ';
        $stmt = $dbInstace->prepare($sql);
        $stmt->bindParam(':path', $path);
        if ($stmt->execute()) {

This code seems to be duplicated across your project.

            return $stmt->fetch(\PDO::FETCH_OBJ);
        } else {
            $error = $stmt->errorInfo();
            $errorMsg = $error[2];
            throw new \RuntimeException('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>');
        }
    }

    /**
     * Clears all cache
     */
    public function clearCache()
    {
        $dbInstace = $this->getDbInstance();
        $sql = '
            DELETE FROM `cache`;
            VACUUM;
        ';
        $stmt = $dbInstace->prepare($sql);
        if ($stmt->execute()) {

This code seems to be duplicated across your project.

            return;
        } else {
            $error = $stmt->errorInfo();
            $errorMsg = $error[2];
            throw new \RuntimeException('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>');
        }
    }

    /**
     * @param $storagePath
     */
    public function setStoragePath($storagePath)
    {
        $this->storagePath = $storagePath;
    }

    /**
     * @return \PDO
     */
    private function getDbInstance()

This method seems to be duplicated in your project.

    {
        if ($this->dbHandle === null) {
            $this->dbHandle = new \PDO('sqlite:' . $this->storagePath . DIRECTORY_SEPARATOR . 'cache.db');
        }
        return $this->dbHandle;
    }

    /**
     * @param $baseCacheSqlPath
     */
    public function init($baseCacheSqlPath)
    {
        $realBaseCacheSqlPath = realpath($baseCacheSqlPath);

        $db = $this->getDbInstance();
        $sql = file_get_contents($realBaseCacheSqlPath);
        $db->exec($sql);
    }

    /**
     * @param $requestUri
     * @param $renderedContent
     */
    public function setCacheForPath($requestUri, $renderedContent)
    {
        // Dont cache if youre logged in, or you might cache the frontend editor buttons
        if (CmsComponent::isCmsLoggedIn()) {
            return;
        }
        $dbInstace = $this->getDbInstance();
        $sql = '
            INSERT OR REPLACE INTO `cache` (path, creationStamp, contents)
                 VALUES (:path, :creationStamp, :contents);
        ';
        $contents = \sanitize_output($renderedContent);
        $creationStamp = time();
        $stmt = $dbInstace->prepare($sql);
        $stmt->bindParam(':path', $requestUri);
        $stmt->bindParam(':creationStamp', $creationStamp);
        $stmt->bindParam(':contents', $contents);
        if ($stmt->execute()) {

This code seems to be duplicated across your project.

            return;
        } else {
            $error = $stmt->errorInfo();
            $errorMsg = $error[2];
            throw new \RuntimeException('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>');
        }
    }

}