X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F67pager.t;h=994cf406b77df4372afbb0fa0c3f74616da1d857;hb=f5f0cb1ddc5bc6b022f08a2cd95201596a5246f0;hp=b7eb2ca9487de434256cf295cba605d06a2db158;hpb=74719352f7e25d81f00de886daa77094ce3289f8;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/t/67pager.t b/t/67pager.t index b7eb2ca..994cf40 100644 --- a/t/67pager.t +++ b/t/67pager.t @@ -1,9 +1,10 @@ +BEGIN { do "./t/lib/ANFANG.pm" or die ( $@ || $! ) } + use strict; use warnings; use Test::More; -use Test::Exception; -use lib qw(t/lib); + use DBICTest; my $schema = DBICTest->init_schema(); @@ -70,12 +71,14 @@ $it = $rs->search( { order_by => 'title', rows => 3 } ); -my $page = $it->page(2); -is( $page->count, 2, "standard resultset paged rs count ok" ); +{ + my $page = $it->page(2); -is( $page->next->title, "Generic Manufactured Singles", "second page of standard resultset ok" ); + is( $page->count, 2, "standard resultset paged rs count ok" ); + is( $page->next->title, "Generic Manufactured Singles", "second page of standard resultset ok" ); +} # test software-based limit paging $it = $rs->search( @@ -111,7 +114,7 @@ $it = $rs->search({}, { }); my $row = $rs->search({}, { - order_by => 'cdid', + order_by => 'cdid', offset => 3, rows => 1 })->single; @@ -186,5 +189,40 @@ $schema->default_resultset_attributes({ rows => 5 }); is($p->(), 5, 'default rows is 5'); +# does serialization work (preserve laziness, while preserving state if exits) +$qcnt = 0; +$it = $rs->search( + {}, + { order_by => 'title', + rows => 5, + page => 2 } +); +$pager = $it->pager; +is ($qcnt, 0, 'No queries on rs/pager creation'); + +# test *requires* it to be Storable +$it = do { + local $DBIx::Class::ResultSourceHandle::thaw_schema = $schema; + Storable::dclone ($it); +}; +is ($qcnt, 0, 'No queries on rs/pager freeze/thaw'); + +is( $it->pager->entries_on_this_page, 1, "entries_on_this_page ok for page 2" ); + +is ($qcnt, 1, 'Count fired to get pager page entries'); + +$rs->create({ title => 'bah', artist => 1, year => 2011 }); + +$qcnt = 0; +# test *requires* it to be Storable +$it = do { + local $DBIx::Class::ResultSourceHandle::thaw_schema = $schema; + Storable::dclone ($it); +}; +is ($qcnt, 0, 'No queries on rs/pager freeze/thaw'); + +is( $it->pager->entries_on_this_page, 1, "entries_on_this_page ok for page 2, even though underlying count changed" ); + +is ($qcnt, 0, 'No count fired on pre-existing total count'); done_testing;