Debian Codegraph @

t/cdbi-t-ocache/21-iterator.t

raw
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 }