| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111 | 
							- <?php
 
- /**
 
-  * @link http://www.yiiframework.com/
 
-  * @copyright Copyright (c) 2008 Yii Software LLC
 
-  * @license http://www.yiiframework.com/license/
 
-  */
 
- namespace yii\caching;
 
- use yii\base\InvalidConfigException;
 
- use yii\db\QueryInterface;
 
- use yii\di\Instance;
 
- /**
 
-  * DbQueryDependency represents a dependency based on the query result of an [[QueryInterface]] instance.
 
-  *
 
-  * If the query result changes, the dependency is considered as changed.
 
-  * The query is specified via the [[query]] property.
 
-  *
 
-  * Object of any class which matches [[QueryInterface]] can be used, so this dependency can be used not only
 
-  * with regular relational databases but with MongoDB, Redis and so on as well.
 
-  *
 
-  * For more details and usage information on Cache, see the [guide article on caching](guide:caching-overview).
 
-  *
 
-  * @see QueryInterface
 
-  *
 
-  * @author Paul Klimov <klimov.paul@gmail.com>
 
-  * @since 2.0.12
 
-  */
 
- class DbQueryDependency extends Dependency
 
- {
 
-     /**
 
-      * @var string|array|object the application component ID of the database connection, connection object or
 
-      * its array configuration.
 
-      * This field can be left blank, allowing query to determine connection automatically.
 
-      */
 
-     public $db;
 
-     /**
 
-      * @var QueryInterface the query which result is used to determine if the dependency has been changed.
 
-      * Actual query method to be invoked is determined by [[method]].
 
-      */
 
-     public $query;
 
-     /**
 
-      * @var string|callable method which should be invoked in over the [[query]] object.
 
-      *
 
-      * If specified as a string an own query method with such name will be invoked, passing [[db]] value as its
 
-      * first argument. For example: `exists`, `all`.
 
-      *
 
-      * This field can be specified as a PHP callback of following signature:
 
-      *
 
-      * ```php
 
-      * function (QueryInterface $query, mixed $db) {
 
-      *     //return mixed;
 
-      * }
 
-      * ```
 
-      *
 
-      * If not set - [[QueryInterface::one()]] will be used.
 
-      */
 
-     public $method;
 
-     /**
 
-      * Generates the data needed to determine if dependency is changed.
 
-      *
 
-      * This method returns the query result.
 
-      * @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 on invalid configuration.
 
-      */
 
-     protected function generateDependencyData($cache)
 
-     {
 
-         $db = $this->db;
 
-         if ($db !== null) {
 
-             $db = Instance::ensure($db);
 
-         }
 
-         if (!$this->query instanceof QueryInterface) {
 
-             throw new InvalidConfigException('"' . get_class($this) . '::$query" should be an instance of "yii\db\QueryInterface".');
 
-         }
 
-         if (!empty($db->enableQueryCache)) {
 
-             // temporarily disable and re-enable query caching
 
-             $originEnableQueryCache = $db->enableQueryCache;
 
-             $db->enableQueryCache = false;
 
-             $result = $this->executeQuery($this->query, $db);
 
-             $db->enableQueryCache = $originEnableQueryCache;
 
-         } else {
 
-             $result = $this->executeQuery($this->query, $db);
 
-         }
 
-         return $result;
 
-     }
 
-     /**
 
-      * Executes the query according to [[method]] specification.
 
-      * @param QueryInterface $query query to be executed.
 
-      * @param mixed $db connection.
 
-      * @return mixed query result.
 
-      */
 
-     private function executeQuery($query, $db)
 
-     {
 
-         if ($this->method === null) {
 
-             return $query->one($db);
 
-         }
 
-         if (is_string($this->method)) {
 
-             return call_user_func([$query, $this->method], $db);
 
-         }
 
-         return call_user_func($this->method, $query, $db);
 
-     }
 
- }
 
 
  |