Phillip Tornroth wrote:
In case it's useful information, the test database is pretty small...
Maybe 15 or 20 megs. The unit tests are individually pretty small.. Less
than 100 inserts each, for sure... So there's not that much to 'roll
back'.. As far as using transactions to undo the state of the database,
let me know if that's possible.. All of our tests have their own
transaction boundaries that they're applying. I don't want to undo that,
but certainly if I could nest each test in a longer-running tx and then
roll it back.. that could work.
I use savepoints for my test framework.
Within a single transaction create savepoints and run your tests. When
you are done, simply rollback the entire transaction. Within your tests,
you can commit or rollback individual savepoints.
http://www.postgresql.org/docs/current/static/sql-savepoint.html
Regards,
LL
