ilTestQuestionPool9DBUpdateSteps Class Reference

Inheritance diagram for ilTestQuestionPool9DBUpdateSteps:

Collaboration diagram for ilTestQuestionPool9DBUpdateSteps:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
	step_2 ()
	step_3 ()
	step_4 ()
	step_5 ()
	step_6 ()
	step_7 ()
Public Member Functions inherited from ilDatabaseUpdateSteps
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 21 of file class.ilTestQuestionPool9DBUpdateSteps.php.

Member Function Documentation

prepare()

ilTestQuestionPool9DBUpdateSteps::prepare

(

ilDBInterface

$db

)

Definition at line 25 of file class.ilTestQuestionPool9DBUpdateSteps.php.

                                              : void
    {
        $this->db = $db;
    }

References $db.

step_1()

ilTestQuestionPool9DBUpdateSteps::step_1

(

)

Definition at line 30 of file class.ilTestQuestionPool9DBUpdateSteps.php.

                            : void
    {
        if ($this->db->tableColumnExists('qpl_questionpool', 'nav_taxonomy')) {
            $this->db->dropTableColumn('qpl_questionpool', 'nav_taxonomy');
        }
    }

step_2()

ilTestQuestionPool9DBUpdateSteps::step_2

(

)

Definition at line 37 of file class.ilTestQuestionPool9DBUpdateSteps.php.

                            : void
    {
        if ($this->db->tableColumnExists('qpl_questions', 'working_time')) {
            $this->db->dropTableColumn('qpl_questions', 'working_time');
        }
    }

step_3()

ilTestQuestionPool9DBUpdateSteps::step_3

(

)

Definition at line 44 of file class.ilTestQuestionPool9DBUpdateSteps.php.

                            : void
    {
        if ($this->db->tableExists('qpl_sol_sug')) {
            $this->db->manipulateF("DELETE FROM qpl_sol_sug WHERE type = %s", ['text'], ['text']);
        }
    }

step_4()

ilTestQuestionPool9DBUpdateSteps::step_4

(

)

Definition at line 51 of file class.ilTestQuestionPool9DBUpdateSteps.php.

                            : 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');
        }
    }

References ilDBConstants\T_TEXT.

step_5()

ilTestQuestionPool9DBUpdateSteps::step_5

(

)

Definition at line 71 of file class.ilTestQuestionPool9DBUpdateSteps.php.

                            : void
    {
        $this->db->modifyTableColumn(
            'qpl_questions',
            'author',
            ['type' => 'text', 'length' => 512]
        );
    }

step_6()

ilTestQuestionPool9DBUpdateSteps::step_6

(

)

Definition at line 80 of file class.ilTestQuestionPool9DBUpdateSteps.php.

                            : void
    {
        $this->db->modifyTableColumn(
            'qpl_questions',
            'title',
            ['type' => 'text', 'length' => 124]
        );
    }

step_7()

ilTestQuestionPool9DBUpdateSteps::step_7

(

)

Definition at line 89 of file class.ilTestQuestionPool9DBUpdateSteps.php.

                            : 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],
            );
        }
    }

References ilDBConstants\T_TEXT.

Field Documentation

$db

ilDBInterface ilTestQuestionPool9DBUpdateSteps::$db

protected

Definition at line 23 of file class.ilTestQuestionPool9DBUpdateSteps.php.

Referenced by prepare().

---

The documentation for this class was generated from the following file:

• components/ILIAS/TestQuestionPool/classes/Setup/class.ilTestQuestionPool9DBUpdateSteps.php