def test_single_transaction(self):
db = DAL(DEFAULT_URI)
db.define_table('tt', Field('aa'))
self.assertEqual(db(db.tt).count(), 0)
db.commit()
try:
with db.single_transaction():
db.tt.insert(aa='test')
1 / 0
except ZeroDivisionError:
pass
self.assertEqual(db(db.tt).count(), 0)
with db.single_transaction():
db.tt.insert(aa='test')
self.assertEqual(db(db.tt).count(), 1)
