Laravel 6 Testing - Unknown database ':memory:'

Question

For some reason my application can't use :memory: as the database while testing is printing the error: SQLSTATE[HY000] [1049] Unknown database ':memory:'

How can I get my test to use database in memory? I have looked on Stack Overflow, LaraCast, and Reddit but haven't found a solution. Is there an alternative way to do this?

PhpUnit.xml

<php>
    <server name="APP_ENV" value="testing"/>
    <server name="BCRYPT_ROUNDS" value="4"/>
    <server name="CACHE_DRIVER" value="array"/>
    <server name="DB_CONNECTION" value="sqlite"/>
    <server name="DB_DATABASE" value=":memory:"/>
    <server name="MAIL_DRIVER" value="array"/>
    <server name="QUEUE_CONNECTION" value="sync"/>
    <server name="SESSION_DRIVER" value="array"/>
    <server name="TELESCOPE_ENABLED" value="false"/>
</php>

config/database.php

'sqlite' => [
    'driver' => 'sqlite',
    'url' => env('DATABASE_URL'),
    'database' => env('DB_DATABASE', database_path('database.sqlite')),
    //'database' => database_path('database.sqlite'),
    'prefix' => '',
    'foreign_key_constraints' => env('DB_FOREIGN_KEYS', true),
],

I have run php artisan config:clear & cache:clear.

@KennyHorna Through CLI using vendor/bin/phpunit --filter="myTestCase" — Jelly Bean
– Jelly Bean, Commented Oct 27, 2020 at 13:43
Did you try to specify the config file? vendor/bin/phpunit --filter="myTestCase" --configuration phpunit.xml — Kenny Horna
– Kenny Horna, Commented Oct 27, 2020 at 13:45

Jelly Bean · Accepted Answer · 2020-10-27 14:44:03Z

1

So eventually decided to remove the <server name="DB_DATABASE" value=":memory:"/> which kind of worked but still gave misc errors, but it made me realize that my phpunit.xml was not overriding my database connection.

So the long and short of the story is I ended up creating a testing connection that uses the :memory: database which worked.

'testing' => [
    'driver' => 'sqlite',
    'database' => ':memory:',
],

As to what was initially preventing it from working the standard way of doing it I still don't know. but this resolved my issue.

answered Oct 27, 2020 at 14:44

Jelly Bean

1,2191 gold badge13 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

Laravel 6 Testing - Unknown database ':memory:'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related