FM / caching

/var/www/vhosts/nabawater/vendor/yiisoft/yii2/caching/

/var/www/vhosts/nabawater/vendor/yiisoft/yii2/caching

Name	Size	Mode	Actions
migrations/	-	0755	rm
ApcCache.php	6539	0644	edit dl rm
ArrayCache.php	2359	0644	edit dl rm
Cache.php	26006	0644	edit dl rm
CacheInterface.php	9564	0644	edit dl rm
ChainedDependency.php	2527	0644	edit dl rm
DbCache.php	10498	0644	edit dl rm
DbDependency.php	2274	0644	edit dl rm
DbQueryDependency.php	3738	0644	edit dl rm
Dependency.php	4243	0644	edit dl rm
DummyCache.php	2915	0644	edit dl rm
ExpressionDependency.php	1950	0644	edit dl rm
FileCache.php	10871	0644	edit dl rm
FileDependency.php	1605	0644	edit dl rm
MemCache.php	13901	0644	edit dl rm
MemCacheServer.php	1966	0644	edit dl rm
TagDependency.php	3601	0644	edit dl rm
WinCache.php	5464	0644	edit dl rm
XCache.php	4322	0644	edit dl rm
ZendDataCache.php	3371	0644	edit dl rm

Edit: /var/www/vhosts/nabawater/vendor/yiisoft/yii2/caching/DbDependency.php (2274B)

<?php
/**
 * @link http://www.yiiframework.com/
 * @copyright Copyright (c) 2008 Yii Software LLC
 * @license http://www.yiiframework.com/license/
 */

namespace yii\caching;

use Yii;
use yii\base\InvalidConfigException;
use yii\db\Connection;
use yii\di\Instance;

/**
 * DbDependency represents a dependency based on the query result of a SQL statement.
 *
 * If the query result changes, the dependency is considered as changed.
 * The query is specified via the [[sql]] property.
 *
 * For more details and usage information on Cache, see the [guide article on caching](guide:caching-overview).
 *
 * @author Qiang Xue <qiang.xue@gmail.com>
 * @since 2.0
 */
class DbDependency extends Dependency
{
    /**
     * @var string the application component ID of the DB connection.
     */
    public $db = 'db';
    /**
     * @var string the SQL query whose result is used to determine if the dependency has been changed.
     * Only the first row of the query result will be used.
     */
    public $sql;
    /**
     * @var array the parameters (name => value) to be bound to the SQL statement specified by [[sql]].
     */
    public $params = [];

/**
     * Generates the data needed to determine if dependency has been changed.
     * This method returns the value of the global state.
     * @param CacheInterface $cache the cache component that is currently evaluating this dependency
     * @return mixed the data needed to determine if dependency has been changed.
     * @throws InvalidConfigException if [[db]] is not a valid application component ID
     */
    protected function generateDependencyData($cache)
    {
        /* @var $db Connection */
        $db = Instance::ensure($this->db, Connection::className());
        if ($this->sql === null) {
            throw new InvalidConfigException('DbDependency::sql must be set.');
        }

if ($db->enableQueryCache) {
            // temporarily disable and re-enable query caching
            $db->enableQueryCache = false;
            $result = $db->createCommand($this->sql, $this->params)->queryOne();
            $db->enableQueryCache = true;
        } else {
            $result = $db->createCommand($this->sql, $this->params)->queryOne();
        }

return $result;
    }
}

cmd: