ilTestQuestionPool80DBUpdateSteps Class Reference

Inheritance diagram for ilTestQuestionPool80DBUpdateSteps:

Collaboration diagram for ilTestQuestionPool80DBUpdateSteps:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
	step_2 ()
	step_3 ()
	step_4 ()
	step_5 ()
	step_6 ()
	step_7 ()
	step_8 ()
	step_9 ()
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.ilTestQuestionPool80DBUpdateSteps.php.

Member Function Documentation

prepare()

ilTestQuestionPool80DBUpdateSteps::prepare

(

ilDBInterface

$db

)

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

References $db.

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

step_1()

ilTestQuestionPool80DBUpdateSteps::step_1

(

)

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

                            : void
    {
        $this->db->manipulateF("DELETE FROM qpl_qst_type WHERE type_tag = %s", ['text'], ['assJavaApplet']);
        $this->db->manipulateF("DELETE FROM qpl_qst_type WHERE type_tag = %s", ['text'], ['assFlashQuestion']);
    }

step_2()

ilTestQuestionPool80DBUpdateSteps::step_2

(

)

Definition at line 36 of file class.ilTestQuestionPool80DBUpdateSteps.php.

References ilDBConstants\T_INTEGER.

                            : void
    {
        if (!$this->db->tableColumnExists('tst_rnd_quest_set_qpls', 'pool_ref_id')) {
            $this->db->addTableColumn(
                'tst_rnd_quest_set_qpls',
                'pool_ref_id',
                [
                    'type' => ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => false,
                    'default' => null
                ]
            );
        }
    }

step_3()

ilTestQuestionPool80DBUpdateSteps::step_3

(

)

Definition at line 52 of file class.ilTestQuestionPool80DBUpdateSteps.php.

                            : void
    {
        $fields = ['gap_id'];
        if (!$this->db->indexExistsByFields('qpl_a_cloze', $fields)) {
            $this->db->addIndex(
                'qpl_a_cloze',
                $fields,
                'i2'
            );
        }
    }

step_4()

ilTestQuestionPool80DBUpdateSteps::step_4

(

)

Definition at line 64 of file class.ilTestQuestionPool80DBUpdateSteps.php.

                            : void
    {
        $fields = ['gap_fi', 'question_fi'];
        if (!$this->db->indexExistsByFields('qpl_a_cloze_combi_res', $fields)) {
            $this->db->addIndex(
                'qpl_a_cloze_combi_res',
                $fields,
                'i1'
            );
        }
    }

step_5()

ilTestQuestionPool80DBUpdateSteps::step_5

(

)

Definition at line 76 of file class.ilTestQuestionPool80DBUpdateSteps.php.

                            : void
    {
        $fields = ['owner'];
        if (!$this->db->indexExistsByFields('qpl_questions', $fields)) {
            $this->db->addIndex(
                'qpl_questions',
                $fields,
                'i5'
            );
        }
        $fields = ['question_fi'];
        if (!$this->db->indexExistsByFields('qpl_num_range', $fields)) {
            $this->db->addIndex(
                'qpl_num_range',
                $fields,
                'i6'
            );
        }
    }

step_6()

ilTestQuestionPool80DBUpdateSteps::step_6

(

)

Definition at line 96 of file class.ilTestQuestionPool80DBUpdateSteps.php.

References ilDBConstants\T_INTEGER.

                            : void
    {
        if (!$this->db->tableColumnExists('qpl_a_errortext', 'position')) {
            $this->db->addTableColumn(
                'qpl_a_errortext',
                'position',
                [
                    'type' => ilDBConstants::T_INTEGER,
                    'length' => 2,
                    'notnull' => false,
                    'default' => null
                ]
            );
        }
    }

step_7()

ilTestQuestionPool80DBUpdateSteps::step_7

(

)

Definition at line 112 of file class.ilTestQuestionPool80DBUpdateSteps.php.

References ilDBConstants\T_CLOB.

                            : void
    {
        if (!$this->db->tableColumnExists('qpl_qst_errortext', 'parsed_errortext')) {
            $this->db->addTableColumn(
                'qpl_qst_errortext',
                'parsed_errortext',
                [
                    'type' => ilDBConstants::T_CLOB,
                    'notnull' => false,
                    'default' => null
                ]
            );
        }
    }

step_8()

ilTestQuestionPool80DBUpdateSteps::step_8

(

)

Definition at line 127 of file class.ilTestQuestionPool80DBUpdateSteps.php.

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

step_9()

ilTestQuestionPool80DBUpdateSteps::step_9

(

)

Definition at line 136 of file class.ilTestQuestionPool80DBUpdateSteps.php.

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

Field Documentation

$db

ilDBInterface ilTestQuestionPool80DBUpdateSteps::$db

protected

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

Referenced by prepare().

---

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

• Modules/TestQuestionPool/Setup/class.ilTestQuestionPool80DBUpdateSteps.php