4 years agojoin support
Matt S Trout [Fri, 12 Apr 2019 20:45:58 +0000]
join support

4 years agoadd group_by and having in ExtraClauses
Matt S Trout [Thu, 11 Apr 2019 17:49:31 +0000]
add group_by and having in ExtraClauses

4 years agoexpand function arguments
Matt S Trout [Thu, 11 Apr 2019 01:30:51 +0000]
expand function arguments

4 years agomake non-ascii operators work
Matt S Trout [Thu, 11 Apr 2019 01:17:40 +0000]
make non-ascii operators work

4 years agowantarray cleanup and hashref query expressions
Matt S Trout [Wed, 10 Apr 2019 03:40:06 +0000]
wantarray cleanup and hashref query expressions

4 years agoclean up naming and provide aliases
Matt S Trout [Wed, 10 Apr 2019 02:15:18 +0000]
clean up naming and provide aliases

4 years agoinclude MRO::Compat for 5.8 perls
Matt S Trout [Wed, 10 Apr 2019 01:55:40 +0000]
include MRO::Compat for 5.8 perls

4 years agoclean up fields handling
Matt S Trout [Wed, 10 Apr 2019 01:50:31 +0000]
clean up fields handling

4 years agoexpand , args while not doubling listification
Matt S Trout [Wed, 10 Apr 2019 01:32:48 +0000]
expand , args while not doubling listification

4 years agoPass all expression stability tests. Verified by:
Matt S Trout [Wed, 10 Apr 2019 01:12:50 +0000]
Pass all expression stability tests. Verified by:

SQL_ABSTRACT_TEST_AGAINST=SQL::Abstract::Clauses \
  SQL_ABSTRACT_TEST_EXPAND_STABILITY=1 \
  PERL5OPT=-MDevel::Dwarn \
  prove -j8 -lr t

4 years agoclean up fields/values expansion for insert
Matt S Trout [Tue, 9 Apr 2019 17:14:53 +0000]
clean up fields/values expansion for insert

4 years agoconvert delete to extended clauses system
Matt S Trout [Tue, 9 Apr 2019 00:36:25 +0000]
convert delete to extended clauses system

4 years agoexpand update expansion
Matt S Trout [Tue, 9 Apr 2019 00:18:28 +0000]
expand update expansion

4 years agoswitch select over to "real" clauses
Matt S Trout [Tue, 9 Apr 2019 00:08:57 +0000]
switch select over to "real" clauses

4 years agogive insert fields a real name
Matt S Trout [Mon, 8 Apr 2019 00:55:11 +0000]
give insert fields a real name

4 years agoclean up expansion
Matt S Trout [Sun, 7 Apr 2019 23:45:01 +0000]
clean up expansion

4 years agoswitch insert to clauses system
Matt S Trout [Sat, 6 Apr 2019 03:28:33 +0000]
switch insert to clauses system

4 years agodelete as clauses
Matt S Trout [Sat, 6 Apr 2019 02:25:09 +0000]
delete as clauses

4 years agoadd update to clauses
Matt S Trout [Sat, 6 Apr 2019 02:07:58 +0000]
add update to clauses

4 years agoconvert direct to literal for * and single-id select
Matt S Trout [Fri, 5 Apr 2019 22:10:57 +0000]
convert direct to literal for * and single-id select

4 years agoclean up select-hackery code
Matt S Trout [Fri, 5 Apr 2019 18:48:37 +0000]
clean up select-hackery code

4 years agoadd select method to ::Clauses and fix bugs
Matt S Trout [Fri, 5 Apr 2019 18:33:42 +0000]
add select method to ::Clauses and fix bugs

4 years agomake sketch vaguely work
Matt S Trout [Fri, 5 Apr 2019 00:00:15 +0000]
make sketch vaguely work

4 years agoinitial sketch of Clauses.pm
Matt S Trout [Thu, 4 Apr 2019 23:45:08 +0000]
initial sketch of Clauses.pm

