;;;; (http://opensource.franz.com/preamble.html), also known as the LLGPL.
;;;; *************************************************************************
-(in-package #:clsql-base-sys)
+(in-package #:clsql-base)
(defgeneric database-type-load-foreign (database-type)
(:documentation
"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."))
(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."))
(:documentation "List all attributes in TABLE."))
(defgeneric database-attribute-type (attribute table database &key owner)
- (:documentation "Return the type of ATTRIBUTE in TABLE."))
+ (:documentation "Return the type of ATTRIBUTE in TABLE. Returns multiple values
+of TYPE_NAME (keyword) PRECISION SCALE NULLABLE."))
(defgeneric database-add-attribute (table attribute database)
(:documentation "Add the attribute to the table."))
;;; 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)
(signal-closed-database-error database)))
(defmethod database-query :before (query-expression (database database)
- result-set)
- (declare (ignore query-expression result-set))
+ result-set field-names)
+ (declare (ignore query-expression result-set field-names))
(unless (is-database-open database)
(signal-closed-database-error database)))