Fi\CoreBundle\Command\Fifree2droptablesCommand

Complexity

Total Complexity

9

Size/Duplication

Total Lines	51
Duplicated Lines	0 %

Test Coverage

Coverage

38.71%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	configure()	0	7	1
B	execute()	0	39	8

<?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();

Equals sign not aligned with surrounding assignments; expected 5 spaces but found 1 space

        $driver = $em->getConnection()->getDriver()->getName();

        if ($driver == "pdo_sqlite") {

The string literal pdo_sqlite does not require double quotes, as per coding-style, please use single quotes.

            $output->writeln("Non previsto per driver: " . $driver);

The string literal Non previsto per driver: does not require double quotes, as per coding-style, please use single quotes.

            return 1;
        }

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

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

The string literal does not require double quotes, as per coding-style, please use single quotes.

        if ($driver == "pdo_pgsql") {

The string literal pdo_pgsql does not require double quotes, as per coding-style, please use single quotes.

            $addcascade = " CASCADE";

The string literal CASCADE does not require double quotes, as per coding-style, please use single quotes.

        }

        //Truncate tabelle
        $tables = $em->getConnection()->getSchemaManager()->listTables();
        foreach ($tables as $table) {
            $tableName = $table->getName();
            $em->getConnection()->executeQuery(sprintf('TRUNCATE TABLE %s' . $addcascade, $tableName));
        }
        //Cancellazione tabelle
        foreach ($tables as $table) {

$table is overwriting a variable from outer foreach loop.

            $tableName = $table->getName();
            $em->getConnection()->executeQuery(sprintf('DROP TABLE %s' . $addcascade, $tableName));
        }
        if ($driver == "pdo_pgsql") {

The string literal pdo_pgsql does not require double quotes, as per coding-style, please use single quotes.

            //Cancellazione sequences
            $sequences = $em->getConnection()->getSchemaManager()->listSequences();
            foreach ($sequences as $sequence) {
                $sequenceName = $sequence->getName();
                $em->getConnection()->executeQuery(sprintf('DROP SEQUENCE %s', $sequenceName));
            }
        }
    }
}