4 years agoadd expand stability test
Matt S Trout [Wed, 10 Apr 2019 00:47:22 +0000]
add expand stability test

4 years agodon't re-expand maybe list expr when already list
Matt S Trout [Wed, 10 Apr 2019 00:35:44 +0000]
don't re-expand maybe list expr when already list

4 years agoclean up insert code more
Matt S Trout [Sat, 6 Apr 2019 02:58:06 +0000]
clean up insert code more

4 years agocentralise field and value aqts for insert
Matt S Trout [Sat, 6 Apr 2019 02:55:34 +0000]
centralise field and value aqts for insert

4 years agoclean up delete code
Matt S Trout [Sat, 6 Apr 2019 02:47:04 +0000]
clean up delete code

4 years agopass -op expansion to expand_op handler, fix in
Matt S Trout [Fri, 5 Apr 2019 21:45:16 +0000]
pass -op expansion to expand_op handler, fix in

4 years agoallow controlling SQL::Abstract class for test suite running
Matt S Trout [Fri, 5 Apr 2019 00:31:46 +0000]
allow controlling SQL::Abstract class for test suite running

4 years agoremove refkind stuff from insert
Matt S Trout [Wed, 3 Apr 2019 01:03:21 +0000]
remove refkind stuff from insert

4 years agoclarify test
Matt S Trout [Wed, 3 Apr 2019 00:08:05 +0000]
clarify test

4 years agotransplant DBIC test
Matt S Trout [Wed, 3 Apr 2019 00:00:39 +0000]
transplant DBIC test

4 years agocleanup multop rendering
Matt S Trout [Tue, 2 Apr 2019 19:53:54 +0000]
cleanup multop rendering

4 years agofix a (bizarre) compatibility issue
Matt S Trout [Tue, 2 Apr 2019 19:16:53 +0000]
fix a (bizarre) compatibility issue

4 years agono op normalization required - already happened outside
Matt S Trout [Tue, 2 Apr 2019 00:00:27 +0000]
no op normalization required - already happened outside

4 years agoswitch to explicit node type returns for non-op nodes
Matt S Trout [Mon, 1 Apr 2019 23:57:51 +0000]
switch to explicit node type returns for non-op nodes

4 years agofinish removing leading /^-/
Matt S Trout [Mon, 1 Apr 2019 05:32:39 +0000]
finish removing leading /^-/

4 years agoremove leading - from expand and render
Matt S Trout [Mon, 1 Apr 2019 05:02:14 +0000]
remove leading - from expand and render

4 years agoremove - from expand keys
Matt S Trout [Mon, 1 Apr 2019 05:00:40 +0000]
remove - from expand keys

4 years agoremove _expr_ from method names
Matt S Trout [Mon, 1 Apr 2019 04:51:08 +0000]
remove _expr_ from method names

4 years agoextract expand_bind to a method
Matt S Trout [Mon, 1 Apr 2019 04:19:02 +0000]
extract expand_bind to a method

4 years agoclean up row and op expansion to methods
Matt S Trout [Mon, 1 Apr 2019 04:16:09 +0000]
clean up row and op expansion to methods

4 years agostop treating old special ops normally
Matt S Trout [Mon, 1 Apr 2019 04:07:47 +0000]
stop treating old special ops normally

4 years agofix last warning
Matt S Trout [Mon, 1 Apr 2019 03:55:52 +0000]
fix last warning

4 years agokill ident/value specialness
Matt S Trout [Mon, 1 Apr 2019 03:16:14 +0000]
kill ident/value specialness

4 years agopush comparison invocation into ident and value expanders
Matt S Trout [Mon, 1 Apr 2019 03:13:52 +0000]
push comparison invocation into ident and value expanders

4 years agorename -tuple to -row
Matt S Trout [Mon, 1 Apr 2019 02:53:34 +0000]
rename -tuple to -row

4 years agomake -is work at top level
Matt S Trout [Mon, 1 Apr 2019 01:52:15 +0000]
make -is work at top level

