Unit test with heterogeneous database
From Tronche's wiki
- testing by re-creation of the database
- Using a data access layer (no database access into the mainstream code)
- Use "Transaction" !
- Use stubs/mocks for database (depend on 2)
NB: unit testing has to be fast (re-creation of database generally isn't) because you run the test suite after every minor modification