X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=tests%2Fbasic.lisp;fp=tests%2Fbasic.lisp;h=721b098b41e72a839f691ce011f4d5331e6b0411;hb=310050ec8360dd9f69d205ff3ff541e0fc59c7e1;hp=c74e05ca9ac8dce27d0e8c6b54c410d994233e7e;hpb=9e472725307c8f98e1590814b0cb77c62cf5dc14;p=umlisp.git diff --git a/tests/basic.lisp b/tests/basic.lisp index c74e05c..721b098 100644 --- a/tests/basic.lisp +++ b/tests/basic.lisp @@ -20,56 +20,56 @@ (setq *rt-basic* '( - (deftest :qrystr/1 (umlisp::query-string mrcon (cui lui)) - "SELECT CUI,LUI FROM MRCON") - - (deftest :qrystr/1e (umlisp::query-string-eval 'mrcon '(cui lui)) - "SELECT CUI,LUI FROM MRCON") - - (deftest :qrystr/2 (umlisp::query-string mrcon (cui lui) 0) - "SELECT CUI,LUI FROM MRCON AND KCUILRL<=0") - - (deftest :qrystr/2e (umlisp::query-string-eval 'mrcon '(cui lui) 0) - "SELECT CUI,LUI FROM MRCON AND KCUILRL<=0") - - (deftest :qrystr/3 (umlisp::query-string mrcon (cui lui) nil cui 5) - "SELECT CUI,LUI FROM MRCON WHERE CUI='5'") - - (deftest :qrystr/3e (umlisp::query-string-eval 'mrcon '(cui lui) nil 'cui 5) - "SELECT CUI,LUI FROM MRCON WHERE CUI='5'") - - (deftest :qrystr/4 (umlisp::query-string mrcon (cui lui) nil kpfstr "Abc") - "SELECT CUI,LUI FROM MRCON WHERE KPFSTR='Abc'") - - (deftest :qrystr/4e (umlisp::query-string-eval 'mrcon '(cui lui) nil 'kpfstr "Abc") - "SELECT CUI,LUI FROM MRCON WHERE KPFSTR='Abc'") - - (deftest :qrystr/5 (umlisp::query-string mrcon (cui lui) 2 cui 5 :single t) - "SELECT CUI,LUI FROM MRCON WHERE CUI='5' AND KCUILRL<=2 LIMIT 1") - - (deftest :qrystr/5e (umlisp::query-string-eval 'mrcon '(cui lui) 2 'cui 5 :single t) - "SELECT CUI,LUI FROM MRCON WHERE CUI='5' AND KCUILRL<=2 LIMIT 1") - + (deftest :qrystr/1 (umlisp::query-string mrconso (cui lui) nil nil nil) + "SELECT CUI,LUI FROM MRCONSO") + + (deftest :qrystr/1e (umlisp::query-string-eval 'mrconso '(cui lui) nil nil nil) + "SELECT CUI,LUI FROM MRCONSO") + + (deftest :qrystr/2 (umlisp::query-string mrconso (cui lui) 0 nil nil) + "SELECT CUI,LUI FROM MRCONSO AND KCUILRL<=0") + + (deftest :qrystr/2e (umlisp::query-string-eval 'mrconso '(cui lui) 0 nil nil) + "SELECT CUI,LUI FROM MRCONSO AND KCUILRL<=0") + + (deftest :qrystr/3 (umlisp::query-string mrconso (cui lui) nil cui 5) + "SELECT CUI,LUI FROM MRCONSO WHERE CUI='5'") + + (deftest :qrystr/3e (umlisp::query-string-eval 'mrconso '(cui lui) nil 'cui 5) + "SELECT CUI,LUI FROM MRCONSO WHERE CUI='5'") + + (deftest :qrystr/4 (umlisp::query-string mrconso (cui lui) nil kpfstr "Abc") + "SELECT CUI,LUI FROM MRCONSO WHERE KPFSTR='Abc'") + + (deftest :qrystr/4e (umlisp::query-string-eval 'mrconso '(cui lui) nil 'kpfstr "Abc") + "SELECT CUI,LUI FROM MRCONSO WHERE KPFSTR='Abc'") + + (deftest :qrystr/5 (umlisp::query-string mrconso (cui lui) 2 cui 5 :single t) + "SELECT CUI,LUI FROM MRCONSO WHERE CUI='5' AND KCUILRL<=2 LIMIT 1") + + (deftest :qrystr/5e (umlisp::query-string-eval 'mrconso '(cui lui) 2 'cui 5 :single t) + "SELECT CUI,LUI FROM MRCONSO WHERE CUI='5' AND KCUILRL<=2 LIMIT 1") + (deftest :qrystr/6 (umlisp::query-string mrdef (sab def) 2 cui 39 :lrl ksrl :single t) "SELECT SAB,DEF FROM MRDEF WHERE CUI='39' AND KSRL<=2 LIMIT 1") - + (deftest :qrystr/6e (umlisp::query-string-eval 'mrdef '(sab def) 2 'cui 39 :lrl 'ksrl :single t) "SELECT SAB,DEF FROM MRDEF WHERE CUI='39' AND KSRL<=2 LIMIT 1") - + (deftest :qrystr/7 (umlisp::query-string mrdef (sab def) 2 cui 39 :lrl ksrl :order (cui asc)) "SELECT SAB,DEF FROM MRDEF WHERE CUI='39' AND KSRL<=2 ORDER BY CUI asc") - + (deftest :qrystr/7e (umlisp::query-string-eval 'mrdef '(sab def) 2 'cui 39 :lrl 'ksrl :order '(cui asc)) "SELECT SAB,DEF FROM MRDEF WHERE CUI='39' AND KSRL<=2 ORDER BY CUI asc") - + (deftest :qrystr/8 (umlisp::query-string mrdef (sab def) 2 cui 39 :lrl ksrl :order (cui asc def desc)) "SELECT SAB,DEF FROM MRDEF WHERE CUI='39' AND KSRL<=2 ORDER BY CUI asc,DEF desc") - + (deftest :qrystr/8e (umlisp::query-string-eval 'mrdef '(sab def) 2 'cui 39 :lrl 'ksrl - :order '(cui asc def desc)) + :order '(cui asc def desc)) "SELECT SAB,DEF FROM MRDEF WHERE CUI='39' AND KSRL<=2 ORDER BY CUI asc,DEF desc") - + (deftest :ui/1 (umlisp::parse-cui "C0002341") 2341) (deftest :ui/2 (umlisp::parse-lui "L0002341") 2341) (deftest :ui/3 (umlisp::parse-sui "S0000000") 0) @@ -85,5 +85,5 @@ (deftest :ui/13 (umlisp::parse-eui "E00002311") 2311) (deftest :ui/14 (umlisp::parse-lui "1234") 1234) (deftest :ui/15 (umlisp::parse-lui 1234) 1234) - + ))