Workflow/Persister/DBI/ExtraData.pm

filter: Statementstmt 32.3% 21 / 65 Branchbran 0.0% 0 / 12 Conditioncond 0.0% 0 / 5 MC/DCmcdc 0.0% 0 / 3 Subroutinesub 75.0% 6 / 8 Podpod 100% 2 / 2 totaltotal 30.5% 29 / 95 CC 11 SCAR 34.2
CC
11
Cov
26%
init
56.0
fetch_workflow
30.0
BEGIN
1.0
CRAP 30.4
↑ Summary Workflow/Condition.pm »
1 package Workflow::Persister::DBI::ExtraData;
2  
3 2 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
4 2 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
5 2 ▶use v5.14.0;
Subroutine BEGIN: called CC=1 SCAR=0.0
6 2 ▶use parent qw( Workflow::Persister::DBI );
Subroutine BEGIN: called CC=1 SCAR=0.0
7 2 ▶use Workflow::Exception qw( configuration_error persist_error );
Subroutine BEGIN: called CC=1 SCAR=0.0
8 2 ▶use Syntax::Keyword::Try;
Subroutine BEGIN: called CC=1 SCAR=0.0
9  
10 2 $Workflow::Persister::DBI::ExtraData::VERSION = '2.12';
11  
12 2 my @FIELDS = qw( table data_field context_key );
13 2 __PACKAGE__->mk_accessors(@FIELDS);
14  
15 0 ▶sub init {
Subroutine init: not called CC=7 SCAR=40.3
Pod documented
16 0 my ( $self, $params ) = @_;
17 0 $self->SUPER::init($params);
18  
19 0 my @not_found = ();
20 0 foreach (qw( table data_field )) {
21 0 ▶ push @not_found, $_ unless ( $params->{"extra_$_"} );
Branch: 1 branch
BranchTrueFalseTotal
unless $$params{"extra_$_"} 0 0 0
22 }
23 0 ▶ if ( scalar @not_found ) {
Branch: 1 branch
BranchTrueFalseTotal
if (scalar @not_found) 0 0 0
24 0 $self->log->error( "Required configuration fields not found: ",
25 join ', ', @not_found );
26 0 configuration_error
27 "To fetch extra data with each workflow with this implementation ",
28 "you must specify: ", join ', ', @not_found;
29 }
30  
31 0 $self->table( $params->{extra_table} );
32 0 my $data_field = $params->{extra_data_field};
33  
34 # If multiple data fields specified we don't allow the user to
35 # specify a context key
36  
37 0 ▶ if ( $data_field =~ /,/ ) {
Branch: 1 branch
BranchTrueFalseTotal
if ($data_field =~ /,/u) { } 0 0 0
38 0 $self->data_field( [ split /\s*,\s*/, $data_field ] );
39 } else {
40 0 $self->data_field($data_field);
41 0 ▶ my $context_key = $params->{extra_context_key} || $data_field;
Condition0%0/3
$params->{'extra_context_key'} || $data_field
l!l&&r!l&&!r
000
MC/DC0%0/2
$params->{'extra_context_key'} || $data_field
$params->{'extra_context_key'} $data_field
Truth table0%0/3
A || B
A= $params->{'extra_context_key'}B= $data_field
ABresult
1X1
011
000
42 0 $self->context_key($context_key);
43 }
44 0 ▶ $self->log->info( "Configured extra data fetch with: ",
Branch: 1 branch
BranchTrueFalseTotal
defined $self->context_key ? : 0 0 0
45 join( '; ', $self->table, $data_field,
46 ( defined $self->context_key
47 ? $self->context_key : '' ) ) );
48 }
49  
50 0 ▶sub fetch_workflow {
Subroutine fetch_workflow: not called CC=5 SCAR=34.0
Pod documented
51 0 my ( $self, $wf_id ) = @_;
52 0 my $wf_info = $self->SUPER::fetch_workflow( $wf_id );
53 0 ▶ my $context = ($wf_info->{context} //= {});
Condition0%0/2
$wf_info->{"context"} //= {}
l!l
00
MC/DC0%0/1
$wf_info->{"context"} //= {}
$wf_info->{"context"}
Truth table0%0/2
A
A= $wf_info->{"context"}
Aresult
11
00
54  
55 0 $self->log->debug( "Fetching extra workflow data for '", $wf_id, "'" );
56  
57 0 my $sql = q{SELECT %s FROM %s WHERE workflow_id = ?};
58 0 my $data_field = $self->data_field;
59 my $select_data_fields
60 = ( ref $data_field )
61 ? join( ', ',
62 0 ▶ map { $self->handle->quote_identifier($_) } @{$data_field} )
Branch: 1 branch
BranchTrueFalseTotal
ref $data_field ? : 0 0 0
63 : $self->handle->quote_identifier($data_field);
64 0 $sql = sprintf $sql, $select_data_fields,
65 $self->handle->quote_identifier( $self->table );
66 0 $self->log->debug( "Using SQL: ", $sql);
67 0 $self->log->debug( "Bind parameters: ", $wf_id );
68  
69 0 my ($sth);
70 try {
71 0 $sth = $self->handle->prepare($sql);
72 0 $sth->execute( $wf_id );
73 }
74 0 catch ($error) {
75 0 persist_error "Failed to retrieve extra data from table ",
76 $self->table, ": $error";
77 }
78  
79 0 $self->log->debug("Prepared/executed extra data fetch ok");
80 0 my $row = $sth->fetchrow_arrayref;
81 0 ▶ if ( ref $data_field ) {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $data_field) { } 0 0 0
82 0 foreach my $i ( 0 .. $#{$data_field} ) {
83 0 $context->{$data_field->[$i]} = $row->[$i];
84 0 $self->log->info(
85 sprintf( "Set data from %s.%s into context key %s ok",
86 $self->table, $data_field->[$i],
87 $data_field->[$i] ) );
88 }
89 } else {
90 0 my $value = $row->[0];
91 0 $context->{ $self->context_key } = $value;
92 0 $self->log->info(
93 sprintf( "Set data from %s.%s into context key %s ok",
94 $self->table, $self->data_field,
95 $self->context_key ) );
96 }
97  
98 0 return $wf_info;
99 }
100  
101 2 1;
102  
103 __END__
↑ Summary Workflow/Condition.pm »