Fi\CoreBundle\Command\Fifree2droptablesCommand

Complexity

Total Complexity

7

Size/Duplication

Total Lines	52
Duplicated Lines	0 %

Test Coverage

Coverage

62.5%

Importance

Changes	2
Bugs	2	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	configure()	0	7	1
B	execute()	0	40	6

<?php

namespace Fi\CoreBundle\Command;

use Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Input\InputOption;
use Symfony\Component\Console\Output\OutputInterface;

class Fifree2droptablesCommand extends ContainerAwareCommand
{

    protected function configure()
    {
        $this
                ->setName('fifree2:droptables')
                ->setDescription('Eliminazione di tutte le tabelle fifree2')
                ->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');
    }

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

        $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();
        //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();
                    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!");
    }
}