SWP\Migrations\Version20180605111249

Complexity

Total Complexity

5

Size/Duplication

Total Lines	51
Duplicated Lines	39.22 %

Coupling/Cohesion

Components	1
Dependencies	5

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	setContainer()	0	4	1
A	up()	0	5	1
A	postUp()	20	20	2
A	down()	0	5	1

<?php

declare(strict_types=1);

namespace SWP\Migrations;

use Behat\Transliterator\Transliterator;
use Doctrine\DBAL\Migrations\AbstractMigration;
use Doctrine\DBAL\Schema\Schema;
use SWP\Bundle\ContentBundle\Model\ArticleAuthor;
use SWP\Bundle\ContentBundle\Model\ArticleAuthorInterface;
use Symfony\Component\DependencyInjection\ContainerAwareInterface;
use Symfony\Component\DependencyInjection\ContainerInterface;

/**
 * Auto-generated Migration: Please modify to your needs!
 */
final class Version20180605111249 extends AbstractMigration implements ContainerAwareInterface

The class Doctrine\DBAL\Migrations\AbstractMigration has been deprecated with message: Please use Doctrine\Migrations\AbstractMigration

{
    /**
     * @var ContainerInterface
     */
    private $container;

    /**
     * @param ContainerInterface|null $container
     */
    public function setContainer(ContainerInterface $container = null)
    {
        $this->container = $container;
    }

    public function up(Schema $schema): void
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
    }

    /**
     * @param Schema $schema
     */
    public function postUp(Schema $schema)

This method seems to be duplicated in your project.

    {
        $entityManager = $this->container->get('doctrine.orm.default_entity_manager');
        $query = $entityManager
            ->createQuery('SELECT au.id, au.name FROM SWP\Bundle\ContentBundle\Model\ArticleAuthor AS au  WHERE au.slug IS NULL');
        $articleAuthors = $query->getArrayResult();

        /** @var ArticleAuthorInterface $articleAuthor */
        foreach ((array) $articleAuthors as $articleAuthor) {
            $qb = $entityManager->createQueryBuilder();
            $query = $qb->update(ArticleAuthor::class, 'au')
                ->set('au.slug', '?1')
                ->where('au.id = ?2')
                ->setParameter(1, Transliterator::transliterate($articleAuthor['name']))
                ->setParameter(2, $articleAuthor['id'])
                ->getQuery();

            $query->execute();
        }
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
    }
}