[SQL-CVS] r1153 - SQLObject/trunk/sqlobject/tests

[<sub...@co...>]

Author: ianb
Date: 2005-10-27 16:24:26 +0000 (Thu, 27 Oct 2005)
New Revision: 1153

Added:
   SQLObject/trunk/sqlobject/tests/test_sqlobject_admin.py
Log:
added some test examples for createSQL that are not yet enabled, but are a useful reference.

Added: SQLObject/trunk/sqlobject/tests/test_sqlobject_admin.py
===================================================================
--- SQLObject/trunk/sqlobject/tests/test_sqlobject_admin.py	2005-10-27 16:20:12 UTC (rev 1152)
+++ SQLObject/trunk/sqlobject/tests/test_sqlobject_admin.py	2005-10-27 16:24:26 UTC (rev 1153)
@@ -0,0 +1,42 @@
+"""
+These Tests are not enabled yet, but here are some working examples of using createSQL so far.
+"""
+
+from sqlobject import *
+
+sqlhub.processConnection = connectionForURI('postgres://pgsql@/db_test')
+
+class Test1(SQLObject):
+    class sqlmeta:
+        createSQL = "CREATE SEQUENCE db_test1_seq;"
+    test1 = StringCol()
+
+class Test2(SQLObject):
+    class sqlmeta:
+        createSQL = ["CREATE SEQUENCE db_test2_seq;",
+                     "ALTER TABLE test2 ADD CHECK(test2 != '');"
+                    ]
+    test2 = StringCol()
+
+
+class Test3(SQLObject):
+    class sqlmeta:
+        createSQL = {'postgres': 'CREATE SEQUENCE db_test3_seq;',
+                     'mysql': 'CREATE SEQUENCE db_test3_seq;'}
+    test3 = StringCol()
+
+
+class Test4(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 Test5(SQLObject):
+    class sqlmeta:
+        createSQL = {'mysql': 'CREATE SEQUENCE db_test5_seq;'}
+    test5 = StringCol()
+