| 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 |