insert into /test/malert_status_local (identifier, severity, lastoccurrence, maintenance, msg, type, agent, firstoccurrence, omni_class, nodealias, alertgroup, node, manager, originalseverity, summary, tags) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict update firstoccurrence=firstoccurrence, servicenowstate=servicenowstate, emailstatus=emailstatus, tally=tally+1
/**
params("xxx", 5, 1622249715000, 1, "设备:222.129.134.178电源整体功能恢复!", 1, "huawei mttrapd #1", 1622211715023, "300", "222.129.134.178", "huawei_power_func", "222.129.134.178", "MTTrapd Probe", 5, "设备:222.129.134.178电源整体功能恢复!", "xxx")
**/
;

select * from /test/malert_status_local limit -1
/**
output()
count(2001)
**/
;


update /test/malert_status_local set summary='xxx' where identifier='xxx'
/**
output()
**/
;

select class,id,identifier,summary from /test/malert_status_local where identifier='xxx'
/**
output()
matchcount(identifier, "xxx", summary, "xxx", 1)
**/
;

update /test/malert_status_local set summary='aaa' where id='4209425540011051504'
/**
output()
**/
;

select class,id,identifier,summary from /test/malert_status_local where id='4209425540011051504'
/**
output()
matchcount(id, "4209425540011051504", summary, "aaa", 1)
**/
;

update /test/malert_status_local set summary='xxx' where id='4209425540011051504'
/**
output()
**/
;

select class,id,identifier,summary from /test/malert_status_local where id='4209425540011051504'
/**
output()
matchcount(id, "4209425540011051504", summary, "xxx", 1)
**/
;

select class,id,identifier,summary from /test/malert_status_local where identifier='xxx'
/**
output()
**/
;

delete from /test/malert_status_local where identifier='xxx'
/**
output()
**/
;

select class,id,identifier,summary from /test/malert_status_local where identifier='xxx'
/**
output()
count(0)
**/
;

select count(*) from /test/malert_status_local
/**
output()
matchcount("count", 2000, 1)
**/
;