PassPresentedVariablesRepo.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class PassPresentedVariablesRepo
{
    public const TABLE_NAME = 'tst_qst_var_presented';

    public function __construct(
        protected ilDBInterface $db
    ) {
    }

    public function getFor(
        int $question_id,
        int $active_id,
        int $pass
    ): ?array {
        $query = 'SELECT variable, value FROM ' . self::TABLE_NAME . ' WHERE '
            . 'question_id = %s AND '
            . 'active_id = %s AND '
            . 'pass = %s';

        $result = $this->db->queryF(
            $query,
            ['integer','integer','integer'],
            [$question_id, $active_id, $pass]
        );

        if($result->numRows() === 0) {
            return null;
        }

        $values = [];
        while ($row = $this->db->fetchAssoc($result)) {
            $values[$row['variable']] = $row['value'];
        }
        return $values;
    }

    public function store(
        int $question_id,
        int $active_id,
        int $pass,
        array $values
    ): void {
        $query = 'INSERT INTO ' . self::TABLE_NAME
            . ' (question_id, active_id, pass, variable, value) '
            . ' VALUES (%s,%s,%s,%s,%s)';

        foreach ($values as $k => $v) {
            $this->db->manipulateF(
                $query,
                ['integer','integer','integer', 'text', 'text'],
                [$question_id, $active_id, $pass, $k, $v]
            );
        }
    }
}