mnabialek / laravel-quick-migrations
Run Laravel tests quicker
Installs: 10 044
Dependents: 0
Suggesters: 0
Security: 0
Stars: 23
Watchers: 1
Forks: 4
Open Issues: 0
Requires
- laravel/framework: ^5.6|6.*|7.*|8.*|9.*|10.*|11.*
Requires (Dev)
- friendsofphp/php-cs-fixer: ^3.52.1
- mockery/mockery: ^1.0
- php-coveralls/php-coveralls: ^2.0
- phpunit/phpunit: ^11.0
README
This package is intended to improve speed of Laravel tests that needs to use migrations. In case you use Laravel's DatabaseMigrations
trait (especially in Browser tests) you might be interested in using this package to save a lot of time.
Be aware this package doesn't improve speed of normal migrations you apply to database - it should be used only if have tests in your application and you want to improve their speed.
Installation
-
Run
composer require mnabialek/laravel-quick-migrations --dev
in console to install this module (Notice
--dev
flag - it's recommended to use this package only for development). -
Run:
php artisan vendor:publish
and choose the number matching
"Mnabialek\LaravelQuickMigrations\Providers\ServiceProvider"
provider.By default you should not edit published file because all the settings are loaded from
.env
file by default.Depending on your needs you might add now into
.env
(or other env files used for tests):QUICK_MIGRATIONS_ENABLED=true QUICK_MIGRATIONS_DUMP_FILE="/custom/directory/custom_filename.sql"
and customize it with your own values. Keep if mind if you set
QUICK_MIGRATIONS_ENABLED
you will automatically use default Laravel migrations again. -
Update all your tests where you use
DatabaseMigrations
trait withQuickDatabaseMigrations
. You should add import line into those files too:use Mnabialek\LaravelQuickMigrations\QuickDatabaseMigrations;
-
Run:
php artisan migrate:fresh --database=selected_sql_connection
into empty database. Of course as
selected_sql_connection
you should use connection you really use in your app (usuallymysql
ormysql_testing
).Now you can manually dump structure of this database into single file (or use
mysqldump
) and save file asstorage/tests/dump.sql
(If you set custom value ofQUICK_MIGRATIONS_DUMP_FILE
in your env file then you should of course put it into your custom location) -
Run your tests and enjoy!
Benchmarks
My test suite (real application) had 53 Laravel Dusk tests with 890 assertions running in Docker container. Database had 93 migrations.
As you see in real-application scenario difference is quite impressive. Using modified trait makes tests running almost 3 times faster comparing to original tests.
Of course in your case results might be different. A lot of depends on migrations you have in your app - how long they take by default. For example assuming you have 100 tests using migrations and applying your migrations takes 10 seconds (for each test) and using your dump would take 6 seconds (for each test) then you would save 100 * 4 seconds that gives 6.66 minutes each time you are running your tests. As you see in my scenario difference was much bigger.
Cons
- You need to manually update dump whenever you add/change migrations. But assuming you are using tests it might be really worth it to spend < 1 minute for dumping fresh migrations to save hundreds of minutes.
- After running tests in your database you have data you created during your tests. From my point of view, if you are using database for tests only you should not care much about it. But of course you can create command that will always remove everything from your database after completing tests if you really need it.
Authors
Author of this package is Marcin Nabiałek and Contributors
Changes
All changes are listed in Changelog
License
This package is licenced under the MIT license.