APIJSON-Demo/MySQL/single/sys_Document.sql at master · Doctorsyan/APIJSON-Demo

61 lines (54 loc) · 343 KB
-- MySQL dump 10.13  Distrib 5.7.17, for macos10.12 (x86_64)
-- Host: apijson.cn    Database: sys
-- ------------------------------------------------------
-- Server version	5.7.34-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-- Table structure for table `Document`
DROP TABLE IF EXISTS `Document`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Document` (
  `id` bigint(15) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `userId` bigint(15) NOT NULL COMMENT '管理员用户id。\n需要先建Admin表，新增登录等相关接口。',
  `testAccountId` bigint(15) NOT NULL DEFAULT '0' COMMENT '测试账号id。0-不限',
  `version` tinyint(4) NOT NULL DEFAULT '3' COMMENT '接口版本号\n<=0 - 不限制版本，任意版本都可用这个接口；\n>0 - 在这个版本添加的接口。\n\n可在给新版文档前调高默认值，新增的测试用例就不用手动设置版本号了。',
  `name` varchar(100) NOT NULL COMMENT '接口名称',
  `type` varchar(5) NOT NULL DEFAULT 'JSON' COMMENT 'PARAM - GET  url parameters,\nFORM - POST  application/www-x-form-url-encoded,\nJSON - POST  application/json',
  `url` varchar(250) NOT NULL COMMENT '请求地址',
  `request` text NOT NULL COMMENT '请求\n用json格式会导致强制排序，而请求中引用赋值只能引用上面的字段，必须有序。',
  `standard` text,
  `header` text COMMENT '请求头 Request Header：\nkey: value  //注释',
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `detail` text COMMENT '详细的说明，可以是普通文本或 Markdown 格式文本',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1634880504502 DEFAULT CHARSET=utf8 COMMENT='测试用例文档\n后端开发者在测试好后，把选好的测试用例上传，这样就能共享给前端/客户端开发者';
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `Document`
LOCK TABLES `Document` WRITE;
/*!40000 ALTER TABLE `Document` DISABLE KEYS */;
INSERT INTO `Document` VALUES (1,82001,82001,1,'登录','JSON','/login','{\n    \"type\": 0,\n    \"phone\": \"13000082001\",\n    \"password\": \"123456\",\n    \"version\": 1,\n    \"remember\": false\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"type\": {\n                \"notnull\": true,\n                \"type\": \"integer\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    0\n                ],\n                \"lengthLevel\": 1,\n                \"lengths\": [],\n                \"comment\": \"密码类型，0-登录密码  1-验证码\"\n            },\n            \"phone\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    11\n                ],\n                \"comment\": \"手机号\"\n            },\n            \"password\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    6\n                ],\n                \"comment\": \"登录密码或验证码\"\n            },\n            \"version\": {\n                \"notnull\": true,\n                \"type\": \"integer\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    1\n                ],\n                \"lengthLevel\": 1,\n                \"lengths\": [],\n                \"comment\": \"版本号\"\n            },\n            \"remember\": {\n                \"notnull\": true,\n                \"type\": \"boolean\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    false\n                ],\n                \"lengthLevel\": 1,\n                \"lengths\": [],\n                \"comment\": \"记住登录\"\n            }\n        }\n    ]\n}','','2017-11-26 07:35:19',NULL),(2,82001,0,1,'注册(先获取验证码type:1)','JSON','/register','{\n    \"Privacy\": {\n        \"phone\": \"13000083333\",\n        \"_password\": \"123456\"\n    },\n    \"User\": {\n        \"name\": \"APIJSONUser\"\n    },\n    \"verify\": \"6840\" //验证码，需要先调用接口 /post/verify\n}',NULL,NULL,'2017-11-26 07:35:19',NULL),(3,82001,0,1,'退出登录','JSON','/logout','{}',NULL,NULL,'2017-11-26 09:56:10',NULL),(1511689914599,82001,0,1,'获取用户隐私信息','JSON','/gets','{\"tag\": \"Privacy\", \"Privacy\": {\"id\": 82001}}',NULL,NULL,'2017-11-26 09:51:54',NULL),(1511796155276,82001,0,1,'获取验证码','JSON','/post/verify','{\n    \"type\": 0,\n    \"phone\": \"13000082001\"\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"type\": {\n                \"notnull\": true,\n                \"type\": \"integer\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    0\n                ],\n                \"lengthLevel\": 1,\n                \"lengths\": [],\n                \"comment\": \"类型: 0-登录 1-注册 2-修改登录密码 3-修改支付密码\"\n            },\n            \"phone\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    11\n                ],\n                \"comment\": \"手机号\"\n            }\n        }\n    ]\n}','','2017-11-27 15:23:28',NULL),(1511796208671,82001,0,1,'检查验证码是否存在','JSON','/heads/verify','{\n    \"type\": 0,  //类型: 0-登录 1-注册 2-修改登录密码 3-修改支付密码\n    \"phone\": \"13000082001\"  //手机号\n}',NULL,NULL,'2017-11-27 15:23:28',NULL),(1511796589078,82001,82001,1,'修改登录密码(先获取验证码type:2)-手机号+验证码','JSON','/put/password','{\n    \"verify\": \"10322\",  //验证码，需要先调用接口 /post/verify\n    \"Privacy\": {\n        \"phone\": \"13000082001\",\n        \"_password\": \"666666\"\n    }\n}',NULL,NULL,'2017-11-27 15:23:28',NULL),(1511796882184,82001,82001,1,'充值(需要支付密码)/提现','JSON','/put/balance','{\"tag\": \"Privacy\", \"Privacy\": {\"id\": 82001, \"balance+\": 100.15, \"_payPassword\": \"123456\"}}',NULL,NULL,'2017-11-27 15:34:42',NULL),(1511969417633,82001,82001,1,'点赞/取消点赞','JSON','/put','{\n    \"Moment\": {\n        \"id\": 15,\n        \"praiseUserIdList-\": [\n            82001\n        ]\n    },\n    \"tag\": \"Moment\"\n}',NULL,NULL,'2017-11-29 15:30:17',NULL),(1511969630372,82001,82001,1,'新增评论','JSON','/post','{     \"Comment\": {         \"momentId\": 15,         \"content\": \"测试新增评论\"     },     \"tag\": \"Comment\" }',NULL,NULL,'2017-11-29 15:33:50',NULL),(1511970009072,82001,82001,1,'新增动态','JSON','/post','{     \"Moment\": {         \"content\": \"测试新增动态\",         \"pictureList\": [\"http://static.oschina.net/uploads/user/48/96331_50.jpg\"         ]     },     \"tag\": \"Moment\" }',NULL,NULL,'2017-11-29 15:40:09',NULL),(1511970224333,82001,82001,1,'修改用户信息','JSON','/put','{\r     \"User\": {\r         \"id\": 82001,\r         \"name\": \"测试账号\"\r     },\r     \"tag\": \"User\"\r }',NULL,NULL,'2017-11-29 15:43:44',NULL),(1521901518765,88888,0,2,'功能符(对象关键词): ⑤从pictureList获取第0张图片：','JSON','/get','{     \"User\": {         \"id\": 38710,         \"@position\": 0,         \"firstPicture()\": \"getFromArray(pictureList,@position)\"     } }',NULL,NULL,'2018-03-24 14:25:18',NULL),(1521901610784,88888,0,2,'功能符(对象关键词): ④查询 按userId分组、id最大值>=100 的Moment数组','JSON','/get','{\"[]\":{\"count\":10,\"Moment\":{\"@column\":\"userId;max(id):maxId\",\"@group\":\"userId\",\"@having\":\"maxId>=100\"}}}',NULL,NULL,'2018-03-24 14:26:50',NULL),(1521901682846,88888,0,2,'功能符(对象关键词): ③查询按userId分组的Moment数组','JSON','/get','{\"[]\":{\"count\":10,\"Moment\":{\"@column\":\"userId,id\",\"@group\":\"userId,id\"}}}',NULL,NULL,'2018-03-24 14:28:02',NULL),(1521901746809,88888,0,2,'功能符(对象关键词): ②查询按 name降序、id默认顺序 排序的User数组','JSON','/get','{\"[]\":{\"count\":10,\"User\":{\"@column\":\"name,id\",\"@order\":\"name-,id\"}}}',NULL,NULL,'2018-03-24 14:29:06',NULL),(1521901787203,88888,0,2,'功能符(对象关键词): ①只查询id,sex,name这几列并且请求结果也按照这个顺序','JSON','/get','{\"User\":{\"@column\":\"id,sex,name\",\"id\":38710}}',NULL,NULL,'2018-03-24 14:29:47',NULL),(1521902033332,88888,0,2,'功能符(数组关键词): ③查询User数组和对应的User总数','JSON','/get','{\"[]\":{\"query\":2,\"count\":5,\"User\":{}},\"total@\":\"/[]/total\"}',NULL,NULL,'2018-03-24 14:33:53',NULL),(1521902069871,88888,0,2,'功能符(数组关键词): ②查询第3页的User数组，每页5个','JSON','/get','{\"[]\":{\"count\":5,\"page\":3,\"User\":{}}}',NULL,NULL,'2018-03-24 14:34:29',NULL),(1521902110680,88888,0,2,'功能符(数组关键词): ①查询User数组，最多5个','JSON','/get','{\"[]\":{\"count\":5,\"User\":{}}}',NULL,NULL,'2018-03-24 14:35:10',NULL),(1521903761689,88888,0,2,'功能符(逻辑运算): ③ ! 非运算','JSON','/head','{\"User\":{\"id!{}\":[82001,38710]}}',NULL,NULL,'2018-03-24 15:02:41',NULL),(1521903828410,88888,0,2,'功能符(逻辑运算): ② | 或运算','JSON','/head','{\"User\":{\"id|{}\":\">90000,<=80000\"}}',NULL,NULL,'2018-03-24 15:03:48',NULL),(1521903882830,88888,0,2,'功能符(逻辑运算): ① & 与运算','JSON','/head','{\"User\":{\"id&{}\":\">80000,<=90000\"}}',NULL,NULL,'2018-03-24 15:04:42',NULL),(1521904098111,88888,0,2,'功能符: 减少 或 去除','JSON','/put/balance','{\n    \n    \"Privacy\": {\n        \"id\": 82001,\n        \"balance+\": -100,\n        \"_payPassword\": \"123456\"\n    },\"tag\": \"Privacy\"\n}',NULL,NULL,'2018-03-24 15:08:18',NULL),(1521904162066,88888,0,2,'功能符: 增加 或 扩展','JSON','/put','{\n    \"Moment\": {\n        \"id\": 15,\n        \"praiseUserIdList+\": [\n            82001\n        ]\n    },\n    \"tag\": \"Moment\"\n}',NULL,NULL,'2018-03-24 15:09:22',NULL),(1521904337054,88888,0,2,'功能符: 新建别名','JSON','/get','{\"Comment\":{\"@column\":\"id,toId:parentId\",\"id\":51}}',NULL,NULL,'2018-03-24 15:12:17',NULL),(1521904394042,88888,0,2,'功能符: 正则匹配','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{\"name~\":\"^[0-9]+$\"}}}',NULL,NULL,'2018-03-24 15:13:14',NULL),(1521904437584,88888,0,2,'功能符: 模糊搜索','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{\"name$\":\"%m%\"}}}',NULL,NULL,'2018-03-24 15:13:57',NULL),(1521904547992,88888,0,2,'功能符: 引用赋值','JSON','/get','{\"Moment\":{\n   \"userId\":38710\n},\n\"User\":{\n   \"id@\":\"/Moment/userId\"\n}}',NULL,NULL,'2018-03-24 15:15:47',NULL),(1521904617127,88888,0,2,'功能符: 远程调用函数','JSON','/get','{     \"Moment\": {         \"id\": 301,         \"@column\": \"userId,praiseUserIdList\",         \"isPraised()\": \"isContain(praiseUserIdList,userId)\"     } }',NULL,NULL,'2018-03-24 15:16:57',NULL),(1521904653622,88888,0,2,'功能符: 包含选项范围','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{\"contactIdList<>\":38710}}}',NULL,NULL,'2018-03-24 15:17:33',NULL),(1521904698935,88888,0,2,'功能符: 匹配条件范围','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{\"id{}\":\"<=80000,>90000\"}}}',NULL,NULL,'2018-03-24 15:18:18',NULL),(1521904756674,88888,0,2,'功能符: 查询数组','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{}}}',NULL,NULL,'2018-03-24 15:19:16',NULL),(1521905263828,88888,82001,2,'操作方法(DELETE):  删除数据','JSON','/delete','{\n   \"Moment\":{\n     \"id\":120\n   },\n   \"tag\":\"Moment\"\n}',NULL,NULL,'2018-03-24 15:27:43',NULL),(1521905599150,88888,82001,2,'操作方法(PUT):  修改数据，只修改所传的字段','JSON','/put','{\n   \"Moment\":{\n     \"id\":235,\n     \"content\":\"APIJSON,let interfaces and documents go to hell !\"\n   },\n   \"tag\":\"Moment\"\n}',NULL,NULL,'2018-03-24 15:33:19',NULL),(1521905680680,88888,82001,2,'操作方法(POST):  新增数据','JSON','/post','{     \"Moment\": {          \"content\": \"APIJSON,let interfaces and documents go to hell !\"     },     \"tag\": \"Moment\" }',NULL,NULL,'2018-03-24 15:34:40',NULL),(1521905787850,88888,82001,2,'操作方法(HEADS):  安全/私密获取数量，用于获取银行卡数量等 对安全性要求高的数据总数','JSON','/heads','{\n    \"Login\": {\n        \"userId\": 38710,\"type\":1\n    },\n    \"tag\": \"Login\"\n}',NULL,NULL,'2018-03-24 15:36:27',NULL),(1521905868719,88888,82001,2,'操作方法(GETS):  安全/私密获取数据，用于获取钱包等 对安全性要求高的数据','JSON','/gets','{\n    \"Privacy\": {\n        \"id\": 82001\n    },\n    \"tag\": \"Privacy\"\n}',NULL,NULL,'2018-03-24 15:37:48',NULL),(1521905895591,88888,82001,2,'操作方法(HEAD):  普通获取数量，可用浏览器调试','JSON','/head','{\n   \"Moment\":{\n     \"userId\":38710\n   }\n}',NULL,NULL,'2018-03-24 15:38:15',NULL),(1521905913188,88888,82001,2,'操作方法(GET):  普通获取数据，可用浏览器调试','JSON','/get','{\n   \"Moment\":{\n     \"id\":235\n   }\n}',NULL,NULL,'2018-03-24 15:38:33',NULL),(1521906240332,88888,0,2,'User发布的Moment列表，每个Moment包括 1.发布者User 2.前3条Comment: ③不查已获取的User','JSON','/get','{\n   \"[]\":{\n     \"page\":0,\n     \"count\":3, \n     \"Moment\":{\n       \"userId\":38710\n     },\n     \"Comment[]\":{\n       \"count\":3,\n       \"Comment\":{\n         \"momentId@\":\"[]/Moment/id\"\n       }\n     }\n   }\n}',NULL,NULL,'2018-03-24 15:44:00',NULL),(1521906265960,88888,0,2,'User发布的Moment列表，每个Moment包括 1.发布者User 2.前3条Comment: ②省去重复的User','JSON','/get','{\n   \"User\":{\n     \"id\":38710\n   },\n   \"[]\":{\n     \"page\":0,\n     \"count\":3, \n     \"Moment\":{\n       \"userId\":38710\n     }, \n     \"Comment[]\":{\n       \"count\":3,\n       \"Comment\":{\n         \"momentId@\":\"[]/Moment/id\"\n       }\n     }\n   }\n}',NULL,NULL,'2018-03-24 15:44:25',NULL),(1521906517001,88888,0,2,'User发布的Moment列表，每个Moment包括 1.发布者User 2.前3条Comment: ①指定id','JSON','/get','{\n    \"[]\": {\n        \"page\": 0,\n        \"count\": 3,\n        \"Moment\":{\"userId\":38710}, \"User\":{\"id\":38710} ,\n        \"Comment[]\": {\n            \"count\": 3,\n            \"Comment\": {\n                \"momentId@\": \"[]/Moment/id\"\n            }\n        }\n    }\n}',NULL,NULL,'2018-03-24 15:48:37',NULL),(1521907009308,88888,0,2,'Moment列表，每个Moment包括 1.发布者User 2.前3条Comment','JSON','/get','{\n   \"[]\":{\n     \"page\":0, \n     \"count\":3, \n     \"Moment\":{}, \n     \"User\":{\n       \"id@\":\"/Moment/userId\"\n     },\n     \"Comment[]\":{\n       \"count\":3,\n       \"Comment\":{\n         \"momentId@\":\"[]/Moment/id\"\n       }\n     }\n   }\n}',NULL,NULL,'2018-03-24 15:56:49',NULL),(1521907303540,88888,0,2,'User列表','JSON','/get','{\n   \"User[]\":{\n     \"page\":0,\n     \"count\":3, \n     \"User\":{\n       \"sex\":0\n     }\n   }\n}',NULL,NULL,'2018-03-24 16:01:43',NULL),(1521907317871,88888,0,2,'Moment和对应的User','JSON','/get','{\n   \"Moment\":{\n     \"userId\":38710\n   }, \n   \"User\":{\n     \"id\":38710\n   }\n}',NULL,NULL,'2018-03-24 16:01:57',NULL),(1521907333041,88888,0,2,'User','JSON','/get','{\n   \"User\":{\n     \"id\":38710\n   }\n}',NULL,NULL,'2018-03-24 16:02:13',NULL),(1521907333043,88888,82002,3,'微信个人资料-用户信息+最近3个有照片的动态的第0张照片','JSON','/get','{\n    \"User\": {\n        \"id\": 82002\n    },\n    \"Moment-firstPicture[]\": {\n        \"count\": 3,\n        \"Moment\": {\n            \"userId@\": \"User/id\",\n            \"@column\": \"pictureList\",\n            \"@having\": \"json_length(pictureList)>0\",\n            \"firstPicture()\": \"getFromArray(pictureList,0)\"\n        }\n    }\n}',NULL,NULL,'2018-03-24 16:03:13',NULL),(1521907333044,82001,82002,3,'微信个人资料-用户信息+最近3个有照片的动态的第0张照片','JSON','/get','{\r     \"User\": {\r         \"id\": 82002\r     },\r     \"Moment-firstPicture[]\": {\r         \"count\": 3,\r         \"Moment\": {\r             \"userId@\": \"User/id\",\r             \"@column\": \"userId,pictureList\",\r             \"@having\": \"json_length(pictureList)>0\",\r             \"firstPicture()\": \"getFromArray(pictureList,0)\"\r         }\r     }\r }',NULL,NULL,'2018-03-24 16:03:13',NULL),(1521907333046,88888,0,2,'获取粉丝的动态列表','JSON','/get','{     \"Moment[]\": {         \"join\": \"&/User/id@\",         \"Moment\": {},         \"User\": {             \"id@\": \"/Moment/userId\",             \"contactIdList<>\": 82001,             \"@column\": \"id\"         }     } }',NULL,NULL,'2018-03-24 16:03:13',NULL),(1521907546129,88888,0,2,'获取类似微信朋友圈的动态列表','JSON','/get','{\n    \"[]\": {\n        \"page\": 0,\n        \"count\": 2,\n        \"Moment\": {\n            \"content$\": \"%a%\"\n        },\n        \"User\": {\n            \"id@\": \"/Moment/userId\",\n            \"@column\": \"id,name,head\"\n        },\n        \"Comment[]\": {\n            \"count\": 2,\n            \"Comment\": {\n                \"momentId@\": \"[]/Moment/id\"\n            }\n        }\n    }\n}',NULL,NULL,'2018-03-24 16:05:46',NULL),(1521907570452,88888,0,2,'获取动态及发布者用户','JSON','/get','{\n    \"Moment\": {},\n    \"User\": {\n        \"id@\": \"Moment/userId\"\n    }\n}',NULL,NULL,'2018-03-24 16:06:10',NULL),(1521907587430,88888,0,2,'获取用户列表','JSON','/get','{\n    \"[]\": {\n        \"count\": 3,\n        \"User\": {\n            \"@column\": \"id,name\"\n        }\n    }\n}',NULL,NULL,'2018-03-24 16:06:27',NULL),(1521907601299,88888,0,2,'获取用户','JSON','/get','{\n  \"User\":{\n  }\n}',NULL,NULL,'2018-03-24 16:06:41',NULL),(1522905263828,82001,0,2,'操作方法(DELETE):  删除数据','JSON','/delete','{\n   \"Moment\":{\n     \"id\":120\n   },\n   \"tag\":\"Moment\"\n}',NULL,NULL,'2018-03-24 13:27:43',NULL),(1522905599150,82001,0,2,'操作方法(PUT):  修改数据，只修改所传的字段','JSON','/put','{\n   \"Moment\":{\n     \"id\":235,\n     \"content\":\"APIJSON,let interfaces and documents go to hell !\"\n   },\n   \"tag\":\"Moment\"\n}',NULL,NULL,'2018-03-24 13:33:19',NULL),(1522905680680,82001,0,2,'操作方法(POST):  新增数据','JSON','/post','{     \"Moment\": {          \"content\": \"APIJSON,let interfaces and documents go to hell !\"     },     \"tag\": \"Moment\" }',NULL,NULL,'2018-03-24 13:34:40',NULL),(1522905787850,82001,0,2,'操作方法(HEADS):  安全/私密获取数量，用于获取银行卡数量等 对安全性要求高的数据总数','JSON','/heads','{\n    \"Login\": {\n        \"userId\": 38710,\"type\":1\n    },\n    \"tag\": \"Login\"\n}',NULL,NULL,'2018-03-24 13:36:27',NULL),(1522905868719,82001,0,2,'操作方法(GETS):  安全/私密获取数据，用于获取钱包等 对安全性要求高的数据','JSON','/gets','{\n    \"Privacy\": {\n        \"id\": 82001\n    },\n    \"tag\": \"Privacy\"\n}',NULL,NULL,'2018-03-24 13:37:48',NULL),(1522905895591,82001,0,2,'操作方法(HEAD):  普通获取数量，可用浏览器调试','JSON','/head','{\n   \"Moment\":{\n     \"userId\":38710\n   }\n}',NULL,NULL,'2018-03-24 13:38:15',NULL),(1522905913188,82001,0,2,'操作方法(GET):  普通获取数据，可用浏览器调试','JSON','/get','{\n   \"Moment\":{\n     \"id\":235\n   }\n}',NULL,NULL,'2018-03-24 13:38:33',NULL),(1544881887527,88888,0,3,'Moment INNER JOIN User LEFT JOIN Comment','JSON','/get','{\n    \"[]\": {\n        \"count\": 10,\n        \"page\": 0,\n        \"join\": \"&/User/id@,</Comment/momentId@\",\n        \"Moment\": {\n            \"@order\": \"date+\"\n        },\n        \"User\": {\n            \"name~\": [\n                \"a\",\n                \"t\"\n            ],\n            \"id@\": \"/Moment/userId\",\n            \"@column\": \"id,name,head\"\n        },\n        \"Comment\": {\n            \"momentId@\": \"/Moment/id\",\n            \"@column\": \"id,momentId,content\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:51:27',NULL),(1544882007411,88888,0,3,'Moment LEFT JOIN User','JSON','/get','{\n    \"[]\": {\n        \"join\": \"</User/id@\",\n        \"Moment\": {\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:53:27',NULL),(1544882038386,88888,0,3,'Comment LEFT JOIN User','JSON','/get','{\n    \"[]\": {\n        \"join\": \"</User/id@\",\n        \"Comment\": {\n            \"@column\": \"id,userId,content\",\"@order\":\"date-\"\n        },\n        \"User\": {\n            \"@column\": \"id,name\",\n            \"id@\": \"/Comment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:53:58',NULL),(1544882070832,88888,0,3,'Moment INNER JOIN User','JSON','/get','{\n    \"[]\": {\n        \"join\": \"&/User/id@\",\n        \"Moment\": {\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\"name~\":[\"a\",\"t\"],\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:54:30',NULL),(1544882126906,88888,0,3,'Comment INNER JOIN User','JSON','/get','{\n    \"[]\": {\n        \"join\": \"&/User/id@\",\n        \"Comment\": {\n            \"content~\": \"a\",\n            \"@order\": \"date-\"\n        },\n        \"User\": {\n            \"name~\": [\n                \"a\",\n                \"t\"\n            ],\n            \"@column\": \"id,name\",\n            \"id@\": \"/Comment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:55:26',NULL),(1544882162662,88888,0,3,'Moment APP JOIN User','JSON','/get','{\n    \"[]\": {\n        \"join\": \"@/User/id@\",\n        \"Moment\": {\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:56:02',NULL),(1544882183671,88888,0,3,'Comment APP JOIN User','JSON','/get','{\n    \"[]\": {\n        \"join\": \"@/User/id@\",\n        \"Comment\": {\n            \"content~\": \"a\",\n            \"@order\": \"date-\"\n        },\n        \"User\": {\n            \"name~\": [\n                \"a\",\n                \"t\"\n            ],\n            \"@column\": \"id,name\",\n            \"id@\": \"/Comment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:56:23',NULL),(1544882236758,88888,0,3,'朋友圈 LEFT JOIN','JSON','/get','{\n    \"[]\": {\n        \"count\": 5,\n        \"page\": 0,\n        \"join\": \"</User/id@\",\n        \"Moment\": {\n            \"@order\": \"date+\"\n        },\n        \"User\": {\n            \"id@\": \"/Moment/userId\",\n            \"@column\": \"id,name,head\"\n        },\n        \"User[]\": {\n            \"count\": 10,\n            \"User\": {\n                \"id{}@\": \"[]/Moment/praiseUserIdList\",\n                \"@column\": \"id,name\"\n            }\n        },\n        \"[]\": {\n            \"count\": 6, \"join\": \"</User/id@\",\n            \"Comment\": {\n                \"@order\": \"date+\",\n                \"momentId@\": \"[]/Moment/id\"\n            },\n            \"User\": {\n                \"id@\": \"/Comment/userId\",\n                \"@column\": \"id,name\"\n            }\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:57:16',NULL),(1544882253771,88888,0,3,'朋友圈 APP JOIN','JSON','/get','{\n    \"[]\": {\n        \"count\": 5,\n        \"page\": 0,\n        \"join\": \"@/User/id@\",\n        \"Moment\": {\n            \"@order\": \"date+\"\n        },\n        \"User\": {\n            \"id@\": \"/Moment/userId\",\n            \"@column\": \"id,name,head\"\n        },\n        \"User[]\": {\n            \"count\": 10,\n            \"User\": {\n                \"id{}@\": \"[]/Moment/praiseUserIdList\",\n                \"@column\": \"id,name\"\n            }\n        },\n        \"[]\": {\n            \"count\": 6,\n            \"join\": \"@/User/id@\",\n            \"Comment\": {\n                \"@order\": \"date+\",\n                \"momentId@\": \"[]/Moment/id\"\n            },\n            \"User\": {\n                \"id@\": \"/Comment/userId\",\n                \"@column\": \"id,name\"\n            }\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:57:33',NULL),(1544882327374,88888,0,3,'Comment SIDE JOIN User','JSON','/get','{\n    \"[]\": {\n        \"join\": \"^/User/id@\",\n        \"Comment\": {\n            \"@column\": \"id,userId,content\",\n            \"@order\": \"date-\"\n        },\n        \"User\": {\n            \"@column\": \"id,name\",\n            \"id@\": \"/Comment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:58:47',NULL),(1544882345510,88888,0,3,'Moment SIDE JOIN User','JSON','/get','{\n    \"[]\": {\n        \"join\": \"^/User/id@\",\n        \"Moment\": {\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:59:05',NULL),(1544883133787,88888,0,3,'Moment^User each with condition','JSON','/get','{\n    \"[]\": {\n        \"join\": \"^/User/id@\",\n        \"Moment\": {\"content~\":\"a\",\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\"sex\":1,\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 14:12:13',NULL),(1544883165350,88888,0,3,'Moment<User each with condition','JSON','/get','{\n    \"[]\": {\n        \"join\": \"</User/id@\",\n        \"Moment\": {\n            \"content~\": \"a\",\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"sex\": 1,\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 14:12:45',NULL),(1544883183460,88888,0,3,'Moment&User each with condition','JSON','/get','{\n    \"[]\": {\n        \"join\": \"&/User/id@\",\n        \"Moment\": {\n            \"content~\": \"a\",\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"sex\": 1,\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 14:13:03',NULL),(1544883206003,88888,0,3,'Moment|User each with condition','JSON','/get','{\n    \"[]\": {\n        \"join\": \"|/User/id@\",\n        \"Moment\": {\n            \"content~\": \"a\",\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"sex\": 1,\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 14:13:26',NULL),(1544883224060,88888,0,3,'Moment!User each with condition','JSON','/get','{\n    \"[]\": {\n        \"join\": \"!/User/id@\",\n        \"Moment\": {\n            \"content~\": \"a\",\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"sex\": 1,\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 14:13:44',NULL),(1544883250598,88888,0,3,'Moment>User each with condition','JSON','/get','{\n    \"[]\": {\n        \"join\": \">/User/id@\",\n        \"Moment\": {\n            \"content~\": \"a\",\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"sex\": 1,\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 14:14:10',NULL),(1544883278939,88888,0,3,'Moment@User each with condition','JSON','/get','{\n    \"[]\": {\n        \"join\": \"@/User/id@\",\n        \"Moment\": {\n            \"content~\": \"a\",\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"sex\": 1,\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 14:14:38',NULL),(1544883352884,88888,0,3,'Moment<User<Comment','JSON','/get','{\n    \"[]\": {\n        \"join\": \"</User/id@,</Comment/momentId@\",\n        \"Moment\": {\n            \"content~\": \"a\",\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"sex\": 1,\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        },\n        \"Comment\": {\n            \"momentId@\": \"/Moment/id\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 14:15:52',NULL),(1544883368286,88888,0,3,'Moment&User<Comment','JSON','/get','{\n    \"[]\": {\n        \"join\": \"&/User/id@,</Comment/momentId@\",\n        \"Moment\": {\n            \"content~\": \"a\",\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"sex\": 1,\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        },\n        \"Comment\": {\n            \"momentId@\": \"/Moment/id\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 14:16:08',NULL),(1544883407371,88888,0,3,'Moment|User<Comment','JSON','/get','{\n    \"[]\": {\n        \"join\": \"|/User/id@,</Comment/momentId@\",\n        \"Moment\": {\n            \"content~\": \"a\",\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"sex\": 1,\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        },\n        \"Comment\": {\n            \"momentId@\": \"/Moment/id\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 14:16:47',NULL),(1544883431831,88888,0,3,'Moment^User<Comment','JSON','/get','{\n    \"[]\": {\n        \"join\": \"^/User/id@,</Comment/momentId@\",\n        \"Moment\": {\n            \"content~\": \"a\",\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"sex\": 1,\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        },\n        \"Comment\": {\n            \"momentId@\": \"/Moment/id\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 14:17:11',NULL),(1544883455364,88888,0,3,'Moment@User<Comment','JSON','/get','{\n    \"[]\": {\n        \"join\": \"@/User/id@,</Comment/momentId@\",\n        \"Moment\": {\n            \"content~\": \"a\",\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"sex\": 1,\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        },\n        \"Comment\": {\n            \"momentId@\": \"/Moment/id\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 14:17:35',NULL),(1544884133788,88888,0,3,'Moment@User each with condition','JSON','/get','{     \"[]\": {         \"join\": \"@/User/id@\",         \"Moment\": {\"content~\":\"a\",             \"@column\": \"id,userId,content\"         },         \"User\": {\"sex\":1,             \"@column\": \"id,name\",             \"id@\": \"/Moment/userId\"         }     } }',NULL,NULL,'2018-12-15 14:12:13',NULL),(1544884165351,88888,0,3,'Moment@User each with condition','JSON','/get','{     \"[]\": {         \"join\": \"@/User/id@\",         \"Moment\": {             \"content~\": \"a\",             \"@column\": \"id,userId,content\"         },         \"User\": {             \"sex\": 1,             \"@column\": \"id,name\",             \"id@\": \"/Moment/userId\"         }     } }',NULL,NULL,'2018-12-15 14:12:45',NULL),(1544884183460,88888,0,3,'Moment@User each with condition','JSON','/get','{     \"[]\": {         \"join\": \"@/User/id@\",         \"Moment\": {             \"content~\": \"a\",             \"@column\": \"id,userId,content\"         },         \"User\": {             \"sex\": 1,             \"@column\": \"id,name\",             \"id@\": \"/Moment/userId\"         }     } }',NULL,NULL,'2018-12-15 14:13:03',NULL),(1544884206003,88888,0,3,'Moment@User each with condition','JSON','/get','{     \"[]\": {         \"join\": \"@/User/id@\",         \"Moment\": {             \"content~\": \"a\",             \"@column\": \"id,userId,content\"         },         \"User\": {             \"sex\": 1,             \"@column\": \"id,name\",             \"id@\": \"/Moment/userId\"         }     } }',NULL,NULL,'2018-12-15 14:13:26',NULL),(1544884224060,88888,0,3,'Moment@User each with condition','JSON','/get','{     \"[]\": {         \"join\": \"@/User/id@\",         \"Moment\": {             \"content~\": \"a\",             \"@column\": \"id,userId,content\"         },         \"User\": {             \"sex\": 1,             \"@column\": \"id,name\",             \"id@\": \"/Moment/userId\"         }     } }',NULL,NULL,'2018-12-15 14:13:44',NULL),(1544884250598,88888,0,3,'Moment@User each with condition','JSON','/get','{     \"[]\": {         \"join\": \"@/User/id@\",         \"Moment\": {             \"content~\": \"a\",             \"@column\": \"id,userId,content\"         },         \"User\": {             \"sex\": 1,             \"@column\": \"id,name\",             \"id@\": \"/Moment/userId\"         }     } }',NULL,NULL,'2018-12-15 14:14:10',NULL),(1544884278939,88888,0,3,'Moment@User each with condition','JSON','/get','{\n    \"[]\": {\n        \"join\": \"@/User/id@\",\n        \"Moment\": {\n            \"content~\": \"a\",\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"sex\": 1,\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 14:14:38',NULL),(1544884352884,88888,0,3,'Moment@User<Comment','JSON','/get','{     \"[]\": {         \"join\": \"@/User/id@,</Comment/momentId@\",         \"Moment\": {             \"content~\": \"a\",             \"@column\": \"id,userId,content\"         },         \"User\": {             \"sex\": 1,             \"@column\": \"id,name\",             \"id@\": \"/Moment/userId\"         },         \"Comment\": {             \"momentId@\": \"/Moment/id\"         }     } }',NULL,NULL,'2018-12-15 14:15:52',NULL),(1544884368286,88888,0,3,'Moment@User<Comment','JSON','/get','{     \"[]\": {         \"join\": \"@/User/id@,</Comment/momentId@\",         \"Moment\": {             \"content~\": \"a\",             \"@column\": \"id,userId,content\"         },         \"User\": {             \"sex\": 1,             \"@column\": \"id,name\",             \"id@\": \"/Moment/userId\"         },         \"Comment\": {             \"momentId@\": \"/Moment/id\"         }     } }',NULL,NULL,'2018-12-15 14:16:08',NULL),(1544884407371,88888,0,3,'Moment@User<Comment','JSON','/get','{     \"[]\": {         \"join\": \"@/User/id@,</Comment/momentId@\",         \"Moment\": {             \"content~\": \"a\",             \"@column\": \"id,userId,content\"         },         \"User\": {             \"sex\": 1,             \"@column\": \"id,name\",             \"id@\": \"/Moment/userId\"         },         \"Comment\": {             \"momentId@\": \"/Moment/id\"         }     } }',NULL,NULL,'2018-12-15 14:16:47',NULL),(1544884431831,88888,0,3,'Moment@User<Comment','JSON','/get','{     \"[]\": {         \"join\": \"@/User/id@,</Comment/momentId@\",         \"Moment\": {             \"content~\": \"a\",             \"@column\": \"id,userId,content\"         },         \"User\": {             \"sex\": 1,             \"@column\": \"id,name\",             \"id@\": \"/Moment/userId\"         },         \"Comment\": {             \"momentId@\": \"/Moment/id\"         }     } }',NULL,NULL,'2018-12-15 14:17:11',NULL),(1544884455364,88888,0,3,'Moment@User<Comment','JSON','/get','{\n    \"[]\": {\n        \"join\": \"@/User/id@,</Comment/momentId@\",\n        \"Moment\": {\n            \"content~\": \"a\",\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"sex\": 1,\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        },\n        \"Comment\": {\n            \"momentId@\": \"/Moment/id\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 14:17:35',NULL),(1546414155879,82001,82001,3,'获取类似微信朋友圈的动态列表','JSON','/get','{\n    \"[]\": {\n        \"page\": 0,\n        \"count\": 2,\n        \"Moment\": {\n            \"content$\": \"%a%\"\n        },\n        \"User\": {\n            \"id@\": \"/Moment/userId\",\n            \"@column\": \"id,name,head\"\n        },\n        \"Comment[]\": {\n            \"count\": 2,\n            \"Comment\": {\n                \"momentId@\": \"[]/Moment/id\"\n            }\n        }\n    }\n}',NULL,NULL,'2019-01-02 07:29:15',NULL),(1546414179257,82001,82001,3,'获取动态及发布者用户','JSON','/get','{\n    \"Moment\": {},\n    \"User\": {\n        \"id@\": \"Moment/userId\"\n    }\n}',NULL,NULL,'2019-01-02 07:29:39',NULL),(1546414192830,82001,82001,3,'获取用户列表','JSON','/get','{\n    \"[]\": {\n        \"count\": 3,\n        \"User\": {\n            \"@column\": \"id,name\"\n        }\n    }\n}',NULL,NULL,'2019-01-02 07:29:52',NULL),(1546414207052,82001,82001,3,'获取用户','JSON','/get','{\n  \"User\":{\n  }\n}',NULL,NULL,'2019-01-02 07:30:07',NULL),(1546881887421,88888,0,1,'子查询 WHERE id IN(SELECT userId FROM Comment WHERE momentId=15)','JSON','/get','{\n    \"[]\": {\n        \"User\": {\n            \"id{}@\": {\n                \"from\": \"Comment\",\n                \"Comment\": {\n                    \"momentId\": 15,\n                    \"@column\": \"userId\"\n                }\n            },\n            \"@column\": \"id,sex,name\"\n        }\n    }\n}',NULL,NULL,'2018-02-24 14:25:18',NULL),(1546881887422,88888,0,1,'子查询 WHERE EXISTS(SELECT userId FROM Comment WHERE momentId=15)','JSON','/get','{\n    \"[]\": {\n        \"User\": {\n            \"id}{@\": {\n                \"from\": \"Comment\",\n                \"Comment\": {\n                    \"momentId\": 15,\n                    \"@column\": \"userId\"\n                }\n            },\n            \"@column\": \"id,sex,name\"\n        }\n    }\n}',NULL,NULL,'2018-02-24 14:25:18',NULL),(1546881887423,88888,0,1,'子查询 WHERE id=(SELECT min(userId) FROM Comment)','JSON','/get','{\n    \"User\": {\n        \"id@\": {\n            \"from\": \"Comment\",\n            \"Comment\": {\n                \"@column\": \"min(userId)\"\n            }\n        }\n    }\n}',NULL,NULL,'2018-02-24 14:28:18',NULL),(1546881887521,82001,82001,1,'子查询 WHERE id IN(SELECT userId FROM Comment WHERE momentId=15)','JSON','/get','{\n    \"[]\": {\n        \"User\": {\n            \"id{}@\": {\n                \"from\": \"Comment\",\n                \"Comment\": {\n                    \"momentId\": 15,\n                    \"@column\": \"userId\"\n                }\n            },\n            \"@column\": \"id,sex,name\"\n        }\n    }\n}',NULL,NULL,'2018-02-24 14:25:18',NULL),(1546881887522,82001,82001,1,'子查询 WHERE EXISTS(SELECT userId FROM Comment WHERE momentId=15)','JSON','/get','{\n    \"[]\": {\n        \"User\": {\n            \"id}{@\": {\n                \"from\": \"Comment\",\n                \"Comment\": {\n                    \"momentId\": 15,\n                    \"@column\": \"userId\"\n                }\n            },\n            \"@column\": \"id,sex,name\"\n        }\n    }\n}',NULL,NULL,'2018-02-24 14:25:18',NULL),(1546881887523,82001,82001,1,'子查询 WHERE id=(SELECT min(userId) FROM Comment)','JSON','/get','{\n    \"User\": {\n        \"id@\": {\n            \"from\": \"Comment\",\n            \"Comment\": {\n                \"@column\": \"min(userId)\"\n            }\n        }\n    }\n}',NULL,NULL,'2018-02-24 14:28:18',NULL),(1546881887524,88888,88888,1,'存储过程','JSON','/get','{\n    \"User\": {\n        \"@limit\": 10,\n        \"@offset\": 0,\n        \"@procedure()\": \"getCommentByUserId(id,@limit,@offset)\"\n    }\n}',NULL,NULL,'2018-03-24 13:34:40',NULL),(1546881887525,82001,82001,1,'存储过程','JSON','/get','{\n    \"User\": {\n        \"@limit\": 10,\n        \"@offset\": 0,\n        \"@procedure()\": \"getCommentByUserId(id,@limit,@offset)\"\n    }\n}',NULL,NULL,'2018-03-24 13:34:40',NULL),(1546881887527,82001,0,1,'Moment INNER JOIN User LEFT JOIN Comment','JSON','/get','{\n    \"[]\": {\n        \"count\": 10,\n        \"page\": 0,\n        \"join\": \"&/User/id@,</Comment/momentId@\",\n        \"Moment\": {\n            \"@order\": \"date+\"\n        },\n        \"User\": {\n            \"name~\": [\n                \"a\",\n                \"t\"\n            ],\n            \"id@\": \"/Moment/userId\",\n            \"@column\": \"id,name,head\"\n        },\n        \"Comment\": {\n            \"momentId@\": \"/Moment/id\",\n            \"@column\": \"id,momentId,content\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:51:27',NULL),(1546882007411,82001,0,1,'Moment LEFT JOIN User','JSON','/get','{\n    \"[]\": {\n        \"join\": \"</User/id@\",\n        \"Moment\": {\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:53:27',NULL),(1546882038386,82001,0,1,'Comment LEFT JOIN User','JSON','/get','{\n    \"[]\": {\n        \"join\": \"</User/id@\",\n        \"Comment\": {\n            \"@column\": \"id,userId,content\",\"@order\":\"date-\"\n        },\n        \"User\": {\n            \"@column\": \"id,name\",\n            \"id@\": \"/Comment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:53:58',NULL),(1546882070832,82001,0,1,'Moment INNER JOIN User','JSON','/get','{\n    \"[]\": {\n        \"join\": \"&/User/id@\",\n        \"Moment\": {\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\"name~\":[\"a\",\"t\"],\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:54:30',NULL),(1546882126906,82001,0,1,'Comment INNER JOIN User','JSON','/get','{\n    \"[]\": {\n        \"join\": \"&/User/id@\",\n        \"Comment\": {\n            \"content~\": \"a\",\n            \"@order\": \"date-\"\n        },\n        \"User\": {\n            \"name~\": [\n                \"a\",\n                \"t\"\n            ],\n            \"@column\": \"id,name\",\n            \"id@\": \"/Comment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:55:26',NULL),(1546882162662,82001,0,1,'Moment APP JOIN User','JSON','/get','{\n    \"[]\": {\n        \"join\": \"@/User/id@\",\n        \"Moment\": {\n            \"@column\": \"id,userId,content\"\n        },\n        \"User\": {\n            \"@column\": \"id,name\",\n            \"id@\": \"/Moment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 13:56:02',NULL),(1546882183671,82001,0,1,'Comment APP JOIN User','JSON','/get','{\n    \"[]\": {\n        \"join\": \"@/User/id@\",\n        \"Comment\": {\n            \"content~\": \"a\",\n            \"@order\": \"date-\"\n        },\n        \"User\": {\n            \"name~\": [\n                \"a\",\n                \"t\"\n            ],\n            \"@column\": \"id,name\",\n            \"id@\": \"/Comment/userId\"\n        }\n    }\n}',NULL,NULL,'2018-12-15 12:56:23',NULL),(1546882236758,82001,0,1,'朋友圈 LEFT JOIN','JSON','/get','{\n    \"[]\": {\n        \"count\": 5,\n        \"page\": 0,\n        \"join\": \"</User/id@\",\n        \"Moment\": {\n            \"@order\": \"date+\"\n        },\n        \"User\": {\n            \"id@\": \"/Moment/userId\",\n            \"@column\": \"id,name,head\"\n        },\n        \"User[]\": {\n            \"count\": 10,\n            \"User\": {\n                \"id{}@\": \"[]/Moment/praiseUserIdList\",\n                \"@column\": \"id,name\"\n            }\n        },\n        \"[]\": {\n            \"count\": 6, \"join\": \"</User/id@\",\n            \"Comment\": {\n                \"@order\": \"date+\",\n                \"momentId@\": \"[]/Moment/id\"\n            },\n            \"User\": {\n                \"id@\": \"/Comment/userId\",\n                \"@column\": \"id,name\"\n            }\n        }\n    }\n}',NULL,NULL,'2018-12-15 12:57:16',NULL),(1546882253771,82001,0,1,'朋友圈 APP JOIN','JSON','/get','{\n    \"[]\": {\n        \"count\": 5,\n        \"page\": 0,\n        \"join\": \"@/User/id@\",\n        \"Moment\": {\n            \"@order\": \"date+\"\n        },\n        \"User\": {\n            \"id@\": \"/Moment/userId\",\n            \"@column\": \"id,name,head\"\n        },\n        \"User[]\": {\n            \"count\": 10,\n            \"User\": {\n                \"id{}@\": \"[]/Moment/praiseUserIdList\",\n                \"@column\": \"id,name\"\n            }\n        },\n        \"[]\": {\n            \"count\": 6,\n            \"join\": \"@/User/id@\",\n            \"Comment\": {\n                \"@order\": \"date+\",\n                \"momentId@\": \"[]/Moment/id\"\n            },\n            \"User\": {\n                \"id@\": \"/Comment/userId\",\n                \"@column\": \"id,name\"\n            }\n        }\n    }\n}',NULL,NULL,'2018-12-15 12:57:33',NULL),(1546901518765,82001,0,2,'功能符(对象关键词): ⑤从pictureList获取第0张图片：','JSON','/get','{     \"User\": {         \"id\": 38710,         \"@position\": 0,         \"firstPicture()\": \"getFromArray(pictureList,@position)\"     } }',NULL,NULL,'2018-03-24 14:25:18',NULL),(1546902069871,82001,0,2,'功能符(数组关键词): ②查询第3页的User数组，每页5个','JSON','/get','{\"[]\":{\"count\":5,\"page\":3,\"User\":{}}}',NULL,NULL,'2018-03-24 14:34:29',NULL),(1546902110680,82001,0,2,'功能符(数组关键词): ①查询User数组，最多5个','JSON','/get','{\"[]\":{\"count\":5,\"User\":{}}}',NULL,NULL,'2018-03-24 14:35:10',NULL),(1546903761689,82001,0,2,'功能符(逻辑运算): ③ ! 非运算','JSON','/head','{\"User\":{\"id!{}\":[82001,38710]}}',NULL,NULL,'2018-03-24 15:02:41',NULL),(1546903828410,82001,0,2,'功能符(逻辑运算): ② | 或运算','JSON','/head','{\"User\":{\"id|{}\":\">90000,<=80000\"}}',NULL,NULL,'2018-03-24 15:03:48',NULL),(1546903882830,82001,0,2,'功能符(逻辑运算): ① & 与运算','JSON','/head','{\"User\":{\"id&{}\":\">80000,<=90000\"}}',NULL,NULL,'2018-03-24 15:04:42',NULL),(1546904098111,82001,82001,2,'功能符: 减少 或 去除','JSON','/put/balance','{\n    \n    \"Privacy\": {\n        \"id\": 82001,\n        \"balance+\": -100,\n        \"_payPassword\": \"123456\"\n    },\"tag\": \"Privacy\"\n}',NULL,NULL,'2018-03-24 15:08:18',NULL),(1546904162066,82001,82001,2,'功能符: 增加 或 扩展','JSON','/put','{\n    \"Moment\": {\n        \"id\": 15,\n        \"praiseUserIdList+\": [\n            82001\n        ]\n    },\n    \"tag\": \"Moment\"\n}',NULL,NULL,'2018-03-24 15:09:22',NULL),(1546904337054,82001,0,2,'功能符: 新建别名','JSON','/get','{\"Comment\":{\"@column\":\"id,toId:parentId\",\"id\":51}}',NULL,NULL,'2018-03-24 15:12:17',NULL),(1546904394042,82001,0,2,'功能符: 正则匹配','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{\"name~\":\"^[0-9]+$\"}}}',NULL,NULL,'2018-03-24 15:13:14',NULL),(1546904437584,82001,0,2,'功能符: 模糊搜索','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{\"name$\":\"%m%\"}}}',NULL,NULL,'2018-03-24 15:13:57',NULL),(1546904547992,82001,0,2,'功能符: 引用赋值','JSON','/get','{\"Moment\":{\n   \"userId\":38710\n},\n\"User\":{\n   \"id@\":\"/Moment/userId\"\n}}',NULL,NULL,'2018-03-24 15:15:47',NULL),(1546904617127,82001,0,2,'功能符: 远程调用函数','JSON','/get','{     \"Moment\": {         \"id\": 301,         \"@column\": \"userId,praiseUserIdList\",         \"isPraised()\": \"isContain(praiseUserIdList,userId)\"     } }',NULL,NULL,'2018-03-24 15:16:57',NULL),(1546904653622,82001,0,2,'功能符: 包含选项范围','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{\"contactIdList<>\":38710}}}',NULL,NULL,'2018-03-24 15:17:33',NULL),(1546904698935,82001,0,2,'功能符: 匹配条件范围','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{\"id{}\":\"<=80000,>90000\"}}}',NULL,NULL,'2018-03-24 15:18:18',NULL),(1546904756674,82001,0,2,'功能符: 查询数组','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{}}}',NULL,NULL,'2018-03-24 15:19:16',NULL),(1546907333046,82001,0,1,'获取粉丝的动态列表','JSON','/get','{     \"Moment[]\": {         \"join\": \"&/User/id@\",         \"Moment\": {},         \"User\": {             \"id@\": \"/Moment/userId\",             \"contactIdList<>\": 82001,             \"@column\": \"id\"         }     } }',NULL,NULL,'2018-03-24 16:03:13',NULL),(1547401498195,88888,0,1,'子查询FROM和IN','JSON','/get','{\r     \"sql@\": {\r         \"from\": \"Comment\",\r         \"Comment\": {\r             \"momentId\": 12,\r             \"@column\": \"userId\",\r             \"@group\": \"userId\"\r         }\r     },\r     \"Comment-userId[]\": {\r         \"Comment\": {\r             \"@from@\": \"sql\"\r         }\r     },\r     \"[]\": {\r         \"User\": {\r             \"id{}@\": \"sql\",\r             \"sex\": 1,\r             \"@column\": \"id,sex,name\"\r         }\r     }\r }',NULL,NULL,'2019-01-13 17:44:58',NULL),(1548728831507,82001,82001,3,'get test','JSON','/get','{\n    \"User\": {\n        \"id\": 82001\n    },\n    \"[]\": {\n        \"Comment\": {\n            \"userId@\": \"User/id\"\n        }\n    }\n}',NULL,NULL,'2019-01-29 02:27:11',NULL),(1556385621907,82001,0,1,'子查询 WHERE id IN(SELECT userId FROM Comment WHERE momentId=15)','JSON','/get','{\n    \"subquery@\": {\n        \"from\": \"Comment\",\n        \"Comment\": {\n            \"momentId\": 15,\n            \"@column\": \"userId\"\n        }\n    },\n    \"User[]\": {\n        \"User\": {\n            \"id{}@\": \"subquery\",\n            \"@column\": \"id,sex,name\"\n        }\n    },\n    \"[]\": null\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"[]\": {\n                \"notnull\": false,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"User\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"id{}@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"object\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            {\n                                                \"from\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 3,\n                                                    \"values\": [],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        7\n                                                    ]\n                                                },\n                                                \"Comment\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"object\",\n                                                    \"valueLevel\": 0,\n                                                    \"values\": [\n                                                        {\n                                                            \"momentId\": {\n                                                                \"notnull\": true,\n                                                                \"type\": \"integer\",\n                                                                \"valueLevel\": 0,\n                                                                \"values\": [\n                                                                    15\n                                                                ],\n                                                                \"lengthLevel\": 1,\n                                                                \"lengths\": []\n                                                            },\n                                                            \"@column\": {\n                                                                \"notnull\": true,\n                                                                \"type\": \"string\",\n                                                                \"valueLevel\": 3,\n                                                                \"values\": [],\n                                                                \"lengthLevel\": 1,\n                                                                \"lengths\": [\n                                                                    6\n                                                                ]\n                                                            }\n                                                        }\n                                                    ]\n                                                }\n                                            }\n                                        ]\n                                    },\n                                    \"@column\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            11\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"subquery@\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"from\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                7\n                            ]\n                        },\n                        \"Comment\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"momentId\": {\n                                        \"notnull\": true,\n                                        \"type\": \"integer\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            15\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": []\n                                    },\n                                    \"@column\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            6\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"User[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"User\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"id{}@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            8\n                                        ]\n                                    },\n                                    \"@column\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            11\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2018-02-24 14:28:18',NULL),(1556385621908,88888,0,1,'子查询 WHERE id IN(SELECT userId FROM Comment WHERE momentId=15)','JSON','/get','{\n    \"subquery@\": {\n        \"from\": \"Comment\",\n        \"Comment\": {\n            \"momentId\": 15,\n            \"@column\": \"userId\"\n        }\n    },\n    \"[]\": {\n        \"User\": {\n            \"id{}@\": \"subquery\",\n            \"@column\": \"id,sex,name\"\n        }\n    }\n}',NULL,NULL,'2018-02-24 14:28:18',NULL),(1556385677607,82001,0,1,'子查询 WHERE EXISTS(SELECT userId FROM Comment WHERE momentId=15)','JSON','/get','{\n    \"subquery@\": {\n        \"from\": \"Comment\",\n        \"Comment\": {\n            \"momentId\": 15,\n            \"@column\": \"userId\"\n        }\n    },\n    \"[]\": {\n        \"User\": {\n            \"id}{@\": \"subquery\",\n            \"@column\": \"id,sex,name\"\n        }\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"User\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"id}{@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [\n                                            {\n                                                \"from\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 3,\n                                                    \"values\": [],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        7\n                                                    ]\n                                                },\n                                                \"Comment\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"object\",\n                                                    \"valueLevel\": 0,\n                                                    \"values\": [\n                                                        {\n                                                            \"momentId\": {\n                                                                \"notnull\": true,\n                                                                \"type\": \"integer\",\n                                                                \"valueLevel\": 0,\n                                                                \"values\": [\n                                                                    15\n                                                                ],\n                                                                \"lengthLevel\": 1,\n                                                                \"lengths\": []\n                                                            },\n                                                            \"@column\": {\n                                                                \"notnull\": true,\n                                                                \"type\": \"string\",\n                                                                \"valueLevel\": 3,\n                                                                \"values\": [],\n                                                                \"lengthLevel\": 1,\n                                                                \"lengths\": [\n                                                                    6\n                                                                ]\n                                                            }\n                                                        }\n                                                    ]\n                                                }\n                                            }\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            8\n                                        ]\n                                    },\n                                    \"@column\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            11\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"subquery@\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"from\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                7\n                            ]\n                        },\n                        \"Comment\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"momentId\": {\n                                        \"notnull\": true,\n                                        \"type\": \"integer\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            15\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": []\n                                    },\n                                    \"@column\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            6\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2018-02-24 14:28:18',NULL),(1556385677608,88888,0,1,'子查询 WHERE EXISTS(SELECT userId FROM Comment WHERE momentId=15)','JSON','/get','{\n    \"subquery@\": {\n        \"from\": \"Comment\",\n        \"Comment\": {\n            \"momentId\": 15,\n            \"@column\": \"userId\"\n        }\n    },\n    \"[]\": {\n        \"User\": {\n            \"id}{@\": \"subquery\",\n            \"@column\": \"id,sex,name\"\n        }\n    }\n}',NULL,NULL,'2018-02-24 14:28:18',NULL),(1558944411696,82001,82001,3,'关联查询 Comment.userId = User.id','JSON','/get','{\n    \"User\": {\n        \"id\": 82001\n    },\n    \"[]\": {\n        \"Comment\": {\n            \"userId@\": \"User/id\"\n        }\n    }\n}',NULL,NULL,'2019-05-27 08:06:51',NULL),(1559995734352,82001,0,3,'get 自定义关键词和远程函数的应用','JSON','/get','{\n    \"User\": {\n        \"id\": 82001,\n        \"@column\": \"contactIdList\",\n        \"@value\": 82006,\n        \"isContect()\": \"isContain(contactIdList,@value)\"\n    }\n}\n/*\n1、获取User表中的id==82001的数据块；\n2、获取contactIdList列中的数据；\n3、设定自定义关键词和值\"@value\": 82006；\n4、调用远程函数isContain判断 contactIdList 中是否存在值为82006的id；\n5、判断结果看 isContect的值。\n*/',NULL,NULL,'2019-06-08 12:08:54',NULL),(1560075285563,82001,0,3,'Comment JOIN User','JSON','/get','{\n    \"[]\": {\n        \"join\": \"</User/id@\",\n        \"Comment\": {\n            \"@order\": \"date-\"\n        },\n        \"User\": {\n            \"id@\": \"/Comment/userId\"\n        }\n    }\n}',NULL,NULL,'2019-06-09 10:14:45',NULL),(1560244940013,82001,82001,3,'测试查询','JSON','/get','{\n    \"User\": {\n        \"id\": 82001\n    },\n    \"[]\": {\n        \"Comment\": {\n            \"userId@\": \"User/id\"\n        }\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"User\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"id\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 1,\n                            \"values\": [\n                                82001\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        }\n                    }\n                ]\n            },\n            \"[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"Comment\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"userId@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            7\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2019-06-11 09:22:20','\n## 测试查询\n2021-10-23 16:13  Tommy\n用户表 User 和评论表 Comment 一对多关联查询，其中\nComment.userId = User.id\n\n### Response\ncode: 状态码：200-成功；其它-失败\nmsg: 状态信息：成功时为 success；失败是为具体报错\n\n![](http://apijson.cn/api/img/logo.png)\nhttps://github.com/Tencent/APIJSON'),(1560737118846,82001,82001,3,'get User','JSON','/get','{\n    \"User\": {\n        \"id\": 82002\n    }\n}',NULL,NULL,'2019-06-17 02:05:18',NULL),(1563115049174,88888,0,3,'去重 DISTINCT','JSON','/get','{\n    \"[]\": {\n        \"Comment\": {\n            \"@column\": \"DISTINCT momentId;count(DISTINCT userId)\",\n            \"@group\": \"momentId\"\n        }\n    },\n    \"@explain\": true\n}',NULL,NULL,'2018-03-20 14:25:18',NULL),(1563120735968,82001,0,3,'去重 DISTINCT','JSON','/get','{\n    \"[]\": {\n        \"Comment\": {\n            \"@column\": \"DISTINCT momentId;count(DISTINCT userId)\",\n            \"@group\": \"momentId\"\n        }\n    },\n    \"@explain\": true\n}',NULL,NULL,'2018-03-20 14:25:18',NULL),(1563983388528,82001,0,3,'热更新 权限控制、请求校验、远程函数 等配置','JSON','/reload','{\n    \"type\": \"REQUEST\", // ALL-全部, ACCESS-权限, REQUEST-请求校验, FUNCTION-远程函数\n    \"phone\": \"13000082001\",\n    \"verify\": \"1234\" //验证码，调用 /post/verify ，type:4 获取\n}',NULL,NULL,'2019-07-24 15:49:48',NULL),(1563983969937,88888,0,3,'热更新 权限控制、请求校验、远程函数 等配置','JSON','/reload','{\n    \"type\": \"REQUEST\", // ALL-全部, ACCESS-权限, REQUEST-请求校验, FUNCTION-远程函数\n    \"phone\": \"13000082001\",\n    \"verify\": \"1234\" //验证码，调用 /post/verify ，type:4 获取\n}',NULL,NULL,'2019-07-24 15:59:29',NULL),(1564388238598,1564369325432,82001,3,'测试上传','JSON','/get','{\n    \"User\": {\n        \"id\": 82001\n    },\n    \"[]\": {\n        \"Comment\": {\n            \"userId@\": \"User/id\"\n        }\n    }\n}',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634765,1564369325432,82001,1,'登录','JSON','/login','{\r     \"type\": 0, //密码类型，0-登录密码  1-验证码\r     \"phone\": \"13000082001\",  //手机号\r     \"password\": \"123456\",  //登录密码或验证码\r     \"version\": 1,  //版本号\r     \"remember\": false  //记住登录\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634766,1564369325432,0,1,'注册(先获取验证码type:1)','JSON','/register','{\r     \"Privacy\": {\r         \"phone\": \"13000083333\",\r         \"_password\": \"123456\"\r     },\r     \"User\": {\r         \"name\": \"APIJSONUser\"\r     },\r     \"verify\": \"6840\" //验证码，需要先调用接口 /post/verify\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634841,82001,0,2,'视图表 ViewTable 查单条记录 /get','JSON','/get','{\n    \"ViewTable\": {\"id\": 82001}\n}\n                                                                                                                                                                                                              \n',NULL,'','2019-07-29 08:43:18',NULL),(1564483634842,82001,0,2,'视图表 ViewTable 查列表带条件','JSON','/get','{\n    \"ViewTable[]\": {\n        \"ViewTable\": {\n            \"toId\": 0,\n            \"content~\": \"a\"\n        }\n    }\n}\n                                                                                                                                                                                                              \n',NULL,'','2019-07-29 08:43:18',NULL),(1564483634843,82001,0,2,'视图表 ViewTable INNER JOIN Moment','JSON','/get','{\n    \"[]\": {\n        \"join\": \"&/Moment/id@\",\n        \"ViewTable\": {\"toId\":0},\n        \"Moment\": {\"content~\":\"a\",\n            \"id@\": \"/ViewTable/momentId\"\n        }\n    }\n}\n                                                                                                                                                                                                              \n',NULL,'','2019-07-29 08:43:18',NULL),(1564483634844,82001,0,2,'视图表 ViewTable 子查询','JSON','/get','{\n    \"ViewTable[]\": {\n        \"ViewTable\": {\n            \"momentId{}@\": {\n                \"from\": \"Moment\",\n                \"Moment\": {\n                    \"@column\": \"id\"\n                }\n            }\n        }\n    }\n}\n                                                                                                                                                                                                              \n',NULL,'','2019-07-29 08:43:18',NULL),(1564483634845,82001,0,2,'视图表 ViewTable LEFT JOIN Moment','JSON','/get','{\n    \"[]\": {\n        \"join\": \"</Moment/id@\",\n        \"ViewTable\": {},\n        \"Moment\": {\n            \"id@\": \"/ViewTable/momentId\"\n        }\n    }\n}\n                                                                                                                                                                                                              \n',NULL,'','2019-07-29 08:43:18',NULL),(1564483634846,82001,0,2,'全局关键词','JSON','/get','{\n    \"[]\": {\n        \"count\": 3,\n        \"Moment\": {},\n      \n        \"User\": {\n            \"id@\": \"/Moment/userId\",\n            \"@column\": \"id,name,head\"\n        },\n        \"[]\": {\n            \"count\": 6,\n            \"Comment\": {\n                \"momentId@\": \"[]/Moment/id\"\n            },\n            \"User\": {\n                \"id@\": \"/Comment/userId\",\n                \"@column\": \"id,name\"\n            }\n        }\n    },\n    \"format\": false,\n    \"tag\": \"Moment[]\",\n    \"version\": 0,\n    \"@role\": \"CIRCLE\",\n    \"@database\": \"MYSQL\",\n    \"@schema\": \"sys\",\n    \"@explain\": true,\n    \"@cache\": 0\n}\n                                                                                                                                                                                                              \n',NULL,'','2019-07-29 08:43:18',NULL),(1564483634853,1564369325432,0,1,'退出登录','JSON','/logout','{}',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634854,1564369325432,0,1,'获取用户隐私信息','JSON','/gets','{\"tag\": \"Privacy\", \"Privacy\": {\"id\": 82001}}',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634855,1564369325432,0,1,'获取验证码','JSON','/post/verify','{\r     \"type\": 0,  //类型: 0-登录 1-注册 2-修改登录密码 3-修改支付密码\r     \"phone\": \"13000082001\"  //手机号\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634856,1564369325432,0,1,'检查验证码是否存在','JSON','/heads/verify','{\r     \"type\": 0,  //类型: 0-登录 1-注册 2-修改登录密码 3-修改支付密码\r     \"phone\": \"13000082001\"  //手机号\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634857,1564369325432,82001,1,'修改登录密码(先获取验证码type:2)-手机号+验证码','JSON','/put/password','{\r     \"verify\": \"10322\",  //验证码，需要先调用接口 /post/verify\r     \"Privacy\": {\r         \"phone\": \"13000082001\",\r         \"_password\": \"666666\"\r     }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634858,1564369325432,82001,1,'充值(需要支付密码)/提现','JSON','/put/balance','{\"tag\": \"Privacy\", \"Privacy\": {\"id\": 82001, \"balance+\": 100.15, \"_payPassword\": \"123456\"}}',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634859,1564369325432,82001,1,'点赞/取消点赞','JSON','/put','{\r     \"Moment\": {\r         \"id\": 15,\r         \"praiseUserIdList-\": [\r             82001\r         ]\r     },\r     \"tag\": \"Moment\"\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634860,1564369325432,82001,1,'新增评论','JSON','/post','{     \"Comment\": {         \"momentId\": 15,         \"content\": \"测试新增评论\"     },     \"tag\": \"Comment\" }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634861,1564369325432,82001,1,'新增动态','JSON','/post','{     \"Moment\": {         \"content\": \"测试新增动态\",         \"pictureList\": [\"http://static.oschina.net/uploads/user/48/96331_50.jpg\"         ]     },     \"tag\": \"Moment\" }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634862,1564369325432,82001,1,'修改用户信息','JSON','/put','{\r     \"User\": {\r         \"id\": 82001,\r         \"name\": \"测试账号\"\r     },\r     \"tag\": \"User\"\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634863,1564369325432,82002,3,'微信个人资料-用户信息+最近3个有照片的动态的第0张照片','JSON','/get','{\r     \"User\": {\r         \"id\": 82002\r     },\r     \"Moment-firstPicture[]\": {\r         \"count\": 3,\r         \"Moment\": {\r             \"userId@\": \"User/id\",\r             \"@column\": \"userId,pictureList\",\r             \"@having\": \"json_length(pictureList)>0\",...',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634864,1564369325432,0,2,'操作方法(DELETE):  删除数据','JSON','/delete','{\r    \"Moment\":{\r      \"id\":120\r    },\r    \"tag\":\"Moment\"\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634865,1564369325432,0,2,'操作方法(PUT):  修改数据，只修改所传的字段','JSON','/put','{\r    \"Moment\":{\r      \"id\":235,\r      \"content\":\"APIJSON,let interfaces and documents go to hell !\"\r    },\r    \"tag\":\"Moment\"\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634866,1564369325432,0,2,'操作方法(POST):  新增数据','JSON','/post','{     \"Moment\": {          \"content\": \"APIJSON,let interfaces and documents go to hell !\"     },     \"tag\": \"Moment\" }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634867,1564369325432,0,2,'操作方法(HEADS):  安全/私密获取数量，用于获取银行卡数量等 对安全性要求高的数据总数','JSON','/heads','{\r     \"Login\": {\r         \"userId\": 38710,\"type\":1\r     },\r     \"tag\": \"Login\"\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634868,1564369325432,0,2,'操作方法(GETS):  安全/私密获取数据，用于获取钱包等 对安全性要求高的数据','JSON','/gets','{\r     \"Privacy\": {\r         \"id\": 82001\r     },\r     \"tag\": \"Privacy\"\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634869,1564369325432,0,2,'操作方法(HEAD):  普通获取数量，可用浏览器调试','JSON','/head','{\r    \"Moment\":{\r      \"userId\":38710\r    }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634870,1564369325432,0,2,'操作方法(GET):  普通获取数据，可用浏览器调试','JSON','/get','{\r    \"Moment\":{\r      \"id\":235\r    }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634871,1564369325432,82001,3,'获取类似微信朋友圈的动态列表','JSON','/get','{\r     \"[]\": {\r         \"page\": 0,\r         \"count\": 2,\r         \"Moment\": {\r             \"content$\": \"%a%\"\r         },\r         \"User\": {\r             \"id@\": \"/Moment/userId\",\r             \"@column\": \"id,name,head\"\r         },\r         \"Comment[]\": {\r             \"...',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634872,1564369325432,82001,3,'获取动态及发布者用户','JSON','/get','{\r     \"Moment\": {},\r     \"User\": {\r         \"id@\": \"Moment/userId\"\r     }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634873,1564369325432,82001,3,'获取用户列表','JSON','/get','{\r     \"[]\": {\r         \"count\": 3,\r         \"User\": {\r             \"@column\": \"id,name\"\r         }\r     }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634874,1564369325432,82001,3,'获取用户','JSON','/get','{\r   \"User\":{\r   }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634875,1564369325432,82001,1,'子查询 WHERE id IN(SELECT userId FROM Comment WHERE momentId=15)','JSON','/get','{\r     \"[]\": {\r         \"User\": {\r             \"id{}@\": {\r                 \"from\": \"Comment\",\r                 \"Comment\": {\r                     \"momentId\": 15,\r                     \"@column\": \"userId\"\r                 }\r             },\r             \"@column\": \"id...',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634876,1564369325432,82001,1,'子查询 WHERE EXISTS(SELECT userId FROM Comment WHERE momentId=15)','JSON','/get','{\r     \"[]\": {\r         \"User\": {\r             \"id}{@\": {\r                 \"from\": \"Comment\",\r                 \"Comment\": {\r                     \"momentId\": 15,\r                     \"@column\": \"userId\"\r                 }\r             },\r             \"@column\": \"id...',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634877,1564369325432,82001,1,'子查询 WHERE id=(SELECT min(userId) FROM Comment)','JSON','/get','{\r     \"User\": {\r         \"id@\": {\r             \"from\": \"Comment\",\r             \"Comment\": {\r                 \"@column\": \"min(userId)\"\r             }\r         }\r     }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634878,1564369325432,82001,1,'存储过程','JSON','/get','{\r     \"User\": {\r         \"@limit\": 10,\r         \"@offset\": 0,\r         \"@procedure()\": \"getCommentByUserId(id,@limit,@offset)\"\r     }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634879,1564369325432,0,1,'Moment INNER JOIN User LEFT JOIN Comment','JSON','/get','{\r     \"[]\": {\r         \"count\": 10,\r         \"page\": 0,\r         \"join\": \"&/User/id@,</Comment/momentId@\",\r         \"Moment\": {\r             \"@order\": \"date+\"\r         },\r         \"User\": {\r             \"name~\": [\r                 \"a\",\r                 \"t\"\r        ...',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634880,1564369325432,0,1,'Moment LEFT JOIN User','JSON','/get','{\r     \"[]\": {\r         \"join\": \"</User/id@\",\r         \"Moment\": {\r             \"@column\": \"id,userId,content\"\r         },\r         \"User\": {\r             \"@column\": \"id,name\",\r             \"id@\": \"/Moment/userId\"\r         }\r     }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634881,1564369325432,0,1,'Comment LEFT JOIN User','JSON','/get','{\r     \"[]\": {\r         \"join\": \"</User/id@\",\r         \"Comment\": {\r             \"@column\": \"id,userId,content\",\"@order\":\"date-\"\r         },\r         \"User\": {\r             \"@column\": \"id,name\",\r             \"id@\": \"/Comment/userId\"\r         }\r     }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634882,1564369325432,0,1,'Moment INNER JOIN User','JSON','/get','{\r     \"[]\": {\r         \"join\": \"&/User/id@\",\r         \"Moment\": {\r             \"@column\": \"id,userId,content\"\r         },\r         \"User\": {\"name~\":[\"a\",\"t\"],\r             \"@column\": \"id,name\",\r             \"id@\": \"/Moment/userId\"\r         }\r     }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634883,1564369325432,0,1,'Comment INNER JOIN User','JSON','/get','{\r     \"[]\": {\r         \"join\": \"&/User/id@\",\r         \"Comment\": {\r             \"content~\": \"a\",\r             \"@order\": \"date-\"\r         },\r         \"User\": {\r             \"name~\": [\r                 \"a\",\r                 \"t\"\r             ],\r             \"@column\":...',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634884,1564369325432,0,1,'Moment APP JOIN User','JSON','/get','{\r     \"[]\": {\r         \"join\": \"@/User/id@\",\r         \"Moment\": {\r             \"@column\": \"id,userId,content\"\r         },\r         \"User\": {\r             \"@column\": \"id,name\",\r             \"id@\": \"/Moment/userId\"\r         }\r     }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634885,1564369325432,0,1,'Comment APP JOIN User','JSON','/get','{\r     \"[]\": {\r         \"join\": \"@/User/id@\",\r         \"Comment\": {\r             \"content~\": \"a\",\r             \"@order\": \"date-\"\r         },\r         \"User\": {\r             \"name~\": [\r                 \"a\",\r                 \"t\"\r             ],\r             \"@column\":...',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634886,1564369325432,0,1,'朋友圈 LEFT JOIN','JSON','/get','{\r     \"[]\": {\r         \"count\": 5,\r         \"page\": 0,\r         \"join\": \"</User/id@\",\r         \"Moment\": {\r             \"@order\": \"date+\"\r         },\r         \"User\": {\r             \"id@\": \"/Moment/userId\",\r             \"@column\": \"id,name,head\"\r         },\r       ...',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634887,1564369325432,0,1,'朋友圈 APP JOIN','JSON','/get','{\r     \"[]\": {\r         \"count\": 5,\r         \"page\": 0,\r         \"join\": \"@/User/id@\",\r         \"Moment\": {\r             \"@order\": \"date+\"\r         },\r         \"User\": {\r             \"id@\": \"/Moment/userId\",\r             \"@column\": \"id,name,head\"\r         },\r       ...',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634888,1564369325432,0,2,'功能符(对象关键词): ⑤从pictureList获取第0张图片：','JSON','/get','{     \"User\": {         \"id\": 38710,         \"@position\": 0,         \"firstPicture()\": \"getFromArray(pictureList,@position)\"     } }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634889,1564369325432,0,2,'功能符(数组关键词): ②查询第3页的User数组，每页5个','JSON','/get','{\"[]\":{\"count\":5,\"page\":3,\"User\":{}}}',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634890,1564369325432,0,2,'功能符(数组关键词): ①查询User数组，最多5个','JSON','/get','{\"[]\":{\"count\":5,\"User\":{}}}',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634891,1564369325432,0,2,'功能符(逻辑运算): ③ ! 非运算','JSON','/head','{\"User\":{\"id!{}\":[82001,38710]}}',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634892,1564369325432,0,2,'功能符(逻辑运算): ② | 或运算','JSON','/head','{\"User\":{\"id|{}\":\">90000,<=80000\"}}',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634893,1564369325432,0,2,'功能符(逻辑运算): ① & 与运算','JSON','/head','{\"User\":{\"id&{}\":\">80000,<=90000\"}}',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634894,1564369325432,82001,2,'功能符: 减少 或 去除','JSON','/put/balance','{\r     \r     \"Privacy\": {\r         \"id\": 82001,\r         \"balance+\": -100,\r         \"_payPassword\": \"123456\"\r     },\"tag\": \"Privacy\"\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634895,1564369325432,82001,2,'功能符: 增加 或 扩展','JSON','/put','{\r     \"Moment\": {\r         \"id\": 15,\r         \"praiseUserIdList+\": [\r             82001\r         ]\r     },\r     \"tag\": \"Moment\"\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634896,1564369325432,0,2,'功能符: 新建别名','JSON','/get','{\"Comment\":{\"@column\":\"id,toId:parentId\",\"id\":51}}',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634897,1564369325432,0,2,'功能符: 正则匹配','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{\"name~\":\"^[0-9]+$\"}}}',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634898,1564369325432,0,2,'功能符: 模糊搜索','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{\"name$\":\"%m%\"}}}',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634899,1564369325432,0,2,'功能符: 引用赋值','JSON','/get','{\"Moment\":{\r    \"userId\":38710\r },\r \"User\":{\r    \"id@\":\"/Moment/userId\"\r }}',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634900,1564369325432,0,2,'功能符: 远程调用函数','JSON','/get','{     \"Moment\": {         \"id\": 301,         \"@column\": \"userId,praiseUserIdList\",         \"isPraised()\": \"isContain(praiseUserIdList,userId)\"     } }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634901,1564369325432,0,2,'功能符: 包含选项范围','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{\"contactIdList<>\":38710}}}',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634902,1564369325432,0,2,'功能符: 匹配条件范围','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{\"id{}\":\"<=80000,>90000\"}}}',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634903,1564369325432,0,2,'功能符: 查询数组','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{}}}',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634904,1564369325432,0,1,'获取粉丝的动态列表','JSON','/get','{     \"Moment[]\": {         \"join\": \"&/User/id@\",         \"Moment\": {},         \"User\": {             \"id@\": \"/Moment/userId\",             \"contactIdList<>\": 82001,             \"@column\": \"id\"         }     } }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634905,1564369325432,82001,3,'get test','JSON','/get','{\r     \"User\": {\r         \"id\": 82001\r     },\r     \"[]\": {\r         \"Comment\": {\r             \"userId@\": \"User/id\"\r         }\r     }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634906,1564369325432,0,1,'子查询 WHERE id IN(SELECT userId FROM Comment WHERE momentId=15)','JSON','/get','{\r     \"subquery@\": {\r         \"from\": \"Comment\",\r         \"Comment\": {\r             \"momentId\": 15,\r             \"@column\": \"userId\"\r         }\r     },\r     \"[]\": {\r         \"User\": {\r             \"id{}@\": \"subquery\",\r             \"@column\": \"id,sex,name\"\r         ...',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634907,1564369325432,0,1,'子查询 WHERE EXISTS(SELECT userId FROM Comment WHERE momentId=15)','JSON','/get','{\r     \"subquery@\": {\r         \"from\": \"Comment\",\r         \"Comment\": {\r             \"momentId\": 15,\r             \"@column\": \"userId\"\r         }\r     },\r     \"[]\": {\r         \"User\": {\r             \"id}{@\": \"subquery\",\r             \"@column\": \"id,sex,name\"\r         ...',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634908,1564369325432,82001,3,'关联查询 Comment.userId = User.id','JSON','/get','{\r     \"User\": {\r         \"id\": 82001\r     },\r     \"[]\": {\r         \"Comment\": {\r             \"userId@\": \"User/id\"\r         }\r     }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634909,1564369325432,0,3,'get 自定义关键词和远程函数的应用','JSON','/get','{\r     \"User\": {\r         \"id\": 82001,\r         \"@column\": \"contactIdList\",\r         \"@value\": 82006,\r         \"isContect()\": \"isContain(contactIdList,@value)\"\r     }\r }\r /*\r 1、获取User表中的id==82001的数据块；\r 2、获取contactIdList列中的数据...',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634910,1564369325432,0,3,'Comment JOIN User','JSON','/get','{\r     \"[]\": {\r         \"join\": \"</User/id@\",\r         \"Comment\": {\r             \"@order\": \"date-\"\r         },\r         \"User\": {\r             \"id@\": \"/Comment/userId\"\r         }\r     }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634911,1564369325432,82001,3,'测试查询','JSON','/get','{\r     \"User\": {\r         \"id\": 82001\r     },\r     \"[]\": {\r         \"Comment\": {\r             \"userId@\": \"User/id\"\r         }\r     }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634912,1564369325432,82001,3,'get User','JSON','/get','{\r     \"User\": {\r         \"id\": 82002\r     }\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634913,1564369325432,0,3,'去重 DISTINCT','JSON','/get','{\r     \"[]\": {\r         \"Comment\": {\r             \"@column\": \"DISTINCT momentId;count(DISTINCT userId)\",\r             \"@group\": \"momentId\"\r         }\r     },\r     \"@explain\": true\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634914,1564369325432,0,3,'热更新 权限控制、请求校验、远程函数 等配置','JSON','/reload','{\r     \"type\": \"REQUEST\", // ALL-全部, ACCESS-权限, REQUEST-请求校验, FUNCTION-远程函数\r     \"phone\": \"13000082001\",\r     \"verify\": \"1234\" //验证码，调用 /post/verify ，type:4 获取\r }',NULL,NULL,'2019-07-29 08:43:18',NULL),(1564483634915,82001,0,2,'功能符：连续范围','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{\"date%\":\"2017-10-01,2018-10-01\"}}}',NULL,'','2019-07-29 08:43:18',NULL),(1564483634916,82001,0,3,'获取用户名称列表','JSON','/get','{\n    \"User-name[]\": {\n        \"User\": {\n            \"@column\": \"name\"\n        }\n    }\n}\n                                                                                                                                                                                                              \n',NULL,'','2019-07-29 08:43:18',NULL),(1564907459034,82001,0,3,'请求头 Request Header','JSON','/get','{\n    \"User\": {\n        \"id\": 82001\n    },\n    \"[]\": {\n        \"Comment\": {\n            \"userId@\": \"User/id\"\n        }\n    }\n}',NULL,'Authorization: Basic GERIJ2438R9FH239NW=  //取出 /login 接口返回的 token\nOther-Header: test','2019-08-04 08:30:59',NULL),(1567927050590,88888,0,3,'test response hint','JSON','/get','{\n    \"[]\": {\n        \"count\": 5,\n        \"page\": 0,\n        \"Moment\": {\n            \"@order\": \"date+\"\n        },\n        \"User\": {\n            \"id@\": \"/Moment/userId\",\n            \"@column\": \"id,name,head\"\n        },\n        \"User[]\": {\n            \"count\": 10,\n            \"query\": 2,\n            \"User\": {\n                \"id{}@\": \"[]/Moment/praiseUserIdList\",\n                \"@column\": \"id,name\"\n            }\n        },\n        \"Comment-userId[]\": {\n            \"count\": 6,\n            \"query\": 2,\n            \"Comment\": {\n                \"@order\": \"date+\",\n                \"momentId@\": \"[]/Moment/id\"\n            }\n        },\n        \"praiseCount@\": \"/User[]/total\",\n        \"commentCount@\": \"/Comment-userId[]/total\"\n    }\n}',NULL,'','2019-09-08 07:17:30',NULL),(1572174664812,88888,0,3,'部分功能总览','JSON','/get','{\n    \"[]\": {\n        \"count\": 5,\n        \"page\": 0,\n        \"join\": \"</User/id@\",\n        \"Moment\": {\n            \"@order\": \"date+\",\n            \"@column\": \"id,userId;date_format(date,%Y-%m-%d %H:%m)\",\n            \"@explain\": true,\n            \"content~\": \"o\",\n            \"userId!\": 82001,\n            \"@combine\": \"userId!,content~\"\n        },\n        \"User\": {\n            \"id@\": \"/Moment/userId\",\n            \"@column\": \"id,name,head\"\n        },\n        \"[]\": {\n            \"count\": 6,\n            \"join\": \"@/User/id@\",\n            \"Comment\": {\n                \"@order\": \"date-\",\n                \"momentId@\": \"[]/Moment/id\"\n            },\n            \"User\": {\n                \"id@\": \"/Comment/userId\",\n                \"@column\": \"DISTINCT id,name;concat(%,name,%):concat\"\n            }\n        }\n    }\n}',NULL,'','2019-10-27 11:11:04',NULL),(1583173736243,88888,0,3,'批量修改-每项单独设置','JSON','/put','{\n    \"Comment[]\": [\n        {\n            \"id\": 1581271679641,\n            \"content\": \"test\"\n        },\n        {\n            \"id\": 1581314845034,\n            \"momentId\": 12,\n            \"date\": \"2020-02-02\"\n        }\n    ],\n    \"tag\": \"Comment:[]\"\n}',NULL,'','2020-03-02 18:28:56',NULL),(1583173841064,88888,0,3,'批量新增-每项单独设置','JSON','/post','{\n    \"Moment[]\": [\n        {\n            \"content\": \"测试新增动态\"\n        },\n        \n        {\n            \"pictureList\": [\n                \"http://abc.com/3.png\"\n            ]\n        },\n        {\n            \"content\": \"test\",\n            \"praiseUserIdList\": [\n                82002\n            ],\n            \"pictureList\": [\n                \"http://abc.com/2.png\"\n            ]\n        }\n    ],\n    \"tag\": \"Moment:[]\"\n}',NULL,'','2020-03-02 18:30:41',NULL),(1583415965740,99999,0,3,'where子查询中多表关联筛选','JSON','/get','{\n    \"User\": {\n        \"id@\": {\n            \"from\": \"Comment\",\n			 \"join\": \"&/Moment/id@\",\n            \"Comment\": {\n                \"@column\": \"min(userId)\"\n            },\n            \"Moment\": {\n                \"id@\": \"/Comment/momentId\",\n				  \"@column\":\"\"\n            }\n        }\n    },\n    \"@explain\": true\n}',NULL,'','2020-03-05 13:46:05',NULL),(1583510816154,99999,0,3,'复杂的子查询与关联查询','JSON','/get','{\n    \"sql@\": {\n        \"from\": \"Comment\",\n        \"join\": \"&/Comment:to/userId@\",\n        \"Comment\": {\n            \"@column\": \"userId\",\n            \"content~\": \"a\"\n        },\n        \"Comment:to\": {\n            \"userId@\": \"/Comment/userId\",\n            \"@column\": \"\",\n            \"content~\": \"j\"\n        }\n    },\n    \"[]\": {\n        \"Moment\": {\n            \"userId{}@\": {\n                \"from\": \"User\",\n                \"User\": {\n                    \"id{}@\": \"sql\",\n                    \"@column\": \"id\"\n                }\n            }\n        }\n    },\n    \"@explain\": true\n}',NULL,'','2020-03-06 16:06:56',NULL),(1583513151839,99999,0,3,'类似12306根据两站来查火车班次','JSON','/get','{   //类似 12306 根据始发站和到达站来过滤火车班次，班次和线路多对一，线路和站点多对多\n    \"sql@\": {\n        \"from\": \"Comment\",\n        \"join\": \"&/Comment:to/userId@\",\n        \"Comment\": {  //假装是始发站\n            \"@column\": \"userId\",\n            \"content~\": \"a\"   //假装是站点名\n        },\n        \"Comment:to\": {  //假装是终点站\n            \"userId@\": \"/Comment/userId\",\n            \"@column\": \"\",\n            \"content~\": \"j\"  //假装是站点名\n        }\n    },\n    \"[]\": {\n        \"Moment\": {  //假装是班次\n            \"userId{}@\": {\n                \"from\": \"User\",\n                \"User\": {  //假装是线路\n                    \"id{}@\": \"sql\",\n                    \"@column\": \"id\"\n                }\n            }\n        }\n    },\n    \"@explain\": true\n}',NULL,'','2020-03-06 16:45:51',NULL),(1584113823081,2000,0,3,'自连接返回数据错误','JSON','/get','{\n    \"[]\": {\n        \"join\": \"&/Comment:to/id@\",\n        \"Comment\": {},  //解决方案：加 \"@column\": \"id,toId\"\n        \"Comment:to\": {\n            \"id@\": \"/Comment/toId\",\n            \"id>\": 0\n        }\n    },\n    \"@explain\": true\n}\n/*\n 这是一个 3.3.0, 3.8.6-4.0.0 都发现存在的 bug，\n 事实上也是自从支持自连接（副表 Comment AS `to`）以来就存在。\n 原因是对副表生成的 SQL 里表名和主表表名一样，导致 \n AbstractSQLExecutor.onPutColumn 中 299 行\n item = onPutColumn(config, rs, rsmd, index, item, i, config.isExplain() == false && hasJoin && i >= viceColumnStart ? childMap : null);\n 488 行 if 走了第一个分支（应该走 else 来把副表的值存进 childMap）\n finalTable = table;\n 从而使 JOIN 查出来的主副表全部字段都在 521 行\n finalTable.put(lable, getValue(config, rs, rsmd, tablePosition, table, columnIndex, lable, childMap));\n 由于主副表有相同字段，导致后面 put 的副表字段替代了前面 put 的主表同名字段。\n \n 除了以上折中方案，还可以判断 AS 的副表别名来做区分，put 进 childMap。\n*/',NULL,'','2020-03-13 15:37:03',NULL),(1584117747580,2000,0,3,'全局默认字段失效','JSON','/login','{\n    \"type\": 0,\n    \"phone\": \"13000082001\",\n    \"password\": \"123456\",\n    \"version\": 1,\n    \"remember\": false,\n    \"format\": true,  //失效\n    \"defaults\": {  //失效\n        \"format\": true,\n        \"@explain\": true,\n        \"@database\": \"POSTGRESQL\",\n        \"@schema\": \"sys\"\n    }\n}',NULL,'','2020-03-13 16:42:27',NULL),(1584118278602,2000,0,3,'SIDE JOIN 实现可能有误','JSON','/get','{\n    \"[]\": {\n        \"join\": \"^/User/id@\",\n        \"Comment\": {\n            \"momentId\": 12\n        },\n        \"User\": {\n            \"id@\": \"/Comment/toId\",\n            \"sex\": 0\n        }\n    },\n    \"@explain\": true\n}\n/*\n SIDE JOIN 实现可能有误，并且性能不大好。\n Comment 的条件 A: momentId=12\n User 的条件 B: sex=0\n 理论上 NOT(A AND B) 等价于(A AND NOT B) OR (B AND NOT A) \n 目前使用的是后者，当我想要改成前者，分别用对应的 SQL 放数据库执行，\n 发现结果集不一样！\n SELECT `Comment`.*, `User`.* FROM `sys`.`Comment` AS `Comment` INNER JOIN `sys`.`apijson_user` AS `User` ON `User`.`id` = `Comment`.`toId` WHERE ( NOT ( `Comment`.`momentId` = 12 AND `User`.`sex` = 0 ) ) LIMIT 10 OFFSET 0\n SELECT `Comment`.*, `User`.* FROM `sys`.`Comment` AS `Comment` INNER JOIN `sys`.`apijson_user` AS `User` ON `User`.`id` = `Comment`.`toId` WHERE ( ( ( (`Comment`.`momentId` = 12) ) AND NOT ( ( (`User`.`sex` = 0) ) ) ) OR ( ( (`User`.`sex` = 0) ) AND NOT ( ( (`Comment`.`momentId` = 12) ) ) ) ) LIMIT 10 OFFSET 0\n*/',NULL,'','2020-03-13 16:51:18',NULL),(1584120971519,2020,0,3,'新增 WITH AS','JSON','/get','{   //看看关注的人最近有什么动态（分享、评论）\n    \"sql@\": {\n        \"with\": true,  //生成 WITH(SELECT id ...) AS `sql`\n        \"from\": \"User\",\n        \"User\": {\n            \"@column\": \"id\",\n            \"@role\": \"CONTACT\"\n        }\n    },\n    \"Moment[]\": {\n        \"Moment\": {\n            \"userId{}@\": \"sql\",\n            \"@order\": \"date-\"\n        }\n    },\n    \"Comment[]\": {\n        \"Comment\": {\n            \"userId{}@\": \"sql\",\n            \"@order\": \"date-\"\n        }\n    },\n    \"@explain\": true\n}',NULL,'','2020-03-13 17:36:11',NULL),(1584120990337,2020,0,3,'新增 UNION','JSON','/get','{\n    \"[]\": {\n        \"User\": {\n            \"name~\": \"a\",\n            \"tag~\": \"a\",\n            \"@combine\": \"name~,tag~\",    \n            \"@union\": 1  //将 @combine 中的 N 个 OR 连接字段用 UNION 替换，原本一条 SQL 需要拆分成 N 条 SQL 来 UNION \n        }\n    },\n    \"@explain\": true\n}',NULL,'','2020-03-13 17:36:30',NULL),(1584121026469,2020,0,3,'新增分布式执行','JSON','/get','{\n    \"User\": {\n        \"@url\": \"http://apijson.cn:8080/get\"  //转发给其它服务器执行\n    },\n    \"[]\": {\n        \"Comment\": {\n            \"userId@\": \"User/id\"\n        }\n    },\n    \"@explain\": true\n}',NULL,'','2020-03-13 17:37:06',NULL),(1589859330200,1589859275450,1589859275450,3,'login','JSON','/login','{\n    \"type\": 0,\n    \"phone\": \"13525569073\",\n    \"password\": \"123456\",\n    \"version\": 1,\n    \"remember\": false,\n    \"format\": false,\n    \"defaults\": {\n        \"@database\": \"MYSQL\",\n        \"@schema\": \"sys\"\n    }\n}',NULL,'','2020-05-19 03:35:30',NULL),(1592545943722,1592544818327,1592544225995,3,'login','JSON','/login','{\n    \"body\": {\n        \"personName\": \"杨家湖超限班长\",\n        \"Authenticated\": true,\n        \"UserName\": \"yjhcxbz\",\n        \"personMobile\": \"\",\n        \"iconList\": [\n            \"PTCL\"\n        ],\n        \"Token\": \"3dba223a3a9046f7abfffdddc9f93936\",\n        \"userOrgName\": \"杨家湖收费站\",\n        \"userId\": \"297edfab72c14e940172c1552d4b0002\",\n        \"userOrgId\": \"009429986\"\n    },\n    \"head\": {\n        \"clientId\": null,\n        \"ret\": {\n            \"retCode\": \"000000\",\n            \"retMsg\": null\n        },\n        \"timestamp\": \"2020-06-19 11:46:52\"\n    }\n}\n                                                                                                                                                                                                              \n',NULL,'','2020-06-19 05:52:23',NULL),(1592546007877,1592544818327,1592544225995,3,'login11','JSON','/login','{\n    \"body\": {\n        \"personName\": \"杨家湖超限班长\",\n        \"Authenticated\": true,\n        \"UserName\": \"yjhcxbz\",\n        \"personMobile\": \"\",\n        \"iconList\": [\n            \"PTCL\"\n        ],\n        \"Token\": \"3dba223a3a9046f7abfffdddc9f93936\",\n        \"userOrgName\": \"杨家湖收费站\",\n        \"userId\": \"297edfab72c14e940172c1552d4b0002\",\n        \"userOrgId\": \"009429986\"\n    },\n    \"head\": {\n        \"clientId\": null,\n        \"ret\": {\n            \"retCode\": \"000000\",\n            \"retMsg\": null\n        },\n        \"timestamp\": \"2020-06-19 11:46:52\"\n    }\n}\n                                                                                                                                                                                                              \n',NULL,'','2020-06-19 05:53:27',NULL),(1593973492312,1593972128383,0,3,'login1','JSON','/login','{\n    \"type\": 0,\n    \"phone\": \"13000082002\",\n    \"password\": \"123456\",\n    \"version\": 1,\n    \"remember\": false,\n    \"format\": false,\n    \"defaults\": {\n        \"@database\": \"MYSQL\",\n        \"@schema\": \"sys\"\n    }\n}',NULL,'','2020-07-05 18:24:52',NULL),(1593973606841,1593972128383,0,3,'get1','JSON','/get','{\n    \"User\": {\n        \"id\": 82001\n    },\n    \"[]\": {\n        \"Comment\": {\n            \"userId@\": \"User/id\"\n        }\n    }\n}\n                                                                                                                                                                                                              \n',NULL,'','2020-07-05 18:26:46',NULL),(1593973707836,1593972128383,0,3,'get1','JSON','/get','{\n    \"User\": {\n        \"id\": 82001\n    },\n    \"[]\": {//ooo\n        \"Comment\": {\n            \"userId@\": \"User/id\"\n        }\n    }\n}\n                                                                                                                                                                                                              \n',NULL,'','2020-07-05 18:28:27',NULL),(1596002514234,1596002416764,0,3,'get','JSON','/get','{\n    \"type\": 0,\n    \"phone\": \"13000082002\",\n    \"password\": \"123456\",\n    \"version\": 1,\n    \"remember\": false,\n    \"format\": false,\n    \"defaults\": {\n        \"@database\": \"MYSQL\",\n        \"@schema\": \"sys\"\n    }\n}\n                                                                                                                                                                                                              \n',NULL,'','2020-07-29 06:01:54',NULL),(1596439230051,1596439187212,0,3,'login','JSON','/login','{\n    \"type\": 0,\n    \"phone\": \"13000082002\",\n    \"password\": \"123456\",\n    \"version\": 1,\n    \"remember\": false,\n    \"format\": false,\n    \"defaults\": {\n        \"@database\": \"MYSQL\",\n        \"@schema\": \"sys\"\n    }\n}',NULL,'','2020-08-03 07:20:30',NULL),(1602231365650,2020,0,3,'JOIN 对象支持包含多个 @ 引用赋值 的字段','JSON','/get','{   // 自动合并  ON Method.class = `Method:group`.class AND Method.package = `Method:group`.package\n    \"Method[]\": {\n        \"count\": 0,\n        \"join\": \"@/Method/class@,@/Method/package@\",\n        \"Method:group\": {\n            \"@column\": \"DISTINCT class\",\n            \"@order\": \"class+\",\n            \"@having\": \"length(class)>0\",\n            \"package*~\": null,\n            \"class*~\": null,\n            \"@combine\": null\n        },\n        \"Method\": {\n            \"package@\": \"[]/Method/package\",\n            \"class@\": \"/Method:group/class\",\n            \"@column\": \"class,genericClassArgs\",\n            \"@order\": \"class+\",\n            \"arguments()\": \"getMethodArguments(genericClassArgs)\"\n        }\n    }\n}\n                                                                                                                                                                                                              \n',NULL,'','2020-10-09 08:16:05',NULL),(1607881786667,99999,0,3,'get','JSON','/get','{\n    \"Comment[]\": {\n        \"Comment\": {\n            \"@column\": \"date,content;concat(id,^,<,>?|,toId,&,{},userId,LES+=)\",\n            \"@having\": \"to_days(date)%7=0\"\n        }\n    },\n    \"@explain\": true\n}\n                                                                                                                                                                                                              \n',NULL,'','2020-12-13 17:49:46',NULL),(1607881843319,99999,0,3,'复杂的 @having','JSON','/get','{\n    \"Comment[]\": {\n        \"Comment\": {\n            \"@having\": \"concat(id,^,<,>?|,&,{},:[],DROP!)<=8^3*3.14-7/4+50\"\n        }\n    },\n    \"@explain\": true\n}\n                                                                                                                                                                                                              \n',NULL,'','2020-12-13 17:50:43',NULL),(1607881872995,99999,0,3,'最近7天','JSON','/get','{\n    \"Comment\": {\n        \"@having\": \"to_days(now())-to_days(`date`)<=7\",\n        \"@raw\": \"@having\"\n    },\n    \"@explain\": true\n}\n                                                                                                                                                                                                              \n',NULL,'','2020-12-13 17:51:12',NULL),(1607881932306,99999,0,3,'@raw 自定义 SQL 片段','JSON','/get','{   // 类似 12306 根据始发站和到达站来过滤火车班次，班次和线路多对一，线路和站点多对多\n    \"sql@\": {\n        \"from\": \"Comment\",\n        \"join\": \"&/Comment:to/userId@\",\n        \"Comment\": {  // 假装是始发站\n            \"@column\": \"userId\",\n            \"content~\": \"a\",  // 假装是站点名\n            \"momentId>\": \"to.momentId\",\n            \"@raw\": \"momentId>\"\n        },\n        \"Comment:to\": {  // 假装是终点站\n            \"userId@\": \"/Comment/userId\",\n            \"@column\": \"\",\n            \"content~\": \"j\"  // 假装是站点名\n        }\n    },\n    \"[]\": {\n        \"Moment\": {  // 假装是班次\n            \"userId{}@\": {\n                \"from\": \"User\",\n                \"User\": {  // 假装是线路\n                    \"id{}@\": \"sql\",\n                    \"@column\": \"id\"\n                }\n            }\n        }\n    },\n    \"@explain\": true\n}\n                                                                                                                                                                                                              \n',NULL,'','2020-12-13 17:52:12',NULL),(1608087204039,82001,0,3,'get test 21:48','JSON','/get','{\n    \"User\": {\n        \"id\": 82001\n    },\n    \"[]\": {\n        \"Comment\": {\n            \"userId@\": \"User/id\"\n        }\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"User\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"id\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 1,\n                            \"values\": [\n                                82001\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        }\n                    }\n                ]\n            },\n            \"[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"Comment\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"userId@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            7\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2020-12-16 02:53:24',NULL),(1608995763278,99999,0,3,'SQL 函数与表达式','JSON','/get','{\n    \"Comment[]\": {\n        \"Comment\": {\n            \"@column\": \"userId;(toId)%3=0;group_concat(DISTINCT +,id)\",\n            \"@having\": \"max(id)>100;userId%5>=1\",\n            \"@group\": \"userId,toId\"\n        }\n    },\n    \"@explain\": true\n}\n                                                                                                                                                                                                              \n',NULL,'','2020-12-26 15:16:03',NULL),(1612031683609,88888,0,2,'视图表 ViewTable 查单条记录 /get','JSON','/get','{\n    \"ViewTable\": {\"id\": 82001}\n}\n                                                                                                                                                                                                              \n',NULL,'','2019-07-29 08:43:18',NULL),(1612031683610,88888,0,2,'视图表 ViewTable 查列表带条件','JSON','/get','{\n    \"ViewTable[]\": {\n        \"ViewTable\": {\n            \"toId\": 0,\n            \"content~\": \"a\"\n        }\n    }\n}\n                                                                                                                                                                                                              \n',NULL,'','2019-07-29 08:43:18',NULL),(1612031683611,88888,0,2,'视图表 ViewTable INNER JOIN Moment','JSON','/get','{\n    \"[]\": {\n        \"join\": \"&/Moment/id@\",\n        \"ViewTable\": {\"toId\":0},\n        \"Moment\": {\"content~\":\"a\",\n            \"id@\": \"/ViewTable/momentId\"\n        }\n    }\n}\n                                                                                                                                                                                                              \n',NULL,'','2019-07-29 08:43:18',NULL),(1612031683612,88888,0,2,'视图表 ViewTable 子查询','JSON','/get','{\n    \"ViewTable[]\": {\n        \"ViewTable\": {\n            \"momentId{}@\": {\n                \"from\": \"Moment\",\n                \"Moment\": {\n                    \"@column\": \"id\"\n                }\n            }\n        }\n    }\n}\n                                                                                                                                                                                                              \n',NULL,'','2019-07-29 08:43:18',NULL),(1612031683613,88888,0,2,'视图表 ViewTable LEFT JOIN Moment','JSON','/get','{\n    \"[]\": {\n        \"join\": \"</Moment/id@\",\n        \"ViewTable\": {},\n        \"Moment\": {\n            \"id@\": \"/ViewTable/momentId\"\n        }\n    }\n}\n                                                                                                                                                                                                              \n',NULL,'','2019-07-29 08:43:18',NULL),(1612031683614,88888,0,2,'全局关键词','JSON','/get','{\n    \"[]\": {\n        \"count\": 3,\n        \"Moment\": {},\n      \n        \"User\": {\n            \"id@\": \"/Moment/userId\",\n            \"@column\": \"id,name,head\"\n        },\n        \"[]\": {\n            \"count\": 6,\n            \"Comment\": {\n                \"momentId@\": \"[]/Moment/id\"\n            },\n            \"User\": {\n                \"id@\": \"/Comment/userId\",\n                \"@column\": \"id,name\"\n            }\n        }\n    },\n    \"format\": false,\n    \"tag\": \"Moment[]\",\n    \"version\": 0,\n    \"@role\": \"CIRCLE\",\n    \"@database\": \"MYSQL\",\n    \"@schema\": \"sys\",\n    \"@explain\": true,\n    \"@cache\": 0\n}\n                                                                                                                                                                                                              \n',NULL,'','2019-07-29 08:43:18',NULL),(1612031683615,88888,0,2,'功能符：连续范围','JSON','/get','{\"User[]\":{\"count\":3,\"User\":{\"date%\":\"2017-10-01,2018-10-01\"}}}',NULL,'','2019-07-29 08:43:18',NULL),(1627003810321,82003,0,3,'关联查询','JSON','/get','{\n    \"[]\": {\n        \"Moment\": {\n            \"@column\": \"id,date,userId\",\n            \"id\": 12\n        },\n        \"User\": {\n            \"id@\": \"/Moment/userId\",\n            \"@column\": \"id,name\"\n        }\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"Moment\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"@column\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            14\n                                        ]\n                                    },\n                                    \"id\": {\n                                        \"notnull\": true,\n                                        \"type\": \"integer\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            12\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": []\n                                    }\n                                }\n                            ]\n                        },\n                        \"User\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"id@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            14\n                                        ]\n                                    },\n                                    \"@column\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            7\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-07-23 01:30:10',NULL),(1627750805078,88888,0,3,'用远程函数校验参数-非法参数','JSON','/put','{\n    \"Moment\": {\n        \"id\": 235,\n        \"pictureList\": [\n            \"a\",\n            \"http://abc.cn/1.png\"\n        ]\n    },\n    \"tag\": \"Moment\"\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"Moment\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"id\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                235\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"pictureList\": {\n                            \"notnull\": true,\n                            \"type\": \"array\",\n                            \"valueLevel\": 0,\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                2\n                            ],\n                            \"values\": [\n                                {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        19,\n                                        1\n                                    ]\n                                }\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"tag\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    6\n                ]\n            }\n        }\n    ]\n}','','2021-07-31 17:00:05',NULL),(1627755287025,82001,0,3,'多数据源同时使用','JSON','/get','{\n    \"@datasource\": \"DRUID\",\n    \"User\": {\n        \"id\": 82001,\n        \"@datasource\": \"HIKARICP\",\n        \"@database\": \"POSTGRESQL\"\n    },\n    \"[]\": {\n        \"Comment\": {\n            \"userId@\": \"User/id\"\n        },\n        \"Moment\": {\n            \"@datasource\": \"DRUID\",\n            \"id@\": \"/Comment/momentId\"\n        }\n    },\n    \"@explain\": true\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"@datasource\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    \"DRUID\"\n                ],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    5\n                ]\n            },\n            \"User\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"id\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 1,\n                            \"values\": [\n                                82001\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"@datasource\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                \"HIKARICP\"\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                8\n                            ]\n                        },\n                        \"@database\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                \"POSTGRESQL\"\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                10\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"Comment\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"userId@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            7\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"Moment\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"@datasource\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            \"DRUID\"\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            5\n                                        ]\n                                    },\n                                    \"id@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            17\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"@explain\": {\n                \"notnull\": true,\n                \"type\": \"boolean\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    true\n                ],\n                \"lengthLevel\": 1,\n                \"lengths\": []\n            }\n        }\n    ]\n}','','2021-07-31 18:14:47',NULL),(1627755325870,88888,0,3,'多数据源同时使用','JSON','/get','{\n    \"@datasource\": \"DRUID\",\n    \"User\": {\n        \"id\": 82001,\n        \"@datasource\": \"HIKARICP\",\n        \"@database\": \"POSTGRESQL\"\n    },\n    \"[]\": {\n        \"Comment\": {\n            \"userId@\": \"User/id\"\n        },\n        \"Moment\": {\n            \"@datasource\": \"DRUID\",\n            \"id@\": \"/Comment/momentId\"\n        }\n    },\n    \"@explain\": true\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"@datasource\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    \"DRUID\"\n                ],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    5\n                ]\n            },\n            \"User\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"id\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 1,\n                            \"values\": [\n                                82001\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"@datasource\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                \"HIKARICP\"\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                8\n                            ]\n                        },\n                        \"@database\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                \"POSTGRESQL\"\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                10\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"Comment\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"userId@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            7\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"Moment\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"@datasource\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            \"DRUID\"\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            5\n                                        ]\n                                    },\n                                    \"id@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            17\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"@explain\": {\n                \"notnull\": true,\n                \"type\": \"boolean\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    true\n                ],\n                \"lengthLevel\": 1,\n                \"lengths\": []\n            }\n        }\n    ]\n}','','2021-07-31 18:15:25',NULL),(1631668437509,1631617361403,0,3,'2021-09-15 09:12 ','JSON','/resource/apijson/get','{}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {}\n    ]\n}','','2021-09-15 01:13:57',NULL),(1631669045947,1631617361403,0,3,'汇聚资源新增','JSON','/resource/apijson/post','{\n    \"ResourceId-()\": \"getResourceId()\",\n    \"username-()\": \"encryption(root)\",\n    \"password-()\": \"encryption(123456)\",\n    \"ResourceInfo\": {\n        \"RESOURCE_ID@\": \"ResourceId\",\n        \"RESOURCE_NAME\": \"测试资源1\",\n        \"RESOURCE_TYPE\": \"1\",\n        \"RESOURCE_SERVE\": \"0\",\n        \"NET_ID\": \"1\",\n        \"UPDATE_FREQUENCY\": \"1\",\n        \"UPDATE_FREQUENCY_UNIT\": \"H\",\n        \"UNIT_ID\": \"1\",\n        \"COMPANY_ID\": \"2\",\n        \"CONTACT_PERSON_ID\": \"1\",\n        \"DESC\": \"测试\",\n        \"SECURITY_LEVEL\": 5,\n        \"IS_SPACE_DATA\": 1,\n        \"SYSTEM_NAME\": \"六合一平台\",\n        \"UNIT_CONTACT_PERSON\": \"郄\",\n        \"AREA_SCOPE\": \"1,2\",\n        \"RESOURCE_ID\": null\n    },\n    \"ResourceDb\": {\n        \"DB_TYPE\": \"1\",\n        \"DB_ADDRESS\": \"58.210.9.133\",\n        \"DB_NAME\": \"public\",\n        \"DB_URI\": \"jdbc:postgresql://101.133.229.133:5432/postgres\",\n        \"TABLE_NAME\": \"t_car_pass_record\",\n        \"DB_USERNAME@\": \"username\",\n        \"DB_PASSWORD@\": \"password\"\n    },\n    \"ResourceTag[]\": [\n        {\n            \"RESOURCE_TAG_ID\": \"1\",\n            \"RESOURCE_INFO_ID@\": \"ResourceId\"\n        },\n        {\n            \"RESOURCE_TAG_ID\": \"2\",\n            \"RESOURCE_INFO_ID@\": \"ResourceId\"\n        }\n    ]\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"ResourceInfo\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"RESOURCE_ID\": {\n                            \"notnull\": false,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"RESOURCE_NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                5\n                            ]\n                        },\n                        \"RESOURCE_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"RESOURCE_SERVE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"NET_ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"UPDATE_FREQUENCY\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"UPDATE_FREQUENCY_UNIT\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                \"H\"\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"UNIT_ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"COMPANY_ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"CONTACT_PERSON_ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"DESC\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                2\n                            ]\n                        },\n                        \"SECURITY_LEVEL\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                5\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"IS_SPACE_DATA\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                1\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"SYSTEM_NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                5\n                            ]\n                        },\n                        \"UNIT_CONTACT_PERSON\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"AREA_SCOPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                3\n                            ]\n                        },\n                        \"RESOURCE_ID@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                10\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ResourceTag[]\": {\n                \"notnull\": true,\n                \"type\": \"array\",\n                \"valueLevel\": 0,\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    2\n                ],\n                \"values\": [\n                    {\n                        \"notnull\": true,\n                        \"type\": \"object\",\n                        \"valueLevel\": 0,\n                        \"values\": [\n                            {\n                                \"RESOURCE_TAG_ID\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        1\n                                    ]\n                                },\n                                \"RESOURCE_INFO_ID@\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        24,\n                                        10\n                                    ]\n                                }\n                            }\n                        ]\n                    }\n                ]\n            },\n            \"ResourceId-()\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    15\n                ]\n            },\n            \"username-()\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    16\n                ]\n            },\n            \"password-()\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    18\n                ]\n            },\n            \"ResourceDb\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"DB_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"DB_ADDRESS\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                12\n                            ]\n                        },\n                        \"DB_NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                6\n                            ]\n                        },\n                        \"DB_URI\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                47\n                            ]\n                        },\n                        \"TABLE_NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                17\n                            ]\n                        },\n                        \"DB_USERNAME@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                8\n                            ]\n                        },\n                        \"DB_PASSWORD@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                8\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-09-15 01:24:05',NULL),(1631670171091,1631617361403,0,3,'资源详情','JSON','/resource/apijson/get','{\n    \"ResourceInfo\": {\n        \"id\": \"1631608580403\"\n    },\n    \"DataUnit:ParentUnit\": {\n        \"id@\": \"ResourceInfo/UNIT_ID\"\n    },\n    \"DataUnit:CompanyUnit\": {\n        \"id@\": \"ResourceInfo/COMPANY_ID\"\n    },\n    \"ContactPerson\": {\n        \"id@\": \"ResourceInfo/CONTACT_PERSON_ID\"\n    },\n    \"[]\": {\n        \"ResourceTag\": {\n            \"RESOURCE_INFO_ID@\": \"ResourceInfo/RESOURCE_ID\"\n        },\n        \"Tag\": {\n            \"id@\": \"[]/ResourceTag/RESOURCE_TAG_ID\"\n        }\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"ResourceInfo\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"id\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                13\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"DataUnit:ParentUnit\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"id@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                20\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"DataUnit:CompanyUnit\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"id@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                23\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ContactPerson\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"id@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                30\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ResourceTag\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"RESOURCE_INFO_ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            24\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"Tag\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"id@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            30\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-09-15 01:42:51',NULL),(1631757289713,1631617361403,0,3,'资源列表查询','JSON','/resource/apijson/get','{\n    \"[]\": {\n        \"ResourceInfo:GROUP\": {\n            \"RESOURCE_NAME$\": \"%1%\",\n            \"@column\": \"RESOURCE_ID;max(REVISION):MAX_REVISION\",\n            \"@group\": \"RESOURCE_ID\",\n            \"@order\": \"RESOURCE_ID\"\n        },\n        \"ResourceInfo\": {\n            \"RESOURCE_ID@\": \"[]/ResourceInfo:GROUP/RESOURCE_ID\",\n            \"REVISION@\": \"[]/ResourceInfo:GROUP/MAX_REVISION\"\n        },\n        \"DataUnit:ParentUnit\": {\n            \"id@\": \"[]/ResourceInfo/UNIT_ID\"\n        },\n        \"DataUnit:CompanyUnit\": {\n            \"id@\": \"[]/ResourceInfo/COMPANY_ID\"\n        },\n        \"ContactPerson\": {\n            \"id@\": \"[]/ResourceInfo/CONTACT_PERSON_ID\"\n        },\n        \"[]\": {\n            \"ResourceTag\": {\n                \"RESOURCE_INFO_ID@\": \"[]/ResourceInfo/RESOURCE_ID\"\n            },\n            \"Tag\": {\n                \"id@\": \"[]/[]/ResourceTag/RESOURCE_TAG_ID\"\n            }\n        },\n        \"query\": 2,\n        \"page\": 0,\n        \"count\": 10\n    },\n    \"total@\": \"/[]/total\",\n    \"page@\": \"/[]/page\",\n    \"info@\": \"/[]/info\"\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ResourceInfo:GROUP\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"@column\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            38\n                                        ]\n                                    },\n                                    \"@group\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            \"RESOURCE_ID\"\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            11\n                                        ]\n                                    },\n                                    \"@order\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            \"RESOURCE_ID\"\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            11\n                                        ]\n                                    },\n                                    \"RESOURCE_NAME$\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            3\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"ResourceInfo\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"RESOURCE_ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            33\n                                        ]\n                                    },\n                                    \"REVISION@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            34\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"DataUnit:ParentUnit\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"id@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            23\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"DataUnit:CompanyUnit\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"id@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            26\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"ContactPerson\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"id@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            33\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"[]\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"ResourceTag\": {\n                                        \"notnull\": true,\n                                        \"type\": \"object\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            {\n                                                \"RESOURCE_INFO_ID@\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 3,\n                                                    \"values\": [],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        27\n                                                    ]\n                                                }\n                                            }\n                                        ]\n                                    },\n                                    \"Tag\": {\n                                        \"notnull\": true,\n                                        \"type\": \"object\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            {\n                                                \"id@\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 3,\n                                                    \"values\": [],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        33\n                                                    ]\n                                                }\n                                            }\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"query\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                2\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"page\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                0\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"count\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                10\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        }\n                    }\n                ]\n            },\n            \"total@\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    9\n                ]\n            },\n            \"page@\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    8\n                ]\n            },\n            \"info@\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    8\n                ]\n            }\n        }\n    ]\n}','','2021-09-16 01:54:49',NULL),(1631771103135,1631617361403,0,3,'查询同一资源各版本列表','JSON','/resource/apijson/get','{\n    \"[]\": {\n        \"ResourceInfo\": {\n            \"RESOURCE_ID\": \"1\",\n            \"@order\": \"REVISION-\"\n        },\n        \"DataUnit:ParentUnit\": {\n            \"id@\": \"[]/ResourceInfo/UNIT_ID\"\n        },\n        \"DataUnit:CompanyUnit\": {\n            \"id@\": \"[]/ResourceInfo/COMPANY_ID\"\n        },\n        \"ContactPerson\": {\n            \"id@\": \"[]/ResourceInfo/CONTACT_PERSON_ID\"\n        },\n        \"[]\": {\n            \"ResourceTag\": {\n                \"RESOURCE_INFO_ID@\": \"[]/ResourceInfo/RESOURCE_ID\",\n                \"REVISION@\": \"[]/ResourceInfo/REVISION\"\n            },\n            \"Tag\": {\n                \"id@\": \"[]/[]/ResourceTag/RESOURCE_TAG_ID\"\n            }\n        },\n        \"query\": 2,\n        \"page\": 0,\n        \"count\": 10\n    },\n    \"total@\": \"/[]/total\",\n    \"page@\": \"/[]/page\",\n    \"info@\": \"/[]/info\"\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ResourceInfo\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"RESOURCE_ID\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            1\n                                        ]\n                                    },\n                                    \"@order\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            9\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"DataUnit:ParentUnit\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"id@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            23\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"DataUnit:CompanyUnit\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"id@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            26\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"ContactPerson\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"id@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            33\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"[]\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"ResourceTag\": {\n                                        \"notnull\": true,\n                                        \"type\": \"object\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            {\n                                                \"RESOURCE_INFO_ID@\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 3,\n                                                    \"values\": [],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        27\n                                                    ]\n                                                },\n                                                \"REVISION@\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 3,\n                                                    \"values\": [],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        24\n                                                    ]\n                                                }\n                                            }\n                                        ]\n                                    },\n                                    \"Tag\": {\n                                        \"notnull\": true,\n                                        \"type\": \"object\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            {\n                                                \"id@\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 3,\n                                                    \"values\": [],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        33\n                                                    ]\n                                                }\n                                            }\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"query\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                2\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"page\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                0\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"count\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                10\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        }\n                    }\n                ]\n            },\n            \"total@\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    9\n                ]\n            },\n            \"page@\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    8\n                ]\n            },\n            \"info@\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    8\n                ]\n            }\n        }\n    ]\n}','','2021-09-16 05:45:03',NULL),(1631773493501,1631617361403,0,3,'上传字典表','JSON','/resource/apijson/post','{\n    \"SysDict[]\": [\n        {\n            \"TYPE\": \"RESOURCE_SERVE\",\n            \"DICT_ID\": \"RESOURCE_SERVE_0\",\n            \"LABEL\": \"汇聚资源\",\n            \"VALUE\": \"0\",\n            \"SORT\": \"1\",\n            \"DESCRIPTION\": \"资源供应类型\"\n        },\n        {\n            \"TYPE\": \"RESOURCE_SERVE\",\n            \"DICT_ID\": \"RESOURCE_SERVE_1\",\n            \"LABEL\": \"落地资源\",\n            \"VALUE\": \"1\",\n            \"SORT\": \"2\",\n            \"DESCRIPTION\": \"资源供应类型\"\n        }\n    ]\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"SysDict[]\": {\n                \"notnull\": true,\n                \"type\": \"array\",\n                \"valueLevel\": 0,\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    2\n                ],\n                \"values\": [\n                    {\n                        \"notnull\": true,\n                        \"type\": \"object\",\n                        \"valueLevel\": 0,\n                        \"values\": [\n                            {\n                                \"TYPE\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 0,\n                                    \"values\": [\n                                        \"RESOURCE_SERVE\"\n                                    ],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        14\n                                    ]\n                                },\n                                \"DICT_ID\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 0,\n                                    \"values\": [\n                                        \"RESOURCE_SERVE_0\",\n                                        \"RESOURCE_SERVE_1\"\n                                    ],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        16\n                                    ]\n                                },\n                                \"LABEL\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        4\n                                    ]\n                                },\n                                \"VALUE\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        1\n                                    ]\n                                },\n                                \"SORT\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        1\n                                    ]\n                                },\n                                \"DESCRIPTION\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        6\n                                    ]\n                                }\n                            }\n                        ]\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-09-16 06:24:53',NULL),(1631775393342,1631617361403,0,3,'字典表查询','JSON','/resource/apijson/get','{\n    \"SysDict[]\": {\n        \"SysDict\": {\n            \"TYPE\": \"RESOURCE_SERVE\"\n        }\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"SysDict[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"SysDict\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"TYPE\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            \"RESOURCE_SERVE\"\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            14\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-09-16 06:56:33',NULL),(1631842712990,1631617361403,0,3,'删除资源','JSON','/resource/apijson/delete','{\n    \"ResourceInfo\": {\n        \"id\": \"1631787701342\"\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"ResourceInfo\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"id\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                13\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-09-17 01:38:32',NULL),(1631842798921,1631617361403,0,3,'资源状态变更','JSON','/resource/apijson/put','{\n    \"ResourceInfo\": {\n        \"id\": \"1631788768897\",\n        \"RESOURCE_STATUS\": 1\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"ResourceInfo\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"id\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                13\n                            ]\n                        },\n                        \"RESOURCE_STATUS\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                1\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-09-17 01:39:58',NULL),(1632301360926,1631617361403,0,3,'落地资源新增','JSON','/resource/apijson/post','{\n    \"ResourceId-()\": \"getResourceId()\",\n    \"username-()\": \"encryption(root)\",\n    \"password-()\": \"encryption(123456)\",\n    \"ResourceInfo\": {\n        \"RESOURCE_ID@\": \"ResourceId\",\n        \"RESOURCE_NAME\": \"停车场落地数据\",\n        \"RESOURCE_TYPE\": \"0\",\n        \"RESOURCE_SERVE\": \"1\",\n        \"NET_ID\": \"1\",\n        \"UPDATE_FREQUENCY\": \"1\",\n        \"UPDATE_FREQUENCY_UNIT\": \"H\",\n        \"DESC\": \"落地资源\",\n        \"SECURITY_LEVEL\": 5,\n        \"IS_SPACE_DATA\": 1,\n        \"AREA_SCOPE\": \"1,2\"\n    },\n    \"ResourceDb\": {\n        \"DB_TYPE\": \"1\",\n        \"DB_ADDRESS\": \"58.210.9.133\",\n        \"DB_NAME\": \"public\",\n        \"DB_URI\": \"jdbc:postgresql://101.133.229.133:5432/postgres\",\n        \"TABLE_NAME\": \"t_car_pass_record\",\n        \"DB_USERNAME@\": \"username\",\n        \"DB_PASSWORD@\": \"password\"\n    },\n    \"LinkInfo[]\": [\n        {\n            \"UP_NODE_ID\": \"1438447993332600833\",\n            \"DOWN_NODE_ID@\": \"ResourceId\",\n            \"UP_NODE_REVISION\": \"1\",\n            \"DOWN_NODE_REVISION\": \"1\"\n        }\n    ],\n    \"ResourceTag[]\": [\n        {\n            \"RESOURCE_TAG_ID\": \"1\",\n            \"RESOURCE_INFO_ID@\": \"ResourceId\"\n        },\n        {\n            \"RESOURCE_TAG_ID\": \"2\",\n            \"RESOURCE_INFO_ID@\": \"ResourceId\"\n        }\n    ]\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"ResourceId-()\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    15\n                ]\n            },\n            \"username-()\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    16\n                ]\n            },\n            \"password-()\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    18\n                ]\n            },\n            \"ResourceInfo\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"RESOURCE_ID@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                10\n                            ]\n                        },\n                        \"RESOURCE_NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                7\n                            ]\n                        },\n                        \"RESOURCE_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"RESOURCE_SERVE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"NET_ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"UPDATE_FREQUENCY\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"UPDATE_FREQUENCY_UNIT\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                \"H\"\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"DESC\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                4\n                            ]\n                        },\n                        \"SECURITY_LEVEL\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                5\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"IS_SPACE_DATA\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                1\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"AREA_SCOPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                3\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ResourceDb\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"DB_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"DB_ADDRESS\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                12\n                            ]\n                        },\n                        \"DB_NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                6\n                            ]\n                        },\n                        \"DB_URI\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                47\n                            ]\n                        },\n                        \"TABLE_NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                17\n                            ]\n                        },\n                        \"DB_USERNAME@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                8\n                            ]\n                        },\n                        \"DB_PASSWORD@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                8\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"LinkInfo[]\": {\n                \"notnull\": true,\n                \"type\": \"array\",\n                \"valueLevel\": 0,\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    1\n                ],\n                \"values\": [\n                    {\n                        \"notnull\": true,\n                        \"type\": \"object\",\n                        \"valueLevel\": 0,\n                        \"values\": [\n                            {\n                                \"UP_NODE_ID\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        19\n                                    ]\n                                },\n                                \"DOWN_NODE_ID@\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        10\n                                    ]\n                                },\n                                \"UP_NODE_REVISION\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        1\n                                    ]\n                                },\n                                \"DOWN_NODE_REVISION\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        1\n                                    ]\n                                }\n                            }\n                        ]\n                    }\n                ]\n            },\n            \"ResourceTag[]\": {\n                \"notnull\": true,\n                \"type\": \"array\",\n                \"valueLevel\": 0,\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    2\n                ],\n                \"values\": [\n                    {\n                        \"notnull\": true,\n                        \"type\": \"object\",\n                        \"valueLevel\": 0,\n                        \"values\": [\n                            {\n                                \"RESOURCE_TAG_ID\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        1\n                                    ]\n                                },\n                                \"RESOURCE_INFO_ID@\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        10\n                                    ]\n                                }\n                            }\n                        ]\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-09-22 09:02:40',NULL),(1633674327218,1631617361403,0,3,'资源详情','JSON','/resource/apijson/get','{\n    \"ResourceInfo\": {\n        \"ID\": \"1632885190990\"\n    },\n    \"DataUnit:ParentUnit\": {\n        \"ID@\": \"ResourceInfo/UNIT_ID\"\n    },\n    \"DataUnit:CompanyUnit\": {\n        \"ID@\": \"ResourceInfo/COMPANY_ID\"\n    },\n    \"ContactPerson\": {\n        \"ID@\": \"ResourceInfo/CONTACT_PERSON_ID\"\n    },\n    \"ResourceDb:数据库\": {\n        \"RESOURCE_ID@\": \"ResourceInfo/RESOURCE_ID\",\n        \"REVISION@\": \"ResourceInfo/REVISION\"\n    },\n    \"FileAttachment[]\": {\n        \"ResourceFile\": {\n            \"RESOURCE_ID@\": \"ResourceInfo/RESOURCE_ID\",\n            \"REVISION@\": \"ResourceInfo/REVISION\"\n        },\n        \"FileAttachment\": {\n            \"ID@\": \"/ResourceFile/FILE_ATTACHMENT_ID\"\n        }\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"ResourceInfo\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                13\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"DataUnit:ParentUnit\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ID@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                20\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"DataUnit:CompanyUnit\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ID@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                23\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ContactPerson\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ID@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                30\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ResourceDb:数据库\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"RESOURCE_ID@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                24\n                            ]\n                        },\n                        \"REVISION@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                21\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"FileAttachment[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ResourceFile\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"RESOURCE_ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            24\n                                        ]\n                                    },\n                                    \"REVISION@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            21\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"FileAttachment\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            32\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-10-08 06:25:27',NULL),(1633681667093,1631617361403,0,3,'资源新增-消息队列','JSON','/resource/apijson/post','{\n    \"ResourceId-()\": \"getResourceId()\",\n    \"ResourceInfo\": {\n        \"RESOURCE_ID@\": \"ResourceId\",\n        \"RESOURCE_NAME\": \"警务通gps数据\",\n        \"RESOURCE_TYPE\": \"1\",\n        \"RESOURCE_SERVE\": \"1\",\n        \"NET_ID\": \"1\",\n        \"UPDATE_FREQUENCY\": \"1\",\n        \"UPDATE_FREQUENCY_UNIT\": \"H\",\n        \"DESC\": \"落地资源\",\n        \"SECURITY_LEVEL\": 5,\n        \"IS_SPACE_DATA\": 1,\n        \"AREA_SCOPE\": \"1,2\"\n    },\n    \"ResourceTopic\": {\n        \"RESOURCE_ID@\": \"ResourceId\",\n        \"QUEUE_TYPE\": \"0\",\n        \"QUEUE_BROKER_LIST\": \"50.73.141.210:39092\",\n        \"QUEUE_TOPIC_NAME\": \"HIK_EVENT\"\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"ResourceId-()\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    15\n                ]\n            },\n            \"ResourceInfo\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"RESOURCE_ID@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                10\n                            ]\n                        },\n                        \"RESOURCE_NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                8\n                            ]\n                        },\n                        \"RESOURCE_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"RESOURCE_SERVE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"NET_ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"UPDATE_FREQUENCY\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"UPDATE_FREQUENCY_UNIT\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                \"H\"\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"DESC\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                4\n                            ]\n                        },\n                        \"SECURITY_LEVEL\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                5\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"IS_SPACE_DATA\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                1\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"AREA_SCOPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                3\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ResourceTopic\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"RESOURCE_ID@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                10\n                            ]\n                        },\n                        \"QUEUE_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"QUEUE_BROKER_LIST\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                19\n                            ]\n                        },\n                        \"QUEUE_TOPIC_NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                \"HIK_EVENT\"\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                9\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-10-08 08:27:47',NULL),(1633682138997,1631617361403,0,3,'资源详情-消息队列','JSON','/resource/apijson/get','{\n    \"ResourceInfo\": {\n        \"ID\": \"1633681660869\"\n    },\n    \"ResourceTopic\": {\n        \"RESOURCE_ID@\": \"ResourceInfo/RESOURCE_ID\",\n        \"SysDict\": {\n            \"TYPE\": \"QUEUE_TYPE\",\n            \"VALUE@\": \"ResourceTopic/QUEUE_TYPE\"\n        }\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"ResourceInfo\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                13\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ResourceTopic\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"RESOURCE_ID@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                24\n                            ]\n                        },\n                        \"SysDict\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"TYPE\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            \"QUEUE_TYPE\"\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            10\n                                        ]\n                                    },\n                                    \"VALUE@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            24\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-10-08 08:35:39',NULL),(1633685540122,1631617361403,0,3,'共享方式新增-api','JSON','/resource/apijson/post','{\n    \"ResourceShare\": {\n        \"NAME\": \"数据库共享\",\n        \"DESC\": \"描述\",\n        \"SHARE_TYPE\": \"2\",\n        \"RESOURCE_INFO_ID\": \"1446390805710295041\"\n    },\n    \"ResourceApi\": {\n        \"SHARE_ID@\": \"ResourceShare/ID\",\n        \"API_ADDRESS\": \"http://58.210.9.133:8989/resource/dataUnit/companyList\",\n        \"API_PORT\": \"8989\",\n        \"API_PATH\": \"/resource/dataUnit/companyList\",\n        \"API_REQUEST_METHOD\": \"0\",\n        \"API_REQUEST_TYPE\": \"0\",\n        \"RESOURCE_ID@\": null\n    },\n    \"ResourceInterfaceParam[]\": [\n        {\n            \"SHARE_ID@\": \"ResourceShare/ID\",\n            \"API_ID@\": \"ResourceApi/ID\",\n            \"PARAM_NAME\": \"id\",\n            \"PARAM_DESC\": \"主键id\",\n            \"PARAM_TYPE\": \"0\",\n            \"RESOURCE_ID@\": null\n        }\n    ],\n    \"ResourceId-()\": null,\n    \"ResourceInfo\": null\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"ResourceId-()\": {\n                \"notnull\": false,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    15\n                ]\n            },\n            \"ResourceInfo\": {\n                \"notnull\": false,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"RESOURCE_ID@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                10\n                            ]\n                        },\n                        \"RESOURCE_NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                8\n                            ]\n                        },\n                        \"RESOURCE_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"RESOURCE_SERVE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"NET_ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"UPDATE_FREQUENCY\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"UPDATE_FREQUENCY_UNIT\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                \"H\"\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"DESC\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                4\n                            ]\n                        },\n                        \"SECURITY_LEVEL\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                5\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"IS_SPACE_DATA\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                1\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"AREA_SCOPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                3\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ResourceApi\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"RESOURCE_ID@\": {\n                            \"notnull\": false,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                10\n                            ]\n                        },\n                        \"API_ADDRESS\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                54\n                            ]\n                        },\n                        \"API_PORT\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                4\n                            ]\n                        },\n                        \"API_PATH\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                30\n                            ]\n                        },\n                        \"API_REQUEST_METHOD\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"API_REQUEST_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"SHARE_ID@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                16\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ResourceInterfaceParam[]\": {\n                \"notnull\": true,\n                \"type\": \"array\",\n                \"valueLevel\": 0,\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    1\n                ],\n                \"values\": [\n                    {\n                        \"notnull\": true,\n                        \"type\": \"object\",\n                        \"valueLevel\": 0,\n                        \"values\": [\n                            {\n                                \"RESOURCE_ID@\": {\n                                    \"notnull\": false,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        10\n                                    ]\n                                },\n                                \"API_ID@\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        14\n                                    ]\n                                },\n                                \"PARAM_NAME\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        2\n                                    ]\n                                },\n                                \"PARAM_DESC\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        4\n                                    ]\n                                },\n                                \"PARAM_TYPE\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        1\n                                    ]\n                                },\n                                \"SHARE_ID@\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        16\n                                    ]\n                                }\n                            }\n                        ]\n                    }\n                ]\n            },\n            \"ResourceShare\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                5\n                            ]\n                        },\n                        \"DESC\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                2\n                            ]\n                        },\n                        \"SHARE_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"RESOURCE_INFO_ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                19\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-10-08 09:32:20',NULL),(1633686401010,1631617361403,0,3,'资源详情-api','JSON','/resource/apijson/get','{\n    \"ResourceInfo\": {\n        \"ID\": \"1633685461722\"\n    },\n    \"ResourceApi\": {\n        \"RESOURCE_ID@\": \"ResourceInfo/RESOURCE_ID\",\n        \"REVISION@\": \"ResourceInfo/REVISION\",\n        \"SysDict:API_REQUEST_METHOD\": {\n            \"TYPE\": \"API_REQUEST_METHOD\",\n            \"VALUE@\": \"/API_REQUEST_METHOD\"\n        },\n        \"SysDict:API_REQUEST_TYPE\": {\n            \"TYPE\": \"API_REQUEST_TYPE\",\n            \"VALUE@\": \"/API_REQUEST_TYPE\"\n        }\n    },\n    \"ResourceInterfaceParam[]\": {\n        \"ResourceInterfaceParam\": {\n            \"API_ID@\": \"ResourceApi/ID\",\n            \"SysDict:PARAM_TYPE\": {\n                \"TYPE\": \"PARAM_TYPE\",\n                \"VALUE@\": \"/PARAM_TYPE\"\n            }\n        }\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"ResourceInfo\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                13\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ResourceApi\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"RESOURCE_ID@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                24\n                            ]\n                        },\n                        \"REVISION@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                21\n                            ]\n                        },\n                        \"SysDict:API_REQUEST_METHOD\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"TYPE\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            \"API_REQUEST_METHOD\"\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            18\n                                        ]\n                                    },\n                                    \"VALUE@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            19\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"SysDict:API_REQUEST_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"TYPE\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            \"API_REQUEST_TYPE\"\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            16\n                                        ]\n                                    },\n                                    \"VALUE@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            17\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ResourceInterfaceParam[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ResourceInterfaceParam\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"API_ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            14\n                                        ]\n                                    },\n                                    \"SysDict:PARAM_TYPE\": {\n                                        \"notnull\": true,\n                                        \"type\": \"object\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            {\n                                                \"TYPE\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 0,\n                                                    \"values\": [\n                                                        \"PARAM_TYPE\"\n                                                    ],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        10\n                                                    ]\n                                                },\n                                                \"VALUE@\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 3,\n                                                    \"values\": [],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        11\n                                                    ]\n                                                }\n                                            }\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-10-08 09:46:41',NULL),(1633770522246,1631617361403,0,3,'资源修改','JSON','/resource/apijson/put','{\n    \"updateResource-()\": \"updateResource(1446391835361595393,1)\",\n    \"ResourceInfo\": {\n        \"ID\": \"1633681660869\",\n        \"RESOURCE_ID\": \"1446391835361595393\",\n        \"REVISION\": 1,\n        \"RESOURCE_NAME\": \"警务通gps数据\",\n        \"RESOURCE_TYPE\": \"1\",\n        \"RESOURCE_SERVE\": \"1\",\n        \"NET_ID\": \"1\",\n        \"UPDATE_FREQUENCY\": \"1\",\n        \"UPDATE_FREQUENCY_UNIT\": \"H\",\n        \"DESC\": \"落地资源1\",\n        \"SECURITY_LEVEL\": 5,\n        \"IS_SPACE_DATA\": 1,\n        \"AREA_SCOPE\": \"1,2\"\n    },\n    \"ResourceTopic-\": {\n        \"RESOURCE_ID\": \"1446391835361595393\",\n        \"REVISION\": 1,\n        \"QUEUE_TYPE\": \"0\",\n        \"QUEUE_BROKER_LIST\": \"50.73.141.210:39081\",\n        \"QUEUE_TOPIC_NAME\": \"HIK_EVENT\"\n    },\n    \"LinkInfo[]-\": [\n        {\n            \"UP_NODE_ID\": \"来源id\",\n            \"DOWN_NODE_ID\": \"1446391835361595393\"\n        }\n    ],\n    \"ResourceFile[]-\": [\n        {\n            \"FILE_ATTACHMENT_ID\": \"文件id\",\n            \"RESOURCE_ID\": \"1446391835361595393\",\n            \"REVISION\": 1\n        }\n    ]\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"updateResource-()\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    37\n                ]\n            },\n            \"ResourceInfo\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                13\n                            ]\n                        },\n                        \"RESOURCE_ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                19\n                            ]\n                        },\n                        \"REVISION\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                1\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"RESOURCE_NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                8\n                            ]\n                        },\n                        \"RESOURCE_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"RESOURCE_SERVE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"NET_ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"UPDATE_FREQUENCY\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"UPDATE_FREQUENCY_UNIT\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                \"H\"\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"DESC\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                5\n                            ]\n                        },\n                        \"SECURITY_LEVEL\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                5\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"IS_SPACE_DATA\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                1\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"AREA_SCOPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                3\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ResourceTopic-\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"RESOURCE_ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                19\n                            ]\n                        },\n                        \"REVISION\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                1\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"QUEUE_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"QUEUE_BROKER_LIST\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                19\n                            ]\n                        },\n                        \"QUEUE_TOPIC_NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                \"HIK_EVENT\"\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                9\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"LinkInfo[]-\": {\n                \"notnull\": true,\n                \"type\": \"array\",\n                \"valueLevel\": 0,\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    1\n                ],\n                \"values\": [\n                    {\n                        \"notnull\": true,\n                        \"type\": \"object\",\n                        \"valueLevel\": 0,\n                        \"values\": [\n                            {\n                                \"UP_NODE_ID\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        4\n                                    ]\n                                },\n                                \"DOWN_NODE_ID\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        19\n                                    ]\n                                }\n                            }\n                        ]\n                    }\n                ]\n            },\n            \"ResourceFile[]-\": {\n                \"notnull\": true,\n                \"type\": \"array\",\n                \"valueLevel\": 0,\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    1\n                ],\n                \"values\": [\n                    {\n                        \"notnull\": true,\n                        \"type\": \"object\",\n                        \"valueLevel\": 0,\n                        \"values\": [\n                            {\n                                \"FILE_ATTACHMENT_ID\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        4\n                                    ]\n                                },\n                                \"RESOURCE_ID\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        19\n                                    ]\n                                },\n                                \"REVISION\": {\n                                    \"notnull\": true,\n                                    \"type\": \"integer\",\n                                    \"valueLevel\": 0,\n                                    \"values\": [\n                                        1\n                                    ],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": []\n                                }\n                            }\n                        ]\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-10-09 09:08:42',NULL),(1634265668211,1631617361403,0,3,'资源列表查询','JSON','/resource/apijson/get','{\n    \"[]\": {\n        \"ResourceInfo\": {\n            \"ID{}@\": {\n                \"from\": \"ResourceInfo:ChildSearch\",\n                \"ResourceInfo:ChildSearch\": {\n                    \"@column\": \"max(ID):ID\",\n                    \"@group\": \"RESOURCE_ID\"\n                }\n            },\n            \"CREATED_TIME>=\": null,\n            \"CREATED_TIME<=\": null,\n            \"RESOURCE_STATUS\": \"0\",\n            \"RESOURCE_NAME$\": \"%%\",\n            \"RESOURCE_SERVE\": \"1\",\n            \"@order\": \"RESOURCE_ID\",\n            \"RESOURCE_OPEN\": \"0\",\n            \"UNIT_ID\": null\n        },\n        \"SysDict:RESOURCE_TYPE\": {\n            \"TYPE\": \"RESOURCE_TYPE\",\n            \"VALUE@\": \"[]/ResourceInfo/RESOURCE_TYPE\"\n        },\n        \"Net\": {\n            \"ID@\": \"[]/ResourceInfo/NET_ID\"\n        },\n        \"SysDict:NET_TYPE\": {\n            \"TYPE\": \"NET_TYPE\",\n            \"VALUE@\": \"[]/Net/NET_TYPE\"\n        },\n        \"DataUnit:ParentUnit\": {\n            \"ID@\": \"[]/ResourceInfo/UNIT_ID\"\n        },\n        \"DataUnit:CompanyUnit\": {\n            \"ID@\": \"[]/ResourceInfo/COMPANY_ID\"\n        },\n        \"ContactPerson\": {\n            \"ID@\": \"[]/ResourceInfo/CONTACT_PERSON_ID\"\n        },\n        \"ResourceShare\": {\n            \"RESOURCE_INFO_ID@\": \"[]/ResourceInfo/RESOURCE_ID\",\n            \"@column\": \"count(1)\"\n        },\n        \"ResourceApply\": {\n            \"RESOURCE_ID@\": \"[]/ResourceInfo/RESOURCE_ID\",\n            \"APPLY_STATUS\": \"0\",\n            \"@column\": \"count(1)\"\n        },\n        \"query\": 2,\n        \"page\": 0,\n        \"count\": 20,\n        \"[]\": null\n    },\n    \"total@\": \"/[]/total\",\n    \"page@\": \"/[]/page\",\n    \"info@\": \"/[]/info\"\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ResourceInfo\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"ID{}@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"object\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            {\n                                                \"from\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 3,\n                                                    \"values\": [],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        24\n                                                    ]\n                                                },\n                                                \"ResourceInfo:ChildSearch\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"object\",\n                                                    \"valueLevel\": 0,\n                                                    \"values\": [\n                                                        {\n                                                            \"@column\": {\n                                                                \"notnull\": true,\n                                                                \"type\": \"string\",\n                                                                \"valueLevel\": 3,\n                                                                \"values\": [],\n                                                                \"lengthLevel\": 1,\n                                                                \"lengths\": [\n                                                                    10\n                                                                ]\n                                                            },\n                                                            \"@group\": {\n                                                                \"notnull\": true,\n                                                                \"type\": \"string\",\n                                                                \"valueLevel\": 0,\n                                                                \"values\": [\n                                                                    \"RESOURCE_ID\"\n                                                                ],\n                                                                \"lengthLevel\": 1,\n                                                                \"lengths\": [\n                                                                    11\n                                                                ]\n                                                            }\n                                                        }\n                                                    ]\n                                                }\n                                            }\n                                        ]\n                                    },\n                                    \"RESOURCE_STATUS\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            1\n                                        ]\n                                    },\n                                    \"RESOURCE_NAME$\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            2\n                                        ]\n                                    },\n                                    \"RESOURCE_SERVE\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            1\n                                        ]\n                                    },\n                                    \"@order\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            \"RESOURCE_ID\"\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            11\n                                        ]\n                                    },\n                                    \"RESOURCE_OPEN\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            1\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"SysDict:RESOURCE_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"TYPE\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            \"RESOURCE_TYPE\"\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            13\n                                        ]\n                                    },\n                                    \"VALUE@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            29\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"Net\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            22\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"SysDict:NET_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"TYPE\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            \"NET_TYPE\"\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            8\n                                        ]\n                                    },\n                                    \"VALUE@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            15\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"DataUnit:ParentUnit\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            23\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"DataUnit:CompanyUnit\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            26\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"ContactPerson\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            33\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"query\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                2\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"page\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                0\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"count\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                20\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"ResourceShare\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"RESOURCE_INFO_ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            27\n                                        ]\n                                    },\n                                    \"@column\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            8\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"ResourceApply\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"RESOURCE_ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            27\n                                        ]\n                                    },\n                                    \"APPLY_STATUS\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            1\n                                        ]\n                                    },\n                                    \"@column\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            8\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"total@\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    9\n                ]\n            },\n            \"page@\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    8\n                ]\n            },\n            \"info@\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    8\n                ]\n            }\n        }\n    ]\n}','','2021-10-15 02:41:08',NULL),(1634284944272,1631617361403,0,3,'共享方式新增api','JSON','/resource/apijson/post','{\n    \"ResourceShare\": {\n        \"NAME\": \"数据库共享\",\n        \"DESC\": \"描述\",\n        \"SHARE_TYPE\": \"2\",\n        \"RESOURCE_INFO_ID\": \"1446390805710295041\"\n    },\n    \"ResourceApi\": {\n        \"SHARE_ID@\": \"ResourceShare/ID\",\n        \"API_ADDRESS\": \"http://58.210.9.133:8989/resource/dataUnit/companyList\",\n        \"API_PORT\": \"8989\",\n        \"API_PATH\": \"/resource/dataUnit/companyList\",\n        \"API_REQUEST_METHOD\": \"0\",\n        \"API_REQUEST_TYPE\": \"0\"\n    },\n    \"ResourceInterfaceParam[]\": [\n        {\n            \"SHARE_ID@\": \"ResourceShare/ID\",\n            \"API_ID@\": \"ResourceApi/ID\",\n            \"PARAM_NAME\": \"id\",\n            \"PARAM_DESC\": \"主键id\",\n            \"PARAM_TYPE\": \"0\",\n            \"PARAM_FORM\": \"0\"\n        }\n    ]\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"ResourceShare\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                5\n                            ]\n                        },\n                        \"DESC\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                2\n                            ]\n                        },\n                        \"SHARE_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"RESOURCE_INFO_ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                19\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ResourceApi\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"SHARE_ID@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                16\n                            ]\n                        },\n                        \"API_ADDRESS\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                54\n                            ]\n                        },\n                        \"API_PORT\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                4\n                            ]\n                        },\n                        \"API_PATH\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                30\n                            ]\n                        },\n                        \"API_REQUEST_METHOD\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"API_REQUEST_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ResourceInterfaceParam[]\": {\n                \"notnull\": true,\n                \"type\": \"array\",\n                \"valueLevel\": 0,\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    1\n                ],\n                \"values\": [\n                    {\n                        \"notnull\": true,\n                        \"type\": \"object\",\n                        \"valueLevel\": 0,\n                        \"values\": [\n                            {\n                                \"SHARE_ID@\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        16\n                                    ]\n                                },\n                                \"API_ID@\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        14\n                                    ]\n                                },\n                                \"PARAM_NAME\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        2\n                                    ]\n                                },\n                                \"PARAM_DESC\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        4\n                                    ]\n                                },\n                                \"PARAM_TYPE\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        1\n                                    ]\n                                },\n                                \"PARAM_FORM\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        1\n                                    ]\n                                }\n                            }\n                        ]\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-10-15 08:02:24',NULL),(1634285131571,1631617361403,0,3,'共享方式新增-数据库','JSON','/resource/apijson/post','{\n    \"ResourceShare\": {\n        \"NAME\": \"数据库共享\",\n        \"DESC\": \"描述\",\n        \"SHARE_TYPE\": \"0\",\n        \"RESOURCE_INFO_ID\": \"1446390805710295041\"\n    },\n    \"ResourceDb\": {\n        \"SHARE_ID@\": \"ResourceShare/ID\",\n        \"DB_TYPE\": \"1\",\n        \"DB_ADDRESS\": \"58.210.9.133\",\n        \"DB_NAME\": \"public\",\n        \"DB_URI\": \"jdbc:postgresql://101.133.229.133:5432/postgres\",\n        \"TABLE_NAME\": \"t_car_pass_record\",\n        \"DB_USERNAME\": \"username\",\n        \"DB_PASSWORD\": \"password\"\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"ResourceShare\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                5\n                            ]\n                        },\n                        \"DESC\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                2\n                            ]\n                        },\n                        \"SHARE_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"RESOURCE_INFO_ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                19\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ResourceDb\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"SHARE_ID@\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                16\n                            ]\n                        },\n                        \"DB_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"DB_ADDRESS\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                12\n                            ]\n                        },\n                        \"DB_NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                6\n                            ]\n                        },\n                        \"DB_URI\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                47\n                            ]\n                        },\n                        \"TABLE_NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                17\n                            ]\n                        },\n                        \"DB_USERNAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                8\n                            ]\n                        },\n                        \"DB_PASSWORD\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                8\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-10-15 08:05:31',NULL),(1634286148582,1631617361403,0,3,'共享方式列表','JSON','/resource/apijson/get','{\n    \"[]\": {\n        \"ResourceShare\": {\n            \"RESOURCE_INFO_ID\": \"1446390805710295041\"\n        },\n        \"SysDict:RESOURCE_TYPE\": {\n            \"TYPE\": \"RESOURCE_TYPE\",\n            \"VALUE@\": \"[]/ResourceShare/SHARE_TYPE\"\n        },\n        \"ResourceDb\": {\n            \"SHARE_ID@\": \"[]/ResourceShare/ID\",\n            \"SysDict\": {\n                \"TYPE\": \"QUEUE_TYPE\",\n                \"VALUE@\": \"ResourceTopic/QUEUE_TYPE\"\n            }\n        },\n        \"ResourceTopic\": {\n            \"SHARE_ID@\": \"[]/ResourceShare/ID\",\n            \"SysDict\": {\n                \"TYPE\": \"QUEUE_TYPE\",\n                \"VALUE@\": \"ResourceTopic/QUEUE_TYPE\"\n            }\n        },\n        \"ResourceApi\": {\n            \"SHARE_ID@\": \"[]/ResourceShare/ID\",\n            \"SysDict:API_REQUEST_METHOD\": {\n                \"TYPE\": \"API_REQUEST_METHOD\",\n                \"VALUE@\": \"/API_REQUEST_METHOD\"\n            },\n            \"SysDict:API_REQUEST_TYPE\": {\n                \"TYPE\": \"API_REQUEST_TYPE\",\n                \"VALUE@\": \"/API_REQUEST_TYPE\"\n            }\n        },\n        \"ResourceInterfaceParam[]\": {\n            \"ResourceInterfaceParam\": {\n                \"SHARE_ID@\": \"[]/ResourceShare/ID\",\n                \"SysDict:PARAM_TYPE\": {\n                    \"TYPE\": \"PARAM_TYPE\",\n                    \"VALUE@\": \"/PARAM_TYPE\"\n                }\n            }\n        }\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ResourceShare\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"RESOURCE_INFO_ID\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            19\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"SysDict:RESOURCE_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"TYPE\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            \"RESOURCE_TYPE\"\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            13\n                                        ]\n                                    },\n                                    \"VALUE@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            27\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"ResourceDb\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"SHARE_ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            19\n                                        ]\n                                    },\n                                    \"SysDict\": {\n                                        \"notnull\": true,\n                                        \"type\": \"object\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            {\n                                                \"TYPE\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 0,\n                                                    \"values\": [\n                                                        \"QUEUE_TYPE\"\n                                                    ],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        10\n                                                    ]\n                                                },\n                                                \"VALUE@\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 3,\n                                                    \"values\": [],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        24\n                                                    ]\n                                                }\n                                            }\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"ResourceTopic\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"SHARE_ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            19\n                                        ]\n                                    },\n                                    \"SysDict\": {\n                                        \"notnull\": true,\n                                        \"type\": \"object\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            {\n                                                \"TYPE\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 0,\n                                                    \"values\": [\n                                                        \"QUEUE_TYPE\"\n                                                    ],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        10\n                                                    ]\n                                                },\n                                                \"VALUE@\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 3,\n                                                    \"values\": [],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        24\n                                                    ]\n                                                }\n                                            }\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"ResourceApi\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"SHARE_ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            19\n                                        ]\n                                    },\n                                    \"SysDict:API_REQUEST_METHOD\": {\n                                        \"notnull\": true,\n                                        \"type\": \"object\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            {\n                                                \"TYPE\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 0,\n                                                    \"values\": [\n                                                        \"API_REQUEST_METHOD\"\n                                                    ],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        18\n                                                    ]\n                                                },\n                                                \"VALUE@\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 3,\n                                                    \"values\": [],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        19\n                                                    ]\n                                                }\n                                            }\n                                        ]\n                                    },\n                                    \"SysDict:API_REQUEST_TYPE\": {\n                                        \"notnull\": true,\n                                        \"type\": \"object\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            {\n                                                \"TYPE\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 0,\n                                                    \"values\": [\n                                                        \"API_REQUEST_TYPE\"\n                                                    ],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        16\n                                                    ]\n                                                },\n                                                \"VALUE@\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 3,\n                                                    \"values\": [],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        17\n                                                    ]\n                                                }\n                                            }\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"ResourceInterfaceParam[]\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"ResourceInterfaceParam\": {\n                                        \"notnull\": true,\n                                        \"type\": \"object\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            {\n                                                \"SHARE_ID@\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"string\",\n                                                    \"valueLevel\": 3,\n                                                    \"values\": [],\n                                                    \"lengthLevel\": 1,\n                                                    \"lengths\": [\n                                                        19\n                                                    ]\n                                                },\n                                                \"SysDict:PARAM_TYPE\": {\n                                                    \"notnull\": true,\n                                                    \"type\": \"object\",\n                                                    \"valueLevel\": 0,\n                                                    \"values\": [\n                                                        {\n                                                            \"TYPE\": {\n                                                                \"notnull\": true,\n                                                                \"type\": \"string\",\n                                                                \"valueLevel\": 0,\n                                                                \"values\": [\n                                                                    \"PARAM_TYPE\"\n                                                                ],\n                                                                \"lengthLevel\": 1,\n                                                                \"lengths\": [\n                                                                    10\n                                                                ]\n                                                            },\n                                                            \"VALUE@\": {\n                                                                \"notnull\": true,\n                                                                \"type\": \"string\",\n                                                                \"valueLevel\": 3,\n                                                                \"values\": [],\n                                                                \"lengthLevel\": 1,\n                                                                \"lengths\": [\n                                                                    11\n                                                                ]\n                                                            }\n                                                        }\n                                                    ]\n                                                }\n                                            }\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-10-15 08:22:28',NULL),(1634289945625,1631617361403,0,3,'删除共享方式','JSON','/resource/apijson/delete','{\n    \"deleteShare-()\": \"deleteShare(1634285087560)\",\n    \"ResourceShare\": {\n        \"ID\": \"1634285087560\"\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"deleteShare-()\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    26\n                ]\n            },\n            \"ResourceShare\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                13\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-10-15 09:25:45',NULL),(1634290488064,1631617361403,0,3,'共享方式修改','JSON','/resource/apijson/put','{\n    \"updateShare-()\": \"updateShare(1634285284517)\",\n    \"ResourceShare\": {\n        \"ID\": \"1634285284517\",\n        \"NAME\": \"数据库共享1\",\n        \"DESC\": \"描述1\",\n        \"SHARE_TYPE\": \"0\"\n    },\n    \"ResourceDb-\": {\n        \"SHARE_ID\": \"1634285284517\",\n        \"DB_TYPE\": \"1\",\n        \"DB_ADDRESS\": \"58.210.9.131\",\n        \"DB_NAME\": \"public\",\n        \"DB_URI\": \"jdbc:postgresql://101.133.229.133:5432/postgres1\",\n        \"TABLE_NAME\": \"t_car_pass_record1\",\n        \"DB_USERNAME\": \"username1\",\n        \"DB_PASSWORD\": \"password1\"\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"updateShare-()\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    26\n                ]\n            },\n            \"ResourceShare\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                13\n                            ]\n                        },\n                        \"NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                6\n                            ]\n                        },\n                        \"DESC\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                3\n                            ]\n                        },\n                        \"SHARE_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ResourceDb-\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"SHARE_ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                13\n                            ]\n                        },\n                        \"DB_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"DB_ADDRESS\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                12\n                            ]\n                        },\n                        \"DB_NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                6\n                            ]\n                        },\n                        \"DB_URI\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                48\n                            ]\n                        },\n                        \"TABLE_NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                18\n                            ]\n                        },\n                        \"DB_USERNAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                9\n                            ]\n                        },\n                        \"DB_PASSWORD\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                9\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-10-15 09:34:48',NULL),(1634631929552,1631617361403,0,3,'共享方式修改api','JSON','/resource/apijson/put','{\n    \"updateShare-()\": \"updateShare(1634285121819)\",\n    \"ResourceShare\": {\n        \"ID\": \"1634285121819\",\n        \"NAME\": \"数据库共享1\",\n        \"DESC\": \"描述1\",\n        \"SHARE_TYPE\": \"0\"\n    },\n    \"ResourceApi-\": {\n        \"SHARE_ID\": \"1634285284517\",\n        \"API_ADDRESS\": \"http://58.210.9.133:8989/resource/dataUnit/companyList\",\n        \"API_PORT\": \"8989\",\n        \"API_PATH\": \"/resource/dataUnit/companyList\",\n        \"API_REQUEST_METHOD\": \"0\",\n        \"API_REQUEST_TYPE\": \"0\"\n    },\n    \"ResourceInterfaceParam[]-\": [\n        {\n            \"SHARE_ID\": \"1634285284517\",\n            \"API_ID@\": \"ResourceApi/ID\",\n            \"PARAM_NAME\": \"id\",\n            \"PARAM_DESC\": \"主键id\",\n            \"PARAM_TYPE\": \"0\",\n            \"PARAM_FORM\": \"0\",\n            \"DB_FIELD_NAME\": \"ID\",\n            \"OPERATE_CHAR\": \"0\"\n        }\n    ]\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"updateShare-()\": {\n                \"notnull\": true,\n                \"type\": \"string\",\n                \"valueLevel\": 3,\n                \"values\": [],\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    26\n                ]\n            },\n            \"ResourceShare\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                13\n                            ]\n                        },\n                        \"NAME\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                6\n                            ]\n                        },\n                        \"DESC\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                3\n                            ]\n                        },\n                        \"SHARE_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ResourceApi-\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"SHARE_ID\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                13\n                            ]\n                        },\n                        \"API_ADDRESS\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                54\n                            ]\n                        },\n                        \"API_PORT\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                4\n                            ]\n                        },\n                        \"API_PATH\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                30\n                            ]\n                        },\n                        \"API_REQUEST_METHOD\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        },\n                        \"API_REQUEST_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                1\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"ResourceInterfaceParam[]-\": {\n                \"notnull\": true,\n                \"type\": \"array\",\n                \"valueLevel\": 0,\n                \"lengthLevel\": 1,\n                \"lengths\": [\n                    1\n                ],\n                \"values\": [\n                    {\n                        \"notnull\": true,\n                        \"type\": \"object\",\n                        \"valueLevel\": 0,\n                        \"values\": [\n                            {\n                                \"SHARE_ID\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        13\n                                    ]\n                                },\n                                \"API_ID@\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        14\n                                    ]\n                                },\n                                \"PARAM_NAME\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        2\n                                    ]\n                                },\n                                \"PARAM_DESC\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        4\n                                    ]\n                                },\n                                \"PARAM_TYPE\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        1\n                                    ]\n                                },\n                                \"PARAM_FORM\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        1\n                                    ]\n                                },\n                                \"DB_FIELD_NAME\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 0,\n                                    \"values\": [\n                                        \"ID\"\n                                    ],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        2\n                                    ]\n                                },\n                                \"OPERATE_CHAR\": {\n                                    \"notnull\": true,\n                                    \"type\": \"string\",\n                                    \"valueLevel\": 3,\n                                    \"values\": [],\n                                    \"lengthLevel\": 1,\n                                    \"lengths\": [\n                                        1\n                                    ]\n                                }\n                            }\n                        ]\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-10-19 08:25:29',NULL),(1634655384665,82001,0,3,'获取用户列表带分页信息-简单接口','JSON','/get/User[]','{\n    \"User\": {\n        \"id\": 82001\n    },\n    \"query\": 2\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"User\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"id\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 1,\n                            \"values\": [\n                                82001\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        }\n                    }\n                ]\n            },\n            \"query\": {\n                \"notnull\": true,\n                \"type\": \"integer\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    2\n                ],\n                \"lengthLevel\": 1,\n                \"lengths\": []\n            },\n            \"User[]\": {\n                \"type\": \"object\",\n                \"notnull\": true,\n                \"comment\": \"查用户数组，tag 为 User[]，会自动包装为 \\\"User[]\\\":{ ... }\"\n            }\n        }\n    ]\n}','','2021-10-19 14:56:24','\n简单接口的最外层参数最能放在 URL parameter，例如 format 和 info@\n/get/User[]?format=false&info@=User[]/info'),(1634695467863,1631617361403,0,3,'共享单位列表','JSON','/resource/apijson/get','{\n    \"[]\": {\n        \"ResourceApply\": {\n            \"RESOURCE_ID\": \"1443059665230364673\",\n            \"APPLY_STATUS\": \"1\"\n        },\n        \"DataUnit:ParentUnit\": {\n            \"ID@\": \"[]/ResourceApply/UNIT_ID\"\n        },\n        \"DataUnit:CompanyUnit\": {\n            \"ID@\": \"[]/ResourceApply/COMPANY_ID\"\n        },\n        \"ResourceShare\": {\n            \"ID@\": \"[]/ResourceApply/SHARE_ID\"\n        },\n        \"SysDict:RESOURCE_TYPE\": {\n            \"TYPE\": \"RESOURCE_TYPE\",\n            \"VALUE@\": \"[]/ResourceShare/SHARE_TYPE\"\n        }\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"ResourceApply\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"RESOURCE_ID\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            19\n                                        ]\n                                    },\n                                    \"APPLY_STATUS\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            1\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"DataUnit:ParentUnit\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            24\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"DataUnit:CompanyUnit\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            27\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"ResourceShare\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"ID@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            25\n                                        ]\n                                    }\n                                }\n                            ]\n                        },\n                        \"SysDict:RESOURCE_TYPE\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"TYPE\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 0,\n                                        \"values\": [\n                                            \"RESOURCE_TYPE\"\n                                        ],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            13\n                                        ]\n                                    },\n                                    \"VALUE@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            27\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-10-20 02:04:27',NULL),(1634741164027,82001,0,3,'获取用户-简单接口','JSON','/get/User','{\n    \"id\": 82001\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"id\": {\n                \"notnull\": true,\n                \"type\": \"integer\",\n                \"valueLevel\": 1,\n                \"values\": [\n                    82001\n                ],\n                \"lengthLevel\": 1,\n                \"lengths\": []\n            },\n            \"User\": {\n                \"type\": \"object\",\n                \"notnull\": false,\n                \"comment\": \"用户信息\"\n            }\n        }\n    ]\n}','','2021-10-20 14:46:04',NULL),(1634845547577,88888,0,3,'测试 JSON5 以及单引号','JSON','/get','{\n    \"User\": {\n        \"id\": 82001,\n        \"@column\": \"id;concat(name,\'-\',tag)\"\n    },\n    \"[]\": {\n        \"Comment\": {\n            \"userId@\": \"User/id\"\n        }\n    }\n}','{\n    \"notnull\": true,\n    \"type\": \"object\",\n    \"valueLevel\": 0,\n    \"values\": [\n        {\n            \"User\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"id\": {\n                            \"notnull\": true,\n                            \"type\": \"integer\",\n                            \"valueLevel\": 1,\n                            \"values\": [\n                                82001\n                            ],\n                            \"lengthLevel\": 1,\n                            \"lengths\": []\n                        },\n                        \"@column\": {\n                            \"notnull\": true,\n                            \"type\": \"string\",\n                            \"valueLevel\": 3,\n                            \"values\": [],\n                            \"lengthLevel\": 1,\n                            \"lengths\": [\n                                23\n                            ]\n                        }\n                    }\n                ]\n            },\n            \"[]\": {\n                \"notnull\": true,\n                \"type\": \"object\",\n                \"valueLevel\": 0,\n                \"values\": [\n                    {\n                        \"Comment\": {\n                            \"notnull\": true,\n                            \"type\": \"object\",\n                            \"valueLevel\": 0,\n                            \"values\": [\n                                {\n                                    \"userId@\": {\n                                        \"notnull\": true,\n                                        \"type\": \"string\",\n                                        \"valueLevel\": 3,\n                                        \"values\": [],\n                                        \"lengthLevel\": 1,\n                                        \"lengths\": [\n                                            7\n                                        ]\n                                    }\n                                }\n                            ]\n                        }\n                    }\n                ]\n            }\n        }\n    ]\n}','','2021-10-21 19:45:47',NULL);
/*!40000 ALTER TABLE `Document` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2021-10-23 23:52:34
FilesExpand file tree

sys_Document.sql

Latest commit

History

sys_Document.sql

File metadata and controls
