Inheritance diagram for ILIAS\Test\Setup\Test11DBUpdateSteps:

Collaboration diagram for ILIAS\Test\Setup\Test11DBUpdateSteps:

Public Member Functions
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

	step_1 ()

	step_2 ()

	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 25 of file Test11DBUpdateSteps.php.

Member Function Documentation

◆ prepare()

ILIAS\Test\Setup\Test11DBUpdateSteps::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 Test11DBUpdateSteps.php.

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

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

◆ step_1()

ILIAS\Test\Setup\Test11DBUpdateSteps::step_1 ( )

Definition at line 36 of file Test11DBUpdateSteps.php.

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

◆ step_2()

ILIAS\Test\Setup\Test11DBUpdateSteps::step_2 ( )

Definition at line 46 of file Test11DBUpdateSteps.php.

                            : void
    {
        // 1. Create table schema
        if (!$this->db->tableExists('tst_test_settings')) {
            // Create table and sequence table
            $this->db->createTable('tst_test_settings', ['id' => ['type' => \ilDBConstants::T_INTEGER]]);
            $this->db->createSequence('tst_test_settings');
            $this->db->addPrimaryKey('tst_test_settings', ['id']);
 
            // Create table columns
            foreach (self::SETTINGS_COLUMNS as $key => $value) {
                [$column_def] = $value;
 
                // No columns should be nullable, except those with NULL by default
                if (!isset($column_def['notnull'])) {
                    $column_def['notnull'] = !$this->columnIsNullable($column_def);
                }
 
                $this->db->addTableColumn('tst_test_settings', $key, $column_def);
            }
        }
 
        // 2. Create a foreign key column in tst_tests
        if (!$this->db->tableColumnExists('tst_tests', 'settings_id')) {
            $this->db->addTableColumn(
                'tst_tests',
                'settings_id',
                ['type' => \ilDBConstants::T_INTEGER, 'default' => null, 'notnull' => false],
            );
            $this->db->addForeignKey(
                'test_settings_fkey',
                ['settings_id'],
                'tst_tests',
                ['id'],
                'tst_test_settings',
                ForeignKeyConstraints::NO_ACTION,
                ForeignKeyConstraints::RESTRICT,
            );
        }
 
        // 3. Create a foreign key column and new columns in tst_test_defaults
        if (!$this->db->tableColumnExists('tst_test_defaults', 'settings_id')) {
            $this->db->addTableColumn(
                'tst_test_defaults',
                'settings_id',
                ['type' => \ilDBConstants::T_INTEGER, 'default' => null, 'notnull' => false],
            );
            $this->db->addForeignKey(
                'test_default_fkey',
                ['settings_id'],
                'tst_test_defaults',
                ['id'],
                'tst_test_settings',
                ForeignKeyConstraints::NO_ACTION,
                ForeignKeyConstraints::RESTRICT
            );
        }
        if (!$this->db->tableColumnExists('tst_test_defaults', 'description')) {
            $this->db->addTableColumn(
                'tst_test_defaults',
                'description',
                ['type' => \ilDBConstants::T_TEXT, 'length' => 4000, 'default' => null],
            );
        }
        if (!$this->db->tableColumnExists('tst_test_defaults', 'author')) {
            $this->db->addTableColumn(
                'tst_test_defaults',
                'author',
                ['type' => \ilDBConstants::T_TEXT, 'length' => 255, 'default' => null],
            );
        }
 
        // 4. Create tst_defaults_marks table to store marks reference
        if (!$this->db->tableExists('tst_defaults_marks')) {
            $this->db->createTable(
                'tst_defaults_marks',
                [
                    'defaults_id' => ['type' => \ilDBConstants::T_INTEGER],
                    'mark_id' => ['type' => \ilDBConstants::T_INTEGER],
                ],
            );
            $this->db->addPrimaryKey('tst_defaults_marks', ['defaults_id', 'mark_id']);
 
            $this->db->addForeignKey(
                'test_default_fkey2',
                ['defaults_id '],
                'tst_defaults_marks',
                ['test_defaults_id'],
                'tst_test_defaults',
                ForeignKeyConstraints::NO_ACTION,
                ForeignKeyConstraints::RESTRICT
            );
 
            $this->db->addForeignKey(
                'test_mark_fkey',
                ['mark_id '],
                'tst_defaults_marks',
                ['mark_id'],
                'tst_mark',
                ForeignKeyConstraints::NO_ACTION,
                ForeignKeyConstraints::CASCADE
            );
        }
    }