X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=tests%2Ftest-fddl.lisp;h=e231592c82610d5368c3607984c217b875415de5;hp=bafa1c55c79150e17a3214185c7363c4da4c3c9c;hb=db9892632e6eb7869aea7a94c16b523a82de1501;hpb=09ad7f1b964e6c58de9bd6c52b9b9b8a0ad9273d

diff --git a/tests/test-fddl.lisp b/tests/test-fddl.lisp
index bafa1c5..e231592 100644
--- a/tests/test-fddl.lisp
+++ b/tests/test-fddl.lisp
@@ -21,7 +21,7 @@
 
 (setq *rt-fddl*
       '(
-      
+	
 ;; list current tables 
 (deftest :fddl/table/1
     (apply #'values 
@@ -157,12 +157,8 @@
            (values
             (clsql:index-exists-p [bar] :owner *test-database-user*)
             (progn
-              (case *test-database-type*
-                (:mysql 
-                 (clsql:drop-index [bar] :on [employee]
-                                  :if-does-not-exist :ignore))
-                (t 
-                 (clsql:drop-index [bar]:if-does-not-exist :ignore)))
+	      (clsql:drop-index [bar] :on [employee]
+				:if-does-not-exist :ignore)
               (clsql:index-exists-p [bar] :owner *test-database-user*))))
   t nil)
 
@@ -173,13 +169,33 @@
       (dolist (name names)
         (clsql:create-index name :on [employee] :attributes '([emplid]))
         (push (clsql:index-exists-p name :owner *test-database-user*) result)
-        (case *test-database-type*
-          (:mysql 
-           (clsql:drop-index name :on [employee] :if-does-not-exist :ignore))
-          (t (clsql:drop-index name :if-does-not-exist :ignore))))
+	(clsql:drop-index name :on [employee] :if-does-not-exist :ignore))
       (apply #'values result))
   t t t)
 
+;; test list-table-indexes
+(deftest :fddl/index/3
+    (progn
+      (clsql:create-index [bar] :on [employee] :attributes
+			  '([last-name]) :unique nil)
+      (clsql:create-index [foo] :on [employee] :attributes
+			  '([first-name]) :unique nil)
+      (values
+       
+       (sort 
+	(mapcar 
+	 #'string-downcase
+	 (clsql:list-table-indexes [employee] :owner *test-database-user*))
+	    #'string-lessp)
+       (sort (clsql:list-table-indexes [company] :owner *test-database-user*)
+	     #'string-lessp)
+       (progn
+	 (clsql:drop-index [bar] :on [employee])
+	 (clsql:drop-index [foo] :on [employee])
+	 t)))
+
+  ("bar" "foo") nil t)
+
 ;; create an sequence, test for existence, drop it and test again 
 (deftest :fddl/sequence/1
     (progn (clsql:create-sequence [foo])