ilCalendarDBUpdateSteps9 Class Reference

Inheritance diagram for ilCalendarDBUpdateSteps9:

Collaboration diagram for ilCalendarDBUpdateSteps9:

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

Protected Attributes
ilDBInterface	$db

Detailed Description

Author

Tim Schmitz schmi.nosp@m.tz@l.nosp@m.eifos.nosp@m..de

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

Member Function Documentation

prepare()

ilCalendarDBUpdateSteps9::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 27 of file class.ilCalendarDBUpdateSteps9.php.

References $db.

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

step_1()

ilCalendarDBUpdateSteps9::step_1

(

)

Definition at line 32 of file class.ilCalendarDBUpdateSteps9.php.

                            : void
    {
        // Add indices
        if (!$this->db->indexExistsByFields('cal_entries', ['starta'])) {
            $this->db->addIndex('cal_entries', ['starta'], 'i3');
        }
        if (!$this->db->indexExistsByFields('cal_entries', ['enda'])) {
            $this->db->addIndex('cal_entries', ['enda'], 'i4');
        }
    }

step_2()

ilCalendarDBUpdateSteps9::step_2

(

)

Definition at line 43 of file class.ilCalendarDBUpdateSteps9.php.

References ilDBConstants\T_TEXT.

                            : void
    {
        // Removes is_milestones column from cal_entries
        if($this->db->tableExists('cal_entries')
            && $this->db->tableColumnExists('cal_entries', 'is_milestone')) {
            $this->db->dropTableColumn('cal_entries', 'is_milestone');
        }
        // Removes completion column from cal_entries
        if($this->db->tableExists('cal_entries')
            && $this->db->tableColumnExists('cal_entries', 'completion')) {
            $this->db->dropTableColumn('cal_entries', 'completion');
        }
        // Deletes table cal_entry_responsible
        if($this->db->tableExists('cal_entry_responsible')) {
            $this->db->dropTable('cal_entry_responsible');
        }

        $query = 'delete from settings where ' .
            'keyword = ' . $this->db->quote('enable_grp_milestones', ilDBConstants::T_TEXT) . ' ' .
            'and module = ' . $this->db->quote('calendar', ilDBConstants::T_TEXT);
        $this->db->manipulate($query);
    }

Field Documentation

$db

ilDBInterface ilCalendarDBUpdateSteps9::$db

protected

Definition at line 25 of file class.ilCalendarDBUpdateSteps9.php.

Referenced by prepare().

---

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

• components/ILIAS/Calendar/classes/Setup/class.ilCalendarDBUpdateSteps9.php