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 $where_copy = dclone($case->{where});
- lives_ok (sub {
+ warnings_are {
my ($stmt, @bind) = $sql->where($case->{where});
is_same_sql_bind(
$stmt,
$case->{stmt},
$case->{bind},
) || diag_where( $case->{where} );
- });
- is (@w, 0, 'No warnings within and-or tests')
- || diag join "\n", 'Emitted warnings:', @w;
+ } [], 'No warnings within and-or tests';
is_deeply ($case->{where}, $where_copy, 'Where conditions unchanged');
}
}
}
-
-
-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 ($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');
}
}