SelectOptionsMigration.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\AdvancedMetaData\Setup;

use ILIAS\Setup;
use ILIAS\Setup\Environment;
use ILIAS\Setup\Migration;

class SelectOptionsMigration implements Setup\Migration
{
    protected \ilDBInterface $db;

    public function getLabel(): string
    {
        return "Grants each select option a permanent ID.";
    }

    public function getDefaultAmountOfStepsPerRun(): int
    {
        return Migration::INFINITE;
    }

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

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

    public function step(Environment $environment): void
    {
        $res = $this->db->manipulate(
            'UPDATE adv_mdf_enum SET position = idx WHERE position IS NULL LIMIT 1'
        );
    }

    public function getRemainingAmountOfSteps(): int
    {
        $res = $this->db->query(
            'SELECT COUNT(*) AS count FROM adv_mdf_enum WHERE position IS NULL'
        );

        $row = $this->db->fetchAssoc($res);
        return (int) $row['count'];
    }
}