class.PRGUpdateRestartedSourceMigration.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

use ILIAS\Setup;
use ILIAS\Setup\Environment;
use ILIAS\Setup\CLI\IOWrapper;

class PRGUpdateRestartedSourceMigration implements Setup\Migration
{
    private const DEFAULT_AMOUNT_OF_STEPS = 1;
    private ilDBInterface $db;

    private mixed $io;

    public function getLabel(): string
    {
        return "Update 'Assigned By' for restarted assignments";
    }

    public function getDefaultAmountOfStepsPerRun(): int
    {
        return self::DEFAULT_AMOUNT_OF_STEPS;
    }

    public function getPreconditions(Environment $environment): array
    {
        return [
            new ilDatabaseInitializedObjective(),
            new ilDatabaseUpdatedObjective()
        ];
    }

    public function prepare(Environment $environment): void
    {
        $this->db = $environment->getResource(Setup\Environment::RESOURCE_DATABASE);
    }

    public function step(Environment $environment): void
    {
        $query = "UPDATE prg_usr_assignments SET last_change_by = " . ilPRGAssignment::AUTO_ASSIGNED_BY_RESTART . PHP_EOL
            . "WHERE id in (SELECT restarted_assignment_id FROM prg_usr_assignments WHERE restarted_assignment_id != -1)" . PHP_EOL
            . "AND restarted_assignment_id NOT IN (SELECT id FROM prg_usr_assignments WHERE last_change_by = " . ilPRGAssignment::AUTO_ASSIGNED_BY_RESTART . ")";
        $this->db->manipulate($query);
    }

    public function getRemainingAmountOfSteps(): int
    {
        $query = "SELECT count(restarted_assignment_id) AS cnt FROM prg_usr_assignments" . PHP_EOL
            . " WHERE restarted_assignment_id != -1" . PHP_EOL
            . "AND restarted_assignment_id NOT IN (SELECT id FROM prg_usr_assignments WHERE last_change_by = " . ilPRGAssignment::AUTO_ASSIGNED_BY_RESTART . ");";

        $result = $this->db->query($query);
        $row = $this->db->fetchAssoc($result);
        return (int) $row['cnt'] > 0 ? 1 : 0;
    }
}