(defvar +umls-sql-map+
'((:2004aa . "KUMLS2004AA")
- (:2006ac . "KUMLS2006AC")))
-(defvar +default-umls-db+ :2006ac)
+ (:2006ac . "KUMLS2006AC")
+ (:2006ad . "MTS2006AD")))
+(defvar +default-umls-db+ "MTS2006AD")
(defun lookup-db-name (db)
(defun sql-connect ()
"Connect to UMLS database, automatically used pooled connections"
(clsql:connect (umls-connection-spec)
- :database-type *umls-sql-type* :pool t))
+ :database-type *umls-sql-type* :pool t))
(defun sql-disconnect (conn)
"Disconnect from UMLS database, but put connection back into pool"
(defmacro with-sql-connection ((conn) &body body)
`(let ((,conn (sql-connect)))
(unwind-protect
- (progn ,@body)
+ (progn ,@body)
(when ,conn (clsql:disconnect :database ,conn)))))
(defun sql-query (cmd conn &key (result-types :auto))
(defmacro with-mutex-sql ((conn) &body body)
`(let ((,conn (sql-connect)))
(unwind-protect
- (progn ,@body)
+ (progn ,@body)
(when ,conn (sql-disconnect ,conn)))))
(defun mutex-sql-execute (cmd)