EV/Storage.pm

filter: Statementstmt 97.2% 639 / 657 Branchbran 79.0% 234 / 296 Conditioncond 66.5% 175 / 263 MC/DCmcdc 40.4% 59 / 146 Subroutinesub 99.1% 116 / 117 Podpod 100% 8 / 8 totaltotal 82.7% 1231 / 1487 CC 247 SCAR 21.3
CC
247
Cov
86%
connect_info
25.7
_mysql_broker_connect_info
20.4
__ANON__
20.0
CRAP 8.4
« EV/ConnectInfo.pm ↑ Summary EV/QueryExecutor.pm »
1 package DBIO::MySQL::EV::Storage;
2 # ABSTRACT: Async MySQL/MariaDB storage driver using EV::MariaDB
3  
4 48 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
5 48 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
6  
7 48 our $VERSION = '0.900007';
8  
9 48 ▶use base 'DBIO::Storage::Async';
Subroutine BEGIN: called CC=1 SCAR=0.0
10  
11 48 ▶use Carp 'croak';
Subroutine BEGIN: called CC=1 SCAR=0.0
12 48 ▶use Scalar::Util ();
Subroutine BEGIN: called CC=1 SCAR=0.0
13 48 ▶use DBIO::Util ();
Subroutine BEGIN: called CC=1 SCAR=0.0
14 48 ▶use DBIO::Carp;
Subroutine BEGIN: called CC=1 SCAR=0.0
15 48 ▶use DBIO::MySQL::SQLMaker;
Subroutine BEGIN: called CC=1 SCAR=0.0
16 48 ▶use DBIO::MySQL::DDL ();
Subroutine BEGIN: called CC=1 SCAR=0.0
17 48 ▶use DBIO::MySQL::Identifier ();
Subroutine BEGIN: called CC=1 SCAR=0.0
18 48 ▶use DBIO::MySQL::NotifyTable;
Subroutine BEGIN: called CC=1 SCAR=0.0
19 48 ▶use DBIO::MySQL::Util ();
Subroutine BEGIN: called CC=1 SCAR=0.0
20 48 ▶use DBIO::MySQL::EV::ConnectInfo ();
Subroutine BEGIN: called CC=1 SCAR=0.0
21 48 ▶use DBIO::MySQL::EV::Future;
Subroutine BEGIN: called CC=1 SCAR=0.0
22 48 ▶use DBIO::MySQL::EV::Pool;
Subroutine BEGIN: called CC=1 SCAR=0.0
23 48 ▶use DBIO::MySQL::EV::QueryExecutor;
Subroutine BEGIN: called CC=1 SCAR=0.0
24 48 ▶use DBIO::MySQL::EV::TransactionContext;
Subroutine BEGIN: called CC=1 SCAR=0.0
25 48 ▶use namespace::clean;
Subroutine BEGIN: called CC=1 SCAR=0.0
26  
27  
28 # --- SQLMaker seams -----------------------------------------------------------
29 # The inherited DBIO::Storage::Async::sql_maker builds the maker from these.
30  
31  
32 153 ▶sub sql_maker_class { 'DBIO::MySQL::SQLMaker' }
Subroutine sql_maker_class: called CC=1 SCAR=0.0
Pod documented
33  
34  
35 152 ▶sub _sql_maker_args {
Subroutine _sql_maker_args: called CC=1 SCAR=0.0
36 return (
37 152 quote_char => '`',
38 name_sep => '.',
39 );
40 }
41  
42  
43 1 ▶sub _post_insert_sql { '' }
Subroutine _post_insert_sql: called CC=1 SCAR=0.0
44  
45  
46 2451 ▶sub future_class { 'DBIO::MySQL::EV::Future' }
Subroutine future_class: called CC=1 SCAR=0.0
Pod documented
47  
48  
49 156 ▶sub transport_capabilities {
Subroutine transport_capabilities: called CC=1 SCAR=0.0
Pod documented
50 156 qw(on_connect_replay listen notify broker_connect_options)
51 }
52  
53 # --- LISTEN / NOTIFY configuration --------------------------------------------
54  
55  
56  
57 48 __PACKAGE__->mk_group_accessors(inherited => qw(
58 notify_table notify_poll_interval notify_lookback notify_retention
59 rollback_wait_timeout
60 ));
61 48 __PACKAGE__->rollback_wait_timeout(30);
62 {
63 48 my %defaults = DBIO::MySQL::NotifyTable->defaults;
64 48 __PACKAGE__->notify_table($defaults{table});
65 48 __PACKAGE__->notify_poll_interval($defaults{poll_interval});
66 48 __PACKAGE__->notify_lookback($defaults{lookback});
67 48 __PACKAGE__->notify_retention($defaults{retention});
68 }
69  
70  
71 366 ▶sub connect_info {
Subroutine connect_info: called CC=25 SCAR=32.5
Pod documented
72 366 my ($self, $info) = @_;
73 366 ▶ if ($info) {
Branch: 1 branch
BranchTrueFalseTotal
if ($info) 357 9 366
74 # Embedded path: the sync storage feeds its own DBI-form connect_info
75 # (['dbi:MariaDB:...', $user, $pass, \%attrs]). Translate it into the async
76 # [ \%conninfo, \%opts ] shape before the normal broker/normalize logic, so
77 # EV::MariaDB gets named params instead of a DSN string it cannot parse.
78 357 ▶ if (ref $info eq 'ARRAY' && defined $info->[0] && !ref $info->[0] && $info->[0] =~ /^dbi:/i) {
Branch: 2 branches
BranchTrueFalseTotal
if (ref $info eq 'ARRAY' and defined $info->[0] and not ref $info->[0] and $info->[0] =~ /^dbi:/i) { } 31 326 357
elsif (ref $info eq 'ARRAY' and @$info == 1 and ref $info->[0] eq 'HASH' and not builtin::blessed($info->[0]) and defined $info->[0]{'dsn'} and not exists $info->[0]{'dbh_maker'}) { } 4 644 648
Condition55%5/9
ref $info eq "ARRAY" and defined $info->[0] and not ref $info->[0] and $info->[0] =~ /^dbi:/i
!ll&&!rl&&r
326031
ref $info eq "ARRAY" and defined $info->[0] and not ref $info->[0]
!ll&&!rl&&r
032631
ref $info eq "ARRAY" and defined $info->[0]
!ll&&!rl&&r
00357
MC/DC25%1/4
ref $info eq "ARRAY" and defined $info->[0] and not ref $info->[0] and $info->[0] =~ /^dbi:/i
ref $info eq "ARRAY" defined $info->[0] not ref $info->[0] $info->[0] =~ /^dbi:/i
Truth table40%2/5
A and B and not(C) and D
A= ref $info eq "ARRAY"B= defined $info->[0]C= not ref $info->[0]D= $info->[0] =~ /^dbi:/i
ABCDresult
0XXX0
10XX0
110X0
11100
11111
79 31 $info = DBIO::MySQL::EV::ConnectInfo::dbi_to_conninfo($info);
80 }
81 # The single-hash form { dsn, user, password, pool_size, <attributes> }
82 # (karr k79), read as the owning sync storage reads it: every key but those
83 # and a nested attrs hash is a connect attribute. dsn and async never reach
84 # EV::MariaDB->new. A blessed hash is a broker; a hash with a dbh_maker is
85 # not a DSN's.
86 ▶ elsif (ref $info eq 'ARRAY' && @$info == 1 && ref $info->[0] eq 'HASH'
Condition80%12/15
ref $info eq "ARRAY" and @$info == 1 and ref $info->[0] eq "HASH" and not builtin::blessed($info->[0]) and defined $info->[0]{"dsn"} and not exists $info->[0]{"dbh_maker"}
!ll&&!rl&&r
32204
ref $info eq "ARRAY" and @$info == 1 and ref $info->[0] eq "HASH" and not builtin::blessed($info->[0]) and defined $info->[0]{"dsn"}
!ll&&!rl&&r
289334
ref $info eq "ARRAY" and @$info == 1 and ref $info->[0] eq "HASH" and not builtin::blessed($info->[0])
!ll&&!rl&&r
289037
ref $info eq "ARRAY" and @$info == 1 and ref $info->[0] eq "HASH"
!ll&&!rl&&r
2058437
ref $info eq "ARRAY" and @$info == 1
!ll&&!rl&&r
0205121
MC/DC50%3/6
ref $info eq "ARRAY" and @$info == 1 and ref $info->[0] eq "HASH" and not builtin::blessed($info->[0]) and defined $info->[0]{"dsn"} and not exists $info->[0]{"dbh_maker"}
ref $info eq "ARRAY" @$info == 1 ref $info->[0] eq "HASH" not builtin::blessed($info->[0]) defined $info->[0]{"dsn"} not exists $info->[0]{"dbh_maker"}
Truth table57%4/7
A and B and C and not(D) and E and not(F)
A= ref $info eq "ARRAY"B= @$info == 1C= ref $info->[0] eq "HASH"D= not builtin::blessed($info->[0])E= defined $info->[0]{"dsn"}F= not exists $info->[0]{"dbh_maker"}
ABCDEFresult
0XXXXX0
10XXXX0
110XXX0
1110XX0
11110X0
1111100
1111111
87 && !Scalar::Util::blessed($info->[0]) && defined $info->[0]{dsn}
88 && !exists $info->[0]{dbh_maker}) {
89 4 my %h = %{ $info->[0] };
90 4 my ($dsn, $user, $pass) = delete @h{qw( dsn user password )};
91 4 my $nested = delete $h{attrs};
92 4 ▶ $info = DBIO::MySQL::EV::ConnectInfo::dbi_to_conninfo([
Branch: 1 branch
BranchTrueFalseTotal
ref $nested eq 'HASH' ? : 1 3 4
93 $dsn, $user, $pass, { %h, ref $nested eq 'HASH' ? %$nested : () },
94 ]);
95 }
96 # A truthy connect_info setter always opens a new ownership generation
97 # (ADR 0045 section 4). disconnect performs the token rotation when a pool
98 # or a listen connection exists; without either we still rotate here,
99 # exactly as the inherited base connect_info does, so a context from the
100 # old generation cannot survive reconfiguration. The listen connection goes
101 # through disconnect too: it was opened with the old connect info and would
102 # go on running with it (karr k65, core k90).
103 349 ▶ if ($self->{pool} || $self->{_listen}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'pool'} or $self->{'_listen'}) { } 15 334 349
Condition100%3/3
$self->{"pool"} or $self->{"_listen"}
l!l&&r!l&&!r
132334
MC/DC100%2/2
$self->{"pool"} or $self->{"_listen"}
$self->{"pool"} $self->{"_listen"}
Truth table100%3/3
A or B
A= $self->{"pool"}B= $self->{"_listen"}
ABresult
1X1
011
000
104 15 $self->disconnect;
105 }
106 else {
107 334 $self->_rotate_context_owner_token;
108 }
109 # [ $broker, \%options ]: the connect options the owning sync storage was
110 # given beside the broker, handed on because this transport declares
111 # broker_connect_options (core k243, karr k59). Read as core's connect_info
112 # reads them: what the owner applies itself (async, the storage and SQL
113 # maker options) is stripped, the rest is split into pool_size and the DBD
114 # attributes. Undef for every other form, which is left as it came.
115 349 my $stripped = $self->_strip_private_connect_attrs($info);
116 349 my $beside = $self->_access_broker_call_options($stripped);
117 347 ▶ $info = $stripped if $beside;
Branch: 1 branch
BranchTrueFalseTotal
if $beside 81 266 347
118  
119 347 $self->{connect_info} = $info;
120  
121 347 ▶ if ($beside || $self->_is_access_broker_connect_info($info)) {
Branch: 1 branch
BranchTrueFalseTotal
if ($beside or $self->_is_access_broker_connect_info($info)) { } 165 182 347
Condition100%3/3
$beside or $self->_is_access_broker_connect_info($info)
l!l&&r!l&&!r
8184182
MC/DC100%2/2
$beside or $self->_is_access_broker_connect_info($info)
$beside $self->_is_access_broker_connect_info($info)
Truth table100%3/3
A or B
A= $besideB= $self->_is_access_broker_connect_info($info)
ABresult
1X1
011
000
122 165 $self->_setup_access_broker($info->[0]);
123 # No conninfo is kept with a broker attached, as in core's connect_info
124 # (core k252): every connection asks the broker anew (_conninfo_provider),
125 # so a stored copy could only ever be this earlier answer -- password
126 # included -- which nothing may use. Dropped before the answer is read:
127 # a refused answer must not leave the connect info of before in place.
128 165 $self->{_conninfo} = undef;
129 # What stands beside the broker, kept where core's accessor answers for
130 # it and never applied: this transport drops DBD attributes, as
131 # dbi_to_conninfo does for a DSN. A connection parameter among them is
132 # not dropped but refused (karr k78) -- here, before the broker is asked,
133 # and for every connection after (_async_broker_conninfo), which is why
134 # they are kept before anything can throw: a storage whose connect_info
135 # was refused opens no connection without the parameter.
136 165 ▶ $self->{_access_broker_call_attributes} = $beside ? $beside->{attributes} : {};
Branch: 1 branch
BranchTrueFalseTotal
$beside ? : 81 84 165
137 165 $self->_mysql_refuse_parameters_beside_broker;
138 129 my $answer = $self->_current_async_connect_info($self->access_broker_mode);
139 129 my (undef, $pool_size, $opts) = $self->_normalize_async_connect_info(
140 $self->_mysql_broker_connect_info($answer)
141 );
142 # One rule for the pool size wherever it is given -- the answer's hash,
143 # slot [3] or [4] of a DBI-form answer, beside the broker; the answer and
144 # the options beside the broker must agree, or this throws (core k245).
145 111 my $given_pool_size = $self->_access_broker_pool_size($answer, $beside);
146 104 ▶ $pool_size = $given_pool_size if defined $given_pool_size;
Branch: 1 branch
BranchTrueFalseTotal
if defined $given_pool_size 35 69 104
147 104 $self->{_pool_size} = $pool_size;
148 104 $self->{_opts} = $opts;
149 }
150 else {
151 182 $self->_clear_access_broker;
152 182 my ($conninfo, $pool_size, $opts) = $self->_normalize_async_connect_info($info);
153 # A whole DSN as the database name of a hash (karr k80): no DSN is read
154 # out of a hash, so it would be the name of the database and the host it
155 # names would not be given. The refusal of the broker's answer, for the
156 # connect info given directly; nothing of the DSN is said, it may carry
157 # a password.
158 croak 'MySQL ev cannot connect from the connect info: '
159 . $self->_mysql_describe_shape(ref $info->[0] eq 'HASH' ? $info->[0] : $info)
160 . ' whose database name is a whole DBI DSN -- a hash is read as '
161 . 'EV::MariaDB parameters and no DSN is read out of one. Give the DSN '
162 . 'as the connect info itself ([ $dsn, $user, $password ] or '
163 . '{ dsn => $dsn, user => ..., password => ... }), or the database '
164 . 'name as dbname with host and port beside it'
165 if ref $conninfo eq 'HASH'
166 182 ▶ && grep { defined($_) && !ref($_) && /^dbi:/i } map { $conninfo->{$_} } qw( database db );
Branch: 2 branches
BranchTrueFalseTotal
if ref $conninfo eq "HASH" and grep {defined $_ and not ref $_ and /^dbi:/i;} map({$conninfo->{$_};} "database", "db") 3 179 182
ref $info->[0] eq 'HASH' ? : 3 0 3
Condition77%7/9
ref $conninfo eq "HASH" and grep {defined $_ and not ref $_ and /^dbi:/i;} map({$conninfo->{$_};} "database", "db")
!ll&&!rl&&r
01793
defined $_ && !ref($_) && /^dbi:/i
!ll&&!rl&&r
1831783
defined $_ and not ref $_
!ll&&!rl&&r
1830181
MC/DC50%1/2
ref $conninfo eq "HASH" and grep {defined $_ and not ref $_ and /^dbi:/i;} map({$conninfo->{$_};} "database", "db")
ref $conninfo eq "HASH" grep {defined $_ and not ref $_ and /^dbi:/i;} map({$conninfo->{$_};} "database", "db")
MC/DC66%2/3
defined $_ && !ref($_) && /^dbi:/i
defined $_ not ref $_ /^dbi:/i
Truth table66%2/3
A and B
A= ref $conninfo eq "HASH"B= grep {defined $_ and not ref $_ and /^dbi:/i;} map({$conninfo->{$_};} "database", "db")
ABresult
0X0
100
111
Truth table75%3/4
A and not(B) && C
A= defined $_B= not ref $_C= /^dbi:/i
ABCresult
0XX0
10X0
1100
1111
167 179 $self->{_conninfo} = $conninfo;
168 179 $self->{_pool_size} = $pool_size;
169 179 $self->{_opts} = $opts;
170 179 $self->{_access_broker_call_attributes} = {};
171 }
172 }
173 292 return $self->{connect_info};
174 }
175  
176  
177 180 ▶sub _async_broker_conninfo {
Subroutine _async_broker_conninfo: called CC=2 SCAR=7.0
178 180 my ($self, $mode) = @_;
179  
180 # Without a broker core's seam answers what connect_info stored. That is no
181 # broker's answer, so it is not read as one.
182 180 ▶ croak 'MySQL ev has no AccessBroker attached to ask for connect info'
Branch: 1 branch
BranchTrueFalseTotal
unless $self->access_broker 0 180 180
183 unless $self->access_broker;
184 180 $self->_mysql_refuse_parameters_beside_broker;
185  
186 164 my ($conninfo) = $self->_normalize_async_connect_info(
187 $self->_mysql_broker_connect_info($self->_current_async_connect_info($mode))
188 );
189 138 return $conninfo;
190 }
191  
192 # Croaks when a connection parameter stands beside the broker (karr k78): a
193 # key of what connect_info kept from [ $broker, \%options ] that is set to a
194 # value and is, by its name, no DBI attribute. The measure is core's for a
195 # broker's hash answer and for the options beside one (core k298 / k307,
196 # DBIO::Storage::DBI::AccessBroker::_access_broker_unapplied_parameters): a
197 # DBI attribute starts with an uppercase letter, with private_, dbi_ or dbd_,
198 # or with the prefix of the DBD -- mysql_ or mariadb_ here: this transport
199 # stands beside either DBD and is not told which, so both count; undef and the
200 # empty string name no parameter. What the owner applies itself and pool_size
201 # are gone from the hash by now. No list of EV::MariaDB parameters is kept: a
202 # lowercase name that is no DBI attribute cannot be told from one, and the
203 # ones EV::MariaDB does not know would make its constructor croak if they were
204 # handed on. Names only, sorted -- a value may be a secret (password), and
205 # nothing is said of the broker's answer, which has not been asked for.
206 345 ▶sub _mysql_refuse_parameters_beside_broker {
Subroutine _mysql_refuse_parameters_beside_broker: called CC=5 SCAR=16.1
207 345 my ($self) = @_;
208 345 my $beside = $self->_access_broker_call_attributes;
209 my @unapplied = sort grep {
210 345 ▶ defined $beside->{$_} && length $beside->{$_}
Condition100%6/6
defined $beside->{$_} && length $beside->{$_} && !/^(?:[A-Z]|private_|dbi_|dbd_|mysql_|mariadb_)/
!ll&&!rl&&r
915859
defined $beside->{$_} and length $beside->{$_}
!ll&&!rl&&r
63217
MC/DC100%3/3
defined $beside->{$_} && length $beside->{$_} && !/^(?:[A-Z]|private_|dbi_|dbd_|mysql_|mariadb_)/
defined $beside->{$_} length $beside->{$_} !/^(?:[A-Z]|private_|dbi_|dbd_|mysql_|mariadb_)/
Truth table100%4/4
A and B && not(C)
A= defined $beside->{$_}B= length $beside->{$_}C= !/^(?:[A-Z]|private_|dbi_|dbd_|mysql_|mariadb_)/
ABCresult
0XX0
10X0
1100
1111
211 && !/^(?:[A-Z]|private_|dbi_|dbd_|mysql_|mariadb_)/
212 } keys %$beside;
213 345 ▶ return unless @unapplied;
Branch: 1 branch
BranchTrueFalseTotal
unless @unapplied 293 52 345
214  
215 52 ▶ croak sprintf
Branch: 1 branch
BranchTrueFalseTotal
@unapplied > 1 ? : 3 49 52
216 'MySQL ev does not apply connection parameter(s) given beside an '
217 . 'AccessBroker (%s): its pooled connections and the listen connection are '
218 . "opened from the broker's answer alone, and would be opened without %s. "
219 . "Give %s in the broker's answer: the DBI form "
220 . "[ 'dbi:mysql:...;<parameter>=...' or 'dbi:MariaDB:...;<parameter>=...', "
221 . '$user, $password ] with the parameter in the DSN, or a hash of EV::MariaDB '
222 . 'connection parameters answered to this transport '
223 . '(connect_info_for_storage). Beside the broker it takes pool_size, and DBI '
224 . 'attributes, which are for the DBI connection of the owning storage and '
225 . 'dropped here',
226 join(', ', @unapplied), (@unapplied > 1 ? 'them' : 'it') x 2;
227 }
228  
229 # What the broker answered, in any shape _async_broker_conninfo lists, as the
230 # [ \%conninfo, \%opts ] pair _normalize_async_connect_info splits. A bare
231 # hashref has already been made that pair by _current_async_connect_info. The
232 # one place this transport reads a broker's answer: at attach and for every
233 # connection, so what is refused here never reaches EV::MariaDB.
234 293 ▶sub _mysql_broker_connect_info {
Subroutine _mysql_broker_connect_info: called CC=20 SCAR=30.1
235 293 my ($self, $info) = @_;
236 293 my ($pair, $shape);
237  
238 293 ▶ if (ref $info eq 'ARRAY') {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $info eq "ARRAY") 289 4 293
239 289 my ($first, $opts) = @$info;
240 289 ▶ if (defined $first && !ref $first && $first =~ /^dbi:([^:]*):/i) {
Branch: 2 branches
BranchTrueFalseTotal
if (defined $first and not ref $first and $first =~ /^dbi:([^:]*):/i) { } 96 193 289
elsif (ref $first eq 'HASH' and @$info <= 2 and !defined($opts) || ref $opts eq 'HASH') { } 187 12 199
Condition83%5/6
defined $first and not ref $first and $first =~ /^dbi:([^:]*):/i
!ll&&!rl&&r
190396
defined $first and not ref $first
!ll&&!rl&&r
019099
MC/DC66%2/3
defined $first and not ref $first and $first =~ /^dbi:([^:]*):/i
defined $first not ref $first $first =~ /^dbi:([^:]*):/i
Truth table75%3/4
A and not(B) and C
A= defined $firstB= not ref $firstC= $first =~ /^dbi:([^:]*):/i
ABCresult
0XX0
10X0
1100
1111
241 # The driver's name alone, as DBI reads it. What stands before the
242 # second colon is more than that: DBI takes attributes there, Password
243 # among them ('dbi:mysql(Password=>...):'), and a DSN gone wrong may
244 # have its parameters there (karr k76).
245 96 my ($driver) = $1 =~ /^(\w*)/;
246 # dbi_to_conninfo dies quoting the DSN -- its passwords masked since
247 # karr k76, the rest as it came -- and this message names the shape of
248 # an answer and nothing that was in it.
249 96 my $refused;
250 96 $pair = do {
251 96 local $@;
252 96 my $got = eval { DBIO::MySQL::EV::ConnectInfo::dbi_to_conninfo($info) };
253 # A refusal of the connect info (karr k64, k80) names keys, never
254 # values, and says what is wrong better than the shape would.
255 96 ▶ $refused = $1 if !$got && $@ =~ /^MySQL ev refuses the connect info: (.*?)\n?\z/s;
Branch: 1 branch
BranchTrueFalseTotal
if not $got and $@ =~ /^MySQL ev refuses the connect info: (.*?)\n?\z/s 1 95 96
Condition100%3/3
not $got and $@ =~ /^MySQL ev refuses the connect info: (.*?)\n?\z/s
!ll&&!rl&&r
8961
MC/DC100%2/2
not $got and $@ =~ /^MySQL ev refuses the connect info: (.*?)\n?\z/s
not $got $@ =~ /^MySQL ev refuses the connect info: (.*?)\n?\z/s
Truth table100%3/3
not(A) and B
A= not $gotB= $@ =~ /^MySQL ev refuses the connect info: (.*?)\n?\z/s
ABresult
0X0
100
111
256 96 $got;
257 };
258 96 ▶ $shape = defined $refused ? "a DBI-form arrayref: $refused"
Branch: 2 branches
BranchTrueFalseTotal
unless $pair 7 89 96
defined $refused ? : 1 6 7
259 : 'a DBI-form arrayref whose DSN is not dbi:mysql:<parameters> or '
260 . "dbi:MariaDB:<parameters> (DBI driver '$driver')"
261 unless $pair;
262 }
263 ▶ elsif (ref $first eq 'HASH' && @$info <= 2 && (!defined $opts || ref $opts eq 'HASH')) {
Condition55%5/9
ref $first eq "HASH" and @$info <= 2 and !defined($opts) || ref $opts eq "HASH"
!ll&&!rl&&r
60187
ref $first eq "HASH" and @$info <= 2
!ll&&!rl&&r
60187
not defined $opts or ref $opts eq "HASH"
l!l&&r!l&&!r
01870
MC/DC25%1/4
ref $first eq "HASH" and @$info <= 2 and !defined($opts) || ref $opts eq "HASH"
ref $first eq "HASH" @$info <= 2 not defined $opts ref $opts eq "HASH"
Truth table40%2/5
A and B and not(C) or D
A= ref $first eq "HASH"B= @$info <= 2C= not defined $optsD= ref $opts eq "HASH"
ABCDresult
0XXX0
10XX0
11000
111X1
11011
264 187 $pair = $info;
265 }
266 }
267  
268 293 ▶ if ($pair) {
Branch: 1 branch
BranchTrueFalseTotal
if ($pair) 276 17 293
269 # Read from the parameters as the pool and the listen connection hand them
270 # over, so the two cannot differ.
271 276 my ($conninfo) = $self->_normalize_async_connect_info($pair);
272 276 ▶ my $described = $self->_mysql_describe_shape(ref $info->[0] eq 'HASH' ? $info->[0] : $info);
Branch: 1 branch
BranchTrueFalseTotal
ref $info->[0] eq 'HASH' ? : 187 89 276
273  
274 # A whole DSN where the name of the database belongs (karr k63):
275 # DBIO::AccessBroker::Static->new(dbname => 'dbi:mysql:...'), the form
276 # core's sync storage takes as the DSN. The answer is still a hash, read
277 # here as EV::MariaDB parameters -- the DSN would be the database's name
278 # and the host it names would not be given, so EV::MariaDB would connect
279 # to the client library's default, the local server, with the broker's
280 # user and password. Refused whatever stands beside it: a host bound in by
281 # a HostBound view is not the one the DSN names either. Told by the form,
282 # 'dbi:' in front; nothing of the DSN is said, it may carry a password.
283 276 ▶ if (grep { defined($_) && !ref($_) && /^dbi:/i } @{$conninfo}{qw( database db )}) {
Branch: 2 branches
BranchTrueFalseTotal
if (grep {defined $_ and not ref $_ and /^dbi:/i;} @{$conninfo;}{'database', 'db'}) { } 12 264 276
elsif ('DBIO::MySQL::EV::Pool'->_mysql_connectable($conninfo)) { } 249 15 264
Condition83%5/6
defined $_ && !ref($_) && /^dbi:/i
!ll&&!rl&&r
29724312
defined $_ and not ref $_
!ll&&!rl&&r
2970255
MC/DC66%2/3
defined $_ && !ref($_) && /^dbi:/i
defined $_ not ref $_ /^dbi:/i
Truth table75%3/4
A and not(B) && C
A= defined $_B= not ref $_C= /^dbi:/i
ABCresult
0XX0
10X0
1100
1111
284 12 $shape = "$described whose database name is a whole DBI DSN -- a hash is "
285 . 'read as EV::MariaDB parameters and no DSN is read out of one, so '
286 . 'the connection would be opened without the host the DSN names. '
287 . 'Have the broker answer the DSN in the DBI form '
288 . '[ $dsn, $user, $password ], or the database name as dbname with '
289 . 'host and port beside it';
290 }
291 # EV::MariaDB->new starts a connect only when given a host or a user.
292 # Given neither, its handle stays unconnected and calls back neither
293 # on_connect nor on_error, so the acquire waiting for it would never
294 # resolve. The test is the pool's, shared with static connect info
295 # (karr k66).
296 elsif (DBIO::MySQL::EV::Pool->_mysql_connectable($conninfo)) {
297 249 return $pair;
298 }
299 else {
300 15 $shape = "$described, which names neither a host nor a user -- "
301 . 'EV::MariaDB opens no connection without one of them';
302 }
303 }
304  
305 44 ▶ croak sprintf
Condition66%2/3
$shape // $self->_mysql_describe_shape($info)
l!l&&r!l&&!r
34100
MC/DC0%0/2
$shape // $self->_mysql_describe_shape($info)
$shape $self->_mysql_describe_shape($info)
Truth table66%2/3
A // B
A= $shapeB= $self->_mysql_describe_shape($info)
ABresult
1X1
011
000
306 'MySQL ev cannot connect from what the AccessBroker returned: %s. '
307 . "It takes a DBI-form arrayref [ 'dbi:mysql:...' or 'dbi:MariaDB:...', "
308 . '$user, $password, \\%%attrs ], a hashref of EV::MariaDB connection '
309 . 'parameters (host, port, database, user, password, ...), or an arrayref '
310 . 'of such a hashref, optionally followed by an options hashref',
311 $shape // $self->_mysql_describe_shape($info);
312 }
313  
314 # The shape of a broker's answer, for an error message: types and hash keys,
315 # never values -- they carry the password.
316 289 ▶sub _mysql_describe_shape {
Subroutine _mysql_describe_shape: called CC=9 SCAR=22.1
317 289 my ($self, $value) = @_;
318 289 ▶ return 'nothing (undef)' unless defined $value;
Branch: 1 branch
BranchTrueFalseTotal
unless defined $value 0 289 289
319 289 ▶ return 'a plain string' unless ref $value;
Branch: 1 branch
BranchTrueFalseTotal
unless ref $value 4 285 289
320 285 ▶ return 'an empty hashref' if ref $value eq 'HASH' && !%$value;
Branch: 1 branch
BranchTrueFalseTotal
if ref $value eq "HASH" and not %$value 3 282 285
Condition100%3/3
ref $value eq "HASH" and not %$value
!ll&&!rl&&r
951873
MC/DC100%2/2
ref $value eq "HASH" and not %$value
ref $value eq "HASH" not %$value
Truth table100%3/3
A and not(B)
A= ref $value eq "HASH"B= not %$value
ABresult
0X0
100
111
321 282 ▶ return sprintf 'a hashref with keys (%s)', join ', ', sort keys %$value
Branch: 1 branch
BranchTrueFalseTotal
if ref $value eq "HASH" 187 95 282
322 if ref $value eq 'HASH';
323 return sprintf 'an arrayref of (%s)', join ', ',
324 95 ▶ map { !defined $_ ? 'undef' : ref $_ ? ref($_) . ' ref' : 'string' } @$value
Branch: 3 branches
BranchTrueFalseTotal
if ref $value eq "ARRAY" 95 0 95
!defined($_) ? : 6 373 379
ref $_ ? : 100 273 373
325 if ref $value eq 'ARRAY';
326 0 return 'a ' . ref($value) . ' ref';
327 }
328  
329  
330 707 ▶sub _normalize_async_connect_info {
Subroutine _normalize_async_connect_info: called CC=6 SCAR=18.0
331 707 my ($self, $info) = @_;
332  
333 707 my $conninfo = $info->[0];
334 707 ▶ $conninfo = ref($conninfo) eq 'HASH' ? { %$conninfo } : $conninfo;
Branch: 1 branch
BranchTrueFalseTotal
ref $conninfo eq 'HASH' ? : 707 0 707
335  
336 707 my $opts = $info->[1];
337 707 ▶ $opts = ref($opts) eq 'HASH' ? { %$opts } : {};
Branch: 1 branch
BranchTrueFalseTotal
ref $opts eq 'HASH' ? : 674 33 707
338  
339 707 my $pool_size = 5;
340 707 ▶ if (ref($conninfo) eq 'HASH') {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $conninfo eq "HASH") 707 0 707
341 707 ▶ $pool_size = delete $conninfo->{pool_size} // 5;
Condition100%2/2
delete $conninfo->{"pool_size"} // 5
l!l
267440
MC/DC100%1/1
delete $conninfo->{"pool_size"} // 5
delete $conninfo->{"pool_size"}
Truth table100%2/2
A
A= delete $conninfo->{"pool_size"}
Aresult
11
00
342 # MySQL uses 'database', not 'dbname'
343 707 ▶ $conninfo->{database} = delete $conninfo->{dbname} if exists $conninfo->{dbname};
Branch: 1 branch
BranchTrueFalseTotal
if exists $conninfo->{"dbname"} 302 405 707
344 }
345  
346 707 return ($conninfo, $pool_size, $opts);
347 }
348  
349  
350 16 ▶sub _conninfo_hash {
Subroutine _conninfo_hash: called CC=3 SCAR=11.0
351 16 my ($self, $ci) = @_;
352 16 ▶ my $conninfo = defined($ci) ? $ci : $self->{_conninfo};
Branch: 1 branch
BranchTrueFalseTotal
defined $ci ? : 0 16 16
353 16 ▶ return unless defined $conninfo;
Branch: 1 branch
BranchTrueFalseTotal
unless defined $conninfo 10 6 16
354 6 return $conninfo;
355 }
356  
357  
358 1208 ▶sub pool {
Subroutine pool: called CC=3 SCAR=11.0
Pod documented
359 1208 my $self = shift;
360 1208 ▶ $self->{pool} ||= do {
Condition66%2/3
$self->{"pool"} ||= do { my(%args) = ("storage", $self, "size", $self->{"_pool_size"}, "future_class", $self->future_class, "on_error", sub { warn DBIO::Util::mask_connect_secrets("DBIO::MySQL::EV pool error: $_[0]\n"); } ); if (my $provider = $self->_conninfo_provider) { $args{"conninfo_provider"} = $provider; } else { $args{"conninfo"} = $self->{"_conninfo"}; } ; "DBIO::MySQL::EV::Pool"->new(%args) }
l!l&&r!l&&!r
9542540
MC/DC0%0/2
$self->{"pool"} ||= do { my(%args) = ("storage", $self, "size", $self->{"_pool_size"}, "future_class", $self->future_class, "on_error", sub { warn DBIO::Util::mask_connect_secrets("DBIO::MySQL::EV pool error: $_[0]\n"); } ); if (my $provider = $self->_conninfo_provider) { $args{"conninfo_provider"} = $provider; } else { $args{"conninfo"} = $self->{"_conninfo"}; } ; "DBIO::MySQL::EV::Pool"->new(%args) }
$self->{"pool"} do { my(%args) = ("storage", $self, "size", $self->{"_pool_size"}, "future_class", $self->future_class, "on_error", sub { warn DBIO::Util::mask_connect_secrets("DBIO::MySQL::EV pool error: $_[0]\n"); } ); if (my $provider = $self->_conninfo_provider) { $args{"conninfo_provider"} = $provider; } else { $args{"conninfo"} = $self->{"_conninfo"}; } ; "DBIO::MySQL::EV::Pool"->new(%args) }
Truth table66%2/3
A ||= B
A= $self->{"pool"}B= do { my(%args) = ("storage", $self, "size", $self->{"_pool_size"}, "future_class", $self->future_class, "on_error", sub { warn DBIO::Util::mask_connect_secrets("DBIO::MySQL::EV pool error: $_[0]\n"); } ); if (my $provider = $self->_conninfo_provider) { $args{"conninfo_provider"} = $provider; } else { $args{"conninfo"} = $self->{"_conninfo"}; } ; "DBIO::MySQL::EV::Pool"->new(%args) }
ABresult
1X1
011
000
361 my %args = (
362 storage => $self,
363 size => $self->{_pool_size},
364 future_class => $self->future_class,
365 # No password in the warning (karr k76). What a connection reports is
366 # masked where its handle is made; this is for whatever else the pool
367 # reports here.
368 5 ▶ on_error => sub { warn DBIO::Util::mask_connect_secrets("DBIO::MySQL::EV pool error: $_[0]\n") },
Subroutine __ANON__: called CC=1 SCAR=0.0
369 254 );
370  
371 254 ▶ if (my $provider = $self->_conninfo_provider) {
Branch: 1 branch
BranchTrueFalseTotal
if (my $provider = $self->_conninfo_provider) { } 93 161 254
372 93 $args{conninfo_provider} = $provider;
373 }
374 else {
375 161 $args{conninfo} = $self->{_conninfo};
376 }
377  
378 254 DBIO::MySQL::EV::Pool->new(%args);
379 };
380 }
381  
382 # Lazily-built query executor. The executor is the MySQL wire seam: it hides
383 # EV::MariaDB's query-vs-prepare/execute split (query() takes no binds), closes
384 # every statement it prepares (karr k45) and keeps the async bind-clearing
385 # contract (karr k11). It is deliberately NOT bound to the
386 # pool -- every execute() is handed the connection to run on (pooled or pinned),
387 # so the executor holds no connection state and building it never forces the
388 # lazy pool into existence. Held on the storage so a caller that pre-wires
389 # { pool, executor } (the offline facade tests) keeps its own instance.
390 987 ▶sub _executor {
Subroutine _executor: called CC=2 SCAR=7.1
391 987 my $self = shift;
392 987 ▶ return $self->{executor} ||= DBIO::MySQL::EV::QueryExecutor->new(
Condition66%2/3
$self->{"executor"} ||= "DBIO::MySQL::EV::QueryExecutor"->new("future_class", $self->future_class, "error_masker", \&DBIO::MySQL::EV::Storage::_mysql_mask_error)
l!l&&r!l&&!r
8491380
MC/DC0%0/2
$self->{"executor"} ||= "DBIO::MySQL::EV::QueryExecutor"->new("future_class", $self->future_class, "error_masker", \&DBIO::MySQL::EV::Storage::_mysql_mask_error)
$self->{"executor"} "DBIO::MySQL::EV::QueryExecutor"->new("future_class", $self->future_class, "error_masker", \&DBIO::MySQL::EV::Storage::_mysql_mask_error)
Truth table66%2/3
A ||= B
A= $self->{"executor"}B= "DBIO::MySQL::EV::QueryExecutor"->new("future_class", $self->future_class, "error_masker", \&DBIO::MySQL::EV::Storage::_mysql_mask_error)
ABresult
1X1
011
000
393 future_class => $self->future_class,
394 error_masker => \&_mysql_mask_error,
395 );
396 }
397  
398  
399 93 ▶sub _mysql_mask_error {
Subroutine _mysql_mask_error: called CC=4 SCAR=15.2
400 93 my ($text, $values, $sql, $code) = @_;
401 93 ▶ return $text unless defined $text && !ref $text;
Branch: 1 branch
BranchTrueFalseTotal
unless defined $text and not ref $text 0 93 93
Condition33%1/3
defined $text and not ref $text
!ll&&!rl&&r
0093
MC/DC0%0/2
defined $text and not ref $text
defined $text not ref $text
Truth table33%1/3
A and not(B)
A= defined $textB= not ref $text
ABresult
0X0
100
111
402  
403 93 my $masked = eval {
404 93 DBIO::Util::mask_bound_values(
405 DBIO::MySQL::Util::mask_error_details($text, $values, $sql, $code),
406 $values,
407 );
408 };
409 93 ▶ return defined $masked ? $masked : $text;
Branch: 1 branch
BranchTrueFalseTotal
defined $masked ? : 93 0 93
410 }
411  
412 # --- Transaction context seams ------------------------------------------------
413  
414  
415 56 ▶sub _txn_context_class { 'DBIO::MySQL::EV::TransactionContext' }
Subroutine _txn_context_class: called CC=1 SCAR=0.0
416  
417  
418 51 ▶sub _txn_conn_accessor { 'txn_conn' }
Subroutine _txn_conn_accessor: called CC=1 SCAR=0.0
419  
420 # --- Async deploy seam --------------------------------------------------------
421  
422  
423 7 ▶sub _ddl_class { 'DBIO::MySQL::DDL' }
Subroutine _ddl_class: called CC=1 SCAR=0.0
424  
425  
426 5 ▶sub _ddl_quote_ident { DBIO::MySQL::Identifier::quote_ident($_[1]) }
Subroutine _ddl_quote_ident: called CC=1 SCAR=0.0
427  
428 # --- SQL shaping seam ---------------------------------------------------------
429  
430  
431 706 ▶sub _transform_sql { $_[1] }
Subroutine _transform_sql: called CC=1 SCAR=0.0
432  
433 # --- Async query execution (transport seams) ----------------------------------
434  
435  
436 308 ▶sub _query_async {
Subroutine _query_async: called CC=2 SCAR=6.9
437 308 my ($self, $sql, $bind, $bind_attrs) = @_;
438 308 ▶ $bind //= [];
Condition50%1/2
$bind //= []
l!l
3080
MC/DC0%0/1
$bind //= []
$bind
Truth table50%1/2
A
A= $bind
Aresult
11
00
439 308 $sql = $self->_transform_sql($sql);
440  
441 # The pool this statement begins on is the one it ends on (karr k90).
442 308 my $pool = $self->pool;
443 # The wait for the pool is held until it is done (core k407): Future.pm
444 # holds a then-sequence only weakly from the Future it waits on, so a caller
445 # that drops it while the pool is full would lose the chain.
446 303 ▶ return $self->_hold_derived($pool->acquire->then(sub {
Subroutine __ANON__: called CC=1 SCAR=0.0
447 303 my $conn = shift;
448 # A dispatch without a Future must still release $conn (karr k50, k61): as
449 # a failed Future it takes the same on_ready release as any other outcome.
450 303 my $f = $self->_seam_future(_await_query_result => $conn, $sql, $bind, $bind_attrs);
451 303 $f->on_ready($self->_release_on_ready($conn, $pool, $pool->_lease($conn)));
452 303 return $self->_mysql_caller_future($f);
453 308 }));
454 }
455  
456  
457 401 ▶sub _mysql_caller_future {
Subroutine _mysql_caller_future: called CC=2 SCAR=7.1
458 401 my ($self, $dispatch) = @_;
459 401 ▶ return $dispatch unless $dispatch->can('without_cancel');
Branch: 1 branch
BranchTrueFalseTotal
unless $dispatch->can("without_cancel") 0 401 401
460 401 return $dispatch->retain->without_cancel;
461 }
462  
463  
464 303 ▶sub _await_query_result {
Subroutine _await_query_result: called CC=1 SCAR=0.0
465 303 my ($self, $conn, $sql, $bind, $bind_attrs) = @_;
466 303 return $self->_mysql_execute($conn, $sql, $bind, undef, $bind_attrs);
467 }
468  
469  
470 643 ▶sub _mysql_execute {
Subroutine _mysql_execute: called CC=6 SCAR=17.9
471 643 my ($self, $conn, $sql, $bind, $dispatch, $bind_attrs) = @_;
472 643 ▶ $dispatch //= 'execute';
Condition100%2/2
$dispatch //= "execute"
l!l
336307
MC/DC100%1/1
$dispatch //= "execute"
$dispatch
Truth table100%2/2
A
A= $dispatch
Aresult
11
00
473  
474 643 my $end = $self->_debug_query($sql, $bind, $bind_attrs);
475 643 my $f;
476 643 ▶ unless (eval { $f = $self->_dispatch_to_executor($dispatch, $conn, $sql, $bind); 1 }) {
Branch: 1 branch
BranchTrueFalseTotal
unless (eval { do { $f = $self->_dispatch_to_executor($dispatch, $conn, $sql, $bind); 1 } }) 5 638 643
477 5 my $err = $@;
478 5 ▶ $end->() if $end;
Branch: 1 branch
BranchTrueFalseTotal
if $end 0 5 5
479 5 $self->_mysql_report_if_gone($conn);
480 5 die $err;
481 }
482 # An executor that answers no Future is _seam_future's to name (karr k61).
483 638 ▶ $f->on_fail($self->_mysql_report_gone_cb($conn))
Branch: 1 branch
BranchTrueFalseTotal
if builtin::blessed($f) and $f->can("on_fail") 636 2 638
Condition66%2/3
builtin::blessed($f) and $f->can("on_fail")
!ll&&!rl&&r
20636
MC/DC50%1/2
builtin::blessed($f) and $f->can("on_fail")
builtin::blessed($f) $f->can("on_fail")
Truth table66%2/3
A and B
A= builtin::blessed($f)B= $f->can("on_fail")
ABresult
0X0
100
111
484 if Scalar::Util::blessed($f) && $f->can('on_fail');
485 638 _mysql_trace_end($end, $f);
486 638 return $f;
487 }
488  
489 # query_end of the core trace (_debug_query), once the statement's Future is
490 # ready, done or failed. $end is undef when nothing is traced. A named sub
491 # holding the coderef alone, never the bind values (ADR 0044).
492 957 ▶sub _mysql_trace_end {
Subroutine _mysql_trace_end: called CC=4 SCAR=16.4
493 957 my ($end, $f) = @_;
494 957 ▶ return unless $end;
Branch: 1 branch
BranchTrueFalseTotal
unless $end 946 11 957
495 11 ▶ return $f->on_ready($end)
Branch: 1 branch
BranchTrueFalseTotal
if builtin::blessed($f) and $f->can("on_ready") 11 0 11
Condition33%1/3
builtin::blessed($f) and $f->can("on_ready")
!ll&&!rl&&r
0011
MC/DC0%0/2
builtin::blessed($f) and $f->can("on_ready")
builtin::blessed($f) $f->can("on_ready")
Truth table33%1/3
A and B
A= builtin::blessed($f)B= $f->can("on_ready")
ABresult
0X0
100
111
496 if Scalar::Util::blessed($f) && $f->can('on_ready');
497 0 $end->();
498 0 return;
499 }
500  
501 # $dispatch: an executor method name, or a coderef called with the executor
502 # and the arguments. An executor that does not offer the queueing method
503 # (a replaced one, a test double) gets a plain execute.
504 691 ▶sub _dispatch_to_executor {
Subroutine _dispatch_to_executor: called CC=3 SCAR=11.0
505 691 my ($self, $dispatch, @args) = @_;
506 691 my $executor = $self->_executor;
507 691 ▶ return $executor->$dispatch(@args) if ref $dispatch;
Branch: 1 branch
BranchTrueFalseTotal
if ref $dispatch 24 667 691
508 667 ▶ $dispatch = 'execute' unless $executor->can($dispatch);
Branch: 1 branch
BranchTrueFalseTotal
unless $executor->can($dispatch) 77 590 667
509 667 return $executor->$dispatch(@args);
510 }
511  
512 955 ▶sub _mysql_report_gone_cb {
Subroutine _mysql_report_gone_cb: called CC=1 SCAR=0.0
513 955 my ($self, $conn) = @_;
514 955 ▶ return sub { $self->_mysql_report_if_gone($conn) };
Subroutine __ANON__: called CC=1 SCAR=0.0
515 }
516  
517 # Without a pool there is nobody to report to, and none is built for it: a
518 # connection the pool does not hold is not the pool's to retire.
519 42 ▶sub _mysql_report_if_gone {
Subroutine _mysql_report_if_gone: called CC=2 SCAR=6.9
520 42 my ($self, $conn) = @_;
521 42 ▶ my $pool = $self->{pool} or return;
Branch: 1 branch
BranchTrueFalseTotal
my $pool = $self->{"pool"} or return 40 2 42
522 40 $pool->_mysql_report_if_gone($conn);
523 40 return;
524 }
525  
526  
527 402 ▶sub _release_on_ready {
Subroutine _release_on_ready: called CC=2 SCAR=7.0
528 402 my ($self, $conn, $pool, $lease) = @_;
529 402 ▶ croak '_release_on_ready needs the pool the connection was acquired from' unless $pool;
Branch: 1 branch
BranchTrueFalseTotal
unless $pool 0 402 402
530 402 ▶ return sub { $pool->release($conn, $lease) };
Subroutine __ANON__: called CC=1 SCAR=0.0
531 }
532  
533  
534 384 ▶sub _query_async_pinned {
Subroutine _query_async_pinned: called CC=4 SCAR=13.9
535 384 my ($self, $conn, $sql, $bind, $bind_attrs) = @_;
536 384 ▶ $bind //= [];
Condition50%1/2
$bind //= []
l!l
3840
MC/DC0%0/1
$bind //= []
$bind
Truth table50%1/2
A
A= $bind
Aresult
11
00
537 384 $sql = $self->_transform_sql($sql);
538 384 ▶ return $self->_mysql_rollback($conn, $sql, $bind)
Branch: 1 branch
BranchTrueFalseTotal
if $sql =~ /\A\s*ROLLBACK\s*;?\s*\z/i 24 360 384
539 if $sql =~ /\A\s*ROLLBACK\s*;?\s*\z/i;
540 360 ▶ return $self->_mysql_commit($conn, $sql, $bind)
Branch: 1 branch
BranchTrueFalseTotal
if $sql =~ /\A\s*COMMIT\s*;?\s*\z/i 24 336 360
541 if $sql =~ /\A\s*COMMIT\s*;?\s*\z/i;
542 336 return $self->_mysql_execute($conn, $sql, $bind, 'execute_after_exclusive', $bind_attrs);
543 }
544  
545  
546 24 ▶sub _mysql_rollback {
Subroutine _mysql_rollback: called CC=1 SCAR=0.0
547 24 my ($self, $conn, $sql, $bind) = @_;
548 24 my $timeout = $self->rollback_wait_timeout;
549 return $self->_mysql_end_transaction(
550 24 ▶ sub { $_[0]->execute_when_idle($_[1], $_[2], $_[3], $timeout) }, $conn, $sql, $bind);
Subroutine __ANON__: called CC=1 SCAR=0.0
551 }
552  
553  
554 24 ▶sub _mysql_commit {
Subroutine _mysql_commit: called CC=1 SCAR=0.0
555 24 my ($self, $conn, $sql, $bind) = @_;
556 24 return $self->_mysql_end_transaction(execute_after_exclusive => $conn, $sql, $bind);
557 }
558  
559 # The statement that ends a transaction on $conn, handed to the executor's
560 # $dispatch (execute, or execute_when_idle). When it does not succeed -- the
561 # dispatch died, or its Future failed -- the connection is retired at its
562 # release: the transaction may still be open on it (karr k74). A dispatch that
563 # died is rethrown unchanged, as _mysql_execute does.
564 48 ▶sub _mysql_end_transaction {
Subroutine _mysql_end_transaction: called CC=5 SCAR=16.3
565 48 my ($self, $dispatch, $conn, $sql, $bind) = @_;
566  
567 48 my $end = $self->_debug_query($sql, $bind);
568 48 my $f;
569 48 ▶ unless (eval { $f = $self->_dispatch_to_executor($dispatch, $conn, $sql, $bind); 1 }) {
Branch: 1 branch
BranchTrueFalseTotal
unless (eval { do { $f = $self->_dispatch_to_executor($dispatch, $conn, $sql, $bind); 1 } }) 1 47 48
570 1 my $err = $@;
571 1 ▶ $end->() if $end;
Branch: 1 branch
BranchTrueFalseTotal
if $end 0 1 1
572 1 $self->_mysql_retire_open_transaction($conn);
573 1 $self->_mysql_report_if_gone($conn);
574 1 die $err;
575 }
576 47 ▶ if (Scalar::Util::blessed($f) && $f->can('on_fail')) {
Branch: 1 branch
BranchTrueFalseTotal
if (builtin::blessed($f) and $f->can("on_fail")) 47 0 47
Condition33%1/3
builtin::blessed($f) and $f->can("on_fail")
!ll&&!rl&&r
0047
MC/DC0%0/2
builtin::blessed($f) and $f->can("on_fail")
builtin::blessed($f) $f->can("on_fail")
Truth table33%1/3
A and B
A= builtin::blessed($f)B= $f->can("on_fail")
ABresult
0X0
100
111
577 47 $f->on_fail($self->_mysql_report_gone_cb($conn));
578 47 $f->on_fail($self->_mysql_retire_open_transaction_cb($conn));
579 }
580 47 _mysql_trace_end($end, $f);
581 47 return $f;
582 }
583  
584 47 ▶sub _mysql_retire_open_transaction_cb {
Subroutine _mysql_retire_open_transaction_cb: called CC=1 SCAR=0.0
585 47 my ($self, $conn) = @_;
586 47 ▶ return sub { $self->_mysql_retire_open_transaction($conn) };
Subroutine __ANON__: called CC=1 SCAR=0.0
587 }
588  
589 6 ▶sub _mysql_retire_open_transaction {
Subroutine _mysql_retire_open_transaction: called CC=2 SCAR=7.0
590 6 my ($self, $conn) = @_;
591 6 ▶ my $pool = $self->{pool} or return;
Branch: 1 branch
BranchTrueFalseTotal
my $pool = $self->{"pool"} or return 6 0 6
592 6 $pool->_mark_connection_dead($conn);
593 6 return;
594 }
595  
596  
597 274 ▶sub _reset_pool_connection {
Subroutine _reset_pool_connection: called CC=3 SCAR=11.0
598 274 my ($self, $conn) = @_;
599  
600 274 my $executor = $self->_executor;
601 274 my $end = $self->_debug_query('COM_RESET_CONNECTION', []);
602 274 my $f;
603 274 ▶ unless (eval { $f = $executor->reset_connection($conn); 1 }) {
Branch: 1 branch
BranchTrueFalseTotal
unless (eval { do { $f = $executor->reset_connection($conn); 1 } }) 2 272 274
604 2 my $err = $@;
605 2 ▶ $end->() if $end;
Branch: 1 branch
BranchTrueFalseTotal
if $end 0 2 2
606 2 $self->_mysql_report_if_gone($conn);
607 2 return $self->future_class->fail($err);
608 }
609 272 $f->on_fail($self->_mysql_report_gone_cb($conn));
610 272 _mysql_trace_end($end, $f);
611  
612 264 ▶ return $f->then(sub {
Subroutine __ANON__: called CC=3 SCAR=11.1
613 264 my $names = $self->{_mysql_session_names}{ Scalar::Util::refaddr($conn) };
614 264 ▶ return $self->future_class->done unless $names;
Branch: 1 branch
BranchTrueFalseTotal
unless $names 260 4 264
615  
616 4 my $set;
617 4 ▶ unless (eval { $set = $self->_mysql_execute($conn, _mysql_set_names_sql(@$names), []); 1 }) {
Branch: 1 branch
BranchTrueFalseTotal
unless (eval { do { $set = $self->_mysql_execute($conn, _mysql_set_names_sql(@$names), []); 1 } }) 0 4 4
618 0 return $self->future_class->fail($@);
619 }
620 4 return $set;
621 263 ▶ })->then(sub {
Subroutine __ANON__: called CC=1 SCAR=0.0
622 263 $self->SUPER::_setup_pool_connection($conn);
623 262 return $self->future_class->done;
624 272 });
625 }
626  
627  
628 262 ▶sub _setup_pool_connection {
Subroutine _setup_pool_connection: called CC=2 SCAR=6.9
629 262 my ($self, $conn) = @_;
630  
631 262 $self->SUPER::_setup_pool_connection($conn);
632  
633 # Without an owning sync storage there are no connect actions and the pool
634 # waits for no connect here (the core seam is a no-op there as well).
635 262 ▶ return unless $self->_owner_storage;
Branch: 1 branch
BranchTrueFalseTotal
unless $self->_owner_storage 241 21 262
636  
637 21 $self->_mysql_remember_session_names($conn);
638 20 return;
639 }
640  
641 # Reads character_set_client and collation_connection of a new connection
642 # (blocking, like the connect actions) and keeps them for the reset.
643 14 ▶sub _mysql_remember_session_names {
Subroutine _mysql_remember_session_names: called CC=5 SCAR=16.2
644 14 my ($self, $conn) = @_;
645  
646 14 my $rows = $self->_run_pool_connect_statement(
647 $conn,
648 'SELECT @@character_set_client, @@collation_connection',
649 { dbio_rows => 1 },
650 );
651 14 ▶ my $row = $rows && $rows->[0] or return;
Branch: 1 branch
BranchTrueFalseTotal
my $row = $rows && $rows->[0] or return 13 1 14
Condition66%2/3
$rows && $rows->[0]
!ll&&!rl&&r
0113
MC/DC50%1/2
$rows && $rows->[0]
$rows $rows->[0]
Truth table66%2/3
A && B
A= $rowsB= $rows->[0]
ABresult
0X0
100
111
652  
653 13 my @names = @$row[0, 1];
654 croak 'the server answered a character set or collation name that is not a plain name'
655 13 ▶ if grep { !defined $_ || $_ !~ /\A[A-Za-z0-9_]+\z/ } @names;
Branch: 1 branch
BranchTrueFalseTotal
if grep {not defined $_ && $_ =~ /\A[A-Za-z0-9_]+\z/;} @names 1 12 13
Condition66%2/3
defined $_ && $_ =~ /\A[A-Za-z0-9_]+\z/
!ll&&!rl&&r
0125
MC/DC50%1/2
defined $_ && $_ =~ /\A[A-Za-z0-9_]+\z/
defined $_ $_ =~ /\A[A-Za-z0-9_]+\z/
Truth table66%2/3
A && B
A= defined $_B= $_ =~ /\A[A-Za-z0-9_]+\z/
ABresult
0X0
100
111
656 12 $self->{_mysql_session_names}{ Scalar::Util::refaddr($conn) } = \@names;
657  
658 12 return;
659 }
660  
661 4 ▶sub _mysql_set_names_sql {
Subroutine _mysql_set_names_sql: called CC=1 SCAR=0.0
662 4 my ($charset, $collation) = @_;
663 4 return "SET NAMES $charset COLLATE $collation";
664 }
665  
666 # --- INSERT: LAST_INSERT_ID instead of RETURNING (MySQL value-add) ------------
667  
668  
669 99 ▶sub insert_async {
Subroutine insert_async: called CC=1 SCAR=0.0
Pod documented
670 99 my ($self, @args) = @_;
671  
672 # INSERT + LAST_INSERT_ID() must ride the SAME session, so pin the whole
673 # insert on one acquired connection and release it once the Future settles --
674 # also when there never is one (karr k50, k61, see _query_async).
675 99 my $pool = $self->pool; # the pool the insert ends on, too (karr k90)
676 98 ▶ return $self->_hold_derived($pool->acquire->then(sub {
Subroutine __ANON__: called CC=1 SCAR=0.0
677 98 my $conn = shift;
678 98 my $f = $self->_seam_future(_run_crud_pinned => 'insert', $conn, @args);
679 98 $f->on_ready($self->_release_on_ready($conn, $pool, $pool->_lease($conn)));
680 98 return $self->_mysql_caller_future($f);
681 99 }));
682 }
683  
684  
685 153 ▶sub _run_crud_pinned {
Subroutine _run_crud_pinned: called CC=5 SCAR=16.3
686 153 my ($self, $op, $conn, @args) = @_;
687 153 ▶ return $self->SUPER::_run_crud_pinned($op, $conn, @args) unless $op eq 'insert';
Branch: 1 branch
BranchTrueFalseTotal
unless $op eq "insert" 33 120 153
688  
689 # The CRUD contract is insert_async($source, \%rowdata) (ADR 0031 §3).
690 # SQLMaker wants a plain table name, so unwrap a blessed source to its
691 # ->name; a bare string passes through.
692 120 my ($source, @rest) = @args;
693 120 my $to_insert = $rest[0];
694 # ADR 0044: the caller's row-data hashref must not be retained for the
695 # flight. The returned-columns assembly only needs the values, so take a
696 # shallow copy at dispatch; the flight closures reference the copy, never
697 # the caller's hashref.
698 120 ▶ my $insert_data = defined $to_insert ? { %$to_insert } : $to_insert;
Branch: 1 branch
BranchTrueFalseTotal
defined $to_insert ? : 120 0 120
699 # The deferred part below (it waits for the sql_mode of a 0) references
700 # these copies only, never the caller's hashref.
701 120 ▶ my @rest_c = ( defined $to_insert ? { %$to_insert } : $to_insert, @rest[ 1 .. $#rest ] );
Branch: 1 branch
BranchTrueFalseTotal
defined $to_insert ? : 120 0 120
702  
703 # An auto-increment value of 0 is "generate" to the server, unless the
704 # session's sql_mode has NO_AUTO_VALUE_ON_ZERO (karr k68): for the plan and
705 # for the returned columns it counts as not supplied. The statement itself
706 # still sends the 0. The sql_mode is read, on the pinned connection, only
707 # for a 0.
708 120 my $zero_col = $self->_zero_auto_increment_column($source, $insert_data);
709 my $generates = ! defined $zero_col
710 ? Future->done(0)
711 4 ▶ : $self->_query_async_pinned($conn, 'SELECT @@SESSION.sql_mode', [])->then(sub {
Subroutine __ANON__: called CC=4 SCAR=14.5
712 4 ▶ my $mode = ref $_[0] eq 'ARRAY' ? $_[0][0] : undef;
Branch: 1 branch
BranchTrueFalseTotal
ref $_[0] eq 'ARRAY' ? : 4 0 4
713 4 ▶ return Future->done(( $mode // '' ) =~ /\bNO_AUTO_VALUE_ON_ZERO\b/ ? 0 : 1);
Branch: 1 branch
BranchTrueFalseTotal
($mode // '') =~ /\bNO_AUTO_VALUE_ON_ZERO\b/ ? : 1 3 4
Condition50%1/2
$mode // ""
l!l
40
MC/DC0%0/1
$mode // ""
$mode
Truth table50%1/2
A
A= $mode
Aresult
11
00
714 120 ▶ });
Branch: 1 branch
BranchTrueFalseTotal
!defined($zero_col) ? : 116 4 120
715 120 ▶ return $generates->then(sub {
Subroutine __ANON__: called CC=11 SCAR=24.6
716 120 my ($generate) = @_;
717 120 my $plan_data = $rest_c[0];
718 120 ▶ if ($generate) {
Branch: 1 branch
BranchTrueFalseTotal
if ($generate) 3 117 120
719 3 $insert_data = { %$insert_data };
720 3 delete $insert_data->{$zero_col};
721 3 $plan_data = { %{ $rest_c[0] } };
722 3 delete $plan_data->{$zero_col};
723 }
724  
725 # ADR 0036 section 4: the identity_column decision belongs to the storage,
726 # never to the SQLMaker. Core's upsert_async hands this backend an
727 # on_conflict structure WITHOUT identity_column -- the sync driver's
728 # _mysql_upsert_plan adds that key before a sync statement runs, and this
729 # path renders the SQLMaker directly, so the plan never ran here either.
730 # Fold its private keys in exactly like DBIO::MySQL::Storage::insert does,
731 # resolved against the OWNING sync storage via the back-ref core wired in
732 # _async_storage (DBIO::Storage::Async/_owner_storage). Without it the ODKU
733 # UPDATE branch carries no `pk` = LAST_INSERT_ID(`pk`) and reports a freshly
734 # sent session's LII (0) instead of the id of the row the server actually
735 # touched. The plan also enforces the sync path's conflict-target rule, so
736 # the two halves of this driver cannot drift.
737 120 my $opts = $rest_c[1];
738  
739 # The plan's decision must survive until sql_maker->insert runs, so the
740 # local fold of its private keys lives at SUB scope (an if-block would end
741 # the localisation before the maker ever saw it -- and the maker's consume
742 # of on_conflict is a delete, which would then bite into the caller's
743 # structure instead of the localised copy).
744 120 my $plan;
745 120 ▶ if ($opts && ref $opts eq 'HASH' && $opts->{on_conflict}
Branch: 1 branch
BranchTrueFalseTotal
if ($opts and ref $opts eq "HASH" and $opts->{"on_conflict"} and builtin::blessed($source)) 16 104 120
Condition66%6/9
$opts and ref $opts eq "HASH" and $opts->{"on_conflict"} and builtin::blessed($source)
!ll&&!rl&&r
104016
$opts and ref $opts eq "HASH" and $opts->{"on_conflict"}
!ll&&!rl&&r
104016
$opts and ref $opts eq "HASH"
!ll&&!rl&&r
104016
MC/DC25%1/4
$opts and ref $opts eq "HASH" and $opts->{"on_conflict"} and builtin::blessed($source)
$opts ref $opts eq "HASH" $opts->{"on_conflict"} builtin::blessed($source)
Truth table40%2/5
A and B and C and D
A= $optsB= ref $opts eq "HASH"C= $opts->{"on_conflict"}D= builtin::blessed($source)
ABCDresult
0XXX0
10XX0
110X0
11100
11111
746 && Scalar::Util::blessed($source)) {
747 16 my $owner = $self->_owner_storage;
748 16 ▶ if ($owner && $owner->can('_mysql_upsert_plan')) {
Branch: 1 branch
BranchTrueFalseTotal
if ($owner and $owner->can("_mysql_upsert_plan")) 16 0 16
Condition33%1/3
$owner and $owner->can("_mysql_upsert_plan")
!ll&&!rl&&r
0016
MC/DC0%0/2
$owner and $owner->can("_mysql_upsert_plan")
$owner $owner->can("_mysql_upsert_plan")
Truth table33%1/3
A and B
A= $ownerB= $owner->can("_mysql_upsert_plan")
ABresult
0X0
100
111
749 # This transport reads SELECT LAST_INSERT_ID(), never RETURNING: say so
750 # to the plan (karr k47), on a copy -- the hint is for the plan alone,
751 # neither the maker nor the caller's structure gets to see it.
752 16 $plan = $owner->_mysql_upsert_plan(
753 $source, $plan_data, { %$opts, returning => 0 },
754 );
755 }
756 }
757 119 ▶ local $opts->{on_conflict} = { %{ $opts->{on_conflict} }, %{ $plan->{extra} } }
Branch: 1 branch
BranchTrueFalseTotal
if $plan 15 104 119
758 if $plan;
759  
760 119 ▶ my $table = (Scalar::Util::blessed($source) && $source->can('name'))
Branch: 1 branch
BranchTrueFalseTotal
builtin::blessed($source) && $source->can('name') ? : 36 83 119
Condition66%2/3
builtin::blessed($source) and $source->can("name")
!ll&&!rl&&r
83036
MC/DC50%1/2
builtin::blessed($source) and $source->can("name")
builtin::blessed($source) $source->can("name")
Truth table66%2/3
A and B
A= builtin::blessed($source)B= $source->can("name")
ABresult
0X0
100
111
761 ? $source->name
762 : $source;
763  
764 119 my ($sql, @bind) = $self->sql_maker->insert($table, @rest_c);
765  
766 # LAST_INSERT_ID() must run on the SAME connection as the INSERT, otherwise
767 # the session-scope LII is undefined / from a prior session. Both run pinned
768 # on $conn, so the SELECT never hits a foreign session's LII.
769 119 my $bind_attrs = $self->_crud_bind_attrs(insert => $source, \@bind, $table, @rest_c);
770 108 ▶ return $self->_query_async_pinned($conn, $sql, \@bind, $bind_attrs)->then(sub {
Subroutine __ANON__: called CC=1 SCAR=0.0
771 108 return $self->_query_async_pinned($conn, 'SELECT LAST_INSERT_ID()', []);
772 106 ▶ })->then(sub {
Subroutine __ANON__: called CC=8 SCAR=21.6
773 106 my $lii_row = shift;
774 106 ▶ my $lii_id = (ref $lii_row eq 'ARRAY' && @$lii_row) ? $lii_row->[0] : undef;
Branch: 1 branch
BranchTrueFalseTotal
ref $lii_row eq 'ARRAY' && @$lii_row ? : 106 0 106
Condition33%1/3
ref $lii_row eq "ARRAY" and @$lii_row
!ll&&!rl&&r
00106
MC/DC0%0/2
ref $lii_row eq "ARRAY" and @$lii_row
ref $lii_row eq "ARRAY" @$lii_row
Truth table33%1/3
A and B
A= ref $lii_row eq "ARRAY"B= @$lii_row
ABresult
0X0
100
111
775 # Capture for legacy ->last_insert_id callers (e.g. scripts, tests).
776 106 ▶ $self->{_last_insert_id} = $lii_id if defined $lii_id;
Branch: 1 branch
BranchTrueFalseTotal
if defined $lii_id 106 0 106
777 106 my $returned = $self->_insert_returned_columns($source, $insert_data, $lii_row);
778  
779 # The whole plan counts, as in DBIO::MySQL::Storage::insert (karr k68):
780 # where it cannot name the row, whatever primary key value is in hand
781 # belongs to the row we tried to insert -- withholding it is the
782 # difference between undef and a confidently wrong row. wants_identity is
783 # false for result => 'void'/'count', where nothing is withheld.
784 106 ▶ if ($plan && ! $plan->{nameable} && $plan->{wants_identity}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($plan and not $plan->{"nameable"} and $plan->{"wants_identity"}) 2 104 106
Condition83%5/6
$plan and not $plan->{"nameable"} and $plan->{"wants_identity"}
!ll&&!rl&&r
10402
$plan and not $plan->{"nameable"}
!ll&&!rl&&r
91132
MC/DC66%2/3
$plan and not $plan->{"nameable"} and $plan->{"wants_identity"}
$plan not $plan->{"nameable"} $plan->{"wants_identity"}
Truth table75%3/4
A and not(B) and C
A= $planB= not $plan->{"nameable"}C= $plan->{"wants_identity"}
ABCresult
0XX0
10X0
1100
1111
785 2 delete @{$returned}{ @{ $plan->{primary_columns} } };
786 2 ▶ carp_once($plan->{reason}) if defined $plan->{reason};
Branch: 1 branch
BranchTrueFalseTotal
if defined $plan->{"reason"} 2 0 2
787 }
788  
789 106 return $returned;
790 119 });
791 120 });
792 }
793  
794  
795 110 ▶sub _insert_returned_columns {
Subroutine _insert_returned_columns: called CC=9 SCAR=22.0
796 110 my ($self, $source, $to_insert, $lii_row) = @_;
797  
798 110 ▶ my %returned = %{ $to_insert || {} };
Condition50%1/2
$to_insert || {}
l!l
1100
MC/DC0%0/1
$to_insert || {}
$to_insert
Truth table50%1/2
A
A= $to_insert
Aresult
11
00
799 110 ▶ return \%returned unless defined $lii_row && ref $lii_row eq 'ARRAY' && @$lii_row;
Branch: 1 branch
BranchTrueFalseTotal
unless defined $lii_row and ref $lii_row eq "ARRAY" and @$lii_row 3 107 110
Condition100%6/6
defined $lii_row and ref $lii_row eq "ARRAY" and @$lii_row
!ll&&!rl&&r
21107
defined $lii_row and ref $lii_row eq "ARRAY"
!ll&&!rl&&r
11108
MC/DC100%3/3
defined $lii_row and ref $lii_row eq "ARRAY" and @$lii_row
defined $lii_row ref $lii_row eq "ARRAY" @$lii_row
Truth table100%4/4
A and B and C
A= defined $lii_rowB= ref $lii_row eq "ARRAY"C= @$lii_row
ABCresult
0XX0
10X0
1100
1111
800 107 my $lii_id = $lii_row->[0];
801 107 ▶ return \%returned unless defined $lii_id;
Branch: 1 branch
BranchTrueFalseTotal
unless defined $lii_id 1 106 107
802  
803 106 my $col = $self->_auto_increment_column($source, $to_insert);
804 106 ▶ return \%returned unless defined $col;
Branch: 1 branch
BranchTrueFalseTotal
unless defined $col 72 34 106
805  
806 # A value the caller gave is the row's value; LAST_INSERT_ID() does not
807 # know it (karr k68). A literal (\'DEFAULT', \'UUID()') is computed by the
808 # server and is as unknown here as an absent or undef one.
809 return \%returned
810 if defined $to_insert->{$col}
811 34 ▶ && ! DBIO::Util::is_literal_value($to_insert->{$col});
Branch: 1 branch
BranchTrueFalseTotal
if defined $to_insert->{$col} and not &DBIO::Util::is_literal_value($to_insert->{$col}) 6 28 34
Condition100%3/3
defined $to_insert->{$col} and not &DBIO::Util::is_literal_value($to_insert->{$col})
!ll&&!rl&&r
2716
MC/DC100%2/2
defined $to_insert->{$col} and not &DBIO::Util::is_literal_value($to_insert->{$col})
defined $to_insert->{$col} not &DBIO::Util::is_literal_value($to_insert->{$col})
Truth table100%3/3
A and not(B)
A= defined $to_insert->{$col}B= not &DBIO::Util::is_literal_value($to_insert->{$col})
ABresult
0X0
100
111
812  
813 28 $returned{$col} = $lii_id;
814  
815 28 return \%returned;
816 }
817  
818 # The auto-increment column the caller gave the value 0 (not a literal), or
819 # undef. The server reads that 0 as "generate" unless the session's sql_mode
820 # has NO_AUTO_VALUE_ON_ZERO (karr k68).
821 120 ▶sub _zero_auto_increment_column {
Subroutine _zero_auto_increment_column: called CC=10 SCAR=23.1
822 120 my ($self, $source, $to_insert) = @_;
823 120 ▶ return unless ref $to_insert eq 'HASH'
Branch: 1 branch
BranchTrueFalseTotal
unless ref $to_insert eq "HASH" and builtin::blessed($source) and $source->can("columns_info") 84 36 120
Condition83%5/6
ref $to_insert eq "HASH" and builtin::blessed($source) and $source->can("columns_info")
!ll&&!rl&&r
83136
ref $to_insert eq "HASH" and builtin::blessed($source)
!ll&&!rl&&r
08337
MC/DC66%2/3
ref $to_insert eq "HASH" and builtin::blessed($source) and $source->can("columns_info")
ref $to_insert eq "HASH" builtin::blessed($source) $source->can("columns_info")
Truth table75%3/4
A and B and C
A= ref $to_insert eq "HASH"B= builtin::blessed($source)C= $source->can("columns_info")
ABCresult
0XX0
10X0
1100
1111
824 && Scalar::Util::blessed($source) && $source->can('columns_info');
825 36 ▶ my $col_infos = eval { $source->columns_info } || {};
Condition50%1/2
eval { do { $source->columns_info } } || {}
l!l
360
MC/DC0%0/1
eval { do { $source->columns_info } } || {}
eval { do { $source->columns_info } }
Truth table50%1/2
A
A= eval { do { $source->columns_info } }
Aresult
11
00
826 36 for my $col ($source->columns) {
827 39 ▶ next unless $col_infos->{$col}{is_auto_increment};
Branch: 1 branch
BranchTrueFalseTotal
unless $col_infos->{$col}{"is_auto_increment"} 5 34 39
828 34 my $v = $to_insert->{$col};
829 34 ▶ return $col if defined $v && ! ref $v && $v =~ /\A\s*[+-]?0+(?:\.0*)?\s*\z/;
Branch: 1 branch
BranchTrueFalseTotal
if defined $v and not ref $v and $v =~ /\A\s*[+-]?0+(?:\.0*)?\s*\z/ 4 30 34
Condition100%6/6
defined $v and not ref $v and $v =~ /\A\s*[+-]?0+(?:\.0*)?\s*\z/
!ll&&!rl&&r
2554
defined $v and not ref $v
!ll&&!rl&&r
2419
MC/DC100%3/3
defined $v and not ref $v and $v =~ /\A\s*[+-]?0+(?:\.0*)?\s*\z/
defined $v not ref $v $v =~ /\A\s*[+-]?0+(?:\.0*)?\s*\z/
Truth table100%4/4
A and not(B) and C
A= defined $vB= not ref $vC= $v =~ /\A\s*[+-]?0+(?:\.0*)?\s*\z/
ABCresult
0XX0
10X0
1100
1111
830 30 return;
831 }
832 2 return;
833 }
834  
835 # Find the column a $storage->insert should drop the LAST_INSERT_ID() value
836 # into, matching the sync DBIO::Storage::DBI heuristic:
837 # - the first column with is_auto_increment, OR
838 # - the first PK column that wasn't supplied in $to_insert (no
839 # is_auto_increment flag on the schema, MySQL still hands back an
840 # LII because the PK is auto_increment server-side).
841 # Returns undef when neither applies (e.g. a table with no PK), in which
842 # case the hashref is left as the supplied insert data only.
843 106 ▶sub _auto_increment_column {
Subroutine _auto_increment_column: called CC=13 SCAR=25.8
844 106 my ($self, $source, $to_insert) = @_;
845 106 ▶ return unless Scalar::Util::blessed($source) && $source->can('columns');
Branch: 1 branch
BranchTrueFalseTotal
unless builtin::blessed($source) and $source->can("columns") 71 35 106
Condition100%3/3
builtin::blessed($source) and $source->can("columns")
!ll&&!rl&&r
70135
MC/DC100%2/2
builtin::blessed($source) and $source->can("columns")
builtin::blessed($source) $source->can("columns")
Truth table100%3/3
A and B
A= builtin::blessed($source)B= $source->can("columns")
ABresult
0X0
100
111
846  
847 35 ▶ my $col_infos = eval { $source->columns_info } || {};
Condition50%1/2
eval { do { $source->columns_info } } || {}
l!l
350
MC/DC0%0/1
eval { do { $source->columns_info } } || {}
eval { do { $source->columns_info } }
Truth table50%1/2
A
A= eval { do { $source->columns_info } }
Aresult
11
00
848 35 ▶ my @pks = $source->can('primary_columns') ? $source->primary_columns : ();
Branch: 1 branch
BranchTrueFalseTotal
$source->can('primary_columns') ? : 35 0 35
849 35 my %is_pk = map { $_ => 1 } @pks;
850  
851 35 my $first_autoinc;
852 my $first_pk_unsupplied;
853 35 for my $col ($source->columns) {
854 121 ▶ if (!defined $first_autoinc
Branch: 1 branch
BranchTrueFalseTotal
if (not defined $first_autoinc and $col_infos->{$col}{"is_auto_increment"} // 0) 33 88 121
Condition80%4/5
not defined $first_autoinc and $col_infos->{$col}{"is_auto_increment"} // 0
!ll&&!rl&&r
83533
$col_infos->{$col}{"is_auto_increment"} // 0
l!l
380
MC/DC50%1/2
not defined $first_autoinc and $col_infos->{$col}{"is_auto_increment"} // 0
not defined $first_autoinc $col_infos->{$col}{"is_auto_increment"}
Truth table66%2/3
not(A) and B
A= not defined $first_autoincB= $col_infos->{$col}{"is_auto_increment"}
ABresult
0X0
100
111
855 && ($col_infos->{$col}{is_auto_increment} // 0)) {
856 33 $first_autoinc = $col;
857 }
858 121 ▶ if ($is_pk{$col}
Branch: 1 branch
BranchTrueFalseTotal
if ($is_pk{$col} and not defined $first_pk_unsupplied and not exists $to_insert->{$col}) 25 96 121
Condition83%5/6
$is_pk{$col} and not defined $first_pk_unsupplied and not exists $to_insert->{$col}
!ll&&!rl&&r
861025
$is_pk{$col} and not defined $first_pk_unsupplied
!ll&&!rl&&r
86035
MC/DC66%2/3
$is_pk{$col} and not defined $first_pk_unsupplied and not exists $to_insert->{$col}
$is_pk{$col} not defined $first_pk_unsupplied not exists $to_insert->{$col}
Truth table75%3/4
A and not(B) and not(C)
A= $is_pk{$col}B= not defined $first_pk_unsuppliedC= not exists $to_insert->{$col}
ABCresult
0XX0
10X0
1100
1111
859 && !defined $first_pk_unsupplied
860 && !exists $to_insert->{$col}) {
861 25 $first_pk_unsupplied = $col;
862 }
863 }
864  
865 35 ▶ return $first_autoinc if defined $first_autoinc;
Branch: 1 branch
BranchTrueFalseTotal
if defined $first_autoinc 33 2 35
866 2 return $first_pk_unsupplied;
867 }
868  
869 # --- Pool connect-action replay seam (karr k68 / k18) -------------------------
870  
871  
872 13 ▶sub _run_pool_connect_statement {
Subroutine _run_pool_connect_statement: called CC=9 SCAR=22.0
873 13 my ($self, $conn, $sql, $attrs, @bind) = @_;
874 13 require EV;
875  
876 # The connection was just spawned; its async connect may still be in flight.
877 # Block the EV loop until it is ready (the core seam's synchronous contract)
878 # -- prepare/execute are exclusive ops and need an idle, connected handle.
879 # Wait on the pool's per-connection readiness Future
880 # (DBIO::Storage::PoolBase::_connection_ready_future -- core's default since
881 # karr k33, which DBIO::MySQL::EV::Pool opts into): it is FAILED when the
882 # spawn's connect fails, so a connection that never comes up throws here
883 # instead of busy-spinning on an is_connected that will never turn true
884 # (k29). Fall back to is_connected for a pool that does not expose the
885 # readiness seam (e.g. a bare test double that is not a PoolBase subclass at
886 # all).
887 13 my $pool = $self->pool;
888 13 ▶ if ($pool->can('_connection_ready_future')) {
Branch: 1 branch
BranchTrueFalseTotal
if ($pool->can('_connection_ready_future')) { } 3 10 13
889 3 my $ready = $pool->_connection_ready_future($conn);
890 3 ▶ EV::run(EV::RUN_ONCE()) until $ready->is_ready;
Branch: 1 branch
BranchTrueFalseTotal
$ready->is_ready or do { &EV::run(2) } 3 5 8
891 3 $ready->get; # rethrows the connect error
892 }
893 else {
894 10 ▶ EV::run(EV::RUN_ONCE()) until $conn->is_connected;
Branch: 1 branch
BranchTrueFalseTotal
$conn->is_connected or do { &EV::run(2) } 10 0 10
895 }
896  
897 12 $sql = $self->_transform_sql($sql);
898  
899 # Through the executor, like every other statement of this transport: a
900 # bound connect statement is prepared, executed AND closed (karr k45 -- this
901 # runner used to carry its own prepare + execute and leaked the statement).
902 # Connect actions are almost always bindless SET statements, which stay on
903 # the plain query path.
904 12 my $f = $self->_executor->execute($conn, $sql, [@bind]);
905 12 ▶ EV::run(EV::RUN_ONCE()) until $f->is_ready;
Branch: 1 branch
BranchTrueFalseTotal
$f->is_ready or do { &EV::run(2) } 12 13 25
906  
907 12 ▶ croak 'pool connect statement failed: ' . ($f->failure // 'cancelled')
Branch: 1 branch
BranchTrueFalseTotal
unless $f->is_done 1 11 12
Condition50%1/2
$f->failure // "cancelled"
l!l
10
MC/DC0%0/1
$f->failure // "cancelled"
$f->failure
Truth table50%1/2
A
A= $f->failure
Aresult
11
00
908 unless $f->is_done;
909 11 ▶ return [ $f->get ] if $attrs && $attrs->{dbio_rows};
Branch: 1 branch
BranchTrueFalseTotal
if $attrs and $attrs->{"dbio_rows"} 5 6 11
Condition100%3/3
$attrs and $attrs->{"dbio_rows"}
!ll&&!rl&&r
515
MC/DC100%2/2
$attrs and $attrs->{"dbio_rows"}
$attrs $attrs->{"dbio_rows"}
Truth table100%3/3
A and B
A= $attrsB= $attrs->{"dbio_rows"}
ABresult
0X0
100
111
910 6 return;
911 }
912  
913 # --- LISTEN / NOTIFY seams (emulated over a notify table) ---------------------
914 #
915 # Core DBIO::Storage::Async owns the contract and the machinery (core ADR 0056);
916 # DBIO::MySQL::NotifyTable owns the emulation's SQL and its per-channel state
917 # (dbio-mysql ADR 0008). What is left is the EV::MariaDB wiring (ADR 0010).
918 # Private helpers are named _mysql_*, as in dbio-mysql's future_io transport,
919 # never _listen_* or _watch_*: they share an inheritance chain with core's
920 # privates, and a same-named method appearing there later would be shadowed.
921 #
922 # The listen connection is a hashref, opaque to core:
923 #
924 # mdb the EV::MariaDB handle; gone once closed
925 # notify its DBIO::MySQL::NotifyTable -- the marks of this connection
926 # pid the process that opened it
927 # busy true while a statement runs on the handle
928 # queue statements waiting for it: [ $sql, \@bind, $future ]
929 # watch the poll loop's state { pid, timer }; gone once unwatched
930 # fork the EV::fork watcher that disarms the handle in a child
931 #
932 # prepare, execute, close_stmt and ping are EXCLUSIVE in EV::MariaDB: each dies
933 # while any other operation is pending on the handle. So every statement of
934 # the emulation -- a mark, a poll, a cleanup -- goes through one FIFO runner
935 # (_mysql_listen_statement), and nothing else is ever sent on the handle.
936  
937  
938 126 ▶sub _listen_open {
Subroutine _listen_open: called CC=3 SCAR=11.0
939 126 my ($self) = @_;
940 126 require EV;
941 126 require EV::MariaDB;
942  
943 126 my $notify = $self->_mysql_notify_table;
944 125 my $provider = $self->_conninfo_provider;
945 125 ▶ my $conninfo = $provider ? $provider->() : $self->{_conninfo};
Branch: 1 branch
BranchTrueFalseTotal
$provider ? : 86 39 125
946 98 ▶ croak 'the listen connection has no connect info -- call connect_info first'
Branch: 1 branch
BranchTrueFalseTotal
unless defined $conninfo 12 86 98
947 unless defined $conninfo;
948 # Neither a host nor a user: EV::MariaDB would start no connect and call back
949 # nothing, and the Future below would never settle (karr k66).
950 86 DBIO::MySQL::EV::Pool->_mysql_refuse_unconnectable($conninfo);
951  
952 84 my $f = $self->future_class->new;
953 84 my $conn = { notify => $notify, pid => $$, busy => 0, queue => [] };
954  
955 # Held until the connect settles: nothing else references the connection
956 # before core receives it. The cycle this makes through the handle's
957 # callbacks ends when the Future is ready, which drops its callbacks.
958 84 my $hold = $conn;
959 84 ▶ $f->on_ready(sub { undef $hold });
Subroutine __ANON__: called CC=1 SCAR=0.0
960  
961 84 my ($on_connect, $on_error) = $self->_mysql_listen_handlers($f, $conn);
962 # Made where the pool's handles are made: no password in what the handle
963 # says, the croak of its constructor and its on_error alike (karr k76).
964 84 $conn->{mdb} = DBIO::MySQL::EV::Pool->_mysql_new_handle(
965 %$conninfo,
966 on_connect => $on_connect,
967 on_error => $on_error,
968 );
969 # keepalive(0): the watcher is a guard, never a reason for the loop to go on
970 # running -- in a child, after it fired, it would otherwise keep EV::run from
971 # ever returning (karr k46).
972 84 $conn->{fork} = EV::fork(_mysql_listen_fork_cb($conn));
973 84 $conn->{fork}->keepalive(0);
974 84 return $f;
975 }
976  
977 # The handle's on_connect / on_error. They share the open's Future only until
978 # the connect settles: the handle keeps its handlers for its lifetime, and the
979 # Future holds the connection it resolved with.
980 84 ▶sub _mysql_listen_handlers {
Subroutine _mysql_listen_handlers: called CC=1 SCAR=0.2
981 84 my ($self, $f, $conn) = @_;
982 84 Scalar::Util::weaken(my $weak_self = $self);
983 84 Scalar::Util::weaken(my $weak_conn = $conn);
984 84 my $pending = $f;
985  
986 82 ▶ my $on_connect = sub {
Subroutine __ANON__: called CC=4 SCAR=14.5
987 82 ▶ my $conn = $weak_conn or return;
Branch: 1 branch
BranchTrueFalseTotal
my $conn = $weak_conn or return 82 0 82
988 82 ▶ return unless $conn->{pid} == $$;
Branch: 1 branch
BranchTrueFalseTotal
unless $conn->{"pid"} == $$ 0 82 82
989 82 ▶ my $f = $pending or return;
Branch: 1 branch
BranchTrueFalseTotal
my $f = $pending or return 82 0 82
990 82 undef $pending;
991 82 $f->done($conn);
992 82 return;
993 84 };
994 2 ▶ my $on_error = sub {
Subroutine __ANON__: called CC=6 SCAR=21.4
995 2 my ($msg) = @_;
996 2 my ($self, $conn) = ($weak_self, $weak_conn);
997 2 ▶ return unless $conn && $conn->{pid} == $$;
Branch: 1 branch
BranchTrueFalseTotal
unless $conn and $conn->{"pid"} == $$ 0 2 2
Condition33%1/3
$conn and $conn->{"pid"} == $$
!ll&&!rl&&r
002
MC/DC0%0/2
$conn and $conn->{"pid"} == $$
$conn $conn->{"pid"} == $$
Truth table33%1/3
A and B
A= $connB= $conn->{"pid"} == $$
ABresult
0X0
100
111
998 2 ▶ $msg //= 'unknown error';
Condition50%1/2
$msg //= "unknown error"
l!l
20
MC/DC0%0/1
$msg //= "unknown error"
$msg
Truth table50%1/2
A
A= $msg
Aresult
11
00
999 2 chomp $msg;
1000 2 ▶ if (my $f = $pending) {
Branch: 1 branch
BranchTrueFalseTotal
if (my $f = $pending) 2 0 2
1001 2 undef $pending;
1002 2 $f->fail("connecting the listen connection failed: $msg");
1003 2 return;
1004 }
1005 0 ▶ $self->_listen_lost($conn, "the listen connection reported an error: $msg")
Branch: 1 branch
BranchTrueFalseTotal
if $self 0 0 0
1006 if $self;
1007 0 return;
1008 84 };
1009 84 return ($on_connect, $on_error);
1010 }
1011  
1012 84 ▶sub _mysql_listen_fork_cb {
Subroutine _mysql_listen_fork_cb: called CC=1 SCAR=4.6
1013 84 my ($conn) = @_;
1014 84 Scalar::Util::weaken(my $weak_conn = $conn);
1015 0 ▶ return sub {
Subroutine __ANON__: not called CC=4 SCAR=30.0
1016 0 ▶ my $conn = $weak_conn or return;
Branch: 1 branch
BranchTrueFalseTotal
my $conn = $weak_conn or return 0 0 0
1017 0 ▶ return if $conn->{pid} == $$;
Branch: 1 branch
BranchTrueFalseTotal
if $conn->{"pid"} == $$ 0 0 0
1018 # A child resumed the event loop. Its copy of the handle must not read
1019 # the parent's socket: stop the poll loop and finish the handle, which in
1020 # a forked process drops the watchers and the client state without
1021 # sending COM_QUIT or shutting the shared socket down.
1022 0 delete $conn->{watch};
1023 0 ▶ my $mdb = delete $conn->{mdb} or return;
Branch: 1 branch
BranchTrueFalseTotal
my $mdb = delete $conn->{"mdb"} or return 0 0 0
1024 0 local $@;
1025 0 eval { $mdb->finish; 1 };
1026 0 return;
1027 84 };
1028 }
1029  
1030  
1031 82 ▶sub _listen_close {
Subroutine _listen_close: called CC=5 SCAR=17.0
1032 82 my ($self, $conn) = @_;
1033 82 delete $conn->{watch};
1034 82 delete $conn->{fork};
1035 82 ▶ my @waiting = splice @{ $conn->{queue} || [] };
Condition50%1/2
$conn->{'queue'} || []
l!l
820
MC/DC0%0/1
$conn->{'queue'} || []
$conn->{'queue'}
Truth table50%1/2
A
A= $conn->{'queue'}
Aresult
11
00
1036 82 ▶ if (my $mdb = delete $conn->{mdb}) {
Branch: 1 branch
BranchTrueFalseTotal
if (my $mdb = delete $conn->{"mdb"}) 82 0 82
1037 82 local $@;
1038 82 eval { $mdb->finish; 1 };
1039 }
1040 82 for my $item (@waiting) {
1041 0 ▶ $item->[2]->fail('the listen connection was closed') unless $item->[2]->is_ready;
Branch: 1 branch
BranchTrueFalseTotal
unless $item->[2]->is_ready 0 0 0
1042 }
1043 82 return;
1044 }
1045  
1046  
1047 31 ▶sub _listen_subscribe {
Subroutine _listen_subscribe: called CC=3 SCAR=11.6
1048 31 my ($self, $conn, $channel) = @_;
1049 31 my $notify = $conn->{notify};
1050 croak "LISTEN on channel '$channel': the listen connection is closed"
1051 31 ▶ unless $notify && $conn->{mdb};
Branch: 1 branch
BranchTrueFalseTotal
unless $notify and $conn->{"mdb"} 0 31 31
Condition33%1/3
$notify and $conn->{"mdb"}
!ll&&!rl&&r
0031
MC/DC0%0/2
$notify and $conn->{"mdb"}
$notify $conn->{"mdb"}
Truth table33%1/3
A and B
A= $notifyB= $conn->{"mdb"}
ABresult
0X0
100
111
1052 31 my ($sql, $bind) = $notify->subscribe_sql($channel);
1053 31 my $fc = $self->future_class;
1054 31 return $self->_mysql_listen_statement($conn, $sql, $bind)->then(
1055 _mysql_subscribed_cb($fc, $notify, $channel),
1056 _mysql_subscribe_failed_cb($fc, $notify),
1057 );
1058 }
1059  
1060 31 ▶sub _mysql_subscribed_cb {
Subroutine _mysql_subscribed_cb: called CC=1 SCAR=0.0
1061 31 my ($fc, $notify, $channel) = @_;
1062 30 ▶ return sub {
Subroutine __ANON__: called CC=1 SCAR=0.0
1063 30 my ($rows) = @_;
1064 30 $notify->subscribed($channel, $rows);
1065 30 return $fc->done;
1066 31 };
1067 }
1068  
1069 31 ▶sub _mysql_subscribe_failed_cb {
Subroutine _mysql_subscribe_failed_cb: called CC=1 SCAR=0.3
1070 31 my ($fc, $notify) = @_;
1071 1 ▶ return sub {
Subroutine __ANON__: called CC=3 SCAR=12.5
1072 1 my ($err) = @_;
1073 1 ▶ $err = sprintf(
Branch: 1 branch
BranchTrueFalseTotal
if defined $err and $err =~ /doesn't exist/ 1 0 1
Condition33%1/3
defined $err and $err =~ /doesn't exist/
!ll&&!rl&&r
001
MC/DC0%0/2
defined $err and $err =~ /doesn't exist/
defined $err $err =~ /doesn't exist/
Truth table33%1/3
A and B
A= defined $errB= $err =~ /doesn't exist/
ABresult
0X0
100
111
1074 'the notify table %s does not exist -- MySQL has no LISTEN/NOTIFY, and '
1075 . 'its emulation needs that table: deploy it once with deploy_notify_table, '
1076 . 'or run DBIO::MySQL::NotifyTable->create_table_sql from a migration (%s)',
1077 $notify->quoted_table, $err,
1078 ) if defined $err && $err =~ /doesn't exist/;
1079 1 return $fc->fail($err);
1080 31 };
1081 }
1082  
1083  
1084 4 ▶sub _listen_unsubscribe {
Subroutine _listen_unsubscribe: called CC=2 SCAR=7.0
1085 4 my ($self, $conn, $channel) = @_;
1086 4 my $notify = $conn->{notify};
1087 4 ▶ $notify->unsubscribe($channel) if $notify;
Branch: 1 branch
BranchTrueFalseTotal
if $notify 4 0 4
1088 4 return $self->future_class->done;
1089 }
1090  
1091  
1092 24 ▶sub _listen_watch {
Subroutine _listen_watch: called CC=3 SCAR=11.6
1093 24 my ($self, $conn) = @_;
1094 24 require EV;
1095 24 ▶ croak 'the listen connection is closed' unless $conn->{mdb} && $conn->{notify};
Branch: 1 branch
BranchTrueFalseTotal
unless $conn->{"mdb"} and $conn->{"notify"} 0 24 24
Condition33%1/3
$conn->{"mdb"} and $conn->{"notify"}
!ll&&!rl&&r
0024
MC/DC0%0/2
$conn->{"mdb"} and $conn->{"notify"}
$conn->{"mdb"} $conn->{"notify"}
Truth table33%1/3
A and B
A= $conn->{"mdb"}B= $conn->{"notify"}
ABresult
0X0
100
111
1096 24 my $watch = $conn->{watch} = { pid => $$ };
1097 24 $self->_mysql_listen_arm($conn, $watch);
1098 24 return;
1099 }
1100  
1101  
1102 24 ▶sub _listen_unwatch {
Subroutine _listen_unwatch: called CC=2 SCAR=7.1
1103 24 my ($self, $conn) = @_;
1104 24 ▶ delete $conn->{watch} if ref $conn;
Branch: 1 branch
BranchTrueFalseTotal
if ref $conn 24 0 24
1105 24 return;
1106 }
1107  
1108  
1109 19 ▶sub _listen_probe {
Subroutine _listen_probe: called CC=4 SCAR=13.9
1110 19 my ($self, $conn) = @_;
1111 19 ▶ my $mdb = $conn->{mdb} or return 0;
Branch: 1 branch
BranchTrueFalseTotal
my $mdb = $conn->{"mdb"} or return 0 18 1 19
1112 18 ▶ return 1 if $conn->{busy};
Branch: 1 branch
BranchTrueFalseTotal
if $conn->{"busy"} 2 16 18
1113 16 ▶ return DBIO::MySQL::EV::Pool->_mysql_connection_gone($mdb) ? 0 : 1;
Branch: 1 branch
BranchTrueFalseTotal
'DBIO::MySQL::EV::Pool'->_mysql_connection_gone($mdb) ? : 7 9 16
1114 }
1115  
1116  
1117 581 ▶sub _listen_delay {
Subroutine _listen_delay: called CC=1 SCAR=0.0
1118 581 my ($self, $seconds) = @_;
1119 581 require EV;
1120 581 my $f = $self->future_class->new;
1121 581 my $timer;
1122 581 EV::now_update(); # a timer counts from the loop's last "now", maybe long ago
1123 6 ▶ $timer = EV::timer($seconds, 0, sub {
Subroutine __ANON__: called CC=2 SCAR=7.2
1124 6 undef $timer;
1125 6 ▶ $f->done unless $f->is_ready;
Branch: 1 branch
BranchTrueFalseTotal
unless $f->is_ready 6 0 6
1126 581 });
1127 581 ▶ $f->on_cancel(sub { undef $timer });
Subroutine __ANON__: called CC=1 SCAR=0.0
1128 581 return $f;
1129 }
1130  
1131  
1132 31 ▶sub _notify_send {
Subroutine _notify_send: called CC=1 SCAR=0.0
1133 31 my ($self, $channel, $payload) = @_;
1134 31 my ($sql, $bind) = $self->_mysql_notify_table->notify_sql($channel, $payload);
1135 30 return $self->_query_async($sql, $bind);
1136 }
1137  
1138  
1139 1 ▶sub deploy_notify_table {
Subroutine deploy_notify_table: called CC=1 SCAR=0.0
Pod documented
1140 1 my ($self) = @_;
1141 1 ▶ return $self->future_class->call(sub {
Subroutine __ANON__: called CC=1 SCAR=0.0
1142 1 $self->_query_async($self->_mysql_notify_table->create_table_sql, []);
1143 1 });
1144 }
1145  
1146 # The notify table of the current settings; croaks on invalid ones.
1147 158 ▶sub _mysql_notify_table {
Subroutine _mysql_notify_table: called CC=1 SCAR=0.0
1148 158 my ($self) = @_;
1149 158 return DBIO::MySQL::NotifyTable->new(
1150 table => $self->notify_table,
1151 poll_interval => $self->notify_poll_interval,
1152 lookback => $self->notify_lookback,
1153 retention => $self->notify_retention,
1154 );
1155 }
1156  
1157 # --- the listen connection's statement runner ---
1158 #
1159 # One statement at a time, in the order asked for. A statement with binds is
1160 # prepare -> execute -> close_stmt: the close frees the server-side statement
1161 # (a poll a second would otherwise leave 3600 of them behind an hour) and is
1162 # exclusive itself, so the handle only counts as idle once it is done. One
1163 # without binds is a plain query. Resolves with the rows (a SELECT) or the
1164 # affected-row count; fails with the server's error.
1165  
1166 124 ▶sub _mysql_listen_statement {
Subroutine _mysql_listen_statement: called CC=2 SCAR=7.0
1167 124 my ($self, $conn, $sql, $bind) = @_;
1168 124 my $f = $self->future_class->new;
1169 124 ▶ push @{ $conn->{queue} }, [ $sql, $bind // [], $f ];
Condition50%1/2
$bind // []
l!l
1240
MC/DC0%0/1
$bind // []
$bind
Truth table50%1/2
A
A= $bind
Aresult
11
00
1170 124 $self->_mysql_listen_next($conn);
1171 124 return $f;
1172 }
1173  
1174 248 ▶sub _mysql_listen_next {
Subroutine _mysql_listen_next: called CC=8 SCAR=20.9
1175 248 my ($self, $conn) = @_;
1176 248 ▶ return if $conn->{busy} || $conn->{pid} != $$;
Branch: 1 branch
BranchTrueFalseTotal
if $conn->{"busy"} or $conn->{"pid"} != $$ 19 229 248
Condition66%2/3
$conn->{"busy"} or $conn->{"pid"} != $$
l!l&&r!l&&!r
190229
MC/DC50%1/2
$conn->{"busy"} or $conn->{"pid"} != $$
$conn->{"busy"} $conn->{"pid"} != $$
Truth table66%2/3
A or B
A= $conn->{"busy"}B= $conn->{"pid"} != $$
ABresult
1X1
011
000
1177 229 ▶ my $item = shift @{ $conn->{queue} } or return;
Branch: 1 branch
BranchTrueFalseTotal
my $item = shift @{$$conn{"queue"};} or return 124 105 229
1178 124 my ($sql, $bind, $f) = @$item;
1179 124 my $done = $self->_mysql_listen_done_cb($conn, $f, $sql, $bind);
1180 my $mdb = $conn->{mdb}
1181 124 ▶ or return $done->(undef, 'the listen connection is closed');
Branch: 1 branch
BranchTrueFalseTotal
my $mdb = $conn->{"mdb"} or return &$done(undef, "the listen connection is closed") 124 0 124
1182  
1183 124 $conn->{busy} = 1;
1184 124 my $ok;
1185 {
1186 124 local $@;
1187 124 $ok = eval {
1188 124 ▶ if (@$bind) {
Branch: 1 branch
BranchTrueFalseTotal
if (@$bind) { } 104 20 124
1189 104 $mdb->prepare($sql, _mysql_listen_prepared_cb($conn, $bind, $done));
1190 }
1191 else {
1192 20 $mdb->query($sql, $done);
1193 }
1194 123 1;
1195 };
1196 124 ▶ $done->(undef, $@ || 'starting a statement on the listen connection failed')
Branch: 1 branch
BranchTrueFalseTotal
unless $ok 1 123 124
Condition50%1/2
$@ || 'starting a statement on the listen connection failed'
l!l
10
MC/DC0%0/1
$@ || 'starting a statement on the listen connection failed'
$@
Truth table50%1/2
A
A= $@
Aresult
11
00
1197 unless $ok;
1198 }
1199 124 return;
1200 }
1201  
1202 104 ▶sub _mysql_listen_prepared_cb {
Subroutine _mysql_listen_prepared_cb: called CC=1 SCAR=0.6
1203 104 my ($conn, $bind, $done) = @_;
1204 104 Scalar::Util::weaken(my $weak_conn = $conn);
1205 103 ▶ return sub {
Subroutine __ANON__: called CC=11 SCAR=29.8
1206 103 my ($stmt, $err) = @_;
1207 103 my $conn = $weak_conn;
1208 103 ▶ return if $conn && $conn->{pid} != $$;
Branch: 1 branch
BranchTrueFalseTotal
if $conn and $conn->{"pid"} != $$ 0 103 103
Condition33%1/3
$conn and $conn->{"pid"} != $$
!ll&&!rl&&r
01030
MC/DC0%0/2
$conn and $conn->{"pid"} != $$
$conn $conn->{"pid"} != $$
Truth table33%1/3
A and B
A= $connB= $conn->{"pid"} != $$
ABresult
0X0
100
111
1209 return $done->(undef, $err // 'prepare failed',
1210 103 ▶ DBIO::MySQL::EV::QueryExecutor::_handle_code($conn && $conn->{mdb}, $err))
Branch: 1 branch
BranchTrueFalseTotal
if defined $err or not defined $stmt 2 101 103
Condition50%4/8
defined $err or not defined $stmt
l!l&&r!l&&!r
20101
$err // "prepare failed"
l!l
20
$conn && $conn->{'mdb'}
!ll&&!rl&&r
002
MC/DC50%1/2
defined $err or not defined $stmt
defined $err not defined $stmt
MC/DC0%0/1
$err // "prepare failed"
$err
MC/DC0%0/2
$conn && $conn->{'mdb'}
$conn $conn->{'mdb'}
Truth table66%2/3
A or not(B)
A= defined $errB= not defined $stmt
ABresult
1X1
011
000
Truth table50%1/2
A
A= $err
Aresult
11
00
Truth table33%1/3
A && B
A= $connB= $conn->{'mdb'}
ABresult
0X0
100
111
1211 if defined $err || !defined $stmt;
1212 my $mdb = $conn && $conn->{mdb}
1213 101 ▶ or return $done->(undef, 'the listen connection was closed');
Branch: 1 branch
BranchTrueFalseTotal
my $mdb = $conn && $conn->{"mdb"} or return &$done(undef, "the listen connection was closed") 101 0 101
Condition33%1/3
$conn && $conn->{'mdb'}
!ll&&!rl&&r
00101
MC/DC0%0/2
$conn && $conn->{'mdb'}
$conn $conn->{'mdb'}
Truth table33%1/3
A && B
A= $connB= $conn->{'mdb'}
ABresult
0X0
100
111
1214 101 local $@;
1215 101 eval { $mdb->execute($stmt, $bind, _mysql_listen_executed_cb($conn, $stmt, $done)); 1 }
1216 101 ▶ or do {
Branch: 1 branch
BranchTrueFalseTotal
eval { do { $mdb->execute($stmt, $bind, _mysql_listen_executed_cb($conn, $stmt, $done)); 1 } } or do { my $died = $@ || "execute failed"; &$done(undef, $died, DBIO::MySQL::EV::QueryExecutor::_handle_code($mdb, $died)) } 101 0 101
1217 0 ▶ my $died = $@ || 'execute failed';
Condition0%0/2
$@ || 'execute failed'
l!l
00
MC/DC0%0/1
$@ || 'execute failed'
$@
Truth table0%0/2
A
A= $@
Aresult
11
00
1218 0 $done->(undef, $died, DBIO::MySQL::EV::QueryExecutor::_handle_code($mdb, $died));
1219 };
1220 101 return;
1221 104 };
1222 }
1223  
1224 101 ▶sub _mysql_listen_executed_cb {
Subroutine _mysql_listen_executed_cb: called CC=1 SCAR=0.0
1225 101 my ($conn, $stmt, $done) = @_;
1226 101 Scalar::Util::weaken(my $weak_conn = $conn);
1227 101 ▶ return sub {
Subroutine __ANON__: called CC=6 SCAR=18.1
1228 101 my ($result, $err) = @_;
1229 101 my $conn = $weak_conn;
1230 101 ▶ return if $conn && $conn->{pid} != $$;
Branch: 1 branch
BranchTrueFalseTotal
if $conn and $conn->{"pid"} != $$ 0 101 101
Condition33%1/3
$conn and $conn->{"pid"} != $$
!ll&&!rl&&r
01010
MC/DC0%0/2
$conn and $conn->{"pid"} != $$
$conn $conn->{"pid"} != $$
Truth table33%1/3
A and B
A= $connB= $conn->{"pid"} != $$
ABresult
0X0
100
111
1231 101 ▶ my $mdb = $conn && $conn->{mdb};
Condition66%2/3
$conn && $conn->{'mdb'}
!ll&&!rl&&r
0299
MC/DC50%1/2
$conn && $conn->{'mdb'}
$conn $conn->{'mdb'}
Truth table66%2/3
A && B
A= $connB= $conn->{'mdb'}
ABresult
0X0
100
111
1232 # The execute's error number, read before the close: it is the execute's
1233 # error the handle holds now.
1234 101 my $code = DBIO::MySQL::EV::QueryExecutor::_handle_code($mdb, $err);
1235 101 my $closing;
1236 101 ▶ if ($mdb) {
Branch: 1 branch
BranchTrueFalseTotal
if ($mdb) 99 2 101
1237 99 local $@;
1238 99 ▶ $closing = eval { $mdb->close_stmt($stmt, sub { $done->($result, $err, $code) }); 1 };
Subroutine __ANON__: called CC=1 SCAR=0.0
1239 }
1240 101 ▶ $done->($result, $err, $code) unless $closing;
Branch: 1 branch
BranchTrueFalseTotal
unless $closing 2 99 101
1241 101 return;
1242 101 };
1243 }
1244  
1245 # Settles the statement's Future once the handle is idle again, then starts
1246 # the next one. Runs at most once: a close_stmt that croaked after calling
1247 # back must not settle twice.
1248 124 ▶sub _mysql_listen_done_cb {
Subroutine _mysql_listen_done_cb: called CC=1 SCAR=0.1
1249 124 my ($self, $conn, $f, $sql, $bind) = @_;
1250 124 Scalar::Util::weaken(my $weak_self = $self);
1251 124 Scalar::Util::weaken(my $weak_conn = $conn);
1252 124 my $settled;
1253 124 ▶ return sub {
Subroutine __ANON__: called CC=11 SCAR=25.9
1254 124 my ($result, $err, $code) = @_;
1255 124 ▶ return if $settled++;
Branch: 1 branch
BranchTrueFalseTotal
if $settled++ 0 124 124
1256 124 my ($self, $conn) = ($weak_self, $weak_conn);
1257 124 ▶ return if $conn && $conn->{pid} != $$;
Branch: 1 branch
BranchTrueFalseTotal
if $conn and $conn->{"pid"} != $$ 0 124 124
Condition33%1/3
$conn and $conn->{"pid"} != $$
!ll&&!rl&&r
01240
MC/DC0%0/2
$conn and $conn->{"pid"} != $$
$conn $conn->{"pid"} != $$
Truth table33%1/3
A and B
A= $connB= $conn->{"pid"} != $$
ABresult
0X0
100
111
1258 124 ▶ $conn->{busy} = 0 if $conn;
Branch: 1 branch
BranchTrueFalseTotal
if $conn 124 0 124
1259 124 ▶ unless ($f->is_ready) {
Branch: 1 branch
BranchTrueFalseTotal
unless ($f->is_ready) 124 0 124
1260 124 ▶ if (defined $err) {
Branch: 1 branch
BranchTrueFalseTotal
if (defined $err) { } 19 105 124
1261 # The notify statements bind a channel and a payload: the server's
1262 # text for them is masked like any statement's (ADR 0075 of the core).
1263 # The server's error number: given by the prepare and execute paths,
1264 # read here for the plain query, where the handle holds the error now.
1265 19 ▶ $code //= DBIO::MySQL::EV::QueryExecutor::_handle_code($conn && $conn->{mdb}, "$err");
Condition83%5/6
$code //= DBIO::MySQL::EV::QueryExecutor::_handle_code($conn && $conn->{"mdb"}, "$err")
l!l&&r!l&&!r
5410
$conn && $conn->{'mdb'}
!ll&&!rl&&r
0410
MC/DC100%2/2
$code //= DBIO::MySQL::EV::QueryExecutor::_handle_code($conn && $conn->{"mdb"}, "$err")
$code DBIO::MySQL::EV::QueryExecutor::_handle_code($conn && $conn->{"mdb"}, "$err")
MC/DC50%1/2
$conn && $conn->{'mdb'}
$conn $conn->{'mdb'}
Truth table100%3/3
A //= B
A= $codeB= DBIO::MySQL::EV::QueryExecutor::_handle_code($conn && $conn->{"mdb"}, "$err")
ABresult
1X1
011
000
Truth table66%2/3
A && B
A= $connB= $conn->{'mdb'}
ABresult
0X0
100
111
1266 19 chomp(my $msg = _mysql_mask_error("$err", $bind, $sql, $code));
1267 19 $f->fail($msg);
1268 }
1269 else {
1270 105 $f->done($result);
1271 }
1272 }
1273 124 ▶ $self->_mysql_listen_next($conn) if $self && $conn;
Branch: 1 branch
BranchTrueFalseTotal
if $self and $conn 124 0 124
Condition33%1/3
$self and $conn
!ll&&!rl&&r
00124
MC/DC0%0/2
$self and $conn
$self $conn
Truth table33%1/3
A and B
A= $selfB= $conn
ABresult
0X0
100
111
1274 124 return;
1275 124 };
1276 }
1277  
1278 # --- the poll loop ---
1279 #
1280 # Named subs, not nested closures: a callback built here closes over exactly
1281 # what it is handed, the storage, connection and watch only weakly. The watch
1282 # state is the loop's identity -- every step first checks it is still the one
1283 # on the connection and belongs to this process.
1284  
1285 231 ▶sub _mysql_listen_live {
Subroutine _mysql_listen_live: called CC=3 SCAR=11.3
1286 231 my ($conn, $watch) = @_;
1287 231 my $current = $conn->{watch};
1288 return $current
1289 && Scalar::Util::refaddr($current) == Scalar::Util::refaddr($watch)
1290 231 ▶ && $watch->{pid} == $$;
Condition66%4/6
$current && builtin::refaddr($current) == builtin::refaddr($watch) && $watch->{'pid'} == $$
!ll&&!rl&&r
10230
$current and builtin::refaddr($current) == builtin::refaddr($watch)
!ll&&!rl&&r
10230
MC/DC33%1/3
$current && builtin::refaddr($current) == builtin::refaddr($watch) && $watch->{'pid'} == $$
$current builtin::refaddr($current) == builtin::refaddr($watch) $watch->{'pid'} == $$
Truth table50%2/4
A and B && C
A= $currentB= builtin::refaddr($current) == builtin::refaddr($watch)C= $watch->{'pid'} == $$
ABCresult
0XX0
10X0
1100
1111
1291 }
1292  
1293 85 ▶sub _mysql_listen_arm {
Subroutine _mysql_listen_arm: called CC=1 SCAR=0.0
1294 85 my ($self, $conn, $watch) = @_;
1295 85 require EV;
1296 85 EV::now_update(); # a timer counts from the loop's last "now", maybe long ago
1297 $watch->{timer} = EV::timer(
1298 85 $conn->{notify}->poll_interval, 0,
1299 $self->_mysql_listen_cb($conn, $watch, '_mysql_listen_poll'),
1300 );
1301 85 return;
1302 }
1303  
1304 # A callback that runs $step($conn, $watch, @args, @callback_args) while the
1305 # watch is live, and treats anything it throws as a dead connection.
1306 166 ▶sub _mysql_listen_cb {
Subroutine _mysql_listen_cb: called CC=1 SCAR=0.0
1307 166 my ($self, $conn, $watch, $step, @args) = @_;
1308 166 Scalar::Util::weaken(my $weak_self = $self);
1309 166 Scalar::Util::weaken(my $weak_conn = $conn);
1310 166 Scalar::Util::weaken(my $weak_watch = $watch);
1311 149 ▶ return sub {
Subroutine __ANON__: called CC=9 SCAR=22.5
1312 149 my @cb_args = @_;
1313 149 my ($self, $conn, $watch) = ($weak_self, $weak_conn, $weak_watch);
1314 149 ▶ return unless $self && $conn && $watch && _mysql_listen_live($conn, $watch);
Branch: 1 branch
BranchTrueFalseTotal
unless $self and $conn and $watch and _mysql_listen_live($conn, $watch) 4 145 149
Condition55%5/9
$self and $conn and $watch and _mysql_listen_live($conn, $watch)
!ll&&!rl&&r
40145
$self and $conn and $watch
!ll&&!rl&&r
04145
$self and $conn
!ll&&!rl&&r
00149
MC/DC25%1/4
$self and $conn and $watch and _mysql_listen_live($conn, $watch)
$self $conn $watch _mysql_listen_live($conn, $watch)
Truth table40%2/5
A and B and C and D
A= $selfB= $connC= $watchD= _mysql_listen_live($conn, $watch)
ABCDresult
0XXX0
10XX0
110X0
11100
11111
1315 145 my $err;
1316 {
1317 145 local $@;
1318 145 ▶ eval { $self->$step($conn, $watch, @args, @cb_args); 1 }
Branch: 1 branch
BranchTrueFalseTotal
eval { do { $self->$step($conn, $watch, @args, @cb_args); 1 } } or $err = $@ || "the listen poll died without a message" 143 2 145
Condition50%1/2
$@ || 'the listen poll died without a message'
l!l
20
MC/DC0%0/1
$@ || 'the listen poll died without a message'
$@
Truth table50%1/2
A
A= $@
Aresult
11
00
1319 or $err = $@ || 'the listen poll died without a message';
1320 }
1321 145 ▶ return unless defined $err && _mysql_listen_live($conn, $watch);
Branch: 1 branch
BranchTrueFalseTotal
unless defined $err and _mysql_listen_live($conn, $watch) 143 2 145
Condition66%2/3
defined $err and _mysql_listen_live($conn, $watch)
!ll&&!rl&&r
14302
MC/DC50%1/2
defined $err and _mysql_listen_live($conn, $watch)
defined $err _mysql_listen_live($conn, $watch)
Truth table66%2/3
A and B
A= defined $errB= _mysql_listen_live($conn, $watch)
ABresult
0X0
100
111
1322 2 delete $conn->{watch};
1323 2 $self->_listen_lost($conn, $err);
1324 2 return;
1325 166 };
1326 }
1327  
1328 67 ▶sub _mysql_listen_poll {
Subroutine _mysql_listen_poll: called CC=4 SCAR=14.0
1329 67 my ($self, $conn, $watch) = @_;
1330 # A mark is being taken (or waits): this tick yields to it.
1331 return $self->_mysql_listen_arm($conn, $watch)
1332 67 ▶ if $conn->{busy} || @{ $conn->{queue} };
Branch: 1 branch
BranchTrueFalseTotal
if $conn->{"busy"} or @{$conn->{"queue"};} 1 66 67
Condition66%2/3
$conn->{"busy"} or @{$conn->{"queue"};}
l!l&&r!l&&!r
1066
MC/DC50%1/2
$conn->{"busy"} or @{$conn->{"queue"};}
$conn->{"busy"} @{$conn->{"queue"};}
Truth table66%2/3
A or B
A= $conn->{"busy"}B= @{$conn->{"queue"};}
ABresult
1X1
011
000
1333  
1334 my ($sql, $bind, $token) = $conn->{notify}->poll_sql
1335 66 ▶ or return $self->_mysql_listen_arm($conn, $watch);
Branch: 1 branch
BranchTrueFalseTotal
() = $conn->{"notify"}->poll_sql or return $self->_mysql_listen_arm($conn, $watch) 66 0 66
1336 66 $self->_mysql_listen_statement($conn, $sql, $bind)->on_ready(
1337 $self->_mysql_listen_cb($conn, $watch, '_mysql_listen_polled', $token),
1338 );
1339 66 return;
1340 }
1341  
1342 64 ▶sub _mysql_listen_polled {
Subroutine _mysql_listen_polled: called CC=7 SCAR=19.5
1343 64 my ($self, $conn, $watch, $token, $f) = @_;
1344 64 my $notify = $conn->{notify};
1345 64 ▶ die 'polling the notify table ' . $notify->quoted_table . ' failed: '
Branch: 1 branch
BranchTrueFalseTotal
unless $f->is_done 1 63 64
Condition50%1/2
$f->failure // "cancelled"
l!l
10
MC/DC0%0/1
$f->failure // "cancelled"
$f->failure
Truth table50%1/2
A
A= $f->failure
Aresult
11
00
1346 . ($f->failure // 'cancelled') . "\n"
1347 unless $f->is_done;
1348  
1349 63 my ($rows) = $f->get;
1350 63 for my $n (@{ $notify->polled($token, $rows) }) {
1351 21 ▶ return unless _mysql_listen_live($conn, $watch);
Branch: 1 branch
BranchTrueFalseTotal
unless _mysql_listen_live($conn, $watch) 1 20 21
1352 20 $self->_listen_dispatch(@$n);
1353 }
1354 62 ▶ return unless _mysql_listen_live($conn, $watch);
Branch: 1 branch
BranchTrueFalseTotal
unless _mysql_listen_live($conn, $watch) 0 62 62
1355  
1356 62 ▶ my ($sql, $bind) = $notify->cleanup_sql
Branch: 1 branch
BranchTrueFalseTotal
() = $notify->cleanup_sql or return $self->_mysql_listen_arm($conn, $watch) 16 46 62
1357 or return $self->_mysql_listen_arm($conn, $watch);
1358 16 $self->_mysql_listen_statement($conn, $sql, $bind)->on_ready(
1359 $self->_mysql_listen_cb($conn, $watch, '_mysql_listen_cleaned'),
1360 );
1361 16 return;
1362 }
1363  
1364 14 ▶sub _mysql_listen_cleaned {
Subroutine _mysql_listen_cleaned: called CC=5 SCAR=16.2
1365 14 my ($self, $conn, $watch, $f) = @_;
1366 14 my $notify = $conn->{notify};
1367 14 ▶ if ($f->is_done) {
Branch: 1 branch
BranchTrueFalseTotal
if ($f->is_done) 12 2 14
1368 12 $notify->cleaned(($f->get)[0]);
1369 12 return $self->_mysql_listen_arm($conn, $watch);
1370 }
1371  
1372 2 ▶ my $err = 'cleaning up the notify table ' . $notify->quoted_table
Condition50%1/2
$f->failure // "cancelled"
l!l
20
MC/DC0%0/1
$f->failure // "cancelled"
$f->failure
Truth table50%1/2
A
A= $f->failure
Aresult
11
00
1373 . ' failed: ' . ($f->failure // 'cancelled');
1374 2 $notify->cleaned(undef);
1375 # A dead connection ends the tick like a failed poll; on a live one the
1376 # cleanup was refused (no DELETE, a lock wait timeout) and polling goes on.
1377 2 ▶ die "$err\n" unless $self->_listen_probe($conn);
Branch: 1 branch
BranchTrueFalseTotal
unless $self->_listen_probe($conn) 1 1 2
1378 1 $self->_listen_error($err);
1379 1 ▶ return unless _mysql_listen_live($conn, $watch); # the hook may act
Branch: 1 branch
BranchTrueFalseTotal
unless _mysql_listen_live($conn, $watch) 0 1 1
1380 1 return $self->_mysql_listen_arm($conn, $watch);
1381 }
1382  
1383 # --- Schema integration -------------------------------------------------------
1384 # schema / debug / connected / in_txn / disconnect / DESTROY and the sync
1385 # CRUD/txn ->get fallbacks are inherited from DBIO::Storage::Async.
1386  
1387  
1388 6 ▶sub last_insert_id {
Subroutine last_insert_id: called CC=1 SCAR=0.0
Pod documented
1389 6 my ($self, $source, @cols) = @_;
1390 6 return $self->{_last_insert_id};
1391 }
1392  
1393 48 1;
1394  
1395 __END__
« EV/ConnectInfo.pm ↑ Summary EV/QueryExecutor.pm »