class.ilDataCollectionDBUpdateSteps11.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilDataCollectionDBUpdateSteps11 implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;
 
    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): 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');
        }
    }
 
    public function step_2(): 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]);
        }
    }
 
    public function step_3(): 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],
            ]);
        }
    }
 
    public function step_4(): 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']);
        }
    }
}