12 years agoUpdate DQ Converter to use new DQ::ExprHelpers
Matt Phillips [Fri, 17 Aug 2012 16:43:15 +0000]
Update DQ Converter to use new DQ::ExprHelpers

Instead of creating DQ structs directly, use the ExprHelpers to handle generation.

12 years agoFix eq_bind checker
Arthur Axel 'fREW' Schmidt [Sat, 28 Jul 2012 17:37:25 +0000]
Fix eq_bind checker

We have to Deepcopy because otherwise we get $VAR->... incorrect failures

12 years agofix arrayref tables to use correct join generation style
Matt S Trout [Sat, 28 Jul 2012 12:45:32 +0000]
fix arrayref tables to use correct join generation style

12 years agodocument order by madness
Matt S Trout [Mon, 7 May 2012 15:00:59 +0000]
document order by madness

12 years agosimple literals get detected and turned into nodes
Matt S Trout [Fri, 20 Apr 2012 11:36:00 +0000]
simple literals get detected and turned into nodes

12 years agoASC purge: t/06order_by.t
Matt S Trout [Fri, 20 Apr 2012 11:35:08 +0000]
ASC purge: t/06order_by.t

12 years agoless generous literal parsing
Matt S Trout [Fri, 20 Apr 2012 11:19:18 +0000]
less generous literal parsing

12 years agoparse simple order literals
Matt S Trout [Fri, 20 Apr 2012 10:03:55 +0000]
parse simple order literals

12 years agoabstract order specification
Matt S Trout [Fri, 20 Apr 2012 09:18:55 +0000]
abstract order specification

12 years agomake renderer and converter classes more pluggable
Matt S Trout [Fri, 20 Apr 2012 09:18:45 +0000]
make renderer and converter classes more pluggable

12 years agohandle ->_where_to_dq($plain_sql_string)
Matt S Trout [Tue, 17 Apr 2012 15:44:27 +0000]
handle ->_where_to_dq($plain_sql_string)

12 years agomore tweaks
Matt S Trout [Mon, 16 Apr 2012 13:46:10 +0000]
more tweaks

12 years agorefactor a bit more, honour literals in converter
Matt S Trout [Mon, 16 Apr 2012 07:11:45 +0000]
refactor a bit more, honour literals in converter

12 years agofactor out Converter
Matt S Trout [Mon, 16 Apr 2012 01:01:16 +0000]
factor out Converter

12 years agosimplify and generalize table literal handling
Matt S Trout [Sat, 14 Apr 2012 18:03:32 +0000]
simplify and generalize table literal handling

12 years agofactor out select logic a bit more
Matt S Trout [Sat, 14 Apr 2012 17:10:54 +0000]
factor out select logic a bit more

12 years agopass unknown @_ downwards for subclassers
Matt S Trout [Sat, 14 Apr 2012 15:49:05 +0000]
pass unknown @_ downwards for subclassers

12 years agoorder inside select node
Matt S Trout [Sat, 14 Apr 2012 15:41:21 +0000]
order inside select node

12 years agofactor some stuff out and enable writeable quoting attributes
Matt S Trout [Sat, 14 Apr 2012 15:05:00 +0000]
factor some stuff out and enable writeable quoting attributes

12 years agothrow toys out the pram and convert to Moo
Matt S Trout [Sat, 14 Apr 2012 11:25:41 +0000]
throw toys out the pram and convert to Moo

12 years agoclean up always_quote usage, factor out _render_sqla
Matt S Trout [Sat, 14 Apr 2012 05:59:33 +0000]
clean up always_quote usage, factor out _render_sqla

12 years agoport -ident and -value
Matt S Trout [Sat, 14 Apr 2012 02:36:30 +0000]
port -ident and -value

12 years agofix handling for nested function calls - see giant comment for compat hate.
Matt S Trout [Mon, 12 Sep 2011 03:22:27 +0000]
fix handling for nested function calls - see giant comment for compat hate.

12 years agohandle scalarref in arrayref of table names
Matt S Trout [Tue, 2 Aug 2011 12:11:24 +0000]
handle scalarref in arrayref of table names

12 years agodelete vestigial _join_sql_clauses method
Matt S Trout [Sun, 31 Jul 2011 20:29:51 +0000]
delete vestigial _join_sql_clauses method

12 years agoannihilate refkind stupidity
Matt S Trout [Sun, 31 Jul 2011 20:20:20 +0000]
annihilate refkind stupidity

12 years agogut values using _mutation_rhs_to_dq code
Matt S Trout [Sun, 31 Jul 2011 19:56:41 +0000]
gut values using _mutation_rhs_to_dq code

