ILIAS\Test\Setup\Test10DBUpdateSteps Class Reference

Inheritance diagram for ILIAS\Test\Setup\Test10DBUpdateSteps:

Collaboration diagram for ILIAS\Test\Setup\Test10DBUpdateSteps:

Public Member Functions
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...
	step_1 ()
	step_2 ()
	step_3 ()
	step_4 ()
	step_5 ()
	step_6 ()
	step_7 ()
	step_8 ()
	step_9 ()
	step_10 ()
	step_11 ()
	step_12 ()

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 27 of file Test10DBUpdateSteps.php.

Member Function Documentation

prepare()

ILIAS\Test\Setup\Test10DBUpdateSteps::prepare

(

\ilDBInterface

$db

)

Prepare the execution of the steps.

Do not use anything from the globals or the DIC inside your steps, only use the instance of the database provided here.

Implements ilDatabaseUpdateSteps.

Definition at line 31 of file Test10DBUpdateSteps.php.

References ILIAS\Test\Setup\Test10DBUpdateSteps\$db.

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

step_1()

ILIAS\Test\Setup\Test10DBUpdateSteps::step_1

(

)

Definition at line 36 of file Test10DBUpdateSteps.php.

                            : void
    {
        if (!$this->db->tableColumnExists('tst_tests', 'ip_range_from')) {
            $this->db->addTableColumn(
                'tst_tests',
                'ip_range_from',
                [
                    'type' => 'text',
                    'length' => 39
                ]
            );
        }
        if (!$this->db->tableColumnExists('tst_tests', 'ip_range_to')) {
            $this->db->addTableColumn(
                'tst_tests',
                'ip_range_to',
                [
                    'type' => 'text',
                    'length' => 39
                ]
            );
        }
    }

step_10()

ILIAS\Test\Setup\Test10DBUpdateSteps::step_10

(

)

Definition at line 402 of file Test10DBUpdateSteps.php.

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

step_11()

ILIAS\Test\Setup\Test10DBUpdateSteps::step_11

(

)

Definition at line 409 of file Test10DBUpdateSteps.php.

References ilDBConstants\T_INTEGER.

                             : void
    {
        if ($this->db->tableColumnExists('tst_tests', 'enable_processing_time')) {
            $this->db->manipulateF(
                'UPDATE tst_tests SET enable_processing_time = %s WHERE enable_processing_time IS NULL',
                [\ilDBConstants::T_INTEGER],
                [0]
            );
            $this->db->modifyTableColumn(
                'tst_tests',
                'enable_processing_time',
                [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 1,
                    'notnull' => true,
                    'default' => 0
                ]
            );
        }
    }

step_12()

ILIAS\Test\Setup\Test10DBUpdateSteps::step_12

(

)

Definition at line 430 of file Test10DBUpdateSteps.php.

References ilDBConstants\T_INTEGER, ilDBConstants\T_TEXT, and ILIAS\Test\ExportImport\DBRepository\TST_EXPORT_TABLE.

                             : void
    {
        if (!$this->db->tableExists(DBRepository::TST_EXPORT_TABLE)) {
            $this->db->createTable(DBRepository::TST_EXPORT_TABLE, [
                'object_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'type' => [
                    'type' => \ilDBConstants::T_TEXT,
                    'length' => 32,
                    'notnull' => true
                ],
                'rid' => [
                    'type' => \ilDBConstants::T_TEXT,
                    'length' => 64
                ]
            ]);
            $this->db->addPrimaryKey(DBRepository::TST_EXPORT_TABLE, ['rid']);
            $this->db->addIndex(DBRepository::TST_EXPORT_TABLE, ['object_id'], 'oid');
        }
    }

step_2()

ILIAS\Test\Setup\Test10DBUpdateSteps::step_2

(

)

Definition at line 60 of file Test10DBUpdateSteps.php.

References ilDBConstants\T_TEXT.

                            : void
    {
        $this->db->update(
            'il_cert_cron_queue',
            ['adapter_class' => [\ilDBConstants::T_TEXT, TestPlaceholderValues::class]],
            ['adapter_class' => [\ilDBConstants::T_TEXT, 'ilTestPlaceholderValues']]
        );
    }

step_3()

ILIAS\Test\Setup\Test10DBUpdateSteps::step_3

(

)

