;;;; Programmer: Kevin M. Rosenberg
;;;; Date Started: Apr 2000
;;;;
-;;;; $Id: sql.lisp,v 1.5 2002/10/16 16:05:23 kevin Exp $
+;;;; $Id: sql.lisp,v 1.8 2002/11/11 07:15:48 kevin Exp $
;;;;
;;;; This file, part of UMLisp, is
;;;; Copyright (c) 2000-2002 by Kevin M. Rosenberg, M.D.
(declaim (optimize (speed 3) (safety 1) (compilation-speed 0) (debug 3)))
-(defvar *umls-sql-dsn* "KUMLS2002AC")
+(defvar *umls-sql-dsn* "KUMLS2002AD")
(defun umls-sql-dsn ()
*umls-sql-dsn*)
(defun umls-sql-dsn! (dbname)
(defun mutex-sql-query (cmd &key (types :auto))
(with-mutex-sql (conn)
(sql-query cmd conn :types types)))
-
-
-
-(defun make-usrl ()
- (with-sql-connection (conn)
- (sql-execute "drop table if exists USRL" conn)
- (sql-execute "create table USRL (sab varchar(80), srl integer)" conn)
- (dolist (tuple (mutex-sql-query "select distinct SAB,SRL from MRSO order by SAB asc"))
- (sql-execute (format nil "insert into USRL (sab,srl) values ('~a',~d)"
- (car tuple) (ensure-integer (cadr tuple)))
- conn)))
- (find-usrl-all))
-
-(defun find-usrl-all ()
- (let ((usrls '())
- (tuples (mutex-sql-query "select SAB,SRL from USRL order by SAB desc")))
- (dolist (tuple tuples)
- (push (make-instance 'usrl :sab (nth 0 tuple)
- :srl (ensure-integer (nth 1 tuple))) usrls))
- usrls))
-
-