Use in-memory SQLite in Laravel PHPUnit test

Question

I'm trying to get a Laravel project running at my new work. The developer who left didn't specify how to get the code up and running in the handover document and no-one else knows either.

The SQLite database is created with :memory:, and php artisan migrate works without errors.

...
Migrating: 2016_06_01_000004_create_oauth_clients_table
Migrated:  2016_06_01_000004_create_oauth_clients_table
...

The method beginDatabaseTransaction() in the trait (standard Laravel code) is being executed, but none of the tables exist afterwards. It's as if the database is being created but the migration is not being executed.

<?php

namespace Illuminate\Foundation\Testing;

trait DatabaseTransactions
{
    /**
     * Handle database transactions on the specified connections.
     *
     * @return void
     */
    public function beginDatabaseTransaction()
    {
        $database = $this->app->make('db');

        foreach ($this->connectionsToTransact() as $name) {
            $database->connection($name)->beginTransaction();
        }

        $this->beforeApplicationDestroyed(function () use ($database) {
            foreach ($this->connectionsToTransact() as $name) {
                $connection = $database->connection($name);

                $connection->rollBack();
                $connection->disconnect();
            }
        });
    }

Test code (the last shown instruction fails):

<?php
namespace Tests\Feature;
use Tests\TestCase;
use Illuminate\Foundation\Testing\DatabaseTransactions;
use Laravel\Passport\ClientRepository;

class PassportTest extends TestCase
{
    use DatabaseTransactions;

    public function test_basic_oauth_token_authentication(){
      $clientRepository = new ClientRepository();
      $client = $clientRepository->createPersonalAccessClient(
          null, 'Test Personal Access Client', $this->baseUrl
      );

Command line:

vendor/bin/phpunit tests/Feature/PassPortTest

Error message:

Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1 no such table: oauth_clients
Caused by  
Doctrine\DBAL\Driver\PDOException: SQLSTATE[HY000]: General error: 1 no such table: oauth_clients
Caused by
PDOException: SQLSTATE[HY000]: General error: 1 no such table: oauth_clients

How can I ensure that the tables have been created as part of each test?

@DigitalDrifter Another site suggested calling Artisan::call('migrate'); as the first thing in th test, but that had no effect. — CJ Dennis
– CJ Dennis, Commented Aug 21, 2018 at 12:09
@DigitalDrifter OK. Using RefreshDatabase instead of DatabaseTransactions gets me past that error (to an unrelated error). Trying touse both gives a PHP error due to conflicting method names. — CJ Dennis
– CJ Dennis, Commented Aug 21, 2018 at 12:19

CJ Dennis · Accepted Answer · 2018-08-24 23:02:48Z

3

Use the RefreshDatabase trait instead of the DatabaseTransactions trait (they have conflicts if you try to use both in the same class).

See the documents about resetting the database after each test.

edited Aug 24, 2018 at 23:02

CJ Dennis

4,3743 gold badges43 silver badges73 bronze badges

answered Aug 24, 2018 at 22:51

Brian Lee

18.3k3 gold badges45 silver badges55 bronze badges

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

Comments

kmuenkel · Accepted Answer · 2018-08-24 12:46:21Z

2

There's a caveat when using :memory: in your SQLite config. The memory location that your command-line migrations are hitting is not the same one that the test is attempting to talk to. Each instance of your app basically spins up a new virtual temporary database.

You have two options. Either replace the :memory: config with an explicit filename, or make your test's setUp() method actually initiate the \Aritsan::call('migrate') call. I wouldn't recommend the latter though, just because it could be slow, and I'm not entirely certain the migrations would actually stick if you have Transactions active at the time.

edited Aug 24, 2018 at 12:46

answered Aug 21, 2018 at 17:20

kmuenkel

2,8091 gold badge22 silver badges26 bronze badges

Collectives™ on Stack Overflow

Use in-memory SQLite in Laravel PHPUnit test

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related