class.ilTestQuestionPool9DBUpdateSteps.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilTestQuestionPool9DBUpdateSteps implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;
 
    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): void
    {
        if ($this->db->tableColumnExists('qpl_questionpool', 'nav_taxonomy')) {
            $this->db->dropTableColumn('qpl_questionpool', 'nav_taxonomy');
        }
    }
 
    public function step_2(): void
    {
        if ($this->db->tableColumnExists('qpl_questions', 'working_time')) {
            $this->db->dropTableColumn('qpl_questions', 'working_time');
        }
    }
 
    public function step_3(): void
    {
        if ($this->db->tableExists('qpl_sol_sug')) {
            $this->db->manipulateF("DELETE FROM qpl_sol_sug WHERE type = %s", ['text'], ['text']);
        }
    }
 
    public function step_4(): void
    {
        $query = '
            UPDATE object_data
            INNER JOIN qpl_questionpool ON object_data.obj_id = qpl_questionpool.obj_fi
            SET object_data.offline = IF(qpl_questionpool.isonline = 1, 0, 1)
            WHERE object_data.type = %s
        ';
 
        $this->db->manipulateF(
            $query,
            [ilDBConstants::T_TEXT],
            ['qpl']
        );
 
        if ($this->db->tableColumnExists('qpl_questionpool', 'isonline')) {
            $this->db->dropTableColumn('qpl_questionpool', 'isonline');
        }
    }
 
    public function step_5(): void
    {
        $this->db->modifyTableColumn(
            'qpl_questions',
            'author',
            ['type' => 'text', 'length' => 512]
        );
    }
 
    public function step_6(): void
    {
        $this->db->modifyTableColumn(
            'qpl_questions',
            'title',
            ['type' => 'text', 'length' => 124]
        );
    }
 
    public function step_7(): void
    {
        $table = 'tst_rnd_quest_set_qpls';
        $table_column = 'pool_title';
        if ($this->db->tableColumnExists($table, $table_column)) {
            $this->db->modifyTableColumn(
                $table,
                $table_column,
                ['type' => ilDBConstants::T_TEXT, 'length' => 255],
            );
        }
    }
}