X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=tests%2Ftest-oodml.lisp;h=9969abde55dc504ac479eedd358a7eda907a9730;hb=4fbe211143d23f4f0ece6db9433d7cabf5ef49ce;hp=7cac6feae92ebfcf34d62ca10246ee518e68c271;hpb=1dda729b250779079efbdc1d3f6bbb3ae4a20ba4;p=clsql.git

diff --git a/tests/test-oodml.lisp b/tests/test-oodml.lisp
index 7cac6fe..9969abd 100644
--- a/tests/test-oodml.lisp
+++ b/tests/test-oodml.lisp
@@ -66,6 +66,29 @@
     (slot-value (caar (clsql:select 'employee :where [= 4 [emplid]])) 'married)
   nil)
 
+(deftest :oodml/select/8
+    (let ((a (caar (clsql:select 'address :where [= 1 [emplid]]))))
+      (values
+       (slot-value a 'street-number)
+       (slot-value a 'street-name)
+       (slot-value a 'city)
+       (slot-value a 'postal-code)))
+  10 "Park Place" "Leningrad" 123)
+
+(deftest :oodml/select/9
+    (let ((a (caar (clsql:select 'address :where [= 2 [emplid]]))))
+      (values
+       (slot-value a 'street-number)
+       (slot-value a 'street-name)
+       (slot-value a 'city)
+       (slot-value a 'postal-code)))
+  nil "" "no city" 0)
+
+(deftest :oodml/select/10 
+    (mapcar #'(lambda (e) (slot-value e 'married)) 
+              (clsql:select 'employee :flatp t :order-by [emplid]))
+  (T T T NIL NIL NIL NIL NIL NIL NIL))
+
 ;; tests update-records-from-instance 
 (deftest :oodml/update-records/1
     (values