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 29 0a 69 dot-locking).
0040: 28 69 6d 70 6f 72 74 20 28 70 72 65 66 69 78 20 (import (prefix
0050: 73 71 6c 69 74 65 33 20 73 71 6c 69 74 65 33 3a sqlite3 sqlite3:
0060: 29 29 0a 0a 28 64 65 63 6c 61 72 65 20 28 75 6e ))..(declare (un
0070: 69 74 20 74 65 73 74 73 29 29 0a 28 64 65 63 6c it tests)).(decl
0080: 61 72 65 20 28 75 73 65 73 20 64 62 29 29 0a 28 are (uses db)).(
0090: 64 65 63 6c 61 72 65 20 28 75 73 65 73 20 63 6f declare (uses co
00a0: 6d 6d 6f 6e 29 29 0a 28 64 65 63 6c 61 72 65 20 mmon)).(declare
00b0: 28 75 73 65 73 20 69 74 65 6d 73 29 29 0a 28 64 (uses items)).(d
00c0: 65 63 6c 61 72 65 20 28 75 73 65 73 20 72 75 6e eclare (uses run
00d0: 63 6f 6e 66 69 67 29 29 0a 0a 28 69 6e 63 6c 75 config))..(inclu
00e0: 64 65 20 22 63 6f 6d 6d 6f 6e 5f 72 65 63 6f 72 de "common_recor
00f0: 64 73 2e 73 63 6d 22 29 0a 28 69 6e 63 6c 75 64 ds.scm").(includ
0100: 65 20 22 6b 65 79 5f 72 65 63 6f 72 64 73 2e 73 e "key_records.s
0110: 63 6d 22 29 0a 28 69 6e 63 6c 75 64 65 20 22 64 cm").(include "d
0120: 62 5f 72 65 63 6f 72 64 73 2e 73 63 6d 22 29 0a b_records.scm").
0130: 28 69 6e 63 6c 75 64 65 20 22 72 75 6e 5f 72 65 (include "run_re
0140: 63 6f 72 64 73 2e 73 63 6d 22 29 0a 28 69 6e 63 cords.scm").(inc
0150: 6c 75 64 65 20 22 74 65 73 74 5f 72 65 63 6f 72 lude "test_recor
0160: 64 73 2e 73 63 6d 22 29 0a 0a 0a 28 64 65 66 69 ds.scm")...(defi
0170: 6e 65 20 28 72 65 67 69 73 74 65 72 2d 74 65 73 ne (register-tes
0180: 74 20 64 62 20 72 75 6e 2d 69 64 20 74 65 73 74 t db run-id test
0190: 2d 6e 61 6d 65 20 69 74 65 6d 2d 70 61 74 68 29 -name item-path)
01a0: 0a 20 20 28 6c 65 74 20 28 28 69 74 65 6d 2d 70 . (let ((item-p
01b0: 61 74 68 73 20 28 69 66 20 28 65 71 75 61 6c 3f aths (if (equal?
01c0: 20 69 74 65 6d 2d 70 61 74 68 20 22 22 29 0a 09 item-path "")..
01d0: 09 09 28 6c 69 73 74 20 69 74 65 6d 2d 70 61 74 ..(list item-pat
01e0: 68 29 0a 09 09 09 28 6c 69 73 74 20 69 74 65 6d h)....(list item
01f0: 2d 70 61 74 68 20 22 22 29 29 29 29 0a 20 20 20 -path "")))).
0200: 20 28 66 6f 72 2d 65 61 63 68 20 0a 20 20 20 20 (for-each .
0210: 20 28 6c 61 6d 62 64 61 20 28 70 74 68 29 0a 20 (lambda (pth).
0220: 20 20 20 20 20 20 28 73 71 6c 69 74 65 33 3a 65 (sqlite3:e
0230: 78 65 63 75 74 65 20 64 62 20 22 49 4e 53 45 52 xecute db "INSER
0240: 54 20 4f 52 20 49 47 4e 4f 52 45 20 49 4e 54 4f T OR IGNORE INTO
0250: 20 74 65 73 74 73 20 28 72 75 6e 5f 69 64 2c 74 tests (run_id,t
0260: 65 73 74 6e 61 6d 65 2c 65 76 65 6e 74 5f 74 69 estname,event_ti
0270: 6d 65 2c 69 74 65 6d 5f 70 61 74 68 2c 73 74 61 me,item_path,sta
0280: 74 65 2c 73 74 61 74 75 73 29 20 56 41 4c 55 45 te,status) VALUE
0290: 53 20 28 3f 2c 3f 2c 73 74 72 66 74 69 6d 65 28 S (?,?,strftime(
02a0: 27 25 73 27 2c 27 6e 6f 77 27 29 2c 3f 2c 27 4e '%s','now'),?,'N
02b0: 4f 54 5f 53 54 41 52 54 45 44 27 2c 27 6e 2f 61 OT_STARTED','n/a
02c0: 27 29 3b 22 20 0a 09 09 09 72 75 6e 2d 69 64 20 ');" ....run-id
02d0: 0a 09 09 09 74 65 73 74 2d 6e 61 6d 65 0a 09 09 ....test-name...
02e0: 09 70 74 68 20 0a 09 09 09 3b 3b 20 28 63 6f 6e .pth ....;; (con
02f0: 63 20 22 2c 22 20 28 73 74 72 69 6e 67 2d 69 6e c "," (string-in
0300: 74 65 72 73 70 65 72 73 65 20 74 61 67 73 20 22 tersperse tags "
0310: 2c 22 29 20 22 2c 22 29 0a 09 09 09 29 29 0a 20 ,") ",")....)).
0320: 20 20 20 20 69 74 65 6d 2d 70 61 74 68 73 20 29 item-paths )
0330: 29 29 0a 0a 3b 3b 20 67 65 74 20 74 68 65 20 70 ))..;; get the p
0340: 72 65 76 69 6f 75 73 20 72 65 63 6f 72 64 20 66 revious record f
0350: 6f 72 20 77 68 65 6e 20 74 68 69 73 20 74 65 73 or when this tes
0360: 74 20 77 61 73 20 72 75 6e 20 77 68 65 72 65 20 t was run where
0370: 61 6c 6c 20 6b 65 79 73 20 6d 61 74 63 68 20 62 all keys match b
0380: 75 74 20 72 75 6e 6e 61 6d 65 0a 3b 3b 20 72 65 ut runname.;; re
0390: 74 75 72 6e 73 20 23 66 20 69 66 20 6e 6f 20 73 turns #f if no s
03a0: 75 63 68 20 74 65 73 74 20 66 6f 75 6e 64 2c 20 uch test found,
03b0: 72 65 74 75 72 6e 73 20 61 20 73 69 6e 67 6c 65 returns a single
03c0: 20 74 65 73 74 20 72 65 63 6f 72 64 20 69 66 20 test record if
03d0: 66 6f 75 6e 64 0a 28 64 65 66 69 6e 65 20 28 74 found.(define (t
03e0: 65 73 74 3a 67 65 74 2d 70 72 65 76 69 6f 75 73 est:get-previous
03f0: 2d 74 65 73 74 2d 72 75 6e 2d 72 65 63 6f 72 64 -test-run-record
0400: 20 64 62 20 72 75 6e 2d 69 64 20 74 65 73 74 2d db run-id test-
0410: 6e 61 6d 65 20 69 74 65 6d 2d 70 61 74 68 29 0a name item-path).
0420: 20 20 28 6c 65 74 2a 20 28 28 6b 65 79 73 20 20 (let* ((keys
0430: 20 20 28 64 62 3a 67 65 74 2d 6b 65 79 73 20 64 (db:get-keys d
0440: 62 29 29 0a 09 20 28 73 65 6c 73 74 72 20 20 28 b)).. (selstr (
0450: 73 74 72 69 6e 67 2d 69 6e 74 65 72 73 70 65 72 string-intersper
0460: 73 65 20 28 6d 61 70 20 28 6c 61 6d 62 64 61 20 se (map (lambda
0470: 28 78 29 28 76 65 63 74 6f 72 2d 72 65 66 20 78 (x)(vector-ref x
0480: 20 30 29 29 20 6b 65 79 73 29 20 22 2c 22 29 29 0)) keys) ","))
0490: 0a 09 20 28 71 72 79 73 74 72 20 20 28 73 74 72 .. (qrystr (str
04a0: 69 6e 67 2d 69 6e 74 65 72 73 70 65 72 73 65 20 ing-intersperse
04b0: 28 6d 61 70 20 28 6c 61 6d 62 64 61 20 28 78 29 (map (lambda (x)
04c0: 28 63 6f 6e 63 20 28 76 65 63 74 6f 72 2d 72 65 (conc (vector-re
04d0: 66 20 78 20 30 29 20 22 3d 3f 22 29 29 20 6b 65 f x 0) "=?")) ke
04e0: 79 73 29 20 22 20 41 4e 44 20 22 29 29 0a 09 20 ys) " AND "))..
04f0: 28 6b 65 79 76 61 6c 73 20 23 66 29 29 0a 20 20 (keyvals #f)).
0500: 20 20 3b 3b 20 66 69 72 73 74 20 6c 6f 6f 6b 20 ;; first look
0510: 75 70 20 74 68 65 20 6b 65 79 20 76 61 6c 75 65 up the key value
0520: 73 20 66 72 6f 6d 20 74 68 65 20 72 75 6e 20 73 s from the run s
0530: 65 6c 65 63 74 65 64 20 62 79 20 72 75 6e 2d 69 elected by run-i
0540: 64 0a 20 20 20 20 28 73 71 6c 69 74 65 33 3a 66 d. (sqlite3:f
0550: 6f 72 2d 65 61 63 68 2d 72 6f 77 20 0a 20 20 20 or-each-row .
0560: 20 20 28 6c 61 6d 62 64 61 20 28 61 20 2e 20 62 (lambda (a . b
0570: 29 0a 20 20 20 20 20 20 20 28 73 65 74 21 20 6b ). (set! k
0580: 65 79 76 61 6c 73 20 28 63 6f 6e 73 20 61 20 62 eyvals (cons a b
0590: 29 29 29 0a 20 20 20 20 20 64 62 0a 20 20 20 20 ))). db.
05a0: 20 28 63 6f 6e 63 20 22 53 45 4c 45 43 54 20 22 (conc "SELECT "
05b0: 20 73 65 6c 73 74 72 20 22 20 46 52 4f 4d 20 72 selstr " FROM r
05c0: 75 6e 73 20 57 48 45 52 45 20 69 64 3d 3f 20 4f uns WHERE id=? O
05d0: 52 44 45 52 20 42 59 20 65 76 65 6e 74 5f 74 69 RDER BY event_ti
05e0: 6d 65 20 44 45 53 43 3b 22 29 20 72 75 6e 2d 69 me DESC;") run-i
05f0: 64 29 0a 20 20 20 20 28 69 66 20 28 6e 6f 74 20 d). (if (not
0600: 6b 65 79 76 61 6c 73 29 0a 09 23 66 0a 09 28 6c keyvals)..#f..(l
0610: 65 74 20 28 28 70 72 65 76 2d 72 75 6e 2d 69 64 et ((prev-run-id
0620: 73 20 27 28 29 29 29 0a 09 20 20 28 61 70 70 6c s '())).. (appl
0630: 79 20 73 71 6c 69 74 65 33 3a 66 6f 72 2d 65 61 y sqlite3:for-ea
0640: 63 68 2d 72 6f 77 0a 09 09 20 28 6c 61 6d 62 64 ch-row... (lambd
0650: 61 20 28 69 64 29 0a 09 09 20 20 20 28 73 65 74 a (id)... (set
0660: 21 20 70 72 65 76 2d 72 75 6e 2d 69 64 73 20 28 ! prev-run-ids (
0670: 63 6f 6e 73 20 69 64 20 70 72 65 76 2d 72 75 6e cons id prev-run
0680: 2d 69 64 73 29 29 29 0a 09 09 20 64 62 0a 09 09 -ids)))... db...
0690: 20 28 63 6f 6e 63 20 22 53 45 4c 45 43 54 20 69 (conc "SELECT i
06a0: 64 20 46 52 4f 4d 20 72 75 6e 73 20 57 48 45 52 d FROM runs WHER
06b0: 45 20 22 20 71 72 79 73 74 72 20 22 20 41 4e 44 E " qrystr " AND
06c0: 20 69 64 20 21 3d 20 3f 3b 22 29 20 28 61 70 70 id != ?;") (app
06d0: 65 6e 64 20 6b 65 79 76 61 6c 73 20 28 6c 69 73 end keyvals (lis
06e0: 74 20 72 75 6e 2d 69 64 29 29 29 0a 09 20 20 3b t run-id))).. ;
06f0: 3b 20 66 6f 72 20 65 61 63 68 20 72 75 6e 20 73 ; for each run s
0700: 74 61 72 74 69 6e 67 20 77 69 74 68 20 74 68 65 tarting with the
0710: 20 6d 6f 73 74 20 72 65 63 65 6e 74 20 6c 6f 6f most recent loo
0720: 6b 20 74 6f 20 73 65 65 20 69 66 20 74 68 65 72 k to see if ther
0730: 65 20 69 73 20 61 20 6d 61 74 63 68 69 6e 67 20 e is a matching
0740: 74 65 73 74 0a 09 20 20 3b 3b 20 69 66 20 66 6f test.. ;; if fo
0750: 75 6e 64 20 74 68 65 6e 20 72 65 74 75 72 6e 20 und then return
0760: 74 68 61 74 20 6d 61 74 63 68 69 6e 67 20 74 65 that matching te
0770: 73 74 20 72 65 63 6f 72 64 0a 09 20 20 28 64 65 st record.. (de
0780: 62 75 67 3a 70 72 69 6e 74 20 34 20 22 73 65 6c bug:print 4 "sel
0790: 73 74 72 3a 20 22 20 73 65 6c 73 74 72 20 22 2c str: " selstr ",
07a0: 20 71 72 79 73 74 72 3a 20 22 20 71 72 79 73 74 qrystr: " qryst
07b0: 72 20 22 2c 20 6b 65 79 76 61 6c 73 3a 20 22 20 r ", keyvals: "
07c0: 6b 65 79 76 61 6c 73 20 22 2c 20 70 72 65 76 69 keyvals ", previ
07d0: 6f 75 73 20 72 75 6e 20 69 64 73 20 66 6f 75 6e ous run ids foun
07e0: 64 3a 20 22 20 70 72 65 76 2d 72 75 6e 2d 69 64 d: " prev-run-id
07f0: 73 29 0a 09 20 20 28 69 66 20 28 6e 75 6c 6c 3f s).. (if (null?
0800: 20 70 72 65 76 2d 72 75 6e 2d 69 64 73 29 20 23 prev-run-ids) #
0810: 66 0a 09 20 20 20 20 20 20 28 6c 65 74 20 6c 6f f.. (let lo
0820: 6f 70 20 28 28 68 65 64 20 28 63 61 72 20 70 72 op ((hed (car pr
0830: 65 76 2d 72 75 6e 2d 69 64 73 29 29 0a 09 09 09 ev-run-ids))....
0840: 20 28 74 61 6c 20 28 63 64 72 20 70 72 65 76 2d (tal (cdr prev-
0850: 72 75 6e 2d 69 64 73 29 29 29 0a 09 09 28 6c 65 run-ids)))...(le
0860: 74 20 28 28 72 65 73 75 6c 74 73 20 28 64 62 2d t ((results (db-
0870: 67 65 74 2d 74 65 73 74 73 2d 66 6f 72 2d 72 75 get-tests-for-ru
0880: 6e 20 64 62 20 68 65 64 20 74 65 73 74 2d 6e 61 n db hed test-na
0890: 6d 65 20 69 74 65 6d 2d 70 61 74 68 20 27 28 29 me item-path '()
08a0: 20 27 28 29 29 29 29 0a 09 09 20 20 28 64 65 62 '())))... (deb
08b0: 75 67 3a 70 72 69 6e 74 20 34 20 22 47 6f 74 20 ug:print 4 "Got
08c0: 74 65 73 74 73 20 66 6f 72 20 72 75 6e 2d 69 64 tests for run-id
08d0: 20 22 20 72 75 6e 2d 69 64 20 22 2c 20 74 65 73 " run-id ", tes
08e0: 74 2d 6e 61 6d 65 20 22 20 74 65 73 74 2d 6e 61 t-name " test-na
08f0: 6d 65 20 22 2c 20 69 74 65 6d 2d 70 61 74 68 20 me ", item-path
0900: 22 20 69 74 65 6d 2d 70 61 74 68 20 22 3a 20 22 " item-path ": "
0910: 20 72 65 73 75 6c 74 73 29 0a 09 09 20 20 28 69 results)... (i
0920: 66 20 28 61 6e 64 20 28 6e 75 6c 6c 3f 20 72 65 f (and (null? re
0930: 73 75 6c 74 73 29 0a 09 09 09 20 20 20 28 6e 6f sults).... (no
0940: 74 20 28 6e 75 6c 6c 3f 20 74 61 6c 29 29 29 0a t (null? tal))).
0950: 09 09 20 20 20 20 20 20 28 6c 6f 6f 70 20 28 63 .. (loop (c
0960: 61 72 20 74 61 6c 29 28 63 64 72 20 74 61 6c 29 ar tal)(cdr tal)
0970: 29 0a 09 09 20 20 20 20 20 20 28 69 66 20 28 6e )... (if (n
0980: 75 6c 6c 3f 20 72 65 73 75 6c 74 73 29 20 23 66 ull? results) #f
0990: 0a 09 09 09 20 20 28 63 61 72 20 72 65 73 75 6c .... (car resul
09a0: 74 73 29 29 29 29 29 29 29 29 29 29 0a 20 20 20 ts)))))))))).
09b0: 20 0a 3b 3b 20 67 65 74 20 74 68 65 20 70 72 65 .;; get the pre
09c0: 76 69 6f 75 73 20 72 65 63 6f 72 64 73 20 66 6f vious records fo
09d0: 72 20 77 68 65 6e 20 74 68 65 73 65 20 74 65 73 r when these tes
09e0: 74 73 20 77 65 72 65 20 72 75 6e 20 77 68 65 72 ts were run wher
09f0: 65 20 61 6c 6c 20 6b 65 79 73 20 6d 61 74 63 68 e all keys match
0a00: 20 62 75 74 20 72 75 6e 6e 61 6d 65 0a 3b 3b 20 but runname.;;
0a10: 4e 42 2f 2f 20 4d 65 72 67 65 20 74 68 69 73 20 NB// Merge this
0a20: 77 69 74 68 20 74 65 73 74 3a 67 65 74 2d 70 72 with test:get-pr
0a30: 65 76 69 6f 75 73 2d 74 65 73 74 2d 72 75 6e 2d evious-test-run-
0a40: 72 65 63 6f 72 64 73 3f 20 54 68 69 73 20 6f 6e records? This on
0a50: 65 20 6c 6f 6f 6b 73 20 66 6f 72 20 61 6c 6c 20 e looks for all
0a60: 6d 61 74 63 68 69 6e 67 20 74 65 73 74 73 0a 3b matching tests.;
0a70: 3b 20 63 61 6e 20 75 73 65 20 77 69 6c 64 63 61 ; can use wildca
0a80: 72 64 73 2e 20 0a 28 64 65 66 69 6e 65 20 28 74 rds. .(define (t
0a90: 65 73 74 3a 67 65 74 2d 6d 61 74 63 68 69 6e 67 est:get-matching
0aa0: 2d 70 72 65 76 69 6f 75 73 2d 74 65 73 74 2d 72 -previous-test-r
0ab0: 75 6e 2d 72 65 63 6f 72 64 73 20 64 62 20 72 75 un-records db ru
0ac0: 6e 2d 69 64 20 74 65 73 74 2d 6e 61 6d 65 20 69 n-id test-name i
0ad0: 74 65 6d 2d 70 61 74 68 29 0a 20 20 28 6c 65 74 tem-path). (let
0ae0: 2a 20 28 28 6b 65 79 73 20 20 20 20 28 64 62 3a * ((keys (db:
0af0: 67 65 74 2d 6b 65 79 73 20 64 62 29 29 0a 09 20 get-keys db))..
0b00: 28 73 65 6c 73 74 72 20 20 28 73 74 72 69 6e 67 (selstr (string
0b10: 2d 69 6e 74 65 72 73 70 65 72 73 65 20 28 6d 61 -intersperse (ma
0b20: 70 20 28 6c 61 6d 62 64 61 20 28 78 29 28 76 65 p (lambda (x)(ve
0b30: 63 74 6f 72 2d 72 65 66 20 78 20 30 29 29 20 6b ctor-ref x 0)) k
0b40: 65 79 73 29 20 22 2c 22 29 29 0a 09 20 28 71 72 eys) ",")).. (qr
0b50: 79 73 74 72 20 20 28 73 74 72 69 6e 67 2d 69 6e ystr (string-in
0b60: 74 65 72 73 70 65 72 73 65 20 28 6d 61 70 20 28 tersperse (map (
0b70: 6c 61 6d 62 64 61 20 28 78 29 28 63 6f 6e 63 20 lambda (x)(conc
0b80: 28 76 65 63 74 6f 72 2d 72 65 66 20 78 20 30 29 (vector-ref x 0)
0b90: 20 22 3d 3f 22 29 29 20 6b 65 79 73 29 20 22 20 "=?")) keys) "
0ba0: 41 4e 44 20 22 29 29 0a 09 20 28 6b 65 79 76 61 AND ")).. (keyva
0bb0: 6c 73 20 23 66 29 0a 09 20 28 74 65 73 74 73 2d ls #f).. (tests-
0bc0: 68 61 73 68 20 28 6d 61 6b 65 2d 68 61 73 68 2d hash (make-hash-
0bd0: 74 61 62 6c 65 29 29 29 0a 20 20 20 20 3b 3b 20 table))). ;;
0be0: 66 69 72 73 74 20 6c 6f 6f 6b 20 75 70 20 74 68 first look up th
0bf0: 65 20 6b 65 79 20 76 61 6c 75 65 73 20 66 72 6f e key values fro
0c00: 6d 20 74 68 65 20 72 75 6e 20 73 65 6c 65 63 74 m the run select
0c10: 65 64 20 62 79 20 72 75 6e 2d 69 64 0a 20 20 20 ed by run-id.
0c20: 20 28 73 71 6c 69 74 65 33 3a 66 6f 72 2d 65 61 (sqlite3:for-ea
0c30: 63 68 2d 72 6f 77 20 0a 20 20 20 20 20 28 6c 61 ch-row . (la
0c40: 6d 62 64 61 20 28 61 20 2e 20 62 29 0a 20 20 20 mbda (a . b).
0c50: 20 20 20 20 28 73 65 74 21 20 6b 65 79 76 61 6c (set! keyval
0c60: 73 20 28 63 6f 6e 73 20 61 20 62 29 29 29 0a 20 s (cons a b))).
0c70: 20 20 20 20 64 62 0a 20 20 20 20 20 28 63 6f 6e db. (con
0c80: 63 20 22 53 45 4c 45 43 54 20 22 20 73 65 6c 73 c "SELECT " sels
0c90: 74 72 20 22 20 46 52 4f 4d 20 72 75 6e 73 20 57 tr " FROM runs W
0ca0: 48 45 52 45 20 69 64 3d 3f 20 4f 52 44 45 52 20 HERE id=? ORDER
0cb0: 42 59 20 65 76 65 6e 74 5f 74 69 6d 65 20 44 45 BY event_time DE
0cc0: 53 43 3b 22 29 20 72 75 6e 2d 69 64 29 0a 20 20 SC;") run-id).
0cd0: 20 20 28 69 66 20 28 6e 6f 74 20 6b 65 79 76 61 (if (not keyva
0ce0: 6c 73 29 0a 09 27 28 29 0a 09 28 6c 65 74 20 28 ls)..'()..(let (
0cf0: 28 70 72 65 76 2d 72 75 6e 2d 69 64 73 20 27 28 (prev-run-ids '(
0d00: 29 29 29 0a 09 20 20 28 61 70 70 6c 79 20 73 71 ))).. (apply sq
0d10: 6c 69 74 65 33 3a 66 6f 72 2d 65 61 63 68 2d 72 lite3:for-each-r
0d20: 6f 77 0a 09 09 20 28 6c 61 6d 62 64 61 20 28 69 ow... (lambda (i
0d30: 64 29 0a 09 09 20 20 20 28 73 65 74 21 20 70 72 d)... (set! pr
0d40: 65 76 2d 72 75 6e 2d 69 64 73 20 28 63 6f 6e 73 ev-run-ids (cons
0d50: 20 69 64 20 70 72 65 76 2d 72 75 6e 2d 69 64 73 id prev-run-ids
0d60: 29 29 29 0a 09 09 20 64 62 0a 09 09 20 28 63 6f )))... db... (co
0d70: 6e 63 20 22 53 45 4c 45 43 54 20 69 64 20 46 52 nc "SELECT id FR
0d80: 4f 4d 20 72 75 6e 73 20 57 48 45 52 45 20 22 20 OM runs WHERE "
0d90: 71 72 79 73 74 72 20 22 20 41 4e 44 20 69 64 20 qrystr " AND id
0da0: 21 3d 20 3f 3b 22 29 20 28 61 70 70 65 6e 64 20 != ?;") (append
0db0: 6b 65 79 76 61 6c 73 20 28 6c 69 73 74 20 72 75 keyvals (list ru
0dc0: 6e 2d 69 64 29 29 29 0a 09 20 20 3b 3b 20 63 6f n-id))).. ;; co
0dd0: 6c 6c 65 63 74 20 61 6c 6c 20 6d 61 74 63 68 69 llect all matchi
0de0: 6e 67 20 74 65 73 74 73 20 66 6f 72 20 74 68 65 ng tests for the
0df0: 20 72 75 6e 73 20 74 68 65 6e 0a 09 20 20 3b 3b runs then.. ;;
0e00: 20 65 78 74 72 61 63 74 20 74 68 65 20 6d 6f 73 extract the mos
0e10: 74 20 72 65 63 65 6e 74 20 74 65 73 74 20 61 6e t recent test an
0e20: 64 20 72 65 74 75 72 6e 20 74 68 61 74 2e 0a 09 d return that...
0e30: 20 20 28 64 65 62 75 67 3a 70 72 69 6e 74 20 34 (debug:print 4
0e40: 20 22 73 65 6c 73 74 72 3a 20 22 20 73 65 6c 73 "selstr: " sels
0e50: 74 72 20 22 2c 20 71 72 79 73 74 72 3a 20 22 20 tr ", qrystr: "
0e60: 71 72 79 73 74 72 20 22 2c 20 6b 65 79 76 61 6c qrystr ", keyval
0e70: 73 3a 20 22 20 6b 65 79 76 61 6c 73 20 0a 09 09 s: " keyvals ...
0e80: 20 20 20 20 20 20 20 22 2c 20 70 72 65 76 69 6f ", previo
0e90: 75 73 20 72 75 6e 20 69 64 73 20 66 6f 75 6e 64 us run ids found
0ea0: 3a 20 22 20 70 72 65 76 2d 72 75 6e 2d 69 64 73 : " prev-run-ids
0eb0: 29 0a 09 20 20 28 69 66 20 28 6e 75 6c 6c 3f 20 ).. (if (null?
0ec0: 70 72 65 76 2d 72 75 6e 2d 69 64 73 29 20 27 28 prev-run-ids) '(
0ed0: 29 20 20 3b 3b 20 6e 6f 20 70 72 65 76 69 6f 75 ) ;; no previou
0ee0: 73 20 72 75 6e 73 3f 20 72 65 74 75 72 6e 20 6e s runs? return n
0ef0: 75 6c 6c 0a 09 20 20 20 20 20 20 28 6c 65 74 20 ull.. (let
0f00: 6c 6f 6f 70 20 28 28 68 65 64 20 28 63 61 72 20 loop ((hed (car
0f10: 70 72 65 76 2d 72 75 6e 2d 69 64 73 29 29 0a 09 prev-run-ids))..
0f20: 09 09 20 28 74 61 6c 20 28 63 64 72 20 70 72 65 .. (tal (cdr pre
0f30: 76 2d 72 75 6e 2d 69 64 73 29 29 29 0a 09 09 28 v-run-ids)))...(
0f40: 6c 65 74 20 28 28 72 65 73 75 6c 74 73 20 28 64 let ((results (d
0f50: 62 2d 67 65 74 2d 74 65 73 74 73 2d 66 6f 72 2d b-get-tests-for-
0f60: 72 75 6e 20 64 62 20 68 65 64 20 74 65 73 74 2d run db hed test-
0f70: 6e 61 6d 65 20 69 74 65 6d 2d 70 61 74 68 20 27 name item-path '
0f80: 28 29 20 27 28 29 29 29 29 0a 09 09 20 20 28 64 () '())))... (d
0f90: 65 62 75 67 3a 70 72 69 6e 74 20 34 20 22 47 6f ebug:print 4 "Go
0fa0: 74 20 74 65 73 74 73 20 66 6f 72 20 72 75 6e 2d t tests for run-
0fb0: 69 64 20 22 20 72 75 6e 2d 69 64 20 22 2c 20 74 id " run-id ", t
0fc0: 65 73 74 2d 6e 61 6d 65 20 22 20 74 65 73 74 2d est-name " test-
0fd0: 6e 61 6d 65 20 0a 09 09 09 20 20 20 20 20 20 20 name ....
0fe0: 22 2c 20 69 74 65 6d 2d 70 61 74 68 20 22 20 69 ", item-path " i
0ff0: 74 65 6d 2d 70 61 74 68 20 22 20 72 65 73 75 6c tem-path " resul
1000: 74 73 3a 20 22 20 28 69 6e 74 65 72 73 70 65 72 ts: " (intersper
1010: 73 65 20 72 65 73 75 6c 74 73 20 22 5c 6e 22 29 se results "\n")
1020: 29 0a 09 09 20 20 3b 3b 20 4b 65 65 70 20 6f 6e )... ;; Keep on
1030: 6c 79 20 74 68 65 20 79 6f 75 6e 67 65 73 74 20 ly the youngest
1040: 6f 66 20 61 6e 79 20 74 65 73 74 2f 69 74 65 6d of any test/item
1050: 20 63 6f 6d 62 69 6e 61 74 69 6f 6e 0a 09 09 20 combination...
1060: 20 28 66 6f 72 2d 65 61 63 68 20 0a 09 09 20 20 (for-each ...
1070: 20 28 6c 61 6d 62 64 61 20 28 74 65 73 74 64 61 (lambda (testda
1080: 74 29 0a 09 09 20 20 20 20 20 28 6c 65 74 2a 20 t)... (let*
1090: 28 28 66 75 6c 6c 2d 74 65 73 74 6e 61 6d 65 20 ((full-testname
10a0: 28 63 6f 6e 63 20 28 64 62 3a 74 65 73 74 2d 67 (conc (db:test-g
10b0: 65 74 2d 74 65 73 74 6e 61 6d 65 20 74 65 73 74 et-testname test
10c0: 64 61 74 29 20 22 2f 22 20 28 64 62 3a 74 65 73 dat) "/" (db:tes
10d0: 74 2d 67 65 74 2d 69 74 65 6d 2d 70 61 74 68 20 t-get-item-path
10e0: 74 65 73 74 64 61 74 29 29 29 0a 09 09 09 20 20 testdat)))....
10f0: 20 20 28 73 74 6f 72 65 64 2d 74 65 73 74 20 20 (stored-test
1100: 20 28 68 61 73 68 2d 74 61 62 6c 65 2d 72 65 66 (hash-table-ref
1110: 2f 64 65 66 61 75 6c 74 20 74 65 73 74 73 2d 68 /default tests-h
1120: 61 73 68 20 66 75 6c 6c 2d 74 65 73 74 6e 61 6d ash full-testnam
1130: 65 20 23 66 29 29 29 0a 09 09 20 20 20 20 20 20 e #f)))...
1140: 20 28 69 66 20 28 6f 72 20 28 6e 6f 74 20 73 74 (if (or (not st
1150: 6f 72 65 64 2d 74 65 73 74 29 0a 09 09 09 20 20 ored-test)....
1160: 20 20 20 20 20 28 61 6e 64 20 73 74 6f 72 65 64 (and stored
1170: 2d 74 65 73 74 0a 09 09 09 09 20 20 20 20 28 3e -test..... (>
1180: 20 28 64 62 3a 74 65 73 74 2d 67 65 74 2d 65 76 (db:test-get-ev
1190: 65 6e 74 5f 74 69 6d 65 20 74 65 73 74 64 61 74 ent_time testdat
11a0: 29 28 64 62 3a 74 65 73 74 2d 67 65 74 2d 65 76 )(db:test-get-ev
11b0: 65 6e 74 5f 74 69 6d 65 20 73 74 6f 72 65 64 2d ent_time stored-
11c0: 74 65 73 74 29 29 29 29 0a 09 09 09 20 20 20 3b test)))).... ;
11d0: 3b 20 74 68 69 73 20 74 65 73 74 20 69 73 20 79 ; this test is y
11e0: 6f 75 6e 67 65 72 2c 20 73 74 6f 72 65 20 69 74 ounger, store it
11f0: 20 69 6e 20 74 68 65 20 68 61 73 68 0a 09 09 09 in the hash....
1200: 20 20 20 28 68 61 73 68 2d 74 61 62 6c 65 2d 73 (hash-table-s
1210: 65 74 21 20 74 65 73 74 73 2d 68 61 73 68 20 66 et! tests-hash f
1220: 75 6c 6c 2d 74 65 73 74 6e 61 6d 65 20 74 65 73 ull-testname tes
1230: 74 64 61 74 29 29 29 29 0a 09 09 20 20 20 72 65 tdat))))... re
1240: 73 75 6c 74 73 29 0a 09 09 20 20 28 69 66 20 28 sults)... (if (
1250: 6e 75 6c 6c 3f 20 74 61 6c 29 0a 09 09 20 20 20 null? tal)...
1260: 20 20 20 28 6d 61 70 20 63 64 72 20 28 68 61 73 (map cdr (has
1270: 68 2d 74 61 62 6c 65 2d 3e 61 6c 69 73 74 20 74 h-table->alist t
1280: 65 73 74 73 2d 68 61 73 68 29 29 20 3b 3b 20 72 ests-hash)) ;; r
1290: 65 74 75 72 6e 20 61 20 6c 69 73 74 20 6f 66 20 eturn a list of
12a0: 74 68 65 20 6d 6f 73 74 20 72 65 63 65 6e 74 20 the most recent
12b0: 74 65 73 74 73 0a 09 09 20 20 20 20 20 20 28 6c tests... (l
12c0: 6f 6f 70 20 28 63 61 72 20 74 61 6c 29 28 63 64 oop (car tal)(cd
12d0: 72 20 74 61 6c 29 29 29 29 29 29 29 29 29 29 0a r tal)))))))))).
12e0: 0a 28 64 65 66 69 6e 65 20 28 74 65 73 74 2d 73 .(define (test-s
12f0: 65 74 2d 73 74 61 74 75 73 21 20 64 62 20 72 75 et-status! db ru
1300: 6e 2d 69 64 20 74 65 73 74 2d 6e 61 6d 65 20 73 n-id test-name s
1310: 74 61 74 65 20 73 74 61 74 75 73 20 69 74 65 6d tate status item
1320: 64 61 74 2d 6f 72 2d 70 61 74 68 20 63 6f 6d 6d dat-or-path comm
1330: 65 6e 74 20 64 61 74 29 0a 20 20 28 6c 65 74 2a ent dat). (let*
1340: 20 28 28 72 65 61 6c 2d 73 74 61 74 75 73 20 73 ((real-status s
1350: 74 61 74 75 73 29 0a 09 20 28 69 74 65 6d 2d 70 tatus).. (item-p
1360: 61 74 68 20 20 20 28 69 66 20 28 73 74 72 69 6e ath (if (strin
1370: 67 3f 20 69 74 65 6d 64 61 74 2d 6f 72 2d 70 61 g? itemdat-or-pa
1380: 74 68 29 20 69 74 65 6d 64 61 74 2d 6f 72 2d 70 th) itemdat-or-p
1390: 61 74 68 20 28 69 74 65 6d 2d 6c 69 73 74 2d 3e ath (item-list->
13a0: 70 61 74 68 20 69 74 65 6d 64 61 74 2d 6f 72 2d path itemdat-or-
13b0: 70 61 74 68 29 29 29 0a 09 20 28 74 65 73 74 64 path))).. (testd
13c0: 61 74 20 20 20 20 20 28 64 62 3a 67 65 74 2d 74 at (db:get-t
13d0: 65 73 74 2d 69 6e 66 6f 20 64 62 20 72 75 6e 2d est-info db run-
13e0: 69 64 20 74 65 73 74 2d 6e 61 6d 65 20 69 74 65 id test-name ite
13f0: 6d 2d 70 61 74 68 29 29 0a 09 20 28 74 65 73 74 m-path)).. (test
1400: 2d 69 64 20 20 20 20 20 28 69 66 20 74 65 73 74 -id (if test
1410: 64 61 74 20 28 64 62 3a 74 65 73 74 2d 67 65 74 dat (db:test-get
1420: 2d 69 64 20 74 65 73 74 64 61 74 29 20 23 66 29 -id testdat) #f)
1430: 29 0a 09 20 28 6f 74 68 65 72 64 61 74 20 20 20 ).. (otherdat
1440: 20 28 69 66 20 64 61 74 20 64 61 74 20 28 6d 61 (if dat dat (ma
1450: 6b 65 2d 68 61 73 68 2d 74 61 62 6c 65 29 29 29 ke-hash-table)))
1460: 0a 09 20 3b 3b 20 62 65 66 6f 72 65 20 70 72 6f .. ;; before pro
1470: 63 65 65 64 69 6e 67 20 77 65 20 6d 75 73 74 20 ceeding we must
1480: 66 69 6e 64 20 6f 75 74 20 69 66 20 74 68 65 20 find out if the
1490: 70 72 65 76 69 6f 75 73 20 74 65 73 74 20 28 77 previous test (w
14a0: 68 65 72 65 20 61 6c 6c 20 6b 65 79 73 20 6d 61 here all keys ma
14b0: 74 63 68 65 64 20 65 78 63 65 70 74 20 72 75 6e tched except run
14c0: 6e 61 6d 65 29 0a 09 20 3b 3b 20 77 61 73 20 57 name).. ;; was W
14d0: 41 49 56 45 44 20 69 66 20 74 68 69 73 20 74 65 AIVED if this te
14e0: 73 74 20 69 73 20 46 41 49 4c 0a 09 20 28 77 61 st is FAIL.. (wa
14f0: 69 76 65 64 20 20 20 28 69 66 20 28 65 71 75 61 ived (if (equa
1500: 6c 3f 20 73 74 61 74 75 73 20 22 46 41 49 4c 22 l? status "FAIL"
1510: 29 0a 09 09 20 20 20 20 20 20 20 28 6c 65 74 20 )... (let
1520: 28 28 70 72 65 76 2d 74 65 73 74 20 28 74 65 73 ((prev-test (tes
1530: 74 3a 67 65 74 2d 70 72 65 76 69 6f 75 73 2d 74 t:get-previous-t
1540: 65 73 74 2d 72 75 6e 2d 72 65 63 6f 72 64 20 64 est-run-record d
1550: 62 20 72 75 6e 2d 69 64 20 74 65 73 74 2d 6e 61 b run-id test-na
1560: 6d 65 20 69 74 65 6d 2d 70 61 74 68 29 29 29 0a me item-path))).
1570: 09 09 09 20 28 69 66 20 70 72 65 76 2d 74 65 73 ... (if prev-tes
1580: 74 20 3b 3b 20 74 72 75 65 20 69 66 20 77 65 20 t ;; true if we
1590: 66 6f 75 6e 64 20 61 20 70 72 65 76 69 6f 75 73 found a previous
15a0: 20 74 65 73 74 20 69 6e 20 74 68 69 73 20 72 75 test in this ru
15b0: 6e 20 73 65 72 69 65 73 0a 09 09 09 20 20 20 20 n series....
15c0: 20 28 6c 65 74 20 28 28 70 72 65 76 2d 73 74 61 (let ((prev-sta
15d0: 74 75 73 20 28 64 62 3a 74 65 73 74 2d 67 65 74 tus (db:test-get
15e0: 2d 73 74 61 74 75 73 20 20 20 70 72 65 76 2d 74 -status prev-t
15f0: 65 73 74 29 29 0a 09 09 09 09 20 20 20 28 70 72 est))..... (pr
1600: 65 76 2d 73 74 61 74 65 20 20 28 64 62 3a 74 65 ev-state (db:te
1610: 73 74 2d 67 65 74 2d 73 74 61 74 65 20 20 20 20 st-get-state
1620: 70 72 65 76 2d 74 65 73 74 29 29 0a 09 09 09 09 prev-test)).....
1630: 20 20 20 28 70 72 65 76 2d 63 6f 6d 6d 65 6e 74 (prev-comment
1640: 20 28 64 62 3a 74 65 73 74 2d 67 65 74 2d 63 6f (db:test-get-co
1650: 6d 6d 65 6e 74 20 70 72 65 76 2d 74 65 73 74 29 mment prev-test)
1660: 29 29 0a 09 09 09 20 20 20 20 20 20 20 28 64 65 )).... (de
1670: 62 75 67 3a 70 72 69 6e 74 20 34 20 22 70 72 65 bug:print 4 "pre
1680: 76 2d 73 74 61 74 75 73 20 22 20 70 72 65 76 2d v-status " prev-
1690: 73 74 61 74 75 73 20 22 2c 20 70 72 65 76 2d 73 status ", prev-s
16a0: 74 61 74 65 20 22 20 70 72 65 76 2d 73 74 61 74 tate " prev-stat
16b0: 65 20 22 2c 20 70 72 65 76 2d 63 6f 6d 6d 65 6e e ", prev-commen
16c0: 74 20 22 20 70 72 65 76 2d 63 6f 6d 6d 65 6e 74 t " prev-comment
16d0: 29 0a 09 09 09 20 20 20 20 20 20 20 28 69 66 20 ).... (if
16e0: 28 61 6e 64 20 28 65 71 75 61 6c 3f 20 70 72 65 (and (equal? pre
16f0: 76 2d 73 74 61 74 65 20 20 22 43 4f 4d 50 4c 45 v-state "COMPLE
1700: 54 45 44 22 29 0a 09 09 09 09 09 28 65 71 75 61 TED")......(equa
1710: 6c 3f 20 70 72 65 76 2d 73 74 61 74 75 73 20 22 l? prev-status "
1720: 57 41 49 56 45 44 22 29 29 0a 09 09 09 09 20 20 WAIVED")).....
1730: 20 70 72 65 76 2d 63 6f 6d 6d 65 6e 74 20 3b 3b prev-comment ;;
1740: 20 77 61 69 76 65 64 20 69 73 20 65 69 74 68 65 waived is eithe
1750: 72 20 74 68 65 20 63 6f 6d 6d 65 6e 74 20 6f 72 r the comment or
1760: 20 23 66 0a 09 09 09 09 20 20 20 23 66 29 29 0a #f..... #f)).
1770: 09 09 09 20 20 20 20 20 23 66 29 29 0a 09 09 20 ... #f))...
1780: 20 20 20 20 20 20 23 66 29 29 29 0a 20 20 20 20 #f))).
1790: 28 69 66 20 77 61 69 76 65 64 20 28 73 65 74 21 (if waived (set!
17a0: 20 72 65 61 6c 2d 73 74 61 74 75 73 20 22 57 41 real-status "WA
17b0: 49 56 45 44 22 29 29 0a 20 20 20 20 28 64 65 62 IVED")). (deb
17c0: 75 67 3a 70 72 69 6e 74 20 34 20 22 72 65 61 6c ug:print 4 "real
17d0: 2d 73 74 61 74 75 73 20 22 20 72 65 61 6c 2d 73 -status " real-s
17e0: 74 61 74 75 73 20 22 2c 20 77 61 69 76 65 64 20 tatus ", waived
17f0: 22 20 77 61 69 76 65 64 20 22 2c 20 73 74 61 74 " waived ", stat
1800: 75 73 20 22 20 73 74 61 74 75 73 29 0a 0a 20 20 us " status)..
1810: 20 20 3b 3b 20 75 70 64 61 74 65 20 74 68 65 20 ;; update the
1820: 70 72 69 6d 61 72 79 20 72 65 63 6f 72 64 20 49 primary record I
1830: 46 20 73 74 61 74 65 20 41 4e 44 20 73 74 61 74 F state AND stat
1840: 75 73 20 61 72 65 20 64 65 66 69 6e 65 64 0a 20 us are defined.
1850: 20 20 20 28 69 66 20 28 61 6e 64 20 73 74 61 74 (if (and stat
1860: 65 20 73 74 61 74 75 73 29 0a 09 28 73 71 6c 69 e status)..(sqli
1870: 74 65 33 3a 65 78 65 63 75 74 65 20 64 62 20 22 te3:execute db "
1880: 55 50 44 41 54 45 20 74 65 73 74 73 20 53 45 54 UPDATE tests SET
1890: 20 73 74 61 74 65 3d 3f 2c 73 74 61 74 75 73 3d state=?,status=
18a0: 3f 2c 65 76 65 6e 74 5f 74 69 6d 65 3d 73 74 72 ?,event_time=str
18b0: 66 74 69 6d 65 28 27 25 73 27 2c 27 6e 6f 77 27 ftime('%s','now'
18c0: 29 20 57 48 45 52 45 20 72 75 6e 5f 69 64 3d 3f ) WHERE run_id=?
18d0: 20 41 4e 44 20 74 65 73 74 6e 61 6d 65 3d 3f 20 AND testname=?
18e0: 41 4e 44 20 69 74 65 6d 5f 70 61 74 68 3d 3f 3b AND item_path=?;
18f0: 22 20 0a 09 09 09 20 73 74 61 74 65 20 72 65 61 " .... state rea
1900: 6c 2d 73 74 61 74 75 73 20 72 75 6e 2d 69 64 20 l-status run-id
1910: 74 65 73 74 2d 6e 61 6d 65 20 69 74 65 6d 2d 70 test-name item-p
1920: 61 74 68 29 29 0a 0a 20 20 20 20 3b 3b 20 69 66 ath)).. ;; if
1930: 20 73 74 61 74 75 73 20 69 73 20 22 41 55 54 4f status is "AUTO
1940: 22 20 74 68 65 6e 20 63 61 6c 6c 20 72 6f 6c 6c " then call roll
1950: 75 70 0a 20 20 20 20 28 69 66 20 28 61 6e 64 20 up. (if (and
1960: 74 65 73 74 2d 69 64 20 73 74 61 74 65 20 73 74 test-id state st
1970: 61 74 75 73 20 28 65 71 75 61 6c 3f 20 73 74 61 atus (equal? sta
1980: 74 75 73 20 22 41 55 54 4f 22 29 29 20 0a 09 28 tus "AUTO")) ..(
1990: 64 62 3a 74 65 73 74 2d 64 61 74 61 2d 72 6f 6c db:test-data-rol
19a0: 6c 75 70 20 64 62 20 74 65 73 74 2d 69 64 29 29 lup db test-id))
19b0: 0a 0a 20 20 20 20 3b 3b 20 61 64 64 20 6d 65 74 .. ;; add met
19c0: 61 64 61 74 61 20 28 6e 65 65 64 20 74 6f 20 64 adata (need to d
19d0: 6f 20 74 68 69 73 20 77 61 79 20 74 6f 20 61 76 o this way to av
19e0: 6f 69 64 20 53 51 4c 20 69 6e 6a 65 63 74 69 6f oid SQL injectio
19f0: 6e 20 69 73 73 75 65 73 29 0a 0a 20 20 20 20 3b n issues).. ;
1a00: 3b 20 3a 66 69 72 73 74 5f 65 72 72 0a 20 20 20 ; :first_err.
1a10: 20 3b 3b 20 28 6c 65 74 20 28 28 76 61 6c 20 28 ;; (let ((val (
1a20: 68 61 73 68 2d 74 61 62 6c 65 2d 72 65 66 2f 64 hash-table-ref/d
1a30: 65 66 61 75 6c 74 20 6f 74 68 65 72 64 61 74 20 efault otherdat
1a40: 22 3a 66 69 72 73 74 5f 65 72 72 22 20 23 66 29 ":first_err" #f)
1a50: 29 29 0a 20 20 20 20 3b 3b 20 20 20 28 69 66 20 )). ;; (if
1a60: 76 61 6c 0a 20 20 20 20 3b 3b 20 20 20 20 20 20 val. ;;
1a70: 20 28 73 71 6c 69 74 65 33 3a 65 78 65 63 75 74 (sqlite3:execut
1a80: 65 20 64 62 20 22 55 50 44 41 54 45 20 74 65 73 e db "UPDATE tes
1a90: 74 73 20 53 45 54 20 66 69 72 73 74 5f 65 72 72 ts SET first_err
1aa0: 3d 3f 20 57 48 45 52 45 20 72 75 6e 5f 69 64 3d =? WHERE run_id=
1ab0: 3f 20 41 4e 44 20 74 65 73 74 6e 61 6d 65 3d 3f ? AND testname=?
1ac0: 20 41 4e 44 20 69 74 65 6d 5f 70 61 74 68 3d 3f AND item_path=?
1ad0: 3b 22 20 76 61 6c 20 72 75 6e 2d 69 64 20 74 65 ;" val run-id te
1ae0: 73 74 2d 6e 61 6d 65 20 69 74 65 6d 2d 70 61 74 st-name item-pat
1af0: 68 29 29 29 0a 20 20 20 20 3b 3b 20 0a 20 20 20 h))). ;; .
1b00: 20 3b 3b 20 3b 3b 20 3a 66 69 72 73 74 5f 77 61 ;; ;; :first_wa
1b10: 72 6e 0a 20 20 20 20 3b 3b 20 28 6c 65 74 20 28 rn. ;; (let (
1b20: 28 76 61 6c 20 28 68 61 73 68 2d 74 61 62 6c 65 (val (hash-table
1b30: 2d 72 65 66 2f 64 65 66 61 75 6c 74 20 6f 74 68 -ref/default oth
1b40: 65 72 64 61 74 20 22 3a 66 69 72 73 74 5f 77 61 erdat ":first_wa
1b50: 72 6e 22 20 23 66 29 29 29 0a 20 20 20 20 3b 3b rn" #f))). ;;
1b60: 20 20 20 28 69 66 20 76 61 6c 0a 20 20 20 20 3b (if val. ;
1b70: 3b 20 20 20 20 20 20 20 28 73 71 6c 69 74 65 33 ; (sqlite3
1b80: 3a 65 78 65 63 75 74 65 20 64 62 20 22 55 50 44 :execute db "UPD
1b90: 41 54 45 20 74 65 73 74 73 20 53 45 54 20 66 69 ATE tests SET fi
1ba0: 72 73 74 5f 77 61 72 6e 3d 3f 20 57 48 45 52 45 rst_warn=? WHERE
1bb0: 20 72 75 6e 5f 69 64 3d 3f 20 41 4e 44 20 74 65 run_id=? AND te
1bc0: 73 74 6e 61 6d 65 3d 3f 20 41 4e 44 20 69 74 65 stname=? AND ite
1bd0: 6d 5f 70 61 74 68 3d 3f 3b 22 20 76 61 6c 20 72 m_path=?;" val r
1be0: 75 6e 2d 69 64 20 74 65 73 74 2d 6e 61 6d 65 20 un-id test-name
1bf0: 69 74 65 6d 2d 70 61 74 68 29 29 29 0a 0a 20 20 item-path)))..
1c00: 20 20 28 6c 65 74 20 28 28 63 61 74 65 67 6f 72 (let ((categor
1c10: 79 20 28 68 61 73 68 2d 74 61 62 6c 65 2d 72 65 y (hash-table-re
1c20: 66 2f 64 65 66 61 75 6c 74 20 6f 74 68 65 72 64 f/default otherd
1c30: 61 74 20 22 3a 63 61 74 65 67 6f 72 79 22 20 22 at ":category" "
1c40: 22 29 29 0a 09 20 20 28 76 61 72 69 61 62 6c 65 ")).. (variable
1c50: 20 28 68 61 73 68 2d 74 61 62 6c 65 2d 72 65 66 (hash-table-ref
1c60: 2f 64 65 66 61 75 6c 74 20 6f 74 68 65 72 64 61 /default otherda
1c70: 74 20 22 3a 76 61 72 69 61 62 6c 65 22 20 22 22 t ":variable" ""
1c80: 29 29 0a 09 20 20 28 76 61 6c 75 65 20 20 20 20 )).. (value
1c90: 28 68 61 73 68 2d 74 61 62 6c 65 2d 72 65 66 2f (hash-table-ref/
1ca0: 64 65 66 61 75 6c 74 20 6f 74 68 65 72 64 61 74 default otherdat
1cb0: 20 22 3a 76 61 6c 75 65 22 20 20 20 20 23 66 29 ":value" #f)
1cc0: 29 0a 09 20 20 28 65 78 70 65 63 74 65 64 20 28 ).. (expected (
1cd0: 68 61 73 68 2d 74 61 62 6c 65 2d 72 65 66 2f 64 hash-table-ref/d
1ce0: 65 66 61 75 6c 74 20 6f 74 68 65 72 64 61 74 20 efault otherdat
1cf0: 22 3a 65 78 70 65 63 74 65 64 22 20 23 66 29 29 ":expected" #f))
1d00: 0a 09 20 20 28 74 6f 6c 20 20 20 20 20 20 28 68 .. (tol (h
1d10: 61 73 68 2d 74 61 62 6c 65 2d 72 65 66 2f 64 65 ash-table-ref/de
1d20: 66 61 75 6c 74 20 6f 74 68 65 72 64 61 74 20 22 fault otherdat "
1d30: 3a 74 6f 6c 22 20 20 20 20 20 20 23 66 29 29 0a :tol" #f)).
1d40: 09 20 20 28 75 6e 69 74 73 20 20 20 20 28 68 61 . (units (ha
1d50: 73 68 2d 74 61 62 6c 65 2d 72 65 66 2f 64 65 66 sh-table-ref/def
1d60: 61 75 6c 74 20 6f 74 68 65 72 64 61 74 20 22 3a ault otherdat ":
1d70: 75 6e 69 74 73 22 20 20 20 20 22 22 29 29 0a 09 units" ""))..
1d80: 20 20 28 64 63 6f 6d 6d 65 6e 74 20 28 68 61 73 (dcomment (has
1d90: 68 2d 74 61 62 6c 65 2d 72 65 66 2f 64 65 66 61 h-table-ref/defa
1da0: 75 6c 74 20 6f 74 68 65 72 64 61 74 20 22 3a 63 ult otherdat ":c
1db0: 6f 6d 6d 65 6e 74 22 20 20 22 22 29 29 29 0a 20 omment" ""))).
1dc0: 20 20 20 20 20 28 64 65 62 75 67 3a 70 72 69 6e (debug:prin
1dd0: 74 20 34 20 0a 09 09 20 20 20 22 63 61 74 65 67 t 4 ... "categ
1de0: 6f 72 79 3a 20 22 20 63 61 74 65 67 6f 72 79 20 ory: " category
1df0: 22 2c 20 76 61 72 69 61 62 6c 65 3a 20 22 20 76 ", variable: " v
1e00: 61 72 69 61 62 6c 65 20 22 2c 20 76 61 6c 75 65 ariable ", value
1e10: 3a 20 22 20 76 61 6c 75 65 0a 09 09 20 20 20 22 : " value... "
1e20: 2c 20 65 78 70 65 63 74 65 64 3a 20 22 20 65 78 , expected: " ex
1e30: 70 65 63 74 65 64 20 22 2c 20 74 6f 6c 3a 20 22 pected ", tol: "
1e40: 20 74 6f 6c 20 22 2c 20 75 6e 69 74 73 3a 20 22 tol ", units: "
1e50: 20 75 6e 69 74 73 29 0a 20 20 20 20 20 20 28 69 units). (i
1e60: 66 20 28 61 6e 64 20 76 61 6c 75 65 20 65 78 70 f (and value exp
1e70: 65 63 74 65 64 20 74 6f 6c 29 20 3b 3b 20 61 6c ected tol) ;; al
1e80: 6c 20 74 68 72 65 65 20 72 65 71 75 69 72 65 64 l three required
1e90: 0a 09 20 20 28 64 62 3a 63 73 76 2d 3e 74 65 73 .. (db:csv->tes
1ea0: 74 2d 64 61 74 61 20 64 62 20 74 65 73 74 2d 69 t-data db test-i
1eb0: 64 20 0a 09 09 09 20 20 20 20 20 28 63 6f 6e 63 d .... (conc
1ec0: 20 63 61 74 65 67 6f 72 79 20 22 2c 22 0a 09 09 category ","...
1ed0: 09 09 20 20 20 76 61 72 69 61 62 6c 65 20 22 2c .. variable ",
1ee0: 22 0a 09 09 09 09 20 20 20 76 61 6c 75 65 20 20 "..... value
1ef0: 20 20 22 2c 22 0a 09 09 09 09 20 20 20 65 78 70 ","..... exp
1f00: 65 63 74 65 64 20 22 2c 22 0a 09 09 09 09 20 20 ected ",".....
1f10: 20 74 6f 6c 20 20 20 20 20 20 22 2c 22 0a 09 09 tol ","...
1f20: 09 09 20 20 20 75 6e 69 74 73 20 20 20 20 22 2c .. units ",
1f30: 22 0a 09 09 09 09 20 20 20 64 63 6f 6d 6d 65 6e "..... dcommen
1f40: 74 20 22 2c 22 29 29 29 29 0a 09 09 09 09 20 20 t ",")))).....
1f50: 20 0a 20 20 20 20 3b 3b 20 6e 65 65 64 20 74 6f . ;; need to
1f60: 20 75 70 64 61 74 65 20 74 68 65 20 74 6f 70 20 update the top
1f70: 74 65 73 74 20 72 65 63 6f 72 64 20 69 66 20 50 test record if P
1f80: 41 53 53 20 6f 72 20 46 41 49 4c 20 61 6e 64 20 ASS or FAIL and
1f90: 74 68 69 73 20 69 73 20 61 20 73 75 62 74 65 73 this is a subtes
1fa0: 74 0a 20 20 20 20 28 69 66 20 28 61 6e 64 20 28 t. (if (and (
1fb0: 6e 6f 74 20 28 65 71 75 61 6c 3f 20 69 74 65 6d not (equal? item
1fc0: 2d 70 61 74 68 20 22 22 29 29 0a 09 20 20 20 20 -path ""))..
1fd0: 20 28 6f 72 20 28 65 71 75 61 6c 3f 20 73 74 61 (or (equal? sta
1fe0: 74 75 73 20 22 50 41 53 53 22 29 0a 09 09 20 28 tus "PASS")... (
1ff0: 65 71 75 61 6c 3f 20 73 74 61 74 75 73 20 22 57 equal? status "W
2000: 41 52 4e 22 29 0a 09 09 20 28 65 71 75 61 6c 3f ARN")... (equal?
2010: 20 73 74 61 74 75 73 20 22 46 41 49 4c 22 29 0a status "FAIL").
2020: 09 09 20 28 65 71 75 61 6c 3f 20 73 74 61 74 75 .. (equal? statu
2030: 73 20 22 57 41 49 56 45 44 22 29 0a 09 09 20 28 s "WAIVED")... (
2040: 65 71 75 61 6c 3f 20 73 74 61 74 75 73 20 22 52 equal? status "R
2050: 55 4e 4e 49 4e 47 22 29 29 29 0a 09 28 62 65 67 UNNING")))..(beg
2060: 69 6e 0a 09 20 20 28 73 71 6c 69 74 65 33 3a 65 in.. (sqlite3:e
2070: 78 65 63 75 74 65 20 0a 09 20 20 20 64 62 0a 09 xecute .. db..
2080: 20 20 20 22 55 50 44 41 54 45 20 74 65 73 74 73 "UPDATE tests
2090: 20 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 53 . S
20a0: 45 54 20 66 61 69 6c 5f 63 6f 75 6e 74 3d 28 53 ET fail_count=(S
20b0: 45 4c 45 43 54 20 63 6f 75 6e 74 28 69 64 29 20 ELECT count(id)
20c0: 46 52 4f 4d 20 74 65 73 74 73 20 57 48 45 52 45 FROM tests WHERE
20d0: 20 72 75 6e 5f 69 64 3d 3f 20 41 4e 44 20 74 65 run_id=? AND te
20e0: 73 74 6e 61 6d 65 3d 3f 20 41 4e 44 20 69 74 65 stname=? AND ite
20f0: 6d 5f 70 61 74 68 20 21 3d 20 27 27 20 41 4e 44 m_path != '' AND
2100: 20 73 74 61 74 75 73 3d 27 46 41 49 4c 27 29 2c status='FAIL'),
2110: 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 .
2120: 20 20 70 61 73 73 5f 63 6f 75 6e 74 3d 28 53 45 pass_count=(SE
2130: 4c 45 43 54 20 63 6f 75 6e 74 28 69 64 29 20 46 LECT count(id) F
2140: 52 4f 4d 20 74 65 73 74 73 20 57 48 45 52 45 20 ROM tests WHERE
2150: 72 75 6e 5f 69 64 3d 3f 20 41 4e 44 20 74 65 73 run_id=? AND tes
2160: 74 6e 61 6d 65 3d 3f 20 41 4e 44 20 69 74 65 6d tname=? AND item
2170: 5f 70 61 74 68 20 21 3d 20 27 27 20 41 4e 44 20 _path != '' AND
2180: 28 73 74 61 74 75 73 3d 27 50 41 53 53 27 20 4f (status='PASS' O
2190: 52 20 73 74 61 74 75 73 3d 27 57 41 52 4e 27 20 R status='WARN'
21a0: 4f 52 20 73 74 61 74 75 73 3d 27 57 41 49 56 45 OR status='WAIVE
21b0: 44 27 29 29 0a 20 20 20 20 20 20 20 20 20 20 20 D')).
21c0: 20 20 57 48 45 52 45 20 72 75 6e 5f 69 64 3d 3f WHERE run_id=?
21d0: 20 41 4e 44 20 74 65 73 74 6e 61 6d 65 3d 3f 20 AND testname=?
21e0: 41 4e 44 20 69 74 65 6d 5f 70 61 74 68 3d 27 27 AND item_path=''
21f0: 3b 22 0a 09 20 20 20 72 75 6e 2d 69 64 20 74 65 ;".. run-id te
2200: 73 74 2d 6e 61 6d 65 20 72 75 6e 2d 69 64 20 74 st-name run-id t
2210: 65 73 74 2d 6e 61 6d 65 20 72 75 6e 2d 69 64 20 est-name run-id
2220: 74 65 73 74 2d 6e 61 6d 65 29 0a 09 20 20 28 69 test-name).. (i
2230: 66 20 28 65 71 75 61 6c 3f 20 73 74 61 74 75 73 f (equal? status
2240: 20 22 52 55 4e 4e 49 4e 47 22 29 20 3b 3b 20 72 "RUNNING") ;; r
2250: 75 6e 6e 69 6e 67 20 74 61 6b 65 73 20 70 72 69 unning takes pri
2260: 6f 72 69 74 79 20 6f 76 65 72 20 61 6c 6c 20 6f ority over all o
2270: 74 68 65 72 20 73 74 61 74 65 73 2c 20 66 6f 72 ther states, for
2280: 63 65 20 74 68 65 20 74 65 73 74 20 73 74 61 74 ce the test stat
2290: 65 20 74 6f 20 52 55 4e 4e 49 4e 47 0a 09 20 20 e to RUNNING..
22a0: 20 20 20 20 28 73 71 6c 69 74 65 33 3a 65 78 65 (sqlite3:exe
22b0: 63 75 74 65 20 64 62 20 22 55 50 44 41 54 45 20 cute db "UPDATE
22c0: 74 65 73 74 73 20 53 45 54 20 73 74 61 74 65 3d tests SET state=
22d0: 3f 20 57 48 45 52 45 20 72 75 6e 5f 69 64 3d 3f ? WHERE run_id=?
22e0: 20 41 4e 44 20 74 65 73 74 6e 61 6d 65 3d 3f 20 AND testname=?
22f0: 41 4e 44 20 69 74 65 6d 5f 70 61 74 68 3d 27 27 AND item_path=''
2300: 3b 22 20 72 75 6e 2d 69 64 20 74 65 73 74 2d 6e ;" run-id test-n
2310: 61 6d 65 29 0a 09 20 20 20 20 20 20 28 73 71 6c ame).. (sql
2320: 69 74 65 33 3a 65 78 65 63 75 74 65 0a 09 20 20 ite3:execute..
2330: 20 20 20 20 20 64 62 0a 09 20 20 20 20 20 20 20 db..
2340: 22 55 50 44 41 54 45 20 74 65 73 74 73 0a 20 20 "UPDATE tests.
2350: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
2360: 20 20 20 20 20 53 45 54 20 73 74 61 74 65 3d 43 SET state=C
2370: 41 53 45 20 57 48 45 4e 20 28 53 45 4c 45 43 54 ASE WHEN (SELECT
2380: 20 63 6f 75 6e 74 28 69 64 29 20 46 52 4f 4d 20 count(id) FROM
2390: 74 65 73 74 73 20 57 48 45 52 45 20 72 75 6e 5f tests WHERE run_
23a0: 69 64 3d 3f 20 41 4e 44 20 74 65 73 74 6e 61 6d id=? AND testnam
23b0: 65 3d 3f 20 41 4e 44 20 69 74 65 6d 5f 70 61 74 e=? AND item_pat
23c0: 68 20 21 3d 20 27 27 20 41 4e 44 20 73 74 61 74 h != '' AND stat
23d0: 65 20 69 6e 20 28 27 52 55 4e 4e 49 4e 47 27 2c e in ('RUNNING',
23e0: 27 4e 4f 54 5f 53 54 41 52 54 45 44 27 29 29 20 'NOT_STARTED'))
23f0: 3e 20 30 20 54 48 45 4e 20 0a 20 20 20 20 20 20 > 0 THEN .
2400: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
2410: 20 20 20 20 27 52 55 4e 4e 49 4e 47 27 0a 20 20 'RUNNING'.
2420: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
2430: 20 20 20 20 20 45 4c 53 45 20 27 43 4f 4d 50 4c ELSE 'COMPL
2440: 45 54 45 44 27 20 45 4e 44 2c 0a 20 20 20 20 20 ETED' END,.
2450: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
2460: 20 20 20 20 20 73 74 61 74 75 73 3d 43 41 53 45 status=CASE
2470: 20 57 48 45 4e 20 66 61 69 6c 5f 63 6f 75 6e 74 WHEN fail_count
2480: 20 3e 20 30 20 54 48 45 4e 20 27 46 41 49 4c 27 > 0 THEN 'FAIL'
2490: 20 57 48 45 4e 20 70 61 73 73 5f 63 6f 75 6e 74 WHEN pass_count
24a0: 20 3e 20 30 20 41 4e 44 20 66 61 69 6c 5f 63 6f > 0 AND fail_co
24b0: 75 6e 74 3d 30 20 54 48 45 4e 20 27 50 41 53 53 unt=0 THEN 'PASS
24c0: 27 20 45 4c 53 45 20 27 55 4e 4b 4e 4f 57 4e 27 ' ELSE 'UNKNOWN'
24d0: 20 45 4e 44 0a 20 20 20 20 20 20 20 20 20 20 20 END.
24e0: 20 20 20 20 20 20 20 20 20 20 20 20 57 48 45 52 WHER
24f0: 45 20 72 75 6e 5f 69 64 3d 3f 20 41 4e 44 20 74 E run_id=? AND t
2500: 65 73 74 6e 61 6d 65 3d 3f 20 41 4e 44 20 69 74 estname=? AND it
2510: 65 6d 5f 70 61 74 68 3d 27 27 3b 22 0a 09 20 20 em_path='';"..
2520: 20 20 20 20 20 72 75 6e 2d 69 64 20 74 65 73 74 run-id test
2530: 2d 6e 61 6d 65 20 72 75 6e 2d 69 64 20 74 65 73 -name run-id tes
2540: 74 2d 6e 61 6d 65 29 29 29 29 0a 20 20 20 20 28 t-name)))). (
2550: 69 66 20 28 6f 72 20 28 61 6e 64 20 28 73 74 72 if (or (and (str
2560: 69 6e 67 3f 20 63 6f 6d 6d 65 6e 74 29 0a 09 09 ing? comment)...
2570: 20 28 73 74 72 69 6e 67 2d 6d 61 74 63 68 20 28 (string-match (
2580: 72 65 67 65 78 70 20 22 5c 5c 53 2b 22 29 20 63 regexp "\\S+") c
2590: 6f 6d 6d 65 6e 74 29 29 0a 09 20 20 20 20 77 61 omment)).. wa
25a0: 69 76 65 64 29 0a 09 28 73 71 6c 69 74 65 33 3a ived)..(sqlite3:
25b0: 65 78 65 63 75 74 65 20 64 62 20 22 55 50 44 41 execute db "UPDA
25c0: 54 45 20 74 65 73 74 73 20 53 45 54 20 63 6f 6d TE tests SET com
25d0: 6d 65 6e 74 3d 3f 20 57 48 45 52 45 20 72 75 6e ment=? WHERE run
25e0: 5f 69 64 3d 3f 20 41 4e 44 20 74 65 73 74 6e 61 _id=? AND testna
25f0: 6d 65 3d 3f 20 41 4e 44 20 69 74 65 6d 5f 70 61 me=? AND item_pa
2600: 74 68 3d 3f 3b 22 0a 09 09 09 20 28 69 66 20 77 th=?;".... (if w
2610: 61 69 76 65 64 20 77 61 69 76 65 64 20 63 6f 6d aived waived com
2620: 6d 65 6e 74 29 20 72 75 6e 2d 69 64 20 74 65 73 ment) run-id tes
2630: 74 2d 6e 61 6d 65 20 69 74 65 6d 2d 70 61 74 68 t-name item-path
2640: 29 29 0a 20 20 20 20 29 29 0a 0a 28 64 65 66 69 )). ))..(defi
2650: 6e 65 20 28 74 65 73 74 2d 73 65 74 2d 6c 6f 67 ne (test-set-log
2660: 21 20 64 62 20 72 75 6e 2d 69 64 20 74 65 73 74 ! db run-id test
2670: 2d 6e 61 6d 65 20 69 74 65 6d 64 61 74 20 6c 6f -name itemdat lo
2680: 67 66 29 20 0a 20 20 28 6c 65 74 20 28 28 69 74 gf) . (let ((it
2690: 65 6d 2d 70 61 74 68 20 28 69 74 65 6d 2d 6c 69 em-path (item-li
26a0: 73 74 2d 3e 70 61 74 68 20 69 74 65 6d 64 61 74 st->path itemdat
26b0: 29 29 29 0a 20 20 20 20 28 73 71 6c 69 74 65 33 ))). (sqlite3
26c0: 3a 65 78 65 63 75 74 65 20 64 62 20 22 55 50 44 :execute db "UPD
26d0: 41 54 45 20 74 65 73 74 73 20 53 45 54 20 66 69 ATE tests SET fi
26e0: 6e 61 6c 5f 6c 6f 67 66 3d 3f 20 57 48 45 52 45 nal_logf=? WHERE
26f0: 20 72 75 6e 5f 69 64 3d 3f 20 41 4e 44 20 74 65 run_id=? AND te
2700: 73 74 6e 61 6d 65 3d 3f 20 41 4e 44 20 69 74 65 stname=? AND ite
2710: 6d 5f 70 61 74 68 3d 3f 3b 22 20 0a 09 09 20 20 m_path=?;" ...
2720: 20 20 20 6c 6f 67 66 20 72 75 6e 2d 69 64 20 74 logf run-id t
2730: 65 73 74 2d 6e 61 6d 65 20 69 74 65 6d 2d 70 61 est-name item-pa
2740: 74 68 29 29 29 0a 0a 28 64 65 66 69 6e 65 20 28 th)))..(define (
2750: 74 65 73 74 2d 73 65 74 2d 74 6f 70 6c 6f 67 21 test-set-toplog!
2760: 20 64 62 20 72 75 6e 2d 69 64 20 74 65 73 74 2d db run-id test-
2770: 6e 61 6d 65 20 6c 6f 67 66 29 20 0a 20 20 28 73 name logf) . (s
2780: 71 6c 69 74 65 33 3a 65 78 65 63 75 74 65 20 64 qlite3:execute d
2790: 62 20 22 55 50 44 41 54 45 20 74 65 73 74 73 20 b "UPDATE tests
27a0: 53 45 54 20 66 69 6e 61 6c 5f 6c 6f 67 66 3d 3f SET final_logf=?
27b0: 20 57 48 45 52 45 20 72 75 6e 5f 69 64 3d 3f 20 WHERE run_id=?
27c0: 41 4e 44 20 74 65 73 74 6e 61 6d 65 3d 3f 20 41 AND testname=? A
27d0: 4e 44 20 69 74 65 6d 5f 70 61 74 68 3d 27 27 3b ND item_path='';
27e0: 22 20 0a 09 09 20 20 20 6c 6f 67 66 20 72 75 6e " ... logf run
27f0: 2d 69 64 20 74 65 73 74 2d 6e 61 6d 65 29 29 0a -id test-name)).
2800: 0a 28 64 65 66 69 6e 65 20 28 74 65 73 74 73 3a .(define (tests:
2810: 73 75 6d 6d 61 72 69 7a 65 2d 69 74 65 6d 73 20 summarize-items
2820: 64 62 20 72 75 6e 2d 69 64 20 74 65 73 74 2d 6e db run-id test-n
2830: 61 6d 65 20 66 6f 72 63 65 29 0a 20 20 3b 3b 20 ame force). ;;
2840: 69 66 20 6e 6f 74 20 66 6f 72 63 65 20 74 68 65 if not force the
2850: 6e 20 6f 6e 6c 79 20 75 70 64 61 74 65 20 74 68 n only update th
2860: 65 20 72 65 63 6f 72 64 20 69 66 20 6f 6e 65 20 e record if one
2870: 6f 66 20 74 68 65 73 65 20 69 73 20 74 72 75 65 of these is true
2880: 3a 0a 20 20 3b 3b 20 20 20 31 2e 20 6c 6f 67 66 :. ;; 1. logf
2890: 20 69 73 20 22 6c 6f 67 2f 66 69 6e 61 6c 2e 6c is "log/final.l
28a0: 6f 67 0a 20 20 3b 3b 20 20 20 32 2e 20 6c 6f 67 og. ;; 2. log
28b0: 66 20 69 73 20 73 61 6d 65 20 61 73 20 6f 75 74 f is same as out
28c0: 70 75 74 66 69 6c 65 6e 61 6d 65 0a 20 20 28 6c putfilename. (l
28d0: 65 74 20 28 28 6f 75 74 70 75 74 66 69 6c 65 6e et ((outputfilen
28e0: 61 6d 65 20 28 63 6f 6e 63 20 22 6d 65 67 61 74 ame (conc "megat
28f0: 65 73 74 2d 72 6f 6c 6c 75 70 2d 22 20 74 65 73 est-rollup-" tes
2900: 74 2d 6e 61 6d 65 20 22 2e 68 74 6d 6c 22 29 29 t-name ".html"))
2910: 0a 09 28 6f 72 69 67 2d 64 69 72 20 20 20 20 20 ..(orig-dir
2920: 20 20 28 63 75 72 72 65 6e 74 2d 64 69 72 65 63 (current-direc
2930: 74 6f 72 79 29 29 0a 09 28 6c 6f 67 66 20 20 20 tory))..(logf
2940: 20 20 20 20 20 20 20 20 23 66 29 29 0a 20 20 20 #f)).
2950: 20 28 73 71 6c 69 74 65 33 3a 66 6f 72 2d 65 61 (sqlite3:for-ea
2960: 63 68 2d 72 6f 77 20 0a 20 20 20 20 20 28 6c 61 ch-row . (la
2970: 6d 62 64 61 20 28 70 61 74 68 20 66 69 6e 61 6c mbda (path final
2980: 5f 6c 6f 67 66 29 0a 20 20 20 20 20 20 20 28 73 _logf). (s
2990: 65 74 21 20 6c 6f 67 66 20 66 69 6e 61 6c 5f 6c et! logf final_l
29a0: 6f 67 66 29 0a 20 20 20 20 20 20 20 28 69 66 20 ogf). (if
29b0: 28 64 69 72 65 63 74 6f 72 79 3f 20 70 61 74 68 (directory? path
29c0: 29 0a 09 20 20 20 28 62 65 67 69 6e 0a 09 20 20 ).. (begin..
29d0: 20 20 20 28 70 72 69 6e 74 20 22 46 6f 75 6e 64 (print "Found
29e0: 20 70 61 74 68 3a 20 22 20 70 61 74 68 29 0a 09 path: " path)..
29f0: 20 20 20 20 20 28 63 68 61 6e 67 65 2d 64 69 72 (change-dir
2a00: 65 63 74 6f 72 79 20 70 61 74 68 29 29 0a 09 20 ectory path))..
2a10: 20 20 20 20 3b 3b 20 28 73 65 74 21 20 6f 75 74 ;; (set! out
2a20: 70 75 74 66 69 6c 65 6e 61 6d 65 20 28 63 6f 6e putfilename (con
2a30: 63 20 70 61 74 68 20 22 2f 22 20 6f 75 74 70 75 c path "/" outpu
2a40: 74 66 69 6c 65 6e 61 6d 65 29 29 29 0a 09 20 20 tfilename)))..
2a50: 20 28 70 72 69 6e 74 20 22 4e 6f 20 73 75 63 68 (print "No such
2a60: 20 70 61 74 68 3a 20 22 20 70 61 74 68 29 29 29 path: " path)))
2a70: 0a 20 20 20 20 20 64 62 20 0a 20 20 20 20 20 22 . db . "
2a80: 53 45 4c 45 43 54 20 72 75 6e 64 69 72 2c 66 69 SELECT rundir,fi
2a90: 6e 61 6c 5f 6c 6f 67 66 20 46 52 4f 4d 20 74 65 nal_logf FROM te
2aa0: 73 74 73 20 57 48 45 52 45 20 72 75 6e 5f 69 64 sts WHERE run_id
2ab0: 3d 3f 20 41 4e 44 20 74 65 73 74 6e 61 6d 65 3d =? AND testname=
2ac0: 3f 20 41 4e 44 20 69 74 65 6d 5f 70 61 74 68 3d ? AND item_path=
2ad0: 27 27 3b 22 0a 20 20 20 20 20 72 75 6e 2d 69 64 '';". run-id
2ae0: 20 74 65 73 74 2d 6e 61 6d 65 29 0a 20 20 20 20 test-name).
2af0: 28 70 72 69 6e 74 20 22 73 75 6d 6d 61 72 69 7a (print "summariz
2b00: 65 2d 69 74 65 6d 73 20 77 69 74 68 20 6c 6f 67 e-items with log
2b10: 66 20 22 20 6c 6f 67 66 29 0a 20 20 20 20 28 69 f " logf). (i
2b20: 66 20 28 6f 72 20 28 65 71 75 61 6c 3f 20 6c 6f f (or (equal? lo
2b30: 67 66 20 22 6c 6f 67 73 2f 66 69 6e 61 6c 2e 6c gf "logs/final.l
2b40: 6f 67 22 29 0a 09 20 20 20 20 28 65 71 75 61 6c og").. (equal
2b50: 3f 20 6c 6f 67 66 20 6f 75 74 70 75 74 66 69 6c ? logf outputfil
2b60: 65 6e 61 6d 65 29 0a 09 20 20 20 20 66 6f 72 63 ename).. forc
2b70: 65 29 0a 09 28 62 65 67 69 6e 0a 09 20 20 28 69 e)..(begin.. (i
2b80: 66 20 28 6f 62 74 61 69 6e 2d 64 6f 74 2d 6c 6f f (obtain-dot-lo
2b90: 63 6b 20 6f 75 74 70 75 74 66 69 6c 65 6e 61 6d ck outputfilenam
2ba0: 65 20 31 20 32 30 20 33 30 29 20 3b 3b 20 72 65 e 1 20 30) ;; re
2bb0: 74 72 79 20 65 76 65 72 79 20 73 65 63 6f 6e 64 try every second
2bc0: 20 66 6f 72 20 32 30 20 73 65 63 6f 6e 64 73 2c for 20 seconds,
2bd0: 20 63 61 6c 6c 20 69 74 20 64 65 61 64 20 61 66 call it dead af
2be0: 74 65 72 20 33 30 20 73 65 63 6f 6e 64 73 20 61 ter 30 seconds a
2bf0: 6e 64 20 73 74 65 61 6c 20 74 68 65 20 6c 6f 63 nd steal the loc
2c00: 6b 0a 09 20 20 20 20 20 20 28 70 72 69 6e 74 20 k.. (print
2c10: 22 4f 62 74 61 69 6e 65 64 20 6c 6f 63 6b 20 66 "Obtained lock f
2c20: 6f 72 20 22 20 6f 75 74 70 75 74 66 69 6c 65 6e or " outputfilen
2c30: 61 6d 65 29 0a 09 20 20 20 20 20 20 28 70 72 69 ame).. (pri
2c40: 6e 74 20 22 46 61 69 6c 65 64 20 74 6f 20 6f 62 nt "Failed to ob
2c50: 74 61 69 6e 20 6c 6f 63 6b 20 66 6f 72 20 22 20 tain lock for "
2c60: 6f 75 74 70 75 74 66 69 6c 65 6e 61 6d 65 29 29 outputfilename))
2c70: 0a 09 20 20 28 6c 65 74 20 28 28 6f 75 70 20 20 .. (let ((oup
2c80: 20 20 28 6f 70 65 6e 2d 6f 75 74 70 75 74 2d 66 (open-output-f
2c90: 69 6c 65 20 6f 75 74 70 75 74 66 69 6c 65 6e 61 ile outputfilena
2ca0: 6d 65 29 29 0a 09 09 28 63 6f 75 6e 74 73 20 28 me))...(counts (
2cb0: 6d 61 6b 65 2d 68 61 73 68 2d 74 61 62 6c 65 29 make-hash-table)
2cc0: 29 0a 09 09 28 73 74 61 74 65 63 6f 75 6e 74 73 )...(statecounts
2cd0: 20 28 6d 61 6b 65 2d 68 61 73 68 2d 74 61 62 6c (make-hash-tabl
2ce0: 65 29 29 0a 09 09 28 6f 75 74 74 78 74 20 22 22 e))...(outtxt ""
2cf0: 29 0a 09 09 28 74 6f 74 20 20 20 20 30 29 29 0a )...(tot 0)).
2d00: 09 20 20 20 20 28 77 69 74 68 2d 6f 75 74 70 75 . (with-outpu
2d10: 74 2d 74 6f 2d 70 6f 72 74 0a 09 09 6f 75 70 0a t-to-port...oup.
2d20: 09 20 20 20 20 20 20 28 6c 61 6d 62 64 61 20 28 . (lambda (
2d30: 29 0a 09 09 28 73 65 74 21 20 6f 75 74 74 78 74 )...(set! outtxt
2d40: 20 28 63 6f 6e 63 20 6f 75 74 74 78 74 20 22 3c (conc outtxt "<
2d50: 68 74 6d 6c 3e 3c 74 69 74 6c 65 3e 53 75 6d 6d html><title>Summ
2d60: 61 72 79 3a 20 22 20 74 65 73 74 2d 6e 61 6d 65 ary: " test-name
2d70: 20 0a 09 09 09 09 20 20 20 22 3c 2f 74 69 74 6c ..... "</titl
2d80: 65 3e 3c 62 6f 64 79 3e 3c 68 32 3e 53 75 6d 6d e><body><h2>Summ
2d90: 61 72 79 20 66 6f 72 20 22 20 74 65 73 74 2d 6e ary for " test-n
2da0: 61 6d 65 20 22 3c 2f 68 32 3e 22 29 29 0a 09 09 ame "</h2>"))...
2db0: 28 73 71 6c 69 74 65 33 3a 66 6f 72 2d 65 61 63 (sqlite3:for-eac
2dc0: 68 2d 72 6f 77 20 0a 09 09 20 28 6c 61 6d 62 64 h-row ... (lambd
2dd0: 61 20 28 69 64 20 69 74 65 6d 70 61 74 68 20 73 a (id itempath s
2de0: 74 61 74 65 20 73 74 61 74 75 73 20 72 75 6e 5f tate status run_
2df0: 64 75 72 61 74 69 6f 6e 20 6c 6f 67 66 20 63 6f duration logf co
2e00: 6d 6d 65 6e 74 29 0a 09 09 20 20 20 28 68 61 73 mment)... (has
2e10: 68 2d 74 61 62 6c 65 2d 73 65 74 21 20 63 6f 75 h-table-set! cou
2e20: 6e 74 73 20 73 74 61 74 75 73 20 28 2b 20 31 20 nts status (+ 1
2e30: 28 68 61 73 68 2d 74 61 62 6c 65 2d 72 65 66 2f (hash-table-ref/
2e40: 64 65 66 61 75 6c 74 20 63 6f 75 6e 74 73 20 73 default counts s
2e50: 74 61 74 75 73 20 30 29 29 29 0a 09 09 20 20 20 tatus 0)))...
2e60: 28 68 61 73 68 2d 74 61 62 6c 65 2d 73 65 74 21 (hash-table-set!
2e70: 20 73 74 61 74 65 63 6f 75 6e 74 73 20 73 74 61 statecounts sta
2e80: 74 65 20 28 2b 20 31 20 28 68 61 73 68 2d 74 61 te (+ 1 (hash-ta
2e90: 62 6c 65 2d 72 65 66 2f 64 65 66 61 75 6c 74 20 ble-ref/default
2ea0: 73 74 61 74 65 63 6f 75 6e 74 73 20 73 74 61 74 statecounts stat
2eb0: 65 20 30 29 29 29 0a 09 09 20 20 20 28 73 65 74 e 0)))... (set
2ec0: 21 20 6f 75 74 74 78 74 20 28 63 6f 6e 63 20 6f ! outtxt (conc o
2ed0: 75 74 74 78 74 20 22 3c 74 72 3e 22 0a 09 09 09 uttxt "<tr>"....
2ee0: 09 20 20 20 20 20 20 22 3c 74 64 3e 3c 61 20 68 . "<td><a h
2ef0: 72 65 66 3d 5c 22 22 20 69 74 65 6d 70 61 74 68 ref=\"" itempath
2f00: 20 22 2f 22 20 6c 6f 67 66 20 22 5c 22 3e 20 22 "/" logf "\"> "
2f10: 20 69 74 65 6d 70 61 74 68 20 22 3c 2f 61 3e 3c itempath "</a><
2f20: 2f 74 64 3e 22 20 0a 09 09 09 09 20 20 20 20 20 /td>" .....
2f30: 20 22 3c 74 64 3e 22 20 73 74 61 74 65 20 20 20 "<td>" state
2f40: 20 22 3c 2f 74 64 3e 22 20 0a 09 09 09 09 20 20 "</td>" .....
2f50: 20 20 20 20 22 3c 74 64 3e 3c 66 6f 6e 74 20 63 "<td><font c
2f60: 6f 6c 6f 72 3d 22 20 28 63 6f 6d 6d 6f 6e 3a 67 olor=" (common:g
2f70: 65 74 2d 63 6f 6c 6f 72 2d 66 72 6f 6d 2d 73 74 et-color-from-st
2f80: 61 74 75 73 20 73 74 61 74 75 73 29 0a 09 09 09 atus status)....
2f90: 09 20 20 20 20 20 20 22 3e 22 20 20 20 73 74 61 . ">" sta
2fa0: 74 75 73 20 20 20 22 3c 2f 66 6f 6e 74 3e 3c 2f tus "</font></
2fb0: 74 64 3e 22 0a 09 09 09 09 20 20 20 20 20 20 22 td>"..... "
2fc0: 3c 74 64 3e 22 20 28 69 66 20 28 65 71 75 61 6c <td>" (if (equal
2fd0: 3f 20 63 6f 6d 6d 65 6e 74 20 22 22 29 0a 09 09 ? comment "")...
2fe0: 09 09 09 09 20 22 26 6e 62 73 70 3b 22 0a 09 09 .... " "...
2ff0: 09 09 09 09 20 63 6f 6d 6d 65 6e 74 29 20 22 3c .... comment) "<
3000: 2f 74 64 3e 22 0a 09 09 09 09 09 09 20 22 3c 2f /td>"....... "</
3010: 74 72 3e 22 29 29 29 0a 09 09 20 64 62 0a 09 09 tr>")))... db...
3020: 20 22 53 45 4c 45 43 54 20 69 64 2c 69 74 65 6d "SELECT id,item
3030: 5f 70 61 74 68 2c 73 74 61 74 65 2c 73 74 61 74 _path,state,stat
3040: 75 73 2c 72 75 6e 5f 64 75 72 61 74 69 6f 6e 2c us,run_duration,
3050: 66 69 6e 61 6c 5f 6c 6f 67 66 2c 63 6f 6d 6d 65 final_logf,comme
3060: 6e 74 20 46 52 4f 4d 20 74 65 73 74 73 20 57 48 nt FROM tests WH
3070: 45 52 45 20 72 75 6e 5f 69 64 3d 3f 20 41 4e 44 ERE run_id=? AND
3080: 20 74 65 73 74 6e 61 6d 65 3d 3f 20 41 4e 44 20 testname=? AND
3090: 69 74 65 6d 5f 70 61 74 68 20 21 3d 20 27 27 3b item_path != '';
30a0: 22 0a 09 09 20 72 75 6e 2d 69 64 20 74 65 73 74 "... run-id test
30b0: 2d 6e 61 6d 65 29 0a 0a 09 09 28 70 72 69 6e 74 -name)....(print
30c0: 20 22 3c 74 61 62 6c 65 3e 3c 74 72 3e 3c 74 64 "<table><tr><td
30d0: 20 76 61 6c 69 67 6e 3d 5c 22 74 6f 70 5c 22 3e valign=\"top\">
30e0: 22 29 0a 09 09 3b 3b 20 50 72 69 6e 74 20 6f 75 ")...;; Print ou
30f0: 74 20 73 74 61 74 73 20 66 6f 72 20 73 74 61 74 t stats for stat
3100: 75 73 0a 09 09 28 73 65 74 21 20 74 6f 74 20 30 us...(set! tot 0
3110: 29 0a 09 09 28 70 72 69 6e 74 20 22 3c 74 61 62 )...(print "<tab
3120: 6c 65 20 63 65 6c 6c 73 70 61 63 69 6e 67 3d 5c le cellspacing=\
3130: 22 30 5c 22 20 62 6f 72 64 65 72 3d 5c 22 31 5c "0\" border=\"1\
3140: 22 3e 3c 74 72 3e 3c 74 64 20 63 6f 6c 73 70 61 "><tr><td colspa
3150: 6e 3d 5c 22 32 5c 22 3e 3c 68 32 3e 53 74 61 74 n=\"2\"><h2>Stat
3160: 65 20 73 74 61 74 73 3c 2f 68 32 3e 3c 2f 74 64 e stats</h2></td
3170: 3e 3c 2f 74 72 3e 22 29 0a 09 09 28 66 6f 72 2d ></tr>")...(for-
3180: 65 61 63 68 20 28 6c 61 6d 62 64 61 20 28 73 74 each (lambda (st
3190: 61 74 65 29 0a 09 09 09 20 20 20 20 28 73 65 74 ate).... (set
31a0: 21 20 74 6f 74 20 28 2b 20 74 6f 74 20 28 68 61 ! tot (+ tot (ha
31b0: 73 68 2d 74 61 62 6c 65 2d 72 65 66 20 73 74 61 sh-table-ref sta
31c0: 74 65 63 6f 75 6e 74 73 20 73 74 61 74 65 29 29 tecounts state))
31d0: 29 0a 09 09 09 20 20 20 20 28 70 72 69 6e 74 20 ).... (print
31e0: 22 3c 74 72 3e 3c 74 64 3e 22 20 73 74 61 74 65 "<tr><td>" state
31f0: 20 22 3c 2f 74 64 3e 3c 74 64 3e 22 20 28 68 61 "</td><td>" (ha
3200: 73 68 2d 74 61 62 6c 65 2d 72 65 66 20 73 74 61 sh-table-ref sta
3210: 74 65 63 6f 75 6e 74 73 20 73 74 61 74 65 29 20 tecounts state)
3220: 22 3c 2f 74 64 3e 3c 2f 74 72 3e 22 29 29 0a 09 "</td></tr>"))..
3230: 09 09 20 20 28 68 61 73 68 2d 74 61 62 6c 65 2d .. (hash-table-
3240: 6b 65 79 73 20 73 74 61 74 65 63 6f 75 6e 74 73 keys statecounts
3250: 29 29 0a 09 09 28 70 72 69 6e 74 20 22 3c 74 72 ))...(print "<tr
3260: 3e 3c 74 64 3e 54 6f 74 61 6c 3c 2f 74 64 3e 3c ><td>Total</td><
3270: 74 64 3e 22 20 74 6f 74 20 22 3c 2f 74 64 3e 3c td>" tot "</td><
3280: 2f 74 72 3e 3c 2f 74 61 62 6c 65 3e 22 29 0a 09 /tr></table>")..
3290: 09 28 70 72 69 6e 74 20 22 3c 2f 74 64 3e 3c 74 .(print "</td><t
32a0: 64 20 76 61 6c 69 67 6e 3d 5c 22 74 6f 70 5c 22 d valign=\"top\"
32b0: 3e 22 29 0a 09 09 3b 3b 20 50 72 69 6e 74 20 6f >")...;; Print o
32c0: 75 74 20 73 74 61 74 73 20 66 6f 72 20 73 74 61 ut stats for sta
32d0: 74 65 0a 09 09 28 73 65 74 21 20 74 6f 74 20 30 te...(set! tot 0
32e0: 29 0a 09 09 28 70 72 69 6e 74 20 22 3c 74 61 62 )...(print "<tab
32f0: 6c 65 20 63 65 6c 6c 73 70 61 63 69 6e 67 3d 5c le cellspacing=\
3300: 22 30 5c 22 20 62 6f 72 64 65 72 3d 5c 22 31 5c "0\" border=\"1\
3310: 22 3e 3c 74 72 3e 3c 74 64 20 63 6f 6c 73 70 61 "><tr><td colspa
3320: 6e 3d 5c 22 32 5c 22 3e 3c 68 32 3e 53 74 61 74 n=\"2\"><h2>Stat
3330: 75 73 20 73 74 61 74 73 3c 2f 68 32 3e 3c 2f 74 us stats</h2></t
3340: 64 3e 3c 2f 74 72 3e 22 29 0a 09 09 28 66 6f 72 d></tr>")...(for
3350: 2d 65 61 63 68 20 28 6c 61 6d 62 64 61 20 28 73 -each (lambda (s
3360: 74 61 74 75 73 29 0a 09 09 09 20 20 20 20 28 73 tatus).... (s
3370: 65 74 21 20 74 6f 74 20 28 2b 20 74 6f 74 20 28 et! tot (+ tot (
3380: 68 61 73 68 2d 74 61 62 6c 65 2d 72 65 66 20 63 hash-table-ref c
3390: 6f 75 6e 74 73 20 73 74 61 74 75 73 29 29 29 0a ounts status))).
33a0: 09 09 09 20 20 20 20 28 70 72 69 6e 74 20 22 3c ... (print "<
33b0: 74 72 3e 3c 74 64 3e 3c 66 6f 6e 74 20 63 6f 6c tr><td><font col
33c0: 6f 72 3d 5c 22 22 20 28 63 6f 6d 6d 6f 6e 3a 67 or=\"" (common:g
33d0: 65 74 2d 63 6f 6c 6f 72 2d 66 72 6f 6d 2d 73 74 et-color-from-st
33e0: 61 74 75 73 20 73 74 61 74 75 73 29 20 22 5c 22 atus status) "\"
33f0: 3e 22 20 73 74 61 74 75 73 0a 09 09 09 09 20 20 >" status.....
3400: 20 22 3c 2f 66 6f 6e 74 3e 3c 2f 74 64 3e 3c 74 "</font></td><t
3410: 64 3e 22 20 28 68 61 73 68 2d 74 61 62 6c 65 2d d>" (hash-table-
3420: 72 65 66 20 63 6f 75 6e 74 73 20 73 74 61 74 75 ref counts statu
3430: 73 29 20 22 3c 2f 74 64 3e 3c 2f 74 72 3e 22 29 s) "</td></tr>")
3440: 29 0a 09 09 09 20 20 28 68 61 73 68 2d 74 61 62 ).... (hash-tab
3450: 6c 65 2d 6b 65 79 73 20 63 6f 75 6e 74 73 29 29 le-keys counts))
3460: 0a 09 09 28 70 72 69 6e 74 20 22 3c 74 72 3e 3c ...(print "<tr><
3470: 74 64 3e 54 6f 74 61 6c 3c 2f 74 64 3e 3c 74 64 td>Total</td><td
3480: 3e 22 20 74 6f 74 20 22 3c 2f 74 64 3e 3c 2f 74 >" tot "</td></t
3490: 72 3e 3c 2f 74 61 62 6c 65 3e 22 29 0a 09 09 28 r></table>")...(
34a0: 70 72 69 6e 74 20 22 3c 2f 74 64 3e 3c 2f 74 64 print "</td></td
34b0: 3e 3c 2f 74 72 3e 3c 2f 74 61 62 6c 65 3e 22 29 ></tr></table>")
34c0: 0a 0a 09 09 28 70 72 69 6e 74 20 22 3c 74 61 62 ....(print "<tab
34d0: 6c 65 20 63 65 6c 6c 73 70 61 63 69 6e 67 3d 5c le cellspacing=\
34e0: 22 30 5c 22 20 62 6f 72 64 65 72 3d 5c 22 31 5c "0\" border=\"1\
34f0: 22 3e 22 20 0a 09 09 20 20 20 20 20 20 20 22 3c ">" ... "<
3500: 74 72 3e 3c 74 64 3e 49 74 65 6d 3c 2f 74 64 3e tr><td>Item</td>
3510: 3c 74 64 3e 53 74 61 74 65 3c 2f 74 64 3e 3c 74 <td>State</td><t
3520: 64 3e 53 74 61 74 75 73 3c 2f 74 64 3e 3c 74 64 d>Status</td><td
3530: 3e 43 6f 6d 6d 65 6e 74 3c 2f 74 64 3e 22 0a 09 >Comment</td>"..
3540: 09 20 20 20 20 20 20 20 6f 75 74 74 78 74 20 22 . outtxt "
3550: 3c 2f 74 61 62 6c 65 3e 3c 2f 62 6f 64 79 3e 3c </table></body><
3560: 2f 68 74 6d 6c 3e 22 29 0a 09 09 28 72 65 6c 65 /html>")...(rele
3570: 61 73 65 2d 64 6f 74 2d 6c 6f 63 6b 20 6f 75 74 ase-dot-lock out
3580: 70 75 74 66 69 6c 65 6e 61 6d 65 29 29 29 0a 09 putfilename)))..
3590: 20 20 20 20 28 63 6c 6f 73 65 2d 6f 75 74 70 75 (close-outpu
35a0: 74 2d 70 6f 72 74 20 6f 75 70 29 0a 09 20 20 20 t-port oup)..
35b0: 20 28 63 68 61 6e 67 65 2d 64 69 72 65 63 74 6f (change-directo
35c0: 72 79 20 6f 72 69 67 2d 64 69 72 29 0a 09 20 20 ry orig-dir)..
35d0: 20 20 28 74 65 73 74 2d 73 65 74 2d 74 6f 70 6c (test-set-topl
35e0: 6f 67 21 20 64 62 20 72 75 6e 2d 69 64 20 74 65 og! db run-id te
35f0: 73 74 2d 6e 61 6d 65 20 6f 75 74 70 75 74 66 69 st-name outputfi
3600: 6c 65 6e 61 6d 65 29 0a 09 20 20 20 20 29 29 29 lename).. )))
3610: 29 29 0a 0a 28 64 65 66 69 6e 65 20 28 67 65 74 ))..(define (get
3620: 2d 61 6c 6c 2d 6c 65 67 61 6c 2d 74 65 73 74 73 -all-legal-tests
3630: 29 0a 20 20 28 6c 65 74 2a 20 28 28 74 65 73 74 ). (let* ((test
3640: 73 20 20 28 67 6c 6f 62 20 28 63 6f 6e 63 20 2a s (glob (conc *
3650: 74 6f 70 70 61 74 68 2a 20 22 2f 74 65 73 74 73 toppath* "/tests
3660: 2f 2a 22 29 29 29 0a 09 20 28 72 65 73 20 20 20 /*"))).. (res
3670: 20 27 28 29 29 29 0a 20 20 20 20 28 64 65 62 75 '())). (debu
3680: 67 3a 70 72 69 6e 74 20 34 20 22 49 4e 46 4f 3a g:print 4 "INFO:
3690: 20 4c 6f 6f 6b 69 6e 67 20 61 74 20 74 65 73 74 Looking at test
36a0: 73 20 22 20 28 73 74 72 69 6e 67 2d 69 6e 74 65 s " (string-inte
36b0: 72 73 70 65 72 73 65 20 74 65 73 74 73 20 22 2c rsperse tests ",
36c0: 22 29 29 0a 20 20 20 20 28 66 6f 72 2d 65 61 63 ")). (for-eac
36d0: 68 20 28 6c 61 6d 62 64 61 20 28 74 65 73 74 70 h (lambda (testp
36e0: 61 74 68 29 0a 09 09 28 69 66 20 28 66 69 6c 65 ath)...(if (file
36f0: 2d 65 78 69 73 74 73 3f 20 28 63 6f 6e 63 20 74 -exists? (conc t
3700: 65 73 74 70 61 74 68 20 22 2f 74 65 73 74 63 6f estpath "/testco
3710: 6e 66 69 67 22 29 29 0a 09 09 20 20 20 20 28 73 nfig"))... (s
3720: 65 74 21 20 72 65 73 20 28 63 6f 6e 73 20 28 6c et! res (cons (l
3730: 61 73 74 20 28 73 74 72 69 6e 67 2d 73 70 6c 69 ast (string-spli
3740: 74 20 74 65 73 74 70 61 74 68 20 22 2f 22 29 29 t testpath "/"))
3750: 20 72 65 73 29 29 29 29 0a 09 20 20 20 20 20 20 res))))..
3760: 74 65 73 74 73 29 0a 20 20 20 20 72 65 73 29 29 tests). res))
3770: 0a 0a 28 64 65 66 69 6e 65 20 28 74 65 73 74 3a ..(define (test:
3780: 67 65 74 2d 74 65 73 74 63 6f 6e 66 69 67 20 74 get-testconfig t
3790: 65 73 74 2d 6e 61 6d 65 20 73 79 73 74 65 6d 2d est-name system-
37a0: 61 6c 6c 6f 77 65 64 29 0a 20 20 28 6c 65 74 2a allowed). (let*
37b0: 20 28 28 74 65 73 74 2d 70 61 74 68 20 20 20 20 ((test-path
37c0: 28 63 6f 6e 63 20 2a 74 6f 70 70 61 74 68 2a 20 (conc *toppath*
37d0: 22 2f 74 65 73 74 73 2f 22 20 74 65 73 74 2d 6e "/tests/" test-n
37e0: 61 6d 65 29 29 0a 09 20 28 74 65 73 74 2d 63 6f ame)).. (test-co
37f0: 6e 66 69 67 66 20 28 63 6f 6e 63 20 74 65 73 74 nfigf (conc test
3800: 2d 70 61 74 68 20 22 2f 74 65 73 74 63 6f 6e 66 -path "/testconf
3810: 69 67 22 29 29 0a 09 20 28 74 65 73 74 65 78 69 ig")).. (testexi
3820: 73 74 73 20 20 20 28 61 6e 64 20 28 66 69 6c 65 sts (and (file
3830: 2d 65 78 69 73 74 73 3f 20 74 65 73 74 2d 63 6f -exists? test-co
3840: 6e 66 69 67 66 29 28 66 69 6c 65 2d 72 65 61 64 nfigf)(file-read
3850: 2d 61 63 63 65 73 73 3f 20 74 65 73 74 2d 63 6f -access? test-co
3860: 6e 66 69 67 66 29 29 29 29 0a 20 20 20 20 28 69 nfigf)))). (i
3870: 66 20 74 65 73 74 65 78 69 73 74 73 0a 09 28 72 f testexists..(r
3880: 65 61 64 2d 63 6f 6e 66 69 67 20 74 65 73 74 2d ead-config test-
3890: 63 6f 6e 66 69 67 66 20 23 66 20 73 79 73 74 65 configf #f syste
38a0: 6d 2d 61 6c 6c 6f 77 65 64 20 65 6e 76 69 72 6f m-allowed enviro
38b0: 6e 2d 70 61 74 74 3a 20 28 69 66 20 73 79 73 74 n-patt: (if syst
38c0: 65 6d 2d 61 6c 6c 6f 77 65 64 0a 09 09 09 09 09 em-allowed......
38d0: 09 09 09 20 20 20 20 20 20 22 70 72 65 2d 6c 61 ... "pre-la
38e0: 75 6e 63 68 2d 65 6e 76 2d 76 61 72 73 22 0a 09 unch-env-vars"..
38f0: 09 09 09 09 09 09 09 20 20 20 20 20 20 23 66 29 ....... #f)
3900: 29 0a 09 23 66 29 29 29 0a 20 20 0a 3b 3b 20 73 )..#f))). .;; s
3910: 6f 72 74 20 74 65 73 74 73 20 62 79 20 70 72 69 ort tests by pri
3920: 6f 72 69 74 79 20 61 6e 64 20 77 61 69 74 6f 6e ority and waiton
3930: 0a 3b 3b 20 4d 6f 76 65 20 74 65 73 74 20 73 70 .;; Move test sp
3940: 65 63 69 66 69 63 20 73 74 75 66 66 20 74 6f 20 ecific stuff to
3950: 61 20 74 65 73 74 20 75 6e 69 74 20 46 49 58 4d a test unit FIXM
3960: 45 20 6f 6e 65 20 6f 66 20 74 68 65 73 65 20 64 E one of these d
3970: 61 79 73 0a 28 64 65 66 69 6e 65 20 28 74 65 73 ays.(define (tes
3980: 74 73 3a 73 6f 72 74 2d 62 79 2d 70 72 69 6f 72 ts:sort-by-prior
3990: 69 74 79 2d 61 6e 64 2d 77 61 69 74 6f 6e 20 74 ity-and-waiton t
39a0: 65 73 74 2d 72 65 63 6f 72 64 73 29 0a 20 20 28 est-records). (
39b0: 6c 65 74 20 28 28 6d 75 6e 67 65 70 72 69 6f 72 let ((mungeprior
39c0: 69 74 79 20 28 6c 61 6d 62 64 61 20 28 70 72 69 ity (lambda (pri
39d0: 6f 72 69 74 79 29 0a 09 09 09 20 28 69 66 20 70 ority).... (if p
39e0: 72 69 6f 72 69 74 79 0a 09 09 09 20 20 20 20 20 riority....
39f0: 28 6c 65 74 20 28 28 74 6d 70 20 28 61 6e 79 2d (let ((tmp (any-
3a00: 3e 6e 75 6d 62 65 72 20 70 72 69 6f 72 69 74 79 >number priority
3a10: 29 29 29 0a 09 09 09 20 20 20 20 20 20 20 28 69 ))).... (i
3a20: 66 20 74 6d 70 20 74 6d 70 20 28 62 65 67 69 6e f tmp tmp (begin
3a30: 20 28 64 65 62 75 67 3a 70 72 69 6e 74 20 30 20 (debug:print 0
3a40: 22 45 52 52 4f 52 3a 20 62 61 64 20 70 72 69 6f "ERROR: bad prio
3a50: 72 69 74 79 20 76 61 6c 75 65 20 22 20 70 72 69 rity value " pri
3a60: 6f 72 69 74 79 20 22 2c 20 75 73 69 6e 67 20 30 ority ", using 0
3a70: 22 29 20 30 29 29 29 0a 09 09 09 20 20 20 20 20 ") 0)))....
3a80: 30 29 29 29 29 0a 20 20 20 20 28 73 6f 72 74 20 0)))). (sort
3a90: 0a 20 20 20 20 20 28 68 61 73 68 2d 74 61 62 6c . (hash-tabl
3aa0: 65 2d 6b 65 79 73 20 74 65 73 74 2d 72 65 63 6f e-keys test-reco
3ab0: 72 64 73 29 20 3b 3b 20 61 76 6f 69 64 20 64 65 rds) ;; avoid de
3ac0: 61 6c 69 6e 67 20 77 69 74 68 20 64 65 6c 65 74 aling with delet
3ad0: 65 64 20 74 65 73 74 73 2c 20 6c 6f 6f 6b 20 61 ed tests, look a
3ae0: 74 20 74 68 65 20 68 61 73 68 20 74 61 62 6c 65 t the hash table
3af0: 0a 20 20 20 20 20 28 6c 61 6d 62 64 61 20 28 61 . (lambda (a
3b00: 20 62 29 0a 20 20 20 20 20 20 20 28 6c 65 74 2a b). (let*
3b10: 20 28 28 61 2d 72 65 63 6f 72 64 20 20 20 28 68 ((a-record (h
3b20: 61 73 68 2d 74 61 62 6c 65 2d 72 65 66 20 74 65 ash-table-ref te
3b30: 73 74 2d 72 65 63 6f 72 64 73 20 61 29 29 0a 09 st-records a))..
3b40: 20 20 20 20 20 20 28 62 2d 72 65 63 6f 72 64 20 (b-record
3b50: 20 20 28 68 61 73 68 2d 74 61 62 6c 65 2d 72 65 (hash-table-re
3b60: 66 20 74 65 73 74 2d 72 65 63 6f 72 64 73 20 62 f test-records b
3b70: 29 29 0a 09 20 20 20 20 20 20 28 61 2d 77 61 69 )).. (a-wai
3b80: 74 6f 6e 73 20 20 28 74 65 73 74 73 3a 74 65 73 tons (tests:tes
3b90: 74 71 75 65 75 65 2d 67 65 74 2d 77 61 69 74 6f tqueue-get-waito
3ba0: 6e 73 20 61 2d 72 65 63 6f 72 64 29 29 0a 09 20 ns a-record))..
3bb0: 20 20 20 20 20 28 62 2d 77 61 69 74 6f 6e 73 20 (b-waitons
3bc0: 20 28 74 65 73 74 73 3a 74 65 73 74 71 75 65 75 (tests:testqueu
3bd0: 65 2d 67 65 74 2d 77 61 69 74 6f 6e 73 20 62 2d e-get-waitons b-
3be0: 72 65 63 6f 72 64 29 29 0a 09 20 20 20 20 20 20 record))..
3bf0: 28 61 2d 63 6f 6e 66 69 67 20 20 20 28 74 65 73 (a-config (tes
3c00: 74 73 3a 74 65 73 74 71 75 65 75 65 2d 67 65 74 ts:testqueue-get
3c10: 2d 74 65 73 74 63 6f 6e 66 69 67 20 20 61 2d 72 -testconfig a-r
3c20: 65 63 6f 72 64 29 29 0a 09 20 20 20 20 20 20 28 ecord)).. (
3c30: 62 2d 63 6f 6e 66 69 67 20 20 20 28 74 65 73 74 b-config (test
3c40: 73 3a 74 65 73 74 71 75 65 75 65 2d 67 65 74 2d s:testqueue-get-
3c50: 74 65 73 74 63 6f 6e 66 69 67 20 20 62 2d 72 65 testconfig b-re
3c60: 63 6f 72 64 29 29 0a 09 20 20 20 20 20 20 28 61 cord)).. (a
3c70: 2d 72 61 77 2d 70 72 69 20 20 28 63 6f 6e 66 69 -raw-pri (confi
3c80: 67 2d 6c 6f 6f 6b 75 70 20 61 2d 63 6f 6e 66 69 g-lookup a-confi
3c90: 67 20 22 72 65 71 75 69 72 65 6d 65 6e 74 73 22 g "requirements"
3ca0: 20 22 70 72 69 6f 72 69 74 79 22 29 29 0a 09 20 "priority"))..
3cb0: 20 20 20 20 20 28 62 2d 72 61 77 2d 70 72 69 20 (b-raw-pri
3cc0: 20 28 63 6f 6e 66 69 67 2d 6c 6f 6f 6b 75 70 20 (config-lookup
3cd0: 62 2d 63 6f 6e 66 69 67 20 22 72 65 71 75 69 72 b-config "requir
3ce0: 65 6d 65 6e 74 73 22 20 22 70 72 69 6f 72 69 74 ements" "priorit
3cf0: 79 22 29 29 0a 09 20 20 20 20 20 20 28 61 2d 70 y")).. (a-p
3d00: 72 69 6f 72 69 74 79 20 28 6d 75 6e 67 65 70 72 riority (mungepr
3d10: 69 6f 72 69 74 79 20 61 2d 72 61 77 2d 70 72 69 iority a-raw-pri
3d20: 29 29 0a 09 20 20 20 20 20 20 28 62 2d 70 72 69 )).. (b-pri
3d30: 6f 72 69 74 79 20 28 6d 75 6e 67 65 70 72 69 6f ority (mungeprio
3d40: 72 69 74 79 20 62 2d 72 61 77 2d 70 72 69 29 29 rity b-raw-pri))
3d50: 29 0a 09 3b 3b 20 20 28 64 65 62 75 67 3a 70 72 )..;; (debug:pr
3d60: 69 6e 74 20 35 20 22 73 6f 72 74 2d 62 79 2d 70 int 5 "sort-by-p
3d70: 72 69 6f 72 69 74 79 2d 61 6e 64 2d 77 61 69 74 riority-and-wait
3d80: 6f 6e 2c 20 61 3a 20 22 20 61 20 22 20 62 3a 20 on, a: " a " b:
3d90: 22 20 62 0a 09 3b 3b 20 09 20 20 20 20 20 20 22 " b..;; . "
3da0: 5c 6e 20 20 20 20 20 61 2d 72 65 63 6f 72 64 3a \n a-record:
3db0: 20 20 20 22 20 61 2d 72 65 63 6f 72 64 20 0a 09 " a-record ..
3dc0: 3b 3b 20 09 20 20 20 20 20 20 22 5c 6e 20 20 20 ;; . "\n
3dd0: 20 20 62 2d 72 65 63 6f 72 64 3a 20 20 20 22 20 b-record: "
3de0: 62 2d 72 65 63 6f 72 64 0a 09 3b 3b 20 09 20 20 b-record..;; .
3df0: 20 20 20 20 22 5c 6e 20 20 20 20 20 61 2d 77 61 "\n a-wa
3e00: 69 74 6f 6e 73 3a 20 20 22 20 61 2d 77 61 69 74 itons: " a-wait
3e10: 6f 6e 73 0a 09 3b 3b 20 09 20 20 20 20 20 20 22 ons..;; . "
3e20: 5c 6e 20 20 20 20 20 62 2d 77 61 69 74 6f 6e 73 \n b-waitons
3e30: 3a 20 20 22 20 62 2d 77 61 69 74 6f 6e 73 0a 09 : " b-waitons..
3e40: 3b 3b 20 09 20 20 20 20 20 20 22 5c 6e 20 20 20 ;; . "\n
3e50: 20 20 61 2d 63 6f 6e 66 69 67 3a 20 20 20 22 20 a-config: "
3e60: 28 68 61 73 68 2d 74 61 62 6c 65 2d 3e 61 6c 69 (hash-table->ali
3e70: 73 74 20 61 2d 63 6f 6e 66 69 67 29 0a 09 3b 3b st a-config)..;;
3e80: 20 09 20 20 20 20 20 20 22 5c 6e 20 20 20 20 20 . "\n
3e90: 62 2d 63 6f 6e 66 69 67 3a 20 20 20 22 20 28 68 b-config: " (h
3ea0: 61 73 68 2d 74 61 62 6c 65 2d 3e 61 6c 69 73 74 ash-table->alist
3eb0: 20 62 2d 63 6f 6e 66 69 67 29 0a 09 3b 3b 20 09 b-config)..;; .
3ec0: 20 20 20 20 20 20 22 5c 6e 20 20 20 20 20 61 2d "\n a-
3ed0: 72 61 77 2d 70 72 69 3a 20 20 22 20 61 2d 72 61 raw-pri: " a-ra
3ee0: 77 2d 70 72 69 0a 09 3b 3b 20 09 20 20 20 20 20 w-pri..;; .
3ef0: 20 22 5c 6e 20 20 20 20 20 62 2d 72 61 77 2d 70 "\n b-raw-p
3f00: 72 69 3a 20 20 22 20 62 2d 72 61 77 2d 70 72 69 ri: " b-raw-pri
3f10: 0a 09 3b 3b 20 09 20 20 20 20 20 20 22 5c 6e 20 ..;; . "\n
3f20: 20 20 20 20 61 2d 70 72 69 6f 72 69 74 79 3a 20 a-priority:
3f30: 22 20 61 2d 70 72 69 6f 72 69 74 79 0a 09 3b 3b " a-priority..;;
3f40: 20 09 20 20 20 20 20 20 22 5c 6e 20 20 20 20 20 . "\n
3f50: 62 2d 70 72 69 6f 72 69 74 79 3a 20 22 20 62 2d b-priority: " b-
3f60: 70 72 69 6f 72 69 74 79 29 0a 09 20 28 74 65 73 priority).. (tes
3f70: 74 73 3a 74 65 73 74 71 75 65 75 65 2d 73 65 74 ts:testqueue-set
3f80: 2d 70 72 69 6f 72 69 74 79 21 20 61 2d 72 65 63 -priority! a-rec
3f90: 6f 72 64 20 61 2d 70 72 69 6f 72 69 74 79 29 0a ord a-priority).
3fa0: 09 20 28 74 65 73 74 73 3a 74 65 73 74 71 75 65 . (tests:testque
3fb0: 75 65 2d 73 65 74 2d 70 72 69 6f 72 69 74 79 21 ue-set-priority!
3fc0: 20 62 2d 72 65 63 6f 72 64 20 62 2d 70 72 69 6f b-record b-prio
3fd0: 72 69 74 79 29 0a 09 20 28 69 66 20 28 61 6e 64 rity).. (if (and
3fe0: 20 61 2d 77 61 69 74 6f 6e 73 20 28 6d 65 6d 62 a-waitons (memb
3ff0: 65 72 20 28 74 65 73 74 73 3a 74 65 73 74 71 75 er (tests:testqu
4000: 65 75 65 2d 67 65 74 2d 74 65 73 74 6e 61 6d 65 eue-get-testname
4010: 20 62 2d 72 65 63 6f 72 64 29 20 61 2d 77 61 69 b-record) a-wai
4020: 74 6f 6e 73 29 29 0a 09 20 20 20 20 20 23 66 20 tons)).. #f
4030: 3b 3b 20 63 61 6e 6e 6f 74 20 68 61 76 65 20 61 ;; cannot have a
4040: 20 77 68 69 63 68 20 69 73 20 77 61 69 74 69 6e which is waitin
4050: 67 20 6f 6e 20 62 20 68 61 70 70 65 6e 69 6e 67 g on b happening
4060: 20 62 65 66 6f 72 65 20 62 0a 09 20 20 20 20 20 before b..
4070: 28 69 66 20 28 61 6e 64 20 62 2d 77 61 69 74 6f (if (and b-waito
4080: 6e 73 20 28 6d 65 6d 62 65 72 20 28 74 65 73 74 ns (member (test
4090: 73 3a 74 65 73 74 71 75 65 75 65 2d 67 65 74 2d s:testqueue-get-
40a0: 74 65 73 74 6e 61 6d 65 20 61 2d 72 65 63 6f 72 testname a-recor
40b0: 64 29 20 62 2d 77 61 69 74 6f 6e 73 29 29 0a 09 d) b-waitons))..
40c0: 09 20 23 74 20 3b 3b 20 74 68 69 73 20 69 73 20 . #t ;; this is
40d0: 74 68 65 20 63 6f 72 72 65 63 74 20 6f 72 64 65 the correct orde
40e0: 72 2c 20 62 20 69 73 20 77 61 69 74 69 6e 67 20 r, b is waiting
40f0: 6f 6e 20 61 20 61 6e 64 20 62 20 69 73 20 62 65 on a and b is be
4100: 66 6f 72 65 20 61 0a 09 09 20 28 69 66 20 28 3e fore a... (if (>
4110: 20 61 2d 70 72 69 6f 72 69 74 79 20 62 2d 70 72 a-priority b-pr
4120: 69 6f 72 69 74 79 29 0a 09 09 20 20 20 20 20 23 iority)... #
4130: 74 20 3b 3b 20 69 66 20 61 20 69 73 20 61 20 68 t ;; if a is a h
4140: 69 67 68 65 72 20 70 72 69 6f 72 69 74 79 20 74 igher priority t
4150: 68 61 6e 20 62 20 74 68 65 6e 20 77 65 20 61 72 han b then we ar
4160: 65 20 67 6f 6f 64 20 74 6f 20 67 6f 0a 09 09 20 e good to go...
4170: 20 20 20 20 23 66 29 29 29 29 29 29 29 29 0a 0a #f))))))))..
4180: 0a 3b 3b 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d .;;=============
4190: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
41a0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
41b0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
41c0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 3b 3b 20 74 65 73 =========.;; tes
41d0: 74 20 73 74 65 70 73 0a 3b 3b 3d 3d 3d 3d 3d 3d t steps.;;======
41e0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
41f0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
4200: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
4210: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
4220: 0a 0a 28 64 65 66 69 6e 65 20 28 74 65 73 74 73 ..(define (tests
4230: 74 65 70 2d 73 65 74 2d 73 74 61 74 75 73 21 20 tep-set-status!
4240: 64 62 20 72 75 6e 2d 69 64 20 74 65 73 74 2d 6e db run-id test-n
4250: 61 6d 65 20 74 65 73 74 73 74 65 70 2d 6e 61 6d ame teststep-nam
4260: 65 20 73 74 61 74 65 2d 69 6e 20 73 74 61 74 75 e state-in statu
4270: 73 2d 69 6e 20 69 74 65 6d 64 61 74 20 63 6f 6d s-in itemdat com
4280: 6d 65 6e 74 20 6c 6f 67 66 69 6c 65 29 0a 20 20 ment logfile).
4290: 28 64 65 62 75 67 3a 70 72 69 6e 74 20 34 20 22 (debug:print 4 "
42a0: 72 75 6e 2d 69 64 3a 20 22 20 72 75 6e 2d 69 64 run-id: " run-id
42b0: 20 22 20 74 65 73 74 2d 6e 61 6d 65 3a 20 22 20 " test-name: "
42c0: 74 65 73 74 2d 6e 61 6d 65 29 0a 20 20 28 6c 65 test-name). (le
42d0: 74 2a 20 28 28 73 74 61 74 65 20 20 20 20 20 28 t* ((state (
42e0: 63 68 65 63 6b 2d 76 61 6c 69 64 2d 69 74 65 6d check-valid-item
42f0: 73 20 22 73 74 61 74 65 22 20 73 74 61 74 65 2d s "state" state-
4300: 69 6e 29 29 0a 09 20 28 73 74 61 74 75 73 20 20 in)).. (status
4310: 20 20 28 63 68 65 63 6b 2d 76 61 6c 69 64 2d 69 (check-valid-i
4320: 74 65 6d 73 20 22 73 74 61 74 75 73 22 20 73 74 tems "status" st
4330: 61 74 75 73 2d 69 6e 29 29 0a 09 20 28 69 74 65 atus-in)).. (ite
4340: 6d 2d 70 61 74 68 20 28 69 74 65 6d 2d 6c 69 73 m-path (item-lis
4350: 74 2d 3e 70 61 74 68 20 69 74 65 6d 64 61 74 29 t->path itemdat)
4360: 29 0a 09 20 28 74 65 73 74 64 61 74 20 20 20 28 ).. (testdat (
4370: 64 62 3a 67 65 74 2d 74 65 73 74 2d 69 6e 66 6f db:get-test-info
4380: 20 64 62 20 72 75 6e 2d 69 64 20 74 65 73 74 2d db run-id test-
4390: 6e 61 6d 65 20 69 74 65 6d 2d 70 61 74 68 29 29 name item-path))
43a0: 29 0a 20 20 20 20 28 64 65 62 75 67 3a 70 72 69 ). (debug:pri
43b0: 6e 74 20 35 20 22 74 65 73 74 64 61 74 3a 20 22 nt 5 "testdat: "
43c0: 20 74 65 73 74 64 61 74 29 0a 20 20 20 20 28 69 testdat). (i
43d0: 66 20 28 61 6e 64 20 74 65 73 74 64 61 74 20 3b f (and testdat ;
43e0: 3b 20 69 66 20 74 68 65 20 73 65 63 74 69 6f 6e ; if the section
43f0: 20 65 78 69 73 74 73 20 74 68 65 6e 20 66 6f 72 exists then for
4400: 63 65 20 73 70 65 63 69 66 69 63 61 74 69 6f 6e ce specification
4410: 20 42 55 47 2c 20 49 20 64 6f 6e 27 74 20 6c 69 BUG, I don't li
4420: 6b 65 20 68 6f 77 20 74 68 69 73 20 77 6f 72 6b ke how this work
4430: 73 2e 0a 09 20 20 20 20 20 28 6f 72 20 28 6e 6f s... (or (no
4440: 74 20 73 74 61 74 65 29 28 6e 6f 74 20 73 74 61 t state)(not sta
4450: 74 75 73 29 29 29 0a 09 28 64 65 62 75 67 3a 70 tus)))..(debug:p
4460: 72 69 6e 74 20 30 20 22 57 41 52 4e 49 4e 47 3a rint 0 "WARNING:
4470: 20 49 6e 76 61 6c 69 64 20 22 20 28 69 66 20 73 Invalid " (if s
4480: 74 61 74 75 73 20 22 73 74 61 74 75 73 22 20 22 tatus "status" "
4490: 73 74 61 74 65 22 29 0a 09 20 20 20 20 20 20 20 state")..
44a0: 22 20 76 61 6c 75 65 20 5c 22 22 20 28 69 66 20 " value \"" (if
44b0: 73 74 61 74 75 73 20 73 74 61 74 65 2d 69 6e 20 status state-in
44c0: 73 74 61 74 75 73 2d 69 6e 29 20 22 5c 22 2c 20 status-in) "\",
44d0: 75 70 64 61 74 65 20 79 6f 75 72 20 76 61 6c 69 update your vali
44e0: 64 76 61 6c 75 65 73 20 73 65 63 74 69 6f 6e 20 dvalues section
44f0: 69 6e 20 6d 65 67 61 74 65 73 74 2e 63 6f 6e 66 in megatest.conf
4500: 69 67 22 29 29 0a 20 20 20 20 28 69 66 20 74 65 ig")). (if te
4510: 73 74 64 61 74 0a 09 28 6c 65 74 20 28 28 74 65 stdat..(let ((te
4520: 73 74 2d 69 64 20 28 74 65 73 74 3a 67 65 74 2d st-id (test:get-
4530: 69 64 20 74 65 73 74 64 61 74 29 29 29 0a 09 20 id testdat)))..
4540: 20 3b 3b 20 46 49 58 4d 45 20 2d 20 74 68 69 73 ;; FIXME - this
4550: 20 73 68 6f 75 6c 64 20 6e 6f 74 20 75 70 64 61 should not upda
4560: 74 65 20 74 68 65 20 6c 6f 67 66 69 6c 65 20 75 te the logfile u
4570: 6e 6c 65 73 73 20 69 74 20 69 73 20 73 70 65 63 nless it is spec
4580: 69 66 69 65 64 2e 0a 09 20 20 28 73 71 6c 69 74 ified... (sqlit
4590: 65 33 3a 65 78 65 63 75 74 65 20 64 62 20 0a 09 e3:execute db ..
45a0: 09 09 22 49 4e 53 45 52 54 20 4f 52 20 52 45 50 .."INSERT OR REP
45b0: 4c 41 43 45 20 69 6e 74 6f 20 74 65 73 74 5f 73 LACE into test_s
45c0: 74 65 70 73 20 28 74 65 73 74 5f 69 64 2c 73 74 teps (test_id,st
45d0: 65 70 6e 61 6d 65 2c 73 74 61 74 65 2c 73 74 61 epname,state,sta
45e0: 74 75 73 2c 65 76 65 6e 74 5f 74 69 6d 65 2c 63 tus,event_time,c
45f0: 6f 6d 6d 65 6e 74 2c 6c 6f 67 66 69 6c 65 29 20 omment,logfile)
4600: 56 41 4c 55 45 53 28 3f 2c 3f 2c 3f 2c 3f 2c 73 VALUES(?,?,?,?,s
4610: 74 72 66 74 69 6d 65 28 27 25 73 27 2c 27 6e 6f trftime('%s','no
4620: 77 27 29 2c 3f 2c 3f 29 3b 22 0a 09 09 09 74 65 w'),?,?);"....te
4630: 73 74 2d 69 64 20 74 65 73 74 73 74 65 70 2d 6e st-id teststep-n
4640: 61 6d 65 20 73 74 61 74 65 2d 69 6e 20 73 74 61 ame state-in sta
4650: 74 75 73 2d 69 6e 20 28 69 66 20 63 6f 6d 6d 65 tus-in (if comme
4660: 6e 74 20 63 6f 6d 6d 65 6e 74 20 22 22 29 20 28 nt comment "") (
4670: 69 66 20 6c 6f 67 66 69 6c 65 20 6c 6f 67 66 69 if logfile logfi
4680: 6c 65 20 22 22 29 29 29 0a 09 28 64 65 62 75 67 le "")))..(debug
4690: 3a 70 72 69 6e 74 20 30 20 22 45 52 52 4f 52 3a :print 0 "ERROR:
46a0: 20 43 61 6e 27 74 20 75 70 64 61 74 65 20 22 20 Can't update "
46b0: 74 65 73 74 2d 6e 61 6d 65 20 22 20 66 6f 72 20 test-name " for
46c0: 72 75 6e 20 22 20 72 75 6e 2d 69 64 20 22 20 2d run " run-id " -
46d0: 3e 20 6e 6f 20 73 75 63 68 20 74 65 73 74 20 69 > no such test i
46e0: 6e 20 64 62 22 29 29 29 29 0a 0a 28 64 65 66 69 n db"))))..(defi
46f0: 6e 65 20 28 74 65 73 74 2d 67 65 74 2d 6b 69 6c ne (test-get-kil
4700: 6c 2d 72 65 71 75 65 73 74 20 64 62 20 72 75 6e l-request db run
4710: 2d 69 64 20 74 65 73 74 2d 6e 61 6d 65 20 69 74 -id test-name it
4720: 65 6d 64 61 74 29 0a 20 20 28 6c 65 74 2a 20 28 emdat). (let* (
4730: 28 69 74 65 6d 2d 70 61 74 68 20 28 69 74 65 6d (item-path (item
4740: 2d 6c 69 73 74 2d 3e 70 61 74 68 20 69 74 65 6d -list->path item
4750: 64 61 74 29 29 0a 09 20 28 74 65 73 74 64 61 74 dat)).. (testdat
4760: 20 20 20 28 64 62 3a 67 65 74 2d 74 65 73 74 2d (db:get-test-
4770: 69 6e 66 6f 20 64 62 20 72 75 6e 2d 69 64 20 74 info db run-id t
4780: 65 73 74 2d 6e 61 6d 65 20 69 74 65 6d 2d 70 61 est-name item-pa
4790: 74 68 29 29 29 0a 20 20 20 20 28 65 71 75 61 6c th))). (equal
47a0: 3f 20 28 74 65 73 74 3a 67 65 74 2d 73 74 61 74 ? (test:get-stat
47b0: 65 20 74 65 73 74 64 61 74 29 20 22 4b 49 4c 4c e testdat) "KILL
47c0: 52 45 51 22 29 29 29 0a 0a 28 64 65 66 69 6e 65 REQ")))..(define
47d0: 20 28 74 65 73 74 2d 73 65 74 2d 6d 65 74 61 2d (test-set-meta-
47e0: 69 6e 66 6f 20 64 62 20 72 75 6e 2d 69 64 20 74 info db run-id t
47f0: 65 73 74 6e 61 6d 65 20 69 74 65 6d 64 61 74 29 estname itemdat)
4800: 0a 20 20 28 6c 65 74 20 28 28 69 74 65 6d 2d 70 . (let ((item-p
4810: 61 74 68 20 28 69 74 65 6d 2d 6c 69 73 74 2d 3e ath (item-list->
4820: 70 61 74 68 20 69 74 65 6d 64 61 74 29 29 0a 09 path itemdat))..
4830: 28 63 70 75 6c 6f 61 64 20 20 28 67 65 74 2d 63 (cpuload (get-c
4840: 70 75 2d 6c 6f 61 64 29 29 0a 09 28 68 6f 73 74 pu-load))..(host
4850: 6e 61 6d 65 20 28 67 65 74 2d 68 6f 73 74 2d 6e name (get-host-n
4860: 61 6d 65 29 29 0a 09 28 64 69 73 6b 66 72 65 65 ame))..(diskfree
4870: 20 28 67 65 74 2d 64 66 20 28 63 75 72 72 65 6e (get-df (curren
4880: 74 2d 64 69 72 65 63 74 6f 72 79 29 29 29 0a 09 t-directory)))..
4890: 28 75 6e 61 6d 65 20 20 20 20 28 67 65 74 2d 75 (uname (get-u
48a0: 6e 61 6d 65 20 22 2d 73 72 76 70 69 6f 22 29 29 name "-srvpio"))
48b0: 0a 09 28 72 75 6e 70 61 74 68 20 20 28 63 75 72 ..(runpath (cur
48c0: 72 65 6e 74 2d 64 69 72 65 63 74 6f 72 79 29 29 rent-directory))
48d0: 29 0a 20 20 20 20 28 73 71 6c 69 74 65 33 3a 65 ). (sqlite3:e
48e0: 78 65 63 75 74 65 20 64 62 20 22 55 50 44 41 54 xecute db "UPDAT
48f0: 45 20 74 65 73 74 73 20 53 45 54 20 68 6f 73 74 E tests SET host
4900: 3d 3f 2c 63 70 75 6c 6f 61 64 3d 3f 2c 64 69 73 =?,cpuload=?,dis
4910: 6b 66 72 65 65 3d 3f 2c 75 6e 61 6d 65 3d 3f 2c kfree=?,uname=?,
4920: 72 75 6e 64 69 72 3d 3f 20 57 48 45 52 45 20 72 rundir=? WHERE r
4930: 75 6e 5f 69 64 3d 3f 20 41 4e 44 20 74 65 73 74 un_id=? AND test
4940: 6e 61 6d 65 3d 3f 20 41 4e 44 20 69 74 65 6d 5f name=? AND item_
4950: 70 61 74 68 3d 3f 3b 22 0a 09 09 20 20 68 6f 73 path=?;"... hos
4960: 74 6e 61 6d 65 0a 09 09 20 20 63 70 75 6c 6f 61 tname... cpuloa
4970: 64 0a 09 09 20 20 64 69 73 6b 66 72 65 65 0a 09 d... diskfree..
4980: 09 20 20 75 6e 61 6d 65 0a 09 09 20 20 72 75 6e . uname... run
4990: 70 61 74 68 0a 09 09 20 20 72 75 6e 2d 69 64 0a path... run-id.
49a0: 09 09 20 20 74 65 73 74 6e 61 6d 65 0a 09 09 20 .. testname...
49b0: 20 69 74 65 6d 2d 70 61 74 68 29 29 29 0a 0a 28 item-path)))..(
49c0: 64 65 66 69 6e 65 20 28 74 65 73 74 2d 75 70 64 define (test-upd
49d0: 61 74 65 2d 6d 65 74 61 2d 69 6e 66 6f 20 64 62 ate-meta-info db
49e0: 20 72 75 6e 2d 69 64 20 74 65 73 74 6e 61 6d 65 run-id testname
49f0: 20 69 74 65 6d 64 61 74 20 6d 69 6e 75 74 65 73 itemdat minutes
4a00: 20 63 70 75 6c 6f 61 64 20 64 69 73 6b 66 72 65 cpuload diskfre
4a10: 65 20 74 6d 70 66 72 65 65 29 0a 20 20 28 6c 65 e tmpfree). (le
4a20: 74 20 28 28 69 74 65 6d 2d 70 61 74 68 20 28 69 t ((item-path (i
4a30: 74 65 6d 2d 6c 69 73 74 2d 3e 70 61 74 68 20 69 tem-list->path i
4a40: 74 65 6d 64 61 74 29 29 29 0a 20 20 20 20 28 69 temdat))). (i
4a50: 66 20 28 6e 6f 74 20 69 74 65 6d 2d 70 61 74 68 f (not item-path
4a60: 29 28 62 65 67 69 6e 20 28 64 65 62 75 67 3a 70 )(begin (debug:p
4a70: 72 69 6e 74 20 30 20 22 57 41 52 4e 49 4e 47 3a rint 0 "WARNING:
4a80: 20 49 54 45 4d 50 41 54 48 20 6e 6f 74 20 73 65 ITEMPATH not se
4a90: 74 2e 22 29 20 20 20 28 73 65 74 21 20 69 74 65 t.") (set! ite
4aa0: 6d 2d 70 61 74 68 20 22 22 29 29 29 0a 20 20 20 m-path ""))).
4ab0: 20 3b 3b 20 28 6c 65 74 20 28 28 74 65 73 74 69 ;; (let ((testi
4ac0: 6e 66 6f 20 28 64 62 3a 67 65 74 2d 74 65 73 74 nfo (db:get-test
4ad0: 2d 69 6e 66 6f 20 64 62 20 72 75 6e 2d 69 64 20 -info db run-id
4ae0: 74 65 73 74 6e 61 6d 65 20 69 74 65 6d 2d 70 61 testname item-pa
4af0: 74 68 29 29 29 0a 20 20 20 20 3b 3b 20 20 20 28 th))). ;; (
4b00: 69 66 20 28 61 6e 64 20 28 6e 6f 74 20 28 65 71 if (and (not (eq
4b10: 75 61 6c 3f 20 28 64 62 3a 74 65 73 74 2d 67 65 ual? (db:test-ge
4b20: 74 2d 73 74 61 74 75 73 20 74 65 73 74 69 6e 66 t-status testinf
4b30: 6f 29 20 22 43 4f 4d 50 4c 45 54 45 44 22 29 29 o) "COMPLETED"))
4b40: 0a 20 20 20 20 3b 3b 20 20 20 20 20 20 20 20 20 . ;;
4b50: 20 20 20 28 6e 6f 74 20 28 65 71 75 61 6c 3f 20 (not (equal?
4b60: 28 64 62 3a 74 65 73 74 2d 67 65 74 2d 73 74 61 (db:test-get-sta
4b70: 74 75 73 20 74 65 73 74 69 6e 66 6f 29 20 22 4b tus testinfo) "K
4b80: 49 4c 4c 52 45 51 22 29 29 0a 20 20 20 20 28 73 ILLREQ")). (s
4b90: 71 6c 69 74 65 33 3a 65 78 65 63 75 74 65 0a 20 qlite3:execute.
4ba0: 20 20 20 20 64 62 0a 20 20 20 20 20 22 55 50 44 db. "UPD
4bb0: 41 54 45 20 74 65 73 74 73 20 53 45 54 20 63 70 ATE tests SET cp
4bc0: 75 6c 6f 61 64 3d 3f 2c 64 69 73 6b 66 72 65 65 uload=?,diskfree
4bd0: 3d 3f 2c 72 75 6e 5f 64 75 72 61 74 69 6f 6e 3d =?,run_duration=
4be0: 3f 2c 73 74 61 74 65 3d 27 52 55 4e 4e 49 4e 47 ?,state='RUNNING
4bf0: 27 20 57 48 45 52 45 20 72 75 6e 5f 69 64 3d 3f ' WHERE run_id=?
4c00: 20 41 4e 44 20 74 65 73 74 6e 61 6d 65 3d 3f 20 AND testname=?
4c10: 41 4e 44 20 69 74 65 6d 5f 70 61 74 68 3d 3f 20 AND item_path=?
4c20: 41 4e 44 20 73 74 61 74 65 20 4e 4f 54 20 49 4e AND state NOT IN
4c30: 20 28 27 43 4f 4d 50 4c 45 54 45 44 27 2c 27 4b ('COMPLETED','K
4c40: 49 4c 4c 52 45 51 27 2c 27 4b 49 4c 4c 45 44 27 ILLREQ','KILLED'
4c50: 29 3b 22 0a 20 20 20 20 20 63 70 75 6c 6f 61 64 );". cpuload
4c60: 0a 20 20 20 20 20 64 69 73 6b 66 72 65 65 0a 20 . diskfree.
4c70: 20 20 20 20 6d 69 6e 75 74 65 73 0a 20 20 20 20 minutes.
4c80: 20 72 75 6e 2d 69 64 0a 20 20 20 20 20 74 65 73 run-id. tes
4c90: 74 6e 61 6d 65 0a 20 20 20 20 20 69 74 65 6d 2d tname. item-
4ca0: 70 61 74 68 29 29 29 0a 0a path)))..