class.ilIntroduceComponentArtifactDBUpdateSteps.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilIntroduceComponentArtifactDBUpdateSteps implements ilDatabaseUpdateSteps
{
    protected \ilDBInterface $db;

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

    public function step_1(): void
    {
        if ($this->db->tableExists("il_compoment")) {
            $this->db->dropTable("il_component");
        }
    }

    public function step_2(): void
    {
        $this->db->dropTable("il_pluginslot");
    }

    public function step_3(): void
    {
        $this->db->manipulate("DELETE FROM il_plugin WHERE plugin_id IS NULL");
    }

    public function step_4(): void
    {
        try {
            $this->db->addPrimaryKey("il_plugin", ["plugin_id"]);
        } catch (\PDOException $e) {
            $this->db->dropPrimaryKey("il_plugin");
            $this->db->addPrimaryKey("il_plugin", ["plugin_id"]);
        }
    }

    public function step_5(): void
    {
        if (!$this->db->tableColumnExists("il_plugin", "component_type")) {
            return;
        }

        $this->db->dropTableColumn("il_plugin", "component_type");
    }

    public function step_6(): void
    {
        if (!$this->db->tableColumnExists("il_plugin", "component_name")) {
            return;
        }

        $this->db->dropTableColumn("il_plugin", "component_name");
    }

    public function step_7(): void
    {
        if (!$this->db->tableColumnExists("il_plugin", "slot_id")) {
            return;
        }

        $this->db->dropTableColumn("il_plugin", "slot_id");
    }

    public function step_8(): void
    {
        if (!$this->db->tableColumnExists("il_plugin", "name")) {
            return;
        }

        $this->db->dropTableColumn("il_plugin", "name");
    }
}