X-Git-Url: http://git.kpe.io/?p=umlisp.git;a=blobdiff_plain;f=sql.lisp;h=97874c7b77c294df986e8053b6329a5a7638315b;hp=3847d02492692f4d5da0c2ee85f87b0be93a937e;hb=HEAD;hpb=9d3b7b50a36bc1d056d72a53ab5a541e16a3b103 diff --git a/sql.lisp b/sql.lisp index 3847d02..97874c7 100644 --- a/sql.lisp +++ b/sql.lisp @@ -22,8 +22,9 @@ (:2006ad . "MTS2006AD") (:2009ab . "MTS2009AB") (:2010aa . "MTS2010AA") - (:2012ab . "MTS2012AB"))) -(defvar +default-umls-db+ "MTS2012AA_ALL") + (:2012ab_all . "MTS2012AB_ALL") + (:2020ab_all . "MTS2020AB_ALL"))) +(defvar +default-umls-db+ "MTS2020AB_ALL") (defun lookup-db-name (db) (cdr (assoc (ensure-keyword db) +umls-sql-map+))) @@ -39,21 +40,21 @@ (keyword (setq *umls-sql-db* (lookup-db-name db))))) -(defvar *umls-sql-user* "secret") +(defvar *umls-sql-user* "mts") (defun umls-sql-user () *umls-sql-user*) (defun set-umls-sql-user (u) (sql-disconnect-pooled) (setq *umls-sql-user* u)) -(defvar *umls-sql-passwd* "secret") +(defvar *umls-sql-passwd* "_mts") (defun umls-sql-passwd () *umls-sql-passwd*) (defun set-umls-sql-passwd (p) (sql-disconnect-pooled) (setq *umls-sql-passwd* p)) -(defvar *umls-sql-host* "localhost") +(defvar *umls-sql-host* "mysql.med-info.com") (defun umls-sql-host () *umls-sql-host*) (defun set-umls-sql-host (h) @@ -71,7 +72,8 @@ (if (eql *umls-sql-type* :mysql) (list *umls-sql-host* *umls-sql-db* *umls-sql-user* *umls-sql-passwd* - nil '((:local-infile . 1))) + nil '((:local-infile . 1)) + ) (list *umls-sql-host* *umls-sql-db* *umls-sql-user* *umls-sql-passwd*)))