Laravel phpunit drops database tables

Question

I'm trying to test my app using phpunit with laravel but each time I run

unit test

vendor\bin\phpunit

All tables in my database drop so I have to migrate each time I run a test

Have you encountered with similar issue & how can I fix it ?

Alexey Mezenin · Accepted Answer · 2017-12-07 19:41:08Z

1

Use a separate connection for tests. Add this connection to config/database.php config file:

'connections' => [

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

answered Dec 7, 2017 at 19:41

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

4 Comments

user3763103 Over a year ago

I will try it, but can I use my default database since I'm not in production environment?

Camilo Over a year ago

I don't recommend using the default database for testing.

Alexey Mezenin Over a year ago

@user3763103 why do you want to do that? I agree with Camilo, you should use in-memory database for testing.

user3763103 Over a year ago

Because I'm building the app in a local environment once I done I will move it to the server therefor I thought that I don't need two databases. Anyway it worked Thank you very much.

Collectives™ on Stack Overflow

Laravel phpunit drops database tables

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related