X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F06order_by.t;h=0d340ae961baa7c2b0b2c39cd1830e5f67d8f396;hb=6bbe13e99769ef04d6cda7a4a6ac6968b535435f;hp=bf478df45d9082c5e39a45caea3789eac795886d;hpb=10e6c94609fc94467ef8f281ffe192d8038ffc9e;p=scpubgit%2FQ-Branch.git diff --git a/t/06order_by.t b/t/06order_by.t index bf478df..0d340ae 100644 --- a/t/06order_by.t +++ b/t/06order_by.t @@ -1,5 +1,3 @@ -#!/usr/bin/perl - use strict; use warnings; use Test::More; @@ -60,6 +58,11 @@ my @cases = expects => '', expects_quoted => '', }, + { + given => [ {} ], + expects => '', + expects_quoted => '', + }, { given => [{-desc => [ qw/colA colB/ ] }], @@ -109,10 +112,10 @@ my @cases = my $sql = SQL::Abstract->new; my $sqlq = SQL::Abstract->new({quote_char => '`'}); -for my $case( @cases) { +for my $case (@cases) { my ($stat, @bind); - ($stat, @bind) = $sql->_order_by($case->{given}); + ($stat, @bind) = $sql->where(undef, $case->{given}); is_same_sql_bind ( $stat, \@bind, @@ -120,7 +123,7 @@ for my $case( @cases) { $case->{bind} || [], ); - ($stat, @bind) = $sqlq->_order_by($case->{given}); + ($stat, @bind) = $sqlq->where(undef, $case->{given}); is_same_sql_bind ( $stat, \@bind, @@ -136,6 +139,12 @@ throws_ok ( ); throws_ok ( + sub { $sql->_order_by([ {-desc => 'colA', -asc => 'colB' } ]) }, + qr/hash passed .+ must have exactly one key/, + 'Undeterministic order exception', +); + +throws_ok ( sub { $sql->_order_by({-desc => [ qw/colA colB/ ], -asc => [ qw/colC colD/ ] }) }, qr/hash passed .+ must have exactly one key/, 'Undeterministic order exception',