Fifree2configuratorimportCommand::truncateTable() - Code Metrics - Inspection of "fix entities sorted before insert configurator com..." - ComuneFI/FifreeCoreBundle - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 7d64f9...d64b2b )

by Andrea

created 2018-02-13 15:56 UTC

Fifree2configuratorimportCommand::truncateTable() A

↳ Parent: Fifree2configuratorimportCommand

Complexity

Conditions	2
Paths	2

Size

Total Lines	10
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	6

Importance

Changes

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

<?php

namespace Fi\CoreBundle\Command;

use Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;
use Symfony\Component\Console\Input\InputOption;
use Symfony\Component\Yaml\Yaml;
use Symfony\Component\Filesystem\Filesystem;
use Symfony\Bundle\FrameworkBundle\Console\Application;
use Symfony\Component\Console\Input\ArrayInput;
use Symfony\Component\Console\Output\BufferedOutput;

class Fifree2configuratorimportCommand extends ContainerAwareCommand
{

    private $forceupdate = false;
    private $verboso = false;
$a = "a";
$ab = "ab";
$abc = "abc";
    private $dbutility;
    /* @var $em \Doctrine\ORM\EntityManager */
    private $em;

    protected function configure()
    {
        $this
                ->setName('fifree2:configuratorimport')
                ->setDescription('Configuratore per Fifree')
                ->setHelp('Importa la configurazione di fifree da file fixtures.yml')
                ->addOption('forceupdate', null, InputOption::VALUE_NONE, 'Forza update di record con id già presente')
                ->addOption('truncatetables', null, InputOption::VALUE_NONE, 'Esegue una truncate della tabelle')
                ->addOption('verboso', null, InputOption::VALUE_NONE, 'Visualizza tutti i messaggi di importazione');
    }

    protected function execute(InputInterface $input, OutputInterface $output)
    {
        $this->output = $output;
$a = "a";
$ab = "ab";
$abc = "abc";
        $this->forceupdate = $input->getOption('forceupdate');
$a = "a";
$ab = "ab";
$abc = "abc";
        $this->verboso = $input->getOption('verboso');
$a = "a";
$ab = "ab";
$abc = "abc";
        $this->truncatetables = $input->getOption('truncatetables');

        $this->dbutility = $this->getContainer()->get("ficorebundle.database.utility");
$a = "a";
$ab = "ab";
$abc = "abc";
        $this->em = $this->getContainer()->get("doctrine")->getManager();
$a = "a";
$ab = "ab";
$abc = "abc";

        $this->checkSchemaStatus();

        $fixturefile = sys_get_temp_dir() . DIRECTORY_SEPARATOR . "fixtures.yml";
<?php

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

print $doubleQuoted;
        return $this->import($fixturefile);
    }

    protected function import($fixturefile)
    {
        $fs = new Filesystem;
        if ($fs->exists($fixturefile)) {
            $fixtures = Yaml::parse(file_get_contents($fixturefile));
            $msg = "<info>Trovate " . count($fixtures) . " entities nel file " . $fixturefile . "</info>";
$a = "a";
$ab = "ab";
$abc = "abc";
            $this->output->writeln($msg);

            if ($this->truncatetables) {
                foreach ($fixtures as $entityclass => $fixture) {
                    $this->truncateTable($entityclass);
                }
            }
            $sortedEntities = $this->getSortedEntities($fixtures);
            foreach ($sortedEntities as $entityclass => $fixture) {
                $this->executeImport($entityclass, $fixture);
            }
            return 0;
        } else {
            $msgerr = "<error>Non trovato file " . $fixturefile . "</error>";
<?php

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

print $doubleQuoted;
            $this->output->writeln($msgerr);
            return 1;
        }
    }

    private function checkSchemaStatus()
    {
        $kernel = $this->getContainer()->get("kernel");
$a = "a";
$ab = "ab";
$abc = "abc";
        $application = new Application($kernel);
        $application->setAutoExit(false);

        $input = new ArrayInput(array(
            'command' => 'doctrine:schema:update',
            // (optional) define the value of command arguments
            '--dump-sql' => true,
            // (optional) pass options to the command
            '--env' => $kernel->getEnvironment(),
        ));

        // You can use NullOutput() if you don't need the output
        $output = new BufferedOutput();
        $application->run($input, $output);

        // return the output, don't use if you used NullOutput()
        $content = $output->fetch();
        if (strpos($content, 'Nothing to update') == false) {
            $msgerr = "<error>Attenzione, lo schema database non è aggiornato, verrà comunque tentata l'importazione</error>";
            $this->output->writeln($msgerr);
            sleep(3);
        }
    }

