DBRepository.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\Test\ExportImport;

use ILIAS\ResourceStorage\Identification\ResourceIdentification;

class DBRepository
{
    public const TST_EXPORT_TABLE = 'tst_exports';

    public function __construct(
        private readonly \ilDBInterface $db
    ) {
    }

    public function store(
        int $object_id,
        Types $type,
        ResourceIdentification $rid
    ): void {
        $this->db->insert(
            self::TST_EXPORT_TABLE,
            [
                'object_id' => [
                    \ilDBConstants::T_INTEGER,
                    $object_id
                ],
                'type' => [
                    \ilDBConstants::T_TEXT,
                    $type->value
                ],
                'rid' => [
                    \ilDBConstants::T_TEXT,
                    $rid->serialize()
                ],
            ]
        );
    }

    public function delete(
        ResourceIdentification $rid
    ): void {
        $this->db->manipulateF(
            'DELETE FROM ' . self::TST_EXPORT_TABLE . ' WHERE rid = %s',
            [\ilDBConstants::T_TEXT],
            [$rid->serialize()]
        );
    }

    public function getFor(
        int $object_id
    ): array {
        return $this->db->fetchAll(
            $this->db->queryF(
                'SELECT * FROM ' . self::TST_EXPORT_TABLE . ' WHERE object_id = %s',
                [\ilDBConstants::T_INTEGER],
                [$object_id]
            )
        );
    }
}