Artifact
2a2c7dc4e0c66e504443595ef538d31c2d8b4c28:
0000: 3b 3b 20 43 6f 70 79 72 69 67 68 74 20 32 30 30 ;; Copyright 200
0010: 37 2d 32 30 30 38 2c 20 4d 61 74 74 68 65 77 20 7-2008, 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 66 69 6e 65 20 28 6d 61 6b ))..(define (mak
0250: 65 2d 73 71 6c 74 62 6c 3a 74 62 6c 29 28 6d 61 e-sqltbl:tbl)(ma
0260: 6b 65 2d 76 65 63 74 6f 72 20 39 29 29 0a 28 64 ke-vector 9)).(d
0270: 65 66 69 6e 65 2d 69 6e 6c 69 6e 65 20 28 73 71 efine-inline (sq
0280: 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 72 6f 77 ltbl:tbl-get-row
0290: 73 20 20 20 20 20 20 20 20 20 20 20 76 65 63 29 s vec)
02a0: 20 20 20 20 28 76 65 63 74 6f 72 2d 72 65 66 20 (vector-ref
02b0: 20 76 65 63 20 30 29 29 0a 28 64 65 66 69 6e 65 vec 0)).(define
02c0: 2d 69 6e 6c 69 6e 65 20 28 73 71 6c 74 62 6c 3a -inline (sqltbl:
02d0: 74 62 6c 2d 67 65 74 2d 66 69 65 6c 64 73 20 20 tbl-get-fields
02e0: 20 20 20 20 20 20 20 76 65 63 29 20 20 20 20 28 vec) (
02f0: 76 65 63 74 6f 72 2d 72 65 66 20 20 76 65 63 20 vector-ref vec
0300: 31 29 29 0a 28 64 65 66 69 6e 65 2d 69 6e 6c 69 1)).(define-inli
0310: 6e 65 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 ne (sqltbl:tbl-g
0320: 65 74 2d 66 69 65 6c 64 73 2d 68 61 73 68 20 20 et-fields-hash
0330: 20 20 76 65 63 29 20 20 20 20 28 76 65 63 74 6f vec) (vecto
0340: 72 2d 72 65 66 20 20 76 65 63 20 32 29 29 0a 28 r-ref vec 2)).(
0350: 64 65 66 69 6e 65 2d 69 6e 6c 69 6e 65 20 28 73 define-inline (s
0360: 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 71 75 qltbl:tbl-get-qu
0370: 65 72 79 20 20 20 20 20 20 20 20 20 20 76 65 63 ery vec
0380: 29 20 20 20 20 28 76 65 63 74 6f 72 2d 72 65 66 ) (vector-ref
0390: 20 20 76 65 63 20 33 29 29 0a 28 64 65 66 69 6e vec 3)).(defin
03a0: 65 2d 69 6e 6c 69 6e 65 20 28 73 71 6c 74 62 6c e-inline (sqltbl
03b0: 3a 74 62 6c 2d 67 65 74 2d 71 75 65 72 79 2d 70 :tbl-get-query-p
03c0: 61 72 61 6d 73 20 20 20 76 65 63 29 20 20 20 20 arams vec)
03d0: 28 76 65 63 74 6f 72 2d 72 65 66 20 20 76 65 63 (vector-ref vec
03e0: 20 34 29 29 0a 28 64 65 66 69 6e 65 2d 69 6e 6c 4)).(define-inl
03f0: 69 6e 65 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d ine (sqltbl:tbl-
0400: 67 65 74 2d 63 6f 6e 6e 20 20 20 20 20 20 20 20 get-conn
0410: 20 20 20 76 65 63 29 20 20 20 20 28 76 65 63 74 vec) (vect
0420: 6f 72 2d 72 65 66 20 20 76 65 63 20 35 29 29 0a or-ref vec 5)).
0430: 28 64 65 66 69 6e 65 2d 69 6e 6c 69 6e 65 20 28 (define-inline (
0440: 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 6e sqltbl:tbl-get-n
0450: 75 6d 2d 72 6f 77 73 20 20 20 20 20 20 20 76 65 um-rows ve
0460: 63 29 20 20 20 20 28 76 65 63 74 6f 72 2d 72 65 c) (vector-re
0470: 66 20 20 76 65 63 20 36 29 29 0a 28 64 65 66 69 f vec 6)).(defi
0480: 6e 65 2d 69 6e 6c 69 6e 65 20 28 73 71 6c 74 62 ne-inline (sqltb
0490: 6c 3a 74 62 6c 2d 67 65 74 2d 63 75 72 72 2d 72 l:tbl-get-curr-r
04a0: 6f 77 2d 70 74 72 20 20 20 76 65 63 29 20 20 20 ow-ptr vec)
04b0: 20 28 76 65 63 74 6f 72 2d 72 65 66 20 20 76 65 (vector-ref ve
04c0: 63 20 37 29 29 0a 28 64 65 66 69 6e 65 2d 69 6e c 7)).(define-in
04d0: 6c 69 6e 65 20 28 73 71 6c 74 62 6c 3a 74 62 6c line (sqltbl:tbl
04e0: 2d 67 65 74 2d 63 75 72 72 2d 72 6f 77 20 20 20 -get-curr-row
04f0: 20 20 20 20 76 65 63 29 20 20 20 20 28 76 65 63 vec) (vec
0500: 74 6f 72 2d 72 65 66 20 20 76 65 63 20 38 29 29 tor-ref vec 8))
0510: 0a 28 64 65 66 69 6e 65 2d 69 6e 6c 69 6e 65 20 .(define-inline
0520: 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d (sqltbl:tbl-set-
0530: 72 6f 77 73 21 20 20 20 20 20 20 20 20 20 20 76 rows! v
0540: 65 63 20 76 61 6c 29 28 76 65 63 74 6f 72 2d 73 ec val)(vector-s
0550: 65 74 21 20 76 65 63 20 30 20 76 61 6c 29 29 0a et! vec 0 val)).
0560: 28 64 65 66 69 6e 65 2d 69 6e 6c 69 6e 65 20 28 (define-inline (
0570: 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d 66 sqltbl:tbl-set-f
0580: 69 65 6c 64 73 21 20 20 20 20 20 20 20 20 76 65 ields! ve
0590: 63 20 76 61 6c 29 28 76 65 63 74 6f 72 2d 73 65 c val)(vector-se
05a0: 74 21 20 76 65 63 20 31 20 76 61 6c 29 29 0a 28 t! vec 1 val)).(
05b0: 64 65 66 69 6e 65 2d 69 6e 6c 69 6e 65 20 28 73 define-inline (s
05c0: 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d 66 69 qltbl:tbl-set-fi
05d0: 65 6c 64 73 2d 68 61 73 68 21 20 20 20 76 65 63 elds-hash! vec
05e0: 20 76 61 6c 29 28 76 65 63 74 6f 72 2d 73 65 74 val)(vector-set
05f0: 21 20 76 65 63 20 32 20 76 61 6c 29 29 0a 28 64 ! vec 2 val)).(d
0600: 65 66 69 6e 65 2d 69 6e 6c 69 6e 65 20 28 73 71 efine-inline (sq
0610: 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d 71 75 65 ltbl:tbl-set-que
0620: 72 79 21 20 20 20 20 20 20 20 20 20 76 65 63 20 ry! vec
0630: 76 61 6c 29 28 76 65 63 74 6f 72 2d 73 65 74 21 val)(vector-set!
0640: 20 76 65 63 20 33 20 76 61 6c 29 29 0a 28 64 65 vec 3 val)).(de
0650: 66 69 6e 65 2d 69 6e 6c 69 6e 65 20 28 73 71 6c fine-inline (sql
0660: 74 62 6c 3a 74 62 6c 2d 73 65 74 2d 71 75 65 72 tbl:tbl-set-quer
0670: 79 2d 70 61 72 61 6d 73 21 20 20 76 65 63 20 76 y-params! vec v
0680: 61 6c 29 28 76 65 63 74 6f 72 2d 73 65 74 21 20 al)(vector-set!
0690: 76 65 63 20 34 20 76 61 6c 29 29 0a 28 64 65 66 vec 4 val)).(def
06a0: 69 6e 65 2d 69 6e 6c 69 6e 65 20 28 73 71 6c 74 ine-inline (sqlt
06b0: 62 6c 3a 74 62 6c 2d 73 65 74 2d 63 6f 6e 6e 21 bl:tbl-set-conn!
06c0: 20 20 20 20 20 20 20 20 20 20 76 65 63 20 76 61 vec va
06d0: 6c 29 28 76 65 63 74 6f 72 2d 73 65 74 21 20 76 l)(vector-set! v
06e0: 65 63 20 35 20 76 61 6c 29 29 0a 28 64 65 66 69 ec 5 val)).(defi
06f0: 6e 65 2d 69 6e 6c 69 6e 65 20 28 73 71 6c 74 62 ne-inline (sqltb
0700: 6c 3a 74 62 6c 2d 73 65 74 2d 6e 75 6d 2d 72 6f l:tbl-set-num-ro
0710: 77 73 21 20 20 20 20 20 20 76 65 63 20 76 61 6c ws! vec val
0720: 29 28 76 65 63 74 6f 72 2d 73 65 74 21 20 76 65 )(vector-set! ve
0730: 63 20 36 20 76 61 6c 29 29 0a 28 64 65 66 69 6e c 6 val)).(defin
0740: 65 2d 69 6e 6c 69 6e 65 20 28 73 71 6c 74 62 6c e-inline (sqltbl
0750: 3a 74 62 6c 2d 73 65 74 2d 63 75 72 72 2d 72 6f :tbl-set-curr-ro
0760: 77 2d 70 74 72 21 20 20 76 65 63 20 76 61 6c 29 w-ptr! vec val)
0770: 28 76 65 63 74 6f 72 2d 73 65 74 21 20 76 65 63 (vector-set! vec
0780: 20 37 20 76 61 6c 29 29 0a 28 64 65 66 69 6e 65 7 val)).(define
0790: 2d 69 6e 6c 69 6e 65 20 28 73 71 6c 74 62 6c 3a -inline (sqltbl:
07a0: 74 62 6c 2d 73 65 74 2d 63 75 72 72 2d 72 6f 77 tbl-set-curr-row
07b0: 21 20 20 20 20 20 20 76 65 63 20 76 61 6c 29 28 ! vec val)(
07c0: 76 65 63 74 6f 72 2d 73 65 74 21 20 76 65 63 20 vector-set! vec
07d0: 38 20 76 61 6c 29 29 0a 0a 28 64 65 66 69 6e 65 8 val))..(define
07e0: 20 20 28 73 71 6c 74 62 6c 3a 69 6e 69 74 69 61 (sqltbl:initia
07f0: 6c 69 7a 65 20 73 65 6c 66 29 3b 3b 20 69 6e 69 lize self);; ini
0800: 74 61 72 67 73 29 0a 20 20 28 73 71 6c 74 62 6c targs). (sqltbl
0810: 3a 74 62 6c 2d 73 65 74 2d 6e 75 6d 2d 72 6f 77 :tbl-set-num-row
0820: 73 21 20 73 65 6c 66 20 30 29 0a 20 20 28 73 71 s! self 0). (sq
0830: 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d 63 75 72 ltbl:tbl-set-cur
0840: 72 2d 72 6f 77 2d 70 74 72 21 20 73 65 6c 66 20 r-row-ptr! self
0850: 30 29 0a 20 20 28 73 71 6c 74 62 6c 3a 74 62 6c 0). (sqltbl:tbl
0860: 2d 73 65 74 2d 66 69 65 6c 64 73 21 20 73 65 6c -set-fields! sel
0870: 66 20 27 28 29 29 0a 20 20 28 73 71 6c 74 62 6c f '()). (sqltbl
0880: 3a 74 62 6c 2d 73 65 74 2d 66 69 65 6c 64 73 2d :tbl-set-fields-
0890: 68 61 73 68 21 20 73 65 6c 66 20 28 6d 61 6b 65 hash! self (make
08a0: 2d 68 61 73 68 2d 74 61 62 6c 65 29 29 29 0a 20 -hash-table))).
08b0: 20 3b 3b 20 28 69 6e 69 74 69 61 6c 69 7a 65 2d ;; (initialize-
08c0: 73 6c 6f 74 73 20 73 65 6c 66 20 69 6e 69 74 61 slots self inita
08d0: 72 67 73 29 29 0a 3b 3b 20 20 28 69 66 20 28 3e rgs)).;; (if (>
08e0: 20 28 6c 65 6e 67 74 68 20 28 73 71 6c 74 62 6c (length (sqltbl
08f0: 3a 74 62 6c 2d 67 65 74 2d 72 6f 77 73 20 73 65 :tbl-get-rows se
0900: 6c 66 29 20 30 29 29 0a 3b 3b 20 20 20 20 20 20 lf) 0)).;;
0910: 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d (sqltbl:tbl-set-
0920: 63 75 72 72 2d 72 6f 77 21 20 73 65 6c 66 20 28 curr-row! self (
0930: 63 61 72 20 72 6f 77 73 29 29 29 29 0a 0a 28 64 car rows))))..(d
0940: 65 66 69 6e 65 20 28 73 71 6c 74 62 6c 3a 6e 65 efine (sqltbl:ne
0950: 78 74 2d 72 6f 77 20 73 65 6c 66 29 0a 20 20 28 xt-row self). (
0960: 6c 65 74 20 28 28 63 75 72 72 2d 72 6f 77 2d 70 let ((curr-row-p
0970: 74 72 20 28 2b 20 28 73 71 6c 74 62 6c 3a 74 62 tr (+ (sqltbl:tb
0980: 6c 2d 67 65 74 2d 63 75 72 72 2d 72 6f 77 2d 70 l-get-curr-row-p
0990: 74 72 20 73 65 6c 66 29 20 31 29 29 0a 20 20 20 tr self) 1)).
09a0: 20 20 20 20 20 28 6e 75 6d 2d 72 6f 77 73 20 20 (num-rows
09b0: 20 20 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 (sqltbl:tbl-g
09c0: 65 74 2d 6e 75 6d 2d 72 6f 77 73 20 73 65 6c 66 et-num-rows self
09d0: 29 29 0a 20 20 20 20 20 20 20 20 28 72 6f 77 73 )). (rows
09e0: 20 20 20 20 20 20 20 20 20 28 73 71 6c 74 62 6c (sqltbl
09f0: 3a 74 62 6c 2d 67 65 74 2d 72 6f 77 73 20 73 65 :tbl-get-rows se
0a00: 6c 66 29 29 29 0a 20 20 20 20 28 69 66 20 28 3e lf))). (if (>
0a10: 20 63 75 72 72 2d 72 6f 77 2d 70 72 74 20 28 73 curr-row-prt (s
0a20: 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 6e 75 qltbl:tbl-get-nu
0a30: 6d 2d 72 6f 77 73 20 73 65 6c 66 29 29 20 23 66 m-rows self)) #f
0a40: 20 3b 3b 20 74 68 65 72 65 20 69 73 20 6e 6f 20 ;; there is no
0a50: 6e 65 78 74 20 72 6f 77 0a 20 20 20 20 20 20 20 next row.
0a60: 20 28 6c 65 74 20 28 28 6e 65 77 2d 63 75 72 72 (let ((new-curr
0a70: 2d 72 6f 77 20 28 6c 69 73 74 2d 72 65 66 20 72 -row (list-ref r
0a80: 6f 77 73 20 63 75 72 72 2d 72 6f 77 2d 70 74 72 ows curr-row-ptr
0a90: 29 29 29 0a 20 20 20 20 20 20 20 20 20 20 28 73 ))). (s
0aa0: 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d 63 75 qltbl:tbl-set-cu
0ab0: 72 72 2d 72 6f 77 21 20 73 65 6c 66 20 6e 65 77 rr-row! self new
0ac0: 2d 63 75 72 72 2d 72 6f 77 29 0a 20 20 20 20 20 -curr-row).
0ad0: 20 20 20 20 20 28 73 71 6c 74 62 6c 3a 74 62 6c (sqltbl:tbl
0ae0: 2d 73 65 74 2d 63 75 72 72 2d 72 6f 77 2d 70 72 -set-curr-row-pr
0af0: 74 21 20 73 65 6c 66 20 63 75 72 72 2d 72 6f 77 t! self curr-row
0b00: 2d 70 72 74 29 0a 20 20 20 20 20 20 20 20 20 20 -prt).
0b10: 6e 65 77 2d 63 75 72 72 2d 72 6f 77 29 29 29 29 new-curr-row))))
0b20: 0a 0a 3b 3b 20 72 75 6e 20 74 68 65 20 71 75 65 ..;; run the que
0b30: 72 79 20 61 6e 64 20 66 69 6c 6c 20 74 68 65 20 ry and fill the
0b40: 72 6f 77 73 20 6c 69 73 74 20 0a 28 64 65 66 69 rows list .(defi
0b50: 6e 65 20 28 73 71 6c 74 62 6c 3a 72 75 6e 2d 71 ne (sqltbl:run-q
0b60: 75 65 72 79 20 73 65 6c 66 20 2e 20 70 61 72 61 uery self . para
0b70: 6d 73 29 0a 20 20 28 6c 65 74 2a 20 28 28 71 75 ms). (let* ((qu
0b80: 65 72 79 20 20 28 73 71 6c 74 62 6c 3a 74 62 6c ery (sqltbl:tbl
0b90: 2d 67 65 74 2d 71 75 65 72 79 20 73 65 6c 66 29 -get-query self)
0ba0: 29 0a 20 20 20 20 20 20 20 20 20 28 66 69 65 6c ). (fiel
0bb0: 64 73 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 ds (sqltbl:tbl-g
0bc0: 65 74 2d 66 69 65 6c 64 73 20 73 65 6c 66 29 29 et-fields self))
0bd0: 0a 20 20 20 20 20 20 20 20 20 28 72 6f 77 73 20 . (rows
0be0: 28 6c 65 74 20 28 28 72 65 73 75 6c 74 20 27 28 (let ((result '(
0bf0: 29 29 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 )).
0c00: 20 20 20 20 20 20 20 20 28 61 63 74 75 61 6c 2d (actual-
0c10: 71 75 65 72 79 20 28 61 70 70 6c 79 20 73 3a 73 query (apply s:s
0c20: 71 6c 70 61 72 61 6d 20 71 75 65 72 79 20 66 69 qlparam query fi
0c30: 65 6c 64 73 20 70 61 72 61 6d 73 29 29 29 0a 20 elds params))).
0c40: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
0c50: 3b 3b 20 28 73 3a 6c 6f 67 20 22 61 63 74 75 61 ;; (s:log "actua
0c60: 6c 2d 71 75 65 72 79 3d 22 20 61 63 74 75 61 6c l-query=" actual
0c70: 2d 71 75 65 72 79 29 0a 20 20 20 20 20 20 20 20 -query).
0c80: 20 20 20 20 20 20 20 20 20 28 64 62 69 3a 66 6f (dbi:fo
0c90: 72 2d 65 61 63 68 2d 72 6f 77 20 28 6c 61 6d 62 r-each-row (lamb
0ca0: 64 61 20 28 74 75 70 6c 65 29 0a 20 20 20 20 20 da (tuple).
0cb0: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
0cc0: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
0cd0: 20 28 73 65 74 21 20 72 65 73 75 6c 74 20 28 63 (set! result (c
0ce0: 6f 6e 73 20 74 75 70 6c 65 20 72 65 73 75 6c 74 ons tuple result
0cf0: 29 29 29 0a 20 20 20 20 20 20 20 20 20 20 20 20 ))).
0d00: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
0d10: 20 20 20 20 20 20 20 20 28 73 71 6c 74 62 6c 3a (sqltbl:
0d20: 74 62 6c 2d 67 65 74 2d 63 6f 6e 6e 20 73 65 6c tbl-get-conn sel
0d30: 66 29 0a 09 09 09 09 61 63 74 75 61 6c 2d 71 75 f).....actual-qu
0d40: 65 72 79 29 0a 20 20 20 20 20 20 20 20 20 20 20 ery).
0d50: 20 20 20 20 20 20 28 73 71 6c 74 62 6c 3a 74 62 (sqltbl:tb
0d60: 6c 2d 73 65 74 2d 71 75 65 72 79 2d 70 61 72 61 l-set-query-para
0d70: 6d 73 21 20 73 65 6c 66 20 70 61 72 61 6d 73 29 ms! self params)
0d80: 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 .
0d90: 20 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 (sqltbl:tbl-se
0da0: 74 2d 6e 75 6d 2d 72 6f 77 73 21 20 73 65 6c 66 t-num-rows! self
0db0: 20 28 6c 65 6e 67 74 68 20 72 65 73 75 6c 74 29 (length result)
0dc0: 29 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 ).
0dd0: 20 20 20 28 73 71 6c 74 62 6c 3a 73 65 74 75 70 (sqltbl:setup
0de0: 2d 66 69 65 6c 64 73 20 73 65 6c 66 29 20 20 3b -fields self) ;
0df0: 3b 20 75 70 64 61 74 65 20 74 68 65 20 66 69 65 ; update the fie
0e00: 6c 64 73 20 6c 6f 6f 6b 75 70 20 68 61 73 68 0a lds lookup hash.
0e10: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
0e20: 20 28 72 65 76 65 72 73 65 20 72 65 73 75 6c 74 (reverse result
0e30: 29 29 29 29 0a 20 20 20 20 28 73 71 6c 74 62 6c )))). (sqltbl
0e40: 3a 74 62 6c 2d 73 65 74 2d 72 6f 77 73 21 20 73 :tbl-set-rows! s
0e50: 65 6c 66 20 72 6f 77 73 29 0a 20 20 20 20 28 69 elf rows). (i
0e60: 66 20 28 6e 6f 74 20 28 6e 75 6c 6c 3f 20 72 6f f (not (null? ro
0e70: 77 73 29 29 0a 20 20 20 20 20 20 20 20 28 73 71 ws)). (sq
0e80: 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d 63 75 72 ltbl:tbl-set-cur
0e90: 72 2d 72 6f 77 21 20 73 65 6c 66 20 28 63 61 72 r-row! self (car
0ea0: 20 72 6f 77 73 29 29 29 0a 20 20 20 20 28 73 71 rows))). (sq
0eb0: 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d 63 75 72 ltbl:tbl-set-cur
0ec0: 72 2d 72 6f 77 2d 70 74 72 21 20 73 65 6c 66 20 r-row-ptr! self
0ed0: 30 29 0a 20 20 20 20 72 6f 77 73 29 29 0a 0a 28 0). rows))..(
0ee0: 64 65 66 69 6e 65 20 28 73 71 6c 74 62 6c 3a 73 define (sqltbl:s
0ef0: 65 74 75 70 2d 66 69 65 6c 64 73 20 73 65 6c 66 etup-fields self
0f00: 29 0a 20 20 28 6c 65 74 20 28 28 66 69 65 6c 64 ). (let ((field
0f10: 73 2d 68 61 73 68 20 28 73 71 6c 74 62 6c 3a 74 s-hash (sqltbl:t
0f20: 62 6c 2d 67 65 74 2d 66 69 65 6c 64 73 2d 68 61 bl-get-fields-ha
0f30: 73 68 20 73 65 6c 66 29 29 0a 20 20 20 20 20 20 sh self)).
0f40: 20 20 28 66 69 65 6c 64 73 2d 6c 69 73 74 20 28 (fields-list (
0f50: 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 66 sqltbl:tbl-get-f
0f60: 69 65 6c 64 73 20 73 65 6c 66 29 29 29 0a 20 20 ields self))).
0f70: 20 20 28 6c 65 74 20 6c 6f 6f 70 20 28 28 68 65 (let loop ((he
0f80: 61 64 20 28 63 61 72 20 66 69 65 6c 64 73 2d 6c ad (car fields-l
0f90: 69 73 74 29 29 0a 20 20 20 20 20 20 20 20 20 20 ist)).
0fa0: 20 20 20 20 20 28 74 61 69 6c 20 28 63 64 72 20 (tail (cdr
0fb0: 66 69 65 6c 64 73 2d 6c 69 73 74 29 29 0a 20 20 fields-list)).
0fc0: 20 20 20 20 20 20 20 20 20 20 20 20 20 28 66 6e (fn
0fd0: 75 6d 20 30 29 29 0a 20 20 20 20 20 20 28 68 61 um 0)). (ha
0fe0: 73 68 2d 74 61 62 6c 65 2d 73 65 74 21 20 66 69 sh-table-set! fi
0ff0: 65 6c 64 73 2d 68 61 73 68 20 68 65 61 64 20 66 elds-hash head f
1000: 6e 75 6d 29 0a 20 20 20 20 20 20 28 69 66 20 28 num). (if (
1010: 6e 75 6c 6c 3f 20 74 61 69 6c 29 20 66 6e 75 6d null? tail) fnum
1020: 0a 20 20 20 20 20 20 20 20 20 20 28 6c 6f 6f 70 . (loop
1030: 20 28 63 61 72 20 74 61 69 6c 29 28 63 64 72 20 (car tail)(cdr
1040: 74 61 69 6c 29 28 2b 20 66 6e 75 6d 20 31 29 29 tail)(+ fnum 1))
1050: 29 29 29 29 0a 0a 3b 3b 20 67 65 74 20 61 20 76 ))))..;; get a v
1060: 61 6c 75 65 20 66 72 6f 6d 20 74 68 65 20 63 75 alue from the cu
1070: 72 72 65 6e 74 20 72 6f 77 0a 28 64 65 66 69 6e rrent row.(defin
1080: 65 20 28 73 71 6c 74 62 6c 3a 67 65 74 2d 66 69 e (sqltbl:get-fi
1090: 65 6c 64 2d 76 61 6c 75 65 2d 63 75 72 72 20 73 eld-value-curr s
10a0: 65 6c 66 20 66 69 65 6c 64 29 0a 20 20 28 6c 65 elf field). (le
10b0: 74 20 28 28 63 75 72 72 2d 72 6f 77 20 20 28 73 t ((curr-row (s
10c0: 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 63 75 qltbl:tbl-get-cu
10d0: 72 72 2d 72 6f 77 20 73 65 6c 66 29 29 0a 20 20 rr-row self)).
10e0: 20 20 20 20 20 20 28 66 69 65 6c 64 2d 6e 75 6d (field-num
10f0: 20 28 68 61 73 68 2d 74 61 62 6c 65 2d 72 65 66 (hash-table-ref
1100: 2f 64 65 66 61 75 6c 74 20 28 73 71 6c 74 62 6c /default (sqltbl
1110: 3a 74 62 6c 2d 67 65 74 2d 66 69 65 6c 64 73 2d :tbl-get-fields-
1120: 68 61 73 68 20 73 65 6c 66 29 20 66 69 65 6c 64 hash self) field
1130: 20 23 66 29 29 29 0a 20 20 20 20 28 69 66 20 66 #f))). (if f
1140: 69 65 6c 64 2d 6e 75 6d 20 0a 20 20 20 20 20 20 ield-num .
1150: 20 20 28 76 65 63 74 6f 72 2d 72 65 66 20 63 75 (vector-ref cu
1160: 72 72 2d 72 6f 77 20 66 69 65 6c 64 2d 6e 75 6d rr-row field-num
1170: 29 0a 20 20 20 20 20 20 20 20 23 66 29 29 29 20 ). #f)))
1180: 3b 3b 20 6e 6f 74 20 66 6f 75 6e 64 20 2d 3e 20 ;; not found ->
1190: 23 66 0a 0a 28 64 65 66 69 6e 65 20 28 73 71 6c #f..(define (sql
11a0: 74 62 6c 3a 76 65 63 74 6f 72 2d 3e 68 61 73 68 tbl:vector->hash
11b0: 20 73 65 6c 66 20 76 65 63 29 0a 20 20 28 6c 65 self vec). (le
11c0: 74 20 28 28 68 20 20 20 20 20 20 28 6d 61 6b 65 t ((h (make
11d0: 2d 68 61 73 68 2d 74 61 62 6c 65 29 29 0a 20 20 -hash-table)).
11e0: 20 20 20 20 20 20 28 66 69 65 6c 64 73 20 28 73 (fields (s
11f0: 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 66 69 qltbl:tbl-get-fi
1200: 65 6c 64 73 20 73 65 6c 66 29 29 29 0a 20 20 20 elds self))).
1210: 20 28 64 6f 20 28 28 69 20 30 20 28 2b 20 69 20 (do ((i 0 (+ i
1220: 31 29 29 29 0a 20 20 20 20 20 20 20 20 28 28 3e 1))). ((>
1230: 3d 20 69 20 28 6c 65 6e 67 74 68 20 66 69 65 6c = i (length fiel
1240: 64 73 29 29 29 0a 20 20 20 20 20 20 28 68 61 73 ds))). (has
1250: 68 2d 74 61 62 6c 65 2d 73 65 74 21 20 68 20 28 h-table-set! h (
1260: 6c 69 73 74 2d 72 65 66 20 66 69 65 6c 64 73 20 list-ref fields
1270: 69 29 28 76 65 63 74 6f 72 2d 72 65 66 20 76 65 i)(vector-ref ve
1280: 63 20 69 29 29 29 0a 20 20 20 20 68 29 29 0a 0a c i))). h))..
1290: 0a 3b 3b 20 72 75 6e 73 20 70 72 6f 63 20 6f 6e .;; runs proc on
12a0: 20 65 61 63 68 20 72 6f 77 20 61 6e 64 20 72 65 each row and re
12b0: 74 75 72 6e 73 20 74 68 65 20 72 65 73 75 6c 74 turns the result
12c0: 69 6e 67 20 6c 69 73 74 0a 28 64 65 66 69 6e 65 ing list.(define
12d0: 20 28 73 71 6c 74 62 6c 3a 6d 61 70 20 73 65 6c (sqltbl:map sel
12e0: 66 20 70 72 6f 63 29 0a 20 20 28 6d 61 70 20 28 f proc). (map (
12f0: 6c 61 6d 62 64 61 20 28 72 6f 77 29 0a 20 20 20 lambda (row).
1300: 20 20 20 20 20 20 28 70 72 6f 63 20 28 73 71 6c (proc (sql
1310: 74 62 6c 3a 76 65 63 74 6f 72 2d 3e 68 61 73 68 tbl:vector->hash
1320: 20 73 65 6c 66 20 72 6f 77 29 29 29 20 28 73 71 self row))) (sq
1330: 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 72 6f 77 ltbl:tbl-get-row
1340: 73 20 73 65 6c 66 29 29 29 0a 20 20 20 0a s self))). .