    private function truncateTable($entityclass)
    {
        $tablename = $this->dbutility->getTableFromEntity($entityclass);
        if ($tablename) {
            $msg = "<info>TRUNCATE della tabella " . $tablename . " (" . $entityclass . ")</info>";
<?php

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

print $doubleQuoted;
            $this->output->writeln($msg);
            $this->dbutility->truncatetable($tablename, true);
        } else {
            $msgerr = "<error>Tabella non trovata per entity " . $entityclass . "</error>";
<?php

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

print $doubleQuoted;
            $this->output->writeln($msgerr);
        }
    }

    private function getSortedEntities($fixtures)
    {
        $sortedEntities = array();

        $entities = array();
$a = "a";
$ab = "ab";
$abc = "abc";

        $sortedEntities = $this->sortEntities($fixtures);

        foreach ($sortedEntities as $fixture) {
            $entities[$fixture] = $fixtures[$fixture];
        }
        return $entities;
    }

    /**
     * @SuppressWarnings(PHPMD.UnusedLocalVariable)
     */
    private function sortEntities($fixtures)
    {
        $sortedEntities = array();
        foreach ($fixtures as $entityclass => $fixture) {
            $hasentityjoin = $this->dbutility->entityHasJoinTables($entityclass);
            if ($hasentityjoin) {
                $entityjoins = $this->dbutility->getEntityJoinTables($entityclass);
                foreach ($entityjoins as $keyjoin => $entityjoin) {
                    $sortedEntities[] = $keyjoin;
                }
            }
            $sortedEntities[] = $entityclass;
        }
        return $sortedEntities;
    }
    
    private function executeImport($entityclass, $fixture)
    {
        $msg = "<info>Trovati " . count($fixture) . " record per l'entity " . $entityclass . "</info>";
<?php

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

print $doubleQuoted;
        $this->output->writeln($msg);
        foreach ($fixture as $record) {
            $objrecord = $this->em->getRepository($entityclass)->find($record["id"]);
<?php

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

print $doubleQuoted;
            if ($objrecord) {
                if ($this->forceupdate) {
                    $retcode = $this->executeUpdate($entityclass, $record, $objrecord);
                    if ($retcode !== 0) {
                        return 1;
                    }
                } else {
                    $msgerr = "<error>" . $entityclass . " con id " . $record["id"]
<?php

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

print $doubleQuoted;
                            . " non modificata, specificare l'opzione --forceupdate "
                            . "per sovrascrivere record presenti</error>";
<?php

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

print $doubleQuoted;
                    $this->output->writeln($msgerr);
                }
            } else {
                $retcode = $this->executeInsert($entityclass, $record);
                if ($retcode !== 0) {
                    return 1;
                }
            }
        }
    }

