UpdateCommand::createProfile() - Code Metrics - Inspection of "cd85d0399cfb6a7a39d3d1c45b20aa88318d090e" - Coderberg/ResidenceCMS - Measure and Improve Code Quality continuously with Scrutinizer

Test Setup Failed

Branch — master (cd85d0)

by Valery

created 2021-08-18 07:30 UTC

UpdateCommand::createProfile() A

↳ Parent: UpdateCommand

Complexity

Conditions	1
Paths	1

Size

Total Lines	8
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	5
c	1
b	0
f	0
nc	1
nop	1
dl	0
loc	8
rs	10

<?php

declare(strict_types=1);

namespace App\Command;

use App\Entity\Profile;
use App\Entity\PropertyDescription;
use App\Repository\PropertyRepository;
use App\Repository\UserRepository;
use Doctrine\ORM\EntityManagerInterface;
use Symfony\Component\Console\Command\Command;
use Symfony\Component\Console\Input\ArrayInput;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;
use Symfony\Component\Console\Style\SymfonyStyle;

final class UpdateCommand extends Command
{
    private $entityManager;
    protected static $defaultName = 'app:update';
    protected static $defaultDescription = 'Application Update Assistant (1.8.1 -> 1.9.0)';
    private $propertyRepository;
    private $userRepository;

    public function __construct(
        EntityManagerInterface $entityManager,
        PropertyRepository $propertyRepository,
        UserRepository $userRepository,
        string $name = null
    ) {
        parent::__construct($name);
        $this->entityManager = $entityManager;
        $this->propertyRepository = $propertyRepository;
        $this->userRepository = $userRepository;
    }

    protected function execute(InputInterface $input, OutputInterface $output): int
    {
        if (0 !== $this->runMigrations($output)) {
            return Command::FAILURE;
        }

        try {
            $this->moveUserDataToProfile();
            $this->movePropertyDescription();
            $this->dropExtraColumns();
            $this->printMessage('success', $input, $output);
        } catch (\Exception $exception) {
            $this->printMessage('fail', $input, $output, $exception->getMessage());

            return Command::FAILURE;
        }

        return Command::SUCCESS;
    }

    private function runMigrations(OutputInterface $output): int
    {
        $consoleInput = new ArrayInput([]);
        $consoleInput->setInteractive(false);
        $this->getApplication()
            ->find('doctrine:migrations:migrate')
            ->run($consoleInput, $output);

        return Command::SUCCESS;
    }

    private function movePropertyDescription()
    {
        $properties = $this->findPropertiesWithoutDescription();

        foreach ($properties as $propertiy) {
            $this->createDescription($propertiy);
        }
    }

    private function moveUserDataToProfile()
    {
        $users = $this->findUsersWithoutProfile();

        foreach ($users as $user) {
            $this->createProfile($user);
        }
    }

    private function createProfile(array $user)
    {
        $profile = (new Profile())
            ->setUser($this->userRepository->find($user['id']))
            ->setUser(/** @scrutinizer ignore-type */ $this->userRepository->find($user['id']))
            ->setFullName($user['full_name'])
            ->setPhone($user['phone']);

        $this->save($profile);
    }

    private function findUsersWithoutProfile()
    {
        $sql = 'SELECT id, full_name, phone FROM users WHERE id NOT IN (SELECT user_id FROM profile)';

        return $this->executeSql($sql)->fetchAll();
        return /** @scrutinizer ignore-deprecated */ $this->executeSql($sql)->fetchAll();
    }

    private function findPropertiesWithoutDescription()
    {
        $sql = 'SELECT id, title, content, meta_title, meta_description
                    FROM property
                    WHERE id
                    NOT IN (SELECT property_id FROM property_description)';

        return $this->executeSql($sql)->fetchAll();
        return /** @scrutinizer ignore-deprecated */ $this->executeSql($sql)->fetchAll();
    }

    private function createDescription(array $property)
    {
        $profile = (new PropertyDescription())
            ->setProperty($this->propertyRepository->find($property['id']))
            ->setProperty(/** @scrutinizer ignore-type */ $this->propertyRepository->find($property['id']))
            ->setTitle($property['title'])
            ->setContent($property['content'])
            ->setMetaTitle($property['meta_title'])
            ->setMetaDescription($property['meta_description']);

        $this->save($profile);
    }

    private function dropExtraColumns(): void
    {
        $this->executeSql('ALTER TABLE users DROP full_name');
        $this->executeSql('ALTER TABLE users DROP phone');
        $this->executeSql('ALTER TABLE property DROP title');
        $this->executeSql('ALTER TABLE property DROP content');
        $this->executeSql('ALTER TABLE property DROP meta_title');
        $this->executeSql('ALTER TABLE property DROP meta_description');
    }

    private function printMessage(string $type, $input, $output, $message = ''): void
    {
        $io = new SymfonyStyle($input, $output);
        $io->success('Database schema updated successfully!');

        'success' === $type
            ? $io->success('Database schema updated successfully!')
            : $io->error($message);
    }

    private function save($entity): void
    {
        $this->entityManager->persist($entity);
        $this->entityManager->flush();
    }

    private function executeSql($sql)
    {
        $connection = $this->entityManager->getConnection();
        $query = $connection->prepare($sql);

        return $query->executeQuery();
    }
}


Coderberg / ResidenceCMS

Branch — master (cd85d0)

UpdateCommand::createProfile() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like