ILIAS  trunk Revision v12.0_alpha-16-g3e876e53c80
ILIAS\Test\Setup\MoveTestSettingsMigration Class Reference
+ Inheritance diagram for ILIAS\Test\Setup\MoveTestSettingsMigration:
+ Collaboration diagram for ILIAS\Test\Setup\MoveTestSettingsMigration:

Public Member Functions

 getLabel ()
 
 getDefaultAmountOfStepsPerRun ()
 Tell the default amount of steps to be executed for one run of the migration. More...
 
 getPreconditions (Environment $environment)
 Objectives the migration depend on. More...
 
 prepare (Environment $environment)
 Prepare the migration by means of some environment. More...
 
 step (Environment $environment)
 Run one step of the migration. More...
 
 getRemainingAmountOfSteps ()
 Count up how many "things" need to be migrated. More...
 
 getLabel ()
 
 getDefaultAmountOfStepsPerRun ()
 Tell the default amount of steps to be executed for one run of the migration. More...
 
 getPreconditions (Environment $environment)
 Objectives the migration depend on. More...
 
 prepare (Environment $environment)
 Prepare the migration by means of some environment. More...
 
 step (Environment $environment)
 Run one step of the migration. More...
 
 getRemainingAmountOfSteps ()
 Count up how many "things" need to be migrated. More...
 

Private Attributes

ilDBInterface $db
 

Additional Inherited Members

- Data Fields inherited from ILIAS\Setup\Migration
const INFINITE = -1
 

Detailed Description

Definition at line 27 of file MoveTestSettingsMigration.php.

Member Function Documentation

◆ getDefaultAmountOfStepsPerRun()

ILIAS\Test\Setup\MoveTestSettingsMigration::getDefaultAmountOfStepsPerRun ( )

Tell the default amount of steps to be executed for one run of the migration.

Return Migration::INFINITE if all units should be migrated at once.

Implements ILIAS\Setup\Migration.

Definition at line 38 of file MoveTestSettingsMigration.php.

38 : int
39 {
40 return 100;
41 }

◆ getLabel()

ILIAS\Test\Setup\MoveTestSettingsMigration::getLabel ( )
Returns
string - a meaningful and concise description for your migration.

Implements ILIAS\Setup\Migration.

Definition at line 33 of file MoveTestSettingsMigration.php.

33 : string
34 {
35 return 'Migrate test settings from tst_tests to tst_test_settings';
36 }

◆ getPreconditions()

ILIAS\Test\Setup\MoveTestSettingsMigration::getPreconditions ( Environment  $environment)

Objectives the migration depend on.

Exceptions
UnachievableExceptionif the objective is not achievable
Returns
Objective[]

Implements ILIAS\Setup\Migration.

Definition at line 43 of file MoveTestSettingsMigration.php.

43 : array
44 {
45 return [new \ilDatabaseInitializedObjective()];
46 }

◆ getRemainingAmountOfSteps()

ILIAS\Test\Setup\MoveTestSettingsMigration::getRemainingAmountOfSteps ( )

Count up how many "things" need to be migrated.

This helps the admin to decide how big he can create the steps and also how long a migration takes

Implements ILIAS\Setup\Migration.

Definition at line 88 of file MoveTestSettingsMigration.php.

88 : int
89 {
90 $result = $this->db->query("SELECT COUNT(test_id) AS cnt FROM tst_tests WHERE settings_id IS NULL");
91 return (int) $this->db->fetchObject($result)->cnt;
92 }

◆ prepare()

ILIAS\Test\Setup\MoveTestSettingsMigration::prepare ( Environment  $environment)

Prepare the migration by means of some environment.

This is not supposed to modify the environment, but will be run to prime the migration object to run step and getRemainingAmountOfSteps afterwards.

Implements ILIAS\Setup\Migration.

Definition at line 48 of file MoveTestSettingsMigration.php.

48 : void
49 {
50 $this->db = $environment->getResource(Setup\Environment::RESOURCE_DATABASE);
51 }

References ILIAS\Setup\Environment\getResource(), and ILIAS\Setup\Environment\RESOURCE_DATABASE.

+ Here is the call graph for this function:

◆ step()

ILIAS\Test\Setup\MoveTestSettingsMigration::step ( Environment  $environment)

Run one step of the migration.

Implements ILIAS\Setup\Migration.

Definition at line 53 of file MoveTestSettingsMigration.php.

53 : void
54 {
55 $columns = implode(',', array_keys(self::SETTINGS_COLUMNS));
56 $row = $this->db->fetchAssoc(
57 $this->db->query("SELECT test_id, {$columns} FROM tst_tests WHERE settings_id IS NULL LIMIT 1")
58 );
59
60 $settings_id = $this->db->nextId('tst_test_settings');
61 $setting_data = ['id' => [\ilDBConstants::T_INTEGER, $settings_id]];
62
63 foreach ($row as $column_name => $value) {
64 if (isset(self::SETTINGS_COLUMNS[$column_name])) {
65 [$column_def] = self::SETTINGS_COLUMNS[$column_name];
66
67 if ($column_name === 'reporting_date') {
68 $value = $this->convertLegacyDate($value);
69 }
70
71 // Convert legacy null values to 0
72 if ($column_def['type'] === \ilDBConstants::T_INTEGER && !$this->columnIsNullable($column_def)) {
73 $value = (int) $value;
74 }
75
76 $setting_data[$column_name] = [$column_def['type'], $value];
77 }
78 }
79
80 $this->db->insert('tst_test_settings', $setting_data);
81 $this->db->update(
82 'tst_tests',
83 ['settings_id' => [\ilDBConstants::T_INTEGER, $settings_id]],
84 ['test_id' => [\ilDBConstants::T_INTEGER, $row['test_id']]]
85 );
86 }
columnIsNullable(array $column_def)
convertLegacyDate(string|\DateTimeImmutable|null $date)

References ILIAS\Test\Setup\columnIsNullable(), ILIAS\Test\Setup\convertLegacyDate(), ILIAS\Repository\int(), and ilDBConstants\T_INTEGER.

+ Here is the call graph for this function:

Field Documentation

◆ $db

ilDBInterface ILIAS\Test\Setup\MoveTestSettingsMigration::$db
private

Definition at line 31 of file MoveTestSettingsMigration.php.


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