10 years agoFix trailing whitespace master
Peter Rabbitson [Fri, 17 Jan 2014 01:55:06 +0000]
Fix trailing whitespace

10 years agoUse ExprDeclare in tests instead of expr.include
Dagfinn Ilmari Mannsåker [Thu, 9 Jan 2014 18:32:07 +0000]
Use ExprDeclare in tests instead of expr.include

10 years agoImport needed ExprDeclare functions in t/example.t
Dagfinn Ilmari Mannsåker [Thu, 9 Jan 2014 18:34:05 +0000]
Import needed ExprDeclare functions in t/example.t

10 years agoClean one of the namespaces to pass a DBIC-side tests
Peter Rabbitson [Sat, 7 Dec 2013 11:01:27 +0000]
Clean one of the namespaces to pass a DBIC-side tests

10 years agorename $sql to $code in Perl renderer
Matt S Trout [Sun, 17 Nov 2013 06:06:38 +0000]
rename $sql to $code in Perl renderer

10 years agoSTRAIGHT_JOIN support for MySQL
Matt S Trout [Sun, 17 Nov 2013 05:38:36 +0000]
STRAIGHT_JOIN support for MySQL

10 years agoprovide $_ in scan_dq_nodes
Matt S Trout [Fri, 15 Nov 2013 19:02:51 +0000]
provide $_ in scan_dq_nodes

10 years agodisable precedence warnings for &
Matt S Trout [Fri, 15 Nov 2013 10:05:06 +0000]
disable precedence warnings for &

10 years agonever overload without fallback
Matt S Trout [Fri, 15 Nov 2013 10:04:56 +0000]
never overload without fallback

10 years agomake keyword-like subs optional exports from ExprDeclare
Matt S Trout [Fri, 15 Nov 2013 08:40:12 +0000]
make keyword-like subs optional exports from ExprDeclare

10 years agoadd support for nulls => "none" in order nodes
Matt S Trout [Mon, 4 Nov 2013 03:04:55 +0000]
add support for nulls => "none" in order nodes

10 years agorequire explicit nulls first/last
Matt S Trout [Mon, 4 Nov 2013 01:30:07 +0000]
require explicit nulls first/last

10 years agouse INNER for old mysqls
Matt S Trout [Mon, 4 Nov 2013 00:42:59 +0000]
use INNER for old mysqls

10 years agomake map_descending available as map_dq_tree via ExprHelpers
Matt S Trout [Sun, 3 Nov 2013 23:33:35 +0000]
make map_descending available as map_dq_tree via ExprHelpers

10 years agoadd double subquery handling to MySQL code
Matt S Trout [Fri, 1 Nov 2013 06:59:31 +0000]
add double subquery handling to MySQL code

10 years agorewrite GenericSubquery to handle multiple order columns
Matt S Trout [Fri, 1 Nov 2013 01:45:55 +0000]
rewrite GenericSubquery to handle multiple order columns

10 years agorespect order_is_stable even with no ORDER BY (assume single row return)
Matt S Trout [Sat, 12 Oct 2013 18:53:57 +0000]
respect order_is_stable even with no ORDER BY (assume single row return)

10 years agoswitch where wrapping order to look better (and make DBIC oraclejoin.t happy)
Matt S Trout [Sat, 12 Oct 2013 15:59:02 +0000]
switch where wrapping order to look better (and make DBIC oraclejoin.t happy)

10 years agoonly default in $_ if @_ is empty, not if $_[0] exists but is undef
Matt S Trout [Wed, 9 Oct 2013 18:18:17 +0000]
only default in $_ if @_ is empty, not if $_[0] exists but is undef

10 years agoadd scan_dq_nodes helper
Matt S Trout [Mon, 7 Oct 2013 13:42:55 +0000]
add scan_dq_nodes helper

10 years agodefault the default_inside_alias in case of a full SELECT list of ASed things
Matt S Trout [Mon, 7 Oct 2013 03:03:12 +0000]
default the default_inside_alias in case of a full SELECT list of ASed things

