INSERT INTO sys_api (handle, title, path, type, action)
VALUES
    ('chorus.generations.get', 'Get generation detail', '/api/v1/chorus/generations/:id', 'BUS', 'GET'),
    ('chorus.generations.input.read', 'Read generation input', '/api/v1/chorus/generations/:id/inputs/:inputID', 'BUS', 'GET'),
    ('chorus.generations.output.read', 'Read generation output', '/api/v1/chorus/generations/:id/outputs/:outputID', 'BUS', 'GET'),
    ('chorus.generations.output.thumbnail', 'Read generation output thumbnail', '/api/v1/chorus/generations/:id/outputs/:outputID/thumbnail', 'BUS', 'GET')
ON DUPLICATE KEY UPDATE
    title = VALUES(title), type = VALUES(type), deleted_at = NULL;

INSERT IGNORE INTO sys_menu_api_rule (menu_id, sys_api_id)
SELECT menu.menu_id, api.id
FROM sys_menu menu
JOIN sys_api api ON api.handle IN (
    'chorus.generations.get',
    'chorus.generations.input.read',
    'chorus.generations.output.read',
    'chorus.generations.output.thumbnail'
)
WHERE menu.path = '/chorus/generations';

INSERT IGNORE INTO sys_casbin_rule (ptype, v0, v1, v2, v3, v4, v5)
SELECT 'p', 'chorus_operator', path, action, '', '', ''
FROM sys_api
WHERE handle IN (
    'chorus.generations.get',
    'chorus.generations.input.read',
    'chorus.generations.output.read',
    'chorus.generations.output.thumbnail'
);