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 32 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 36 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 60 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 65 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 89 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 109 of file class.ilEmployeeTalkDBUpdateSteps.php.

                            : void
    {
        // replaced by OrgUnit objectives
    }

◆ step_5()

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

Definition at line 114 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 130 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 41 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;
        }
    }