chicken-eggs:ssql.git
6 years agoadd some tests for the `null?' operator 0.2.0
Moritz Heidkamp [Thu, 1 Sep 2011 13:08:09 +0000 (15:08 +0200)]
add some tests for the `null?' operator

6 years agoadd GROUP BY support
Moritz Heidkamp [Fri, 26 Aug 2011 12:15:56 +0000 (14:15 +0200)]
add GROUP BY support

6 years agoadd the `coalesce' function
Moritz Heidkamp [Tue, 23 Aug 2011 17:04:22 +0000 (19:04 +0200)]
add the `coalesce' function

6 years agoturn `values' into a normal prefix operator and require tuples to be given as vectors...
Moritz Heidkamp [Tue, 23 Aug 2011 15:11:44 +0000 (17:11 +0200)]
turn `values' into a normal prefix operator and require tuples to be given as vectors to reduce special-casing

6 years agore-use the function operator for `call' instead of re-implementing it
Moritz Heidkamp [Tue, 23 Aug 2011 15:00:45 +0000 (17:00 +0200)]
re-use the function operator for `call' instead of re-implementing it

6 years agoimprove sub-query parenthesization and add more tests
Moritz Heidkamp [Tue, 23 Aug 2011 15:00:24 +0000 (17:00 +0200)]
improve sub-query parenthesization and add more tests

6 years agoadd `call' syntax to allow calling of arbitrary functions
Moritz Heidkamp [Mon, 22 Aug 2011 18:17:57 +0000 (20:17 +0200)]
add `call' syntax to allow calling of arbitrary functions

6 years agoadd support for DELETE statements
Moritz Heidkamp [Mon, 22 Aug 2011 17:18:05 +0000 (19:18 +0200)]
add support for DELETE statements

6 years agoamend clauses-order
Moritz Heidkamp [Thu, 18 Aug 2011 16:38:31 +0000 (18:38 +0200)]
amend clauses-order

6 years agoadd group to composition tests
Moritz Heidkamp [Thu, 18 Aug 2011 15:10:33 +0000 (17:10 +0200)]
add group to composition tests

6 years agochange `(update widgets ...)' to `(update (table widgets) ...)' so as to not have...
Moritz Heidkamp [Thu, 18 Aug 2011 15:08:04 +0000 (17:08 +0200)]
change `(update widgets ...)' to `(update (table widgets) ...)' so as to not have a single symbol floating around there in order to make update statements composable

6 years agochange insert syntax
Moritz Heidkamp [Thu, 18 Aug 2011 14:14:03 +0000 (16:14 +0200)]
change insert syntax

6 years agoit's not like I created that API myself
Moritz Heidkamp [Wed, 17 Aug 2011 18:39:35 +0000 (20:39 +0200)]
it's not like I created that API myself

6 years agoallow inserts without explicit column list
Moritz Heidkamp [Wed, 17 Aug 2011 18:31:01 +0000 (20:31 +0200)]
allow inserts without explicit column list

6 years agobasic insert support
Moritz Heidkamp [Wed, 17 Aug 2011 18:16:34 +0000 (20:16 +0200)]
basic insert support

6 years agono syntax striptease there
Moritz Heidkamp [Wed, 17 Aug 2011 18:04:11 +0000 (20:04 +0200)]
no syntax striptease there

6 years agosimple update support
Moritz Heidkamp [Wed, 17 Aug 2011 17:21:07 +0000 (19:21 +0200)]
simple update support

6 years agodowncase tests
Moritz Heidkamp [Wed, 17 Aug 2011 16:22:50 +0000 (18:22 +0200)]
downcase tests

6 years agoadd test for set literals
Moritz Heidkamp [Wed, 17 Aug 2011 16:22:25 +0000 (18:22 +0200)]
add test for set literals

6 years agouse test-group
Moritz Heidkamp [Wed, 17 Aug 2011 16:21:01 +0000 (18:21 +0200)]
use test-group

6 years agoinject where inject is due
Moritz Heidkamp [Wed, 17 Aug 2011 16:20:54 +0000 (18:20 +0200)]
inject where inject is due

6 years agoallow column aliasing in (col ...)
Moritz Heidkamp [Thu, 31 Mar 2011 20:06:54 +0000 (22:06 +0200)]
allow column aliasing in (col ...)

