-- SQLINES DEMO *** Distrib 5.7.17, for macos10.12 (x86_64)
--
-- SQLINES DEMO *** Database: sys
-- SQLINES DEMO *** -------------------------------------
-- SQLINES DEMO *** 7.33-log
/* SQLINES DEMO *** ARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/* SQLINES DEMO *** ARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/* SQLINES DEMO *** LLATION_CONNECTION=@@COLLATION_CONNECTION */;
/* SQLINES DEMO *** tf8 */;
/* SQLINES DEMO *** ME_ZONE=@@TIME_ZONE */;
/* SQLINES DEMO *** NE='+00:00' */;
/* SQLINES DEMO *** IQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/* SQLINES DEMO *** REIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/* SQLINES DEMO *** L_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/* SQLINES DEMO *** L_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- SQLINES DEMO *** or table `Document`
--
DROP TABLE IF EXISTS Document;
/* SQLINES DEMO *** cs_client = @@character_set_client */;
/* SQLINES DEMO *** er_set_client = utf8 */;
-- SQLINES LICENSE FOR EVALUATION USE ONLY
CREATE TABLE Document (
id bigint NOT NULL AUTO_INCREMENT ,
userId bigint NOT NULL ,
testAccountId bigint NOT NULL DEFAULT '0' ,
version tinyint NOT NULL DEFAULT '3' ,
name varchar(100) NOT NULL ,
type varchar(5) NOT NULL DEFAULT 'JSON' ,
url varchar(250) NOT NULL ,
request clob NOT NULL ,
standard clob,
header clob ,
date timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ,
PRIMARY KEY (id)
) ;
/* SQLINES DEMO *** er_set_client = @saved_cs_client */;
--
-- SQLINES DEMO *** table `Document`
--
LOCK TABLES Document WRITE;
/* SQLINES DEMO *** `Document` DISABLE KEYS */;
INSERT INTO Document VALUES (1,82001,82001,1,'登录','JSON','/login','{n "type": 0, //密ç 类型，0-登录密ç 1-验è¯ç n "phone": "13000082001", //手机å·n "password": "123456", //登录密ç 或验è¯ç n "version": 1, //版本å·n "remember": false //è®°ä½ç™»å½•n}',NULL,NULL,'2017-11-26 07:35:19'),(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/verifyn}',NULL,NULL,'2017-11-26 07:35:19'),(3,82001,0,1,'退出登录','JSON','/logout','{}',NULL,NULL,'2017-11-26 09:56:10'),(1511689914599,82001,0,1,'获å–用户éšç§ä¿¡æ¯','JSON','/gets','{"tag": "Privacy", "Privacy": {"id": 82001}}',NULL,NULL,'2017-11-26 09:51:54'),(1511796155276,82001,0,1,'获å–验è¯ç ','JSON','/post/verify','{n "type": 0, //类型: 0-登录 1-注册 2-修改登录密ç 3-修改支付密ç n "phone": "13000082001" //手机å·n}',NULL,NULL,'2017-11-27 15:23:28'),(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'),(1511796589078,82001,82001,1,'修改登录密ç (先获å–验è¯ç type:2)-手机å·+验è¯ç ','JSON','/put/password','{n "verify": "10322", //验è¯ç ，需è¦å…ˆè°ƒç”¨æŽ¥å£ /post/verifyn "Privacy": {n "phone": "13000082001",n "_password": "666666"n }n}',NULL,NULL,'2017-11-27 15:23:28'),(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'),(1511969417633,82001,82001,1,'点赞/å–消点赞','JSON','/put','{n "Moment": {n "id": 15,n "praiseUserIdList-": [n 82001n ]n },n "tag": "Moment"n}',NULL,NULL,'2017-11-29 15:30:17'),(1511969630372,82001,82001,1,'新增评论','JSON','/post','{ "Comment": { "momentId": 15, "content": "测试新增评论" }, "tag": "Comment" }',NULL,NULL,'2017-11-29 15:33:50'),(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'),(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'),(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'),(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'),(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'),(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'),(1521901787203,88888,0,2,'功能符(对象关键è¯): â‘ åªæŸ¥è¯¢id,sex,nameè¿™å‡ åˆ—å¹¶ä¸”è¯·æ±‚ç»“æžœä¹ŸæŒ‰ç…§è¿™ä¸ªé¡ºåº','JSON','/get','{"User":{"@column":"id,sex,name","id":38710}}',NULL,NULL,'2018-03-24 14:29:47'),(1521902033332,88888,0,2,'功能符(数组关键è¯): ③查询User数组和对应的User总数','JSON','/get','{"[]":{"query":2,"count":5,"User":{}},"total@":"/[]/total"}',NULL,NULL,'2018-03-24 14:33:53'),(1521902069871,88888,0,2,'功能符(数组关键è¯): ②查询第3页的User数组，æ¯é¡µ5个','JSON','/get','{"[]":{"count":5,"page":3,"User":{}}}',NULL,NULL,'2018-03-24 14:34:29'),(1521902110680,88888,0,2,'功能符(数组关键è¯): ①查询User数组，最多5个','JSON','/get','{"[]":{"count":5,"User":{}}}',NULL,NULL,'2018-03-24 14:35:10'),(1521903761689,88888,0,2,'功能符(逻辑è¿ç®—): â‘¢ ! éžè¿ç®—','JSON','/head','{"User":{"id!{}":[82001,38710]}}',NULL,NULL,'2018-03-24 15:02:41'),(1521903828410,88888,0,2,'功能符(逻辑è¿ç®—): â‘¡ | 或è¿ç®—','JSON','/head','{"User":{"id|{}":">90000,<=80000"}}',NULL,NULL,'2018-03-24 15:03:48'),(1521903882830,88888,0,2,'功能符(逻辑è¿ç®—): â‘ & 与è¿ç®—','JSON','/head','{"User":{"id&{}":">80000,<=90000"}}',NULL,NULL,'2018-03-24 15:04:42'),(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'),(1521904162066,88888,0,2,'功能符: å¢žåŠ æˆ– 扩展','JSON','/put','{n "Moment": {n "id": 15,n "praiseUserIdList+": [n 82001n ]n },n "tag": "Moment"n}',NULL,NULL,'2018-03-24 15:09:22'),(1521904337054,88888,0,2,'功能符: 新建别å','JSON','/get','{"Comment":{"@column":"id,toId:parentId","id":51}}',NULL,NULL,'2018-03-24 15:12:17'),(1521904394042,88888,0,2,'功能符: æ£åˆ™åŒ¹é…','JSON','/get','{"User[]":{"count":3,"User":{"name~":"^[0-9]+$"}}}',NULL,NULL,'2018-03-24 15:13:14'),(1521904437584,88888,0,2,'功能符: 模糊æœç´¢','JSON','/get','{"User[]":{"count":3,"User":{"name$":"%m%"}}}',NULL,NULL,'2018-03-24 15:13:57'),(1521904547992,88888,0,2,'功能符: 引用赋值','JSON','/get','{"Moment":{n "userId":38710n},n"User":{n "id@":"/Moment/userId"n}}',NULL,NULL,'2018-03-24 15:15:47'),(1521904617127,88888,0,2,'功能符: 远程调用函数','JSON','/get','{ "Moment": { "id": 301, "@column": "userId,praiseUserIdList", "isPraised()": "isContain(praiseUserIdList,userId)" } }',NULL,NULL,'2018-03-24 15:16:57'),(1521904653622,88888,0,2,'功能符: 包å«é€‰é¡¹èŒƒå›´','JSON','/get','{"User[]":{"count":3,"User":{"contactIdList<>":38710}}}',NULL,NULL,'2018-03-24 15:17:33'),(1521904698935,88888,0,2,'功能符: 匹é…æ¡ä»¶èŒƒå›´','JSON','/get','{"User[]":{"count":3,"User":{"id{}":"<=80000,>90000"}}}',NULL,NULL,'2018-03-24 15:18:18'),(1521904756674,88888,0,2,'功能符: 查询数组','JSON','/get','{"User[]":{"count":3,"User":{}}}',NULL,NULL,'2018-03-24 15:19:16'),(1521905263828,88888,82001,2,'æ“作方法(DELETE): åˆ é™¤æ•°æ®','JSON','/delete','{n "Moment":{n "id":120n },n "tag":"Moment"n}',NULL,NULL,'2018-03-24 15:27:43'),(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'),(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'),(1521905787850,88888,82001,2,'æ“作方法(HEADS): 安全/ç§å¯†èŽ·å–æ•°é‡ï¼Œç”¨äºŽèŽ·å–银行å¡æ•°é‡ç‰ 对安全性è¦æ±‚高的数æ®æ€»æ•°','JSON','/heads','{n "Login": {n "userId": 38710,"type":1n },n "tag": "Login"n}',NULL,NULL,'2018-03-24 15:36:27'),(1521905868719,88888,82001,2,'æ“作方法(GETS): 安全/ç§å¯†èŽ·å–æ•°æ®ï¼Œç”¨äºŽèŽ·å–é’±åŒ…ç‰ å¯¹å®‰å…¨æ€§è¦æ±‚高的数æ®','JSON','/gets','{n "Privacy": {n "id": 82001n },n "tag": "Privacy"n}',NULL,NULL,'2018-03-24 15:37:48'),(1521905895591,88888,82001,2,'æ“作方法(HEAD): 普通获å–æ•°é‡ï¼Œå¯ç”¨æµè§ˆå™¨è°ƒè¯•','JSON','/head','{n "Moment":{n "userId":38710n }n}',NULL,NULL,'2018-03-24 15:38:15'),(1521905913188,88888,82001,2,'æ“作方法(GET): 普通获å–æ•°æ®ï¼Œå¯ç”¨æµè§ˆå™¨è°ƒè¯•','JSON','/get','{n "Moment":{n "id":235n }n}',NULL,NULL,'2018-03-24 15:38:33'),(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":38710n },n "Comment[]":{n "count":3,n "Comment":{n "momentId@":"[]/Moment/id"n }n }n }n}',NULL,NULL,'2018-03-24 15:44:00'),(1521906265960,88888,0,2,'Userå‘布的Moment列表，æ¯ä¸ªMoment包括 1.å‘布者User 2.å‰3æ¡Comment: â‘¡çœåŽ»é‡å¤çš„User','JSON','/get','{n "User":{n "id":38710n },n "[]":{n "page":0,n "count":3, n "Moment":{n "userId":38710n }, n "Comment[]":{n "count":3,n "Comment":{n "momentId@":"[]/Moment/id"n }n }n }n}',NULL,NULL,'2018-03-24 15:44:25'),(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'),(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'),(1521907303540,88888,0,2,'User列表','JSON','/get','{n "User[]":{n "page":0,n "count":3, n "User":{n "sex":0n }n }n}',NULL,NULL,'2018-03-24 16:01:43'),(1521907317871,88888,0,2,'Moment和对应的User','JSON','/get','{n "Moment":{n "userId":38710n }, n "User":{n "id":38710n }n}',NULL,NULL,'2018-03-24 16:01:57'),(1521907333041,88888,0,2,'User','JSON','/get','{n "User":{n "id":38710n }n}',NULL,NULL,'2018-03-24 16:02:13'),(1521907333043,88888,82002,3,'微信个人资料-用户信æ¯+最近3个有照片的动æ€çš„第0å¼ ç…§ç‰‡','JSON','/get','{n "User": {n "id": 82002n },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'),(1521907333044,82001,82002,3,'微信个人资料-用户信æ¯+最近3个有照片的动æ€çš„第0å¼ ç…§ç‰‡','JSON','/get','{r "User": {r "id": 82002r },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'),(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'),(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'),(1521907570452,88888,0,2,'获å–动æ€åŠå‘布者用户','JSON','/get','{n "Moment": {},n "User": {n "id@": "Moment/userId"n }n}',NULL,NULL,'2018-03-24 16:06:10'),(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'),(1521907601299,88888,0,2,'获å–用户','JSON','/get','{n "User":{n }n}',NULL,NULL,'2018-03-24 16:06:41'),(1522905263828,82001,0,2,'æ“作方法(DELETE): åˆ é™¤æ•°æ®','JSON','/delete','{n "Moment":{n "id":120n },n "tag":"Moment"n}',NULL,NULL,'2018-03-24 13:27:43'),(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'),(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'),(1522905787850,82001,0,2,'æ“作方法(HEADS): 安全/ç§å¯†èŽ·å–æ•°é‡ï¼Œç”¨äºŽèŽ·å–银行å¡æ•°é‡ç‰ 对安全性è¦æ±‚高的数æ®æ€»æ•°','JSON','/heads','{n "Login": {n "userId": 38710,"type":1n },n "tag": "Login"n}',NULL,NULL,'2018-03-24 13:36:27'),(1522905868719,82001,0,2,'æ“作方法(GETS): 安全/ç§å¯†èŽ·å–æ•°æ®ï¼Œç”¨äºŽèŽ·å–é’±åŒ…ç‰ å¯¹å®‰å…¨æ€§è¦æ±‚高的数æ®','JSON','/gets','{n "Privacy": {n "id": 82001n },n "tag": "Privacy"n}',NULL,NULL,'2018-03-24 13:37:48'),(1522905895591,82001,0,2,'æ“作方法(HEAD): 普通获å–æ•°é‡ï¼Œå¯ç”¨æµè§ˆå™¨è°ƒè¯•','JSON','/head','{n "Moment":{n "userId":38710n }n}',NULL,NULL,'2018-03-24 13:38:15'),(1522905913188,82001,0,2,'æ“作方法(GET): 普通获å–æ•°æ®ï¼Œå¯ç”¨æµè§ˆå™¨è°ƒè¯•','JSON','/get','{n "Moment":{n "id":235n }n}',NULL,NULL,'2018-03-24 13:38:33'),(1544881887527,88888,0,3,'Moment INNER JOIN User LEFT JOIN Comment','JSON','/get','{n "[]": {n "count": 10,n "page": 0,n "join": "&/User/id@,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'),(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'),(1544883352884,88888,0,3,'Moment90000,<=80000"}}',NULL,NULL,'2018-03-24 15:03:48'),(1546903882830,82001,0,2,'功能符(逻辑è¿ç®—): â‘ & 与è¿ç®—','JSON','/head','{"User":{"id&{}":">80000,<=90000"}}',NULL,NULL,'2018-03-24 15:04:42'),(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'),(1546904162066,82001,82001,2,'功能符: å¢žåŠ æˆ– 扩展','JSON','/put','{n "Moment": {n "id": 15,n "praiseUserIdList+": [n 82001n ]n },n "tag": "Moment"n}',NULL,NULL,'2018-03-24 15:09:22'),(1546904337054,82001,0,2,'功能符: 新建别å','JSON','/get','{"Comment":{"@column":"id,toId:parentId","id":51}}',NULL,NULL,'2018-03-24 15:12:17'),(1546904394042,82001,0,2,'功能符: æ£åˆ™åŒ¹é…','JSON','/get','{"User[]":{"count":3,"User":{"name~":"^[0-9]+$"}}}',NULL,NULL,'2018-03-24 15:13:14'),(1546904437584,82001,0,2,'功能符: 模糊æœç´¢','JSON','/get','{"User[]":{"count":3,"User":{"name$":"%m%"}}}',NULL,NULL,'2018-03-24 15:13:57'),(1546904547992,82001,0,2,'功能符: 引用赋值','JSON','/get','{"Moment":{n "userId":38710n},n"User":{n "id@":"/Moment/userId"n}}',NULL,NULL,'2018-03-24 15:15:47'),(1546904617127,82001,0,2,'功能符: 远程调用函数','JSON','/get','{ "Moment": { "id": 301, "@column": "userId,praiseUserIdList", "isPraised()": "isContain(praiseUserIdList,userId)" } }',NULL,NULL,'2018-03-24 15:16:57'),(1546904653622,82001,0,2,'功能符: 包å«é€‰é¡¹èŒƒå›´','JSON','/get','{"User[]":{"count":3,"User":{"contactIdList<>":38710}}}',NULL,NULL,'2018-03-24 15:17:33'),(1546904698935,82001,0,2,'功能符: 匹é…æ¡ä»¶èŒƒå›´','JSON','/get','{"User[]":{"count":3,"User":{"id{}":"<=80000,>90000"}}}',NULL,NULL,'2018-03-24 15:18:18'),(1546904756674,82001,0,2,'功能符: 查询数组','JSON','/get','{"User[]":{"count":3,"User":{}}}',NULL,NULL,'2018-03-24 15:19:16'),(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'),(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'),(1548728831507,82001,82001,3,'get test','JSON','/get','{n "User": {n "id": 82001n },n "[]": {n "Comment": {n "userId@": "User/id"n }n }n}',NULL,NULL,'2019-01-29 02:27:11'),(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 "[]": {n "User": {n "id{}@": "subquery",n "@column": "id,sex,name"n }n }n}',NULL,NULL,'2018-02-24 14:28:18'),(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'),(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}',NULL,NULL,'2018-02-24 14:28:18'),(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'),(1558944411696,82001,82001,3,'å…³è”查询 Comment.userId = User.id','JSON','/get','{n "User": {n "id": 82001n },n "[]": {n "Comment": {n "userId@": "User/id"n }n }n}',NULL,NULL,'2019-05-27 08:06:51'),(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'),(1560075285563,82001,0,3,'Comment JOIN User','JSON','/get','{n "[]": {n "join": "0",...',NULL,NULL,'2019-07-29 08:43:18'),(1564483634864,1564369325432,0,2,'æ“作方法(DELETE): åˆ é™¤æ•°æ®','JSON','/delete','{r "Moment":{r "id":120r },r "tag":"Moment"r }',NULL,NULL,'2019-07-29 08:43:18'),(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'),(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'),(1564483634867,1564369325432,0,2,'æ“作方法(HEADS): 安全/ç§å¯†èŽ·å–æ•°é‡ï¼Œç”¨äºŽèŽ·å–银行å¡æ•°é‡ç‰ 对安全性è¦æ±‚高的数æ®æ€»æ•°','JSON','/heads','{r "Login": {r "userId": 38710,"type":1r },r "tag": "Login"r }',NULL,NULL,'2019-07-29 08:43:18'),(1564483634868,1564369325432,0,2,'æ“作方法(GETS): 安全/ç§å¯†èŽ·å–æ•°æ®ï¼Œç”¨äºŽèŽ·å–é’±åŒ…ç‰ å¯¹å®‰å…¨æ€§è¦æ±‚高的数æ®','JSON','/gets','{r "Privacy": {r "id": 82001r },r "tag": "Privacy"r }',NULL,NULL,'2019-07-29 08:43:18'),(1564483634869,1564369325432,0,2,'æ“作方法(HEAD): 普通获å–æ•°é‡ï¼Œå¯ç”¨æµè§ˆå™¨è°ƒè¯•','JSON','/head','{r "Moment":{r "userId":38710r }r }',NULL,NULL,'2019-07-29 08:43:18'),(1564483634870,1564369325432,0,2,'æ“作方法(GET): 普通获å–æ•°æ®ï¼Œå¯ç”¨æµè§ˆå™¨è°ƒè¯•','JSON','/get','{r "Moment":{r "id":235r }r }',NULL,NULL,'2019-07-29 08:43:18'),(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'),(1564483634872,1564369325432,82001,3,'获å–动æ€åŠå‘布者用户','JSON','/get','{r "Moment": {},r "User": {r "id@": "Moment/userId"r }r }',NULL,NULL,'2019-07-29 08:43:18'),(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'),(1564483634874,1564369325432,82001,3,'获å–用户','JSON','/get','{r "User":{r }r }',NULL,NULL,'2019-07-29 08:43:18'),(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'),(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'),(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'),(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'),(1564483634879,1564369325432,0,1,'Moment INNER JOIN User LEFT JOIN Comment','JSON','/get','{r "[]": {r "count": 10,r "page": 0,r "join": "&/User/id@,90000,<=80000"}}',NULL,NULL,'2019-07-29 08:43:18'),(1564483634893,1564369325432,0,2,'功能符(逻辑è¿ç®—): â‘ & 与è¿ç®—','JSON','/head','{"User":{"id&{}":">80000,<=90000"}}',NULL,NULL,'2019-07-29 08:43:18'),(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'),(1564483634895,1564369325432,82001,2,'功能符: å¢žåŠ æˆ– 扩展','JSON','/put','{r "Moment": {r "id": 15,r "praiseUserIdList+": [r 82001r ]r },r "tag": "Moment"r }',NULL,NULL,'2019-07-29 08:43:18'),(1564483634896,1564369325432,0,2,'功能符: 新建别å','JSON','/get','{"Comment":{"@column":"id,toId:parentId","id":51}}',NULL,NULL,'2019-07-29 08:43:18'),(1564483634897,1564369325432,0,2,'功能符: æ£åˆ™åŒ¹é…','JSON','/get','{"User[]":{"count":3,"User":{"name~":"^[0-9]+$"}}}',NULL,NULL,'2019-07-29 08:43:18'),(1564483634898,1564369325432,0,2,'功能符: 模糊æœç´¢','JSON','/get','{"User[]":{"count":3,"User":{"name$":"%m%"}}}',NULL,NULL,'2019-07-29 08:43:18'),(1564483634899,1564369325432,0,2,'功能符: 引用赋值','JSON','/get','{"Moment":{r "userId":38710r },r "User":{r "id@":"/Moment/userId"r }}',NULL,NULL,'2019-07-29 08:43:18'),(1564483634900,1564369325432,0,2,'功能符: 远程调用函数','JSON','/get','{ "Moment": { "id": 301, "@column": "userId,praiseUserIdList", "isPraised()": "isContain(praiseUserIdList,userId)" } }',NULL,NULL,'2019-07-29 08:43:18'),(1564483634901,1564369325432,0,2,'功能符: 包å«é€‰é¡¹èŒƒå›´','JSON','/get','{"User[]":{"count":3,"User":{"contactIdList<>":38710}}}',NULL,NULL,'2019-07-29 08:43:18'),(1564483634902,1564369325432,0,2,'功能符: 匹é…æ¡ä»¶èŒƒå›´','JSON','/get','{"User[]":{"count":3,"User":{"id{}":"<=80000,>90000"}}}',NULL,NULL,'2019-07-29 08:43:18'),(1564483634903,1564369325432,0,2,'功能符: 查询数组','JSON','/get','{"User[]":{"count":3,"User":{}}}',NULL,NULL,'2019-07-29 08:43:18'),(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'),(1564483634905,1564369325432,82001,3,'get test','JSON','/get','{r "User": {r "id": 82001r },r "[]": {r "Comment": {r "userId@": "User/id"r }r }r }',NULL,NULL,'2019-07-29 08:43:18'),(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'),(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'),(1564483634908,1564369325432,82001,3,'å…³è”查询 Comment.userId = User.id','JSON','/get','{r "User": {r "id": 82001r },r "[]": {r "Comment": {r "userId@": "User/id"r }r }r }',NULL,NULL,'2019-07-29 08:43:18'),(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'),(1564483634910,1564369325432,0,3,'Comment JOIN User','JSON','/get','{r "[]": {r "join": "": 0n }n },n "@explain": truen}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'),(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'),(1584118278602,2000,0,3,'SIDE JOIN 实现å¯èƒ½æœ‰è¯¯','JSON','/get','{n "[]": {n "join": "^/User/id@",n "Comment": {n "momentId": 12n },n "User": {n "id@": "/Comment/toId",n "sex": 0n }n },n "@explain": truen}n/*n SIDE JOIN 实现å¯èƒ½æœ‰è¯¯ï¼Œå¹¶ä¸”性能ä¸å¤§å¥½ã€‚n Comment çš„æ¡ä»¶ A: momentId=12n User çš„æ¡ä»¶ B: sex=0n ç†è®ºä¸Š 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 0n 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 0n*/',NULL,'','2020-03-13 16:51:18'),(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": truen}',NULL,'','2020-03-13 17:36:11'),(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": truen}',NULL,'','2020-03-13 17:36:30'),(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": truen}',NULL,'','2020-03-13 17:37:06'),(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'),(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": nulln },n "timestamp": "2020-06-19 11:46:52"n }n}n n',NULL,'','2020-06-19 05:52:23'),(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": nulln },n "timestamp": "2020-06-19 11:46:52"n }n}n n',NULL,'','2020-06-19 05:53:27'),(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'),(1593973606841,1593972128383,0,3,'get1','JSON','/get','{n "User": {n "id": 82001n },n "[]": {n "Comment": {n "userId@": "User/id"n }n }n}n n',NULL,'','2020-07-05 18:26:46'),(1593973707836,1593972128383,0,3,'get1','JSON','/get','{n "User": {n "id": 82001n },n "[]": {//ooon "Comment": {n "userId@": "User/id"n }n }n}n n',NULL,'','2020-07-05 18:28:27'),(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'),(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'),(1602231365650,2020,0,3,'JOIN 对象支æŒåŒ…å«å¤šä¸ª @ 引用赋值 çš„å—段','JSON','/get','{ // 自动åˆå¹¶ ON Method.class = `Method:group`.class AND Method.package = `Method:group`.packagen "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": nulln },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'),(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": truen}n n',NULL,'','2020-12-13 17:49:46'),(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": truen}n n',NULL,'','2020-12-13 17:50:43'),(1607881872995,99999,0,3,'最近7天','JSON','/get','{n "Comment": {n "@having": "to_days(now())-to_days(`date`)<=7",n "@raw": "@having"n },n "@explain": truen}n n',NULL,'','2020-12-13 17:51:12'),(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": truen}n n',NULL,'','2020-12-13 17:52:12'),(1608087204039,82001,0,3,'get','JSON','/get','{n "Moment": {n "id": 12n }n}',NULL,'','2020-12-16 02:53:24'),(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": truen}n n',NULL,'','2020-12-26 15:16:03'),(1612031683609,88888,0,2,'视图表 ViewTable 查å•æ¡è®°å½• /get','JSON','/get','{n "ViewTable": {"id": 82001}n}n n',NULL,'','2019-07-29 08:43:18'),(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'),(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'),(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'),(1612031683613,88888,0,2,'视图表 ViewTable LEFT JOIN Moment','JSON','/get','{n "[]": {n "join": "