use warnings;
use Test::More;
use Test::Exception;
+use Test::Warn;
use SQL::Abstract::Test import => [qw(is_same_sql_bind diag_where)];
use SQL::Abstract;
* Modifiers are respected in both hashrefs and arrayrefs (with the obvious
limitation of one modifier type per hahsref)
- * When in condition context i.e. where => { -or { a = 1 } }, each modifier
+ * When in condition context i.e. where => { -or => { a = 1 } }, each modifier
affects only the immediate element following it.
* When in column multi-condition context i.e.
- where => { x => { '!=', [-and, [qw/1 2 3/]] } }, a modifier affects the
+ where => { x => { '!=', [-and => [qw/1 2 3/]] } }, a modifier affects the
OUTER ARRAYREF if and only if it is the first element of said ARRAYREF
=cut
TODO: {
local $TODO = $case->{todo} if $case->{todo};
- my @w;
- local $SIG{__WARN__} = sub { push @w, @_ };
-
- my $sql = SQL::Abstract->new ($case->{args} || {});
+ my $sql = SQL::Abstract->new($case->{args} || {});
my $where_copy = dclone($case->{where});
- lives_ok (sub {
- my ($stmt, @bind) = $sql->where($case->{where});
- is_same_sql_bind(
- $stmt,
- \@bind,
- $case->{stmt},
- $case->{bind},
- ) || diag_where( $case->{where} );
- });
- is (@w, 0, 'No warnings within and-or tests')
- || diag join "\n", 'Emitted warnings:', @w;
+ warnings_are {
+ lives_ok {
+ my ($stmt, @bind) = $sql->where($case->{where});
+ is_same_sql_bind(
+ $stmt,
+ \@bind,
+ $case->{stmt},
+ $case->{bind},
+ ) || (diag_where ( $case->{where} ), diag dumper ([ EXP => $sql->_expand_expr($case->{where}) ]));
+ } || (diag_where ( $case->{where} ), diag dumper ([ EXP => $sql->_expand_expr($case->{where}) ]));
+ } [], 'No warnings within and-or tests';
is_deeply ($case->{where}, $where_copy, 'Where conditions unchanged');
}
local $SQL::Abstract::Test::parenthesis_significant = 1;
- my $sql = SQL::Abstract->new ($case->{args} || {});
+ my $sql = SQL::Abstract->new($case->{args} || {});
lives_ok (sub {
my ($stmt, @bind) = $sql->where($case->{where});
is_same_sql_bind(
\@bind,
$case->{stmt},
$case->{bind},
- ) || diag_where ( $case->{where} );
+ ) || (diag_where ( $case->{where} ), diag dumper ([ EXP => $sql->_expand_expr($case->{where}) ]));
});
}
}
-
-
-my $w_str = "\QUse of [and|or|nest]_N modifiers is deprecated and will be removed in SQLA v2.0\E";
for my $case (@numbered_mods) {
TODO: {
local $TODO = $case->{todo} if $case->{todo};
+ # not using Test::Warn here - variable amount of warnings
my @w;
local $SIG{__WARN__} = sub { push @w, @_ };
- my $sql = SQL::Abstract->new ($case->{args} || {});
- lives_ok (sub {
+
+ my $sql = SQL::Abstract->new($case->{args} || {});
+ lives_ok {
my ($old_s, @old_b) = $sql->where($case->{backcompat});
my ($new_s, @new_b) = $sql->where($case->{correct});
is_same_sql_bind(
backcompat => $case->{backcompat},
correct => $case->{correct},
});
- });
-
- ok (@w, 'Warnings were emitted about a mod_N construct');
-
- my @non_match;
- for (@w) {
- push @non_match, $_ if ($_ !~ /$w_str/);
- }
+ };
- is (@non_match, 0, 'All warnings match the deprecation message')
- || diag join "\n", 'Rogue warnings:', @non_match;
+ ok ( (grep
+ { $_ =~ qr/\QUse of [and|or|nest]_N modifiers is deprecated and will be removed in SQLA v2.0/ }
+ @w
+ ), 'Warnings were emitted about a mod_N construct');
}
}