Spring Python 0.4 has been released. It includes the much awaited TransactionTemplate. Check out:
* http://springpython.python-hosting.com/browser/trunk/src/springpython/test/databaseTransactionTestCases.py - examples of usage
* http://springpython.python-hosting.com/wiki/TransactionTemplate - updated wiki documentation
So far, I have been able to test it against a transactional MySQL database. You can checkout http://springpython.python-hosting.com/browser/trunk/src/springpython/test/support/setupTestDB.sql to see how it is setup.
If we can get a script written to setup a similar database for PostGreSQL, then we can extend the test cases to verify it works there as well.
Not sure about the status of Sqlite regarding transactional support. But, none-the-less, Spring Python needs to "handle" it without blowing up.
I don't have Oracle on my home computer, so I'm at a disadvantage in testing any solutions for this.
|