WriteSqlInSchemeLikeSyntax - Cookbook - s c h e m a t i c s : c o o k b o o k

Write SQL In Scheme Like Syntax

Problem

Writing SQL queries, by writing strings using "string-append" can be a pain. a sexp would make life easier.

Solution

(require (planet "sql.scm" ("soegaard" "sqlite.plt")))

Discussion

sql.scm was intended for sqlite, so you need to use some workarounds sometimes.

When you need to reference a fieldname with a space in it, try:

(SELECT ALL (|"field one"| field2) FROM table)

by using the pipe, you can force many things. For example, Postgresql allows

SELECT DISTINCT ON (groupname) field1, groupname, field3 FROM table1

you can do this in sql.scm with:

(SELECT DISTINCT (|ON (groupname) field1| groupname field3) FROM table1)

Contributors

-- HiSeeComments - 01 Jul 2008

CookbookForm
TopicType:	Recipe
ParentTopic:	DatabaseRecipes
TopicOrder:	999

Current Rev: r1.2 - 01 Jul 2008 - 05:32 GMT - AntonVanStraaten, Revision History:Diffs | r1.2 | > | r1.1

Copyright © 2004 by the contributing authors. All material on the Schematics Cookbook web site is the property of the contributing authors.
The copyright for certain compilations of material taken from this website is held by the SchematicsEditorsGroup - see ContributorAgreement & LGPL.
Other than such compilations, this material can be redistributed and/or modified under the terms of the GNU Lesser General Public License (LGPL), version 2.1, as published by the Free Software Foundation.
Ideas, requests, problems regarding Schematics Cookbook? Send feedback. / You are Main.guest

PLT Scheme	SISC
Scheme48	SCM
MIT Scheme	scsh
JScheme	Kawa
Chicken	Guile
Bigloo	Tiny
Gambit	LispMe
Gauche	Chez

s c h e m a t i c s : c o o k b o o k