| 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__ |