odbtools/odbctest/mql/basic/11collect/26.authgroupupdate.mql

select _group from /matrix/group where name = 'admin' refresh
/**
output()
**/
;

update /matrix/group set _group = null where name = 'admin'
;

select _group from /matrix/group where name = 'admin' refresh
/**
output()
matchcount(`_group`, nil, 1)
**/
;

update /matrix/group set _group = _group + ? where name in ?
/**
params({"add": ["网络部"], "delete": ["网络部"], "edit": ["网络部"], "list": ["网络部"]}, ["admin"])
**/
;

select _group from /matrix/group where name = 'admin' refresh
/**
output()
matchcount(`_group.delete.0`, "网络部", 1)
**/
;

update /matrix/group set _group = _group + ? where name in ?
/**
params({"add": ["市场部"]}, ["admin"])
**/
;

select _group from /matrix/group where name = 'admin' refresh
/**
output()
matchcount(`_group.add.len`, 2, 1)
**/
;