X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=base%2Fbasic-sql.lisp;fp=base%2Fbasic-sql.lisp;h=61a932e5ad02df135fc3e6c0687c4c6c962ca0d8;hb=5691bb90517d7c565a141d131da76c3de1f8d566;hp=4610c4208793c21cf3e85d57ddb8564b4392880f;hpb=7fe2be1c1362639b32fab48534f3dce614586ff4;p=clsql.git diff --git a/base/basic-sql.lisp b/base/basic-sql.lisp index 4610c42..61a932e 100644 --- a/base/basic-sql.lisp +++ b/base/basic-sql.lisp @@ -61,7 +61,7 @@ pair.")) (defmacro do-query (((&rest args) query-expression - &key (database '*default-database*) (types nil)) + &key (database '*default-database*) (result-types nil)) &body body) "Repeatedly executes BODY within a binding of ARGS on the attributes of each record resulting from QUERY. The return value is determined by @@ -74,7 +74,7 @@ the result of executing BODY. The default value of DATABASE is `(let ((,db ,database)) (multiple-value-bind (,result-set ,columns) (database-query-result-set ,query-expression ,db - :full-set nil :types ,types) + :full-set nil :result-types ,result-types) (when ,result-set (unwind-protect (do ((,row (make-list ,columns))) @@ -86,7 +86,7 @@ the result of executing BODY. The default value of DATABASE is (defun map-query (output-type-spec function query-expression &key (database *default-database*) - (types nil)) + (result-types nil)) "Map the function over all tuples that are returned by the query in query-expression. The results of the function are collected as specified in output-type-spec and returned like in MAP." @@ -94,21 +94,21 @@ specified in output-type-spec and returned like in MAP." `(if (atom ,type) ,type (car ,type)))) (case (type-specifier-atom output-type-spec) ((nil) - (map-query-for-effect function query-expression database types)) + (map-query-for-effect function query-expression database result-types)) (list - (map-query-to-list function query-expression database types)) + (map-query-to-list function query-expression database result-types)) ((simple-vector simple-string vector string array simple-array bit-vector simple-bit-vector base-string simple-base-string) - (map-query-to-simple output-type-spec function query-expression database types)) + (map-query-to-simple output-type-spec function query-expression database result-types)) (t (funcall #'map-query (cmucl-compat:result-type-or-lose output-type-spec t) - function query-expression :database database :types types))))) + function query-expression :database database :result-types result-types))))) -(defun map-query-for-effect (function query-expression database types) +(defun map-query-for-effect (function query-expression database result-types) (multiple-value-bind (result-set columns) (database-query-result-set query-expression database :full-set nil - :types types) + :result-types result-types) (when result-set (unwind-protect (do ((row (make-list columns))) @@ -117,10 +117,10 @@ specified in output-type-spec and returned like in MAP." (apply function row)) (database-dump-result-set result-set database))))) -(defun map-query-to-list (function query-expression database types) +(defun map-query-to-list (function query-expression database result-types) (multiple-value-bind (result-set columns) (database-query-result-set query-expression database :full-set nil - :types types) + :result-types result-types) (when result-set (unwind-protect (let ((result (list nil))) @@ -132,10 +132,10 @@ specified in output-type-spec and returned like in MAP." (database-dump-result-set result-set database))))) -(defun map-query-to-simple (output-type-spec function query-expression database types) +(defun map-query-to-simple (output-type-spec function query-expression database result-types) (multiple-value-bind (result-set columns rows) (database-query-result-set query-expression database :full-set t - :types types) + :result-types result-types) (when result-set (unwind-protect (if rows