Blueprint::createView() - 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 2020-12-23 23:12 UTC
Blueprint::createView() A

↳ Parent: Blueprint
Complexity

Conditions	1
Paths	1
Size

Total Lines	3
Code Lines	1
Duplication

Lines	0
Ratio	0 %
Importance

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

declare(strict_types=1);

namespace Umbrellio\Postgres\Schema;

use Illuminate\Database\Schema\Blueprint as BaseBlueprint;
use Illuminate\Database\Schema\ColumnDefinition;
use Illuminate\Support\Facades\Schema;
use Illuminate\Support\Fluent;
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\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\Definitions\Indexes\CheckDefinition;
use Umbrellio\Postgres\Schema\Definitions\Indexes\ExcludeDefinition;
use Umbrellio\Postgres\Schema\Definitions\Indexes\UniqueDefinition;
use Umbrellio\Postgres\Schema\Definitions\Routines\Functions\CreateFunctionDefinition;
use Umbrellio\Postgres\Schema\Definitions\Routines\Functions\DropFunctionDefinition;
use Umbrellio\Postgres\Schema\Definitions\Routines\Procedures\CreateProcedureDefinition;
use Umbrellio\Postgres\Schema\Definitions\Routines\Procedures\DropProcedureDefinition;
use Umbrellio\Postgres\Schema\Definitions\Routines\Triggers\CreateTriggerDefinition;
use Umbrellio\Postgres\Schema\Definitions\Routines\Triggers\DropTriggerDefinition;
use Umbrellio\Postgres\Schema\Definitions\Tables\AttachPartitionDefinition;
use Umbrellio\Postgres\Schema\Definitions\Tables\LikeDefinition;
use Umbrellio\Postgres\Schema\Definitions\Views\ViewDefinition;

class Blueprint extends BaseBlueprint
{
    /**
     * @return AttachPartitionDefinition
     */
    public function attachPartition(string $partition)
    {
        return $this->addCommand('attachPartition', compact('partition'));
        return $this->/** @scrutinizer ignore-call */ addCommand('attachPartition', compact('partition'));
    }

    public function detachPartition(string $partition): void
    {
        $this->addCommand('detachPartition', compact('partition'));
    }

    /**
     * @return LikeDefinition
     */
    public function like(string $table)
    {
        return $this->addCommand('like', compact('table'));
    }

    public function ifNotExists(): Fluent
    {
        return $this->addCommand('ifNotExists');
    }

    /**
     * @param array|string $columns
     * @return UniqueDefinition
     */
    public function uniquePartial($columns, ?string $index = null, ?string $algorithm = null)
    {
        $columns = (array) $columns;

        $index = $index ?: $this->createIndexName('unique', $columns);
        $index = $index ?: $this->/** @scrutinizer ignore-call */ createIndexName('unique', $columns);

        return $this->addExtendedCommand(

            UniqueBuilder::class,
            'uniquePartial',
            compact('columns', 'index', 'algorithm')
        );
    }

    public function dropUniquePartial($index): Fluent
    {
        return $this->dropIndexCommand('dropIndex', 'unique', $index);
        return $this->/** @scrutinizer ignore-call */ dropIndexCommand('dropIndex', 'unique', $index);
    }

    /**
     * @param array|string $columns
     * @return ExcludeDefinition
     */
    public function exclude($columns, ?string $index = null)
    {
        $columns = (array) $columns;

        $index = $index ?: $this->createIndexName('excl', $columns);

        return $this->addExtendedCommand(ExcludeBuilder::class, 'exclude', compact('columns', 'index'));

    }

    /**
     * @param array|string $columns
     * @return CheckDefinition
     */
    public function check($columns, ?string $index = null)
    {
        $columns = (array) $columns;

        $index = $index ?: $this->createIndexName('chk', $columns);

        return $this->addExtendedCommand(CheckBuilder::class, 'check', compact('columns', 'index'));

    }

    public function dropExclude($index): Fluent
    {
        return $this->dropIndexCommand('dropUnique', 'excl', $index);
    }

    public function dropCheck($index): Fluent
    {
        return $this->dropIndexCommand('dropUnique', 'chk', $index);
    }

    public function hasIndex($index, bool $unique = false): bool
    {
        if (is_array($index)) {
            $index = $this->createIndexName($unique === false ? 'index' : 'unique', $index);
        }

        return array_key_exists($index, $this->getSchemaManager()->listTableIndexes($this->getTable()));
        return array_key_exists($index, $this->getSchemaManager()->listTableIndexes($this->/** @scrutinizer ignore-call */ getTable()));
    }

    /**
     * @return ViewDefinition
     */
    public function createView(string $view, string $select, bool $materialize = false)
    {
        return $this->addCommand('createView', compact('view', 'select', 'materialize'));
    }

    /**
     * @return CreateTriggerDefinition
     */
    public function createTrigger(string $name)
    {
        return $this->addExtendedCommand(CreateTriggerBuilder::class, 'createTrigger', compact('name'));

    }

    /**
     * @return CreateFunctionDefinition
     */
    public function createFunction(string $name)
    {
        return $this->addExtendedCommand(CreateFunctionBuilder::class, 'createFunction', compact('name'));

    }

    /**
     * @return CreateProcedureDefinition
     */
    public function createProcedure(string $name)
    {
        return $this->addExtendedCommand(CreateProcedureBuilder::class, 'createProcedure', compact('name'));

    }

    /**
     * @return DropFunctionDefinition
     */
    public function dropFunction(string $name)
    {
        return $this->addExtendedCommand(DropFunctionBuilder::class, 'dropFunction', compact('name'));

    }

    /**
     * @return DropProcedureDefinition
     */
    public function dropProcedure(string $name)
    {
        return $this->addExtendedCommand(DropProcedureBuilder::class, 'dropProcedure', compact('name'));

    }

    public function dropView(string $view): Fluent
    {
        return $this->addCommand('dropView', compact('view'));
    }

    /**
     * @return DropTriggerDefinition
     */
    public function dropTrigger(string $name, bool $dropDepends = false)
    {
        return $this->addExtendedCommand(DropTriggerBuilder::class, 'dropTrigger', compact('name', 'dropDepends'));

    }

    /**
     * Almost like 'decimal' type, but can be with variable precision (by default)
     */
    public function numeric(string $column, ?int $precision = null, ?int $scale = null): ColumnDefinition
    {
        return $this->addColumn('numeric', $column, compact('precision', 'scale'));
        return $this->/** @scrutinizer ignore-call */ addColumn('numeric', $column, compact('precision', 'scale'));
    }

    public function tsrange(string $column): ColumnDefinition
    {
        return $this->addColumn('tsrange', $column);
    }

    protected function getSchemaManager()
    {
        return Schema::getConnection()->getDoctrineSchemaManager();
    }

    private function addExtendedCommand(string $fluent, string $name, array $parameters = [])
    {
        $command = new $fluent(array_merge(compact('name'), $parameters));
        $this->commands[] = $command;

        return $command;
    }
}

umbrellio / laravel-pg-extensions

Pull Request — master (#28)

Blueprint::createView() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
