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'];
    }
}