Source code for sqlobject.tests.test_sqlobject_admin

# These tests are not enabled yet, but here are some working examples
# of using createSQL so far.
fromsqlobjectimport SQLObject, StringCol

[docs]
classSOTest1(SQLObject):
 classsqlmeta:
 createSQL = "CREATE SEQUENCE db_test1_seq;"
 test1 = StringCol()

[docs]
classSOTest2(SQLObject):
 classsqlmeta:
 createSQL = ["CREATE SEQUENCE db_test2_seq;",
 "ALTER TABLE test2 ADD CHECK(test2 != '');"]
 test2 = StringCol()

[docs]
classSOTest3(SQLObject):
 classsqlmeta:
 createSQL = {'postgres': 'CREATE SEQUENCE db_test3_seq;',
 'mysql': 'CREATE SEQUENCE db_test3_seq;'}
 test3 = StringCol()

[docs]
classSOTest4(SQLObject):
 classsqlmeta:
 createSQL = {'postgres': ['CREATE SEQUENCE db_test4_seq;',
 "ALTER TABLE test4 ADD CHECK(test4 != '');"],
 'mysql': 'CREATE SEQUENCE db_test4_seq;'}
 test4 = StringCol()

[docs]
classSOTest5(SQLObject):
 classsqlmeta:
 createSQL = {'mysql': 'CREATE SEQUENCE db_test5_seq;'}
 test5 = StringCol()