ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps Class Reference

Inheritance diagram for ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps:

Collaboration diagram for ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps:

Public Member Functions
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...
	step_1 ()
	step_2 ()
	step_3 ()
	step_4 ()
	step_5 ()
	step_6 ()
	step_7 ()

Protected Attributes
ilDBInterface	$db

Detailed Description

Author

Alexander Killing killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

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

Member Function Documentation

prepare()

ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps::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 28 of file class.ilMediaObjectsDBUpdateSteps.php.

References ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps\$db.

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

step_1()

ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps::step_1

(

)

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

References ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps\$db, and ilDBInterface\addTableColumn().

                            : void
    {
        $db = $this->db;
        if (!$db->tableColumnExists('media_item', 'duration')) {
            $db->addTableColumn('media_item', 'duration', array(
                "type" => "integer",
                "notnull" => true,
                "length" => 4,
                "default" => 0
            ));
        }
    }

Here is the call graph for this function:

step_2()

ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps::step_2

(

)

Definition at line 46 of file class.ilMediaObjectsDBUpdateSteps.php.

                            : void
    {
        // skipped, since added to ILIAS 8 later
    }

step_3()

ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps::step_3

(

)

Definition at line 51 of file class.ilMediaObjectsDBUpdateSteps.php.

References ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps\$db, and ilDBInterface\queryF().

                            : void
    {
        $db = $this->db;
        $set = $db->queryF(
            "SELECT * FROM settings " .
            " WHERE module = %s AND keyword = %s ",
            ["text", "text"],
            ["mobs", "black_list_file_types"]
        );
        $black_list_str = "";
        while ($rec = $db->fetchAssoc($set)) {
            $black_list_str = $rec["value"] ?? "";
        }
        $black_list = explode(",", $black_list_str);
        $new_black_list = [];
        foreach ($black_list as $type) {
            $type = strtolower(trim($type));
            switch ($type) {
                case "html": $type = "text/html";
                    break;
                case "mp4": $type = "video/mp4";
                    break;
                case "webm": $type = "video/webm";
                    break;
                case "mp3": $type = "audio/mpeg";
                    break;
                case "png": $type = "image/png";
                    break;
                case "jpeg":
                case "jpg": $type = "image/jpeg";
                    break;
                case "gif": $type = "image/gif";
                    break;
                case "webp": $type = "image/webp";
                    break;
                case "svg": $type = "image/svg+xml";
                    break;
                case "pdf": $type = "application/pdf";
                    break;
            }
            if (in_array($type, ["video/vimeo", "video/youtube", "video/mp4", "video/webm", "audio/mpeg",
                                 "image/png", "image/jpeg", "image/gif", "image/webp", "image/svg+xml",
                                 "text/html", "application/pdf"])) {
                if (!in_array($type, $new_black_list)) {
                    $new_black_list[] = $type;
                }
            }
        }
        $db->update(
            "settings",
            [
            "value" => ["text", implode(",", $new_black_list)]
        ],
            [    // where
                "module" => ["text", "mobs"],
                "keyword" => ["text", "black_list_file_types"]
            ]
        );
    }

Here is the call graph for this function:

step_4()

ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps::step_4

(

)

Definition at line 111 of file class.ilMediaObjectsDBUpdateSteps.php.

References ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps\$db, and ilDBInterface\modifyTableColumn().

                            : void
    {
        $db = $this->db;
        $db->modifyTableColumn('map_area', 'coords', ['length' => 4000]);
    }

Here is the call graph for this function:

step_5()

ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps::step_5

(

)

Definition at line 117 of file class.ilMediaObjectsDBUpdateSteps.php.

References ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps\$db, and ilDBInterface\createTable().

                            : void
    {
        $db = $this->db;
        $db->createTable('mob_data', [
            "id" => [
                "type" => "integer",
                "notnull" => true,
                "length" => 4,
                "default" => 0
            ],
            "rid" => [
                'type' => 'text',
                'notnull' => true,
                'length' => 64,
                'default' => ""
            ]
        ]);
    }

Here is the call graph for this function:

step_6()

ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps::step_6

(

)

Definition at line 136 of file class.ilMediaObjectsDBUpdateSteps.php.

References ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps\$db, and ilDBInterface\addPrimaryKey().

                            : void
    {
        $db = $this->db;
        $db->addPrimaryKey("mob_data", ["id"]);
    }

Here is the call graph for this function:

step_7()

ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps::step_7

(

)

Definition at line 142 of file class.ilMediaObjectsDBUpdateSteps.php.

                            : void
    {
        if (!$this->db->indexExistsByFields('media_item', ['mob_id'])) {
            $this->db->addIndex('media_item', ['mob_id'], 'i1');
        }
    }

Field Documentation

$db

ilDBInterface ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps::$db

protected

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

Referenced by ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps\prepare(), ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps\step_1(), ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps\step_3(), ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps\step_4(), ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps\step_5(), and ILIAS\MediaObjects\Setup\ilMediaObjectsDBUpdateSteps\step_6().

---

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

• components/ILIAS/MediaObjects/classes/Setup/class.ilMediaObjectsDBUpdateSteps.php