X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=sql-classes.lisp;h=48e7d54a538e66bea2290c61e8d4ae76037bbd92;hb=5be6bdf06e0c99612a4c1a1d6f110e424400d96e;hp=6ef05ed1dadc5f0a0008ae0b33f7b2b7daa8d9b3;hpb=f4ba2f539190a686523f1ba439fce1073b02e54d;p=umlisp.git

diff --git a/sql-classes.lisp b/sql-classes.lisp
index 6ef05ed..48e7d54 100644
--- a/sql-classes.lisp
+++ b/sql-classes.lisp
@@ -510,12 +510,12 @@ is OBJNAME from TABLE where WHERE-NAME field = WHERE-VALUE with FIELDS"
 
 (defun find-usab-all ()
   "Find usab for a key"
-  (collect-umlisp-query (mrsab (vcui rcui vsab rsab son sf sver mstart mend imeta
+  (collect-umlisp-query (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 nil nil)
     (make-instance 'usab :vcui (ensure-integer vcui) 
 		   :rcui (ensure-integer rcui) :vsab vsab :rsab rsab :son son
-		   :sf sf :sver sver :mstart mstart :mend mend :imeta imeta
+		   :sf sf :sver sver :vstart vstart :vend vend :imeta imeta
 		   :rmeta rmeta :slc slc :scc scc  :srl (ensure-integer srl)
 		   :tfr (ensure-integer tfr) :cfr (ensure-integer cfr)
 		   :cxty cxty :ttyl ttyl :atnl atnl :lat lat :cenc cenc
@@ -523,13 +523,13 @@ 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 mstart
-				    mend imeta rmeta slc scc srl tfr cfr cxty
+  (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) 
 		   :rcui (ensure-integer rcui) :vsab vsab :rsab rsab :son son
-		   :sf sf :sver sver :mstart mstart :mend mend :imeta imeta
+		   :sf sf :sver sver :vstart vstart :vend vend :imeta imeta
 		   :rmeta rmeta :slc slc :scc scc :srl (ensure-integer srl)
 		   :tfr (ensure-integer tfr) :cfr (ensure-integer cfr)
 		   :cxty cxty :ttyl ttyl :atnl atnl :lat lat :cenc cenc
@@ -790,7 +790,7 @@ is OBJNAME from TABLE where WHERE-NAME field = WHERE-VALUE with FIELDS"
 
 (defun make-ustats ()
   (with-sql-connection (conn)
-    (sql-execute "drop table if exists USTATS" conn)
+    (ignore-errors (sql-execute "drop table USTATS" conn))
     (sql-execute "create table USTATS (NAME varchar(160), COUNT bigint, SRL integer)" conn)
     
     (dotimes (srl 4)
@@ -844,11 +844,18 @@ is OBJNAME from TABLE where WHERE-NAME field = WHERE-VALUE with FIELDS"
 	       conn))
 
 (defun find-ustats-all (&key (srl *current-srl*))
-  (collect-umlisp-query (ustats (name count srl) nil srl srl
-				   :order (name asc))
-   (make-instance 'ustats :name name :hits (ensure-integer count)
-		  :srl (ensure-integer srl))))
-
+  (if srl
+      (collect-umlisp-query (ustats (name count srl) nil srl srl
+				    :order (name asc))
+			    (make-instance 'ustats :name name
+					   :hits (ensure-integer count)
+					   :srl (ensure-integer srl)))
+    (collect-umlisp-query (ustats (name count srl) nil nil nil
+				  :order (name asc))
+			  (make-instance 'ustats :name name
+					 :hits (ensure-integer count)
+					 :srl (ensure-integer srl)))))
+  
 (defun find-ustats-srl (srl)
   (collect-umlisp-query (ustats (name count) nil srl srl :order (name asc))
 			   (make-instance 'ustats :name name :hits (ensure-integer count))))