Releases: stats4sd/laravel-sql-views
v1.2.0 - Add config options to disable folder creation
This release adds config options to allow the developer to control whether the database/views
and database/procedures
folders are created.
For users updating, you may wish to add the following snippet to your config/sqlviews.php
file:
'folder' => [
'create' => [
'views' => env('SQL_VIEWS_REGISTER_VIEWS_FOLDER', true),
'procedures' => env('SQL_VIEWS_REGISTER_PROCEDURES_FOLDER', true)
]
]
v1.1.1
Bug fix - make sure the example procedure is actually runnable SQL code!
v1.1.0 - MySQL Functions + Procedures
Adds a new feature to let developers manage MySQL functions / procedures as .sql files within the Laravel application.
Now, when running php artisan updatesql
, as well as creating/updating a view for each .sql query inside database/views
, it will also run all .sql files within database/procedures
. It runs those files without modification, so it is up to the developer to add the correct "DROP PROCEDURE IF EXISTS" / "CREATE OR REPLACE PROCEDURE" statements.
This also allows any arbritary SQL statements to be run via an artisan command, which might be useful to generate reports at the database level, or to allow developers / data analysists more familiar with SQL than PHP to contribute to a Laravel application.
v1.0.3 - Laravel 9 Support
Another minor update to allow for use with Laravel 9 applications.
v1.0.2 - Support for Laravel 8
Simple update to composer file to allow installation with Laravel 8
1.0.1 - Run From Controller
.Minor update to allow the updatesql command to be run from anywhere, including via the Artisan facade.
The Initial Release
it does one thing, and hopefully it does it well.