Chamilo\CoreBundle\Migrations\Schema\V200\Version20201212114910

Complexity

Total Complexity

4

Size/Duplication

Total Lines	20
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getDescription()	0	3	1
A	up()	0	13	3

<?php

namespace Chamilo\CoreBundle\Migrations\Schema\V200;

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

final class Version20201212114910 extends AbstractMigrationChamilo
{
    public function getDescription() : string
    {
        return 'Migrate content';
    }

    public function up(Schema $schema) : void
    {
        $connection = $this->getEntityManager()->getConnection();

        $sql = 'SELECT * FROM course';
        $result = $connection->executeQuery($sql);
        $data = $result->fetchAllAssociative();
        foreach ($data as $course) {
            $courseId = $course['id'];
            $sql = "SELECT * FROM c_document WHERE c_id = $courseId";
            $result = $connection->executeQuery($sql);
            $documents = $result->fetchAllAssociative();
            foreach ($documents as $document) {
                //$repo
            }

            //$this->addSql($sql);
        }

    }
}