Testing a Laravel Console Command

Published: Jan 31, 2021 by C.S. Rhymes

I recently discovered that you can test an artisan console command very easily in Laravel 8 and make assertions on the output. In this example we are going to make a console command to import some products into our database from a csv file and then test they are all added as expected.

First we need to create a console command using artisan.

php artisan make:command ImportProducts

In this newly created class, we are going to use the Spatie Simple Excel package to read the csv file and then import the products. We are going to use the product_code as the unique identifier and we are going to update or create the product name and description.

The console command expects a file location as an argument. It also has a confirm to ensure the user wants to run the command. After each product is added it will output the message Imported and then the product code.


namespace App\Console\Commands;

use App\Models\Product;
use Illuminate\Console\Command;
use Spatie\SimpleExcel\SimpleExcelReader;

class ImportProducts extends Command
    protected $signature = 'import:products {file}';
    protected $description = 'Import products into the products table';

    public function __construct()

    public function handle()
        $file = $this->argument('file');

        if(!$this->confirm('Do you really wish to import products?')) {
            $this->error('Import cancelled');
            return 1;

        $this->info('Starting import');

        $rows = SimpleExcelReader::create($file)->getRows();

        $rows->each(function (array $row) {
                ['product_code' => $row['product_code']],
                ['name' => $row['name'], 'description' => $row['description']]
            $this->info("Imported {$row['product_code']}");

        $this->info('Products imported');
        return 0;

Running the command

To run the console command manually we can run the following:

php artisan import:products /path/to/csv-file.csv

Creating a test

Next we can create a test using artisan. You could say this is a unit test as it’s a console command, but as we are testing the whole process of the import from start to finish I personally think it should be a feature test.

php artisan make:test ImportProductsTest

We want to ensure we use RefreshDatabase; in our test class as we need to create the products table to test importing the data into the database.

Creating a test file

The command expects a file to import so we will create a csv file in Tests/Files/import-products.csv with the below test content.

ABC123,yPhone3,The latest and greatest yPhone
ABC111,yPhone3S,A smaller and more compact version of the yPhone

Testing the file is required

First we are going to test that the file is required. If we run the command without a file we get a RuntimeException, so let’s test this is what we expect.

public function test_importing_without_a_file()

Testing cancelling the import

We added a confirmation to ensure that we really want to run the command, so we can test that the command stops running and outputs the ‘Importing cancelled’ message, as well as not outputting the ‘Products imported’ message.

The expectsConfirmation method has two arguments, the first being the expected output and the second being the response you want to give.

The expectsOutput allows you to test that the message you expect is outputted.

To test a message isn’t output we can use the doesntExpectOutput method.

Lastly, we can test the exit code using the assertExitCode.

public function test_cancel_import_products_command()
    $this->artisan('import:products ' .__DIR__.'/../Files/import-products.csv')
        ->expectsConfirmation('Do you really wish to import products?', 'no')
        ->expectsOutput('Import cancelled')
        ->doesntExpectOutput('Products imported')

Testing the import process

Now we have tested without a file and cancelling the command, we can test running the command from start to finish and ensure that it outputs all the messages we expect to see and returns the correct exit code.

public function test_import_products_command()
    $this->artisan('import:products ' .__DIR__.'/../Files/import-products.csv')
        ->expectsConfirmation('Do you really wish to import products?', 'yes')
        ->expectsOutput('Starting import')
        ->expectsOutput('Imported ABC123')
        ->expectsOutput('Imported ABC111')
        ->expectsOutput('Products imported')

We can go one step further and ensure that the data we imported was actually inserted into the database correctly (using $this->assertDatabaseHas()) by adding the following to the test.

$this->assertDatabaseHas('products', [
    'product_code' => 'ABC123',
    'name' => 'yPhone3',
    'description' => 'The latest and greatest yPhone',

$this->assertDatabaseHas('products', [
    'product_code' => 'ABC111',
    'name' => 'yPhone3S',
    'description' => 'A smaller and more compact version of the yPhone',

Running the test

Finally, we need to run the test. This is done using php artisan test or vendor/bin/phpunit.

php artisan test

   PASS  Tests\Feature\ImportProductsTest
  ✓ import products command
  ✓ cancel import products command
  ✓ importing without a file

  Tests:  3 passed
  Time:   0.24s

For more information on testing console commands, please refer to the Laravel docs.

Photo by Caleb George from StockSnap

laravel testing php artisan


Latest Posts

Using when with the Laravel Http Client
Using when with the Laravel Http Client

Here’s a little tip I discovered that I haven’t seen documented anywhere. You can use when() and unless() with the Laravel Http client.

New book announcement!
New book announcement!

Announcing the new book, The Little-Astwick Mysteries - Trouble at the church, by C.S. Rhymes. It is now available for pre-order on the Amazon Kindle store for £2.99, with the release date of the 1st February 2024.

Using prettier to format your Jekyll theme
Using prettier to format your Jekyll theme

I have been using prettier for a few years to automatically format code, especially JavaScript and TypeScript projects, as it helps standardise the output on a shared code project. I have maintained a few different Jekyll themes over the years and wanted to use the power of prettier to automatically format code consistently.

How NOT to make a website

How NOT to make a Website

By C.S. Rhymes

From £2.49

Nigel's Intranet Adventure

Nigel's Intranet Adventure

By C.S. Rhymes

From £2.99