Laravel - Tests on MySQL database

Question

I'm learning Laravel and Functional tests. On laracast we have in phpunit.xml:

<php>
        <env name="DB_CONNECTION" value="sqlite"/>
        <env name="DB_DATABASE" value=":memory:"/>
</php>

I can not test on mysql database because when I switch my DB_CONNECTION param to "mysql" I have error "PDOException: SQLSTATE[HY000] [1049] Unknown database ':memory:'".

When I don't use memory all tables are removed from my database:
My Test Class looks like that:

class ThreadsTest extends TestCase
{

    use DatabaseMigrations;

    /** @test */
    public function a_user_can_browse_threads()
    {
        $response = $this->get('/threads');
        $response->assertStatus(200);
    }
}

Does anybody know how can I test in memory with MySQL? I can't find any information

Ravshanbek Ahmedov · Accepted Answer · 2020-10-08 10:35:55Z

2

You can run with separete database

    <env name="DB_CONNECTION" value="mysql"/>
    <env name="DB_HOST" value="localhost"/>
    <env name="DB_DATABASE" value="test"/>
    <env name="DB_USERNAME" value="root" />
    <env name="DB_PASSWORD" value="" />

answered Oct 8, 2020 at 10:35

Ravshanbek Ahmedov

2816 silver badges9 bronze badges

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

Comments

Jonas Staudenmeir · Accepted Answer · 2018-04-07 14:37:52Z

0

That's not possible. You can't run MySQL as an in-memory database as you can with SQLite.

answered Apr 7, 2018 at 14:37

Jonas Staudenmeir

26.1k7 gold badges70 silver badges115 bronze badges

6 Comments

MMTT Over a year ago

So how we can test on MySQL ? All tables are removed after run tests. What is correct way to testing on MySQL database ?

Jonas Staudenmeir Over a year ago

Do you have MySQL installed on your system?

MMTT Over a year ago

Yes. Only MySQL (XAMPP)

Jonas Staudenmeir Over a year ago

Create a separate database for your tests and add it to phpunit.xml. You can wrap your tests in transactions to rollback the changes: laravel.com/docs/5.6/…

Jonas Staudenmeir Over a year ago

An application written for MySQL doesn't always work with SQLite because of missing database features. Even if it does, testing with SQLite is not a replacement for testing with the production environment's DBMS.

|

elijah7 · Accepted Answer · 2022-02-03 14:23:31Z

0

Simply change the parameters

<php>
    <env name="DB_CONNECTION" value="sqlite"/>
    <env name="DB_DATABASE" value=":memory:"/>
</php>

to

<php>
    <env name="DB_CONNECTION" value="mysql"/>
    <env name="DB_DATABASE" value="your_test_instance"/>
</php>

answered Feb 3, 2022 at 14:23

elijah7

3733 silver badges8 bronze badges

Collectives™ on Stack Overflow

Laravel - Tests on MySQL database

3 Answers 3

Comments

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related