4 years agoswitch update to using _render_expr
Matt S Trout [Mon, 17 Sep 2018 01:46:00 +0000]
switch update to using _render_expr

4 years agoswitch between to render_expr
Matt S Trout [Mon, 17 Sep 2018 01:34:00 +0000]
switch between to render_expr

4 years agoconvert -in to render_expr
Matt S Trout [Mon, 17 Sep 2018 01:33:02 +0000]
convert -in to render_expr

4 years agohave func use render_expr
Matt S Trout [Mon, 17 Sep 2018 01:31:02 +0000]
have func use render_expr

4 years agoremove vestigial ANDOR op
Matt S Trout [Mon, 17 Sep 2018 01:29:49 +0000]
remove vestigial ANDOR op

4 years agomove _OP over to _render_expr
Matt S Trout [Mon, 17 Sep 2018 01:29:00 +0000]
move _OP over to _render_expr

4 years agoinitial introduction of render_expr, make sql(true|false) into methods
Matt S Trout [Mon, 17 Sep 2018 01:23:38 +0000]
initial introduction of render_expr, make sql(true|false) into methods

4 years agomore debugging in tests
Matt S Trout [Mon, 17 Sep 2018 01:22:55 +0000]
more debugging in tests

4 years agoeliminate (I hope) last and/or case in expansion
Matt S Trout [Mon, 17 Sep 2018 00:12:41 +0000]
eliminate (I hope) last and/or case in expansion

