ilMDLOMUpdateSteps Class Reference

Inheritance diagram for ilMDLOMUpdateSteps:

Collaboration diagram for ilMDLOMUpdateSteps:

Public Member Functions
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...
	step_1 ()
	Add a column to the il_meta_general table to store the 'Aggregation Level' element. More...
	step_2 ()
	Add two columns to the il_meta_contribute table to store the descrption of the date and its language. More...
	step_3 ()
	Add two columns to the il_meta_annotation table to store the description of the date and its language. More...
	step_4 ()
	Add two columns to the il_meta_educational table to store the description of the typical learning time and its language. More...
	step_5 ()
	Add two columns to the il_meta_technical table to store the description of the duration and its language. More...
	step_6 ()
	Add a new table for the non-unique coverage. More...
	step_7 ()
	Add a new table for the non-unique metadata schema. More...
	step_8 ()
	Add a new table for the non-unique or-composite in requirements. More...
	step_9 ()
	Add a new table for the non-unique learning resource type. More...
	step_10 ()
	Add a new table for the non-unique intented end user role. More...
	step_11 ()
	Add a new table for the non-unique context. More...

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 21 of file class.ilMDLOMUpdateSteps.php.

Member Function Documentation

prepare()

ilMDLOMUpdateSteps::prepare

(

\ilDBInterface

$db

)

Prepare the execution of the steps.

Do not use anything from the globals or the DIC inside your steps, only use the instance of the database provided here.

Implements ilDatabaseUpdateSteps.

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

References $db.

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

step_1()

ilMDLOMUpdateSteps::step_1

(

)

Add a column to the il_meta_general table to store the 'Aggregation Level' element.

Definition at line 34 of file class.ilMDLOMUpdateSteps.php.

References ilDBConstants\T_TEXT.

                            : void
    {
        if (!$this->db->tableColumnExists('il_meta_general', 'general_aggl')) {
            $this->db->addTableColumn(
                'il_meta_general',
                'general_aggl',
                [
                    'type' => ilDBConstants::T_TEXT,
                    'length' => 16,
                ]
            );
        }
    }

step_10()

ilMDLOMUpdateSteps::step_10

(

)

Add a new table for the non-unique intented end user role.

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

References ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

                             : void
    {
        if (!$this->db->tableExists('il_meta_end_usr_role')) {
            $this->db->createTable(
                'il_meta_end_usr_role',
                [
                    'meta_end_usr_role_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                        'notnull' => true,
                        'default' => 0
                    ],
                    'rbac_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'obj_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'obj_type' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 6
                    ],
                    'parent_type' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 16
                    ],
                    'parent_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'intended_end_user_role' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 16
                    ]
                ]
            );

            $this->db->createSequence('il_meta_end_usr_role');
            $this->db->addPrimaryKey('il_meta_end_usr_role', ['meta_end_usr_role_id']);
        }
    }

step_11()

ilMDLOMUpdateSteps::step_11

(

)

Add a new table for the non-unique context.

Definition at line 391 of file class.ilMDLOMUpdateSteps.php.

References ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

                             : void
    {
        if (!$this->db->tableExists('il_meta_context')) {
            $this->db->createTable(
                'il_meta_context',
                [
                    'meta_context_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                        'notnull' => true,
                        'default' => 0
                    ],
                    'rbac_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'obj_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'obj_type' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 6
                    ],
                    'parent_type' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 16
                    ],
                    'parent_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'context' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 16
                    ]
                ]
            );

            $this->db->createSequence('il_meta_context');
            $this->db->addPrimaryKey('il_meta_context', ['meta_context_id']);
        }
    }

step_2()

ilMDLOMUpdateSteps::step_2

(

)

Add two columns to the il_meta_contribute table to store the descrption of the date and its language.

Definition at line 52 of file class.ilMDLOMUpdateSteps.php.

References ilDBConstants\T_CLOB, and ilDBConstants\T_TEXT.

                            : void
    {
        if (!$this->db->tableColumnExists('il_meta_contribute', 'c_date_descr')) {
            $this->db->addTableColumn(
                'il_meta_contribute',
                'c_date_descr',
                [
                    'type' => ilDBConstants::T_CLOB,
                ]
            );
        }
        if (!$this->db->tableColumnExists('il_meta_contribute', 'descr_lang')) {
            $this->db->addTableColumn(
                'il_meta_contribute',
                'descr_lang',
                [
                    'type' => ilDBConstants::T_TEXT,
                    'length' => 2
                ]
            );
        }
    }

step_3()

ilMDLOMUpdateSteps::step_3

(

)

Add two columns to the il_meta_annotation table to store the description of the date and its language.

Definition at line 79 of file class.ilMDLOMUpdateSteps.php.

References ilDBConstants\T_CLOB, and ilDBConstants\T_TEXT.

                            : void
    {
        if (!$this->db->tableColumnExists('il_meta_annotation', 'a_date_descr')) {
            $this->db->addTableColumn(
                'il_meta_annotation',
                'a_date_descr',
                [
                    'type' => ilDBConstants::T_CLOB,
                ]
            );
        }
        if (!$this->db->tableColumnExists('il_meta_annotation', 'date_descr_lang')) {
            $this->db->addTableColumn(
                'il_meta_annotation',
                'date_descr_lang',
                [
                    'type' => ilDBConstants::T_TEXT,
                    'length' => 2
                ]
            );
        }
    }

step_4()

