class.TestQuestionPoolSkillDBRepository.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\TestQuestionPool\Skills;

class TestQuestionPoolSkillDBRepository
{
    protected \ilDBInterface $db;

    public function __construct(
        \ilDBInterface $db = null
    ) {
        global $DIC;

        $this->db = ($db) ?: $DIC->database();
    }

    public function removeForSkill(int $skill_node_id, bool $is_reference): void
    {
        if (!$is_reference) {
            $this->db->manipulate("DELETE FROM qpl_qst_skl_assigns " .
                " WHERE skill_base_fi = " . $this->db->quote($skill_node_id, "integer"));
            $this->db->manipulate("DELETE FROM qpl_qst_skl_sol_expr " .
                " WHERE skill_base_fi = " . $this->db->quote($skill_node_id, "integer"));
        } else {
            $this->db->manipulate("DELETE FROM qpl_qst_skl_assigns " .
                " WHERE skill_tref_fi = " . $this->db->quote($skill_node_id, "integer"));
            $this->db->manipulate("DELETE FROM qpl_qst_skl_sol_expr " .
                " WHERE skill_tref_fi = " . $this->db->quote($skill_node_id, "integer"));
        }
    }
}