Python - how to run end to end test cases with mysql database?

Question

Is there any in memory DB for Python similar to HSQLDB. MySQL is the DB the application uses and for running end to end test cases, we are currently bringing up a clone of actual DB which causes some delay and couple of manual steps.

I have tried SQLite3 facing some trouble with running DDL queries generated for MySQL.

What are the good options for bringing up temporary DB to run all test cases and shut it down after test execution?

Thank you

Take a look here. It lists several different options in several answers so make sure you check them down the page. — progmatico
– progmatico, Commented Jan 28, 2019 at 15:30

Guilherme Defreitas · Accepted Answer · 2019-01-28 15:23:30Z

1

MySQL has an in-memory engine (https://dev.mysql.com/doc/refman/5.5/en/memory-storage-engine.html). I've never used, but I guess it will help you run the tests quickly.

answered Jan 28, 2019 at 15:23

Guilherme Defreitas

1,0541 gold badge10 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Python - how to run end to end test cases with mysql database?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related