src/Model/Storage/Database.php

   1 <?php
   2 /**
   3  * @file src/Model/Storage/Filesystem.php
   4  * @brief Storage backend system
   5  */
   6
   7 namespace Friendica\Model\Storage;
   8
   9 use Friendica\Core\L10n\L10n;
  10 use Psr\Log\LoggerInterface;
  11 use Friendica\Database\Database as DBA;
  12
  13 /**
  14  * @brief Database based storage system
  15  *
  16  * This class manage data stored in database table.
  17  */
  18 class Database extends AbstractStorage
  19 {
  20         const NAME = 'Database';
  21
  22         /** @var DBA */
  23         private $dba;
  24
  25         /**
  26          * @param DBA             $dba
  27          * @param LoggerInterface $logger
  28          * @param L10n            $l10n
  29          */
  30         public function __construct(DBA $dba, LoggerInterface $logger, L10n $l10n)
  31         {
  32                 parent::__construct($l10n, $logger);
  33
  34                 $this->dba = $dba;
  35         }
  36
  37         /**
  38          * @inheritDoc
  39          */
  40         public function get(string $reference)
  41         {
  42                 $result = $this->dba->selectFirst('storage', ['data'], ['id' => $reference]);
  43                 if (!$this->dba->isResult($result)) {
  44                         return '';
  45                 }
  46
  47                 return $result['data'];
  48         }
  49
  50         /**
  51          * @inheritDoc
  52          */
  53         public function put(string $data, string $reference = '')
  54         {
  55                 if ($reference !== '') {
  56                         $result = $this->dba->update('storage', ['data' => $data], ['id' => $reference]);
  57                         if ($result === false) {
  58                                 $this->logger->warning('Failed to update data.', ['id' => $reference, 'errorCode' => $this->dba->errorNo(), 'errorMessage' => $this->dba->errorMessage()]);
  59                                 throw new StorageException($this->l10n->t('Database storage failed to update %s', $reference));
  60                         }
  61
  62                         return $reference;
  63                 } else {
  64                         $result = $this->dba->insert('storage', ['data' => $data]);
  65                         if ($result === false) {
  66                                 $this->logger->warning('Failed to insert data.', ['errorCode' => $this->dba->errorNo(), 'errorMessage' => $this->dba->errorMessage()]);
  67                                 throw new StorageException($this->l10n->t('Database storage failed to insert data'));
  68                         }
  69
  70                         return $this->dba->lastInsertId();
  71                 }
  72         }
  73
  74         /**
  75          * @inheritDoc
  76          */
  77         public function delete(string $reference)
  78         {
  79                 return $this->dba->delete('storage', ['id' => $reference]);
  80         }
  81
  82         /**
  83          * @inheritDoc
  84          */
  85         public function getOptions()
  86         {
  87                 return [];
  88         }
  89
  90         /**
  91          * @inheritDoc
  92          */
  93         public function saveOptions(array $data)
  94         {
  95                 return [];
  96         }
  97
  98         /**
  99          * @inheritDoc
 100          */
 101         public static function getName()
 102         {
 103                 return self::NAME;
 104         }
 105 }