#
#################
-
my @tests = (
{
func => 'select',
bind => ['boom']
},
{
+ # this is maybe wrong but a single arg doesn't get quoted
+ func => 'select',
+ args => ['test', 'id', { a => { '!=', 'boom' } }],
+ stmt => 'SELECT id FROM test WHERE ( a != ? )',
+ stmt_q => 'SELECT id FROM `test` WHERE ( `a` != ? )',
+ bind => ['boom']
+ },
+ {
func => 'update',
args => ['test', {a => 'boom'}, {a => undef}],
stmt => 'UPDATE test SET a = ? WHERE ( a IS NULL )',
},
{
func => 'update',
+ args => ['test', {a => undef }, {a => 'boom'}],
+ stmt => 'UPDATE test SET a = ? WHERE ( a = ? )',
+ stmt_q => 'UPDATE `test` SET `a` = ? WHERE ( `a` = ? )',
+ bind => [undef,'boom']
+ },
+ {
+ func => 'update',
args => ['test', {a => 'boom'}, { a => {'!=', "bang" }} ],
stmt => 'UPDATE test SET a = ? WHERE ( a != ? )',
stmt_q => 'UPDATE `test` SET `a` = ? WHERE ( `a` != ? )',
[ foo => "bar", $lhs => \["baz"], bizz => "buzz" ],
[ $lhs => \"baz" ],
[ $lhs => \["baz"] ],
-
- # except for this one, that is automagically arrayified
- { foo => "bar", -or => { $lhs => \"baz" }, bizz => "buzz" },
) {
push @tests, {
func => 'where',
## deprecations - sorta worked, likely abused by folks
for my $where_arg (
# the arrayref forms of this never worked and throw above
+ { foo => "bar", -or => { $lhs => \"baz" }, bizz => "buzz" },
{ foo => "bar", -and => { $lhs => \"baz" }, bizz => "buzz" },
{ foo => "bar", $lhs => \"baz", bizz => "buzz" },
{ foo => "bar", $lhs => \["baz"], bizz => "buzz" },
) || diag dumper({ args => $t->{args}, result => $stmt });
}
else {
- warnings_like(
- sub { $cref->() },
- $t->{warns} || [],
- ) || diag dumper({ args => $t->{args}, result => $stmt });
+ lives_ok(sub {
+ warnings_like(
+ sub { $cref->() },
+ $t->{warns} || [],
+ ) || diag dumper({ args => $t->{args}, result => $stmt });
+ }) || diag dumper({ args => $t->{args}, result => $stmt, threw => $@ });
is_same_sql_bind(
$stmt,
\@bind,
$quoted ? $t->{stmt_q}: $t->{stmt},
$t->{bind}
- );
+ ) || diag dumper({ args => $t->{args}, result => $stmt });;
}
}
}