FusqlFS/Backend/MySQL/Table/Triggers.pm untested

filter: Statementstmt 0.0% 0 / 56 Branchbran 0.0% 0 / 8 Conditioncond 0.0% 0 / 11 MC/DCmcdc 0.0% 0 / 7 Subroutinesub 0.0% 0 / 10 Podpod 0.0% 0 / 6 totaltotal 0.0% 0 / 98 CC 5 SCAR 16.7
CC
5
Cov
0%
get
12.0
store
6.0
rename
6.0
CRAP 5.3
1 use strict;
2 use 5.010;
3  
4 package FusqlFS::Backend::MySQL::Table::Triggers;
5 use FusqlFS::Version;
6 our $VERSION = $FusqlFS::Version::VERSION;
7 use parent 'FusqlFS::Artifact::Table::Lazy';
8  
9 =head1 NAME
10  
11 FusqlFS::Backend::MySQL::Table::Triggers -
12  
13 =head1 SYNOPSIS
14  
15 =head1 DESCRIPTION
16  
17 =head1 EXPOSED STRUCTURE
18  
19 =over
20  
21 =item F<./create.sql>
22  
23 C<CREATE TRIGGER> clause to create this trigger.
24  
25 =item F<./struct>
26  
27 Additional trigger info with following fields:
28  
29 =over
30  
31 =item C<when>
32  
33 I<one of before or after> defines if trigger is triggered before or after event(s).
34  
35 =item C<event>
36  
37 I<one of insert, delete, update> an event trigger will be triggered on.
38  
39 =back
40  
41 =item F<./code>
42  
43 Trigger body code.
44  
45 =item F<./definer>
46  
47 Symlink to user who defined the trigger.
48  
49 =back
50  
51 =cut
52  
53 sub init
54 {
55 my $self = shift;
56  
57 $self->{get_expr} = $self->expr('SHOW TRIGGERS WHERE `Table` = ? AND `Trigger` = ?');
58 $self->{get_create_expr} = 'SHOW CREATE TRIGGER `%s`';
59 $self->{list_expr} = $self->expr('SHOW TRIGGERS WHERE `Table` = ?');
60  
61 $self->{store_expr} = 'CREATE TRIGGER `%(name)$s` %(when)$s %(event)$s ON `%(table)$s` FOR EACH ROW %(code)$s';
62 $self->{drop_expr} = 'DROP TRIGGER `%s`';
63  
64 $self->{template} = {
65 'code' => '',
66 'definer' => \('users/' . $self->dbh()->{Username} . '@%'),
67 'struct' => $self->dump({
68 event => 'insert',
69 when => 'after',
70 }),
71 };
72 }
73  
74 sub get
75 {
76 my $self = shift;
77 my ($table, $name) = @_;
78  
79 unless ($self->SUPER::get($table, $name))
80 {
81 my $data = $self->one_row($self->{get_expr}, $table, $name);
82 return unless $data;
83  
84 my $result = {
85 struct => $self->dump({
86 'event' => lc $data->{Event},
87 'when' => lc $data->{Timing},
88 }),
89 definer => \"users/$data->{Definer}",
90 code => $data->{Statement},
91 'create.sql' => $self->one_row($self->{get_create_expr}, [$name])->{'SQL Original Statement'},
92 };
93  
94 return $result;
95 }
96 }
97  
98 sub list
99 {
100 my $self = shift;
101 my ($table) = @_;
102 my @list = @{$self->SUPER::list($table)};
103 return [ (@{$self->all_col($self->{list_expr}, $table)}, @list) ];
104 }
105  
106 sub drop
107 {
108 my $self = shift;
109 my ($table, $name) = @_;
110 $self->SUPER::drop($table, $name) or $self->do($self->{drop_expr}, [$name]);
111 }
112  
113 sub store
114 {
115 my $self = shift;
116 my ($table, $name, $data) = @_;
117 return unless $data;
118  
119 my $struct = $self->validate($data, {
120 struct => {
121 when => qr/^(before|after)$/i,
122 event => qr/^(insert|delete|update)$/i,
123 },
124 code => undef,
125 definer => ['SCALAR', sub{ $$_ =~ m{^users/\w+} }],
126 }) or return;
127  
128 $self->drop($table, $name);
129 $self->do($self->{store_expr}, {
130 name => $name,
131 table => $table,
132 event => uc $struct->{struct}->{event},
133 when => uc $struct->{struct}->{when},
134 code => $struct->{code},
135 }) or $self->SUPER::store($table, $name, $data);
136 }
137  
138 sub rename
139 {
140 my $self = shift;
141 my ($table, $name, $newname) = @_;
142 unless ($self->SUPER::rename($table, $name, $newname)) {
143 my $data = $self->get($table, $name);
144 $self->drop($table, $name) and $self->store($table, $newname, $data);
145 }
146 }
147  
148 1;
149