Download the PHP package karlerss/laravel-db-script-manager without Composer
On this page you can find all versions of the php package karlerss/laravel-db-script-manager. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download karlerss/laravel-db-script-manager
More information about karlerss/laravel-db-script-manager
Files in karlerss/laravel-db-script-manager
Package laravel-db-script-manager
Short Description Manage database views, stored procedures etc with Laravel
License MIT
Homepage https://github.com/karlerss/laravel-db-script-manager
Informations about the package laravel-db-script-manager
Laravel Database Script Manager
Managing database objects in a version controlled application is hard. Laravel's migrate functionality gets us half way there. Managing your views, triggers and stored procedures with Laravel's migrations is error-prone or really verbose (try modifying a table which is used for a view).
This package modifies php artisan migrate
command so that:
- All script-defined database objects are removed
- Your migrations are executed
- All script-defined database objects are added again
Installation
Via Composer
Usage
Create a new script:
php artisan make:db-script add_active_users_view
A file similar to a migration file is created in database/scripts.
Implement the up()
and down()
methods. The down mehtod sql script should check
if the database object exists (DROP VIEW IF EXISTS active_users
).
Testing
Contributing
Please see contributing.md for details and a todolist.
Security
If you discover any security related issues, please email author email instead of using the issue tracker.
Credits
- Karl-Sander Erss
- All Contributors
License
MIT. Please see the license file for more information.