-
Notifications
You must be signed in to change notification settings - Fork 28
Expand file tree
/
Copy pathtest_sqlobject_admin.py
More file actions
38 lines (27 loc) · 1.05 KB
/
test_sqlobject_admin.py
File metadata and controls
38 lines (27 loc) · 1.05 KB
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
# These tests are not enabled yet, but here are some working examples
# of using createSQL so far.
from sqlobject import SQLObject, StringCol
class SOTest1(SQLObject):
class sqlmeta:
createSQL = "CREATE SEQUENCE db_test1_seq;"
test1 = StringCol()
class SOTest2(SQLObject):
class sqlmeta:
createSQL = ["CREATE SEQUENCE db_test2_seq;",
"ALTER TABLE test2 ADD CHECK(test2 != '');"]
test2 = StringCol()
class SOTest3(SQLObject):
class sqlmeta:
createSQL = {'postgres': 'CREATE SEQUENCE db_test3_seq;',
'mysql': 'CREATE SEQUENCE db_test3_seq;'}
test3 = StringCol()
class SOTest4(SQLObject):
class sqlmeta:
createSQL = {'postgres': ['CREATE SEQUENCE db_test4_seq;',
"ALTER TABLE test4 ADD CHECK(test4 != '');"],
'mysql': 'CREATE SEQUENCE db_test4_seq;'}
test4 = StringCol()
class SOTest5(SQLObject):
class sqlmeta:
createSQL = {'mysql': 'CREATE SEQUENCE db_test5_seq;'}
test5 = StringCol()