cakephp / phinx

    /**

     * {@inheritdoc}

     */

    public function getColumns($tableName)

    {

        $columns = [];

        $rows = $this->fetchAll(sprintf('SHOW COLUMNS FROM %s', $this->quoteTableName($tableName)));

        foreach ($rows as $columnInfo) {

            $phinxType = $this->getPhinxType($columnInfo['Type']);

            $column = new Column();

            $column->setName($columnInfo['Field'])

                   ->setNull($columnInfo['Null'] !== 'NO')

                   ->setDefault($columnInfo['Default'])

                   ->setType($phinxType['name'])

                   ->setSigned(strpos($columnInfo['Type'], 'unsigned') === false)

                   ->setLimit($phinxType['limit']);

            if ($columnInfo['Extra'] === 'auto_increment') {

                $column->setIdentity(true);

            }

            if (isset($phinxType['values'])) {

                $column->setValues($phinxType['values']);

            }

            $columns[] = $column;

        }

        return $columns;

    }

    /**

     * {@inheritdoc}

    /**

     * {@inheritdoc}

     */

    public function getColumns($tableName)

    {

        $columns = [];

        $sql = sprintf(

            "SELECT column_name, data_type, is_identity, is_nullable,

             column_default, character_maximum_length, numeric_precision, numeric_scale

             FROM information_schema.columns

             WHERE table_name ='%s'",

            $tableName

        );

        $columnsInfo = $this->fetchAll($sql);

        foreach ($columnsInfo as $columnInfo) {

            $column = new Column();

            $column->setName($columnInfo['column_name'])

                   ->setType($this->getPhinxType($columnInfo['data_type']))

                   ->setNull($columnInfo['is_nullable'] === 'YES')

                   ->setDefault($columnInfo['column_default'])

                   ->setIdentity($columnInfo['is_identity'] === 'YES')

                   ->setPrecision($columnInfo['numeric_precision'])

                   ->setScale($columnInfo['numeric_scale']);

            if (preg_match('/\bwith time zone$/', $columnInfo['data_type'])) {

                $column->setTimezone(true);

            }

            if (isset($columnInfo['character_maximum_length'])) {

                $column->setLimit($columnInfo['character_maximum_length']);

            }

            $columns[] = $column;

        }

        return $columns;

    }

    /**

     * {@inheritdoc}