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