10 years agodon't gensym for unqualified versions of already selected columns
Matt S Trout [Mon, 7 Oct 2013 00:58:36 +0000]
don't gensym for unqualified versions of already selected columns

10 years agoCleanup after Moo
Peter Rabbitson [Mon, 17 Jun 2013 08:30:47 +0000]
Cleanup after Moo

11 years agoRender empty insert value lists as DEFAULT VALUES
Dagfinn Ilmari Mannsåker [Sat, 23 Mar 2013 10:18:46 +0000]
Render empty insert value lists as DEFAULT VALUES

Except for MySQL, which is Special™, as usual.

11 years agoPreserve NULLS ordering in SubqueryRemap
Dagfinn Ilmari Mannsåker [Fri, 22 Mar 2013 23:12:43 +0000]
Preserve NULLS ordering in SubqueryRemap

11 years agoLimitXY Slice dialect
Matt S Trout [Thu, 21 Mar 2013 03:20:49 +0000]
LimitXY Slice dialect

11 years agoadd slice_subquery method for DBIC introspection
Matt S Trout [Thu, 21 Mar 2013 03:01:02 +0000]
add slice_subquery method for DBIC introspection

11 years agoallow optional hashref as final arg to helpers
Matt Phillips [Mon, 18 Mar 2013 13:31:28 +0000]
allow optional hashref as final arg to helpers

11 years agodon't negate undef in Slice/FetchFirst
Matt S Trout [Mon, 18 Mar 2013 00:37:29 +0000]
don't negate undef in Slice/FetchFirst

11 years agoRETURNING ... INTO support
Matt S Trout [Sun, 17 Mar 2013 22:31:06 +0000]
RETURNING ... INTO support

11 years agoPRIOR rendering for CONNECT BY
Matt S Trout [Sun, 17 Mar 2013 21:47:21 +0000]
PRIOR rendering for CONNECT BY

11 years agoAdd support for NULLS FIRST/LAST in ORDER BY
Dagfinn Ilmari Mannsåker [Sat, 26 Jan 2013 19:16:39 +0000]
Add support for NULLS FIRST/LAST in ORDER BY

11 years agonested where nodes
Matt S Trout [Wed, 5 Dec 2012 13:33:04 +0000]
nested where nodes

11 years agofixed incorrect is_Literal usage
Matt Phillips [Tue, 27 Nov 2012 20:45:32 +0000]
fixed incorrect is_Literal usage

11 years agoadd slice stability requirement code
Matt S Trout [Mon, 15 Oct 2012 21:20:02 +0000]
add slice stability requirement code

11 years agoseparate to_sql mechanism
Matt S Trout [Thu, 11 Oct 2012 15:27:46 +0000]
separate to_sql mechanism

11 years agodemonstrate limit dialects
Matt S Trout [Thu, 11 Oct 2012 12:45:05 +0000]
demonstrate limit dialects

11 years agolimit/offset
Matt S Trout [Thu, 11 Oct 2012 12:34:10 +0000]
limit/offset

11 years agoorder by somewhat working
Matt S Trout [Thu, 11 Oct 2012 12:24:16 +0000]
order by somewhat working

11 years agoselect+join+where
Matt S Trout [Thu, 11 Oct 2012 12:07:51 +0000]
select+join+where

11 years agobeginnings of declarative code
Matt S Trout [Thu, 11 Oct 2012 12:01:12 +0000]
beginnings of declarative code

11 years agoSELECT a, b FROM foo
Prog Rammer [Fri, 7 Sep 2012 17:56:23 +0000]
SELECT a, b FROM foo

11 years agocosmetic
Prog Rammer [Mon, 27 Aug 2012 20:16:29 +0000]
cosmetic

11 years agotest for between
Prog Rammer [Mon, 27 Aug 2012 20:14:53 +0000]
test for between

11 years agotest for count(*)
Prog Rammer [Mon, 27 Aug 2012 18:29:25 +0000]
test for count(*)

11 years agoleft outer join
Prog Rammer [Mon, 27 Aug 2012 16:25:52 +0000]
left outer join

11 years agosimple group by test
Prog Rammer [Mon, 27 Aug 2012 16:18:37 +0000]
simple group by test

