Debian Codegraph @

mysql-test/suite/period/create_triggers.inc

raw
1 create or replace table log_tbl(id int auto_increment primary key, log text) engine=myisam;
2
3 create or replace procedure log(s text)
4 insert into log_tbl(log) values(s);
5
6 if (!$trig_table)
7 {
8 die "No $trig_table specified";
9 }
10
11 if (!$trig_cols)
12 {
13 let $trig_cols= s, e;
14 }
15
16 let $old_trig_args= `select REGEXP_REPLACE('$trig_cols', '([[:word:]]+)',
17 'old.\\\\\\\\1')`;
18 let $old_trig_args= `select REPLACE('$old_trig_args', ',', ', ", ", ')`;
19 let $new_trig_args= `select REGEXP_REPLACE('$trig_cols', '([[:word:]]+)',
20 'new.\\\\\\\\1')`;
21 let $new_trig_args= `select REPLACE('$new_trig_args', ',', ', ", ", ')`;
22
23 eval create trigger tr1upd_$trig_table before update on $trig_table
24 for each row call log(CONCAT('>UPD: ', $old_trig_args, ' -> ', $new_trig_args));
25 eval create trigger tr2upd_$trig_table after update on $trig_table
26 for each row call log(CONCAT('<UPD: ', $old_trig_args, ' -> ', $new_trig_args));
27 eval create trigger tr1del_$trig_table before delete on $trig_table
28 for each row call log(CONCAT('>DEL: ', $old_trig_args));
29 eval create trigger tr2del_$trig_table after delete on $trig_table
30 for each row call log(CONCAT('<DEL: ', $old_trig_args));
31 eval create trigger tr1ins_$trig_table before insert on $trig_table
32 for each row call log(CONCAT('>INS: ', $new_trig_args));
33 eval create trigger tr2ins_$trig_table after insert on $trig_table
34 for each row call log(CONCAT('<INS: ', $new_trig_args));
35
36
37 let trig_cols= 0;
38 let trig_table= 0;