ilResourceStorageDB90 Class Reference

Class ilResourceStorageDB90. More...

Inheritance diagram for ilResourceStorageDB90:

Collaboration diagram for ilResourceStorageDB90:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
	creates a new database table "il_resource_flavour" that is used to reference resource flavours to it's original resource. More...
	step_2 ()
	step_3 ()
	step_4 ()
Public Member Functions inherited from ilDatabaseUpdateSteps
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

Protected Attributes
ilDBInterface	$db

Detailed Description

Class ilResourceStorageDB90.

Author

Fabian Schmid fabia.nosp@m.n@sr.nosp@m..solu.nosp@m.tion.nosp@m.s

Definition at line 26 of file class.ilResourceStorageDB90.php.

Member Function Documentation

prepare()

ilResourceStorageDB90::prepare

(

ilDBInterface

$db

)

Definition at line 30 of file class.ilResourceStorageDB90.php.

References $db.

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

step_1()

ilResourceStorageDB90::step_1

(

)

creates a new database table "il_resource_flavour" that is used to reference resource flavours to it's original resource.

Definition at line 40 of file class.ilResourceStorageDB90.php.

                            : 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']);
    }

step_2()

ilResourceStorageDB90::step_2

(

)

Definition at line 77 of file class.ilResourceStorageDB90.php.

                            : 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) {
        }
    }

step_3()

ilResourceStorageDB90::step_3

(

)

Definition at line 94 of file class.ilResourceStorageDB90.php.

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

step_4()

ilResourceStorageDB90::step_4

(

)

Definition at line 105 of file class.ilResourceStorageDB90.php.

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

Field Documentation

$db

ilDBInterface ilResourceStorageDB90::$db

protected

Definition at line 28 of file class.ilResourceStorageDB90.php.

Referenced by prepare().

---

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

• components/ILIAS/ResourceStorage/classes/Setup/DB/class.ilResourceStorageDB90.php