(slot-value a 'loc))))
10 10 "subloc-1" "a subloc")
+(deftest :oodml/select/23
+ (with-dataset *ds-artists*
+ (length (clsql:select 'artist :flatp t :caching nil)))
+ 0)
+
+
+
;; test retrieval is deferred
(deftest :oodm/retrieval/1
(with-dataset *ds-employees*
;; tests update-record-from-slot
(deftest :oodml/update-records/2
(with-dataset *ds-employees*
+ ;(start-sql-recording :type :both)
(values
(employee-email
(car (clsql:select 'employee
:where [= 1 [slot-value 'employee 'emplid]]
:flatp t
:caching nil)))
- (progn
- (setf (slot-value employee1 'email) "lenin-nospam@soviet.org")
- (clsql:update-record-from-slot employee1 'email)
+ (progn
+ (setf (slot-value employee1 'email) "lenin-nospam@soviet.org")
+ (clsql:update-record-from-slot employee1 'email)
(employee-email
(car (clsql:select 'employee
:where [= 1 [slot-value 'employee 'emplid]]
;; (was failing in Postgresql at somepoint)
(deftest :oodml/update-records/10
(with-dataset *ds-employees*
- (let ((emp (first (clsql:select 'employee :where [= [emplid] 1] :flatp T))))
+ (let ((emp (first (clsql:select 'employee :where [= [emplid] 1] :flatp t))))
(setf (height emp) nil)
(clsql-sys:update-record-from-slot emp 'height)
(values
((42.0d0))
((24.13d0)))
+(deftest :oodml/update-records/11
+ (with-dataset *ds-artists*
+ (clsql:update-records-from-instance artist1)
+ (list (name artist1) (artist_id artist1)))
+ ("Mogwai" 1))
+
+(deftest :oodml/update-records/12
+ (with-dataset *ds-artists*
+ (clsql:update-records-from-instance artist1)
+ (list (name artist1) (genre artist1)))
+ ("Mogwai" "Unknown"))
;; tests update-instance-from-records
(deftest :oodml/update-instance/1
(values
(let ((inst (make-instance 'theme
:title "test-theme" :vars "test-vars"
- :doc "test-doc")))
+ :doc "test-doc"))
+ (*print-circle* nil))
(setf (slot-value inst 'title) "alternate-test-theme")
(format nil "~a ~a ~a ~a"
(or (select [title] :from [node]