Merge pull request #10860 from nupplaphil/feat/depository_profilefield

[friendica.git] / src / Model / Storage / Database.php

diff --git a/src/Model/Storage/Database.php b/src/Model/Storage/Database.php
index cfd4803c8f48e638191a1b9b45fa52322c83f686..7b90d878909221d8f2ac59d48e990c8cd0f51f08 100644 (file)
--- a/src/Model/Storage/Database.php
+++ b/src/Model/Storage/Database.php
@@ -1,58 +1,128 @@
 <?php
 /**
- * @file src/Model/Storage/Filesystem.php
- * @brief Storage backend system
+ * @copyright Copyright (C) 2010-2021, the Friendica project
+ *
+ * @license GNU AGPL version 3 or any later version
+ *
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Affero General Public License as
+ * published by the Free Software Foundation, either version 3 of the
+ * License, or (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU Affero General Public License for more details.
+ *
+ * You should have received a copy of the GNU Affero General Public License
+ * along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ *
  */
 
 namespace Friendica\Model\Storage;
 
-use Friendica\Core\Logger;
-use Friendica\Core\L10n;
-use Friendica\Core\System;
-use Friendica\Database\DBA;
+use Exception;
+use Friendica\Database\Database as DBA;
 
 /**
- * @brief Database based storage system
+ * Database based storage system
  *
  * This class manage data stored in database table.
  */
-class Database implements IStorage
+class Database implements IWritableStorage
 {
-       public static function get($ref)
+       const NAME = 'Database';
+
+       /** @var DBA */
+       private $dba;
+
+       /**
+        * @param DBA             $dba
+        */
+       public function __construct(DBA $dba)
        {
-               $r = DBA::selectFirst('storage', ['data'], ['id' => $ref]);
-               if (!DBA::isResult($r)) {
-                       return '';
-               }
+               $this->dba = $dba;
+       }
 
-               return $r['data'];
+       /**
+        * @inheritDoc
+        */
+       public function get(string $reference): string
+       {
+               try {
+                       $result = $this->dba->selectFirst('storage', ['data'], ['id' => $reference]);
+                       if (!$this->dba->isResult($result)) {
+                               throw new ReferenceStorageException(sprintf('Database storage cannot find data for reference %s', $reference));
+                       }
+
+                       return $result['data'];
+               } catch (Exception $exception) {
+                       if ($exception instanceof ReferenceStorageException) {
+                               throw $exception;
+                       } else {
+                               throw new StorageException(sprintf('Database storage failed to get %s', $reference), $exception->getCode(), $exception);
+                       }
+               }
        }
 
-       public static function put($data, $ref = '')
+       /**
+        * @inheritDoc
+        */
+       public function put(string $data, string $reference = ''): string
        {
-               if ($ref !== '') {
-                       $r = DBA::update('storage', ['data' => $data], ['id' => $ref]);
-                       if ($r === false) {
-                               Logger::log('Failed to update data with id ' . $ref . ': ' . DBA::errorNo() . ' : ' . DBA::errorMessage());
-                               throw new StorageException(L10n::t('Database storage failed to update %s', $ref));
-                       }
-                       return $ref;
+               if ($reference !== '') {
+                       try {
+                               $result = $this->dba->update('storage', ['data' => $data], ['id' => $reference]);
+                       } catch (Exception $exception) {
+                               throw new StorageException(sprintf('Database storage failed to update %s', $reference), $exception->getCode(), $exception);
+                       }
+                       if ($result === false) {
+                               throw new StorageException(sprintf('Database storage failed to update %s', $reference), 500, new Exception($this->dba->errorMessage(), $this->dba->errorNo()));
+                       }
+
+                       return $reference;
                } else {
-                       $r = DBA::insert('storage', ['data' => $data]);
-                       if ($r === false) {
-                               Logger::log('Failed to insert data: ' . DBA::errorNo() . ' : ' . DBA::errorMessage());
-                               throw new StorageException(L10n::t('Database storage failed to insert data'));
+                       try {
+                               $result = $this->dba->insert('storage', ['data' => $data]);
+                       } catch (Exception $exception) {
+                               throw new StorageException(sprintf('Database storage failed to insert %s', $reference), $exception->getCode(), $exception);
+                       }
+                       if ($result === false) {
+                               throw new StorageException(sprintf('Database storage failed to update %s', $reference), 500, new Exception($this->dba->errorMessage(), $this->dba->errorNo()));
+                       }
+
+                       return $this->dba->lastInsertId();
+               }
+       }
+
+       /**
+        * @inheritDoc
+        */
+       public function delete(string $reference)
+       {
+               try {
+                       if (!$this->dba->delete('storage', ['id' => $reference]) || $this->dba->affectedRows() === 0) {
+                               throw new ReferenceStorageException(sprintf('Database storage failed to delete %s', $reference));
+                       }
+               } catch (Exception $exception) {
+                       if ($exception instanceof ReferenceStorageException) {
+                               throw $exception;
+                       } else {
+                               throw new StorageException(sprintf('Database storage failed to delete %s', $reference), $exception->getCode(), $exception);
                        }
-                       return DBA::lastInsertId();
                }
        }
 
-       public static function delete($ref)
+       /**
+        * @inheritDoc
+        */
+       public static function getName(): string
+       {
+               return self::NAME;
+       }
+
+       public function __toString()
        {
-               return DBA::delete('storage', ['id' => $ref]);
+               return self::getName();
        }
-       
-       public static function getOptions() { return []; }
-       
-       public static function saveOptions($data) { return []; }
 }