DBIx/Class/Storage/DBI/DB2.pm

filter: Statementstmt 61.2% 19 / 31 Branchbran 12.5% 1 / 8 Conditioncond 10.0% 1 / 10 MC/DCmcdc 0.0% 0 / 6 Subroutinesub 71.4% 5 / 7 Podpod 50.0% 1 / 2 totaltotal 42.1% 27 / 64 CC 9 SCAR 25.4
CC
9
Cov
43%
sql_limit_dialect
30.0
sql_name_sep
6.0
_dbh_last_insert_id
6.0
CRAP 12.7
« DBIx/Class/Storage/BlockRunner.pm ↑ Summary DBIx/Class/Storage/DBI/Sybase.pm »
1 package DBIx::Class::Storage::DBI::DB2;
2  
3 3 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
4 3 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
5  
6 3 ▶use base qw/DBIx::Class::Storage::DBI/;
Subroutine BEGIN: called CC=1 SCAR=0.0
7 3 ▶use mro 'c3';
Subroutine BEGIN: called CC=1 SCAR=0.0
8  
9 3 __PACKAGE__->datetime_parser_type('DateTime::Format::DB2');
10 3 __PACKAGE__->sql_quote_char ('"');
11  
12 # lazy-default kind of thing
13 1 ▶sub sql_name_sep {
Subroutine sql_name_sep: called CC=4 SCAR=17.9
Pod undocumented
14 1 my $self = shift;
15  
16 1 my $v = $self->next::method(@_);
17  
18 1 ▶ if (! defined $v and ! @_) {
Branch: 1 branch
BranchTrueFalseTotal
unless (defined $v or @_) 0 1 1
Condition33%1/3
defined $v or @_
l!l&&r!l&&!r
100
MC/DC0%0/2
defined $v or @_
defined $v @_
Truth table33%1/3
A or B
A= defined $vB= @_
ABresult
1X1
011
000
19 0 ▶ $v = $self->next::method($self->_dbh_get_info('SQL_QUALIFIER_NAME_SEPARATOR') || '.');
Condition0%0/2
$self->_dbh_get_info('SQL_QUALIFIER_NAME_SEPARATOR') || '.'
l!l
00
MC/DC0%0/1
$self->_dbh_get_info('SQL_QUALIFIER_NAME_SEPARATOR') || '.'
$self->_dbh_get_info('SQL_QUALIFIER_NAME_SEPARATOR')
Truth table0%0/2
A
A= $self->_dbh_get_info('SQL_QUALIFIER_NAME_SEPARATOR')
Aresult
11
00
20 }
21  
22 1 return $v;
23 }
24  
25 0 ▶sub sql_limit_dialect {
Subroutine sql_limit_dialect: not called CC=5 SCAR=34.0
Pod documented
26 0 my $self = shift;
27  
28 0 my $v = $self->next::method(@_);
29  
30 0 ▶ if (! defined $v and ! @_) {
Branch: 1 branch
BranchTrueFalseTotal
unless (defined $v or @_) 0 0 0
Condition0%0/3
defined $v or @_
l!l&&r!l&&!r
000
MC/DC0%0/2
defined $v or @_
defined $v @_
Truth table0%0/3
A or B
A= defined $vB= @_
ABresult
1X1
011
000
31 $v = $self->next::method(
32 0 ▶ ($self->_server_info->{normalized_dbms_version}||0) >= 5.004
Branch: 1 branch
BranchTrueFalseTotal
($self->_server_info->{'normalized_dbms_version'} || 0) >= 5.004 ? : 0 0 0
Condition0%0/2
$self->_server_info->{'normalized_dbms_version'} || 0
l!l
00
MC/DC0%0/1
$self->_server_info->{'normalized_dbms_version'} || 0
$self->_server_info->{'normalized_dbms_version'}
Truth table0%0/2
A
A= $self->_server_info->{'normalized_dbms_version'}
Aresult
11
00
33 ? 'RowNumberOver'
34 : 'FetchFirst'
35 );
36 }
37  
38 0 return $v;
39 }
40  
41 0 ▶sub _dbh_last_insert_id {
Subroutine _dbh_last_insert_id: not called CC=2 SCAR=17.9
42 0 my ($self, $dbh, $source, $col) = @_;
43  
44 0 my $name_sep = $self->sql_name_sep;
45  
46 0 my $sth = $dbh->prepare_cached(
47 # An older equivalent of 'VALUES(IDENTITY_VAL_LOCAL())', for compat
48 # with ancient DB2 versions. Should work on modern DB2's as well:
49 # http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/admin/r0002369.htm?resultof=%22%73%79%73%64%75%6d%6d%79%31%22%20
50 "SELECT IDENTITY_VAL_LOCAL() FROM sysibm${name_sep}sysdummy1",
51 {},
52 3
53 );
54 0 $sth->execute();
55  
56 0 my @res = $sth->fetchrow_array();
57  
58 0 ▶ return @res ? $res[0] : undef;
Branch: 1 branch
BranchTrueFalseTotal
@res ? : 0 0 0
59 }
60  
61 =head1 NAME
62  
63 DBIx::Class::Storage::DBI::DB2 - IBM DB2 support for DBIx::Class
64  
65 =head1 DESCRIPTION
66  
67 This class implements autoincrements for DB2, sets the limit dialect to
68 RowNumberOver over FetchFirst depending on the availability of support for
69 RowNumberOver, queries the server name_sep from L<DBI> and sets the L<DateTime>
70 parser to L<DateTime::Format::DB2>.
71  
72 =head1 FURTHER QUESTIONS?
73  
74 Check the list of L<additional DBIC resources|DBIx::Class/GETTING HELP/SUPPORT>.
75  
76 =head1 COPYRIGHT AND LICENSE
77  
78 This module is free software L<copyright|DBIx::Class/COPYRIGHT AND LICENSE>
79 by the L<DBIx::Class (DBIC) authors|DBIx::Class/AUTHORS>. You can
80 redistribute it and/or modify it under the same terms as the
81 L<DBIx::Class library|DBIx::Class/COPYRIGHT AND LICENSE>.
82  
83 =cut
84  
85 3 1;
86  
87 # vim:sts=2 sw=2:
« DBIx/Class/Storage/BlockRunner.pm ↑ Summary DBIx/Class/Storage/DBI/Sybase.pm »