ilSkillDBUpdateSteps Class Reference

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Inheritance diagram for ilSkillDBUpdateSteps:

Collaboration diagram for ilSkillDBUpdateSteps:

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 ()
	step_8 ()
	step_9 ()
	step_10 ()
	step_11 ()

Protected Attributes
ilDBInterface	$db

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning

Definition at line 22 of file class.ilSkillDBUpdateSteps.php.

Member Function Documentation

prepare()

ilSkillDBUpdateSteps::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 26 of file class.ilSkillDBUpdateSteps.php.

References $db.

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

step_1()

ilSkillDBUpdateSteps::step_1

(

)

Definition at line 31 of file class.ilSkillDBUpdateSteps.php.

                            : void
    {
        if ($this->db->sequenceExists('skl_self_eval')) {
            $this->db->dropSequence('skl_self_eval');
        }

        if ($this->db->tableExists('skl_self_eval')) {
            $this->db->dropTable('skl_self_eval');
        }

        if ($this->db->tableExists('skl_self_eval_level')) {
            $this->db->dropTable('skl_self_eval_level');
        }
    }

step_10()

ilSkillDBUpdateSteps::step_10

(

)

Definition at line 157 of file class.ilSkillDBUpdateSteps.php.

                             : void
    {
        if (!$this->db->tableColumnExists("skl_profile", "image_id")) {
            $this->db->addTableColumn("skl_profile", "image_id", array(
                "type" => "text",
                "notnull" => true,
                "length" => 4000
            ));
        }
    }

step_11()

ilSkillDBUpdateSteps::step_11

(

)

Definition at line 168 of file class.ilSkillDBUpdateSteps.php.

                             : void
    {
        if (!$this->db->tableExists("skl_profile_completion")) {
            $fields = [
                "profile_id" => [
                    "type" => "integer",
                    "length" => 4,
                    "notnull" => true
                ],
                "user_id" => [
                    "type" => "integer",
                    "length" => 4,
                    "notnull" => true
                ],
                "date" => [
                    "type" => "timestamp",
                    "notnull" => true
                ],
                "fulfilled" => [
                    "type" => "integer",
                    "length" => 1,
                    "notnull" => true
                ]
            ];
            $this->db->createTable("skl_profile_completion", $fields);
            $this->db->addPrimaryKey("skl_profile_completion", ["profile_id", "user_id", "date"]);
        }
    }

step_2()

ilSkillDBUpdateSteps::step_2

(

)

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

                            : void
    {
        if (!$this->db->tableColumnExists('skl_user_skill_level', 'trigger_user_id')) {
            $this->db->addTableColumn(
                'skl_user_skill_level',
                'trigger_user_id',
                array(
                    'type' => 'text',
                    'notnull' => true,
                    'length' => 20,
                    'default' => "-"
                )
            );
        }
    }

step_3()

ilSkillDBUpdateSteps::step_3

(

)

Definition at line 62 of file class.ilSkillDBUpdateSteps.php.

                            : void
    {
        if (!$this->db->tableColumnExists('skl_user_has_level', 'trigger_user_id')) {
            $this->db->addTableColumn(
                'skl_user_has_level',
                'trigger_user_id',
                array(
                    'type' => 'text',
                    'notnull' => true,
                    'length' => 20,
                    'default' => "-"
                )
            );
        }
    }

step_4()

ilSkillDBUpdateSteps::step_4

(

)

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

                            : void
    {
        // moved to ilSkillSetupAgent using Objectives
    }

step_5()

ilSkillDBUpdateSteps::step_5

(

)

Definition at line 83 of file class.ilSkillDBUpdateSteps.php.

                            : void
    {
        // moved to ilSkillSetupAgent using Objectives
    }

step_6()

ilSkillDBUpdateSteps::step_6

(

)

Definition at line 88 of file class.ilSkillDBUpdateSteps.php.

                            : void
    {
        $this->db->update(
            "object_data",
            [
                "title" => ["text", "Default"],
                "description" => ["text", ""]
            ],
            [    // where
                 "type" => ["text", "skee"],
                 "title" => ["text", "Skill Tree"]
            ]
        );
    }

step_7()

ilSkillDBUpdateSteps::step_7

(

)

Definition at line 103 of file class.ilSkillDBUpdateSteps.php.

                            : void
    {
        $set = $this->db->queryF(
            "SELECT * FROM object_data " .
            " WHERE type = %s AND title = %s",
            ["string", "string"],
            ["skee", "Default"]
        );
        $rec = $this->db->fetchAssoc($set);

        $this->db->update(
            "skl_tree",
            [
            "skl_tree_id" => ["integer", $rec["obj_id"]]
        ],
            [    // where
                "skl_tree_id" => ["integer", 1]
            ]
        );
    }

step_8()

ilSkillDBUpdateSteps::step_8

(

)

Definition at line 124 of file class.ilSkillDBUpdateSteps.php.

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

step_9()

ilSkillDBUpdateSteps::step_9

(

)

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

                            : void
    {
        $set = $this->db->queryF(
            "SELECT * FROM object_data " .
            " WHERE type = %s AND title = %s",
            ["string", "string"],
            ["skee", "Default"]
        );
        $rec = $this->db->fetchAssoc($set);

        $this->db->update(
            "skl_profile",
            [
            "skill_tree_id" => ["integer", $rec["obj_id"]]
        ],
            [    // where
                "skill_tree_id" => ["integer", 0]
            ]
        );
    }

Field Documentation

$db

ilDBInterface ilSkillDBUpdateSteps::$db

protected

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

Referenced by prepare().

---

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

• Services/Skill/classes/Setup/class.ilSkillDBUpdateSteps.php