Downloads
Stars
Version
A small package to help automate the creation and updating of MySQL views and procedures.
This package lets you store the query definition for every MySQL view and stored procedure you need within your Laravel codebase, and lets you edit the SQL query strings directly instead of using migration files. This is useful when:
Via Composer
$ composer require stats4sd/laravel-sql-views
The package includes a single console command php artisan updatesql
. This command does 2 things:
database/views
directory. It will create a view for every .sql
file it finds, using the filename as the view name and the contents as the query definition.database/procedures
directory. It will run all .sql
files in that directly verbatim. The intention is that you would include scripts to create the required procedures, but in theory you could include any SQL code that you want to run on a regular basis.To use:
database/views
directory. You need 1 file per view. Do not include the "CREATE OR REPLACE VIEW" segment, just include the query definition itself.database/procedures
folder.php artisan updatesql
.It will search the folders recursively, so you can organise your views into subfolders if you wish.
The packge comes with a tiny config file.
php artisan vendor:publish --tag=sqlviews.config
To disable the automatic creation of either the database/views
and/or database/procedures
folder(s) you can add the following .env
variables :-
SQL_VIEWS_REGISTER_VIEWS_FOLDER=false
SQL_VIEWS_REGISTER_PROCEDURES_FOLDER=false
Please note that disabling folder creation without a good understanding of this package will cause you issues.
Please see the changelog for more information on what has changed recently.
Please see contributing.md for details and a todolist.
If you discover any security related issues, please email author email instead of using the issue tracker.
MIT license. Please see the license file for more information.