projects
/
umlisp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
r9104: update dates/headers
[umlisp.git]
/
sql.lisp
diff --git
a/sql.lisp
b/sql.lisp
index 5495af4b71048b54ea0079426879691917599f31..86f689328f0b2925819c5285874d993ebc6fe4fc 100644
(file)
--- a/
sql.lisp
+++ b/
sql.lisp
@@
-2,15
+2,15
@@
;;;; *************************************************************************
;;;; FILE IDENTIFICATION
;;;;
;;;; *************************************************************************
;;;; FILE IDENTIFICATION
;;;;
-;;;; Name:
sql.lisp
-;;;; Purpose:
Low-level SQL routines data for UMLisp
-;;;; Author:
Kevin M. Rosenberg
-;;;;
Date Star
ted: Apr 2000
+;;;; Name: sql.lisp
+;;;; Purpose: Low-level SQL routines data for UMLisp
+;;;; Author: Kevin M. Rosenberg
+;;;;
Crea
ted: Apr 2000
;;;;
;;;;
-;;;; $Id
: sql.lisp,v 1.15 2003/08/08 09:18:03 kevin Exp
$
+;;;; $Id$
;;;;
;;;; This file, part of UMLisp, is
;;;;
;;;; This file, part of UMLisp, is
-;;;; Copyright (c) 2000-200
3
by Kevin M. Rosenberg, M.D.
+;;;; Copyright (c) 2000-200
4
by Kevin M. Rosenberg, M.D.
;;;;
;;;; UMLisp users are granted the rights to distribute and use this software
;;;; as governed by the terms of the GNU General Public License.
;;;;
;;;; UMLisp users are granted the rights to distribute and use this software
;;;; as governed by the terms of the GNU General Public License.
@@
-20,21
+20,21
@@
(defvar +umls-sql-map+
'((:2002AD . "KUMLS2002AD") (:2003AA . "KUMLS2003AA")
(defvar +umls-sql-map+
'((:2002AD . "KUMLS2002AD") (:2003AA . "KUMLS2003AA")
- (:2003AB . "KUMLS2003AB")))
-(defvar +default-umls-db+ "KUMLS2003AB")
+ (:2003AB . "KUMLS2003AB") (:2003AC . "KUMLS2003AC")
+ (:2004AA . "KUMLS2004AA")))
+(defvar +default-umls-db+ :2003AC)
(defun lookup-db-name (db)
(cdr (assoc (ensure-keyword db) +umls-sql-map+)))
(defun lookup-db-name (db)
(cdr (assoc (ensure-keyword db) +umls-sql-map+)))
+(defvar *umls-sql-db* +default-umls-db+)
(defun umls-sql-db ()
*umls-sql-db*)
(defun umls-sql-db! (db)
(setq *umls-sql-db* db))
(defun umls-sql-db ()
*umls-sql-db*)
(defun umls-sql-db! (db)
(setq *umls-sql-db* db))
-(umls-sql-db! :2003AB)
-
(defvar *umls-sql-user* "secret")
(defun umls-sql-user ()
*umls-sql-user*)
(defvar *umls-sql-user* "secret")
(defun umls-sql-user ()
*umls-sql-user*)
@@
-87,8
+87,8
@@
(sql-query stmt conn)
(sql-execute stmt conn)))
(sql-query stmt conn)
(sql-execute stmt conn)))
-(defun sql-query (cmd conn &key (types :auto))
- (clsql:query cmd :database conn :
types
types))
+(defun sql-query (cmd conn &key (
result-
types :auto))
+ (clsql:query cmd :database conn :
result-types result-
types))
(defun sql-execute (cmd conn)
(clsql:execute-command cmd :database conn))
(defun sql-execute (cmd conn)
(clsql:execute-command cmd :database conn))
@@
-110,6
+110,6
@@
(with-mutex-sql (conn)
(sql-execute cmd conn)))
(with-mutex-sql (conn)
(sql-execute cmd conn)))
-(defun mutex-sql-query (cmd &key (types :auto))
+(defun mutex-sql-query (cmd &key (
result-
types :auto))
(with-mutex-sql (conn)
(with-mutex-sql (conn)
- (sql-query cmd conn :
types
types)))
+ (sql-query cmd conn :
result-types result-
types)))