class.ilWOPIDB90.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilWOPIDB90 implements \ilDatabaseUpdateSteps
{
    private ?ilDBInterface $db = null;
 
    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): void
    {
        // create app table
        $this->db->createTable('wopi_app', [
            'id' => [
                'type' => 'integer',
                'length' => 4,
                'notnull' => true,
            ],
            'name' => [
                'type' => 'text',
                'length' => 256,
                'notnull' => true,
            ],
            'favicon' => [
                'type' => 'text',
                'length' => 256,
                'notnull' => false,
            ],
        ]);
        $this->db->addPrimaryKey('wopi_app', ['id']);
        $this->db->createSequence('wopi_app');
    }
 
    public function step_2(): void
    {
        // create action table
        $this->db->createTable('wopi_action', [
            'id' => [
                'type' => 'integer',
                'length' => 4,
                'notnull' => true,
            ],
            'app_id' => [
                'type' => 'integer',
                'length' => 4,
                'notnull' => true,
            ],
            'name' => [
                'type' => 'text',
                'length' => 256,
                'notnull' => true,
            ],
            'ext' => [
                'type' => 'text',
                'length' => 256,
                'notnull' => true,
            ],
            'urlsrc' => [
                'type' => 'text',
                'length' => 2048,
                'notnull' => true,
            ]
        ]);
        $this->db->addPrimaryKey('wopi_action', ['id']);
        $this->db->createSequence('wopi_action');
        $this->db->addIndex('wopi_action', ['app_id'], 'i1');
    }
 
    public function step_3(): void
    {
        if (!$this->db->tableColumnExists('wopi_action', 'url_appendix')) {
            $this->db->addTableColumn(
                'wopi_action',
                'url_appendix',
                [
                    'type' => 'text',
                    'length' => 4000,
                    'notnull' => false,
                ]
            );
        }
    }
 
    public function step_4(): void
    {
        if (!$this->db->tableColumnExists('wopi_action', 'target_ext')) {
            $this->db->addTableColumn(
                'wopi_action',
                'target_ext',
                [
                    'type' => 'text',
                    'length' => 256,
                    'notnull' => false,
                ],
            );
        }
    }
}