ilGlossaryDBUpdateSteps Class Reference

Inheritance diagram for ilGlossaryDBUpdateSteps:

Collaboration diagram for ilGlossaryDBUpdateSteps:

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 ()
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 21 of file class.ilGlossaryDBUpdateSteps.php.

Member Function Documentation

prepare()

ilGlossaryDBUpdateSteps::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.ilGlossaryDBUpdateSteps.php.

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

References $db.

step_1()

ilGlossaryDBUpdateSteps::step_1

(

)

Definition at line 30 of file class.ilGlossaryDBUpdateSteps.php.

                            : void
    {
        if (!$this->db->tableColumnExists("glossary_term", "short_text")) {
            $this->db->addTableColumn("glossary_term", "short_text", [
                "type" => "text",
                "length" => 4000,
                "notnull" => false
            ]);
        }
 
        if (!$this->db->tableColumnExists("glossary_term", "short_text_dirty")) {
            $this->db->addTableColumn("glossary_term", "short_text_dirty", [
                "type" => "integer",
                "notnull" => true,
                "length" => 4,
                "default" => 0
            ]);
        }
    }

step_2()

ilGlossaryDBUpdateSteps::step_2

(

)

Definition at line 50 of file class.ilGlossaryDBUpdateSteps.php.

                            : void
    {
        if (!$this->db->tableColumnExists("glossary_definition", "migration")) {
            $this->db->addTableColumn("glossary_definition", "migration", [
                "type" => "integer",
                "notnull" => true,
                "length" => 4,
                "default" => 0
            ]);
        }
    }

step_3()

ilGlossaryDBUpdateSteps::step_3

(

)

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

                            : void
    {
        if (!$this->db->tableExists('glo_flashcard_term')) {
            $fields = [
                'term_id' => [
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true,
                    'default' => 0
                ],
                'user_id' => [
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true,
                    'default' => 0
                ],
                'glo_id' => [
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true,
                    'default' => 0
                ],
                'last_access' => [
                    'type' => 'timestamp',
                    'notnull' => false
                ],
                'box_nr' => [
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true,
                    'default' => 0
                ]
            ];
            $this->db->createTable("glo_flashcard_term", $fields);
            $this->db->addPrimaryKey("glo_flashcard_term", ["term_id", "user_id", "glo_id"]);
        }
    }

step_4()

ilGlossaryDBUpdateSteps::step_4

(

)

Definition at line 100 of file class.ilGlossaryDBUpdateSteps.php.

                            : void
    {
        if (!$this->db->tableExists('glo_flashcard_box')) {
            $fields = [
                'box_nr' => [
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true,
                    'default' => 0
                ],
                'user_id' => [
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true,
                    'default' => 0
                ],
                'glo_id' => [
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true,
                    'default' => 0
                ],
                'last_access' => [
                    'type' => 'timestamp',
                    'notnull' => false
                ]
            ];
            $this->db->createTable("glo_flashcard_box", $fields);
            $this->db->addPrimaryKey("glo_flashcard_box", ["box_nr", "user_id", "glo_id"]);
        }
    }

step_5()

ilGlossaryDBUpdateSteps::step_5

(

)

Definition at line 132 of file class.ilGlossaryDBUpdateSteps.php.

                            : void
    {
        if (!$this->db->tableColumnExists("glossary", "flash_active")) {
            $this->db->addTableColumn("glossary", "flash_active", [
                "type" => "text",
                "notnull" => true,
                "length" => 1,
                "default" => "n"
            ]);
        }
 
        if (!$this->db->tableColumnExists("glossary", "flash_mode")) {
            $this->db->addTableColumn("glossary", "flash_mode", [
                "type" => "text",
                "notnull" => true,
                "length" => 10,
                "default" => "term"
            ]);
        }
    }

step_6()

ilGlossaryDBUpdateSteps::step_6

(

)

Definition at line 153 of file class.ilGlossaryDBUpdateSteps.php.

                            : void
    {
        if (!$this->db->tableExists('glossary_collection')) {
            $fields = [
                'id' => [
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true,
                    'default' => 0
                ],
                'glo_id' => [
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true,
                    'default' => 0
                ]
            ];
            $this->db->createTable("glossary_collection", $fields);
            $this->db->addPrimaryKey("glossary_collection", ["id", "glo_id"]);
        }
    }

Field Documentation

$db

ilDBInterface ilGlossaryDBUpdateSteps::$db

protected

Definition at line 23 of file class.ilGlossaryDBUpdateSteps.php.

Referenced by prepare().

---

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

• components/ILIAS/Glossary/classes/Setup/class.ilGlossaryDBUpdateSteps.php