1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
|
use strict;
use warnings;
use Test::More;
use Test::Exception;
use lib qw(t/lib);
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 =>
{
'cd.year' => "2000",
},
{
join => 'tags',
order_by => 'me.trackid',
rows => 1,
}
);
my $use_prefetch = $no_prefetch->search(
{},
{
prefetch => 'tags',
}
);
is($use_prefetch->count, $no_prefetch->count, 'counts with and without prefetch match');
is(
scalar ($use_prefetch->all),
scalar ($no_prefetch->all),
"Amount of returned rows is right"
);
}, 'search_related prefetch with order_by works');
lives_ok ( sub {
my $no_prefetch = $schema->resultset('Track')->search_related(cd =>
{
'cd.year' => "2000",
'tagid' => 1,
},
{
join => 'tags',
rows => 1,
}
);
my $use_prefetch = $no_prefetch->search(
undef,
{
prefetch => 'tags',
}
);
is(
scalar ($use_prefetch->all),
scalar ($no_prefetch->all),
"Amount of returned rows is right"
);
is($use_prefetch->count, $no_prefetch->count, 'counts with and without prefetch match');
}, 'search_related prefetch with condition referencing unqualified column of a joined table works');
lives_ok (sub {
my $rs = $schema->resultset("Artwork")->search(undef, {distinct => 1})
->search_related('artwork_to_artist')->search_related('artist',
undef,
{ prefetch => 'cds' },
);
is($rs->all, 0, 'prefetch without WHERE (objects)');
is($rs->count, 0, 'prefetch without WHERE (count)');
$rs = $schema->resultset("Artwork")->search(undef, {distinct => 1})
->search_related('artwork_to_artist')->search_related('artist',
{ 'cds.title' => 'foo' },
{ prefetch => 'cds' },
);
is($rs->all, 0, 'prefetch with WHERE (objects)');
is($rs->count, 0, 'prefetch with WHERE (count)');
# test where conditions at the root of the related chain
my $artist_rs = $schema->resultset("Artist")->search({artistid => 2});
my $artist = $artist_rs->next;
$artist->create_related ('cds', $_) for (
{
year => 1999, title => 'vague cd', genre => { name => 'vague genre' }
},
{
year => 1999, title => 'vague cd2', genre => { name => 'vague genre' }
},
);
$rs = $artist_rs->search_related('cds')->search_related('genre',
{ 'genre.name' => 'vague genre' },
{ prefetch => 'cds' },
);
is($rs->all, 1, 'base without distinct (objects)');
is($rs->count, 1, 'base without distinct (count)');
# artist -> 2 cds -> 2 genres -> 2 cds for each genre = 4
is($rs->search_related('cds')->all, 4, 'prefetch without distinct (objects)');
is($rs->search_related('cds')->count, 4, 'prefetch without distinct (count)');
$rs = $artist_rs->search_related('cds', {}, { distinct => 1})->search_related('genre',
{ 'genre.name' => 'vague genre' },
);
is($rs->all, 2, 'distinct does not propagate over search_related (objects)');
is($rs->count, 2, 'distinct does not propagate over search_related (count)');
$rs = $rs->search ({}, { distinct => 1} );
is($rs->all, 1, 'distinct without prefetch (objects)');
is($rs->count, 1, 'distinct without prefetch (count)');
$rs = $artist_rs->search_related('cds')->search_related('genre',
{ 'genre.name' => 'vague genre' },
{ prefetch => 'cds', distinct => 1 },
);
is($rs->all, 1, 'distinct with prefetch (objects)');
is($rs->count, 1, 'distinct with prefetch (count)');
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');
done_testing;
|
