4 years agoformat works
Matt S Trout [Sat, 24 Aug 2019 04:13:04 +0000]
format works

4 years agoclean things up and better sqlacexpr
Matt S Trout [Sat, 24 Aug 2019 02:19:31 +0000]
clean things up and better sqlacexpr

4 years agoimproving formatting
Matt S Trout [Sat, 24 Aug 2019 02:16:50 +0000]
improving formatting

4 years agocreate sql part joining control code
Matt S Trout [Tue, 20 Aug 2019 00:45:33 +0000]
create sql part joining control code

4 years agois_op and register_op
Matt S Trout [Mon, 15 Jul 2019 22:06:31 +0000]
is_op and register_op

4 years agoadd CAST() to ExtraClauses
Matt S Trout [Fri, 17 May 2019 02:21:59 +0000]
add CAST() to ExtraClauses

4 years agosmarter sqlacexpr
Matt S Trout [Fri, 17 May 2019 02:21:25 +0000]
smarter sqlacexpr

4 years agoallow plain - to fall through in hashpair expansion
Matt S Trout [Fri, 17 May 2019 02:20:57 +0000]
allow plain - to fall through in hashpair expansion

4 years agoanother update test
John Napiorkowski [Mon, 6 May 2019 18:20:47 +0000]
another update test

4 years agoCTEs with DELETE and having
John Napiorkowski [Fri, 3 May 2019 00:16:45 +0000]
CTEs with DELETE and having

4 years agofix stupid mistake when converting list to qw()
Matt S Trout [Thu, 2 May 2019 20:31:20 +0000]
fix stupid mistake when converting list to qw()

4 years agowith + insert test
Matt S Trout [Thu, 2 May 2019 19:28:46 +0000]
with + insert test

4 years agoit would help if I actually enabled with for non-select statements
Matt S Trout [Thu, 2 May 2019 19:03:05 +0000]
it would help if I actually enabled with for non-select statements

4 years agosurface with_recursive as well
Matt S Trout [Thu, 25 Apr 2019 15:01:18 +0000]
surface with_recursive as well

4 years agoFirst attempt at SQLA2Support
Matt S Trout [Thu, 25 Apr 2019 14:06:36 +0000]
First attempt at SQLA2Support

4 years agoadd with.pm to extras
Matt S Trout [Tue, 23 Apr 2019 00:15:03 +0000]
add with.pm to extras

4 years agolast use of row for non-rowtype
Matt S Trout [Mon, 22 Apr 2019 03:51:57 +0000]
last use of row for non-rowtype

4 years agoeliminate sucky use of row
Matt S Trout [Mon, 22 Apr 2019 03:40:09 +0000]
eliminate sucky use of row

4 years agorebuild convert using extension system
Matt S Trout [Sun, 21 Apr 2019 02:42:50 +0000]
rebuild convert using extension system

4 years agonormalise expansion methods
Matt S Trout [Sun, 21 Apr 2019 02:30:31 +0000]
normalise expansion methods

4 years agomake stability test try and invoke diff
Matt S Trout [Sun, 21 Apr 2019 02:14:51 +0000]
make stability test try and invoke diff

4 years agoexpand alias
Matt S Trout [Sun, 21 Apr 2019 02:00:38 +0000]
expand alias

4 years agorestore expand stability for extraclauses
Matt S Trout [Sat, 20 Apr 2019 02:53:12 +0000]
restore expand stability for extraclauses

4 years agobetter expand stability testing
Matt S Trout [Sat, 20 Apr 2019 02:41:54 +0000]
better expand stability testing

4 years agohandle convert where using expander wrapping
Matt S Trout [Fri, 19 Apr 2019 21:42:30 +0000]
handle convert where using expander wrapping

4 years agomove render statement to parts based
Matt S Trout [Fri, 19 Apr 2019 05:07:55 +0000]
move render statement to parts based

4 years agofinish porting to join_query_parts as arrayref
Matt S Trout [Fri, 19 Apr 2019 05:03:02 +0000]
finish porting to join_query_parts as arrayref

4 years agoextract remaining insert clause expansion handling to methods
Matt S Trout [Fri, 19 Apr 2019 04:14:41 +0000]
extract remaining insert clause expansion handling to methods

4 years agomove render_aqt to arrayref
Matt S Trout [Fri, 19 Apr 2019 03:51:44 +0000]
move render_aqt to arrayref

4 years agoport clause renderers to arrayref convention
Matt S Trout [Fri, 19 Apr 2019 02:09:52 +0000]
port clause renderers to arrayref convention

4 years agofirst step towards arrayref render_aqt return
Matt S Trout [Fri, 19 Apr 2019 02:04:41 +0000]
first step towards arrayref render_aqt return

