X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=sql%2Fsql.cl;fp=sql%2Fsql.cl;h=310001eb221defd1860adb513c293d640fd3ff81;hb=b55c36d4d3835550407db78b1baa76a0bffdc5c1;hp=6d2d8bb1a8b0478b35ff640d931a658824c88248;hpb=a01be1182a7df36a329ee6384e8e403adb2ed9b1;p=clsql.git diff --git a/sql/sql.cl b/sql/sql.cl index 6d2d8bb..310001e 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.14 2002/05/01 20:22:16 marc.battyani Exp $ +;;;; $Id: sql.cl,v 1.15 2002/05/03 20:50:18 marc.battyani Exp $ ;;;; ;;;; This file, part of CLSQL, is Copyright (c) 2002 by Kevin M. Rosenberg ;;;; and Copyright (c) 1999-2001 by Pierre R. Mai @@ -96,12 +96,15 @@ initialized, as indicated by `*initialized-database-types*'." (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." +connection-spec. if-exists is currently ignored. +If pool is t the the connection will be taken from the general pool, +if pool is a conn-pool object the connection will be taken from this pool. +" (let* ((db-name (database-name-from-spec connection-spec database-type)) (old-db (unless (eq if-exists :new) (find-database db-name nil))) (result nil)) (if pool - (setq result (acquire-from-pool connection-spec database-type)) + (setq result (acquire-from-pool connection-spec database-type pool)) (if old-db (case if-exists ; (:new @@ -134,11 +137,11 @@ connection-spec. if-exists is currently ignored." result))) -(defun disconnect (&key (database *default-database*) - (pool nil)) +(defun disconnect (&key (database *default-database*)) "Closes the connection to database. Resets *default-database* if that -database was disconnected and only one other connection exists." - (if pool +database was disconnected and only one other connection exists. +if the database is from a pool it will be released to this pool." + (if (conn-pool database) (release-to-pool database) (when (database-disconnect database) (setq *connected-databases* (delete database *connected-databases*))