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
64
65
66
67
68
69
70
71
72
73
74
75
|
test_run = require('test_run').new()
---
...
engine = test_run:get_cfg('engine')
---
...
_ = box.space._session_settings:update('sql_default_engine', {{'=', 2, engine}})
---
...
-- create space
box.execute("CREATE TABLE t(id INT PRIMARY KEY)")
---
- row_count: 1
...
box.execute("CREATE TRIGGER tt_bu BEFORE UPDATE ON t FOR EACH ROW BEGIN SELECT 1; END")
---
- row_count: 1
...
box.execute("CREATE TRIGGER tt_au AFTER UPDATE ON t FOR EACH ROW BEGIN SELECT 1; END")
---
- row_count: 1
...
box.execute("CREATE TRIGGER tt_bi BEFORE INSERT ON t FOR EACH ROW BEGIN SELECT 1; END")
---
- row_count: 1
...
box.execute("CREATE TRIGGER tt_ai AFTER INSERT ON t FOR EACH ROW BEGIN SELECT 1; END")
---
- row_count: 1
...
box.execute("CREATE TRIGGER tt_bd BEFORE DELETE ON t FOR EACH ROW BEGIN SELECT 1; END")
---
- row_count: 1
...
box.execute("CREATE TRIGGER tt_ad AFTER DELETE ON t FOR EACH ROW BEGIN SELECT 1; END")
---
- row_count: 1
...
-- check that these triggers exist
box.execute("SELECT \"name\", \"opts\" FROM \"_trigger\"")
---
- metadata:
- name: name
type: string
- name: opts
type: map
rows:
- ['TT_AD', {'sql': 'CREATE TRIGGER tt_ad AFTER DELETE ON t FOR EACH ROW BEGIN SELECT
1; END'}]
- ['TT_AI', {'sql': 'CREATE TRIGGER tt_ai AFTER INSERT ON t FOR EACH ROW BEGIN SELECT
1; END'}]
- ['TT_AU', {'sql': 'CREATE TRIGGER tt_au AFTER UPDATE ON t FOR EACH ROW BEGIN SELECT
1; END'}]
- ['TT_BD', {'sql': 'CREATE TRIGGER tt_bd BEFORE DELETE ON t FOR EACH ROW BEGIN
SELECT 1; END'}]
- ['TT_BI', {'sql': 'CREATE TRIGGER tt_bi BEFORE INSERT ON t FOR EACH ROW BEGIN
SELECT 1; END'}]
- ['TT_BU', {'sql': 'CREATE TRIGGER tt_bu BEFORE UPDATE ON t FOR EACH ROW BEGIN
SELECT 1; END'}]
...
-- drop table
box.execute("DROP TABLE t")
---
- row_count: 1
...
-- check that triggers were dropped with deleted table
box.execute("SELECT \"name\", \"opts\" FROM \"_trigger\"")
---
- metadata:
- name: name
type: string
- name: opts
type: map
rows: []
...
|
