X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fprefetch%2Fincomplete.t;h=f8e89def398956ad33b3e656e0480dc40402a42f;hb=fcf32d04540e2c67625641b0bc004111a7d90252;hp=36f259ff69d1b8cb885a088560e723f2951cef77;hpb=fe0708a2d68b5d34b6bc6f7e70164c3e569f1dd0;p=dbsrgits%2FDBIx-Class.git diff --git a/t/prefetch/incomplete.t b/t/prefetch/incomplete.t index 36f259f..f8e89de 100644 --- a/t/prefetch/incomplete.t +++ b/t/prefetch/incomplete.t @@ -9,7 +9,7 @@ use DBICTest; my $schema = DBICTest->init_schema(); lives_ok(sub { - # while cds.* will be selected anyway (prefetch currently forces the result of _resolve_prefetch) + # while cds.* will be selected anyway (prefetch implies it) # only the requested me.name column will be fetched. # reference sql with select => [...] @@ -20,7 +20,7 @@ lives_ok(sub { { prefetch => [ qw/ cds / ], order_by => [ { -desc => 'me.name' }, 'cds.title' ], - select => [qw/ me.name cds.title / ], + select => [qw/ me.name cds.title / ], }, ); @@ -31,7 +31,6 @@ lives_ok(sub { is ($we_are_goth->cds->first->title, 'Come Be Depressed With Us', 'Correct cd for artist'); }, 'explicit prefetch on a keyless object works'); - lives_ok ( sub { my $rs = $schema->resultset('CD')->search( @@ -50,14 +49,14 @@ lives_ok ( sub { my @cds_and_tracks; for my $cd ($rs->all) { - my $data->{year} = $cd->year; + my $data = { year => $cd->year, cdid => $cd->cdid }; for my $tr ($cd->tracks->all) { push @{$data->{tracks}}, { $tr->get_columns }; } push @cds_and_tracks, $data; } - my $pref_rs = $rs->search ({}, { columns => ['year'], prefetch => 'tracks' }); + my $pref_rs = $rs->search ({}, { columns => [qw/year cdid/], prefetch => 'tracks' }); my @pref_cds_and_tracks; for my $cd ($pref_rs->all) { @@ -106,8 +105,23 @@ throws_ok( sub { $schema->resultset('Track')->search({}, { join => { cd => 'artist' }, '+columns' => 'artist.name' } )->next; }, - qr|\QCan't inflate manual prefetch into non-existent relationship 'artist' from 'Track', check the inflation specification (columns/as) ending in 'artist.name'|, + qr|\QCan't inflate prefetch into non-existent relationship 'artist' from 'Track', check the inflation specification (columns/as) ending in '...artist.name'|, 'Sensible error message on mis-specified "as"', ); +# check complex limiting prefetch without the join-able columns +{ + my $pref_rs = $schema->resultset('Owners')->search({}, { + rows => 3, + offset => 1, + columns => 'name', # only the owner name, still prefetch all the books + prefetch => 'books', + }); + + lives_ok { + is ($pref_rs->all, 1, 'Expected count of objects on limtied prefetch') + } "Complex limited prefetch works with non-selected join condition"; +} + + done_testing;