ilStudyProgrammeProgressTableUpdateSteps 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 ilStudyProgrammeProgressTableUpdateSteps:

Collaboration diagram for ilStudyProgrammeProgressTableUpdateSteps:

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

Protected Attributes
ilDBInterface	$db

Private Attributes
const	TABLE_NAME = 'prg_usr_progress'

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 21 of file ilStudyProgrammeProgressTableUpdateSteps.php.

Member Function Documentation

prepare()

ilStudyProgrammeProgressTableUpdateSteps::prepare

(

ilDBInterface

$db

)

Definition at line 27 of file ilStudyProgrammeProgressTableUpdateSteps.php.

References $db.

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

step_1()

ilStudyProgrammeProgressTableUpdateSteps::step_1

(

)

Definition at line 32 of file ilStudyProgrammeProgressTableUpdateSteps.php.

References $query.

                            : void
    {
        $column_name = 'individual';

        if (!$this->db->tableColumnExists(self::TABLE_NAME, $column_name)) {
            $this->db->addTableColumn(
                self::TABLE_NAME,
                $column_name,
                [
                    "type" => "integer",
                    "length" => 1,
                    "notnull" => true,
                    "default" => 0
                ]
            );
            $query = 'UPDATE ' . self::TABLE_NAME
                . ' SET ' . $column_name . ' = 1'
                . ' WHERE last_change_by IS NOT NULL';
            $this->db->manipulate($query);
        }
    }

step_2()

ilStudyProgrammeProgressTableUpdateSteps::step_2

(

)

Definition at line 54 of file ilStudyProgrammeProgressTableUpdateSteps.php.

                            : void
    {
        $old = "risky_to_fail_mail_send";
        $new = "sent_mail_risky_to_fail";

        if ($this->db->tableColumnExists(self::TABLE_NAME, $old) && !$this->db->tableColumnExists(self::TABLE_NAME, $new)) {
            $this->db->renameTableColumn(self::TABLE_NAME, $old, $new);
        }
    }

step_3()

ilStudyProgrammeProgressTableUpdateSteps::step_3

(

)

Definition at line 64 of file ilStudyProgrammeProgressTableUpdateSteps.php.

                            : void
    {
        $column_name = 'sent_mail_expires';

        if (!$this->db->tableColumnExists(self::TABLE_NAME, $column_name)) {
            $this->db->addTableColumn(
                self::TABLE_NAME,
                $column_name,
                [
                    "type" => "timestamp",
                    "notnull" => false
                ]
            );
        }
    }

Field Documentation

$db

ilDBInterface ilStudyProgrammeProgressTableUpdateSteps::$db

protected

Definition at line 25 of file ilStudyProgrammeProgressTableUpdateSteps.php.

Referenced by prepare().

TABLE_NAME

const ilStudyProgrammeProgressTableUpdateSteps::TABLE_NAME = 'prg_usr_progress'

private

Definition at line 23 of file ilStudyProgrammeProgressTableUpdateSteps.php.

---

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

• Modules/StudyProgramme/classes/Setup/ilStudyProgrammeProgressTableUpdateSteps.php