Informix/Introspect/ForeignKeys.pm

filter: Statementstmt 100% 30 / 30 Branchbran n/a Conditioncond 33.3% 2 / 6 MC/DCmcdc 0.0% 0 / 4 Subroutinesub 100% 4 / 4 Podpod 100% 1 / 1 totaltotal 82.2% 37 / 45 CC 5 SCAR 12.7
CC
5
Cov
89%
fetch
5.1
BEGIN
1.0
BEGIN
1.0
CRAP 3.6
« Informix/Diff/UniqueConstraint.pm ↑ Summary Informix/Introspect/Indexes.pm »
1 package DBIO::Informix::Introspect::ForeignKeys;
2 # ABSTRACT: Introspect Informix foreign keys
3  
4 21 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
5 21 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
6  
7 21 our $VERSION = '0.900007';
8  
9 21 ▶use DBIO::Informix::Introspect::Util ();
Subroutine BEGIN: called CC=1 SCAR=0.0
10  
11  
12  
13 1 ▶sub fetch {
Subroutine fetch: called CC=5 SCAR=16.3
Pod documented
14 1 my ($class, $dbh, $schema, $tables) = @_;
15 1 my %fks;
16  
17 1 local $dbh->{FetchHashKeyName} = 'NAME_lc';
18  
19 1 my $q = DBIO::Informix::Introspect::Util::qualifier($schema);
20 1 my $parts = DBIO::Informix::Introspect::Util::_parts_sql();
21 1 my $rparts = DBIO::Informix::Introspect::Util::_rparts_sql();
22 1 my %names; # tabid => { colno => colname }
23  
24 1 for my $from_table (sort keys %$tables) {
25 2 my $sth = $dbh->prepare(qq{
26 SELECT c.constrname AS fk_name,
27 t.tabid AS tabid,
28 rt.tabname AS to_table,
29 r.ptabid AS ptabid,
30 $parts,
31 $rparts,
32 r.matchtype AS match, r.updrule AS upd_rule, r.delrule AS del_rule
33 FROM $q.sysconstraints c
34 JOIN $q.systables t ON c.tabid = t.tabid
35 JOIN $q.sysreferences r ON c.constrid = r.constrid
36 JOIN $q.sysconstraints rc ON r.primary = rc.constrid
37 JOIN $q.systables rt ON r.ptabid = rt.tabid
38 JOIN $q.sysindexes i ON i.tabid = c.tabid AND i.idxname = c.idxname
39 JOIN $q.sysindexes ri ON ri.tabid = r.ptabid AND ri.idxname = rc.idxname
40 WHERE c.constrtype = 'R'
41 AND t.tabname = ?
42 ORDER BY c.constrname
43 });
44 2 $sth->execute($from_table);
45 2 my @rows = @{ $sth->fetchall_arrayref({}) };
46 2 $sth->finish;
47  
48 2 for my $row (@rows) {
49 1 ▶ my $from_names = $names{ $row->{tabid} } //= DBIO::Informix::Introspect::Util::column_names($dbh, $q, $row->{tabid});
Condition33%1/3
$names{$row->{"tabid"}} //= DBIO::Informix::Introspect::Util::column_names($dbh, $q, $row->{"tabid"})
l!l&&r!l&&!r
010
MC/DC0%0/2
$names{$row->{"tabid"}} //= DBIO::Informix::Introspect::Util::column_names($dbh, $q, $row->{"tabid"})
$names{$row->{"tabid"}} DBIO::Informix::Introspect::Util::column_names($dbh, $q, $row->{"tabid"})
Truth table33%1/3
A //= B
A= $names{$row->{"tabid"}}B= DBIO::Informix::Introspect::Util::column_names($dbh, $q, $row->{"tabid"})
ABresult
1X1
011
000
50 1 ▶ my $to_names = $names{ $row->{ptabid} } //= DBIO::Informix::Introspect::Util::column_names($dbh, $q, $row->{ptabid});
Condition33%1/3
$names{$row->{"ptabid"}} //= DBIO::Informix::Introspect::Util::column_names($dbh, $q, $row->{"ptabid"})
l!l&&r!l&&!r
010
MC/DC0%0/2
$names{$row->{"ptabid"}} //= DBIO::Informix::Introspect::Util::column_names($dbh, $q, $row->{"ptabid"})
$names{$row->{"ptabid"}} DBIO::Informix::Introspect::Util::column_names($dbh, $q, $row->{"ptabid"})
Truth table33%1/3
A //= B
A= $names{$row->{"ptabid"}}B= DBIO::Informix::Introspect::Util::column_names($dbh, $q, $row->{"ptabid"})
ABresult
1X1
011
000
51  
52 1 push @{ $fks{$from_table} }, {
53 fk_name => $row->{fk_name},
54 from_columns => [ DBIO::Informix::Introspect::Util::names_for(
55 $from_names, DBIO::Informix::Introspect::Util::part_columns($row, 'part')) ],
56 to_table => $row->{to_table},
57 to_columns => [ DBIO::Informix::Introspect::Util::names_for(
58 $to_names, DBIO::Informix::Introspect::Util::part_columns($row, 'rpart')) ],
59 match => $row->{match},
60 upd_rule => $row->{upd_rule},
61 del_rule => $row->{del_rule},
62 1 };
63 }
64 }
65  
66 1 return \%fks;
67 }
68  
69 21 1;
70  
71 __END__
« Informix/Diff/UniqueConstraint.pm ↑ Summary Informix/Introspect/Indexes.pm »