12 years agode-REFKIND-rubbish-ify from handling
Matt S Trout [Sun, 31 Jul 2011 19:51:40 +0000]
de-REFKIND-rubbish-ify from handling

12 years agoport INSERT, factor out mutation op RHS code
Matt S Trout [Sun, 31 Jul 2011 19:40:12 +0000]
port INSERT, factor out mutation op RHS code

12 years agoconvert update, refactor some stuff
Matt S Trout [Sun, 31 Jul 2011 15:15:15 +0000]
convert update, refactor some stuff

12 years agofactor out from+where handling and port DELETE
Matt S Trout [Sun, 31 Jul 2011 10:01:58 +0000]
factor out from+where handling and port DELETE

12 years agoseparate out _where_to_dq from _expr_to_dq and rewrite select to use DQ
Matt S Trout [Sun, 31 Jul 2011 09:12:46 +0000]
separate out _where_to_dq from _expr_to_dq and rewrite select to use DQ

12 years agofix expression generation for UPDATE
Matt S Trout [Sun, 31 Jul 2011 06:15:11 +0000]
fix expression generation for UPDATE

12 years agofirst cut at convert and case options
Matt S Trout [Sun, 31 Jul 2011 05:38:19 +0000]
first cut at convert and case options

12 years agoimplement $self->{logic} and kill numbered modifiers
Matt S Trout [Sun, 31 Jul 2011 05:20:21 +0000]
implement $self->{logic} and kill numbered modifiers

12 years agoConvert deprec. test to expectation of fatal error
Peter Rabbitson [Sun, 31 Jul 2011 05:07:16 +0000]
Convert deprec. test to expectation of fatal error

12 years agoimprove and/or handling
Matt S Trout [Sun, 31 Jul 2011 04:42:09 +0000]
improve and/or handling

12 years agoremove builtin special ops; handled elsewhere
Matt S Trout [Sun, 31 Jul 2011 02:49:39 +0000]
remove builtin special ops; handled elsewhere

12 years agospecial ops handling
Matt S Trout [Sun, 31 Jul 2011 02:44:54 +0000]
special ops handling

12 years agoallow \n in op names - not sure why this ever worked, but the scope guard test uses...
Matt S Trout [Sun, 31 Jul 2011 02:07:30 +0000]
allow \n in op names - not sure why this ever worked, but the scope guard test uses it and I don't see an immediate reason to disallow it

12 years agorefactor operator construction and add injection guard support back
Matt S Trout [Sun, 31 Jul 2011 02:01:22 +0000]
refactor operator construction and add injection guard support back

12 years agoswitch { foo => \'= bar' } to using multipart literal support
Matt S Trout [Sun, 31 Jul 2011 01:21:04 +0000]
switch { foo => \'= bar' } to using multipart literal support

12 years agoclean up IN/BETWEEN handling
Matt S Trout [Sun, 31 Jul 2011 00:59:56 +0000]
clean up IN/BETWEEN handling

12 years agosort hash keys when found as RHS in a hashpair
Matt S Trout [Sun, 31 Jul 2011 00:33:46 +0000]
sort hash keys when found as RHS in a hashpair

12 years agohandle empty where clauses, fix a quoting bug in literals, re-add support for custom...
Matt S Trout [Sat, 30 Jul 2011 23:41:45 +0000]
handle empty where clauses, fix a quoting bug in literals, re-add support for custom default comparison op

12 years agohandle crack fueled inner function thing
Matt S Trout [Fri, 29 Jul 2011 20:51:02 +0000]
handle crack fueled inner function thing

12 years agorewrite _where_to_dq to get rid of refkind switch
Matt S Trout [Mon, 25 Jul 2011 15:09:07 +0000]
rewrite _where_to_dq to get rid of refkind switch

12 years agohandle more IN/BETWEEN odd cases, fix value_meta handling
Matt S Trout [Mon, 25 Jul 2011 15:05:09 +0000]
handle more IN/BETWEEN odd cases, fix value_meta handling

12 years agofirst chunk of WHERE clause conversion
Matt S Trout [Mon, 25 Jul 2011 11:41:43 +0000]
first chunk of WHERE clause conversion

12 years agorefactor somewhat and convert order_by
Matt S Trout [Sun, 17 Jul 2011 06:55:15 +0000]
refactor somewhat and convert order_by

12 years agofactor _table_dq out and use in SELECT
Matt S Trout [Sun, 17 Jul 2011 02:34:02 +0000]
factor _table_dq out and use in SELECT

12 years agopass SELECT's FROM+etc. through DQ
Matt S Trout [Sun, 17 Jul 2011 02:25:09 +0000]
pass SELECT's FROM+etc. through DQ

