CouchLike.pm

filter: Statementstmt 8.3% 30 / 359 Branchbran 0.0% 0 / 138 Conditioncond 0.0% 0 / 34 MC/DCmcdc 0.0% 0 / 21 Subroutinesub 20.0% 9 / 45 Podpod 13.6% 3 / 22 totaltotal 6.7% 42 / 619 CC 91 SCAR 43.8
CC
91
Cov
6%
update_views
240.0
view
210.0
_put_multi
156.0
CRAP 79.8
↑ Summary CouchLike/Iterator.pm »
1 package DBIx::CouchLike;
2  
3 1 ▶use 5.8.1;
Subroutine BEGIN: called CC=1 SCAR=0.0
4 1 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
5 1 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
6 1 ▶use Carp;
Subroutine BEGIN: called CC=1 SCAR=0.0
7 1 ▶use JSON 2.0 ();
Subroutine BEGIN: called CC=1 SCAR=0.0
8 1 ▶use UNIVERSAL::require;
Subroutine BEGIN: called CC=1 SCAR=0.0
9 1 ▶use base qw/ Class::Accessor::Fast /;
Subroutine BEGIN: called CC=1 SCAR=0.0
10 1 ▶use DBIx::CouchLike::Iterator;
Subroutine BEGIN: called CC=1 SCAR=0.0
11 1 ▶use DBIx::CouchLike::Sth;
Subroutine BEGIN: called CC=1 SCAR=0.0
12  
13 1 our $VERSION = '0.16';
14 1 our $RD;
15 1 __PACKAGE__->mk_accessors(qw/ dbh table utf8 _json trace versioning /);
16  
17 0 ▶sub new {
Subroutine new: not called CC=4 SCAR=30.0
Pod documented
18 0 my $class = shift;
19 0 my $self = $class->SUPER::new(@_);
20 0 ▶ $self->{utf8} = 1 unless defined $self->{utf8};
Branch: 1 branch
BranchTrueFalseTotal
unless defined $self->{"utf8"} 0 0 0
21  
22 0 $self->{_json} = JSON->new;
23 0 $self->{_json}->utf8( $self->{utf8} );
24 0 ▶ _setup_downgrade() if !$self->{utf8} && !$RD;
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"utf8"} or $DBIx::CouchLike::RD 0 0 0
Condition0%0/3
$self->{"utf8"} or $DBIx::CouchLike::RD
l!l&&r!l&&!r
000
MC/DC0%0/2
$self->{"utf8"} or $DBIx::CouchLike::RD
$self->{"utf8"} $DBIx::CouchLike::RD
Truth table0%0/3
A or B
A= $self->{"utf8"}B= $DBIx::CouchLike::RD
ABresult
1X1
011
000
25 0 $self;
26 }
27  
28 0 ▶sub _setup_downgrade {
Subroutine _setup_downgrade: not called CC=1 SCAR=6.9
29 0 require Unicode::RecursiveDowngrade;
30 0 $RD = Unicode::RecursiveDowngrade->new;
31 $Unicode::RecursiveDowngrade::DowngradeFunc
32 0 ▶ = sub { utf8::downgrade($_[0]); $_[0] };
Subroutine __ANON__: not called CC=1 SCAR=6.9
33 }
34  
35 0 ▶sub utf8 {
Subroutine utf8: not called CC=4 SCAR=30.0
Pod undocumented
36 0 my $self = shift;
37 0 ▶ if (@_) {
Branch: 1 branch
BranchTrueFalseTotal
if (@_) 0 0 0
38 0 $self->{utf8} = shift;
39 0 $self->{_json}->utf8( $self->{utf8} );
40 0 ▶ _setup_downgrade() if !$self->{utf8} && !$RD;
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"utf8"} or $DBIx::CouchLike::RD 0 0 0
Condition0%0/3
$self->{"utf8"} or $DBIx::CouchLike::RD
l!l&&r!l&&!r
000
MC/DC0%0/2
$self->{"utf8"} or $DBIx::CouchLike::RD
$self->{"utf8"} $DBIx::CouchLike::RD
Truth table0%0/3
A or B
A= $self->{"utf8"}B= $DBIx::CouchLike::RD
ABresult
1X1
011
000
41 }
42 0 $self->{utf8};
43 }
44  
45 0 ▶sub to_json {
Subroutine to_json: not called CC=2 SCAR=17.9
Pod undocumented
46 0 my $self = shift;
47 0 my $json = $self->{_json}->encode(shift);
48 0 ▶ utf8::downgrade($json) unless $self->{utf8};
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"utf8"} 0 0 0
49 0 $json;
50 }
51  
52 0 ▶sub from_json {
Subroutine from_json: not called CC=2 SCAR=17.9
Pod undocumented
53 0 my $self = shift;
54 0 my $json = shift;
55 $self->{utf8} ? $self->{_json}->decode($json)
56 0 ▶ : $RD->downgrade( $self->{_json}->decode($json) );
Branch: 1 branch
BranchTrueFalseTotal
$self->{'utf8'} ? : 0 0 0
57 }
58  
59 0 ▶sub id_generator {
Subroutine id_generator: not called CC=4 SCAR=30.0
Pod undocumented
60 0 my $self = shift;
61 0 ▶ if (@_) {
Branch: 1 branch
BranchTrueFalseTotal
if (@_) 0 0 0
62 0 $self->{id_generator} = shift;
63 }
64 0 ▶ $self->{id_generator} ||= do {
Condition0%0/3
$self->{"id_generator"} ||= do { my $gen; eval { do { require Data::YUID::Generator; $gen = "Data::YUID::Generator"->new } }; unless ($gen) { require DBIx::CouchLike::IdGenerator; $gen = "DBIx::CouchLike::IdGenerator"->new; } ; $gen }
l!l&&r!l&&!r
000
MC/DC0%0/2
$self->{"id_generator"} ||= do { my $gen; eval { do { require Data::YUID::Generator; $gen = "Data::YUID::Generator"->new } }; unless ($gen) { require DBIx::CouchLike::IdGenerator; $gen = "DBIx::CouchLike::IdGenerator"->new; } ; $gen }
$self->{"id_generator"} do { my $gen; eval { do { require Data::YUID::Generator; $gen = "Data::YUID::Generator"->new } }; unless ($gen) { require DBIx::CouchLike::IdGenerator; $gen = "DBIx::CouchLike::IdGenerator"->new; } ; $gen }
Truth table0%0/3
A ||= B
A= $self->{"id_generator"}B= do { my $gen; eval { do { require Data::YUID::Generator; $gen = "Data::YUID::Generator"->new } }; unless ($gen) { require DBIx::CouchLike::IdGenerator; $gen = "DBIx::CouchLike::IdGenerator"->new; } ; $gen }
ABresult
1X1
011
000
65 0 my $gen;
66 0 eval {
67 0 require Data::YUID::Generator;
68 0 $gen = Data::YUID::Generator->new;
69 };
70 0 ▶ unless ($gen) {
Branch: 1 branch
BranchTrueFalseTotal
unless ($gen) 0 0 0
71 0 require DBIx::CouchLike::IdGenerator;
72 0 $gen = DBIx::CouchLike::IdGenerator->new;
73 }
74 0 $gen;
75 };
76 }
77  
78 0 ▶sub sub_class {
Subroutine sub_class: not called CC=1 SCAR=6.9
Pod undocumented
79 0 my $self = shift;
80 0 return ref($self) . "::" . $self->dbh->{Driver}->{Name};
81 }
82  
83 0 ▶sub create_table {
Subroutine create_table: not called CC=4 SCAR=30.0
Pod undocumented
84 0 my $self = shift;
85 0 ▶ return if !$self->table or !$self->dbh;
Branch: 1 branch
BranchTrueFalseTotal
unless $self->table and $self->dbh 0 0 0
Condition0%0/3
$self->table and $self->dbh
!ll&&!rl&&r
000
MC/DC0%0/2
$self->table and $self->dbh
$self->table $self->dbh
Truth table0%0/3
A and B
A= $self->tableB= $self->dbh
ABresult
0X0
100
111
86  
87 0 my $sub_class = $self->sub_class;
88 0 eval {
89 0 $sub_class->require;
90 0 $sub_class->create_table( $self->dbh, $self->table, $self->{versioning} );
91 };
92 0 ▶ if ($@) {
Branch: 1 branch
BranchTrueFalseTotal
if ($@) 0 0 0
93 carp( "$@ Unsupported Driver: "
94 . $self->dbh->{Driver}->{Name}
95 0 . " to create_table()"
96 );
97 }
98 0 1;
99 }
100  
101 0 ▶sub prepare_sql {
Subroutine prepare_sql: not called CC=2 SCAR=17.9
Pod undocumented
102 0 my $self = shift;
103 0 my $sql = shift;
104 0 $sql =~ s{_DATA_}{ $self->table . "_data" }eg;
105 0 $sql =~ s{_MAP_}{ $self->table . "_map" }eg;
106 return DBIx::CouchLike::Sth->new({
107 trace => $self->{trace},
108 sth => $self->dbh->prepare($sql),
109 sql => $sql,
110 0 ▶ quote => $self->{trace} ? sub { $self->dbh->quote($_[0]) } : undef,
Subroutine __ANON__: not called CC=1 SCAR=6.9
111 0 ▶ });
Branch: 1 branch
BranchTrueFalseTotal
$self->{'trace'} ? : 0 0 0
112 }
113  
114 0 ▶sub get {
Subroutine get: not called CC=1 SCAR=6.9
Pod documented
115 0 my $self = shift;
116 0 my $id = shift;
117 0 $self->get_multi($id);
118 }
119  
120 0 ▶sub get_multi {
Subroutine get_multi: not called CC=5 SCAR=34.0
Pod undocumented
121 0 my $self = shift;
122 0 my @id = @_;
123 0 my $pf = join(",", map {"?"} @id);
124  
125 0 my $versioning = $self->{versioning};
126 0 ▶ my $sql = $versioning
Branch: 1 branch
BranchTrueFalseTotal
$versioning ? : 0 0 0
127 ? qq{SELECT id, value, version FROM _DATA_ WHERE id IN($pf)}
128 : qq{SELECT id, value FROM _DATA_ WHERE id IN($pf)};
129 0 my $sth = $self->prepare_sql($sql);
130 0 $sth->execute(@id);
131 0 my @res;
132 0 ▶ while ( my $r = $sth->fetchrow_arrayref ) {
Branch: 1 branch
BranchTrueFalseTotal
if (my $r = $sth->fetchrow_arrayref) 0 0 0
133 0 my $res = $self->from_json($r->[1]);
134 0 $res->{_id} = $r->[0];
135 0 ▶ $res->{_version} = $r->[2] if $versioning;
Branch: 1 branch
BranchTrueFalseTotal
if $versioning 0 0 0
136 0 push @res, $res;
137 }
138 0 ▶ return wantarray ? @res : $res[0];
Branch: 1 branch
BranchTrueFalseTotal
wantarray ? : 0 0 0
139 }
140  
141 0 ▶sub post {
Subroutine post: not called CC=3 SCAR=24.8
Pod undocumented
142 0 my $self = shift;
143 my ( $id, $value_ref )
144 0 ▶ = ref $_[0] ? ( delete $_[0]->{_id} || $self->id_generator->get_id, $_[0] )
Branch: 1 branch
BranchTrueFalseTotal
ref $_[0] ? : 0 0 0
Condition0%0/3
delete $_[0]{"_id"} or $self->id_generator->get_id
l!l&&r!l&&!r
000
MC/DC0%0/2
delete $_[0]{"_id"} or $self->id_generator->get_id
delete $_[0]{"_id"} $self->id_generator->get_id
Truth table0%0/3
A or B
A= delete $_[0]{"_id"}B= $self->id_generator->get_id
ABresult
1X1
011
000
145 : ( $_[0], $_[1] );
146 0 $value_ref->{_id} = $id;
147 0 $self->post_multi($value_ref);
148 }
149  
150 0 ▶sub post_multi {
Subroutine post_multi: not called CC=1 SCAR=6.9
Pod undocumented
151 0 my $self = shift;
152 0 $self->_post_multi([], @_);
153 }
154  
155 0 ▶sub _post_multi {
Subroutine _post_multi: not called CC=9 SCAR=45.0
156 0 my $self = shift;
157 0 my $views = shift;
158 0 my @value_ref = @_;
159 0 my $versioning = $self->{versioning};
160 0 ▶ my $sql = $versioning
Branch: 1 branch
BranchTrueFalseTotal
$versioning ? : 0 0 0
161 ? q{INSERT INTO _DATA_ (id, value, version) VALUES(?, ?, ?)}
162 : q{INSERT INTO _DATA_ (id, value) VALUES(?, ?)};
163 0 my $sth = $self->prepare_sql($sql);
164 0 my @id;
165 0 for my $value_ref (@value_ref) {
166 0 ▶ my $id = delete($value_ref->{_id}) || $self->id_generator->get_id;
Condition0%0/3
delete $value_ref->{'_id'} || $self->id_generator->get_id
l!l&&r!l&&!r
000
MC/DC0%0/2
delete $value_ref->{'_id'} || $self->id_generator->get_id
delete $value_ref->{'_id'} $self->id_generator->get_id
Truth table0%0/3
A || B
A= delete $value_ref->{'_id'}B= $self->id_generator->get_id
ABresult
1X1
011
000
167 0 ▶ my $version = $versioning ? ( $value_ref->{_version} ||= 0 ) : undef;
Branch: 1 branch
BranchTrueFalseTotal
$versioning ? : 0 0 0
Condition0%0/2
$value_ref->{"_version"} ||= 0
l!l
00
MC/DC0%0/1
$value_ref->{"_version"} ||= 0
$value_ref->{"_version"}
Truth table0%0/2
A
A= $value_ref->{"_version"}
Aresult
11
00
168 0 my $json = $self->to_json($value_ref);
169 0 my @param = ($id, $json);
170 0 ▶ push @param, $version if $versioning;
Branch: 1 branch
BranchTrueFalseTotal
if $versioning 0 0 0
171 0 $sth->execute(@param);
172  
173 0 $value_ref->{_id} = $id;
174 0 ▶ $value_ref->{_version} = $version if $versioning;
Branch: 1 branch
BranchTrueFalseTotal
if $versioning 0 0 0
175 0 push @id, $id;
176 }
177 0 $self->update_views( $views, @value_ref );
178 0 ▶ return wantarray ? @id : $id[0];
Branch: 1 branch
BranchTrueFalseTotal
wantarray ? : 0 0 0
179 }
180  
181 0 ▶sub put {
Subroutine put: not called CC=2 SCAR=17.9
Pod undocumented
182 0 my $self = shift;
183 my ( $id, $value_ref )
184 0 ▶ = ref $_[0] ? ( delete $_[0]->{_id}, $_[0] )
Branch: 1 branch
BranchTrueFalseTotal
ref $_[0] ? : 0 0 0
185 : ( $_[0], $_[1] );
186 0 $value_ref->{_id} = $id;
187 0 $self->put_multi($value_ref);
188 }
189  
190 0 ▶sub put_multi {
Subroutine put_multi: not called CC=1 SCAR=6.9
Pod undocumented
191 0 my $self = shift;
192 0 $self->_put_multi([], @_);
193 }
194  
195 0 ▶sub put_with_views {
Subroutine put_with_views: not called CC=1 SCAR=6.9
Pod undocumented
196 0 my $self = shift;
197 0 my @views = map { "_design/$_" } @_;
198 0 ▶ sub {
Subroutine __ANON__: not called CC=1 SCAR=6.9
199 0 $self->_put_multi(\@views, @_);
200 0 };
201 }
202  
203 0 ▶sub _put_multi {
Subroutine _put_multi: not called CC=12 SCAR=50.5
204 0 my $self = shift;
205 0 my $views = shift;
206 0 my @value_ref = @_;
207 0 my $versioning = $self->{versioning};
208 0 ▶ my $sql = $versioning
Branch: 1 branch
BranchTrueFalseTotal
$versioning ? : 0 0 0
209 ? q{UPDATE _DATA_ SET value=?, version=version+1 WHERE id=? AND version=?}
210 : q{UPDATE _DATA_ SET value=? WHERE id=?};
211 0 my $sth = $self->prepare_sql($sql);
212  
213 0 my @post;
214 my @put;
215 0 my @id;
216 0 for my $value_ref (@value_ref) {
217 0 my $id = delete $value_ref->{_id};
218 0 my $put = defined $value_ref->{_version};
219 0 ▶ my $version = $versioning ? ($value_ref->{_version} ||= 0) : undef;
Branch: 1 branch
BranchTrueFalseTotal
$versioning ? : 0 0 0
Condition0%0/2
$value_ref->{"_version"} ||= 0
l!l
00
MC/DC0%0/1
$value_ref->{"_version"} ||= 0
$value_ref->{"_version"}
Truth table0%0/2
A
A= $value_ref->{"_version"}
Aresult
11
00
220 0 my $json = $self->to_json($value_ref);
221  
222 0 $value_ref->{_id} = $id;
223 0 my @param = ($json, $id);
224 0 ▶ push @param, $version if $versioning;
Branch: 1 branch
BranchTrueFalseTotal
if $versioning 0 0 0
225 0 my $r = $sth->execute(@param);
226 0 ▶ if ( $r == 0 ) {
Branch: 1 branch
BranchTrueFalseTotal
if ($r == 0) { } 0 0 0
227 0 ▶ if ($versioning && $put) {
Branch: 1 branch
BranchTrueFalseTotal
if ($versioning and $put) { } 0 0 0
Condition0%0/3
$versioning and $put
!ll&&!rl&&r
000
MC/DC0%0/2
$versioning and $put
$versioning $put
Truth table0%0/3
A and B
A= $versioningB= $put
ABresult
0X0
100
111
228 0 croak("Can't put id: $id, version: $version");
229 }
230 else {
231 0 push @post, $value_ref;
232 }
233 }
234 else {
235 0 push @id, $id;
236 0 push @put, $value_ref;
237 }
238 }
239 0 my @new_id;
240 0 ▶ @new_id = $self->post_multi(@post) if @post;
Branch: 1 branch
BranchTrueFalseTotal
if @post 0 0 0
241 0 $self->update_views( $views, @put );
242 0 ▶ return wantarray ? (@id, @new_id) : $id[0] || $new_id[0];
Branch: 1 branch
BranchTrueFalseTotal
wantarray ? : 0 0 0
Condition0%0/3
$id[0] or $new_id[0]
l!l&&r!l&&!r
000
MC/DC0%0/2
$id[0] or $new_id[0]
$id[0] $new_id[0]
Truth table0%0/3
A or B
A= $id[0]B= $new_id[0]
ABresult
1X1
011
000
243 }
244  
245 0 ▶sub delete {
Subroutine delete: not called CC=2 SCAR=17.9
Pod undocumented
246 0 my $self = shift;
247 0 my $id = shift;
248 0 my $sth = $self->prepare_sql(q{DELETE FROM _DATA_ WHERE id=?});
249 0 my $res = $sth->execute($id);
250  
251 0 ▶ if ( $id =~ qr{^_design/} ) {
Branch: 1 branch
BranchTrueFalseTotal
if ($id =~ qr"^_design/") { } 0 0 0
252 0 my ($part, @value) = $self->_start_with( design_id => $id );
253 0 my $del_sth = $self->prepare_sql(
254 q{DELETE FROM _MAP_ WHERE } . $part
255 );
256 0 $del_sth->execute(@value);
257 }
258 else {
259 0 my $del_sth = $self->prepare_sql(
260 q{DELETE FROM _MAP_ WHERE id=?}
261 );
262 0 $del_sth->execute($id);
263 };
264 0 return $res;
265 }
266  
267 0 ▶sub view {
Subroutine view: not called CC=14 SCAR=53.5
Pod documented
268 0 my $self = shift;
269 0 my $target = shift;
270 0 ▶ my $query = shift || {};
Condition0%0/2
shift() || {}
l!l
00
MC/DC0%0/1
shift() || {}
shift()
Truth table0%0/2
A
A= shift()
Aresult
11
00
271  
272 0 ▶ $target = "_design/$target"
Branch: 1 branch
BranchTrueFalseTotal
unless $target =~ qr"^_design/" 0 0 0
273 unless $target =~ qr{^_design/};
274  
275 0 my ( undef, $design_id, $name ) = split "/", $target;
276 0 ▶ my $design = $self->get("_design/$design_id")
Branch: 1 branch
BranchTrueFalseTotal
my $design = $self->get("_design/$design_id") or return 0 0 0
277 or return;
278  
279 0 my @param = ($target);
280 0 my $sql = q{
281 SELECT m.id, m.key, m.value _COL_
282 FROM _MAP_ AS m _JOIN_
283 WHERE m.design_id=?};
284 0 ▶ if ( exists $query->{key} ) {
Branch: 3 branches
BranchTrueFalseTotal
if (exists $query->{'key'}) { } 0 0 0
elsif (exists $query->{'key_like'}) { } 0 0 0
elsif (exists $query->{'key_start_with'}) { } 0 0 0
285 0 ▶ if ( ref $query->{key} eq 'ARRAY' ) {
Branch: 3 branches
BranchTrueFalseTotal
if (ref $query->{'key'} eq 'ARRAY') { } 0 0 0
elsif (ref $query->{'key'} eq 'HASH') { } 0 0 0
elsif (ref $query->{'key'} eq 'SCALAR') { } 0 0 0
286 $sql .= " AND m.key IN ("
287 0 . join(",", map { "?" } @{ $query->{key} })
288 . ")";
289 0 push @param, @{ $query->{key} };
290 }
291 elsif ( ref $query->{key} eq 'HASH' ) {
292 0 my %k = %{ $query->{key} };
293 0 $sql .= sprintf " AND m.key %s ? ", (keys %k)[0];
294 0 push @param, (values %k)[0];
295 }
296 elsif ( ref $query->{key} eq 'SCALAR' ) {
297 0 $sql .= sprintf " AND m.key %s", ${ $query->{key} };
298 }
299 else {
300 0 $sql .= q{ AND m.key=? };
301 0 push @param, $query->{key};
302 }
303 }
304 elsif ( exists $query->{key_like} ) {
305 0 $sql .= q{ AND m.key LIKE ? };
306 0 push @param, $query->{key_like};
307 }
308 elsif ( exists $query->{key_start_with} ) {
309 my ($part, @value)
310 0 = $self->_start_with("m.key" => $query->{key_start_with});
311 0 $sql .= q{ AND } . $part;
312 0 push @param, @value;
313 }
314  
315 0 ▶ if ( $query->{include_docs} ) {
Branch: 1 branch
BranchTrueFalseTotal
if ($query->{'include_docs'}) { } 0 0 0
316 0 $sql =~ s{_COL_}{, d.value};
317 0 $sql =~ s{_JOIN_}{JOIN _DATA_ AS d USING(id)};
318 }
319 else {
320 0 $sql =~ s{(?:_COL_|_JOIN_)}{}g;
321 }
322  
323 $sql .= sprintf(
324 " ORDER BY m.key %s, m.value %s, m.id ",
325 $query->{key_reverse} ? "DESC" : "",
326 0 ▶ $query->{value_reverse} ? "DESC" : "",
Branch: 2 branches
BranchTrueFalseTotal
$query->{'key_reverse'} ? : 0 0 0
$query->{'value_reverse'} ? : 0 0 0
327 );
328  
329 0 $sql = $self->_offset_limit_sql( $sql, $query, \@param );
330  
331 0 my $sth = $self->prepare_sql($sql);
332 0 $sth->execute(@param);
333  
334 my $itr = DBIx::CouchLike::Iterator->new({
335 sth => $sth,
336 query => $query,
337 reduce => $design->{views}->{$name}->{reduce},
338 0 couch => $self,
339 });
340 0 ▶ return wantarray ? $itr->all()
Branch: 1 branch
BranchTrueFalseTotal
wantarray ? : 0 0 0
341 : $itr;
342 }
343  
344 0 ▶sub all_designs {
Subroutine all_designs: not called CC=2 SCAR=17.9
Pod undocumented
345 0 my $self = shift;
346  
347 0 my $sql = "SELECT id, NULL, value FROM _DATA_ WHERE ";
348 0 my ($part, @value) = $self->_start_with( id => "_design/" );
349 0 $sql .= $part . " ORDER BY id";
350  
351 0 my $sth = $self->prepare_sql($sql);
352 0 $sth->execute(@value);
353  
354 0 my $itr = DBIx::CouchLike::Iterator->new({
355 sth => $sth,
356 query => {},
357 couch => $self,
358 });
359 0 ▶ return wantarray ? $itr->all()
Branch: 1 branch
BranchTrueFalseTotal
wantarray ? : 0 0 0
360 : $itr;
361 }
362  
363 0 ▶sub all {
Subroutine all: not called CC=8 SCAR=42.8
Pod undocumented
364 0 my $self = shift;
365 0 ▶ my $query = shift || {};
Condition0%0/2
shift() || {}
l!l
00
MC/DC0%0/1
shift() || {}
shift()
Truth table0%0/2
A
A= shift()
Aresult
11
00
366  
367 0 my @param;
368 0 my $sql = q{SELECT id, NULL, value FROM _DATA_};
369 0 ▶ if ($query->{id_like}) {
Branch: 4 branches
BranchTrueFalseTotal
if ($query->{'id_like'}) { } 0 0 0
elsif ($query->{'id_start_with'}) { } 0 0 0
elsif ($query->{'id_in'}) { } 0 0 0
elsif ($query->{'exclude_designs'}) { } 0 0 0
370 0 $sql .= " WHERE id LIKE ?";
371 0 push @param, $query->{id_like};
372 }
373 elsif ($query->{id_start_with}) {
374 my ($part, @value)
375 0 = $self->_start_with( id => $query->{id_start_with} );
376 0 $sql .= " WHERE $part";
377 0 push @param, @value;
378 }
379 elsif ($query->{id_in}) {
380 0 my @id = @{ $query->{id_in} };
381 0 $sql .= " WHERE id IN (" . join(",", map { "?" } @id) . ")";
382 0 push @param, @id;
383 }
384 elsif ($query->{exclude_designs}) {
385 0 my ($part, @value) = $self->_start_with( id => "_design/" );
386 0 $sql .= " WHERE NOT $part";
387 0 push @param, @value;
388 }
389  
390 0 $sql .= " ORDER BY id";
391 0 ▶ $sql .= " DESC" if $query->{reverse};
Branch: 1 branch
BranchTrueFalseTotal
if $query->{"reverse"} 0 0 0
392  
393 0 $sql = $self->_offset_limit_sql( $sql, $query, \@param );
394 0 my $sth = $self->prepare_sql($sql);
395 0 $sth->execute(@param);
396  
397 0 my $itr = DBIx::CouchLike::Iterator->new({
398 sth => $sth,
399 query => $query,
400 couch => $self,
401 });
402 0 ▶ return wantarray ? $itr->all()
Branch: 1 branch
BranchTrueFalseTotal
wantarray ? : 0 0 0
403 : $itr;
404 }
405  
406 0 ▶sub post_with_views {
Subroutine post_with_views: not called CC=1 SCAR=6.9
Pod undocumented
407 0 my $self = shift;
408 0 my @views = map { "_design/$_" } @_;
409 0 ▶ sub {
Subroutine __ANON__: not called CC=1 SCAR=6.9
410 0 $self->_post_multi(\@views, @_);
411 0 };
412 }
413  
414 0 ▶sub _start_with {
Subroutine _start_with: not called CC=1 SCAR=6.9
415 0 my $self = shift;
416 0 my $sub_class = $self->sub_class;
417 0 $sub_class->require;
418 0 $sub_class->_start_with(@_);
419 }
420  
421 0 ▶sub _offset_limit_sql {
Subroutine _offset_limit_sql: not called CC=3 SCAR=24.8
422 0 my $self = shift;
423  
424 0 my $sub;
425 0 ▶ if ( $sub = $self->{_offset_limit_sql_sub} ) {
Branch: 1 branch
BranchTrueFalseTotal
if ($sub = $self->{"_offset_limit_sql_sub"}) 0 0 0
426 0 return $sub->(@_);
427 }
428 0 my $sub_class = $self->sub_class;
429 0 eval {
430 0 $sub_class->require;
431 0 ▶ $sub = $self->{_offset_limit_sql_sub} = sub {
Subroutine __ANON__: not called CC=1 SCAR=6.9
432 0 $sub_class->_offset_limit_sql(@_);
433 0 };
434 };
435 0 ▶ if ( $sub ) {
Branch: 1 branch
BranchTrueFalseTotal
if ($sub) 0 0 0
436 0 return $sub->(@_);
437 }
438  
439 carp( "Unsupported Driver: "
440 . $self->dbh->{Driver}->{Name}
441 0 . " for using limit/offset"
442 );
443 }
444  
445 0 ▶sub _select_all {
Subroutine _select_all: not called CC=4 SCAR=30.0
446 0 my $self = shift;
447 0 my $sub = shift;
448 0 my $sth = $self->prepare_sql(q{SELECT id, value FROM _DATA_});
449 0 $sth->execute();
450 0 ▶ while ( my $r = $sth->fetchrow_arrayref ) {
Branch: 1 branch
BranchTrueFalseTotal
if (my $r = $sth->fetchrow_arrayref) 0 0 0
451 0 ▶ next if $r->[0] =~ qr{^_design/};
Branch: 1 branch
BranchTrueFalseTotal
if $r->[0] =~ qr"^_design/" 0 0 0
452 0 my $id = $r->[0];
453 0 my $value_ref = $self->from_json($r->[1]);
454 0 $value_ref->{_id} = $id;
455 0 ▶ $sub->( $id, $value_ref ) if $sub;
Branch: 1 branch
BranchTrueFalseTotal
if $sub 0 0 0
456 }
457 }
458  
459 0 ▶sub create_view {
Subroutine create_view: not called CC=5 SCAR=34.0
Pod undocumented
460 0 my $self = shift;
461 0 my $design_val = shift;
462 0 my $dbh = $self->dbh;
463  
464 0 my $design_id = delete $design_val->{_id};
465  
466 0 my ($part, @value) = $self->_start_with( design_id => $design_id );
467 0 my $del_sth = $self->prepare_sql(
468 q{DELETE FROM _MAP_ WHERE } . $part
469 );
470 0 $del_sth->execute(@value);
471 0 $design_val->{_id} = $design_id;
472  
473 0 ▶ my $views = $design_val->{views} or return 1;
Branch: 1 branch
BranchTrueFalseTotal
my $views = $design_val->{"views"} or return 1 0 0 0
474 0 my $index_sth = $self->prepare_sql(
475 q{INSERT INTO _MAP_ (design_id, id, key, value) VALUES (?,?,?,?)}
476 );
477  
478 VIEW:
479 0 for my $name ( keys %$views ) {
480 0 ▶ my $code = $views->{$name}->{map} or next VIEW;
Branch: 1 branch
BranchTrueFalseTotal
my $code = $views->{$name}{"map"} or next VIEW 0 0 0
481 0 my $sub = eval $code; ## no critic
482 0 ▶ if ($@) {
Branch: 1 branch
BranchTrueFalseTotal
if ($@) 0 0 0
483 0 warn $@;
484 0 next VIEW;
485 }
486 $self->_select_all(
487 0 ▶ sub {
Subroutine __ANON__: not called CC=1 SCAR=6.9
488 0 $self->_data_to_map({
489 sub => $sub,
490 id => $_[0],
491 data_val => $_[1],
492 sth => $index_sth,
493 design_id => "$design_id/$name",
494 });
495 }
496 0 );
497 }
498 0 return 1;
499 }
500  
501 0 ▶sub update_views {
Subroutine update_views: not called CC=15 SCAR=54.8
Pod undocumented
502 0 my $self = shift;
503 0 my $dbh = $self->dbh;
504 0 ▶ my $views = shift || [];
Condition0%0/2
shift() || []
l!l
00
MC/DC0%0/1
shift() || []
shift()
Truth table0%0/2
A
A= shift()
Aresult
11
00
505 0 my @views = @$views;
506  
507 0 my @data_val;
508 my @id;
509 0 for my $data_val (@_) {
510 0 ▶ if ( $data_val->{_id} =~ qr{^_design/} ) {
Branch: 1 branch
BranchTrueFalseTotal
if ($data_val->{'_id'} =~ qr"^_design/") { } 0 0 0
511 0 $self->create_view( $data_val );
512 }
513 else {
514 0 push @data_val, $data_val;
515 0 push @id, $data_val->{_id};
516 }
517 }
518 0 ▶ return 1 unless @data_val;
Branch: 1 branch
BranchTrueFalseTotal
unless @data_val 0 0 0
519  
520 0 my $pf = join(",", map {"?"} @id);
521 0 ▶ my $df = @views ? join(",", map {"?"} @views) : "";
Branch: 1 branch
BranchTrueFalseTotal
@views ? : 0 0 0
522  
523 0 ▶ if (@views) {
Branch: 1 branch
BranchTrueFalseTotal
if (@views) { } 0 0 0
524 0 my $del_sql = qq{DELETE FROM _MAP_ WHERE id IN ($pf)};
525 0 my @value;
526 my @cond;
527 0 for my $v (@views) {
528 0 my ($part, @v) = $self->_start_with( design_id => $v );
529 0 push @cond, $part;
530 0 push @value, @v;
531 }
532 0 $del_sql .= " AND (" . join(" OR ", @cond). ")";
533 0 $self->prepare_sql($del_sql)
534 ->execute(@id, @value);
535 }
536 else {
537 0 $self->prepare_sql(qq{DELETE FROM _MAP_ WHERE id IN ($pf)})
538 ->execute(@id);
539 }
540  
541 0 my $index_sth = $self->prepare_sql(
542 q{INSERT INTO _MAP_ (design_id, id, key, value) VALUES (?,?,?,?)}
543 );
544  
545 0 my $sth;
546 0 ▶ if (@views) {
Branch: 1 branch
BranchTrueFalseTotal
if (@views) { } 0 0 0
547 0 $sth = $self->prepare_sql(
548 qq{SELECT id, value FROM _DATA_ WHERE id IN($df)}
549 );
550 0 $sth->execute(@views);
551 }
552 else {
553 0 my ($part, @value) = $self->_start_with( id => '_design/' );
554 0 $sth = $self->prepare_sql(
555 q{SELECT id, value FROM _DATA_ WHERE } . $part
556 );
557 0 $sth->execute(@value);
558 }
559  
560 DESIGN:
561 0 ▶ while ( my $r = $sth->fetchrow_arrayref ) {
Branch: 1 branch
BranchTrueFalseTotal
if (my $r = $sth->fetchrow_arrayref) 0 0 0
562 0 my $design_id = $r->[0];
563 0 my $val = $self->from_json($r->[1]);
564 0 ▶ my $views = $val->{views} or next DESIGN;
Branch: 1 branch
BranchTrueFalseTotal
my $views = $val->{"views"} or next DESIGN 0 0 0
565  
566 VIEW:
567 0 for my $name ( keys %$views ) {
568 0 ▶ my $code = $views->{$name}->{map} or next VIEW;
Branch: 1 branch
BranchTrueFalseTotal
my $code = $views->{$name}{"map"} or next VIEW 0 0 0
569 0 my $sub = eval $code; ## no critic
570 0 ▶ if ($@) {
Branch: 1 branch
BranchTrueFalseTotal
if ($@) 0 0 0
571 0 warn $@;
572 0 next VIEW;
573 }
574 0 for my $data_val (@data_val) {
575 $self->_data_to_map({
576 sub => $sub,
577 id => $data_val->{_id},
578 0 data_val => $data_val,
579 sth => $index_sth,
580 design_id => "$design_id/$name",
581 });
582 }
583 }
584 }
585 0 return 1;
586 }
587  
588 0 ▶sub _data_to_map {
Subroutine _data_to_map: not called CC=4 SCAR=30.0
589 0 my $self = shift;
590 0 my $args = shift;
591  
592 0 my @pair;
593 0 ▶ my $emit = sub {
Subroutine __ANON__: not called CC=2 SCAR=17.9
594 0 my ( $k, $v ) = @_;
595 0 ▶ push @pair, [
Branch: 1 branch
BranchTrueFalseTotal
ref $v ? : 0 0 0
596 $k,
597 ref $v ? $self->to_json($v) : $v,
598 ];
599 0 };
600 0 eval { $args->{sub}->( $args->{data_val}, $emit ) };
601 0 ▶ if ($@) {
Branch: 1 branch
BranchTrueFalseTotal
if ($@) 0 0 0
602 0 warn $@;
603 0 return;
604 }
605 PAIR:
606 0 for my $p (@pair) {
607 0 ▶ next PAIR unless defined $p->[0];
Branch: 1 branch
BranchTrueFalseTotal
unless defined $p->[0] 0 0 0
608 $args->{sth}->execute(
609 $args->{design_id}, $args->{id},
610 0 $p->[0], $p->[1],
611 );
612 }
613 }
614  
615  
616 1 1;
617 __END__
↑ Summary CouchLike/Iterator.pm »