Fifree2configuratorimportCommand::checkSysstemTables() - Code Metrics - Inspection of "try fix test pgsql storicomodifiche" - ComuneFI/FifreeCoreBundle - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( e1acfb...7d1485 )

by Andrea

created 2018-02-14 09:35 UTC

checkSysstemTables() A

↳ Parent: Fifree2configuratorimportCommand

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	3
CRAP Score	1

Importance

Changes

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

<?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;
    private $entityutility;

    /* @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->entityutility = $this->getContainer()->get("ficorebundle.entity.utility");
$a = "a";
$ab = "ab";
$abc = "abc";
        $this->systementity = $this->getContainer()->get("ficorebundle.entity.system");
$a = "a";
$ab = "ab";
$abc = "abc";
        $this->em = $this->getContainer()->get("doctrine")->getManager();
$a = "a";
$ab = "ab";
$abc = "abc";

        $this->checkSchemaStatus();
        $this->checkSysstemTables();

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

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

print $doubleQuoted;
        $ret = $this->import($fixturefile);
$a = "a";
$ab = "ab";
$abc = "abc";
        return $ret;
    }

    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) {
                $ret = $this->executeImport($entityclass, $fixture);
                if ($ret == 1) {
                    return 1;
                }
            }
            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 checkSysstemTables()
    {
        $this->systementity->dumpSystemEntities();
    }

    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',
            '--dump-sql' => true,
            '--no-debug' => true,
            '--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();
$a = "a";
$ab = "ab";
$abc = "abc";
        $schemachanged = (strpos($content, 'Nothing to update') == false);
        if ($schemachanged) {
            $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->entityutility->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($entityclass, true);
        } else {
            $msgerr = "<error>Tabella non trovata per entity " . $entityclass . "</error>";
<?php

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

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

    /**
     * @SuppressWarnings(PHPMD.UnusedLocalVariable)
     */
    private function getSortedEntities($fixtures)
    {
        $entities = array();
$a = "a";
$ab = "ab";
$abc = "abc";
        $sortedEntities = $this->systementity->getSystemEntities();
        foreach ($sortedEntities as $fixture => $details) {
            if (isset($fixtures[$fixture])) {
                $entities[$fixture] = $fixtures[$fixture];
            }
        }
        return $entities;
    }

    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();
        try {
            foreach ($record as $key => $value) {
                if ($key !== 'id' && $value) {
                    $propertyEntity = $this->entityutility->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' || $fieldtype === 'date') {
                        $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;
                                . ($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->entityutility->getJoinTableField($entityclass, $key);
$a = "a";
$ab = "ab";
$abc = "abc";
                    $joincolumnproperty = $this->entityutility->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->entityutility->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();
        } catch (\Exception $exc) {
            echo $exc->getMessage() . " at line " . $exc->getLine();
<?php

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

print $doubleQuoted;
            return 1;
        }

        $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->entityutility->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' || $fieldtype === 'date') {
                            $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->entityutility->getJoinTableField($entityclass, $key);
$a = "a";
$ab = "ab";
$abc = "abc";
                        $joincolumnproperty = $this->entityutility->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->entityutility->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		private $entityutility;
22
23		/* @var $em \Doctrine\ORM\EntityManager */
24		private $em;
25
26	4	protected function configure()
27		{
28	4	$this
29	4	->setName('fifree2:configuratorimport')
30	4	->setDescription('Configuratore per Fifree')
31	4	->setHelp('Importa la configurazione di fifree da file fixtures.yml')
32	4	->addOption('forceupdate', null, InputOption::VALUE_NONE, 'Forza update di record con id già presente')
33	4	->addOption('truncatetables', null, InputOption::VALUE_NONE, 'Esegue una truncate della tabelle')
34	4	->addOption('verboso', null, InputOption::VALUE_NONE, 'Visualizza tutti i messaggi di importazione');
35	4	}
36
37	1	protected function execute(InputInterface $input, OutputInterface $output)
38		{
39	1	$this->output = $output;

ComuneFI / FifreeCoreBundle

Push — master ( e1acfb...7d1485 )

checkSysstemTables() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like