Connection/Oracle/PLSQL.pm

filter: Statementstmt 51.3% 19 / 37 Branchbran n/a Conditioncond n/a MC/DCmcdc n/a Subroutinesub 66.6% 6 / 9 Podpod 100% 3 / 3 totaltotal 57.1% 28 / 49 CC 1 SCAR 2.9
CC
1
Cov
51%
prepare
2.0
execute
2.0
bind_parameters
2.0
CRAP 1.3
« Connection/MySQL/PLSQL.pm ↑ Summary
1 package DBIx::Connection::Oracle::PLSQL;
2  
3 1 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
4 1 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
5  
6 1 ▶use Abstract::Meta::Class ':all';
Subroutine BEGIN: called CC=1 SCAR=0.0
7 1 ▶use Carp 'confess';
Subroutine BEGIN: called CC=1 SCAR=0.0
8 1 ▶use base qw(DBIx::PLSQLHandler);
Subroutine BEGIN: called CC=1 SCAR=0.0
9  
10 1 ▶use vars qw($VERSION);
Subroutine BEGIN: called CC=1 SCAR=0.0
11  
12 1 $VERSION = 0.02;
13  
14  
15 =head1 NAME
16  
17 DBIx::Connection::Oracle::PLSQL - PLSQL block handler
18  
19 =head1 SYNOPSIS
20  
21 use DBIx::PLSQLHandler;
22  
23 my $plsql_handler = new DBIx::PLSQLHandler(
24 name => 'test_proc',
25 connection => $connection,
26 plsql => "
27 DECLARE
28 var1 INT;
29 BEGIN
30 var1 := :var2 + :var3;
31 END;",
32 );
33 $plsql_handler->execute(var2 => 12, var3 => 8);
34  
35 or
36  
37 use DBIx::Connection;
38  
39  
40 my $plsql_handler = $connection->plsql_handler(
41 name => 'test_proc',
42 connection => $connection,
43 plsql => "
44 DECLARE
45 var1 INT;
46 BEGIN
47 :var1 := :var2 + :var3;
48 END;",
49 );
50  
51 my $result_set = $plsql_handler->execute(var2 => 12, var3 => 8);
52  
53  
54 =head2 methods
55  
56 =over
57  
58 =item prepare
59  
60 Prepares plsql cursor
61  
62 =cut
63  
64 0 ▶sub prepare {
Subroutine prepare: not called CC=1 SCAR=6.9
Pod documented
65 0 my ($self) = @_;
66 0 $self->set_sql($self->plsql);
67 0 $self->SUPER::prepare();
68 }
69  
70  
71  
72 =item execute
73  
74 =cut
75  
76 0 ▶sub execute {
Subroutine execute: not called CC=1 SCAR=6.9
Pod documented
77 0 my $self = shift;
78 0 my $result_set = $self->bind_parameters(@_);
79 0 $self->SUPER::execute();
80 0 $result_set;
81 }
82  
83  
84 =item bind_parameters
85  
86 =cut
87  
88 0 ▶sub bind_parameters {
Subroutine bind_parameters: not called CC=1 SCAR=6.9
Pod documented
89 0 my ($self, %bind_parameters) = @_;
90 0 my $bind_variables = $self->bind_variables;
91 0 my @bind_in_variables = $self->bind_in_variables;
92 0 my %bind_params = (map {$_ => $bind_parameters{$_}} @bind_in_variables);
93 0 my @binded_out_variables = $self->binded_out_variables;
94 0 my %bind_params_inout = (map {$_ => $bind_parameters{$_}} @binded_out_variables);
95 0 $self->bind_params(\%bind_params);
96 0 $self->bind_params_inout(\%bind_params_inout);
97 0 \%bind_params_inout;
98 }
99  
100 __END__
« Connection/MySQL/PLSQL.pm ↑ Summary