SettingsDBRepository.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\MediaPool\Settings;
 
use ilDBInterface;
use ILIAS\MediaPool\InternalDataService;
 
class SettingsDBRepository
{
    public function __construct(
        protected ilDBInterface $db,
        protected InternalDataService $data
    ) {
    }
 
    public function create(Settings $settings): void
    {
        $this->db->insert('mep_data', [
            'id' => ['integer', $settings->getId()],
            'default_width' => ['integer', $settings->getDefaultWidth()],
            'default_height' => ['integer', $settings->getDefaultHeight()],
            'for_translation' => ['integer', (int) $settings->getForTranslation()],
        ]);
    }
 
    public function update(Settings $settings): void
    {
        $this->db->update('mep_data', [
            'default_width' => ['integer', $settings->getDefaultWidth()],
            'default_height' => ['integer', $settings->getDefaultHeight()],
            'for_translation' => ['integer', (int) $settings->getForTranslation()],
        ], [
            'id' => ['integer', $settings->getId()],
        ]);
    }
 
    public function getById(int $id): ?Settings
    {
        $set = $this->db->queryF(
            'SELECT * FROM mep_data WHERE id = %s',
            ['integer'],
            [$id]
        );
 
        $rec = $this->db->fetchAssoc($set);
        if ($rec) {
            return $this->getSettingsFromRecord($rec);
        }
 
        return null;
    }
 
    public function delete(int $id): void
    {
        $this->db->manipulateF(
            'DELETE FROM mep_data WHERE id = %s',
            ['integer'],
            [$id]
        );
    }
 
    protected function getSettingsFromRecord(array $rec): Settings
    {
        return $this->data->settings(
            (int) $rec['id'],
            (int) $rec['default_width'],
            (int) $rec['default_height'],
            (bool) $rec['for_translation']
        );
    }
}