X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=sql.lisp;h=60db70661d991dfa295bd7ca624ce0b98c532c66;hb=4b868c1d56d25c99db944ae35a4f33c7cf5d98d6;hp=7e5ce8892f1e5d61c17b964c8711b2819cfce680;hpb=cd8b476663925be5a1ebbeb569a056e2e5b93aba;p=umlisp.git diff --git a/sql.lisp b/sql.lisp index 7e5ce88..60db706 100644 --- a/sql.lisp +++ b/sql.lisp @@ -1,18 +1,31 @@ -;;;; -*- Mode: LISP; Syntax: Common-Lisp; Base: 10; Pkg: umlisp -*- -;; SQL/UMLS database Layer over database backend -;; Copyright (c) 2001 Kevin M. Rosenberg, M.D. -;; $Id: sql.lisp,v 1.2 2002/10/08 22:13:41 kevin Exp $ +;;;; -*- Mode: Lisp; Syntax: ANSI-Common-Lisp; Base: 10; Package: umlisp -*- +;;;; ************************************************************************* +;;;; FILE IDENTIFICATION +;;;; +;;;; Name: sql.lisp +;;;; Purpose: Low-level SQL routines data for UMLisp +;;;; Programmer: Kevin M. Rosenberg +;;;; Date Started: Apr 2000 +;;;; +;;;; $Id: sql.lisp,v 1.9 2002/12/09 14:11:09 kevin Exp $ +;;;; +;;;; This file, part of UMLisp, is +;;;; Copyright (c) 2000-2002 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. +;;;; ************************************************************************* (in-package :umlisp) +(declaim (optimize (speed 3) (safety 1) (compilation-speed 0) (debug 3))) -(declaim (optimize (speed 1) (safety 3))) -(defvar *umls-sql-dsn* "KUMLS2002AC") -(defun umls-sql-dsn () - *umls-sql-dsn*) -(defun umls-sql-dsn! (dbname) +(defvar *umls-sql-db* "KUMLS2002AD") +(defun umls-sql-db () + *umls-sql-db*) +(defun umls-sql-db! (dbname) (sql-disconnect-pooled) - (setq *umls-sql-dsn* dbname)) + (setq *umls-sql-db* dbname)) (defvar *umls-sql-user* "secret") (defun umls-sql-user () @@ -44,7 +57,7 @@ (defun sql-connect () "Connect to UMLS database, automatically used pooled connections" - (clsql:connect `(,(umls-sql-host) ,(umls-sql-dsn) ,(umls-sql-user) ,(umls-sql-passwd)) + (clsql:connect `(,(umls-sql-host) ,(umls-sql-db) ,(umls-sql-user) ,(umls-sql-passwd)) :database-type *umls-sql-type* :pool t)) (defun sql-disconnect (conn) @@ -91,6 +104,3 @@ (defun mutex-sql-query (cmd &key (types :auto)) (with-mutex-sql (conn) (sql-query cmd conn :types types))) - - -