blib/lib/DBIx/Class/Helper/SimpleStats.pm

filter: Statementstmt 98.1% 52 / 53 Branchbran 70.0% 7 / 10 Conditioncond 100% 2 / 2 MC/DCmcdc 100% 1 / 1 Subroutinesub 100% 10 / 10 Podpod 100% 1 / 1 totaltotal 94.8% 73 / 77 CC 8 SCAR 12.8
CC
8
Cov
94%
simple_stats
7.0
__ANON__
2.0
BEGIN
1.0
CRAP 3.6
↑ Summary
1 package DBIx::Class::Helper::SimpleStats;
2  
3 # ABSTRACT: Simple grouping and aggregate functions for DBIx::Class
4  
5 1 ▶use v5.10.1;
Subroutine BEGIN: called CC=1 SCAR=0.0
6  
7 1 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
8 1 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
9  
10 1 ▶use base qw( DBIx::Class );
Subroutine BEGIN: called CC=1 SCAR=0.0
11  
12 1 ▶use Carp;
Subroutine BEGIN: called CC=1 SCAR=0.0
13 1 ▶use List::Util 1.45 qw/ uniqstr /;
Subroutine BEGIN: called CC=1 SCAR=0.0
14 1 ▶use Ref::Util qw/ is_plain_hashref is_ref /;
Subroutine BEGIN: called CC=1 SCAR=0.0
15  
16 # RECOMMEND PREREQ: Ref::Util::XS
17  
18 1 ▶use namespace::clean;
Subroutine BEGIN: called CC=1 SCAR=0.0
19  
20 1 our $VERSION = 'v0.1.3';
21  
22  
23  
24 6 ▶sub simple_stats {
Subroutine simple_stats: called CC=7 SCAR=19.5
Pod documented
25 6 my ( $self, @args ) = @_;
26  
27 6 ▶ croak "No columns" unless @args;
Branch: 1 branch
BranchTrueFalseTotal
unless @args 0 6 6
28  
29 6 my @cols;
30 my @funcs;
31  
32 6 my $me = $self->current_source_alias;
33  
34 20 ▶ my $alias = sub {
Subroutine __ANON__: called CC=2 SCAR=7.1
35 20 my $ident = shift;
36 20 ▶ $ident = "$me.$ident" unless $ident =~ /^(\w+)\./;
Branch: 1 branch
BranchTrueFalseTotal
unless $ident =~ /^(\w+)\./ 20 0 20
37 20 return $ident;
38 6 };
39  
40 6 foreach my $arg (@args) {
41  
42 11 ▶ if ( is_ref($arg) ) {
Branch: 1 branch
BranchTrueFalseTotal
if (Ref::Util::XS::is_ref($arg)) { } 7 4 11
43  
44 7 ▶ if ( is_plain_hashref($arg) ) {
Branch: 1 branch
BranchTrueFalseTotal
if (Ref::Util::XS::is_plain_hashref($arg)) { } 7 0 7
45  
46 7 my $as = delete $arg->{'-as'};
47 7 my ( $func, $col ) = each %{$arg};
48  
49 7 ▶ $as //= "${col}_${func}";
Condition100%2/2
$as //= "${col}_$func"
l!l
16
MC/DC100%1/1
$as //= "${col}_$func"
$as
Truth table100%2/2
A
A= $as
Aresult
11
00
50  
51 7 push @cols, $alias->($col);
52  
53 7 push @funcs, { $func => $alias->($col), -as => $as };
54  
55 }
56 else {
57  
58 0 croak "Unsupported reference type: " . ref($arg);
59  
60 }
61  
62 }
63 else {
64  
65 4 push @cols, $alias->($arg);
66  
67 }
68  
69 }
70  
71 6 ▶ unless (@funcs) {
Branch: 1 branch
BranchTrueFalseTotal
unless (@funcs) 2 4 6
72  
73 2 my $func = "count";
74 2 my $col = $cols[0];
75 2 $col =~ s/^\w+\.// ;
76  
77 2 push @funcs, { $func => $alias->($col), -as => "${col}_${func}" };
78  
79 }
80  
81 6 my @names = map { delete $_->{'-as'} } @funcs;
82  
83 6 my @group = uniqstr @cols;
84  
85 6 return $self->search(
86 undef,
87 {
88 group_by => \@group,
89 select => [ @group, @funcs ],
90 as => [ @group, @names ],
91 order_by => \@group,
92 }
93 );
94  
95 }
96  
97  
98  
99  
100 1 1;
101  
102 __END__
↑ Summary