Definition at line 69 of file Test10DBUpdateSteps.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\ERROR_LOG_TABLE, ILIAS\Test\Logging\TestLoggingDatabaseRepository\PARTICIPANT_LOG_TABLE, ILIAS\Test\Logging\TestLoggingDatabaseRepository\QUESTION_ADMINISTRATION_LOG_TABLE, ILIAS\Test\Logging\TestLoggingDatabaseRepository\SCORING_LOG_TABLE, ilDBConstants\T_CLOB, ilDBConstants\T_INTEGER, ilDBConstants\T_TEXT, and ILIAS\Test\Logging\TestLoggingDatabaseRepository\TEST_ADMINISTRATION_LOG_TABLE.

                            : void
    {
        if (!$this->db->tableExists(TestLoggingDatabaseRepository::TEST_ADMINISTRATION_LOG_TABLE)) {
            $this->db->createTable(TestLoggingDatabaseRepository::TEST_ADMINISTRATION_LOG_TABLE, [
                'id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'ref_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'admin_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'interaction_type' => [
                    'type' => \ilDBConstants::T_TEXT,
                    'length' => 256,
                    'notnull' => true
                ],
                'modification_ts' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'additional_data' => [
                    'type' => \ilDBConstants::T_CLOB
                ]
            ]);
            $this->db->createSequence(TestLoggingDatabaseRepository::TEST_ADMINISTRATION_LOG_TABLE);
            $this->db->addPrimaryKey(TestLoggingDatabaseRepository::TEST_ADMINISTRATION_LOG_TABLE, ['id']);
            $this->db->addIndex(TestLoggingDatabaseRepository::TEST_ADMINISTRATION_LOG_TABLE, ['ref_id'], 'rid');
        }

        if (!$this->db->tableExists(TestLoggingDatabaseRepository::QUESTION_ADMINISTRATION_LOG_TABLE)) {
            $this->db->createTable(TestLoggingDatabaseRepository::QUESTION_ADMINISTRATION_LOG_TABLE, [
                'id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'ref_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'qst_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8
                ],
                'admin_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'interaction_type' => [
                    'type' => \ilDBConstants::T_TEXT,
                    'length' => 256,
                    'notnull' => true
                ],
                'modification_ts' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'additional_data' => [
                    'type' => \ilDBConstants::T_CLOB
                ]
            ]);
            $this->db->createSequence(TestLoggingDatabaseRepository::QUESTION_ADMINISTRATION_LOG_TABLE);
            $this->db->addPrimaryKey(TestLoggingDatabaseRepository::QUESTION_ADMINISTRATION_LOG_TABLE, ['id']);
            $this->db->addIndex(TestLoggingDatabaseRepository::QUESTION_ADMINISTRATION_LOG_TABLE, ['ref_id'], 'rid');
        }

        if (!$this->db->tableExists(TestLoggingDatabaseRepository::PARTICIPANT_LOG_TABLE)) {
            $this->db->createTable(TestLoggingDatabaseRepository::PARTICIPANT_LOG_TABLE, [
                'id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'ref_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'qst_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => false
                ],
                'pax_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'source_ip' => [
                    'type' => \ilDBConstants::T_TEXT,
                    'length' => 42,
                    'notnull' => true
                ],
                'interaction_type' => [
                    'type' => \ilDBConstants::T_TEXT,
                    'length' => 256,
                    'notnull' => true
                ],
                'modification_ts' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'additional_data' => [
                    'type' => \ilDBConstants::T_CLOB
                ]
            ]);
            $this->db->createSequence(TestLoggingDatabaseRepository::PARTICIPANT_LOG_TABLE);
            $this->db->addPrimaryKey(TestLoggingDatabaseRepository::PARTICIPANT_LOG_TABLE, ['id']);
            $this->db->addIndex(TestLoggingDatabaseRepository::PARTICIPANT_LOG_TABLE, ['ref_id'], 'rid');
        }

        if (!$this->db->tableExists(TestLoggingDatabaseRepository::SCORING_LOG_TABLE)) {
            $this->db->createTable(TestLoggingDatabaseRepository::SCORING_LOG_TABLE, [
                'id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'ref_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'qst_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'admin_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'pax_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'interaction_type' => [
                    'type' => \ilDBConstants::T_TEXT,
                    'length' => 256,
                    'notnull' => true
                ],
                'modification_ts' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'additional_data' => [
                    'type' => \ilDBConstants::T_CLOB
                ]
            ]);
            $this->db->createSequence(TestLoggingDatabaseRepository::SCORING_LOG_TABLE);
            $this->db->addPrimaryKey(TestLoggingDatabaseRepository::SCORING_LOG_TABLE, ['id']);
            $this->db->addIndex(TestLoggingDatabaseRepository::SCORING_LOG_TABLE, ['ref_id'], 'rid');
        }

        if (!$this->db->tableExists(TestLoggingDatabaseRepository::ERROR_LOG_TABLE)) {
            $this->db->createTable(TestLoggingDatabaseRepository::ERROR_LOG_TABLE, [
                'id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'ref_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'qst_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8
                ],
                'admin_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8
                ],
                'pax_id' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8
                ],
                'interaction_type' => [
                    'type' => \ilDBConstants::T_TEXT,
                    'length' => 256,
                    'notnull' => true
                ],
                'modification_ts' => [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ],
                'error_message' => [
                    'type' => \ilDBConstants::T_TEXT,
                    'length' => 4000,
                    'notnull' => true,
                    'default' => ''
                ]
            ]);
            $this->db->createSequence(TestLoggingDatabaseRepository::ERROR_LOG_TABLE);
            $this->db->addPrimaryKey(TestLoggingDatabaseRepository::ERROR_LOG_TABLE, ['id']);
            $this->db->addIndex(TestLoggingDatabaseRepository::ERROR_LOG_TABLE, ['ref_id'], 'rid');
        }
    }