11 years agoanother way to join
Prog Rammer [Mon, 27 Aug 2012 16:08:47 +0000]
another way to join

from ilmari++ in irc

11 years agofixups for HAVING clauses
Matt S Trout [Sat, 25 Aug 2012 18:47:08 +0000]
fixups for HAVING clauses

11 years agowhitespace
Prog Rammer [Fri, 24 Aug 2012 20:09:18 +0000]
whitespace

11 years agolike sql.t but using ExprHelpers directly
Prog Rammer [Fri, 24 Aug 2012 20:00:38 +0000]
like sql.t but using ExprHelpers directly

Only a few features that I've figured out so far.

11 years agodon't deparenthesise subqueries with a group by
Matt S Trout [Thu, 23 Aug 2012 18:27:39 +0000]
don't deparenthesise subqueries with a group by

11 years agorandomised crazy order by support for subquery remap
Matt S Trout [Thu, 23 Aug 2012 18:27:21 +0000]
randomised crazy order by support for subquery remap

11 years agonuke old attempt at generic subquery
Matt S Trout [Thu, 23 Aug 2012 18:26:58 +0000]
nuke old attempt at generic subquery

11 years agoslightly better error messages
Matt S Trout [Thu, 23 Aug 2012 12:33:37 +0000]
slightly better error messages

11 years agofix desc detection for genericsubq
Matt S Trout [Sat, 18 Aug 2012 12:25:57 +0000]
fix desc detection for genericsubq

11 years agofirst cut at GenericSubquery
Matt S Trout [Fri, 17 Aug 2012 14:32:23 +0000]
first cut at GenericSubquery

11 years agoworking RowNum.pm
Matt S Trout [Fri, 17 Aug 2012 12:40:01 +0000]
working RowNum.pm

11 years agobeginnings of RowNum.pm
Matt S Trout [Thu, 16 Aug 2012 17:53:39 +0000]
beginnings of RowNum.pm

11 years agominor helper tweaks
Matt S Trout [Thu, 16 Aug 2012 17:34:23 +0000]
minor helper tweaks

11 years agoworking RowNumberOver
Matt S Trout [Thu, 16 Aug 2012 16:33:08 +0000]
working RowNumberOver

11 years agoRemove array expansion in Literal()
Matt Phillips [Fri, 17 Aug 2012 16:47:01 +0000]
Remove array expansion in Literal()

Was breaking SQL::Abstract testsuite.

11 years agofunctionalise order mapping
Matt S Trout [Sun, 29 Jul 2012 17:19:00 +0000]
functionalise order mapping

11 years agomore functional select list generation
Matt S Trout [Sun, 29 Jul 2012 15:20:05 +0000]
more functional select list generation

11 years agoslight syntactical cleanup
Matt S Trout [Sat, 28 Jul 2012 19:48:06 +0000]
slight syntactical cleanup

11 years agoadd compose routine and refactor FetchFirst to functional style
Matt S Trout [Sat, 28 Jul 2012 18:56:32 +0000]
add compose routine and refactor FetchFirst to functional style

11 years agoclean up FetchFirst more
Matt S Trout [Sat, 28 Jul 2012 18:06:58 +0000]
clean up FetchFirst more

11 years agoimport cleanups
Matt S Trout [Sat, 28 Jul 2012 17:57:48 +0000]
import cleanups

11 years agoremove debugging code
Matt S Trout [Sat, 28 Jul 2012 17:57:12 +0000]
remove debugging code

11 years agofirst expansion to using helper subs
Matt S Trout [Sat, 28 Jul 2012 17:48:52 +0000]
first expansion to using helper subs

11 years agofixup! first cut of rno sketch
Arthur Axel 'fREW' Schmidt [Sat, 28 Jul 2012 17:37:01 +0000]
fixup! first cut of rno sketch

11 years agofirst cut of rno sketch
Matt S Trout [Sat, 28 Jul 2012 16:52:56 +0000]
first cut of rno sketch

11 years agofix expr.include to generate alias nodes correctly
Matt S Trout [Sat, 28 Jul 2012 11:38:59 +0000]
fix expr.include to generate alias nodes correctly