12 years agogenerate SELECT list using DQ
Matt S Trout [Sun, 17 Jul 2011 02:09:00 +0000]
generate SELECT list using DQ

12 years agomove _render_dq call for _table to top level of method
Matt S Trout [Sun, 17 Jul 2011 01:14:31 +0000]
move _render_dq call for _table to top level of method

12 years agohandle \@from via DQ
Matt S Trout [Sun, 17 Jul 2011 01:10:22 +0000]
handle \@from via DQ

12 years agoswitch literal FROM clause generation
Matt S Trout [Sat, 16 Jul 2011 23:55:03 +0000]
switch literal FROM clause generation

12 years agocreate Data::Query::Renderer::SQL::Naive object and use it for single-table FROM...
Matt S Trout [Sat, 16 Jul 2011 23:46:06 +0000]
create Data::Query::Renderer::SQL::Naive object and use it for single-table FROM clause generation

12 years agoPull in some dependency bugfixes
Peter Rabbitson [Wed, 11 Apr 2012 05:12:57 +0000]
Pull in some dependency bugfixes

12 years agoUpgrade M::I
Peter Rabbitson [Tue, 29 Nov 2011 04:55:59 +0000]
Upgrade M::I

12 years agoMigrate -ident and -value from dbic, reorganize docs
Peter Rabbitson [Sun, 20 Mar 2011 09:30:17 +0000]
Migrate -ident and -value from dbic, reorganize docs

13 years agoDocument with the right name
Ryan P. Kelly [Wed, 29 Jun 2011 03:54:51 +0000]
Document with the right name

13 years agoCleaning up docs as ribasushi suggested. Made it clear that literal sql
Naveed Massjouni [Fri, 22 Apr 2011 22:08:21 +0000]
Cleaning up docs as ribasushi suggested. Made it clear that literal sql
should be used as a last resort.  Provided an example for testing IS NOT NULL.

13 years agoCleanup parser a bit more, anchor everything correctly, etc
Peter Rabbitson [Sun, 7 Aug 2011 03:54:03 +0000]
Cleanup parser a bit more, anchor everything correctly, etc

13 years agoAdd test for SQL statement that used to fail before the refactor
Alexander Hartmaier [Fri, 29 Jul 2011 13:14:35 +0000]
Add test for SQL statement that used to fail before the refactor

13 years agoMassively refactor arbitrary sql parser code
Peter Rabbitson [Sat, 6 Aug 2011 20:22:28 +0000]
Massively refactor arbitrary sql parser code

Now it deals much better with malformedness, does not recurse to insanely
deep evels, and reports much much better errors on test mismatches

13 years agoFix over-eager parenthesis unrolling (only legal in AND/OR)
Peter Rabbitson [Mon, 1 Aug 2011 10:14:49 +0000]
Fix over-eager parenthesis unrolling (only legal in AND/OR)

13 years agoPromote AS to a binop of sorts
Peter Rabbitson [Mon, 1 Aug 2011 10:03:29 +0000]
Promote AS to a binop of sorts

13 years agoDo not import Carp functions into the namespace
Peter Rabbitson [Sat, 19 Mar 2011 23:30:26 +0000]
Do not import Carp functions into the namespace

13 years ago_debug not debug, RT#67179
Justin Hunter [Fri, 8 Apr 2011 00:38:54 +0000]
_debug not debug, RT#67179

13 years agofix some pod per RT65556
Justin Hunter [Fri, 1 Apr 2011 14:47:29 +0000]
fix some pod per RT65556

13 years agofix git url, RT67137
Justin Hunter [Fri, 1 Apr 2011 14:12:45 +0000]
fix git url, RT67137

13 years agotake out useless _table option
Arthur Axel 'fREW' Schmidt [Tue, 29 Mar 2011 14:37:50 +0000]
take out useless _table option

13 years agoAdd some crazy malformed SQL to make sure things do not throw
Peter Rabbitson [Fri, 7 Jan 2011 09:40:14 +0000]
Add some crazy malformed SQL to make sure things do not throw

It looks like the empty-not-undef fix in 7cc47319 also fixes the general
issue of throwing on unknown operators (e.g. reverting af75bd59 would
still yield passing code, though the AST will still be incorrect).

Add a currently passing test as a reminder of what stuff to look for

13 years agoFix incorrect comparison of malformed lists
Peter Rabbitson [Fri, 7 Jan 2011 09:18:32 +0000]
Fix incorrect comparison of malformed lists

AND OR and , must have both a lhs and a rhs, if neither is
present add a [], which will properly trip the comparison
later on.

13 years agoFix recursion warnings while parsing extremely long lists
Peter Rabbitson [Fri, 7 Jan 2011 09:05:06 +0000]
Fix recursion warnings while parsing extremely long lists

