Inheritance diagram for ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps:

Collaboration diagram for ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps:

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 ()

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

Protected Attributes
ilDBInterface	$db

Private Member Functions
	useTransaction (callable $updateStep)

Detailed Description

Author: Nicolas Schaefli nick@.nosp@m.flux.nosp@m.labs..nosp@m.ch

Definition at line 26 of file class.ilEmployeeTalkDBUpdateSteps.php.

Member Function Documentation

◆ prepare()

ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps::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 30 of file class.ilEmployeeTalkDBUpdateSteps.php.

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

References ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps\$db.

◆ step_1()

ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps::step_1 ( )

Definition at line 54 of file class.ilEmployeeTalkDBUpdateSteps.php.

                            : void
    {
        // removed this content in favour of a ilTreeAdminNodeAddedObjective
    }

◆ step_2()

ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps::step_2 ( )

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

                            : void
    {
        $this->useTransaction(function (\ilDBInterface $db) {
            $etalTableName = 'etal_data';
 
            if (!$db->tableExists($etalTableName)) {
                $db->createTable($etalTableName, [
                    'object_id' => ['type' => 'integer', 'length' => 8, 'notnull' => true],
                    'series_id' => ['type' => 'text', 'length' => 36, 'notnull' => true, 'fixed' => true],
                    'start_date' => ['type' => 'integer', 'length' => 8, 'notnull' => true],
                    'end_date' => ['type' => 'integer', 'length' => 8, 'notnull' => true],
                    'all_day' => ['type' => 'integer', 'length' => 1, 'notnull' => true],
                    'employee' => ['type' => 'integer', 'length' => 8, 'notnull' => true],
                    'location' => ['type' => 'text', 'length' => 200, 'notnull' => false, 'fixed' => false],
                    'completed' => ['type' => 'integer', 'length' => 1, 'notnull' => true]
                ]);
 
                $db->addPrimaryKey($etalTableName, ['object_id']);
                $db->addIndex($etalTableName, ['series_id'], 'ser');
                $db->addIndex($etalTableName, ['employee'], 'emp');
            }
        });
    }

References ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps\$db, ilDBInterface\tableExists(), and ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps\useTransaction().

Here is the call graph for this function:

◆ step_3()

ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps::step_3 ( )

Definition at line 83 of file class.ilEmployeeTalkDBUpdateSteps.php.

                            : void
    {
        $this->useTransaction(function (\ilDBInterface $db) {
            $etalTableName = 'etal_data';
 
            if (!$db->tableColumnExists($etalTableName, 'standalone_date')) {
                $db->addTableColumn(
                    $etalTableName,
                    'standalone_date',
                    [
                        'type' => 'integer',
                        'length' => 1,
                        'notnull' => true,
                        'default' => 0
                    ]
                );
            }
        });
    }

References ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps\$db, ilDBInterface\tableColumnExists(), and ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps\useTransaction().

Here is the call graph for this function:

◆ step_4()

ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps::step_4 ( )

Definition at line 103 of file class.ilEmployeeTalkDBUpdateSteps.php.

                            : void
    {
        // replaced by OrgUnit objectives
    }

◆ step_5()

ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps::step_5 ( )

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

                            : void
    {
        $this->useTransaction(function (\ilDBInterface $db) {
            $table_name = 'etal_serie';
 
            if (!$db->tableExists($table_name)) {
                $db->createTable($table_name, [
                    'id' => ['type' => 'integer', 'length' => 8, 'notnull' => true],
                    'editing_locked' => ['type' => 'integer', 'length' => 1, 'notnull' => true],
                ]);
 
                $db->addPrimaryKey($table_name, ['id']);
            }
        });
    }

References ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps\$db, ilDBInterface\tableExists(), and ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps\useTransaction().

Here is the call graph for this function:

◆ step_6()

ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps::step_6 ( )

Definition at line 124 of file class.ilEmployeeTalkDBUpdateSteps.php.

                            : void
    {
        $this->useTransaction(function (\ilDBInterface $db) {
            $table_name = 'etal_data';
            $column_name = 'template_id';
 
            if (!$db->tableColumnExists($table_name, $column_name)) {
                $db->addTableColumn(
                    $table_name,
                    $column_name,
                    [
                        'type' => 'integer',
                        'length' => 8,
                        'notnull' => true,
                        'default' => 0
                    ]
                );
            }
        });
    }

References ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps\$db, ilDBInterface\tableColumnExists(), and ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps\useTransaction().

Here is the call graph for this function:

◆ useTransaction()

ILIAS\EmployeeTalk\Setup\ilEmployeeTalkDBUpdateSteps::useTransaction ( callable $updateStep )

private

Definition at line 35 of file class.ilEmployeeTalkDBUpdateSteps.php.

                                                         : void
    {
        try {
            if ($this->db->supportsTransactions()) {
                $this->db->beginTransaction();
            }
            $updateStep($this->db);
 
            if ($this->db->supportsTransactions()) {
                $this->db->commit();
            }
        } catch (\Exception $exception) {
            if ($this->db->supportsTransactions()) {
                $this->db->rollback();
            }
            throw $exception;
        }
    }