class.ilTestQuestionPool10DBUpdateSteps.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilTestQuestionPool10DBUpdateSteps implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;
 
    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): void
    {
        $this->db->manipulateF('UPDATE qpl_questions SET title=%s WHERE ISNULL(title)', [ilDBConstants::T_TEXT], ['']);
        $this->db->manipulateF('UPDATE qpl_questions SET description=%s WHERE ISNULL(description)', [ilDBConstants::T_TEXT], ['']);
        $this->db->manipulateF('UPDATE qpl_questions SET question_text=%s WHERE ISNULL(question_text)', [ilDBConstants::T_TEXT], ['']);
        $this->db->manipulateF('UPDATE qpl_questions SET lifecycle=%s WHERE ISNULL(lifecycle)', [ilDBConstants::T_TEXT], ['draft']);
        $this->db->manipulateF('UPDATE qpl_questions SET complete=%s WHERE ISNULL(complete)', [ilDBConstants::T_TEXT], ['1']);
        $this->db->modifyTableColumn('qpl_questions', 'title', ['notnull' => 1, 'default' => '']);
        $this->db->modifyTableColumn('qpl_questions', 'description', ['notnull' => 1, 'default' => '']);
        $this->db->modifyTableColumn('qpl_questions', 'question_text', ['notnull' => 1, 'default' => '']);
        $this->db->modifyTableColumn('qpl_questions', 'lifecycle', ['notnull' => 1, 'default' => 'draft']);
        $this->db->modifyTableColumn('qpl_questions', 'complete', ['notnull' => 1, 'default' => '1']);
    }
 
    public function step_2(): void
    {
        if ($this->db->tableColumnExists('qpl_questionpool', 'show_taxonomies')) {
            $this->db->dropTableColumn('qpl_questionpool', 'show_taxonomies');
        }
    }
}