+
+#+lispworks (in-package loop)
+
+#+lispworks
+(cl-user::define-loop-method (record records tuple tuples) ansi-loop::clsql-loop-method (in of from))
+
+#+lispworks
+(defun ansi-loop::clsql-loop-method (method-name iter-var iter-var-data-type
+ prep-phrases inclusive? allowed-preps
+ method-specific-data)
+ (let ((in-phrase nil)
+ (from-phrase nil))
+ (loop for (prep . rest) in prep-phrases
+ do
+ (cond
+ ((or (eq prep 'in) (eq prep 'of))
+ (when in-phrase
+ (error
+ "Duplicate OF or IN iteration path: ~S." (cons prep rest)))
+ (setq in-phrase rest))
+ ((eq prep 'from)
+ (when from-phrase
+ (error
+ "Duplicate FROM iteration path: ~S." (cons prep rest)))
+ (setq from-phrase rest))
+ (t
+ (error
+ "Unknown preposition: ~S." prep))))
+ (unless in-phrase
+ (error "Missing OF or IN iteration path."))
+ (unless from-phrase
+ (setq from-phrase '(clsql-base-sys:*default-database*)))
+ (cond
+ ((consp iter-var)
+ (let ((query-var (ansi-loop::loop-gentemp 'loop-record-))
+ (db-var (ansi-loop::loop-gentemp 'loop-record-database-))
+ (result-set-var (ansi-loop::loop-gentemp
+ 'loop-record-result-set-))
+ (step-var (ansi-loop::loop-gentemp 'loop-record-step-)))
+ #+ignore
+ (push `(when ,result-set-var
+ (clsql-base-sys:database-dump-result-set ,result-set-var ,db-var))
+ ansi-loop::*epilogue*)
+ `(((,iter-var nil ,iter-var-data-type) (,query-var ,(first in-phrase))
+ (,db-var ,(first from-phrase))
+ (,result-set-var nil)
+ (,step-var nil))
+ ((multiple-value-bind (%rs %cols)
+ (clsql-base-sys:database-query-result-set ,query-var ,db-var)
+ (setq ,result-set-var %rs ,step-var (make-list %cols))))
+ ()
+ ()
+ (not (clsql-base-sys:database-store-next-row ,result-set-var ,db-var ,step-var))
+ (,iter-var ,step-var)
+ (not ,result-set-var)
+ ()
+ (not (clsql-base-sys:database-store-next-row ,result-set-var ,db-var ,step-var))
+ (,iter-var ,step-var))))
+ (t
+ (let ((query-var (ansi-loop::loop-gentemp 'loop-record-))
+ (db-var (ansi-loop::loop-gentemp 'loop-record-database-))
+ (result-set-var (ansi-loop::loop-gentemp
+ 'loop-record-result-set-)))
+ #+ignore
+ (push `(when ,result-set-var
+ (clsql-base-sys:database-dump-result-set ,result-set-var ,db-var))
+ ansi-loop::*epilogue*)
+ `(((,iter-var nil ,iter-var-data-type) (,query-var ,(first in-phrase))
+ (,db-var ,(first from-phrase))
+ (,result-set-var nil))
+ ((multiple-value-bind (%rs %cols)
+ (clsql-base-sys:database-query-result-set ,query-var ,db-var)
+ (setq ,result-set-var %rs ,iter-var (make-list %cols))))
+ ()
+ ()
+ (not (clsql-base-sys:database-store-next-row ,result-set-var ,db-var ,iter-var))
+ ()
+ (not ,result-set-var)
+ ()
+ (not (clsql-base-sys:database-store-next-row ,result-set-var ,db-var ,iter-var))
+ ()))))))
+
+
+