Generate/Methods.pm untested

filter: Statementstmt 0.0% 0 / 87 Branchbran 0.0% 0 / 4 Conditioncond 0.0% 0 / 3 MC/DCmcdc 0.0% 0 / 2 Subroutinesub 0.0% 0 / 9 Podpod 0.0% 0 / 8 totaltotal 0.0% 0 / 113 CC 3 SCAR 12.4
CC
3
Cov
0%
_select_index_method
6.0
_get_from_fkey
6.0
generate
2.0
CRAP 3.5
1 package Daje::Generate::Perl::Generate::Methods;
2 use Mojo::Base 'Daje::Workflow::GeneratePerl::Base::Common' ,-base, -signatures;
3  
4  
5  
6  
7 our $VERSION = '0.01';
8  
9 has 'fields' ;
10 has 'pkey' ;
11 has 'fkey' ;
12 has 'insert' ;
13 has 'update' ;
14 has 'select_fields' ;
15 has 'select_method' ;
16 has 'select_index_method';
17  
18 sub generate($self) {
19 $self->pkey($self->_get_from_pkey());
20 $self->fkey($self->_get_from_fkey());
21 $self->insert($self->_insert_method());
22 $self->update($self->_update_method());
23 $self->select_fields($self->_select_fields());
24 $self->select_method($self->_select_method());
25 $self->select_index_method($self->_select_index_method());
26 }
27  
28 sub _select_index_method($self) {
29 my $sql = "";
30 my $tpl = $self->templates->get_data_section('select_from_index');
31 my $table_name = $self->json->{table_name};
32 my $indexes = $self->json->{indexes};
33 my $length = scalar @{$indexes};
34 if($length > 0 and ref @{$indexes}[0] eq 'HASH') {
35 for (my $i = 0; $i < $length; $i++) {
36 my $temp = $tpl;
37 my $method = $table_name . '_' . @{$indexes}[$i]->{column_name};
38 my $parameter = '$' . @{$indexes}[$i]->{column_name};
39 my $condition = "@{$indexes}[$i]->{column_name} => $parameter";
40 $temp =~ s/<<method_name>>/$method/ig;
41 $temp =~ s/<<parameters>>/$parameter/ig;
42 $temp =~ s/<<condition>>/$condition/ig;
43 $sql .= $temp;
44 }
45 }
46 return $sql;
47 }
48  
49 sub _select_method($self) {
50 my $tpl = $self->templates->get_data_section('load_list');
51  
52 return $tpl;
53 }
54  
55 sub _select_fields($self) {
56 my $tpl = $self->templates->get_data_section('fields_method');
57 my $select = $self->fields->select();
58 my $p_key = $self->fields->primary_key();
59 my $table_name = $self->json->{table_name};
60  
61 $tpl =~ s/<<select_fields>>/$select/ig;
62 $tpl =~ s/<<primary_key>>/$p_key/ig;
63 $tpl =~ s/<<table_name>>/$table_name/ig;
64 return $tpl;
65 }
66  
67 sub _update_method($self) {
68 my $tpl = $self->templates->get_data_section('update_data');
69 my $table_name = $self->json->{table_name};
70 $tpl =~ s/<<table_name>>/$table_name/ig;
71 return $tpl;
72 }
73  
74 sub _insert_method($self) {
75 my $tpl = $self->templates->get_data_section('insert_data');
76 my $table_name = $self->json->{table_name};
77 $tpl =~ s/<<table_name>>/$table_name/ig;
78 return $tpl;
79 }
80  
81 sub _get_from_fkey($self) {
82 my $load_from_fkey = "";
83 my $f_key = $self->fields->foreign_keys();
84 my $table_name = $self->json->{table_name};
85 my $select = $self->fields->select();
86 if (defined $f_key) {
87 my $length = scalar @{$f_key};
88 for (my $i = 0; $i < $length; $i++) {
89 my $tpl = $self->templates->get_data_section('load_from_fkey');
90 $tpl =~ s/<<foreign_key>>/@{$f_key}[$i]/ig;
91 $tpl =~ s/<<table_name>>/$table_name/ig;
92 $tpl =~ s/<<select_fields>>/$select/ig;
93 $load_from_fkey .= $tpl . "\n\n";
94 }
95 }
96 return $load_from_fkey;
97 }
98  
99 sub _get_from_pkey($self){
100 my $load_from_pkey = $self->templates->get_data_section('load_from_pkey');
101 my $p_key = $self->fields->primary_key();
102 my $select = $self->fields->select();
103  
104 my $table_name = $self->json->{table_name};
105 $load_from_pkey =~ s/<<primary_key>>/$p_key/ig;
106 $load_from_pkey =~ s/<<table_name>>/$table_name/ig;
107 $load_from_pkey =~ s/<<select_fields>>/$select/ig;
108 return $load_from_pkey;
109 }
110  
111 1;
112  
113  
114 #################### pod generated by Pod::Autopod - keep this line to make pod updates possible ####################
115  
116 =head1 NAME
117  
118 Daje::Generate::Perl::Generate::Methods
119  
120  
121 =head1 DESCRIPTION
122  
123 pod generated by Pod::Autopod - keep this line to make pod updates possible ####################
124  
125  
126 =head1 REQUIRES
127  
128 L<Mojo::Base>
129  
130  
131 =head1 METHODS
132  
133 =head2 generate($self)
134  
135 generate($self)();
136  
137  
138 =cut
139