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

9 years agoBump Moo dep and remove warning defatalisation hack
Dagfinn Ilmari Mannsåker [Tue, 7 Jul 2015 18:19:52 +0000]
Bump Moo dep and remove warning defatalisation hack

Moo 2 no longer pulls in strictures

9 years agoAdd _update_returning method for UPDATE … RETURNING
Dagfinn Ilmari Mannsåker [Sun, 21 Dec 2014 14:43:28 +0000]
Add _update_returning method for UPDATE … RETURNING

It just calls _returning, but allows subclasses to override UPDATE …
RETURNING independently from INSERT … RETURNING

9 years agoKeep calling _insert_returning for INSERT … RETURNING
Dagfinn Ilmari Mannsåker [Sun, 21 Dec 2014 14:42:45 +0000]
Keep calling _insert_returning for INSERT … RETURNING

DBIC::SQLMaker::Oracle overrides this method, and its insert calls
next::method, so we need keep calling the old method for the override to
work.

9 years agoFixed missing '}' in POD examples and reformat for clarity
Daniel Perrett [Fri, 10 Oct 2014 10:17:50 +0000]
Fixed missing '}' in POD examples and reformat for clarity

9 years agoReinstate _insert_returning method for DBIC compat
Dagfinn Ilmari Mannsåker [Mon, 15 Dec 2014 20:29:57 +0000]
Reinstate _insert_returning method for DBIC compat

9 years agoAdd support for UPDATE ... RETURNING ...
Dagfinn Ilmari Mannsåker [Mon, 15 Dec 2014 20:14:46 +0000]
Add support for UPDATE ... RETURNING ...

Similar to INSERT ... RETURNING ...

10 years agoRelease 1.81 v1.81
Peter Rabbitson [Sat, 25 Oct 2014 11:30:24 +0000]
Release 1.81

