FlavourDBRepository.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\ResourceStorage\Resource\Repository;
 
use ILIAS\ResourceStorage\Flavour\Definition\FlavourDefinition;
use ILIAS\ResourceStorage\Flavour\Flavour;
use ILIAS\ResourceStorage\Identification\ResourceIdentification;
 
class FlavourDBRepository implements FlavourRepository
{
    protected const TABLE_NAME = 'il_resource_flavour';
    protected const F_RESOURCE_ID = 'rid';
    protected const F_REVISION = 'revision';
    protected const F_DEFINITION = 'definition_id';
    protected const F_VARIANT = 'variant';
    private array $results_cache = [];
 
    public function __construct(private \ilDBInterface $db)
    {
    }
 
 
    public function has(ResourceIdentification $rid, int $revision, FlavourDefinition $definition): bool
    {
        return $this->buildResult($rid, $revision, $definition, false)->numRows() > 0;
    }
 
    public function store(Flavour $flavour): void
    {
        if (!$this->has($flavour->getResourceId(), $flavour->getRevision(), $flavour->getDefinition())) {
            $this->db->insert(
                self::TABLE_NAME,
                [
                    self::F_RESOURCE_ID => ['text', $flavour->getResourceId()->serialize()],
                    self::F_REVISION => ['integer', $flavour->getRevision()],
                    self::F_DEFINITION => ['text', $flavour->getDefinition()->getId()],
                    self::F_VARIANT => ['text', $flavour->getDefinition()->getVariantName() ?? '']
                ]
            );
        }
    }
 
    public function get(ResourceIdentification $rid, int $revision, FlavourDefinition $definition): Flavour
    {
        return new Flavour(
            $definition,
            $rid,
            $revision
        );
    }
 
 
    public function delete(Flavour $flavour): void
    {
        $rid = $flavour->getResourceId();
        $definition = $flavour->getDefinition();
 
        $r = $this->db->manipulateF(
            "DELETE FROM " . self::TABLE_NAME
            . " WHERE " . self::F_RESOURCE_ID . " = %s AND "
            . self::F_REVISION . " = %s AND "
            . self::F_DEFINITION . " = %s AND (" . self::F_VARIANT . " = %s OR " . self::F_VARIANT . " IS NULL)",
            ['text', 'integer', 'text', 'text'],
            [$rid->serialize(), $flavour->getRevision(), $definition->getId(), $definition->getVariantName()]
        );
    }
 
 
    public function preload(array $identification_strings): void
    {
        // TODO: Implement preload() method.
    }
 
    public function populateFromArray(array $data): void
    {
        // TODO: Implement populateFromArray() method.
    }
 
 
    private function buildResult(
        ResourceIdentification $rid,
        int $revision,
        FlavourDefinition $definition,
        bool $use_cache = true
    ): \ilDBStatement {
        $rcache = $rid->serialize() . $definition->getId() . $definition->getVariantName();
        if ($use_cache && isset($this->results_cache[$rcache])) {
            return $this->results_cache[$rcache];
        }
 
        $r = $this->db->queryF(
            "SELECT *  FROM " . self::TABLE_NAME
            . " WHERE " . self::F_RESOURCE_ID . " = %s AND "
            . self::F_REVISION . " = %s AND "
            . self::F_DEFINITION . " = %s AND (" . self::F_VARIANT . " = %s OR " . self::F_VARIANT . " IS NULL)",
            [
                'text',
                'integer',
                'text',
                'text'
            ],
            [
                $rid->serialize(),
                $revision,
                $definition->getId(),
                $definition->getVariantName() ?? ''
            ]
        );
        return $this->results_cache[$rcache] = $r;
    }
}