Debian Codegraph @

t/cdbi-t-ocache/05-Query.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 => 20);
13 }
14
15 use lib 't/cdbi-t/testlib';
16 use Film;
17 use Actor;
18 Film->has_many(actors => Actor => { order_by => 'name' });
19 Actor->has_a(Film => 'Film');
20
21 my $film1 = Film->insert({ title => 'Film 1', rating => 'U' });
22 my $film2 = Film->insert({ title => 'Film 2', rating => '15' });
23 my $film3 = Film->insert({ title => 'Film 3', rating => '15' });
24
25 my $act1 = Actor->insert({ name => 'Fred', film => $film1, salary => 1 });
26 my $act2 = Actor->insert({ name => 'Fred', film => $film2, salary => 2 });
27 my $act3 = Actor->insert({ name => 'John', film => $film1, salary => 3 });
28 my $act4 = Actor->insert({ name => 'John', film => $film2, salary => 1 });
29 my $act5 = Actor->insert({ name => 'Pete', film => $film1, salary => 1 });
30 my $act6 = Actor->insert({ name => 'Pete', film => $film3, salary => 1 });
31
32 use Class::DBI::Query;
33 $SIG{__WARN__} = sub {};
34
35 {
36 my @actors = eval {
37 my $query =
38 Class::DBI::Query->new(
39 { owner => 'Actor', where_clause => 'name = "Fred"' });
40 my $sth = $query->run();
41 Actor->sth_to_objects($sth);
42 };
43 is @actors, 2, "** Full where in query";
44 is $@, '', "No errors";
45 isa_ok $actors[0], "Actor";
46 }
47
48 {
49 my @actors = eval {
50 my $query =
51 Class::DBI::Query->new(
52 { owner => 'Actor', where_clause => 'name = ?' });
53 my $sth = $query->run('Fred');
54 Actor->sth_to_objects($sth);
55 };
56 is @actors, 2, "** Placeholder in query";
57 is $@, '', "No errors";
58 isa_ok $actors[0], "Actor";
59 }
60
61 {
62 my @actors = eval {
63 my $query = Class::DBI::Query->new({ owner => 'Actor' });
64 $query->add_restriction('name = ?');
65 my $sth = $query->run('Fred');
66 Actor->sth_to_objects($sth);
67 };
68 is @actors, 2, "** Add restriction";
69 is $@, '', "No errors";
70 isa_ok $actors[0], "Actor";
71 }
72
73 {
74 my @actors = eval {
75 my $query = Class::DBI::Query->new({ owner => 'Actor' });
76 my @tables = qw/Film Actor/;
77 my $film_pri = Film->primary_column;
78 $query->kings(@tables);
79 $query->add_restriction("$tables[1].film = $tables[0].$film_pri");
80 $query->add_restriction('salary = ?');
81 $query->add_restriction('rating = ?');
82 my $sth = $query->run(1, 15);
83 Actor->sth_to_objects($sth);
84 };
85 is @actors, 2, "** Join";
86 is $@, '', "No errors";
87 isa_ok $actors[0], "Actor";
88 }
89
90 { # Normal search
91 my @films = Film->search(rating => 15);
92 is @films, 2, "2 Films with 15 rating";
93 }
94
95 { # Restrict a has_many
96 my @actors = $film1->actors;
97 is @actors, 3, "3 Actors in film 1";
98 my @underpaid = $film1->actors(salary => 1);
99 is @underpaid, 2, "2 of them underpaid";
100 }
101
102 { # Restrict a has_many as class method
103 my @underpaid = Film->actors(salary => 1);
104 my @under2 = Actor->search(salary => 1);
105 is_deeply [ sort map $_->id, @underpaid ], [ sort map $_->id, @under2 ],
106 "Can search on foreign key";
107 }
108
109 { # Fully qualify table names
110 my @actors = Film->actors(salary => 1, rating => 'U');
111 is @actors, 2, "Cross table search";
112 isa_ok $actors[0], "Actor";
113 }
114
115 { # Fully qualify table names
116 my @actors = Film->actors('actor.salary' => 1, 'film.rating' => 'U');
117 is @actors, 2, "Fully qualified tables";
118 isa_ok $actors[0], "Actor";
119 }
120