staudenmeir / laravel-migration-views

src/Schema/Grammars/CompilesViews.php

<?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 refresh a materialized view.
     *
     * @param string $name
     * @return string
     */
    public function compileRefreshMaterializedView(string $name): string
    {
        return 'refresh materialized view ' . $this->wrapTable($name);
    }
}