Informix/Introspect/Indexes.pm

filter: Statementstmt 100% 28 / 28 Branchbran 100% 4 / 4 Conditioncond n/a MC/DCmcdc n/a Subroutinesub 100% 4 / 4 Podpod 100% 1 / 1 totaltotal 100% 37 / 37 CC 5 SCAR 12.5
CC
5
Cov
100%
fetch
5.0
BEGIN
1.0
BEGIN
1.0
CRAP 3.5
« Informix/Introspect/ForeignKeys.pm ↑ Summary Informix/Introspect/UniqueConstraints.pm »
1 package DBIO::Informix::Introspect::Indexes;
2 # ABSTRACT: Introspect Informix indexes
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.1
Pod documented
14 1 my ($class, $dbh, $schema, $tables) = @_;
15 1 my %indexes;
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  
22 1 for my $table_name (sort keys %$tables) {
23 2 my $sth = $dbh->prepare(qq{
24 SELECT i.idxname, i.idxtype, i.tabid, $parts
25 FROM $q.sysindexes i
26 JOIN $q.systables t ON i.tabid = t.tabid
27 WHERE t.tabname = ?
28 AND NOT EXISTS (
29 SELECT 1 FROM $q.sysconstraints c
30 WHERE c.tabid = i.tabid AND c.idxname = i.idxname
31 )
32 ORDER BY i.idxname
33 });
34 2 $sth->execute($table_name);
35 2 my @rows = @{ $sth->fetchall_arrayref({}) };
36 2 $sth->finish;
37 2 ▶ next unless @rows;
Branch: 1 branch
BranchTrueFalseTotal
unless @rows 1 1 2
38  
39 1 my $names = DBIO::Informix::Introspect::Util::column_names($dbh, $q, $rows[0]{tabid});
40  
41 1 for my $row (@rows) {
42 2 my $idx_name = $row->{idxname};
43 $indexes{$table_name}{$idx_name} = {
44 index_name => $idx_name,
45 2 ▶ unique => ($row->{idxtype} eq 'U') ? 1 : 0,
Branch: 1 branch
BranchTrueFalseTotal
$row->{'idxtype'} eq 'U' ? : 1 1 2
46 columns => [ DBIO::Informix::Introspect::Util::names_for(
47 $names, DBIO::Informix::Introspect::Util::part_columns($row, 'part')
48 ) ],
49 };
50 }
51 }
52  
53 1 return \%indexes;
54 }
55  
56 21 1;
57  
58 __END__
« Informix/Introspect/ForeignKeys.pm ↑ Summary Informix/Introspect/UniqueConstraints.pm »