X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=base%2Fdb-interface.lisp;h=cfae08a402ef84c66d7f1ee47cc8e4accb5a5eb2;hb=8b5250e14e3280bdc4641c3b35a8dc68ca4dbde7;hp=9a91a6902c2ebebe3357d9a102fa5ac7d551d637;hpb=f2a0eb003af406415567c9f8545455ede786db87;p=clsql.git

diff --git a/base/db-interface.lisp b/base/db-interface.lisp
index 9a91a69..cfae08a 100644
--- a/base/db-interface.lisp
+++ b/base/db-interface.lisp
@@ -30,13 +30,6 @@
    "The internal generic implementation for checking if
 database type library loaded successfully."))
 
-(defgeneric database-type (database)
-  (:documentation
-   "Returns database type")
-  (:method (database)
-	   (signal-no-database-error database)))
-
-
 (defgeneric database-initialize-database-type (database-type)
   (:documentation
    "The internal generic implementation of initialize-database-type."))
@@ -59,9 +52,9 @@ was called with the connection-spec."))
 	   (signal-no-database-error database))
   (:documentation "Internal generic implementation of disconnect."))
 
-(defgeneric database-query (query-expression database result-types)
-  (:method (query-expression (database t) result-types)
-	   (declare (ignore query-expression result-types))
+(defgeneric database-query (query-expression database result-types field-names)
+  (:method (query-expression (database t) result-types field-names)
+	   (declare (ignore query-expression result-types field-names))
 	   (signal-no-database-error database))
   (:documentation "Internal generic implementation of query."))
 
@@ -224,6 +217,13 @@ the given lisp type and parameters."))
 	   t)
   (:documentation "T [default] if database-type supports views."))
 
+(defgeneric db-type-default-case (db-type)
+  (:method (db-type)
+	   (declare (ignore db-type))
+	   ;; By default, CommonSQL converts identifiers to UPPER case. 
+	   :upper)
+  (:documentation ":upper [default] if means identifiers mapped to UPPER case SQL like CommonSQL API. However, Postgresql maps identifiers to lower case, so PostgreSQL uses a value of :lower for this result."))
+
 (defgeneric db-type-has-fancy-math? (db-type)
   (:method (db-type)
 	   (declare (ignore db-type))
@@ -277,7 +277,7 @@ the given lisp type and parameters."))
     (signal-closed-database-error database)))
 
 (defmethod database-query :before (query-expression (database database) 
-				   result-set)
+				   result-set field-names)
   (declare (ignore query-expression result-set))
   (unless (is-database-open database)
     (signal-closed-database-error database)))