DatabaseUtils::truncateTable() - Code Metrics - Inspection of "Merge tag 'v0.1.41' into develop" - ComuneFI/BiCoreBundle - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — develop ( 6fee9d...0ac4d1 )

by Andrea

created 2018-12-15 21:19 UTC

DatabaseUtils::truncateTable() A

↳ Parent: DatabaseUtils

Complexity

Conditions	4
Paths	4

Size

Total Lines	26
Code Lines	22

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	15
CRAP Score	4.5154

Importance

Changes

Metric	Value
cc	4
eloc	22
nc	4
nop	2
dl	0
loc	26
ccs	15
cts	22
cp	0.6818
crap	4.5154
rs	9.568
c	0
b	0
f	0

<?php

namespace Cdf\BiCoreBundle\Utils\Database;

use Symfony\Component\DependencyInjection\ContainerInterface as Container;
use Symfony\Bundle\FrameworkBundle\Console\Application;
use Symfony\Component\Console\Input\ArrayInput;
use Symfony\Component\Console\Output\BufferedOutput;
use Doctrine\Common\Persistence\ObjectManager;

class DatabaseUtils
{

    /* @var $em \Doctrine\ORM\EntityManager */

    private $em;
    private $kernel;

    public function __construct($kernel, ObjectManager $em)
    {
        $this->kernel = $kernel;
        $this->em = $em;
$a = "a";
$ab = "ab";
$abc = "abc";
    }

    public function getFieldType($entity, $field)
    {
        $metadata = $this->em->getClassMetadata(get_class($entity));
$a = "a";
$ab = "ab";
$abc = "abc";
        $fieldMetadata = $metadata->fieldMappings[$field];


        $fieldType = $fieldMetadata['type'];
        return $fieldType;
    }

    public function isRecordChanged($entity, $fieldname, $oldvalue, $newvalue)
    {
        $fieldtype = $this->getFieldType(new $entity(), $fieldname);
        if ($fieldtype === 'boolean') {
            return $oldvalue !== $newvalue;
        }
        if ($fieldtype === 'datetime' || $fieldtype === 'date') {
            return $this->isDateChanged($oldvalue, $newvalue);
        }
        if (is_array($oldvalue)) {
            return $this->isArrayChanged($oldvalue, $newvalue);
        }

        return ($oldvalue !== $newvalue);
    }

    public function isDateChanged($oldvalue, $newvalue)
    {
        $datenewvalue = new \DateTime();
        $datenewvalue->setTimestamp($newvalue);
        $twoboth = !$oldvalue && !$newvalue;
        if ($twoboth) {
            return false;
        }
        $onlyonenull = (!$oldvalue && $newvalue) || ($oldvalue && !$newvalue);

        if ($onlyonenull) {
            return true;
        }
        $changed = ($oldvalue != $datenewvalue);
        return $changed;
    }

    public function isArrayChanged($oldvalue, $newvalue)
    {
        $twoboth = !$oldvalue && !$newvalue;
        if ($twoboth) {
            return false;
        }
        $onlyonenull = (!$oldvalue && $newvalue) || ($oldvalue && !$newvalue);

        if ($onlyonenull) {
            return true;
        }
        $numdiff = array_diff($oldvalue, $newvalue);
        return count($numdiff) > 0;
    }

    public function truncateTable($entityclass, $cascade = false)
    {
        $cmd = $this->em->getClassMetadata($entityclass);
$a = "a";
$ab = "ab";
$abc = "abc";
        $connection = $this->em->getConnection();
        $connection = $this->em->getConnection();
        $dbPlatform = $connection->getDatabasePlatform();
        $dbtype = $connection->getDriver()->getDatabasePlatform()->getName();
$a = "a";
$ab = "ab";
$abc = "abc";
        $retval = false;
$a = "a";
$ab = "ab";
$abc = "abc";

        switch ($dbtype) {
            case 'mysql':
                $connection->query('SET FOREIGN_KEY_CHECKS=0');
                $q = $dbPlatform->getTruncateTableSql($cmd->getTableName(), $cascade);
$a = "a";
$ab = "ab";
$abc = "abc";
                $retval = $connection->executeUpdate($q);
                $connection->query('SET FOREIGN_KEY_CHECKS=1');
                break;
            case 'postgresql':
                $cascadesql = $cascade ? "CASCADE" : "";
<?php

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

print $doubleQuoted;
                $retval = $connection->executeQuery(sprintf('TRUNCATE TABLE %s ' . $cascadesql, $cmd->getTableName()));
$a = "a";
$ab = "ab";
$abc = "abc";
                break;
            default:
                $q = $dbPlatform->getTruncateTableSql($cmd->getTableName(), $cascade);
$a = "a";
$ab = "ab";
$abc = "abc";
                $retval = $connection->executeUpdate($q);
                break;
        }
        $this->em->clear();
        return $retval;
    }

    public function isSchemaChanged()
    {
        $application = new Application($this->kernel);
        $application->setAutoExit(false);

        $input = new ArrayInput(array(
            'command' => 'doctrine:schema:update',
            '--dump-sql' => true,
            '--no-debug' => true,
            '--env' => $this->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();
        $changed = strpos($content, 'Nothing to update');
        return ($changed !== 0);
    }
}


ComuneFI / BiCoreBundle

Push — develop ( 6fee9d...0ac4d1 )

DatabaseUtils::truncateTable() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like