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
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

14 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)

14 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
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
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

14 years agoReenable show_progress in example
Peter Rabbitson [Mon, 8 Nov 2010 02:56:34 +0000]
Reenable show_progress in example

14 years agoDocument repo
Arthur Axel 'fREW' Schmidt [Sat, 6 Nov 2010 23:46:14 +0000]
Document repo

14 years agoFix missing doc (RT#62587)
Arthur Axel 'fREW' Schmidt [Wed, 3 Nov 2010 02:36:14 +0000]
Fix missing doc (RT#62587)

14 years agoAdd error checking on "profile" for SQLA::Tree
Arthur Axel 'fREW' Schmidt [Fri, 29 Oct 2010 01:40:24 +0000]
Add error checking on "profile" for SQLA::Tree

14 years agoHighlight HAVING
Arthur Axel 'fREW' Schmidt [Thu, 28 Oct 2010 04:24:49 +0000]
Highlight HAVING

14 years agodocs for pretty printer
Arthur Axel 'fREW' Schmidt [Tue, 26 Oct 2010 01:39:10 +0000]
docs for pretty printer

14 years agofixup tests
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 21:15:40 +0000]
fixup tests

14 years agofix precedence for executing in new
Arthur Axel 'fREW' Schmidt [Tue, 26 Oct 2010 01:21:28 +0000]
fix precedence for executing in new

14 years agotests for bulk insert
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 21:06:44 +0000]
tests for bulk insert

14 years agoDo not show_progress by default
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 20:59:47 +0000]
Do not show_progress by default

14 years agosquash_repeats > no_repeats
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 20:58:51 +0000]
squash_repeats > no_repeats

14 years agotest for no-repeats
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 20:20:29 +0000]
test for no-repeats

14 years agoAdd "no_repeats" option to fix it such that repeated SQL may be ellided except for...
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 14:44:29 +0000]
Add "no_repeats" option to fix it such that repeated SQL may be ellided except for placeholders

14 years agotry DBIC colorizer!
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 21:04:36 +0000]
try DBIC colorizer!

14 years agobetter bulk insert support
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 20:45:00 +0000]
better bulk insert support

14 years agoallow disabling of show_progress; _ some accessors
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 20:41:46 +0000]
allow disabling of show_progress; _ some accessors

14 years agoAdd EXECUTING for clarity of long running SQL
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 20:30:26 +0000]
Add EXECUTING for clarity of long running SQL

14 years agomake console color profile a bit easier to read
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 17:10:06 +0000]
make console color profile a bit easier to read

14 years agoHighlight transaction keywords
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 17:05:00 +0000]
Highlight transaction keywords

14 years agoHide bulk inserts from DBIx::Class
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 16:43:00 +0000]
Hide bulk inserts from DBIx::Class

14 years agofix pagination keywords
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 02:18:52 +0000]
fix pagination keywords

14 years agofix placeholder quoting
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 01:49:36 +0000]
fix placeholder quoting

14 years agorelease SQL::Abstract 1.69
Arthur Axel "fREW" Schmidt [Fri, 22 Oct 2010 14:32:27 +0000]
release SQL::Abstract 1.69

14 years agofix tree tests
Arthur Axel "fREW" Schmidt [Fri, 22 Oct 2010 04:12:18 +0000]
fix tree tests

14 years agoAdd support for { -op => $foo } in UPDATE arguments
Peter Rabbitson [Thu, 21 Oct 2010 17:11:29 +0000]
Add support for { -op => $foo } in UPDATE arguments
Refactor unary op handlers to allow overrides at any level
Makes for very very hairy internals, but immensely useful for upstream

14 years agoFix default value inserts (an op can have an empty arglist)
Peter Rabbitson [Thu, 21 Oct 2010 14:51:31 +0000]
Fix default value inserts (an op can have an empty arglist)

14 years agoFix incorrect padding
Peter Rabbitson [Thu, 21 Oct 2010 13:53:11 +0000]
Fix incorrect padding

14 years agoProper placeholder support in the AST
Peter Rabbitson [Thu, 21 Oct 2010 13:36:51 +0000]
Proper placeholder support in the AST

14 years agoProperly support ops containing _'s (valid in Oracle)
Peter Rabbitson [Thu, 21 Oct 2010 13:21:26 +0000]
Properly support ops containing _'s (valid in Oracle)

14 years agoPreserve \@bindargs passed to unparse()
Peter Rabbitson [Thu, 21 Oct 2010 12:49:11 +0000]
Preserve \@bindargs passed to unparse()

14 years agoAdd list support, and various mini-fixes
Peter Rabbitson [Thu, 21 Oct 2010 12:39:16 +0000]
Add list support, and various mini-fixes

14 years agoexamined placeholder status a bit more carefully
John Napiorkowski [Wed, 20 Oct 2010 18:01:23 +0000]
examined placeholder status a bit more carefully

