Artifact
80d836633e1675c51f0717687cff805097b12152:
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 6d 6f 64 75 6c 65 20 73 71 6c 74 ))..(module sqlt
0250: 62 6c 0a 20 20 20 20 2a 0a 0a 28 69 6d 70 6f 72 bl. *..(impor
0260: 74 20 63 68 69 63 6b 65 6e 20 73 63 68 65 6d 65 t chicken scheme
0270: 20 64 61 74 61 2d 73 74 72 75 63 74 75 72 65 73 data-structures
0280: 20 65 78 74 72 61 73 20 73 72 66 69 2d 31 33 20 extras srfi-13
0290: 70 6f 72 74 73 20 29 0a 0a 3b 3b 20 28 64 65 63 ports )..;; (dec
02a0: 6c 61 72 65 20 28 75 6e 69 74 20 73 71 6c 74 62 lare (unit sqltb
02b0: 6c 29 29 0a 0a 28 64 65 66 69 6e 65 20 28 6d 61 l))..(define (ma
02c0: 6b 65 2d 73 71 6c 74 62 6c 3a 74 62 6c 29 28 6d ke-sqltbl:tbl)(m
02d0: 61 6b 65 2d 76 65 63 74 6f 72 20 39 29 29 0a 28 ake-vector 9)).(
02e0: 64 65 66 69 6e 65 20 28 73 71 6c 74 62 6c 3a 74 define (sqltbl:t
02f0: 62 6c 2d 67 65 74 2d 72 6f 77 73 20 20 20 20 20 bl-get-rows
0300: 20 20 20 20 20 20 76 65 63 29 20 20 20 20 28 76 vec) (v
0310: 65 63 74 6f 72 2d 72 65 66 20 20 76 65 63 20 30 ector-ref vec 0
0320: 29 29 0a 28 64 65 66 69 6e 65 20 28 73 71 6c 74 )).(define (sqlt
0330: 62 6c 3a 74 62 6c 2d 67 65 74 2d 66 69 65 6c 64 bl:tbl-get-field
0340: 73 20 20 20 20 20 20 20 20 20 76 65 63 29 20 20 s vec)
0350: 20 20 28 76 65 63 74 6f 72 2d 72 65 66 20 20 76 (vector-ref v
0360: 65 63 20 31 29 29 0a 28 64 65 66 69 6e 65 20 28 ec 1)).(define (
0370: 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 66 sqltbl:tbl-get-f
0380: 69 65 6c 64 73 2d 68 61 73 68 20 20 20 20 76 65 ields-hash ve
0390: 63 29 20 20 20 20 28 76 65 63 74 6f 72 2d 72 65 c) (vector-re
03a0: 66 20 20 76 65 63 20 32 29 29 0a 28 64 65 66 69 f vec 2)).(defi
03b0: 6e 65 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 ne (sqltbl:tbl-g
03c0: 65 74 2d 71 75 65 72 79 20 20 20 20 20 20 20 20 et-query
03d0: 20 20 76 65 63 29 20 20 20 20 28 76 65 63 74 6f vec) (vecto
03e0: 72 2d 72 65 66 20 20 76 65 63 20 33 29 29 0a 28 r-ref vec 3)).(
03f0: 64 65 66 69 6e 65 20 28 73 71 6c 74 62 6c 3a 74 define (sqltbl:t
0400: 62 6c 2d 67 65 74 2d 71 75 65 72 79 2d 70 61 72 bl-get-query-par
0410: 61 6d 73 20 20 20 76 65 63 29 20 20 20 20 28 76 ams vec) (v
0420: 65 63 74 6f 72 2d 72 65 66 20 20 76 65 63 20 34 ector-ref vec 4
0430: 29 29 0a 28 64 65 66 69 6e 65 20 28 73 71 6c 74 )).(define (sqlt
0440: 62 6c 3a 74 62 6c 2d 67 65 74 2d 63 6f 6e 6e 20 bl:tbl-get-conn
0450: 20 20 20 20 20 20 20 20 20 20 76 65 63 29 20 20 vec)
0460: 20 20 28 76 65 63 74 6f 72 2d 72 65 66 20 20 76 (vector-ref v
0470: 65 63 20 35 29 29 0a 28 64 65 66 69 6e 65 20 28 ec 5)).(define (
0480: 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 6e sqltbl:tbl-get-n
0490: 75 6d 2d 72 6f 77 73 20 20 20 20 20 20 20 76 65 um-rows ve
04a0: 63 29 20 20 20 20 28 76 65 63 74 6f 72 2d 72 65 c) (vector-re
04b0: 66 20 20 76 65 63 20 36 29 29 0a 28 64 65 66 69 f vec 6)).(defi
04c0: 6e 65 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 ne (sqltbl:tbl-g
04d0: 65 74 2d 63 75 72 72 2d 72 6f 77 2d 70 74 72 20 et-curr-row-ptr
04e0: 20 20 76 65 63 29 20 20 20 20 28 76 65 63 74 6f vec) (vecto
04f0: 72 2d 72 65 66 20 20 76 65 63 20 37 29 29 0a 28 r-ref vec 7)).(
0500: 64 65 66 69 6e 65 20 28 73 71 6c 74 62 6c 3a 74 define (sqltbl:t
0510: 62 6c 2d 67 65 74 2d 63 75 72 72 2d 72 6f 77 20 bl-get-curr-row
0520: 20 20 20 20 20 20 76 65 63 29 20 20 20 20 28 76 vec) (v
0530: 65 63 74 6f 72 2d 72 65 66 20 20 76 65 63 20 38 ector-ref vec 8
0540: 29 29 0a 28 64 65 66 69 6e 65 20 28 73 71 6c 74 )).(define (sqlt
0550: 62 6c 3a 74 62 6c 2d 73 65 74 2d 72 6f 77 73 21 bl:tbl-set-rows!
0560: 20 20 20 20 20 20 20 20 20 20 76 65 63 20 76 61 vec va
0570: 6c 29 28 76 65 63 74 6f 72 2d 73 65 74 21 20 76 l)(vector-set! v
0580: 65 63 20 30 20 76 61 6c 29 29 0a 28 64 65 66 69 ec 0 val)).(defi
0590: 6e 65 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 ne (sqltbl:tbl-s
05a0: 65 74 2d 66 69 65 6c 64 73 21 20 20 20 20 20 20 et-fields!
05b0: 20 20 76 65 63 20 76 61 6c 29 28 76 65 63 74 6f vec val)(vecto
05c0: 72 2d 73 65 74 21 20 76 65 63 20 31 20 76 61 6c r-set! vec 1 val
05d0: 29 29 0a 28 64 65 66 69 6e 65 20 28 73 71 6c 74 )).(define (sqlt
05e0: 62 6c 3a 74 62 6c 2d 73 65 74 2d 66 69 65 6c 64 bl:tbl-set-field
05f0: 73 2d 68 61 73 68 21 20 20 20 76 65 63 20 76 61 s-hash! vec va
0600: 6c 29 28 76 65 63 74 6f 72 2d 73 65 74 21 20 76 l)(vector-set! v
0610: 65 63 20 32 20 76 61 6c 29 29 0a 28 64 65 66 69 ec 2 val)).(defi
0620: 6e 65 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 ne (sqltbl:tbl-s
0630: 65 74 2d 71 75 65 72 79 21 20 20 20 20 20 20 20 et-query!
0640: 20 20 76 65 63 20 76 61 6c 29 28 76 65 63 74 6f vec val)(vecto
0650: 72 2d 73 65 74 21 20 76 65 63 20 33 20 76 61 6c r-set! vec 3 val
0660: 29 29 0a 28 64 65 66 69 6e 65 20 28 73 71 6c 74 )).(define (sqlt
0670: 62 6c 3a 74 62 6c 2d 73 65 74 2d 71 75 65 72 79 bl:tbl-set-query
0680: 2d 70 61 72 61 6d 73 21 20 20 76 65 63 20 76 61 -params! vec va
0690: 6c 29 28 76 65 63 74 6f 72 2d 73 65 74 21 20 76 l)(vector-set! v
06a0: 65 63 20 34 20 76 61 6c 29 29 0a 28 64 65 66 69 ec 4 val)).(defi
06b0: 6e 65 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 ne (sqltbl:tbl-s
06c0: 65 74 2d 63 6f 6e 6e 21 20 20 20 20 20 20 20 20 et-conn!
06d0: 20 20 76 65 63 20 76 61 6c 29 28 76 65 63 74 6f vec val)(vecto
06e0: 72 2d 73 65 74 21 20 76 65 63 20 35 20 76 61 6c r-set! vec 5 val
06f0: 29 29 0a 28 64 65 66 69 6e 65 20 28 73 71 6c 74 )).(define (sqlt
0700: 62 6c 3a 74 62 6c 2d 73 65 74 2d 6e 75 6d 2d 72 bl:tbl-set-num-r
0710: 6f 77 73 21 20 20 20 20 20 20 76 65 63 20 76 61 ows! vec va
0720: 6c 29 28 76 65 63 74 6f 72 2d 73 65 74 21 20 76 l)(vector-set! v
0730: 65 63 20 36 20 76 61 6c 29 29 0a 28 64 65 66 69 ec 6 val)).(defi
0740: 6e 65 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 ne (sqltbl:tbl-s
0750: 65 74 2d 63 75 72 72 2d 72 6f 77 2d 70 74 72 21 et-curr-row-ptr!
0760: 20 20 76 65 63 20 76 61 6c 29 28 76 65 63 74 6f vec val)(vecto
0770: 72 2d 73 65 74 21 20 76 65 63 20 37 20 76 61 6c r-set! vec 7 val
0780: 29 29 0a 28 64 65 66 69 6e 65 20 28 73 71 6c 74 )).(define (sqlt
0790: 62 6c 3a 74 62 6c 2d 73 65 74 2d 63 75 72 72 2d bl:tbl-set-curr-
07a0: 72 6f 77 21 20 20 20 20 20 20 76 65 63 20 76 61 row! vec va
07b0: 6c 29 28 76 65 63 74 6f 72 2d 73 65 74 21 20 76 l)(vector-set! v
07c0: 65 63 20 38 20 76 61 6c 29 29 0a 0a 28 64 65 66 ec 8 val))..(def
07d0: 69 6e 65 20 20 28 73 71 6c 74 62 6c 3a 69 6e 69 ine (sqltbl:ini
07e0: 74 69 61 6c 69 7a 65 20 73 65 6c 66 29 3b 3b 20 tialize self);;
07f0: 69 6e 69 74 61 72 67 73 29 0a 20 20 28 73 71 6c initargs). (sql
0800: 74 62 6c 3a 74 62 6c 2d 73 65 74 2d 6e 75 6d 2d tbl:tbl-set-num-
0810: 72 6f 77 73 21 20 73 65 6c 66 20 30 29 0a 20 20 rows! self 0).
0820: 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d (sqltbl:tbl-set-
0830: 63 75 72 72 2d 72 6f 77 2d 70 74 72 21 20 73 65 curr-row-ptr! se
0840: 6c 66 20 30 29 0a 20 20 28 73 71 6c 74 62 6c 3a lf 0). (sqltbl:
0850: 74 62 6c 2d 73 65 74 2d 66 69 65 6c 64 73 21 20 tbl-set-fields!
0860: 73 65 6c 66 20 27 28 29 29 0a 20 20 28 73 71 6c self '()). (sql
0870: 74 62 6c 3a 74 62 6c 2d 73 65 74 2d 66 69 65 6c tbl:tbl-set-fiel
0880: 64 73 2d 68 61 73 68 21 20 73 65 6c 66 20 28 6d ds-hash! self (m
0890: 61 6b 65 2d 68 61 73 68 2d 74 61 62 6c 65 29 29 ake-hash-table))
08a0: 29 0a 20 20 3b 3b 20 28 69 6e 69 74 69 61 6c 69 ). ;; (initiali
08b0: 7a 65 2d 73 6c 6f 74 73 20 73 65 6c 66 20 69 6e ze-slots self in
08c0: 69 74 61 72 67 73 29 29 0a 3b 3b 20 20 28 69 66 itargs)).;; (if
08d0: 20 28 3e 20 28 6c 65 6e 67 74 68 20 28 73 71 6c (> (length (sql
08e0: 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 72 6f 77 73 tbl:tbl-get-rows
08f0: 20 73 65 6c 66 29 20 30 29 29 0a 3b 3b 20 20 20 self) 0)).;;
0900: 20 20 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 (sqltbl:tbl-s
0910: 65 74 2d 63 75 72 72 2d 72 6f 77 21 20 73 65 6c et-curr-row! sel
0920: 66 20 28 63 61 72 20 72 6f 77 73 29 29 29 29 0a f (car rows)))).
0930: 0a 28 64 65 66 69 6e 65 20 28 73 71 6c 74 62 6c .(define (sqltbl
0940: 3a 6e 65 78 74 2d 72 6f 77 20 73 65 6c 66 29 0a :next-row self).
0950: 20 20 28 6c 65 74 20 28 28 63 75 72 72 2d 72 6f (let ((curr-ro
0960: 77 2d 70 74 72 20 28 2b 20 28 73 71 6c 74 62 6c w-ptr (+ (sqltbl
0970: 3a 74 62 6c 2d 67 65 74 2d 63 75 72 72 2d 72 6f :tbl-get-curr-ro
0980: 77 2d 70 74 72 20 73 65 6c 66 29 20 31 29 29 0a w-ptr self) 1)).
0990: 20 20 20 20 20 20 20 20 28 6e 75 6d 2d 72 6f 77 (num-row
09a0: 73 20 20 20 20 20 28 73 71 6c 74 62 6c 3a 74 62 s (sqltbl:tb
09b0: 6c 2d 67 65 74 2d 6e 75 6d 2d 72 6f 77 73 20 73 l-get-num-rows s
09c0: 65 6c 66 29 29 0a 20 20 20 20 20 20 20 20 28 72 elf)). (r
09d0: 6f 77 73 20 20 20 20 20 20 20 20 20 28 73 71 6c ows (sql
09e0: 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 72 6f 77 73 tbl:tbl-get-rows
09f0: 20 73 65 6c 66 29 29 29 0a 20 20 20 20 28 69 66 self))). (if
0a00: 20 28 3e 20 63 75 72 72 2d 72 6f 77 2d 70 72 74 (> curr-row-prt
0a10: 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 (sqltbl:tbl-get
0a20: 2d 6e 75 6d 2d 72 6f 77 73 20 73 65 6c 66 29 29 -num-rows self))
0a30: 20 23 66 20 3b 3b 20 74 68 65 72 65 20 69 73 20 #f ;; there is
0a40: 6e 6f 20 6e 65 78 74 20 72 6f 77 0a 20 20 20 20 no next row.
0a50: 20 20 20 20 28 6c 65 74 20 28 28 6e 65 77 2d 63 (let ((new-c
0a60: 75 72 72 2d 72 6f 77 20 28 6c 69 73 74 2d 72 65 urr-row (list-re
0a70: 66 20 72 6f 77 73 20 63 75 72 72 2d 72 6f 77 2d f rows curr-row-
0a80: 70 74 72 29 29 29 0a 20 20 20 20 20 20 20 20 20 ptr))).
0a90: 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 (sqltbl:tbl-set
0aa0: 2d 63 75 72 72 2d 72 6f 77 21 20 73 65 6c 66 20 -curr-row! self
0ab0: 6e 65 77 2d 63 75 72 72 2d 72 6f 77 29 0a 20 20 new-curr-row).
0ac0: 20 20 20 20 20 20 20 20 28 73 71 6c 74 62 6c 3a (sqltbl:
0ad0: 74 62 6c 2d 73 65 74 2d 63 75 72 72 2d 72 6f 77 tbl-set-curr-row
0ae0: 2d 70 72 74 21 20 73 65 6c 66 20 63 75 72 72 2d -prt! self curr-
0af0: 72 6f 77 2d 70 72 74 29 0a 20 20 20 20 20 20 20 row-prt).
0b00: 20 20 20 6e 65 77 2d 63 75 72 72 2d 72 6f 77 29 new-curr-row)
0b10: 29 29 29 0a 0a 3b 3b 20 72 75 6e 20 74 68 65 20 )))..;; run the
0b20: 71 75 65 72 79 20 61 6e 64 20 66 69 6c 6c 20 74 query and fill t
0b30: 68 65 20 72 6f 77 73 20 6c 69 73 74 20 0a 28 64 he rows list .(d
0b40: 65 66 69 6e 65 20 28 73 71 6c 74 62 6c 3a 72 75 efine (sqltbl:ru
0b50: 6e 2d 71 75 65 72 79 20 73 65 6c 66 20 2e 20 70 n-query self . p
0b60: 61 72 61 6d 73 29 0a 20 20 28 6c 65 74 2a 20 28 arams). (let* (
0b70: 28 71 75 65 72 79 20 20 28 73 71 6c 74 62 6c 3a (query (sqltbl:
0b80: 74 62 6c 2d 67 65 74 2d 71 75 65 72 79 20 73 65 tbl-get-query se
0b90: 6c 66 29 29 0a 20 20 20 20 20 20 20 20 20 28 66 lf)). (f
0ba0: 69 65 6c 64 73 20 28 73 71 6c 74 62 6c 3a 74 62 ields (sqltbl:tb
0bb0: 6c 2d 67 65 74 2d 66 69 65 6c 64 73 20 73 65 6c l-get-fields sel
0bc0: 66 29 29 0a 20 20 20 20 20 20 20 20 20 28 72 6f f)). (ro
0bd0: 77 73 20 28 6c 65 74 20 28 28 72 65 73 75 6c 74 ws (let ((result
0be0: 20 27 28 29 29 0a 20 20 20 20 20 20 20 20 20 20 '()).
0bf0: 20 20 20 20 20 20 20 20 20 20 20 28 61 63 74 75 (actu
0c00: 61 6c 2d 71 75 65 72 79 20 28 61 70 70 6c 79 20 al-query (apply
0c10: 73 3a 73 71 6c 70 61 72 61 6d 20 71 75 65 72 79 s:sqlparam query
0c20: 20 66 69 65 6c 64 73 20 70 61 72 61 6d 73 29 29 fields params))
0c30: 29 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 ).
0c40: 20 20 20 3b 3b 20 28 73 3a 6c 6f 67 20 22 61 63 ;; (s:log "ac
0c50: 74 75 61 6c 2d 71 75 65 72 79 3d 22 20 61 63 74 tual-query=" act
0c60: 75 61 6c 2d 71 75 65 72 79 29 0a 20 20 20 20 20 ual-query).
0c70: 20 20 20 20 20 20 20 20 20 20 20 20 28 64 62 69 (dbi
0c80: 3a 66 6f 72 2d 65 61 63 68 2d 72 6f 77 20 28 6c :for-each-row (l
0c90: 61 6d 62 64 61 20 28 74 75 70 6c 65 29 0a 20 20 ambda (tuple).
0ca0: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
0cb0: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
0cc0: 20 20 20 20 28 73 65 74 21 20 72 65 73 75 6c 74 (set! result
0cd0: 20 28 63 6f 6e 73 20 74 75 70 6c 65 20 72 65 73 (cons tuple res
0ce0: 75 6c 74 29 29 29 0a 20 20 20 20 20 20 20 20 20 ult))).
0cf0: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
0d00: 20 20 20 20 20 20 20 20 20 20 20 28 73 71 6c 74 (sqlt
0d10: 62 6c 3a 74 62 6c 2d 67 65 74 2d 63 6f 6e 6e 20 bl:tbl-get-conn
0d20: 73 65 6c 66 29 0a 09 09 09 09 61 63 74 75 61 6c self).....actual
0d30: 2d 71 75 65 72 79 29 0a 20 20 20 20 20 20 20 20 -query).
0d40: 20 20 20 20 20 20 20 20 20 28 73 71 6c 74 62 6c (sqltbl
0d50: 3a 74 62 6c 2d 73 65 74 2d 71 75 65 72 79 2d 70 :tbl-set-query-p
0d60: 61 72 61 6d 73 21 20 73 65 6c 66 20 70 61 72 61 arams! self para
0d70: 6d 73 29 0a 20 20 20 20 20 20 20 20 20 20 20 20 ms).
0d80: 20 20 20 20 20 28 73 71 6c 74 62 6c 3a 74 62 6c (sqltbl:tbl
0d90: 2d 73 65 74 2d 6e 75 6d 2d 72 6f 77 73 21 20 73 -set-num-rows! s
0da0: 65 6c 66 20 28 6c 65 6e 67 74 68 20 72 65 73 75 elf (length resu
0db0: 6c 74 29 29 0a 20 20 20 20 20 20 20 20 20 20 20 lt)).
0dc0: 20 20 20 20 20 20 28 73 71 6c 74 62 6c 3a 73 65 (sqltbl:se
0dd0: 74 75 70 2d 66 69 65 6c 64 73 20 73 65 6c 66 29 tup-fields self)
0de0: 20 20 3b 3b 20 75 70 64 61 74 65 20 74 68 65 20 ;; update the
0df0: 66 69 65 6c 64 73 20 6c 6f 6f 6b 75 70 20 68 61 fields lookup ha
0e00: 73 68 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 sh.
0e10: 20 20 20 20 28 72 65 76 65 72 73 65 20 72 65 73 (reverse res
0e20: 75 6c 74 29 29 29 29 0a 20 20 20 20 28 73 71 6c ult)))). (sql
0e30: 74 62 6c 3a 74 62 6c 2d 73 65 74 2d 72 6f 77 73 tbl:tbl-set-rows
0e40: 21 20 73 65 6c 66 20 72 6f 77 73 29 0a 20 20 20 ! self rows).
0e50: 20 28 69 66 20 28 6e 6f 74 20 28 6e 75 6c 6c 3f (if (not (null?
0e60: 20 72 6f 77 73 29 29 0a 20 20 20 20 20 20 20 20 rows)).
0e70: 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d (sqltbl:tbl-set-
0e80: 63 75 72 72 2d 72 6f 77 21 20 73 65 6c 66 20 28 curr-row! self (
0e90: 63 61 72 20 72 6f 77 73 29 29 29 0a 20 20 20 20 car rows))).
0ea0: 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d (sqltbl:tbl-set-
0eb0: 63 75 72 72 2d 72 6f 77 2d 70 74 72 21 20 73 65 curr-row-ptr! se
0ec0: 6c 66 20 30 29 0a 20 20 20 20 72 6f 77 73 29 29 lf 0). rows))
0ed0: 0a 0a 28 64 65 66 69 6e 65 20 28 73 71 6c 74 62 ..(define (sqltb
0ee0: 6c 3a 73 65 74 75 70 2d 66 69 65 6c 64 73 20 73 l:setup-fields s
0ef0: 65 6c 66 29 0a 20 20 28 6c 65 74 20 28 28 66 69 elf). (let ((fi
0f00: 65 6c 64 73 2d 68 61 73 68 20 28 73 71 6c 74 62 elds-hash (sqltb
0f10: 6c 3a 74 62 6c 2d 67 65 74 2d 66 69 65 6c 64 73 l:tbl-get-fields
0f20: 2d 68 61 73 68 20 73 65 6c 66 29 29 0a 20 20 20 -hash self)).
0f30: 20 20 20 20 20 28 66 69 65 6c 64 73 2d 6c 69 73 (fields-lis
0f40: 74 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 t (sqltbl:tbl-ge
0f50: 74 2d 66 69 65 6c 64 73 20 73 65 6c 66 29 29 29 t-fields self)))
0f60: 0a 20 20 20 20 28 6c 65 74 20 6c 6f 6f 70 20 28 . (let loop (
0f70: 28 68 65 61 64 20 28 63 61 72 20 66 69 65 6c 64 (head (car field
0f80: 73 2d 6c 69 73 74 29 29 0a 20 20 20 20 20 20 20 s-list)).
0f90: 20 20 20 20 20 20 20 20 28 74 61 69 6c 20 28 63 (tail (c
0fa0: 64 72 20 66 69 65 6c 64 73 2d 6c 69 73 74 29 29 dr fields-list))
0fb0: 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 .
0fc0: 28 66 6e 75 6d 20 30 29 29 0a 20 20 20 20 20 20 (fnum 0)).
0fd0: 28 68 61 73 68 2d 74 61 62 6c 65 2d 73 65 74 21 (hash-table-set!
0fe0: 20 66 69 65 6c 64 73 2d 68 61 73 68 20 68 65 61 fields-hash hea
0ff0: 64 20 66 6e 75 6d 29 0a 20 20 20 20 20 20 28 69 d fnum). (i
1000: 66 20 28 6e 75 6c 6c 3f 20 74 61 69 6c 29 20 66 f (null? tail) f
1010: 6e 75 6d 0a 20 20 20 20 20 20 20 20 20 20 28 6c num. (l
1020: 6f 6f 70 20 28 63 61 72 20 74 61 69 6c 29 28 63 oop (car tail)(c
1030: 64 72 20 74 61 69 6c 29 28 2b 20 66 6e 75 6d 20 dr tail)(+ fnum
1040: 31 29 29 29 29 29 29 0a 0a 3b 3b 20 67 65 74 20 1))))))..;; get
1050: 61 20 76 61 6c 75 65 20 66 72 6f 6d 20 74 68 65 a value from the
1060: 20 63 75 72 72 65 6e 74 20 72 6f 77 0a 28 64 65 current row.(de
1070: 66 69 6e 65 20 28 73 71 6c 74 62 6c 3a 67 65 74 fine (sqltbl:get
1080: 2d 66 69 65 6c 64 2d 76 61 6c 75 65 2d 63 75 72 -field-value-cur
1090: 72 20 73 65 6c 66 20 66 69 65 6c 64 29 0a 20 20 r self field).
10a0: 28 6c 65 74 20 28 28 63 75 72 72 2d 72 6f 77 20 (let ((curr-row
10b0: 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 (sqltbl:tbl-get
10c0: 2d 63 75 72 72 2d 72 6f 77 20 73 65 6c 66 29 29 -curr-row self))
10d0: 0a 20 20 20 20 20 20 20 20 28 66 69 65 6c 64 2d . (field-
10e0: 6e 75 6d 20 28 68 61 73 68 2d 74 61 62 6c 65 2d num (hash-table-
10f0: 72 65 66 2f 64 65 66 61 75 6c 74 20 28 73 71 6c ref/default (sql
1100: 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 66 69 65 6c tbl:tbl-get-fiel
1110: 64 73 2d 68 61 73 68 20 73 65 6c 66 29 20 66 69 ds-hash self) fi
1120: 65 6c 64 20 23 66 29 29 29 0a 20 20 20 20 28 69 eld #f))). (i
1130: 66 20 66 69 65 6c 64 2d 6e 75 6d 20 0a 20 20 20 f field-num .
1140: 20 20 20 20 20 28 76 65 63 74 6f 72 2d 72 65 66 (vector-ref
1150: 20 63 75 72 72 2d 72 6f 77 20 66 69 65 6c 64 2d curr-row field-
1160: 6e 75 6d 29 0a 20 20 20 20 20 20 20 20 23 66 29 num). #f)
1170: 29 29 20 3b 3b 20 6e 6f 74 20 66 6f 75 6e 64 20 )) ;; not found
1180: 2d 3e 20 23 66 0a 0a 28 64 65 66 69 6e 65 20 28 -> #f..(define (
1190: 73 71 6c 74 62 6c 3a 76 65 63 74 6f 72 2d 3e 68 sqltbl:vector->h
11a0: 61 73 68 20 73 65 6c 66 20 76 65 63 29 0a 20 20 ash self vec).
11b0: 28 6c 65 74 20 28 28 68 20 20 20 20 20 20 28 6d (let ((h (m
11c0: 61 6b 65 2d 68 61 73 68 2d 74 61 62 6c 65 29 29 ake-hash-table))
11d0: 0a 20 20 20 20 20 20 20 20 28 66 69 65 6c 64 73 . (fields
11e0: 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 (sqltbl:tbl-get
11f0: 2d 66 69 65 6c 64 73 20 73 65 6c 66 29 29 29 0a -fields self))).
1200: 20 20 20 20 28 64 6f 20 28 28 69 20 30 20 28 2b (do ((i 0 (+
1210: 20 69 20 31 29 29 29 0a 20 20 20 20 20 20 20 20 i 1))).
1220: 28 28 3e 3d 20 69 20 28 6c 65 6e 67 74 68 20 66 ((>= i (length f
1230: 69 65 6c 64 73 29 29 29 0a 20 20 20 20 20 20 28 ields))). (
1240: 68 61 73 68 2d 74 61 62 6c 65 2d 73 65 74 21 20 hash-table-set!
1250: 68 20 28 6c 69 73 74 2d 72 65 66 20 66 69 65 6c h (list-ref fiel
1260: 64 73 20 69 29 28 76 65 63 74 6f 72 2d 72 65 66 ds i)(vector-ref
1270: 20 76 65 63 20 69 29 29 29 0a 20 20 20 20 68 29 vec i))). h)
1280: 29 0a 0a 0a 3b 3b 20 72 75 6e 73 20 70 72 6f 63 )...;; runs proc
1290: 20 6f 6e 20 65 61 63 68 20 72 6f 77 20 61 6e 64 on each row and
12a0: 20 72 65 74 75 72 6e 73 20 74 68 65 20 72 65 73 returns the res
12b0: 75 6c 74 69 6e 67 20 6c 69 73 74 0a 28 64 65 66 ulting list.(def
12c0: 69 6e 65 20 28 73 71 6c 74 62 6c 3a 6d 61 70 20 ine (sqltbl:map
12d0: 73 65 6c 66 20 70 72 6f 63 29 0a 20 20 28 6d 61 self proc). (ma
12e0: 70 20 28 6c 61 6d 62 64 61 20 28 72 6f 77 29 0a p (lambda (row).
12f0: 20 20 20 20 20 20 20 20 20 28 70 72 6f 63 20 28 (proc (
1300: 73 71 6c 74 62 6c 3a 76 65 63 74 6f 72 2d 3e 68 sqltbl:vector->h
1310: 61 73 68 20 73 65 6c 66 20 72 6f 77 29 29 29 20 ash self row)))
1320: 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d (sqltbl:tbl-get-
1330: 72 6f 77 73 20 73 65 6c 66 29 29 29 0a 20 20 20 rows self))).
1340: 0a 29 0a .).