yii\db\Connection::cache PHP 메소드

Connection 1 문서 파일 보기 프로젝트 열기: yiisoft/yii2

cache() 공개 메소드

When query caching is enabled ([[enableQueryCache]] is true and [[queryCache]] refers to a valid cache), queries performed within the callable will be cached and their results will be fetched from cache if available. For example, php The customer will be fetched from cache if available. If not, the query will be made against DB and cached for use next time. $customer = $db->cache(function (Connection $db) { return $db->createCommand('SELECT * FROM customer WHERE id=1')->queryOne(); }); Note that query cache is only meaningful for queries that return results. For queries performed with [[Command::execute()]], query cache will not be used.

또한 보기: enableQueryCache

또한 보기: queryCache

또한 보기: noCache()

public cache ( callable $callable, integer $duration = null, yii\caching\Dependency $dependency = null ) : mixed
$callable	callable	a PHP callable that contains DB queries which will make use of query cache. The signature of the callable is `function (Connection $db)`.
$duration	integer	the number of seconds that query results can remain valid in the cache. If this is not set, the value of [[queryCacheDuration]] will be used instead. Use 0 to indicate that the cached data will never expire.
$dependency	yii\caching\Dependency	the cache dependency associated with the cached query results.
리턴	mixed	the return result of the callable

    public function cache(callable $callable, $duration = null, $dependency = null)
    {
        $this->_queryCacheInfo[] = [$duration === null ? $this->queryCacheDuration : $duration, $dependency];
        try {
            $result = call_user_func($callable, $this);
            array_pop($this->_queryCacheInfo);
            return $result;
        } catch (\Exception $e) {
            array_pop($this->_queryCacheInfo);
            throw $e;
        }
    }

Connection

__sleep

beginTransaction

cache

createCommand

createPdoInstance

getDriverName

getIsActive

getLastInsertID

getMasterPdo

getQueryBuilder

getQueryCacheInfo