Inheritance diagram for ilFixMissingQuestionDuplicationMigration:

Collaboration diagram for ilFixMissingQuestionDuplicationMigration:

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

bool	$ilias_is_initialized = false

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

Detailed Description

Definition at line 24 of file class.ilFixMissingQuestionDuplicationMigration.php.

Member Function Documentation

◆ getDefaultAmountOfStepsPerRun()

ilFixMissingQuestionDuplicationMigration::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 35 of file class.ilFixMissingQuestionDuplicationMigration.php.

◆ getLabel()

ilFixMissingQuestionDuplicationMigration::getLabel ( )

Returns: string - a meaningful and concise description for your migration.

Implements ILIAS\Setup\Migration.

Definition at line 30 of file class.ilFixMissingQuestionDuplicationMigration.php.

                              : string
    {
        return 'Fix Missing Question Duplication When Creating in Test And Pool';
    }

◆ getPreconditions()

ilFixMissingQuestionDuplicationMigration::getPreconditions ( Environment $environment )

Objectives the migration depend on.

Exceptions

UnachievableException if the objective is not achievable

Returns: Objective[]

Implements ILIAS\Setup\Migration.

Definition at line 40 of file class.ilFixMissingQuestionDuplicationMigration.php.

                                                              : array
    {
        return [
            new \ilDatabaseInitializedObjective()
        ];
    }

◆ getRemainingAmountOfSteps()

ilFixMissingQuestionDuplicationMigration::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 92 of file class.ilFixMissingQuestionDuplicationMigration.php.

                                               : int
    {
        $query = 'SELECT COUNT(qst.question_id) AS cnt FROM tst_tests AS tst'
            . '   INNER JOIN tst_test_question AS tst_qst'
            . '      ON tst.test_id = tst_qst.test_fi'
            . '   INNER JOIN qpl_questions AS qst'
            . '      ON tst_qst.question_fi = qst.question_id'
            . '   WHERE tst.question_set_type = "FIXED_QUEST_SET"'
            . '      AND qst.obj_fi != tst.obj_fi'
            . '      AND ISNULL(qst.original_id)';
        $result = $this->db->query($query);
        $row = $this->db->fetchAssoc($result);
 
        return (int) ($row['cnt'] ?? 0);
    }

References $query.

◆ prepare()

ilFixMissingQuestionDuplicationMigration::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 47 of file class.ilFixMissingQuestionDuplicationMigration.php.

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

References ILIAS\Setup\Environment\getResource().

Here is the call graph for this function:

◆ step()

ilFixMissingQuestionDuplicationMigration::step ( Environment $environment )

Run one step of the migration.

Implements ILIAS\Setup\Migration.

Definition at line 52 of file class.ilFixMissingQuestionDuplicationMigration.php.

                                                  : void
    {
        if (!$this->ilias_is_initialized) {
            \ilContext::init(\ilContext::CONTEXT_CRON);
            \ilInitialisation::initILIAS();
            $this->ilias_is_initialized = true;
        }
        $query_main = 'SELECT qst.question_id FROM tst_tests AS tst'
            . '   INNER JOIN tst_test_question AS tst_qst'
            . '      ON tst.test_id = tst_qst.test_fi'
            . '   INNER JOIN qpl_questions AS qst'
            . '      ON tst_qst.question_fi = qst.question_id'
            . '   WHERE tst.question_set_type = "FIXED_QUEST_SET"'
            . '      AND qst.obj_fi != tst.obj_fi'
            . '      AND ISNULL(qst.original_id)';
        $result_main = $this->db->query($query_main);
        while ($question = $this->db->fetchAssoc($result_main)) {
            $question_obj = assQuestion::_instanciateQuestion((int) $question['question_id']);
            $clone_id = $question_obj->duplicate(false);
 
            $this->db->update(
                'qpl_questions',
                ['original_id' => ['integer', $clone_id]],
                ['original_id' => ['integer', $question['question_id']]]
            );
 
            $test_query = 'SELECT obj_fi FROM tst_test_question INNER JOIN tst_tests ON tst_test_question.test_fi = tst_tests.test_id WHERE question_fi = %s';
            $test_result = $this->db->queryF($test_query, ['integer'], [$question['question_id']]);
 
            $this->db->update(
                'qpl_questions',
                [
                    'original_id' => ['integer', $clone_id],
                    'obj_fi' => ['integer', ($this->db->fetchObject($test_result))->obj_fi]
                ],
                ['question_id' => ['integer', $question['question_id']]]
            );
        }
    }