4 years ago{ x => { -and => [ ... ] } converted to op
Matt S Trout [Mon, 17 Sep 2018 00:09:00 +0000]
{ x => { -and => [ ... ] } converted to op

4 years ago{ x => { -and => ... } } converted to op
Matt S Trout [Mon, 17 Sep 2018 00:07:25 +0000]
{ x => { -and => ... } } converted to op

4 years agofurther and/or conversion
Matt S Trout [Mon, 17 Sep 2018 00:03:36 +0000]
further and/or conversion

4 years agostart of moving and/or to ops
Matt S Trout [Sun, 16 Sep 2018 23:58:26 +0000]
start of moving and/or to ops

4 years agomake non-unops multipart
Matt S Trout [Sun, 16 Sep 2018 22:49:17 +0000]
make non-unops multipart

4 years agoeliminate (I think) -not as an expanded node type
Matt S Trout [Sun, 16 Sep 2018 22:45:12 +0000]
eliminate (I think) -not as an expanded node type

4 years agoclean up notreached code
Matt S Trout [Sun, 16 Sep 2018 22:28:51 +0000]
clean up notreached code

4 years agofixup operator + empty arrayref handling
Matt S Trout [Sun, 16 Sep 2018 21:36:15 +0000]
fixup operator + empty arrayref handling

4 years agoresolve final 02where fail by adding -func, 01generate still sad
Matt S Trout [Sun, 16 Sep 2018 20:47:11 +0000]
resolve final 02where fail by adding -func, 01generate still sad

4 years agotrap exceptions and show expr expansion in 02where
Matt S Trout [Sun, 16 Sep 2018 20:46:41 +0000]
trap exceptions and show expr expansion in 02where

4 years agoMANGLE
Matt S Trout [Sat, 15 Sep 2018 17:14:07 +0000]
MANGLE

4 years agonotreached at base of expand_expr
Matt S Trout [Wed, 12 Sep 2018 00:31:15 +0000]
notreached at base of expand_expr

4 years agoeliminate IS special op usage
Matt S Trout [Tue, 11 Sep 2018 23:14:43 +0000]
eliminate IS special op usage

4 years agoeliminated value old special op impl
Matt S Trout [Tue, 11 Sep 2018 22:31:18 +0000]
eliminated value old special op impl

4 years agoensure ident no longer uses the old code
Matt S Trout [Tue, 11 Sep 2018 22:24:13 +0000]
ensure ident no longer uses the old code

4 years agodisable IN and BETWEEN implementations
Matt S Trout [Tue, 11 Sep 2018 22:10:45 +0000]
disable IN and BETWEEN implementations

4 years agoneed to normalize op to avoid spurious use of old unary ops
Matt S Trout [Tue, 11 Sep 2018 22:07:46 +0000]
need to normalize op to avoid spurious use of old unary ops

4 years agoIN support as a custom -op type
Matt S Trout [Tue, 11 Sep 2018 21:40:56 +0000]
IN support as a custom -op type

4 years agoexpand and render BETWEEN and NOT BETWEEN
Matt S Trout [Sun, 9 Sep 2018 18:24:55 +0000]
expand and render BETWEEN and NOT BETWEEN

4 years agoLITERAL op should perform bindtype check
Matt S Trout [Sat, 8 Sep 2018 19:02:59 +0000]
LITERAL op should perform bindtype check

4 years agoregularise more code, switch one test from die to warn verification
Matt S Trout [Sat, 8 Sep 2018 18:15:00 +0000]
regularise more code, switch one test from die to warn verification

4 years agoswitch another literal case to -literal
Matt S Trout [Sat, 8 Sep 2018 16:33:52 +0000]
switch another literal case to -literal

4 years agouse -literal for top level exprs
Matt S Trout [Sat, 8 Sep 2018 01:55:26 +0000]
use -literal for top level exprs

4 years agoinitial introduction of literal op
Matt S Trout [Sat, 8 Sep 2018 01:51:55 +0000]
initial introduction of literal op

4 years agoexpand hashpair w/hash RHS
Matt S Trout [Sat, 8 Sep 2018 00:02:47 +0000]
expand hashpair w/hash RHS

4 years agoexpand top level arrays
Matt S Trout [Fri, 7 Sep 2018 23:44:57 +0000]
expand top level arrays

4 years agoinclude exception for 00new failures
Matt S Trout [Fri, 7 Sep 2018 23:43:58 +0000]
include exception for 00new failures

4 years agoadd -op and -bind, expand some cases to them
Matt S Trout [Fri, 7 Sep 2018 22:47:58 +0000]
add -op and -bind, expand some cases to them

4 years agobetter results from 01generate when a test unexpecteedly dies
Matt S Trout [Fri, 7 Sep 2018 22:47:24 +0000]
better results from 01generate when a test unexpecteedly dies

4 years agoexpand -bool, stop forbidding top-level unary ops
Matt S Trout [Tue, 4 Sep 2018 02:53:32 +0000]
expand -bool, stop forbidding top-level unary ops

4 years agonegation expansion
Matt S Trout [Tue, 4 Sep 2018 02:46:19 +0000]
negation expansion

4 years agoarrayref hashpair case
Matt S Trout [Tue, 4 Sep 2018 02:29:14 +0000]
arrayref hashpair case

4 years agorearrange hashpair expansion
Matt S Trout [Tue, 4 Sep 2018 01:39:42 +0000]
rearrange hashpair expansion

4 years agoexpander handles literal as RHS
Matt S Trout [Mon, 3 Sep 2018 22:43:09 +0000]
expander handles literal as RHS

4 years agoadd -nest to hashpair expansion
Matt S Trout [Mon, 3 Sep 2018 21:50:36 +0000]
add -nest to hashpair expansion

4 years agohashpair expansion - defaulting to $self->{cmp}
Matt S Trout [Mon, 3 Sep 2018 21:34:47 +0000]
hashpair expansion - defaulting to $self->{cmp}

4 years agoexpression expansion pass, zeroth cut
Matt S Trout [Mon, 3 Sep 2018 21:13:36 +0000]
expression expansion pass, zeroth cut

4 years agoremove another special case IS NULL rendering
Matt S Trout [Sun, 2 Sep 2018 20:45:37 +0000]
remove another special case IS NULL rendering

4 years agomake undef value use is operator
Matt S Trout [Sun, 2 Sep 2018 20:28:52 +0000]
make undef value use is operator

4 years agoexplicit defaulting of scalar-rhs hashpair
Matt S Trout [Sun, 2 Sep 2018 20:23:57 +0000]
explicit defaulting of scalar-rhs hashpair

4 years agoRelease commit for 1.87 v1.87
Dagfinn Ilmari Mannsåker [Tue, 2 Jun 2020 10:36:30 +0000]
Release commit for 1.87

4 years agoBumping version to 1.87
Dagfinn Ilmari Mannsåker [Tue, 2 Jun 2020 10:32:51 +0000]
Bumping version to 1.87

4 years agoAdd a missed fallback to the package-global $tb
Dagfinn Ilmari Mannsåker [Mon, 3 Feb 2020 11:33:02 +0000]
Add a missed fallback to the package-global $tb

4 years agoRemove explicit Exporter inheritace in SQL::Abstract::Test
Dagfinn Ilmari Mannsåker [Fri, 31 Jan 2020 17:37:11 +0000]
Remove explicit Exporter inheritace in SQL::Abstract::Test

Test:::Builder::Module is documented to inherit from Exporter.

4 years agoRe-fetch the Test::Builder object in each test function
Dagfinn Ilmari Mannsåker [Fri, 31 Jan 2020 17:29:16 +0000]
Re-fetch the Test::Builder object in each test function

Rather than stashing it in a global, as recommende in the
Test::Builder::Module documentation.  However, keep the global in case
someone is overriding it despite it not being documented.

4 years agoAdd runtime dependency on Test::Deep and Test::Builder::Module (RT#131623)
Dagfinn Ilmari Mannsåker [Fri, 31 Jan 2020 11:27:38 +0000]
Add runtime dependency on Test::Deep and Test::Builder::Module (RT#131623)

They are used by SQL::Abstract::Test, and modules that test-depend on
that shouldn't have to explicitly depend on Test::Deep themselves.

4 years agoConsistently use single quotes for deps in Makefile.PL
Dagfinn Ilmari Mannsåker [Fri, 31 Jan 2020 11:18:24 +0000]
Consistently use single quotes for deps in Makefile.PL

6 years agoRelease commit for 1.86 v1.86
Dagfinn Ilmari Mannsåker [Mon, 9 Jul 2018 16:28:58 +0000]
Release commit for 1.86

6 years agoBumping version to 1.86
Dagfinn Ilmari Mannsåker [Mon, 9 Jul 2018 16:22:24 +0000]
Bumping version to 1.86

6 years agoAdd Changes entry for literal '0' WHERE fix
Dagfinn Ilmari Mannsåker [Mon, 9 Jul 2018 15:49:09 +0000]
Add Changes entry for literal '0' WHERE fix

6 years agoDo not replace the literal string '0' with ''
Fabrizio Gennari [Fri, 6 Apr 2018 08:58:30 +0000]
Do not replace the literal string '0' with ''

6 years agoAdd overloadable _select_fields method
Sebastian Riedel [Sun, 28 Jan 2018 11:34:40 +0000]
Add overloadable _select_fields method

Consistent with _update_set_values and _insert_values

6 years agoRemove spaces before colons in POD
Dagfinn Ilmari Mannsåker [Sat, 27 Jan 2018 12:08:30 +0000]
Remove spaces before colons in POD

6 years agoRemove obsolete docs for arrayrefref as select source
Dagfinn Ilmari Mannsåker [Sat, 27 Jan 2018 11:51:29 +0000]
Remove obsolete docs for arrayrefref as select source

Support for this was removed as "useless", with no Changes or
documentation update, in version 1.74 (commit
a0d6d3230359880681d5d328d6b1775c0fbe5983).

6 years agoIgnore built dist files and directories
Dagfinn Ilmari Mannsåker [Sat, 27 Jan 2018 11:29:26 +0000]
Ignore built dist files and directories

6 years agoRelease commit for 1.85 v1.85
Dagfinn Ilmari Mannsåker [Sat, 27 Jan 2018 11:15:01 +0000]
Release commit for 1.85

6 years agoBumping version to 1.85
Dagfinn Ilmari Mannsåker [Sat, 27 Jan 2018 11:10:01 +0000]
Bumping version to 1.85

6 years agoAdd Changes entry for UPDATE ... SET ... refactor
Dagfinn Ilmari Mannsåker [Sat, 27 Jan 2018 10:57:45 +0000]
Add Changes entry for UPDATE ... SET ... refactor

6 years agoRemove pointless quoting of single variables
Dagfinn Ilmari Mannsåker [Fri, 26 Jan 2018 22:59:23 +0000]
Remove pointless quoting of single variables

By moving the spaces into adjacent SQL literals

6 years agoadd reusable _update_set_values method, consistent with _insert_values
Sebastian Riedel [Fri, 26 Jan 2018 19:01:20 +0000]
add reusable _update_set_values method, consistent with _insert_values

6 years agoAdd Travis-CI config
Dagfinn Ilmari Mannsåker [Wed, 17 Jan 2018 12:01:26 +0000]
Add Travis-CI config

7 years agoSpelling errors
Xavier Guimard [Wed, 25 Oct 2017 20:37:36 +0000]
Spelling errors

7 years agoWhitespace cleanup
Dagfinn Ilmari Mannsåker [Thu, 13 Apr 2017 10:13:38 +0000]
Whitespace cleanup

7 years agoPrune pointless puke parens
Dagfinn Ilmari Mannsåker [Thu, 13 Apr 2017 10:35:48 +0000]
Prune pointless puke parens

7 years agoMake META->{no_index}->{package} an array
Dagfinn Ilmari Mannsåker [Mon, 3 Apr 2017 16:58:45 +0000]
Make META->{no_index}->{package} an array

CPAN::Meta::Converter fixes it, but might as well make it right from
the beginning.

7 years agoAdd modules used in author tests to develop-requires
Dagfinn Ilmari Mannsåker [Mon, 3 Apr 2017 15:48:03 +0000]
Add modules used in author tests to develop-requires

Also remove conditional skippage from author tests

7 years agoRestore perl version requirement missed in the Distar port
Dagfinn Ilmari Mannsåker [Mon, 3 Apr 2017 15:32:43 +0000]
Restore perl version requirement missed in the Distar port

7 years agoRelease commit for 1.84 v1.84
Dagfinn Ilmari Mannsåker [Mon, 3 Apr 2017 15:29:18 +0000]
Release commit for 1.84

7 years agoBumping version to 1.84
Dagfinn Ilmari Mannsåker [Mon, 3 Apr 2017 15:28:00 +0000]
Bumping version to 1.84

7 years agoRestore 'dynamic_config => 0' missed in the Distar port
Dagfinn Ilmari Mannsåker [Mon, 3 Apr 2017 15:27:41 +0000]
Restore 'dynamic_config => 0' missed in the Distar port

7 years agoRelease commit for 1.83 v1.83
Dagfinn Ilmari Mannsåker [Mon, 3 Apr 2017 15:20:15 +0000]
Release commit for 1.83

7 years agoBumping version to 1.83
Dagfinn Ilmari Mannsåker [Mon, 3 Apr 2017 15:16:15 +0000]
Bumping version to 1.83

7 years agoPort to Distar
Dagfinn Ilmari Mannsåker [Mon, 3 Apr 2017 15:16:06 +0000]
Port to Distar

7 years agoNote GitHub PR number for DELETE ... RETURNING (GH#9)
Dagfinn Ilmari Mannsåker [Mon, 3 Apr 2017 14:42:04 +0000]
Note GitHub PR number for DELETE ... RETURNING (GH#9)

7 years agoComment why each of the RETURNING clauses have their own method
Dagfinn Ilmari Mannsåker [Mon, 3 Apr 2017 10:25:29 +0000]
Comment why each of the RETURNING clauses have their own method

7 years agoAdd support for DELETE ... RETURNING ...
Sebastian Riedel [Mon, 20 Mar 2017 21:39:23 +0000]
Add support for DELETE ... RETURNING ...

7 years agoRelease 1.82 v1.82
Dagfinn Ilmari Mannsåker [Mon, 20 Mar 2017 17:55:06 +0000]
Release 1.82

7 years agoAlign clauses of complex ORDER BY example for readability
Dagfinn Ilmari Mannsåker [Wed, 1 Mar 2017 12:22:46 +0000]
Align clauses of complex ORDER BY example for readability

7 years agoFix syntax errors in ORDER BY docs (GH#7)
Joshua Keroes [Fri, 15 Jul 2016 21:34:48 +0000]
Fix syntax errors in ORDER BY docs (GH#7)

Missing some } characters. Had to reformat the table to make them fit.

Read under -w

7 years agoAdd explicit dependency on Sub::Quote (GH#8)
Dagfinn Ilmari Mannsåker [Wed, 1 Mar 2017 12:11:16 +0000]
Add explicit dependency on Sub::Quote (GH#8)

Sub::Quote was split out of Moo in version 2.00300, but keep the
versioned requirement the same as for Moo so we don't force people on
intermediate versions to upgrade.

7 years agoRelease 1.81_01 v1.81_01
Dagfinn Ilmari Mannsåker [Tue, 28 Feb 2017 19:09:42 +0000]
Release 1.81_01

7 years agoAdd Changes entry for ORDER BY doc improvements
Dagfinn Ilmari Mannsåker [Mon, 20 Feb 2017 12:04:17 +0000]
Add Changes entry for ORDER BY doc improvements

8 years agoDocument arrayrefref (\[...]) form for order_by
Ricardo Signes [Fri, 6 May 2016 20:36:36 +0000]
Document arrayrefref (\[...]) form for order_by

Amended by committer to also mention it and the scalarref form in the
introductory paragraph, and move the scalarref form further down the
table of examples.

8 years agoRemove pointless prototypes on methods
Dagfinn Ilmari Mannsåker [Fri, 4 Mar 2016 15:03:06 +0000]
Remove pointless prototypes on methods

8 years agoFix ->insert($table, \@values) with >26 values (RT#112684)
Dagfinn Ilmari Mannsåker [Fri, 4 Mar 2016 14:59:17 +0000]
Fix ->insert($table, \@values) with >26 values (RT#112684)

This gets rid of the cute hash key ordering hack and instead factors the
body of the loop in ->_insert_values into a separate method that the
arrayref version calls directly in the right order.

8 years agoAdd Changes entry for UPDATE ... RETURNING
Dagfinn Ilmari Mannsåker [Sat, 20 Feb 2016 15:10:54 +0000]
Add Changes entry for UPDATE ... RETURNING

8 years ago10% speedup of identifier quoting
Dagfinn Ilmari Mannsåker [Wed, 30 Dec 2015 23:49:47 +0000]
10% speedup of identifier quoting

9 years agoTeach ::Tree that ILIKE (PostgreSQL) and REGEXP (MySQL) are binary ops
Dagfinn Ilmari Mannsåker [Mon, 19 Oct 2015 10:25:53 +0000]
Teach ::Tree that ILIKE (PostgreSQL) and REGEXP (MySQL) are binary ops

9 years agoFix ORDER BY clause type in synopsis and where() header
Dagfinn Ilmari Mannsåker [Tue, 23 Jun 2015 10:32:32 +0000]
Fix ORDER BY clause type in synopsis and where() header

The ORDER BY clause can be either a string, stringref, arrayref or
hashref, so don't imply it has to be an arrayref in the docs.

9 years agoFix order clauses with bind parameters in ->where
Dagfinn Ilmari Mannsåker [Sun, 28 Jun 2015 13:32:28 +0000]
Fix order clauses with bind parameters in ->where

->where was ignoring the bind parameters returned by ->_order_by

9 years agoIgnore editor droppings
Dagfinn Ilmari Mannsåker [Tue, 7 Jul 2015 18:24:04 +0000]
Ignore editor droppings