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

Creating multi-worksheet Excel files with Simple Excel
Creating multi-worksheet Excel files with Simple Excel

Recently I had to create a large data export for a project. I like using Spatie’s Simple Excel package to do this as it is very simple to use and works well when exporting large amounts of data to a CSV or Excel file with the ability to stream a download to the browser. This particular project had an additional requirement though, exporting multiple worksheet’s of data at once. Luckily, this package allows you to do this too.

The PHP foreach loop
The PHP foreach loop

An alternative to the for loop, the foreach loop is used to iterate or loop over an array. The foreach loop allows you to loop through the items in the array without setting a limit for it to stop like you do in a for loop.

The PHP for loop
The PHP for loop

If you have something you want to repeat then consider using a PHP for loop, saving you from copying and pasting the same code multiple times. Adding the code into a loop means you only have to write it once, and you also only have to maintain the code in one place in future.

How NOT to make a website

How NOT to make a Website

By C.S. Rhymes

From £8.99

Nigel's Intranet Adventure

Nigel's Intranet Adventure

By C.S. Rhymes

From £2.69