Artifact
29093c83c7a4b8f98924bcb80e3ae2d54a0e1726:
0000: 3b 3b 20 43 6f 70 79 72 69 67 68 74 20 32 30 30 ;; Copyright 200
0010: 37 2d 32 30 31 31 2c 20 4d 61 74 74 68 65 77 20 7-2011, Matthew
0020: 57 65 6c 6c 61 6e 64 2e 20 4b 69 61 74 6f 61 2e Welland. Kiatoa.
0030: 63 6f 6d 20 41 6c 6c 20 72 69 67 68 74 73 20 72 com All rights r
0040: 65 73 65 72 76 65 64 2e 0a 3b 3b 20 0a 0a 3b 3b eserved..;; ..;;
0050: 20 44 4f 4e 27 54 20 55 53 45 20 54 48 49 53 21 DON'T USE THIS!
0060: 21 21 21 20 49 74 20 77 61 73 20 61 20 62 61 64 !!! It was a bad
0070: 20 69 64 65 61 20 3a 2d 28 0a 0a 3b 3b 20 28 72 idea :-(..;; (r
0080: 65 71 75 69 72 65 2d 65 78 74 65 6e 73 69 6f 6e equire-extension
0090: 20 74 69 6e 79 63 6c 6f 73 29 0a 0a 3b 3b 20 28 tinyclos)..;; (
00a0: 64 65 66 69 6e 65 2d 63 6c 61 73 73 20 3c 73 71 define-class <sq
00b0: 6c 74 62 6c 3e 20 28 29 0a 3b 3b 20 20 20 28 72 ltbl> ().;; (r
00c0: 6f 77 73 0a 3b 3b 20 20 20 20 66 69 65 6c 64 73 ows.;; fields
00d0: 20 20 20 20 20 20 20 3b 3b 20 6c 69 73 74 20 6f ;; list o
00e0: 66 20 66 69 65 6c 64 0a 3b 3b 20 20 20 20 66 69 f field.;; fi
00f0: 65 6c 64 73 2d 68 61 73 68 20 20 3b 3b 20 68 61 elds-hash ;; ha
0100: 73 68 20 6f 66 20 66 69 65 6c 64 73 20 2d 3e 20 sh of fields ->
0110: 6e 75 6d 62 65 72 0a 3b 3b 20 20 20 20 71 75 65 number.;; que
0120: 72 79 20 20 20 20 20 20 20 20 3b 3b 20 71 75 65 ry ;; que
0130: 72 79 20 73 74 72 69 6e 67 20 75 73 69 6e 67 20 ry string using
0140: 3f 27 73 0a 3b 3b 20 20 20 20 71 75 65 72 79 2d ?'s.;; query-
0150: 70 61 72 61 6d 73 20 3b 3b 20 6c 69 73 74 20 6f params ;; list o
0160: 66 20 70 61 72 61 6d 73 20 66 6f 72 20 74 68 65 f params for the
0170: 20 71 75 65 72 79 0a 3b 3b 20 20 20 20 63 6f 6e query.;; con
0180: 6e 20 20 20 20 20 20 20 20 20 3b 3b 20 63 6f 6e n ;; con
0190: 6e 65 63 74 69 6f 6e 20 74 6f 20 64 62 0a 3b 3b nection to db.;;
01a0: 20 20 20 20 6e 75 6d 2d 72 6f 77 73 20 20 20 20 num-rows
01b0: 20 3b 3b 20 77 68 61 74 65 76 65 72 20 0a 3b 3b ;; whatever .;;
01c0: 20 20 20 20 63 75 72 72 2d 72 6f 77 2d 70 74 72 curr-row-ptr
01d0: 20 3b 3b 20 6e 75 6d 62 65 72 20 6f 66 20 74 68 ;; number of th
01e0: 65 20 63 75 72 72 65 6e 74 20 72 6f 77 0a 3b 3b e current row.;;
01f0: 20 20 20 20 63 75 72 72 2d 72 6f 77 20 20 20 20 curr-row
0200: 20 3b 3b 20 74 68 65 20 63 75 72 72 65 6e 74 20 ;; the current
0210: 72 6f 77 20 76 65 63 74 6f 72 20 28 3f 3f 20 64 row vector (?? d
0220: 6f 20 77 65 20 72 65 61 6c 6c 79 20 77 61 6e 74 o we really want
0230: 20 74 68 69 73 20 3f 3f 29 0a 3b 3b 20 20 20 20 this ??).;;
0240: 29 29 0a 0a 28 64 65 63 6c 61 72 65 20 28 75 6e ))..(declare (un
0250: 69 74 20 73 71 6c 74 62 6c 29 29 0a 0a 28 64 65 it sqltbl))..(de
0260: 66 69 6e 65 20 28 6d 61 6b 65 2d 73 71 6c 74 62 fine (make-sqltb
0270: 6c 3a 74 62 6c 29 28 6d 61 6b 65 2d 76 65 63 74 l:tbl)(make-vect
0280: 6f 72 20 39 29 29 0a 28 64 65 66 69 6e 65 20 28 or 9)).(define (
0290: 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 72 sqltbl:tbl-get-r
02a0: 6f 77 73 20 20 20 20 20 20 20 20 20 20 20 76 65 ows ve
02b0: 63 29 20 20 20 20 28 76 65 63 74 6f 72 2d 72 65 c) (vector-re
02c0: 66 20 20 76 65 63 20 30 29 29 0a 28 64 65 66 69 f vec 0)).(defi
02d0: 6e 65 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 ne (sqltbl:tbl-g
02e0: 65 74 2d 66 69 65 6c 64 73 20 20 20 20 20 20 20 et-fields
02f0: 20 20 76 65 63 29 20 20 20 20 28 76 65 63 74 6f vec) (vecto
0300: 72 2d 72 65 66 20 20 76 65 63 20 31 29 29 0a 28 r-ref vec 1)).(
0310: 64 65 66 69 6e 65 20 28 73 71 6c 74 62 6c 3a 74 define (sqltbl:t
0320: 62 6c 2d 67 65 74 2d 66 69 65 6c 64 73 2d 68 61 bl-get-fields-ha
0330: 73 68 20 20 20 20 76 65 63 29 20 20 20 20 28 76 sh vec) (v
0340: 65 63 74 6f 72 2d 72 65 66 20 20 76 65 63 20 32 ector-ref vec 2
0350: 29 29 0a 28 64 65 66 69 6e 65 20 28 73 71 6c 74 )).(define (sqlt
0360: 62 6c 3a 74 62 6c 2d 67 65 74 2d 71 75 65 72 79 bl:tbl-get-query
0370: 20 20 20 20 20 20 20 20 20 20 76 65 63 29 20 20 vec)
0380: 20 20 28 76 65 63 74 6f 72 2d 72 65 66 20 20 76 (vector-ref v
0390: 65 63 20 33 29 29 0a 28 64 65 66 69 6e 65 20 28 ec 3)).(define (
03a0: 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 71 sqltbl:tbl-get-q
03b0: 75 65 72 79 2d 70 61 72 61 6d 73 20 20 20 76 65 uery-params ve
03c0: 63 29 20 20 20 20 28 76 65 63 74 6f 72 2d 72 65 c) (vector-re
03d0: 66 20 20 76 65 63 20 34 29 29 0a 28 64 65 66 69 f vec 4)).(defi
03e0: 6e 65 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 ne (sqltbl:tbl-g
03f0: 65 74 2d 63 6f 6e 6e 20 20 20 20 20 20 20 20 20 et-conn
0400: 20 20 76 65 63 29 20 20 20 20 28 76 65 63 74 6f vec) (vecto
0410: 72 2d 72 65 66 20 20 76 65 63 20 35 29 29 0a 28 r-ref vec 5)).(
0420: 64 65 66 69 6e 65 20 28 73 71 6c 74 62 6c 3a 74 define (sqltbl:t
0430: 62 6c 2d 67 65 74 2d 6e 75 6d 2d 72 6f 77 73 20 bl-get-num-rows
0440: 20 20 20 20 20 20 76 65 63 29 20 20 20 20 28 76 vec) (v
0450: 65 63 74 6f 72 2d 72 65 66 20 20 76 65 63 20 36 ector-ref vec 6
0460: 29 29 0a 28 64 65 66 69 6e 65 20 28 73 71 6c 74 )).(define (sqlt
0470: 62 6c 3a 74 62 6c 2d 67 65 74 2d 63 75 72 72 2d bl:tbl-get-curr-
0480: 72 6f 77 2d 70 74 72 20 20 20 76 65 63 29 20 20 row-ptr vec)
0490: 20 20 28 76 65 63 74 6f 72 2d 72 65 66 20 20 76 (vector-ref v
04a0: 65 63 20 37 29 29 0a 28 64 65 66 69 6e 65 20 28 ec 7)).(define (
04b0: 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 63 sqltbl:tbl-get-c
04c0: 75 72 72 2d 72 6f 77 20 20 20 20 20 20 20 76 65 urr-row ve
04d0: 63 29 20 20 20 20 28 76 65 63 74 6f 72 2d 72 65 c) (vector-re
04e0: 66 20 20 76 65 63 20 38 29 29 0a 28 64 65 66 69 f vec 8)).(defi
04f0: 6e 65 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 ne (sqltbl:tbl-s
0500: 65 74 2d 72 6f 77 73 21 20 20 20 20 20 20 20 20 et-rows!
0510: 20 20 76 65 63 20 76 61 6c 29 28 76 65 63 74 6f vec val)(vecto
0520: 72 2d 73 65 74 21 20 76 65 63 20 30 20 76 61 6c r-set! vec 0 val
0530: 29 29 0a 28 64 65 66 69 6e 65 20 28 73 71 6c 74 )).(define (sqlt
0540: 62 6c 3a 74 62 6c 2d 73 65 74 2d 66 69 65 6c 64 bl:tbl-set-field
0550: 73 21 20 20 20 20 20 20 20 20 76 65 63 20 76 61 s! vec va
0560: 6c 29 28 76 65 63 74 6f 72 2d 73 65 74 21 20 76 l)(vector-set! v
0570: 65 63 20 31 20 76 61 6c 29 29 0a 28 64 65 66 69 ec 1 val)).(defi
0580: 6e 65 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 ne (sqltbl:tbl-s
0590: 65 74 2d 66 69 65 6c 64 73 2d 68 61 73 68 21 20 et-fields-hash!
05a0: 20 20 76 65 63 20 76 61 6c 29 28 76 65 63 74 6f vec val)(vecto
05b0: 72 2d 73 65 74 21 20 76 65 63 20 32 20 76 61 6c r-set! vec 2 val
05c0: 29 29 0a 28 64 65 66 69 6e 65 20 28 73 71 6c 74 )).(define (sqlt
05d0: 62 6c 3a 74 62 6c 2d 73 65 74 2d 71 75 65 72 79 bl:tbl-set-query
05e0: 21 20 20 20 20 20 20 20 20 20 76 65 63 20 76 61 ! vec va
05f0: 6c 29 28 76 65 63 74 6f 72 2d 73 65 74 21 20 76 l)(vector-set! v
0600: 65 63 20 33 20 76 61 6c 29 29 0a 28 64 65 66 69 ec 3 val)).(defi
0610: 6e 65 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 ne (sqltbl:tbl-s
0620: 65 74 2d 71 75 65 72 79 2d 70 61 72 61 6d 73 21 et-query-params!
0630: 20 20 76 65 63 20 76 61 6c 29 28 76 65 63 74 6f vec val)(vecto
0640: 72 2d 73 65 74 21 20 76 65 63 20 34 20 76 61 6c r-set! vec 4 val
0650: 29 29 0a 28 64 65 66 69 6e 65 20 28 73 71 6c 74 )).(define (sqlt
0660: 62 6c 3a 74 62 6c 2d 73 65 74 2d 63 6f 6e 6e 21 bl:tbl-set-conn!
0670: 20 20 20 20 20 20 20 20 20 20 76 65 63 20 76 61 vec va
0680: 6c 29 28 76 65 63 74 6f 72 2d 73 65 74 21 20 76 l)(vector-set! v
0690: 65 63 20 35 20 76 61 6c 29 29 0a 28 64 65 66 69 ec 5 val)).(defi
06a0: 6e 65 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 ne (sqltbl:tbl-s
06b0: 65 74 2d 6e 75 6d 2d 72 6f 77 73 21 20 20 20 20 et-num-rows!
06c0: 20 20 76 65 63 20 76 61 6c 29 28 76 65 63 74 6f vec val)(vecto
06d0: 72 2d 73 65 74 21 20 76 65 63 20 36 20 76 61 6c r-set! vec 6 val
06e0: 29 29 0a 28 64 65 66 69 6e 65 20 28 73 71 6c 74 )).(define (sqlt
06f0: 62 6c 3a 74 62 6c 2d 73 65 74 2d 63 75 72 72 2d bl:tbl-set-curr-
0700: 72 6f 77 2d 70 74 72 21 20 20 76 65 63 20 76 61 row-ptr! vec va
0710: 6c 29 28 76 65 63 74 6f 72 2d 73 65 74 21 20 76 l)(vector-set! v
0720: 65 63 20 37 20 76 61 6c 29 29 0a 28 64 65 66 69 ec 7 val)).(defi
0730: 6e 65 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 ne (sqltbl:tbl-s
0740: 65 74 2d 63 75 72 72 2d 72 6f 77 21 20 20 20 20 et-curr-row!
0750: 20 20 76 65 63 20 76 61 6c 29 28 76 65 63 74 6f vec val)(vecto
0760: 72 2d 73 65 74 21 20 76 65 63 20 38 20 76 61 6c r-set! vec 8 val
0770: 29 29 0a 0a 28 64 65 66 69 6e 65 20 20 28 73 71 ))..(define (sq
0780: 6c 74 62 6c 3a 69 6e 69 74 69 61 6c 69 7a 65 20 ltbl:initialize
0790: 73 65 6c 66 29 3b 3b 20 69 6e 69 74 61 72 67 73 self);; initargs
07a0: 29 0a 20 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d ). (sqltbl:tbl-
07b0: 73 65 74 2d 6e 75 6d 2d 72 6f 77 73 21 20 73 65 set-num-rows! se
07c0: 6c 66 20 30 29 0a 20 20 28 73 71 6c 74 62 6c 3a lf 0). (sqltbl:
07d0: 74 62 6c 2d 73 65 74 2d 63 75 72 72 2d 72 6f 77 tbl-set-curr-row
07e0: 2d 70 74 72 21 20 73 65 6c 66 20 30 29 0a 20 20 -ptr! self 0).
07f0: 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d (sqltbl:tbl-set-
0800: 66 69 65 6c 64 73 21 20 73 65 6c 66 20 27 28 29 fields! self '()
0810: 29 0a 20 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d ). (sqltbl:tbl-
0820: 73 65 74 2d 66 69 65 6c 64 73 2d 68 61 73 68 21 set-fields-hash!
0830: 20 73 65 6c 66 20 28 6d 61 6b 65 2d 68 61 73 68 self (make-hash
0840: 2d 74 61 62 6c 65 29 29 29 0a 20 20 3b 3b 20 28 -table))). ;; (
0850: 69 6e 69 74 69 61 6c 69 7a 65 2d 73 6c 6f 74 73 initialize-slots
0860: 20 73 65 6c 66 20 69 6e 69 74 61 72 67 73 29 29 self initargs))
0870: 0a 3b 3b 20 20 28 69 66 20 28 3e 20 28 6c 65 6e .;; (if (> (len
0880: 67 74 68 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d gth (sqltbl:tbl-
0890: 67 65 74 2d 72 6f 77 73 20 73 65 6c 66 29 20 30 get-rows self) 0
08a0: 29 29 0a 3b 3b 20 20 20 20 20 20 28 73 71 6c 74 )).;; (sqlt
08b0: 62 6c 3a 74 62 6c 2d 73 65 74 2d 63 75 72 72 2d bl:tbl-set-curr-
08c0: 72 6f 77 21 20 73 65 6c 66 20 28 63 61 72 20 72 row! self (car r
08d0: 6f 77 73 29 29 29 29 0a 0a 28 64 65 66 69 6e 65 ows))))..(define
08e0: 20 28 73 71 6c 74 62 6c 3a 6e 65 78 74 2d 72 6f (sqltbl:next-ro
08f0: 77 20 73 65 6c 66 29 0a 20 20 28 6c 65 74 20 28 w self). (let (
0900: 28 63 75 72 72 2d 72 6f 77 2d 70 74 72 20 28 2b (curr-row-ptr (+
0910: 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 (sqltbl:tbl-get
0920: 2d 63 75 72 72 2d 72 6f 77 2d 70 74 72 20 73 65 -curr-row-ptr se
0930: 6c 66 29 20 31 29 29 0a 20 20 20 20 20 20 20 20 lf) 1)).
0940: 28 6e 75 6d 2d 72 6f 77 73 20 20 20 20 20 28 73 (num-rows (s
0950: 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 6e 75 qltbl:tbl-get-nu
0960: 6d 2d 72 6f 77 73 20 73 65 6c 66 29 29 0a 20 20 m-rows self)).
0970: 20 20 20 20 20 20 28 72 6f 77 73 20 20 20 20 20 (rows
0980: 20 20 20 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d (sqltbl:tbl-
0990: 67 65 74 2d 72 6f 77 73 20 73 65 6c 66 29 29 29 get-rows self)))
09a0: 0a 20 20 20 20 28 69 66 20 28 3e 20 63 75 72 72 . (if (> curr
09b0: 2d 72 6f 77 2d 70 72 74 20 28 73 71 6c 74 62 6c -row-prt (sqltbl
09c0: 3a 74 62 6c 2d 67 65 74 2d 6e 75 6d 2d 72 6f 77 :tbl-get-num-row
09d0: 73 20 73 65 6c 66 29 29 20 23 66 20 3b 3b 20 74 s self)) #f ;; t
09e0: 68 65 72 65 20 69 73 20 6e 6f 20 6e 65 78 74 20 here is no next
09f0: 72 6f 77 0a 20 20 20 20 20 20 20 20 28 6c 65 74 row. (let
0a00: 20 28 28 6e 65 77 2d 63 75 72 72 2d 72 6f 77 20 ((new-curr-row
0a10: 28 6c 69 73 74 2d 72 65 66 20 72 6f 77 73 20 63 (list-ref rows c
0a20: 75 72 72 2d 72 6f 77 2d 70 74 72 29 29 29 0a 20 urr-row-ptr))).
0a30: 20 20 20 20 20 20 20 20 20 28 73 71 6c 74 62 6c (sqltbl
0a40: 3a 74 62 6c 2d 73 65 74 2d 63 75 72 72 2d 72 6f :tbl-set-curr-ro
0a50: 77 21 20 73 65 6c 66 20 6e 65 77 2d 63 75 72 72 w! self new-curr
0a60: 2d 72 6f 77 29 0a 20 20 20 20 20 20 20 20 20 20 -row).
0a70: 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d (sqltbl:tbl-set-
0a80: 63 75 72 72 2d 72 6f 77 2d 70 72 74 21 20 73 65 curr-row-prt! se
0a90: 6c 66 20 63 75 72 72 2d 72 6f 77 2d 70 72 74 29 lf curr-row-prt)
0aa0: 0a 20 20 20 20 20 20 20 20 20 20 6e 65 77 2d 63 . new-c
0ab0: 75 72 72 2d 72 6f 77 29 29 29 29 0a 0a 3b 3b 20 urr-row))))..;;
0ac0: 72 75 6e 20 74 68 65 20 71 75 65 72 79 20 61 6e run the query an
0ad0: 64 20 66 69 6c 6c 20 74 68 65 20 72 6f 77 73 20 d fill the rows
0ae0: 6c 69 73 74 20 0a 28 64 65 66 69 6e 65 20 28 73 list .(define (s
0af0: 71 6c 74 62 6c 3a 72 75 6e 2d 71 75 65 72 79 20 qltbl:run-query
0b00: 73 65 6c 66 20 2e 20 70 61 72 61 6d 73 29 0a 20 self . params).
0b10: 20 28 6c 65 74 2a 20 28 28 71 75 65 72 79 20 20 (let* ((query
0b20: 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d (sqltbl:tbl-get-
0b30: 71 75 65 72 79 20 73 65 6c 66 29 29 0a 20 20 20 query self)).
0b40: 20 20 20 20 20 20 28 66 69 65 6c 64 73 20 28 73 (fields (s
0b50: 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 66 69 qltbl:tbl-get-fi
0b60: 65 6c 64 73 20 73 65 6c 66 29 29 0a 20 20 20 20 elds self)).
0b70: 20 20 20 20 20 28 72 6f 77 73 20 28 6c 65 74 20 (rows (let
0b80: 28 28 72 65 73 75 6c 74 20 27 28 29 29 0a 20 20 ((result '()).
0b90: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
0ba0: 20 20 20 28 61 63 74 75 61 6c 2d 71 75 65 72 79 (actual-query
0bb0: 20 28 61 70 70 6c 79 20 73 3a 73 71 6c 70 61 72 (apply s:sqlpar
0bc0: 61 6d 20 71 75 65 72 79 20 66 69 65 6c 64 73 20 am query fields
0bd0: 70 61 72 61 6d 73 29 29 29 0a 20 20 20 20 20 20 params))).
0be0: 20 20 20 20 20 20 20 20 20 20 20 3b 3b 20 28 73 ;; (s
0bf0: 3a 6c 6f 67 20 22 61 63 74 75 61 6c 2d 71 75 65 :log "actual-que
0c00: 72 79 3d 22 20 61 63 74 75 61 6c 2d 71 75 65 72 ry=" actual-quer
0c10: 79 29 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 y).
0c20: 20 20 20 20 28 64 62 69 3a 66 6f 72 2d 65 61 63 (dbi:for-eac
0c30: 68 2d 72 6f 77 20 28 6c 61 6d 62 64 61 20 28 74 h-row (lambda (t
0c40: 75 70 6c 65 29 0a 20 20 20 20 20 20 20 20 20 20 uple).
0c50: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
0c60: 20 20 20 20 20 20 20 20 20 20 20 20 28 73 65 74 (set
0c70: 21 20 72 65 73 75 6c 74 20 28 63 6f 6e 73 20 74 ! result (cons t
0c80: 75 70 6c 65 20 72 65 73 75 6c 74 29 29 29 0a 20 uple result))).
0c90: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
0ca0: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
0cb0: 20 20 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 (sqltbl:tbl-g
0cc0: 65 74 2d 63 6f 6e 6e 20 73 65 6c 66 29 0a 09 09 et-conn self)...
0cd0: 09 09 61 63 74 75 61 6c 2d 71 75 65 72 79 29 0a ..actual-query).
0ce0: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
0cf0: 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 (sqltbl:tbl-set
0d00: 2d 71 75 65 72 79 2d 70 61 72 61 6d 73 21 20 73 -query-params! s
0d10: 65 6c 66 20 70 61 72 61 6d 73 29 0a 20 20 20 20 elf params).
0d20: 20 20 20 20 20 20 20 20 20 20 20 20 20 28 73 71 (sq
0d30: 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d 6e 75 6d ltbl:tbl-set-num
0d40: 2d 72 6f 77 73 21 20 73 65 6c 66 20 28 6c 65 6e -rows! self (len
0d50: 67 74 68 20 72 65 73 75 6c 74 29 29 0a 20 20 20 gth result)).
0d60: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 28 73 (s
0d70: 71 6c 74 62 6c 3a 73 65 74 75 70 2d 66 69 65 6c qltbl:setup-fiel
0d80: 64 73 20 73 65 6c 66 29 20 20 3b 3b 20 75 70 64 ds self) ;; upd
0d90: 61 74 65 20 74 68 65 20 66 69 65 6c 64 73 20 6c ate the fields l
0da0: 6f 6f 6b 75 70 20 68 61 73 68 0a 20 20 20 20 20 ookup hash.
0db0: 20 20 20 20 20 20 20 20 20 20 20 20 28 72 65 76 (rev
0dc0: 65 72 73 65 20 72 65 73 75 6c 74 29 29 29 29 0a erse result)))).
0dd0: 20 20 20 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d (sqltbl:tbl-
0de0: 73 65 74 2d 72 6f 77 73 21 20 73 65 6c 66 20 72 set-rows! self r
0df0: 6f 77 73 29 0a 20 20 20 20 28 69 66 20 28 6e 6f ows). (if (no
0e00: 74 20 28 6e 75 6c 6c 3f 20 72 6f 77 73 29 29 0a t (null? rows)).
0e10: 20 20 20 20 20 20 20 20 28 73 71 6c 74 62 6c 3a (sqltbl:
0e20: 74 62 6c 2d 73 65 74 2d 63 75 72 72 2d 72 6f 77 tbl-set-curr-row
0e30: 21 20 73 65 6c 66 20 28 63 61 72 20 72 6f 77 73 ! self (car rows
0e40: 29 29 29 0a 20 20 20 20 28 73 71 6c 74 62 6c 3a ))). (sqltbl:
0e50: 74 62 6c 2d 73 65 74 2d 63 75 72 72 2d 72 6f 77 tbl-set-curr-row
0e60: 2d 70 74 72 21 20 73 65 6c 66 20 30 29 0a 20 20 -ptr! self 0).
0e70: 20 20 72 6f 77 73 29 29 0a 0a 28 64 65 66 69 6e rows))..(defin
0e80: 65 20 28 73 71 6c 74 62 6c 3a 73 65 74 75 70 2d e (sqltbl:setup-
0e90: 66 69 65 6c 64 73 20 73 65 6c 66 29 0a 20 20 28 fields self). (
0ea0: 6c 65 74 20 28 28 66 69 65 6c 64 73 2d 68 61 73 let ((fields-has
0eb0: 68 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 h (sqltbl:tbl-ge
0ec0: 74 2d 66 69 65 6c 64 73 2d 68 61 73 68 20 73 65 t-fields-hash se
0ed0: 6c 66 29 29 0a 20 20 20 20 20 20 20 20 28 66 69 lf)). (fi
0ee0: 65 6c 64 73 2d 6c 69 73 74 20 28 73 71 6c 74 62 elds-list (sqltb
0ef0: 6c 3a 74 62 6c 2d 67 65 74 2d 66 69 65 6c 64 73 l:tbl-get-fields
0f00: 20 73 65 6c 66 29 29 29 0a 20 20 20 20 28 6c 65 self))). (le
0f10: 74 20 6c 6f 6f 70 20 28 28 68 65 61 64 20 28 63 t loop ((head (c
0f20: 61 72 20 66 69 65 6c 64 73 2d 6c 69 73 74 29 29 ar fields-list))
0f30: 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 .
0f40: 28 74 61 69 6c 20 28 63 64 72 20 66 69 65 6c 64 (tail (cdr field
0f50: 73 2d 6c 69 73 74 29 29 0a 20 20 20 20 20 20 20 s-list)).
0f60: 20 20 20 20 20 20 20 20 28 66 6e 75 6d 20 30 29 (fnum 0)
0f70: 29 0a 20 20 20 20 20 20 28 68 61 73 68 2d 74 61 ). (hash-ta
0f80: 62 6c 65 2d 73 65 74 21 20 66 69 65 6c 64 73 2d ble-set! fields-
0f90: 68 61 73 68 20 68 65 61 64 20 66 6e 75 6d 29 0a hash head fnum).
0fa0: 20 20 20 20 20 20 28 69 66 20 28 6e 75 6c 6c 3f (if (null?
0fb0: 20 74 61 69 6c 29 20 66 6e 75 6d 0a 20 20 20 20 tail) fnum.
0fc0: 20 20 20 20 20 20 28 6c 6f 6f 70 20 28 63 61 72 (loop (car
0fd0: 20 74 61 69 6c 29 28 63 64 72 20 74 61 69 6c 29 tail)(cdr tail)
0fe0: 28 2b 20 66 6e 75 6d 20 31 29 29 29 29 29 29 0a (+ fnum 1)))))).
0ff0: 0a 3b 3b 20 67 65 74 20 61 20 76 61 6c 75 65 20 .;; get a value
1000: 66 72 6f 6d 20 74 68 65 20 63 75 72 72 65 6e 74 from the current
1010: 20 72 6f 77 0a 28 64 65 66 69 6e 65 20 28 73 71 row.(define (sq
1020: 6c 74 62 6c 3a 67 65 74 2d 66 69 65 6c 64 2d 76 ltbl:get-field-v
1030: 61 6c 75 65 2d 63 75 72 72 20 73 65 6c 66 20 66 alue-curr self f
1040: 69 65 6c 64 29 0a 20 20 28 6c 65 74 20 28 28 63 ield). (let ((c
1050: 75 72 72 2d 72 6f 77 20 20 28 73 71 6c 74 62 6c urr-row (sqltbl
1060: 3a 74 62 6c 2d 67 65 74 2d 63 75 72 72 2d 72 6f :tbl-get-curr-ro
1070: 77 20 73 65 6c 66 29 29 0a 20 20 20 20 20 20 20 w self)).
1080: 20 28 66 69 65 6c 64 2d 6e 75 6d 20 28 68 61 73 (field-num (has
1090: 68 2d 74 61 62 6c 65 2d 72 65 66 2f 64 65 66 61 h-table-ref/defa
10a0: 75 6c 74 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d ult (sqltbl:tbl-
10b0: 67 65 74 2d 66 69 65 6c 64 73 2d 68 61 73 68 20 get-fields-hash
10c0: 73 65 6c 66 29 20 66 69 65 6c 64 20 23 66 29 29 self) field #f))
10d0: 29 0a 20 20 20 20 28 69 66 20 66 69 65 6c 64 2d ). (if field-
10e0: 6e 75 6d 20 0a 20 20 20 20 20 20 20 20 28 76 65 num . (ve
10f0: 63 74 6f 72 2d 72 65 66 20 63 75 72 72 2d 72 6f ctor-ref curr-ro
1100: 77 20 66 69 65 6c 64 2d 6e 75 6d 29 0a 20 20 20 w field-num).
1110: 20 20 20 20 20 23 66 29 29 29 20 3b 3b 20 6e 6f #f))) ;; no
1120: 74 20 66 6f 75 6e 64 20 2d 3e 20 23 66 0a 0a 28 t found -> #f..(
1130: 64 65 66 69 6e 65 20 28 73 71 6c 74 62 6c 3a 76 define (sqltbl:v
1140: 65 63 74 6f 72 2d 3e 68 61 73 68 20 73 65 6c 66 ector->hash self
1150: 20 76 65 63 29 0a 20 20 28 6c 65 74 20 28 28 68 vec). (let ((h
1160: 20 20 20 20 20 20 28 6d 61 6b 65 2d 68 61 73 68 (make-hash
1170: 2d 74 61 62 6c 65 29 29 0a 20 20 20 20 20 20 20 -table)).
1180: 20 28 66 69 65 6c 64 73 20 28 73 71 6c 74 62 6c (fields (sqltbl
1190: 3a 74 62 6c 2d 67 65 74 2d 66 69 65 6c 64 73 20 :tbl-get-fields
11a0: 73 65 6c 66 29 29 29 0a 20 20 20 20 28 64 6f 20 self))). (do
11b0: 28 28 69 20 30 20 28 2b 20 69 20 31 29 29 29 0a ((i 0 (+ i 1))).
11c0: 20 20 20 20 20 20 20 20 28 28 3e 3d 20 69 20 28 ((>= i (
11d0: 6c 65 6e 67 74 68 20 66 69 65 6c 64 73 29 29 29 length fields)))
11e0: 0a 20 20 20 20 20 20 28 68 61 73 68 2d 74 61 62 . (hash-tab
11f0: 6c 65 2d 73 65 74 21 20 68 20 28 6c 69 73 74 2d le-set! h (list-
1200: 72 65 66 20 66 69 65 6c 64 73 20 69 29 28 76 65 ref fields i)(ve
1210: 63 74 6f 72 2d 72 65 66 20 76 65 63 20 69 29 29 ctor-ref vec i))
1220: 29 0a 20 20 20 20 68 29 29 0a 0a 0a 3b 3b 20 72 ). h))...;; r
1230: 75 6e 73 20 70 72 6f 63 20 6f 6e 20 65 61 63 68 uns proc on each
1240: 20 72 6f 77 20 61 6e 64 20 72 65 74 75 72 6e 73 row and returns
1250: 20 74 68 65 20 72 65 73 75 6c 74 69 6e 67 20 6c the resulting l
1260: 69 73 74 0a 28 64 65 66 69 6e 65 20 28 73 71 6c ist.(define (sql
1270: 74 62 6c 3a 6d 61 70 20 73 65 6c 66 20 70 72 6f tbl:map self pro
1280: 63 29 0a 20 20 28 6d 61 70 20 28 6c 61 6d 62 64 c). (map (lambd
1290: 61 20 28 72 6f 77 29 0a 20 20 20 20 20 20 20 20 a (row).
12a0: 20 28 70 72 6f 63 20 28 73 71 6c 74 62 6c 3a 76 (proc (sqltbl:v
12b0: 65 63 74 6f 72 2d 3e 68 61 73 68 20 73 65 6c 66 ector->hash self
12c0: 20 72 6f 77 29 29 29 20 28 73 71 6c 74 62 6c 3a row))) (sqltbl:
12d0: 74 62 6c 2d 67 65 74 2d 72 6f 77 73 20 73 65 6c tbl-get-rows sel
12e0: 66 29 29 29 0a 20 20 20 0a f))). .