forked from open-doubao-ai/OpenDoubao
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsys_Call.sql
More file actions
130 lines (115 loc) · 6.93 KB
/
Copy pathsys_Call.sql
File metadata and controls
130 lines (115 loc) · 6.93 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
-- A2API APIJSON HTTP call logs
-- Table: Call (sys schema / Demo DB)
-- After import: reload Access/Request in APIJSON (or restart the server).
DROP TABLE IF EXISTS `Call`;
CREATE TABLE `Call` (
`id` bigint NOT NULL COMMENT '主键，客户端/服务端分配（如 Date.now()）',
`userId` bigint DEFAULT NULL COMMENT '调用用户 id（APIJSON visitor）',
`submitter` varchar(80) DEFAULT NULL COMMENT '提交人标识 / 登录名',
`sessionId` varchar(80) DEFAULT NULL COMMENT '会话 id',
`requestId` varchar(80) DEFAULT NULL COMMENT '业务 requestId（propose/HITL）',
`source` varchar(40) NOT NULL DEFAULT 'unknown' COMMENT '来源：chat-demo/bound/data-api/admin/approve',
`operation` varchar(20) NOT NULL COMMENT 'APIJSON 方法：get/head/gets/heads/post/put/delete',
`method` varchar(10) NOT NULL DEFAULT 'POST' COMMENT 'HTTP Method，APIJSON 一般为 POST',
`type` varchar(10) NOT NULL DEFAULT 'JSON' COMMENT '请求体类型：JSON/PARAM/FORM',
`url` varchar(250) NOT NULL COMMENT '完整请求 URL',
`bizTable` varchar(50) DEFAULT NULL COMMENT '主业务表别名',
`tag` varchar(50) DEFAULT NULL COMMENT '请求 tag',
`role` varchar(20) DEFAULT NULL COMMENT '实际/期望角色',
`request` text COMMENT '请求体 JSON 文本（可截断）',
`response` text COMMENT '响应体 JSON 文本（可截断）',
`ok` tinyint NOT NULL DEFAULT 0 COMMENT '是否成功：1-是，0-否',
`code` int DEFAULT NULL COMMENT 'APIJSON code 或 HTTP status',
`durationMs` int DEFAULT NULL COMMENT '耗时毫秒',
`usedLlm` tinyint NOT NULL DEFAULT 0 COMMENT '该次是否经过 LLM：1-是，0-否',
`error` text COMMENT '失败信息',
`detail` text COMMENT '备注',
`date` datetime COMMENT '调用时间'
) COMMENT='A2API APIJSON 调用日志';
-- Access (id 9003 — do not reuse 9002; that id is Apply alias Apply in sys_Apply.sql)
DELETE FROM `Access`
WHERE `id` = 9003
OR `alias` = 'Call'
OR (`name` = 'Call' AND (`alias` IS NULL OR `alias` = '' OR `alias` = 'Call'));
DELETE FROM `Access`
WHERE `id` = 9002 AND (`alias` = 'Call' OR `name` = 'Call');
INSERT INTO `Access` (`id`, `debug`, `schema`, `name`, `alias`, `get`, `head`, `gets`, `heads`, `post`, `put`, `delete`, `date`, `detail`)
VALUES (
9003, 0, NULL, 'Call', 'Call',
'["LOGIN", "OWNER", "ADMIN"]',
'["LOGIN", "OWNER", "ADMIN"]',
'["LOGIN", "OWNER", "ADMIN"]',
'["LOGIN", "OWNER", "ADMIN"]',
'["LOGIN", "OWNER", "ADMIN"]',
'["ADMIN"]',
'["ADMIN"]',
NOW(),
'A2API APIJSON call logs'
);
-- Request
DELETE FROM `Request` WHERE `id` IN (9003001, 9003002, 9003003) OR `tag` = 'Call';
INSERT INTO `Request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`) VALUES
(9003001, 0, 1, 'POST', 'Call',
'{"MUST":"id,operation,method,url,ok","INSERT":{"@role":"LOGIN"}}',
'Create A2API Call log', NOW()),
(9003002, 0, 1, 'PUT', 'Call',
'{"MUST":"id","INSERT":{"@role":"ADMIN"}}',
'Update Call log', NOW()),
(9003003, 0, 1, 'GETS', 'Call',
'{}',
'List Call logs', NOW());
-- Seed ~12 call logs for admin stats demos
INSERT INTO `Call` (
`id`, `userId`, `submitter`, `sessionId`, `requestId`, `source`,
`operation`, `method`, `type`, `url`, `bizTable`, `tag`, `role`,
`request`, `response`, `ok`, `code`, `durationMs`, `usedLlm`, `error`, `detail`, `date`
) VALUES
(9100001, 82001, 'alice', 'sess_a1', 'r_get_moments', 'chat-demo',
'get', 'POST', 'JSON', 'http://localhost:8080/get', 'Moment', NULL, 'LOGIN',
'{"[]":{"count":3,"Moment":{"@order":"date-"}}}',
'{"code":200,"[]":[{"Moment":{"id":12}}]}', 1, 200, 48, 1, NULL, 'Bootstrap list moments', '2026-07-20 09:01:00'),
(9100002, 82001, 'alice', 'sess_a1', 'r_get_moments', 'bound',
'get', 'POST', 'JSON', 'http://localhost:8080/get', 'Moment', NULL, 'LOGIN',
'{"[]":{"count":3,"Moment":{"@order":"date-"},"page":1}}',
'{"code":200,"[]":[{"Moment":{"id":12}}]}', 1, 200, 32, 0, NULL, 'Steady-state page change', '2026-07-20 09:01:20'),
(9100003, 82001, 'alice', 'sess_a1', 'r_user_detail', 'chat-demo',
'get', 'POST', 'JSON', 'http://localhost:8080/get', 'User', NULL, 'LOGIN',
'{"User":{"id":38710}}',
'{"code":200,"User":{"id":38710,"name":"Tommy"}}', 1, 200, 41, 1, NULL, 'User detail', '2026-07-20 09:05:00'),
(9100004, 82002, 'bob', 'sess_b1', 'r_put_user', 'chat-demo',
'put', 'POST', 'JSON', 'http://localhost:8080/put', 'User', 'User', 'OWNER',
'{"User":{"id":38710,"name":"Bob"},"tag":"User"}',
'{"code":400,"msg":"no Request row for PUT tag=\\"User\\""}', 0, 400, 55, 0,
'no Request row for PUT tag="User"', 'Permission gate → Apply', '2026-07-21 10:00:00'),
(9100005, 82002, 'bob', 'sess_b1', 'r_post_moment', 'data-api',
'post', 'POST', 'JSON', 'http://localhost:8080/post', 'Moment', 'Moment', 'OWNER',
'{"Moment":{"content":"hi"},"tag":"Moment"}',
'{"code":200,"Moment":{"id":99}}', 1, 200, 67, 0, NULL, 'Data API create', '2026-07-21 10:12:00'),
(9100006, 82001, 'alice', 'sess_a2', 'r_del_comment', 'chat-demo',
'delete', 'POST', 'JSON', 'http://localhost:8080/delete', 'Comment', 'Comment', 'OWNER',
'{"Comment":{"id":12},"tag":"Comment"}',
NULL, 0, 0, 120, 0, 'awaiting admin approval', 'Sensitive delete queued', '2026-07-22 11:00:00'),
(9100007, NULL, 'admin-ui', NULL, 'apply_9002008', 'approve',
'post', 'POST', 'JSON', 'http://localhost:8080/post', 'Request', 'Request', 'ADMIN',
'{"Request":{"method":"POST","tag":"Moment","structure":{}},"tag":"Request"}',
'{"code":200,"Request":{"id":9002010}}', 1, 200, 88, 0, NULL, 'Approve wrote Request', '2026-07-23 16:00:05'),
(9100008, 82003, 'carol', 'sess_c1', 'r_gets_privacy', 'chat-demo',
'gets', 'POST', 'JSON', 'http://localhost:8080/gets', 'Privacy', 'Privacy', 'OWNER',
'{"Privacy":{"id":82001},"tag":"Privacy","version":2}',
'{"code":401,"msg":"请登录或注册"}', 0, 401, 28, 1, '请登录或注册', 'Private read without session', '2026-07-23 18:30:00'),
(9100009, 82001, 'alice', 'sess_a3', 'r_comments', 'bound',
'get', 'POST', 'JSON', 'http://localhost:8080/get', 'Comment', NULL, 'LOGIN',
'{"[]":{"count":20,"Comment":{"momentId":12}}}',
'{"code":200,"[]":[]}', 1, 200, 36, 0, NULL, 'List comments under moment', '2026-07-24 08:00:00'),
(9100010, 82001, 'alice', 'sess_a3', 'r_post_comment', 'chat-demo',
'post', 'POST', 'JSON', 'http://localhost:8080/post', 'Comment', 'Comment', 'OWNER',
'{"Comment":{"momentId":12,"content":"nice"},"tag":"Comment"}',
'{"code":200,"Comment":{"id":44}}', 1, 200, 72, 0, NULL, 'Create comment', '2026-07-24 08:01:00'),
(9100011, 82004, 'dave', 'sess_d1', 'r_get_fail', 'data-api',
'get', 'POST', 'JSON', 'http://localhost:8080/get', 'Moment', NULL, 'UNKNOWN',
'{"Moment":{"id":-1}}',
'{"code":200,"Moment":null}', 1, 200, 22, 0, NULL, 'Empty hit still code 200', '2026-07-24 20:15:00'),
(9100012, 82001, 'alice', 'sess_a4', 'r_put_moment', 'bound',
'put', 'POST', 'JSON', 'http://localhost:8080/put', 'Moment', 'Moment', 'OWNER',
'{"Moment":{"id":12,"content":"edited"},"tag":"Moment"}',
'{"code":200,"Moment":{"id":12}}', 1, 200, 59, 0, NULL, 'Edit moment after Access grant', '2026-07-25 01:10:00');