RoutesAuthDBI/Schema.pm

filter: Statementstmt 90.9% 30 / 33 Branchbran 62.5% 5 / 8 Conditioncond 58.3% 7 / 12 MC/DCmcdc 0.0% 0 / 6 Subroutinesub 83.3% 5 / 6 Podpod 0.0% 0 / 3 totaltotal 69.1% 47 / 68 CC 12 SCAR 20.2
CC
12
Cov
79%
_vars
11.4
schema
3.0
schema_flush
2.0
CRAP 7.5
« RoutesAuthDBI/Model/Logins.pm ↑ Summary RoutesAuthDBI/Guest.pm »
1 package Mojolicious::Plugin::RoutesAuthDBI::Schema;
2 2 ▶use Mojo::Base 'Mojolicious::Controller';
Subroutine BEGIN: called CC=1 SCAR=0.0
3 2 ▶use DBIx::Mojo::Template;
Subroutine BEGIN: called CC=1 SCAR=0.0
4  
5 2 our $defaults = {# copy to pod!
6 schema => "public",
7 sequence => '"public"."id"',
8 tables => { # no quotes! one schema!
9 routes => 'routes',
10 refs=>'refs',
11 logins => 'logins',
12 profiles => 'profiles',
13 roles =>'roles',
14 actions => 'actions',
15 controllers => 'controllers',
16 namespaces => 'namespaces',
17 oauth_sites => 'oauth.sites',
18 oauth_users => 'oauth.users',
19 guests => 'guests',
20 logs=>'logs',
21 },
22
23 };
24 2 my $dict = DBIx::Mojo::Template->new(__PACKAGE__, vars=>$defaults, mt=>{tag_start=>'{%', tag_end=>'%}'});
25  
26 =pod
27  
28 =encoding utf8
29  
30 =head1 Mojolicious::Plugin::RoutesAuthDBI::Schema
31  
32 ¡ ¡ ¡ ALL GLORY TO GLORIA ! ! !
33  
34 =head1 NAME
35  
36 Mojolicious::Plugin::RoutesAuthDBI::Schema - DB schema (PostgreSQL).
37  
38 =head1 DB DESIGN DIAGRAM
39  
40 See L<https://github.com/mche/Mojolicious-Plugin-RoutesAuthDBI/blob/master/Diagram.svg>
41  
42 =head1 DB design
43  
44 =head2 Default variables for SQL templates
45  
46 {
47 schema => "public",
48 sequence => '"public"."id"',
49 tables => { # no quotes! one schema!
50 routes => 'routes',
51 refs=>'refs',
52 logins => 'logins',
53 profiles => 'profiles',
54 roles =>'roles',
55 actions => 'actions',
56 controllers => 'controllers',
57 namespaces => 'namespaces',
58 oauth_sites => 'oauth.sites',
59 oauth_users => 'oauth.users',
60 guests => 'guests',
61 logs=>'logs',
62 },
63 }
64  
65  
66 =cut
67  
68  
69 2 ▶sub _vars {
Subroutine _vars: called CC=10 SCAR=24.3
70 2 my $c = shift;
71 2 my $vars = {};
72  
73 2 for my $var (keys %$defaults) {
74
75 6 ▶ if (ref $defaults->{$var} eq 'HASH') {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $Mojolicious::Plugin::RoutesAuthDBI::Schema::defaults->{$var} eq 'HASH') { } 2 4 6
76
77 2 for (keys %{$defaults->{$var}}) {
78 24 ▶ my $val = $c->stash($_) || $c->param($_) || $defaults->{$var}{$_};
Condition66%4/6
$c->stash($_) || $c->param($_) || $Mojolicious::Plugin::RoutesAuthDBI::Schema::defaults->{$var}{$_}
l!l&&r!l&&!r
8160
$c->stash($_) or $c->param($_)
l!l&&r!l&&!r
0816
MC/DC0%0/3
$c->stash($_) || $c->param($_) || $Mojolicious::Plugin::RoutesAuthDBI::Schema::defaults->{$var}{$_}
$c->stash($_) $c->param($_) $Mojolicious::Plugin::RoutesAuthDBI::Schema::defaults->{$var}{$_}
Truth table50%2/4
A or B || C
A= $c->stash($_)B= $c->param($_)C= $Mojolicious::Plugin::RoutesAuthDBI::Schema::defaults->{$var}{$_}
ABCresult
1XX1
01X1
0011
0000
79 24 ▶ $vars->{$var}{$_} = $val
Branch: 1 branch
BranchTrueFalseTotal
unless $val =~ /undef|none/u 24 0 24
80 unless $val =~ m'undef|none';
81 }
82 } else {
83 4 ▶ my $val = $c->stash($var) || $c->param($var) || $defaults->{$var};
Condition50%3/6
$c->stash($var) || $c->param($var) || $Mojolicious::Plugin::RoutesAuthDBI::Schema::defaults->{$var}
l!l&&r!l&&!r
400
$c->stash($var) or $c->param($var)
l!l&&r!l&&!r
220
MC/DC0%0/3
$c->stash($var) || $c->param($var) || $Mojolicious::Plugin::RoutesAuthDBI::Schema::defaults->{$var}
$c->stash($var) $c->param($var) $Mojolicious::Plugin::RoutesAuthDBI::Schema::defaults->{$var}
Truth table50%2/4
A or B || C
A= $c->stash($var)B= $c->param($var)C= $Mojolicious::Plugin::RoutesAuthDBI::Schema::defaults->{$var}
ABCresult
1XX1
01X1
0011
0000
84 4 ▶ $vars->{$var} = $val
Branch: 1 branch
BranchTrueFalseTotal
unless $val =~ /undef|none/u 4 0 4
85 unless $val =~ m'undef|none';
86 }
87
88 }
89 2 $vars;
90 }
91  
92 1 ▶sub schema {
Subroutine schema: called CC=3 SCAR=11.0
Pod undocumented
93 1 my $c = shift;
94 1 my $vars = $c->_vars;
95
96 1 $c->app->log->debug($c->dumper($vars));
97
98 1 my $text = $dict->{'schema'}->render(%$vars);
99 $text .= "\n\n".$dict->{'sequence'}->render(%$vars)
100 1 ▶ if $vars->{sequence};
Branch: 1 branch
BranchTrueFalseTotal
if $vars->{"sequence"} 1 0 1
101 $text .= "\n\n".$dict->{$_}->render(%$vars)
102 1 for grep $vars->{tables}{$_}, qw(routes namespaces controllers actions profiles logins roles refs oauth_sites oauth_users guests logs);
103
104 1 $c->render(format=>'txt', text => $text);
105  
106 }
107  
108 1 ▶sub schema_drop {
Subroutine schema_drop: called CC=1 SCAR=0.0
Pod undocumented
109 1 my $c = shift;
110 1 my $vars = $c->_vars;
111 #~ $schema = qq{"$schema".} if $schema;
112 1 $c->render(format=>'txt', text => $dict->{'drop'}->render(%$vars));
113  
114 }
115  
116 0 ▶sub schema_flush {
Subroutine schema_flush: not called CC=1 SCAR=6.9
Pod undocumented
117 0 my $c = shift;
118 0 my $vars = $c->_vars;
119 0 $c->render(format=>'txt', text => $dict->{'flush'}->render(%$vars));
120 }
121  
122 2 1;
123  
124 __DATA__
« RoutesAuthDBI/Model/Logins.pm ↑ Summary RoutesAuthDBI/Guest.pm »