0000: 28 75 73 65 20 73 71 6c 69 74 65 33 20 73 72 66 (use sqlite3 srf
0010: 69 2d 31 20 70 6f 73 69 78 20 72 65 67 65 78 20 i-1 posix regex
0020: 72 65 67 65 78 2d 63 61 73 65 20 73 72 66 69 2d regex-case srfi-
0030: 36 39 20 64 6f 74 2d 6c 6f 63 6b 69 6e 67 20 74 69 dot-locking t
0040: 63 70 20 72 70 63 29 0a 28 69 6d 70 6f 72 74 20 cp rpc).(import
0050: 28 70 72 65 66 69 78 20 73 71 6c 69 74 65 33 20 (prefix sqlite3
0060: 73 71 6c 69 74 65 33 3a 29 29 0a 28 69 6d 70 6f sqlite3:)).(impo
0070: 72 74 20 28 70 72 65 66 69 78 20 72 70 63 20 72 rt (prefix rpc r
0080: 70 63 3a 29 29 0a 0a 28 64 65 63 6c 61 72 65 20 pc:))..(declare
0090: 28 75 6e 69 74 20 74 65 73 74 73 29 29 0a 28 64 (unit tests)).(d
00a0: 65 63 6c 61 72 65 20 28 75 73 65 73 20 64 62 29 eclare (uses db)
00b0: 29 0a 28 64 65 63 6c 61 72 65 20 28 75 73 65 73 ).(declare (uses
00c0: 20 63 6f 6d 6d 6f 6e 29 29 0a 28 64 65 63 6c 61 common)).(decla
00d0: 72 65 20 28 75 73 65 73 20 69 74 65 6d 73 29 29 re (uses items))
00e0: 0a 28 64 65 63 6c 61 72 65 20 28 75 73 65 73 20 .(declare (uses
00f0: 72 75 6e 63 6f 6e 66 69 67 29 29 0a 0a 28 69 6e runconfig))..(in
0100: 63 6c 75 64 65 20 22 63 6f 6d 6d 6f 6e 5f 72 65 clude "common_re
0110: 63 6f 72 64 73 2e 73 63 6d 22 29 0a 28 69 6e 63 cords.scm").(inc
0120: 6c 75 64 65 20 22 6b 65 79 5f 72 65 63 6f 72 64 lude "key_record
0130: 73 2e 73 63 6d 22 29 0a 28 69 6e 63 6c 75 64 65 s.scm").(include
0140: 20 22 64 62 5f 72 65 63 6f 72 64 73 2e 73 63 6d "db_records.scm
0150: 22 29 0a 28 69 6e 63 6c 75 64 65 20 22 72 75 6e ").(include "run
0160: 5f 72 65 63 6f 72 64 73 2e 73 63 6d 22 29 0a 28 _records.scm").(
0170: 69 6e 63 6c 75 64 65 20 22 74 65 73 74 5f 72 65 include "test_re
0180: 63 6f 72 64 73 2e 73 63 6d 22 29 0a 0a 28 64 65 cords.scm")..(de
0190: 66 69 6e 65 20 28 74 65 73 74 73 3a 72 65 67 69 fine (tests:regi
01a0: 73 74 65 72 2d 74 65 73 74 20 64 62 20 72 75 6e ster-test db run
01b0: 2d 69 64 20 74 65 73 74 2d 6e 61 6d 65 20 69 74 -id test-name it
01c0: 65 6d 2d 70 61 74 68 29 0a 20 20 28 6c 65 74 20 em-path). (let
01d0: 28 28 69 74 65 6d 2d 70 61 74 68 73 20 28 69 66 ((item-paths (if
01e0: 20 28 65 71 75 61 6c 3f 20 69 74 65 6d 2d 70 61 (equal? item-pa
01f0: 74 68 20 22 22 29 0a 09 09 09 28 6c 69 73 74 20 th "")....(list
0200: 69 74 65 6d 2d 70 61 74 68 29 0a 09 09 09 28 6c item-path)....(l
0210: 69 73 74 20 69 74 65 6d 2d 70 61 74 68 20 22 22 ist item-path ""
0220: 29 29 29 29 0a 20 20 20 20 28 66 6f 72 2d 65 61 )))). (for-ea
0230: 63 68 20 0a 20 20 20 20 20 28 6c 61 6d 62 64 61 ch . (lambda
0240: 20 28 70 74 68 29 0a 20 20 20 20 20 20 20 28 73 (pth). (s
0250: 71 6c 69 74 65 33 3a 65 78 65 63 75 74 65 20 64 qlite3:execute d
0260: 62 20 22 49 4e 53 45 52 54 20 4f 52 20 49 47 4e b "INSERT OR IGN
0270: 4f 52 45 20 49 4e 54 4f 20 74 65 73 74 73 20 28 ORE INTO tests (
0280: 72 75 6e 5f 69 64 2c 74 65 73 74 6e 61 6d 65 2c run_id,testname,
0290: 65 76 65 6e 74 5f 74 69 6d 65 2c 69 74 65 6d 5f event_time,item_
02a0: 70 61 74 68 2c 73 74 61 74 65 2c 73 74 61 74 75 path,state,statu
02b0: 73 29 20 56 41 4c 55 45 53 20 28 3f 2c 3f 2c 73 s) VALUES (?,?,s
02c0: 74 72 66 74 69 6d 65 28 27 25 73 27 2c 27 6e 6f trftime('%s','no
02d0: 77 27 29 2c 3f 2c 27 4e 4f 54 5f 53 54 41 52 54 w'),?,'NOT_START
02e0: 45 44 27 2c 27 6e 2f 61 27 29 3b 22 20 0a 09 09 ED','n/a');" ...
02f0: 09 72 75 6e 2d 69 64 20 0a 09 09 09 74 65 73 74 .run-id ....test
0300: 2d 6e 61 6d 65 0a 09 09 09 70 74 68 29 29 0a 20 -name....pth)).
0310: 20 20 20 20 69 74 65 6d 2d 70 61 74 68 73 20 29 item-paths )
0320: 29 29 0a 0a 3b 3b 20 67 65 74 20 74 68 65 20 70 ))..;; get the p
0330: 72 65 76 69 6f 75 73 20 72 65 63 6f 72 64 20 66 revious record f
0340: 6f 72 20 77 68 65 6e 20 74 68 69 73 20 74 65 73 or when this tes
0350: 74 20 77 61 73 20 72 75 6e 20 77 68 65 72 65 20 t was run where
0360: 61 6c 6c 20 6b 65 79 73 20 6d 61 74 63 68 20 62 all keys match b
0370: 75 74 20 72 75 6e 6e 61 6d 65 0a 3b 3b 20 72 65 ut runname.;; re
0380: 74 75 72 6e 73 20 23 66 20 69 66 20 6e 6f 20 73 turns #f if no s
0390: 75 63 68 20 74 65 73 74 20 66 6f 75 6e 64 2c 20 uch test found,
03a0: 72 65 74 75 72 6e 73 20 61 20 73 69 6e 67 6c 65 returns a single
03b0: 20 74 65 73 74 20 72 65 63 6f 72 64 20 69 66 20 test record if
03c0: 66 6f 75 6e 64 0a 28 64 65 66 69 6e 65 20 28 74 found.(define (t
03d0: 65 73 74 3a 67 65 74 2d 70 72 65 76 69 6f 75 73 est:get-previous
03e0: 2d 74 65 73 74 2d 72 75 6e 2d 72 65 63 6f 72 64 -test-run-record
03f0: 20 64 62 20 72 75 6e 2d 69 64 20 74 65 73 74 2d db run-id test-
0400: 6e 61 6d 65 20 69 74 65 6d 2d 70 61 74 68 29 0a name item-path).
0410: 20 20 28 6c 65 74 2a 20 28 28 6b 65 79 73 20 20 (let* ((keys
0420: 20 20 28 64 62 3a 67 65 74 2d 6b 65 79 73 20 64 (db:get-keys d
0430: 62 29 29 0a 09 20 28 73 65 6c 73 74 72 20 20 28 b)).. (selstr (
0440: 73 74 72 69 6e 67 2d 69 6e 74 65 72 73 70 65 72 string-intersper
0450: 73 65 20 28 6d 61 70 20 28 6c 61 6d 62 64 61 20 se (map (lambda
0460: 28 78 29 28 76 65 63 74 6f 72 2d 72 65 66 20 78 (x)(vector-ref x
0470: 20 30 29 29 20 6b 65 79 73 29 20 22 2c 22 29 29 0)) keys) ","))
0480: 0a 09 20 28 71 72 79 73 74 72 20 20 28 73 74 72 .. (qrystr (str
0490: 69 6e 67 2d 69 6e 74 65 72 73 70 65 72 73 65 20 ing-intersperse
04a0: 28 6d 61 70 20 28 6c 61 6d 62 64 61 20 28 78 29 (map (lambda (x)
04b0: 28 63 6f 6e 63 20 28 76 65 63 74 6f 72 2d 72 65 (conc (vector-re
04c0: 66 20 78 20 30 29 20 22 3d 3f 22 29 29 20 6b 65 f x 0) "=?")) ke
04d0: 79 73 29 20 22 20 41 4e 44 20 22 29 29 0a 09 20 ys) " AND "))..
04e0: 28 6b 65 79 76 61 6c 73 20 23 66 29 29 0a 20 20 (keyvals #f)).
04f0: 20 20 3b 3b 20 66 69 72 73 74 20 6c 6f 6f 6b 20 ;; first look
0500: 75 70 20 74 68 65 20 6b 65 79 20 76 61 6c 75 65 up the key value
0510: 73 20 66 72 6f 6d 20 74 68 65 20 72 75 6e 20 73 s from the run s
0520: 65 6c 65 63 74 65 64 20 62 79 20 72 75 6e 2d 69 elected by run-i
0530: 64 0a 20 20 20 20 28 73 71 6c 69 74 65 33 3a 66 d. (sqlite3:f
0540: 6f 72 2d 65 61 63 68 2d 72 6f 77 20 0a 20 20 20 or-each-row .
0550: 20 20 28 6c 61 6d 62 64 61 20 28 61 20 2e 20 62 (lambda (a . b
0560: 29 0a 20 20 20 20 20 20 20 28 73 65 74 21 20 6b ). (set! k
0570: 65 79 76 61 6c 73 20 28 63 6f 6e 73 20 61 20 62 eyvals (cons a b
0580: 29 29 29 0a 20 20 20 20 20 64 62 0a 20 20 20 20 ))). db.
0590: 20 28 63 6f 6e 63 20 22 53 45 4c 45 43 54 20 22 (conc "SELECT "
05a0: 20 73 65 6c 73 74 72 20 22 20 46 52 4f 4d 20 72 selstr " FROM r
05b0: 75 6e 73 20 57 48 45 52 45 20 69 64 3d 3f 20 4f uns WHERE id=? O
05c0: 52 44 45 52 20 42 59 20 65 76 65 6e 74 5f 74 69 RDER BY event_ti
05d0: 6d 65 20 44 45 53 43 3b 22 29 20 72 75 6e 2d 69 me DESC;") run-i
05e0: 64 29 0a 20 20 20 20 28 69 66 20 28 6e 6f 74 20 d). (if (not
05f0: 6b 65 79 76 61 6c 73 29 0a 09 23 66 0a 09 28 6c keyvals)..#f..(l
0600: 65 74 20 28 28 70 72 65 76 2d 72 75 6e 2d 69 64 et ((prev-run-id
0610: 73 20 27 28 29 29 29 0a 09 20 20 28 61 70 70 6c s '())).. (appl
0620: 79 20 73 71 6c 69 74 65 33 3a 66 6f 72 2d 65 61 y sqlite3:for-ea
0630: 63 68 2d 72 6f 77 0a 09 09 20 28 6c 61 6d 62 64 ch-row... (lambd
0640: 61 20 28 69 64 29 0a 09 09 20 20 20 28 73 65 74 a (id)... (set
0650: 21 20 70 72 65 76 2d 72 75 6e 2d 69 64 73 20 28 ! prev-run-ids (
0660: 63 6f 6e 73 20 69 64 20 70 72 65 76 2d 72 75 6e cons id prev-run
0670: 2d 69 64 73 29 29 29 0a 09 09 20 64 62 0a 09 09 -ids)))... db...
0680: 20 28 63 6f 6e 63 20 22 53 45 4c 45 43 54 20 69 (conc "SELECT i
0690: 64 20 46 52 4f 4d 20 72 75 6e 73 20 57 48 45 52 d FROM runs WHER
06a0: 45 20 22 20 71 72 79 73 74 72 20 22 20 41 4e 44 E " qrystr " AND
06b0: 20 69 64 20 21 3d 20 3f 3b 22 29 20 28 61 70 70 id != ?;") (app
06c0: 65 6e 64 20 6b 65 79 76 61 6c 73 20 28 6c 69 73 end keyvals (lis
06d0: 74 20 72 75 6e 2d 69 64 29 29 29 0a 09 20 20 3b t run-id))).. ;
06e0: 3b 20 66 6f 72 20 65 61 63 68 20 72 75 6e 20 73 ; for each run s
06f0: 74 61 72 74 69 6e 67 20 77 69 74 68 20 74 68 65 tarting with the
0700: 20 6d 6f 73 74 20 72 65 63 65 6e 74 20 6c 6f 6f most recent loo
0710: 6b 20 74 6f 20 73 65 65 20 69 66 20 74 68 65 72 k to see if ther
0720: 65 20 69 73 20 61 20 6d 61 74 63 68 69 6e 67 20 e is a matching
0730: 74 65 73 74 0a 09 20 20 3b 3b 20 69 66 20 66 6f test.. ;; if fo
0740: 75 6e 64 20 74 68 65 6e 20 72 65 74 75 72 6e 20 und then return
0750: 74 68 61 74 20 6d 61 74 63 68 69 6e 67 20 74 65 that matching te
0760: 73 74 20 72 65 63 6f 72 64 0a 09 20 20 28 64 65 st record.. (de
0770: 62 75 67 3a 70 72 69 6e 74 20 34 20 22 73 65 6c bug:print 4 "sel
0780: 73 74 72 3a 20 22 20 73 65 6c 73 74 72 20 22 2c str: " selstr ",
0790: 20 71 72 79 73 74 72 3a 20 22 20 71 72 79 73 74 qrystr: " qryst
07a0: 72 20 22 2c 20 6b 65 79 76 61 6c 73 3a 20 22 20 r ", keyvals: "
07b0: 6b 65 79 76 61 6c 73 20 22 2c 20 70 72 65 76 69 keyvals ", previ
07c0: 6f 75 73 20 72 75 6e 20 69 64 73 20 66 6f 75 6e ous run ids foun
07d0: 64 3a 20 22 20 70 72 65 76 2d 72 75 6e 2d 69 64 d: " prev-run-id
07e0: 73 29 0a 09 20 20 28 69 66 20 28 6e 75 6c 6c 3f s).. (if (null?
07f0: 20 70 72 65 76 2d 72 75 6e 2d 69 64 73 29 20 23 prev-run-ids) #
0800: 66 0a 09 20 20 20 20 20 20 28 6c 65 74 20 6c 6f f.. (let lo
0810: 6f 70 20 28 28 68 65 64 20 28 63 61 72 20 70 72 op ((hed (car pr
0820: 65 76 2d 72 75 6e 2d 69 64 73 29 29 0a 09 09 09 ev-run-ids))....
0830: 20 28 74 61 6c 20 28 63 64 72 20 70 72 65 76 2d (tal (cdr prev-
0840: 72 75 6e 2d 69 64 73 29 29 29 0a 09 09 28 6c 65 run-ids)))...(le
0850: 74 20 28 28 72 65 73 75 6c 74 73 20 28 72 64 62 t ((results (rdb
0860: 3a 67 65 74 2d 74 65 73 74 73 2d 66 6f 72 2d 72 :get-tests-for-r
0870: 75 6e 20 64 62 20 68 65 64 20 74 65 73 74 2d 6e un db hed test-n
0880: 61 6d 65 20 69 74 65 6d 2d 70 61 74 68 20 27 28 ame item-path '(
0890: 29 20 27 28 29 29 29 29 0a 09 09 20 20 28 64 65 ) '())))... (de
08a0: 62 75 67 3a 70 72 69 6e 74 20 34 20 22 47 6f 74 bug:print 4 "Got
08b0: 20 74 65 73 74 73 20 66 6f 72 20 72 75 6e 2d 69 tests for run-i
08c0: 64 20 22 20 72 75 6e 2d 69 64 20 22 2c 20 74 65 d " run-id ", te
08d0: 73 74 2d 6e 61 6d 65 20 22 20 74 65 73 74 2d 6e st-name " test-n
08e0: 61 6d 65 20 22 2c 20 69 74 65 6d 2d 70 61 74 68 ame ", item-path
08f0: 20 22 20 69 74 65 6d 2d 70 61 74 68 20 22 3a 20 " item-path ":
0900: 22 20 72 65 73 75 6c 74 73 29 0a 09 09 20 20 28 " results)... (
0910: 69 66 20 28 61 6e 64 20 28 6e 75 6c 6c 3f 20 72 if (and (null? r
0920: 65 73 75 6c 74 73 29 0a 09 09 09 20 20 20 28 6e esults).... (n
0930: 6f 74 20 28 6e 75 6c 6c 3f 20 74 61 6c 29 29 29 ot (null? tal)))
0940: 0a 09 09 20 20 20 20 20 20 28 6c 6f 6f 70 20 28 ... (loop (
0950: 63 61 72 20 74 61 6c 29 28 63 64 72 20 74 61 6c car tal)(cdr tal
0960: 29 29 0a 09 09 20 20 20 20 20 20 28 69 66 20 28 ))... (if (
0970: 6e 75 6c 6c 3f 20 72 65 73 75 6c 74 73 29 20 23 null? results) #
0980: 66 0a 09 09 09 20 20 28 63 61 72 20 72 65 73 75 f.... (car resu
0990: 6c 74 73 29 29 29 29 29 29 29 29 29 29 0a 20 20 lts)))))))))).
09a0: 20 20 0a 3b 3b 20 67 65 74 20 74 68 65 20 70 72 .;; get the pr
09b0: 65 76 69 6f 75 73 20 72 65 63 6f 72 64 73 20 66 evious records f
09c0: 6f 72 20 77 68 65 6e 20 74 68 65 73 65 20 74 65 or when these te
09d0: 73 74 73 20 77 65 72 65 20 72 75 6e 20 77 68 65 sts were run whe
09e0: 72 65 20 61 6c 6c 20 6b 65 79 73 20 6d 61 74 63 re all keys matc
09f0: 68 20 62 75 74 20 72 75 6e 6e 61 6d 65 0a 3b 3b h but runname.;;
0a00: 20 4e 42 2f 2f 20 4d 65 72 67 65 20 74 68 69 73 NB// Merge this
0a10: 20 77 69 74 68 20 74 65 73 74 3a 67 65 74 2d 70 with test:get-p
0a20: 72 65 76 69 6f 75 73 2d 74 65 73 74 2d 72 75 6e revious-test-run
0a30: 2d 72 65 63 6f 72 64 73 3f 20 54 68 69 73 20 6f -records? This o
0a40: 6e 65 20 6c 6f 6f 6b 73 20 66 6f 72 20 61 6c 6c ne looks for all
0a50: 20 6d 61 74 63 68 69 6e 67 20 74 65 73 74 73 0a matching tests.
0a60: 3b 3b 20 63 61 6e 20 75 73 65 20 77 69 6c 64 63 ;; can use wildc
0a70: 61 72 64 73 2e 20 0a 28 64 65 66 69 6e 65 20 28 ards. .(define (
0a80: 74 65 73 74 3a 67 65 74 2d 6d 61 74 63 68 69 6e test:get-matchin
0a90: 67 2d 70 72 65 76 69 6f 75 73 2d 74 65 73 74 2d g-previous-test-
0aa0: 72 75 6e 2d 72 65 63 6f 72 64 73 20 64 62 20 72 run-records db r
0ab0: 75 6e 2d 69 64 20 74 65 73 74 2d 6e 61 6d 65 20 un-id test-name
0ac0: 69 74 65 6d 2d 70 61 74 68 29 0a 20 20 28 6c 65 item-path). (le
0ad0: 74 2a 20 28 28 6b 65 79 73 20 20 20 20 28 64 62 t* ((keys (db
0ae0: 3a 67 65 74 2d 6b 65 79 73 20 64 62 29 29 0a 09 :get-keys db))..
0af0: 20 28 73 65 6c 73 74 72 20 20 28 73 74 72 69 6e (selstr (strin
0b00: 67 2d 69 6e 74 65 72 73 70 65 72 73 65 20 28 6d g-intersperse (m
0b10: 61 70 20 28 6c 61 6d 62 64 61 20 28 78 29 28 76 ap (lambda (x)(v
0b20: 65 63 74 6f 72 2d 72 65 66 20 78 20 30 29 29 20 ector-ref x 0))
0b30: 6b 65 79 73 29 20 22 2c 22 29 29 0a 09 20 28 71 keys) ",")).. (q
0b40: 72 79 73 74 72 20 20 28 73 74 72 69 6e 67 2d 69 rystr (string-i
0b50: 6e 74 65 72 73 70 65 72 73 65 20 28 6d 61 70 20 ntersperse (map
0b60: 28 6c 61 6d 62 64 61 20 28 78 29 28 63 6f 6e 63 (lambda (x)(conc
0b70: 20 28 76 65 63 74 6f 72 2d 72 65 66 20 78 20 30 (vector-ref x 0
0b80: 29 20 22 3d 3f 22 29 29 20 6b 65 79 73 29 20 22 ) "=?")) keys) "
0b90: 20 41 4e 44 20 22 29 29 0a 09 20 28 6b 65 79 76 AND ")).. (keyv
0ba0: 61 6c 73 20 23 66 29 0a 09 20 28 74 65 73 74 73 als #f).. (tests
0bb0: 2d 68 61 73 68 20 28 6d 61 6b 65 2d 68 61 73 68 -hash (make-hash
0bc0: 2d 74 61 62 6c 65 29 29 29 0a 20 20 20 20 3b 3b -table))). ;;
0bd0: 20 66 69 72 73 74 20 6c 6f 6f 6b 20 75 70 20 74 first look up t
0be0: 68 65 20 6b 65 79 20 76 61 6c 75 65 73 20 66 72 he key values fr
0bf0: 6f 6d 20 74 68 65 20 72 75 6e 20 73 65 6c 65 63 om the run selec
0c00: 74 65 64 20 62 79 20 72 75 6e 2d 69 64 0a 20 20 ted by run-id.
0c10: 20 20 28 73 71 6c 69 74 65 33 3a 66 6f 72 2d 65 (sqlite3:for-e
0c20: 61 63 68 2d 72 6f 77 20 0a 20 20 20 20 20 28 6c ach-row . (l
0c30: 61 6d 62 64 61 20 28 61 20 2e 20 62 29 0a 20 20 ambda (a . b).
0c40: 20 20 20 20 20 28 73 65 74 21 20 6b 65 79 76 61 (set! keyva
0c50: 6c 73 20 28 63 6f 6e 73 20 61 20 62 29 29 29 0a ls (cons a b))).
0c60: 20 20 20 20 20 64 62 0a 20 20 20 20 20 28 63 6f db. (co
0c70: 6e 63 20 22 53 45 4c 45 43 54 20 22 20 73 65 6c nc "SELECT " sel
0c80: 73 74 72 20 22 20 46 52 4f 4d 20 72 75 6e 73 20 str " FROM runs
0c90: 57 48 45 52 45 20 69 64 3d 3f 20 4f 52 44 45 52 WHERE id=? ORDER
0ca0: 20 42 59 20 65 76 65 6e 74 5f 74 69 6d 65 20 44 BY event_time D
0cb0: 45 53 43 3b 22 29 20 72 75 6e 2d 69 64 29 0a 20 ESC;") run-id).
0cc0: 20 20 20 28 69 66 20 28 6e 6f 74 20 6b 65 79 76 (if (not keyv
0cd0: 61 6c 73 29 0a 09 27 28 29 0a 09 28 6c 65 74 20 als)..'()..(let
0ce0: 28 28 70 72 65 76 2d 72 75 6e 2d 69 64 73 20 27 ((prev-run-ids '
0cf0: 28 29 29 29 0a 09 20 20 28 61 70 70 6c 79 20 73 ())).. (apply s
0d00: 71 6c 69 74 65 33 3a 66 6f 72 2d 65 61 63 68 2d qlite3:for-each-
0d10: 72 6f 77 0a 09 09 20 28 6c 61 6d 62 64 61 20 28 row... (lambda (
0d20: 69 64 29 0a 09 09 20 20 20 28 73 65 74 21 20 70 id)... (set! p
0d30: 72 65 76 2d 72 75 6e 2d 69 64 73 20 28 63 6f 6e rev-run-ids (con
0d40: 73 20 69 64 20 70 72 65 76 2d 72 75 6e 2d 69 64 s id prev-run-id
0d50: 73 29 29 29 0a 09 09 20 64 62 0a 09 09 20 28 63 s)))... db... (c
0d60: 6f 6e 63 20 22 53 45 4c 45 43 54 20 69 64 20 46 onc "SELECT id F
0d70: 52 4f 4d 20 72 75 6e 73 20 57 48 45 52 45 20 22 ROM runs WHERE "
0d80: 20 71 72 79 73 74 72 20 22 20 41 4e 44 20 69 64 qrystr " AND id
0d90: 20 21 3d 20 3f 3b 22 29 20 28 61 70 70 65 6e 64 != ?;") (append
0da0: 20 6b 65 79 76 61 6c 73 20 28 6c 69 73 74 20 72 keyvals (list r
0db0: 75 6e 2d 69 64 29 29 29 0a 09 20 20 3b 3b 20 63 un-id))).. ;; c
0dc0: 6f 6c 6c 65 63 74 20 61 6c 6c 20 6d 61 74 63 68 ollect all match
0dd0: 69 6e 67 20 74 65 73 74 73 20 66 6f 72 20 74 68 ing tests for th
0de0: 65 20 72 75 6e 73 20 74 68 65 6e 0a 09 20 20 3b e runs then.. ;
0df0: 3b 20 65 78 74 72 61 63 74 20 74 68 65 20 6d 6f ; extract the mo
0e00: 73 74 20 72 65 63 65 6e 74 20 74 65 73 74 20 61 st recent test a
0e10: 6e 64 20 72 65 74 75 72 6e 20 74 68 61 74 2e 0a nd return that..
0e20: 09 20 20 28 64 65 62 75 67 3a 70 72 69 6e 74 20 . (debug:print
0e30: 34 20 22 73 65 6c 73 74 72 3a 20 22 20 73 65 6c 4 "selstr: " sel
0e40: 73 74 72 20 22 2c 20 71 72 79 73 74 72 3a 20 22 str ", qrystr: "
0e50: 20 71 72 79 73 74 72 20 22 2c 20 6b 65 79 76 61 qrystr ", keyva
0e60: 6c 73 3a 20 22 20 6b 65 79 76 61 6c 73 20 0a 09 ls: " keyvals ..
0e70: 09 20 20 20 20 20 20 20 22 2c 20 70 72 65 76 69 . ", previ
0e80: 6f 75 73 20 72 75 6e 20 69 64 73 20 66 6f 75 6e ous run ids foun
0e90: 64 3a 20 22 20 70 72 65 76 2d 72 75 6e 2d 69 64 d: " prev-run-id
0ea0: 73 29 0a 09 20 20 28 69 66 20 28 6e 75 6c 6c 3f s).. (if (null?
0eb0: 20 70 72 65 76 2d 72 75 6e 2d 69 64 73 29 20 27 prev-run-ids) '
0ec0: 28 29 20 20 3b 3b 20 6e 6f 20 70 72 65 76 69 6f () ;; no previo
0ed0: 75 73 20 72 75 6e 73 3f 20 72 65 74 75 72 6e 20 us runs? return
0ee0: 6e 75 6c 6c 0a 09 20 20 20 20 20 20 28 6c 65 74 null.. (let
0ef0: 20 6c 6f 6f 70 20 28 28 68 65 64 20 28 63 61 72 loop ((hed (car
0f00: 20 70 72 65 76 2d 72 75 6e 2d 69 64 73 29 29 0a prev-run-ids)).
0f10: 09 09 09 20 28 74 61 6c 20 28 63 64 72 20 70 72 ... (tal (cdr pr
0f20: 65 76 2d 72 75 6e 2d 69 64 73 29 29 29 0a 09 09 ev-run-ids)))...
0f30: 28 6c 65 74 20 28 28 72 65 73 75 6c 74 73 20 28 (let ((results (
0f40: 72 64 62 3a 67 65 74 2d 74 65 73 74 73 2d 66 6f rdb:get-tests-fo
0f50: 72 2d 72 75 6e 20 64 62 20 68 65 64 20 74 65 73 r-run db hed tes
0f60: 74 2d 6e 61 6d 65 20 69 74 65 6d 2d 70 61 74 68 t-name item-path
0f70: 20 27 28 29 20 27 28 29 29 29 29 0a 09 09 20 20 '() '())))...
0f80: 28 64 65 62 75 67 3a 70 72 69 6e 74 20 34 20 22 (debug:print 4 "
0f90: 47 6f 74 20 74 65 73 74 73 20 66 6f 72 20 72 75 Got tests for ru
0fa0: 6e 2d 69 64 20 22 20 72 75 6e 2d 69 64 20 22 2c n-id " run-id ",
0fb0: 20 74 65 73 74 2d 6e 61 6d 65 20 22 20 74 65 73 test-name " tes
0fc0: 74 2d 6e 61 6d 65 20 0a 09 09 09 20 20 20 20 20 t-name ....
0fd0: 20 20 22 2c 20 69 74 65 6d 2d 70 61 74 68 20 22 ", item-path "
0fe0: 20 69 74 65 6d 2d 70 61 74 68 20 22 20 72 65 73 item-path " res
0ff0: 75 6c 74 73 3a 20 22 20 28 69 6e 74 65 72 73 70 ults: " (intersp
1000: 65 72 73 65 20 72 65 73 75 6c 74 73 20 22 5c 6e erse results "\n
1010: 22 29 29 0a 09 09 20 20 3b 3b 20 4b 65 65 70 20 "))... ;; Keep
1020: 6f 6e 6c 79 20 74 68 65 20 79 6f 75 6e 67 65 73 only the younges
1030: 74 20 6f 66 20 61 6e 79 20 74 65 73 74 2f 69 74 t of any test/it
1040: 65 6d 20 63 6f 6d 62 69 6e 61 74 69 6f 6e 0a 09 em combination..
1050: 09 20 20 28 66 6f 72 2d 65 61 63 68 20 0a 09 09 . (for-each ...
1060: 20 20 20 28 6c 61 6d 62 64 61 20 28 74 65 73 74 (lambda (test
1070: 64 61 74 29 0a 09 09 20 20 20 20 20 28 6c 65 74 dat)... (let
1080: 2a 20 28 28 66 75 6c 6c 2d 74 65 73 74 6e 61 6d * ((full-testnam
1090: 65 20 28 63 6f 6e 63 20 28 64 62 3a 74 65 73 74 e (conc (db:test
10a0: 2d 67 65 74 2d 74 65 73 74 6e 61 6d 65 20 74 65 -get-testname te
10b0: 73 74 64 61 74 29 20 22 2f 22 20 28 64 62 3a 74 stdat) "/" (db:t
10c0: 65 73 74 2d 67 65 74 2d 69 74 65 6d 2d 70 61 74 est-get-item-pat
10d0: 68 20 74 65 73 74 64 61 74 29 29 29 0a 09 09 09 h testdat)))....
10e0: 20 20 20 20 28 73 74 6f 72 65 64 2d 74 65 73 74 (stored-test
10f0: 20 20 20 28 68 61 73 68 2d 74 61 62 6c 65 2d 72 (hash-table-r
1100: 65 66 2f 64 65 66 61 75 6c 74 20 74 65 73 74 73 ef/default tests
1110: 2d 68 61 73 68 20 66 75 6c 6c 2d 74 65 73 74 6e -hash full-testn
1120: 61 6d 65 20 23 66 29 29 29 0a 09 09 20 20 20 20 ame #f)))...
1130: 20 20 20 28 69 66 20 28 6f 72 20 28 6e 6f 74 20 (if (or (not
1140: 73 74 6f 72 65 64 2d 74 65 73 74 29 0a 09 09 09 stored-test)....
1150: 20 20 20 20 20 20 20 28 61 6e 64 20 73 74 6f 72 (and stor
1160: 65 64 2d 74 65 73 74 0a 09 09 09 09 20 20 20 20 ed-test.....
1170: 28 3e 20 28 64 62 3a 74 65 73 74 2d 67 65 74 2d (> (db:test-get-
1180: 65 76 65 6e 74 5f 74 69 6d 65 20 74 65 73 74 64 event_time testd
1190: 61 74 29 28 64 62 3a 74 65 73 74 2d 67 65 74 2d at)(db:test-get-
11a0: 65 76 65 6e 74 5f 74 69 6d 65 20 73 74 6f 72 65 event_time store
11b0: 64 2d 74 65 73 74 29 29 29 29 0a 09 09 09 20 20 d-test))))....
11c0: 20 3b 3b 20 74 68 69 73 20 74 65 73 74 20 69 73 ;; this test is
11d0: 20 79 6f 75 6e 67 65 72 2c 20 73 74 6f 72 65 20 younger, store
11e0: 69 74 20 69 6e 20 74 68 65 20 68 61 73 68 0a 09 it in the hash..
11f0: 09 09 20 20 20 28 68 61 73 68 2d 74 61 62 6c 65 .. (hash-table
1200: 2d 73 65 74 21 20 74 65 73 74 73 2d 68 61 73 68 -set! tests-hash
1210: 20 66 75 6c 6c 2d 74 65 73 74 6e 61 6d 65 20 74 full-testname t
1220: 65 73 74 64 61 74 29 29 29 29 0a 09 09 20 20 20 estdat))))...
1230: 72 65 73 75 6c 74 73 29 0a 09 09 20 20 28 69 66 results)... (if
1240: 20 28 6e 75 6c 6c 3f 20 74 61 6c 29 0a 09 09 20 (null? tal)...
1250: 20 20 20 20 20 28 6d 61 70 20 63 64 72 20 28 68 (map cdr (h
1260: 61 73 68 2d 74 61 62 6c 65 2d 3e 61 6c 69 73 74 ash-table->alist
1270: 20 74 65 73 74 73 2d 68 61 73 68 29 29 20 3b 3b tests-hash)) ;;
1280: 20 72 65 74 75 72 6e 20 61 20 6c 69 73 74 20 6f return a list o
1290: 66 20 74 68 65 20 6d 6f 73 74 20 72 65 63 65 6e f the most recen
12a0: 74 20 74 65 73 74 73 0a 09 09 20 20 20 20 20 20 t tests...
12b0: 28 6c 6f 6f 70 20 28 63 61 72 20 74 61 6c 29 28 (loop (car tal)(
12c0: 63 64 72 20 74 61 6c 29 29 29 29 29 29 29 29 29 cdr tal)))))))))
12d0: 29 0a 0a 3b 3b 20 0a 28 64 65 66 69 6e 65 20 28 )..;; .(define (
12e0: 74 65 73 74 2d 73 65 74 2d 73 74 61 74 75 73 21 test-set-status!
12f0: 20 64 62 20 72 75 6e 2d 69 64 20 74 65 73 74 2d db run-id test-
1300: 6e 61 6d 65 20 73 74 61 74 65 20 73 74 61 74 75 name state statu
1310: 73 20 69 74 65 6d 64 61 74 2d 6f 72 2d 70 61 74 s itemdat-or-pat
1320: 68 20 63 6f 6d 6d 65 6e 74 20 64 61 74 29 0a 20 h comment dat).
1330: 20 28 6c 65 74 2a 20 28 28 72 65 61 6c 2d 73 74 (let* ((real-st
1340: 61 74 75 73 20 73 74 61 74 75 73 29 0a 09 20 28 atus status).. (
1350: 69 74 65 6d 2d 70 61 74 68 20 20 20 28 69 66 20 item-path (if
1360: 28 73 74 72 69 6e 67 3f 20 69 74 65 6d 64 61 74 (string? itemdat
1370: 2d 6f 72 2d 70 61 74 68 29 20 69 74 65 6d 64 61 -or-path) itemda
1380: 74 2d 6f 72 2d 70 61 74 68 20 28 69 74 65 6d 2d t-or-path (item-
1390: 6c 69 73 74 2d 3e 70 61 74 68 20 69 74 65 6d 64 list->path itemd
13a0: 61 74 2d 6f 72 2d 70 61 74 68 29 29 29 0a 09 20 at-or-path)))..
13b0: 28 74 65 73 74 64 61 74 20 20 20 20 20 28 64 62 (testdat (db
13c0: 3a 67 65 74 2d 74 65 73 74 2d 69 6e 66 6f 20 64 :get-test-info d
13d0: 62 20 72 75 6e 2d 69 64 20 74 65 73 74 2d 6e 61 b run-id test-na
13e0: 6d 65 20 69 74 65 6d 2d 70 61 74 68 29 29 0a 09 me item-path))..
13f0: 20 28 74 65 73 74 2d 69 64 20 20 20 20 20 28 69 (test-id (i
1400: 66 20 74 65 73 74 64 61 74 20 28 64 62 3a 74 65 f testdat (db:te
1410: 73 74 2d 67 65 74 2d 69 64 20 74 65 73 74 64 61 st-get-id testda
1420: 74 29 20 23 66 29 29 0a 09 20 28 6f 74 68 65 72 t) #f)).. (other
1430: 64 61 74 20 20 20 20 28 69 66 20 64 61 74 20 64 dat (if dat d
1440: 61 74 20 28 6d 61 6b 65 2d 68 61 73 68 2d 74 61 at (make-hash-ta
1450: 62 6c 65 29 29 29 0a 09 20 3b 3b 20 62 65 66 6f ble))).. ;; befo
1460: 72 65 20 70 72 6f 63 65 65 64 69 6e 67 20 77 65 re proceeding we
1470: 20 6d 75 73 74 20 66 69 6e 64 20 6f 75 74 20 69 must find out i
1480: 66 20 74 68 65 20 70 72 65 76 69 6f 75 73 20 74 f the previous t
1490: 65 73 74 20 28 77 68 65 72 65 20 61 6c 6c 20 6b est (where all k
14a0: 65 79 73 20 6d 61 74 63 68 65 64 20 65 78 63 65 eys matched exce
14b0: 70 74 20 72 75 6e 6e 61 6d 65 29 0a 09 20 3b 3b pt runname).. ;;
14c0: 20 77 61 73 20 57 41 49 56 45 44 20 69 66 20 74 was WAIVED if t
14d0: 68 69 73 20 74 65 73 74 20 69 73 20 46 41 49 4c his test is FAIL
14e0: 0a 09 20 28 77 61 69 76 65 64 20 20 20 28 69 66 .. (waived (if
14f0: 20 28 65 71 75 61 6c 3f 20 73 74 61 74 75 73 20 (equal? status
1500: 22 46 41 49 4c 22 29 0a 09 09 20 20 20 20 20 20 "FAIL")...
1510: 20 28 6c 65 74 20 28 28 70 72 65 76 2d 74 65 73 (let ((prev-tes
1520: 74 20 28 74 65 73 74 3a 67 65 74 2d 70 72 65 76 t (test:get-prev
1530: 69 6f 75 73 2d 74 65 73 74 2d 72 75 6e 2d 72 65 ious-test-run-re
1540: 63 6f 72 64 20 64 62 20 72 75 6e 2d 69 64 20 74 cord db run-id t
1550: 65 73 74 2d 6e 61 6d 65 20 69 74 65 6d 2d 70 61 est-name item-pa
1560: 74 68 29 29 29 0a 09 09 09 20 28 69 66 20 70 72 th))).... (if pr
1570: 65 76 2d 74 65 73 74 20 3b 3b 20 74 72 75 65 20 ev-test ;; true
1580: 69 66 20 77 65 20 66 6f 75 6e 64 20 61 20 70 72 if we found a pr
1590: 65 76 69 6f 75 73 20 74 65 73 74 20 69 6e 20 74 evious test in t
15a0: 68 69 73 20 72 75 6e 20 73 65 72 69 65 73 0a 09 his run series..
15b0: 09 09 20 20 20 20 20 28 6c 65 74 20 28 28 70 72 .. (let ((pr
15c0: 65 76 2d 73 74 61 74 75 73 20 28 64 62 3a 74 65 ev-status (db:te
15d0: 73 74 2d 67 65 74 2d 73 74 61 74 75 73 20 20 20 st-get-status
15e0: 70 72 65 76 2d 74 65 73 74 29 29 0a 09 09 09 09 prev-test)).....
15f0: 20 20 20 28 70 72 65 76 2d 73 74 61 74 65 20 20 (prev-state
1600: 28 64 62 3a 74 65 73 74 2d 67 65 74 2d 73 74 61 (db:test-get-sta
1610: 74 65 20 20 20 20 70 72 65 76 2d 74 65 73 74 29 te prev-test)
1620: 29 0a 09 09 09 09 20 20 20 28 70 72 65 76 2d 63 )..... (prev-c
1630: 6f 6d 6d 65 6e 74 20 28 64 62 3a 74 65 73 74 2d omment (db:test-
1640: 67 65 74 2d 63 6f 6d 6d 65 6e 74 20 70 72 65 76 get-comment prev
1650: 2d 74 65 73 74 29 29 29 0a 09 09 09 20 20 20 20 -test)))....
1660: 20 20 20 28 64 65 62 75 67 3a 70 72 69 6e 74 20 (debug:print
1670: 34 20 22 70 72 65 76 2d 73 74 61 74 75 73 20 22 4 "prev-status "
1680: 20 70 72 65 76 2d 73 74 61 74 75 73 20 22 2c 20 prev-status ",
1690: 70 72 65 76 2d 73 74 61 74 65 20 22 20 70 72 65 prev-state " pre
16a0: 76 2d 73 74 61 74 65 20 22 2c 20 70 72 65 76 2d v-state ", prev-
16b0: 63 6f 6d 6d 65 6e 74 20 22 20 70 72 65 76 2d 63 comment " prev-c
16c0: 6f 6d 6d 65 6e 74 29 0a 09 09 09 20 20 20 20 20 omment)....
16d0: 20 20 28 69 66 20 28 61 6e 64 20 28 65 71 75 61 (if (and (equa
16e0: 6c 3f 20 70 72 65 76 2d 73 74 61 74 65 20 20 22 l? prev-state "
16f0: 43 4f 4d 50 4c 45 54 45 44 22 29 0a 09 09 09 09 COMPLETED").....
1700: 09 28 65 71 75 61 6c 3f 20 70 72 65 76 2d 73 74 .(equal? prev-st
1710: 61 74 75 73 20 22 57 41 49 56 45 44 22 29 29 0a atus "WAIVED")).
1720: 09 09 09 09 20 20 20 70 72 65 76 2d 63 6f 6d 6d .... prev-comm
1730: 65 6e 74 20 3b 3b 20 77 61 69 76 65 64 20 69 73 ent ;; waived is
1740: 20 65 69 74 68 65 72 20 74 68 65 20 63 6f 6d 6d either the comm
1750: 65 6e 74 20 6f 72 20 23 66 0a 09 09 09 09 20 20 ent or #f.....
1760: 20 23 66 29 29 0a 09 09 09 20 20 20 20 20 23 66 #f)).... #f
1770: 29 29 0a 09 09 20 20 20 20 20 20 20 23 66 29 29 ))... #f))
1780: 29 0a 20 20 20 20 28 69 66 20 77 61 69 76 65 64 ). (if waived
1790: 20 28 73 65 74 21 20 72 65 61 6c 2d 73 74 61 74 (set! real-stat
17a0: 75 73 20 22 57 41 49 56 45 44 22 29 29 0a 20 20 us "WAIVED")).
17b0: 20 20 28 64 65 62 75 67 3a 70 72 69 6e 74 20 34 (debug:print 4
17c0: 20 22 72 65 61 6c 2d 73 74 61 74 75 73 20 22 20 "real-status "
17d0: 72 65 61 6c 2d 73 74 61 74 75 73 20 22 2c 20 77 real-status ", w
17e0: 61 69 76 65 64 20 22 20 77 61 69 76 65 64 20 22 aived " waived "
17f0: 2c 20 73 74 61 74 75 73 20 22 20 73 74 61 74 75 , status " statu
1800: 73 29 0a 0a 20 20 20 20 3b 3b 20 75 70 64 61 74 s).. ;; updat
1810: 65 20 74 68 65 20 70 72 69 6d 61 72 79 20 72 65 e the primary re
1820: 63 6f 72 64 20 49 46 20 73 74 61 74 65 20 41 4e cord IF state AN
1830: 44 20 73 74 61 74 75 73 20 61 72 65 20 64 65 66 D status are def
1840: 69 6e 65 64 0a 20 20 20 20 28 69 66 20 28 61 6e ined. (if (an
1850: 64 20 73 74 61 74 65 20 73 74 61 74 75 73 29 0a d state status).
1860: 09 28 72 64 62 3a 74 65 73 74 2d 73 65 74 2d 73 .(rdb:test-set-s
1870: 74 61 74 65 2d 73 74 61 74 75 73 2d 62 79 2d 72 tate-status-by-r
1880: 75 6e 2d 69 64 2d 74 65 73 74 6e 61 6d 65 20 64 un-id-testname d
1890: 62 20 72 75 6e 2d 69 64 20 74 65 73 74 2d 6e 61 b run-id test-na
18a0: 6d 65 20 69 74 65 6d 2d 70 61 74 68 20 72 65 61 me item-path rea
18b0: 6c 2d 73 74 61 74 75 73 20 73 74 61 74 65 29 29 l-status state))
18c0: 0a 0a 20 20 20 20 3b 3b 20 69 66 20 73 74 61 74 .. ;; if stat
18d0: 75 73 20 69 73 20 22 41 55 54 4f 22 20 74 68 65 us is "AUTO" the
18e0: 6e 20 63 61 6c 6c 20 72 6f 6c 6c 75 70 20 28 6e n call rollup (n
18f0: 6f 74 65 2c 20 74 68 69 73 20 6f 6e 65 20 6d 6f ote, this one mo
1900: 64 69 66 69 65 73 20 64 61 74 61 20 69 6e 20 74 difies data in t
1910: 65 73 74 0a 20 20 20 20 3b 3b 20 72 75 6e 20 61 est. ;; run a
1920: 72 65 61 2c 20 64 6f 20 6e 6f 74 20 72 70 63 20 rea, do not rpc
1930: 69 74 20 28 79 65 74 29 0a 20 20 20 20 28 69 66 it (yet). (if
1940: 20 28 61 6e 64 20 74 65 73 74 2d 69 64 20 73 74 (and test-id st
1950: 61 74 65 20 73 74 61 74 75 73 20 28 65 71 75 61 ate status (equa
1960: 6c 3f 20 73 74 61 74 75 73 20 22 41 55 54 4f 22 l? status "AUTO"
1970: 29 29 20 0a 09 28 64 62 3a 74 65 73 74 2d 64 61 )) ..(db:test-da
1980: 74 61 2d 72 6f 6c 6c 75 70 20 64 62 20 74 65 73 ta-rollup db tes
1990: 74 2d 69 64 20 73 74 61 74 75 73 29 29 0a 0a 20 t-id status))..
19a0: 20 20 20 3b 3b 20 61 64 64 20 6d 65 74 61 64 61 ;; add metada
19b0: 74 61 20 28 6e 65 65 64 20 74 6f 20 64 6f 20 74 ta (need to do t
19c0: 68 69 73 20 77 61 79 20 74 6f 20 61 76 6f 69 64 his way to avoid
19d0: 20 53 51 4c 20 69 6e 6a 65 63 74 69 6f 6e 20 69 SQL injection i
19e0: 73 73 75 65 73 29 0a 0a 20 20 20 20 3b 3b 20 3a ssues).. ;; :
19f0: 66 69 72 73 74 5f 65 72 72 0a 20 20 20 20 3b 3b first_err. ;;
1a00: 20 28 6c 65 74 20 28 28 76 61 6c 20 28 68 61 73 (let ((val (has
1a10: 68 2d 74 61 62 6c 65 2d 72 65 66 2f 64 65 66 61 h-table-ref/defa
1a20: 75 6c 74 20 6f 74 68 65 72 64 61 74 20 22 3a 66 ult otherdat ":f
1a30: 69 72 73 74 5f 65 72 72 22 20 23 66 29 29 29 0a irst_err" #f))).
1a40: 20 20 20 20 3b 3b 20 20 20 28 69 66 20 76 61 6c ;; (if val
1a50: 0a 20 20 20 20 3b 3b 20 20 20 20 20 20 20 28 73 . ;; (s
1a60: 71 6c 69 74 65 33 3a 65 78 65 63 75 74 65 20 64 qlite3:execute d
1a70: 62 20 22 55 50 44 41 54 45 20 74 65 73 74 73 20 b "UPDATE tests
1a80: 53 45 54 20 66 69 72 73 74 5f 65 72 72 3d 3f 20 SET first_err=?
1a90: 57 48 45 52 45 20 72 75 6e 5f 69 64 3d 3f 20 41 WHERE run_id=? A
1aa0: 4e 44 20 74 65 73 74 6e 61 6d 65 3d 3f 20 41 4e ND testname=? AN
1ab0: 44 20 69 74 65 6d 5f 70 61 74 68 3d 3f 3b 22 20 D item_path=?;"
1ac0: 76 61 6c 20 72 75 6e 2d 69 64 20 74 65 73 74 2d val run-id test-
1ad0: 6e 61 6d 65 20 69 74 65 6d 2d 70 61 74 68 29 29 name item-path))
1ae0: 29 0a 20 20 20 20 3b 3b 20 0a 20 20 20 20 3b 3b ). ;; . ;;
1af0: 20 3b 3b 20 3a 66 69 72 73 74 5f 77 61 72 6e 0a ;; :first_warn.
1b00: 20 20 20 20 3b 3b 20 28 6c 65 74 20 28 28 76 61 ;; (let ((va
1b10: 6c 20 28 68 61 73 68 2d 74 61 62 6c 65 2d 72 65 l (hash-table-re
1b20: 66 2f 64 65 66 61 75 6c 74 20 6f 74 68 65 72 64 f/default otherd
1b30: 61 74 20 22 3a 66 69 72 73 74 5f 77 61 72 6e 22 at ":first_warn"
1b40: 20 23 66 29 29 29 0a 20 20 20 20 3b 3b 20 20 20 #f))). ;;
1b50: 28 69 66 20 76 61 6c 0a 20 20 20 20 3b 3b 20 20 (if val. ;;
1b60: 20 20 20 20 20 28 73 71 6c 69 74 65 33 3a 65 78 (sqlite3:ex
1b70: 65 63 75 74 65 20 64 62 20 22 55 50 44 41 54 45 ecute db "UPDATE
1b80: 20 74 65 73 74 73 20 53 45 54 20 66 69 72 73 74 tests SET first
1b90: 5f 77 61 72 6e 3d 3f 20 57 48 45 52 45 20 72 75 _warn=? WHERE ru
1ba0: 6e 5f 69 64 3d 3f 20 41 4e 44 20 74 65 73 74 6e n_id=? AND testn
1bb0: 61 6d 65 3d 3f 20 41 4e 44 20 69 74 65 6d 5f 70 ame=? AND item_p
1bc0: 61 74 68 3d 3f 3b 22 20 76 61 6c 20 72 75 6e 2d ath=?;" val run-
1bd0: 69 64 20 74 65 73 74 2d 6e 61 6d 65 20 69 74 65 id test-name ite
1be0: 6d 2d 70 61 74 68 29 29 29 0a 0a 20 20 20 20 28 m-path))).. (
1bf0: 6c 65 74 20 28 28 63 61 74 65 67 6f 72 79 20 28 let ((category (
1c00: 68 61 73 68 2d 74 61 62 6c 65 2d 72 65 66 2f 64 hash-table-ref/d
1c10: 65 66 61 75 6c 74 20 6f 74 68 65 72 64 61 74 20 efault otherdat
1c20: 22 3a 63 61 74 65 67 6f 72 79 22 20 22 22 29 29 ":category" ""))
1c30: 0a 09 20 20 28 76 61 72 69 61 62 6c 65 20 28 68 .. (variable (h
1c40: 61 73 68 2d 74 61 62 6c 65 2d 72 65 66 2f 64 65 ash-table-ref/de
1c50: 66 61 75 6c 74 20 6f 74 68 65 72 64 61 74 20 22 fault otherdat "
1c60: 3a 76 61 72 69 61 62 6c 65 22 20 22 22 29 29 0a :variable" "")).
1c70: 09 20 20 28 76 61 6c 75 65 20 20 20 20 28 68 61 . (value (ha
1c80: 73 68 2d 74 61 62 6c 65 2d 72 65 66 2f 64 65 66 sh-table-ref/def
1c90: 61 75 6c 74 20 6f 74 68 65 72 64 61 74 20 22 3a ault otherdat ":
1ca0: 76 61 6c 75 65 22 20 20 20 20 23 66 29 29 0a 09 value" #f))..
1cb0: 20 20 28 65 78 70 65 63 74 65 64 20 28 68 61 73 (expected (has
1cc0: 68 2d 74 61 62 6c 65 2d 72 65 66 2f 64 65 66 61 h-table-ref/defa
1cd0: 75 6c 74 20 6f 74 68 65 72 64 61 74 20 22 3a 65 ult otherdat ":e
1ce0: 78 70 65 63 74 65 64 22 20 23 66 29 29 0a 09 20 xpected" #f))..
1cf0: 20 28 74 6f 6c 20 20 20 20 20 20 28 68 61 73 68 (tol (hash
1d00: 2d 74 61 62 6c 65 2d 72 65 66 2f 64 65 66 61 75 -table-ref/defau
1d10: 6c 74 20 6f 74 68 65 72 64 61 74 20 22 3a 74 6f lt otherdat ":to
1d20: 6c 22 20 20 20 20 20 20 23 66 29 29 0a 09 20 20 l" #f))..
1d30: 28 75 6e 69 74 73 20 20 20 20 28 68 61 73 68 2d (units (hash-
1d40: 74 61 62 6c 65 2d 72 65 66 2f 64 65 66 61 75 6c table-ref/defaul
1d50: 74 20 6f 74 68 65 72 64 61 74 20 22 3a 75 6e 69 t otherdat ":uni
1d60: 74 73 22 20 20 20 20 22 22 29 29 0a 09 20 20 28 ts" "")).. (
1d70: 74 79 70 65 20 20 20 20 20 28 68 61 73 68 2d 74 type (hash-t
1d80: 61 62 6c 65 2d 72 65 66 2f 64 65 66 61 75 6c 74 able-ref/default
1d90: 20 6f 74 68 65 72 64 61 74 20 22 3a 74 79 70 65 otherdat ":type
1da0: 22 20 20 20 20 20 22 22 29 29 0a 09 20 20 28 64 " "")).. (d
1db0: 63 6f 6d 6d 65 6e 74 20 28 68 61 73 68 2d 74 61 comment (hash-ta
1dc0: 62 6c 65 2d 72 65 66 2f 64 65 66 61 75 6c 74 20 ble-ref/default
1dd0: 6f 74 68 65 72 64 61 74 20 22 3a 63 6f 6d 6d 65 otherdat ":comme
1de0: 6e 74 22 20 20 22 22 29 29 29 0a 20 20 20 20 20 nt" ""))).
1df0: 20 28 64 65 62 75 67 3a 70 72 69 6e 74 20 34 20 (debug:print 4
1e00: 0a 09 09 20 20 20 22 63 61 74 65 67 6f 72 79 3a ... "category:
1e10: 20 22 20 63 61 74 65 67 6f 72 79 20 22 2c 20 76 " category ", v
1e20: 61 72 69 61 62 6c 65 3a 20 22 20 76 61 72 69 61 ariable: " varia
1e30: 62 6c 65 20 22 2c 20 76 61 6c 75 65 3a 20 22 20 ble ", value: "
1e40: 76 61 6c 75 65 0a 09 09 20 20 20 22 2c 20 65 78 value... ", ex
1e50: 70 65 63 74 65 64 3a 20 22 20 65 78 70 65 63 74 pected: " expect
1e60: 65 64 20 22 2c 20 74 6f 6c 3a 20 22 20 74 6f 6c ed ", tol: " tol
1e70: 20 22 2c 20 75 6e 69 74 73 3a 20 22 20 75 6e 69 ", units: " uni
1e80: 74 73 29 0a 20 20 20 20 20 20 28 69 66 20 28 61 ts). (if (a
1e90: 6e 64 20 76 61 6c 75 65 20 65 78 70 65 63 74 65 nd value expecte
1ea0: 64 20 74 6f 6c 29 20 3b 3b 20 61 6c 6c 20 74 68 d tol) ;; all th
1eb0: 72 65 65 20 72 65 71 75 69 72 65 64 0a 09 20 20 ree required..
1ec0: 28 72 64 62 3a 63 73 76 2d 3e 74 65 73 74 2d 64 (rdb:csv->test-d
1ed0: 61 74 61 20 64 62 20 74 65 73 74 2d 69 64 20 0a ata db test-id .
1ee0: 09 09 09 20 20 20 20 20 28 63 6f 6e 63 20 63 61 ... (conc ca
1ef0: 74 65 67 6f 72 79 20 22 2c 22 0a 09 09 09 09 20 tegory ",".....
1f00: 20 20 76 61 72 69 61 62 6c 65 20 22 2c 22 0a 09 variable ","..
1f10: 09 09 09 20 20 20 76 61 6c 75 65 20 20 20 20 22 ... value "
1f20: 2c 22 0a 09 09 09 09 20 20 20 65 78 70 65 63 74 ,"..... expect
1f30: 65 64 20 22 2c 22 0a 09 09 09 09 20 20 20 74 6f ed ","..... to
1f40: 6c 20 20 20 20 20 20 22 2c 22 0a 09 09 09 09 20 l ",".....
1f50: 20 20 75 6e 69 74 73 20 20 20 20 22 2c 22 0a 09 units ","..
1f60: 09 09 09 20 20 20 64 63 6f 6d 6d 65 6e 74 20 22 ... dcomment "
1f70: 2c 2c 22 20 3b 3b 20 65 78 74 72 61 20 63 6f 6d ,," ;; extra com
1f80: 6d 61 20 66 6f 72 20 73 74 61 74 75 73 0a 09 09 ma for status...
1f90: 09 09 20 20 20 74 79 70 65 20 20 20 20 20 29 29 .. type ))
1fa0: 29 29 0a 09 09 09 09 20 20 20 0a 20 20 20 20 3b ))..... . ;
1fb0: 3b 20 6e 65 65 64 20 74 6f 20 75 70 64 61 74 65 ; need to update
1fc0: 20 74 68 65 20 74 6f 70 20 74 65 73 74 20 72 65 the top test re
1fd0: 63 6f 72 64 20 69 66 20 50 41 53 53 20 6f 72 20 cord if PASS or
1fe0: 46 41 49 4c 20 61 6e 64 20 74 68 69 73 20 69 73 FAIL and this is
1ff0: 20 61 20 73 75 62 74 65 73 74 0a 20 20 20 20 28 a subtest. (
2000: 72 64 62 3a 72 6f 6c 6c 2d 75 70 2d 70 61 73 73 rdb:roll-up-pass
2010: 2d 66 61 69 6c 2d 63 6f 75 6e 74 73 20 64 62 20 -fail-counts db
2020: 72 75 6e 2d 69 64 20 74 65 73 74 2d 6e 61 6d 65 run-id test-name
2030: 20 69 74 65 6d 2d 70 61 74 68 20 73 74 61 74 75 item-path statu
2040: 73 29 0a 0a 20 20 20 20 28 69 66 20 28 6f 72 20 s).. (if (or
2050: 28 61 6e 64 20 28 73 74 72 69 6e 67 3f 20 63 6f (and (string? co
2060: 6d 6d 65 6e 74 29 0a 09 09 20 28 73 74 72 69 6e mment)... (strin
2070: 67 2d 6d 61 74 63 68 20 28 72 65 67 65 78 70 20 g-match (regexp
2080: 22 5c 5c 53 2b 22 29 20 63 6f 6d 6d 65 6e 74 29 "\\S+") comment)
2090: 29 0a 09 20 20 20 20 77 61 69 76 65 64 29 0a 09 ).. waived)..
20a0: 28 72 64 62 3a 74 65 73 74 2d 73 65 74 2d 63 6f (rdb:test-set-co
20b0: 6d 6d 65 6e 74 20 64 62 20 20 72 75 6e 2d 69 64 mment db run-id
20c0: 20 74 65 73 74 2d 6e 61 6d 65 20 69 74 65 6d 2d test-name item-
20d0: 70 61 74 68 20 28 69 66 20 77 61 69 76 65 64 20 path (if waived
20e0: 77 61 69 76 65 64 20 63 6f 6d 6d 65 6e 74 29 29 waived comment))
20f0: 29 0a 20 20 20 20 29 29 0a 0a 28 64 65 66 69 6e ). ))..(defin
2100: 65 20 28 74 65 73 74 2d 73 65 74 2d 6c 6f 67 21 e (test-set-log!
2110: 20 64 62 20 72 75 6e 2d 69 64 20 74 65 73 74 2d db run-id test-
2120: 6e 61 6d 65 20 69 74 65 6d 64 61 74 20 6c 6f 67 name itemdat log
2130: 66 29 20 0a 20 20 28 6c 65 74 20 28 28 69 74 65 f) . (let ((ite
2140: 6d 2d 70 61 74 68 20 28 69 74 65 6d 2d 6c 69 73 m-path (item-lis
2150: 74 2d 3e 70 61 74 68 20 69 74 65 6d 64 61 74 29 t->path itemdat)
2160: 29 29 0a 20 20 20 20 28 72 64 62 3a 74 65 73 74 )). (rdb:test
2170: 2d 73 65 74 2d 6c 6f 67 21 20 64 62 20 72 75 6e -set-log! db run
2180: 2d 69 64 20 74 65 73 74 2d 6e 61 6d 65 20 69 74 -id test-name it
2190: 65 6d 2d 70 61 74 68 20 6c 6f 67 66 29 29 29 0a em-path logf))).
21a0: 0a 28 64 65 66 69 6e 65 20 28 74 65 73 74 2d 73 .(define (test-s
21b0: 65 74 2d 74 6f 70 6c 6f 67 21 20 64 62 20 72 75 et-toplog! db ru
21c0: 6e 2d 69 64 20 74 65 73 74 2d 6e 61 6d 65 20 6c n-id test-name l
21d0: 6f 67 66 29 20 0a 20 20 28 73 71 6c 69 74 65 33 ogf) . (sqlite3
21e0: 3a 65 78 65 63 75 74 65 20 64 62 20 22 55 50 44 :execute db "UPD
21f0: 41 54 45 20 74 65 73 74 73 20 53 45 54 20 66 69 ATE tests SET fi
2200: 6e 61 6c 5f 6c 6f 67 66 3d 3f 20 57 48 45 52 45 nal_logf=? WHERE
2210: 20 72 75 6e 5f 69 64 3d 3f 20 41 4e 44 20 74 65 run_id=? AND te
2220: 73 74 6e 61 6d 65 3d 3f 20 41 4e 44 20 69 74 65 stname=? AND ite
2230: 6d 5f 70 61 74 68 3d 27 27 3b 22 20 0a 09 09 20 m_path='';" ...
2240: 20 20 6c 6f 67 66 20 72 75 6e 2d 69 64 20 74 65 logf run-id te
2250: 73 74 2d 6e 61 6d 65 29 29 0a 0a 28 64 65 66 69 st-name))..(defi
2260: 6e 65 20 28 74 65 73 74 73 3a 73 75 6d 6d 61 72 ne (tests:summar
2270: 69 7a 65 2d 69 74 65 6d 73 20 64 62 20 72 75 6e ize-items db run
2280: 2d 69 64 20 74 65 73 74 2d 6e 61 6d 65 20 66 6f -id test-name fo
2290: 72 63 65 29 0a 20 20 3b 3b 20 69 66 20 6e 6f 74 rce). ;; if not
22a0: 20 66 6f 72 63 65 20 74 68 65 6e 20 6f 6e 6c 79 force then only
22b0: 20 75 70 64 61 74 65 20 74 68 65 20 72 65 63 6f update the reco
22c0: 72 64 20 69 66 20 6f 6e 65 20 6f 66 20 74 68 65 rd if one of the
22d0: 73 65 20 69 73 20 74 72 75 65 3a 0a 20 20 3b 3b se is true:. ;;
22e0: 20 20 20 31 2e 20 6c 6f 67 66 20 69 73 20 22 6c 1. logf is "l
22f0: 6f 67 2f 66 69 6e 61 6c 2e 6c 6f 67 0a 20 20 3b og/final.log. ;
2300: 3b 20 20 20 32 2e 20 6c 6f 67 66 20 69 73 20 73 ; 2. logf is s
2310: 61 6d 65 20 61 73 20 6f 75 74 70 75 74 66 69 6c ame as outputfil
2320: 65 6e 61 6d 65 0a 20 20 28 6c 65 74 20 28 28 6f ename. (let ((o
2330: 75 74 70 75 74 66 69 6c 65 6e 61 6d 65 20 28 63 utputfilename (c
2340: 6f 6e 63 20 22 6d 65 67 61 74 65 73 74 2d 72 6f onc "megatest-ro
2350: 6c 6c 75 70 2d 22 20 74 65 73 74 2d 6e 61 6d 65 llup-" test-name
2360: 20 22 2e 68 74 6d 6c 22 29 29 0a 09 28 6f 72 69 ".html"))..(ori
2370: 67 2d 64 69 72 20 20 20 20 20 20 20 28 63 75 72 g-dir (cur
2380: 72 65 6e 74 2d 64 69 72 65 63 74 6f 72 79 29 29 rent-directory))
2390: 0a 09 28 6c 6f 67 66 20 20 20 20 20 20 20 20 20 ..(logf
23a0: 20 20 23 66 29 29 0a 20 20 20 20 28 73 71 6c 69 #f)). (sqli
23b0: 74 65 33 3a 66 6f 72 2d 65 61 63 68 2d 72 6f 77 te3:for-each-row
23c0: 20 0a 20 20 20 20 20 28 6c 61 6d 62 64 61 20 28 . (lambda (
23d0: 70 61 74 68 20 66 69 6e 61 6c 5f 6c 6f 67 66 29 path final_logf)
23e0: 0a 20 20 20 20 20 20 20 28 73 65 74 21 20 6c 6f . (set! lo
23f0: 67 66 20 66 69 6e 61 6c 5f 6c 6f 67 66 29 0a 20 gf final_logf).
2400: 20 20 20 20 20 20 28 69 66 20 28 64 69 72 65 63 (if (direc
2410: 74 6f 72 79 3f 20 70 61 74 68 29 0a 09 20 20 20 tory? path)..
2420: 28 62 65 67 69 6e 0a 09 20 20 20 20 20 28 70 72 (begin.. (pr
2430: 69 6e 74 20 22 46 6f 75 6e 64 20 70 61 74 68 3a int "Found path:
2440: 20 22 20 70 61 74 68 29 0a 09 20 20 20 20 20 28 " path).. (
2450: 63 68 61 6e 67 65 2d 64 69 72 65 63 74 6f 72 79 change-directory
2460: 20 70 61 74 68 29 29 0a 09 20 20 20 20 20 3b 3b path)).. ;;
2470: 20 28 73 65 74 21 20 6f 75 74 70 75 74 66 69 6c (set! outputfil
2480: 65 6e 61 6d 65 20 28 63 6f 6e 63 20 70 61 74 68 ename (conc path
2490: 20 22 2f 22 20 6f 75 74 70 75 74 66 69 6c 65 6e "/" outputfilen
24a0: 61 6d 65 29 29 29 0a 09 20 20 20 28 70 72 69 6e ame))).. (prin
24b0: 74 20 22 4e 6f 20 73 75 63 68 20 70 61 74 68 3a t "No such path:
24c0: 20 22 20 70 61 74 68 29 29 29 0a 20 20 20 20 20 " path))).
24d0: 64 62 20 0a 20 20 20 20 20 22 53 45 4c 45 43 54 db . "SELECT
24e0: 20 72 75 6e 64 69 72 2c 66 69 6e 61 6c 5f 6c 6f rundir,final_lo
24f0: 67 66 20 46 52 4f 4d 20 74 65 73 74 73 20 57 48 gf FROM tests WH
2500: 45 52 45 20 72 75 6e 5f 69 64 3d 3f 20 41 4e 44 ERE run_id=? AND
2510: 20 74 65 73 74 6e 61 6d 65 3d 3f 20 41 4e 44 20 testname=? AND
2520: 69 74 65 6d 5f 70 61 74 68 3d 27 27 3b 22 0a 20 item_path='';".
2530: 20 20 20 20 72 75 6e 2d 69 64 20 74 65 73 74 2d run-id test-
2540: 6e 61 6d 65 29 0a 20 20 20 20 28 70 72 69 6e 74 name). (print
2550: 20 22 73 75 6d 6d 61 72 69 7a 65 2d 69 74 65 6d "summarize-item
2560: 73 20 77 69 74 68 20 6c 6f 67 66 20 22 20 6c 6f s with logf " lo
2570: 67 66 29 0a 20 20 20 20 28 69 66 20 28 6f 72 20 gf). (if (or
2580: 28 65 71 75 61 6c 3f 20 6c 6f 67 66 20 22 6c 6f (equal? logf "lo
2590: 67 73 2f 66 69 6e 61 6c 2e 6c 6f 67 22 29 0a 09 gs/final.log")..
25a0: 20 20 20 20 28 65 71 75 61 6c 3f 20 6c 6f 67 66 (equal? logf
25b0: 20 6f 75 74 70 75 74 66 69 6c 65 6e 61 6d 65 29 outputfilename)
25c0: 0a 09 20 20 20 20 66 6f 72 63 65 29 0a 09 28 62 .. force)..(b
25d0: 65 67 69 6e 0a 09 20 20 28 69 66 20 28 6f 62 74 egin.. (if (obt
25e0: 61 69 6e 2d 64 6f 74 2d 6c 6f 63 6b 20 6f 75 74 ain-dot-lock out
25f0: 70 75 74 66 69 6c 65 6e 61 6d 65 20 31 20 32 30 putfilename 1 20
2600: 20 33 30 29 20 3b 3b 20 72 65 74 72 79 20 65 76 30) ;; retry ev
2610: 65 72 79 20 73 65 63 6f 6e 64 20 66 6f 72 20 32 ery second for 2
2620: 30 20 73 65 63 6f 6e 64 73 2c 20 63 61 6c 6c 20 0 seconds, call
2630: 69 74 20 64 65 61 64 20 61 66 74 65 72 20 33 30 it dead after 30
2640: 20 73 65 63 6f 6e 64 73 20 61 6e 64 20 73 74 65 seconds and ste
2650: 61 6c 20 74 68 65 20 6c 6f 63 6b 0a 09 20 20 20 al the lock..
2660: 20 20 20 28 70 72 69 6e 74 20 22 4f 62 74 61 69 (print "Obtai
2670: 6e 65 64 20 6c 6f 63 6b 20 66 6f 72 20 22 20 6f ned lock for " o
2680: 75 74 70 75 74 66 69 6c 65 6e 61 6d 65 29 0a 09 utputfilename)..
2690: 20 20 20 20 20 20 28 70 72 69 6e 74 20 22 46 61 (print "Fa
26a0: 69 6c 65 64 20 74 6f 20 6f 62 74 61 69 6e 20 6c iled to obtain l
26b0: 6f 63 6b 20 66 6f 72 20 22 20 6f 75 74 70 75 74 ock for " output
26c0: 66 69 6c 65 6e 61 6d 65 29 29 0a 09 20 20 28 6c filename)).. (l
26d0: 65 74 20 28 28 6f 75 70 20 20 20 20 28 6f 70 65 et ((oup (ope
26e0: 6e 2d 6f 75 74 70 75 74 2d 66 69 6c 65 20 6f 75 n-output-file ou
26f0: 74 70 75 74 66 69 6c 65 6e 61 6d 65 29 29 0a 09 tputfilename))..
2700: 09 28 63 6f 75 6e 74 73 20 28 6d 61 6b 65 2d 68 .(counts (make-h
2710: 61 73 68 2d 74 61 62 6c 65 29 29 0a 09 09 28 73 ash-table))...(s
2720: 74 61 74 65 63 6f 75 6e 74 73 20 28 6d 61 6b 65 tatecounts (make
2730: 2d 68 61 73 68 2d 74 61 62 6c 65 29 29 0a 09 09 -hash-table))...
2740: 28 6f 75 74 74 78 74 20 22 22 29 0a 09 09 28 74 (outtxt "")...(t
2750: 6f 74 20 20 20 20 30 29 29 0a 09 20 20 20 20 28 ot 0)).. (
2760: 77 69 74 68 2d 6f 75 74 70 75 74 2d 74 6f 2d 70 with-output-to-p
2770: 6f 72 74 0a 09 09 6f 75 70 0a 09 20 20 20 20 20 ort...oup..
2780: 20 28 6c 61 6d 62 64 61 20 28 29 0a 09 09 28 73 (lambda ()...(s
2790: 65 74 21 20 6f 75 74 74 78 74 20 28 63 6f 6e 63 et! outtxt (conc
27a0: 20 6f 75 74 74 78 74 20 22 3c 68 74 6d 6c 3e 3c outtxt "<html><
27b0: 74 69 74 6c 65 3e 53 75 6d 6d 61 72 79 3a 20 22 title>Summary: "
27c0: 20 74 65 73 74 2d 6e 61 6d 65 20 0a 09 09 09 09 test-name .....
27d0: 20 20 20 22 3c 2f 74 69 74 6c 65 3e 3c 62 6f 64 "</title><bod
27e0: 79 3e 3c 68 32 3e 53 75 6d 6d 61 72 79 20 66 6f y><h2>Summary fo
27f0: 72 20 22 20 74 65 73 74 2d 6e 61 6d 65 20 22 3c r " test-name "<
2800: 2f 68 32 3e 22 29 29 0a 09 09 28 73 71 6c 69 74 /h2>"))...(sqlit
2810: 65 33 3a 66 6f 72 2d 65 61 63 68 2d 72 6f 77 20 e3:for-each-row
2820: 0a 09 09 20 28 6c 61 6d 62 64 61 20 28 69 64 20 ... (lambda (id
2830: 69 74 65 6d 70 61 74 68 20 73 74 61 74 65 20 73 itempath state s
2840: 74 61 74 75 73 20 72 75 6e 5f 64 75 72 61 74 69 tatus run_durati
2850: 6f 6e 20 6c 6f 67 66 20 63 6f 6d 6d 65 6e 74 29 on logf comment)
2860: 0a 09 09 20 20 20 28 68 61 73 68 2d 74 61 62 6c ... (hash-tabl
2870: 65 2d 73 65 74 21 20 63 6f 75 6e 74 73 20 73 74 e-set! counts st
2880: 61 74 75 73 20 28 2b 20 31 20 28 68 61 73 68 2d atus (+ 1 (hash-
2890: 74 61 62 6c 65 2d 72 65 66 2f 64 65 66 61 75 6c table-ref/defaul
28a0: 74 20 63 6f 75 6e 74 73 20 73 74 61 74 75 73 20 t counts status
28b0: 30 29 29 29 0a 09 09 20 20 20 28 68 61 73 68 2d 0)))... (hash-
28c0: 74 61 62 6c 65 2d 73 65 74 21 20 73 74 61 74 65 table-set! state
28d0: 63 6f 75 6e 74 73 20 73 74 61 74 65 20 28 2b 20 counts state (+
28e0: 31 20 28 68 61 73 68 2d 74 61 62 6c 65 2d 72 65 1 (hash-table-re
28f0: 66 2f 64 65 66 61 75 6c 74 20 73 74 61 74 65 63 f/default statec
2900: 6f 75 6e 74 73 20 73 74 61 74 65 20 30 29 29 29 ounts state 0)))
2910: 0a 09 09 20 20 20 28 73 65 74 21 20 6f 75 74 74 ... (set! outt
2920: 78 74 20 28 63 6f 6e 63 20 6f 75 74 74 78 74 20 xt (conc outtxt
2930: 22 3c 74 72 3e 22 0a 09 09 09 09 20 20 20 20 20 "<tr>".....
2940: 20 22 3c 74 64 3e 3c 61 20 68 72 65 66 3d 5c 22 "<td><a href=\"
2950: 22 20 69 74 65 6d 70 61 74 68 20 22 2f 22 20 6c " itempath "/" l
2960: 6f 67 66 20 22 5c 22 3e 20 22 20 69 74 65 6d 70 ogf "\"> " itemp
2970: 61 74 68 20 22 3c 2f 61 3e 3c 2f 74 64 3e 22 20 ath "</a></td>"
2980: 0a 09 09 09 09 20 20 20 20 20 20 22 3c 74 64 3e ..... "<td>
2990: 22 20 73 74 61 74 65 20 20 20 20 22 3c 2f 74 64 " state "</td
29a0: 3e 22 20 0a 09 09 09 09 20 20 20 20 20 20 22 3c >" ..... "<
29b0: 74 64 3e 3c 66 6f 6e 74 20 63 6f 6c 6f 72 3d 22 td><font color="
29c0: 20 28 63 6f 6d 6d 6f 6e 3a 67 65 74 2d 63 6f 6c (common:get-col
29d0: 6f 72 2d 66 72 6f 6d 2d 73 74 61 74 75 73 20 73 or-from-status s
29e0: 74 61 74 75 73 29 0a 09 09 09 09 20 20 20 20 20 tatus).....
29f0: 20 22 3e 22 20 20 20 73 74 61 74 75 73 20 20 20 ">" status
2a00: 22 3c 2f 66 6f 6e 74 3e 3c 2f 74 64 3e 22 0a 09 "</font></td>"..
2a10: 09 09 09 20 20 20 20 20 20 22 3c 74 64 3e 22 20 ... "<td>"
2a20: 28 69 66 20 28 65 71 75 61 6c 3f 20 63 6f 6d 6d (if (equal? comm
2a30: 65 6e 74 20 22 22 29 0a 09 09 09 09 09 09 20 22 ent "")....... "
2a40: 26 6e 62 73 70 3b 22 0a 09 09 09 09 09 09 20 63 "....... c
2a50: 6f 6d 6d 65 6e 74 29 20 22 3c 2f 74 64 3e 22 0a omment) "</td>".
2a60: 09 09 09 09 09 09 20 22 3c 2f 74 72 3e 22 29 29 ...... "</tr>"))
2a70: 29 0a 09 09 20 64 62 0a 09 09 20 22 53 45 4c 45 )... db... "SELE
2a80: 43 54 20 69 64 2c 69 74 65 6d 5f 70 61 74 68 2c CT id,item_path,
2a90: 73 74 61 74 65 2c 73 74 61 74 75 73 2c 72 75 6e state,status,run
2aa0: 5f 64 75 72 61 74 69 6f 6e 2c 66 69 6e 61 6c 5f _duration,final_
2ab0: 6c 6f 67 66 2c 63 6f 6d 6d 65 6e 74 20 46 52 4f logf,comment FRO
2ac0: 4d 20 74 65 73 74 73 20 57 48 45 52 45 20 72 75 M tests WHERE ru
2ad0: 6e 5f 69 64 3d 3f 20 41 4e 44 20 74 65 73 74 6e n_id=? AND testn
2ae0: 61 6d 65 3d 3f 20 41 4e 44 20 69 74 65 6d 5f 70 ame=? AND item_p
2af0: 61 74 68 20 21 3d 20 27 27 3b 22 0a 09 09 20 72 ath != '';"... r
2b00: 75 6e 2d 69 64 20 74 65 73 74 2d 6e 61 6d 65 29 un-id test-name)
2b10: 0a 0a 09 09 28 70 72 69 6e 74 20 22 3c 74 61 62 ....(print "<tab
2b20: 6c 65 3e 3c 74 72 3e 3c 74 64 20 76 61 6c 69 67 le><tr><td valig
2b30: 6e 3d 5c 22 74 6f 70 5c 22 3e 22 29 0a 09 09 3b n=\"top\">")...;
2b40: 3b 20 50 72 69 6e 74 20 6f 75 74 20 73 74 61 74 ; Print out stat
2b50: 73 20 66 6f 72 20 73 74 61 74 75 73 0a 09 09 28 s for status...(
2b60: 73 65 74 21 20 74 6f 74 20 30 29 0a 09 09 28 70 set! tot 0)...(p
2b70: 72 69 6e 74 20 22 3c 74 61 62 6c 65 20 63 65 6c rint "<table cel
2b80: 6c 73 70 61 63 69 6e 67 3d 5c 22 30 5c 22 20 62 lspacing=\"0\" b
2b90: 6f 72 64 65 72 3d 5c 22 31 5c 22 3e 3c 74 72 3e order=\"1\"><tr>
2ba0: 3c 74 64 20 63 6f 6c 73 70 61 6e 3d 5c 22 32 5c <td colspan=\"2\
2bb0: 22 3e 3c 68 32 3e 53 74 61 74 65 20 73 74 61 74 "><h2>State stat
2bc0: 73 3c 2f 68 32 3e 3c 2f 74 64 3e 3c 2f 74 72 3e s</h2></td></tr>
2bd0: 22 29 0a 09 09 28 66 6f 72 2d 65 61 63 68 20 28 ")...(for-each (
2be0: 6c 61 6d 62 64 61 20 28 73 74 61 74 65 29 0a 09 lambda (state)..
2bf0: 09 09 20 20 20 20 28 73 65 74 21 20 74 6f 74 20 .. (set! tot
2c00: 28 2b 20 74 6f 74 20 28 68 61 73 68 2d 74 61 62 (+ tot (hash-tab
2c10: 6c 65 2d 72 65 66 20 73 74 61 74 65 63 6f 75 6e le-ref statecoun
2c20: 74 73 20 73 74 61 74 65 29 29 29 0a 09 09 09 20 ts state)))....
2c30: 20 20 20 28 70 72 69 6e 74 20 22 3c 74 72 3e 3c (print "<tr><
2c40: 74 64 3e 22 20 73 74 61 74 65 20 22 3c 2f 74 64 td>" state "</td
2c50: 3e 3c 74 64 3e 22 20 28 68 61 73 68 2d 74 61 62 ><td>" (hash-tab
2c60: 6c 65 2d 72 65 66 20 73 74 61 74 65 63 6f 75 6e le-ref statecoun
2c70: 74 73 20 73 74 61 74 65 29 20 22 3c 2f 74 64 3e ts state) "</td>
2c80: 3c 2f 74 72 3e 22 29 29 0a 09 09 09 20 20 28 68 </tr>")).... (h
2c90: 61 73 68 2d 74 61 62 6c 65 2d 6b 65 79 73 20 73 ash-table-keys s
2ca0: 74 61 74 65 63 6f 75 6e 74 73 29 29 0a 09 09 28 tatecounts))...(
2cb0: 70 72 69 6e 74 20 22 3c 74 72 3e 3c 74 64 3e 54 print "<tr><td>T
2cc0: 6f 74 61 6c 3c 2f 74 64 3e 3c 74 64 3e 22 20 74 otal</td><td>" t
2cd0: 6f 74 20 22 3c 2f 74 64 3e 3c 2f 74 72 3e 3c 2f ot "</td></tr></
2ce0: 74 61 62 6c 65 3e 22 29 0a 09 09 28 70 72 69 6e table>")...(prin
2cf0: 74 20 22 3c 2f 74 64 3e 3c 74 64 20 76 61 6c 69 t "</td><td vali
2d00: 67 6e 3d 5c 22 74 6f 70 5c 22 3e 22 29 0a 09 09 gn=\"top\">")...
2d10: 3b 3b 20 50 72 69 6e 74 20 6f 75 74 20 73 74 61 ;; Print out sta
2d20: 74 73 20 66 6f 72 20 73 74 61 74 65 0a 09 09 28 ts for state...(
2d30: 73 65 74 21 20 74 6f 74 20 30 29 0a 09 09 28 70 set! tot 0)...(p
2d40: 72 69 6e 74 20 22 3c 74 61 62 6c 65 20 63 65 6c rint "<table cel
2d50: 6c 73 70 61 63 69 6e 67 3d 5c 22 30 5c 22 20 62 lspacing=\"0\" b
2d60: 6f 72 64 65 72 3d 5c 22 31 5c 22 3e 3c 74 72 3e order=\"1\"><tr>
2d70: 3c 74 64 20 63 6f 6c 73 70 61 6e 3d 5c 22 32 5c <td colspan=\"2\
2d80: 22 3e 3c 68 32 3e 53 74 61 74 75 73 20 73 74 61 "><h2>Status sta
2d90: 74 73 3c 2f 68 32 3e 3c 2f 74 64 3e 3c 2f 74 72 ts</h2></td></tr
2da0: 3e 22 29 0a 09 09 28 66 6f 72 2d 65 61 63 68 20 >")...(for-each
2db0: 28 6c 61 6d 62 64 61 20 28 73 74 61 74 75 73 29 (lambda (status)
2dc0: 0a 09 09 09 20 20 20 20 28 73 65 74 21 20 74 6f .... (set! to
2dd0: 74 20 28 2b 20 74 6f 74 20 28 68 61 73 68 2d 74 t (+ tot (hash-t
2de0: 61 62 6c 65 2d 72 65 66 20 63 6f 75 6e 74 73 20 able-ref counts
2df0: 73 74 61 74 75 73 29 29 29 0a 09 09 09 20 20 20 status)))....
2e00: 20 28 70 72 69 6e 74 20 22 3c 74 72 3e 3c 74 64 (print "<tr><td
2e10: 3e 3c 66 6f 6e 74 20 63 6f 6c 6f 72 3d 5c 22 22 ><font color=\""
2e20: 20 28 63 6f 6d 6d 6f 6e 3a 67 65 74 2d 63 6f 6c (common:get-col
2e30: 6f 72 2d 66 72 6f 6d 2d 73 74 61 74 75 73 20 73 or-from-status s
2e40: 74 61 74 75 73 29 20 22 5c 22 3e 22 20 73 74 61 tatus) "\">" sta
2e50: 74 75 73 0a 09 09 09 09 20 20 20 22 3c 2f 66 6f tus..... "</fo
2e60: 6e 74 3e 3c 2f 74 64 3e 3c 74 64 3e 22 20 28 68 nt></td><td>" (h
2e70: 61 73 68 2d 74 61 62 6c 65 2d 72 65 66 20 63 6f ash-table-ref co
2e80: 75 6e 74 73 20 73 74 61 74 75 73 29 20 22 3c 2f unts status) "</
2e90: 74 64 3e 3c 2f 74 72 3e 22 29 29 0a 09 09 09 20 td></tr>"))....
2ea0: 20 28 68 61 73 68 2d 74 61 62 6c 65 2d 6b 65 79 (hash-table-key
2eb0: 73 20 63 6f 75 6e 74 73 29 29 0a 09 09 28 70 72 s counts))...(pr
2ec0: 69 6e 74 20 22 3c 74 72 3e 3c 74 64 3e 54 6f 74 int "<tr><td>Tot
2ed0: 61 6c 3c 2f 74 64 3e 3c 74 64 3e 22 20 74 6f 74 al</td><td>" tot
2ee0: 20 22 3c 2f 74 64 3e 3c 2f 74 72 3e 3c 2f 74 61 "</td></tr></ta
2ef0: 62 6c 65 3e 22 29 0a 09 09 28 70 72 69 6e 74 20 ble>")...(print
2f00: 22 3c 2f 74 64 3e 3c 2f 74 64 3e 3c 2f 74 72 3e "</td></td></tr>
2f10: 3c 2f 74 61 62 6c 65 3e 22 29 0a 0a 09 09 28 70 </table>")....(p
2f20: 72 69 6e 74 20 22 3c 74 61 62 6c 65 20 63 65 6c rint "<table cel
2f30: 6c 73 70 61 63 69 6e 67 3d 5c 22 30 5c 22 20 62 lspacing=\"0\" b
2f40: 6f 72 64 65 72 3d 5c 22 31 5c 22 3e 22 20 0a 09 order=\"1\">" ..
2f50: 09 20 20 20 20 20 20 20 22 3c 74 72 3e 3c 74 64 . "<tr><td
2f60: 3e 49 74 65 6d 3c 2f 74 64 3e 3c 74 64 3e 53 74 >Item</td><td>St
2f70: 61 74 65 3c 2f 74 64 3e 3c 74 64 3e 53 74 61 74 ate</td><td>Stat
2f80: 75 73 3c 2f 74 64 3e 3c 74 64 3e 43 6f 6d 6d 65 us</td><td>Comme
2f90: 6e 74 3c 2f 74 64 3e 22 0a 09 09 20 20 20 20 20 nt</td>"...
2fa0: 20 20 6f 75 74 74 78 74 20 22 3c 2f 74 61 62 6c outtxt "</tabl
2fb0: 65 3e 3c 2f 62 6f 64 79 3e 3c 2f 68 74 6d 6c 3e e></body></html>
2fc0: 22 29 0a 09 09 28 72 65 6c 65 61 73 65 2d 64 6f ")...(release-do
2fd0: 74 2d 6c 6f 63 6b 20 6f 75 74 70 75 74 66 69 6c t-lock outputfil
2fe0: 65 6e 61 6d 65 29 29 29 0a 09 20 20 20 20 28 63 ename))).. (c
2ff0: 6c 6f 73 65 2d 6f 75 74 70 75 74 2d 70 6f 72 74 lose-output-port
3000: 20 6f 75 70 29 0a 09 20 20 20 20 28 63 68 61 6e oup).. (chan
3010: 67 65 2d 64 69 72 65 63 74 6f 72 79 20 6f 72 69 ge-directory ori
3020: 67 2d 64 69 72 29 0a 09 20 20 20 20 28 74 65 73 g-dir).. (tes
3030: 74 2d 73 65 74 2d 74 6f 70 6c 6f 67 21 20 64 62 t-set-toplog! db
3040: 20 72 75 6e 2d 69 64 20 74 65 73 74 2d 6e 61 6d run-id test-nam
3050: 65 20 6f 75 74 70 75 74 66 69 6c 65 6e 61 6d 65 e outputfilename
3060: 29 0a 09 20 20 20 20 29 29 29 29 29 0a 0a 28 64 ).. )))))..(d
3070: 65 66 69 6e 65 20 28 67 65 74 2d 61 6c 6c 2d 6c efine (get-all-l
3080: 65 67 61 6c 2d 74 65 73 74 73 29 0a 20 20 28 6c egal-tests). (l
3090: 65 74 2a 20 28 28 74 65 73 74 73 20 20 28 67 6c et* ((tests (gl
30a0: 6f 62 20 28 63 6f 6e 63 20 2a 74 6f 70 70 61 74 ob (conc *toppat
30b0: 68 2a 20 22 2f 74 65 73 74 73 2f 2a 22 29 29 29 h* "/tests/*")))
30c0: 0a 09 20 28 72 65 73 20 20 20 20 27 28 29 29 29 .. (res '()))
30d0: 0a 20 20 20 20 28 64 65 62 75 67 3a 70 72 69 6e . (debug:prin
30e0: 74 20 34 20 22 49 4e 46 4f 3a 20 4c 6f 6f 6b 69 t 4 "INFO: Looki
30f0: 6e 67 20 61 74 20 74 65 73 74 73 20 22 20 28 73 ng at tests " (s
3100: 74 72 69 6e 67 2d 69 6e 74 65 72 73 70 65 72 73 tring-interspers
3110: 65 20 74 65 73 74 73 20 22 2c 22 29 29 0a 20 20 e tests ",")).
3120: 20 20 28 66 6f 72 2d 65 61 63 68 20 28 6c 61 6d (for-each (lam
3130: 62 64 61 20 28 74 65 73 74 70 61 74 68 29 0a 09 bda (testpath)..
3140: 09 28 69 66 20 28 66 69 6c 65 2d 65 78 69 73 74 .(if (file-exist
3150: 73 3f 20 28 63 6f 6e 63 20 74 65 73 74 70 61 74 s? (conc testpat
3160: 68 20 22 2f 74 65 73 74 63 6f 6e 66 69 67 22 29 h "/testconfig")
3170: 29 0a 09 09 20 20 20 20 28 73 65 74 21 20 72 65 )... (set! re
3180: 73 20 28 63 6f 6e 73 20 28 6c 61 73 74 20 28 73 s (cons (last (s
3190: 74 72 69 6e 67 2d 73 70 6c 69 74 20 74 65 73 74 tring-split test
31a0: 70 61 74 68 20 22 2f 22 29 29 20 72 65 73 29 29 path "/")) res))
31b0: 29 29 0a 09 20 20 20 20 20 20 74 65 73 74 73 29 )).. tests)
31c0: 0a 20 20 20 20 72 65 73 29 29 0a 0a 28 64 65 66 . res))..(def
31d0: 69 6e 65 20 28 74 65 73 74 3a 67 65 74 2d 74 65 ine (test:get-te
31e0: 73 74 63 6f 6e 66 69 67 20 74 65 73 74 2d 6e 61 stconfig test-na
31f0: 6d 65 20 73 79 73 74 65 6d 2d 61 6c 6c 6f 77 65 me system-allowe
3200: 64 29 0a 20 20 28 6c 65 74 2a 20 28 28 74 65 73 d). (let* ((tes
3210: 74 2d 70 61 74 68 20 20 20 20 28 63 6f 6e 63 20 t-path (conc
3220: 2a 74 6f 70 70 61 74 68 2a 20 22 2f 74 65 73 74 *toppath* "/test
3230: 73 2f 22 20 74 65 73 74 2d 6e 61 6d 65 29 29 0a s/" test-name)).
3240: 09 20 28 74 65 73 74 2d 63 6f 6e 66 69 67 66 20 . (test-configf
3250: 28 63 6f 6e 63 20 74 65 73 74 2d 70 61 74 68 20 (conc test-path
3260: 22 2f 74 65 73 74 63 6f 6e 66 69 67 22 29 29 0a "/testconfig")).
3270: 09 20 28 74 65 73 74 65 78 69 73 74 73 20 20 20 . (testexists
3280: 28 61 6e 64 20 28 66 69 6c 65 2d 65 78 69 73 74 (and (file-exist
3290: 73 3f 20 74 65 73 74 2d 63 6f 6e 66 69 67 66 29 s? test-configf)
32a0: 28 66 69 6c 65 2d 72 65 61 64 2d 61 63 63 65 73 (file-read-acces
32b0: 73 3f 20 74 65 73 74 2d 63 6f 6e 66 69 67 66 29 s? test-configf)
32c0: 29 29 29 0a 20 20 20 20 28 69 66 20 74 65 73 74 ))). (if test
32d0: 65 78 69 73 74 73 0a 09 28 72 65 61 64 2d 63 6f exists..(read-co
32e0: 6e 66 69 67 20 74 65 73 74 2d 63 6f 6e 66 69 67 nfig test-config
32f0: 66 20 23 66 20 73 79 73 74 65 6d 2d 61 6c 6c 6f f #f system-allo
3300: 77 65 64 20 65 6e 76 69 72 6f 6e 2d 70 61 74 74 wed environ-patt
3310: 3a 20 28 69 66 20 73 79 73 74 65 6d 2d 61 6c 6c : (if system-all
3320: 6f 77 65 64 0a 09 09 09 09 09 09 09 09 20 20 20 owed.........
3330: 20 20 20 22 70 72 65 2d 6c 61 75 6e 63 68 2d 65 "pre-launch-e
3340: 6e 76 2d 76 61 72 73 22 0a 09 09 09 09 09 09 09 nv-vars"........
3350: 09 20 20 20 20 20 20 23 66 29 29 0a 09 23 66 29 . #f))..#f)
3360: 29 29 0a 20 20 0a 3b 3b 20 73 6f 72 74 20 74 65 )). .;; sort te
3370: 73 74 73 20 62 79 20 70 72 69 6f 72 69 74 79 20 sts by priority
3380: 61 6e 64 20 77 61 69 74 6f 6e 0a 3b 3b 20 4d 6f and waiton.;; Mo
3390: 76 65 20 74 65 73 74 20 73 70 65 63 69 66 69 63 ve test specific
33a0: 20 73 74 75 66 66 20 74 6f 20 61 20 74 65 73 74 stuff to a test
33b0: 20 75 6e 69 74 20 46 49 58 4d 45 20 6f 6e 65 20 unit FIXME one
33c0: 6f 66 20 74 68 65 73 65 20 64 61 79 73 0a 28 64 of these days.(d
33d0: 65 66 69 6e 65 20 28 74 65 73 74 73 3a 73 6f 72 efine (tests:sor
33e0: 74 2d 62 79 2d 70 72 69 6f 72 69 74 79 2d 61 6e t-by-priority-an
33f0: 64 2d 77 61 69 74 6f 6e 20 74 65 73 74 2d 72 65 d-waiton test-re
3400: 63 6f 72 64 73 29 0a 20 20 28 6c 65 74 20 28 28 cords). (let ((
3410: 6d 75 6e 67 65 70 72 69 6f 72 69 74 79 20 28 6c mungepriority (l
3420: 61 6d 62 64 61 20 28 70 72 69 6f 72 69 74 79 29 ambda (priority)
3430: 0a 09 09 09 20 28 69 66 20 70 72 69 6f 72 69 74 .... (if priorit
3440: 79 0a 09 09 09 20 20 20 20 20 28 6c 65 74 20 28 y.... (let (
3450: 28 74 6d 70 20 28 61 6e 79 2d 3e 6e 75 6d 62 65 (tmp (any->numbe
3460: 72 20 70 72 69 6f 72 69 74 79 29 29 29 0a 09 09 r priority)))...
3470: 09 20 20 20 20 20 20 20 28 69 66 20 74 6d 70 20 . (if tmp
3480: 74 6d 70 20 28 62 65 67 69 6e 20 28 64 65 62 75 tmp (begin (debu
3490: 67 3a 70 72 69 6e 74 20 30 20 22 45 52 52 4f 52 g:print 0 "ERROR
34a0: 3a 20 62 61 64 20 70 72 69 6f 72 69 74 79 20 76 : bad priority v
34b0: 61 6c 75 65 20 22 20 70 72 69 6f 72 69 74 79 20 alue " priority
34c0: 22 2c 20 75 73 69 6e 67 20 30 22 29 20 30 29 29 ", using 0") 0))
34d0: 29 0a 09 09 09 20 20 20 20 20 30 29 29 29 29 0a ).... 0)))).
34e0: 20 20 20 20 28 73 6f 72 74 20 0a 20 20 20 20 20 (sort .
34f0: 28 68 61 73 68 2d 74 61 62 6c 65 2d 6b 65 79 73 (hash-table-keys
3500: 20 74 65 73 74 2d 72 65 63 6f 72 64 73 29 20 3b test-records) ;
3510: 3b 20 61 76 6f 69 64 20 64 65 61 6c 69 6e 67 20 ; avoid dealing
3520: 77 69 74 68 20 64 65 6c 65 74 65 64 20 74 65 73 with deleted tes
3530: 74 73 2c 20 6c 6f 6f 6b 20 61 74 20 74 68 65 20 ts, look at the
3540: 68 61 73 68 20 74 61 62 6c 65 0a 20 20 20 20 20 hash table.
3550: 28 6c 61 6d 62 64 61 20 28 61 20 62 29 0a 20 20 (lambda (a b).
3560: 20 20 20 20 20 28 6c 65 74 2a 20 28 28 61 2d 72 (let* ((a-r
3570: 65 63 6f 72 64 20 20 20 28 68 61 73 68 2d 74 61 ecord (hash-ta
3580: 62 6c 65 2d 72 65 66 20 74 65 73 74 2d 72 65 63 ble-ref test-rec
3590: 6f 72 64 73 20 61 29 29 0a 09 20 20 20 20 20 20 ords a))..
35a0: 28 62 2d 72 65 63 6f 72 64 20 20 20 28 68 61 73 (b-record (has
35b0: 68 2d 74 61 62 6c 65 2d 72 65 66 20 74 65 73 74 h-table-ref test
35c0: 2d 72 65 63 6f 72 64 73 20 62 29 29 0a 09 20 20 -records b))..
35d0: 20 20 20 20 28 61 2d 77 61 69 74 6f 6e 73 20 20 (a-waitons
35e0: 28 74 65 73 74 73 3a 74 65 73 74 71 75 65 75 65 (tests:testqueue
35f0: 2d 67 65 74 2d 77 61 69 74 6f 6e 73 20 61 2d 72 -get-waitons a-r
3600: 65 63 6f 72 64 29 29 0a 09 20 20 20 20 20 20 28 ecord)).. (
3610: 62 2d 77 61 69 74 6f 6e 73 20 20 28 74 65 73 74 b-waitons (test
3620: 73 3a 74 65 73 74 71 75 65 75 65 2d 67 65 74 2d s:testqueue-get-
3630: 77 61 69 74 6f 6e 73 20 62 2d 72 65 63 6f 72 64 waitons b-record
3640: 29 29 0a 09 20 20 20 20 20 20 28 61 2d 63 6f 6e )).. (a-con
3650: 66 69 67 20 20 20 28 74 65 73 74 73 3a 74 65 73 fig (tests:tes
3660: 74 71 75 65 75 65 2d 67 65 74 2d 74 65 73 74 63 tqueue-get-testc
3670: 6f 6e 66 69 67 20 20 61 2d 72 65 63 6f 72 64 29 onfig a-record)
3680: 29 0a 09 20 20 20 20 20 20 28 62 2d 63 6f 6e 66 ).. (b-conf
3690: 69 67 20 20 20 28 74 65 73 74 73 3a 74 65 73 74 ig (tests:test
36a0: 71 75 65 75 65 2d 67 65 74 2d 74 65 73 74 63 6f queue-get-testco
36b0: 6e 66 69 67 20 20 62 2d 72 65 63 6f 72 64 29 29 nfig b-record))
36c0: 0a 09 20 20 20 20 20 20 28 61 2d 72 61 77 2d 70 .. (a-raw-p
36d0: 72 69 20 20 28 63 6f 6e 66 69 67 2d 6c 6f 6f 6b ri (config-look
36e0: 75 70 20 61 2d 63 6f 6e 66 69 67 20 22 72 65 71 up a-config "req
36f0: 75 69 72 65 6d 65 6e 74 73 22 20 22 70 72 69 6f uirements" "prio
3700: 72 69 74 79 22 29 29 0a 09 20 20 20 20 20 20 28 rity")).. (
3710: 62 2d 72 61 77 2d 70 72 69 20 20 28 63 6f 6e 66 b-raw-pri (conf
3720: 69 67 2d 6c 6f 6f 6b 75 70 20 62 2d 63 6f 6e 66 ig-lookup b-conf
3730: 69 67 20 22 72 65 71 75 69 72 65 6d 65 6e 74 73 ig "requirements
3740: 22 20 22 70 72 69 6f 72 69 74 79 22 29 29 0a 09 " "priority"))..
3750: 20 20 20 20 20 20 28 61 2d 70 72 69 6f 72 69 74 (a-priorit
3760: 79 20 28 6d 75 6e 67 65 70 72 69 6f 72 69 74 79 y (mungepriority
3770: 20 61 2d 72 61 77 2d 70 72 69 29 29 0a 09 20 20 a-raw-pri))..
3780: 20 20 20 20 28 62 2d 70 72 69 6f 72 69 74 79 20 (b-priority
3790: 28 6d 75 6e 67 65 70 72 69 6f 72 69 74 79 20 62 (mungepriority b
37a0: 2d 72 61 77 2d 70 72 69 29 29 29 0a 09 3b 3b 20 -raw-pri)))..;;
37b0: 20 28 64 65 62 75 67 3a 70 72 69 6e 74 20 35 20 (debug:print 5
37c0: 22 73 6f 72 74 2d 62 79 2d 70 72 69 6f 72 69 74 "sort-by-priorit
37d0: 79 2d 61 6e 64 2d 77 61 69 74 6f 6e 2c 20 61 3a y-and-waiton, a:
37e0: 20 22 20 61 20 22 20 62 3a 20 22 20 62 0a 09 3b " a " b: " b..;
37f0: 3b 20 09 20 20 20 20 20 20 22 5c 6e 20 20 20 20 ; . "\n
3800: 20 61 2d 72 65 63 6f 72 64 3a 20 20 20 22 20 61 a-record: " a
3810: 2d 72 65 63 6f 72 64 20 0a 09 3b 3b 20 09 20 20 -record ..;; .
3820: 20 20 20 20 22 5c 6e 20 20 20 20 20 62 2d 72 65 "\n b-re
3830: 63 6f 72 64 3a 20 20 20 22 20 62 2d 72 65 63 6f cord: " b-reco
3840: 72 64 0a 09 3b 3b 20 09 20 20 20 20 20 20 22 5c rd..;; . "\
3850: 6e 20 20 20 20 20 61 2d 77 61 69 74 6f 6e 73 3a n a-waitons:
3860: 20 20 22 20 61 2d 77 61 69 74 6f 6e 73 0a 09 3b " a-waitons..;
3870: 3b 20 09 20 20 20 20 20 20 22 5c 6e 20 20 20 20 ; . "\n
3880: 20 62 2d 77 61 69 74 6f 6e 73 3a 20 20 22 20 62 b-waitons: " b
3890: 2d 77 61 69 74 6f 6e 73 0a 09 3b 3b 20 09 20 20 -waitons..;; .
38a0: 20 20 20 20 22 5c 6e 20 20 20 20 20 61 2d 63 6f "\n a-co
38b0: 6e 66 69 67 3a 20 20 20 22 20 28 68 61 73 68 2d nfig: " (hash-
38c0: 74 61 62 6c 65 2d 3e 61 6c 69 73 74 20 61 2d 63 table->alist a-c
38d0: 6f 6e 66 69 67 29 0a 09 3b 3b 20 09 20 20 20 20 onfig)..;; .
38e0: 20 20 22 5c 6e 20 20 20 20 20 62 2d 63 6f 6e 66 "\n b-conf
38f0: 69 67 3a 20 20 20 22 20 28 68 61 73 68 2d 74 61 ig: " (hash-ta
3900: 62 6c 65 2d 3e 61 6c 69 73 74 20 62 2d 63 6f 6e ble->alist b-con
3910: 66 69 67 29 0a 09 3b 3b 20 09 20 20 20 20 20 20 fig)..;; .
3920: 22 5c 6e 20 20 20 20 20 61 2d 72 61 77 2d 70 72 "\n a-raw-pr
3930: 69 3a 20 20 22 20 61 2d 72 61 77 2d 70 72 69 0a i: " a-raw-pri.
3940: 09 3b 3b 20 09 20 20 20 20 20 20 22 5c 6e 20 20 .;; . "\n
3950: 20 20 20 62 2d 72 61 77 2d 70 72 69 3a 20 20 22 b-raw-pri: "
3960: 20 62 2d 72 61 77 2d 70 72 69 0a 09 3b 3b 20 09 b-raw-pri..;; .
3970: 20 20 20 20 20 20 22 5c 6e 20 20 20 20 20 61 2d "\n a-
3980: 70 72 69 6f 72 69 74 79 3a 20 22 20 61 2d 70 72 priority: " a-pr
3990: 69 6f 72 69 74 79 0a 09 3b 3b 20 09 20 20 20 20 iority..;; .
39a0: 20 20 22 5c 6e 20 20 20 20 20 62 2d 70 72 69 6f "\n b-prio
39b0: 72 69 74 79 3a 20 22 20 62 2d 70 72 69 6f 72 69 rity: " b-priori
39c0: 74 79 29 0a 09 20 28 74 65 73 74 73 3a 74 65 73 ty).. (tests:tes
39d0: 74 71 75 65 75 65 2d 73 65 74 2d 70 72 69 6f 72 tqueue-set-prior
39e0: 69 74 79 21 20 61 2d 72 65 63 6f 72 64 20 61 2d ity! a-record a-
39f0: 70 72 69 6f 72 69 74 79 29 0a 09 20 28 74 65 73 priority).. (tes
3a00: 74 73 3a 74 65 73 74 71 75 65 75 65 2d 73 65 74 ts:testqueue-set
3a10: 2d 70 72 69 6f 72 69 74 79 21 20 62 2d 72 65 63 -priority! b-rec
3a20: 6f 72 64 20 62 2d 70 72 69 6f 72 69 74 79 29 0a ord b-priority).
3a30: 09 20 28 69 66 20 28 61 6e 64 20 61 2d 77 61 69 . (if (and a-wai
3a40: 74 6f 6e 73 20 28 6d 65 6d 62 65 72 20 28 74 65 tons (member (te
3a50: 73 74 73 3a 74 65 73 74 71 75 65 75 65 2d 67 65 sts:testqueue-ge
3a60: 74 2d 74 65 73 74 6e 61 6d 65 20 62 2d 72 65 63 t-testname b-rec
3a70: 6f 72 64 29 20 61 2d 77 61 69 74 6f 6e 73 29 29 ord) a-waitons))
3a80: 0a 09 20 20 20 20 20 23 66 20 3b 3b 20 63 61 6e .. #f ;; can
3a90: 6e 6f 74 20 68 61 76 65 20 61 20 77 68 69 63 68 not have a which
3aa0: 20 69 73 20 77 61 69 74 69 6e 67 20 6f 6e 20 62 is waiting on b
3ab0: 20 68 61 70 70 65 6e 69 6e 67 20 62 65 66 6f 72 happening befor
3ac0: 65 20 62 0a 09 20 20 20 20 20 28 69 66 20 28 61 e b.. (if (a
3ad0: 6e 64 20 62 2d 77 61 69 74 6f 6e 73 20 28 6d 65 nd b-waitons (me
3ae0: 6d 62 65 72 20 28 74 65 73 74 73 3a 74 65 73 74 mber (tests:test
3af0: 71 75 65 75 65 2d 67 65 74 2d 74 65 73 74 6e 61 queue-get-testna
3b00: 6d 65 20 61 2d 72 65 63 6f 72 64 29 20 62 2d 77 me a-record) b-w
3b10: 61 69 74 6f 6e 73 29 29 0a 09 09 20 23 74 20 3b aitons))... #t ;
3b20: 3b 20 74 68 69 73 20 69 73 20 74 68 65 20 63 6f ; this is the co
3b30: 72 72 65 63 74 20 6f 72 64 65 72 2c 20 62 20 69 rrect order, b i
3b40: 73 20 77 61 69 74 69 6e 67 20 6f 6e 20 61 20 61 s waiting on a a
3b50: 6e 64 20 62 20 69 73 20 62 65 66 6f 72 65 20 61 nd b is before a
3b60: 0a 09 09 20 28 69 66 20 28 3e 20 61 2d 70 72 69 ... (if (> a-pri
3b70: 6f 72 69 74 79 20 62 2d 70 72 69 6f 72 69 74 79 ority b-priority
3b80: 29 0a 09 09 20 20 20 20 20 23 74 20 3b 3b 20 69 )... #t ;; i
3b90: 66 20 61 20 69 73 20 61 20 68 69 67 68 65 72 20 f a is a higher
3ba0: 70 72 69 6f 72 69 74 79 20 74 68 61 6e 20 62 20 priority than b
3bb0: 74 68 65 6e 20 77 65 20 61 72 65 20 67 6f 6f 64 then we are good
3bc0: 20 74 6f 20 67 6f 0a 09 09 20 20 20 20 20 23 66 to go... #f
3bd0: 29 29 29 29 29 29 29 29 0a 0a 0a 3b 3b 3d 3d 3d ))))))))...;;===
3be0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
3bf0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
3c00: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
3c10: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
3c20: 3d 3d 3d 0a 3b 3b 20 74 65 73 74 20 73 74 65 70 ===.;; test step
3c30: 73 0a 3b 3b 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d s.;;============
3c40: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
3c50: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
3c60: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
3c70: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 0a 3b 3b 20 74 ==========..;; t
3c80: 65 73 74 73 74 65 70 2d 73 65 74 2d 73 74 61 74 eststep-set-stat
3c90: 75 73 21 20 75 73 65 64 20 74 6f 20 62 65 20 68 us! used to be h
3ca0: 65 72 65 0a 0a 28 64 65 66 69 6e 65 20 28 74 65 ere..(define (te
3cb0: 73 74 2d 67 65 74 2d 6b 69 6c 6c 2d 72 65 71 75 st-get-kill-requ
3cc0: 65 73 74 20 64 62 20 72 75 6e 2d 69 64 20 74 65 est db run-id te
3cd0: 73 74 2d 6e 61 6d 65 20 69 74 65 6d 64 61 74 29 st-name itemdat)
3ce0: 0a 20 20 28 6c 65 74 2a 20 28 28 69 74 65 6d 2d . (let* ((item-
3cf0: 70 61 74 68 20 28 69 74 65 6d 2d 6c 69 73 74 2d path (item-list-
3d00: 3e 70 61 74 68 20 69 74 65 6d 64 61 74 29 29 0a >path itemdat)).
3d10: 09 20 28 74 65 73 74 64 61 74 20 20 20 28 64 62 . (testdat (db
3d20: 3a 67 65 74 2d 74 65 73 74 2d 69 6e 66 6f 20 64 :get-test-info d
3d30: 62 20 72 75 6e 2d 69 64 20 74 65 73 74 2d 6e 61 b run-id test-na
3d40: 6d 65 20 69 74 65 6d 2d 70 61 74 68 29 29 29 0a me item-path))).
3d50: 20 20 20 20 28 65 71 75 61 6c 3f 20 28 74 65 73 (equal? (tes
3d60: 74 3a 67 65 74 2d 73 74 61 74 65 20 74 65 73 74 t:get-state test
3d70: 64 61 74 29 20 22 4b 49 4c 4c 52 45 51 22 29 29 dat) "KILLREQ"))
3d80: 29 0a 0a 28 64 65 66 69 6e 65 20 28 74 65 73 74 )..(define (test
3d90: 2d 73 65 74 2d 6d 65 74 61 2d 69 6e 66 6f 20 64 -set-meta-info d
3da0: 62 20 72 75 6e 2d 69 64 20 74 65 73 74 6e 61 6d b run-id testnam
3db0: 65 20 69 74 65 6d 64 61 74 29 0a 20 20 28 6c 65 e itemdat). (le
3dc0: 74 20 28 28 69 74 65 6d 2d 70 61 74 68 20 28 69 t ((item-path (i
3dd0: 74 65 6d 2d 6c 69 73 74 2d 3e 70 61 74 68 20 69 tem-list->path i
3de0: 74 65 6d 64 61 74 29 29 0a 09 28 63 70 75 6c 6f temdat))..(cpulo
3df0: 61 64 20 20 28 67 65 74 2d 63 70 75 2d 6c 6f 61 ad (get-cpu-loa
3e00: 64 29 29 0a 09 28 68 6f 73 74 6e 61 6d 65 20 28 d))..(hostname (
3e10: 67 65 74 2d 68 6f 73 74 2d 6e 61 6d 65 29 29 0a get-host-name)).
3e20: 09 28 64 69 73 6b 66 72 65 65 20 28 67 65 74 2d .(diskfree (get-
3e30: 64 66 20 28 63 75 72 72 65 6e 74 2d 64 69 72 65 df (current-dire
3e40: 63 74 6f 72 79 29 29 29 0a 09 28 75 6e 61 6d 65 ctory)))..(uname
3e50: 20 20 20 20 28 67 65 74 2d 75 6e 61 6d 65 20 22 (get-uname "
3e60: 2d 73 72 76 70 69 6f 22 29 29 0a 09 28 72 75 6e -srvpio"))..(run
3e70: 70 61 74 68 20 20 28 63 75 72 72 65 6e 74 2d 64 path (current-d
3e80: 69 72 65 63 74 6f 72 79 29 29 29 0a 20 20 20 20 irectory))).
3e90: 28 73 71 6c 69 74 65 33 3a 65 78 65 63 75 74 65 (sqlite3:execute
3ea0: 20 64 62 20 22 55 50 44 41 54 45 20 74 65 73 74 db "UPDATE test
3eb0: 73 20 53 45 54 20 68 6f 73 74 3d 3f 2c 63 70 75 s SET host=?,cpu
3ec0: 6c 6f 61 64 3d 3f 2c 64 69 73 6b 66 72 65 65 3d load=?,diskfree=
3ed0: 3f 2c 75 6e 61 6d 65 3d 3f 2c 72 75 6e 64 69 72 ?,uname=?,rundir
3ee0: 3d 3f 20 57 48 45 52 45 20 72 75 6e 5f 69 64 3d =? WHERE run_id=
3ef0: 3f 20 41 4e 44 20 74 65 73 74 6e 61 6d 65 3d 3f ? AND testname=?
3f00: 20 41 4e 44 20 69 74 65 6d 5f 70 61 74 68 3d 3f AND item_path=?
3f10: 3b 22 0a 09 09 20 20 68 6f 73 74 6e 61 6d 65 0a ;"... hostname.
3f20: 09 09 20 20 63 70 75 6c 6f 61 64 0a 09 09 20 20 .. cpuload...
3f30: 64 69 73 6b 66 72 65 65 0a 09 09 20 20 75 6e 61 diskfree... una
3f40: 6d 65 0a 09 09 20 20 72 75 6e 70 61 74 68 0a 09 me... runpath..
3f50: 09 20 20 72 75 6e 2d 69 64 0a 09 09 20 20 74 65 . run-id... te
3f60: 73 74 6e 61 6d 65 0a 09 09 20 20 69 74 65 6d 2d stname... item-
3f70: 70 61 74 68 29 29 29 0a 0a 3b 3b 3d 3d 3d 3d 3d path)))..;;=====
3f80: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
3f90: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
3fa0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
3fb0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
3fc0: 3d 0a 3b 3b 20 41 20 52 20 43 20 48 20 49 20 56 =.;; A R C H I V
3fd0: 20 49 20 4e 20 47 0a 3b 3b 3d 3d 3d 3d 3d 3d 3d I N G.;;=======
3fe0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
3ff0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
4000: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
4010: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a ===============.
4020: 0a 28 64 65 66 69 6e 65 20 28 74 65 73 74 3a 61 .(define (test:a
4030: 72 63 68 69 76 65 20 64 62 20 74 65 73 74 2d 69 rchive db test-i
4040: 64 29 0a 20 20 23 66 29 0a 0a 28 64 65 66 69 6e d). #f)..(defin
4050: 65 20 28 74 65 73 74 3a 61 72 63 68 69 76 65 2d e (test:archive-
4060: 74 65 73 74 73 20 64 62 20 6b 65 79 6e 61 6d 65 tests db keyname
4070: 73 20 74 61 72 67 65 74 29 0a 20 20 23 66 29 0a s target). #f).
4080: 0a 3b 3b 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d .;;=============
4090: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
40a0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
40b0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
40c0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 3b 3b 20 52 20 50 =========.;; R P
40d0: 20 43 0a 3b 3b 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d C.;;===========
40e0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
40f0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
4100: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
4110: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 0a 28 64 65 ===========..(de
4120: 66 69 6e 65 20 28 72 74 65 73 74 73 3a 72 65 67 fine (rtests:reg
4130: 69 73 74 65 72 2d 74 65 73 74 20 64 62 20 72 75 ister-test db ru
4140: 6e 2d 69 64 20 74 65 73 74 2d 6e 61 6d 65 20 69 n-id test-name i
4150: 74 65 6d 2d 70 61 74 68 29 0a 20 20 28 69 66 20 tem-path). (if
4160: 2a 72 75 6e 72 65 6d 6f 74 65 2a 0a 20 20 20 20 *runremote*.
4170: 20 20 28 6c 65 74 20 28 28 68 6f 73 74 20 28 76 (let ((host (v
4180: 65 63 74 6f 72 2d 72 65 66 20 2a 72 75 6e 72 65 ector-ref *runre
4190: 6d 6f 74 65 2a 20 30 29 29 0a 09 20 20 20 20 28 mote* 0)).. (
41a0: 70 6f 72 74 20 28 76 65 63 74 6f 72 2d 72 65 66 port (vector-ref
41b0: 20 2a 72 75 6e 72 65 6d 6f 74 65 2a 20 31 29 29 *runremote* 1))
41c0: 29 0a 09 28 28 72 70 63 3a 70 72 6f 63 65 64 75 )..((rpc:procedu
41d0: 72 65 20 27 72 74 65 73 74 73 3a 72 65 67 69 73 re 'rtests:regis
41e0: 74 65 72 2d 74 65 73 74 20 68 6f 73 74 20 70 6f ter-test host po
41f0: 72 74 29 20 72 75 6e 2d 69 64 20 74 65 73 74 2d rt) run-id test-
4200: 6e 61 6d 65 20 69 74 65 6d 2d 70 61 74 68 29 29 name item-path))
4210: 0a 20 20 20 20 20 20 28 74 65 73 74 73 3a 72 65 . (tests:re
4220: 67 69 73 74 65 72 2d 74 65 73 74 20 64 62 20 72 gister-test db r
4230: 75 6e 2d 69 64 20 74 65 73 74 2d 6e 61 6d 65 20 un-id test-name
4240: 69 74 65 6d 2d 70 61 74 68 29 29 29 0a item-path))).