Simplish/Result.pm untested

filter: Statementstmt 0.0% 0 / 111 Branchbran 0.0% 0 / 42 Conditioncond 0.0% 0 / 2 MC/DCmcdc n/a Subroutinesub 0.0% 0 / 24 Podpod 0.0% 0 / 19 totaltotal 0.0% 0 / 198 SCAR 62.3
CC
22
Cov
0%
objects
42.0
object
20.0
kv_list
12.0
CRAP 506.0
1 package DBIx::Simplish::Result;
2  
3 # ABSTRACT: A result of a L<DBIx::Simplish> query.
4  
5 use Moo;
6 use Types::Standard qw/InstanceOf Bool/;
7 use List::MoreUtils qw/zip/;
8 use Carp qw/croak/;
9 use Class::Load qw/load_class/;
10  
11 our $VERSION = '1.000_001'; # TRIAL VERSION
12  
13 has _sth => (
14 is => 'ro',
15 required => 1,
16 init_arg => 'sth',
17 isa => InstanceOf['DBI::st'],
18 handles => {
19 _row_array => 'fetchrow_arrayref',
20 _row_hash => 'fetchrow_hashref',
21 _all_array => 'fetchall_arrayref',
22 _bind_cols => 'bind_columns',
23 attr => 'attr',
24 rows => 'rows',
25 func => 'func',
26 fetch => 'fetch',
27 finish => 'finish',
28 },
29 );
30 has lc_columns => (
31 is => 'ro',
32 isa => Bool,
33 required => 1,
34 );
35  
36 sub _col_case {
37 my $self = shift;
38 return $self->lc_columns ? 'NAME_lc' : 'NAME';
39 }
40  
41 sub columns {
42 my $self = shift;
43 my $columns = $self->_sth->{$self->_col_case};
44 return wantarray ? @{$columns} : $columns;
45 };
46  
47 sub bind { ## no critic (RequireArgUnpacking, ProhibitBuiltinHomonyms)
48 my $self = shift;
49 return $self->_bind_cols(\@_[0..$#_]);
50 }
51  
52 sub into { ## no critic (RequireArgUnpacking)
53 my $self = shift;
54 $self->_bind_cols(\@_[0..$#_]);
55 return $self->fetch;
56 }
57  
58 sub list {
59 my $self = shift;
60 my $list = $self->_row_array || [];
61 return wantarray ? @{$list} : $list->[-1];
62 }
63  
64 sub hash {
65 my $self = shift;
66 return $self->_row_hash($self->_col_case);
67 }
68  
69 sub array {
70 goto &_row_array;
71 }
72  
73 sub kv_list {
74 my $self = shift;
75 return unless my @row = $self->list;
76 my @columns = $self->columns;
77 my @kv_list = zip(@columns, @row);
78 return wantarray ? @kv_list : \@kv_list;
79 }
80  
81 sub kv_array {
82 my $self = shift;
83 return scalar $self->kv_list
84 }
85  
86 sub object {
87 my ($self, $class, @args) = @_;
88 $class = __PACKAGE__ . ":$class" if $class =~ /^:/;
89 load_class($class);
90 if ($class->can('new_from_dbix_simpler')) {
91 return scalar $class->new_from_dbix_simpler($self, @args)
92 } elsif ($class->can('new')) {
93 return $class->new($self->kv_list);
94 } else {
95 croak(q/Can't locate object method "new_from_dbix_simpler" or "new"/);
96 }
97 }
98  
99 sub flat {
100 my $self = shift;
101 my @flat = map {@{$_}} $self->arrays;
102 return wantarray ? @flat : \@flat;
103 }
104  
105 sub arrays {
106 my $self = shift;
107 my $arrays = $self->_all_array;
108 return wantarray ? @{$arrays} : $arrays;
109 }
110  
111 sub hashes {
112 my $self = shift;
113 my @hashes;
114 while (my $hash = $self->hash) {
115 push @hashes, $hash;
116 }
117 return wantarray ? @hashes : \@hashes;
118 }
119  
120 sub kv_flat {
121 my $self = shift;
122 my @flat = map {@{$_}} $self->kv_arrays;
123 return wantarray ? @flat : \@flat;
124 }
125  
126 sub kv_arrays {
127 my $self = shift;
128 my @arrays;
129 while (my $array = $self->kv_array) {
130 push @arrays, $array;
131 }
132 return wantarray ? @arrays : \@arrays;
133 }
134  
135 sub objects {
136 my ($self, $class, @args) = @_;
137 $class = __PACKAGE__ . ":$class" if $class =~ /^:/;
138 load_class($class);
139 if ($class->can('new_from_dbix_simpler')) {
140 my @objects = $class->new_from_dbix_simpler($self, @args);
141 return wantarray ? @objects : \@objects;
142 } elsif ($class->can('new')) {
143 my @objects = map {$class->new(@{$_})} $self->kv_arrays;
144 return wantarray ? @objects : \@objects;
145 } else {
146 croak(q/Can't locate object method "new_from_dbix_simpler" or "new"/);
147 }
148 }
149  
150 sub map_arrays {
151 my ($self, $col_num) = @_;
152 my %map;
153 while (my @array = $self->list) {
154 my ($key) = splice @array, $col_num, 1;
155 $map{$key} = \@array;
156 }
157 return wantarray ? %map : \%map;
158 }
159  
160 sub map_hashes {
161 my ($self, $col_name) = @_;
162 my %map;
163 while (my $map = $self->hash) {
164 my $key = delete $map->{$col_name};
165 $map{$key} = $map;
166 }
167 return wantarray ? %map : \%map;
168 }
169  
170  
171 sub map { ## no critic (ProhibitBuiltinHomonyms)
172 my $self = shift;
173 my %map = map {@{$_}} @{$self->_all_array([0, 1])};
174 return wantarray ? %map : \%map;
175 }
176  
177 1;
178  
179 __END__