| 1 |
use strict; |
| 2 |
use Test::More; |
| 3 |
use Class::DBI::Sweet; |
| 4 |
Class::DBI::Sweet->default_search_attributes({ use_resultset_cache => 0 }); |
| 5 |
Class::DBI::Sweet->cache(Cache::MemoryCache->new( |
| 6 |
{ namespace => "SweetTest", default_expires_in => 60 } ) ); |
| 7 |
|
| 8 |
BEGIN { |
| 9 |
eval "use Cache::MemoryCache"; |
| 10 |
plan skip_all => "needs Cache::Cache for testing" if $@; |
| 11 |
eval "use DBD::SQLite"; |
| 12 |
plan $@ ? (skip_all => 'needs DBD::SQLite for testing') : (tests => 33); |
| 13 |
} |
| 14 |
|
| 15 |
use lib 't/cdbi-t/testlib'; |
| 16 |
use Film; |
| 17 |
|
| 18 |
Film->retrieve_all->delete_all; |
| 19 |
|
| 20 |
my @film = ( |
| 21 |
Film->insert({ Title => 'Film 1' }), |
| 22 |
Film->insert({ Title => 'Film 2' }), |
| 23 |
Film->insert({ Title => 'Film 3' }), |
| 24 |
Film->insert({ Title => 'Film 4' }), |
| 25 |
Film->insert({ Title => 'Film 5' }), |
| 26 |
Film->insert({ Title => 'Film 6' }), |
| 27 |
); |
| 28 |
|
| 29 |
{ |
| 30 |
my $it1 = Film->retrieve_all; |
| 31 |
isa_ok $it1, "Class::DBI::Iterator"; |
| 32 |
|
| 33 |
my $it2 = Film->retrieve_all; |
| 34 |
isa_ok $it2, "Class::DBI::Iterator"; |
| 35 |
|
| 36 |
while (my $from1 = $it1->next) { |
| 37 |
my $from2 = $it2->next; |
| 38 |
is $from1->id, $from2->id, "Both iterators get $from1"; |
| 39 |
} |
| 40 |
} |
| 41 |
|
| 42 |
{ |
| 43 |
my $it = Film->retrieve_all; |
| 44 |
is $it->first->title, "Film 1", "Film 1 first"; |
| 45 |
is $it->next->title, "Film 2", "Film 2 next"; |
| 46 |
is $it->first->title, "Film 1", "First goes back to 1"; |
| 47 |
is $it->next->title, "Film 2", "With 2 still next"; |
| 48 |
$it->reset; |
| 49 |
is $it->next->title, "Film 1", "Reset brings us to film 1 again"; |
| 50 |
is $it->next->title, "Film 2", "And 2 is still next"; |
| 51 |
} |
| 52 |
|
| 53 |
|
| 54 |
{ |
| 55 |
my $it = Film->retrieve_all; |
| 56 |
my @slice = $it->slice(2,4); |
| 57 |
is @slice, 3, "correct slice size (array)"; |
| 58 |
is $slice[0]->title, "Film 3", "Film 3 first"; |
| 59 |
is $slice[2]->title, "Film 5", "Film 5 last"; |
| 60 |
} |
| 61 |
|
| 62 |
{ |
| 63 |
my $it = Film->retrieve_all; |
| 64 |
my $slice = $it->slice(2,4); |
| 65 |
isa_ok $slice, "Class::DBI::Iterator", "slice as iterator"; |
| 66 |
is $slice->count, 3,"correct slice size (array)"; |
| 67 |
is $slice->first->title, "Film 3", "Film 3 first"; |
| 68 |
is $slice->next->title, "Film 4", "Film 4 next"; |
| 69 |
is $slice->first->title, "Film 3", "First goes back to 3"; |
| 70 |
is $slice->next->title, "Film 4", "With 4 still next"; |
| 71 |
$slice->reset; |
| 72 |
is $slice->next->title, "Film 3", "Reset brings us to film 3 again"; |
| 73 |
is $slice->next->title, "Film 4", "And 4 is still next"; |
| 74 |
|
| 75 |
# check if the original iterator still works |
| 76 |
is $it->count, 6, "back to the original iterator, is of right size"; |
| 77 |
is $it->first->title, "Film 1", "Film 1 first"; |
| 78 |
is $it->next->title, "Film 2", "Film 2 next"; |
| 79 |
is $it->first->title, "Film 1", "First goes back to 1"; |
| 80 |
is $it->next->title, "Film 2", "With 2 still next"; |
| 81 |
is $it->next->title, "Film 3", "Film 3 is still in original Iterator"; |
| 82 |
$it->reset; |
| 83 |
is $it->next->title, "Film 1", "Reset brings us to film 1 again"; |
| 84 |
is $it->next->title, "Film 2", "And 2 is still next"; |
| 85 |
} |