ilResourceStorageDB80 Class Reference

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Inheritance diagram for ilResourceStorageDB80:

Collaboration diagram for ilResourceStorageDB80:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
	step_2 ()
	step_3 ()
	step_4 ()
	step_5 ()
	step_6 ()
	step_7 ()
	step_8 ()
	step_9 ()
	step_10 ()
	step_11 ()
	step_12 ()
	step_13 ()
Public Member Functions inherited from ilDatabaseUpdateSteps
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

Protected Attributes
ilDBInterface	$db

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning Class ilResourceStorageDB80

Author

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

Definition at line 23 of file class.ilResourceStorageDB80.php.

Member Function Documentation

prepare()

ilResourceStorageDB80::prepare

(

ilDBInterface

$db

)

Definition at line 27 of file class.ilResourceStorageDB80.php.

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

References $db.

step_1()

ilResourceStorageDB80::step_1

(

)

Definition at line 32 of file class.ilResourceStorageDB80.php.

                            : void
    {
        if (!$this->db->tableExists('il_resource_stkh_u') && $this->db->tableExists('il_resource_stakeh')) {
            $this->db->renameTable('il_resource_stakeh', 'il_resource_stkh_u');
            $this->db->createTable(
                'il_resource_stkh',
                [
                    'id' => ['type' => 'text', 'length' => 32, 'notnull' => true, 'default' => ''],
                    'class_name' => ['type' => 'text', 'length' => 250, 'notnull' => true, 'default' => ''],
                ]
            );
            $this->db->addPrimaryKey('il_resource_stkh', ['id']);
            $this->db->manipulate(
                "INSERT INTO il_resource_stkh (id, class_name) SELECT DISTINCT stakeholder_id, stakeholder_class FROM il_resource_stkh_u;"
            );
        }
 
        if ($this->db->tableColumnExists('il_resource_stkh_u', 'stakeholder_class')) {
            $this->db->dropTableColumn('il_resource_stkh_u', 'stakeholder_class');
        }
        if ($this->db->tableColumnExists('il_resource_stkh_u', 'internal')) {
            $this->db->dropTableColumn('il_resource_stkh_u', 'internal');
        }
    }

step_10()

ilResourceStorageDB80::step_10

(

)

Definition at line 302 of file class.ilResourceStorageDB80.php.

                             : void
    {
        if (!$this->db->primaryExistsByFields('il_resource_rca', ['rcid', 'rid'])) {
            $this->db->addPrimaryKey(
                'il_resource_rca',
                [
                    'rcid',
                    'rid',
                ]
            );
        }
 
        if (!$this->db->primaryExistsByFields('il_resource_rc', ['rcid'])) {
            $this->db->addPrimaryKey(
                'il_resource_rc',
                [
                    'rcid'
                ]
            );
        }
    }

step_11()

ilResourceStorageDB80::step_11

(

)

Definition at line 324 of file class.ilResourceStorageDB80.php.

                             : void
    {
        $this->db->modifyTableColumn(
            'il_resource_rc',
            'owner',
            ['length' => 4]
        );
 
        $this->db->modifyTableColumn(
            'il_resource_revision',
            'owner_id',
            ['length' => 4]
        );
    }

step_12()

ilResourceStorageDB80::step_12

(

)

Definition at line 339 of file class.ilResourceStorageDB80.php.

                             : void
    {
        $this->db->renameTableColumn(
            'il_resource_rc',
            'owner',
            'owner_id',
        );
    }

step_13()

ilResourceStorageDB80::step_13

(

)

Definition at line 348 of file class.ilResourceStorageDB80.php.

                             : void
    {
        if ($this->db->indexExistsByFields('il_resource_stkh_u', ['stakeholder_id'])) {
            $this->db->dropIndexByFields('il_resource_stkh_u', ['stakeholder_id']);
        }
        if ($this->db->indexExistsByFields('il_resource_stkh_u', ['rid'])) {
            $this->db->dropIndexByFields('il_resource_stkh_u', ['rid']);
        }
        if (!$this->db->primaryExistsByFields('il_resource_stkh_u', ['rid', 'stakeholder_id'])) {
            $this->db->addPrimaryKey('il_resource_stkh_u', ['rid', 'stakeholder_id']);
        }
    }

step_2()

ilResourceStorageDB80::step_2

(

)

Definition at line 57 of file class.ilResourceStorageDB80.php.

                            : void
    {
        //  rename all identification columns to rid
        if (!$this->db->tableColumnExists('il_resource', 'rid')) {
            $this->db->renameTableColumn(
                'il_resource',
                'identification',
                'rid'
            );
        }
        if (!$this->db->tableColumnExists('il_resource_info', 'rid')) {
            $this->db->renameTableColumn(
                'il_resource_info',
                'identification',
                'rid'
            );
        }
        if (!$this->db->tableColumnExists('il_resource_revision', 'rid')) {
            $this->db->renameTableColumn(
                'il_resource_revision',
                'identification',
                'rid'
            );
        }
        if (!$this->db->tableColumnExists('il_resource_stkh_u', 'rid')) {
            $this->db->renameTableColumn(
                'il_resource_stkh_u',
                'identification',
                'rid'
            );
        }
    }

step_3()

ilResourceStorageDB80::step_3

(

)

