X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F61findnot.t;h=e9fe1ac755a20477a8746e8f03dae04f6eb1dcd9;hb=d8cf3aa31fb3d6ff7813f021fcc002663725fc41;hp=17f64fd4ea073498d25fb5e67604436e37d8542e;hpb=550adccc763b6887aa2ce43b1d1d9fb48b240763;p=dbsrgits%2FDBIx-Class.git diff --git a/t/61findnot.t b/t/61findnot.t index 17f64fd..e9fe1ac 100644 --- a/t/61findnot.t +++ b/t/61findnot.t @@ -1,15 +1,16 @@ +BEGIN { do "./t/lib/ANFANG.pm" or die ( $@ || $! ) } + use strict; -use warnings; +use warnings; use Test::More; use Test::Warn; -use lib qw(t/lib); +use Test::Exception; + use DBICTest; my $schema = DBICTest->init_schema(); -plan tests => 20; - my $art = $schema->resultset("Artist")->find(4); ok(!defined($art), 'Find on primary id: artist not found'); my @cd = $schema->resultset("CD")->find(6); @@ -48,15 +49,55 @@ ok(@cd && !defined($cd[0]), 'Array contains an undef as only element'); $cd = $schema->resultset("CD")->first; my $artist_rs = $schema->resultset("Artist")->search({ artistid => $cd->artist->artistid }); -$art = $artist_rs->find({ name => 'some other name' }, { key => 'primary' }); -ok($art, 'Artist found by key in the resultset'); +for my $key ('', 'primary') { + my $art = $artist_rs->find({ name => 'some other name' }, { $key ? (key => $key) : () }); + is($art->artistid, $cd->get_column('artist'), "Artist found through @{[ $key ? 'explicit' : 'implicit' ]} key locked in the resultset"); +} + +# collapsing and non-collapsing are separate codepaths, thus the separate tests +my $ea_count = 0; +$schema->exception_action(sub { + $ea_count++; + die @_; +}); $artist_rs = $schema->resultset("Artist"); -warning_is { + +warnings_exist { + $artist_rs->find({}) +} qr/\QQuery returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single/ + => "Non-unique find generated a cursor inexhaustion warning"; + +throws_ok { $artist_rs->find({}, { key => 'primary' }) -} "DBIx::Class::ResultSet::find(): Query returned more than one row", "Non-unique find generated a cursor inexhaustion warning"; +} qr/Unable to satisfy requested constraint 'primary'/; + +for (1, 0) { + local $ENV{DBIC_NULLABLE_KEY_NOWARN}; + warnings_like + sub { + $artist_rs->find({ artistid => undef }, { key => 'primary' }) + }, + $_ ? [ + qr/undef values supplied for requested unique constraint.+almost certainly not what you wanted/, + ] : [], + 'One warning on NULL conditions for constraint' + ; +} + +is( $ea_count, 1, "exception action invoked the expected amount of times (just the exception)" ); + +$schema->exception_action(undef); + $artist_rs = $schema->resultset("Artist")->search({}, { prefetch => 'cds' }); -warning_is { + +warnings_exist { + $artist_rs->find({}) +} qr/\QDBIx::Class::ResultSet::find(): Query returned more than one row/, "Non-unique find generated a cursor inexhaustion warning"; + +throws_ok { $artist_rs->find({}, { key => 'primary' }) -} "DBIx::Class::ResultSet::find(): Query returned more than one row", "Non-unique find generated a cursor inexhaustion warning"; +} qr/Unable to satisfy requested constraint 'primary'/; + +done_testing;