10 years agoFix overly-enthusiastic parenthesis unroller (RT#99503)
Peter Rabbitson [Sat, 25 Oct 2014 10:47:35 +0000]
Fix overly-enthusiastic parenthesis unroller (RT#99503)

10 years agoRe-indent and quote versions in Makefile
Peter Rabbitson [Sat, 25 Oct 2014 10:46:39 +0000]
Re-indent and quote versions in Makefile

No functional changes

10 years agoRelease 1.80 v1.80
Peter Rabbitson [Sun, 5 Oct 2014 21:05:57 +0000]
Release 1.80

10 years agoSkip tests on smokers with a broken DBIC trial
Peter Rabbitson [Sun, 5 Oct 2014 21:03:53 +0000]
Skip tests on smokers with a broken DBIC trial

10 years agoCroak on invalid top-level special ops
Peter Rabbitson [Fri, 26 Sep 2014 12:02:04 +0000]
Croak on invalid top-level special ops

When they were originally introduced it never occured neither to me, nor
whoever reviewed that a plain special-op will not work at top level.
Add an extra check at the fallback point (ugly, but still effective)

10 years agoSaner handling of nested_lhs, we now set it in one spot only
Peter Rabbitson [Fri, 3 Oct 2014 11:21:49 +0000]
Saner handling of nested_lhs, we now set it in one spot only

10 years agospelling mistake (RT#99147)
gregor herrmann [Fri, 26 Sep 2014 14:34:04 +0000]
spelling mistake (RT#99147)

10 years agoWhatever I was thinking it wasn't making much sense
Peter Rabbitson [Fri, 26 Sep 2014 01:56:45 +0000]
Whatever I was thinking it wasn't making much sense

Good thing I started pondering how to port this to DQ, otherwise would not
have noticed I fucked up... for a while

10 years agoRelease 1.79 v1.79
Peter Rabbitson [Thu, 25 Sep 2014 12:00:59 +0000]
Release 1.79

10 years agoEven though MRO::C is a dep of Moo, specify it explicitly
Peter Rabbitson [Thu, 25 Sep 2014 11:59:55 +0000]
Even though MRO::C is a dep of Moo, specify it explicitly

Some folks do this http://cpanratings.perl.org/dist/SQL-Abstract#9620

10 years agoDeprecate and properly handle empty lhs
Peter Rabbitson [Thu, 25 Sep 2014 11:08:35 +0000]
Deprecate and properly handle empty lhs

10 years agoMore robust Moo import block (modelled on DBIC)
Peter Rabbitson [Wed, 24 Sep 2014 00:25:20 +0000]
More robust Moo import block (modelled on DBIC)

10 years agoUpdating links to repositories, added GitHub mirror
Rudolf Leermakers [Tue, 23 Sep 2014 23:29:56 +0000]
Updating links to repositories, added GitHub mirror

Modelled on the corresponding DBIC setup

10 years agoMinor documentation fixes; typos, POD formatting code syntax, return value explanatio...
Rudolf Leermakers [Tue, 23 Sep 2014 23:01:11 +0000]
Minor documentation fixes; typos, POD formatting code syntax, return value explanation consistency

10 years agoLink fixes (no other changes)
Peter Rabbitson [Sun, 21 Sep 2014 17:40:27 +0000]
Link fixes (no other changes)

10 years agoWarn if _recurse_where is called in scalar context
Dagfinn Ilmari Mannsåker [Sat, 12 Apr 2014 17:09:17 +0000]
Warn if _recurse_where is called in scalar context

DBIC used to do this, but doesn't any more. Still something else might...

10 years agoTruly fix literal+bind examples (build upon a3e3e6a18)
Peter Rabbitson [Sat, 20 Sep 2014 23:03:12 +0000]
Truly fix literal+bind examples (build upon a3e3e6a18)

Throw away the dummy text - it was always misleading and incorrect
Add some space to clarify which part is which

10 years agoFix typos in literal + bind examples
Dagfinn Ilmari Mannsåker [Tue, 22 Jul 2014 22:52:47 +0000]
Fix typos in literal + bind examples

10 years agoIRC meta
Peter Rabbitson [Fri, 19 Sep 2014 16:05:12 +0000]
IRC meta

10 years agoWell how about them apples?! Add temporary overload-madness escape hatch
Peter Rabbitson [Fri, 19 Sep 2014 15:54:52 +0000]
Well how about them apples?! Add temporary overload-madness escape hatch

10 years agoBoolification-derived-stringification is a thing... just shoot me now
Peter Rabbitson [Fri, 19 Sep 2014 14:35:14 +0000]
Boolification-derived-stringification is a thing... just shoot me now

10 years agoAn arrayref makes sense for literals, but no sense for values
Peter Rabbitson [Sun, 14 Sep 2014 17:45:01 +0000]
An arrayref makes sense for literals, but no sense for values

Change the API before it goes live (extra benefit - no mixing up of
the functions by accident)

10 years agoMore (still passing!!!) test cases after conversation with FC
Peter Rabbitson [Wed, 10 Sep 2014 05:51:11 +0000]
More (still passing!!!) test cases after conversation with FC

10 years agoEven more versatile is_plain_value testing - feeble attempts to trip up perl
Peter Rabbitson [Fri, 5 Sep 2014 06:16:57 +0000]
Even more versatile is_plain_value testing - feeble attempts to trip up perl

This is an attempt to simulate the behavior of JSON::PP::Boolean, and to
replicate the error autarch was seeing - clearly there is more to it than
just simple value juggling. Oh well, commit already written tests anyway.

See further commits for the actual code changes

10 years agoMake sure is_plain_value returns the actual object pre-stringify
Peter Rabbitson [Fri, 5 Sep 2014 08:37:21 +0000]
Make sure is_plain_value returns the actual object pre-stringify

This is important since DBIC is starting to heavily rely on the
contents of the returned []

10 years agoEven more reuse of @_
Peter Rabbitson [Fri, 5 Sep 2014 07:59:15 +0000]
Even more reuse of @_

10 years ago{ -ident => undef } makes zero sense
Peter Rabbitson [Thu, 4 Sep 2014 10:29:49 +0000]
{ -ident => undef } makes zero sense

10 years agoCorrect comments about overload methods vs. ->can()
Dagfinn Ilmari Mannsåker [Fri, 18 Jul 2014 09:08:01 +0000]
Correct comments about overload methods vs. ->can()

10 years agoAha - this is why I didn't use ->can originally
Peter Rabbitson [Thu, 17 Jul 2014 17:05:49 +0000]
Aha - this is why I didn't use ->can originally

Punt for the time being, will investigate why later. The error looks like:

rabbit@Ahasver:~/devel/dbic$ git rev-parse HEAD
32497625ce5699576c8a63edd16401d4f741c282

rabbit@Ahasver:~/devel/dbic$ PERL5LIB=/home/rabbit/devel/sqla/lib prove -lT t/100populate.t
t/100populate.t .. 1/? Stub found while resolving method "???" overloading """" in package "Path::Class::File" at /home/rabbit/devel/sqla/lib/SQL/Abstract.pm line 118, <> line 1.
t/100populate.t .. Dubious, test returned 255 (wstat 65280, 0xff00)
All 43 subtests passed

Test Summary Report
-------------------
t/100populate.t (Wstat: 65280 Tests: 43 Failed: 0)
  Non-zero exit status: 255
  Parse errors: No plan found in TAP output
Files=1, Tests=43,  1 wallclock secs ( 0.04 usr  0.00 sys +  0.90 cusr  0.03 csys =  0.97 CPU)
Result: FAIL

10 years agoNew exportable functions: is_literal_value($) and is_plain_value($)
Peter Rabbitson [Thu, 17 Jul 2014 09:23:53 +0000]
New exportable functions: is_literal_value($) and is_plain_value($)

Ported from DBIC with some corner case fixes added.

10 years agoFix -values not being handled properly with NULLs
Peter Rabbitson [Wed, 16 Jul 2014 11:50:55 +0000]
Fix -values not being handled properly with NULLs

10 years agoEscape closing quote character in table and column names
Dagfinn Ilmari Mannsåker [Thu, 29 May 2014 09:12:08 +0000]
Escape closing quote character in table and column names

10 years agoAfter 5f3fa0ac script/ is no more
Peter Rabbitson [Wed, 16 Jul 2014 11:47:43 +0000]
After 5f3fa0ac script/ is no more

10 years agoFixup descriptions a bit
Peter Rabbitson [Wed, 16 Jul 2014 10:00:47 +0000]
Fixup descriptions a bit

10 years agoAdd basic .dir-locals.el
Dagfinn Ilmari Mannsåker [Wed, 25 Jun 2014 17:07:37 +0000]
Add basic .dir-locals.el

10 years agorelease 1.78 v1.78
Peter Rabbitson [Wed, 28 May 2014 10:13:30 +0000]
release 1.78

10 years agoDrop reqs - works on 5.6.1 just fine
Peter Rabbitson [Wed, 28 May 2014 10:07:54 +0000]
Drop reqs - works on 5.6.1 just fine

10 years agoRewrite sql formatter script and shove it into examples until more tested
Peter Rabbitson [Wed, 28 May 2014 10:06:10 +0000]
Rewrite sql formatter script and shove it into examples until more tested

Combined with the opportunistic parser this little tool has the promise of
actually being useful outside of the echo chamber. Someone with good UX
skillz ought to take this to the next level... or something ;)

10 years agoSwap CAG with Moo, lazify a lot of the profile selection
Peter Rabbitson [Wed, 21 May 2014 13:15:04 +0000]
Swap CAG with Moo, lazify a lot of the profile selection

There should be zero functional changes

10 years agoPort the \[] *_sql_bind unpacker from DBIC
Peter Rabbitson [Tue, 27 May 2014 18:06:03 +0000]
Port the \[] *_sql_bind unpacker from DBIC

10 years agoUse variables to simplify grocking the parenthesis unroller rules
Peter Rabbitson [Wed, 21 May 2014 10:08:26 +0000]
Use variables to simplify grocking the parenthesis unroller rules

Zero (hopefully) functional changes

10 years agoFix the reassembler to treat RNO as the precious special snowflake it is
Arthur Axel 'fREW' Schmidt [Fri, 14 Mar 2014 16:12:05 +0000]
Fix the reassembler to treat RNO as the precious special snowflake it is

Yes, the parser is accumulating a lot of cruft this way with special casing
and whatnot, and yes it is necessary for the future when we write a real
parser which will *HAVE* to deal with the corner cases. The accumulated set
of tests is the goal here (with the side effect of better UX) -- ribasushi

10 years agoTreat RNO as a unary op, and properly normalize it
Peter Rabbitson [Wed, 21 May 2014 09:22:24 +0000]
Treat RNO as a unary op, and properly normalize it

10 years agoOriginal (now passing) test for 08e163601
Arthur Axel 'fREW' Schmidt [Wed, 26 Feb 2014 17:56:12 +0000]
Original (now passing) test for 08e163601

10 years agoFix the binop leg of the parser to correctly consider only a single LHS node
Peter Rabbitson [Wed, 21 May 2014 08:46:16 +0000]
Fix the binop leg of the parser to correctly consider only a single LHS node

Work gracefully around malformed "no lhs" cases as well

10 years agorelease 1.77 v1.77
Peter Rabbitson [Fri, 17 Jan 2014 01:03:15 +0000]
release 1.77

10 years agoPort scalarref in array of sources test from dq (7732c37a)
Peter Rabbitson [Thu, 16 Jan 2014 23:39:31 +0000]
Port scalarref in array of sources test from dq (7732c37a)

10 years agoFix regression in column level { not => undef } op
Peter Rabbitson [Thu, 16 Jan 2014 23:14:23 +0000]
Fix regression in column level { not => undef } op

In 3cdadcbe we stopped considering a bare 'not' being an inequality op.
However there is code in the wild relying on this, so add an extra
compat shim (cheap)

10 years agoCheck for extra warnings, and diag input and output
Dagfinn Ilmari Mannsåker [Fri, 3 Jan 2014 18:26:01 +0000]
Check for extra warnings, and diag input and output

We want to test the _lack_ of warnings as well, and having the input and
output is handy for figuring out what's wrong.

10 years agoDiag input and output for unexpected success
Dagfinn Ilmari Mannsåker [Fri, 3 Jan 2014 15:03:46 +0000]
Diag input and output for unexpected success

10 years agoEnsure that multi-nested parenthesis are never unrolled after IN
Peter Rabbitson [Fri, 3 Jan 2014 16:57:16 +0000]
Ensure that multi-nested parenthesis are never unrolled after IN

This lets us remove parenthesis_significant from many tests that do
not need it, including reversal of 1ba9d0f03

10 years agoParentheses are significant in IN tests
Dagfinn Ilmari Mannsåker [Fri, 27 Dec 2013 14:52:12 +0000]
Parentheses are significant in IN tests

10 years agorelease 1.75 v1.75
Peter Rabbitson [Fri, 27 Dec 2013 04:49:24 +0000]
release 1.75

10 years agoMove simple IN/BETWEEN tests to t/05in_between.t
Dagfinn Ilmari Mannsåker [Thu, 26 Dec 2013 21:27:11 +0000]
Move simple IN/BETWEEN tests to t/05in_between.t

No changes in the actual tests except splitting the empty array and
scalar tests for IN into separate cases.

10 years agoActually use the descriptions in the test cases
Dagfinn Ilmari Mannsåker [Thu, 26 Dec 2013 21:28:27 +0000]
Actually use the descriptions in the test cases

10 years agoAn old (now passing) test for regression introduced in 6f2a5b6
Arthur Axel 'fREW' Schmidt [Fri, 20 Apr 2012 18:46:28 +0000]
An old (now passing) test for regression introduced in 6f2a5b6

10 years agoPort fce4b7a9 from the DQ branch (with warning expectation ammendments)
Dagfinn Ilmari Mannsåker [Fri, 6 Dec 2013 17:24:22 +0000]
Port fce4b7a9 from the DQ branch (with warning expectation ammendments)

10 years agoReintroduce handling of IS( NOT) ops
Peter Rabbitson [Thu, 26 Dec 2013 08:23:06 +0000]
Reintroduce handling of IS( NOT) ops

This is undocumented syntax, but it is very likely someone is using it in
the wild, and the previous inequality op handler rewrite broke this

10 years agoExtensive tests and deprecations of multivalue/no value inequality op calls
Peter Rabbitson [Thu, 26 Dec 2013 05:47:18 +0000]
Extensive tests and deprecations of multivalue/no value inequality op calls

All sql-generation tests match pre <= 1.74 behavior (except for the newly
added rlike operator, which now warns while it simply did not work with
undefs before)

10 years agoMove test to a better location (no changes)
Peter Rabbitson [Thu, 26 Dec 2013 05:28:02 +0000]
Move test to a better location (no changes)

10 years agoNormalize handling of expected warnings/exceptions in tests
Peter Rabbitson [Thu, 26 Dec 2013 05:26:51 +0000]
Normalize handling of expected warnings/exceptions in tests

10 years agoRemove many of the settled-by-time comments, modernize a bit
Peter Rabbitson [Thu, 26 Dec 2013 05:07:25 +0000]
Remove many of the settled-by-time comments, modernize a bit

10 years agoCentralize handling of in-test dumpering
Peter Rabbitson [Thu, 26 Dec 2013 04:29:17 +0000]
Centralize handling of in-test dumpering

10 years agoExtra stopword (we need to find a way to introduce dialects...)
Peter Rabbitson [Sun, 22 Dec 2013 11:36:59 +0000]
Extra stopword (we need to find a way to introduce dialects...)

10 years agoNo tabs, no trailers
Peter Rabbitson [Wed, 18 Dec 2013 13:50:36 +0000]
No tabs, no trailers

10 years agoMake it clearer in examples that bool takes expressions
Peter Rabbitson [Wed, 18 Dec 2013 13:25:05 +0000]
Make it clearer in examples that bool takes expressions

timbunce++

10 years agoTest BETWEEN after the IN debacle (luckily it throws in all expected cases)
Peter Rabbitson [Wed, 18 Dec 2013 10:15:20 +0000]
Test BETWEEN after the IN debacle (luckily it throws in all expected cases)

Generalize the emitted exception text

10 years agoWe already have Storable as a dep, this is pointless
Peter Rabbitson [Wed, 18 Dec 2013 10:20:23 +0000]
We already have Storable as a dep, this is pointless

10 years agoAnd yet more improvements in the parsing engine
Peter Rabbitson [Tue, 17 Dec 2013 23:33:31 +0000]
And yet more improvements in the parsing engine

Streamline the construction of -MISC (gah I hate that name) nodes, and make
sure we do not treat placeholders as list element node terminator

10 years agoDo not yell loudly on TODOified is_same_* tests
Peter Rabbitson [Wed, 18 Dec 2013 08:15:50 +0000]
Do not yell loudly on TODOified is_same_* tests