Mysql/Util.pm

filter: Statementstmt 20.0% 15 / 75 Branchbran 4.3% 2 / 46 Conditioncond n/a MC/DCmcdc n/a Subroutinesub 50.0% 3 / 6 Podpod 50.0% 1 / 2 totaltotal 16.2% 21 / 129 CC 24 SCAR 53.8
CC
24
Cov
14%
find_monotonic_first
342.0
lookup
30.0
import
3.3
CRAP 217.9
↑ Summary Mysql/Replication.pm »
1 package Mojar::Mysql::Util;
2 1 ▶use Mojo::Base -strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
3  
4 1 our $VERSION = 0.011;
5  
6 1 require Carp;
7  
8 1 ▶sub import {
Subroutine import: called CC=3 SCAR=12.0
9 1 my $caller = caller;
10 1 my %want = map {$_ => 1} @_;
11  
12 1 ▶ no strict 'refs';
Subroutine BEGIN: called CC=1 SCAR=0.0
13 0 *{"${caller}::find_monotonic_first"} = \&find_monotonic_first
14 1 ▶ if $want{find_monotonic_first};
Branch: 1 branch
BranchTrueFalseTotal
if $want{"find_monotonic_first"} 0 1 1
15  
16 # Need a closure for lookup => cannot use Exporter
17 0 ▶ *{"${caller}::lookup"} = sub { lookup($caller, @_) } if $want{lookup};
Subroutine __ANON__: not called CC=1 SCAR=2.0
Branch: 1 branch
BranchTrueFalseTotal
if $want{"lookup"} 0 1 1
18 }
19  
20 1 our $FindRangeSize = 200;
21  
22 0 ▶sub find_monotonic_first {
Subroutine find_monotonic_first: not called CC=18 SCAR=58.3
Pod documented
23 0 my ($dbh, $schema, $table, $column, $condition) = @_;
24 0 ▶ Carp::croak $column .'Missing required condition' unless defined $condition;
Branch: 1 branch
BranchTrueFalseTotal
unless defined $condition 0 0 0
25 0 my $debug = $ENV{MOJAR_MYSQL_UTIL_DEBUG};
26  
27 0 my ($min, $max) = $dbh->selectrow_array(sprintf
28 q{SELECT MIN(%s), MAX(%s)
29 FROM %s.%s},
30 $column, $column,
31 $schema, $table
32 );
33  
34 0 ▶ if (ref $condition eq 'CODE') {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $condition eq 'CODE') { } 0 0 0
35 # Perl callback
36 0 my $sth_row = $dbh->prepare(sprintf
37 q{SELECT *
38 FROM %s.%s
39 WHERE %s = ?},
40 $schema, $table,
41 $column
42 );
43  
44 0 my $row;
45 0 do {
46 # Check minimum
47 0 $row = $dbh->selectrow_hashref($sth_row, undef, $min);
48 0 ▶ return $min if $condition->($row);
Branch: 1 branch
BranchTrueFalseTotal
if &$condition($row) 0 0 0
49  
50 # Check maximum
51 0 $row = $dbh->selectrow_hashref($sth_row, undef, $max);
52 0 ▶ return undef unless $condition->($row); # Problem with data
Branch: 1 branch
BranchTrueFalseTotal
unless &$condition($row) 0 0 0
53  
54 # Check range
55 0 ▶ if ($max - $min <= $FindRangeSize) {
Branch: 1 branch
BranchTrueFalseTotal
if ($max - $min <= $Mojar::Mysql::Util::FindRangeSize) 0 0 0
56 0 my $candidate = $min;
57 0 ▶ do {
Branch: 1 branch
BranchTrueFalseTotal
&$condition($row) or do { do { ($candidate) = $dbh->selectrow_array(sprintf("SELECT MIN(%s)\nFROM %s.%s\nWHERE ? < %s", $column, $schema, $table, $column), undef, $candidate); $row = $dbh->selectrow_hashref($sth_row, undef, $candidate) } } 0 0 0
58 0 ($candidate) = $dbh->selectrow_array(sprintf(
59 q{SELECT MIN(%s)
60 FROM %s.%s
61 WHERE ? < %s},
62 $column,
63 $schema, $table,
64 $column),
65 undef,
66 $candidate
67 );
68 0 $row = $dbh->selectrow_hashref($sth_row, undef, $candidate);
69 } until $condition->($row);
70 0 return $candidate;
71 }
72  
73 # Calculate new
74 # First find mean
75 0 my $new = $min + int( ($max - $min) / 2 + 0.1 );
76 # then find first record after that...
77 0 my ($candidate) = $dbh->selectrow_array(sprintf(
78 q{SELECT MIN(%s)
79 FROM %s.%s
80 WHERE ? <= %s},
81 $column,
82 $schema, $table,
83 $column),
84 undef,
85 $new
86 );
87 0 ▶ if ($candidate >= $max) {
Branch: 1 branch
BranchTrueFalseTotal
if ($candidate >= $max) 0 0 0
88 # ...or before that
89 0 ($candidate) = $dbh->selectrow_array(sprintf(
90 q{SELECT MAX(%s)
91 FROM %s.%s
92 WHERE %s <= ?},
93 $column,
94 $schema, $table,
95 $column),
96 undef,
97 $new
98 );
99 0 ▶ return undef if $candidate <= $min; # Problem with data
Branch: 1 branch
BranchTrueFalseTotal
if $candidate <= $min 0 0 0
100 }
101 0 $new = $candidate;
102 # $min < $candidate < $max
103  
104 0 $row = $dbh->selectrow_hashref($sth_row, undef, $new);
105 0 ▶ if ($condition->($row)) {
Branch: 1 branch
BranchTrueFalseTotal
if (&$condition($row)) { } 0 0 0
106 0 $max = $new;
107 }
108 else {
109 0 $min = $new;
110 }
111 0 ▶ warn $min, ' : ', $max if $debug;
Branch: 1 branch
BranchTrueFalseTotal
if $debug 0 0 0
112 } while 1;
113 }
114  
115 else {
116 # SQL where-clause
117 0 my $sth_row = $dbh->prepare(sprintf
118 q{SELECT COUNT(*)
119 FROM %s.%s
120 WHERE %s = ?
121 AND (%s)},
122 $schema, $table,
123 $column,
124 $condition
125 );
126 0 my $sth_range = $dbh->prepare(sprintf
127 q{SELECT MIN(%s)
128 FROM %s.%s
129 WHERE ? <= %s
130 AND %s <= ?
131 AND (%s)},
132 $column,
133 $schema, $table,
134 $column,
135 $column,
136 $condition
137 );
138  
139 # Brute force (for demos)
140 # return $dbh->selectrow_arrayref($sth_range, undef, $min, $max)->[0];
141  
142 0 my $satisfied;
143 0 do {
144 # Check range
145 0 ▶ if ($max - $min <= $FindRangeSize) {
Branch: 1 branch
BranchTrueFalseTotal
if ($max - $min <= $Mojar::Mysql::Util::FindRangeSize) 0 0 0
146 0 my ($solution) = $dbh->selectrow_array($sth_range, undef, $min, $max);
147 0 return $solution;
148 }
149  
150 # Check minimum
151 0 ($satisfied) = $dbh->selectrow_array($sth_row, undef, $min);
152 0 ▶ return $min if $satisfied;
Branch: 1 branch
BranchTrueFalseTotal
if $satisfied 0 0 0
153  
154 # Check maximum
155 0 ($satisfied) = $dbh->selectrow_array($sth_row, undef, $max);
156 0 ▶ return undef unless $satisfied; # Problem with data
Branch: 1 branch
BranchTrueFalseTotal
unless $satisfied 0 0 0
157  
158 # Calculate new
159 # First find mean
160 0 my $new = $min + int( ($max - $min) / 2 + 0.1 );
161 # then find first record after that...
162 0 my ($candidate) = $dbh->selectrow_array(sprintf(
163 q{SELECT MIN(%s)
164 FROM %s.%s
165 WHERE ? <= %s},
166 $column,
167 $schema, $table,
168 $column),
169 undef,
170 $new
171 );
172 0 ▶ if ($candidate >= $max) {
Branch: 1 branch
BranchTrueFalseTotal
if ($candidate >= $max) 0 0 0
173 # ...or before that
174 0 ($candidate) = $dbh->selectrow_array(sprintf(
175 q{SELECT MAX(%s)
176 FROM %s.%s
177 WHERE %s <= ?},
178 $column,
179 $schema, $table,
180 $column),
181 undef,
182 $new
183 );
184 0 ▶ return undef if $candidate <= $min; # Problem with data
Branch: 1 branch
BranchTrueFalseTotal
if $candidate <= $min 0 0 0
185 }
186 0 $new = $candidate;
187 # $min < $candidate < $max
188  
189 0 ($satisfied) = $dbh->selectrow_array($sth_row, undef, $new);
190 0 ▶ if ($satisfied) {
Branch: 1 branch
BranchTrueFalseTotal
if ($satisfied) { } 0 0 0
191 0 $max = $new;
192 }
193 else {
194 0 $min = $new;
195 }
196 0 ▶ warn $min, ' : ', $max if $debug;
Branch: 1 branch
BranchTrueFalseTotal
if $debug 0 0 0
197 } while 1;
198 }
199 }
200  
201 0 ▶sub lookup {
Subroutine lookup: not called CC=5 SCAR=34.0
Pod undocumented
202 0 my ($class, $name, $schema, $table, $key_col, $value_col) = @_;
203 0 ▶ Carp::croak 'Wrong number of args' unless @_ == 6;
Branch: 1 branch
BranchTrueFalseTotal
unless @_ == 6 0 0 0
204 0 ▶ Carp::croak qq{Lookup '$name' invalid} unless $name =~ /^[a-zA-Z_]\w*$/;
Branch: 1 branch
BranchTrueFalseTotal
unless $name =~ /^[a-zA-Z_]\w*$/u 0 0 0
205  
206 0 my $code = <<EOT;
207 package $class;
208 sub $name {
209 my \$dbh = shift;
210 if (\@_ == 1) {
211 return \$dbh->selectrow_arrayref(
212 q{SELECT $value_col
213 FROM ${schema}.$table
214 WHERE $key_col = ?},
215 undef,
216 \$_[0]
217 )->[0];
218 }
219 \$dbh->do(
220 q{REPLACE INTO ${schema}.$table
221 SET $value_col = ?
222 WHERE $key_col = ?},
223 undef,
224 \$_[1], \$_[0]
225 );
226 return;
227 }
228 EOT
229 0 ▶ warn "-- Lookup $name in $class\n$code\n\n" if $ENV{MOJAR_MYSQL_UTIL_DEBUG};
Branch: 1 branch
BranchTrueFalseTotal
if $ENV{"MOJAR_MYSQL_UTIL_DEBUG"} 0 0 0
230 0 ▶ Carp::croak "Mojar::Mysql::Util error: $@" unless eval "$code;1";
Branch: 1 branch
BranchTrueFalseTotal
unless eval "$code;1" 0 0 0
231 }
232  
233 1 1;
234 __END__
↑ Summary Mysql/Replication.pm »