Hey all,
I'd like to have a clean DB between tests, one approach that works is to
drop tables and recreate fixtures. This can be quite slow and I'd rather
have something more lean.
If possible I'd like to create a snapshot before each test and rollback to
the snapshot after each test. From browsing the docs it seems like
SQLAlchemy might be able to achieve this using nested transactions or
subtransactions. FWIW I am using Postgres 9.1+.
I had a quick go at this and ended up with something similar to
*# my_db.py*
session = .... # setup connect & session to postgres
*# my_app.py*
from .my_db import session
def add_stuff():
session.add(stuff)
session.commit()
*# test.py*
from .my_db import session
from .my_app import add_stuff
class MyTest(unittest.TestCase):
def setUp(self):
session.begin_nested()
def tearDown(self):
session.rollback()
def test_app(self):
add_stuff()
but that does not work. The commit in add_stuff is not reverted by the
rollback in tearDown. Am I going in the right direction?
Cheers!
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
