0000: 3b 3b 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ;;==============
0010: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0020: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0030: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0040: 3d 3d 3d 3d 3d 3d 3d 3d 0a 3b 3b 20 43 6f 70 79 ========.;; Copy
0050: 72 69 67 68 74 20 32 30 30 36 2d 32 30 31 33 2c right 2006-2013,
0060: 20 4d 61 74 74 68 65 77 20 57 65 6c 6c 61 6e 64 Matthew Welland
0070: 2e 0a 3b 3b 20 0a 3b 3b 20 54 68 69 73 20 66 69 ..;; .;; This fi
0080: 6c 65 20 69 73 20 70 61 72 74 20 6f 66 20 4d 65 le is part of Me
0090: 67 61 74 65 73 74 2e 0a 3b 3b 20 0a 3b 3b 20 20 gatest..;; .;;
00a0: 20 20 20 4d 65 67 61 74 65 73 74 20 69 73 20 66 Megatest is f
00b0: 72 65 65 20 73 6f 66 74 77 61 72 65 3a 20 79 6f ree software: yo
00c0: 75 20 63 61 6e 20 72 65 64 69 73 74 72 69 62 75 u can redistribu
00d0: 74 65 20 69 74 20 61 6e 64 2f 6f 72 20 6d 6f 64 te it and/or mod
00e0: 69 66 79 0a 3b 3b 20 20 20 20 20 69 74 20 75 6e ify.;; it un
00f0: 64 65 72 20 74 68 65 20 74 65 72 6d 73 20 6f 66 der the terms of
0100: 20 74 68 65 20 47 4e 55 20 47 65 6e 65 72 61 6c the GNU General
0110: 20 50 75 62 6c 69 63 20 4c 69 63 65 6e 73 65 20 Public License
0120: 61 73 20 70 75 62 6c 69 73 68 65 64 20 62 79 0a as published by.
0130: 3b 3b 20 20 20 20 20 74 68 65 20 46 72 65 65 20 ;; the Free
0140: 53 6f 66 74 77 61 72 65 20 46 6f 75 6e 64 61 74 Software Foundat
0150: 69 6f 6e 2c 20 65 69 74 68 65 72 20 76 65 72 73 ion, either vers
0160: 69 6f 6e 20 33 20 6f 66 20 74 68 65 20 4c 69 63 ion 3 of the Lic
0170: 65 6e 73 65 2c 20 6f 72 0a 3b 3b 20 20 20 20 20 ense, or.;;
0180: 28 61 74 20 79 6f 75 72 20 6f 70 74 69 6f 6e 29 (at your option)
0190: 20 61 6e 79 20 6c 61 74 65 72 20 76 65 72 73 69 any later versi
01a0: 6f 6e 2e 0a 3b 3b 20 0a 3b 3b 20 20 20 20 20 4d on..;; .;; M
01b0: 65 67 61 74 65 73 74 20 69 73 20 64 69 73 74 72 egatest is distr
01c0: 69 62 75 74 65 64 20 69 6e 20 74 68 65 20 68 6f ibuted in the ho
01d0: 70 65 20 74 68 61 74 20 69 74 20 77 69 6c 6c 20 pe that it will
01e0: 62 65 20 75 73 65 66 75 6c 2c 0a 3b 3b 20 20 20 be useful,.;;
01f0: 20 20 62 75 74 20 57 49 54 48 4f 55 54 20 41 4e but WITHOUT AN
0200: 59 20 57 41 52 52 41 4e 54 59 3b 20 77 69 74 68 Y WARRANTY; with
0210: 6f 75 74 20 65 76 65 6e 20 74 68 65 20 69 6d 70 out even the imp
0220: 6c 69 65 64 20 77 61 72 72 61 6e 74 79 20 6f 66 lied warranty of
0230: 0a 3b 3b 20 20 20 20 20 4d 45 52 43 48 41 4e 54 .;; MERCHANT
0240: 41 42 49 4c 49 54 59 20 6f 72 20 46 49 54 4e 45 ABILITY or FITNE
0250: 53 53 20 46 4f 52 20 41 20 50 41 52 54 49 43 55 SS FOR A PARTICU
0260: 4c 41 52 20 50 55 52 50 4f 53 45 2e 20 20 53 65 LAR PURPOSE. Se
0270: 65 20 74 68 65 0a 3b 3b 20 20 20 20 20 47 4e 55 e the.;; GNU
0280: 20 47 65 6e 65 72 61 6c 20 50 75 62 6c 69 63 20 General Public
0290: 4c 69 63 65 6e 73 65 20 66 6f 72 20 6d 6f 72 65 License for more
02a0: 20 64 65 74 61 69 6c 73 2e 0a 3b 3b 20 0a 3b 3b details..;; .;;
02b0: 20 20 20 20 20 59 6f 75 20 73 68 6f 75 6c 64 20 You should
02c0: 68 61 76 65 20 72 65 63 65 69 76 65 64 20 61 20 have received a
02d0: 63 6f 70 79 20 6f 66 20 74 68 65 20 47 4e 55 20 copy of the GNU
02e0: 47 65 6e 65 72 61 6c 20 50 75 62 6c 69 63 20 4c General Public L
02f0: 69 63 65 6e 73 65 0a 3b 3b 20 20 20 20 20 61 6c icense.;; al
0300: 6f 6e 67 20 77 69 74 68 20 4d 65 67 61 74 65 73 ong with Megates
0310: 74 2e 20 20 49 66 20 6e 6f 74 2c 20 73 65 65 20 t. If not, see
0320: 3c 68 74 74 70 3a 2f 2f 77 77 77 2e 67 6e 75 2e <http://www.gnu.
0330: 6f 72 67 2f 6c 69 63 65 6e 73 65 73 2f 3e 2e 0a org/licenses/>..
0340: 3b 3b 0a 3b 3b 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ;;.;;===========
0350: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0360: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0370: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0380: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 0a 3b 3b 3d ===========..;;=
0390: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
03a0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
03b0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
03c0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
03d0: 3d 3d 3d 3d 3d 0a 3b 3b 20 44 61 74 61 62 61 73 =====.;; Databas
03e0: 65 20 61 63 63 65 73 73 0a 3b 3b 3d 3d 3d 3d 3d e access.;;=====
03f0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0400: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0410: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0420: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0430: 3d 0a 0a 28 72 65 71 75 69 72 65 2d 65 78 74 65 =..(require-exte
0440: 6e 73 69 6f 6e 20 28 73 72 66 69 20 31 38 29 20 nsion (srfi 18)
0450: 65 78 74 72 61 73 20 74 63 70 29 0a 28 75 73 65 extras tcp).(use
0460: 20 73 71 6c 69 74 65 33 20 73 72 66 69 2d 31 20 sqlite3 srfi-1
0470: 70 6f 73 69 78 20 72 65 67 65 78 20 72 65 67 65 posix regex rege
0480: 78 2d 63 61 73 65 20 73 72 66 69 2d 36 39 20 63 x-case srfi-69 c
0490: 73 76 2d 78 6d 6c 20 73 31 31 6e 20 6d 64 35 20 sv-xml s11n md5
04a0: 6d 65 73 73 61 67 65 2d 64 69 67 65 73 74 20 62 message-digest b
04b0: 61 73 65 36 34 29 0a 28 69 6d 70 6f 72 74 20 28 ase64).(import (
04c0: 70 72 65 66 69 78 20 73 71 6c 69 74 65 33 20 73 prefix sqlite3 s
04d0: 71 6c 69 74 65 33 3a 29 29 0a 28 69 6d 70 6f 72 qlite3:)).(impor
04e0: 74 20 28 70 72 65 66 69 78 20 62 61 73 65 36 34 t (prefix base64
04f0: 20 62 61 73 65 36 34 3a 29 29 0a 0a 28 64 65 63 base64:))..(dec
0500: 6c 61 72 65 20 28 75 6e 69 74 20 74 64 62 29 29 lare (unit tdb))
0510: 0a 28 64 65 63 6c 61 72 65 20 28 75 73 65 73 20 .(declare (uses
0520: 63 6f 6d 6d 6f 6e 29 29 0a 28 64 65 63 6c 61 72 common)).(declar
0530: 65 20 28 75 73 65 73 20 6b 65 79 73 29 29 0a 28 e (uses keys)).(
0540: 64 65 63 6c 61 72 65 20 28 75 73 65 73 20 63 6c declare (uses cl
0550: 69 65 6e 74 29 29 0a 28 64 65 63 6c 61 72 65 20 ient)).(declare
0560: 28 75 73 65 73 20 6d 74 29 29 0a 28 64 65 63 6c (uses mt)).(decl
0570: 61 72 65 20 28 75 73 65 73 20 64 62 29 29 0a 0a are (uses db))..
0580: 28 64 65 63 6c 61 72 65 20 28 75 73 65 73 20 63 (declare (uses c
0590: 6f 6d 6d 6f 6e 6d 6f 64 29 29 0a 28 69 6d 70 6f ommonmod)).(impo
05a0: 72 74 20 63 6f 6d 6d 6f 6e 6d 6f 64 29 0a 0a 28 rt commonmod)..(
05b0: 64 65 63 6c 61 72 65 20 28 75 73 65 73 20 64 62 declare (uses db
05c0: 6d 6f 64 29 29 0a 28 69 6d 70 6f 72 74 20 64 62 mod)).(import db
05d0: 6d 6f 64 29 0a 0a 28 64 65 63 6c 61 72 65 20 28 mod)..(declare (
05e0: 75 73 65 73 20 6f 64 73 29 29 0a 28 69 6d 70 6f uses ods)).(impo
05f0: 72 74 20 6f 64 73 29 0a 0a 28 69 6e 63 6c 75 64 rt ods)..(includ
0600: 65 20 22 63 6f 6d 6d 6f 6e 5f 72 65 63 6f 72 64 e "common_record
0610: 73 2e 73 63 6d 22 29 0a 28 69 6e 63 6c 75 64 65 s.scm").(include
0620: 20 22 64 62 5f 72 65 63 6f 72 64 73 2e 73 63 6d "db_records.scm
0630: 22 29 0a 28 69 6e 63 6c 75 64 65 20 22 6b 65 79 ").(include "key
0640: 5f 72 65 63 6f 72 64 73 2e 73 63 6d 22 29 0a 28 _records.scm").(
0650: 69 6e 63 6c 75 64 65 20 22 72 75 6e 5f 72 65 63 include "run_rec
0660: 6f 72 64 73 2e 73 63 6d 22 29 0a 0a 3b 3b 3d 3d ords.scm")..;;==
0670: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0680: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0690: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
06a0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
06b0: 3d 3d 3d 3d 0a 3b 3b 0a 3b 3b 20 54 20 45 20 53 ====.;;.;; T E S
06c0: 20 54 20 20 20 44 20 41 20 54 20 41 20 42 20 41 T D A T A B A
06d0: 20 53 20 45 20 53 0a 3b 3b 0a 3b 3b 3d 3d 3d 3d S E S.;;.;;====
06e0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
06f0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0700: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0710: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0720: 3d 3d 0a 0a 3b 3b 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ==..;;==========
0730: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0740: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0750: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
0760: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 3b 3b 20 ============.;;
0770: 54 20 45 20 53 20 54 20 20 20 53 20 50 20 45 20 T E S T S P E
0780: 43 20 49 20 46 20 49 20 43 20 20 20 44 20 42 20 C I F I C D B
0790: 0a 3b 3b 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d .;;=============
07a0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
07b0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
07c0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
07d0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 0a 3b 3b 20 43 72 =========..;; Cr
07e0: 65 61 74 65 20 74 68 65 20 73 71 6c 69 74 65 20 eate the sqlite
07f0: 64 62 20 66 6f 72 20 74 68 65 20 69 6e 64 69 76 db for the indiv
0800: 69 64 75 61 6c 20 74 65 73 74 28 73 29 0a 3b 3b idual test(s).;;
0810: 0a 3b 3b 20 4d 6f 76 65 64 20 74 68 65 73 65 20 .;; Moved these
0820: 74 61 62 6c 65 73 20 69 6e 74 6f 20 3c 72 75 6e tables into <run
0830: 69 64 3e 2e 64 62 0a 3b 3b 20 54 48 49 53 20 43 id>.db.;; THIS C
0840: 4f 44 45 20 54 4f 20 42 45 20 52 45 4d 4f 56 45 ODE TO BE REMOVE
0850: 44 0a 3b 3b 0a 28 64 65 66 69 6e 65 20 28 6f 70 D.;;.(define (op
0860: 65 6e 2d 74 65 73 74 2d 64 62 20 77 6f 72 6b 2d en-test-db work-
0870: 61 72 65 61 29 20 0a 20 20 28 64 65 62 75 67 3a area) . (debug:
0880: 70 72 69 6e 74 2d 69 6e 66 6f 20 31 31 20 2a 64 print-info 11 *d
0890: 65 66 61 75 6c 74 2d 6c 6f 67 2d 70 6f 72 74 2a efault-log-port*
08a0: 20 22 6f 70 65 6e 2d 74 65 73 74 2d 64 62 20 22 "open-test-db "
08b0: 20 77 6f 72 6b 2d 61 72 65 61 29 0a 20 20 28 69 work-area). (i
08c0: 66 20 28 61 6e 64 20 77 6f 72 6b 2d 61 72 65 61 f (and work-area
08d0: 20 0a 09 20 20 20 28 64 69 72 65 63 74 6f 72 79 .. (directory
08e0: 3f 20 77 6f 72 6b 2d 61 72 65 61 29 0a 09 20 20 ? work-area)..
08f0: 20 28 66 69 6c 65 2d 72 65 61 64 2d 61 63 63 65 (file-read-acce
0900: 73 73 3f 20 77 6f 72 6b 2d 61 72 65 61 29 29 0a ss? work-area)).
0910: 20 20 20 20 20 20 28 6c 65 74 2a 20 28 28 64 62 (let* ((db
0920: 70 61 74 68 20 20 20 20 20 20 20 20 20 20 20 20 path
0930: 20 20 28 63 6f 6e 63 20 77 6f 72 6b 2d 61 72 65 (conc work-are
0940: 61 20 22 2f 74 65 73 74 64 61 74 2e 64 62 22 29 a "/testdat.db")
0950: 29 0a 09 20 20 20 20 20 28 64 62 65 78 69 73 74 ).. (dbexist
0960: 73 20 20 20 20 20 20 20 20 20 20 20 20 28 63 6f s (co
0970: 6d 6d 6f 6e 3a 66 69 6c 65 2d 65 78 69 73 74 73 mmon:file-exists
0980: 3f 20 64 62 70 61 74 68 29 29 0a 09 20 20 20 20 ? dbpath))..
0990: 20 28 77 6f 72 6b 2d 61 72 65 61 2d 77 72 69 74 (work-area-writ
09a0: 65 61 62 6c 65 20 28 66 69 6c 65 2d 77 72 69 74 eable (file-writ
09b0: 65 2d 61 63 63 65 73 73 3f 20 77 6f 72 6b 2d 61 e-access? work-a
09c0: 72 65 61 29 29 0a 09 20 20 20 20 20 28 64 62 20 rea)).. (db
09d0: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
09e0: 20 28 68 61 6e 64 6c 65 2d 65 78 63 65 70 74 69 (handle-excepti
09f0: 6f 6e 73 20 20 3b 3b 20 6f 70 65 6e 20 74 68 65 ons ;; open the
0a00: 20 64 62 20 69 66 20 61 72 65 61 20 77 72 69 74 db if area writ
0a10: 65 61 62 6c 65 20 6f 72 20 64 62 20 70 72 65 2d eable or db pre-
0a20: 65 78 69 73 74 69 6e 67 2e 20 6f 70 65 6e 20 69 existing. open i
0a30: 6e 2d 6d 65 6d 20 6f 74 68 65 72 77 69 73 65 2e n-mem otherwise.
0a40: 20 69 66 20 65 78 63 65 70 74 69 6f 6e 2c 20 6f if exception, o
0a50: 70 65 6e 20 69 6e 2d 6d 65 6d 0a 09 09 09 09 20 pen in-mem.....
0a60: 20 20 65 78 6e 0a 09 09 09 09 20 20 20 28 62 65 exn..... (be
0a70: 67 69 6e 0a 09 09 09 09 20 20 20 20 20 28 70 72 gin..... (pr
0a80: 69 6e 74 2d 63 61 6c 6c 2d 63 68 61 69 6e 20 28 int-call-chain (
0a90: 63 75 72 72 65 6e 74 2d 65 72 72 6f 72 2d 70 6f current-error-po
0aa0: 72 74 29 29 0a 09 09 09 09 20 20 20 20 20 28 64 rt))..... (d
0ab0: 65 62 75 67 3a 70 72 69 6e 74 20 32 20 2a 64 65 ebug:print 2 *de
0ac0: 66 61 75 6c 74 2d 6c 6f 67 2d 70 6f 72 74 2a 20 fault-log-port*
0ad0: 22 45 52 52 4f 52 3a 20 70 72 6f 62 6c 65 6d 20 "ERROR: problem
0ae0: 61 63 63 65 73 73 69 6e 67 20 74 65 73 74 20 64 accessing test d
0af0: 62 20 22 20 77 6f 72 6b 2d 61 72 65 61 20 22 2c b " work-area ",
0b00: 20 79 6f 75 20 70 72 6f 62 61 62 6c 79 20 73 68 you probably sh
0b10: 6f 75 6c 64 20 63 6c 65 61 6e 20 61 6e 64 20 72 ould clean and r
0b20: 65 2d 72 75 6e 20 74 68 69 73 20 74 65 73 74 22 e-run this test"
0b30: 0a 09 09 09 09 09 09 20 20 28 28 63 6f 6e 64 69 ....... ((condi
0b40: 74 69 6f 6e 2d 70 72 6f 70 65 72 74 79 2d 61 63 tion-property-ac
0b50: 63 65 73 73 6f 72 20 27 65 78 6e 20 27 6d 65 73 cessor 'exn 'mes
0b60: 73 61 67 65 29 20 65 78 6e 29 29 0a 09 09 09 09 sage) exn)).....
0b70: 20 20 20 20 20 28 73 65 74 21 20 64 62 65 78 69 (set! dbexi
0b80: 73 74 73 20 23 66 29 20 3b 3b 20 6d 75 73 74 20 sts #f) ;; must
0b90: 66 6f 72 63 65 20 72 65 2d 63 72 65 61 74 69 6f force re-creatio
0ba0: 6e 20 6f 66 20 74 61 62 6c 65 73 2c 20 6d 6f 72 n of tables, mor
0bb0: 65 20 74 6f 6d 2d 66 6f 6f 6c 65 72 79 0a 09 09 e tom-foolery...
0bc0: 09 09 20 20 20 20 20 28 73 71 6c 69 74 65 33 3a .. (sqlite3:
0bd0: 6f 70 65 6e 2d 64 61 74 61 62 61 73 65 20 22 3a open-database ":
0be0: 6d 65 6d 6f 72 79 3a 22 29 29 20 3b 3b 20 6f 70 memory:")) ;; op
0bf0: 65 6e 20 61 6e 20 69 6e 2d 6d 65 6d 6f 72 79 20 en an in-memory
0c00: 64 62 20 74 6f 20 61 6c 6c 6f 77 20 72 65 61 64 db to allow read
0c10: 6f 6e 6c 79 20 61 63 63 65 73 73 20 0a 09 09 09 only access ....
0c20: 09 20 20 20 28 69 66 20 28 6f 72 20 77 6f 72 6b . (if (or work
0c30: 2d 61 72 65 61 2d 77 72 69 74 65 61 62 6c 65 0a -area-writeable.
0c40: 09 09 09 09 09 20 20 20 64 62 65 78 69 73 74 73 ..... dbexists
0c50: 29 0a 09 09 09 09 20 20 20 20 20 20 20 28 73 71 )..... (sq
0c60: 6c 69 74 65 33 3a 6f 70 65 6e 2d 64 61 74 61 62 lite3:open-datab
0c70: 61 73 65 20 64 62 70 61 74 68 29 0a 09 09 09 09 ase dbpath).....
0c80: 20 20 20 20 20 20 20 28 73 71 6c 69 74 65 33 3a (sqlite3:
0c90: 6f 70 65 6e 2d 64 61 74 61 62 61 73 65 20 22 3a open-database ":
0ca0: 6d 65 6d 6f 72 79 3a 22 29 29 29 29 0a 09 20 20 memory:"))))..
0cb0: 20 20 20 28 74 64 62 2d 77 72 69 74 65 61 62 6c (tdb-writeabl
0cc0: 65 20 20 20 20 20 20 20 28 61 6e 64 20 28 66 69 e (and (fi
0cd0: 6c 65 2d 77 72 69 74 65 2d 61 63 63 65 73 73 3f le-write-access?
0ce0: 20 77 6f 72 6b 2d 61 72 65 61 29 0a 09 09 09 09 work-area).....
0cf0: 20 20 20 20 20 20 20 28 66 69 6c 65 2d 77 72 69 (file-wri
0d00: 74 65 2d 61 63 63 65 73 73 3f 20 64 62 70 61 74 te-access? dbpat
0d10: 68 29 29 29 0a 09 20 20 20 20 20 28 68 61 6e 64 h))).. (hand
0d20: 6c 65 72 20 20 20 28 73 71 6c 69 74 65 33 3a 6d ler (sqlite3:m
0d30: 61 6b 65 2d 62 75 73 79 2d 74 69 6d 65 6f 75 74 ake-busy-timeout
0d40: 20 28 69 66 20 28 61 72 67 73 3a 67 65 74 2d 61 (if (args:get-a
0d50: 72 67 20 22 2d 6f 76 65 72 72 69 64 65 2d 74 69 rg "-override-ti
0d60: 6d 65 6f 75 74 22 29 0a 09 09 09 09 09 09 20 20 meout").......
0d70: 20 20 20 20 20 28 73 74 72 69 6e 67 2d 3e 6e 75 (string->nu
0d80: 6d 62 65 72 20 28 61 72 67 73 3a 67 65 74 2d 61 mber (args:get-a
0d90: 72 67 20 22 2d 6f 76 65 72 72 69 64 65 2d 74 69 rg "-override-ti
0da0: 6d 65 6f 75 74 22 29 29 0a 09 09 09 09 09 09 20 meout")).......
0db0: 20 20 20 20 20 20 31 33 36 30 30 30 29 29 29 29 136000))))
0dc0: 0a 09 0a 09 28 69 66 20 28 61 6e 64 20 74 64 62 ....(if (and tdb
0dd0: 2d 77 72 69 74 65 61 62 6c 65 0a 09 09 20 2a 64 -writeable... *d
0de0: 62 2d 77 72 69 74 65 2d 61 63 63 65 73 73 2a 29 b-write-access*)
0df0: 0a 09 20 20 20 20 28 73 71 6c 69 74 65 33 3a 73 .. (sqlite3:s
0e00: 65 74 2d 62 75 73 79 2d 68 61 6e 64 6c 65 72 21 et-busy-handler!
0e10: 20 64 62 20 68 61 6e 64 6c 65 72 29 29 0a 09 28 db handler))..(
0e20: 69 66 20 28 6e 6f 74 20 64 62 65 78 69 73 74 73 if (not dbexists
0e30: 29 0a 09 20 20 20 20 28 62 65 67 69 6e 0a 09 20 ).. (begin..
0e40: 20 20 20 20 20 28 64 62 3a 73 65 74 2d 73 79 6e (db:set-syn
0e50: 63 20 64 62 29 20 3b 3b 20 28 73 71 6c 69 74 65 c db) ;; (sqlite
0e60: 33 3a 65 78 65 63 75 74 65 20 64 62 20 22 50 52 3:execute db "PR
0e70: 41 47 4d 41 20 73 79 6e 63 68 72 6f 6e 6f 75 73 AGMA synchronous
0e80: 20 3d 20 46 55 4c 4c 3b 22 29 0a 09 20 20 20 20 = FULL;")..
0e90: 20 20 28 64 65 62 75 67 3a 70 72 69 6e 74 2d 69 (debug:print-i
0ea0: 6e 66 6f 20 31 31 20 2a 64 65 66 61 75 6c 74 2d nfo 11 *default-
0eb0: 6c 6f 67 2d 70 6f 72 74 2a 20 22 49 6e 69 74 69 log-port* "Initi
0ec0: 61 6c 69 7a 65 64 20 74 65 73 74 20 64 61 74 61 alized test data
0ed0: 62 61 73 65 20 22 20 64 62 70 61 74 68 29 0a 09 base " dbpath)..
0ee0: 20 20 20 20 20 20 28 74 64 62 3a 74 65 73 74 64 (tdb:testd
0ef0: 62 2d 69 6e 69 74 69 61 6c 69 7a 65 20 64 62 29 b-initialize db)
0f00: 29 29 0a 09 3b 3b 20 28 73 71 6c 69 74 65 33 3a ))..;; (sqlite3:
0f10: 65 78 65 63 75 74 65 20 64 62 20 22 50 52 41 47 execute db "PRAG
0f20: 4d 41 20 73 79 6e 63 68 72 6f 6e 6f 75 73 20 3d MA synchronous =
0f30: 20 30 3b 22 29 0a 09 28 64 65 62 75 67 3a 70 72 0;")..(debug:pr
0f40: 69 6e 74 2d 69 6e 66 6f 20 31 31 20 2a 64 65 66 int-info 11 *def
0f50: 61 75 6c 74 2d 6c 6f 67 2d 70 6f 72 74 2a 20 22 ault-log-port* "
0f60: 6f 70 65 6e 2d 74 65 73 74 2d 64 62 20 45 4e 44 open-test-db END
0f70: 20 28 73 75 63 65 73 73 66 75 6c 29 22 20 77 6f (sucessful)" wo
0f80: 72 6b 2d 61 72 65 61 29 0a 09 3b 3b 20 6e 6f 77 rk-area)..;; now
0f90: 20 6c 65 74 27 73 20 74 65 73 74 20 74 68 61 74 let's test that
0fa0: 20 65 76 65 72 79 74 68 69 6e 67 20 69 73 20 63 everything is c
0fb0: 6f 72 72 65 63 74 0a 09 28 68 61 6e 64 6c 65 2d orrect..(handle-
0fc0: 65 78 63 65 70 74 69 6f 6e 73 0a 09 20 65 78 6e exceptions.. exn
0fd0: 0a 09 20 28 62 65 67 69 6e 0a 09 20 20 20 28 70 .. (begin.. (p
0fe0: 72 69 6e 74 2d 63 61 6c 6c 2d 63 68 61 69 6e 20 rint-call-chain
0ff0: 28 63 75 72 72 65 6e 74 2d 65 72 72 6f 72 2d 70 (current-error-p
1000: 6f 72 74 29 29 0a 09 20 20 20 28 64 65 62 75 67 ort)).. (debug
1010: 3a 70 72 69 6e 74 2d 65 72 72 6f 72 20 30 20 2a :print-error 0 *
1020: 64 65 66 61 75 6c 74 2d 6c 6f 67 2d 70 6f 72 74 default-log-port
1030: 2a 20 22 70 72 6f 62 6c 65 6d 20 61 63 63 65 73 * "problem acces
1040: 73 69 6e 67 20 74 65 73 74 20 64 62 20 22 20 77 sing test db " w
1050: 6f 72 6b 2d 61 72 65 61 20 22 2c 20 79 6f 75 20 ork-area ", you
1060: 70 72 6f 62 61 62 6c 79 20 73 68 6f 75 6c 64 20 probably should
1070: 63 6c 65 61 6e 20 61 6e 64 20 72 65 2d 72 75 6e clean and re-run
1080: 20 74 68 69 73 20 74 65 73 74 20 6f 72 20 72 65 this test or re
1090: 6d 6f 76 65 20 74 68 65 20 66 69 6c 65 20 22 20 move the file "
10a0: 0a 09 09 09 64 62 70 61 74 68 20 22 2e 5c 6e 20 ....dbpath ".\n
10b0: 20 22 0a 09 09 09 28 28 63 6f 6e 64 69 74 69 6f "....((conditio
10c0: 6e 2d 70 72 6f 70 65 72 74 79 2d 61 63 63 65 73 n-property-acces
10d0: 73 6f 72 20 27 65 78 6e 20 27 6d 65 73 73 61 67 sor 'exn 'messag
10e0: 65 29 20 65 78 6e 29 29 0a 09 20 20 20 23 66 29 e) exn)).. #f)
10f0: 0a 09 20 3b 3b 20 49 73 20 74 68 65 72 65 20 61 .. ;; Is there a
1100: 20 63 68 65 61 70 65 72 20 73 69 6e 67 6c 65 20 cheaper single
1110: 6c 69 6e 65 20 6f 70 65 72 61 74 69 6f 6e 20 74 line operation t
1120: 68 61 74 20 77 69 6c 6c 20 63 68 65 63 6b 20 66 hat will check f
1130: 6f 72 20 65 78 69 73 74 61 6e 63 65 20 6f 66 20 or existance of
1140: 61 20 74 61 62 6c 65 0a 09 20 3b 3b 20 61 6e 64 a table.. ;; and
1150: 20 72 61 69 73 65 20 61 6e 20 65 78 63 65 70 74 raise an except
1160: 69 6f 6e 20 3f 0a 09 20 28 73 71 6c 69 74 65 33 ion ?.. (sqlite3
1170: 3a 65 78 65 63 75 74 65 20 64 62 20 22 53 45 4c :execute db "SEL
1180: 45 43 54 20 69 64 20 46 52 4f 4d 20 74 65 73 74 ECT id FROM test
1190: 5f 64 61 74 61 20 4c 49 4d 49 54 20 31 3b 22 29 _data LIMIT 1;")
11a0: 29 0a 09 64 62 29 0a 20 20 20 20 20 20 3b 3b 20 )..db). ;;
11b0: 6e 6f 20 77 6f 72 6b 2d 61 72 65 61 20 6f 72 20 no work-area or
11c0: 6e 6f 74 20 72 65 61 64 61 62 6c 65 20 2d 20 63 not readable - c
11d0: 72 65 61 74 65 20 61 20 70 6c 61 63 65 68 6f 6c reate a placehol
11e0: 64 65 72 20 74 6f 20 66 61 6b 65 20 72 65 73 74 der to fake rest
11f0: 20 6f 66 20 77 6f 72 6c 64 20 6f 75 74 0a 20 20 of world out.
1200: 20 20 20 20 28 6c 65 74 20 28 28 62 61 64 64 62 (let ((baddb
1210: 20 28 73 71 6c 69 74 65 33 3a 6f 70 65 6e 2d 64 (sqlite3:open-d
1220: 61 74 61 62 61 73 65 20 22 3a 6d 65 6d 6f 72 79 atabase ":memory
1230: 3a 22 29 29 29 0a 20 09 28 64 65 62 75 67 3a 70 :"))). .(debug:p
1240: 72 69 6e 74 2d 69 6e 66 6f 20 31 31 20 2a 64 65 rint-info 11 *de
1250: 66 61 75 6c 74 2d 6c 6f 67 2d 70 6f 72 74 2a 20 fault-log-port*
1260: 22 6f 70 65 6e 2d 74 65 73 74 2d 64 62 20 45 4e "open-test-db EN
1270: 44 20 28 75 6e 73 75 63 65 73 73 66 75 6c 29 22 D (unsucessful)"
1280: 20 77 6f 72 6b 2d 61 72 65 61 29 0a 20 09 3b 3b work-area). .;;
1290: 20 70 72 6f 76 69 64 65 20 61 6e 20 69 6e 2d 6d provide an in-m
12a0: 65 6d 20 64 62 20 28 74 68 69 73 20 69 73 20 64 em db (this is d
12b0: 61 6e 67 65 72 6f 75 73 21 29 0a 20 09 28 74 64 angerous!). .(td
12c0: 62 3a 74 65 73 74 64 62 2d 69 6e 69 74 69 61 6c b:testdb-initial
12d0: 69 7a 65 20 62 61 64 64 62 29 0a 20 09 62 61 64 ize baddb). .bad
12e0: 64 62 29 29 29 0a 0a 3b 3b 20 66 69 6e 64 20 61 db)))..;; find a
12f0: 6e 64 20 6f 70 65 6e 20 74 68 65 20 74 65 73 74 nd open the test
1300: 64 61 74 2e 64 62 20 66 69 6c 65 20 66 6f 72 20 dat.db file for
1310: 61 6e 20 65 78 69 73 74 69 6e 67 20 74 65 73 74 an existing test
1320: 0a 28 64 65 66 69 6e 65 20 28 74 64 62 3a 6f 70 .(define (tdb:op
1330: 65 6e 2d 74 65 73 74 2d 64 62 2d 62 79 2d 74 65 en-test-db-by-te
1340: 73 74 2d 69 64 20 74 65 73 74 2d 69 64 20 23 21 st-id test-id #!
1350: 6b 65 79 20 28 77 6f 72 6b 2d 61 72 65 61 20 23 key (work-area #
1360: 66 29 29 0a 20 20 28 6c 65 74 2a 20 28 28 74 65 f)). (let* ((te
1370: 73 74 2d 70 61 74 68 20 28 69 66 20 77 6f 72 6b st-path (if work
1380: 2d 61 72 65 61 0a 09 09 09 77 6f 72 6b 2d 61 72 -area....work-ar
1390: 65 61 0a 09 09 09 28 72 6d 74 3a 74 65 73 74 2d ea....(rmt:test-
13a0: 67 65 74 2d 72 75 6e 64 69 72 2d 66 72 6f 6d 2d get-rundir-from-
13b0: 74 65 73 74 2d 69 64 20 74 65 73 74 2d 69 64 29 test-id test-id)
13c0: 29 29 29 0a 20 20 20 20 28 64 65 62 75 67 3a 70 ))). (debug:p
13d0: 72 69 6e 74 20 33 20 2a 64 65 66 61 75 6c 74 2d rint 3 *default-
13e0: 6c 6f 67 2d 70 6f 72 74 2a 20 22 54 45 53 54 20 log-port* "TEST
13f0: 50 41 54 48 3a 20 22 20 74 65 73 74 2d 70 61 74 PATH: " test-pat
1400: 68 29 0a 20 20 20 20 28 6f 70 65 6e 2d 74 65 73 h). (open-tes
1410: 74 2d 64 62 20 74 65 73 74 2d 70 61 74 68 29 29 t-db test-path))
1420: 29 0a 0a 3b 3b 20 66 69 6e 64 20 61 6e 64 20 6f )..;; find and o
1430: 70 65 6e 20 74 68 65 20 74 65 73 74 64 61 74 2e pen the testdat.
1440: 64 62 20 66 69 6c 65 20 66 6f 72 20 61 6e 20 65 db file for an e
1450: 78 69 73 74 69 6e 67 20 74 65 73 74 0a 28 64 65 xisting test.(de
1460: 66 69 6e 65 20 28 74 64 62 3a 6f 70 65 6e 2d 74 fine (tdb:open-t
1470: 65 73 74 2d 64 62 2d 62 79 2d 74 65 73 74 2d 69 est-db-by-test-i
1480: 64 2d 6c 6f 63 61 6c 20 64 62 73 74 72 75 63 74 d-local dbstruct
1490: 20 72 75 6e 2d 69 64 20 74 65 73 74 2d 69 64 20 run-id test-id
14a0: 23 21 6b 65 79 20 28 77 6f 72 6b 2d 61 72 65 61 #!key (work-area
14b0: 20 23 66 29 29 0a 20 20 28 6c 65 74 2a 20 28 28 #f)). (let* ((
14c0: 74 65 73 74 2d 70 61 74 68 20 28 69 66 20 77 6f test-path (if wo
14d0: 72 6b 2d 61 72 65 61 0a 09 09 09 77 6f 72 6b 2d rk-area....work-
14e0: 61 72 65 61 0a 09 09 09 28 64 62 3a 74 65 73 74 area....(db:test
14f0: 2d 67 65 74 2d 72 75 6e 64 69 72 2d 66 72 6f 6d -get-rundir-from
1500: 2d 74 65 73 74 2d 69 64 20 64 62 73 74 72 75 63 -test-id dbstruc
1510: 74 20 72 75 6e 2d 69 64 20 74 65 73 74 2d 69 64 t run-id test-id
1520: 29 29 29 29 0a 20 20 20 20 28 64 65 62 75 67 3a )))). (debug:
1530: 70 72 69 6e 74 20 33 20 2a 64 65 66 61 75 6c 74 print 3 *default
1540: 2d 6c 6f 67 2d 70 6f 72 74 2a 20 22 54 45 53 54 -log-port* "TEST
1550: 20 50 41 54 48 3a 20 22 20 74 65 73 74 2d 70 61 PATH: " test-pa
1560: 74 68 29 0a 20 20 20 20 28 6f 70 65 6e 2d 74 65 th). (open-te
1570: 73 74 2d 64 62 20 74 65 73 74 2d 70 61 74 68 29 st-db test-path)
1580: 29 29 0a 0a 3b 3b 20 66 69 6e 64 20 61 6e 64 20 ))..;; find and
1590: 6f 70 65 6e 20 74 68 65 20 74 65 73 74 64 61 74 open the testdat
15a0: 2e 64 62 20 66 69 6c 65 20 66 6f 72 20 61 6e 20 .db file for an
15b0: 65 78 69 73 74 69 6e 67 20 74 65 73 74 0a 28 64 existing test.(d
15c0: 65 66 69 6e 65 20 28 74 64 62 3a 6f 70 65 6e 2d efine (tdb:open-
15d0: 72 75 6e 2d 63 6c 6f 73 65 2d 64 62 2d 62 79 2d run-close-db-by-
15e0: 74 65 73 74 2d 69 64 2d 6c 6f 63 61 6c 20 64 62 test-id-local db
15f0: 73 74 72 75 63 74 20 72 75 6e 2d 69 64 20 74 65 struct run-id te
1600: 73 74 2d 69 64 20 77 6f 72 6b 2d 61 72 65 61 20 st-id work-area
1610: 70 72 6f 63 20 2e 20 70 61 72 61 6d 73 29 0a 20 proc . params).
1620: 20 28 6c 65 74 2a 20 28 28 74 65 73 74 2d 70 61 (let* ((test-pa
1630: 74 68 20 28 69 66 20 77 6f 72 6b 2d 61 72 65 61 th (if work-area
1640: 0a 09 09 09 77 6f 72 6b 2d 61 72 65 61 0a 09 09 ....work-area...
1650: 09 28 64 62 3a 74 65 73 74 2d 67 65 74 2d 72 75 .(db:test-get-ru
1660: 6e 64 69 72 2d 66 72 6f 6d 2d 74 65 73 74 2d 69 ndir-from-test-i
1670: 64 20 64 62 73 74 72 75 63 74 20 72 75 6e 2d 69 d dbstruct run-i
1680: 64 20 74 65 73 74 2d 69 64 29 29 29 0a 09 20 28 d test-id))).. (
1690: 74 64 62 20 20 20 20 20 20 20 20 28 6f 70 65 6e tdb (open
16a0: 2d 74 65 73 74 2d 64 62 20 74 65 73 74 2d 70 61 -test-db test-pa
16b0: 74 68 29 29 29 0a 20 20 20 20 28 61 70 70 6c 79 th))). (apply
16c0: 20 70 72 6f 63 20 74 64 62 20 70 61 72 61 6d 73 proc tdb params
16d0: 29 29 29 0a 0a 28 64 65 66 69 6e 65 20 28 74 64 )))..(define (td
16e0: 62 3a 74 65 73 74 64 62 2d 69 6e 69 74 69 61 6c b:testdb-initial
16f0: 69 7a 65 20 64 62 29 0a 20 20 28 64 65 62 75 67 ize db). (debug
1700: 3a 70 72 69 6e 74 20 31 31 20 2a 64 65 66 61 75 :print 11 *defau
1710: 6c 74 2d 6c 6f 67 2d 70 6f 72 74 2a 20 22 64 62 lt-log-port* "db
1720: 3a 74 65 73 74 64 62 2d 69 6e 69 74 69 61 6c 69 :testdb-initiali
1730: 7a 65 20 53 54 41 52 54 22 29 0a 20 20 28 73 71 ze START"). (sq
1740: 6c 69 74 65 33 3a 77 69 74 68 2d 74 72 61 6e 73 lite3:with-trans
1750: 61 63 74 69 6f 6e 0a 20 20 20 64 62 0a 20 20 20 action. db.
1760: 28 6c 61 6d 62 64 61 20 28 29 0a 20 20 20 20 20 (lambda ().
1770: 28 66 6f 72 2d 65 61 63 68 0a 20 20 20 20 20 20 (for-each.
1780: 28 6c 61 6d 62 64 61 20 28 73 71 6c 63 6d 64 29 (lambda (sqlcmd)
1790: 0a 09 28 73 71 6c 69 74 65 33 3a 65 78 65 63 75 ..(sqlite3:execu
17a0: 74 65 20 64 62 20 73 71 6c 63 6d 64 29 29 0a 20 te db sqlcmd)).
17b0: 20 20 20 20 20 28 6c 69 73 74 20 22 43 52 45 41 (list "CREA
17c0: 54 45 20 54 41 42 4c 45 20 49 46 20 4e 4f 54 20 TE TABLE IF NOT
17d0: 45 58 49 53 54 53 20 74 65 73 74 5f 72 75 6e 64 EXISTS test_rund
17e0: 61 74 20 28 0a 20 20 20 20 20 20 20 20 20 20 20 at (.
17f0: 20 20 20 69 64 20 49 4e 54 45 47 45 52 20 50 52 id INTEGER PR
1800: 49 4d 41 52 59 20 4b 45 59 2c 0a 20 20 20 20 20 IMARY KEY,.
1810: 20 20 20 20 20 20 20 20 20 75 70 64 61 74 65 5f update_
1820: 74 69 6d 65 20 54 49 4d 45 53 54 41 4d 50 2c 0a time TIMESTAMP,.
1830: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 63 70 cp
1840: 75 6c 6f 61 64 20 49 4e 54 45 47 45 52 20 44 45 uload INTEGER DE
1850: 46 41 55 4c 54 20 2d 31 2c 0a 20 20 20 20 20 20 FAULT -1,.
1860: 20 20 20 20 20 20 20 20 64 69 73 6b 66 72 65 65 diskfree
1870: 20 49 4e 54 45 47 45 52 20 44 45 46 41 55 4c 54 INTEGER DEFAULT
1880: 20 2d 31 2c 0a 20 20 20 20 20 20 20 20 20 20 20 -1,.
1890: 20 20 20 64 69 73 6b 75 73 61 67 65 20 49 4e 54 diskusage INT
18a0: 47 45 52 20 44 45 46 41 55 4c 54 20 2d 31 2c 0a GER DEFAULT -1,.
18b0: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 72 75 ru
18c0: 6e 5f 64 75 72 61 74 69 6f 6e 20 49 4e 54 45 47 n_duration INTEG
18d0: 45 52 20 44 45 46 41 55 4c 54 20 30 29 3b 22 0a ER DEFAULT 0);".
18e0: 09 20 20 20 20 22 43 52 45 41 54 45 20 54 41 42 . "CREATE TAB
18f0: 4c 45 20 49 46 20 4e 4f 54 20 45 58 49 53 54 53 LE IF NOT EXISTS
1900: 20 74 65 73 74 5f 64 61 74 61 20 28 0a 20 20 20 test_data (.
1910: 20 20 20 20 20 20 20 20 20 20 20 69 64 20 49 4e id IN
1920: 54 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 TEGER PRIMARY KE
1930: 59 2c 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 Y,.
1940: 20 74 65 73 74 5f 69 64 20 49 4e 54 45 47 45 52 test_id INTEGER
1950: 2c 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 ,.
1960: 63 61 74 65 67 6f 72 79 20 54 45 58 54 20 44 45 category TEXT DE
1970: 46 41 55 4c 54 20 27 27 2c 0a 20 20 20 20 20 20 FAULT '',.
1980: 20 20 20 20 20 20 20 20 76 61 72 69 61 62 6c 65 variable
1990: 20 54 45 58 54 2c 0a 09 20 20 20 20 20 20 76 61 TEXT,.. va
19a0: 6c 75 65 20 52 45 41 4c 2c 0a 09 20 20 20 20 20 lue REAL,..
19b0: 20 65 78 70 65 63 74 65 64 20 52 45 41 4c 2c 0a expected REAL,.
19c0: 09 20 20 20 20 20 20 74 6f 6c 20 52 45 41 4c 2c . tol REAL,
19d0: 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 75 . u
19e0: 6e 69 74 73 20 54 45 58 54 2c 0a 20 20 20 20 20 nits TEXT,.
19f0: 20 20 20 20 20 20 20 20 20 63 6f 6d 6d 65 6e 74 comment
1a00: 20 54 45 58 54 20 44 45 46 41 55 4c 54 20 27 27 TEXT DEFAULT ''
1a10: 2c 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 ,.
1a20: 73 74 61 74 75 73 20 54 45 58 54 20 44 45 46 41 status TEXT DEFA
1a30: 55 4c 54 20 27 6e 2f 61 27 2c 0a 20 20 20 20 20 ULT 'n/a',.
1a40: 20 20 20 20 20 20 20 20 20 74 79 70 65 20 54 45 type TE
1a50: 58 54 20 44 45 46 41 55 4c 54 20 27 27 2c 0a 20 XT DEFAULT '',.
1a60: 20 20 20 20 20 20 20 20 20 20 20 20 20 43 4f 4e CON
1a70: 53 54 52 41 49 4e 54 20 74 65 73 74 5f 64 61 74 STRAINT test_dat
1a80: 61 5f 63 6f 6e 73 74 72 61 69 6e 74 20 55 4e 49 a_constraint UNI
1a90: 51 55 45 20 28 74 65 73 74 5f 69 64 2c 63 61 74 QUE (test_id,cat
1aa0: 65 67 6f 72 79 2c 76 61 72 69 61 62 6c 65 29 29 egory,variable))
1ab0: 3b 22 0a 09 20 20 20 20 22 43 52 45 41 54 45 20 ;".. "CREATE
1ac0: 54 41 42 4c 45 20 49 46 20 4e 4f 54 20 45 58 49 TABLE IF NOT EXI
1ad0: 53 54 53 20 74 65 73 74 5f 73 74 65 70 73 20 28 STS test_steps (
1ae0: 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 69 . i
1af0: 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d 41 52 d INTEGER PRIMAR
1b00: 59 20 4b 45 59 2c 0a 20 20 20 20 20 20 20 20 20 Y KEY,.
1b10: 20 20 20 20 20 74 65 73 74 5f 69 64 20 49 4e 54 test_id INT
1b20: 45 47 45 52 2c 20 0a 20 20 20 20 20 20 20 20 20 EGER, .
1b30: 20 20 20 20 20 73 74 65 70 6e 61 6d 65 20 54 45 stepname TE
1b40: 58 54 2c 20 0a 20 20 20 20 20 20 20 20 20 20 20 XT, .
1b50: 20 20 20 73 74 61 74 65 20 54 45 58 54 20 44 45 state TEXT DE
1b60: 46 41 55 4c 54 20 27 4e 4f 54 5f 53 54 41 52 54 FAULT 'NOT_START
1b70: 45 44 27 2c 20 0a 20 20 20 20 20 20 20 20 20 20 ED', .
1b80: 20 20 20 20 73 74 61 74 75 73 20 54 45 58 54 20 status TEXT
1b90: 44 45 46 41 55 4c 54 20 27 6e 2f 61 27 2c 0a 20 DEFAULT 'n/a',.
1ba0: 20 20 20 20 20 20 20 20 20 20 20 20 20 65 76 65 eve
1bb0: 6e 74 5f 74 69 6d 65 20 54 49 4d 45 53 54 41 4d nt_time TIMESTAM
1bc0: 50 2c 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 P,.
1bd0: 20 63 6f 6d 6d 65 6e 74 20 54 45 58 54 20 44 45 comment TEXT DE
1be0: 46 41 55 4c 54 20 27 27 2c 0a 20 20 20 20 20 20 FAULT '',.
1bf0: 20 20 20 20 20 20 20 20 6c 6f 67 66 69 6c 65 20 logfile
1c00: 54 45 58 54 20 44 45 46 41 55 4c 54 20 27 27 2c TEXT DEFAULT '',
1c10: 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 43 . C
1c20: 4f 4e 53 54 52 41 49 4e 54 20 74 65 73 74 5f 73 ONSTRAINT test_s
1c30: 74 65 70 73 5f 63 6f 6e 73 74 72 61 69 6e 74 20 teps_constraint
1c40: 55 4e 49 51 55 45 20 28 74 65 73 74 5f 69 64 2c UNIQUE (test_id,
1c50: 73 74 65 70 6e 61 6d 65 2c 73 74 61 74 65 29 29 stepname,state))
1c60: 3b 22 0a 09 20 20 20 20 3b 3b 20 74 65 73 74 5f ;".. ;; test_
1c70: 6d 65 74 61 20 63 61 6e 20 62 65 20 75 73 65 64 meta can be used
1c80: 20 66 6f 72 20 68 61 6e 64 69 6e 67 20 63 6f 6d for handing com
1c90: 6d 61 6e 64 73 20 74 6f 20 74 68 65 20 74 65 73 mands to the tes
1ca0: 74 0a 09 20 20 20 20 3b 3b 20 65 2e 67 2e 20 4b t.. ;; e.g. K
1cb0: 49 4c 4c 52 45 51 0a 09 20 20 20 20 3b 3b 20 20 ILLREQ.. ;;
1cc0: 20 20 20 20 74 68 65 20 61 63 6b 73 74 61 74 65 the ackstate
1cd0: 20 69 73 20 73 65 74 20 74 6f 20 31 20 6f 6e 63 is set to 1 onc
1ce0: 65 20 74 68 65 20 63 6f 6d 6d 61 6e 64 20 68 61 e the command ha
1cf0: 73 20 62 65 65 6e 20 63 6f 6d 70 6c 65 74 65 64 s been completed
1d00: 0a 09 20 20 20 20 22 43 52 45 41 54 45 20 54 41 .. "CREATE TA
1d10: 42 4c 45 20 49 46 20 4e 4f 54 20 45 58 49 53 54 BLE IF NOT EXIST
1d20: 53 20 74 65 73 74 5f 6d 65 74 61 20 28 0a 20 20 S test_meta (.
1d30: 20 20 20 20 20 20 20 20 20 20 20 20 69 64 20 49 id I
1d40: 4e 54 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b NTEGER PRIMARY K
1d50: 45 59 2c 0a 20 20 20 20 20 20 20 20 20 20 20 20 EY,.
1d60: 20 20 76 61 72 20 54 45 58 54 2c 0a 20 20 20 20 var TEXT,.
1d70: 20 20 20 20 20 20 20 20 20 20 76 61 6c 20 54 45 val TE
1d80: 58 54 2c 0a 20 20 20 20 20 20 20 20 20 20 20 20 XT,.
1d90: 20 20 61 63 6b 73 74 61 74 65 20 49 4e 54 45 47 ackstate INTEG
1da0: 45 52 20 44 45 46 41 55 4c 54 20 30 2c 0a 20 20 ER DEFAULT 0,.
1db0: 20 20 20 20 20 20 20 20 20 20 20 20 43 4f 4e 53 CONS
1dc0: 54 52 41 49 4e 54 20 6d 65 74 61 64 61 74 5f 63 TRAINT metadat_c
1dd0: 6f 6e 73 74 72 61 69 6e 74 20 55 4e 49 51 55 45 onstraint UNIQUE
1de0: 20 28 76 61 72 29 29 3b 22 29 29 29 29 0a 20 20 (var));")))).
1df0: 28 64 65 62 75 67 3a 70 72 69 6e 74 20 31 31 20 (debug:print 11
1e00: 2a 64 65 66 61 75 6c 74 2d 6c 6f 67 2d 70 6f 72 *default-log-por
1e10: 74 2a 20 22 64 62 3a 74 65 73 74 64 62 2d 69 6e t* "db:testdb-in
1e20: 69 74 69 61 6c 69 7a 65 20 45 4e 44 22 29 29 0a itialize END")).
1e30: 0a 3b 3b 20 54 68 69 73 20 72 6f 75 74 69 6e 65 .;; This routine
1e40: 20 6d 6f 76 65 64 20 74 6f 20 64 62 3a 72 65 61 moved to db:rea
1e50: 64 2d 74 65 73 74 2d 64 61 74 61 0a 3b 3b 0a 28 d-test-data.;;.(
1e60: 64 65 66 69 6e 65 20 28 74 64 62 3a 72 65 61 64 define (tdb:read
1e70: 2d 74 65 73 74 2d 64 61 74 61 20 74 64 62 20 74 -test-data tdb t
1e80: 65 73 74 2d 69 64 20 63 61 74 65 67 6f 72 79 70 est-id categoryp
1e90: 61 74 74 29 0a 20 20 28 6c 65 74 20 28 28 72 65 att). (let ((re
1ea0: 73 20 27 28 29 29 29 0a 20 20 20 20 28 73 71 6c s '())). (sql
1eb0: 69 74 65 33 3a 66 6f 72 2d 65 61 63 68 2d 72 6f ite3:for-each-ro
1ec0: 77 20 0a 20 20 20 20 20 28 6c 61 6d 62 64 61 20 w . (lambda
1ed0: 28 69 64 20 74 65 73 74 5f 69 64 20 63 61 74 65 (id test_id cate
1ee0: 67 6f 72 79 20 76 61 72 69 61 62 6c 65 20 76 61 gory variable va
1ef0: 6c 75 65 20 65 78 70 65 63 74 65 64 20 74 6f 6c lue expected tol
1f00: 20 75 6e 69 74 73 20 63 6f 6d 6d 65 6e 74 20 73 units comment s
1f10: 74 61 74 75 73 20 74 79 70 65 29 0a 20 20 20 20 tatus type).
1f20: 20 20 20 28 73 65 74 21 20 72 65 73 20 28 63 6f (set! res (co
1f30: 6e 73 20 28 76 65 63 74 6f 72 20 69 64 20 74 65 ns (vector id te
1f40: 73 74 5f 69 64 20 63 61 74 65 67 6f 72 79 20 76 st_id category v
1f50: 61 72 69 61 62 6c 65 20 76 61 6c 75 65 20 65 78 ariable value ex
1f60: 70 65 63 74 65 64 20 74 6f 6c 20 75 6e 69 74 73 pected tol units
1f70: 20 63 6f 6d 6d 65 6e 74 20 73 74 61 74 75 73 20 comment status
1f80: 74 79 70 65 29 20 72 65 73 29 29 29 0a 20 20 20 type) res))).
1f90: 20 20 74 64 62 0a 20 20 20 20 20 22 53 45 4c 45 tdb. "SELE
1fa0: 43 54 20 69 64 2c 74 65 73 74 5f 69 64 2c 63 61 CT id,test_id,ca
1fb0: 74 65 67 6f 72 79 2c 76 61 72 69 61 62 6c 65 2c tegory,variable,
1fc0: 76 61 6c 75 65 2c 65 78 70 65 63 74 65 64 2c 74 value,expected,t
1fd0: 6f 6c 2c 75 6e 69 74 73 2c 63 6f 6d 6d 65 6e 74 ol,units,comment
1fe0: 2c 73 74 61 74 75 73 2c 74 79 70 65 20 46 52 4f ,status,type FRO
1ff0: 4d 20 74 65 73 74 5f 64 61 74 61 20 57 48 45 52 M test_data WHER
2000: 45 20 74 65 73 74 5f 69 64 3d 3f 20 41 4e 44 20 E test_id=? AND
2010: 63 61 74 65 67 6f 72 79 20 4c 49 4b 45 20 3f 20 category LIKE ?
2020: 4f 52 44 45 52 20 42 59 20 63 61 74 65 67 6f 72 ORDER BY categor
2030: 79 2c 76 61 72 69 61 62 6c 65 3b 22 20 74 65 73 y,variable;" tes
2040: 74 2d 69 64 20 63 61 74 65 67 6f 72 79 70 61 74 t-id categorypat
2050: 74 29 0a 20 20 20 20 28 73 71 6c 69 74 65 33 3a t). (sqlite3:
2060: 66 69 6e 61 6c 69 7a 65 21 20 74 64 62 29 0a 20 finalize! tdb).
2070: 20 20 20 28 72 65 76 65 72 73 65 20 72 65 73 29 (reverse res)
2080: 29 29 0a 0a 3b 3b 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ))..;;==========
2090: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
20a0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
20b0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
20c0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 3b 3b 20 ============.;;
20d0: 54 20 45 20 53 20 54 20 20 20 44 20 41 20 54 20 T E S T D A T
20e0: 41 20 0a 3b 3b 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d A .;;===========
20f0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
2100: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
2110: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
2120: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 0a 3b 3b 20 ===========..;;
2130: 3b 3b 20 67 65 74 20 61 20 6c 69 73 74 20 6f 66 ;; get a list of
2140: 20 74 65 73 74 5f 64 61 74 61 20 72 65 63 6f 72 test_data recor
2150: 64 73 20 6d 61 74 63 68 69 6e 67 20 63 61 74 65 ds matching cate
2160: 67 6f 72 79 70 61 74 74 0a 3b 3b 20 28 64 65 66 gorypatt.;; (def
2170: 69 6e 65 20 28 74 64 62 3a 72 65 61 64 2d 74 65 ine (tdb:read-te
2180: 73 74 2d 64 61 74 61 20 74 65 73 74 2d 69 64 20 st-data test-id
2190: 63 61 74 65 67 6f 72 79 70 61 74 74 20 23 21 6b categorypatt #!k
21a0: 65 79 20 28 77 6f 72 6b 2d 61 72 65 61 20 23 66 ey (work-area #f
21b0: 29 29 0a 3b 3b 20 20 20 28 6c 65 74 20 28 28 74 )).;; (let ((t
21c0: 64 62 20 20 28 74 64 62 3a 6f 70 65 6e 2d 74 65 db (tdb:open-te
21d0: 73 74 2d 64 62 2d 62 79 2d 74 65 73 74 2d 69 64 st-db-by-test-id
21e0: 20 74 65 73 74 2d 69 64 20 77 6f 72 6b 2d 61 72 test-id work-ar
21f0: 65 61 3a 20 77 6f 72 6b 2d 61 72 65 61 29 29 29 ea: work-area)))
2200: 0a 3b 3b 20 20 20 20 20 28 69 66 20 28 73 71 6c .;; (if (sql
2210: 69 74 65 33 3a 64 61 74 61 62 61 73 65 3f 20 74 ite3:database? t
2220: 64 62 29 0a 3b 3b 20 09 28 6c 65 74 20 28 28 72 db).;; .(let ((r
2230: 65 73 20 27 28 29 29 29 0a 3b 3b 20 09 20 20 28 es '())).;; . (
2240: 73 71 6c 69 74 65 33 3a 66 6f 72 2d 65 61 63 68 sqlite3:for-each
2250: 2d 72 6f 77 20 0a 3b 3b 20 09 20 20 20 28 6c 61 -row .;; . (la
2260: 6d 62 64 61 20 28 69 64 20 74 65 73 74 5f 69 64 mbda (id test_id
2270: 20 63 61 74 65 67 6f 72 79 20 76 61 72 69 61 62 category variab
2280: 6c 65 20 76 61 6c 75 65 20 65 78 70 65 63 74 65 le value expecte
2290: 64 20 74 6f 6c 20 75 6e 69 74 73 20 63 6f 6d 6d d tol units comm
22a0: 65 6e 74 20 73 74 61 74 75 73 20 74 79 70 65 29 ent status type)
22b0: 0a 3b 3b 20 09 20 20 20 20 20 28 73 65 74 21 20 .;; . (set!
22c0: 72 65 73 20 28 63 6f 6e 73 20 28 76 65 63 74 6f res (cons (vecto
22d0: 72 20 69 64 20 74 65 73 74 5f 69 64 20 63 61 74 r id test_id cat
22e0: 65 67 6f 72 79 20 76 61 72 69 61 62 6c 65 20 76 egory variable v
22f0: 61 6c 75 65 20 65 78 70 65 63 74 65 64 20 74 6f alue expected to
2300: 6c 20 75 6e 69 74 73 20 63 6f 6d 6d 65 6e 74 20 l units comment
2310: 73 74 61 74 75 73 20 74 79 70 65 29 20 72 65 73 status type) res
2320: 29 29 29 0a 3b 3b 20 09 20 20 20 74 64 62 0a 3b ))).;; . tdb.;
2330: 3b 20 09 20 20 20 22 53 45 4c 45 43 54 20 69 64 ; . "SELECT id
2340: 2c 74 65 73 74 5f 69 64 2c 63 61 74 65 67 6f 72 ,test_id,categor
2350: 79 2c 76 61 72 69 61 62 6c 65 2c 76 61 6c 75 65 y,variable,value
2360: 2c 65 78 70 65 63 74 65 64 2c 74 6f 6c 2c 75 6e ,expected,tol,un
2370: 69 74 73 2c 63 6f 6d 6d 65 6e 74 2c 73 74 61 74 its,comment,stat
2380: 75 73 2c 74 79 70 65 20 46 52 4f 4d 20 74 65 73 us,type FROM tes
2390: 74 5f 64 61 74 61 20 57 48 45 52 45 20 74 65 73 t_data WHERE tes
23a0: 74 5f 69 64 3d 3f 20 41 4e 44 20 63 61 74 65 67 t_id=? AND categ
23b0: 6f 72 79 20 4c 49 4b 45 20 3f 20 4f 52 44 45 52 ory LIKE ? ORDER
23c0: 20 42 59 20 63 61 74 65 67 6f 72 79 2c 76 61 72 BY category,var
23d0: 69 61 62 6c 65 3b 22 20 74 65 73 74 2d 69 64 20 iable;" test-id
23e0: 63 61 74 65 67 6f 72 79 70 61 74 74 29 0a 3b 3b categorypatt).;;
23f0: 20 09 20 20 28 73 71 6c 69 74 65 33 3a 66 69 6e . (sqlite3:fin
2400: 61 6c 69 7a 65 21 20 74 64 62 29 0a 3b 3b 20 09 alize! tdb).;; .
2410: 20 20 28 72 65 76 65 72 73 65 20 72 65 73 29 29 (reverse res))
2420: 0a 3b 3b 20 09 27 28 29 29 29 29 0a 0a 3b 3b 20 .;; .'())))..;;
2430: 4e 4f 54 45 3a 20 52 75 6e 20 74 68 69 73 20 6c NOTE: Run this l
2440: 6f 63 61 6c 20 77 69 74 68 20 23 66 20 66 6f 72 ocal with #f for
2450: 20 64 62 20 21 21 21 0a 28 64 65 66 69 6e 65 20 db !!!.(define
2460: 28 74 64 62 3a 6c 6f 61 64 2d 74 65 73 74 2d 64 (tdb:load-test-d
2470: 61 74 61 20 72 75 6e 2d 69 64 20 74 65 73 74 2d ata run-id test-
2480: 69 64 29 0a 20 20 28 6c 65 74 20 6c 6f 6f 70 20 id). (let loop
2490: 28 28 6c 69 6e 20 28 72 65 61 64 2d 6c 69 6e 65 ((lin (read-line
24a0: 29 29 29 0a 20 20 20 20 28 69 66 20 28 6e 6f 74 ))). (if (not
24b0: 20 28 65 6f 66 2d 6f 62 6a 65 63 74 3f 20 6c 69 (eof-object? li
24c0: 6e 29 29 0a 09 28 62 65 67 69 6e 0a 09 20 20 28 n))..(begin.. (
24d0: 64 65 62 75 67 3a 70 72 69 6e 74 20 34 20 2a 64 debug:print 4 *d
24e0: 65 66 61 75 6c 74 2d 6c 6f 67 2d 70 6f 72 74 2a efault-log-port*
24f0: 20 6c 69 6e 29 0a 20 20 20 20 20 20 20 20 20 20 lin).
2500: 3b 3b 28 77 68 65 6e 20 6c 69 6e 20 3b 3b 20 74 ;;(when lin ;; t
2510: 68 69 73 20 77 68 65 6e 20 62 6c 6f 63 6b 65 64 his when blocked
2520: 20 73 74 61 63 6b 20 64 75 6d 70 20 63 61 75 73 stack dump caus
2530: 65 64 20 62 79 20 2e 64 61 74 20 66 69 6c 65 20 ed by .dat file
2540: 66 72 6f 6d 20 6c 6f 67 70 72 6f 20 62 65 69 6e from logpro bein
2550: 67 20 30 2d 62 79 74 65 2e 20 20 66 69 78 65 64 g 0-byte. fixed
2560: 20 62 79 20 75 70 67 72 61 64 69 6e 67 20 6c 6f by upgrading lo
2570: 67 70 72 6f 0a 20 20 20 20 20 20 20 20 20 20 28 gpro. (
2580: 72 6d 74 3a 63 73 76 2d 3e 74 65 73 74 2d 64 61 rmt:csv->test-da
2590: 74 61 20 72 75 6e 2d 69 64 20 74 65 73 74 2d 69 ta run-id test-i
25a0: 64 20 6c 69 6e 29 0a 20 20 20 20 20 20 20 20 20 d lin).
25b0: 20 3b 3b 29 0a 09 20 20 28 6c 6f 6f 70 20 28 72 ;;).. (loop (r
25c0: 65 61 64 2d 6c 69 6e 65 29 29 29 29 29 0a 20 20 ead-line))))).
25d0: 3b 3b 20 72 6f 6c 6c 20 75 70 20 74 68 65 20 63 ;; roll up the c
25e0: 75 72 72 65 6e 74 20 72 65 73 75 6c 74 73 2e 0a urrent results..
25f0: 20 20 3b 3b 20 46 49 58 4d 45 3a 20 41 64 64 20 ;; FIXME: Add
2600: 74 68 65 20 73 74 61 74 75 73 20 74 6f 6f 20 0a the status too .
2610: 20 20 28 72 6d 74 3a 74 65 73 74 2d 64 61 74 61 (rmt:test-data
2620: 2d 72 6f 6c 6c 75 70 20 72 75 6e 2d 69 64 20 74 -rollup run-id t
2630: 65 73 74 2d 69 64 20 23 66 29 29 0a 0a 3b 3b 20 est-id #f))..;;
2640: 4e 4f 54 45 3a 20 52 75 6e 20 74 68 69 73 20 6c NOTE: Run this l
2650: 6f 63 61 6c 20 77 69 74 68 20 23 66 20 66 6f 72 ocal with #f for
2660: 20 64 62 20 21 21 21 0a 28 64 65 66 69 6e 65 20 db !!!.(define
2670: 28 74 64 62 3a 6c 6f 61 64 2d 6c 6f 67 70 72 6f (tdb:load-logpro
2680: 2d 64 61 74 61 20 72 75 6e 2d 69 64 20 74 65 73 -data run-id tes
2690: 74 2d 69 64 29 0a 20 20 28 6c 65 74 20 6c 6f 6f t-id). (let loo
26a0: 70 20 28 28 6c 69 6e 20 28 72 65 61 64 2d 6c 69 p ((lin (read-li
26b0: 6e 65 29 29 29 0a 20 20 20 20 28 69 66 20 28 6e ne))). (if (n
26c0: 6f 74 20 28 65 6f 66 2d 6f 62 6a 65 63 74 3f 20 ot (eof-object?
26d0: 6c 69 6e 29 29 0a 09 28 62 65 67 69 6e 0a 09 20 lin))..(begin..
26e0: 20 28 64 65 62 75 67 3a 70 72 69 6e 74 20 34 20 (debug:print 4
26f0: 2a 64 65 66 61 75 6c 74 2d 6c 6f 67 2d 70 6f 72 *default-log-por
2700: 74 2a 20 6c 69 6e 29 0a 20 20 20 20 20 20 20 20 t* lin).
2710: 20 20 3b 3b 28 77 68 65 6e 20 6c 69 6e 20 20 3b ;;(when lin ;
2720: 3b 20 74 68 69 73 20 77 68 65 6e 20 62 6c 6f 63 ; this when bloc
2730: 6b 65 64 20 73 74 61 63 6b 20 64 75 6d 70 20 63 ked stack dump c
2740: 61 75 73 65 64 20 62 79 20 2e 64 61 74 20 66 69 aused by .dat fi
2750: 6c 65 20 66 72 6f 6d 20 6c 6f 67 70 72 6f 20 62 le from logpro b
2760: 65 69 6e 67 20 30 2d 62 79 74 65 2e 20 20 66 69 eing 0-byte. fi
2770: 78 65 64 20 62 79 20 75 70 67 72 61 64 69 6e 67 xed by upgrading
2780: 20 6c 6f 67 70 72 6f 0a 20 20 20 20 20 20 20 20 logpro.
2790: 20 20 28 72 6d 74 3a 63 73 76 2d 3e 74 65 73 74 (rmt:csv->test
27a0: 2d 64 61 74 61 20 72 75 6e 2d 69 64 20 74 65 73 -data run-id tes
27b0: 74 2d 69 64 20 6c 69 6e 29 0a 20 20 20 20 20 20 t-id lin).
27c0: 20 20 20 20 3b 3b 29 0a 09 20 20 28 6c 6f 6f 70 ;;).. (loop
27d0: 20 28 72 65 61 64 2d 6c 69 6e 65 29 29 29 29 29 (read-line)))))
27e0: 0a 20 20 3b 3b 20 72 6f 6c 6c 20 75 70 20 74 68 . ;; roll up th
27f0: 65 20 63 75 72 72 65 6e 74 20 72 65 73 75 6c 74 e current result
2800: 73 2e 0a 20 20 3b 3b 20 46 49 58 4d 45 3a 20 41 s.. ;; FIXME: A
2810: 64 64 20 74 68 65 20 73 74 61 74 75 73 20 74 6f dd the status to
2820: 6f 20 0a 20 20 28 72 6d 74 3a 74 65 73 74 2d 64 o . (rmt:test-d
2830: 61 74 61 2d 72 6f 6c 6c 75 70 20 72 75 6e 2d 69 ata-rollup run-i
2840: 64 20 74 65 73 74 2d 69 64 20 23 66 29 29 0a 0a d test-id #f))..
2850: 3b 3b 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ;;==============
2860: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
2870: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
2880: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
2890: 3d 3d 3d 3d 3d 3d 3d 3d 0a 3b 3b 20 53 20 54 20 ========.;; S T
28a0: 45 20 50 20 53 20 0a 3b 3b 3d 3d 3d 3d 3d 3d 3d E P S .;;=======
28b0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
28c0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
28d0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d ================
28e0: 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a ===============.
28f0: 0a 28 64 65 66 69 6e 65 20 28 74 64 62 3a 73 74 .(define (tdb:st
2900: 65 70 2d 67 65 74 2d 74 69 6d 65 2d 61 73 2d 73 ep-get-time-as-s
2910: 74 72 69 6e 67 20 76 65 63 29 0a 20 20 28 73 65 tring vec). (se
2920: 63 6f 6e 64 73 2d 3e 74 69 6d 65 2d 73 74 72 69 conds->time-stri
2930: 6e 67 20 28 74 64 62 3a 73 74 65 70 2d 67 65 74 ng (tdb:step-get
2940: 2d 65 76 65 6e 74 5f 74 69 6d 65 20 76 65 63 29 -event_time vec)
2950: 29 29 0a 0a 3b 3b 20 67 65 74 20 61 20 70 72 65 ))..;; get a pre
2960: 74 74 79 20 74 61 62 6c 65 20 74 6f 20 73 75 6d tty table to sum
2970: 6d 61 72 69 7a 65 20 73 74 65 70 73 0a 3b 3b 20 marize steps.;;
2980: 0a 3b 3b 20 4e 4f 54 20 55 53 45 44 2c 20 57 49 .;; NOT USED, WI
2990: 4c 4c 20 42 45 20 52 45 4d 4f 56 45 44 0a 3b 3b LL BE REMOVED.;;
29a0: 0a 28 64 65 66 69 6e 65 20 28 74 64 62 3a 67 65 .(define (tdb:ge
29b0: 74 2d 73 74 65 70 73 2d 74 61 62 6c 65 20 73 74 t-steps-table st
29c0: 65 70 73 29 3b 3b 20 6f 72 67 61 6e 69 73 65 20 eps);; organise
29d0: 74 68 65 20 73 74 65 70 73 20 66 6f 72 20 62 65 the steps for be
29e0: 74 74 65 72 20 72 65 61 64 61 62 69 6c 69 74 79 tter readability
29f0: 0a 20 20 28 6c 65 74 20 28 28 72 65 73 20 28 6d . (let ((res (m
2a00: 61 6b 65 2d 68 61 73 68 2d 74 61 62 6c 65 29 29 ake-hash-table))
2a10: 29 0a 20 20 20 20 28 66 6f 72 2d 65 61 63 68 20 ). (for-each
2a20: 0a 20 20 20 20 20 28 6c 61 6d 62 64 61 20 28 73 . (lambda (s
2a30: 74 65 70 29 0a 20 20 20 20 20 20 20 28 64 65 62 tep). (deb
2a40: 75 67 3a 70 72 69 6e 74 20 36 20 2a 64 65 66 61 ug:print 6 *defa
2a50: 75 6c 74 2d 6c 6f 67 2d 70 6f 72 74 2a 20 22 73 ult-log-port* "s
2a60: 74 65 70 3d 22 20 73 74 65 70 29 0a 20 20 20 20 tep=" step).
2a70: 20 20 20 28 6c 65 74 20 28 28 72 65 63 6f 72 64 (let ((record
2a80: 20 28 68 61 73 68 2d 74 61 62 6c 65 2d 72 65 66 (hash-table-ref
2a90: 2f 64 65 66 61 75 6c 74 20 0a 09 09 20 20 20 20 /default ...
2aa0: 20 20 72 65 73 20 0a 09 09 20 20 20 20 20 20 28 res ... (
2ab0: 74 64 62 3a 73 74 65 70 2d 67 65 74 2d 73 74 65 tdb:step-get-ste
2ac0: 70 6e 61 6d 65 20 73 74 65 70 29 20 0a 09 09 20 pname step) ...
2ad0: 20 20 20 20 20 3b 3b 20 20 20 20 20 20 20 20 73 ;; s
2ae0: 74 65 70 6e 61 6d 65 20 20 20 20 20 20 20 20 20 tepname
2af0: 20 20 20 20 20 20 20 73 74 61 72 74 20 65 6e 64 start end
2b00: 20 73 74 61 74 75 73 20 44 75 72 61 74 69 6f 6e status Duration
2b10: 20 20 4c 6f 67 66 69 6c 65 20 0a 09 09 20 20 20 Logfile ...
2b20: 20 20 20 28 76 65 63 74 6f 72 20 28 74 64 62 3a (vector (tdb:
2b30: 73 74 65 70 2d 67 65 74 2d 73 74 65 70 6e 61 6d step-get-stepnam
2b40: 65 20 73 74 65 70 29 20 22 22 20 20 20 22 22 20 e step) "" ""
2b50: 22 22 20 20 20 20 20 22 22 20 20 20 20 20 20 20 "" ""
2b60: 20 22 22 29 29 29 29 0a 09 20 28 64 65 62 75 67 "")))).. (debug
2b70: 3a 70 72 69 6e 74 20 36 20 2a 64 65 66 61 75 6c :print 6 *defaul
2b80: 74 2d 6c 6f 67 2d 70 6f 72 74 2a 20 22 72 65 63 t-log-port* "rec
2b90: 6f 72 64 28 62 65 66 6f 72 65 29 20 3d 20 22 20 ord(before) = "
2ba0: 72 65 63 6f 72 64 20 0a 09 09 20 20 20 20 20 20 record ...
2bb0: 22 5c 6e 69 64 3a 20 20 20 20 20 20 20 22 20 28 "\nid: " (
2bc0: 74 64 62 3a 73 74 65 70 2d 67 65 74 2d 69 64 20 tdb:step-get-id
2bd0: 73 74 65 70 29 0a 09 09 20 20 20 20 20 20 22 5c step)... "\
2be0: 6e 73 74 65 70 6e 61 6d 65 3a 20 22 20 28 74 64 nstepname: " (td
2bf0: 62 3a 73 74 65 70 2d 67 65 74 2d 73 74 65 70 6e b:step-get-stepn
2c00: 61 6d 65 20 73 74 65 70 29 0a 09 09 20 20 20 20 ame step)...
2c10: 20 20 22 5c 6e 73 74 61 74 65 3a 20 20 20 20 22 "\nstate: "
2c20: 20 28 74 64 62 3a 73 74 65 70 2d 67 65 74 2d 73 (tdb:step-get-s
2c30: 74 61 74 65 20 73 74 65 70 29 0a 09 09 20 20 20 tate step)...
2c40: 20 20 20 22 5c 6e 73 74 61 74 75 73 3a 20 20 20 "\nstatus:
2c50: 22 20 28 74 64 62 3a 73 74 65 70 2d 67 65 74 2d " (tdb:step-get-
2c60: 73 74 61 74 75 73 20 73 74 65 70 29 0a 09 09 20 status step)...
2c70: 20 20 20 20 20 22 5c 6e 74 69 6d 65 3a 20 20 20 "\ntime:
2c80: 20 20 22 20 28 74 64 62 3a 73 74 65 70 2d 67 65 " (tdb:step-ge
2c90: 74 2d 65 76 65 6e 74 5f 74 69 6d 65 20 73 74 65 t-event_time ste
2ca0: 70 29 29 0a 09 20 28 63 61 73 65 20 28 73 74 72 p)).. (case (str
2cb0: 69 6e 67 2d 3e 73 79 6d 62 6f 6c 20 28 74 64 62 ing->symbol (tdb
2cc0: 3a 73 74 65 70 2d 67 65 74 2d 73 74 61 74 65 20 :step-get-state
2cd0: 73 74 65 70 29 29 0a 09 20 20 20 28 28 73 74 61 step)).. ((sta
2ce0: 72 74 29 28 76 65 63 74 6f 72 2d 73 65 74 21 20 rt)(vector-set!
2cf0: 72 65 63 6f 72 64 20 31 20 28 74 64 62 3a 73 74 record 1 (tdb:st
2d00: 65 70 2d 67 65 74 2d 65 76 65 6e 74 5f 74 69 6d ep-get-event_tim
2d10: 65 20 73 74 65 70 29 29 0a 09 20 20 20 20 28 76 e step)).. (v
2d20: 65 63 74 6f 72 2d 73 65 74 21 20 72 65 63 6f 72 ector-set! recor
2d30: 64 20 33 20 28 69 66 20 28 65 71 75 61 6c 3f 20 d 3 (if (equal?
2d40: 28 76 65 63 74 6f 72 2d 72 65 66 20 72 65 63 6f (vector-ref reco
2d50: 72 64 20 33 29 20 22 22 29 0a 09 09 09 09 20 20 rd 3) "").....
2d60: 20 20 20 20 28 74 64 62 3a 73 74 65 70 2d 67 65 (tdb:step-ge
2d70: 74 2d 73 74 61 74 75 73 20 73 74 65 70 29 29 29 t-status step)))
2d80: 0a 09 20 20 20 20 28 69 66 20 28 3e 20 28 73 74 .. (if (> (st
2d90: 72 69 6e 67 2d 6c 65 6e 67 74 68 20 28 74 64 62 ring-length (tdb
2da0: 3a 73 74 65 70 2d 67 65 74 2d 6c 6f 67 66 69 6c :step-get-logfil
2db0: 65 20 73 74 65 70 29 29 0a 09 09 20 20 20 30 29 e step))... 0)
2dc0: 0a 09 09 28 76 65 63 74 6f 72 2d 73 65 74 21 20 ...(vector-set!
2dd0: 72 65 63 6f 72 64 20 35 20 28 74 64 62 3a 73 74 record 5 (tdb:st
2de0: 65 70 2d 67 65 74 2d 6c 6f 67 66 69 6c 65 20 73 ep-get-logfile s
2df0: 74 65 70 29 29 29 29 0a 09 20 20 20 28 28 65 6e tep)))).. ((en
2e00: 64 29 20 20 0a 09 20 20 20 20 28 76 65 63 74 6f d) .. (vecto
2e10: 72 2d 73 65 74 21 20 72 65 63 6f 72 64 20 32 20 r-set! record 2
2e20: 28 61 6e 79 2d 3e 6e 75 6d 62 65 72 20 28 74 64 (any->number (td
2e30: 62 3a 73 74 65 70 2d 67 65 74 2d 65 76 65 6e 74 b:step-get-event
2e40: 5f 74 69 6d 65 20 73 74 65 70 29 29 29 0a 09 20 _time step)))..
2e50: 20 20 20 28 76 65 63 74 6f 72 2d 73 65 74 21 20 (vector-set!
2e60: 72 65 63 6f 72 64 20 33 20 28 74 64 62 3a 73 74 record 3 (tdb:st
2e70: 65 70 2d 67 65 74 2d 73 74 61 74 75 73 20 73 74 ep-get-status st
2e80: 65 70 29 29 0a 09 20 20 20 20 28 76 65 63 74 6f ep)).. (vecto
2e90: 72 2d 73 65 74 21 20 72 65 63 6f 72 64 20 34 20 r-set! record 4
2ea0: 28 6c 65 74 20 28 28 73 74 61 72 74 74 20 28 61 (let ((startt (a
2eb0: 6e 79 2d 3e 6e 75 6d 62 65 72 20 28 76 65 63 74 ny->number (vect
2ec0: 6f 72 2d 72 65 66 20 72 65 63 6f 72 64 20 31 29 or-ref record 1)
2ed0: 29 29 0a 09 09 09 09 09 28 65 6e 64 74 20 20 20 ))......(endt
2ee0: 28 61 6e 79 2d 3e 6e 75 6d 62 65 72 20 28 76 65 (any->number (ve
2ef0: 63 74 6f 72 2d 72 65 66 20 72 65 63 6f 72 64 20 ctor-ref record
2f00: 32 29 29 29 29 0a 09 09 09 09 20 20 20 20 28 64 2))))..... (d
2f10: 65 62 75 67 3a 70 72 69 6e 74 20 34 20 2a 64 65 ebug:print 4 *de
2f20: 66 61 75 6c 74 2d 6c 6f 67 2d 70 6f 72 74 2a 20 fault-log-port*
2f30: 22 72 65 63 6f 72 64 5b 31 5d 3d 22 20 28 76 65 "record[1]=" (ve
2f40: 63 74 6f 72 2d 72 65 66 20 72 65 63 6f 72 64 20 ctor-ref record
2f50: 31 29 20 0a 09 09 09 09 09 09 20 22 2c 20 73 74 1) ....... ", st
2f60: 61 72 74 74 3d 22 20 73 74 61 72 74 74 20 22 2c artt=" startt ",
2f70: 20 65 6e 64 74 3d 22 20 65 6e 64 74 0a 09 09 09 endt=" endt....
2f80: 09 09 09 20 22 2c 20 67 65 74 2d 73 74 61 74 75 ... ", get-statu
2f90: 73 3a 20 22 20 28 74 64 62 3a 73 74 65 70 2d 67 s: " (tdb:step-g
2fa0: 65 74 2d 73 74 61 74 75 73 20 73 74 65 70 29 29 et-status step))
2fb0: 0a 09 09 09 09 20 20 20 20 28 69 66 20 28 61 6e ..... (if (an
2fc0: 64 20 28 6e 75 6d 62 65 72 3f 20 73 74 61 72 74 d (number? start
2fd0: 74 29 28 6e 75 6d 62 65 72 3f 20 65 6e 64 74 29 t)(number? endt)
2fe0: 29 0a 09 09 09 09 09 28 73 65 63 6f 6e 64 73 2d )......(seconds-
2ff0: 3e 68 72 2d 6d 69 6e 2d 73 65 63 20 28 2d 20 65 >hr-min-sec (- e
3000: 6e 64 74 20 73 74 61 72 74 74 29 29 20 22 2d 31 ndt startt)) "-1
3010: 22 29 29 29 0a 09 20 20 20 20 28 69 66 20 28 3e "))).. (if (>
3020: 20 28 73 74 72 69 6e 67 2d 6c 65 6e 67 74 68 20 (string-length
3030: 28 74 64 62 3a 73 74 65 70 2d 67 65 74 2d 6c 6f (tdb:step-get-lo
3040: 67 66 69 6c 65 20 73 74 65 70 29 29 0a 09 09 20 gfile step))...
3050: 20 20 30 29 0a 09 09 28 76 65 63 74 6f 72 2d 73 0)...(vector-s
3060: 65 74 21 20 72 65 63 6f 72 64 20 35 20 28 74 64 et! record 5 (td
3070: 62 3a 73 74 65 70 2d 67 65 74 2d 6c 6f 67 66 69 b:step-get-logfi
3080: 6c 65 20 73 74 65 70 29 29 29 29 0a 09 20 20 20 le step))))..
3090: 28 65 6c 73 65 0a 09 20 20 20 20 28 76 65 63 74 (else.. (vect
30a0: 6f 72 2d 73 65 74 21 20 72 65 63 6f 72 64 20 32 or-set! record 2
30b0: 20 28 74 64 62 3a 73 74 65 70 2d 67 65 74 2d 73 (tdb:step-get-s
30c0: 74 61 74 65 20 73 74 65 70 29 29 0a 09 20 20 20 tate step))..
30d0: 20 28 76 65 63 74 6f 72 2d 73 65 74 21 20 72 65 (vector-set! re
30e0: 63 6f 72 64 20 33 20 28 74 64 62 3a 73 74 65 70 cord 3 (tdb:step
30f0: 2d 67 65 74 2d 73 74 61 74 75 73 20 73 74 65 70 -get-status step
3100: 29 29 0a 09 20 20 20 20 28 76 65 63 74 6f 72 2d )).. (vector-
3110: 73 65 74 21 20 72 65 63 6f 72 64 20 34 20 28 74 set! record 4 (t
3120: 64 62 3a 73 74 65 70 2d 67 65 74 2d 65 76 65 6e db:step-get-even
3130: 74 5f 74 69 6d 65 20 73 74 65 70 29 29 29 29 0a t_time step)))).
3140: 09 20 28 68 61 73 68 2d 74 61 62 6c 65 2d 73 65 . (hash-table-se
3150: 74 21 20 72 65 73 20 28 74 64 62 3a 73 74 65 70 t! res (tdb:step
3160: 2d 67 65 74 2d 73 74 65 70 6e 61 6d 65 20 73 74 -get-stepname st
3170: 65 70 29 20 72 65 63 6f 72 64 29 0a 09 20 28 64 ep) record).. (d
3180: 65 62 75 67 3a 70 72 69 6e 74 20 36 20 2a 64 65 ebug:print 6 *de
3190: 66 61 75 6c 74 2d 6c 6f 67 2d 70 6f 72 74 2a 20 fault-log-port*
31a0: 22 72 65 63 6f 72 64 28 61 66 74 65 72 29 20 20 "record(after)
31b0: 3d 20 22 20 72 65 63 6f 72 64 20 0a 09 09 20 20 = " record ...
31c0: 20 20 20 20 22 5c 6e 69 64 3a 20 20 20 20 20 20 "\nid:
31d0: 20 22 20 28 74 64 62 3a 73 74 65 70 2d 67 65 74 " (tdb:step-get
31e0: 2d 69 64 20 73 74 65 70 29 0a 09 09 20 20 20 20 -id step)...
31f0: 20 20 22 5c 6e 73 74 65 70 6e 61 6d 65 3a 20 22 "\nstepname: "
3200: 20 28 74 64 62 3a 73 74 65 70 2d 67 65 74 2d 73 (tdb:step-get-s
3210: 74 65 70 6e 61 6d 65 20 73 74 65 70 29 0a 09 09 tepname step)...
3220: 20 20 20 20 20 20 22 5c 6e 73 74 61 74 65 3a 20 "\nstate:
3230: 20 20 20 22 20 28 74 64 62 3a 73 74 65 70 2d 67 " (tdb:step-g
3240: 65 74 2d 73 74 61 74 65 20 73 74 65 70 29 0a 09 et-state step)..
3250: 09 20 20 20 20 20 20 22 5c 6e 73 74 61 74 75 73 . "\nstatus
3260: 3a 20 20 20 22 20 28 74 64 62 3a 73 74 65 70 2d : " (tdb:step-
3270: 67 65 74 2d 73 74 61 74 75 73 20 73 74 65 70 29 get-status step)
3280: 0a 09 09 20 20 20 20 20 20 22 5c 6e 74 69 6d 65 ... "\ntime
3290: 3a 20 20 20 20 20 22 20 28 74 64 62 3a 73 74 65 : " (tdb:ste
32a0: 70 2d 67 65 74 2d 65 76 65 6e 74 5f 74 69 6d 65 p-get-event_time
32b0: 20 73 74 65 70 29 29 29 29 0a 20 20 20 20 20 3b step)))). ;
32c0: 3b 20 28 65 6c 73 65 20 20 20 28 76 65 63 74 6f ; (else (vecto
32d0: 72 2d 73 65 74 21 20 72 65 63 6f 72 64 20 31 20 r-set! record 1
32e0: 28 74 64 62 3a 73 74 65 70 2d 67 65 74 2d 65 76 (tdb:step-get-ev
32f0: 65 6e 74 5f 74 69 6d 65 20 73 74 65 70 29 29 29 ent_time step)))
3300: 0a 20 20 20 20 20 28 73 6f 72 74 20 73 74 65 70 . (sort step
3310: 73 20 28 6c 61 6d 62 64 61 20 28 61 20 62 29 0a s (lambda (a b).
3320: 09 09 20 20 20 28 63 6f 6e 64 0a 09 09 20 20 20 .. (cond...
3330: 20 28 28 3c 20 20 20 28 74 64 62 3a 73 74 65 70 ((< (tdb:step
3340: 2d 67 65 74 2d 65 76 65 6e 74 5f 74 69 6d 65 20 -get-event_time
3350: 61 29 28 74 64 62 3a 73 74 65 70 2d 67 65 74 2d a)(tdb:step-get-
3360: 65 76 65 6e 74 5f 74 69 6d 65 20 62 29 29 20 23 event_time b)) #
3370: 74 29 0a 09 09 20 20 20 20 28 28 65 71 3f 20 28 t)... ((eq? (
3380: 74 64 62 3a 73 74 65 70 2d 67 65 74 2d 65 76 65 tdb:step-get-eve
3390: 6e 74 5f 74 69 6d 65 20 61 29 28 74 64 62 3a 73 nt_time a)(tdb:s
33a0: 74 65 70 2d 67 65 74 2d 65 76 65 6e 74 5f 74 69 tep-get-event_ti
33b0: 6d 65 20 62 29 29 20 0a 09 09 20 20 20 20 20 28 me b)) ... (
33c0: 3c 20 20 20 28 74 64 62 3a 73 74 65 70 2d 67 65 < (tdb:step-ge
33d0: 74 2d 69 64 20 61 29 20 20 20 20 20 20 20 20 28 t-id a) (
33e0: 74 64 62 3a 73 74 65 70 2d 67 65 74 2d 69 64 20 tdb:step-get-id
33f0: 62 29 29 29 0a 09 09 20 20 20 20 28 65 6c 73 65 b)))... (else
3400: 20 23 66 29 29 29 29 29 0a 20 20 20 20 72 65 73 #f))))). res
3410: 29 29 0a 0a 3b 3b 20 4d 6f 76 65 20 74 68 69 73 ))..;; Move this
3420: 20 74 6f 20 73 74 65 70 73 2e 73 63 6d 0a 3b 3b to steps.scm.;;
3430: 0a 3b 3b 20 67 65 74 20 61 20 70 72 65 74 74 79 .;; get a pretty
3440: 20 74 61 62 6c 65 20 74 6f 20 73 75 6d 6d 61 72 table to summar
3450: 69 7a 65 20 73 74 65 70 73 0a 3b 3b 0a 28 64 65 ize steps.;;.(de
3460: 66 69 6e 65 20 28 74 64 62 3a 67 65 74 2d 73 74 fine (tdb:get-st
3470: 65 70 73 2d 74 61 62 6c 65 2d 6c 69 73 74 20 73 eps-table-list s
3480: 74 65 70 73 29 0a 20 20 3b 3b 20 6f 72 67 61 6e teps). ;; organ
3490: 69 73 65 20 74 68 65 20 73 74 65 70 73 20 66 6f ise the steps fo
34a0: 72 20 62 65 74 74 65 72 20 72 65 61 64 61 62 69 r better readabi
34b0: 6c 69 74 79 0a 20 20 28 6c 65 74 20 28 28 72 65 lity. (let ((re
34c0: 73 20 28 6d 61 6b 65 2d 68 61 73 68 2d 74 61 62 s (make-hash-tab
34d0: 6c 65 29 29 29 0a 20 20 20 20 28 66 6f 72 2d 65 le))). (for-e
34e0: 61 63 68 20 0a 20 20 20 20 20 28 6c 61 6d 62 64 ach . (lambd
34f0: 61 20 28 73 74 65 70 29 0a 20 20 20 20 20 20 20 a (step).
3500: 28 64 65 62 75 67 3a 70 72 69 6e 74 20 36 20 2a (debug:print 6 *
3510: 64 65 66 61 75 6c 74 2d 6c 6f 67 2d 70 6f 72 74 default-log-port
3520: 2a 20 22 73 74 65 70 3d 22 20 73 74 65 70 29 0a * "step=" step).
3530: 20 20 20 20 20 20 20 28 6c 65 74 20 28 28 72 65 (let ((re
3540: 63 6f 72 64 20 28 68 61 73 68 2d 74 61 62 6c 65 cord (hash-table
3550: 2d 72 65 66 2f 64 65 66 61 75 6c 74 20 0a 09 09 -ref/default ...
3560: 20 20 20 20 20 20 72 65 73 20 0a 09 09 20 20 20 res ...
3570: 20 20 20 28 74 64 62 3a 73 74 65 70 2d 67 65 74 (tdb:step-get
3580: 2d 73 74 65 70 6e 61 6d 65 20 73 74 65 70 29 20 -stepname step)
3590: 0a 09 09 20 20 20 20 20 20 3b 3b 20 20 20 20 20 ... ;;
35a0: 20 20 20 73 74 65 70 6e 61 6d 65 20 20 20 20 20 stepname
35b0: 20 20 20 20 20 20 20 20 20 20 20 73 74 61 72 74 start
35c0: 20 65 6e 64 20 73 74 61 74 75 73 20 20 20 20 0a end status .
35d0: 09 09 20 20 20 20 20 20 28 76 65 63 74 6f 72 20 .. (vector
35e0: 28 74 64 62 3a 73 74 65 70 2d 67 65 74 2d 73 74 (tdb:step-get-st
35f0: 65 70 6e 61 6d 65 20 73 74 65 70 29 20 22 22 20 epname step) ""
3600: 20 20 22 22 20 22 22 20 20 20 20 20 22 22 20 22 "" "" "" "
3610: 22 29 29 29 29 0a 09 20 28 64 65 62 75 67 3a 70 ")))).. (debug:p
3620: 72 69 6e 74 20 36 20 2a 64 65 66 61 75 6c 74 2d rint 6 *default-
3630: 6c 6f 67 2d 70 6f 72 74 2a 20 22 72 65 63 6f 72 log-port* "recor
3640: 64 28 62 65 66 6f 72 65 29 20 3d 20 22 20 72 65 d(before) = " re
3650: 63 6f 72 64 20 0a 09 09 20 20 20 20 20 20 22 5c cord ... "\
3660: 6e 69 64 3a 20 20 20 20 20 20 20 22 20 28 74 64 nid: " (td
3670: 62 3a 73 74 65 70 2d 67 65 74 2d 69 64 20 73 74 b:step-get-id st
3680: 65 70 29 0a 09 09 20 20 20 20 20 20 22 5c 6e 73 ep)... "\ns
3690: 74 65 70 6e 61 6d 65 3a 20 22 20 28 74 64 62 3a tepname: " (tdb:
36a0: 73 74 65 70 2d 67 65 74 2d 73 74 65 70 6e 61 6d step-get-stepnam
36b0: 65 20 73 74 65 70 29 0a 09 09 20 20 20 20 20 20 e step)...
36c0: 22 5c 6e 73 74 61 74 65 3a 20 20 20 20 22 20 28 "\nstate: " (
36d0: 74 64 62 3a 73 74 65 70 2d 67 65 74 2d 73 74 61 tdb:step-get-sta
36e0: 74 65 20 73 74 65 70 29 0a 09 09 20 20 20 20 20 te step)...
36f0: 20 22 5c 6e 73 74 61 74 75 73 3a 20 20 20 22 20 "\nstatus: "
3700: 28 74 64 62 3a 73 74 65 70 2d 67 65 74 2d 73 74 (tdb:step-get-st
3710: 61 74 75 73 20 73 74 65 70 29 0a 09 09 20 20 20 atus step)...
3720: 20 20 20 22 5c 6e 74 69 6d 65 3a 20 20 20 20 20 "\ntime:
3730: 22 20 28 74 64 62 3a 73 74 65 70 2d 67 65 74 2d " (tdb:step-get-
3740: 65 76 65 6e 74 5f 74 69 6d 65 20 73 74 65 70 29 event_time step)
3750: 29 0a 09 20 28 63 61 73 65 20 28 73 74 72 69 6e ).. (case (strin
3760: 67 2d 3e 73 79 6d 62 6f 6c 20 28 74 64 62 3a 73 g->symbol (tdb:s
3770: 74 65 70 2d 67 65 74 2d 73 74 61 74 65 20 73 74 tep-get-state st
3780: 65 70 29 29 0a 09 20 20 20 28 28 73 74 61 72 74 ep)).. ((start
3790: 29 28 76 65 63 74 6f 72 2d 73 65 74 21 20 72 65 )(vector-set! re
37a0: 63 6f 72 64 20 31 20 28 74 64 62 3a 73 74 65 70 cord 1 (tdb:step
37b0: 2d 67 65 74 2d 65 76 65 6e 74 5f 74 69 6d 65 20 -get-event_time
37c0: 73 74 65 70 29 29 0a 09 20 20 20 20 28 76 65 63 step)).. (vec
37d0: 74 6f 72 2d 73 65 74 21 20 72 65 63 6f 72 64 20 tor-set! record
37e0: 33 20 28 69 66 20 28 65 71 75 61 6c 3f 20 28 76 3 (if (equal? (v
37f0: 65 63 74 6f 72 2d 72 65 66 20 72 65 63 6f 72 64 ector-ref record
3800: 20 33 29 20 22 22 29 0a 09 09 09 09 20 20 20 20 3) "").....
3810: 20 20 28 74 64 62 3a 73 74 65 70 2d 67 65 74 2d (tdb:step-get-
3820: 73 74 61 74 75 73 20 73 74 65 70 29 29 29 0a 09 status step)))..
3830: 20 20 20 20 28 69 66 20 28 3e 20 28 73 74 72 69 (if (> (stri
3840: 6e 67 2d 6c 65 6e 67 74 68 20 28 74 64 62 3a 73 ng-length (tdb:s
3850: 74 65 70 2d 67 65 74 2d 6c 6f 67 66 69 6c 65 20 tep-get-logfile
3860: 73 74 65 70 29 29 0a 09 09 20 20 20 30 29 0a 09 step))... 0)..
3870: 09 28 76 65 63 74 6f 72 2d 73 65 74 21 20 72 65 .(vector-set! re
3880: 63 6f 72 64 20 35 20 28 74 64 62 3a 73 74 65 70 cord 5 (tdb:step
3890: 2d 67 65 74 2d 6c 6f 67 66 69 6c 65 20 73 74 65 -get-logfile ste
38a0: 70 29 29 29 29 0a 09 20 20 20 28 28 65 6e 64 29 p)))).. ((end)
38b0: 20 20 0a 09 20 20 20 20 28 76 65 63 74 6f 72 2d .. (vector-
38c0: 73 65 74 21 20 72 65 63 6f 72 64 20 32 20 28 61 set! record 2 (a
38d0: 6e 79 2d 3e 6e 75 6d 62 65 72 20 28 74 64 62 3a ny->number (tdb:
38e0: 73 74 65 70 2d 67 65 74 2d 65 76 65 6e 74 5f 74 step-get-event_t
38f0: 69 6d 65 20 73 74 65 70 29 29 29 0a 09 20 20 20 ime step)))..
3900: 20 28 76 65 63 74 6f 72 2d 73 65 74 21 20 72 65 (vector-set! re
3910: 63 6f 72 64 20 33 20 28 74 64 62 3a 73 74 65 70 cord 3 (tdb:step
3920: 2d 67 65 74 2d 73 74 61 74 75 73 20 73 74 65 70 -get-status step
3930: 29 29 0a 09 20 20 20 20 28 76 65 63 74 6f 72 2d )).. (vector-
3940: 73 65 74 21 20 72 65 63 6f 72 64 20 34 20 28 6c set! record 4 (l
3950: 65 74 20 28 28 73 74 61 72 74 74 20 28 61 6e 79 et ((startt (any
3960: 2d 3e 6e 75 6d 62 65 72 20 28 76 65 63 74 6f 72 ->number (vector
3970: 2d 72 65 66 20 72 65 63 6f 72 64 20 31 29 29 29 -ref record 1)))
3980: 0a 09 09 09 09 09 28 65 6e 64 74 20 20 20 28 61 ......(endt (a
3990: 6e 79 2d 3e 6e 75 6d 62 65 72 20 28 76 65 63 74 ny->number (vect
39a0: 6f 72 2d 72 65 66 20 72 65 63 6f 72 64 20 32 29 or-ref record 2)
39b0: 29 29 29 0a 09 09 09 09 20 20 20 20 28 64 65 62 )))..... (deb
39c0: 75 67 3a 70 72 69 6e 74 20 34 20 2a 64 65 66 61 ug:print 4 *defa
39d0: 75 6c 74 2d 6c 6f 67 2d 70 6f 72 74 2a 20 22 72 ult-log-port* "r
39e0: 65 63 6f 72 64 5b 31 5d 3d 22 20 28 76 65 63 74 ecord[1]=" (vect
39f0: 6f 72 2d 72 65 66 20 72 65 63 6f 72 64 20 31 29 or-ref record 1)
3a00: 20 0a 09 09 09 09 09 09 20 22 2c 20 73 74 61 72 ....... ", star
3a10: 74 74 3d 22 20 73 74 61 72 74 74 20 22 2c 20 65 tt=" startt ", e
3a20: 6e 64 74 3d 22 20 65 6e 64 74 0a 09 09 09 09 09 ndt=" endt......
3a30: 09 20 22 2c 20 67 65 74 2d 73 74 61 74 75 73 3a . ", get-status:
3a40: 20 22 20 28 74 64 62 3a 73 74 65 70 2d 67 65 74 " (tdb:step-get
3a50: 2d 73 74 61 74 75 73 20 73 74 65 70 29 29 0a 09 -status step))..
3a60: 09 09 09 20 20 20 20 28 69 66 20 28 61 6e 64 20 ... (if (and
3a70: 28 6e 75 6d 62 65 72 3f 20 73 74 61 72 74 74 29 (number? startt)
3a80: 28 6e 75 6d 62 65 72 3f 20 65 6e 64 74 29 29 0a (number? endt)).
3a90: 09 09 09 09 09 28 73 65 63 6f 6e 64 73 2d 3e 68 .....(seconds->h
3aa0: 72 2d 6d 69 6e 2d 73 65 63 20 28 2d 20 65 6e 64 r-min-sec (- end
3ab0: 74 20 73 74 61 72 74 74 29 29 20 22 2d 31 22 29 t startt)) "-1")
3ac0: 29 29 0a 09 20 20 20 20 28 69 66 20 28 3e 20 28 )).. (if (> (
3ad0: 73 74 72 69 6e 67 2d 6c 65 6e 67 74 68 20 28 74 string-length (t
3ae0: 64 62 3a 73 74 65 70 2d 67 65 74 2d 6c 6f 67 66 db:step-get-logf
3af0: 69 6c 65 20 73 74 65 70 29 29 0a 09 09 20 20 20 ile step))...
3b00: 30 29 0a 09 09 28 76 65 63 74 6f 72 2d 73 65 74 0)...(vector-set
3b10: 21 20 72 65 63 6f 72 64 20 35 20 28 74 64 62 3a ! record 5 (tdb:
3b20: 73 74 65 70 2d 67 65 74 2d 6c 6f 67 66 69 6c 65 step-get-logfile
3b30: 20 73 74 65 70 29 29 29 29 0a 09 20 20 20 28 65 step)))).. (e
3b40: 6c 73 65 0a 09 20 20 20 20 28 76 65 63 74 6f 72 lse.. (vector
3b50: 2d 73 65 74 21 20 72 65 63 6f 72 64 20 32 20 28 -set! record 2 (
3b60: 74 64 62 3a 73 74 65 70 2d 67 65 74 2d 73 74 61 tdb:step-get-sta
3b70: 74 65 20 73 74 65 70 29 29 0a 09 20 20 20 20 28 te step)).. (
3b80: 76 65 63 74 6f 72 2d 73 65 74 21 20 72 65 63 6f vector-set! reco
3b90: 72 64 20 33 20 28 74 64 62 3a 73 74 65 70 2d 67 rd 3 (tdb:step-g
3ba0: 65 74 2d 73 74 61 74 75 73 20 73 74 65 70 29 29 et-status step))
3bb0: 0a 09 20 20 20 20 28 76 65 63 74 6f 72 2d 73 65 .. (vector-se
3bc0: 74 21 20 72 65 63 6f 72 64 20 34 20 28 74 64 62 t! record 4 (tdb
3bd0: 3a 73 74 65 70 2d 67 65 74 2d 65 76 65 6e 74 5f :step-get-event_
3be0: 74 69 6d 65 20 73 74 65 70 29 29 29 29 0a 09 20 time step))))..
3bf0: 28 68 61 73 68 2d 74 61 62 6c 65 2d 73 65 74 21 (hash-table-set!
3c00: 20 72 65 73 20 28 74 64 62 3a 73 74 65 70 2d 67 res (tdb:step-g
3c10: 65 74 2d 73 74 65 70 6e 61 6d 65 20 73 74 65 70 et-stepname step
3c20: 29 20 72 65 63 6f 72 64 29 0a 09 20 28 64 65 62 ) record).. (deb
3c30: 75 67 3a 70 72 69 6e 74 20 36 20 2a 64 65 66 61 ug:print 6 *defa
3c40: 75 6c 74 2d 6c 6f 67 2d 70 6f 72 74 2a 20 22 72 ult-log-port* "r
3c50: 65 63 6f 72 64 28 61 66 74 65 72 29 20 20 3d 20 ecord(after) =
3c60: 22 20 72 65 63 6f 72 64 20 0a 09 09 20 20 20 20 " record ...
3c70: 20 20 22 5c 6e 69 64 3a 20 20 20 20 20 20 20 22 "\nid: "
3c80: 20 28 74 64 62 3a 73 74 65 70 2d 67 65 74 2d 69 (tdb:step-get-i
3c90: 64 20 73 74 65 70 29 0a 09 09 20 20 20 20 20 20 d step)...
3ca0: 22 5c 6e 73 74 65 70 6e 61 6d 65 3a 20 22 20 28 "\nstepname: " (
3cb0: 74 64 62 3a 73 74 65 70 2d 67 65 74 2d 73 74 65 tdb:step-get-ste
3cc0: 70 6e 61 6d 65 20 73 74 65 70 29 0a 09 09 20 20 pname step)...
3cd0: 20 20 20 20 22 5c 6e 73 74 61 74 65 3a 20 20 20 "\nstate:
3ce0: 20 22 20 28 74 64 62 3a 73 74 65 70 2d 67 65 74 " (tdb:step-get
3cf0: 2d 73 74 61 74 65 20 73 74 65 70 29 0a 09 09 20 -state step)...
3d00: 20 20 20 20 20 22 5c 6e 73 74 61 74 75 73 3a 20 "\nstatus:
3d10: 20 20 22 20 28 74 64 62 3a 73 74 65 70 2d 67 65 " (tdb:step-ge
3d20: 74 2d 73 74 61 74 75 73 20 73 74 65 70 29 0a 09 t-status step)..
3d30: 09 20 20 20 20 20 20 22 5c 6e 74 69 6d 65 3a 20 . "\ntime:
3d40: 20 20 20 20 22 20 28 74 64 62 3a 73 74 65 70 2d " (tdb:step-
3d50: 67 65 74 2d 65 76 65 6e 74 5f 74 69 6d 65 20 73 get-event_time s
3d60: 74 65 70 29 29 29 29 0a 20 20 20 20 20 3b 3b 20 tep)))). ;;
3d70: 28 65 6c 73 65 20 20 20 28 76 65 63 74 6f 72 2d (else (vector-
3d80: 73 65 74 21 20 72 65 63 6f 72 64 20 31 20 28 74 set! record 1 (t
3d90: 64 62 3a 73 74 65 70 2d 67 65 74 2d 65 76 65 6e db:step-get-even
3da0: 74 5f 74 69 6d 65 20 73 74 65 70 29 29 29 0a 20 t_time step))).
3db0: 20 20 20 20 28 73 6f 72 74 20 73 74 65 70 73 20 (sort steps
3dc0: 28 6c 61 6d 62 64 61 20 28 61 20 62 29 0a 09 09 (lambda (a b)...
3dd0: 20 20 20 28 63 6f 6e 64 0a 09 09 20 20 20 20 28 (cond... (
3de0: 28 3c 20 20 20 28 74 64 62 3a 73 74 65 70 2d 67 (< (tdb:step-g
3df0: 65 74 2d 65 76 65 6e 74 5f 74 69 6d 65 20 61 29 et-event_time a)
3e00: 28 74 64 62 3a 73 74 65 70 2d 67 65 74 2d 65 76 (tdb:step-get-ev
3e10: 65 6e 74 5f 74 69 6d 65 20 62 29 29 20 23 74 29 ent_time b)) #t)
3e20: 0a 09 09 20 20 20 20 28 28 65 71 3f 20 28 74 64 ... ((eq? (td
3e30: 62 3a 73 74 65 70 2d 67 65 74 2d 65 76 65 6e 74 b:step-get-event
3e40: 5f 74 69 6d 65 20 61 29 28 74 64 62 3a 73 74 65 _time a)(tdb:ste
3e50: 70 2d 67 65 74 2d 65 76 65 6e 74 5f 74 69 6d 65 p-get-event_time
3e60: 20 62 29 29 20 0a 09 09 20 20 20 20 20 28 3c 20 b)) ... (<
3e70: 20 20 28 74 64 62 3a 73 74 65 70 2d 67 65 74 2d (tdb:step-get-
3e80: 69 64 20 61 29 20 20 20 20 20 20 20 20 28 74 64 id a) (td
3e90: 62 3a 73 74 65 70 2d 67 65 74 2d 69 64 20 62 29 b:step-get-id b)
3ea0: 29 29 0a 09 09 20 20 20 20 28 65 6c 73 65 20 23 ))... (else #
3eb0: 66 29 29 29 29 29 0a 20 20 20 20 72 65 73 29 29 f))))). res))
3ec0: 0a 0a 3b 3b 0a 3b 3b 20 4d 6f 76 65 20 74 6f 20 ..;;.;; Move to
3ed0: 73 74 65 70 73 2e 73 63 6d 0a 3b 3b 0a 28 64 65 steps.scm.;;.(de
3ee0: 66 69 6e 65 20 28 74 64 62 3a 67 65 74 2d 63 6f fine (tdb:get-co
3ef0: 6d 70 72 65 73 73 65 64 2d 73 74 65 70 73 20 63 mpressed-steps c
3f00: 6f 6d 70 72 73 74 65 70 73 29 20 3b 3b 20 66 72 omprsteps) ;; fr
3f10: 6f 6d 20 74 64 62 3a 67 65 74 2d 73 74 65 70 73 om tdb:get-steps
3f20: 2d 74 61 62 6c 65 0a 20 20 28 6d 61 70 20 28 6c -table. (map (l
3f30: 61 6d 62 64 61 20 28 78 29 0a 09 20 3b 3b 20 74 ambda (x).. ;; t
3f40: 61 6b 65 20 61 64 76 61 6e 74 61 67 65 20 6f 66 ake advantage of
3f50: 20 74 68 65 20 5c 6e 20 6f 6e 20 74 69 6d 65 2d the \n on time-
3f60: 3e 73 74 72 69 6e 67 0a 09 20 28 76 65 63 74 6f >string.. (vecto
3f70: 72 0a 09 20 20 28 76 65 63 74 6f 72 2d 72 65 66 r.. (vector-ref
3f80: 20 78 20 30 29 0a 09 20 20 28 6c 65 74 20 28 28 x 0).. (let ((
3f90: 73 20 28 76 65 63 74 6f 72 2d 72 65 66 20 78 20 s (vector-ref x
3fa0: 31 29 29 29 0a 09 20 20 20 20 28 69 66 20 28 6e 1))).. (if (n
3fb0: 75 6d 62 65 72 3f 20 73 29 28 73 65 63 6f 6e 64 umber? s)(second
3fc0: 73 2d 3e 74 69 6d 65 2d 73 74 72 69 6e 67 20 73 s->time-string s
3fd0: 29 20 73 29 29 0a 09 20 20 28 6c 65 74 20 28 28 ) s)).. (let ((
3fe0: 73 20 28 76 65 63 74 6f 72 2d 72 65 66 20 78 20 s (vector-ref x
3ff0: 32 29 29 29 0a 09 20 20 20 20 28 69 66 20 28 6e 2))).. (if (n
4000: 75 6d 62 65 72 3f 20 73 29 28 73 65 63 6f 6e 64 umber? s)(second
4010: 73 2d 3e 74 69 6d 65 2d 73 74 72 69 6e 67 20 73 s->time-string s
4020: 29 20 73 29 29 0a 09 20 20 28 76 65 63 74 6f 72 ) s)).. (vector
4030: 2d 72 65 66 20 78 20 33 29 20 20 20 20 3b 3b 20 -ref x 3) ;;
4040: 73 74 61 74 75 73 0a 09 20 20 28 76 65 63 74 6f status.. (vecto
4050: 72 2d 72 65 66 20 78 20 34 29 0a 09 20 20 28 76 r-ref x 4).. (v
4060: 65 63 74 6f 72 2d 72 65 66 20 78 20 35 29 29 29 ector-ref x 5)))
4070: 20 20 3b 3b 20 74 69 6d 65 20 64 65 6c 74 61 0a ;; time delta.
4080: 20 20 20 20 20 20 20 28 73 6f 72 74 20 28 68 61 (sort (ha
4090: 73 68 2d 74 61 62 6c 65 2d 76 61 6c 75 65 73 20 sh-table-values
40a0: 63 6f 6d 70 72 73 74 65 70 73 29 0a 09 20 20 20 comprsteps)..
40b0: 20 20 28 6c 61 6d 62 64 61 20 28 61 20 62 29 0a (lambda (a b).
40c0: 09 20 20 20 20 20 20 20 28 6c 65 74 20 28 28 74 . (let ((t
40d0: 69 6d 65 2d 61 20 28 76 65 63 74 6f 72 2d 72 65 ime-a (vector-re
40e0: 66 20 61 20 31 29 29 0a 09 09 20 20 20 20 20 28 f a 1))... (
40f0: 74 69 6d 65 2d 62 20 28 76 65 63 74 6f 72 2d 72 time-b (vector-r
4100: 65 66 20 62 20 31 29 29 29 0a 09 09 20 28 69 66 ef b 1)))... (if
4110: 20 28 61 6e 64 20 28 6e 75 6d 62 65 72 3f 20 74 (and (number? t
4120: 69 6d 65 2d 61 29 28 6e 75 6d 62 65 72 3f 20 74 ime-a)(number? t
4130: 69 6d 65 2d 62 29 29 0a 09 09 20 20 20 20 20 28 ime-b))... (
4140: 69 66 20 28 3c 20 74 69 6d 65 2d 61 20 74 69 6d if (< time-a tim
4150: 65 2d 62 29 0a 09 09 09 20 23 74 0a 09 09 09 20 e-b).... #t....
4160: 28 69 66 20 28 65 71 3f 20 74 69 6d 65 2d 61 20 (if (eq? time-a
4170: 74 69 6d 65 2d 62 29 0a 09 09 09 20 20 20 20 20 time-b)....
4180: 28 73 74 72 69 6e 67 3c 3f 20 28 63 6f 6e 63 20 (string<? (conc
4190: 28 76 65 63 74 6f 72 2d 72 65 66 20 61 20 32 29 (vector-ref a 2)
41a0: 29 0a 09 09 09 09 20 20 20 20 20 20 20 28 63 6f )..... (co
41b0: 6e 63 20 28 76 65 63 74 6f 72 2d 72 65 66 20 62 nc (vector-ref b
41c0: 20 32 29 29 29 0a 09 09 09 20 20 20 20 20 23 66 2))).... #f
41d0: 29 29 0a 09 09 20 20 20 20 20 28 73 74 72 69 6e ))... (strin
41e0: 67 3c 3f 20 28 63 6f 6e 63 20 74 69 6d 65 2d 61 g<? (conc time-a
41f0: 29 28 63 6f 6e 63 20 74 69 6d 65 2d 62 29 29 29 )(conc time-b)))
4200: 29 29 29 29 29 0a 0a 3b 3b 20 0a 28 64 65 66 69 )))))..;; .(defi
4210: 6e 65 20 28 74 64 62 3a 72 65 6d 6f 74 65 2d 75 ne (tdb:remote-u
4220: 70 64 61 74 65 2d 74 65 73 74 64 61 74 2d 6d 65 pdate-testdat-me
4230: 74 61 2d 69 6e 66 6f 20 72 75 6e 2d 69 64 20 74 ta-info run-id t
4240: 65 73 74 2d 69 64 20 77 6f 72 6b 2d 61 72 65 61 est-id work-area
4250: 20 63 70 75 6c 6f 61 64 20 64 69 73 6b 66 72 65 cpuload diskfre
4260: 65 20 6d 69 6e 75 74 65 73 29 0a 20 20 28 6c 65 e minutes). (le
4270: 74 20 28 28 74 64 62 20 20 20 20 20 20 20 20 20 t ((tdb
4280: 28 72 6d 74 3a 6f 70 65 6e 2d 74 65 73 74 2d 64 (rmt:open-test-d
4290: 62 2d 62 79 2d 74 65 73 74 2d 69 64 20 72 75 6e b-by-test-id run
42a0: 2d 69 64 20 74 65 73 74 2d 69 64 20 77 6f 72 6b -id test-id work
42b0: 2d 61 72 65 61 3a 20 77 6f 72 6b 2d 61 72 65 61 -area: work-area
42c0: 29 29 29 0a 20 20 20 20 28 69 66 20 28 73 71 6c ))). (if (sql
42d0: 69 74 65 33 3a 64 61 74 61 62 61 73 65 3f 20 74 ite3:database? t
42e0: 64 62 29 0a 09 28 62 65 67 69 6e 0a 09 20 20 28 db)..(begin.. (
42f0: 73 71 6c 69 74 65 33 3a 65 78 65 63 75 74 65 20 sqlite3:execute
4300: 74 64 62 20 22 49 4e 53 45 52 54 20 49 4e 54 4f tdb "INSERT INTO
4310: 20 74 65 73 74 5f 72 75 6e 64 61 74 20 28 75 70 test_rundat (up
4320: 64 61 74 65 5f 74 69 6d 65 2c 63 70 75 6c 6f 61 date_time,cpuloa
4330: 64 2c 64 69 73 6b 66 72 65 65 2c 72 75 6e 5f 64 d,diskfree,run_d
4340: 75 72 61 74 69 6f 6e 29 20 56 41 4c 55 45 53 20 uration) VALUES
4350: 28 73 74 72 66 74 69 6d 65 28 27 25 73 27 2c 27 (strftime('%s','
4360: 6e 6f 77 27 29 2c 3f 2c 3f 2c 3f 29 3b 22 0a 09 now'),?,?,?);"..
4370: 09 09 20 20 20 63 70 75 6c 6f 61 64 20 64 69 73 .. cpuload dis
4380: 6b 66 72 65 65 20 6d 69 6e 75 74 65 73 29 0a 09 kfree minutes)..
4390: 20 20 28 73 71 6c 69 74 65 33 3a 66 69 6e 61 6c (sqlite3:final
43a0: 69 7a 65 21 20 74 64 62 29 29 0a 09 28 64 65 62 ize! tdb))..(deb
43b0: 75 67 3a 70 72 69 6e 74 20 32 20 2a 64 65 66 61 ug:print 2 *defa
43c0: 75 6c 74 2d 6c 6f 67 2d 70 6f 72 74 2a 20 22 43 ult-log-port* "C
43d0: 61 6e 27 74 20 75 70 64 61 74 65 20 74 65 73 74 an't update test
43e0: 64 61 74 2e 64 62 20 66 6f 72 20 74 65 73 74 20 dat.db for test
43f0: 22 20 74 65 73 74 2d 69 64 20 22 20 72 65 61 64 " test-id " read
4400: 2d 6f 6e 6c 79 20 6f 72 20 6e 6f 6e 2d 65 78 69 -only or non-exi
4410: 73 74 61 6e 74 22 29 29 29 29 0a 20 20 20 20 0a stant")))). .