Laravel 6 PHPUnit Testing - could not find driver (SQL: PRAGMA foreign_keys = ON;)

Question

I'm started to write tests in Laravel. My application works, I can login, run migrations, but when I'm trying to test the login, I'm getting the following error:

could not find driver (SQL: PRAGMA foreign_keys = ON;)

My DB is in Postgres, and my test is as follows:

/** @test */
public function user_login_ok()
{
    $response = $this->json('POST', '/api/login', [
       'email' => '[email protected]',
       'password' => 'test'
    ]);

    $this->assertEquals(200, $response->getStatusCode());
}

I'm not worried (for now) if my test is good enough or even right, but to solve this error.

Do you have an environment file specifically for testing, or are there some configuration options for the database in phpunit.xml php section? If yes, these settings could be trying to use a database connection you do not have set up. — Bryan
– Bryan, Commented Feb 5, 2020 at 15:41
No problem. I added an answer with my comment contents for future question visitors. Feel free to accept. — Bryan
– Bryan, Commented Feb 6, 2020 at 17:45

Alaa mohammed · Accepted Answer · 2021-01-20 09:33:38Z

10

You may need to enable extension for pdo_sqlite in your php.ini file that is being used by phpunit.

answered Jan 20, 2021 at 9:33

Alaa mohammed

1611 silver badge8 bronze badges

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

Comments

Bryan · Accepted Answer · 2020-02-06 17:44:35Z

3

Do you have a testing environment specific .env file? Do you have php section environment configuration in your phpunit.xml file?

If either of these has configuration for your database connection, they should be reviewed to make sure they are configured correctly.

answered Feb 6, 2020 at 17:44

Bryan

3,5041 gold badge21 silver badges23 bronze badges

Comments

Andre Toledo Gama · Accepted Answer · 2023-03-18 23:42:55Z

In your phpunit.xml file (probably in the project root) you will see the following settings at the end

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

Change the line

<server name="DB_CONNECTION" value="sqlite"/>

For the type of database you are using, in my case it is mysql

<server name="DB_CONNECTION" value="mysql"/>

To be sure of the type of database you are using, look at your .env

DB_CONNECTION=mysql

Collectives™ on Stack Overflow

Laravel 6 PHPUnit Testing - could not find driver (SQL: PRAGMA foreign_keys = ON;)

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related