r9119: Automated commit for Debian build of clsql upstream-version-2.9.2

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

diff --git a/base/db-interface.lisp b/base/db-interface.lisp
index 7c75dd0fa95dd7305c64ef4daff373e4763dd73e..9591c9c488495970b06952b87767c692a74e830d 100644 (file)
--- a/base/db-interface.lisp
+++ b/base/db-interface.lisp
@@ -186,6 +186,9 @@ the given lisp type and parameters."))
 (defgeneric database-list-indexes (database &key owner)
   (:documentation "List all indexes in the DATABASE."))
 
+(defgeneric database-list-table-indexes (table database &key owner)
+  (:documentation "List all indexes for a table in the DATABASE."))
+
 (defgeneric database-list-attributes (table database &key owner)
   (:documentation "List all attributes in TABLE."))
 
@@ -201,6 +204,50 @@ the given lisp type and parameters."))
 (defgeneric oid (object)
   (:documentation "Return the unique ID of a database object."))
 
+;;; Database backend capabilities
+
+(defgeneric database-underlying-type (database)
+  (:method (database)
+    (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-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))
+          ;; SQL92 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)