DBomb/GluedQuery.pm

filter: Statementstmt 86.6% 13 / 15 Branchbran n/a Conditioncond n/a MC/DCmcdc n/a Subroutinesub 100% 5 / 5 Podpod n/a totaltotal 90.0% 18 / 20 CC 1 SCAR 0.6
CC
1
Cov
87%
BEGIN
1.3
BEGIN
1.0
BEGIN
1.0
CRAP 1.1
« DBomb/Query/Delete.pm ↑ Summary DBomb/Base/Defs.pm »
1 package DBomb::GluedQuery;
2  
3 =head1 NAME
4  
5 DBomb::GluedQuery - A query that is glued to a DBomb meta object by primary key.
6  
7 =cut
8  
9 8 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
10 8 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
11 our $VERSION = '$Revision: 1.13 $';
12  
13 8 ▶use Carp::Assert;
Subroutine BEGIN: called CC=1 SCAR=0.0
14 8 ▶use Carp qw(carp croak);
Subroutine BEGIN: called CC=1 SCAR=0.0
15 0 ▶use DBomb;
Subroutine BEGIN: called CC=1 SCAR=2.6
16 use DBomb::Value::Key;
17 use base qw(DBomb::Query);
18 use Class::MethodMaker
19 'get_set' => [ qw(columns_list), # [ column_info, ... ]
20 qw(peer), # a DBomb::Base object
21 qw(primary_key_idx), # [ index, index ]
22 ],
23 ;
24  
25 ## new DBomb::GluedQuery($dbh,$columns_list)
26 ## new DBomb::GluedQuery($dbh,$peer,$columns_list)
27 ## new DBomb::GluedQuery($peer,$columns_list)
28 ## new DBomb::GluedQuery($columns_list)
29 sub init
30 {
31 my $self = shift;
32 my $columns;
33 $self->columns_list([]);
34 $self->primary_key_idx([]);
35  
36 ## First argument might be a dbh or peer object
37 for(@_){
38  
39 if (UNIVERSAL::isa($_,'DBI::db')){
40 $self->dbh($_);
41 }
42 elsif (UNIVERSAL::isa($_,'DBomb::Base')){
43 $self->peer($_);
44 }
45 elsif (UNIVERSAL::isa($_, 'ARRAY')){
46 $columns = $_;
47 }
48 else{
49 croak "invalid paramter to GluedQuery->new()";
50 }
51 }
52  
53 ## verify args
54 assert(defined($columns), 'GluedQuery requires a [columns_list]');
55 assert(UNIVERSAL::isa($columns,'ARRAY'), 'GluedQuery requires a [columns_list]');
56 for(@$columns){
57 assert(UNIVERSAL::isa($_,'DBomb::Meta::ColumnInfo'), 'GluedQuery requires columninfo objs')
58 }
59  
60 ## Save the indexes of the primary key columns.
61 my %unseen_pk_columns = map { $_->name => $_ } @{$columns->[0]->table_info->primary_key->columns_list};
62 for my $i (0..$#$columns) {
63 if ( $columns->[$i]->is_in_primary_key ){
64 push @{$self->primary_key_idx}, $i;
65 delete $unseen_pk_columns{$columns->[$i]->name};
66 }
67 }
68  
69 ## Add the primary key columns that were not in the column list.
70 ## Only do this for peerless queries
71 if (not defined $self->peer){
72  
73 for (values %unseen_pk_columns){
74 push @$columns, $_;
75 push @{$self->primary_key_idx}, $#$columns;
76 }
77 }
78  
79  
80 for (@$columns){
81 push @{$self->columns_list}, $_;
82 }
83  
84 $self->SUPER::init(map {$_->fq_name} @{$self->columns_list});
85  
86 }
87  
88 sub from
89 {
90 my ($self, $table_info) = @_;
91 assert(UNIVERSAL::isa($table_info,'DBomb::Meta::TableInfo'), 'valid parameters');
92 return $self->SUPER::from($table_info->name);
93 }
94  
95 sub join { die "not implemented" }
96 sub on { die "not implemented" }
97 sub right_join { die "not implemented" }
98 sub left_join { die "not implemented" }
99  
100  
101 sub fetchrow_arrayref
102 {
103 my $self = shift;
104 return $self->SUPER::fetchrow_arrayref(@_);
105 }
106  
107 sub fetchall_arrayref
108 {
109 my $self = shift;
110 my $a = [];
111 while (my $obj = $self->fetchrow_objectref){
112 push @$a, $obj;
113 }
114 return $a;
115 }
116  
117 sub fetch
118 {
119 fetchrow_objectref(@_);
120 }
121  
122 sub fetchrow_objectref
123 {
124 my $self = shift;
125  
126 my $row = $self->SUPER::fetchrow_arrayref;
127 return undef unless $row && @$row;
128  
129 my $columns = $self->columns_list;
130 my $tinfo = $columns->[0]->table_info;
131 my $class = $tinfo->class;
132  
133 my $obj = $self->peer;
134  
135 if (not $obj) {
136  
137 # pluck the primary keys first.
138 my $pkv = new DBomb::Value::Key($tinfo->primary_key,
139 [ map { $row->[$_] } @{$self->primary_key_idx} ]);
140  
141 $obj = $class->new($pkv);
142 $obj->dbh($self->dbh);
143 }
144  
145 assert($obj, 'has a peer, or, PK is in query');
146  
147 my $values = $obj->_dbo_values;
148 for my $i (0..$#$row){
149 next if $columns->[$i]->is_in_primary_key; # skip pks.
150  
151 #my $accessor = $columns->[$i]->accessor;
152 #$obj->$accessor($row->[$i]);
153 $values->{$columns->[$i]->name}->set_value_from_select($row->[$i]);
154 }
155  
156 return $obj;
157 }
158  
159 ## selectall_arrayref()
160 ## selectall_arrayref($dbh,@bind_values)
161 ## selectall_arrayref(@bind_values)
162 sub selectall_arrayref
163 {
164 my $self = shift;
165 my (@bind_values) = @_;
166 my $dbh = $self->dbh;
167  
168 if (UNIVERSAL::isa($bind_values[0],'DBI::db')){
169 $dbh = $self->dbh(shift @bind_values);
170 }
171  
172 assert(defined($dbh), 'selectall_arrayref requires a $dbh');
173  
174 $self->prepare($dbh);
175 $self->execute(@bind_values);
176 return $self->fetchall_arrayref;
177 }
178  
179  
180 1;
181 __END__
« DBomb/Query/Delete.pm ↑ Summary DBomb/Base/Defs.pm »