ilSkillDBUpdateSteps Class Reference

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

Definition at line 21 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 25 of file class.ilSkillDBUpdateSteps.php.

References $db.

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

step_1()

ilSkillDBUpdateSteps::step_1

(

)

Definition at line 30 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 156 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 167 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 45 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 61 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 77 of file class.ilSkillDBUpdateSteps.php.

                            : void
    {
        // moved to ilSkillSetupAgent using Objectives
    }

step_5()

ilSkillDBUpdateSteps::step_5

(

)

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

                            : void
    {
        // moved to ilSkillSetupAgent using Objectives
    }

step_6()

ilSkillDBUpdateSteps::step_6

(

)

Definition at line 87 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 102 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 123 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 135 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 23 of file class.ilSkillDBUpdateSteps.php.

Referenced by prepare().

---

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

• components/ILIAS/Skill/classes/Setup/class.ilSkillDBUpdateSteps.php