Definition at line 90 of file class.ilResourceStorageDB80.php.

                            : void
    {
        // set all rid columns to the same size
        $attributes = [
            'length' => 64,
            'notnull' => true,
            'default' => '',
        ];
        $this->db->modifyTableColumn(
            'il_resource',
            'rid',
            $attributes
        );
        $this->db->modifyTableColumn(
            'il_resource_info',
            'rid',
            $attributes
        );
        $this->db->modifyTableColumn(
            'il_resource_revision',
            'rid',
            $attributes
        );
        $this->db->modifyTableColumn(
            'il_resource_stkh_u',
            'rid',
            $attributes
        );
        try {
            $this->db->modifyTableColumn(
                'file_data',
                'rid',
                $attributes
            );
        } catch (Throwable) {
        }
    }

step_4()

ilResourceStorageDB80::step_4

(

)

Definition at line 128 of file class.ilResourceStorageDB80.php.

                            : void
    {
        if (!$this->db->tableColumnExists('il_resource_info', 'version_number')) {
            $this->db->addTableColumn(
                'il_resource_info',
                'version_number',
                [
                    'type' => 'integer',
                    'length' => 8
                ]
            );
 
            $this->db->manipulate(
                "UPDATE il_resource_info
JOIN il_resource_revision ON il_resource_info.internal = il_resource_revision.internal
SET il_resource_info.version_number = il_resource_revision.version_number
"
            );
        }
    }

step_5()

ilResourceStorageDB80::step_5

(

)

Definition at line 149 of file class.ilResourceStorageDB80.php.

                            : void
    {
        // remove internal columns and add primaries
        if ($this->db->tableColumnExists('il_resource_revision', 'internal')) {
            $this->db->dropTableColumn('il_resource_revision', 'internal');
            $this->db->addPrimaryKey(
                'il_resource_revision',
                [
                    'rid',
                    'version_number',
                ]
            );
        }
        if ($this->db->tableColumnExists('il_resource_info', 'internal')) {
            $this->db->dropTableColumn('il_resource_info', 'internal');
            $this->db->addPrimaryKey(
                'il_resource_info',
                [
                    'rid',
                    'version_number',
                ]
            );
        }
        if ($this->db->tableColumnExists('il_resource_stkh', 'internal')) {
            $this->db->dropTableColumn('il_resource_stkh', 'internal');
            $this->db->addPrimaryKey(
                'il_resource_stkh',
                [
                    'rid',
                    'stakeholder_id',
                ]
            );
        }
    }

step_6()

ilResourceStorageDB80::step_6

(

)

Definition at line 184 of file class.ilResourceStorageDB80.php.

                            : void
    {
        // set several fields to notnull
        $attributes = [
            'notnull' => true,
            'default' => '',
        ];
        $table_fields = [
            'il_resource' => ['storage_id'],
            'il_resource_info' => ['title', 'size', 'creation_date'],
            'il_resource_revision' => ['owner_id', 'title'],
        ];
        foreach ($table_fields as $table => $fields) {
            foreach ($fields as $field) {
                $this->db->modifyTableColumn(
                    $table,
                    $field,
                    $attributes
                );
            }
        }
    }

step_7()

ilResourceStorageDB80::step_7

(

)

Definition at line 207 of file class.ilResourceStorageDB80.php.

                            : void
    {
        // add index to file_data rid
        if (!$this->db->indexExistsByFields('file_data', ['rid'])) {
            $this->db->addIndex('file_data', ['rid'], 'i1');
        }
    }

step_8()

ilResourceStorageDB80::step_8

(

)

Definition at line 215 of file class.ilResourceStorageDB80.php.

                            : void
    {
        // several changes to irss tables
        $this->db->modifyTableColumn(
            'il_resource_revision',
            'available',
            [
                'default' => 1,
            ]
        );
        $this->db->modifyTableColumn(
            'il_resource_stkh_u',
            'stakeholder_id',
            ['length' => 64]
        );
        $this->db->modifyTableColumn(
            'il_resource_stkh',
            'id',
            ['length' => 64]
        );
        $this->db->modifyTableColumn(
            'il_resource_info',
            'title',
            ['length' => 255]
        );
        $this->db->modifyTableColumn(
            'il_resource_revision',
            'title',
            ['length' => 255]
        );
    }

step_9()

ilResourceStorageDB80::step_9

(

)

Definition at line 247 of file class.ilResourceStorageDB80.php.

                            : void
    {
        if (!$this->db->tableExists('il_resource_rc')) {
            $this->db->createTable(
                'il_resource_rc',
                [
                    'rcid' => [
                        'type' => 'text',
                        'length' => 64,
                        'notnull' => true,
                        'default' => '',
                    ],
                    'title' => [
                        'type' => 'text',
                        'length' => 4000,
                        'notnull' => false,
                        'default' => '',
                    ],
                    'owner' => [
                        'type' => 'integer',
                        'length' => 8,
                        'notnull' => true,
                        'default' => 0,
                    ],
                ]
            );
        }
 
        if (!$this->db->tableExists('il_resource_rca')) {
            $this->db->createTable(
                'il_resource_rca',
                [
                    'rcid' => [
                        'type' => 'text',
                        'length' => 64,
                        'notnull' => true,
                        'default' => '',
                    ],
                    'rid' => [
                        'type' => 'text',
                        'length' => 64,
                        'notnull' => true,
                        'default' => '',
                    ],
                    'position' => [
                        'type' => 'integer',
                        'length' => 8,
                        'notnull' => true,
                        'default' => 0,
                    ],
                ]
            );
        }
    }

Field Documentation

$db

ilDBInterface ilResourceStorageDB80::$db

protected

Definition at line 25 of file class.ilResourceStorageDB80.php.

Referenced by prepare().

---

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

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