13 years agoFix stupid not exists omission
Peter Rabbitson [Wed, 22 Dec 2010 15:45:39 +0000]
Fix stupid not exists omission

13 years agoRelease 1.72 v1.72
Arthur Axel 'fREW' Schmidt [Tue, 21 Dec 2010 17:53:00 +0000]
Release 1.72

13 years agoConsolidate the injection_guard checks, fix bobby's name
Peter Rabbitson [Tue, 21 Dec 2010 16:24:29 +0000]
Consolidate the injection_guard checks, fix bobby's name

13 years agoinjection_guard implementation
Peter Rabbitson [Tue, 21 Dec 2010 12:56:07 +0000]
injection_guard implementation

13 years agoRequire bugfixed CAG
Peter Rabbitson [Tue, 21 Dec 2010 11:01:43 +0000]
Require bugfixed CAG

13 years agoUndocument -nest with extreme prejudice
Peter Rabbitson [Tue, 21 Dec 2010 10:26:09 +0000]
Undocument -nest with extreme prejudice

-nest is a wart that never served any reasonable purpose. While
DBIC is outright deprecating it, SQLA is simply undocumenting it,
committing to keep all tests intact (but not committing to
reimplement -nest in the Data::Query adapter).

13 years agoRemoved excess parentheses in generated SQL
Wes Malone [Tue, 30 Nov 2010 03:41:49 +0000]
Removed excess parentheses in generated SQL

13 years agoFix stupid assumption in parenthesis unroller
Peter Rabbitson [Sun, 5 Dec 2010 20:02:29 +0000]
Fix stupid assumption in parenthesis unroller

13 years agoPass options to _insert_returning and allow bind rvs
Peter Rabbitson [Sun, 5 Dec 2010 18:21:51 +0000]
Pass options to _insert_returning and allow bind rvs

13 years agoadd handling for NULL when using -in
Justin Hunter [Wed, 1 Dec 2010 00:03:50 +0000]
add handling for NULL when using -in

13 years agoBetter diagnostics (unparse the parent of the failed chunk)
Peter Rabbitson [Sun, 28 Nov 2010 01:31:25 +0000]
Better diagnostics (unparse the parent of the failed chunk)

13 years agoAsk for a faster CAG, switch to MI::AI
Peter Rabbitson [Sat, 27 Nov 2010 22:54:42 +0000]
Ask for a faster CAG, switch to MI::AI

14 years agoWarnfree tests
Peter Rabbitson [Wed, 24 Nov 2010 16:44:40 +0000]
Warnfree tests

14 years agoFix retardation in -between bind handling
Peter Rabbitson [Wed, 24 Nov 2010 16:42:56 +0000]
Fix retardation in -between bind handling

14 years agomigrate _parenthesis_unroll to SQL::Abstract::Tree
Arthur Axel 'fREW' Schmidt [Sat, 13 Nov 2010 05:39:46 +0000]
migrate _parenthesis_unroll to SQL::Abstract::Tree

14 years agoFix parsing of foo.* in SQLA::Tree
Dagfinn Ilmari Mannsåker [Tue, 9 Nov 2010 11:40:31 +0000]
Fix parsing of foo.* in SQLA::Tree

14 years agoRelease 1.71 v1.71
Peter Rabbitson [Tue, 9 Nov 2010 11:20:51 +0000]
Release 1.71

14 years agoDisable dbic-tests when no dbic is present
Peter Rabbitson [Tue, 9 Nov 2010 11:14:34 +0000]
Disable dbic-tests when no dbic is present

14 years agoRelease 1.70 v1.70
Arthur Axel 'fREW' Schmidt [Tue, 9 Nov 2010 04:44:09 +0000]
Release 1.70

14 years agosort changes by importance
Arthur Axel 'fREW' Schmidt [Tue, 9 Nov 2010 04:40:38 +0000]
sort changes by importance

14 years agono raw ASCII
Arthur Axel 'fREW' Schmidt [Tue, 9 Nov 2010 01:12:49 +0000]
no raw ASCII

14 years agobetter quoting logic
Arthur Axel 'fREW' Schmidt [Tue, 9 Nov 2010 01:11:59 +0000]
better quoting logic

14 years agoLeave quotes from DBIC in bindargs
Arthur Axel 'fREW' Schmidt [Tue, 9 Nov 2010 00:45:46 +0000]
Leave quotes from DBIC in bindargs

14 years agoMake resulting SQL work on MySQL
Peter Rabbitson [Mon, 8 Nov 2010 03:04:01 +0000]
Make resulting SQL work on MySQL

14 years agogitignore
Peter Rabbitson [Mon, 8 Nov 2010 03:03:18 +0000]
gitignore