Set up in-memory Sqlite database for testing in pest

Question

I'm trying to set up testing using pest in a laravel project. I have several migrations which are stored in ./test/database/migrations, and I'd like to spin up a new sqlite in-memory database using those migrations prior to running tests. This seems like a fairly standard set-up, but I can't seem to get it to work.

my phpunit.xml contains this:

    <env name="DB_CONNECTION" value="sqlite_testing" />

config/database.php

    'sqlite_testing' => [
      'driver'   => 'sqlite',
      'database' => ':memory:',
      'prefix'   => '',
    ],

It seems that it is able to connect to the database, but none of the migrations have run. I get errors like this:

SQLSTATE[HY000]: General error: 1 no such table: users (Connection: sqlite_testing, SQL: select * from "users" where "users"."deleted_at" is null limit 1)

I tried to run the migrations in the test by doing this:

beforeAll(function () {
  Artisan::call('migrate', ['--path' => "tests/database/migrations"]);
});

Is the test setup in a CI/CD pipeline? Or are you manually testing this? — Tatachiblob
– Tatachiblob, Commented Apr 17 at 23:55

mankowitz · Accepted Answer · 2025-04-30 14:50:46Z

2

I hope this helps someone. In order to run migrations from a particular directory, I had to edit /tests/TestCase.php and add the options to migrateFreshUsing() like this:

abstract class TestCase extends BaseTestCase
{
  use RefreshDatabase;

  protected function migrateFreshUsing()
  {
    return [
      '--path' => 'tests/database/migrations',
      '--database' => 'sqlite_testing',
    ];
  }
}

answered Apr 30 at 14:50

mankowitz

2,1151 gold badge19 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tatachiblob · Accepted Answer · 2025-04-18 14:02:48Z

0

You can try adding this line of code in your pest test

<?php
 
use Illuminate\Foundation\Testing\RefreshDatabase; // add this
 
uses(RefreshDatabase::class); // add this

test('test my code', function () {
});

answered Apr 18 at 14:02

Tatachiblob

1,7018 silver badges20 bronze badges

2 Comments

mankowitz Apr 20 at 13:28

This doesn't work. How do I tell it to run my migrations from a particular directory (tests/database/migrations instead of default)? Also, This creates a bunch of errors because my permissions table is not created when it tries to boot the app.

mankowitz Apr 20 at 13:29

Also, I want it to run the migrations only once. I want it to create the in-memory database at start of testing, not before each test.

Collectives™ on Stack Overflow

Set up in-memory Sqlite database for testing in pest

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related