X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F02where.t;h=644eca5c8b1ecde7290bec4bcc97f117f993d943;hb=c7e9c808fa4346e2c2692f107852626c0ccde404;hp=229770b6a0e573702fb635cb16d62821fa1ffebd;hpb=417dd15e9d8e3a2575614757202bcfb4bbe9c660;p=dbsrgits%2FSQL-Abstract.git diff --git a/t/02where.t b/t/02where.t index 229770b..644eca5 100644 --- a/t/02where.t +++ b/t/02where.t @@ -2,7 +2,8 @@ use strict; use warnings; use Test::More; use Test::Warn; -use SQL::Abstract::Test import => [qw(is_same_sql_bind diag_where) ]; +use Test::Exception; +use SQL::Abstract::Test import => [qw(is_same_sql_bind diag_where dumper) ]; use SQL::Abstract; @@ -10,6 +11,12 @@ my $not_stringifiable = bless {}, 'SQLA::NotStringifiable'; my @handle_tests = ( { + where => 'foo', + order => [], + stmt => ' WHERE foo', + bind => [], + }, + { where => { requestor => 'inna', worker => ['nwiger', 'rcwe', 'sfz'], @@ -391,17 +398,24 @@ my @handle_tests = ( stmt => " WHERE ( 0 ) ", bind => [ ], }, + { + where => { artistid => {} }, + stmt => '', + bind => [ ], + } ); for my $case (@handle_tests) { my $sql = SQL::Abstract->new; my ($stmt, @bind); - warnings_exist { - ($stmt, @bind) = $sql->where($case->{where}, $case->{order}); - } $case->{warns} || []; + lives_ok { + warnings_exist { + ($stmt, @bind) = $sql->where($case->{where}, $case->{order}); + } $case->{warns} || []; + }; is_same_sql_bind($stmt, \@bind, $case->{stmt}, $case->{bind}) - || diag_where ( $case->{where} ); + || do { diag_where ( $case->{where} ); diag dumper($sql->_expand_expr($case->{where})) }; } done_testing;