Artifact
9b13c4cca290ec135d33cc3efcc6a172f49c3df9:
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 65 73 73 69 6f 6e 3a 69 6e 69 74 69 (session:initi
07f0: 61 6c 69 7a 65 20 73 65 6c 66 29 3b 3b 20 69 6e alize self);; in
0800: 69 74 61 72 67 73 29 0a 20 20 28 73 71 6c 74 62 itargs). (sqltb
0810: 6c 3a 74 62 6c 2d 73 65 74 2d 6e 75 6d 2d 72 6f l:tbl-set-num-ro
0820: 77 73 21 20 73 65 6c 66 20 30 29 0a 20 20 28 73 ws! self 0). (s
0830: 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d 63 75 qltbl:tbl-set-cu
0840: 72 72 2d 72 6f 77 2d 70 74 72 21 20 73 65 6c 66 rr-row-ptr! self
0850: 20 30 29 0a 20 20 28 73 71 6c 74 62 6c 3a 74 62 0). (sqltbl:tb
0860: 6c 2d 73 65 74 2d 66 69 65 6c 64 73 21 20 73 65 l-set-fields! se
0870: 6c 66 20 27 28 29 29 0a 20 20 28 73 71 6c 74 62 lf '()). (sqltb
0880: 6c 3a 74 62 6c 2d 73 65 74 2d 66 69 65 6c 64 73 l:tbl-set-fields
0890: 2d 68 61 73 68 21 20 73 65 6c 66 20 28 6d 61 6b -hash! self (mak
08a0: 65 2d 68 61 73 68 2d 74 61 62 6c 65 29 29 29 0a e-hash-table))).
08b0: 20 20 3b 3b 20 28 69 6e 69 74 69 61 6c 69 7a 65 ;; (initialize
08c0: 2d 73 6c 6f 74 73 20 73 65 6c 66 20 69 6e 69 74 -slots self init
08d0: 61 72 67 73 29 29 0a 3b 3b 20 20 28 69 66 20 28 args)).;; (if (
08e0: 3e 20 28 6c 65 6e 67 74 68 20 28 73 71 6c 74 62 > (length (sqltb
08f0: 6c 3a 74 62 6c 2d 67 65 74 2d 72 6f 77 73 20 73 l:tbl-get-rows s
0900: 65 6c 66 29 20 30 29 29 0a 3b 3b 20 20 20 20 20 elf) 0)).;;
0910: 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 (sqltbl:tbl-set
0920: 2d 63 75 72 72 2d 72 6f 77 21 20 73 65 6c 66 20 -curr-row! self
0930: 28 63 61 72 20 72 6f 77 73 29 29 29 29 0a 0a 28 (car rows))))..(
0940: 64 65 66 69 6e 65 20 28 73 71 6c 74 62 6c 3a 6e define (sqltbl:n
0950: 65 78 74 2d 72 6f 77 20 73 65 6c 66 29 0a 20 20 ext-row self).
0960: 28 6c 65 74 20 28 28 63 75 72 72 2d 72 6f 77 2d (let ((curr-row-
0970: 70 74 72 20 28 2b 20 28 73 71 6c 74 62 6c 3a 74 ptr (+ (sqltbl:t
0980: 62 6c 2d 67 65 74 2d 63 75 72 72 2d 72 6f 77 2d bl-get-curr-row-
0990: 70 74 72 20 73 65 6c 66 29 20 31 29 29 0a 20 20 ptr self) 1)).
09a0: 20 20 20 20 20 20 28 6e 75 6d 2d 72 6f 77 73 20 (num-rows
09b0: 20 20 20 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d (sqltbl:tbl-
09c0: 67 65 74 2d 6e 75 6d 2d 72 6f 77 73 20 73 65 6c get-num-rows sel
09d0: 66 29 29 0a 20 20 20 20 20 20 20 20 28 72 6f 77 f)). (row
09e0: 73 20 20 20 20 20 20 20 20 20 28 73 71 6c 74 62 s (sqltb
09f0: 6c 3a 74 62 6c 2d 67 65 74 2d 72 6f 77 73 20 73 l:tbl-get-rows s
0a00: 65 6c 66 29 29 29 0a 20 20 20 20 28 69 66 20 28 elf))). (if (
0a10: 3e 20 63 75 72 72 2d 72 6f 77 2d 70 72 74 20 28 > curr-row-prt (
0a20: 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 6e sqltbl:tbl-get-n
0a30: 75 6d 2d 72 6f 77 73 20 73 65 6c 66 29 29 20 23 um-rows self)) #
0a40: 66 20 3b 3b 20 74 68 65 72 65 20 69 73 20 6e 6f f ;; there is no
0a50: 20 6e 65 78 74 20 72 6f 77 0a 20 20 20 20 20 20 next row.
0a60: 20 20 28 6c 65 74 20 28 28 6e 65 77 2d 63 75 72 (let ((new-cur
0a70: 72 2d 72 6f 77 20 28 6c 69 73 74 2d 72 65 66 20 r-row (list-ref
0a80: 72 6f 77 73 20 63 75 72 72 2d 72 6f 77 2d 70 74 rows curr-row-pt
0a90: 72 29 29 29 0a 20 20 20 20 20 20 20 20 20 20 28 r))). (
0aa0: 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d 63 sqltbl:tbl-set-c
0ab0: 75 72 72 2d 72 6f 77 21 20 73 65 6c 66 20 6e 65 urr-row! self ne
0ac0: 77 2d 63 75 72 72 2d 72 6f 77 29 0a 20 20 20 20 w-curr-row).
0ad0: 20 20 20 20 20 20 28 73 71 6c 74 62 6c 3a 74 62 (sqltbl:tb
0ae0: 6c 2d 73 65 74 2d 63 75 72 72 2d 72 6f 77 2d 70 l-set-curr-row-p
0af0: 72 74 21 20 73 65 6c 66 20 63 75 72 72 2d 72 6f rt! self curr-ro
0b00: 77 2d 70 72 74 29 0a 20 20 20 20 20 20 20 20 20 w-prt).
0b10: 20 6e 65 77 2d 63 75 72 72 2d 72 6f 77 29 29 29 new-curr-row)))
0b20: 29 0a 0a 3b 3b 20 72 75 6e 20 74 68 65 20 71 75 )..;; run the qu
0b30: 65 72 79 20 61 6e 64 20 66 69 6c 6c 20 74 68 65 ery and fill the
0b40: 20 72 6f 77 73 20 6c 69 73 74 20 0a 28 64 65 66 rows list .(def
0b50: 69 6e 65 20 28 73 71 6c 74 62 6c 3a 72 75 6e 2d ine (sqltbl:run-
0b60: 71 75 65 72 79 20 73 65 6c 66 20 2e 20 70 61 72 query self . par
0b70: 61 6d 73 29 0a 20 20 28 6c 65 74 2a 20 28 28 71 ams). (let* ((q
0b80: 75 65 72 79 20 20 28 73 71 6c 74 62 6c 3a 74 62 uery (sqltbl:tb
0b90: 6c 2d 67 65 74 2d 71 75 65 72 79 20 73 65 6c 66 l-get-query self
0ba0: 29 29 0a 20 20 20 20 20 20 20 20 20 28 66 69 65 )). (fie
0bb0: 6c 64 73 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d lds (sqltbl:tbl-
0bc0: 67 65 74 2d 66 69 65 6c 64 73 20 73 65 6c 66 29 get-fields self)
0bd0: 29 0a 20 20 20 20 20 20 20 20 20 28 72 6f 77 73 ). (rows
0be0: 20 28 6c 65 74 20 28 28 72 65 73 75 6c 74 20 27 (let ((result '
0bf0: 28 29 29 0a 20 20 20 20 20 20 20 20 20 20 20 20 ()).
0c00: 20 20 20 20 20 20 20 20 20 28 61 63 74 75 61 6c (actual
0c10: 2d 71 75 65 72 79 20 28 61 70 70 6c 79 20 73 3a -query (apply s:
0c20: 73 71 6c 70 61 72 61 6d 20 71 75 65 72 79 20 66 sqlparam query f
0c30: 69 65 6c 64 73 20 70 61 72 61 6d 73 29 29 29 0a ields params))).
0c40: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
0c50: 20 3b 3b 20 28 73 3a 6c 6f 67 20 22 61 63 74 75 ;; (s:log "actu
0c60: 61 6c 2d 71 75 65 72 79 3d 22 20 61 63 74 75 61 al-query=" actua
0c70: 6c 2d 71 75 65 72 79 29 0a 20 20 20 20 20 20 20 l-query).
0c80: 20 20 20 20 20 20 20 20 20 20 28 64 62 69 3a 66 (dbi:f
0c90: 6f 72 2d 65 61 63 68 2d 72 6f 77 20 28 6c 61 6d or-each-row (lam
0ca0: 62 64 61 20 28 74 75 70 6c 65 29 0a 20 20 20 20 bda (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 20 28 73 65 74 21 20 72 65 73 75 6c 74 20 28 (set! result (
0ce0: 63 6f 6e 73 20 74 75 70 6c 65 20 72 65 73 75 6c cons tuple resul
0cf0: 74 29 29 29 0a 20 20 20 20 20 20 20 20 20 20 20 t))).
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 20 28 73 71 6c 74 62 6c (sqltbl
0d20: 3a 74 62 6c 2d 67 65 74 2d 63 6f 6e 6e 20 73 65 :tbl-get-conn se
0d30: 6c 66 29 0a 09 09 09 09 61 63 74 75 61 6c 2d 71 lf).....actual-q
0d40: 75 65 72 79 29 0a 20 20 20 20 20 20 20 20 20 20 uery).
0d50: 20 20 20 20 20 20 20 28 73 71 6c 74 62 6c 3a 74 (sqltbl:t
0d60: 62 6c 2d 73 65 74 2d 71 75 65 72 79 2d 70 61 72 bl-set-query-par
0d70: 61 6d 73 21 20 73 65 6c 66 20 70 61 72 61 6d 73 ams! self params
0d80: 29 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 ).
0d90: 20 20 20 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 73 (sqltbl:tbl-s
0da0: 65 74 2d 6e 75 6d 2d 72 6f 77 73 21 20 73 65 6c et-num-rows! sel
0db0: 66 20 28 6c 65 6e 67 74 68 20 72 65 73 75 6c 74 f (length result
0dc0: 29 29 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 )).
0dd0: 20 20 20 20 28 73 71 6c 74 62 6c 3a 73 65 74 75 (sqltbl:setu
0de0: 70 2d 66 69 65 6c 64 73 20 73 65 6c 66 29 20 20 p-fields self)
0df0: 3b 3b 20 75 70 64 61 74 65 20 74 68 65 20 66 69 ;; update the fi
0e00: 65 6c 64 73 20 6c 6f 6f 6b 75 70 20 68 61 73 68 elds lookup hash
0e10: 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 .
0e20: 20 20 28 72 65 76 65 72 73 65 20 72 65 73 75 6c (reverse resul
0e30: 74 29 29 29 29 0a 20 20 20 20 28 73 71 6c 74 62 t)))). (sqltb
0e40: 6c 3a 74 62 6c 2d 73 65 74 2d 72 6f 77 73 21 20 l:tbl-set-rows!
0e50: 73 65 6c 66 20 72 6f 77 73 29 0a 20 20 20 20 28 self rows). (
0e60: 69 66 20 28 6e 6f 74 20 28 6e 75 6c 6c 3f 20 72 if (not (null? r
0e70: 6f 77 73 29 29 0a 20 20 20 20 20 20 20 20 28 73 ows)). (s
0e80: 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d 63 75 qltbl:tbl-set-cu
0e90: 72 72 2d 72 6f 77 21 20 73 65 6c 66 20 28 63 61 rr-row! self (ca
0ea0: 72 20 72 6f 77 73 29 29 29 0a 20 20 20 20 28 73 r rows))). (s
0eb0: 71 6c 74 62 6c 3a 74 62 6c 2d 73 65 74 2d 63 75 qltbl:tbl-set-cu
0ec0: 72 72 2d 72 6f 77 2d 70 74 72 21 20 73 65 6c 66 rr-row-ptr! self
0ed0: 20 30 29 0a 20 20 20 20 72 6f 77 73 29 29 0a 0a 0). rows))..
0ee0: 28 64 65 66 69 6e 65 20 28 73 71 6c 74 62 6c 3a (define (sqltbl:
0ef0: 73 65 74 75 70 2d 66 69 65 6c 64 73 20 73 65 6c setup-fields sel
0f00: 66 29 0a 20 20 28 6c 65 74 20 28 28 66 69 65 6c f). (let ((fiel
0f10: 64 73 2d 68 61 73 68 20 28 73 71 6c 74 62 6c 3a ds-hash (sqltbl:
0f20: 74 62 6c 2d 67 65 74 2d 66 69 65 6c 64 73 2d 68 tbl-get-fields-h
0f30: 61 73 68 20 73 65 6c 66 29 29 0a 20 20 20 20 20 ash self)).
0f40: 20 20 20 28 66 69 65 6c 64 73 2d 6c 69 73 74 20 (fields-list
0f50: 28 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d (sqltbl:tbl-get-
0f60: 66 69 65 6c 64 73 20 73 65 6c 66 29 29 29 0a 20 fields self))).
0f70: 20 20 20 28 6c 65 74 20 6c 6f 6f 70 20 28 28 68 (let loop ((h
0f80: 65 61 64 20 28 63 61 72 20 66 69 65 6c 64 73 2d ead (car fields-
0f90: 6c 69 73 74 29 29 0a 20 20 20 20 20 20 20 20 20 list)).
0fa0: 20 20 20 20 20 20 28 74 61 69 6c 20 28 63 64 72 (tail (cdr
0fb0: 20 66 69 65 6c 64 73 2d 6c 69 73 74 29 29 0a 20 fields-list)).
0fc0: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 28 66 (f
0fd0: 6e 75 6d 20 30 29 29 0a 20 20 20 20 20 20 28 68 num 0)). (h
0fe0: 61 73 68 2d 74 61 62 6c 65 2d 73 65 74 21 20 66 ash-table-set! f
0ff0: 69 65 6c 64 73 2d 68 61 73 68 20 68 65 61 64 20 ields-hash head
1000: 66 6e 75 6d 29 0a 20 20 20 20 20 20 28 69 66 20 fnum). (if
1010: 28 6e 75 6c 6c 3f 20 74 61 69 6c 29 20 66 6e 75 (null? tail) fnu
1020: 6d 0a 20 20 20 20 20 20 20 20 20 20 28 6c 6f 6f m. (loo
1030: 70 20 28 63 61 72 20 74 61 69 6c 29 28 63 64 72 p (car tail)(cdr
1040: 20 74 61 69 6c 29 28 2b 20 66 6e 75 6d 20 31 29 tail)(+ fnum 1)
1050: 29 29 29 29 29 0a 0a 3b 3b 20 67 65 74 20 61 20 )))))..;; get a
1060: 76 61 6c 75 65 20 66 72 6f 6d 20 74 68 65 20 63 value from the c
1070: 75 72 72 65 6e 74 20 72 6f 77 0a 28 64 65 66 69 urrent row.(defi
1080: 6e 65 20 28 73 71 6c 74 62 6c 3a 67 65 74 2d 66 ne (sqltbl:get-f
1090: 69 65 6c 64 2d 76 61 6c 75 65 2d 63 75 72 72 20 ield-value-curr
10a0: 73 65 6c 66 20 66 69 65 6c 64 29 0a 20 20 28 6c self field). (l
10b0: 65 74 20 28 28 63 75 72 72 2d 72 6f 77 20 20 28 et ((curr-row (
10c0: 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 63 sqltbl:tbl-get-c
10d0: 75 72 72 2d 72 6f 77 20 73 65 6c 66 29 29 0a 20 urr-row self)).
10e0: 20 20 20 20 20 20 20 28 66 69 65 6c 64 2d 6e 75 (field-nu
10f0: 6d 20 28 68 61 73 68 2d 74 61 62 6c 65 2d 72 65 m (hash-table-re
1100: 66 2f 64 65 66 61 75 6c 74 20 28 73 71 6c 74 62 f/default (sqltb
1110: 6c 3a 74 62 6c 2d 67 65 74 2d 66 69 65 6c 64 73 l:tbl-get-fields
1120: 2d 68 61 73 68 20 73 65 6c 66 29 20 66 69 65 6c -hash self) fiel
1130: 64 20 23 66 29 29 29 0a 20 20 20 20 28 69 66 20 d #f))). (if
1140: 66 69 65 6c 64 2d 6e 75 6d 20 0a 20 20 20 20 20 field-num .
1150: 20 20 20 28 76 65 63 74 6f 72 2d 72 65 66 20 63 (vector-ref c
1160: 75 72 72 2d 72 6f 77 20 66 69 65 6c 64 2d 6e 75 urr-row field-nu
1170: 6d 29 0a 20 20 20 20 20 20 20 20 23 66 29 29 29 m). #f)))
1180: 20 3b 3b 20 6e 6f 74 20 66 6f 75 6e 64 20 2d 3e ;; not found ->
1190: 20 23 66 0a 0a 28 64 65 66 69 6e 65 20 28 73 71 #f..(define (sq
11a0: 6c 74 62 6c 3a 76 65 63 74 6f 72 2d 3e 68 61 73 ltbl:vector->has
11b0: 68 20 73 65 6c 66 20 76 65 63 29 0a 20 20 28 6c h self vec). (l
11c0: 65 74 20 28 28 68 20 20 20 20 20 20 28 6d 61 6b et ((h (mak
11d0: 65 2d 68 61 73 68 2d 74 61 62 6c 65 29 29 0a 20 e-hash-table)).
11e0: 20 20 20 20 20 20 20 28 66 69 65 6c 64 73 20 28 (fields (
11f0: 73 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 66 sqltbl:tbl-get-f
1200: 69 65 6c 64 73 20 73 65 6c 66 29 29 29 0a 20 20 ields self))).
1210: 20 20 28 64 6f 20 28 28 69 20 30 20 28 2b 20 69 (do ((i 0 (+ i
1220: 20 31 29 29 29 0a 20 20 20 20 20 20 20 20 28 28 1))). ((
1230: 3e 3d 20 69 20 28 6c 65 6e 67 74 68 20 66 69 65 >= i (length fie
1240: 6c 64 73 29 29 29 0a 20 20 20 20 20 20 28 68 61 lds))). (ha
1250: 73 68 2d 74 61 62 6c 65 2d 73 65 74 21 20 68 20 sh-table-set! h
1260: 28 6c 69 73 74 2d 72 65 66 20 66 69 65 6c 64 73 (list-ref fields
1270: 20 69 29 28 76 65 63 74 6f 72 2d 72 65 66 20 76 i)(vector-ref v
1280: 65 63 20 69 29 29 29 0a 20 20 20 20 68 29 29 0a ec i))). h)).
1290: 0a 0a 3b 3b 20 72 75 6e 73 20 70 72 6f 63 20 6f ..;; runs proc o
12a0: 6e 20 65 61 63 68 20 72 6f 77 20 61 6e 64 20 72 n each row and r
12b0: 65 74 75 72 6e 73 20 74 68 65 20 72 65 73 75 6c eturns the resul
12c0: 74 69 6e 67 20 6c 69 73 74 0a 28 64 65 66 69 6e ting list.(defin
12d0: 65 20 28 73 71 6c 74 62 6c 3a 6d 61 70 20 73 65 e (sqltbl:map se
12e0: 6c 66 20 70 72 6f 63 29 0a 20 20 28 6d 61 70 20 lf proc). (map
12f0: 28 6c 61 6d 62 64 61 20 28 72 6f 77 29 0a 20 20 (lambda (row).
1300: 20 20 20 20 20 20 20 28 70 72 6f 63 20 28 73 71 (proc (sq
1310: 6c 74 62 6c 3a 76 65 63 74 6f 72 2d 3e 68 61 73 ltbl:vector->has
1320: 68 20 73 65 6c 66 20 72 6f 77 29 29 29 20 28 73 h self row))) (s
1330: 71 6c 74 62 6c 3a 74 62 6c 2d 67 65 74 2d 72 6f qltbl:tbl-get-ro
1340: 77 73 20 73 65 6c 66 29 29 29 0a 20 20 20 0a ws self))). .