r10077: * multiple: Apply patch from Joerg Hoehle with multiple

[clsql.git] / tests / test-init.lisp

diff --git a/tests/test-init.lisp b/tests/test-init.lisp
index cb1cec578b3a793cfc4493845ffd1e25f0197c7f..b1a89341af6499018a7025cc7c4b0474519b1649 100644 (file)
--- a/tests/test-init.lisp
+++ b/tests/test-init.lisp
@@ -48,7 +48,7 @@
 (def-view-class employee (person)
   ((emplid
     :db-kind :key
-    :db-constraints :not-null
+    :db-constraints (:not-null :unique)
     :type integer
     :initarg :emplid)
    (groupid
@@ -164,6 +164,11 @@
            :db-info (:join-class address
                                  :home-key aaddressid
                                  :foreign-key addressid
+                                 :retrieval :immediate))
+   (employee :db-kind :join
+            :db-info (:join-class employee
+                                 :home-key aemplid
+                                 :foreign-key emplid
                                  :retrieval :immediate)))
   (:base-table "ea_join"))
 
@@ -593,8 +598,17 @@
                (clsql-sys:in test :fdml/query/6 :fdml/select/31))
           (push (cons test "union not supported") skip-tests))
          ((and (eq *test-database-type* :oracle)
-               (clsql-sys:in test :fdml/query/8 :fdml/select/21))
+               (clsql-sys:in test :fdml/query/8 :fdml/select/21 
+                              :fddl/table/6))
           (push (cons test "syntax not supported") skip-tests))
+          ((and (eq *test-database-type* :odbc)
+               (eq *test-database-underlying-type* :postgresql)
+               (clsql-sys:in test :fddl/owner/1))
+           (push (cons test "table ownership not supported by postgresql odbc driver") skip-tests))
+         ((and (not (member *test-database-underlying-type* 
+                             '(:postgresql :oracle)))
+               (clsql-sys:in test :fddl/owner/1))
+           (push (cons test "table ownership not supported") skip-tests))
          (t
           (push test-form test-forms)))))
       (values (nreverse test-forms) (nreverse skip-tests))))