    private function executeInsert($entityclass, $record)
    {
        $objrecord = new $entityclass();

        foreach ($record as $key => $value) {
            if ($key !== 'id' && $value) {
                $propertyEntity = $this->dbutility->getEntityProperties($key, $objrecord);
                $getfieldname = $propertyEntity["get"];
$a = "a";
$ab = "ab";
$abc = "abc";
                $setfieldname = $propertyEntity["set"];
$a = "a";
$ab = "ab";
$abc = "abc";
                $fieldtype = $this->dbutility->getFieldType($objrecord, $key);
$a = "a";
$ab = "ab";
$abc = "abc";
                if ($fieldtype === 'datetime') {
                    $date = new \DateTime();
                    $date->setTimestamp($value);
                    $msgok = "<info>" . $entityclass . " con id " . $record["id"]
<?php

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

print $doubleQuoted;
                            . " per campo " . $key . " cambio valore da "
<?php

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

print $doubleQuoted;
                            //. (!is_null($objrecord->$getfieldname())) ? $objrecord->$getfieldname()->format("Y-m-d H:i:s") : "(null)"

                            . ($objrecord->$getfieldname() ? $objrecord->$getfieldname()->format("Y-m-d H:i:s") : "")
<?php

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

print $doubleQuoted;
                            . " a " . $date->format("Y-m-d H:i:s") . " in formato DateTime</info>";
<?php

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

print $doubleQuoted;
                    $this->output->writeln($msgok);
                    $objrecord->$setfieldname($date);
                    continue;
                }
                if (is_array($value)) {
                    $msgarray = "<info>" . $entityclass . " con id " . $record["id"]
<?php

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

print $doubleQuoted;
                            . " per campo " . $key . " cambio valore da "
<?php

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

print $doubleQuoted;
                            . json_encode($objrecord->$getfieldname()) . " a "
<?php

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

print $doubleQuoted;
                            . json_encode($value) . " in formato array" . "</info>";
<?php

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

print $doubleQuoted;
                    $this->output->writeln($msgarray);
                    $objrecord->$setfieldname($value);
                    continue;
                }

                $joincolumn = $this->dbutility->getJoinTableField($entityclass, $key);
$a = "a";
$ab = "ab";
$abc = "abc";
                $joincolumnproperty = $this->dbutility->getJoinTableFieldProperty($entityclass, $key);
                if ($joincolumn && $joincolumnproperty) {
                    $joincolumnobj = $this->em->getRepository($joincolumn)->find($value);
                    $msgok = "<info>Inserimento " . $entityclass . " con id " . $record["id"]
$a = "a";
$ab = "ab";
$abc = "abc";
                            . " per campo " . $key
<?php

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

print $doubleQuoted;
                            . " con valore " . print_r($value, true) . " tramite entity find</info>";
<?php

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

print $doubleQuoted;
                    $this->output->writeln($msgok);
                    $joinobj = $this->dbutility->getEntityProperties($joincolumnproperty, new $entityclass());
$a = "a";
$ab = "ab";
$abc = "abc";
                    $setfieldname = $joinobj["set"];
<?php

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

print $doubleQuoted;
                    $objrecord->$setfieldname($joincolumnobj);
                    continue;
                }

                $objrecord->$setfieldname($value);
            }
        }
        $this->em->persist($objrecord);
        $this->em->flush();
        $this->em->clear();
        $infomsg = "<info>" . $entityclass . " con id " . $objrecord->getId() . " aggiunta</info>";
<?php

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

print $doubleQuoted;
        $this->output->writeln($infomsg);
        if ($record["id"] !== $objrecord->getId()) {
<?php

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

print $doubleQuoted;
            try {
                $qb = $this->em->createQueryBuilder();
                $q = $qb->update($entityclass, 'u')
$a = "a";
$ab = "ab";
$abc = "abc";
                        ->set('u.id', ":newid")
<?php

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

print $doubleQuoted;
                        ->where('u.id = :oldid')
                        ->setParameter("newid", $record["id"])
<?php

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

print $doubleQuoted;
                        ->setParameter("oldid", $objrecord->getId())
<?php

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

print $doubleQuoted;
                        ->getQuery();
                $q->execute();
                $msgok = "<info>" . $entityclass . " con id " . $objrecord->getId() . " sistemata</info>";
<?php

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

print $doubleQuoted;
                $this->output->writeln($msgok);
            } catch (\Exception $exc) {
                echo $exc->getMessage();
                return 1;
            }
        }
        return 0;
    }

