34 lines
907 B
SQL
34 lines
907 B
SQL
DELETE casbin
|
|
FROM sys_casbin_rule casbin
|
|
JOIN sys_api api
|
|
ON casbin.ptype = 'p'
|
|
AND casbin.v0 = 'chorus_operator'
|
|
AND casbin.v1 = api.path
|
|
AND casbin.v2 = api.action
|
|
WHERE api.handle IN (
|
|
'chorus.generations.get',
|
|
'chorus.generations.input.read',
|
|
'chorus.generations.output.read',
|
|
'chorus.generations.output.thumbnail'
|
|
);
|
|
|
|
DELETE menu_api
|
|
FROM sys_menu_api_rule menu_api
|
|
JOIN sys_api api ON api.id = menu_api.sys_api_id
|
|
JOIN sys_menu menu ON menu.menu_id = menu_api.menu_id
|
|
WHERE menu.path = '/chorus/generations'
|
|
AND api.handle IN (
|
|
'chorus.generations.get',
|
|
'chorus.generations.input.read',
|
|
'chorus.generations.output.read',
|
|
'chorus.generations.output.thumbnail'
|
|
);
|
|
|
|
DELETE FROM sys_api
|
|
WHERE handle IN (
|
|
'chorus.generations.get',
|
|
'chorus.generations.input.read',
|
|
'chorus.generations.output.read',
|
|
'chorus.generations.output.thumbnail'
|
|
);
|