4 years agotest more complex in clause
Matt S Trout [Mon, 1 Apr 2019 01:47:00 +0000]
test more complex in clause

4 years agoteach between to work as a unop
Matt S Trout [Mon, 1 Apr 2019 01:30:54 +0000]
teach between to work as a unop

4 years agomake 05in_between handle die() usefully
Matt S Trout [Mon, 1 Apr 2019 01:30:25 +0000]
make 05in_between handle die() usefully

4 years agoexpand between better
Matt S Trout [Mon, 1 Apr 2019 01:01:49 +0000]
expand between better

4 years agomake between work as a binop
Matt S Trout [Mon, 1 Apr 2019 00:35:41 +0000]
make between work as a binop

4 years agorename list node type to tuple
Matt S Trout [Wed, 27 Mar 2019 04:27:49 +0000]
rename list node type to tuple

4 years agomake , special cased to avoid premature generalisation
Matt S Trout [Wed, 27 Mar 2019 04:22:11 +0000]
make , special cased to avoid premature generalisation

4 years agomake list always parenthesised, make , op work for everything else
Matt S Trout [Wed, 27 Mar 2019 04:19:41 +0000]
make list always parenthesised, make , op work for everything else

4 years agoremove $logic from maybe_list_expr
Matt S Trout [Wed, 27 Mar 2019 04:00:08 +0000]
remove $logic from maybe_list_expr

4 years agomake weird undef order_by cases explicit
Matt S Trout [Wed, 27 Mar 2019 03:58:35 +0000]
make weird undef order_by cases explicit

4 years agoforce , as multop, switch order_by
Matt S Trout [Wed, 27 Mar 2019 03:48:23 +0000]
force , as multop, switch order_by

4 years agoswitch value defaulting in _in expansion to standard
Matt S Trout [Wed, 27 Mar 2019 03:27:31 +0000]
switch value defaulting in _in expansion to standard

4 years agobetter in handling
Matt S Trout [Wed, 27 Mar 2019 03:25:15 +0000]
better in handling

4 years agorestore -in dying to have tests clean before breaking it
Matt S Trout [Wed, 27 Mar 2019 02:43:24 +0000]
restore -in dying to have tests clean before breaking it

4 years agonormalize ops to _ style
Matt S Trout [Wed, 27 Mar 2019 02:37:54 +0000]
normalize ops to _ style

4 years agotmp
Matt S Trout [Wed, 27 Mar 2019 01:59:18 +0000]
tmp

4 years agonormalise ops to foo, foo_bar etc.
Matt S Trout [Wed, 27 Mar 2019 01:25:39 +0000]
normalise ops to foo, foo_bar etc.

4 years agocondense op handling
Matt S Trout [Wed, 27 Mar 2019 01:22:40 +0000]
condense op handling

4 years agoonly remove a leading - if word char following to avoid murdering e.g. --
Matt S Trout [Wed, 27 Mar 2019 01:21:55 +0000]
only remove a leading - if word char following to avoid murdering e.g. --

4 years agosimplify Default_Scalar_to code
Matt S Trout [Wed, 27 Mar 2019 01:15:05 +0000]
simplify Default_Scalar_to code

4 years agokill dying on IN for non-DBIC
Matt S Trout [Tue, 26 Mar 2019 05:38:39 +0000]
kill dying on IN for non-DBIC

4 years agofew more comments
Matt S Trout [Tue, 26 Mar 2019 04:41:22 +0000]
few more comments

4 years agoextract scalar handling
Matt S Trout [Tue, 26 Mar 2019 04:40:00 +0000]
extract scalar handling

4 years agomove _render_op above specific op renderers
Matt S Trout [Tue, 26 Mar 2019 04:06:13 +0000]
move _render_op above specific op renderers

4 years agoold SQLA extension system compat marked
Matt S Trout [Tue, 26 Mar 2019 04:03:30 +0000]
old SQLA extension system compat marked

