A recipe for fast, reliable end-to-end tests (no mocks): 1
A recipe for fast, reliable end-to-end tests (no mocks):
1. Create a test DB instance.
2. Create SQL scripts to populate the test DB with enough data to test the app.
3. Create an automated process to quickly reset the test DB.
4. Reset the DB before starting the test suite.
5. (optional) For more speed and reliability, create one DB per test and run the tests in parallel.