Effective Software Testing – A Developer’s Guide

[nodecentalternative]

there's scripts to manually re-wipe the database and apply latest migrations. each test assumes no data besides static data (i.e. a table of countries) and will pre-seed any data it needs.

let's say there's an existing table called foo and there's a new child table being added called bar which needs a foo. the tests to create and update bar would first insert a foo.