class.ilResourceStorageDB90.php

Go to the documentation of this file.

<?php

use ILIAS\ResourceStorage\Resource\ResourceType;
use ILIAS\ResourceStorage\Revision\RevisionStatus;

class ilResourceStorageDB90 implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;

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


    public function step_1(): void
    {
        $flavour_table = "il_resource_flavour";
        $this->db->dropTable($flavour_table, false);
        if ($this->db->tableExists($flavour_table)) {
            return;
        }

        $this->db->createTable($flavour_table, [
            'rid' => [
                'notnull' => true,
                'length' => '64',
                'type' => 'text',
            ],
            'revision' => [
                'notnull' => true,
                'length' => '8',
                'type' => 'integer',
            ],
            'definition_id' => [
                'notnull' => true,
                'length' => '64',
                'type' => 'text',
            ],
            'variant' => [
                'notnull' => false,
                'length' => '768',
                'type' => 'text',
            ]
        ]);

        $this->db->addIndex($flavour_table, ['rid'], 'i1');
        $this->db->addIndex($flavour_table, ['definition_id'], 'i3');
        $this->db->addIndex($flavour_table, ['variant'], 'i4');
        $this->db->addPrimaryKey($flavour_table, ['rid', 'revision', 'definition_id', 'variant']);
    }

    public function step_2(): void
    {
        // Remove some unused indexes, since they are in primaries now
        try {
            $this->db->dropIndexByFields('il_resource_info', ['rid']);
        } catch (Exception) {
        }
        try {
            $this->db->dropIndexByFields('il_resource_revision', ['rid']);
        } catch (Exception) {
        }
        try {
            $this->db->dropIndexByFields('il_resource_stkh_u', ['rid']);
        } catch (Exception) {
        }
    }

    public function step_3(): void
    {
        // add column rtype to il_resource
        $this->db->addTableColumn('il_resource', 'rtype', [
            'type' => 'integer',
            'length' => '1',
            'notnull' => true,
            'default' => ResourceType::SINGLE_FILE->value
        ]);
    }

    public function step_4(): void
    {
        // add column rtype to il_resource
        $this->db->addTableColumn('il_resource_revision', 'status', [
            'type' => 'integer',
            'length' => '2',
            'notnull' => true,
            'default' => RevisionStatus::PUBLISHED->value
        ]);
    }
}