3)
(deftest :oodml/select/6
- (slot-value (caar (clsql:select 'employee :where [= 1 [emplid]])) 'married)
- t)
+ (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/7
- (slot-value (caar (clsql:select 'employee :where [= 4 [emplid]])) 'married)
- nil)
+ (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/8
+ (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