[Chicken-users] Re: Thoughts on an O/RM library?

[Hans Bulfone]

hi,

On Sat, Feb 04, 2006 at 12:17:37AM -0600, Reed Sheridan wrote:

> I really just don't want to manually
> conc strings together, and have to remember to escape SQL strings, which I
> will forget and then some 1337 Hax0r will drop my tables...

then you might find my sql library useful:

http://www.nil.at/software/sql.sexp

it is a small (and incomplete) library for constructing sql queries:

#;2> (define (some-scheme-function x) (+ x 99))
#;3> (sql:select
 '(f.data quux.name)
 '((as foobar f) quux)
 `(and (= f.quux quux.bla)
       (>= quux.xyz (some_database_function ,(some-scheme-function 1) 
"te'st"))))
"SELECT f.data,quux.name FROM foobar AS f,quux WHERE ((f.quux=quux.bla) AND 
(quux.xyz>=some_database_function(100,'te''st')))"
#;4> 

some special syntax and other things are probably missing, but it has
already been useful in some programs.

regards,
hans.