ilSeparateQuestionListSettingMigration.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\Test\Setup;

use ILIAS\Setup;
use ILIAS\Setup\Environment;
use ilDatabaseInitializedObjective;
use ilDatabaseUpdatedObjective;
use ilDBInterface;
use Exception;
use ILIAS\Setup\CLI\IOWrapper;

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

    private mixed $io;

    public function getLabel(): string
    {
        return "Update QuestionList Settings";
    }

    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
    {
        $result = $this->db->manipulate(
            'UPDATE tst_tests SET show_questionlist = 1 WHERE usr_pass_overview_mode > 0 AND show_questionlist IS NULL LIMIT 1'
        );

        if ($result === 0) {
            $this->db->manipulate(
                'UPDATE tst_tests SET show_questionlist = 0 WHERE usr_pass_overview_mode = 0 AND show_questionlist IS NULL LIMIT 1'
            );
        }
    }

    public function getRemainingAmountOfSteps(): int
    {
        $result = $this->db->query(
            "SELECT count(*) as cnt FROM tst_tests WHERE show_questionlist is NULL"
        );
        $row = $this->db->fetchAssoc($result);

        return (int) $row['cnt'] ?? 0;
    }
}