X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F02where.t;fp=t%2F02where.t;h=fc926f2776a7e7d8b8030b5ad06227dfaf0b9896;hb=428975b0e646c0769d7eb530d4f52443471a9a9a;hp=e6e1eddd4b5b353f2104e6caba93f3332934a055;hpb=23401b818b099397e04df91b43340ecd59e8f92b;p=dbsrgits%2FSQL-Abstract.git diff --git a/t/02where.t b/t/02where.t index e6e1edd..fc926f2 100644 --- a/t/02where.t +++ b/t/02where.t @@ -106,7 +106,7 @@ my @handle_tests = ( }, { - where => { + where => { priority => [ {'>', 3}, {'<', 1} ], requestor => \'is not null', }, @@ -116,7 +116,7 @@ my @handle_tests = ( }, { - where => { + where => { requestor => { '!=', ['-and', undef, ''] }, }, stmt => " WHERE ( requestor IS NOT NULL AND requestor != ? )", @@ -124,9 +124,9 @@ my @handle_tests = ( }, { - where => { + where => { priority => [ {'>', 3}, {'<', 1} ], - requestor => { '!=', undef }, + requestor => { '!=', undef }, }, order => [qw/a b c d e f g/], stmt => " WHERE ( ( ( priority > ? ) OR ( priority < ? ) ) AND requestor IS NOT NULL )" @@ -135,9 +135,9 @@ my @handle_tests = ( }, { - where => { + where => { priority => { 'between', [1, 3] }, - requestor => { 'like', undef }, + requestor => { 'like', undef }, }, order => \'requestor, ticket', #LDNOTE: modified parentheses @@ -149,12 +149,12 @@ my @handle_tests = ( { - where => { - id => 1, - num => { - '<=' => 20, - '>' => 10, - }, + where => { + id => 1, + num => { + '<=' => 20, + '>' => 10, + }, }, # LDNOTE : modified test below, just parentheses differ # @@ -406,7 +406,7 @@ for my $case (@handle_tests) { local $Data::Dumper::Terse = 1; my $sql = SQL::Abstract->new; my($stmt, @bind); - lives_ok (sub { + lives_ok (sub { ($stmt, @bind) = $sql->where($case->{where}, $case->{order}); is_same_sql_bind($stmt, \@bind, $case->{stmt}, $case->{bind}) || diag "Search term:\n" . Dumper $case->{where};