TableInformation::getConstraintsGroupByName() - Code Metrics - Inspection of "Unified duplicated code on TableInformation" - shawe/FSConsoleTools - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Push — master ( ff9e28...8752e2 )

by Francesc
created 2018-05-28 23:04 UTC
TableInformation::getConstraintsGroupByName() A

↳ Parent: TableInformation
Complexity

Conditions	3
Paths	3
Size

Total Lines	12
Code Lines	8
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	3
eloc	8
nc	3
nop	0
dl	0
loc	12
rs	9.4285
c	0
b	0
f	0
<?php
/**
 * Created by PhpStorm.
 * User: shawe [email protected]
 * Date: 26/05/18
 * Time: 22:11
 */

namespace FacturaScriptsUtils\Console\Command\Common;

use FacturaScripts\Core\Base\DataBase;
filter:
    dependency_paths: ["lib/*"]

/**
 * Trait TableInformation.
 *
 * @author Francesc Pineda Segarra <[email protected]>
 */
trait TableInformation
{

    /**
     * Folder destiny path.
     *
     * @var string
     */
    private $dstFolder;

    /**
     * Name of the model.
     *
     * @var string
     */
    private $modelName;

    /**
     * Name of the table.
     *
     * @var string
     */
    private $tableName;

    /**
     * Set destiny folder.
     *
     * @param string $dstFolder
     *
     * @return $this
     */
    public function setDstFolder(string $dstFolder): self
    {
        $this->dstFolder = $dstFolder;
        return $this;
    }

    /**
     * Set the model name to use.
     *
     * @param string $modelName
     *
     * @return $this
     */
    public function setModelName(string $modelName): self
    {
        $this->modelName = $modelName;
        return $this;
    }

    /**
     * Set table name to use.
     *
     * @param string $tableName
     *
     * @return $this
     */
    public function setTableName(string $tableName): self
    {
        $this->tableName = $tableName;
        return $this;
    }

    /**
     * Return the folder destiny path.
     *
     * @return string
     */
    public function getDstFolder(): string
    {
        return $this->dstFolder;
    }

    /**
     * Return the model name.
     *
     * @return string
     */
    public function getModelName(): string
    {
        return $this->modelName;
    }

    /**
     * Return the table name.
     *
     * @return string
     */
    public function getTableName(): string
    {
        return $this->tableName;
    }

    /**
     * Returns an array with tables.
     *
     * @param DataBase $dataBase
     *
     * @return array
     */
    public function getTables(DataBase $dataBase): array
    {
        return $dataBase->getTables();
    }

    /**
     * Returns an array with the columns of a given table.
     *
     * @param DataBase $dataBase
     * @param string   $tableName
     *
     * @return array
     */
    public function getItemsFromTable(DataBase $dataBase, string $tableName): array
    {
        return $dataBase->getColumns($tableName);
    }

    /**
     * Returns an array with the constraints of a table.
     *
     * @param DataBase $dataBase
     * @param string   $tableName
     *
     * @return array
     */
    public function getConstraintFromTable(DataBase $dataBase, $tableName): array
    {
        return $dataBase->getConstraints($tableName, true);
    }

    /**
     * Return constraints grouped by name.
     *
     * @return array
     */
    public function getConstraintsGroupByName(): array
    {
        $constraint = [];
        foreach ($this->getConstraintFromTable($this->getDataBase(), $this->getTableName()) as $cons) {
        foreach ($this->getConstraintFromTable($this->/** @scrutinizer ignore-call */ getDataBase(), $this->getTableName()) as $cons) {
            if (isset($constraint[$cons['name']])) {
                $constraint[$cons['name']]['column_name'] .= ', ' . $cons['column_name'];
            } else {
                $constraint[$cons['name']] = $cons;
            }
        }
        \ksort($constraint);
        return $constraint;
    }

    /**
     * Return items from table by type.
     *
     * @param string $type
     *
     * @return array
     */
    public function getItemsFromTableBy(string $type = ''): array
    {
        $items = [];
        foreach ($this->getItemsFromTable($this->getDataBase(), $this->getTableName()) as $item) {
            $colType = $this->parseType($item['type'], 'view');
            if (0 === \strpos($colType, $type)) {
                $items[] = $item;
            }
        }
        return $items;
    }

    /**
     * Return items from table ordered, primary key first.
     *
     * @return array
     */
    public function getItemsFromTableOrdered(): array
    {
        $items = [];
        $primaryKey = null;
        foreach ($this->getItemsFromTable($this->getDataBase(), $this->getTableName()) as $item) {
            $items[] = $item;
            if (0 === \strpos($item['default'], 'nextval')) {
                $primaryKey = array_pop($items);
            }
        }
        array_unshift($items, $primaryKey);
        return $items;
    }

    /**
     * Return a list of tables.
     *
     * @return string
     */
    public function getTablesMsg(): string
    {
        return \implode(', ', $this->getTables($this->dataBase));
    }

    /**
     * Convert type to XML/PHP type.
     *
     * @param string $type
     * @param string $usedOn
     *
     * @return string
     */
    public function parseType($type = '', string $usedOn = ''): string
    {
        switch ($usedOn) {
            case 'table':
                $type = str_replace('varchar', 'character varying', $type);
                $type = preg_replace('/^double$/', 'double precision', $type);
                $type = preg_replace('/^int\(\d+\)/', 'integer', $type);
                $type = preg_replace('/tinyint\(1\)/', 'boolean', $type);
                $type = preg_replace('/^timestamp$/', 'timestamp without time zone', $type);
                break;
            case 'php':
                $type = preg_replace('/^varchar\(\d+\)/', 'string', $type);
                $type = preg_replace('/^character varying\(\d+\)/', 'string', $type);
                $type = str_replace('text', 'string', $type);
                $type = str_replace('double precision', 'float', $type);
                $type = preg_replace('/^int\(\d+\)/', 'int', $type);
                $type = preg_replace('/tinyint\(1\)/', 'bool', $type);
                $type = preg_replace('/^timestamp$/', 'string', $type);
                $type = str_replace('date', 'string', $type);
                break;
            case 'view':
                $type = preg_replace('/^character varying\(\d+\)/', 'text', $type);
                $type = str_replace('double precision', 'number-decimal', $type);
                $type = str_replace('integer', 'number', $type);
                $type = str_replace('boolean', 'checkbox', $type);
                $type = preg_replace('/^timestamp$/', 'text', $type);
                $type = str_replace('time without time zone', 'text', $type);
                $type = str_replace('date', 'datepicker', $type);
                break;
        }

        return $type;
    }
}

shawe / FSConsoleTools

Push — master ( ff9e28...8752e2 )

TableInformation::getConstraintsGroupByName() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
