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