X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fprefetch%2Fvia_search_related.t;h=1942c1421b81dbbc1456327b7ebcd26e9880eef6;hb=4e9fc3f33df616fb7340d05e304ff985b9cce9cb;hp=40f7b8fae0479d997939092e62c0556e121bb066;hpb=1a736efbe47845f6eeccc00059b37172cfc6e441;p=dbsrgits%2FDBIx-Class.git diff --git a/t/prefetch/via_search_related.t b/t/prefetch/via_search_related.t index 40f7b8f..1942c14 100644 --- a/t/prefetch/via_search_related.t +++ b/t/prefetch/via_search_related.t @@ -9,6 +9,10 @@ use DBICTest; my $schema = DBICTest->init_schema(); +my $queries; +my $debugcb = sub { $queries++; }; +my $orig_debug = $schema->storage->debug; + lives_ok ( sub { my $no_prefetch = $schema->resultset('Track')->search_related(cd => { @@ -126,9 +130,19 @@ lives_ok (sub { TODO: { local $TODO = "This makes another 2 trips to the database, it can't be right"; + + $queries = 0; + $schema->storage->debugcb ($debugcb); + $schema->storage->debug (1); + # artist -> 2 cds -> 2 genres -> 2 cds for each genre + distinct = 2 is($rs->search_related('cds')->all, 2, 'prefetched distinct with prefetch (objects)'); is($rs->search_related('cds')->count, 2, 'prefetched distinct with prefetch (count)'); + + is ($queries, 0, 'No extra queries fired (prefetch survives search_related)'); + + $schema->storage->debugcb (undef); + $schema->storage->debug ($orig_debug); } }, 'distinct generally works with prefetch on deep search_related chains');