Inheritance diagram for ILIAS\Wiki\Setup\ilWikiDBUpdateSteps:

Collaboration diagram for ILIAS\Wiki\Setup\ilWikiDBUpdateSteps:

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

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

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

Member Function Documentation

◆ prepare()

ILIAS\Wiki\Setup\ilWikiDBUpdateSteps::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.ilWikiDBUpdateSteps.php.

References ILIAS\Wiki\Setup\ilWikiDBUpdateSteps\$db.

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

◆ step_1()

ILIAS\Wiki\Setup\ilWikiDBUpdateSteps::step_1 ( )

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

References ILIAS\Wiki\Setup\ilWikiDBUpdateSteps\$db, and ilDBInterface\modifyTableColumn().

                             : void
     {
         $db = $this->db;
         foreach (["int_links", "ext_links", "footnotes", "num_ratings", "num_words", "avg_rating", "deleted"] as $field) {
             $db->modifyTableColumn('wiki_stat_page', $field, array(
                 'type' => 'integer',
                 'length' => 4,
                 'notnull' => true,
                 'default' => 0
             ));
         }
     }

Here is the call graph for this function:

◆ step_2()

ILIAS\Wiki\Setup\ilWikiDBUpdateSteps::step_2 ( )

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

References ILIAS\Wiki\Setup\ilWikiDBUpdateSteps\$db, and ilDBInterface\modifyTableColumn().

                             : void
     {
         $db = $this->db;
         foreach (["num_chars"] as $field) {
             $db->modifyTableColumn('wiki_stat_page', $field, array(
                 'type' => 'integer',
                 'length' => 8,
                 'notnull' => true,
                 'default' => 0
             ));
         }
     }

Here is the call graph for this function:

◆ step_3()

ILIAS\Wiki\Setup\ilWikiDBUpdateSteps::step_3 ( )

Definition at line 59 of file class.ilWikiDBUpdateSteps.php.

References ILIAS\Wiki\Setup\ilWikiDBUpdateSteps\$db, and ilDBInterface\modifyTableColumn().

                             : void
     {
         $db = $this->db;
         foreach (["num_pages", "del_pages", "avg_rating"] as $field) {
             $db->modifyTableColumn('wiki_stat', $field, array(
                 'type' => 'integer',
                 'length' => 4,
                 'notnull' => true,
                 'default' => 0
             ));
         }
     }

Here is the call graph for this function:

◆ step_4()

ILIAS\Wiki\Setup\ilWikiDBUpdateSteps::step_4 ( )

Definition at line 72 of file class.ilWikiDBUpdateSteps.php.

References ILIAS\Wiki\Setup\ilWikiDBUpdateSteps\$db, and ilDBInterface\addTableColumn().

                             : void
     {
         $db = $this->db;
         if (!$db->tableColumnExists('il_wiki_page', 'lang')) {
             $this->db->addTableColumn('il_wiki_page', 'lang', array(
                 'type' => 'text',
                 'notnull' => true,
                 'length' => 10,
                 'default' => "-"
             ));
             $this->db->dropPrimaryKey('il_wiki_page');
             $this->db->addPrimaryKey(
                 'il_wiki_page',
                 ["id", "lang"]
             );
         }
     }

Here is the call graph for this function:

◆ step_5()

ILIAS\Wiki\Setup\ilWikiDBUpdateSteps::step_5 ( )

Definition at line 90 of file class.ilWikiDBUpdateSteps.php.

References ILIAS\Wiki\Setup\ilWikiDBUpdateSteps\$db, and ilDBInterface\addTableColumn().

                             : void
     {
         $db = $this->db;
         if (!$db->tableColumnExists('il_wiki_missing_page', 'lang')) {
             $this->db->addTableColumn('il_wiki_missing_page', 'lang', array(
                 'type' => 'text',
                 'notnull' => true,
                 'length' => 5,
                 'default' => "-"
             ));
             $this->db->dropPrimaryKey('il_wiki_missing_page');
             $this->db->addPrimaryKey(
                 'il_wiki_missing_page',
                 ["wiki_id", "source_id", "target_name", "lang"]
             );
         }
     }

Here is the call graph for this function:

◆ step_6()

ILIAS\Wiki\Setup\ilWikiDBUpdateSteps::step_6 ( )

Definition at line 108 of file class.ilWikiDBUpdateSteps.php.

References ILIAS\Wiki\Setup\ilWikiDBUpdateSteps\$db, and ilDBInterface\queryF().

                             : void
     {
         $db = $this->db;
         $set = $db->queryF(
             "SELECT * FROM il_wiki_data " .
             " WHERE public_notes = %s ",
             ["integer"],
             [1]
         );
         while ($rec = $db->fetchAssoc($set)) {
             $set2 = $db->queryF(
                 "SELECT * FROM note_settings " .
                 " WHERE rep_obj_id = %s AND obj_id = %s",
                 ["integer", "integer"],
                 [$rec["id"], 0]
             );
             if ($rec2 = $db->fetchAssoc($set2)) {
                 $db->update(
                     "note_settings",
                     [
                     "activated" => ["integer", 1]
                 ],
                     [    // where
                         "rep_obj_id" => ["integer", $rec["id"]],
                         "obj_id" => ["integer", 0]
                     ]
                 );
             } else {
                 $db->insert("note_settings", [
                     "rep_obj_id" => ["integer", $rec["id"]],
                     "obj_id" => ["integer", 0],
                     "activated" => ["integer", 1],
                     "obj_type" => ["text", "wiki"]
                 ]);
             }
         }
 
     }