Interface
12076Interface Overview
_resource Structure
CREATE TABLE `_resource` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`resourceHook` text COMMENT '[ "before": {"service": "xx", "serviceFunction": "xxx"}, "after": [] }',
`pageId` varchar(255) DEFAULT NULL COMMENT 'page id; E.g: index',
`actionId` varchar(255) DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
`desc` varchar(255) DEFAULT NULL COMMENT 'Description',
`resourceType` varchar(255) DEFAULT NULL COMMENT 'resource type; E.g: auth service sql',
`appDataSchema` text COMMENT 'appData parameter validation',
`resourceData` text COMMENT 'resource data; { "service": "auth", "serviceFunction": "passwordLogin" } or { "table": "${tableName}", "action": "select", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',
`requestDemo` text COMMENT 'Request Demo',
`responseDemo` text COMMENT 'Response Demo',
`operation` varchar(255) DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete, jhRestore',
`operationByUserId` varchar(255) DEFAULT NULL COMMENT 'Operator userId',
`operationByUser` varchar(255) DEFAULT NULL COMMENT 'Operator username',
`operationAt` varchar(255) DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00 ',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 823 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Request resource table; Soft delete not enabled; resourceId=`${appId}.${pageId}.${actionId}`'_resource Content
| id | desc | pageId | actionId | resourceType | resourceHook | resourceData |
|