ManagesViews::createMaterializedView() - Code Metrics - Inspection of "Merge branch '1.6'" - staudenmeir/laravel-migration-views - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( b9affb...b0865c )

by Jonas

created 2024-02-05 14:02 UTC

ManagesViews::createMaterializedView() A

↳ Parent: ManagesViews

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	2
CRAP Score	1

Importance

Changes

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

<?php

namespace Staudenmeir\LaravelMigrationViews\Schema\Builders;

use Illuminate\Database\Eloquent\Builder as EloquentBuilder;
use Illuminate\Database\Query\Builder as QueryBuilder;
use Illuminate\Support\Str;

trait ManagesViews
{
    /**
     * Create a new view on the schema.
     *
     * @param string $name
     * @param \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|string $query
     * @param array|null $columns
     * @param bool $orReplace
     * @param bool $materialized
     * @return void
     */
    public function createView($name, $query, array $columns = null, $orReplace = false, bool $materialized = false)
    {
        $query = $this->getQueryString($query);

        $this->connection->statement(
            $this->grammar->compileCreateView($name, $query, $columns, $orReplace, $materialized)
        );
    }

    /**
     * Create a new view on the schema or replace an existing one.
     *
     * @param string $name
     * @param \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|string $query
     * @param array|null $columns
     * @return void
     */
    public function createOrReplaceView($name, $query, array $columns = null)
    {
        $this->createView($name, $query, $columns, true);
    }

    /**
     * Create a new materialized view on the schema.
     *
     * @param string $name
     * @param \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|string $query
     * @param array|null $columns
     * @return void
     */
    public function createMaterializedView(string $name, EloquentBuilder|QueryBuilder $query, array $columns = null): void
    {
        $this->createView($name, $query, $columns, materialized: true);
    }

    /**
     * Convert the query and its bindings to an SQL string.
     *
     * @param \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|string $query
     * @return string
     */
    protected function getQueryString($query)
    {
        if (is_string($query)) {
            return $query;
        }

        $bindings = $this->stringifyBindings(
            $query->getBindings()
            /** @scrutinizer ignore-type */ $query->getBindings()
        );

        return Str::replaceArray('?', $bindings, $query->toSql());
        return Str::replaceArray('?', $bindings, /** @scrutinizer ignore-type */ $query->toSql());
    }

    /**
     * Stringify the query bindings.
     *
     * @param array $bindings
     * @return array
     */
    protected function stringifyBindings(array $bindings)
    {
        $bindings = $this->connection->prepareBindings($bindings);

        foreach ($bindings as &$binding) {
            if (is_object($binding)) {
                $binding = (string) $binding;
            }

            if (is_string($binding)) {
                $binding = $this->connection->getPdo()->quote($binding);
            }
        }

        return $bindings;
    }

    /**
     * Rename a view on the schema.
     *
     * @param string $from
     * @param string $to
     * @return void
     */
    public function renameView($from, $to)
    {
        $this->rename($from, $to);
               rename($from, $to);
    }

    /**
     * Drop a view from the schema.
     *
     * @param string $name
     * @param bool $ifExists
     * @return void
     */
    public function dropView($name, $ifExists = false)
    {
        $this->connection->statement(
            $this->grammar->compileDropView($name, $ifExists)
        );
    }

    /**
     * Drop a view from the schema if it exists.
     *
     * @param string $name
     * @return void
     */
    public function dropViewIfExists($name)
    {
        $this->dropView($name, true);
    }

    /**
     * Determine if the given view exists on the schema.
     *
     * @param string $name
     * @return bool
     */
    public function hasView($name)
    {
        $view = $this->connection->getTablePrefix().$name;

        $view = $this->connection->selectOne(
            $this->grammar->compileViewExists(),
            $this->getBindingsForHasView($view)
        );

        return !is_null($view);
    }

    /**
     * Get the bindings for a "Has View" statement.
     *
     * @param string $view
     * @return array
     */
    protected function getBindingsForHasView($view)
    {
        return [$this->connection->getDatabaseName(), $view];
    }

    /**
     * Get the column listing for a given view.
     *
     * @param string $name
     * @return array
     */
    public function getViewColumnListing($name)
    {
        return $this->getColumnListing($name);
        return $this->/** @scrutinizer ignore-call */ getColumnListing($name);
    }

    /**
     * Refresh a materialized view on the schema.
     *
     * @param string $name
     * @return void
     */
    public function refreshMaterializedView(string $name): void
    {
        $this->connection->statement(
            $this->grammar->compileRefreshMaterializedView($name)
        );
    }
}


staudenmeir / laravel-migration-views

Push — master ( b9affb...b0865c )

ManagesViews::createMaterializedView() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like