A2API/apps/admin/sql/sys_Call.sql at main · APIJSON/A2API · GitHub

History

130 lines (115 loc) · 6.93 KB

Raw

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"]',

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

A2API/apps/admin/sql/sys_Call.sql at main · APIJSON/A2API · GitHub

Uh oh!

Expand file tree

Breadcrumbs

sys_Call.sql

Latest commit

History

Breadcrumbs

sys_Call.sql

File metadata and controls