add general caching structureissue-5183

1 files changed, 29 insertions, 0 deletions

diff --git a/lib/classes/cache/DbCache.php b/lib/classes/cache/DbCache.php
index 5714ce9..783ab10 100644
--- a/lib/classes/cache/DbCache.php
+++ b/lib/classes/cache/DbCache.php
@@ -112,6 +112,35 @@ class DbCache extends Cache
         return $item;
     }
 
+    public function getItems(array $keys = []): array
+    {
+        $query = "SELECT `cache_key`, `content`, `expires`
+                  FROM `cache`
+                  WHERE `cache_key` IN (:keys)
+                    AND `expires` > UNIX_TIMESTAMP()";
+        $results = DBManager::get()->fetchAll($query, [':keys' => $keys]);
+        $items = [];
+        foreach ($results as $result) {
+            $item = new Item($result['cache_key']);
+            $item->setHit();
+            if ($result['content']) {
+                $item->set(unserialize($result['content']));
+            }
+            if ($result['expires']) {
+                $expiration = new \DateTime();
+                $expiration->setTimestamp($result['expires']);
+                $item->expiresAt($expiration);
+            }
+            $items[$result['cache_key']] = $item;
+        }
+        // Don't return null, fill remaining keys
+        foreach (array_diff($keys, array_keys($items)) as $remaining_key) {
+            $items[$remaining_key] = new Item($remaining_key);
+        }
+        return $items;
+    }
+
+
     /**
      * @inheritDoc
      */