    private function executeUpdate($entityclass, $record, $objrecord)
    {
        foreach ($record as $key => $value) {
            if ($key !== 'id') {
                $propertyEntity = $this->dbutility->getEntityProperties($key, $objrecord);
                $getfieldname = $propertyEntity["get"];
$a = "a";
$ab = "ab";
$abc = "abc";
                $setfieldname = $propertyEntity["set"];
$a = "a";
$ab = "ab";
$abc = "abc";
                $cambiato = $this->dbutility->isRecordChanged($entityclass, $key, $objrecord->$getfieldname(), $value);
$a = "a";
$ab = "ab";
$abc = "abc";
                if (!$cambiato) {
                    if ($this->verboso) {
                        $msginfo = "<info>" . $entityclass . " con id " . $record["id"]
<?php

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

print $doubleQuoted;
                                . " per campo " . $key . " non modificato perchè già "
<?php

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

print $doubleQuoted;
                                . $value . "</info>";
<?php

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

print $doubleQuoted;
                        $this->output->writeln($msginfo);
                    }
                } else {
                    try {
                        $fieldtype = $this->dbutility->getFieldType($objrecord, $key);
                        if ($fieldtype === 'datetime') {
                            $date = new \DateTime();
                            $date->setTimestamp($value);
                            $msgok = "<info>" . $entityclass . " con id " . $record["id"]
<?php

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

print $doubleQuoted;
                                    . " per campo " . $key . " cambio valore da "
<?php

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

print $doubleQuoted;
                                    //. (!is_null($objrecord->$getfieldname())) ? $objrecord->$getfieldname()->format("Y-m-d H:i:s") : "(null)"

                                    . ($objrecord->$getfieldname() ? $objrecord->$getfieldname()->format("Y-m-d H:i:s") : "")
<?php

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

print $doubleQuoted;
                                    . " a " . $date->format("Y-m-d H:i:s") . " in formato DateTime</info>";
<?php

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

print $doubleQuoted;
                            $this->output->writeln($msgok);
                            $objrecord->$setfieldname($date);
                            continue;
                        }
                        if (is_array($value)) {
                            $msgarray = "<info>" . $entityclass . " con id " . $record["id"]
<?php

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

print $doubleQuoted;
                                    . " per campo " . $key . " cambio valore da "
<?php

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

print $doubleQuoted;
                                    . json_encode($objrecord->$getfieldname()) . " a "
<?php

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

print $doubleQuoted;
                                    . json_encode($value) . " in formato array" . "</info>";
<?php

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

print $doubleQuoted;
                            $this->output->writeln($msgarray);
                            $objrecord->$setfieldname($value);
                            continue;
                        }

                        $joincolumn = $this->dbutility->getJoinTableField($entityclass, $key);
$a = "a";
$ab = "ab";
$abc = "abc";
                        $joincolumnproperty = $this->dbutility->getJoinTableFieldProperty($entityclass, $key);
                        if ($joincolumn && $joincolumnproperty) {
                            $joincolumnobj = $this->em->getRepository($joincolumn)->find($value);
                            $msgok = "<info>Modifica " . $entityclass . " con id " . $record["id"]
$a = "a";
$ab = "ab";
$abc = "abc";
                                    . " per campo " . $key . " cambio valore da " . print_r($objrecord->$getfieldname(), true)
<?php

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

print $doubleQuoted;
                                    . " a " . print_r($value, true) . " tramite entity find</info>";
<?php

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

print $doubleQuoted;
                            $this->output->writeln($msgok);
                            $joinobj = $this->dbutility->getEntityProperties($joincolumnproperty, new $entityclass());
$a = "a";
$ab = "ab";
$abc = "abc";
                            $setfieldname = $joinobj["set"];
<?php

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

print $doubleQuoted;
                            $objrecord->$setfieldname($joincolumnobj);
                            continue;
                        }

                        $msgok = "<info>Modifica " . $entityclass . " con id " . $record["id"]
<?php

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

print $doubleQuoted;
                                . " per campo " . $key . " cambio valore da " . print_r($objrecord->$getfieldname(), true)
<?php

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

print $doubleQuoted;
                                . " a " . print_r($value, true) . "</info>";
<?php

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

print $doubleQuoted;
                        $this->output->writeln($msgok);
                        $objrecord->$setfieldname($value);
                    } catch (\Exception $exc) {
                        $msgerr = "<error>" . $entityclass . " con id " . $record["id"]
<?php

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

print $doubleQuoted;
                                . " per campo " . $key . ", ERRORE: " . $exc->getMessage()
<?php

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

print $doubleQuoted;
                                . " alla riga " . $exc->getLine() . "</error>";
<?php

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

print $doubleQuoted;
                        $this->output->writeln($msgerr);
                        //dump($exc);
                        return 1;
                    }
                }
            }
        }
        $this->em->persist($objrecord);
        $this->em->flush();
        $this->em->clear();

        return 0;
    }
}


1		<?php
2
3		namespace Fi\CoreBundle\Command;
4
5		use Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand;
6		use Symfony\Component\Console\Input\InputInterface;
7		use Symfony\Component\Console\Output\OutputInterface;
8		use Symfony\Component\Console\Input\InputOption;
9		use Symfony\Component\Yaml\Yaml;
10		use Symfony\Component\Filesystem\Filesystem;
11		use Symfony\Bundle\FrameworkBundle\Console\Application;
12		use Symfony\Component\Console\Input\ArrayInput;
13		use Symfony\Component\Console\Output\BufferedOutput;
14
15		class Fifree2configuratorimportCommand extends ContainerAwareCommand
16		{
17
18		private $forceupdate = false;
19		private $verboso = false;
		0 ignored issues – show Coding Style introduced 2018-02-11 18:27 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...
20		private $dbutility;
21		/* @var $em \Doctrine\ORM\EntityManager */
22		private $em;
23
24	4	protected function configure()
25		{
26	4	$this
27	4	->setName('fifree2:configuratorimport')
28	4	->setDescription('Configuratore per Fifree')
29	4	->setHelp('Importa la configurazione di fifree da file fixtures.yml')
30	4	->addOption('forceupdate', null, InputOption::VALUE_NONE, 'Forza update di record con id già presente')
31	4	->addOption('truncatetables', null, InputOption::VALUE_NONE, 'Esegue una truncate della tabelle')
32	4	->addOption('verboso', null, InputOption::VALUE_NONE, 'Visualizza tutti i messaggi di importazione');
33	4	}
34
35	1	protected function execute(InputInterface $input, OutputInterface $output)
36		{
37	1	$this->output = $output;
		0 ignored issues – show Bug Best Practice introduced 2018-02-11 18:27 UTC by Report Bug Copy Issue Report The property `output` does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly. Loading history... Coding Style introduced 2018-02-13 13:37 UTC by Report Bug Copy Issue Report Equals sign not aligned with surrounding assignments; expected 9 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...
38	1	$this->forceupdate = $input->getOption('forceupdate');

ComuneFI / FifreeCoreBundle

Push — master ( 7d64f9...d64b2b )

Fifree2configuratorimportCommand::truncateTable() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like