odbtools/odbctest/mql/aaa/24trigger/11trigger.mql

-- ============================================================
-- 触发器操作测试
-- ============================================================

-- 1. 触发器相关操作：insert 后验证数据
insert into /test/aaa/test_trigger (t_name, t_value, t_status) values ('trigger_test_1', 500, 'pending')
;

select * from /test/aaa/test_trigger where t_name='trigger_test_1'
/**
output()
count(1)
match("t_value","500")
**/
;

-- 2. update 模拟触发器状态变更
update /test/aaa/test_trigger set t_status='completed', t_value=600 where t_name='trigger_test_1'
;

select t_name, t_value, t_status from /test/aaa/test_trigger where t_name='trigger_test_1'
/**
output()
match("t_status","completed")
match("t_value","600")
**/
;

-- 3. 批量触发器测试
insert into /test/aaa/test_trigger (t_name, t_value, t_status) values ('trigger_batch_1', 10, 'init')
;

insert into /test/aaa/test_trigger (t_name, t_value, t_status) values ('trigger_batch_2', 20, 'init')
;

-- 批量更新状态（模拟触发器批量触发）
update /test/aaa/test_trigger set t_status='processed' where t_status='init'
;

select t_name, t_status from /test/aaa/test_trigger where t_status='processed'
/**
output()
matchcount("t_name","trigger_batch",2)
**/
;

-- 4. delete 触发器相关数据
delete from /test/aaa/test_trigger where t_name='trigger_batch_1'
;

select * from /test/aaa/test_trigger where t_name='trigger_batch_1'
/**
output()
count(0)
**/
;

-- 5. 触发器相关聚合
select t_status, count(*) from /test/aaa/test_trigger group by t_status
/**
output()
**/
;