summaryrefslogtreecommitdiff
path: root/test/engine.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/engine.py')
-rw-r--r--test/engine.py64
1 files changed, 0 insertions, 64 deletions
diff --git a/test/engine.py b/test/engine.py
deleted file mode 100644
index 193201fa1..000000000
--- a/test/engine.py
+++ /dev/null
@@ -1,64 +0,0 @@
-from sqlalchemy import *
-
-from testbase import PersistTest
-import testbase
-import unittest, re
-import tables
-
-class TransactionTest(PersistTest):
- def setUpAll(self):
- tables.create()
- def tearDownAll(self):
- tables.drop()
- def tearDown(self):
- tables.delete()
-
- def testbasic(self):
- testbase.db.begin()
- tables.users.insert().execute(user_name='jack')
- tables.users.insert().execute(user_name='fred')
- testbase.db.commit()
- l = tables.users.select().execute().fetchall()
- print l
- self.assert_(len(l) == 2)
-
- def testrollback(self):
- testbase.db.begin()
- tables.users.insert().execute(user_name='jack')
- tables.users.insert().execute(user_name='fred')
- testbase.db.rollback()
- l = tables.users.select().execute().fetchall()
- print l
- self.assert_(len(l) == 0)
-
- @testbase.unsupported('sqlite')
- def testnested(self):
- """tests nested sessions. SQLite should raise an error."""
- testbase.db.begin()
- tables.users.insert().execute(user_name='jack')
- tables.users.insert().execute(user_name='fred')
- testbase.db.push_session()
- tables.users.insert().execute(user_name='ed')
- tables.users.insert().execute(user_name='wendy')
- testbase.db.pop_session()
- testbase.db.rollback()
- l = tables.users.select().execute().fetchall()
- print l
- self.assert_(len(l) == 2)
-
- def testtwo(self):
- testbase.db.begin()
- tables.users.insert().execute(user_name='jack')
- tables.users.insert().execute(user_name='fred')
- testbase.db.commit()
- testbase.db.begin()
- tables.users.insert().execute(user_name='ed')
- tables.users.insert().execute(user_name='wendy')
- testbase.db.commit()
- testbase.db.rollback()
- l = tables.users.select().execute().fetchall()
- print l
- self.assert_(len(l) == 4)
-
-if __name__ == "__main__":
- testbase.main()