Dry running Laravel migrations before actually migrating them
Sometimes, you might run into a situation where you want to see what all database queries will run upon running your Laravel migrations, and that too without actually running the migrations.
You can do just this by appending the --pretend option/flag to the artisan migrate command like so.
$ php artisan migrate --pretend
For instance, let’s say, I created a migration to create a flights table using the artisan make:migrate command with the following content.
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateFlightsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('flights', function (Blueprint $table) {
$table->id();
$table->timestamps();
$table->string('name')->index();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('flights');
}
}
Now, when I run the artisan migrate command with the --pretend option, it will list down all the database queries that will get executed during an actual migration like so.
Pretty handy, right?
Like this article?
Buy me a coffee
👋 Hi there! I'm Amit. I write articles about all things web development. You can become a sponsor on my blog to help me continue my writing journey and get your brand in front of thousands of eyes.
