ilDataCollectionDBUpdateSteps11 Class Reference

Inheritance diagram for ilDataCollectionDBUpdateSteps11:

Collaboration diagram for ilDataCollectionDBUpdateSteps11:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
	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

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

Member Function Documentation

prepare()

ilDataCollectionDBUpdateSteps11::prepare

(

ilDBInterface

$db

)

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

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

References $db.

step_1()

ilDataCollectionDBUpdateSteps11::step_1

(

)

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

                            : void
    {
        if ($this->db->tableColumnExists('il_dcl_field', 'is_unique')) {
            $st = $this->db->queryF(
                'SELECT id FROM il_dcl_field WHERE is_unique = %s AND datatype_id IN (%s, %s, %s, %s)',
                [
                    ilDBConstants::T_INTEGER,
                    ilDBConstants::T_INTEGER,
                    ilDBConstants::T_INTEGER,
                    ilDBConstants::T_INTEGER,
                    ilDBConstants::T_INTEGER
                ],
                [
                    1,
                    ilDclDatatype::INPUTFORMAT_TEXT,
                    ilDclDatatype::INPUTFORMAT_TEXT_SELECTION,
                    ilDclDatatype::INPUTFORMAT_DATE_SELECTION,
                    ilDclDatatype::INPUTFORMAT_ILIAS_REF,
                ]
            );
            while ($row = $this->db->fetchAssoc($st)) {
                $this->db->insert(
                    'il_dcl_field_prop',
                    [
                        "id" => [ilDBConstants::T_INTEGER, $this->db->nextId('il_dcl_field_prop')],
                        "field_id" => [ilDBConstants::T_INTEGER, (int) $row['id']],
                        "name" => [ilDBConstants::T_TEXT, ilDclBaseFieldModel::PROP_UNIQUE],
                        "value" => [ilDBConstants::T_TEXT, '1'],
                    ]
                );
            }
            $this->db->dropTableColumn('il_dcl_field', 'is_unique');
        }
    }

References ilDclDatatype\INPUTFORMAT_DATE_SELECTION, ilDclDatatype\INPUTFORMAT_ILIAS_REF, ilDclDatatype\INPUTFORMAT_TEXT, ilDclDatatype\INPUTFORMAT_TEXT_SELECTION, ilDclBaseFieldModel\PROP_UNIQUE, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

step_2()

ilDataCollectionDBUpdateSteps11::step_2

(

)

Definition at line 65 of file class.ilDataCollectionDBUpdateSteps11.php.

                            : void
    {
        if (!$this->db->tableColumnExists('il_dcl_tableview', 'role_limitation')) {
            $this->db->addTableColumn('il_dcl_tableview', 'role_limitation', [
                'type' => ilDBConstants::T_INTEGER,
                'length' => 1,
                'notnull' => true,
                'default' => 0
            ]);
            $this->db->manipulateF('UPDATE il_dcl_tableview SET role_limitation = %s', [ilDBConstants::T_INTEGER], [1]);
        }
    }

References ilDBConstants\T_INTEGER.

step_3()

ilDataCollectionDBUpdateSteps11::step_3

(

)

Definition at line 78 of file class.ilDataCollectionDBUpdateSteps11.php.

                            : void
    {
        $query = 'SELECT id FROM il_dcl_datatype WHERE id = %s';
        if ($this->db->fetchAssoc($this->db->queryF($query, [ilDBConstants::T_INTEGER], [ilDclDatatype::INPUTFORMAT_DATETIME])) === null) {
            $this->db->insert('il_dcl_datatype', [
                'id' => [ilDBConstants::T_INTEGER, ilDclDatatype::INPUTFORMAT_DATETIME],
                'title' => [ilDBConstants::T_TEXT, 'datetime'],
                'storage_location' => [ilDBConstants::T_INTEGER, 3],
                'sort' => [ilDBConstants::T_INTEGER, 52],
            ]);
        }
        if ($this->db->fetchAssoc($this->db->queryF($query, [ilDBConstants::T_INTEGER], [ilDclDatatype::INPUTFORMAT_DATETIME_SELECTION])) === null) {
            $this->db->insert('il_dcl_datatype', [
                'id' => [ilDBConstants::T_INTEGER, ilDclDatatype::INPUTFORMAT_DATETIME_SELECTION],
                'title' => [ilDBConstants::T_TEXT, 'datetime_selection'],
                'storage_location' => [ilDBConstants::T_INTEGER, 1],
                'sort' => [ilDBConstants::T_INTEGER, 54],
            ]);
        }
    }

References ilDclDatatype\INPUTFORMAT_DATETIME, ilDclDatatype\INPUTFORMAT_DATETIME_SELECTION, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

step_4()

ilDataCollectionDBUpdateSteps11::step_4

(

)

Definition at line 99 of file class.ilDataCollectionDBUpdateSteps11.php.

                            : void
    {
        if (!$this->db->tableExists('il_dcl_notification')) {
            $this->db->createTable('il_dcl_notification', [
                'obj_id' => [
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true
                ],
                'usr_id' => [
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true
                ],
                'setting' => [
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true
                ],
            ]);
            $this->db->addPrimaryKey('il_dcl_notification', ['obj_id', 'usr_id', 'setting']);
        }
    }

Field Documentation

$db

ilDBInterface ilDataCollectionDBUpdateSteps11::$db

protected

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

Referenced by prepare().

---

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

• components/ILIAS/DataCollection/classes/Setup/class.ilDataCollectionDBUpdateSteps11.php