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