blib/lib/DBIO/PostgreSQL/Introspect.pm

filter: Statementstmt 77.0% 249 / 323 Branchbran 64.2% 81 / 126 Conditioncond 59.0% 91 / 154 MC/DCmcdc 35.4% 28 / 79 Subroutinesub 82.3% 42 / 51 Podpod 100% 24 / 24 totaltotal 68.0% 515 / 757 CC 141 SCAR 32.3
CC
141
Cov
70%
column_reads
72.0
result_class_extra_statements
58.8
under_empty_search_path
56.0
CRAP 25.3
« blib/lib/DBIO/PostgreSQL/Introspect/Sequences.pm ↑ Summary blib/lib/DBIO/PostgreSQL/Diff.pm »
1 package DBIO::PostgreSQL::Introspect;
2 # ABSTRACT: Introspect a PostgreSQL database via pg_catalog
3  
4 171 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
5 171 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
6  
7 171 our $VERSION = '0.900007';
8  
9 171 ▶use base 'DBIO::Introspect::Base';
Subroutine BEGIN: called CC=1 SCAR=0.0
10  
11 171 ▶use Scalar::Util ();
Subroutine BEGIN: called CC=1 SCAR=0.0
12 171 ▶use DBIO::PostgreSQL::Util ();
Subroutine BEGIN: called CC=1 SCAR=0.0
13  
14  
15 171 ▶use DBIO::PostgreSQL::Introspect::Schemas;
Subroutine BEGIN: called CC=1 SCAR=0.0
16 171 ▶use DBIO::PostgreSQL::Introspect::Tables;
Subroutine BEGIN: called CC=1 SCAR=0.0
17 171 ▶use DBIO::PostgreSQL::Introspect::Columns;
Subroutine BEGIN: called CC=1 SCAR=0.0
18 171 ▶use DBIO::PostgreSQL::Introspect::Types;
Subroutine BEGIN: called CC=1 SCAR=0.0
19 171 ▶use DBIO::PostgreSQL::Introspect::Indexes;
Subroutine BEGIN: called CC=1 SCAR=0.0
20 171 ▶use DBIO::PostgreSQL::Introspect::Triggers;
Subroutine BEGIN: called CC=1 SCAR=0.0
21 171 ▶use DBIO::PostgreSQL::Introspect::Functions;
Subroutine BEGIN: called CC=1 SCAR=0.0
22 171 ▶use DBIO::PostgreSQL::Introspect::Extensions;
Subroutine BEGIN: called CC=1 SCAR=0.0
23 171 ▶use DBIO::PostgreSQL::Introspect::Policies;
Subroutine BEGIN: called CC=1 SCAR=0.0
24 171 ▶use DBIO::PostgreSQL::Introspect::Sequences;
Subroutine BEGIN: called CC=1 SCAR=0.0
25 171 ▶use DBIO::PostgreSQL::Introspect::OutsideReaders;
Subroutine BEGIN: called CC=1 SCAR=0.0
26 171 ▶use DBIO::PostgreSQL::Introspect::OutsideDependents;
Subroutine BEGIN: called CC=1 SCAR=0.0
27 171 ▶use DBIO::PostgreSQL::Introspect::ForeignKeys;
Subroutine BEGIN: called CC=1 SCAR=0.0
28 171 ▶use DBIO::PostgreSQL::Introspect::CheckConstraints;
Subroutine BEGIN: called CC=1 SCAR=0.0
29 171 ▶use DBIO::PostgreSQL::Introspect::Normalize;
Subroutine BEGIN: called CC=1 SCAR=0.0
30  
31 9 ▶sub schema_filter { $_[0]->{schema_filter} }
Subroutine schema_filter: called CC=1 SCAR=0.0
Pod documented
32 72 ▶sub preserve_case { $_[0]->{preserve_case} // 0 }
Subroutine preserve_case: called CC=2 SCAR=7.6
Pod documented
Condition50%1/2
$_[0]{"preserve_case"} // 0
l!l
720
MC/DC0%0/1
$_[0]{"preserve_case"} // 0
$_[0]{"preserve_case"}
Truth table50%1/2
A
A= $_[0]{"preserve_case"}
Aresult
11
00
33 0 ▶sub qualified_names { exists $_[0]->{qualified_names} ? ($_[0]->{qualified_names} ? 1 : 0) : 1 }
Subroutine qualified_names: not called CC=3 SCAR=24.8
Pod documented
Branch: 2 branches
BranchTrueFalseTotal
exists $_[0]{'qualified_names'} ? : 0 0 0
$_[0]{'qualified_names'} ? : 0 0 0
34  
35  
36 0 ▶sub _build_model {
Subroutine _build_model: not called CC=2 SCAR=17.9
37 0 my ($self) = @_;
38 0 ▶ return $self->_read_sections unless $self->qualified_names;
Branch: 1 branch
BranchTrueFalseTotal
unless $self->qualified_names 0 0 0
39 0 ▶ return $self->under_empty_search_path($self->dbh, sub { $self->_read_sections });
Subroutine __ANON__: not called CC=1 SCAR=6.9
40 }
41  
42 0 ▶sub _read_sections {
Subroutine _read_sections: not called CC=3 SCAR=24.8
43 0 my ($self) = @_;
44 0 my $dbh = $self->dbh;
45 0 my $filter = $self->schema_filter;
46  
47 # model key => Introspect::Section class name.
48 # Sections with filtered => 0 are fetched without the schema filter
49 # (extensions are cluster-wide, not bound to a single schema).
50 0 my %SECTIONS = (
51 schemas => ['Schemas', 1],
52 extensions => ['Extensions', 0],
53 types => ['Types', 1],
54 tables => ['Tables', 1],
55 columns => ['Columns', 1],
56 indexes => ['Indexes', 1],
57 triggers => ['Triggers', 1],
58 functions => ['Functions', 1],
59 policies => ['Policies', 1],
60 sequences => ['Sequences', 1],
61 outside_readers => ['OutsideReaders', 1],
62 outside_dependents => ['OutsideDependents', 1],
63 foreign_keys => ['ForeignKeys', 1],
64 check_constraints => ['CheckConstraints', 1],
65 );
66  
67 0 my %model;
68 0 for my $key (sort keys %SECTIONS) {
69 0 my ($class, $filtered) = @{ $SECTIONS{$key} };
70 0 my $pkg = "DBIO::PostgreSQL::Introspect::$class";
71 0 ▶ $model{$key} = $pkg->fetch($dbh, $filtered ? $filter : ());
Branch: 1 branch
BranchTrueFalseTotal
$filtered ? : 0 0 0
72 }
73 0 return \%model;
74 }
75  
76  
77 2 ▶sub table_keys {
Subroutine table_keys: called CC=2 SCAR=7.0
Pod documented
78 2 my ($self) = @_;
79 2 my $model = $self->model;
80 return [
81 5 sort grep { $self->_include_table($_) }
82 2 ▶ keys %{ $model->{tables} || {} }
Condition50%1/2
$model->{'tables'} || {}
l!l
20
MC/DC0%0/1
$model->{'tables'} || {}
$model->{'tables'}
Truth table50%1/2
A
A= $model->{'tables'}
Aresult
11
00
83 ];
84 }
85  
86 5 ▶sub _include_table {
Subroutine _include_table: called CC=4 SCAR=14.6
87 5 my ($self, $table_key) = @_;
88 5 my ($schema) = split /\./, $table_key, 2;
89 5 my $filter = $self->schema_filter;
90 5 ▶ return 1 unless $filter && @$filter;
Branch: 1 branch
BranchTrueFalseTotal
unless $filter and @$filter 0 5 5
Condition33%1/3
$filter and @$filter
!ll&&!rl&&r
005
MC/DC0%0/2
$filter and @$filter
$filter @$filter
Truth table33%1/3
A and B
A= $filterB= @$filter
ABresult
0X0
100
111
91 5 ▶ return 1 if grep { $_ eq '%' } @$filter;
Branch: 1 branch
BranchTrueFalseTotal
if grep {$_ eq "%";} @$filter 0 5 5
92 5 return scalar grep { $_ eq $schema } @$filter;
93 }
94  
95 72 ▶sub _normalize_name {
Subroutine _normalize_name: called CC=1 SCAR=0.0
96 72 return DBIO::PostgreSQL::Introspect::Normalize->name(@_[1..$#_], $_[0]->preserve_case);
97 }
98  
99  
100 445 ▶sub identity_kind {
Subroutine identity_kind: called CC=5 SCAR=16.1
Pod documented
101 445 my ($class, $id) = @_;
102 445 ▶ return 'ALWAYS' if defined $id && $id eq 'a';
Branch: 1 branch
BranchTrueFalseTotal
if defined $id and $id eq "a" 11 434 445
Condition100%3/3
defined $id and $id eq "a"
!ll&&!rl&&r
18924511
MC/DC100%2/2
defined $id and $id eq "a"
defined $id $id eq "a"
Truth table100%3/3
A and B
A= defined $idB= $id eq "a"
ABresult
0X0
100
111
103 434 ▶ return 'BY DEFAULT' if defined $id && $id eq 'd';
Branch: 1 branch
BranchTrueFalseTotal
if defined $id and $id eq "d" 7 427 434
Condition100%3/3
defined $id and $id eq "d"
!ll&&!rl&&r
1892387
MC/DC100%2/2
defined $id and $id eq "d"
defined $id $id eq "d"
Truth table100%3/3
A and B
A= defined $idB= $id eq "d"
ABresult
0X0
100
111
104 427 return undef;
105 }
106  
107  
108 130 ▶sub generated_kind {
Subroutine generated_kind: called CC=5 SCAR=16.1
Pod documented
109 130 my ($class, $generated) = @_;
110 130 ▶ return undef unless defined $generated && length $generated;
Branch: 1 branch
BranchTrueFalseTotal
unless defined $generated and length $generated 105 25 130
Condition100%3/3
defined $generated and length $generated
!ll&&!rl&&r
852025
MC/DC100%2/2
defined $generated and length $generated
defined $generated length $generated
Truth table100%3/3
A and B
A= defined $generatedB= length $generated
ABresult
0X0
100
111
111 25 ▶ return 'STORED' if $generated eq 's';
Branch: 1 branch
BranchTrueFalseTotal
if $generated eq "s" 18 7 25
112 7 ▶ return 'VIRTUAL' if $generated eq 'v';
Branch: 1 branch
BranchTrueFalseTotal
if $generated eq "v" 6 1 7
113 1 die "attgenerated '$generated' is a kind of generated column this version of "
114 . "DBIO::PostgreSQL does not know\n";
115 }
116  
117  
118 129 ▶sub qualified_key {
Subroutine qualified_key: called CC=7 SCAR=35.4
Pod documented
119 129 my ($class, $a, $b) = @_;
120  
121 # Two-arg form: ($schema, $name).
122 129 ▶ if (ref $a eq '') {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $a eq "") 129 0 129
123 129 return "$a.$b";
124 }
125  
126 # Hashref form: pull schema + the first matching name field.
127 0 my $schema = $a->{schema_name};
128 my $name = $a->{table_name}
129 // $a->{type_name}
130 // $a->{function_name}
131 // $a->{sequence_name}
132 // $a->{index_name}
133 0 ▶ // $a->{policy_name};
Condition0%0/15
(((($a->{"table_name"} // $a->{"type_name"}) // $a->{"function_name"}) // $a->{"sequence_name"}) // $a->{"index_name"}) // $a->{"policy_name"}
l!l&&r!l&&!r
000
((($a->{"table_name"} // $a->{"type_name"}) // $a->{"function_name"}) // $a->{"sequence_name"}) // $a->{"index_name"}
l!l&&r!l&&!r
000
(($a->{"table_name"} // $a->{"type_name"}) // $a->{"function_name"}) // $a->{"sequence_name"}
l!l&&r!l&&!r
000
($a->{"table_name"} // $a->{"type_name"}) // $a->{"function_name"}
l!l&&r!l&&!r
000
$a->{"table_name"} // $a->{"type_name"}
l!l&&r!l&&!r
000
MC/DC0%0/6
(((($a->{"table_name"} // $a->{"type_name"}) // $a->{"function_name"}) // $a->{"sequence_name"}) // $a->{"index_name"}) // $a->{"policy_name"}
$a->{"table_name"} $a->{"type_name"} $a->{"function_name"} $a->{"sequence_name"} $a->{"index_name"} $a->{"policy_name"}
Truth table0%0/7
A // B // C // D // E // F
A= $a->{"table_name"}B= $a->{"type_name"}C= $a->{"function_name"}D= $a->{"sequence_name"}E= $a->{"index_name"}F= $a->{"policy_name"}
ABCDEFresult
1XXXXX1
01XXXX1
001XXX1
0001XX1
00001X1
0000011
0000000
134 0 return "$schema.$name";
135 }
136  
137  
138 2483 ▶sub key_names {
Subroutine key_names: called CC=8 SCAR=20.9
Pod documented
139 2483 my ($class, $key, $field, @entries) = @_;
140  
141 2483 for my $entry (@entries) {
142 # reftype, not ref: a diff operation hands in itself, a blessed hash.
143 2661 ▶ next unless (Scalar::Util::reftype($entry) // '') eq 'HASH';
Branch: 1 branch
BranchTrueFalseTotal
unless (builtin::reftype($entry) // "") eq "HASH" 9 2652 2661
Condition100%2/2
builtin::reftype($entry) // ""
l!l
26529
MC/DC100%1/1
builtin::reftype($entry) // ""
builtin::reftype($entry)
Truth table100%2/2
A
A= builtin::reftype($entry)
Aresult
11
00
144 2652 my ($schema, $name) = @{$entry}{ 'schema_name', $field };
145 2652 ▶ return ($schema, $name)
Branch: 1 branch
BranchTrueFalseTotal
if defined $schema and length $schema and defined $name and length $name 2464 188 2652
Condition77%7/9
defined $schema and length $schema and defined $name and length $name
!ll&&!rl&&r
18802464
defined $schema and length $schema and defined $name
!ll&&!rl&&r
18712464
defined $schema and length $schema
!ll&&!rl&&r
18702465
MC/DC50%2/4
defined $schema and length $schema and defined $name and length $name
defined $schema length $schema defined $name length $name
Truth table60%3/5
A and B and C and D
A= defined $schemaB= length $schemaC= defined $nameD= length $name
ABCDresult
0XXX0
10XX0
110X0
11100
11111
146 if defined $schema && length $schema && defined $name && length $name;
147 }
148  
149 19 return split /\./, $key, 2;
150 }
151  
152  
153 # The handles a call is running for, by address.
154 171 my %UNDER_EMPTY_SEARCH_PATH;
155  
156 0 ▶sub under_empty_search_path {
Subroutine under_empty_search_path: not called CC=7 SCAR=40.3
Pod documented
157 0 my ($class, $dbh, $code) = @_;
158  
159 0 my $handle = Scalar::Util::refaddr($dbh);
160 0 ▶ return $code->() if $UNDER_EMPTY_SEARCH_PATH{$handle};
Branch: 1 branch
BranchTrueFalseTotal
if $UNDER_EMPTY_SEARCH_PATH{$handle} 0 0 0
161 0 local $UNDER_EMPTY_SEARCH_PATH{$handle} = 1;
162  
163 # Without it a statement that fails is passed over, the one that empties
164 # the search_path among them.
165 0 local $dbh->{RaiseError} = 1;
166  
167 # A transaction of the caller's. DBI knows of one it has begun itself
168 # (AutoCommit is off then, sent to the server or not); of a BEGIN that was
169 # sent as a statement only the server knows, and ping says so.
170 0 ▶ my $savepoint = !$dbh->{AutoCommit} || $dbh->ping == 3;
Condition0%0/3
!$dbh->{'AutoCommit'} || $dbh->ping == 3
l!l&&r!l&&!r
000
MC/DC0%0/2
!$dbh->{'AutoCommit'} || $dbh->ping == 3
!$dbh->{'AutoCommit'} $dbh->ping == 3
Truth table0%0/3
not(A) || B
A= !$dbh->{'AutoCommit'}B= $dbh->ping == 3
ABresult
1X1
011
000
171  
172 0 ▶ if ($savepoint) { $dbh->do('SAVEPOINT dbio_pg_introspect') }
Branch: 1 branch
BranchTrueFalseTotal
if ($savepoint) { } 0 0 0
173 0 else { $dbh->begin_work }
174  
175 0 my $result;
176 0 my $ran = eval {
177 0 $dbh->do(q{SELECT pg_catalog.set_config('search_path', '', true)});
178 0 $result = $code->();
179 0 1;
180 };
181 0 my $error = $@;
182  
183 0 my $undone = eval {
184 0 ▶ if ($savepoint) {
Branch: 1 branch
BranchTrueFalseTotal
if ($savepoint) { } 0 0 0
185 0 $dbh->do('ROLLBACK TO SAVEPOINT dbio_pg_introspect');
186 0 $dbh->do('RELEASE SAVEPOINT dbio_pg_introspect');
187 }
188 else {
189 0 $dbh->rollback;
190 }
191 0 1;
192 };
193 0 my $undo_error = $@;
194  
195 # The error worth reporting is the first one.
196 0 ▶ die $error unless $ran;
Branch: 1 branch
BranchTrueFalseTotal
unless $ran 0 0 0
197 0 ▶ die $undo_error unless $undone;
Branch: 1 branch
BranchTrueFalseTotal
unless $undone 0 0 0
198  
199 0 return $result;
200 }
201  
202  
203 0 ▶sub system_schema_filter {
Subroutine system_schema_filter: not called CC=2 SCAR=17.9
Pod documented
204 0 my ($class, $alias) = @_;
205 0 ▶ $alias //= 'n';
Condition0%0/2
$alias //= "n"
l!l
00
MC/DC0%0/1
$alias //= "n"
$alias
Truth table0%0/2
A
A= $alias
Aresult
11
00
206 0 return "AND $alias.nspname !~ '^pg_'\n AND $alias.nspname != 'information_schema'";
207 }
208  
209  
210 0 ▶sub extension_member_filter {
Subroutine extension_member_filter: not called CC=1 SCAR=6.9
Pod documented
211 0 my ($class, $catalog, $oid) = @_;
212 0 return "\n AND NOT EXISTS (\n"
213 . " SELECT 1 FROM pg_catalog.pg_depend ext_dep\n"
214 . " WHERE ext_dep.classid = 'pg_catalog.$catalog'::pg_catalog.regclass\n"
215 . " AND ext_dep.objid = $oid\n"
216 . " AND ext_dep.deptype = 'e'\n"
217 . " )";
218 }
219  
220  
221 0 ▶sub internal_part_filter {
Subroutine internal_part_filter: not called CC=1 SCAR=6.9
Pod documented
222 0 my ($class, $catalog, $oid) = @_;
223 0 return "\n AND NOT EXISTS (\n"
224 . " SELECT 1 FROM pg_catalog.pg_depend int_dep\n"
225 . " WHERE int_dep.classid = 'pg_catalog.$catalog'::pg_catalog.regclass\n"
226 . " AND int_dep.objid = $oid\n"
227 . " AND int_dep.objsubid = 0\n"
228 . " AND int_dep.deptype = 'i'\n"
229 . " )";
230 }
231  
232  
233 0 ▶sub column_reads {
Subroutine column_reads: not called CC=8 SCAR=42.8
Pod documented
234 0 my ($class, $dbh, $filter, $catalog, $relation, $name, $where) = @_;
235  
236 0 my $sql = qq{
237 SELECT DISTINCT
238 n.nspname AS schema_name,
239 c.relname AS table_name,
240 o.$name AS object_name,
241 rn.nspname AS ref_schema,
242 r.relname AS ref_name,
243 a.attname AS ref_column
244 FROM pg_catalog.$catalog o
245 JOIN pg_catalog.pg_class c ON c.oid = o.$relation
246 JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
247 JOIN pg_catalog.pg_depend d
248 ON d.classid = 'pg_catalog.$catalog'::pg_catalog.regclass
249 AND d.objid = o.oid
250 AND d.refclassid = 'pg_catalog.pg_class'::pg_catalog.regclass
251 AND d.refobjsubid > 0
252 JOIN pg_catalog.pg_class r ON r.oid = d.refobjid
253 JOIN pg_catalog.pg_namespace rn ON rn.oid = r.relnamespace
254 JOIN pg_catalog.pg_attribute a ON a.attrelid = d.refobjid AND a.attnum = d.refobjsubid
255 WHERE 1=1
256 };
257 0 ▶ $sql .= "\n AND $where" if defined $where;
Branch: 1 branch
BranchTrueFalseTotal
if defined $where 0 0 0
258 0 $sql .= "\n " . $class->system_schema_filter('n');
259 0 $sql .= $class->extension_member_filter('pg_class', 'c.oid');
260  
261 0 my @bind;
262 0 ▶ if ($filter && @$filter) {
Branch: 1 branch
BranchTrueFalseTotal
if ($filter and @$filter) 0 0 0
Condition0%0/3
$filter and @$filter
!ll&&!rl&&r
000
MC/DC0%0/2
$filter and @$filter
$filter @$filter
Truth table0%0/3
A and B
A= $filterB= @$filter
ABresult
0X0
100
111
263 0 $sql .= ' AND n.nspname = ANY($1)';
264 0 push @bind, $filter;
265 }
266  
267 0 my $sth = $dbh->prepare($sql);
268 0 $sth->execute(@bind);
269  
270 0 my %reads;
271 0 ▶ while (my $row = $sth->fetchrow_hashref) {
Branch: 1 branch
BranchTrueFalseTotal
if (my $row = $sth->fetchrow_hashref) 0 0 0
272 0 my $on = $class->qualified_key($row);
273 0 my $read = $class->qualified_key(@{$row}{qw( ref_schema ref_name )});
274 0 push @{ $reads{$on}{ $row->{object_name} }{$read} }, $row->{ref_column};
275 }
276 0 for my $objects (values %reads) {
277 0 for my $object (values %$objects) {
278 0 $_ = [ sort @$_ ] for values %$object;
279 }
280 }
281  
282 0 return \%reads;
283 }
284  
285 15 ▶sub _normalize_data_type {
Subroutine _normalize_data_type: called CC=8 SCAR=22.4
286 15 my ($self, $info, $column) = @_;
287  
288 # Enum columns need the value list from the model, which is the only
289 # stateful piece of the normalization. Resolve it here so the leaf
290 # helper stays pure.
291 15 my $enum_values;
292 15 ▶ if ($column->{type_category} && $column->{type_category} eq 'e' && $column->{enum_type}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($column->{"type_category"} and $column->{"type_category"} eq "e" and $column->{"enum_type"}) 1 14 15
Condition66%4/6
$column->{"type_category"} and $column->{"type_category"} eq "e" and $column->{"enum_type"}
!ll&&!rl&&r
1401
$column->{"type_category"} and $column->{"type_category"} eq "e"
!ll&&!rl&&r
0141
MC/DC33%1/3
$column->{"type_category"} and $column->{"type_category"} eq "e" and $column->{"enum_type"}
$column->{"type_category"} $column->{"type_category"} eq "e" $column->{"enum_type"}
Truth table50%2/4
A and B and C
A= $column->{"type_category"}B= $column->{"type_category"} eq "e"C= $column->{"enum_type"}
ABCresult
0XX0
10X0
1100
1111
293 1 ▶ my $ts = $column->{type_schema} || '';
Condition50%1/2
$column->{'type_schema'} || ''
l!l
10
MC/DC0%0/1
$column->{'type_schema'} || ''
$column->{'type_schema'}
Truth table50%1/2
A
A= $column->{'type_schema'}
Aresult
11
00
294 1 ▶ my $qualified = $ts ne 'public' ? "$ts.$column->{enum_type}" : $column->{enum_type};
Branch: 1 branch
BranchTrueFalseTotal
$ts ne 'public' ? : 1 0 1
295 my $type_info = $self->model->{types}{$qualified}
296 1 ▶ || $self->model->{types}{ "$ts.$column->{enum_type}" };
Condition33%1/3
$self->model->{'types'}{$qualified} || $self->model->{'types'}{"$ts.$column->{'enum_type'}"}
l!l&&r!l&&!r
100
MC/DC0%0/2
$self->model->{'types'}{$qualified} || $self->model->{'types'}{"$ts.$column->{'enum_type'}"}
$self->model->{'types'}{$qualified} $self->model->{'types'}{"$ts.$column->{'enum_type'}"}
Truth table33%1/3
A || B
A= $self->model->{'types'}{$qualified}B= $self->model->{'types'}{"$ts.$column->{'enum_type'}"}
ABresult
1X1
011
000
297 1 ▶ $enum_values = $type_info->{values} if $type_info;
Branch: 1 branch
BranchTrueFalseTotal
if $type_info 1 0 1
298 }
299  
300 15 return DBIO::PostgreSQL::Introspect::Normalize->data_type($info, $column, $enum_values);
301 }
302  
303 15 ▶sub _normalize_default_value {
Subroutine _normalize_default_value: called CC=1 SCAR=0.0
304 15 return DBIO::PostgreSQL::Introspect::Normalize->default_value(@_[1..$#_]);
305 }
306  
307  
308 1 ▶sub normalize_array {
Subroutine normalize_array: called CC=1 SCAR=0.0
Pod documented
309 1 return DBIO::PostgreSQL::Introspect::Normalize->array($_[1]);
310 }
311  
312  
313 5 ▶sub table_columns {
Subroutine table_columns: called CC=2 SCAR=7.0
Pod documented
314 5 my ($self, $table_key) = @_;
315 return [
316 19 map { $self->_normalize_name($_->{column_name}) }
317 26 sort { $a->{ordinal} <=> $b->{ordinal} }
318 5 ▶ @{ $self->model->{columns}{$table_key} || [] }
Condition50%1/2
$self->model->{'columns'}{$table_key} || []
l!l
50
MC/DC0%0/1
$self->model->{'columns'}{$table_key} || []
$self->model->{'columns'}{$table_key}
Truth table50%1/2
A
A= $self->model->{'columns'}{$table_key}
Aresult
11
00
319 ];
320 }
321  
322  
323 4 ▶sub table_columns_info {
Subroutine table_columns_info: called CC=10 SCAR=23.1
Pod documented
324 4 my ($self, $table_key) = @_;
325  
326 4 ▶ $self->{_table_columns_info_cache} //= {};
Condition100%2/2
$self->{"_table_columns_info_cache"} //= {}
l!l
13
MC/DC100%1/1
$self->{"_table_columns_info_cache"} //= {}
$self->{"_table_columns_info_cache"}
Truth table100%2/2
A
A= $self->{"_table_columns_info_cache"}
Aresult
11
00
327 4 my $cached = $self->{_table_columns_info_cache}{$table_key};
328 4 ▶ return { %$cached } if $cached;
Branch: 1 branch
BranchTrueFalseTotal
if $cached 0 4 4
329  
330 4 my %pk = map { $_ => 1 } @{ $self->table_pk_info($table_key) };
331 4 my %columns;
332  
333 4 for my $column (
334 22 sort { $a->{ordinal} <=> $b->{ordinal} }
335 4 ▶ @{ $self->model->{columns}{$table_key} || [] }
Condition50%1/2
$self->model->{'columns'}{$table_key} || []
l!l
40
MC/DC0%0/1
$self->model->{'columns'}{$table_key} || []
$self->model->{'columns'}{$table_key}
Truth table50%1/2
A
A= $self->model->{'columns'}{$table_key}
Aresult
11
00
336 ) {
337 15 my $name = $self->_normalize_name($column->{column_name});
338 my $info = {
339 # karr k49 / core k126: fold the primary key into is_nullable the way
340 # the core base now does. The PG model carries no is_pk flag on the
341 # column -- table_pk_info comes from the indexes section -- so the fold
342 # uses the already-resolved %pk set.
343 15 ▶ is_nullable => (($column->{not_null} || $pk{$name}) ? 0 : 1),
Branch: 1 branch
BranchTrueFalseTotal
$column->{'not_null'} || $pk{$name} ? : 11 4 15
Condition100%3/3
$column->{"not_null"} or $pk{$name}
l!l&&r!l&&!r
1014
MC/DC100%2/2
$column->{"not_null"} or $pk{$name}
$column->{"not_null"} $pk{$name}
Truth table100%3/3
A or B
A= $column->{"not_null"}B= $pk{$name}
ABresult
1X1
011
000
344 };
345  
346 15 $self->_normalize_data_type($info, $column);
347 15 $self->_normalize_default_value($info, $column->{default_value}, $pk{$name});
348  
349 15 ▶ if ($column->{identity}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($column->{"identity"}) 1 14 15
350 1 $info->{is_auto_increment} = 1;
351 1 $info->{extra}{identity} = $column->{identity};
352 1 ▶ $info->{retrieve_on_insert} = 1 if $pk{$name};
Branch: 1 branch
BranchTrueFalseTotal
if $pk{$name} 0 1 1
353 }
354  
355 15 ▶ if ($column->{generated}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($column->{"generated"}) 1 14 15
356 1 $info->{extra}{generated} = $column->{generated};
357 }
358  
359 15 $columns{$name} = $info;
360 }
361  
362 4 $self->{_table_columns_info_cache}{$table_key} = \%columns;
363 4 return { %columns };
364 }
365  
366  
367 10 ▶sub table_pk_info {
Subroutine table_pk_info: called CC=5 SCAR=16.5
Pod documented
368 10 my ($self, $table_key) = @_;
369  
370 10 ▶ my $indexes = $self->model->{indexes}{$table_key} || {};
Condition50%1/2
$self->model->{'indexes'}{$table_key} || {}
l!l
100
MC/DC0%0/1
$self->model->{'indexes'}{$table_key} || {}
$self->model->{'indexes'}{$table_key}
Truth table50%1/2
A
A= $self->model->{'indexes'}{$table_key}
Aresult
11
00
371 10 for my $name (sort keys %$indexes) {
372 21 my $index = $indexes->{$name};
373 21 ▶ next unless $index->{is_primary};
Branch: 1 branch
BranchTrueFalseTotal
unless $index->{"is_primary"} 11 10 21
374 10 ▶ return [ map { $self->_normalize_name($_) } @{ $index->{columns} || [] } ];
Condition50%1/2
$index->{'columns'} || []
l!l
100
MC/DC0%0/1
$index->{'columns'} || []
$index->{'columns'}
Truth table50%1/2
A
A= $index->{'columns'}
Aresult
11
00
375 }
376  
377 0 return [];
378 }
379  
380  
381 7 ▶sub table_uniq_info {
Subroutine table_uniq_info: called CC=13 SCAR=26.0
Pod documented
382 7 my ($self, $table_key) = @_;
383  
384 7 ▶ my $indexes = $self->model->{indexes}{$table_key} || {};
Condition50%1/2
$self->model->{'indexes'}{$table_key} || {}
l!l
70
MC/DC0%0/1
$self->model->{'indexes'}{$table_key} || {}
$self->model->{'indexes'}{$table_key}
Truth table50%1/2
A
A= $self->model->{'indexes'}{$table_key}
Aresult
11
00
385 7 my @uniqs;
386  
387 7 for my $name (sort keys %$indexes) {
388 18 my $index = $indexes->{$name};
389 18 ▶ next unless $index->{is_unique};
Branch: 1 branch
BranchTrueFalseTotal
unless $index->{"is_unique"} 5 13 18
390 13 ▶ next if $index->{is_primary};
Branch: 1 branch
BranchTrueFalseTotal
if $index->{"is_primary"} 7 6 13
391 6 ▶ next if $index->{predicate};
Branch: 1 branch
BranchTrueFalseTotal
if $index->{"predicate"} 0 6 6
392 6 ▶ next if $index->{expressions};
Branch: 1 branch
BranchTrueFalseTotal
if $index->{"expressions"} 1 5 6
393 5 ▶ next unless @{ $index->{columns} || [] };
Branch: 1 branch
BranchTrueFalseTotal
unless @{$index->{"columns"} or [];} 0 5 5
Condition50%1/2
$index->{'columns'} || []
l!l
50
MC/DC0%0/1
$index->{'columns'} || []
$index->{'columns'}
Truth table50%1/2
A
A= $index->{'columns'}
Aresult
11
00
394 5 ▶ next if ($index->{access_method} || '') ne 'btree';
Branch: 1 branch
BranchTrueFalseTotal
if ($index->{"access_method"} || "") ne "btree" 0 5 5
Condition50%1/2
$index->{'access_method'} || ''
l!l
50
MC/DC0%0/1
$index->{'access_method'} || ''
$index->{'access_method'}
Truth table50%1/2
A
A= $index->{'access_method'}
Aresult
11
00
395 # A per-column operator class cannot be expressed as a UNIQUE constraint,
396 # so such an index stays an index. Mirrored by $simple_unique in
397 # result_class_extra_statements -- change both or the index is emitted
398 # twice, as a constraint and as an index (karr k54).
399 5 ▶ next if $index->{opclasses} && %{ $index->{opclasses} };
Branch: 1 branch
BranchTrueFalseTotal
if $index->{"opclasses"} and %{$index->{"opclasses"};} 2 3 5
Condition100%3/3
$index->{"opclasses"} and %{$index->{"opclasses"};}
!ll&&!rl&&r
122
MC/DC100%2/2
$index->{"opclasses"} and %{$index->{"opclasses"};}
$index->{"opclasses"} %{$index->{"opclasses"};}
Truth table100%3/3
A and B
A= $index->{"opclasses"}B= %{$index->{"opclasses"};}
ABresult
0X0
100
111
400  
401 push @uniqs, [
402 3 $name => [ map { $self->_normalize_name($_) } @{ $index->{columns} } ],
403 ];
404 }
405  
406 7 return \@uniqs;
407 }
408  
409  
410 3 ▶sub table_fk_info {
Subroutine table_fk_info: called CC=5 SCAR=16.4
Pod documented
411 3 my ($self, $table_key) = @_;
412  
413 my @fks = map {
414 {
415 constraint_name => $_->{constraint_name},
416 2 ▶ local_columns => [ map { $self->_normalize_name($_) } @{ $_->{local_columns} || [] } ],
Condition50%1/2
$_->{'local_columns'} || []
l!l
20
MC/DC0%0/1
$_->{'local_columns'} || []
$_->{'local_columns'}
Truth table50%1/2
A
A= $_->{'local_columns'}
Aresult
11
00
417 2 ▶ remote_columns => [ map { $self->_normalize_name($_) } @{ $_->{remote_columns} || [] } ],
Branch: 1 branch
BranchTrueFalseTotal
$_->{'is_deferrable'} ? : 0 2 2
Condition50%1/2
$_->{'remote_columns'} || []
l!l
20
MC/DC0%0/1
$_->{'remote_columns'} || []
$_->{'remote_columns'}
Truth table50%1/2
A
A= $_->{'remote_columns'}
Aresult
11
00
418 remote_schema => $_->{remote_schema},
419 remote_table => $_->{remote_table},
420 attrs => {
421 is_deferrable => $_->{is_deferrable} ? 1 : 0,
422 on_delete => $_->{on_delete},
423 on_update => $_->{on_update},
424 },
425 }
426 3 ▶ } @{ $self->model->{foreign_keys}{$table_key} || [] };
Condition100%2/2
$self->model->{'foreign_keys'}{$table_key} || []
l!l
21
MC/DC100%1/1
$self->model->{'foreign_keys'}{$table_key} || []
$self->model->{'foreign_keys'}{$table_key}
Truth table100%2/2
A
A= $self->model->{'foreign_keys'}{$table_key}
Aresult
11
00
427  
428 3 return \@fks;
429 }
430  
431  
432 3 ▶sub table_is_view {
Subroutine table_is_view: called CC=4 SCAR=14.3
Pod documented
433 3 my ($self, $table_key) = @_;
434 3 ▶ my $table = $self->model->{tables}{$table_key} || {};
Condition50%1/2
$self->model->{'tables'}{$table_key} || {}
l!l
30
MC/DC0%0/1
$self->model->{'tables'}{$table_key} || {}
$self->model->{'tables'}{$table_key}
Truth table50%1/2
A
A= $self->model->{'tables'}{$table_key}
Aresult
11
00
435 3 ▶ return ($table->{kind} || '') =~ /^(?:v|m)\z/ ? 1 : 0;
Branch: 1 branch
BranchTrueFalseTotal
($table->{'kind'} || '') =~ /^(?:v|m)\z/ ? : 1 2 3
Condition50%1/2
$table->{'kind'} || ''
l!l
30
MC/DC0%0/1
$table->{'kind'} || ''
$table->{'kind'}
Truth table50%1/2
A
A= $table->{'kind'}
Aresult
11
00
436 }
437  
438  
439 146978 ▶sub view_definition {
Subroutine view_definition: called CC=4 SCAR=13.9
Pod documented
440 146978 my ($self, $table_key) = @_;
441 146978 ▶ my $table = $self->model->{tables}{$table_key} || {};
Condition50%1/2
$self->model->{'tables'}{$table_key} || {}
l!l
1469780
MC/DC0%0/1
$self->model->{'tables'}{$table_key} || {}
$self->model->{'tables'}{$table_key}
Truth table50%1/2
A
A= $self->model->{'tables'}{$table_key}
Aresult
11
00
442 146978 my $def = $table->{view_definition};
443 146978 ▶ return undef unless defined $def;
Branch: 1 branch
BranchTrueFalseTotal
unless defined $def 7 146971 146978
444 146971 $def =~ s/^\s+//;
445 146971 $def = DBIO::PostgreSQL::Util::trim_end($def);
446 # one closing semicolon, with the whitespace around it
447 146971 ▶ $def = DBIO::PostgreSQL::Util::trim_end(substr($def, 0, -1))
Branch: 1 branch
BranchTrueFalseTotal
if substr($def, -1) eq ";" 146966 5 146971
448 if substr($def, -1) eq ';';
449 146971 return $def;
450 }
451  
452  
453 1 ▶sub table_comment {
Subroutine table_comment: called CC=1 SCAR=0.0
Pod documented
454 1 my ($self, $table_key) = @_;
455 1 return $self->model->{tables}{$table_key}{comment};
456 }
457  
458  
459 1 ▶sub column_comment {
Subroutine column_comment: called CC=5 SCAR=16.5
Pod documented
460 1 my ($self, $table_key, $column_name) = @_;
461  
462 1 ▶ $self->{_column_comment_cache} //= {};
Condition50%1/2
$self->{"_column_comment_cache"} //= {}
l!l
01
MC/DC0%0/1
$self->{"_column_comment_cache"} //= {}
$self->{"_column_comment_cache"}
Truth table50%1/2
A
A= $self->{"_column_comment_cache"}
Aresult
11
00
463 1 ▶ unless (exists $self->{_column_comment_cache}{$table_key}) {
Branch: 1 branch
BranchTrueFalseTotal
unless (exists $self->{"_column_comment_cache"}{$table_key}) 1 0 1
464 1 my %cache;
465 1 ▶ for my $column (@{ $self->model->{columns}{$table_key} || [] }) {
Condition50%1/2
$self->model->{'columns'}{$table_key} || []
l!l
10
MC/DC0%0/1
$self->model->{'columns'}{$table_key} || []
$self->model->{'columns'}{$table_key}
Truth table50%1/2
A
A= $self->model->{'columns'}{$table_key}
Aresult
11
00
466 9 $cache{ $self->_normalize_name($column->{column_name}) } = $column->{comment};
467 }
468 1 $self->{_column_comment_cache}{$table_key} = \%cache;
469 }
470 1 return $self->{_column_comment_cache}{$table_key}{ $self->_normalize_name($column_name) };
471 }
472  
473  
474 60674 ▶sub result_class_extra_statements {
Subroutine result_class_extra_statements: called CC=49 SCAR=40.7
Pod documented
475 60674 my ($self, $table_key) = @_;
476  
477 60674 my ($schema_name, $table_name) = split /\./, $table_key, 2;
478 60674 my @stmts;
479  
480 60674 ▶ push @stmts, [pg_schema => $schema_name]
Branch: 1 branch
BranchTrueFalseTotal
if defined $schema_name and length $schema_name 60674 0 60674
Condition33%1/3
defined $schema_name and length $schema_name
!ll&&!rl&&r
0060674
MC/DC0%0/2
defined $schema_name and length $schema_name
defined $schema_name length $schema_name
Truth table33%1/3
A and B
A= defined $schema_nameB= length $schema_name
ABresult
0X0
100
111
481 if defined $schema_name && length $schema_name;
482  
483 60674 ▶ my $indexes = $self->model->{indexes}{$table_key} || {};
Condition100%2/2
$self->model->{'indexes'}{$table_key} || {}
l!l
560669
MC/DC100%1/1
$self->model->{'indexes'}{$table_key} || {}
$self->model->{'indexes'}{$table_key}
Truth table100%2/2
A
A= $self->model->{'indexes'}{$table_key}
Aresult
11
00
484 60674 my %pg_indexes;
485 60674 for my $name (sort keys %$indexes) {
486 13 my $index = $indexes->{$name};
487 13 ▶ next if $index->{is_primary};
Branch: 1 branch
BranchTrueFalseTotal
if $index->{"is_primary"} 4 9 13
488  
489 # Mirrors table_uniq_info: an index it hands over as a UNIQUE constraint
490 # must not also be emitted here. Keep the two conditions in step.
491 my $simple_unique = $index->{is_unique}
492 && !$index->{predicate}
493 && !$index->{expressions}
494 2 && !($index->{opclasses} && %{ $index->{opclasses} })
495 2 ▶ && @{ $index->{columns} || [] }
Condition50%2/4
$index->{'columns'} || []
l!l
20
$index->{'access_method'} || ''
l!l
20
MC/DC0%0/1
$index->{'columns'} || []
$index->{'columns'}
MC/DC0%0/1
$index->{'access_method'} || ''
$index->{'access_method'}
Truth table50%1/2
A
A= $index->{'columns'}
Aresult
11
00
Truth table50%1/2
A
A= $index->{'access_method'}
Aresult
11
00
496 9 ▶ && ($index->{access_method} || '') eq 'btree';
Condition83%15/18
$index->{'is_unique'} && !$index->{'predicate'} && !$index->{'expressions'} && !($index->{'opclasses'} && %{$index->{'opclasses'};}) && @{$index->{'columns'} or [];} && ($index->{'access_method'} || '') eq 'btree'
!ll&&!rl&&r
702
$index->{"is_unique"} and not $index->{"predicate"} and not $index->{"expressions"} and not $index->{"opclasses"} && %{$index->{"opclasses"};} and @{$index->{"columns"} or [];}
!ll&&!rl&&r
702
$index->{"is_unique"} and not $index->{"predicate"} and not $index->{"expressions"} and not $index->{"opclasses"} && %{$index->{"opclasses"};}
!ll&&!rl&&r
612
$index->{"is_unique"} and not $index->{"predicate"} and not $index->{"expressions"}
!ll&&!rl&&r
513
$index->{"is_unique"} and not $index->{"predicate"}
!ll&&!rl&&r
504
$index->{'opclasses'} && %{$index->{'opclasses'};}
!ll&&!rl&&r
111
MC/DC57%4/7
$index->{'is_unique'} && !$index->{'predicate'} && !$index->{'expressions'} && !($index->{'opclasses'} && %{$index->{'opclasses'};}) && @{$index->{'columns'} or [];} && ($index->{'access_method'} || '') eq 'btree'
$index->{"is_unique"} not $index->{"predicate"} not $index->{"expressions"} $index->{'opclasses'} %{$index->{'opclasses'};} @{$index->{"columns"} or [];} ($index->{'access_method'} || '') eq 'btree'
Truth table50%5/10
A and not(B) and not(C) and not(D && E) and F && G
A= $index->{"is_unique"}B= not $index->{"predicate"}C= not $index->{"expressions"}D= $index->{'opclasses'}E= %{$index->{'opclasses'};}F= @{$index->{"columns"} or [];}G= ($index->{'access_method'} || '') eq 'btree'
ABCDEFGresult
0XXXXXX0
10XXXXX0
110XXXX0
11111XX0
1110X0X0
111100X0
1110X100
11110100
1110X111
11110111
497  
498 9 ▶ next if $simple_unique;
Branch: 1 branch
BranchTrueFalseTotal
if $simple_unique 2 7 9
499  
500 7 my %def;
501 6 $def{columns} = [ map { $self->_normalize_name($_) } @{ $index->{columns} } ]
502 7 ▶ if @{ $index->{columns} || [] };
Branch: 1 branch
BranchTrueFalseTotal
if @{$index->{"columns"} or [];} 6 1 7
Condition50%1/2
$index->{'columns'} || []
l!l
70
MC/DC0%0/1
$index->{'columns'} || []
$index->{'columns'}
Truth table50%1/2
A
A= $index->{'columns'}
Aresult
11
00
503 7 ▶ $def{expression} = $index->{expressions} if $index->{expressions};
Branch: 1 branch
BranchTrueFalseTotal
if $index->{"expressions"} 1 6 7
504 7 ▶ $def{where} = $index->{predicate} if $index->{predicate};
Branch: 1 branch
BranchTrueFalseTotal
if $index->{"predicate"} 1 6 7
505 $def{using} = $index->{access_method}
506 7 ▶ if ($index->{access_method} || '') ne 'btree';
Branch: 1 branch
BranchTrueFalseTotal
if ($index->{"access_method"} || "") ne "btree" 2 5 7
Condition50%1/2
$index->{'access_method'} || ''
l!l
70
MC/DC0%0/1
$index->{'access_method'} || ''
$index->{'access_method'}
Truth table50%1/2
A
A= $index->{'access_method'}
Aresult
11
00
507 7 ▶ $def{unique} = 1 if $index->{is_unique};
Branch: 1 branch
BranchTrueFalseTotal
if $index->{"is_unique"} 2 5 7
508 2 $def{include} = [ map { $self->_normalize_name($_) } @{ $index->{include_columns} } ]
509 7 ▶ if @{ $index->{include_columns} || [] };
Branch: 1 branch
BranchTrueFalseTotal
if @{$index->{"include_columns"} or [];} 2 5 7
Condition50%1/2
$index->{'include_columns'} || []
l!l
70
MC/DC0%0/1
$index->{'include_columns'} || []
$index->{'include_columns'}
Truth table50%1/2
A
A= $index->{'include_columns'}
Aresult
11
00
510 $def{with} = $index->{storage_params}
511 7 ▶ if $index->{storage_params} && %{ $index->{storage_params} };
Branch: 1 branch
BranchTrueFalseTotal
if $index->{"storage_params"} and %{$index->{"storage_params"};} 2 5 7
Condition66%2/3
$index->{"storage_params"} and %{$index->{"storage_params"};}
!ll&&!rl&&r
052
MC/DC50%1/2
$index->{"storage_params"} and %{$index->{"storage_params"};}
$index->{"storage_params"} %{$index->{"storage_params"};}
Truth table66%2/3
A and B
A= $index->{"storage_params"}B= %{$index->{"storage_params"};}
ABresult
0X0
100
111
512  
513 # Per-column operator classes. Without these an introspected pgvector
514 # hnsw index cannot be redeployed at all: hnsw has no default opclass
515 # for vector, so CREATE INDEX ... USING hnsw (embedding) is rejected.
516 # An ivfflat index would come back with its default, vector_l2_ops,
517 # whatever class it had. That default itself never arrives here:
518 # pg_get_indexdef does not print it.
519 7 ▶ if ($index->{opclasses} && %{ $index->{opclasses} }) {
Branch: 1 branch
BranchTrueFalseTotal
if ($index->{"opclasses"} and %{$index->{"opclasses"};}) 3 4 7
Condition66%2/3
$index->{"opclasses"} and %{$index->{"opclasses"};}
!ll&&!rl&&r
403
MC/DC50%1/2
$index->{"opclasses"} and %{$index->{"opclasses"};}
$index->{"opclasses"} %{$index->{"opclasses"};}
Truth table66%2/3
A and B
A= $index->{"opclasses"}B= %{$index->{"opclasses"};}
ABresult
0X0
100
111
520 3 my %opclasses;
521 3 for my $column (keys %{ $index->{opclasses} }) {
522 3 $opclasses{ $self->_normalize_name($column) } = $index->{opclasses}{$column};
523 }
524 3 $def{opclasses} = \%opclasses;
525 }
526  
527 7 ▶ $pg_indexes{$name} = \%def if %def;
Branch: 1 branch
BranchTrueFalseTotal
if %def 7 0 7
528 }
529 60674 for my $name (sort keys %pg_indexes) {
530 7 push @stmts, [pg_index => $name, $pg_indexes{$name}];
531 }
532  
533 60674 ▶ my $triggers = $self->model->{triggers}{$table_key} || {};
Condition100%2/2
$self->model->{'triggers'}{$table_key} || {}
l!l
606704
MC/DC100%1/1
$self->model->{'triggers'}{$table_key} || {}
$self->model->{'triggers'}{$table_key}
Truth table100%2/2
A
A= $self->model->{'triggers'}{$table_key}
Aresult
11
00
534 60674 for my $name (sort keys %$triggers) {
535 60670 my $trigger = $triggers->{$name};
536 60670 my $execute = $trigger->{execute};
537 push @stmts, [pg_trigger => $name, {
538 when => $trigger->{timing},
539 event => $trigger->{event},
540 for_each => $trigger->{orientation},
541 60670 ▶ ($execute ? (execute => $execute) : ()),
Branch: 1 branch
BranchTrueFalseTotal
$execute ? : 60670 0 60670
542 }];
543 }
544  
545 60674 ▶ my $table = $self->model->{tables}{$table_key} || {};
Condition100%2/2
$self->model->{'tables'}{$table_key} || {}
l!l
560669
MC/DC100%1/1
$self->model->{'tables'}{$table_key} || {}
$self->model->{'tables'}{$table_key}
Truth table100%2/2
A
A= $self->model->{'tables'}{$table_key}
Aresult
11
00
546 60674 ▶ my $policies = $self->model->{policies}{$table_key} || {};
Condition100%2/2
$self->model->{'policies'}{$table_key} || {}
l!l
160673
MC/DC100%1/1
$self->model->{'policies'}{$table_key} || {}
$self->model->{'policies'}{$table_key}
Truth table100%2/2
A
A= $self->model->{'policies'}{$table_key}
Aresult
11
00
547 60674 ▶ if ($table->{rls_enabled} || $table->{rls_forced} || keys %$policies) {
Branch: 1 branch
BranchTrueFalseTotal
if ($table->{"rls_enabled"} or $table->{"rls_forced"} or keys %$policies) 1 60673 60674
Condition66%4/6
$table->{"rls_enabled"} or $table->{"rls_forced"} or keys %$policies
l!l&&r!l&&!r
1060673
$table->{"rls_enabled"} or $table->{"rls_forced"}
l!l&&r!l&&!r
1060673
MC/DC33%1/3
$table->{"rls_enabled"} or $table->{"rls_forced"} or keys %$policies
$table->{"rls_enabled"} $table->{"rls_forced"} keys %$policies
Truth table50%2/4
A or B or C
A= $table->{"rls_enabled"}B= $table->{"rls_forced"}C= keys %$policies
ABCresult
1XX1
01X1
0011
0000
548 1 my %defs;
549 1 for my $name (sort keys %$policies) {
550 1 my $policy = $policies->{$name};
551 $defs{$name} = {
552 for => $policy->{command} || 'ALL',
553 ($policy->{roles} ? (roles => $self->normalize_array($policy->{roles})) : ()),
554 ($policy->{using_expr} ? (using => $policy->{using_expr}) : ()),
555 1 ▶ ($policy->{check_expr} ? (with_check => $policy->{check_expr}) : ()),
Branch: 3 branches
BranchTrueFalseTotal
$policy->{'roles'} ? : 1 0 1
$policy->{'using_expr'} ? : 1 0 1
$policy->{'check_expr'} ? : 1 0 1
Condition50%1/2
$policy->{'command'} || 'ALL'
l!l
10
MC/DC0%0/1
$policy->{'command'} || 'ALL'
$policy->{'command'}
Truth table50%1/2
A
A= $policy->{'command'}
Aresult
11
00
556 };
557 }
558 push @stmts, [pg_rls => {
559 enable => $table->{rls_enabled} ? 1 : 0,
560 1 ▶ force => $table->{rls_forced} ? 1 : 0,
Branch: 3 branches
BranchTrueFalseTotal
$table->{'rls_enabled'} ? : 1 0 1
$table->{'rls_forced'} ? : 1 0 1
keys %defs ? : 1 0 1
561 (keys %defs ? (policies => \%defs) : ()),
562 }];
563 }
564  
565 60674 ▶ my $checks = $self->model->{check_constraints}{$table_key} || {};
Condition100%2/2
$self->model->{'check_constraints'}{$table_key} || {}
l!l
160673
MC/DC100%1/1
$self->model->{'check_constraints'}{$table_key} || {}
$self->model->{'check_constraints'}{$table_key}
Truth table100%2/2
A
A= $self->model->{'check_constraints'}{$table_key}
Aresult
11
00
566 60674 for my $name (sort keys %$checks) {
567 1 push @stmts, [pg_check_constraint => $name, $checks->{$name}];
568 }
569  
570 60674 return @stmts;
571 }
572  
573  
574 171 1;
575  
576 __END__
« blib/lib/DBIO/PostgreSQL/Introspect/Sequences.pm ↑ Summary blib/lib/DBIO/PostgreSQL/Diff.pm »