X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;ds=sidebyside;f=sql-classes.lisp;h=e70c638d3a485963e4abe5875219b15751ccb811;hb=0f5f4f56ab77890ac68b8fb34a2edcca4962e152;hp=2b7869cb3438a2bcae33eab850b628a532276b15;hpb=fab71e6fecf552789593d979b85cea58099f236d;p=umlisp.git diff --git a/sql-classes.lisp b/sql-classes.lisp index 2b7869c..e70c638 100644 --- a/sql-classes.lisp +++ b/sql-classes.lisp @@ -583,10 +583,10 @@ is OBJNAME from TABLE where WHERE-NAME field = WHERE-VALUE with FIELDS" (defun find-usab-by-key (key-name key) "Find usab for a key" (collect-umlisp-query-eval ('mrsab '(vcui rcui vsab rsab son sf sver vstart - vend imeta rmeta slc scc srl tfr cfr cxty - ttyl atnl lat cenc curver sabin) - nil key-name key :single t) - (make-instance 'usab :vcui (ensure-integer vcui) + vend imeta rmeta slc scc srl tfr cfr cxty + ttyl atnl lat cenc curver sabin) + nil key-name key :single t) + (make-instance 'usab :vcui (ensure-integer vcui) :rcui (ensure-integer rcui) :vsab vsab :rsab rsab :son son :sf sf :sver sver :vstart vstart :vend vend :imeta imeta :rmeta rmeta :slc slc :scc scc :srl (ensure-integer srl) @@ -866,7 +866,7 @@ is OBJNAME from TABLE where WHERE-NAME field = WHERE-VALUE with FIELDS" (ignore-errors (sql-execute "drop table USTATS" conn)) (sql-execute "create table USTATS (NAME varchar(160), COUNT bigint, SRL integer)" conn) - (dotimes (srl 4) + (dotimes (srl 5) (insert-ustats-count conn "Concept Count" "MRCONSO" "distinct CUI" "KCUILRL" srl) (insert-ustats-count conn "Term Count" "MRCONSO" "distinct KCUILUI" "KCUILRL" srl) (insert-ustats-count conn "Distinct Term Count" "MRCONSO" "distinct LUI" "KLUILRL" srl)