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