class.ilAdministrationDBUpdateSteps.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\Administration\Setup;

use ilDatabaseUpdateSteps;
use ilDBInterface;

class ilAdministrationDBUpdateSteps implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;

    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }

    public function step_1(): void
    {
        // note: release_8 has step_3 as step_1
    }

    public function step_2(): void
    {
        if ($this->db->sequenceExists("adm_settings_template")) {
            $this->db->dropSequence("adm_settings_template");
        }

        if ($this->db->tableExists("adm_settings_template")) {
            $this->db->dropTable("adm_settings_template");
        }
    }

    public function step_3(): void
    {
        $this->db->addTableColumn(
            'settings',
            'value2',
            array(      "type" => "text",
                      "length" => 4000,
                      "notnull" => false,
                      "default" => null)
        );

        $this->db->query("UPDATE settings SET value2 = SUBSTRING(value, 1, 4000)");
        $this->db->dropTableColumn('settings', 'value');
        $this->db->renameTableColumn('settings', 'value2', 'value');
    }

    public function step_4(): void
    {
        $this->db->manipulate("DELETE FROM settings WHERE keyword LIKE 'char_selector%'");
    }
}