laravel phpunit Unknown database ':memory:

Question

This error is bugging me. my laravel version is 5.6 I don't think I have made any changes to my phpunit.xml file except these

<php>
        <env name="APP_ENV" value="testing"/>            
        <env name="CACHE_DRIVER" value="array"/>
        <env name="SESSION_DRIVER" value="array"/>
        <env name="QUEUE_DRIVER" value="sync"/>
        <env name="MAIL_DRIVER" value="array"/>
        <env name="DB_CONNECTION" value="sqlite"/>
        <env name="DB_DATABASE" value=":memory:"/>

    </php>

I'm writing test like this:

<?php

namespace Tests\Feature;

use Tests\TestCase;
use Illuminate\Foundation\Testing\RefreshDatabase;
use Illuminate\Foundation\Testing\DatabaseMigrations;

class DemoTest extends TestCase
{
    use DatabaseMigrations;

    public function test_it_is_nothing()
    {
        $this->get('/volunteers')->assertStatus('200');
    }
}

I have also referenced to this post Laravel multiple databases PHPUnit but not helpful.

ahmed waleed · Answer 1 · 2019-03-19T06:53:48.143

4

Please make sure following things:-

make sure you have sqlite db installed
clear your config php artisan config:clear
also make sure your phpunit.xml exist on your project root directory
check if your have DB_DRIVER env in your phpunit.xml please remove it
when running test try to point your config to phpunit.xml vendor/bin/phpunit --config PATH_TO_YOUR_PHPUNIT_XML_FILE
try to update your phpunit version

If none of above work please try adding another db config to your config/database.php

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

then your phpunit.xml would look like this

<?xml version="1.0" encoding="UTF-8"?>
<phpunit>
    ...
    <php>
        <env name="APP_ENV" value="testing"/>
        <env name="CACHE_DRIVER" value="array"/>
        <env name="SESSION_DRIVER" value="array"/>
        <env name="QUEUE_DRIVER" value="sync"/>
        <env name="DB_DEFAULT" value="sqlite_testing" />
    </php>
</phpunit>

edited Mar 19 '19 at 06:53

answered Mar 19 '19 at 06:41

ahmed waleed

477
1
4
12

I have done all those things.. i have unit version 7.5.6. – rakesh shrestha Mar 19 '19 at 06:47
Have you updated phpunit version ? Can you please share your phpunit.xml file. – ahmed waleed Mar 19 '19 at 06:48
I updated the answer please have a look that might fix your problem. – ahmed waleed Mar 19 '19 at 06:54
that didnt work.. i did artisan clear as well but instead of using the sqlite its using mysql.. and clearing out my tables – rakesh shrestha Mar 19 '19 at 07:07
maybe sqlite is the problem ... I have unzipped `sqlite3.def sqlite3.dll sqlite3.exe` in `C:\sqlite` and set the environment variable.. but sqlite3 on bash is not running it – rakesh shrestha Mar 19 '19 at 07:13
i fixed that problem but stuck with `Base table or view not found: 1146 Table 'fgp_test.sessions' doesn't exist (SQL: select * from `sessions` where `id` = XTDuo816miXOnmnCHTdXfrZaYouLGrX1IAikZAZP ` – rakesh shrestha Mar 25 '19 at 06:39
Are you using `use DatabaseMigrations` trait ? – ahmed waleed Mar 25 '19 at 18:23

score 0 · Answer 2 · answered Jan 19 '20 at 09:54

For me, the problem was that I was having another connection for the model being tested. e.g:

namespace App;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class Salesperson extends Model
{
    use SoftDeletes;

    protected $connection = 'mysql_dynamic_db';

    /**
    * The attributes that are mass assignable.
    *
    * @var array
    */
    protected $fillable = [
        'name',
        'f_name',
        'cnic',
        'address',
        'mobile',
        'email',
        'salary',
        'comm_percent',
    ];
}

So for the time when I run tests, I just comment the following line:

protected $connection = 'mysql_dynamic_db';

and the above error that says unknown database :memory: is gone. Now all works fine.

Andre Toledo Gama · Answer 3 · 2023-03-19T00:48:00.227

First, check if the line extension=pdo_sqlite is not commented in your php.ini.

change it

;extension=pdo_sqlite

to

extension=pdo_sqlite

And go to your config/database.php file and change the sqlite database like the example below

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

to

'connections' => [
  'sqlite' => [
    'driver' => 'sqlite',
    'url' => env('DATABASE_URL'),
    'database' => ':memory:',
    'prefix' => '',
    'foreign_key_constraints' => env('DB_FOREIGN_KEYS', true),
  ],
];

You can also change the database, but use one for testing, don't use your production.

You can simply change the name :memory: to the name of the database you are using like this

this

<env name="DB_DATABASE" value=":memory:"/>

to

<env name="DB_DATABASE" value="name_database"/>

Don't forget to change the DB_CONNECTION if necessary.

laravel phpunit Unknown database ':memory:

3 Answers3