4 years agomove multop rendering to join_query_parts
Matt S Trout [Fri, 19 Apr 2019 01:56:52 +0000]
move multop rendering to join_query_parts

4 years agofuck wantarray
Matt S Trout [Fri, 19 Apr 2019 01:48:22 +0000]
fuck wantarray

4 years agoclean up join call
Matt S Trout [Fri, 19 Apr 2019 01:43:42 +0000]
clean up join call

4 years agoextract remaining insert clause expansion handling to methods
Matt S Trout [Thu, 18 Apr 2019 18:43:13 +0000]
extract remaining insert clause expansion handling to methods

4 years agoimprove infinite recursion debugging, fix infinite recursion bug
Matt S Trout [Thu, 18 Apr 2019 18:34:52 +0000]
improve infinite recursion debugging, fix infinite recursion bug

4 years agomurder AUTOLOAD by default because I keep getting confused by it while debugging
Matt S Trout [Thu, 18 Apr 2019 13:46:31 +0000]
murder AUTOLOAD by default because I keep getting confused by it while debugging

4 years agothere is a lurking infinite loop in 01generate inserts but this is still better
Matt S Trout [Thu, 18 Apr 2019 03:08:36 +0000]
there is a lurking infinite loop in 01generate inserts but this is still better

4 years agoswitch Abstract.pm renderers to using join_query_parts
Matt S Trout [Thu, 18 Apr 2019 02:32:54 +0000]
switch Abstract.pm renderers to using join_query_parts

4 years agocompact andor
Matt S Trout [Thu, 18 Apr 2019 02:26:29 +0000]
compact andor

4 years agocleanup andor
Matt S Trout [Thu, 18 Apr 2019 02:15:17 +0000]
cleanup andor

4 years agobetween and in cleanup
Matt S Trout [Thu, 18 Apr 2019 02:05:29 +0000]
between and in cleanup

4 years agomake join_query_parts handle scalars
Matt S Trout [Thu, 18 Apr 2019 02:00:53 +0000]
make join_query_parts handle scalars

4 years agofirst keyword move
Matt S Trout [Thu, 18 Apr 2019 02:00:33 +0000]
first keyword move

4 years agomove format_keyword into base sqla
Matt S Trout [Thu, 18 Apr 2019 01:57:42 +0000]
move format_keyword into base sqla

4 years agorow and between
Matt S Trout [Thu, 18 Apr 2019 01:56:10 +0000]
row and between

4 years agomove func rendering over to join_query_parts
Matt S Trout [Thu, 18 Apr 2019 01:45:44 +0000]
move func rendering over to join_query_parts

4 years agotake advantage of join_query_parts to clean up
Matt S Trout [Thu, 18 Apr 2019 01:23:49 +0000]
take advantage of join_query_parts to clean up

4 years agomake the legacy convert feature its own node
Matt S Trout [Thu, 18 Apr 2019 01:14:58 +0000]
make the legacy convert feature its own node

4 years agomore use cleanup, add hashref to join_sql_parts
Matt S Trout [Thu, 18 Apr 2019 01:07:17 +0000]
more use cleanup, add hashref to join_sql_parts

4 years agorename join_clauses to join_query_parts
Matt S Trout [Thu, 18 Apr 2019 00:55:58 +0000]
rename join_clauses to join_query_parts

4 years agoeliminate vestigial length checks
Matt S Trout [Thu, 18 Apr 2019 00:39:14 +0000]
eliminate vestigial length checks

4 years agofixup sigil usage
Matt S Trout [Wed, 17 Apr 2019 02:13:45 +0000]
fixup sigil usage

4 years agoAdded the sql expr scripts I've been using to test
Matt S Trout [Wed, 17 Apr 2019 02:12:28 +0000]
Added the sql expr scripts I've been using to test

4 years agostatement_list and test
Matt S Trout [Wed, 17 Apr 2019 02:01:55 +0000]
statement_list and test

4 years agowrap expander and expander list
Matt S Trout [Wed, 17 Apr 2019 01:32:39 +0000]
wrap expander and expander list

4 years agoconsolidate with_recursive
Matt S Trout [Wed, 17 Apr 2019 01:08:52 +0000]
consolidate with_recursive

4 years agomove setop expansion to generic rather than loop
Matt S Trout [Wed, 17 Apr 2019 01:03:35 +0000]
move setop expansion to generic rather than loop

4 years agomove clause rendering to better calling convention
Matt S Trout [Wed, 17 Apr 2019 00:46:00 +0000]
move clause rendering to better calling convention

