Inheritance diagram for ILIAS\COPage\Setup\ilCOPageDBUpdateSteps:

Collaboration diagram for ILIAS\COPage\Setup\ilCOPageDBUpdateSteps:

Public Member Functions
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

	step_1 ()

	step_2 ()

	step_3 ()

	step_4 ()

	step_5 ()

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.ilCOPageDBUpdateSteps.php.

Member Function Documentation

◆ prepare()

ILIAS\COPage\Setup\ilCOPageDBUpdateSteps::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.ilCOPageDBUpdateSteps.php.

References ILIAS\COPage\Setup\ilCOPageDBUpdateSteps\$db.

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

◆ step_1()

ILIAS\COPage\Setup\ilCOPageDBUpdateSteps::step_1 ( )

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

                             : void
     {
         $field = array(
             'type' => 'integer',
             'length' => 2,
             'notnull' => true,
             'default' => 0
         );
 
         $this->db->modifyTableColumn("copg_pc_def", "order_nr", $field);
     }

◆ step_2()

ILIAS\COPage\Setup\ilCOPageDBUpdateSteps::step_2 ( )

Definition at line 45 of file class.ilCOPageDBUpdateSteps.php.

                             : void
     {
         $field = array(
             'type' => 'integer',
             'length' => 4,
             'notnull' => true,
             'default' => 0
         );
 
         $this->db->modifyTableColumn("copg_pc_def", "order_nr", $field);
     }

◆ step_3()

ILIAS\COPage\Setup\ilCOPageDBUpdateSteps::step_3 ( )

Definition at line 57 of file class.ilCOPageDBUpdateSteps.php.

                             : void
     {
         $this->db->update(
             "page_layout",
             [
             "title" => ["text", "Text page with accompanying media"]
         ],
             [    // where
                 "title" => ["text", "1A Simple text page with accompanying media"]
             ]
         );
         $this->db->update(
             "page_layout",
             [
             "title" => ["text", "Text page with accompanying media and test"]
         ],
             [    // where
                 "title" => ["text", "1C Text page with accompanying media and test"]
             ]
         );
         $this->db->update(
             "page_layout",
             [
             "title" => ["text", "Text page with accompanying media followed by test and text"]
         ],
             [    // where
                 "title" => ["text", "1E Text page with accompanying media followed by test and text"]
             ]
         );
         $this->db->update(
             "page_layout",
             [
             "title" => ["text", "Media page with accompanying text and test"]
         ],
             [    // where
                 "title" => ["text", "2C Simple media page with accompanying text and test"]
             ]
         );
         $this->db->update(
             "page_layout",
             [
             "title" => ["text", "Vertical component navigation page with media and text "]
         ],
             [    // where
                 "title" => ["text", "7C Vertical component navigation page with media and text"]
             ]
         );
     }

◆ step_4()

ILIAS\COPage\Setup\ilCOPageDBUpdateSteps::step_4 ( )

Definition at line 106 of file class.ilCOPageDBUpdateSteps.php.

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

◆ step_5()

ILIAS\COPage\Setup\ilCOPageDBUpdateSteps::step_5 ( )

Definition at line 118 of file class.ilCOPageDBUpdateSteps.php.

                             : void
     {
         $set = $this->db->queryF(
             "SELECT content FROM page_object " .
             " WHERE page_id = %s AND parent_type = %s AND lang = %s",
             ["integer", "text", "text"],
             [5, "stys", "-"]
         );
         while ($rec = $this->db->fetchAssoc($set)) {
             $content = $rec["content"];
 
             $replacements = [
                 ["a4e417c08feebeafb1487e60a2e245a4", "a4e417c08feebeafb1487e60a2e245a5"],
                 ["a4e417c08feebeafb1487e60a2e245a4", "a4e417c08feebeafb1487e60a2e245a6"],
                 ["a4e417c08feebeafb1487e60a2e245a5", "a4e417c08feebeafb1487e60a2e245a7"],
                 ["a4e417c08feebeafb1487e60a2e245a5", "a4e417c08feebeafb1487e60a2e245a8"]
             ];
 
             foreach ($replacements as $r) {
                 $content = preg_replace('/' . $r[0] . '/', $r[1], $content, 1);
             }
 
             $this->db->update(
                 "page_object",
                 [
                 "content" => ["clob", $content]
             ],
                 [    // where
                     "page_id" => ["integer", 5],
                     "parent_type" => ["text", "stys"],
                     "lang" => ["text", '-'],
                 ]
             );
         }
     }