BiCoreBundleDroptablesCommand::__construct() - Code Metrics - Inspection of "Merge branch 'release/v0.1.36'" - ComuneFI/BiCoreBundle - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 632657...4bf89d )

by Andrea

created 2018-12-14 11:34 UTC

BiCoreBundleDroptablesCommand::__construct() A

↳ Parent: BiCoreBundleDroptablesCommand

Complexity

Conditions	1
Paths	1

Size

Total Lines	6
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	3
CRAP Score	1

Importance

Changes

Metric	Value
cc	1
eloc	2
nc	1
nop	1
dl	0
loc	6
ccs	3
cts	3
cp	1
crap	1
rs	10
c	0
b	0
f	0

<?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\Common\Persistence\ObjectManager;

class BiCoreBundleDroptablesCommand extends Command
{
    protected function configure()
    {
        $this
                ->setName('bicorebundle:droptables')
                ->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(ObjectManager $em)
    {
        $this->em = $em;


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

    protected function execute(InputInterface $input, OutputInterface $output)
    {
        /* @var $em \Doctrine\ORM\EntityManager */
        $em = $this->em;
$a = "a";
$ab = "ab";
$abc = "abc";
        $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":
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                    $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":
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                    $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!");
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
    }
}


1		<?php
2
3		namespace Cdf\BiCoreBundle\Command;
4
5		use Symfony\Component\Console\Command\Command;
6		use Symfony\Component\Console\Input\InputInterface;
7		use Symfony\Component\Console\Input\InputOption;
8		use Symfony\Component\Console\Output\OutputInterface;
9		use \Doctrine\Common\Persistence\ObjectManager;
10
11		class BiCoreBundleDroptablesCommand extends Command
12		{
13	3	protected function configure()
14		{
15		$this
16	3	->setName('bicorebundle:droptables')
17	3	->setDescription('Eliminazione di tutte le tabelle bicorebundle')
18	3	->setHelp('ATTENZIONE, questo comando cancellerà tutte le informazioni presenti nel database!!')
19	3	->addOption('force', null, InputOption::VALUE_NONE, 'Se non impostato, il comando non avrà effetto');
20	3	}
21
22	3	public function __construct(ObjectManager $em)
23		{
24	3	$this->em = $em;
		0 ignored issues – show Bug Best Practice introduced 2018-12-14 11:04 UTC by Report Bug Copy Issue Report The property `em` does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly. Loading history...
25
26		// you must call the parent constructor
27	3	parent::__construct();
28	3	}
29
30	1	protected function execute(InputInterface $input, OutputInterface $output)
31		{
32		/* @var $em \Doctrine\ORM\EntityManager */
33	1	$em = $this->em;
		0 ignored issues – show Coding Style introduced 2018-12-14 11:04 UTC by Report Bug Copy Issue Report Equals sign not aligned with surrounding assignments; expected 5 spaces but found 1 space This check looks for multiple assignments in successive lines of code. It will report an issue if the operators are not in a straight line. To visualize $a = "a"; $ab = "ab"; $abc = "abc"; will produce issues in the first and second line, while this second example $a = "a"; $ab = "ab"; $abc = "abc"; will produce no issues. Loading history...
34	1	$driver = $em->getConnection()->getDatabasePlatform()->getName();
35
36	1	$force = $input->getOption('force');
37
38	1	if (!$force) {
39		$output->writeln("Specificare l'opzione --force per eseguire il comando");
40		return 1;
41		}
42
43		//Truncate tabelle
44	1	$tables = $em->getConnection()->getSchemaManager()->listTables();
45		//Cancellazione tabelle
46	1	foreach ($tables as $table) {
47	1	$tableName = $table->getName();
48	1	switch ($driver) {
49	1	case "postgresql":
		0 ignored issues – show Coding Style Comprehensibility introduced 2018-11-17 22:42 UTC by Report Bug Copy Issue Report The string literal `postgresql` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history...
50		$em->getConnection()->executeQuery(sprintf('DROP TABLE %s CASCADE', $tableName));
51		$sequences = $em->getConnection()->getSchemaManager()->listSequences();
52		foreach ($sequences as $sequence) {
53		$sequenceName = $sequence->getName();
54		$em->getConnection()->executeQuery(sprintf('DROP SEQUENCE %s', $sequenceName));
55		}
56		break;
57	1	case "mysql":
		0 ignored issues – show Coding Style Comprehensibility introduced 2018-11-17 22:42 UTC by Report Bug Copy Issue Report The string literal `mysql` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history...
58	1	$em->getConnection()->executeQuery('SET FOREIGN_KEY_CHECKS=0');
59	1	$em->getConnection()->executeQuery(sprintf('DROP TABLE %s', $tableName));
60	1	$em->getConnection()->executeQuery('SET FOREIGN_KEY_CHECKS=1');
61	1	break;
62		default:
63		//$em->getConnection()->executeQuery(sprintf('DELETE FROM %s', $tableName));
		0 ignored issues – show Unused Code Comprehensibility introduced 2018-11-17 22:42 UTC by Report Bug Copy Issue Report `77%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
64		$em->getConnection()->executeQuery(sprintf('DROP TABLE %s', $tableName));
65	1	break;
66		}
67		}
68
69	1	$output->writeln("Done!");
		0 ignored issues – show Coding Style Comprehensibility introduced 2018-11-17 22:42 UTC by Report Bug Copy Issue Report The string literal `Done!` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history...
70	1	}
71		}
72

ComuneFI / BiCoreBundle

Push — master ( 632657...4bf89d )

BiCoreBundleDroptablesCommand::__construct() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like