ilWOPIDB90 Class Reference

Inheritance diagram for ilWOPIDB90:

Collaboration diagram for ilWOPIDB90:

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...

Private Attributes
ilDBInterface	$db = null

Detailed Description

Author

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

Definition at line 24 of file class.ilWOPIDB90.php.

Member Function Documentation

prepare()

ilWOPIDB90::prepare

(

ilDBInterface

$db

)

Definition at line 28 of file class.ilWOPIDB90.php.

References $db.

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

step_1()

ilWOPIDB90::step_1

(

)

Definition at line 33 of file class.ilWOPIDB90.php.

                            : 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');
    }

step_2()

ilWOPIDB90::step_2

(

)

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

                            : 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');
    }

step_3()

ilWOPIDB90::step_3

(

)

Definition at line 92 of file class.ilWOPIDB90.php.

                            : void
    {
        if (!$this->db->tableColumnExists('wopi_action', 'url_appendix')) {
            $this->db->addTableColumn(
                'wopi_action',
                'url_appendix',
                [
                    'type' => 'text',
                    'length' => 4000,
                    'notnull' => false,
                ]
            );
        }
    }

step_4()

ilWOPIDB90::step_4

(

)

Definition at line 107 of file class.ilWOPIDB90.php.

                            : void
    {
        if (!$this->db->tableColumnExists('wopi_action', 'target_ext')) {
            $this->db->addTableColumn(
                'wopi_action',
                'target_ext',
                [
                    'type' => 'text',
                    'length' => 256,
                    'notnull' => false,
                ],
            );
        }
    }

Field Documentation

$db

ilDBInterface ilWOPIDB90::$db = null

private

Definition at line 26 of file class.ilWOPIDB90.php.

Referenced by prepare().

---

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

• components/ILIAS/WOPI/classes/Setup/class.ilWOPIDB90.php