4 years agoclean up calling code w/new render convention
Matt S Trout [Tue, 16 Apr 2019 03:52:42 +0000]
clean up calling code w/new render convention

4 years agoclean up calling convention
Matt S Trout [Tue, 16 Apr 2019 03:48:34 +0000]
clean up calling convention

4 years agofix up with clause code - got the parens wrong
Matt S Trout [Tue, 16 Apr 2019 02:14:23 +0000]
fix up with clause code - got the parens wrong

4 years agowith recursive test and bugfixes
Matt S Trout [Tue, 16 Apr 2019 02:10:00 +0000]
with recursive test and bugfixes

4 years agobasic with support
Matt S Trout [Mon, 15 Apr 2019 20:21:59 +0000]
basic with support

4 years agorefactor to add the rest of the setops
Matt S Trout [Mon, 15 Apr 2019 17:28:51 +0000]
refactor to add the rest of the setops

4 years agoLHS of as is interpreted as ident so this is more correct
Matt S Trout [Mon, 15 Apr 2019 16:45:35 +0000]
LHS of as is interpreted as ident so this is more correct

4 years agoswitch keyword formatting to method, fix clause order, add setop infra
Matt S Trout [Mon, 15 Apr 2019 16:34:07 +0000]
switch keyword formatting to method, fix clause order, add setop infra

4 years agopromote _join_parts to public method join_clauses
Matt S Trout [Mon, 15 Apr 2019 02:18:45 +0000]
promote _join_parts to public method join_clauses

4 years agointroduce keyword concept to avoid private methods
Matt S Trout [Mon, 15 Apr 2019 02:14:51 +0000]
introduce keyword concept to avoid private methods

4 years agoclauses transforms
Matt S Trout [Mon, 15 Apr 2019 02:03:18 +0000]
clauses transforms

4 years agofurther APIfication
Matt S Trout [Mon, 15 Apr 2019 01:45:26 +0000]
further APIfication

4 years agomove more stuff to method calls
Matt S Trout [Mon, 15 Apr 2019 01:41:58 +0000]
move more stuff to method calls

4 years agobetter extension api
Matt S Trout [Mon, 15 Apr 2019 01:27:04 +0000]
better extension api

4 years agoclean up op expansion
Matt S Trout [Mon, 15 Apr 2019 01:02:36 +0000]
clean up op expansion

4 years agoclean up from_list
Matt S Trout [Mon, 15 Apr 2019 00:43:46 +0000]
clean up from_list

4 years agomove to default registration
Matt S Trout [Mon, 15 Apr 2019 00:38:07 +0000]
move to default registration

4 years agoinitial extension api
Matt S Trout [Mon, 15 Apr 2019 00:18:09 +0000]
initial extension api

4 years agodemonstrate adding clauses with no special expand/render
Matt S Trout [Sun, 14 Apr 2019 19:58:05 +0000]
demonstrate adding clauses with no special expand/render

4 years agoverify "col = (SELECT ...)" works
Matt S Trout [Sun, 14 Apr 2019 19:16:56 +0000]
verify "col = (SELECT ...)" works

4 years agoclean up op/func handling, add exists, add de-inconsistency switch
Matt S Trout [Sun, 14 Apr 2019 19:08:58 +0000]
clean up op/func handling, add exists, add de-inconsistency switch

4 years agointroduce "top level" concept, move -values to Clauses to use it
Matt S Trout [Sun, 14 Apr 2019 18:01:25 +0000]
introduce "top level" concept, move -values to Clauses to use it

4 years agosugar for select and multi-row insert
Matt S Trout [Sun, 14 Apr 2019 02:36:20 +0000]
sugar for select and multi-row insert

4 years agomake INSERT SELECT work
Matt S Trout [Sat, 13 Apr 2019 18:39:27 +0000]
make INSERT SELECT work

4 years agosubselect in from renders ok
Matt S Trout [Sat, 13 Apr 2019 17:21:52 +0000]
subselect in from renders ok

4 years agodelete from, update using, join using
Matt S Trout [Sat, 13 Apr 2019 04:16:38 +0000]
delete from, update using, join using

4 years agoadd, expand, and use in from, VALUES
Matt S Trout [Sat, 13 Apr 2019 02:54:04 +0000]
add, expand, and use in from, VALUES

4 years agovalues clause
Matt S Trout [Sat, 13 Apr 2019 02:19:07 +0000]
values clause

4 years agoadd as support
Matt S Trout [Sat, 13 Apr 2019 01:54:51 +0000]
add as support

4 years agoclauses test (xt/ because extra deps)
Matt S Trout [Fri, 12 Apr 2019 20:50:38 +0000]
clauses test (xt/ because extra deps)

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