Classes\AdaptersDriver\Mysql::parseForeignKeys()

Complexity

Conditions	11
Paths	25

Size

Total Lines	72
Code Lines	40

Duplication

Lines	40
Ratio	55.56 %

Importance

Changes	5
Bugs	1	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	Mysql::getPDOString()	0	10	1
A	Mysql::getPDOSocketString()	0	9	1

<?php

For compatibility and reusability of your code, PSR1 recommends that a file should introduce either new symbols (like classes, functions, etc.) or have side-effects (like outputting something, or including other files), but not both at the same time. The first symbol is defined on line 18 and the first side effect is on line 9.

namespace Classes\AdaptersDriver;

use Classes\Db\Column;
use Classes\Db\Constrant;
use Classes\Db\DbTable;

require_once 'Classes/AdaptersDriver/AbsractAdapter.php';
require_once 'Classes/Db/Column.php';
require_once 'Classes/Db/Constrant.php';
require_once 'Classes/Db/DbTable.php';

/**
 * @author Pedro Alarcao <phacl151@gmail.com>
 * @link   https://github.com/pedro151/ORM-Generator
 */
class Mysql extends AbsractAdapter
{

    /**
     * @var int
     */
    protected $port = 3306;

    /**
     * converts MySQL data types to PHP data types
     *
     * @param string $str
     *
     * @return string
     */
    protected function convertTypeToPhp ( $str )
    {
        if ( preg_match ( '/(tinyint\(1\)|bit)/' , $str ) )
        {
            $res = 'boolean';
        } elseif ( preg_match ( '/(datetime|timestamp|blob|char|enum|text|date)/' , $str ) )
        {
            $res = 'string';
        } elseif ( preg_match ( '/(decimal|numeric|float|double)/' , $str ) )
        {
            $res = 'float';
        } elseif ( preg_match ( '#^(?:tiny|small|medium|long|big|var)?(\w+)(?:\(\d+\))?(?:\s\w+)*$#' , $str , $matches ) )
        {
            $res = $matches[ 1 ];
        } else
        {
            print "Can't convert column type to PHP - Unrecognized type: $str";
        }

        return $res;

The variable $res does not seem to be defined for all execution paths leading up to this point.

    }

    /**
     * @inheritDoc
     */
    public function parseTables ()

This method seems to be duplicated in your project.

    {
        if ( $this->hasTables () )
        {
            return $this->getAllTables ();
        }

        $schema = 0;
        foreach ( $this->getListColumns () as $table )
        {
            $key = $table [ 'table_name' ];
            if ( ! $this->hasTable ( $key , $schema ) )
            {
                $this->createTable ( $key , $schema );
            }

            $column = Column::getInstance ()
                            ->populate (
                                array (
                                    'name'       => $table [ 'column_name' ] ,
                                    'type'       => $this->convertTypeToPhp ( $table[ 'data_type' ] ) ,
                                    'nullable'   => ( $table[ 'is_nullable' ] == 'YES' ) ,
                                    'max_length' => $table[ 'max_length' ]
                                )
                            );

            $this->getTable ( $key , $schema )
                 ->addColumn ( $column )
                 ->setNamespace (
                     $this->config->createClassNamespace ( $this->getTable ( $key , $schema ) )
                 );
        }
    }

    /**
     * @inheritDoc
     * @return string
     */
    public function getPDOString ()
    {
        return sprintf (
            "mysql:host=%s;port=%s;dbname=%s" ,
            $this->host ,
            $this->port ,
            $this->database

        );
    }

    /**
     * @inheritDoc
     * @return string
     */
    public function getPDOSocketString ()
    {
        return sprintf (
            "mysql:unix_socket=%s;dbname=%s" ,
            $this->socket ,
            $this->database

        );
    }

    /**
     * @inheritDoc
     * @return string[]
     */
    public function getListNameTable ()
    {
        if ( empty( $this->tableList ) )
        {
            $this->tableList = $this->getPDO ()->query (

The property tableList does not exist. Did you maybe forget to declare it?

                "show tables"
            )->fetchAll ();
        }

        return $this->tableList;
    }

    /**
     * retorna multiplos arrays com dados da column em array
     *
     * @return array[]
     */
    public function getListColumns ()
    {

        return $this->getPDO ()->query (
            "select
                0 AS table_schema,
                table_name,
                column_name ,
                data_type,
                is_nullable,
                character_maximum_length AS max_length
            from information_schema.columns
            where table_schema IN ('{$this->database}')
            order by table_name,ordinal_position"
        )->fetchAll ( \PDO::FETCH_ASSOC );
    }

    /**
     * @return array
     */
    public function getListConstrant ()
    {
        return $this->getPDO ()->query (
            "SELECT distinct
     i.constraint_type,
     k.constraint_name,
     --k.table_schema,
     0 AS table_schema,
     k.table_name,
	 k.column_name,
     k.REFERENCED_TABLE_SCHEMA AS foreign_schema,
	 k.REFERENCED_TABLE_NAME AS foreign_table,
	 k.REFERENCED_COLUMN_NAME AS foreign_column
FROM information_schema.TABLE_CONSTRAINTS as i
inner join information_schema.key_column_usage as k
ON i.CONSTRAINT_NAME = k.CONSTRAINT_NAME and k.TABLE_SCHEMA <> 'mysql'
WHERE
i.TABLE_SCHEMA IN ('{$this->database}') AND i.CONSTRAINT_TYPE IN ('FOREIGN KEY', 'PRIMARY KEY' )
order by k.table_schema, k.table_name;"
        )->fetchAll ( \PDO::FETCH_ASSOC );
    }

    /**
     * retorna o numero total de tabelas
     *
     * @return int
     */
    public function getTotalTables ()
    {
        if ( empty( $this->totalTables ) )
        {

            $this->totalTables = $this->getPDO ()->query (
                "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = '{$this->database}'"
            )->fetchColumn ();
        }

        return (int) $this->totalTables;
    }

    /**
     * @inheritDoc
     *
     * @param $table
     * @param $column
     */
    public function getSequence ( $table , $column )
    {
        $return = $this->getPDO ()
                       ->query ( "select * from information_schema.columns where extra like '%auto_increment%' and  TABLE_SCHEMA='{$this->database}' AND TABLE_NAME='{$table}' AND COLUMN_NAME='{$column}';" )
                       ->fetch ( \PDO::FETCH_ASSOC );

        if ( ! $return )
        {
            return;
        }

        return "{$return['TABLE_NAME']}_{$return['COLUMN_NAME']}_seq";
    }

}