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'
);