SQLiteBuilder::createView() - Code Metrics - Inspection of "Support Laravel 8" - staudenmeir/laravel-migration-views - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 3415eb...56b5c5 )

by Jonas

created 2020-08-19 21:27 UTC

SQLiteBuilder::createView() A

↳ Parent: SQLiteBuilder

Complexity

Conditions	2
Paths	2

Size

Total Lines	7
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	4
CRAP Score	2

Importance

Changes	1
Bugs	0	Features	0

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

<?php

namespace Staudenmeir\LaravelMigrationViews\Schema\Builders;

use Illuminate\Database\Schema\SQLiteBuilder as Base;
use Illuminate\Support\Str;

class SQLiteBuilder extends Base
{
    use ManagesViews {
        createView as createViewParent;
    }

    /**
     * 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
     * @return void
     */
    public function createView($name, $query, array $columns = null, $orReplace = false)
    {
        if ($orReplace) {
            $this->dropViewIfExists($name);
        }

        $this->createViewParent($name, $query, $columns);
    }

    /**
     * Rename a view on the schema.
     *
     * @param string $from
     * @param string $to
     * @return void
     */
    public function renameView($from, $to)
    {
        $view = $this->connection->selectOne(
            "select * from sqlite_master where type = 'view' and name = ?",
            [$this->connection->getTablePrefix().$from]
        );

        $this->dropView($from);

        $query = Str::replaceFirst(
            $this->grammar->wrapTable($from),
            $this->grammar->wrapTable($to),
            $view->sql
        );

        $this->connection->statement($query);
    }

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


1		<?php
2
3		namespace Staudenmeir\LaravelMigrationViews\Schema\Builders;
4
5		use Illuminate\Database\Schema\SQLiteBuilder as Base;
6		use Illuminate\Support\Str;
7
8		class SQLiteBuilder extends Base
9		{
10		use ManagesViews {
11		createView as createViewParent;
12		}
13
14		/**
15		* Create a new view on the schema.
16		*
17		* @param string $name
18		* @param \Illuminate\Database\Eloquent\Builder\|\Illuminate\Database\Query\Builder\|string $query
19		* @param array\|null $columns
20		* @param bool $orReplace
21		* @return void
22		*/
23	10	public function createView($name, $query, array $columns = null, $orReplace = false)
24		{
25	10	if ($orReplace) {
26	1	$this->dropViewIfExists($name);
27		}
28
29	10	$this->createViewParent($name, $query, $columns);
30	10	}
31
32		/**
33		* Rename a view on the schema.
34		*
35		* @param string $from
36		* @param string $to
37		* @return void
38		*/
39	1	public function renameView($from, $to)
40		{
41	1	$view = $this->connection->selectOne(
42	1	"select * from sqlite_master where type = 'view' and name = ?",
43	1	[$this->connection->getTablePrefix().$from]
44		);
45
46	1	$this->dropView($from);
47
48	1	$query = Str::replaceFirst(
49	1	$this->grammar->wrapTable($from),
50	1	$this->grammar->wrapTable($to),
51	1	$view->sql
52		);
53
54	1	$this->connection->statement($query);
55	1	}
56
57		/**
58		* Get the bindings for a "Has View" statement.
59		*
60		* @param string $view
61		* @return array
62		*/
63	3	protected function getBindingsForHasView($view)
64		{
65	3	return [$view];
66		}
67		}
68

staudenmeir / laravel-migration-views

Push — master ( 3415eb...56b5c5 )

SQLiteBuilder::createView() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like