X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=base%2Fbasic-sql.lisp;h=eaccc03315e1770b8139e0be2a10cbd27bd7a757;hp=5c12002bcfe527802991a4d4ebd2ca16629778cb;hb=9bbed78051e80e6ab76ae47834136035602bbbf1;hpb=6c70be35cc348b559d8aa869ecd0e14e27d5edbc diff --git a/base/basic-sql.lisp b/base/basic-sql.lisp index 5c12002..eaccc03 100644 --- a/base/basic-sql.lisp +++ b/base/basic-sql.lisp @@ -12,7 +12,7 @@ ;;;; (http://opensource.franz.com/preamble.html), also known as the LLGPL. ;;;; ************************************************************************* -(in-package #:clsql-base-sys) +(in-package #:clsql-base) ;;; Query @@ -30,16 +30,17 @@ 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)) + (result-types :auto) (flatp nil) (field-names t)) (record-sql-action query-expression :query 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-action res :result database) - res)) + (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) + (if field-names + (values result names) + result)))) ;;; Execute @@ -59,10 +60,6 @@ pair.")) (record-sql-action res :result database)) (values)) - -(defmethod describe-table ((table string) &key (database *default-database*)) - (database-describe-table database table)) - (defmacro do-query (((&rest args) query-expression &key (database '*default-database*) (result-types nil)) &body body)