step_4()

ILIAS\Test\Setup\Test10DBUpdateSteps::step_4

(

)

Definition at line 286 of file Test10DBUpdateSteps.php.

                            : void
    {
        if (!$this->db->tableColumnExists('tst_invited_user', 'ip_range_from')) {
            $this->db->addTableColumn(
                'tst_invited_user',
                'ip_range_from',
                [
                    'type' => 'text',
                    'length' => 39
                ]
            );
        }
        if (!$this->db->tableColumnExists('tst_invited_user', 'ip_range_to')) {
            $this->db->addTableColumn(
                'tst_invited_user',
                'ip_range_to',
                [
                    'type' => 'text',
                    'length' => 39
                ]
            );
        }


        if ($this->db->tableColumnExists('tst_invited_user', 'clientip')) {
            $this->db->manipulate('UPDATE tst_invited_user SET ip_range_from = clientip, ip_range_to = clientip WHERE ip_range_from IS NULL AND ip_range_to IS NULL');
            $this->db->dropTableColumn('tst_invited_user', 'clientip');
        }
    }

step_5()

ILIAS\Test\Setup\Test10DBUpdateSteps::step_5

(

)

Definition at line 316 of file Test10DBUpdateSteps.php.

References ilDBConstants\T_INTEGER.

                            : void
    {
        if (!$this->db->tableColumnExists('tst_addtime', 'user_fi')) {
            $this->db->addTableColumn(
                'tst_addtime',
                'user_fi',
                [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ]
            );
        }
        if (!$this->db->tableColumnExists('tst_addtime', 'test_fi')) {
            $this->db->addTableColumn(
                'tst_addtime',
                'test_fi',
                [
                    'type' => \ilDBConstants::T_INTEGER,
                    'length' => 8,
                    'notnull' => true
                ]
            );
        }

        if ($this->db->tableColumnExists('tst_addtime', 'active_fi')) {
            $this->db->manipulate(
                '
                UPDATE tst_addtime INNER JOIN tst_active ON tst_active.active_id = tst_addtime.active_fi
                SET tst_addtime.test_fi = tst_active.test_fi, tst_addtime.user_fi = tst_active.user_fi'
            );

            $this->db->dropTableColumn('tst_addtime', 'active_fi');
        }

        if (!$this->db->primaryExistsByFields('tst_addtime', ['user_fi', 'test_fi'])) {
            $this->db->addPrimaryKey('tst_addtime', ['user_fi', 'test_fi']);
        }
    }

step_6()

ILIAS\Test\Setup\Test10DBUpdateSteps::step_6

(

)

Definition at line 356 of file Test10DBUpdateSteps.php.

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

step_7()

ILIAS\Test\Setup\Test10DBUpdateSteps::step_7

(

)

Definition at line 363 of file Test10DBUpdateSteps.php.

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

        if ($this->db->tableColumnExists('tst_pass_result', 'obligations_answered')) {
            $this->db->dropTableColumn('tst_pass_result', 'obligations_answered');
        }

        if ($this->db->tableColumnExists('tst_test_question', 'obligatory')) {
            $this->db->dropTableColumn('tst_test_question', 'obligatory');
        }

        if ($this->db->tableColumnExists('tst_result_cache', 'obligations_answered')) {
            $this->db->dropTableColumn('tst_result_cache', 'obligations_answered');
        }
    }

step_8()

ILIAS\Test\Setup\Test10DBUpdateSteps::step_8

(

)

Definition at line 382 of file Test10DBUpdateSteps.php.

References ilDBConstants\T_TEXT.

                            : void
    {
        if (!$this->db->tableColumnExists('tst_pass_result', 'finalized_by')) {
            $this->db->addTableColumn(
                'tst_pass_result',
                'finalized_by',
                [
                    'type' => \ilDBConstants::T_TEXT,
                    'length' => 256,
                    'notnull' => false
                ]
            );
        }
    }

step_9()

ILIAS\Test\Setup\Test10DBUpdateSteps::step_9

(

)

Definition at line 397 of file Test10DBUpdateSteps.php.

                            : void
    {
        $this->db->manipulate('DELETE FROM rbac_operations WHERE operation = "tst_statistics"');
    }

Field Documentation

$db

ilDBInterface ILIAS\Test\Setup\Test10DBUpdateSteps::$db

protected

Definition at line 29 of file Test10DBUpdateSteps.php.

Referenced by ILIAS\Test\Setup\Test10DBUpdateSteps\prepare().

---

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

• components/ILIAS/Test/src/Setup/Test10DBUpdateSteps.php