-
12 Jun 2010 »
improving performance of django tests with nested transactions/savepoints
This monkey-patches
django.tests.testcases.TestCaseso that all tests in aTestCasetake place in aBEGINtransaction, while test methods take place in a nested transaction, with a savepoint being recorded after fixtures are loaded before a test, and rolling back to it after ... -
12 Jun 2010 »
support for sqlite3 nested transactions/savepoints in django
Afaik, only the Oracle and Postgres backends has this; sqlite already has it for almost a year now, but there still isn't support for it in django.
I've posted a patch for inclusion; it'll be interesting to see how it goes.
-
12 Jun 2010 »
nested transactions/savepoints in sqlite/pysqlite
Perusing the builtin-sqlite3 docs, as well as those of pysqlite, doesn't seem to offer much clue to using these.
After lots of hair-tearing, I think I've got it figured out.
Here's what most people usually do on their first try:
cur1.execute("create table test(i)") cur1 ...