14 years agoadded test for the html profile destroyed placeholder problem
John Napiorkowski [Wed, 20 Oct 2010 17:49:40 +0000]
added test for the html profile destroyed placeholder problem

14 years agofix placeholder surround and add complex test
Arthur Axel "fREW" Schmidt [Fri, 15 Oct 2010 00:31:47 +0000]
fix placeholder surround and add complex test

14 years agoChanges for past two commits
Arthur Axel "fREW" Schmidt [Sat, 9 Oct 2010 08:46:41 +0000]
Changes for past two commits

14 years agos// does not return the modified string, $_ does
Arthur Axel "fREW" Schmidt [Sat, 9 Oct 2010 08:39:57 +0000]
s// does not return the modified string, $_ does

14 years agomake format-sql actually useful
Arthur Axel "fREW" Schmidt [Sat, 9 Oct 2010 08:26:07 +0000]
make format-sql actually useful

14 years agoadd a couple more examples
Arthur Axel "fREW" Schmidt [Sat, 9 Oct 2010 07:57:12 +0000]
add a couple more examples

14 years agoFix bogus test (does not pass yet)
Peter Rabbitson [Wed, 29 Sep 2010 16:55:23 +0000]
Fix bogus test (does not pass yet)

14 years agot/01generate.t
Peter Rabbitson [Wed, 29 Sep 2010 16:54:53 +0000]
t/01generate.t

14 years agoThese 'optimizations' are silly
Peter Rabbitson [Mon, 27 Sep 2010 06:54:06 +0000]
These 'optimizations' are silly

14 years agoFix bindtype omission in -in handling
Peter Rabbitson [Thu, 23 Sep 2010 10:51:29 +0000]
Fix bindtype omission in -in handling

14 years agoBackout errnoeusly committed stuff
Peter Rabbitson [Wed, 22 Sep 2010 14:19:34 +0000]
Backout errnoeusly committed stuff

14 years agoFix incomplete handling of IN/BETWEEN sub-args
Peter Rabbitson [Wed, 22 Sep 2010 14:14:40 +0000]
Fix incomplete handling of IN/BETWEEN sub-args

14 years agoReplace one more grep with a regex
Peter Rabbitson [Wed, 22 Sep 2010 10:09:34 +0000]
Replace one more grep with a regex

14 years agoReenable the tester test - it's fast enough now
Peter Rabbitson [Wed, 22 Sep 2010 10:01:59 +0000]
Reenable the tester test - it's fast enough now

14 years agoStupid stupid typo
Peter Rabbitson [Wed, 22 Sep 2010 10:00:37 +0000]
Stupid stupid typo

14 years agoTokenizer fixed \o/
Peter Rabbitson [Wed, 22 Sep 2010 09:49:58 +0000]
Tokenizer fixed \o/

14 years agoadd test for parsing lists
Arthur Axel "fREW" Schmidt [Wed, 22 Sep 2010 02:48:52 +0000]
add test for parsing lists

14 years agoMove the colordefs to the profile def
Peter Rabbitson [Tue, 21 Sep 2010 05:11:08 +0000]
Move the colordefs to the profile def

14 years agorelease 1.68
Arthur Axel "fREW" Schmidt [Thu, 16 Sep 2010 14:45:33 +0000]
release 1.68

14 years agoadd a bit more doc, test doc, and rename a method
Arthur Axel "fREW" Schmidt [Thu, 16 Sep 2010 14:44:32 +0000]
add a bit more doc, test doc, and rename a method

14 years agoplaceholder coloring!
Arthur Axel "fREW" Schmidt [Tue, 14 Sep 2010 02:40:48 +0000]
placeholder coloring!

14 years agodoc additions and a method rename
Arthur Axel "fREW" Schmidt [Tue, 14 Sep 2010 01:00:24 +0000]
doc additions and a method rename

14 years agouse object interface to Hash::Merge
Arthur Axel "fREW" Schmidt [Sun, 12 Sep 2010 19:39:58 +0000]
use object interface to Hash::Merge

14 years agorelease 1.67_03
Arthur Axel "fREW" Schmidt [Sun, 12 Sep 2010 19:38:38 +0000]
release 1.67_03

14 years agodocs for ::Tree
Arthur Axel "fREW" Schmidt [Sat, 11 Sep 2010 17:36:22 +0000]
docs for ::Tree

14 years agocaller info does not belong here
Arthur Axel "fREW" Schmidt [Sat, 11 Sep 2010 17:09:39 +0000]
caller info does not belong here

14 years agoinitial start of warn-style caller info
Arthur Axel "fREW" Schmidt [Fri, 10 Sep 2010 04:14:55 +0000]
initial start of warn-style caller info

14 years agoadd missing dep
Arthur Axel "fREW" Schmidt [Fri, 10 Sep 2010 04:13:12 +0000]
add missing dep

14 years agomerge configs with profiles
Arthur Axel "fREW" Schmidt [Thu, 9 Sep 2010 23:13:22 +0000]
merge configs with profiles