ilMDLOMUpdateSteps::step_4

(

)

Add two columns to the il_meta_educational table to store the description of the typical learning time and its language.

Definition at line 106 of file class.ilMDLOMUpdateSteps.php.

References ilDBConstants\T_CLOB, and ilDBConstants\T_TEXT.

                            : void
    {
        if (!$this->db->tableColumnExists('il_meta_educational', 'tlt_descr')) {
            $this->db->addTableColumn(
                'il_meta_educational',
                'tlt_descr',
                [
                    'type' => ilDBConstants::T_CLOB,
                ]
            );
        }
        if (!$this->db->tableColumnExists('il_meta_educational', 'tlt_descr_lang')) {
            $this->db->addTableColumn(
                'il_meta_educational',
                'tlt_descr_lang',
                [
                    'type' => ilDBConstants::T_TEXT,
                    'length' => 2
                ]
            );
        }
    }

step_5()

ilMDLOMUpdateSteps::step_5

(

)

Add two columns to the il_meta_technical table to store the description of the duration and its language.

Definition at line 133 of file class.ilMDLOMUpdateSteps.php.

References ilDBConstants\T_CLOB, and ilDBConstants\T_TEXT.

                            : void
    {
        if (!$this->db->tableColumnExists('il_meta_technical', 'duration_descr')) {
            $this->db->addTableColumn(
                'il_meta_technical',
                'duration_descr',
                [
                    'type' => ilDBConstants::T_CLOB,
                ]
            );
        }
        if (!$this->db->tableColumnExists('il_meta_technical', 'duration_descr_lang')) {
            $this->db->addTableColumn(
                'il_meta_technical',
                'duration_descr_lang',
                [
                    'type' => ilDBConstants::T_TEXT,
                    'length' => 2
                ]
            );
        }
    }

step_6()

ilMDLOMUpdateSteps::step_6

(

)

Add a new table for the non-unique coverage.

Definition at line 159 of file class.ilMDLOMUpdateSteps.php.

References ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

                            : void
    {
        if (!$this->db->tableExists('il_meta_coverage')) {
            $this->db->createTable(
                'il_meta_coverage',
                [
                    'meta_coverage_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                        'notnull' => true,
                        'default' => 0
                    ],
                    'rbac_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'obj_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'obj_type' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 6
                    ],
                    'parent_type' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 16
                    ],
                    'parent_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'coverage' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 4000
                    ],
                    'coverage_language' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 2,
                        'fixed' => true
                    ]
                ]
            );

            $this->db->createSequence('il_meta_coverage');
            $this->db->addPrimaryKey('il_meta_coverage', ['meta_coverage_id']);
        }
    }

step_7()

ilMDLOMUpdateSteps::step_7

(

)

Add a new table for the non-unique metadata schema.

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

References ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

                            : void
    {
        if (!$this->db->tableExists('il_meta_meta_schema')) {
            $this->db->createTable(
                'il_meta_meta_schema',
                [
                    'meta_meta_schema_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                        'notnull' => true,
                        'default' => 0
                    ],
                    'rbac_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'obj_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'obj_type' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 6
                    ],
                    'parent_type' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 16
                    ],
                    'parent_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'meta_data_schema' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 16
                    ]
                ]
            );

            $this->db->createSequence('il_meta_meta_schema');
            $this->db->addPrimaryKey('il_meta_meta_schema', ['meta_meta_schema_id']);
        }
    }

step_8()

ilMDLOMUpdateSteps::step_8

(

)

Add a new table for the non-unique or-composite in requirements.

Definition at line 250 of file class.ilMDLOMUpdateSteps.php.

References ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

                            : void
    {
        if (!$this->db->tableExists('il_meta_or_composite')) {
            $this->db->createTable(
                'il_meta_or_composite',
                [
                    'meta_or_composite_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                        'notnull' => true,
                        'default' => 0
                    ],
                    'rbac_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'obj_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'obj_type' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 6
                    ],
                    'parent_type' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 16
                    ],
                    'parent_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'type' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 16
                    ],
                    'name' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 32
                    ],
                    'min_version' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 255
                    ],
                    'max_version' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 255
                    ]
                ]
            );

            $this->db->createSequence('il_meta_or_composite');
            $this->db->addPrimaryKey('il_meta_or_composite', ['meta_or_composite_id']);
        }
    }

step_9()

ilMDLOMUpdateSteps::step_9

(

)

Add a new table for the non-unique learning resource type.

Definition at line 305 of file class.ilMDLOMUpdateSteps.php.

References ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

                            : void
    {
        if (!$this->db->tableExists('il_meta_lr_type')) {
            $this->db->createTable(
                'il_meta_lr_type',
                [
                    'meta_lr_type_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                        'notnull' => true,
                        'default' => 0
                    ],
                    'rbac_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'obj_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'obj_type' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 6
                    ],
                    'parent_type' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 16
                    ],
                    'parent_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                    ],
                    'learning_resource_type' => [
                        'type' => ilDBConstants::T_TEXT,
                        'length' => 32
                    ]
                ]
            );

            $this->db->createSequence('il_meta_lr_type');
            $this->db->addPrimaryKey('il_meta_lr_type', ['meta_lr_type_id']);
        }
    }

Field Documentation

$db

ilDBInterface ilMDLOMUpdateSteps::$db

protected

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

Referenced by prepare().

---

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

• components/ILIAS/MetaData/classes/Setup/class.ilMDLOMUpdateSteps.php