X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=sql%2Fsql.cl;h=f5eebd730768fe4ee6e75670b1a4fd2d0daa365c;hb=f8478421f5a0440246f70aa4234ff25f416be7e3;hp=529925dfed98a1600b28ad67b5c28892a0cf3a41;hpb=0384597fcf4fdc8b05c48596798606ea5dc58146;p=clsql.git

diff --git a/sql/sql.cl b/sql/sql.cl
index 529925d..f5eebd7 100644
--- a/sql/sql.cl
+++ b/sql/sql.cl
@@ -8,7 +8,7 @@
 ;;;;                 Original code by Pierre R. Mai 
 ;;;; Date Started:  Feb 2002
 ;;;;
-;;;; $Id: sql.cl,v 1.9 2002/03/29 08:12:16 kevin Exp $
+;;;; $Id: sql.cl,v 1.13 2002/04/27 20:58:11 kevin Exp $
 ;;;;
 ;;;; This file, part of CLSQL, is Copyright (c) 2002 by Kevin M. Rosenberg
 ;;;; and Copyright (c) 1999-2001 by Pierre R. Mai
@@ -35,11 +35,14 @@
 (defvar *loaded-database-types* nil
   "Contains a list of database types which have been defined/loaded.")
 
+(defmethod database-type-load-foreign :after (database-type)
+  (when (database-type-library-loaded database-type)
+     (pushnew database-type *loaded-database-types*)))
+
 (defun reload-database-types ()
   "Reloads any foreign code for the loaded database types after a dump."
   (mapc #'database-type-load-foreign *loaded-database-types*))
 
-
 (defvar *default-database-type* nil
   "Specifies the default type of database.  Currently only :mysql is
 supported.")
@@ -92,56 +95,59 @@ initialized, as indicated by `*initialized-database-types*'."
 
 (defun connect (connection-spec
 		&key (if-exists *connect-if-exists*)
-		(database-type *default-database-type*))
+		(database-type *default-database-type*)
+		(pool nil))
   "Connects to a database of the given database-type, using the type-specific
 connection-spec.  if-exists is currently ignored."
   (let* ((db-name (database-name-from-spec connection-spec database-type))
 	 (old-db (find-database db-name nil))
 	 (result nil))
-    (if old-db
-	(case if-exists
-	  (:new
-	   (setq result
-		 (database-connect connection-spec database-type)))
-	  (:warn-new
-	   (setq result
-		 (database-connect connection-spec database-type))
-	   (warn 'clsql-exists-warning :old-db old-db :new-db result))
-	  (:error
-	   (restart-case
-	       (error 'clsql-exists-error :old-db old-db)
-	     (create-new ()
-	       :report "Create a new connection."
-	       (setq result
-		     (database-connect connection-spec database-type)))
-	     (use-old ()
-	       :report "Use the existing connection."
-	       (setq result old-db))))
-	  (:warn-old
-	   (setq result old-db)
-	   (warn 'clsql-exists-warning :old-db old-db :new-db old-db))
-	  (:old
-	   (setq result old-db)))
+    (if pool
+	(setq result (acquire-from-pool connection-spec database-type))
+      (if old-db
+	  (case if-exists
+	    (:new
+	     (setq result
+	       (database-connect connection-spec database-type)))
+	    (:warn-new
+	     (setq result
+	       (database-connect connection-spec database-type))
+	     (warn 'clsql-exists-warning :old-db old-db :new-db result))
+	    (:error
+	     (restart-case
+		 (error 'clsql-exists-error :old-db old-db)
+	       (create-new ()
+		   :report "Create a new connection."
+		 (setq result
+		   (database-connect connection-spec database-type)))
+	       (use-old ()
+		   :report "Use the existing connection."
+		 (setq result old-db))))
+	    (:warn-old
+	     (setq result old-db)
+	     (warn 'clsql-exists-warning :old-db old-db :new-db old-db))
+	    (:old
+	     (setq result old-db)))
 	(setq result
-	      (database-connect connection-spec database-type)))
+	  (database-connect connection-spec database-type))))
     (when result
       (pushnew result *connected-databases*)
       (setq *default-database* result)
       result)))
 
 
-
-(defun disconnect (&key (database *default-database*))
+(defun disconnect (&key (database *default-database*)
+		   (pool nil))
   "Closes the connection to database. Resets *default-database* if that
 database was disconnected and only one other connection exists."
-  (when (database-disconnect database)
-    (setq *connected-databases* (delete database *connected-databases*))
-    (when (eq database *default-database*)
-      (setq *default-database* (car *connected-databases*)))
-    (change-class database 'closed-database)
-    t))
-
-
+  (if pool
+      (release-to-pool database)
+    (when (database-disconnect database)
+      (setq *connected-databases* (delete database *connected-databases*))
+      (when (eq database *default-database*)
+	(setq *default-database* (car *connected-databases*)))
+      (change-class database 'closed-database)
+      t)))
 
 ;;; Basic operations on databases
 
@@ -267,5 +273,20 @@ specified in output-type-spec and returned like in MAP."
 		    ,@body))
 	     (database-dump-result-set ,result-set ,db)))))))
 
+;;; Marc Battyani : 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))