Cdf\BiCoreBundle\Command\BiCoreBundleDroptablesCommand

Complexity

Total Complexity

8

Size/Duplication

Total Lines	65
Duplicated Lines	0 %

Test Coverage

Coverage

73.52%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	6	1
B	execute()	0	43	6
A	configure()	0	6	1

<?php

namespace Cdf\BiCoreBundle\Command;

use Symfony\Component\Console\Command\Command;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Input\InputOption;
use Symfony\Component\Console\Output\OutputInterface;
use Doctrine\ORM\EntityManagerInterface;

class BiCoreBundleDroptablesCommand extends Command
{

    protected static $defaultName = 'bicorebundle:droptables';
    private EntityManagerInterface $em;

    protected function configure(): void
    {
        $this
                ->setDescription('Eliminazione di tutte le tabelle bicorebundle')
                ->setHelp('ATTENZIONE, questo comando cancellerà tutte le informazioni presenti nel database!!')
                ->addOption('force', null, InputOption::VALUE_NONE, 'Se non impostato, il comando non avrà effetto');
    }

    public function __construct(EntityManagerInterface $em)
    {
        $this->em = $em;

        // you *must* call the parent constructor
        parent::__construct();
    }

    protected function execute(InputInterface $input, OutputInterface $output): int
    {
        /* @var $em \Doctrine\ORM\EntityManager */
        $em = $this->em;
        $driver = $em->getConnection()->getDatabasePlatform()->getName();

The function Doctrine\DBAL\Platforms\AbstractPlatform::getName() has been deprecated: Identify platforms by their class.

        $force = $input->getOption('force');

        if (!$force) {
            $output->writeln("Specificare l'opzione --force per eseguire il comando");

            return 1;
        }

        //Truncate tabelle
        $tables = $em->getConnection()->getSchemaManager()->listTables();

The function Doctrine\DBAL\Connection::getSchemaManager() has been deprecated: Use {@see createSchemaManager()} instead.

        //Cancellazione tabelle
        foreach ($tables as $table) {
            $tableName = $table->getName();

            switch ($driver) {
                case 'postgresql':
                    $em->getConnection()->executeQuery(sprintf('DROP TABLE %s CASCADE', $tableName));
                    $sequences = $em->getConnection()->getSchemaManager()->listSequences();

The function Doctrine\DBAL\Connection::getSchemaManager() has been deprecated: Use {@see createSchemaManager()} instead.

                    foreach ($sequences as $sequence) {
                        $sequenceName = $sequence->getName();
                        $em->getConnection()->executeQuery(sprintf('DROP SEQUENCE %s', $sequenceName));
                    }
                    break;
                case 'mysql':
                    $em->getConnection()->executeQuery('SET FOREIGN_KEY_CHECKS=0');
                    $em->getConnection()->executeQuery(sprintf('DROP TABLE %s', $tableName));
                    $em->getConnection()->executeQuery('SET FOREIGN_KEY_CHECKS=1');
                    break;
                default:
                    //$em->getConnection()->executeQuery(sprintf('DELETE FROM %s', $tableName));
                    $em->getConnection()->executeQuery(sprintf('DROP TABLE %s', $tableName));
                    break;
            }
        }

        $output->writeln('Done!');
        return 0;
    }
}