mysql_pr_fn_debugger/mysql_pr_fn_debugger.sql at master · willyrgf/mysql_pr_fn_debugger · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
delimiter //

drop database if exists debug//
create database debug//

drop table if exists debug.debug//
create table  debug.debug (
  id bigint not null auto_increment,
  proc_id varchar(32) default 'proc_id_undefined',
  debug_text text not null,
  created_at datetime default now(),
  primary key (id)
)//
create index idx_created_at on debug.debug(created_at)//

drop procedure if exists debug._log//
create procedure debug._log(in proc_id varchar(32), in debug_text text)
begin
    insert into
        debug.debug (
            proc_id,
            debug_text
        )
    values (
        proc_id,
        debug_text
    );
end//

drop procedure if exists debug._xlog//
create procedure debug._xlog(in debug_text text)
begin
    insert into
        debug.debug (
            debug_text
        )
    values (
        debug_text
    );
end//

drop procedure if exists debug._show//
create procedure debug._show()
begin
    select
        bug.proc_id,
        bug.debug_text,
        bug.created_at
    from
        debug.debug bug
    order by
        bug.created_at desc
    limit 50;
end//

drop procedure if exists debug._cleanup//
create procedure debug._cleanup()
begin
    truncate table
        debug.debug;
end//

delimiter ;