ilGlossaryDBUpdateSteps 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 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 ()

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

References $db.

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

step_1()

ilGlossaryDBUpdateSteps::step_1

(

)

Definition at line 31 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 51 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 63 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 101 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 133 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 154 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 24 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