4 years agoextract concept of undef value
Matt S Trout [Tue, 26 Mar 2019 03:53:37 +0000]
extract concept of undef value

4 years agoextract _hashpair_cmp for using default cmp
Matt S Trout [Tue, 26 Mar 2019 03:43:43 +0000]
extract _hashpair_cmp for using default cmp

4 years agouse hashtriple for auto-expand generation
Matt S Trout [Tue, 26 Mar 2019 03:40:53 +0000]
use hashtriple for auto-expand generation

4 years agouse hashtriple for auto-{cmp}
Matt S Trout [Tue, 26 Mar 2019 03:38:23 +0000]
use hashtriple for auto-{cmp}

4 years agofactor the rest of the undef handling out
Matt S Trout [Tue, 26 Mar 2019 03:30:48 +0000]
factor the rest of the undef handling out

4 years agostart to extract op checking for null
Matt S Trout [Tue, 26 Mar 2019 03:27:18 +0000]
start to extract op checking for null

4 years agoeverything else is notreached, so rename unhandled to notreached
Matt S Trout [Tue, 26 Mar 2019 03:11:19 +0000]
everything else is notreached, so rename unhandled to notreached

4 years agoextract hashtriple expander
Matt S Trout [Tue, 26 Mar 2019 03:10:21 +0000]
extract hashtriple expander

4 years agoandor for hashpair RHS
Matt S Trout [Tue, 26 Mar 2019 03:03:42 +0000]
andor for hashpair RHS

4 years agoswitch more is expansion cases
Matt S Trout [Tue, 26 Mar 2019 02:51:50 +0000]
switch more is expansion cases

4 years agonuke is/is not code now handled by render_op
Matt S Trout [Tue, 26 Mar 2019 02:45:09 +0000]
nuke is/is not code now handled by render_op

4 years agoextract IS/IS NOT
Matt S Trout [Tue, 26 Mar 2019 02:40:21 +0000]
extract IS/IS NOT

4 years agoclean up op handling code more
Matt S Trout [Tue, 26 Mar 2019 02:17:56 +0000]
clean up op handling code more

4 years agomove rendering to default render_op
Matt S Trout [Tue, 26 Mar 2019 01:57:59 +0000]
move rendering to default render_op

4 years agoextract andor rendering
Matt S Trout [Tue, 26 Mar 2019 01:56:56 +0000]
extract andor rendering

4 years agoextract _render_op_in
Matt S Trout [Tue, 26 Mar 2019 01:55:22 +0000]
extract _render_op_in

4 years agoextract between rendering into a method
Matt S Trout [Tue, 26 Mar 2019 01:53:57 +0000]
extract between rendering into a method

4 years agoclean up part of the arrayref stuff
Matt S Trout [Tue, 26 Mar 2019 01:49:53 +0000]
clean up part of the arrayref stuff

4 years agolet andor expand the ident hashref case
Matt S Trout [Tue, 26 Mar 2019 00:47:22 +0000]
let andor expand the ident hashref case

4 years agofurther andor consolidation
Matt S Trout [Tue, 26 Mar 2019 00:42:29 +0000]
further andor consolidation

4 years agoadd some hopefully useful comments
Matt S Trout [Tue, 26 Mar 2019 00:40:32 +0000]
add some hopefully useful comments

4 years agomove more expansion into andor
Matt S Trout [Tue, 26 Mar 2019 00:36:28 +0000]
move more expansion into andor

4 years agomake scalar/blessed args cleaner
Matt S Trout [Mon, 25 Mar 2019 03:20:01 +0000]
make scalar/blessed args cleaner

4 years agosurface _expand_ident call
Matt S Trout [Mon, 25 Mar 2019 03:11:58 +0000]
surface _expand_ident call

4 years agolet _expand_expr produce the deprecation warning
Matt S Trout [Mon, 25 Mar 2019 03:10:34 +0000]
let _expand_expr produce the deprecation warning