X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=base%2Fbasic-sql.lisp;h=4546f4e1b4214b874887ef350940f8db9015c1f0;hb=8b5250e14e3280bdc4641c3b35a8dc68ca4dbde7;hp=61a932e5ad02df135fc3e6c0687c4c6c962ca0d8;hpb=5691bb90517d7c565a141d131da76c3de1f8d566;p=clsql.git diff --git a/base/basic-sql.lisp b/base/basic-sql.lisp index 61a932e..4546f4e 100644 --- a/base/basic-sql.lisp +++ b/base/basic-sql.lisp @@ -30,16 +30,15 @@ one result per row. Returns a list of lists of values of the result of that expression and a list of field names selected in sql-exp.")) (defmethod query ((query-expression string) &key (database *default-database*) - (result-types nil) (flatp nil)) - (record-sql-command query-expression database) - (let* ((res (database-query query-expression database result-types)) - (res (if (and flatp (= (length - (slot-value query-expression 'selections)) - 1)) - (mapcar #'car res) - res))) - (record-sql-result res database) - res)) + (result-types nil) (flatp nil) (field-names t)) + (record-sql-action query-expression :query database) + (multiple-value-bind (rows names) (database-query query-expression database result-types + field-names) + (let ((result (if (and flatp (= 1 (length (car rows)))) + (mapcar #'car rows) + rows))) + (record-sql-action result :result database) + (values result names)))) ;;; Execute @@ -54,12 +53,11 @@ pair.")) (defmethod execute-command ((sql-expression string) &key (database *default-database*)) - (record-sql-command sql-expression database) + (record-sql-action sql-expression :command database) (let ((res (database-execute-command sql-expression database))) - (record-sql-result res database)) + (record-sql-action res :result database)) (values)) - (defmacro do-query (((&rest args) query-expression &key (database '*default-database*) (result-types nil)) &body body)