Chamilo\CoreBundle\Migrations\Schema\V200\Version20230321164019

Complexity

Total Complexity

4

Size/Duplication

Total Lines	36
Duplicated Lines	0 %

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getDescription()	0	3	1
A	up()	0	24	2
A	down()	0	2	1

<?php

declare(strict_types=1);

/* For licensing terms, see /license.txt */

namespace Chamilo\CoreBundle\Migrations\Schema\V200;

use Chamilo\CoreBundle\Entity\TrackEAttemptQualify;
use Chamilo\CoreBundle\Migrations\AbstractMigrationChamilo;
use Doctrine\DBAL\Schema\Schema;

class Version20230321164019 extends AbstractMigrationChamilo
{
    public function getDescription(): string
    {
        return 'Migrate track_e_attempt_recording';
    }

    public function up(Schema $schema): void
    {
        $container = $this->getContainer();
        $doctrine = $container->get('doctrine');
        $em = $doctrine->getManager();

        $sql = 'SELECT * FROM track_e_attempt_recording';
        $connection = $this->getEntityManager()->getConnection();
        $result = $connection->executeQuery($sql);
        $items = $result->fetchAllAssociative();

        foreach ($items as $item) {
            $trackQualify = new TrackEAttemptQualify();
            $trackQualify
                ->setExeId($item['exe_id'])

The method setExeId() does not exist on Chamilo\CoreBundle\Entity\TrackEAttemptQualify.

                ->setQuestionId($item['question_id'])
                ->setAnswer($item['answer'])
                ->setMarks((int) $item['marks'])
                ->setAuthor($item['author'])
                ->setTeacherComment($item['teacher_comment'])
                ->setSessionId($item['session_id'])
            ;
            $em->persist($trackQualify);
            $em->flush();
        }
    }

    public function down(Schema $schema): void
    {
    }
}