DDLGeneration::getMySQLColumnDef() - Code Metrics - dvdoug/DB - Measure and Improve Code Quality continuously with Scrutinizer

DDLGeneration::getMySQLColumnDef() D
last analyzed 2021-01-22 11:38 UTC

↳ Parent: DDLGeneration

Complexity

Conditions	18
Paths	52

Size

Total Lines	74
Code Lines	56

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	48
CRAP Score	18.2716

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	18
eloc	56
c	1
b	0
f	0
nc	52
nop	0
dl	0
loc	74
ccs	48
cts	53
cp	0.9057
crap	18.2716
rs	4.8666

How to fix Long Method Complexity

<?php

declare(strict_types=1);
/**
 * Database Access Layer.
 * @author Doug Wright
 */

namespace DVDoug\DB;

use function addslashes;
use function array_intersect_key;
use function array_map;
use function array_unique;
use function asort;
use function explode;
use function implode;
use function in_array;
use function sprintf;
use function strpos;
use function strtolower;
use function substr;
use function trim;

/**
 * Metadata about a database column.
 * @author Doug Wright
 */
trait DDLGeneration
{
    /**
     * Get MySQL column definition.
     */
    public function getMySQLColumnDef(): string
    {
        $def = '`' . strtolower($this->getName()) . '` ';
        $def = '`' . strtolower($this->/** @scrutinizer ignore-call */ getName()) . '` ';
        $MySQLType = $this->getMySQLType();
        $MySQLType = $this->getMySQLType();
        if (strpos($MySQLType, 'UNSIGNED') !== false) {
            $unsigned = true;
            $MySQLType = substr($MySQLType, 0, -9);
        } else {
            $unsigned = false;
        }

        if (in_array($MySQLType, ['ENUM', 'SET'])) {
            $query = sprintf('SHOW COLUMNS FROM %s.%s LIKE %s',
                $this->connection->quoteIdentifier($this->database),
                $this->connection->quoteIdentifier($this->table),
                $this->connection->escape($this->name));

            $statement = $this->connection->query($query);
            $values = $statement->fetchAssoc(false)['Type'];
            $values = explode("','", substr($values, strpos($values, '(') + 2, -2));
            $values = array_intersect_key($values, array_unique(array_map('strtolower', $values)));
            asort($values);

            $def .= $MySQLType;
            $def .= '(' . implode(', ', array_map(function ($c) {return "'" . addslashes($c) . "'"; }, $values)) . ')';
        } elseif (in_array($MySQLType, ['CHAR', 'VARCHAR']) && $this->getLength() < 64 && $this->getDistinctValueCount() <= 16) {
        } elseif (in_array($MySQLType, ['CHAR', 'VARCHAR']) && $this->getLength() < 64 && $this->/** @scrutinizer ignore-call */ getDistinctValueCount() <= 16) {
            $query = sprintf('SELECT DISTINCT %s FROM %s.%s WHERE %s IS NOT NULL ORDER BY %s ASC',
                $this->connection->quoteIdentifier($this->name),
                $this->connection->quoteIdentifier($this->database),
                $this->connection->quoteIdentifier($this->table),
                $this->connection->quoteIdentifier($this->name),
                $this->connection->quoteIdentifier($this->name));
            $values = [];
            foreach ($this->connection->query($query) as $value) {
                $values[] = trim($value[$this->name]);
            }
            $values = array_intersect_key($values, array_unique(array_map('strtolower', $values)));
            asort($values);

            if ($values) {
                $def .= 'ENUM';
                $def .= '(' . implode(', ', array_map(function ($c) {return "'" . addslashes($c) . "'"; }, $values)) . ')';
            } else {
                $def .= $MySQLType;
                if ($this->getLength() > 0) {
                    $def .= '(' . $this->getLength() . ')';
                }
            }
        } elseif (in_array($MySQLType, ['DATETIME', 'TIMESTAMP', 'TIME'])) {
            $def .= $MySQLType;
            $def .= '(' . (int) $this->getScale() . ')';
            $def .= '(' . (int) $this->/** @scrutinizer ignore-call */ getScale() . ')';
        } else {
            $def .= $MySQLType;

            if ($this->getScale() && !in_array($MySQLType, ['DATE'])) {
                $def .= '(' . $this->getPrecision() . ',' . $this->getScale() . ')';
                $def .= '(' . $this->/** @scrutinizer ignore-call */ getPrecision() . ',' . $this->getScale() . ')';
            } elseif ($this->getPrecision() && !in_array($MySQLType, ['TINYINT', 'SMALLINT', 'MEDIUMINT', 'INT', 'BIGINT'])) {
                $def .= '(' . $this->getPrecision() . ')';
            } elseif ($this->getLength() > 0 && !in_array($MySQLType, ['TINYINT', 'SMALLINT', 'MEDIUMINT', 'INT', 'BIGINT'])) {
                $def .= '(' . $this->getLength() . ')';
            }

            if ($unsigned) {
                $def .= ' UNSIGNED';
            }
        }

        if ($this->isNullable()) {
        if ($this->/** @scrutinizer ignore-call */ isNullable()) {
            $def .= ' NULL';
        } else {
            $def .= ' NOT NULL';
        }

        return $def;
    }

    /**
     * Get Oracle column definition.
     */
    public function getOracleColumnDef(): string
    {
        $def = '`' . strtolower($this->getName()) . '` ';

        $def .= $this->getOracleType();
        $def .= $this->/** @scrutinizer ignore-call */ getOracleType();

        if ($this->getScale()) {
            $def .= '(' . $this->getPrecision() . ',' . $this->getScale() . ')';
        } elseif ($this->getPrecision()) {
            $def .= '(' . $this->getPrecision() . ')';
        } elseif ($this->getLength()) {
            $def .= '(' . $this->getLength() . ')';
        }

        if ($this->isNullable()) {
            $def .= ' NULL';
        } else {
            $def .= ' NOT NULL';
        }

        return $def;
    }
}


dvdoug / DB

DDLGeneration::getMySQLColumnDef() D last analyzed 2021-01-22 11:38 UTC

Complexity

Size

Duplication

Code Coverage

Importance

How to fix Long Method Complexity

Long Method

Duplication Side-by-Side

Filter issues like

DDLGeneration::getMySQLColumnDef() D
last analyzed 2021-01-22 11:38 UTC