6 years agoadd `in' operator
Moritz Heidkamp [Thu, 31 Mar 2011 19:07:58 +0000 (21:07 +0200)]
add `in' operator

6 years agoadd support for tuple literals as vectors
Moritz Heidkamp [Thu, 31 Mar 2011 19:04:22 +0000 (21:04 +0200)]
add support for tuple literals as vectors

6 years agossql: add `infix*' operator type which allows defining infix operators without surrou...
Moritz Heidkamp [Thu, 31 Mar 2011 19:03:22 +0000 (21:03 +0200)]
ssql: add `infix*' operator type which allows defining infix operators without surrounding parens (required for column aliases with `AS')

6 years agoremove postgresql from meta file
Moritz Heidkamp [Wed, 30 Mar 2011 17:07:43 +0000 (19:07 +0200)]
remove postgresql from meta file

6 years agofix release-info tarball location
Moritz Heidkamp [Sat, 26 Mar 2011 18:48:11 +0000 (19:48 +0100)]
fix release-info tarball location

6 years agoadd release-info file 0.1
Moritz Heidkamp [Sat, 26 Mar 2011 18:15:16 +0000 (19:15 +0100)]
add release-info file

6 years agomake `merge-clause' a proper method
Moritz Heidkamp [Sun, 6 Mar 2011 21:21:38 +0000 (22:21 +0100)]
make `merge-clause' a proper method

6 years agomove `insert-clause' into ssql translator engine so it can be specialized
Moritz Heidkamp [Sun, 6 Mar 2011 21:03:02 +0000 (22:03 +0100)]
move `insert-clause' into ssql translator engine so it can be specialized

6 years agovery basic ssql composition support through the `ssql-compose' procedure
Moritz Heidkamp [Sun, 6 Mar 2011 13:41:43 +0000 (14:41 +0100)]
very basic ssql composition support through the `ssql-compose' procedure

6 years agossql: move ssql-pgsql into a separate egg to remove the postgresql dependency and...
syn [Sun, 27 Feb 2011 21:13:35 +0000 (21:13 +0000)]
ssql: move ssql-pgsql into a separate egg to remove the postgresql dependency and rename it to ssql-postgresql in the course to match with awful-postgresql and autoform-postgresql

git-svn-id: https://code.call-cc.org/svn/chicken-eggs/release/4/ssql/trunk@22911 fca3e652-9b03-0410-8d7b-ac86a6ce46c4

6 years agossql: add check to `define-operator' to fail at macro expansion time rather than...
syn [Sun, 27 Feb 2011 20:43:35 +0000 (20:43 +0000)]
ssql: add check to `define-operator' to fail at macro expansion time rather than at runtime when invalid operator types are given

git-svn-id: https://code.call-cc.org/svn/chicken-eggs/release/4/ssql/trunk@22910 fca3e652-9b03-0410-8d7b-ac86a6ce46c4

6 years agossql: don't wrap prefix and suffix operators in parentheses; fix FROM clause with...
syn [Sun, 27 Feb 2011 20:31:54 +0000 (20:31 +0000)]
ssql: don't wrap prefix and suffix operators in parentheses; fix FROM clause with multiple tables to separate table names with commas; add `order' operator.

git-svn-id: https://code.call-cc.org/svn/chicken-eggs/release/4/ssql/trunk@22909 fca3e652-9b03-0410-8d7b-ac86a6ce46c4

6 years agossql: add ssql-pgsql (whoops)
syn [Fri, 25 Feb 2011 22:20:22 +0000 (22:20 +0000)]
ssql: add ssql-pgsql (whoops)

git-svn-id: https://code.call-cc.org/svn/chicken-eggs/release/4/ssql/trunk@22896 fca3e652-9b03-0410-8d7b-ac86a6ce46c4

6 years agossql: port to chicken 4 and remove prometheud dependency
syn [Fri, 25 Feb 2011 22:14:40 +0000 (22:14 +0000)]
ssql: port to chicken 4 and remove prometheud dependency

git-svn-id: https://code.call-cc.org/svn/chicken-eggs/release/4/ssql/trunk@22895 fca3e652-9b03-0410-8d7b-ac86a6ce46c4