Chamilo\CoreBundle\Migrations\Schema\V200\Version20250923205900::up()

Complexity

Conditions	6
Paths	9

Size

Total Lines	75
Code Lines	47

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

<?php
    public function up(Schema $schema): void
    {
        /** @var ToolChain $toolChain */
        $toolChain = $this->container->get(ToolChain::class);

The method get() does not exist on null.

        /** @var SettingsManager $settings */
        $settings  = $this->container->get(SettingsManager::class);

        // Ensure global catalog is seeded (tool + resource_types)
        $toolChain->createTools();

        $targetTitle = 'dropbox';

        // Get Tool ID by title (fail fast if not found)
        $toolId = $this->entityManager
            ->createQuery('SELECT t.id FROM Chamilo\CoreBundle\Entity\Tool t WHERE t.title = :title')

The method createQuery() does not exist on null.

            ->setParameter('title', $targetTitle)
            ->getOneOrNullResult(Query::HYDRATE_SINGLE_SCALAR);

        if ($toolId === null) {
            $this->write('Tool "'.$targetTitle.'" does not exist; aborting migration.');
            return;
        }
        $toolId = (int) $toolId;

        $activeOnCreate = $settings->getSetting('course.active_tools_on_create') ?? [];
        $visible        = \in_array($targetTitle, $activeOnCreate, true);
        $linkVisibility = $visible ? ResourceLink::VISIBILITY_PUBLISHED : ResourceLink::VISIBILITY_DRAFT;

        $batchSize = self::BATCH_SIZE;
        $i = 0;

        // Iterate over course IDs only (no heavy hydration)
        $q = $this->entityManager->createQuery('SELECT c.id FROM Chamilo\CoreBundle\Entity\Course c');

        foreach ($q->toIterable([], Query::HYDRATE_SCALAR) as $row) {
            $courseId = (int) $row['id'];

            // Does the course already have this tool?
            $exists = (int) $this->entityManager
                ->createQuery(
                    'SELECT COUNT(ct.iid)
                       FROM Chamilo\CourseBundle\Entity\CTool ct
                      WHERE ct.title = :title
                        AND ct.course = :course'
                )
                ->setParameter('title', $targetTitle)
                ->setParameter('course', $this->entityManager->getReference(Course::class, $courseId))
                ->getSingleScalarResult();

            if ($exists > 0) {
                continue;
            }

            $toolRef   = $this->entityManager->getReference(Tool::class, $toolId);
            $courseRef = $this->entityManager->getReference(Course::class, $courseId);

            $ctool = (new CTool())
                ->setTool($toolRef)
                ->setTitle($targetTitle)
                ->setVisibility($visible)
                ->setCourse($courseRef)
                ->setParent($courseRef)
                ->setCreator($courseRef->getCreator())
                ->addCourseLink($courseRef, null, null, $linkVisibility);

            $this->entityManager->persist($ctool);

            if ((++$i % $batchSize) === 0) {
                $this->entityManager->flush();
                $this->entityManager->clear();
            }
        }

        $this->entityManager->flush();
        $this->entityManager->clear();
    }