PostgresGrammar::compileViewExists() - Code Metrics - Inspection of "WIP: Feature/triggers" - umbrellio/laravel-pg-extensions - Measure and Improve Code Quality continuously with Scrutinizer

Failed Conditions
Pull Request — master (#28)

by Dallas
created 2024-05-03 08:47 UTC
PostgresGrammar::compileViewExists() A

↳ Parent: PostgresGrammar
Complexity

Conditions	1
Paths	1
Size

Total Lines	3
Code Lines	1
Duplication

Lines	0
Ratio	0 %
Code Coverage

Tests	0
CRAP Score	2
Importance

Changes
Metric	Value
eloc	1
dl	0
loc	3
rs	10
c	0
b	0
f	0
ccs	0
cts	0
cp	0
cc	1
nc	1
nop	0
crap	2
<?php

declare(strict_types=1);

namespace Umbrellio\Postgres\Schema\Grammars;

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Schema\Grammars\PostgresGrammar as BasePostgresGrammar;
use Illuminate\Support\Fluent;
use Umbrellio\Postgres\Compilers\AttachPartitionCompiler;
use Umbrellio\Postgres\Compilers\CheckCompiler;
use Umbrellio\Postgres\Compilers\CreateCompiler;
use Umbrellio\Postgres\Compilers\CreateFunctionCompiler;
use Umbrellio\Postgres\Compilers\CreateProcedureCompiler;
use Umbrellio\Postgres\Compilers\CreateTriggerCompiler;
use Umbrellio\Postgres\Compilers\DropFunctionCompiler;
use Umbrellio\Postgres\Compilers\DropProcedureCompiler;
use Umbrellio\Postgres\Compilers\DropTriggerCompiler;
use Umbrellio\Postgres\Compilers\ExcludeCompiler;
use Umbrellio\Postgres\Compilers\UniqueCompiler;
use Umbrellio\Postgres\Schema\Builders\Constraints\Check\CheckBuilder;
use Umbrellio\Postgres\Schema\Builders\Constraints\Exclude\ExcludeBuilder;
use Umbrellio\Postgres\Schema\Builders\Indexes\Unique\UniqueBuilder;
use Umbrellio\Postgres\Schema\Builders\Indexes\Unique\UniquePartialBuilder;
use Umbrellio\Postgres\Schema\Builders\Routines\CreateFunctionBuilder;
use Umbrellio\Postgres\Schema\Builders\Routines\CreateProcedureBuilder;
use Umbrellio\Postgres\Schema\Builders\Routines\CreateTriggerBuilder;
use Umbrellio\Postgres\Schema\Builders\Routines\DropFunctionBuilder;
use Umbrellio\Postgres\Schema\Builders\Routines\DropProcedureBuilder;
use Umbrellio\Postgres\Schema\Builders\Routines\DropTriggerBuilder;
use Umbrellio\Postgres\Schema\Types\DateRangeType;
use Umbrellio\Postgres\Schema\Types\NumericType;
use Umbrellio\Postgres\Schema\Types\TsRangeType;
use Umbrellio\Postgres\Schema\Types\TsTzRangeType;

class PostgresGrammar extends BasePostgresGrammar
{
    public function compileCreate(Blueprint $blueprint, Fluent $command): string
    {
        $like = $this->getCommandByName($blueprint, 'like');
        $ifNotExists = $this->getCommandByName($blueprint, 'ifNotExists');

        return CreateCompiler::compile(
            $this,
            $blueprint,
            $this->getColumns($blueprint),
            compact('like', 'ifNotExists')
        );
    }

    /**
     * @codeCoverageIgnore
     */
    public function compileAttachPartition(Blueprint $blueprint, Fluent $command): string
    {
        return AttachPartitionCompiler::compile($this, $blueprint, $command);
    }

    /**
     * @codeCoverageIgnore
     */
    public function compileDetachPartition(Blueprint $blueprint, Fluent $command): string
    {
        return sprintf(
            'alter table %s detach partition %s',
            $this->wrapTable($blueprint),
            $command->get('partition')
        );
    }

    /**
     * @codeCoverageIgnore
     */
    public function compileCreateView(Blueprint $blueprint, Fluent $command): string
    public function compileCreateView(/** @scrutinizer ignore-unused */ Blueprint $blueprint, Fluent $command): string
    {
        $materialize = $command->get('materialize') ? 'materialized' : '';
        return implode(' ', array_filter([
            'create',
            $materialize,
            'view',
            $this->wrapTable($command->get('view')),
            'as',
            $command->get('select'),
        ]));
    }

    public function compileCreateTrigger(Blueprint $blueprint, CreateTriggerBuilder $command): array
    {
        return CreateTriggerCompiler::compile($this, $blueprint, $command);
    }

    public function compileCreateFunction(Blueprint $blueprint, CreateFunctionBuilder $command): array
    {
        return CreateFunctionCompiler::compile($this, $blueprint, $command);
    }

    public function compileCreateProcedure(Blueprint $blueprint, CreateProcedureBuilder $command): array
    {
        return CreateProcedureCompiler::compile($this, $blueprint, $command);
    }

    public function compileDropTrigger(Blueprint $blueprint, DropTriggerBuilder $command): array
    {
        return DropTriggerCompiler::compile($this, $blueprint, $command);
    }

    public function compileDropFunction(Blueprint $blueprint, DropFunctionBuilder $command): string
    {
        return DropFunctionCompiler::compile($this, $blueprint, $command);
    }

    public function compileDropProcedure(Blueprint $blueprint, DropProcedureBuilder $command): string
    {
        return DropProcedureCompiler::compile($this, $blueprint, $command);
    }

    /**
     * @codeCoverageIgnore
     */
    public function compileDropView(Blueprint $blueprint, Fluent $command): string
    public function compileDropView(/** @scrutinizer ignore-unused */ Blueprint $blueprint, Fluent $command): string
    {
        return 'drop view ' . $this->wrapTable($command->get('view'));
    }

    /**
     * @codeCoverageIgnore
     */
    public function compileViewExists(): string
    {
        return 'select * from information_schema.views where table_schema = ? and table_name = ?';
    }

    /**
     * @codeCoverageIgnore
     */
    public function compileForeignKeysListing(string $tableName): string
    {
        return sprintf("
            SELECT
                kcu.column_name as source_column_name,
                ccu.table_name AS target_table_name,
                ccu.column_name AS target_column_name
            FROM
                information_schema.table_constraints AS tc
                    JOIN information_schema.key_column_usage AS kcu
                         ON tc.constraint_name = kcu.constraint_name
                             AND tc.table_schema = kcu.table_schema
                    JOIN information_schema.constraint_column_usage AS ccu
                         ON ccu.constraint_name = tc.constraint_name
                             AND ccu.table_schema = tc.table_schema
            WHERE tc.constraint_type = 'FOREIGN KEY' AND tc.table_name='%s';
        ", $tableName);
    }

    /**
     * @codeCoverageIgnore
     */
    public function compileViewDefinition(): string
    {
        return 'select view_definition from information_schema.views where table_schema = ? and table_name = ?';
    }

    public function compileUniquePartial(Blueprint $blueprint, UniqueBuilder $command): string
    {
        $constraints = $command->get('constraints');
        if ($constraints instanceof UniquePartialBuilder) {
            return UniqueCompiler::compile($this, $blueprint, $command, $constraints);
        }
        return $this->compileUnique($blueprint, $command);
    }

    public function compileExclude(Blueprint $blueprint, ExcludeBuilder $command): string
    {
        return ExcludeCompiler::compile($this, $blueprint, $command);
    }

    public function compileCheck(Blueprint $blueprint, CheckBuilder $command): string
    {
        return CheckCompiler::compile($this, $blueprint, $command);
    }

    protected function typeNumeric(Fluent $column): string
    {
        $type = NumericType::TYPE_NAME;
        $precision = $column->get('precision');
        $scale = $column->get('scale');

        if ($precision && $scale) {
            return "{$type}({$precision}, {$scale})";
        }

        if ($precision) {
            return "{$type}({$precision})";
        }

        return $type;
    }

    protected function typeTsrange(Fluent $column): string
    protected function typeTsrange(/** @scrutinizer ignore-unused */ Fluent $column): string
    {
        return TsRangeType::TYPE_NAME;
    }

    protected function typeTstzrange(Fluent $column): string
    protected function typeTstzrange(/** @scrutinizer ignore-unused */ Fluent $column): string
    {
        return TsTzRangeType::TYPE_NAME;
    }

    protected function typeDaterange(Fluent $column): string
    protected function typeDaterange(/** @scrutinizer ignore-unused */ Fluent $column): string
    {
        return DateRangeType::TYPE_NAME;
    }
}

umbrellio / laravel-pg-extensions

Pull Request — master (#28)

PostgresGrammar::compileViewExists() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like
