/
test.py
58 lines (44 loc) · 1.25 KB
/
test.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
"""
web.py test suite.
"""
import sys
import web
import unittest
def commit(value):
web.transact()
web.insert("test", seqname=False, value=value)
web.commit()
def rollback(value):
web.transact()
web.insert("test", seqname=False, value=value)
web.rollback()
def getrow(value):
d = web.select('test', where='value=$value', vars=locals())
a = (d and d[0].value) or None
return a
def assert_presence(*values):
for v in values:
assert getrow(v) is not None
def assert_absence(*values):
for v in values:
assert getrow(v) is None
class PostgresTest(unittest.TestCase):
parameters = dict(dbn="postgres", db="webtest", user="postgres", pw="")
def setUp(self):
web.config.db_parameters = self.parameters
#web.config.db_printing = True
web.load()
web.delete("test", where="1=1")
def tearDown(self):
sys.stdout.flush()
sys.stderr.flush()
def testCommit(self):
commit(1)
assert_presence(1)
def testRollback(self):
rollback(1)
assert_absence(1)
class MySQLTest(PostgresTest):
parameters = dict(dbn="mysql", db="webtest", user="webpy", pw="")
if __name__ == "__main__":
unittest.main()