staudenmeir/laravel-migration-views

Laravel database migrations with SQL views

laravel-migration-views's Issues

A seperate new "migrate:fresh" that drop the views too?

Currently as long as 1 view migration exist

php artisan migrate:fresh will no longer work because it will throw a view already exist command

So suggestion to add 1 new command to this package that drop all tables and views

Laravel 8 installation issues

I got this error when installing this on a Laravel v8.31.0

Root composer.json requires staudenmeir/laravel-migration-views 1.0 -> satisfiable by staudenmeir/laravel-migration-views[v1.0].
    - staudenmeir/laravel-migration-views v1.0 requires illuminate/database ~5.5.25|5.6.*|5.7.* -> found illuminate/database[v5.5.28, ..., 5.7.x-dev] but these were not loaded, likely because it conflicts with another require

[Request] Add compatibility for this plugin? (MariaDB)

https://github.com/ybr-nx/laravel-mariadb

Not currently reading mariadb as a supported database.

Update a view with multiple tables

Hi,

Looking at your extensive list of DB related packages. I wonder if you ever had to create a DB VIEW consisting of multiple tables and still be able to INSERT/UPDATE to the VIEW using Eloquent.

The use case is like trait in PHP which can be added to a class to enhance its behavior. Likewise, I'm attempting to enhance an existing table by combining it with another using a VIEW, but the resulting code in Laravel hasn't been good enough.

[Request] Add option to get view columns list

It's possible get tables' columns as mencioned here https://stackoverflow.com/a/37157879/4830771

But it doesn't work with views on SQL Server. I had not tested on others database.

[QUESTION] Does it support materialized view?

Hello, i just looking for lib that can create view and also materialized view.

Drop view problem

I have problem with dropping view
It tells me that the view already exists when I run php artisan migrate:fresh

QUERY PARAMETER CLOSURE

Hi staundenmeir,

I think it is a better idea if you implemented the $query parameter with Closure or Callable instead of Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|string. It's not just make the code looks tidier, it also make the code readeable especially to new programmer like me :P.

Regards,
knighht