src/Core/Cache/DatabaseCacheDriver.php

   1 <?php
   2
   3 namespace Friendica\Core\Cache;
   4
   5 use Friendica\Core\Cache;
   6 use Friendica\Database\DBA;
   7 use Friendica\Util\DateTimeFormat;
   8
   9 /**
  10  * Database Cache Driver
  11  *
  12  * @author Hypolite Petovan <hypolite@mrpetovan.com>
  13  */
  14 class DatabaseCacheDriver extends AbstractCacheDriver implements ICacheDriver
  15 {
  16         public function get($key)
  17         {
  18                 $cache = DBA::selectFirst('cache', ['v'], ['`k` = ? AND `expires` >= ?', $key, DateTimeFormat::utcNow()]);
  19
  20                 if (DBA::isResult($cache)) {
  21                         $cached = $cache['v'];
  22                         $value = @unserialize($cached);
  23
  24                         // Only return a value if the serialized value is valid.
  25                         // We also check if the db entry is a serialized
  26                         // boolean 'false' value (which we want to return).
  27                         if ($cached === serialize(false) || $value !== false) {
  28                                 return $value;
  29                         }
  30                 }
  31
  32                 return null;
  33         }
  34
  35         public function set($key, $value, $ttl = Cache::FIVE_MINUTES)
  36         {
  37                 $fields = [
  38                         'v'       => serialize($value),
  39                         'expires' => DateTimeFormat::utc('now + ' . $ttl . 'seconds'),
  40                         'updated' => DateTimeFormat::utcNow()
  41                 ];
  42
  43                 return DBA::update('cache', $fields, ['k' => $key], true);
  44         }
  45
  46         public function delete($key)
  47         {
  48                 return DBA::delete('cache', ['k' => $key]);
  49         }
  50
  51         public function clear($outdated = true)
  52         {
  53                 if ($outdated) {
  54                         return DBA::delete('cache', ['`expires` < NOW()']);
  55                 } else {
  56                         return DBA::delete('cache', ['`k` IS NOT NULL ']);
  57                 }
  58         }
  59 }