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']
        );
    }
}