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

Collaboration diagram for ilStudyProgrammeAssignmentTableUpdateSteps:

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

Data Fields
const	TABLE_NAME = 'prg_usr_assignments'

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

Member Function Documentation

prepare()

ilStudyProgrammeAssignmentTableUpdateSteps::prepare

(

ilDBInterface

$db

)

Definition at line 27 of file ilStudyProgrammeAssignmentTableUpdateSteps.php.

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

References $db.

step_1()

ilStudyProgrammeAssignmentTableUpdateSteps::step_1

(

)

Definition at line 32 of file ilStudyProgrammeAssignmentTableUpdateSteps.php.

                            : void
    {
        $column_name = 'assigned_manually';
 
        if (!$this->db->tableColumnExists(self::TABLE_NAME, $column_name)) {
            $this->db->addTableColumn(
                self::TABLE_NAME,
                $column_name,
                [
                    'type' => 'integer',
                    'length' => 1,
                    'default' => 0,
                    'notnull' => false
                ]
            );
        }
 
        $query = 'UPDATE ' . self::TABLE_NAME
            . ' JOIN object_data ON last_change_by = object_data.obj_id'
            . ' SET ' . $column_name . ' = 1'
            . ' WHERE type = "usr";'
        ;
        $this->db->manipulate($query);
    }

References $query.

Field Documentation

$db

ilDBInterface ilStudyProgrammeAssignmentTableUpdateSteps::$db

protected

Definition at line 25 of file ilStudyProgrammeAssignmentTableUpdateSteps.php.

Referenced by prepare().

TABLE_NAME

const ilStudyProgrammeAssignmentTableUpdateSteps::TABLE_NAME = 'prg_usr_assignments'

Definition at line 23 of file ilStudyProgrammeAssignmentTableUpdateSteps.php.

---

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

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