MSSQL/Introspect/Views.pm

filter: Statementstmt 23.5% 8 / 34 Branchbran 0.0% 0 / 2 Conditioncond 0.0% 0 / 6 MC/DCmcdc 0.0% 0 / 3 Subroutinesub 50.0% 2 / 4 Podpod 100% 2 / 2 totaltotal 23.5% 12 / 51 CC 7 SCAR 29.3
CC
7
Cov
19%
fetch
30.0
dependencies
12.0
BEGIN
1.0
CRAP 18.8
« MSSQL/Storage.pm ↑ Summary MSSQL/Diff/PrimaryKey.pm »
1 package DBIO::MSSQL::Introspect::Views;
2 # ABSTRACT: Introspect MSSQL view definitions
3  
4 27 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
5 27 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
6  
7 27 our $VERSION = '0.900007';
8  
9  
10 0 ▶sub fetch {
Subroutine fetch: not called CC=5 SCAR=34.0
Pod documented
11 0 my ($class, $dbh, $schema) = @_;
12 0 ▶ $schema //= 'dbo';
Condition0%0/2
$schema //= "dbo"
l!l
00
MC/DC0%0/1
$schema //= "dbo"
$schema
Truth table0%0/2
A
A= $schema
Aresult
11
00
13  
14 0 my $sth = $dbh->prepare(q{
15 SELECT v.name AS view_name, CAST(LEN(m.definition) AS int) AS len
16 FROM sys.views v
17 JOIN sys.sql_modules m ON m.object_id = v.object_id
18 WHERE v.schema_id = SCHEMA_ID(?) AND m.definition IS NOT NULL
19 ORDER BY v.name
20 });
21 0 $sth->execute($schema);
22 0 my @views = map { [ $_->{view_name}, $_->{len} ] } @{ $sth->fetchall_arrayref({}) };
23  
24 0 my %defs;
25 0 for my $view (@views) {
26 0 my ($name, $len) = @$view;
27 0 my $text = '';
28 0 ▶ for (my $at = 1; $at <= $len; $at += 4000) {
Branch: 1 branch
BranchTrueFalseTotal
if ($at <= $len) 0 0 0
29 0 my $piece_sql = sprintf q{
30 SELECT CAST(SUBSTRING(m.definition, %d, 4000) AS nvarchar(4000)) AS piece
31 FROM sys.views v
32 JOIN sys.sql_modules m ON m.object_id = v.object_id
33 WHERE v.schema_id = SCHEMA_ID(?) AND v.name = ?
34 }, $at;
35 0 my ($piece) = $dbh->selectrow_array($piece_sql, undef, $schema, $name);
36 0 ▶ $text .= $piece // '';
Condition0%0/2
$piece // ""
l!l
00
MC/DC0%0/1
$piece // ""
$piece
Truth table0%0/2
A
A= $piece
Aresult
11
00
37 }
38 0 $defs{$name} = $text;
39 }
40 0 return \%defs;
41 }
42  
43  
44 0 ▶sub dependencies {
Subroutine dependencies: not called CC=3 SCAR=24.8
Pod documented
45 0 my ($class, $dbh, $schema) = @_;
46 0 ▶ $schema //= 'dbo';
Condition0%0/2
$schema //= "dbo"
l!l
00
MC/DC0%0/1
$schema //= "dbo"
$schema
Truth table0%0/2
A
A= $schema
Aresult
11
00
47 0 my $sth = $dbh->prepare(q{
48 SELECT DISTINCT v.name AS view_name, rs.name AS ref_schema, rv.name AS ref_name
49 FROM sys.sql_expression_dependencies d
50 JOIN sys.views v ON v.object_id = d.referencing_id
51 JOIN sys.views rv ON rv.object_id = d.referenced_id
52 JOIN sys.schemas rs ON rs.schema_id = rv.schema_id
53 WHERE v.schema_id = SCHEMA_ID(?)
54 ORDER BY v.name, rs.name, rv.name
55 });
56 0 $sth->execute($schema);
57 0 my %deps;
58 0 push @{ $deps{ $_->{view_name} } }, [ $_->{ref_schema}, $_->{ref_name} ]
59 0 for @{ $sth->fetchall_arrayref({}) };
60 0 return \%deps;
61 }
62  
63 27 1;
64  
65 __END__
« MSSQL/Storage.pm ↑ Summary MSSQL/Diff/PrimaryKey.pm »