jwz104/eloquent-view

Create sql views with eloquent

Eloquent view

With Eloquent view you can create a SQL view with the eloquent query builder. This will prevent huge SQL strings in your migrations., _(*1)

Installation

Run composer require jwz104/eloquent-view., _(*2)

Add the service provider to config/app.php:, _(*3)

'providers' => [
    Jwz104\EloquentView\EloquentViewServiceProvider::class,
]

Optionally add the facade:, _(*4)

'aliases' => [
    'EloquentView' => Jwz104\EloquentView\Facades\EloquentView::class,
]

How to use

Eloquent view is really easy to use.
Just parse a builder instance to the create method of the view builder., _(*5)

Example migration:, _(*6)

class CreateEmployeesView extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        $builder = DB::table('employees')
            ->join('companies', 'employees.company_id', '=', 'companies.id')
            ->select('employees.*', 'companies.name');

        EloquentView::create('employees_view', $builder);
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        EloquentView::dropIfExists('employees_view');
    }
}