X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=tests%2Ftest-oodml.lisp;h=3cde0a75602354d67d57069324976e52f7221893;hb=a56b464f5cd084bb8cc493a150b49a6033f48143;hp=2ae3005c55e16e73b5fd7473b233408313103f36;hpb=75defa0ce7e93c50c87fe272632dcdd942e80d49;p=clsql.git

diff --git a/tests/test-oodml.lisp b/tests/test-oodml.lisp
index 2ae3005..3cde0a7 100644
--- a/tests/test-oodml.lisp
+++ b/tests/test-oodml.lisp
@@ -105,6 +105,16 @@
 	     (employee-addresses employee2))
 	  ((t t 2 2 2)))
 
+        (deftest :oodml/select/11 
+         (values (mapcar #'(lambda (x) (slot-value x 'emplid))
+                         (clsql:select 'employee :order-by '(([emplid] :asc)) 
+                                       :flatp t))
+          (mapcar #'(lambda (x) (slot-value x 'emplid))
+                  (clsql:select 'employee :order-by '(([emplid] :desc)) 
+                                :flatp t)))
+         (1 2 3 4 5 6 7 8 9 10)
+         (10 9 8 7 6 5 4 3 2 1))
+
 	;; test retrieval is deferred
 	(deftest :oodm/retrieval/1
 	    (every #'(lambda (e) (not (slot-boundp e 'company)))
@@ -374,7 +384,7 @@
 	  ("Lenin" "Stalin" "Trotsky"))
 
 
-      (deftest oodml/cache/1
+      (deftest :oodml/cache/1
 	  (progn
 	    (setf (clsql-sys:record-caches *default-database*) nil)
 	    (let ((employees (select 'employee)))
@@ -382,17 +392,17 @@
 		     employees (select 'employee))))
 	t)
 
-	(deftest oodml/cache/2
+	(deftest :oodml/cache/2
 	    (let ((employees (select 'employee)))
 	      (equal employees (select 'employee :flatp t)))
 	  nil)
 	
-	(deftest oodml/refresh/1
+	(deftest :oodml/refresh/1
 	    (let ((addresses (select 'address)))
 	      (equal addresses (select 'address :refresh t)))
 	  t)
 
-	(deftest oodml/refresh/2
+	(deftest :oodml/refresh/2
 	    (let* ((addresses (select 'address :order-by [addressid] :flatp t))
 		   (city (slot-value (car addresses) 'city)))
 	      (clsql:update-records [addr] 
@@ -409,14 +419,14 @@
 			new-city)))
 	  t "Leningrad" "A new city")
 	
-	(deftest oodml/refresh/3
+	(deftest :oodml/refresh/3
 	    (let* ((addresses (select 'address :order-by [addressid] :flatp t)))
 	      (values
 	       (equal addresses (select 'address :refresh t :flatp t))
 	       (equal addresses (select 'address :flatp t))))
 	  nil nil)
 	
-	(deftest oodml/refresh/4
+	(deftest :oodml/refresh/4
 	    (let* ((addresses (select 'address :order-by [addressid] :flatp t))
 		   (*db-auto-sync* t))
 	      (make-instance 'address :addressid 1000 :city "A new address city")
@@ -430,7 +440,7 @@
 	  2 3 t t)
 		
 	      
-	(deftest oodml/uoj/1
+	(deftest :oodml/uoj/1
 	    (progn
 	      (let* ((dea-list (select 'deferred-employee-address :caching nil :order-by [ea_join aaddressid]
 				       :flatp t))