X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=base%2Fbasic-sql.lisp;h=86f826755317b9ca1830ed4d1b96703f6d02417c;hb=913477a11d2258f8fe87ff5b390c8904d17d66fe;hp=4e968e826b4570052da98d728f1778e5a8e4c161;hpb=d2df77ea1494c4801d071c8f0e5f7886fd018da9;p=clsql.git

diff --git a/base/basic-sql.lisp b/base/basic-sql.lisp
index 4e968e8..86f8267 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,14 +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 flatp
-                  (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
 
@@ -163,5 +166,21 @@ specified in output-type-spec and returned like in MAP."
 		       (apply function row))))
 	(database-dump-result-set result-set database)))))
 
+;;; Large objects support
 
+(defun create-large-object (&key (database *default-database*))
+  "Creates a new large object in the database and returns the object identifier"
+  (database-create-large-object database))
+
+(defun write-large-object (object-id data &key (database *default-database*))
+  "Writes data to the large object"
+  (database-write-large-object object-id data database))
+
+(defun read-large-object (object-id &key (database *default-database*))
+  "Reads the large object content"
+  (database-read-large-object object-id database))
+
+(defun delete-large-object (object-id &key (database *default-database*))
+  "Deletes the large object in the database"
+  (database-delete-large-object object-id database))