Staudenmeir\LaravelMigrationViews\Schema\Grammars\CompilesViews

Complexity

Total Complexity

8

Size/Duplication

Total Lines	56
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	compileRefreshMaterializedView()	0	3	1
A	compileCreateView()	0	9	4
A	compileViewExists()	0	3	1
A	compileDropView()	0	5	2

<?php

namespace Staudenmeir\LaravelMigrationViews\Schema\Grammars;

trait CompilesViews
{
    /**
     * Compile the query to create a view.
     *
     * @param string $name
     * @param string $query
     * @param array|null $columns
     * @param bool $orReplace
     * @param bool $materialized
     * @return string
     */
    public function compileCreateView($name, $query, $columns, $orReplace, bool $materialized = false)
    {
        $orReplaceSql = $orReplace ? 'or replace ' : '';

        $materializedSql = $materialized ? 'materialized ' : '';

        $columns = $columns ? '('.$this->columnize($columns).') ' : '';

It seems like columnize() must be provided by classes using this trait. How about adding it as abstract method to this trait?

        return 'create '.$orReplaceSql.$materializedSql.'view '.$this->wrapTable($name).' '.$columns.'as '.$query;

It seems like wrapTable() must be provided by classes using this trait. How about adding it as abstract method to this trait?

    }

    /**
     * Compile the query to drop a view.
     *
     * @param string $name
     * @param bool $ifExists
     * @return string
     */
    public function compileDropView($name, $ifExists)
    {
        $ifExists = $ifExists ? 'if exists ' : '';

        return 'drop view '.$ifExists.$this->wrapTable($name);
    }

    /**
     * Compile the query to determine if a view exists.
     *
     * @return string
     */
    public function compileViewExists()
    {
        return 'select * from information_schema.views where table_schema = ? and table_name = ?';
    }

    /**
     * Compile the query to refresh a materialized view.
     *
     * @param string $name
     * @return string
     */
    public function compileRefreshMaterializedView(string $name): string
    {
        return 'refresh materialized view ' . $this->wrapTable($name);
    }
}