karlerss/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:

1. All script-defined database objects are removed
2. Your migrations are executed
3. All script-defined database objects are added again

Installation

Via Composer

$ composer require karlerss/laravel-db-script-manager

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

$ vendor/bin/phpunit

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.