Sybase/Introspect/ForeignKeys.pm

filter: Statementstmt 100% 21 / 21 Branchbran 50.0% 1 / 2 Conditioncond 50.0% 2 / 4 MC/DCmcdc 0.0% 0 / 2 Subroutinesub 100% 3 / 3 Podpod 100% 1 / 1 totaltotal 84.8% 28 / 33 CC 6 SCAR 15.8
CC
6
Cov
89%
fetch
6.1
BEGIN
1.0
BEGIN
1.0
CRAP 4.9
« Sybase/Util.pm ↑ Summary Sybase/Diff/Index.pm »
1 package DBIO::Sybase::Introspect::ForeignKeys;
2 # ABSTRACT: Introspect Sybase ASE foreign keys
3  
4 28 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
5 28 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
6  
7 28 our $VERSION = '0.900007';
8  
9  
10  
11 14 ▶sub fetch {
Subroutine fetch: called CC=6 SCAR=18.2
Pod documented
12 14 my ($class, $dbh, $schema, $tables) = @_;
13 14 ▶ $schema //= 'dbo';
Condition50%1/2
$schema //= "dbo"
l!l
140
MC/DC0%0/1
$schema //= "dbo"
$schema
Truth table50%1/2
A
A= $schema
Aresult
11
00
14 14 my %foreign_keys;
15  
16 my $keys = join ', ',
17 224 (map { "col_name(r.tableid, r.fokey$_) AS fk$_" } 1 .. 16),
18 14 (map { "col_name(r.reftabid, r.refkey$_) AS rk$_" } 1 .. 16);
19  
20 14 my $rows = $dbh->selectall_arrayref(qq{
21 SELECT o.name AS table_name,
22 object_name(r.constrid) AS constraint_name,
23 object_name(r.reftabid) AS ref_table_name,
24 r.keycnt, $keys
25 FROM sysreferences r
26 JOIN sysobjects o ON o.id = r.tableid
27 JOIN sysusers u ON u.uid = o.uid
28 WHERE u.name = ?
29 AND r.pmrydbname IS NULL
30 AND r.frgndbname IS NULL
31 ORDER BY o.name, object_name(r.constrid)
32 }, { Slice => {} }, $schema);
33  
34 14 for my $row (@$rows) {
35 14 ▶ next unless exists $tables->{ $row->{table_name} };
Branch: 1 branch
BranchTrueFalseTotal
unless exists $$tables{$row->{"table_name"}} 0 14 14
36 14 ▶ for my $n (1 .. ($row->{keycnt} // 0)) {
Condition50%1/2
$row->{"keycnt"} // 0
l!l
140
MC/DC0%0/1
$row->{"keycnt"} // 0
$row->{"keycnt"}
Truth table50%1/2
A
A= $row->{"keycnt"}
Aresult
11
00
37 14 push @{ $foreign_keys{ $row->{table_name} } }, {
38 constraint_name => $row->{constraint_name},
39 column_name => $row->{"fk$n"},
40 ref_table_name => $row->{ref_table_name},
41 14 ref_column_name => $row->{"rk$n"},
42 update_rule => 'NO ACTION',
43 delete_rule => 'NO ACTION',
44 };
45 }
46 }
47  
48 14 return \%foreign_keys;
49 }
50  
51 28 1;
52  
53 __END__
« Sybase/Util.pm ↑ Summary Sybase/Diff/Index.pm »