CODEWITHSUNDEEP
pythonmysqldatabasefunctional-testing
ac184
ac184

Reputation: 961

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

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

Upvotes: 0

Views: 211

Answers (1)

Guilherme Defreitas
Guilherme Defreitas

Reputation: 1054

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.

Upvotes: 1

Related Questions