Staudenmeir\LaravelMigrationViews\Schema\Builders\SqlServerBuilder

Complexity

Total Complexity

6

Size/Duplication

Total Lines	64
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	getViewColumnListing()	0	8	1
A	createView()	0	7	2
A	dropView()	0	5	2
A	getBindingsForHasView()	0	3	1

<?php

namespace Staudenmeir\LaravelMigrationViews\Schema\Builders;

use Illuminate\Database\Schema\SqlServerBuilder as Base;

class SqlServerBuilder 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);
    }

    /**
     * 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),
            $ifExists ? [$this->connection->getTablePrefix().$name] : []
        );
    }

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

    /**
     * Get the column listing for a given view.
     *
     * @param string $name
     * @return array
     */
    public function getViewColumnListing($name)
    {
        $results = $this->connection->selectFromWriteConnection(
            $this->grammar->compileViewColumnListing(),
            [$this->connection->getTablePrefix().$name]
        );

        return $this->connection->getPostProcessor()->processColumnListing($results);
    }
}