30 lines
1.3 KiB
SQL
30 lines
1.3 KiB
SQL
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'
|
|
);
|