;;;; Author: Kevin M. Rosenberg
;;;; Date Started: Apr 2000
;;;;
-;;;; $Id: sql-classes.lisp,v 1.82 2003/05/16 03:10:18 kevin Exp $
+;;;; $Id: sql-classes.lisp,v 1.86 2003/06/24 00:27:59 kevin Exp $
;;;;
;;;; This file, part of UMLisp, is
-;;;; Copyright (c) 2000-2002 by Kevin M. Rosenberg, M.D.
+;;;; Copyright (c) 2000-2003 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 (compilation-speed 0) (debug 3)))
+(in-package #:umlisp)
(defvar *current-srl* nil)
(ensure-cui-integer cui)
(ensure-lui-integer lui)
(ensure-sui-integer sui)
- (let ((ls (format nil "select CODE,ATN,SAB,ATV from MRSAT where ")))
+ (let ((ls "select CODE,ATN,SAB,ATV from MRSAT where "))
(cond
- (sui (string-append ls (format nil "KCUISUI=~D" (make-cuisui cui sui))))
- (lui (string-append ls (format nil "KCUILUI=~D and sui=0"
- (make-cuilui cui lui))))
- (t (string-append ls (format nil "cui=~D and lui=0 and sui=0" cui))))
+ (sui (string-append ls "KCUISUI="
+ (integer-string (make-cuisui cui sui) 14)))
+ (lui (string-append ls "KCUILUI="
+ (integer-string (make-cuilui cui lui) 14)
+ " and sui=0"))
+ (t (string-append ls "cui=" (prefixed-fixnum-string cui nil 7)
+ " and lui=0 and sui=0")))
(when srl
- (string-append ls (format nil " and KSRL <= ~D" srl)))
+ (string-append ls " and KSRL<=" (prefixed-fixnum-string srl nil 3)))
(loop for tuple in (mutex-sql-query ls) collect
(destructuring-bind (code atn sab atv) tuple
(make-instance 'usat :code code :atn atn :sab sab :atv atv)))))
:order (cui asc sui asc))
(find-ustr-cuisui (ensure-integer cui) (ensure-integer sui) :srl srl)))
+(defun find-uterm-word (word &key (srl *current-srl*))
+ "Return list of uterms that match word"
+ (collect-umlisp-query (mrxw_eng (cui sui) srl wd word :lrl klrl
+ :order (cui asc sui asc))
+ (find-uterm-cuisui (ensure-integer cui) (ensure-integer sui) :srl srl)))
+
+(defun find-uterm-normalized-word (word &key (srl *current-srl*))
+ "Return list of uterms that match word"
+ (collect-umlisp-query (mrxnw_eng (cui sui) srl nwd word :lrl klrl
+ :order (cui asc sui asc))
+ (find-uterm-cuisui (ensure-integer cui) (ensure-integer sui) :srl srl)))
+
(defun find-ucon-noneng-word (word &key (srl *current-srl*) (like nil))
"Return list of ucons that match non-english word"
(collect-umlisp-query-eval ('mrxw_noneng '(cui) srl 'wd word :like like