postgres_sys_Document.sql

create table "Document"
(
    id       bigint                                    not null
        primary key,
    "userId" bigint                                    not null,
    version  smallint                                  not null,
    name     varchar(100)                              not null,
    url      varchar(250)                              not null,
    request  text                                      not null,
    response text,
    header   text,
    date     timestamp,
    apijson  text,
    type     varchar default 'JSON'::character varying not null,
    sqlauto  text
);

comment on column "Document".id is '唯一标识';

comment on column "Document"."userId" is '用户id
		应该用adminId，只有当登录账户是管理员时才能操作文档。
		需要先建Admin表，新增登录等相关接口。';

comment on column "Document".version is '接口版本号
		<=0 - 不限制版本，任意版本都可用这个接口
		>0 - 在这个版本添加的接口';

comment on column "Document".name is '接口名称';

comment on column "Document".url is '请求地址';

comment on column "Document".request is '请求
		用json格式会导致强制排序，而请求中引用赋值只能引用上面的字段，必须有序。';

comment on column "Document".response is '标准返回结果JSON
		用json格式会导致强制排序，而请求中引用赋值只能引用上面的字段，必须有序。';

comment on column "Document".header is '请求头 Request Header： 		key: value //注释';

comment on column "Document".date is '创建时间';

comment on column "Document".apijson is '从 request 映射为实际的 APIJSON 请求 JSON';

comment on column "Document".type is 'PARAM - GET  url parameters,\nFORM - POST  application/www-x-form-url-encoded,\nJSON - POST  application/json';

comment on column "Document".sqlauto is '用于 SQLAuto 测试的 SQL 语句';

alter table "Document"
    owner to postgres;

INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1, 82001, 1, '登录', '/login', '{"type": 0, "phone": "13000082001", "version": 1, "password": "123456"}', null, null, '2017-11-26 07:35:19.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (3, 82001, 1, '退出登录', '/logout', '{}', null, null, '2017-11-26 09:36:10.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1511796208669, 82001, 1, '检查验证码是否存在', '/heads/verify', '{"type": 0, "phone": "13000082001"}', '{"Verify":{"code":200,"msg":"success","count":1},"code":200,"msg":"success"}', null, '2017-11-27 15:23:28.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1511964176688, 82001, 1, '获取评论列表-动态详情页Comment+User', '/get', '{
    "[]": {
        "count": 20,
        "page": 0,
        "Comment": {
            "@order": "date+",
            "momentId": 15
        },
        "User": {
            "id@": "/Comment/userId",
            "@column": "id,name,head"
        }
    }
}', '{"[]":[{"Comment":{"id":176,"toId":166,"userId":38710,"momentId":15,"date":"2017-03-25 20:28:03.0","content":"thank you"},"User":{"id":38710,"name":"TommyLemon","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000"}},{"Comment":{"id":1490863469638,"toId":0,"userId":82002,"momentId":15,"date":"2017-03-30 16:44:29.0","content":"Just do it"},"User":{"id":82002,"name":"Happy~","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000"}},{"Comment":{"id":1490875660259,"toId":1490863469638,"userId":82055,"momentId":15,"date":"2017-03-30 20:07:40.0","content":"I prove wht you said(??????)"},"User":{"id":82055,"name":"Solid","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1508227456407,"toId":0,"userId":82001,"momentId":15,"date":"2017-10-17 16:04:16.0","content":"hsh"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1509346606036,"toId":0,"userId":82001,"momentId":15,"date":"2017-10-30 14:56:46.0","content":"测"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1525933255901,"userId":82001,"momentId":15,"date":"2018-05-10 14:20:55.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1527949266037,"userId":82001,"momentId":15,"date":"2018-06-02 22:21:06.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1528339777338,"userId":82001,"momentId":15,"date":"2018-06-07 10:49:37.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1528366915282,"userId":82001,"momentId":15,"date":"2018-06-07 18:21:55.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1528366931410,"userId":82001,"momentId":15,"date":"2018-06-07 18:22:11.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1528392773597,"userId":82001,"momentId":15,"date":"2018-06-08 01:32:53.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1529034360708,"userId":82001,"momentId":15,"date":"2018-06-15 11:46:00.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1529078537044,"userId":82001,"momentId":15,"date":"2018-06-16 00:02:17.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1529401004622,"userId":82001,"momentId":15,"date":"2018-06-19 17:36:44.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1529401505690,"userId":82001,"momentId":15,"date":"2018-06-19 17:45:05.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1529468113356,"userId":82001,"momentId":15,"date":"2018-06-20 12:15:13.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1529724026842,"userId":82001,"momentId":15,"date":"2018-06-23 11:20:26.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1529909214303,"userId":82001,"momentId":15,"date":"2018-06-25 14:46:54.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1530276831779,"userId":82001,"momentId":15,"date":"2018-06-29 20:53:51.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1531365764793,"userId":82001,"momentId":15,"date":"2018-07-12 11:22:44.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}}],"code":200,"msg":"success"}', null, '2017-11-29 14:02:56.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1511969417632, 82001, 1, '点赞/取消点赞', '/put', '{
    "Moment": {
        "id": 15,
        "praiseUserIdList-": [
            82001
        ]
    },
    "tag": "Moment"
}', '{"Moment":{"code":200,"msg":"success","id":15,"count":1},"code":200,"msg":"success"}', null, '2017-11-29 15:30:17.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1511969630371, 82001, 1, '新增评论', '/post', '{     "Comment": {         "momentId": 15,         "content": "测试新增评论"     },     "tag": "Comment" }', '{"Comment":{"code":200,"msg":"success","id":1533140610714,"count":1},"code":200,"msg":"success"}', null, '2017-11-29 15:33:50.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1511970009071, 82001, 1, '新增动态', '/post', '{     "Moment": {         "content": "测试新增动态",         "pictureList": ["http://static.oschina.net/uploads/user/48/96331_50.jpg"         ]     },     "tag": "Moment" }', '{"Moment":{"code":200,"msg":"success","id":1533140610716,"count":1},"code":200,"msg":"success"}', null, '2017-11-29 15:40:09.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1511970224332, 82001, 1, '修改用户信息', '/put', '{
     "User": {
         "id": 82001,
         "name": "测试账号"
     },
     "tag": "User"
 }', '{"User":{"code":200,"msg":"success","id":82001,"count":1},"code":200,"msg":"success"}', null, '2017-11-29 15:43:44.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1512216131854, 82001, 1, '获取文档列表(即在线解析网页上的文档)-表和字段、请求格式限制', '/get', '{
    "[]": {
        "Table": {
            "TABLE_SCHEMA": "sys",
            "TABLE_TYPE": "BASE TABLE",
            "TABLE_NAME!$": [
                "\\_%",
                "sys\\_%",
                "system\\_%"
            ],
            "@order": "TABLE_NAME+",
            "@column": "TABLE_NAME,TABLE_COMMENT"
        },
        "Column[]": {
            "Column": {
                "TABLE_NAME@": "[]/Table/TABLE_NAME",
                "@column": "COLUMN_NAME,COLUMN_TYPE,IS_NULLABLE,COLUMN_COMMENT"
            }
        }
    },
    "Request[]": {
        "Request": {
            "@order": "version-,method-"
        }
    }
}', null, null, '2017-12-02 12:02:11.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521901518764, 82001, 2, '功能符(对象关键词): ⑤从pictureList获取第0张图片：', '/get', '{     "User": {         "id": 38710,         "@position": 0,         "firstPicture()": "getFromArray(pictureList,@position)"     } }', '{"User":{"id":38710,"sex":0,"name":"TommyLemon","tag":"Android&Java","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","contactIdList":[82003,82005,90814,82004,82009,82002,82044,93793,70793],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0","@position":0,"firstPicture":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000"},"code":200,"msg":"success"}', null, '2018-03-24 14:25:18.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521901610783, 82001, 2, '功能符(对象关键词): ④查询 按userId分组、id最大值>=100 的Moment数组', '/get', '{"[]":{"count":10,"Moment":{"@column":"userId;max(id):maxId","@group":"userId","@having":"maxId>=100"}}}', '{"[]":[{"Moment":{"userId":38710,"maxId":1537025707417}},{"Moment":{"userId":70793,"maxId":551}},{"Moment":{"userId":82001,"maxId":1537025634931}},{"Moment":{"userId":82002,"maxId":1531062713966}},{"Moment":{"userId":82003,"maxId":1536805585275}},{"Moment":{"userId":82045,"maxId":1508073178489}},{"Moment":{"userId":82056,"maxId":1514858533480}},{"Moment":{"userId":93793,"maxId":1516086423441}},{"Moment":{"userId":1520242280259,"maxId":1520242333325}},{"Moment":{"userId":1523626157302,"maxId":1523936332614}}],"code":200,"msg":"success"}', null, '2018-03-24 14:26:50.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521901682845, 82001, 2, '功能符(对象关键词): ③查询按userId分组的Moment数组', '/get', '{"[]":{"count":10,"Moment":{"@column":"userId,id","@group":"userId,id"}}}', '{"[]":[{"Moment":{"userId":38710,"id":235}},{"Moment":{"userId":38710,"id":470}},{"Moment":{"userId":38710,"id":511}},{"Moment":{"userId":38710,"id":595}},{"Moment":{"userId":38710,"id":704}},{"Moment":{"userId":38710,"id":1491200468898}},{"Moment":{"userId":38710,"id":1493835799335}},{"Moment":{"userId":38710,"id":1512314438990}},{"Moment":{"userId":38710,"id":1513094436910}},{"Moment":{"userId":38710,"id":1537025625613}}],"code":200,"msg":"success"}', null, '2018-03-24 14:28:02.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521901746808, 82001, 2, '功能符(对象关键词): ②查询按 name降序、id默认顺序 排序的User数组', '/get', '{"[]":{"count":10,"User":{"@column":"name,id","@order":"name-,id"}}}', '{"[]":[{"User":{"name":"赵钱孙李","id":1508072071492}},{"User":{"name":"测试改名","id":82001}},{"User":{"name":"梦","id":1528264711016}},{"User":{"name":"宁旭","id":1532188114543}},{"User":{"name":"四五六","id":1508072160401}},{"User":{"name":"哈哈哈","id":1524042900591}},{"User":{"name":"周吴郑王","id":1508072105320}},{"User":{"name":"七八九十","id":1508072202871}},{"User":{"name":"一二三","id":1499057230629}},{"User":{"name":"Yong","id":82027}}],"code":200,"msg":"success"}', null, '2018-03-24 14:29:06.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521901787202, 82001, 2, '功能符(对象关键词): ①只查询id,sex,name这几列并且请求结果也按照这个顺序', '/get', '{"User":{"@column":"id,sex,name","id":38710}}', '{"User":{"id":38710,"sex":0,"name":"TommyLemon"},"code":200,"msg":"success"}', null, '2018-03-24 14:29:47.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1511963990071, 82001, 1, '获取动态Moment+User+praiseUserList', '/get', '{
    "Moment": {
        "id": 15
    },
    "User": {
        "id@": "Moment/userId",
        "@column": "id,name,head"
    },
    "User[]": {
        "count": 10,
        "User": {
            "id{}@": "Moment/praiseUserIdList",
            "@column": "id,name"
        }
    }
}', '{"Moment":{"id":15,"userId":70793,"date":"2017-02-08 16:06:11.0","content":"APIJSON is a JSON Transmission Structure Protocol…","praiseUserIdList":[82055,82002,38710],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"]},"User":{"id":70793,"name":"Strong","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000"},"User[]":[{"id":38710,"name":"TommyLemon"},{"id":82002,"name":"Happy~"},{"id":82055,"name":"Solid"}],"code":200,"msg":"success"}', null, '2017-11-29 13:59:50.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521902033331, 82001, 2, '功能符(数组关键词): ③查询User数组和对应的User总数', '/get', '{"[]":{"query":2,"count":5,"User":{}},"total@":"/[]/total"}', '{"[]":[{"User":{"id":38710,"sex":0,"name":"TommyLemon","tag":"Android&Java","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","contactIdList":[82003,82005,90814,82004,82009,82002,82044,93793,70793],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":70793,"sex":0,"name":"Strong","tag":"djdj","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[38710,82002],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/788c0a7e11a","https://camo.githubusercontent.com/f513f67"],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82001,"sex":0,"name":"测试改名","tag":"APIJSON User","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[82025,82024,82003,93793,82012,82028,82021,82006,82030,82035],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82002,"sex":1,"name":"Happy~","tag":"iOS","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000","contactIdList":[82005,82001,38710],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82003,"sex":1,"name":"Wechat","head":"http://common.cnblogs.com/images/wechat.png","contactIdList":[82001,93793],"pictureList":[],"date":"2017-02-01 19:21:50.0"}}],"total":121,"code":200,"msg":"success"}', null, '2018-03-24 14:33:53.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521902069870, 82001, 2, '功能符(数组关键词): ②查询第3页的User数组，每页5个', '/get', '{"[]":{"count":5,"page":3,"User":{}}}', '{"[]":[{"User":{"id":82025,"sex":1,"name":"Tommy","head":"http://static.oschina.net/uploads/user/629/1258821_50.jpg?t=1378063141000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82026,"sex":0,"name":"iOS","head":"http://static.oschina.net/uploads/user/1200/2400261_50.png?t=1439638750000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82027,"sex":0,"name":"Yong","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82028,"sex":1,"name":"gaeg","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82029,"sex":0,"name":"GASG","head":"http://common.cnblogs.com/images/wechat.png","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}}],"code":200,"msg":"success"}', null, '2018-03-24 14:34:29.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521902110679, 82001, 2, '功能符(数组关键词): ①查询User数组，最多5个', '/get', '{"[]":{"count":5,"User":{}}}', '{"[]":[{"User":{"id":38710,"sex":0,"name":"TommyLemon","tag":"Android&Java","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","contactIdList":[82003,82005,90814,82004,82009,82002,82044,93793,70793],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":70793,"sex":0,"name":"Strong","tag":"djdj","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[38710,82002],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/788c0a7e11a","https://camo.githubusercontent.com/f513f67"],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82001,"sex":0,"name":"测试改名","tag":"APIJSON User","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[82025,82024,82003,93793,82012,82028,82021,82006,82030,82035],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82002,"sex":1,"name":"Happy~","tag":"iOS","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000","contactIdList":[82005,82001,38710],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82003,"sex":1,"name":"Wechat","head":"http://common.cnblogs.com/images/wechat.png","contactIdList":[82001,93793],"pictureList":[],"date":"2017-02-01 19:21:50.0"}}],"code":200,"msg":"success"}', null, '2018-03-24 14:35:10.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521904162065, 82001, 2, '功能符: 增加 或 扩展', '/put', '{
    "Moment": {
        "id": 15,
        "praiseUserIdList+": [
            82001
        ]
    },
    "tag": "Moment"
}', '{"Moment":{"code":200,"msg":"success","id":15,"count":1},"code":200,"msg":"success"}', null, '2018-03-24 15:09:22.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521904394041, 82001, 2, '功能符: 正则匹配', '/get', '{"User[]":{"count":3,"User":{"name?":"^[0-9]+$"}}}', '{"User[]":[{"id":90814,"sex":0,"name":"007","head":"http://static.oschina.net/uploads/user/51/102723_50.jpg?t=1449212504000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"id":1528339692804,"sex":1,"name":"568599","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[1528250827953,1528264711016],"date":"2018-06-07 10:48:12.0"}],"code":200,"msg":"success"}', null, '2018-03-24 15:13:14.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521903761688, 82001, 2, '功能符(逻辑运算): ③ ! 非运算', '/head', '{"User":{"id!{}":[82001,38710]}}', '{"User":{"code":200,"msg":"success","count":119},"code":200,"msg":"success"}', null, '2018-03-24 15:02:41.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521903828409, 82001, 2, '功能符(逻辑运算): ② | 或运算', '/head', '{"User":{"id|{}":">90000,<=80000"}}', '{"User":{"code":200,"msg":"success","count":72},"code":200,"msg":"success"}', null, '2018-03-24 15:03:48.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521903882829, 82001, 2, '功能符(逻辑运算): ① & 与运算', '/head', '{"User":{"id&{}":">80000,<=90000"}}', '{"User":{"code":200,"msg":"success","count":49},"code":200,"msg":"success"}', null, '2018-03-24 15:04:42.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521904337053, 82001, 2, '功能符: 新建别名', '/get', '{"Comment":{"@column":"id,toId:parentId","id":51}}', '{"Comment":{"id":51,"parentId":45},"code":200,"msg":"success"}', null, '2018-03-24 15:12:17.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521904437583, 82001, 2, '功能符: 模糊搜索', '/get', '{"User[]":{"count":3,"User":{"name$":"%m%"}}}', '{"User[]":[{"id":38710,"sex":0,"name":"TommyLemon","tag":"Android&Java","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","contactIdList":[82003,82005,90814,82004,82009,82002,82044,93793,70793],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},{"id":82004,"sex":0,"name":"Tommy","tag":"fasef","head":"http://static.oschina.net/uploads/user/1200/2400261_50.png?t=1439638750000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"id":82006,"sex":1,"name":"Meria","head":"http://static.oschina.net/uploads/user/998/1997902_50.jpg?t=1407806577000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}],"code":200,"msg":"success"}', null, '2018-03-24 15:13:57.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521904547991, 82001, 2, '功能符: 引用赋值', '/get', '{"Moment":{
   "userId":38710
},
"User":{
   "id@":"/Moment/userId"
}}', '{"Moment":{"id":235,"userId":38710,"date":"2017-02-08 16:06:11.0","content":"APIJSON,let interfaces and documents go to hell !","praiseUserIdList":[82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_mpwj.jpg","http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000"]},"User":{"id":38710,"sex":0,"name":"TommyLemon","tag":"Android&Java","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","contactIdList":[82003,82005,90814,82004,82009,82002,82044,93793,70793],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"code":200,"msg":"success"}', null, '2018-03-24 15:15:47.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521904653621, 82001, 2, '功能符: 包含选项范围', '/get', '{"User[]":{"count":3,"User":{"contactIdList<>":38710}}}', '{"User[]":[{"id":70793,"sex":0,"name":"Strong","tag":"djdj","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[38710,82002],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/788c0a7e11a","https://camo.githubusercontent.com/f513f67"],"date":"2017-02-01 19:21:50.0"},{"id":82002,"sex":1,"name":"Happy~","tag":"iOS","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000","contactIdList":[82005,82001,38710],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"id":82005,"sex":1,"name":"Jan","tag":"AG","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[82001,38710,1532439021068],"pictureList":[],"date":"2017-02-01 19:21:50.0"}],"code":200,"msg":"success"}', null, '2018-03-24 15:17:33.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521904698934, 82001, 2, '功能符: 匹配条件范围', '/get', '{"User[]":{"count":3,"User":{"id{}":"<=80000,>90000"}}}', '{"User[]":[{"id":38710,"sex":0,"name":"TommyLemon","tag":"Android&Java","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","contactIdList":[82003,82005,90814,82004,82009,82002,82044,93793,70793],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},{"id":70793,"sex":0,"name":"Strong","tag":"djdj","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[38710,82002],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/788c0a7e11a","https://camo.githubusercontent.com/f513f67"],"date":"2017-02-01 19:21:50.0"},{"id":90814,"sex":0,"name":"007","head":"http://static.oschina.net/uploads/user/51/102723_50.jpg?t=1449212504000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}],"code":200,"msg":"success"}', null, '2018-03-24 15:18:18.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521904756673, 82001, 2, '功能符: 查询数组', '/get', '{"User[]":{"count":3,"User":{}}}', '{"User[]":[{"id":38710,"sex":0,"name":"TommyLemon","tag":"Android&Java","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","contactIdList":[82003,82005,90814,82004,82009,82002,82044,93793,70793],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},{"id":70793,"sex":0,"name":"Strong","tag":"djdj","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[38710,82002],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/788c0a7e11a","https://camo.githubusercontent.com/f513f67"],"date":"2017-02-01 19:21:50.0"},{"id":82001,"sex":0,"name":"测试改名","tag":"APIJSON User","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[82025,82024,82003,93793],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"}],"code":200,"msg":"success"}', null, '2018-03-24 15:19:16.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521905680679, 82001, 2, '操作方法(POST):  新增数据', '/post', '{     "Moment": {         "content": "APIJSON,let interfaces and documents go to hell !"     },     "tag": "Moment" }', '{"Moment":{"code":200,"msg":"success","id":1538112282445,"count":1},"code":200,"msg":"success"}', null, '2018-03-24 15:34:40.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521905787849, 82001, 2, '操作方法(HEADS):  安全/私密获取数量，用于获取银行卡数量等 对安全性要求高的数据总数', '/heads', '{
    "Login": {
        "userId": 38710,"type":1
    },
    "tag": "Login"
}', '{"Login":{"code":200,"msg":"success","count":1},"code":200,"msg":"success"}', null, '2018-03-24 15:36:27.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521905868718, 82001, 2, '操作方法(GETS):  安全/私密获取数据，用于获取钱包等 对安全性要求高的数据', '/gets', '{
    "Privacy": {
        "id": 82001
    },
    "tag": "Privacy"
}', '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":9832.86},"code":200,"msg":"success"}', null, '2018-03-24 15:37:48.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521905895590, 82001, 2, '操作方法(HEAD):  普通获取数量，可用浏览器调试', '/head', '{
   "Moment":{
     "userId":38710
   }
}', '{"Moment":{"code":200,"msg":"success","count":10},"code":200,"msg":"success"}', null, '2018-03-24 15:38:15.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521905913187, 82001, 2, '操作方法(GET):  普通获取数据，可用浏览器调试', '/get', '{
   "Moment":{
     "id":235
   }
}', '{"Moment":{"id":235,"userId":38710,"date":"2017-02-08 16:06:11.0","content":"APIJSON,let interfaces and documents go to hell !","praiseUserIdList":[82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_mpwj.jpg","http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000"]},"code":200,"msg":"success"}', null, '2018-03-24 15:38:33.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521906240331, 82001, 2, 'User发布的Moment列表，每个Moment包括 1.发布者User 2.前3条Comment: ③不查已获取的User', '/get', '{
   "[]":{
     "page":0,
     "count":3, 
     "Moment":{
       "userId":38710
     },
     "Comment[]":{
       "count":3,
       "Comment":{
         "momentId@":"[]/Moment/id"
       }
     }
   }
}', '{"[]":[{"Moment":{"id":235,"userId":38710,"date":"2017-02-08 16:06:11.0","content":"APIJSON,let interfaces and documents go to hell !","praiseUserIdList":[82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_mpwj.jpg","http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000"]},"Comment[]":[{"id":160,"toId":0,"userId":82001,"momentId":235,"date":"2017-03-02 13:56:06.0","content":"This is a Content...-160"},{"id":163,"toId":0,"userId":82001,"momentId":235,"date":"2017-03-02 13:56:06.0","content":"This is a Content...-163"},{"id":168,"toId":1490442545077,"userId":82001,"momentId":235,"date":"2017-03-25 19:49:14.0","content":"???"}]},{"Moment":{"id":470,"userId":38710,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-470","praiseUserIdList":[82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172507_Pz9Y.png"]},"Comment[]":[{"id":4,"toId":0,"userId":38710,"momentId":470,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-4"},{"id":22,"toId":221,"userId":82001,"momentId":470,"date":"2017-02-01 19:20:50.0","content":"测试修改评论"},{"id":47,"toId":4,"userId":70793,"momentId":470,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-47"}]},{"Moment":{"id":511,"userId":38710,"date":"2017-02-08 16:06:11.0","praiseUserIdList":[70793,93793,82001],"pictureList":["https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","http://static.oschina.net/uploads/img/201604/22172507_aMmH.jpg","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067"]},"Comment[]":[{"id":178,"userId":38710,"momentId":511,"date":"2017-03-25 20:30:55.0","content":"wbw"},{"id":1490863711703,"toId":0,"userId":70793,"momentId":511,"date":"2017-03-30 16:48:31.0","content":"I hope I can join"},{"id":1490863717947,"toId":178,"userId":70793,"momentId":511,"date":"2017-03-30 16:48:37.0","content":"what?"}]}],"code":200,"msg":"success"}', null, '2018-03-24 15:44:00.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521906265959, 82001, 2, 'User发布的Moment列表，每个Moment包括 1.发布者User 2.前3条Comment: ②省去重复的User', '/get', '{
   "User":{
     "id":38710
   },
   "[]":{
     "page":0,
     "count":3, 
     "Moment":{
       "userId":38710
     }, 
     "Comment[]":{
       "count":3,
       "Comment":{
         "momentId@":"[]/Moment/id"
       }
     }
   }
}', '{"User":{"id":38710,"sex":0,"name":"TommyLemon","tag":"Android&Java","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","contactIdList":[82003,82005,90814,82004,82009,82002,82044,93793,70793],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"[]":[{"Moment":{"id":235,"userId":38710,"date":"2017-02-08 16:06:11.0","content":"APIJSON,let interfaces and documents go to hell !","praiseUserIdList":[82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_mpwj.jpg","http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000"]},"Comment[]":[{"id":160,"toId":0,"userId":82001,"momentId":235,"date":"2017-03-02 13:56:06.0","content":"This is a Content...-160"},{"id":163,"toId":0,"userId":82001,"momentId":235,"date":"2017-03-02 13:56:06.0","content":"This is a Content...-163"},{"id":168,"toId":1490442545077,"userId":82001,"momentId":235,"date":"2017-03-25 19:49:14.0","content":"???"}]},{"Moment":{"id":470,"userId":38710,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-470","praiseUserIdList":[82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172507_Pz9Y.png"]},"Comment[]":[{"id":4,"toId":0,"userId":38710,"momentId":470,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-4"},{"id":22,"toId":221,"userId":82001,"momentId":470,"date":"2017-02-01 19:20:50.0","content":"测试修改评论"},{"id":47,"toId":4,"userId":70793,"momentId":470,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-47"}]},{"Moment":{"id":511,"userId":38710,"date":"2017-02-08 16:06:11.0","praiseUserIdList":[70793,93793,82001],"pictureList":["https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","http://static.oschina.net/uploads/img/201604/22172507_aMmH.jpg","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067"]},"Comment[]":[{"id":178,"userId":38710,"momentId":511,"date":"2017-03-25 20:30:55.0","content":"wbw"},{"id":1490863711703,"toId":0,"userId":70793,"momentId":511,"date":"2017-03-30 16:48:31.0","content":"I hope I can join"},{"id":1490863717947,"toId":178,"userId":70793,"momentId":511,"date":"2017-03-30 16:48:37.0","content":"what?"}]}],"code":200,"msg":"success"}', null, '2018-03-24 15:44:25.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521906517000, 82001, 2, 'User发布的Moment列表，每个Moment包括 1.发布者User 2.前3条Comment: ①指定id', '/get', '{
    "[]": {
        "page": 0,
        "count": 3,
        "Moment":{"userId":38710}, "User":{"id":38710} ,
        "Comment[]": {
            "count": 3,
            "Comment": {
                "momentId@": "[]/Moment/id"
            }
        }
    }
}', '{"[]":[{"Moment":{"id":235,"userId":38710,"date":"2017-02-08 16:06:11.0","content":"APIJSON,let interfaces and documents go to hell !","praiseUserIdList":[82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_mpwj.jpg","http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000"]},"User":{"id":38710,"sex":0,"name":"TommyLemon","tag":"Android&Java","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","contactIdList":[82003,82005,90814,82004,82009,82002,82044,93793,70793],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"Comment[]":[{"id":160,"toId":0,"userId":82001,"momentId":235,"date":"2017-03-02 13:56:06.0","content":"This is a Content...-160"},{"id":163,"toId":0,"userId":82001,"momentId":235,"date":"2017-03-02 13:56:06.0","content":"This is a Content...-163"},{"id":168,"toId":1490442545077,"userId":82001,"momentId":235,"date":"2017-03-25 19:49:14.0","content":"???"}]},{"Moment":{"id":470,"userId":38710,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-470","praiseUserIdList":[82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172507_Pz9Y.png"]},"User":{"id":38710,"sex":0,"name":"TommyLemon","tag":"Android&Java","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","contactIdList":[82003,82005,90814,82004,82009,82002,82044,93793,70793],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"Comment[]":[{"id":4,"toId":0,"userId":38710,"momentId":470,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-4"},{"id":22,"toId":221,"userId":82001,"momentId":470,"date":"2017-02-01 19:20:50.0","content":"测试修改评论"},{"id":47,"toId":4,"userId":70793,"momentId":470,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-47"}]},{"Moment":{"id":511,"userId":38710,"date":"2017-02-08 16:06:11.0","praiseUserIdList":[70793,93793,82001],"pictureList":["https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","http://static.oschina.net/uploads/img/201604/22172507_aMmH.jpg","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067"]},"User":{"id":38710,"sex":0,"name":"TommyLemon","tag":"Android&Java","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","contactIdList":[82003,82005,90814,82004,82009,82002,82044,93793,70793],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"Comment[]":[{"id":178,"userId":38710,"momentId":511,"date":"2017-03-25 20:30:55.0","content":"wbw"},{"id":1490863711703,"toId":0,"userId":70793,"momentId":511,"date":"2017-03-30 16:48:31.0","content":"I hope I can join"},{"id":1490863717947,"toId":178,"userId":70793,"momentId":511,"date":"2017-03-30 16:48:37.0","content":"what?"}]}],"code":200,"msg":"success"}', null, '2018-03-24 15:48:37.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521907303539, 82001, 2, 'User列表', '/get', '{
   "User[]":{
     "page":0,
     "count":3, 
     "User":{
       "sex":0
     }
   }
}', '{"User[]":[{"id":38710,"sex":0,"name":"TommyLemon","tag":"Android&Java","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","contactIdList":[82003,82005,90814,82004,82009,82002,82044,93793,70793],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},{"id":70793,"sex":0,"name":"Strong","tag":"djdj","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[38710,82002],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/788c0a7e11a","https://camo.githubusercontent.com/f513f67"],"date":"2017-02-01 19:21:50.0"},{"id":82001,"sex":0,"name":"测试账号","tag":"Dev","head":"https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png","contactIdList":[82034,82006,82030,82021,82038],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"}],"code":200,"msg":"success","time:start/duration/end":"1556501639031/9/1556501639040","query:depth/max":"3/5","sql:generate/cache/execute/maxExecute":"3/2/1/200"}', null, '2018-03-24 16:01:43.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521904617126, 82001, 2, '功能符: 远程调用函数', '/get', '{     "Moment": {         "id": 301,         "@column": "userId,praiseUserIdList",         "isPraised()": "isContain(praiseUserIdList,userId)"     } }', '{"Moment":{"userId":93793,"praiseUserIdList":[38710,93793,82003,82005,82040,82055,82002,82001],"isPraised":true},"code":200,"msg":"success"}', null, '2018-03-24 15:16:57.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521907009307, 82001, 2, 'Moment列表，每个Moment包括 1.发布者User 2.前3条Comment', '/get', '{
   "[]":{
     "page":0, 
     "count":3, 
     "Moment":{}, 
     "User":{
       "id@":"/Moment/userId"
     },
     "Comment[]":{
       "count":3,
       "Comment":{
         "momentId@":"[]/Moment/id"
       }
     }
   }
}', '{"[]":[{"Moment":{"id":12,"userId":70793,"date":"2017-02-08 16:06:11.0","content":"APIJSON,let interfaces and documents go to hell !","praiseUserIdList":[70793,93793,82044,82040,82055,90814,38710,82002,82006,1508072105320,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/788c0a7e11a4f5aadef3c886f028c79b4808613a/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343932353935372d313732303737333630382e6a7067","http://static.oschina.net/uploads/img/201604/22172507_Pz9Y.png","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067"]},"User":{"id":70793,"sex":0,"name":"Strong","tag":"djdj","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[38710,82002],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/788c0a7e11a","https://camo.githubusercontent.com/f513f67"],"date":"2017-02-01 19:21:50.0"},"Comment[]":[{"id":162,"toId":0,"userId":93793,"momentId":12,"date":"2017-03-06 13:03:45.0","content":"This is a Content...-162"},{"id":164,"toId":0,"userId":93793,"momentId":12,"date":"2017-03-06 13:03:45.0","content":"This is a Content...-164"},{"id":172,"toId":162,"userId":82001,"momentId":12,"date":"2017-03-25 20:22:58.0","content":"OK"}]},{"Moment":{"id":15,"userId":70793,"date":"2017-02-08 16:06:11.0","content":"APIJSON is a JSON Transmission Structure Protocol…","praiseUserIdList":[82002,70793,38710,93793,82001],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"]},"User":{"id":70793,"sex":0,"name":"Strong","tag":"djdj","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[38710,82002],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/788c0a7e11a","https://camo.githubusercontent.com/f513f67"],"date":"2017-02-01 19:21:50.0"},"Comment[]":[{"id":176,"toId":166,"userId":38710,"momentId":15,"date":"2017-03-25 20:28:03.0","content":"thank you"},{"id":1490863469638,"toId":0,"userId":82002,"momentId":15,"date":"2017-03-30 16:44:29.0","content":"Just do it"},{"id":1490875660259,"toId":1490863469638,"userId":82055,"momentId":15,"date":"2017-03-30 20:07:40.0","content":"I prove wht you said(??????)"}]},{"Moment":{"id":32,"userId":82002,"date":"2017-02-08 16:06:11.0","praiseUserIdList":[38710,82002,82001],"pictureList":["https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067","https://camo.githubusercontent.com/5f5c4e0c4dc539c34e8eae8ac0cbc6dccdfee5d3/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343533333831362d323032373434343231382e6a7067","http://static.oschina.net/uploads/img/201604/22172508_mpwj.jpg"]},"User":{"id":82002,"sex":1,"name":"Happy~","tag":"iOS","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000","contactIdList":[82005,82001,38710],"pictureList":[],"date":"2017-02-01 19:21:50.0"},"Comment[]":[{"id":1512035117021,"toId":0,"userId":82001,"momentId":32,"date":"2017-11-30 17:45:17.0","content":"图片看不了啊"},{"id":1512039030970,"toId":1512035117021,"userId":82001,"momentId":32,"date":"2017-11-30 18:50:30.0","content":"一般九宫格图片都是压缩图，分辨率在300*300左右，加载很快，点击放大后才是原图，1080P左右"},{"id":1555557851140,"toId":1512035117021,"userId":82001,"momentId":32,"date":"2019-04-18 11:24:11.0","content":"1545456"}]}],"code":200,"msg":"success","time:start/duration/end":"1556501639028/18/1556501639046","query:depth/max":"5/5","sql:generate/cache/execute/maxExecute":"15/9/6/200"}', null, '2018-03-24 15:56:49.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521907333047, 82001, 2, '获取粉丝的动态列表', '/get', '{     "Moment[]": {         "join": "&/User/id@",         "Moment": {},         "User": {             "id@": "/Moment/userId",             "contactIdList<>": 82001,             "@column": "id"         }     } }', '{"Moment[]":[{"id":32,"userId":82002,"date":"2017-02-08 16:06:11.0","praiseUserIdList":[38710,82002,82001],"pictureList":["https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067","https://camo.githubusercontent.com/5f5c4e0c4dc539c34e8eae8ac0cbc6dccdfee5d3/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343533333831362d323032373434343231382e6a7067","http://static.oschina.net/uploads/img/201604/22172508_mpwj.jpg"]},{"id":371,"userId":82002,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-371","praiseUserIdList":[90814,93793,82003,82005,82006,82040,82002,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","http://static.oschina.net/uploads/img/201604/22172507_aMmH.jpg","http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg"]},{"id":1508053762227,"userId":82003,"date":"2017-10-15 15:49:22.0","content":"我也试试","praiseUserIdList":[1515565976140,82001],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"]},{"id":1508072491570,"userId":82002,"date":"2017-10-15 21:01:31.0","content":"有点冷~","praiseUserIdList":[82001,82002],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"]},{"id":1508073178489,"userId":82045,"date":"2017-10-15 21:12:58.0","content":"发动态","praiseUserIdList":[82001],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"]},{"id":1514017444961,"userId":82002,"date":"2017-12-23 16:24:04.0","content":"123479589679","praiseUserIdList":[82002,1520242280259,82001,70793,1524042900591,1528264711016],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"]},{"id":1531062713966,"userId":82002,"date":"2018-07-08 23:11:53.0","content":"云南好美啊( ◞˟૩˟)◞","praiseUserIdList":[82001,82005,38710,70793,93793,82003,1531969715979],"pictureList":["https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1531072366455&di=c0d4b15b2c4b70aad49e6ae747f60742&imgtype=0&src=http%3A%2F%2Fpic1.win4000.com%2Fwallpaper%2F3%2F57a2a41f57d09.jpg","https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1531072499167&di=5b5621d117edbc5d344a03ba0a6b580b&imgtype=0&src=http%3A%2F%2Fi0.szhomeimg.com%2FUploadFiles%2FBBS%2F2006%2F08%2F05%2F24752199_79122.91.jpg"]},{"id":1536805585275,"userId":82003,"date":"2018-09-13 10:26:25.0","content":"iPhone Xs发布了，大家怎么看？","praiseUserIdList":[82002,82005,70793,82003,82001],"pictureList":["https://pic1.zhimg.com/80/v2-e129b40810070443add1c28e6185c894_hd.jpg"]},{"id":1545564986045,"userId":82003,"date":"2018-12-23 19:36:26.0","content":"测试新增动态","praiseUserIdList":[82001],"pictureList":["http://static.oschina.net/uploads/user/48/96331_50.jpg"]},{"id":1548145750536,"userId":82003,"date":"2019-01-22 16:29:10.0","content":"APIJSON,let interfaces and documents go to hell !","praiseUserIdList":[82001],"pictureList":[]}],"code":200,"msg":"success","time:start/duration/end":"1556501638963/39/1556501639002","query:depth/max":"3/5","sql:generate/cache/execute/maxExecute":"20/16/4/200"}', null, '2018-03-24 16:03:13.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521907317870, 82001, 2, 'Moment和对应的User', '/get', '{
   "Moment":{
     "userId":38710
   }, 
   "User":{
     "id":38710
   }
}', '{"Moment":{"id":235,"userId":38710,"date":"2017-02-08 16:06:11.0","content":"APIJSON,let interfaces and documents go to hell !","praiseUserIdList":[82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_mpwj.jpg","http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000"]},"User":{"id":38710,"sex":0,"name":"TommyLemon","tag":"Android&Java","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","contactIdList":[82003,82005,90814,82004,82009,82002,82044,93793,70793],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"code":200,"msg":"success","time:start/duration/end":"1556501639026/16/1556501639042","query:depth/max":"1/5","sql:generate/cache/execute/maxExecute":"2/0/2/200"}', null, '2018-03-24 16:01:57.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521907333044, 82001, 2, 'User', '/get', '{
   "User":{
     "id":38710
   }
}', '{"User":{"id":38710,"sex":0,"name":"TommyLemon","tag":"Android&Java","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","contactIdList":[82003,82005,90814,82004,82009,82002,82044,93793,70793],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"code":200,"msg":"success","time:start/duration/end":"1556501639010/3/1556501639013","query:depth/max":"1/5","sql:generate/cache/execute/maxExecute":"1/0/1/200"}', null, '2018-03-24 16:02:13.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521907333046, 82001, 2, 'Moment INNER JOIN User LEFT JOIN Comment', '/get', '{
    "[]": {
        "count": 10,
        "page": 0,
        "join": "&/User/id@,</Comment/momentId@",
        "Moment": {
            "@order": "date+"
        },
        "User": {
            "name?": [
                "a",
                "t"
            ],
            "id@": "/Moment/userId",
            "@column": "id,name,head"
        },
        "Comment": {
            "momentId@": "/Moment/id",
            "@column": "id,momentId,content"
        }
    }
}', '{"[]":[{"Moment":{"id":170,"userId":70793,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-73","praiseUserIdList":[82044,82002,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172508_mpwj.jpg"]},"User":{"id":70793,"name":"Strong","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000"},"Comment":{"id":99,"momentId":170,"content":"This is a Content...-99"}},{"Moment":{"id":170,"userId":70793,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-73","praiseUserIdList":[82044,82002,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172508_mpwj.jpg"]},"User":{"id":70793,"name":"Strong","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000"},"Comment":{"id":99,"momentId":170,"content":"This is a Content...-99"}},{"Moment":{"id":371,"userId":82002,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-371","praiseUserIdList":[90814,93793,82003,82005,82006,82040,82002,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","http://static.oschina.net/uploads/img/201604/22172507_aMmH.jpg","http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg"]},"User":{"id":82002,"name":"Happy~","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000"},"Comment":{"id":182,"momentId":371,"content":"hahaha"}},{"Moment":{"id":170,"userId":70793,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-73","praiseUserIdList":[82044,82002,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172508_mpwj.jpg"]},"User":{"id":70793,"name":"Strong","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000"},"Comment":{"id":99,"momentId":170,"content":"This is a Content...-99"}},{"Moment":{"id":371,"userId":82002,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-371","praiseUserIdList":[90814,93793,82003,82005,82006,82040,82002,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","http://static.oschina.net/uploads/img/201604/22172507_aMmH.jpg","http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg"]},"User":{"id":82002,"name":"Happy~","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000"},"Comment":{"id":182,"momentId":371,"content":"hahaha"}},{"Moment":{"id":371,"userId":82002,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-371","praiseUserIdList":[90814,93793,82003,82005,82006,82040,82002,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","http://static.oschina.net/uploads/img/201604/22172507_aMmH.jpg","http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg"]},"User":{"id":82002,"name":"Happy~","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000"},"Comment":{"id":182,"momentId":371,"content":"hahaha"}},{"Moment":{"id":371,"userId":82002,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-371","praiseUserIdList":[90814,93793,82003,82005,82006,82040,82002,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","http://static.oschina.net/uploads/img/201604/22172507_aMmH.jpg","http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg"]},"User":{"id":82002,"name":"Happy~","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000"},"Comment":{"id":182,"momentId":371,"content":"hahaha"}},{"Moment":{"id":371,"userId":82002,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-371","praiseUserIdList":[90814,93793,82003,82005,82006,82040,82002,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","http://static.oschina.net/uploads/img/201604/22172507_aMmH.jpg","http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg"]},"User":{"id":82002,"name":"Happy~","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000"},"Comment":{"id":182,"momentId":371,"content":"hahaha"}},{"Moment":{"id":371,"userId":82002,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-371","praiseUserIdList":[90814,93793,82003,82005,82006,82040,82002,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","http://static.oschina.net/uploads/img/201604/22172507_aMmH.jpg","http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg"]},"User":{"id":82002,"name":"Happy~","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000"},"Comment":{"id":182,"momentId":371,"content":"hahaha"}},{"Moment":{"id":371,"userId":82002,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-371","praiseUserIdList":[90814,93793,82003,82005,82006,82040,82002,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","http://static.oschina.net/uploads/img/201604/22172507_aMmH.jpg","http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg"]},"User":{"id":82002,"name":"Happy~","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000"},"Comment":{"id":182,"momentId":371,"content":"hahaha"}}],"code":200,"msg":"success","time:start/duration/end":"1556501638957/51/1556501639008","query:depth/max":"3/5","sql:generate/cache/execute/maxExecute":"30/27/3/200"}', null, '2018-03-24 16:02:43.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1569382305979, 82001, 2, '测试查询', '/get', '{
    "User": {
        "id": 82001
    },
    "[]": {
        "Comment": {
            "userId@": "User/id"
        }
    }
}', null, '', '2019-09-25 03:31:45.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (2, 82001, 1, '注册(先获取验证码type:1)', '/register', '{
    "Privacy": {
        "phone": "13000083333",
        "_password": "123456"
    },
    "User": {
        "name": "APIJSONUser"
    },
    "verify": "6840"
}', '{"code":412,"msg":"手机号或验证码错误！"}', null, '2017-11-26 06:56:10.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1511689914598, 82001, 1, '获取用户隐私信息', '/gets', '{"tag": "Privacy", "Privacy": {"id": 82001}}', '{"Privacy":{"id":82001,"more":true,"certified":1,"phone":13000082001,"balance":9835.11},"code":200,"msg":"success"}', null, '2017-11-26 09:51:54.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1511796155276, 82001, 1, '获取验证码', '/post/verify', '{"type": 0, "phone": "13000082001"}', '{"Verify":{"id":1533396718012,"type":0,"phone":13000082001,"verify":4995,"date":"2018-08-04 23:31:58.0"},"tag":"Verify","code":200,"msg":"success"}', null, '2017-11-27 15:22:35.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1511796589078, 82001, 1, '修改登录密码(先获取验证码type:2)-手机号+验证码', '/put/password', '{"verify": "10322", "Privacy": {"phone": "13000082001", "_password": "666666"}}', '{"code":412,"msg":"手机号或验证码错误！"}', null, '2017-11-27 15:29:49.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1511796882183, 82001, 1, '充值(需要支付密码)/提现', '/put/balance', '{"tag": "Privacy", "Privacy": {"id": 82001, "balance+": 100.15, "_payPassword": "123456"}}', '{"Privacy":{"code":200,"msg":"success","id":82001,"count":1},"code":200,"msg":"success"}', null, '2017-11-27 15:34:42.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1511963330794, 82001, 2, '获取文档列表(即在线解析网页上的共享)-API调用方式', '/get', '{
    "Document[]": {
        "Document": {
            "@role": "login",
            "@order": "version-,date-"
        }
    }
}', null, null, '2017-11-29 13:48:50.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1511963677324, 82001, 1, '获取用户', '/get', '{"User": {"id": 82001}}', '{"User":{"id":82001,"sex":0,"name":"测试改名","tag":"APIJSON User","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[82025,82024,82003,93793,70793],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"code":200,"msg":"success"}', null, '2017-11-29 13:54:37.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1511963722969, 82001, 1, '获取用户列表("id{}":contactIdList)-朋友页', '/get', '{
    "User[]": {
        "count": 10,
        "page": 0,
        "User": {
            "@column": "id,sex,name,tag,head",
            "@order": "name+",
            "id{}": [
                82002,
                82004,
                70793
            ]
        }
    }
}', '{"User[]":[{"id":82002,"sex":1,"name":"Happy~","tag":"iOS","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000"},{"id":70793,"sex":0,"name":"Strong","tag":"djdj","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000"},{"id":82004,"sex":0,"name":"Tommy","tag":"fasef","head":"http://static.oschina.net/uploads/user/1200/2400261_50.png?t=1439638750000"}],"code":200,"msg":"success"}', null, '2017-11-29 13:55:22.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521907587429, 82001, 2, '获取用户列表', '/get', '{
    "[]": {
        "count": 3,
        "User": {
            "@column": "id,name"
        }
    }
}', '{"[]":[{"User":{"id":38710,"name":"TommyLemon"}},{"User":{"id":70793,"name":"Strong"}},{"User":{"id":82001,"name":"测试账号"}}],"code":200,"msg":"success","time:start/duration/end":"1556501638960/37/1556501638997","query:depth/max":"3/5","sql:generate/cache/execute/maxExecute":"3/2/1/200"}', null, '2018-03-24 16:06:27.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1511967853339, 82001, 1, '获取动态列表Moment+User+User:parise[]+Comment[]', '/get', '{     "[]": {         "count": 5,         "page": 0,         "Moment": {             "@order": "date+"         },         "User": {             "id@": "/Moment/userId",             "@column": "id,name,head"         },         "User[]": {             "count": 10,             "User": {                 "id{}@": "[]/Moment/praiseUserIdList",                 "@column": "id,name"             }         },         "[]": {             "count": 6,             "Comment": {                 "@order": "date+",                 "momentId@": "[]/Moment/id"             },             "User": {                 "id@": "/Comment/userId",                 "@column": "id,name"             }         }     } }', '{"[]":[{"Moment":{"id":301,"userId":93793,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-301","praiseUserIdList":[38710,93793,82003,82005,82040,82055,82002,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg"]},"User":{"id":93793,"name":"Mike","head":"http://static.oschina.net/uploads/user/48/96331_50.jpg"},"User[]":[{"id":38710,"name":"TommyLemon"},{"id":82001,"name":"测试改名"},{"id":82002,"name":"Happy~"},{"id":82003,"name":"Wechat"},{"id":82005,"name":"Jan"},{"id":82040,"name":"Dream"},{"id":82055,"name":"Solid"},{"id":93793,"name":"Mike"}],"[]":[{"Comment":{"id":45,"toId":0,"userId":93793,"momentId":301,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-45"},"User":{"id":93793,"name":"Mike"}},{"Comment":{"id":51,"toId":45,"userId":82003,"momentId":301,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-51"},"User":{"id":82003,"name":"Wechat"}},{"Comment":{"id":76,"toId":45,"userId":93793,"momentId":301,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-76"},"User":{"id":93793,"name":"Mike"}},{"Comment":{"id":120,"toId":0,"userId":93793,"momentId":301,"date":"2017-03-02 13:56:06.0","content":"This is a Content...-110"},"User":{"id":93793,"name":"Mike"}},{"Comment":{"id":124,"toId":0,"userId":82001,"momentId":301,"date":"2017-03-02 13:56:06.0","content":"This is a Content...-114"},"User":{"id":82001,"name":"测试改名"}},{"Comment":{"id":1490781009548,"toId":51,"userId":82001,"momentId":301,"date":"2017-03-29 17:50:09.0","content":"3"},"User":{"id":82001,"name":"测试改名"}}]},{"Moment":{"id":58,"userId":90814,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-435","praiseUserIdList":[38710,82003,82005,93793,82006,82044,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172507_aMmH.jpg"]},"User":{"id":90814,"name":"007","head":"http://static.oschina.net/uploads/user/51/102723_50.jpg?t=1449212504000"},"User[]":[{"id":38710,"name":"TommyLemon"},{"id":82001,"name":"测试改名"},{"id":82003,"name":"Wechat"},{"id":82005,"name":"Jan"},{"id":82006,"name":"Meria"},{"id":82044,"name":"Love"},{"id":93793,"name":"Mike"}],"[]":[{"Comment":{"id":13,"toId":0,"userId":82005,"momentId":58,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-13"},"User":{"id":82005,"name":"Jan"}},{"Comment":{"id":77,"toId":13,"userId":93793,"momentId":58,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-77"},"User":{"id":93793,"name":"Mike"}},{"Comment":{"id":97,"toId":13,"userId":82006,"momentId":58,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-97"},"User":{"id":82006,"name":"Meria"}},{"Comment":{"id":167,"userId":82001,"momentId":58,"date":"2017-03-25 19:48:41.0","content":"Nice!"},"User":{"id":82001,"name":"测试改名"}},{"Comment":{"id":173,"userId":38710,"momentId":58,"date":"2017-03-25 20:25:13.0","content":"Good"},"User":{"id":38710,"name":"TommyLemon"}},{"Comment":{"id":188,"toId":97,"userId":82001,"momentId":58,"date":"2017-03-26 15:21:32.0","content":"1646"},"User":{"id":82001,"name":"测试改名"}}]},{"Moment":{"id":371,"userId":82002,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-371","praiseUserIdList":[90814,93793,82003,82005,82006,82040,82002,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","http://static.oschina.net/uploads/img/201604/22172507_aMmH.jpg","http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg"]},"User":{"id":82002,"name":"Happy~","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000"},"User[]":[{"id":82001,"name":"测试改名"},{"id":82002,"name":"Happy~"},{"id":82003,"name":"Wechat"},{"id":82005,"name":"Jan"},{"id":82006,"name":"Meria"},{"id":82040,"name":"Dream"},{"id":90814,"name":"007"},{"id":93793,"name":"Mike"}],"[]":[{"Comment":{"id":68,"toId":0,"userId":82005,"momentId":371,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-68"},"User":{"id":82005,"name":"Jan"}},{"Comment":{"id":157,"userId":93793,"momentId":371,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-157"},"User":{"id":93793,"name":"Mike"}},{"Comment":{"id":110,"toId":0,"userId":93793,"momentId":371,"date":"2017-02-01 19:23:24.0","content":"This is a Content...-110"},"User":{"id":93793,"name":"Mike"}},{"Comment":{"id":114,"toId":0,"userId":82001,"momentId":371,"date":"2017-03-02 13:56:06.0","content":"This is a Content...-114"},"User":{"id":82001,"name":"测试改名"}},{"Comment":{"id":115,"toId":0,"userId":38710,"momentId":371,"date":"2017-03-02 13:56:06.0","content":"This is a Content...-115"},"User":{"id":38710,"name":"TommyLemon"}},{"Comment":{"id":116,"toId":0,"userId":70793,"momentId":371,"date":"2017-03-02 13:56:06.0","content":"This is a Content...-116"},"User":{"id":70793,"name":"Strong"}}]},{"Moment":{"id":170,"userId":70793,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-73","praiseUserIdList":[82044,82002,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172508_mpwj.jpg"]},"User":{"id":70793,"name":"Strong","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000"},"User[]":[{"id":82001,"name":"测试改名"},{"id":82002,"name":"Happy~"},{"id":82044,"name":"Love"}],"[]":[{"Comment":{"id":44,"toId":0,"userId":82003,"momentId":170,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-44"},"User":{"id":82003,"name":"Wechat"}},{"Comment":{"id":54,"toId":0,"userId":82004,"momentId":170,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-54"},"User":{"id":82004,"name":"Tommy"}},{"Comment":{"id":99,"toId":44,"userId":70793,"momentId":170,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-99"},"User":{"id":70793,"name":"Strong"}},{"Comment":{"id":206,"toId":54,"userId":82001,"momentId":170,"date":"2017-03-29 11:04:23.0","content":"ejej"},"User":{"id":82001,"name":"测试改名"}},{"Comment":{"id":1490780759866,"toId":99,"userId":82001,"momentId":170,"date":"2017-03-29 17:45:59.0","content":"99"},"User":{"id":82001,"name":"测试改名"}},{"Comment":{"id":1490863661426,"toId":1490780759866,"userId":70793,"momentId":170,"date":"2017-03-30 16:47:41.0","content":"66"},"User":{"id":70793,"name":"Strong"}}]},{"Moment":{"id":470,"userId":38710,"date":"2017-02-01 19:14:31.0","content":"This is a Content...-470","praiseUserIdList":[82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172507_Pz9Y.png"]},"User":{"id":38710,"name":"TommyLemon","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000"},"User[]":[{"id":82001,"name":"测试改名"}],"[]":[{"Comment":{"id":4,"toId":0,"userId":38710,"momentId":470,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-4"},"User":{"id":38710,"name":"TommyLemon"}},{"Comment":{"id":22,"toId":221,"userId":82001,"momentId":470,"date":"2017-02-01 19:20:50.0","content":"测试修改评论"},"User":{"id":82001,"name":"测试改名"}},{"Comment":{"id":47,"toId":4,"userId":70793,"momentId":470,"date":"2017-02-01 19:20:50.0","content":"This is a Content...-47"},"User":{"id":70793,"name":"Strong"}},{"Comment":{"id":1490863507114,"toId":4,"userId":82003,"momentId":470,"date":"2017-03-30 16:45:07.0","content":"yes"},"User":{"id":82003,"name":"Wechat"}},{"Comment":{"id":1490863903900,"toId":0,"userId":82006,"momentId":470,"date":"2017-03-30 16:51:43.0","content":"SOGA"},"User":{"id":82006,"name":"Meria"}},{"Comment":{"id":1491740899179,"toId":0,"userId":82001,"momentId":470,"date":"2017-04-09 20:28:19.0","content":"www"},"User":{"id":82001,"name":"测试改名"}}]}],"code":200,"msg":"success"}', null, '2017-11-29 15:04:13.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1511969181103, 82001, 1, '添加朋友', '/put', '{
    "User": {
        "id": 82001,
        "contactIdList+": [93793]
    },
    "tag": "User"
}', '{"User":{"id":82001,"contactIdList+":[93793],"@role":"owner"},"code":409,"msg":"PUT User, contactIdList:93793 已存在！"}', null, '2017-11-29 15:26:21.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521904098110, 82001, 2, '功能符: 减少 或 去除', '/put/balance', '{
    
    "Privacy": {
        "id": 82001,
        "balance+": -100,
        "_payPassword": "123456"
    },"tag": "Privacy"
}', '{"Privacy":{"code":200,"msg":"success","id":82001,"count":1},"code":200,"msg":"success"}', null, '2018-03-24 15:08:18.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521905263827, 82001, 2, '操作方法(DELETE):  删除数据', '/delete', '{
   "Moment":{
     "id":120
   },
   "tag":"Moment"
}', '{"Moment":{"code":404,"msg":"可能对象不存在！","id":120,"count":0},"Comment":{"code":404,"msg":"可能对象不存在！","count":0},"code":200,"msg":"success"}', null, '2018-03-24 15:27:43.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521905599149, 82001, 2, '操作方法(PUT):  修改数据，只修改所传的字段', '/put', '{
   "Moment":{
     "id":235,
     "content":"APIJSON,let interfaces and documents go to hell !"
   },
   "tag":"Moment"
}', '{"Moment":{"code":200,"msg":"success","id":235,"count":1},"code":200,"msg":"success"}', null, '2018-03-24 15:33:19.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521907546128, 82001, 2, '获取类似微信朋友圈的动态列表', '/get', '{
    "[]": {
        "page": 0,
        "count": 2,
        "Moment": {
            "content$": "%a%"
        },
        "User": {
            "id@": "/Moment/userId",
            "@column": "id,name,head"
        },
        "Comment[]": {
            "count": 2,
            "Comment": {
                "momentId@": "[]/Moment/id"
            }
        }
    }
}', '{"[]":[{"Moment":{"id":12,"userId":70793,"date":"2017-02-08 16:06:11.0","content":"APIJSON,let interfaces and documents go to hell !","praiseUserIdList":[70793,93793,82044,82040,82055,90814,38710,82002,82006,1508072105320,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/788c0a7e11a4f5aadef3c886f028c79b4808613a/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343932353935372d313732303737333630382e6a7067","http://static.oschina.net/uploads/img/201604/22172507_Pz9Y.png","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067"]},"User":{"id":70793,"name":"Strong","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000"},"Comment[]":[{"id":162,"toId":0,"userId":93793,"momentId":12,"date":"2017-03-06 13:03:45.0","content":"This is a Content...-162"},{"id":164,"toId":0,"userId":93793,"momentId":12,"date":"2017-03-06 13:03:45.0","content":"This is a Content...-164"}]},{"Moment":{"id":15,"userId":70793,"date":"2017-02-08 16:06:11.0","content":"APIJSON is a JSON Transmission Structure Protocol…","praiseUserIdList":[82002,70793,38710,93793,82001],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"]},"User":{"id":70793,"name":"Strong","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000"},"Comment[]":[{"id":176,"toId":166,"userId":38710,"momentId":15,"date":"2017-03-25 20:28:03.0","content":"thank you"},{"id":1490863469638,"toId":0,"userId":82002,"momentId":15,"date":"2017-03-30 16:44:29.0","content":"Just do it"}]}],"code":200,"msg":"success","time:start/duration/end":"1556501638962/38/1556501639000","query:depth/max":"5/5","sql:generate/cache/execute/maxExecute":"8/4/4/200"}', null, '2018-03-24 16:05:46.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521907570451, 82001, 2, '获取动态及发布者用户', '/get', '{
    "Moment": {},
    "User": {
        "id@": "Moment/userId"
    }
}', '{"Moment":{"id":12,"userId":70793,"date":"2017-02-08 16:06:11.0","content":"APIJSON,let interfaces and documents go to hell !","praiseUserIdList":[70793,93793,82044,82040,82055,90814,38710,82002,82006,1508072105320,82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/788c0a7e11a4f5aadef3c886f028c79b4808613a/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343932353935372d313732303737333630382e6a7067","http://static.oschina.net/uploads/img/201604/22172507_Pz9Y.png","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067"]},"User":{"id":70793,"sex":0,"name":"Strong","tag":"djdj","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[38710,82002],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg","http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg","https://camo.githubusercontent.com/788c0a7e11a","https://camo.githubusercontent.com/f513f67"],"date":"2017-02-01 19:21:50.0"},"code":200,"msg":"success","time:start/duration/end":"1556501638952/40/1556501638992","query:depth/max":"1/5","sql:generate/cache/execute/maxExecute":"2/0/2/200"}', null, '2018-03-24 16:06:10.000000', null, 'JSON', null);
INSERT INTO sys."Document" (id, "userId", version, name, url, request, response, header, date, apijson, type, sqlauto) VALUES (1521907601298, 82001, 2, '获取用户', '/get', '{
  "User":{
  }
}', '{"User":{"id":38710,"sex":0,"name":"TommyLemon","tag":"Android&Java","head":"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","contactIdList":[82003,82005,90814,82004,82009,82002,82044,93793,70793],"pictureList":["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000","http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"code":200,"msg":"success","time:start/duration/end":"1556501638955/17/1556501638972","query:depth/max":"1/5","sql:generate/cache/execute/maxExecute":"1/0/1/200"}', null, '2018-03-24 16:06:41.000000', null, 'JSON', null);