KitLoong\MigrationsGenerator\Repositories\PgSQLRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	29
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	getTypeByColumnName()	0	26	2

<?php
/**
 * Created by PhpStorm.
 * User: liow.kitloong
 * Date: 2020/04/07
 */

namespace KitLoong\MigrationsGenerator\Repositories;

use Illuminate\Support\Facades\DB;
use KitLoong\MigrationsGenerator\MigrationGeneratorSetting;

class PgSQLRepository
{
    public function getTypeByColumnName(string $table, string $columnName): ?string
    {
        /** @var MigrationGeneratorSetting $setting */
        $setting = app(MigrationGeneratorSetting::class);

        $column = DB::connection($setting->getConnection())
            ->select("SELECT
    pg_catalog.format_type(a.atttypid, a.atttypmod) as \"datatype\"
FROM
    pg_catalog.pg_attribute a
WHERE
    a.attnum > 0
    AND NOT a.attisdropped
    AND a.attrelid = (
        SELECT c.oid
        FROM pg_catalog.pg_class c
            LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
        WHERE c.relname ~ '^(${table})$'
            AND pg_catalog.pg_table_is_visible(c.oid)
    )
    AND a.attname='${columnName}'");
        if (count($column) > 0) {
            return $column[0]->datatype;
        }
        return null;
    }
}