4 years agoin practice, shoving a space after every ) turned out to suck
Matt S Trout [Mon, 16 Sep 2019 17:45:51 +0000]
in practice, shoving a space after every ) turned out to suck

4 years agomore code cleanup
Matt S Trout [Sat, 14 Sep 2019 02:42:38 +0000]
more code cleanup

4 years agomore formatting cleanup
Matt S Trout [Sat, 14 Sep 2019 02:28:51 +0000]
more formatting cleanup

4 years agocleanup and improve formatting logic
Matt S Trout [Sat, 14 Sep 2019 01:56:42 +0000]
cleanup and improve formatting logic

4 years agobetter indentation and interpolation
Matt S Trout [Mon, 9 Sep 2019 00:21:47 +0000]
better indentation and interpolation

4 years agopresent AS correctly
Matt S Trout [Mon, 9 Sep 2019 00:21:24 +0000]
present AS correctly

4 years agofix indentation and newlines for more cases
Matt S Trout [Mon, 9 Sep 2019 00:02:44 +0000]
fix indentation and newlines for more cases

4 years agoclearer formatting with less pointless whitespace/newlines
Matt S Trout [Sun, 8 Sep 2019 23:56:42 +0000]
clearer formatting with less pointless whitespace/newlines

4 years agoON( now renders correctly as ON (
Matt S Trout [Fri, 6 Sep 2019 02:03:52 +0000]
ON( now renders correctly as ON (

4 years agohandle non-ref internals
Matt S Trout [Fri, 6 Sep 2019 01:47:38 +0000]
handle non-ref internals

4 years agoformatter starts to work
Matt S Trout [Fri, 6 Sep 2019 01:24:58 +0000]
formatter starts to work

4 years agobetter followiung principles
Matt S Trout [Fri, 6 Sep 2019 00:50:08 +0000]
better followiung principles

4 years agomake cast expander stable
Matt S Trout [Tue, 27 Aug 2019 00:49:57 +0000]
make cast expander stable

4 years agobender
Matt S Trout [Sat, 24 Aug 2019 04:18:47 +0000]
bender

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

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

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

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

5 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

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

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

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

5 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

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

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

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

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

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

5 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

5 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

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

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

5 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

5 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

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

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

5 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

5 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

5 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

5 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

5 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

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

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

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

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

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

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

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

5 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

5 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

5 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

5 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

5 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

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

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

5 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

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

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

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

5 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

5 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

5 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

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

5 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

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

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

5 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

5 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

5 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

5 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

5 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

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

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

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

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

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

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

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

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

5 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

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

5 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

5 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

5 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

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

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

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

5 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