11 years agofirst whack at GenericSubQ, half works
Matt S Trout [Sun, 27 May 2012 18:54:32 +0000]
first whack at GenericSubQ, half works

11 years agoMOAR order
Matt S Trout [Mon, 7 May 2012 06:16:12 +0000]
MOAR order

11 years agoFIRST ? SKIP ?
Matt S Trout [Sun, 6 May 2012 23:58:32 +0000]
FIRST ? SKIP ?

11 years agoimplement FIRST ? SKIP ?
Matt S Trout [Sun, 6 May 2012 23:25:01 +0000]
implement FIRST ? SKIP ?

12 years agofixup gensym behaviour
Matt S Trout [Fri, 20 Apr 2012 10:52:46 +0000]
fixup gensym behaviour

12 years agoORDER BY never generates ASC
Matt S Trout [Fri, 20 Apr 2012 10:52:37 +0000]
ORDER BY never generates ASC

12 years agoSlice implementations as roles
Matt S Trout [Fri, 20 Apr 2012 10:03:30 +0000]
Slice implementations as roles

12 years agoallow a group by node without a list
Matt S Trout [Fri, 20 Apr 2012 03:52:42 +0000]
allow a group by node without a list

12 years agohandle nested rather than unrolled joins
Matt S Trout [Mon, 16 Apr 2012 14:03:00 +0000]
handle nested rather than unrolled joins

12 years agoallow '' literals though wtf
Matt S Trout [Mon, 16 Apr 2012 13:46:25 +0000]
allow '' literals though wtf

12 years agorename alias node content
Matt S Trout [Mon, 16 Apr 2012 12:34:10 +0000]
rename alias node content

12 years agoslice type
Matt S Trout [Mon, 16 Apr 2012 07:11:08 +0000]
slice type

12 years agoON and LEFT/RIGHT
Matt S Trout [Sat, 14 Apr 2012 19:17:23 +0000]
ON and LEFT/RIGHT

12 years agoinitial group by support
Matt S Trout [Sat, 14 Apr 2012 17:10:39 +0000]
initial group by support

12 years agoalways_quote might be set with no quote chars
Matt S Trout [Sat, 14 Apr 2012 04:35:13 +0000]
always_quote might be set with no quote chars

12 years agolast direct hash access (I think)
Matt S Trout [Sat, 14 Apr 2012 02:54:44 +0000]
last direct hash access (I think)

12 years agoadd more attributes
Matt S Trout [Sat, 14 Apr 2012 02:54:16 +0000]
add more attributes

12 years agoinitial Mooification
Matt S Trout [Sat, 14 Apr 2012 02:48:51 +0000]
initial Mooification

12 years agofix test to pass, come back to it later
Matt S Trout [Sat, 14 Apr 2012 02:48:42 +0000]
fix test to pass, come back to it later

12 years agostart sketching out a Perl renderer
Matt S Trout [Sat, 13 Aug 2011 14:31:54 +0000]
start sketching out a Perl renderer

12 years agoclean up code to use intersperse
Matt S Trout [Sun, 31 Jul 2011 20:39:00 +0000]
clean up code to use intersperse

12 years agoINSERT support
Matt S Trout [Sun, 31 Jul 2011 19:39:06 +0000]
INSERT support

12 years agorefactor DELETE and add UPDATE
Matt S Trout [Sun, 31 Jul 2011 15:03:46 +0000]
refactor DELETE and add UPDATE

12 years agoDELETE support
Matt S Trout [Sun, 31 Jul 2011 10:01:32 +0000]
DELETE support

12 years agoadd constant for DQ_WHERE
Matt S Trout [Sun, 31 Jul 2011 09:11:55 +0000]
add constant for DQ_WHERE

12 years agoparens around BETWEEN
Matt S Trout [Sun, 31 Jul 2011 05:44:52 +0000]
parens around BETWEEN

12 years agogrudginly implement lc_keywords
Matt S Trout [Sun, 31 Jul 2011 05:38:30 +0000]
grudginly implement lc_keywords