r9137: add defgenerics

[clsql.git] / base / db-interface.lisp

diff --git a/base/db-interface.lisp b/base/db-interface.lisp
index d874a7f67dfa15249b46bd7eae2e1368d061ea70..2d52105bd2bb3dc478c1cc7b570c9499896ab625 100644 (file)
--- 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."))
@@ -206,13 +199,61 @@ the given lisp type and parameters."))
 
 ;;; Database backend capabilities
 
-(defgeneric db-use-column-on-drop-index? (database)
+(defgeneric database-underlying-type (database)
   (:method (database)
-          (declare (ignore database))
-          ;; Standard SQL does not use column name on DROP INDEX
-          nil)
-  (:documentation "NIL [default] lif database does not use column name on DROP INDEX."))
+    (database-type database))
+  (:documentation "Returns the type of the underlying database. For ODBC, needs to query ODBC driver."))
 
+(defgeneric db-type-use-column-on-drop-index? (db-type)
+  (:method (db-type)
+          (declare (ignore db-type))
+          nil)
+  (:documentation "NIL [default] if database-type does not use column name on DROP INDEX."))
+
+(defgeneric db-type-has-views? (db-type)
+  (:method (db-type)
+          (declare (ignore db-type))
+          ;; SQL92 has views
+          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))
+          nil)
+  (:documentation "NIL [default] if database-type does not have fancy math."))
+
+(defgeneric db-type-has-subqueries? (db-type)
+  (:method (db-type)
+          (declare (ignore db-type))
+          t)
+  (:documentation "T [default] if database-type supports views."))
+
+(defgeneric db-type-has-boolean-where? (db-type)
+  (:method (db-type)
+          (declare (ignore db-type))
+          ;; SQL99 has boolean where
+          t)
+  (:documentation "T [default] if database-type supports boolean WHERE clause, such as 'WHERE MARRIED'."))
+
+(defgeneric db-backend-has-create/destroy-db? (db-type)
+  (:method (db-type)
+          (declare (ignore db-type))
+          t)
+  (:documentation "T [default] if backend can destroy and create databases."))
+
+(defgeneric db-type-transaction-capable? (db database)
+  (:method (db database)
+          (declare (ignore db database))
+          t)
+  (:documentation "T [default] if database can supports transactions."))
 
 ;;; Large objects support (Marc Battyani)