laravel migrate fresh

An artisan command to build up a database from scratch

180
23
PHP

The migrate:fresh command is included by default since Laravel 5.5.

An artisan command to build up the database from scratch

Latest Version on Packagist
Software License
Build Status
Quality Score
StyleCI
Total Downloads

Laravel has a migrate:refresh command to build up the database using migrations. To clear the database it’ll first rollback all migrations by using the down method in each migration.

But what if you don’t use the down method inside your projects? The migrate:refresh command will fail as the database isn’t cleared first.

This package contains a migrate:fresh command that’ll nuke all the tables in your database regardless of whether you’ve set up the down method in each migration.

Postcardware

You’re free to use this package (it’s MIT-licensed), but if it makes it to your production environment we highly appreciate you sending us a postcard from your hometown, mentioning which of our package(s) you are using.

Our address is: Spatie, Samberstraat 69D, 2060 Antwerp, Belgium.

The best postcards are published on our website.

Requirements

This command supports MySQL, sqlite, PostgreSQL and MS SQL databases.

Note: the migrate:fresh command is included by default in Laravel 5.5.

Installation

You can install the package via composer:

composer require spatie/laravel-migrate-fresh

Next add the Spatie\MigrateFresh\Commands\MigrateFresh class to your console kernel.

// app/Console/Kernel.php

protected $commands = [
   ...
    \Spatie\MigrateFresh\Commands\MigrateFresh::class,
]

Usage

This command will drop all tables from your database and run all migrations.

php artisan migrate:fresh

Be aware that the command will knock down all tables in the database. Tables not belonging to your application will be dropped as well.

By tagging on the seed option all seeders will run as well.

php artisan migrate:fresh --seed

If the command is being executed in a production environment, confirmation will be asked first. To suppress the confirmation use the force option.

php artisan migrate:fresh --force

Events

This package fires several events, which you can hook into to perform some extra logic rebuilding the database.

  • Spatie\MigrateFresh\Events\DroppingTables: will be fired right before dropping the first table
  • Spatie\MigrateFresh\Events\DroppedTables: will be fired right after all the tables have been dropped and before running the up steps of the migrations

Changelog

Please see CHANGELOG for more information what has changed recently.

Testing

In order for the test to be run you should set up an empty mysql database laravel_migrate_fresh . The username should be root, the required password should be empty.

$ composer test

Contributing

Please see CONTRIBUTING for details.

Security

If you discover any security related issues, please email [email protected] instead of using the issue tracker.

Credits

Initial code to drop all tables in a Postgresql db was provided by Jonathan Reinink and reviewed by Peter Matseykanets. Peter also added support for Sqlite.

About Spatie

Spatie is a webdesign agency based in Antwerp, Belgium. You’ll find an overview of all our open source projects on our website.

License

The MIT License (MIT). Please see License File for more information.