ilTestQuestionPool10DBUpdateSteps Class Reference

Inheritance diagram for ilTestQuestionPool10DBUpdateSteps:

Collaboration diagram for ilTestQuestionPool10DBUpdateSteps:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
	step_2 ()
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.ilTestQuestionPool10DBUpdateSteps.php.

Member Function Documentation

prepare()

ilTestQuestionPool10DBUpdateSteps::prepare

(

ilDBInterface

$db

)

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

References $db.

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

step_1()

ilTestQuestionPool10DBUpdateSteps::step_1

(

)

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

References ilDBConstants\T_TEXT.

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

step_2()

ilTestQuestionPool10DBUpdateSteps::step_2

(

)

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

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

Field Documentation

$db

ilDBInterface ilTestQuestionPool10DBUpdateSteps::$db

protected

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

Referenced by prepare().

---

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

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