postgres_sys_TestRecord.sql

create table "TestRecord"
(
    id           bigint       not null
        constraint "TestRecord_pkey"
            primary key,
    "userId"     bigint       not null,
    "documentId" bigint       not null,
    response     text         not null,
    date         timestamp(6) not null,
    compare      text,
    standard     text
);

comment on table "TestRecord" is '测试记录
主要用于保存自动化接口回归测试';

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

comment on column "TestRecord"."userId" is '用户id';

comment on column "TestRecord"."documentId" is '测试用例文档id';

comment on column "TestRecord".response is '接口返回结果JSON';

comment on column "TestRecord".date is '创建日期';

comment on column "TestRecord".compare is '对比结果';

comment on column "TestRecord".standard is 'response 的校验标准，是一个 JSON 格式的 AST ，描述了正确 Response 的结构、里面的字段名称、类型、长度、取值范围 等属性。';

alter table "TestRecord"
    owner to postgres;

INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520087199083, 82001, 1519526273822, '{"[]":[{"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,93793],"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"}},{"User":{"id":82005,"sex":1,"name":"Jan","tag":"AG","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[82001,38710],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"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"}},{"User":{"id":82021,"sex":1,"name":"Tommy","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"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":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":82030,"sex":1,"name":"Fun","head":"http://static.oschina.net/uploads/user/998/1997902_50.jpg?t=1407806577000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82033,"sex":1,"name":"GAS","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82034,"sex":1,"name":"Jump","head":"http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82035,"sex":1,"name":"Tab","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":82039,"sex":1,"name":"Everyday","head":"http://common.cnblogs.com/images/icon_weibo_24.png","contactIdList":[],"pictureList":[],"date":"2017-02-19 21:57:56.0"}},{"User":{"id":82040,"sex":1,"name":"Dream","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793],"pictureList":[],"date":"2017-03-03 00:44:26.0"}},{"User":{"id":82042,"sex":1,"name":"Why","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[],"pictureList":[],"date":"2017-03-04 18:04:33.0"}},{"User":{"id":82044,"sex":1,"name":"Love","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000","contactIdList":[82006],"pictureList":[],"date":"2017-03-04 18:20:27.0"}},{"User":{"id":82055,"sex":1,"name":"Solid","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[38710,82002],"pictureList":[],"date":"2017-03-11 23:04:00.0"}},{"User":{"id":82056,"sex":1,"name":"IronMan","head":"http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000","contactIdList":[],"pictureList":[],"date":"2017-03-11 23:32:25.0"}},{"User":{"id":82059,"sex":1,"name":"He&She","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[],"pictureList":[],"date":"2017-03-19 22:49:15.0"}},{"User":{"id":82060,"sex":1,"name":"Anyway~","head":"http://static.oschina.net/uploads/user/1/3064_50.jpg?t=1449566001000","contactIdList":[],"pictureList":[],"date":"2017-03-21 22:10:18.0"}},{"User":{"id":1490109742863,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-03-21 23:22:22.0"}},{"User":{"id":1490420651686,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793],"pictureList":[],"date":"2017-03-25 13:44:11.0"}},{"User":{"id":1490973670928,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793,93793],"pictureList":[],"date":"2017-03-31 23:21:10.0"}},{"User":{"id":1508072105320,"sex":1,"name":"周吴郑王","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-10-15 20:55:05.0"}}],"code":200,"msg":"success"}', '2018-03-03 14:26:39.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520087202299, 82001, 1519368532249, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":21927.05},"code":200,"msg":"success"}', '2018-03-03 14:26:42.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520087205329, 82001, 1511969630372, '{"Comment":{"code":200,"msg":"success","id":1520087181598,"count":1},"code":200,"msg":"success"}', '2018-03-03 14:26:45.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520088798322, 82001, 1519526273822, '{"Document[]":[{"id":1519526273822,"userId":82001,"version":2,"compare":2,"name":"gets请求","url":"/gets","request":"{
    "Privacy": {
        "id": 82001
    },
    "tag": "Privacy"
}","date":"2018-02-25 10:37:53.0"},{"id":1519368532249,"userId":82001,"version":2,"compare":1,"name":"login请求","url":"/login","request":"{
    "type": 0,
    "phone": "13000082001",
    "password": "123456",
    "version": 1
}","date":"2018-02-23 14:48:52.0"},{"id":1516325614520,"userId":82001,"version":2,"compare":0,"name":"get请求","url":"/get","request":"        {
          "[]":{
            "User":{
              "sex":1
            }
          }
        }
      ","date":"2018-01-19 09:33:34.0"},{"id":1511963330795,"userId":0,"version":2,"compare":0,"name":"获取文档列表(即在线解析网页上的共享)-API调用方式","url":"/get","request":"{
    "Document[]": {
        "Document": {
            "@role": "login",
            "@order": "version-,date-"
        }
    }
}","date":"2017-11-29 21:48:50.0"},{"id":1512216131855,"userId":0,"version":1,"compare":0,"name":"获取文档列表(即在线解析网页上的文档)-表和字段、请求格式限制","url":"/get","request":"{
    "[]": {
        "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-"
        }
    }
}","date":"2017-12-02 20:02:11.0"},{"id":1511970224333,"userId":0,"version":1,"compare":3,"name":"修改用户信息","url":"/put","request":"{
    "User": {
        "id": 82001,
        "name": "测试改名"
    },
    "tag": "User"
}","date":"2017-11-29 23:43:44.0"},{"id":1511970009072,"userId":0,"version":1,"compare":0,"name":"新增动态","url":"/post","request":"{
    "Moment": {
        "userId": 82001,
        "content": "测试新增动态",
        "pictureList": ["http://static.oschina.net/uploads/user/48/96331_50.jpg"
        ]
    },
    "tag": "Moment"
}","date":"2017-11-29 23:40:09.0"},{"id":1511969630372,"userId":0,"version":1,"compare":4,"name":"新增评论","url":"/post","request":"{
    "Comment": {
        "userId": 82001,
        "momentId": 15,
        "content": "测试新增评论"
    },
    "tag": "Comment"
}","date":"2017-11-29 23:33:50.0"},{"id":1511969417633,"userId":0,"version":1,"compare":0,"name":"点赞/取消点赞","url":"/put","request":"{
    "Moment": {
        "id": 15,
        "praiseUserIdList-": [
            82001
        ]
    },
    "tag": "Moment"
}","date":"2017-11-29 23:30:17.0"},{"id":1511969181104,"userId":0,"version":1,"compare":0,"name":"添加朋友","url":"/put","request":"{
    "User": {
        "id": 82001,
        "contactIdList+": [93793]
    },
    "tag": "User"
}","date":"2017-11-29 23:26:21.0"},{"id":1511967853340,"userId":0,"version":1,"compare":0,"name":"获取动态列表Moment+User+User:parise[]+Comment[]","url":"/get","request":"{
    "[]": {
        "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"
            }
        }
    }
}","date":"2017-11-29 23:04:13.0"},{"id":1511964176689,"userId":0,"version":1,"compare":0,"name":"获取评论列表-动态详情页Comment+User","url":"/get","request":"{
    "[]": {
        "count": 20,
        "page": 0,
        "Comment": {
            "@order": "date+",
            "momentId": 15
        },
        "User": {
            "id@": "/Comment/userId",
            "@column": "id,name,head"
        }
    }
}","date":"2017-11-29 22:02:56.0"},{"id":1511963990072,"userId":0,"version":1,"compare":0,"name":"获取动态Moment+User+praiseUserList","url":"/get","request":"{
    "Moment": {
        "id": 15
    },
    "User": {
        "id@": "Moment/userId",
        "@column": "id,name,head"
    },
    "User[]": {
        "count": 10,
        "User": {
            "id{}@": "Moment/praiseUserIdList",
            "@column": "id,name"
        }
    }
}","date":"2017-11-29 21:59:50.0"},{"id":1511963722970,"userId":0,"version":1,"compare":0,"name":"获取用户列表("id{}":contactIdList)-朋友页","url":"/get","request":"{
    "User[]": {
        "count": 10,
        "page": 0,
        "User": {
            "@column": "id,sex,name,tag,head",
            "@order": "name+",
            "id{}": [
                82002,
                82004,
                70793
            ]
        }
    }
}","date":"2017-11-29 21:55:22.0"},{"id":1511963677325,"userId":0,"version":1,"compare":1,"name":"获取用户","url":"/get","request":"{"User": {"id": 82001}}","date":"2017-11-29 21:54:37.0"},{"id":1511796882184,"userId":0,"version":1,"compare":0,"name":"充值(需要支付密码)/提现","url":"/put/balance","request":"{"tag": "Privacy", "Privacy": {"id": 82001, "balance+": 100.15, "_payPassword": "123456"}}","date":"2017-11-27 23:34:42.0"},{"id":1511796589079,"userId":0,"version":1,"compare":0,"name":"修改登录密码(先获取验证码type:2)-手机号+验证码","url":"/put/password","request":"{"verify": "10322", "Privacy": {"phone": "13000082001", "_password": "666666"}}","date":"2017-11-27 23:29:49.0"},{"id":1511796208670,"userId":0,"version":1,"compare":0,"name":"检查验证码是否存在","url":"/heads/verify","request":"{"type": 0, "phone": "13000082001"}","date":"2017-11-27 23:23:28.0"},{"id":1511796155277,"userId":0,"version":1,"compare":0,"name":"获取验证码","url":"/post/verify","request":"{"type": 0, "phone": "13000082001"}","date":"2017-11-27 23:22:35.0"},{"id":3,"userId":0,"version":1,"compare":0,"name":"退出登录","url":"/logout","request":"{}","date":"2017-11-26 17:56:10.0"},{"id":1511689914599,"userId":0,"version":1,"compare":0,"name":"获取用户隐私信息","url":"/gets","request":"{"tag": "Privacy", "Privacy": {"id": 82001}}","date":"2017-11-26 17:51:54.0"},{"id":1,"userId":0,"version":1,"compare":0,"name":"登录","url":"/login","request":"{"type": 0, "phone": "13000082001", "version": 1, "password": "123456"}","date":"2017-11-26 15:35:19.0"},{"id":2,"userId":0,"version":1,"compare":0,"name":"注册(先获取验证码type:1)","url":"/register","request":"{
    "Privacy": {
        "phone": "13000083333",
        "_password": "123456"
    },
    "User": {
        "name": "APIJSONUser"
    },
    "verify": "6840"
}"}],"code":200,"msg":"success"}', '2018-03-03 14:53:18.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520088802486, 82001, 1511970224333, '{"Comment":{"code":200,"msg":"success","id":1520088770429,"count":1},"code":200,"msg":"success"}', '2018-03-03 14:53:22.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520088813403, 82001, 1511969630372, '{"Moment":{"id":15,"praiseUserIdList-":[82001]},"code":417,"msg":"PUT Moment, praiseUserIdList:82001 不存在！"}', '2018-03-03 14:53:33.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520088985525, 82001, 1511963677325, '{"code":412,"msg":"手机号或验证码错误！"}', '2018-03-03 14:56:25.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520089316891, 82001, 1519368532249, '{"User":{"code":200,"msg":"success","id":82001,"count":1},"code":200,"msg":"success"}', '2018-03-03 15:01:56.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520089324108, 82001, 1511970224333, '{"Comment":{"code":200,"msg":"success","id":1520089307634,"count":1},"code":200,"msg":"success"}', '2018-03-03 15:02:04.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520089326569, 82001, 1511969630372, '{"[]":[{"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,93793],"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"}},{"User":{"id":82005,"sex":1,"name":"Jan","tag":"AG","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[82001,38710],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"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"}},{"User":{"id":82021,"sex":1,"name":"Tommy","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"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":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":82030,"sex":1,"name":"Fun","head":"http://static.oschina.net/uploads/user/998/1997902_50.jpg?t=1407806577000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82033,"sex":1,"name":"GAS","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82034,"sex":1,"name":"Jump","head":"http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82035,"sex":1,"name":"Tab","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":82039,"sex":1,"name":"Everyday","head":"http://common.cnblogs.com/images/icon_weibo_24.png","contactIdList":[],"pictureList":[],"date":"2017-02-19 21:57:56.0"}},{"User":{"id":82040,"sex":1,"name":"Dream","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793],"pictureList":[],"date":"2017-03-03 00:44:26.0"}},{"User":{"id":82042,"sex":1,"name":"Why","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[],"pictureList":[],"date":"2017-03-04 18:04:33.0"}},{"User":{"id":82044,"sex":1,"name":"Love","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000","contactIdList":[82006],"pictureList":[],"date":"2017-03-04 18:20:27.0"}},{"User":{"id":82055,"sex":1,"name":"Solid","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[38710,82002],"pictureList":[],"date":"2017-03-11 23:04:00.0"}},{"User":{"id":82056,"sex":1,"name":"IronMan","head":"http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000","contactIdList":[],"pictureList":[],"date":"2017-03-11 23:32:25.0"}},{"User":{"id":82059,"sex":1,"name":"He&She","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[],"pictureList":[],"date":"2017-03-19 22:49:15.0"}},{"User":{"id":82060,"sex":1,"name":"Anyway~","head":"http://static.oschina.net/uploads/user/1/3064_50.jpg?t=1449566001000","contactIdList":[],"pictureList":[],"date":"2017-03-21 22:10:18.0"}},{"User":{"id":1490109742863,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-03-21 23:22:22.0"}},{"User":{"id":1490420651686,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793],"pictureList":[],"date":"2017-03-25 13:44:11.0"}},{"User":{"id":1490973670928,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793,93793],"pictureList":[],"date":"2017-03-31 23:21:10.0"}},{"User":{"id":1508072105320,"sex":1,"name":"周吴郑王","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-10-15 20:55:05.0"}}],"code":200,"msg":"success"}', '2018-03-03 15:02:06.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520089328891, 82001, 1511963677325, '{"code":412,"msg":"手机号或验证码错误！"}', '2018-03-03 15:02:08.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520089695229, 82001, 2, '{"Document[]":[{"id":1519526273822,"userId":82001,"version":2,"name":"gets请求","url":"/gets","request":"{
    "Privacy": {
        "id": 82001
    },
    "tag": "Privacy"
}","response":"{"Document[]":[{"id":1519526273822,"userId":82001,"version":2,"compare":2,"name":"gets请求","url":"/gets","request":"{
    "Privacy": {
        "id": 82001
    },
    "tag": "Privacy"
}","date":"2018-02-25 10:37:53.0"},{"id":1519368532249,"userId":82001,"version":2,"compare":1,"name":"login请求","url":"/login","request":"{
    "type": 0,
    "phone": "13000082001",
    "password": "123456",
    "version": 1
}","date":"2018-02-23 14:48:52.0"},{"id":1516325614520,"userId":82001,"version":2,"compare":0,"name":"get请求","url":"/get","request":"        {
          "[]":{
            "User":{
              "sex":1
            }
          }
        }
      ","date":"2018-01-19 09:33:34.0"},{"id":1511963330795,"userId":0,"version":2,"compare":0,"name":"获取文档列表(即在线解析网页上的共享)-API调用方式","url":"/get","request":"{
    "Document[]": {
        "Document": {
            "@role": "login",
            "@order": "version-,date-"
        }
    }
}","date":"2017-11-29 21:48:50.0"},{"id":1512216131855,"userId":0,"version":1,"compare":0,"name":"获取文档列表(即在线解析网页上的文档)-表和字段、请求格式限制","url":"/get","request":"{
    "[]": {
        "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-"
        }
    }
}","date":"2017-12-02 20:02:11.0"},{"id":1511970224333,"userId":0,"version":1,"compare":3,"name":"修改用户信息","url":"/put","request":"{
    "User": {
        "id": 82001,
        "name": "测试改名"
    },
    "tag": "User"
}","date":"2017-11-29 23:43:44.0"},{"id":1511970009072,"userId":0,"version":1,"compare":0,"name":"新增动态","url":"/post","request":"{
    "Moment": {
        "userId": 82001,
        "content": "测试新增动态",
        "pictureList": ["http://static.oschina.net/uploads/user/48/96331_50.jpg"
        ]
    },
    "tag": "Moment"
}","date":"2017-11-29 23:40:09.0"},{"id":1511969630372,"userId":0,"version":1,"compare":4,"name":"新增评论","url":"/post","request":"{
    "Comment": {
        "userId": 82001,
        "momentId": 15,
        "content": "测试新增评论"
    },
    "tag": "Comment"
}","date":"2017-11-29 23:33:50.0"},{"id":1511969417633,"userId":0,"version":1,"compare":0,"name":"点赞/取消点赞","url":"/put","request":"{
    "Moment": {
        "id": 15,
        "praiseUserIdList-": [
            82001
        ]
    },
    "tag": "Moment"
}","date":"2017-11-29 23:30:17.0"},{"id":1511969181104,"userId":0,"version":1,"compare":0,"name":"添加朋友","url":"/put","request":"{
    "User": {
        "id": 82001,
        "contactIdList+": [93793]
    },
    "tag": "User"
}","date":"2017-11-29 23:26:21.0"},{"id":1511967853340,"userId":0,"version":1,"compare":0,"name":"获取动态列表Moment+User+User:parise[]+Comment[]","url":"/get","request":"{
    "[]": {
        "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"
            }
        }
    }
}","date":"2017-11-29 23:04:13.0"},{"id":1511964176689,"userId":0,"version":1,"compare":0,"name":"获取评论列表-动态详情页Comment+User","url":"/get","request":"{
    "[]": {
        "count": 20,
        "page": 0,
        "Comment": {
            "@order": "date+",
            "momentId": 15
        },
        "User": {
            "id@": "/Comment/userId",
            "@column": "id,name,head"
        }
    }
}","date":"2017-11-29 22:02:56.0"},{"id":1511963990072,"userId":0,"version":1,"compare":0,"name":"获取动态Moment+User+praiseUserList","url":"/get","request":"{
    "Moment": {
        "id": 15
    },
    "User": {
        "id@": "Moment/userId",
        "@column": "id,name,head"
    },
    "User[]": {
        "count": 10,
        "User": {
            "id{}@": "Moment/praiseUserIdList",
            "@column": "id,name"
        }
    }
}","date":"2017-11-29 21:59:50.0"},{"id":1511963722970,"userId":0,"version":1,"compare":0,"name":"获取用户列表("id{}":contactIdList)-朋友页","url":"/get","request":"{
    "User[]": {
        "count": 10,
        "page": 0,
        "User": {
            "@column": "id,sex,name,tag,head",
            "@order": "name+",
            "id{}": [
                82002,
                82004,
                70793
            ]
        }
    }
}","date":"2017-11-29 21:55:22.0"},{"id":1511963677325,"userId":0,"version":1,"compare":1,"name":"获取用户","url":"/get","request":"{"User": {"id": 82001}}","date":"2017-11-29 21:54:37.0"},{"id":1511796882184,"userId":0,"version":1,"compare":0,"name":"充值(需要支付密码)/提现","url":"/put/balance","request":"{"tag": "Privacy", "Privacy": {"id": 82001, "balance+": 100.15, "_payPassword": "123456"}}","date":"2017-11-27 23:34:42.0"},{"id":1511796589079,"userId":0,"version":1,"compare":0,"name":"修改登录密码(先获取验证码type:2)-手机号+验证码","url":"/put/password","request":"{"verify": "10322", "Privacy": {"phone": "13000082001", "_password": "666666"}}","date":"2017-11-27 23:29:49.0"},{"id":1511796208670,"userId":0,"version":1,"compare":0,"name":"检查验证码是否存在","url":"/heads/verify","request":"{"type": 0, "phone": "13000082001"}","date":"2017-11-27 23:23:28.0"},{"id":1511796155277,"userId":0,"version":1,"compare":0,"name":"获取验证码","url":"/post/verify","request":"{"type": 0, "phone": "13000082001"}","date":"2017-11-27 23:22:35.0"},{"id":3,"userId":0,"version":1,"compare":0,"name":"退出登录","url":"/logout","request":"{}","date":"2017-11-26 17:56:10.0"},{"id":1511689914599,"userId":0,"version":1,"compare":0,"name":"获取用户隐私信息","url":"/gets","request":"{"tag": "Privacy", "Privacy": {"id": 82001}}","date":"2017-11-26 17:51:54.0"},{"id":1,"userId":0,"version":1,"compare":0,"name":"登录","url":"/login","request":"{"type": 0, "phone": "13000082001", "version": 1, "password": "123456"}","date":"2017-11-26 15:35:19.0"},{"id":2,"userId":0,"version":1,"compare":0,"name":"注册(先获取验证码type:1)","url":"/register","request":"{
    "Privacy": {
        "phone": "13000083333",
        "_password": "123456"
    },
    "User": {
        "name": "APIJSONUser"
    },
    "verify": "6840"
}"}],"code":200,"msg":"success"}","date":"2018-02-25 10:37:53.0"},{"id":1519368532249,"userId":82001,"version":2,"name":"login请求","url":"/login","request":"{
    "type": 0,
    "phone": "13000082001",
    "password": "123456",
    "version": 1
}","response":"{"User":{"code":200,"msg":"success","id":82001,"count":1},"code":200,"msg":"success"}","date":"2018-02-23 14:48:52.0"},{"id":1516325614520,"userId":82001,"version":2,"name":"get请求","url":"/get","request":"        {
          "[]":{
            "User":{
              "sex":1
            }
          }
        }
      ","date":"2018-01-19 09:33:34.0"},{"id":1511963330795,"userId":0,"version":2,"name":"获取文档列表(即在线解析网页上的共享)-API调用方式","url":"/get","request":"{
    "Document[]": {
        "Document": {
            "@role": "login",
            "@order": "version-,date-"
        }
    }
}","date":"2017-11-29 21:48:50.0"},{"id":1512216131855,"userId":0,"version":1,"name":"获取文档列表(即在线解析网页上的文档)-表和字段、请求格式限制","url":"/get","request":"{
    "[]": {
        "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-"
        }
    }
}","date":"2017-12-02 20:02:11.0"},{"id":1511970224333,"userId":0,"version":1,"name":"修改用户信息","url":"/put","request":"{
    "User": {
        "id": 82001,
        "name": "测试改名"
    },
    "tag": "User"
}","date":"2017-11-29 23:43:44.0"},{"id":1511970009072,"userId":0,"version":1,"name":"新增动态","url":"/post","request":"{
    "Moment": {
        "userId": 82001,
        "content": "测试新增动态",
        "pictureList": ["http://static.oschina.net/uploads/user/48/96331_50.jpg"
        ]
    },
    "tag": "Moment"
}","date":"2017-11-29 23:40:09.0"},{"id":1511969630372,"userId":0,"version":1,"name":"新增评论","url":"/post","request":"{
    "Comment": {
        "userId": 82001,
        "momentId": 15,
        "content": "测试新增评论"
    },
    "tag": "Comment"
}","date":"2017-11-29 23:33:50.0"},{"id":1511969417633,"userId":0,"version":1,"name":"点赞/取消点赞","url":"/put","request":"{
    "Moment": {
        "id": 15,
        "praiseUserIdList-": [
            82001
        ]
    },
    "tag": "Moment"
}","date":"2017-11-29 23:30:17.0"},{"id":1511969181104,"userId":0,"version":1,"name":"添加朋友","url":"/put","request":"{
    "User": {
        "id": 82001,
        "contactIdList+": [93793]
    },
    "tag": "User"
}","date":"2017-11-29 23:26:21.0"},{"id":1511967853340,"userId":0,"version":1,"name":"获取动态列表Moment+User+User:parise[]+Comment[]","url":"/get","request":"{
    "[]": {
        "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"
            }
        }
    }
}","date":"2017-11-29 23:04:13.0"},{"id":1511964176689,"userId":0,"version":1,"name":"获取评论列表-动态详情页Comment+User","url":"/get","request":"{
    "[]": {
        "count": 20,
        "page": 0,
        "Comment": {
            "@order": "date+",
            "momentId": 15
        },
        "User": {
            "id@": "/Comment/userId",
            "@column": "id,name,head"
        }
    }
}","date":"2017-11-29 22:02:56.0"},{"id":1511963990072,"userId":0,"version":1,"name":"获取动态Moment+User+praiseUserList","url":"/get","request":"{
    "Moment": {
        "id": 15
    },
    "User": {
        "id@": "Moment/userId",
        "@column": "id,name,head"
    },
    "User[]": {
        "count": 10,
        "User": {
            "id{}@": "Moment/praiseUserIdList",
            "@column": "id,name"
        }
    }
}","date":"2017-11-29 21:59:50.0"},{"id":1511963722970,"userId":0,"version":1,"name":"获取用户列表("id{}":contactIdList)-朋友页","url":"/get","request":"{
    "User[]": {
        "count": 10,
        "page": 0,
        "User": {
            "@column": "id,sex,name,tag,head",
            "@order": "name+",
            "id{}": [
                82002,
                82004,
                70793
            ]
        }
    }
}","date":"2017-11-29 21:55:22.0"},{"id":1511963677325,"userId":0,"version":1,"name":"获取用户","url":"/get","request":"{"User": {"id": 82001}}","date":"2017-11-29 21:54:37.0"},{"id":1511796882184,"userId":0,"version":1,"name":"充值(需要支付密码)/提现","url":"/put/balance","request":"{"tag": "Privacy", "Privacy": {"id": 82001, "balance+": 100.15, "_payPassword": "123456"}}","date":"2017-11-27 23:34:42.0"},{"id":1511796589079,"userId":0,"version":1,"name":"修改登录密码(先获取验证码type:2)-手机号+验证码","url":"/put/password","request":"{"verify": "10322", "Privacy": {"phone": "13000082001", "_password": "666666"}}","date":"2017-11-27 23:29:49.0"},{"id":1511796208670,"userId":0,"version":1,"name":"检查验证码是否存在","url":"/heads/verify","request":"{"type": 0, "phone": "13000082001"}","date":"2017-11-27 23:23:28.0"},{"id":1511796155277,"userId":0,"version":1,"name":"获取验证码","url":"/post/verify","request":"{"type": 0, "phone": "13000082001"}","date":"2017-11-27 23:22:35.0"},{"id":3,"userId":0,"version":1,"name":"退出登录","url":"/logout","request":"{}","date":"2017-11-26 17:56:10.0"},{"id":1511689914599,"userId":0,"version":1,"name":"获取用户隐私信息","url":"/gets","request":"{"tag": "Privacy", "Privacy": {"id": 82001}}","date":"2017-11-26 17:51:54.0"},{"id":1,"userId":0,"version":1,"name":"登录","url":"/login","request":"{"type": 0, "phone": "13000082001", "version": 1, "password": "123456"}","date":"2017-11-26 15:35:19.0"},{"id":2,"userId":0,"version":1,"name":"注册(先获取验证码type:1)","url":"/register","request":"{
    "Privacy": {
        "phone": "13000083333",
        "_password": "123456"
    },
    "User": {
        "name": "APIJSONUser"
    },
    "verify": "6840"
}"}],"code":200,"msg":"success"}', '2018-03-03 15:08:15.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520090219049, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":22628.1},"code":200,"msg":"success"}', '2018-03-03 15:16:59.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520090220914, 82001, 1516325614520, '{"[]":[{"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,93793],"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"}},{"User":{"id":82005,"sex":1,"name":"Jan","tag":"AG","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[82001,38710],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"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"}},{"User":{"id":82021,"sex":1,"name":"Tommy","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"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":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":82030,"sex":1,"name":"Fun","head":"http://static.oschina.net/uploads/user/998/1997902_50.jpg?t=1407806577000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82033,"sex":1,"name":"GAS","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82034,"sex":1,"name":"Jump","head":"http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82035,"sex":1,"name":"Tab","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":82039,"sex":1,"name":"Everyday","head":"http://common.cnblogs.com/images/icon_weibo_24.png","contactIdList":[],"pictureList":[],"date":"2017-02-19 21:57:56.0"}},{"User":{"id":82040,"sex":1,"name":"Dream","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793],"pictureList":[],"date":"2017-03-03 00:44:26.0"}},{"User":{"id":82042,"sex":1,"name":"Why","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[],"pictureList":[],"date":"2017-03-04 18:04:33.0"}},{"User":{"id":82044,"sex":1,"name":"Love","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000","contactIdList":[82006],"pictureList":[],"date":"2017-03-04 18:20:27.0"}},{"User":{"id":82055,"sex":1,"name":"Solid","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[38710,82002],"pictureList":[],"date":"2017-03-11 23:04:00.0"}},{"User":{"id":82056,"sex":1,"name":"IronMan","head":"http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000","contactIdList":[],"pictureList":[],"date":"2017-03-11 23:32:25.0"}},{"User":{"id":82059,"sex":1,"name":"He&She","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[],"pictureList":[],"date":"2017-03-19 22:49:15.0"}},{"User":{"id":82060,"sex":1,"name":"Anyway~","head":"http://static.oschina.net/uploads/user/1/3064_50.jpg?t=1449566001000","contactIdList":[],"pictureList":[],"date":"2017-03-21 22:10:18.0"}},{"User":{"id":1490109742863,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-03-21 23:22:22.0"}},{"User":{"id":1490420651686,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793],"pictureList":[],"date":"2017-03-25 13:44:11.0"}},{"User":{"id":1490973670928,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793,93793],"pictureList":[],"date":"2017-03-31 23:21:10.0"}},{"User":{"id":1508072105320,"sex":1,"name":"周吴郑王","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-10-15 20:55:05.0"}}],"code":200,"msg":"success"}', '2018-03-03 15:17:00.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520090222151, 82001, 1519368532249, '{"User":{"id":82001,"sex":0,"name":"测试改名","tag":"APIJSON User","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[82025,70793,82034,93793,82021,82033],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"code":200,"msg":"success"}', '2018-03-03 15:17:02.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520090430596, 82001, 1516325614520, '{"User":{"id":82001,"sex":0,"name":"测试改名","tag":"APIJSON User","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[82025,70793,82034,93793,82021,82033],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"code":200,"msg":"success"}', '2018-03-03 15:20:30.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520090633508, 82001, 1516325614520, '{"code":412,"msg":"手机号或验证码错误！"}', '2018-03-03 15:23:53.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520091069489, 82001, 1516325614520, '{"code":412,"msg":"手机号或验证码错误！"}', '2018-03-03 15:31:09.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520091190755, 82001, 1519368532249, '{"code":412,"msg":"手机号或验证码错误！"}', '2018-03-03 15:33:10.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520091349017, 82001, 1519526273822, '{"code":412,"msg":"手机号或验证码错误！"}', '2018-03-03 15:35:49.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520091550804, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":22628.1},"code":200,"msg":"success"}', '2018-03-03 15:39:10.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520091551472, 82001, 1519368532249, '{"User":{"id":82001,"sex":0,"name":"测试改名","tag":"APIJSON User","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[82025,70793,82034,93793,82021,82033],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"code":200,"msg":"success"}', '2018-03-03 15:39:11.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520091552062, 82001, 1516325614520, '{"[]":[{"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,93793],"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"}},{"User":{"id":82005,"sex":1,"name":"Jan","tag":"AG","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[82001,38710],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"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"}},{"User":{"id":82021,"sex":1,"name":"Tommy","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"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":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":82030,"sex":1,"name":"Fun","head":"http://static.oschina.net/uploads/user/998/1997902_50.jpg?t=1407806577000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82033,"sex":1,"name":"GAS","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82034,"sex":1,"name":"Jump","head":"http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82035,"sex":1,"name":"Tab","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":82039,"sex":1,"name":"Everyday","head":"http://common.cnblogs.com/images/icon_weibo_24.png","contactIdList":[],"pictureList":[],"date":"2017-02-19 21:57:56.0"}},{"User":{"id":82040,"sex":1,"name":"Dream","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793],"pictureList":[],"date":"2017-03-03 00:44:26.0"}},{"User":{"id":82042,"sex":1,"name":"Why","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[],"pictureList":[],"date":"2017-03-04 18:04:33.0"}},{"User":{"id":82044,"sex":1,"name":"Love","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000","contactIdList":[82006],"pictureList":[],"date":"2017-03-04 18:20:27.0"}},{"User":{"id":82055,"sex":1,"name":"Solid","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[38710,82002],"pictureList":[],"date":"2017-03-11 23:04:00.0"}},{"User":{"id":82056,"sex":1,"name":"IronMan","head":"http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000","contactIdList":[],"pictureList":[],"date":"2017-03-11 23:32:25.0"}},{"User":{"id":82059,"sex":1,"name":"He&She","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[],"pictureList":[],"date":"2017-03-19 22:49:15.0"}},{"User":{"id":82060,"sex":1,"name":"Anyway~","head":"http://static.oschina.net/uploads/user/1/3064_50.jpg?t=1449566001000","contactIdList":[],"pictureList":[],"date":"2017-03-21 22:10:18.0"}},{"User":{"id":1490109742863,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-03-21 23:22:22.0"}},{"User":{"id":1490420651686,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793],"pictureList":[],"date":"2017-03-25 13:44:11.0"}},{"User":{"id":1490973670928,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793,93793],"pictureList":[],"date":"2017-03-31 23:21:10.0"}},{"User":{"id":1508072105320,"sex":1,"name":"周吴郑王","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-10-15 20:55:05.0"}}],"code":200,"msg":"success"}', '2018-03-03 15:39:12.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520173915650, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":27134.85},"code":200,"msg":"success"}', '2018-03-04 14:31:55.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520091900844, 82001, 1516325614520, '{"[]":[{"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,93793],"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"}},{"User":{"id":82005,"sex":1,"name":"Jan","tag":"AG","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[82001,38710],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"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"}},{"User":{"id":82021,"sex":1,"name":"Tommy","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"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":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":82030,"sex":1,"name":"Fun","head":"http://static.oschina.net/uploads/user/998/1997902_50.jpg?t=1407806577000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82033,"sex":1,"name":"GAS","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82034,"sex":1,"name":"Jump","head":"http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82035,"sex":1,"name":"Tab","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":82039,"sex":1,"name":"Everyday","head":"http://common.cnblogs.com/images/icon_weibo_24.png","contactIdList":[],"pictureList":[],"date":"2017-02-19 21:57:56.0"}},{"User":{"id":82040,"sex":1,"name":"Dream","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793],"pictureList":[],"date":"2017-03-03 00:44:26.0"}},{"User":{"id":82042,"sex":1,"name":"Why","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[],"pictureList":[],"date":"2017-03-04 18:04:33.0"}},{"User":{"id":82044,"sex":1,"name":"Love","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000","contactIdList":[82006],"pictureList":[],"date":"2017-03-04 18:20:27.0"}},{"User":{"id":82055,"sex":1,"name":"Solid","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[38710,82002],"pictureList":[],"date":"2017-03-11 23:04:00.0"}},{"User":{"id":82056,"sex":1,"name":"IronMan","head":"http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000","contactIdList":[],"pictureList":[],"date":"2017-03-11 23:32:25.0"}},{"User":{"id":82059,"sex":1,"name":"He&She","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[],"pictureList":[],"date":"2017-03-19 22:49:15.0"}},{"User":{"id":82060,"sex":1,"name":"Anyway~","head":"http://static.oschina.net/uploads/user/1/3064_50.jpg?t=1449566001000","contactIdList":[],"pictureList":[],"date":"2017-03-21 22:10:18.0"}},{"User":{"id":1490109742863,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-03-21 23:22:22.0"}},{"User":{"id":1490420651686,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793],"pictureList":[],"date":"2017-03-25 13:44:11.0"}},{"User":{"id":1490973670928,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793,93793],"pictureList":[],"date":"2017-03-31 23:21:10.0"}},{"User":{"id":1508072105320,"sex":1,"name":"周吴郑王","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-10-15 20:55:05.0"}}],"code":200,"msg":"success"}', '2018-03-03 15:45:00.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520092115128, 82001, 1520091922118, '{"User":{"id":82001,"sex":0,"name":"测试改名","tag":"APIJSON User","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[82025,70793,82034,93793,82021,82033],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"code":200,"msg":"success"}', '2018-03-03 15:48:35.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520092224195, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":22628.1},"code":200,"msg":"success"}', '2018-03-03 15:50:24.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520092385815, 82001, 1520091922118, '{"User":{"id":82001,"sex":0,"name":"测试改名","tag":"APIJSON User","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[82025,70793,82034,93793,82021,82033],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"code":200,"msg":"success"}', '2018-03-03 15:53:05.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520092411345, 82001, 1516325614520, '{"[]":[{"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,93793],"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"}},{"User":{"id":82005,"sex":1,"name":"Jan","tag":"AG","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[82001,38710],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"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"}},{"User":{"id":82021,"sex":1,"name":"Tommy","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"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":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":82030,"sex":1,"name":"Fun","head":"http://static.oschina.net/uploads/user/998/1997902_50.jpg?t=1407806577000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82033,"sex":1,"name":"GAS","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82034,"sex":1,"name":"Jump","head":"http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82035,"sex":1,"name":"Tab","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":82039,"sex":1,"name":"Everyday","head":"http://common.cnblogs.com/images/icon_weibo_24.png","contactIdList":[],"pictureList":[],"date":"2017-02-19 21:57:56.0"}},{"User":{"id":82040,"sex":1,"name":"Dream","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793],"pictureList":[],"date":"2017-03-03 00:44:26.0"}},{"User":{"id":82042,"sex":1,"name":"Why","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[],"pictureList":[],"date":"2017-03-04 18:04:33.0"}},{"User":{"id":82044,"sex":1,"name":"Love","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000","contactIdList":[82006],"pictureList":[],"date":"2017-03-04 18:20:27.0"}},{"User":{"id":82055,"sex":1,"name":"Solid","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[38710,82002],"pictureList":[],"date":"2017-03-11 23:04:00.0"}},{"User":{"id":82056,"sex":1,"name":"IronMan","head":"http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000","contactIdList":[],"pictureList":[],"date":"2017-03-11 23:32:25.0"}},{"User":{"id":82059,"sex":1,"name":"He&She","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000","contactIdList":[],"pictureList":[],"date":"2017-03-19 22:49:15.0"}},{"User":{"id":82060,"sex":1,"name":"Anyway~","head":"http://static.oschina.net/uploads/user/1/3064_50.jpg?t=1449566001000","contactIdList":[],"pictureList":[],"date":"2017-03-21 22:10:18.0"}},{"User":{"id":1490109742863,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-03-21 23:22:22.0"}},{"User":{"id":1490420651686,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793],"pictureList":[],"date":"2017-03-25 13:44:11.0"}},{"User":{"id":1490973670928,"sex":1,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[70793,93793],"pictureList":[],"date":"2017-03-31 23:21:10.0"}},{"User":{"id":1508072105320,"sex":1,"name":"周吴郑王","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-10-15 20:55:05.0"}}],"code":200,"msg":"success"}', '2018-03-03 15:53:31.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520092528119, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":22628.1},"code":200,"msg":"success"}', '2018-03-03 15:55:28.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520092670553, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":22628.1},"code":200,"msg":"success"}', '2018-03-03 15:57:50.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520092819799, 82001, 1520091922118, '{"User":{"id":82001,"sex":0,"name":"测试改名","tag":"APIJSON User","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[82025,70793,82034,93793,82021,82033],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"code":200,"msg":"success"}', '2018-03-03 16:00:19.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520173868568, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":26734.25},"code":200,"msg":"success"}', '2018-03-04 14:31:08.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520173870784, 82001, 1512216131855, '{"[]":[{"Table":{"TABLE_NAME":"apijson_privacy","TABLE_COMMENT":"用户隐私信息表。
对安全要求高，不想泄漏真实名称。对外名称为 Privacy"},"Column[]":[{"COLUMN_NAME":"id","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"唯一标识"},{"COLUMN_NAME":"certified","COLUMN_TYPE":"tinyint(2)","IS_NULLABLE":"NO","COLUMN_COMMENT":"已认证"},{"COLUMN_NAME":"phone","COLUMN_TYPE":"bigint(11)","IS_NULLABLE":"NO","COLUMN_COMMENT":"手机号，仅支持 11 位数的。不支持 +86 这种国家地区开头的。如果要支持就改为 VARCHAR(14)"},{"COLUMN_NAME":"balance","COLUMN_TYPE":"decimal(10,2)","IS_NULLABLE":"NO","COLUMN_COMMENT":"余额"},{"COLUMN_NAME":"_password","COLUMN_TYPE":"varchar(20)","IS_NULLABLE":"NO","COLUMN_COMMENT":"登录密码"},{"COLUMN_NAME":"_payPassword","COLUMN_TYPE":"int(6)","IS_NULLABLE":"NO","COLUMN_COMMENT":"支付密码"}]},{"Table":{"TABLE_NAME":"apijson_user","TABLE_COMMENT":"用户公开信息表。
对安全要求高，不想泄漏真实名称。对外名称为 User"},"Column[]":[{"COLUMN_NAME":"id","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"唯一标识"},{"COLUMN_NAME":"sex","COLUMN_TYPE":"tinyint(2)","IS_NULLABLE":"NO","COLUMN_COMMENT":"性别：
0-男
1-女"},{"COLUMN_NAME":"name","COLUMN_TYPE":"varchar(20)","IS_NULLABLE":"YES","COLUMN_COMMENT":"名称"},{"COLUMN_NAME":"tag","COLUMN_TYPE":"varchar(45)","IS_NULLABLE":"YES","COLUMN_COMMENT":"标签"},{"COLUMN_NAME":"head","COLUMN_TYPE":"varchar(300)","IS_NULLABLE":"YES","COLUMN_COMMENT":"头像url"},{"COLUMN_NAME":"contactIdList","COLUMN_TYPE":"json","IS_NULLABLE":"YES","COLUMN_COMMENT":"联系人id列表"},{"COLUMN_NAME":"pictureList","COLUMN_TYPE":"json","IS_NULLABLE":"YES","COLUMN_COMMENT":"照片列表"},{"COLUMN_NAME":"date","COLUMN_TYPE":"timestamp","IS_NULLABLE":"YES","COLUMN_COMMENT":"创建日期"}]},{"Table":{"TABLE_NAME":"Comment","TABLE_COMMENT":"评论"},"Column[]":[{"COLUMN_NAME":"id","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"唯一标识"},{"COLUMN_NAME":"toId","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"YES","COLUMN_COMMENT":"被回复的id"},{"COLUMN_NAME":"userId","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"评论人id"},{"COLUMN_NAME":"momentId","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"动态id"},{"COLUMN_NAME":"date","COLUMN_TYPE":"timestamp","IS_NULLABLE":"YES","COLUMN_COMMENT":"创建日期"},{"COLUMN_NAME":"content","COLUMN_TYPE":"varchar(1000)","IS_NULLABLE":"NO","COLUMN_COMMENT":"内容"}]},{"Table":{"TABLE_NAME":"Document","TABLE_COMMENT":"测试用例文档
后端开发者在测试好后，把选好的测试用例上传，这样就能共享给前端/客户端开发者"},"Column[]":[{"COLUMN_NAME":"id","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"唯一标识"},{"COLUMN_NAME":"userId","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"用户id
应该用adminId，只有当登录账户是管理员时才能操作文档。
需要先建Admin表，新增登录等相关接口。"},{"COLUMN_NAME":"version","COLUMN_TYPE":"tinyint(4)","IS_NULLABLE":"NO","COLUMN_COMMENT":"接口版本号
<=0 - 不限制版本，任意版本都可用这个接口
>0 - 在这个版本添加的接口"},{"COLUMN_NAME":"name","COLUMN_TYPE":"varchar(50)","IS_NULLABLE":"NO","COLUMN_COMMENT":"接口名称"},{"COLUMN_NAME":"url","COLUMN_TYPE":"varchar(250)","IS_NULLABLE":"NO","COLUMN_COMMENT":"请求地址"},{"COLUMN_NAME":"request","COLUMN_TYPE":"text","IS_NULLABLE":"NO","COLUMN_COMMENT":"请求
用json格式会导致强制排序，而请求中引用赋值只能引用上面的字段，必须有序。"},{"COLUMN_NAME":"response","COLUMN_TYPE":"text","IS_NULLABLE":"YES","COLUMN_COMMENT":"标准返回结果JSON
用json格式会导致强制排序，而请求中引用赋值只能引用上面的字段，必须有序。"},{"COLUMN_NAME":"date","COLUMN_TYPE":"timestamp","IS_NULLABLE":"YES","COLUMN_COMMENT":"创建日期"}]},{"Table":{"TABLE_NAME":"Login","TABLE_COMMENT":"@deprecated，登录信息存session"},"Column[]":[{"COLUMN_NAME":"id","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"唯一标识"},{"COLUMN_NAME":"userId","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"用户id"},{"COLUMN_NAME":"type","COLUMN_TYPE":"tinyint(2)","IS_NULLABLE":"NO","COLUMN_COMMENT":"类型
0-密码登录
1-验证码登录"},{"COLUMN_NAME":"date","COLUMN_TYPE":"timestamp","IS_NULLABLE":"NO","COLUMN_COMMENT":"创建日期"}]},{"Table":{"TABLE_NAME":"Moment","TABLE_COMMENT":"动态"},"Column[]":[{"COLUMN_NAME":"id","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"唯一标识"},{"COLUMN_NAME":"userId","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"用户id"},{"COLUMN_NAME":"date","COLUMN_TYPE":"timestamp","IS_NULLABLE":"YES","COLUMN_COMMENT":"创建日期"},{"COLUMN_NAME":"content","COLUMN_TYPE":"varchar(300)","IS_NULLABLE":"YES","COLUMN_COMMENT":"内容"},{"COLUMN_NAME":"praiseUserIdList","COLUMN_TYPE":"json","IS_NULLABLE":"NO","COLUMN_COMMENT":"点赞的用户id列表"},{"COLUMN_NAME":"pictureList","COLUMN_TYPE":"json","IS_NULLABLE":"NO","COLUMN_COMMENT":"图片列表"}]},{"Table":{"TABLE_NAME":"Praise","TABLE_COMMENT":"如果对Moment写安全要求高，可以将Moment内praiserUserIdList分离到Praise表中，作为userIdList。
权限注解也改下：
@MethodAccess(
		PUT = {OWNER, ADMIN}
		)
class Moment {
       …
}

@MethodAccess(
		PUT = {LOGIN, CONTACT, CIRCLE, OWNER, ADMIN}
		)
 class Praise {
       …
 }
"},"Column[]":[{"COLUMN_NAME":"id","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"动态id"},{"COLUMN_NAME":"momentId","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"唯一标识"},{"COLUMN_NAME":"userId","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"用户id"},{"COLUMN_NAME":"date","COLUMN_TYPE":"timestamp","IS_NULLABLE":"YES","COLUMN_COMMENT":"点赞时间"}]},{"Table":{"TABLE_NAME":"Request","TABLE_COMMENT":"最好编辑完后删除主键，这样就是只读状态，不能随意更改。需要更改就重新加上主键。

每次启动服务器时加载整个表到内存。
这个表不可省略，model内注解的权限只是客户端能用的，其它可以保证即便服务端代码错误时也不会误删数据。"},"Column[]":[{"COLUMN_NAME":"id","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"唯一标识"},{"COLUMN_NAME":"version","COLUMN_TYPE":"tinyint(4)","IS_NULLABLE":"NO","COLUMN_COMMENT":"GET,HEAD可用任意结构访问任意开放内容，不需要这个字段。
其它的操作因为写入了结构和内容，所以都需要，按照不同的version选择对应的structure。

自动化版本管理：
Request JSON最外层可以传  “version”:Integer 。
1.未传或 <= 0，用最新版。 “@order”:”version-“
2.已传且 > 0，用version以上的可用版本的最低版本。 “@order”:”version+”, “version{}”:”>={version}”"},{"COLUMN_NAME":"method","COLUMN_TYPE":"varchar(10)","IS_NULLABLE":"YES","COLUMN_COMMENT":"只限于GET,HEAD外的操作方法。"},{"COLUMN_NAME":"tag","COLUMN_TYPE":"varchar(20)","IS_NULLABLE":"NO","COLUMN_COMMENT":"标签"},{"COLUMN_NAME":"structure","COLUMN_TYPE":"json","IS_NULLABLE":"NO","COLUMN_COMMENT":"结构"},{"COLUMN_NAME":"detail","COLUMN_TYPE":"varchar(10000)","IS_NULLABLE":"YES","COLUMN_COMMENT":"详细说明"},{"COLUMN_NAME":"date","COLUMN_TYPE":"timestamp","IS_NULLABLE":"YES","COLUMN_COMMENT":"创建日期"}]},{"Table":{"TABLE_NAME":"Response","TABLE_COMMENT":"每次启动服务器时加载整个表到内存。"},"Column[]":[{"COLUMN_NAME":"id","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"唯一标识"},{"COLUMN_NAME":"method","COLUMN_TYPE":"varchar(10)","IS_NULLABLE":"YES","COLUMN_COMMENT":"方法"},{"COLUMN_NAME":"model","COLUMN_TYPE":"varchar(20)","IS_NULLABLE":"NO","COLUMN_COMMENT":"表名，table是SQL关键词不能用"},{"COLUMN_NAME":"structure","COLUMN_TYPE":"json","IS_NULLABLE":"NO","COLUMN_COMMENT":"结构"},{"COLUMN_NAME":"detail","COLUMN_TYPE":"varchar(10000)","IS_NULLABLE":"YES","COLUMN_COMMENT":"详细说明"},{"COLUMN_NAME":"date","COLUMN_TYPE":"timestamp","IS_NULLABLE":"YES","COLUMN_COMMENT":"创建日期"}]},{"Table":{"TABLE_NAME":"Test","TABLE_COMMENT":"测试及验证用的表，可以用 SELECT condition替代 SELECT * FROM Test WHERE condition，这样就不需要这张表了"},"Column[]":[{"COLUMN_NAME":"id","COLUMN_TYPE":"tinyint(2)","IS_NULLABLE":"NO","COLUMN_COMMENT":""}]},{"Table":{"TABLE_NAME":"TestRecord","TABLE_COMMENT":"测试记录
主要用于保存自动化接口回归测试"},"Column[]":[{"COLUMN_NAME":"id","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"唯一标识"},{"COLUMN_NAME":"userId","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"用户id"},{"COLUMN_NAME":"documentId","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"测试用例文档id"},{"COLUMN_NAME":"response","COLUMN_TYPE":"text","IS_NULLABLE":"NO","COLUMN_COMMENT":"接口返回结果JSON"},{"COLUMN_NAME":"date","COLUMN_TYPE":"timestamp","IS_NULLABLE":"NO","COLUMN_COMMENT":"创建日期"}]},{"Table":{"TABLE_NAME":"Verify","TABLE_COMMENT":""},"Column[]":[{"COLUMN_NAME":"id","COLUMN_TYPE":"bigint(15)","IS_NULLABLE":"NO","COLUMN_COMMENT":"唯一标识"},{"COLUMN_NAME":"type","COLUMN_TYPE":"int(2)","IS_NULLABLE":"NO","COLUMN_COMMENT":"类型：
0-登录
1-注册
2-修改登录密码
3-修改支付密码"},{"COLUMN_NAME":"phone","COLUMN_TYPE":"bigint(11)","IS_NULLABLE":"NO","COLUMN_COMMENT":"手机号"},{"COLUMN_NAME":"verify","COLUMN_TYPE":"int(6)","IS_NULLABLE":"NO","COLUMN_COMMENT":"验证码"},{"COLUMN_NAME":"date","COLUMN_TYPE":"timestamp","IS_NULLABLE":"NO","COLUMN_COMMENT":"创建时间"}]}],"Request[]":[{"id":36,"version":2,"method":"PUT","tag":"Document","structure":{"ADD":{"@role":"owner"},"DISALLOW":"userId","NECESSARY":"id"},"date":"2017-11-26 16:35:15.0"},{"id":35,"version":2,"method":"POST","tag":"Document","structure":{"DISALLOW":"id","NECESSARY":"userId,name,url,request"},"date":"2017-11-26 16:34:41.0"},{"id":32,"version":2,"method":"GETS","tag":"Privacy","structure":{"ADD":{"@role":"owner"},"DISALLOW":"_password,_payPassword","NECESSARY":"id"},"date":"2017-06-13 00:05:51.0"},{"id":33,"version":2,"method":"GETS","tag":"Privacy-CIRCLE","structure":{"Privacy":{"DISALLOW":"!","NECESSARY":"id","PUT":{"@column":"phone","@role":"CIRCLE"}}},"date":"2017-06-13 00:05:51.0"},{"id":37,"version":2,"method":"DELETE","tag":"Document","structure":{"ADD":{"@role":"owner"},"DISALLOW":"!","NECESSARY":"id"},"date":"2017-11-26 16:36:20.0"},{"id":4,"version":1,"method":"PUT","tag":"User","structure":{"ADD":{"@role":"owner"},"DISALLOW":"phone","NECESSARY":"id"},"detail":"必须传id，不允许传phone。ADD当没传@role时用owner补全","date":"2017-02-01 19:19:51.0"},{"id":8,"version":1,"method":"PUT","tag":"User-phone","structure":{"User":{"ADD":{"@role":"owner"},"DISALLOW":"!","NECESSARY":"id,phone,_password","PUT":{"@condition":"_password"}}},"detail":"! 表示其它所有，这里指necessary所有未包含的字段","date":"2017-02-01 19:19:51.0"},{"id":17,"version":1,"method":"PUT","tag":"Moment","structure":{"DISALLOW":"userId,date","NECESSARY":"id"},"date":"2017-02-01 19:19:51.0"},{"id":23,"version":1,"method":"PUT","tag":"Privacy","structure":{"ADD":{"@role":"owner"},"NECESSARY":"id"},"detail":"ADD当没传@role时用owner补全","date":"2017-02-01 19:19:51.0"},{"id":25,"version":1,"method":"PUT","tag":"Praise","structure":{"NECESSARY":"id"},"detail":"必须传id","date":"2017-02-01 19:19:51.0"},{"id":27,"version":1,"method":"PUT","tag":"Comment[]","structure":{"Comment":{"ADD":{"@role":"owner"},"NECESSARY":"id{}"}},"detail":"DISALLOW没必要用于DELETE","date":"2017-02-01 19:19:51.0"},{"id":28,"version":1,"method":"PUT","tag":"Comment","structure":{"ADD":{"@role":"owner"},"NECESSARY":"id"},"detail":"这里省略了Comment，因为tag就是Comment，Parser.getCorrectRequest会自动补全","date":"2017-02-01 19:19:51.0"},{"id":30,"version":1,"method":"PUT","tag":"balance+","structure":{"Privacy":{"VERIFY":{"balance+&{}":">=1,<=100000"},"DISALLOW":"!","NECESSARY":"id,balance+"}},"detail":"验证balance+对应的值是否满足>=1且<=100000","date":"2017-10-21 16:48:34.0"},{"id":31,"version":1,"method":"PUT","tag":"balance-","structure":{"Privacy":{"VERIFY":{"balance-&{}":">=1,<=10000"},"DISALLOW":"!","NECESSARY":"id,balance-,_password","PUT":{"@condition":"_password"}}},"detail":"PUT强制把_password作为WHERE条件","date":"2017-10-21 16:48:34.0"},{"id":1,"version":1,"method":"POST","tag":"register","structure":{"Privacy":{"UNIQUE":"phone","VERIFY":{"phone?":"phone"},"DISALLOW":"id","NECESSARY":"_password,phone"},"User":{"DISALLOW":"id","NECESSARY":"name","PUT":{"id@":"Privacy/id"}}},"detail":"UNIQUE校验phone是否已存在。VERIFY校验phone是否符合手机号的格式","date":"2017-02-01 19:19:51.0"},{"id":2,"version":1,"method":"POST","tag":"Moment","structure":{"ADD":{"praiseUserIdList":[],"pictureList":[]},"DISALLOW":"id","NECESSARY":"userId,pictureList"},"detail":"ADD当没传pictureList和praiseUserIdList时用空数组[]补全，保证不会为null","date":"2017-02-01 19:19:51.0"},{"id":3,"version":1,"method":"POST","tag":"Comment","structure":{"DISALLOW":"id","NECESSARY":"userId,momentId,content"},"detail":"必须传userId,momentId,content，不允许传id","date":"2017-02-01 19:19:51.0"},{"id":14,"version":1,"method":"POST","tag":"Verify","structure":{"DISALLOW":"!","NECESSARY":"phone,verify"},"detail":"必须传phone,verify，其它都不允许传","date":"2017-02-18 22:20:43.0"},{"id":38,"version":1,"method":"POST","tag":"TestRecord","structure":{"DISALLOW":"id","NECESSARY":"userId,documentId,response"},"date":"2017-11-26 16:34:41.0"},{"id":16,"version":1,"method":"HEADS","tag":"Verify","structure":{},"detail":"允许任意内容","date":"2017-02-18 22:20:43.0"},{"id":21,"version":1,"method":"HEADS","tag":"Login","structure":{"DISALLOW":"!","NECESSARY":"userId,type"},"date":"2017-02-18 22:20:43.0"},{"id":15,"version":1,"method":"GETS","tag":"Verify","structure":{"NECESSARY":"phone"},"detail":"必须传phone","date":"2017-02-18 22:20:43.0"},{"id":22,"version":1,"method":"GETS","tag":"User","structure":{},"detail":"允许传任何内容，除了表对象","date":"2017-02-18 22:20:43.0"},{"id":29,"version":1,"method":"GETS","tag":"login","structure":{"Privacy":{"DISALLOW":"id","NECESSARY":"phone,_password"}},"date":"2017-10-15 18:04:52.0"},{"id":5,"version":1,"method":"DELETE","tag":"Moment","structure":{"Moment":{"ADD":{"@role":"owner"},"NECESSARY":"id"},"PUT":{"Comment":{"@role":"admin","momentId@":"Moment/id"}}},"date":"2017-02-01 19:19:51.0"},{"id":6,"version":1,"method":"DELETE","tag":"Comment","structure":{"Comment":{"ADD":{"@role":"owner"},"NECESSARY":"id"},"PUT":{"Comment:child":{"toId@":"Comment/id","@role":"admin"}}},"detail":"disallow没必要用于DELETE","date":"2017-02-01 19:19:51.0"},{"id":26,"version":1,"method":"DELETE","tag":"Comment[]","structure":{"Comment":{"ADD":{"@role":"owner"},"NECESSARY":"id{}"}},"detail":"DISALLOW没必要用于DELETE","date":"2017-02-01 19:19:51.0"}],"code":200,"msg":"success"}', '2018-03-04 14:31:10.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520173872976, 82001, 1511970224333, '{"User":{"code":200,"msg":"success","id":82001,"count":1},"code":200,"msg":"success"}', '2018-03-04 14:31:12.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520173873719, 82001, 1511970009072, '{"Moment":{"code":200,"msg":"success","id":1520173865791,"count":1},"code":200,"msg":"success"}', '2018-03-04 14:31:13.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520173875424, 82001, 1511969181104, '{"User":{"id":82001,"contactIdList+":[93793],"@role":"owner"},"code":409,"msg":"PUT User, contactIdList:93793 已存在！"}', '2018-03-04 14:31:15.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520173877914, 82001, 1511969630372, '{"Comment":{"code":200,"msg":"success","id":1520173865916,"count":1},"code":200,"msg":"success"}', '2018-03-04 14:31:17.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520173878817, 82001, 1511967853340, '{"[]":[{"Moment":{"id":1520173760960,"userId":82001,"date":"2018-03-04 22:29:20.0","content":"测试新增动态","praiseUserIdList":[],"pictureList":["http://static.oschina.net/uploads/user/48/96331_50.jpg"]},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Moment":{"id":1520173720451,"userId":82001,"date":"2018-03-04 22:28:40.0","content":"测试新增动态","praiseUserIdList":[],"pictureList":["http://static.oschina.net/uploads/user/48/96331_50.jpg"]},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Moment":{"id":1520173672910,"userId":82001,"date":"2018-03-04 22:27:52.0","content":"测试新增动态","praiseUserIdList":[],"pictureList":["http://static.oschina.net/uploads/user/48/96331_50.jpg"]},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Moment":{"id":1520173667947,"userId":82001,"date":"2018-03-04 22:27:47.0","content":"测试新增动态","praiseUserIdList":[],"pictureList":["http://static.oschina.net/uploads/user/48/96331_50.jpg"]},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Moment":{"id":1520173666384,"userId":82001,"date":"2018-03-04 22:27:46.0","content":"测试新增动态","praiseUserIdList":[],"pictureList":["http://static.oschina.net/uploads/user/48/96331_50.jpg"]},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}}],"code":200,"msg":"success"}', '2018-03-04 14:31:18.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520173879493, 82001, 1511964176689, '{"[]":[{"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":"http://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":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1520086403693,"userId":82001,"momentId":15,"date":"2018-03-03 22:13:23.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1520086647789,"userId":82001,"momentId":15,"date":"2018-03-03 22:17:27.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1520086858159,"userId":82001,"momentId":15,"date":"2018-03-03 22:20:58.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1520087089611,"userId":82001,"momentId":15,"date":"2018-03-03 22:24:49.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1520087181598,"userId":82001,"momentId":15,"date":"2018-03-03 22:26:21.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1520088770429,"userId":82001,"momentId":15,"date":"2018-03-03 22:52:50.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1520089307634,"userId":82001,"momentId":15,"date":"2018-03-03 23:01:47.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1520089508692,"userId":82001,"momentId":15,"date":"2018-03-03 23:05:08.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1520089597667,"userId":82001,"momentId":15,"date":"2018-03-03 23:06:37.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1520089619339,"userId":82001,"momentId":15,"date":"2018-03-03 23:06:59.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1520089621208,"userId":82001,"momentId":15,"date":"2018-03-03 23:07:01.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1520171621453,"userId":82001,"momentId":15,"date":"2018-03-04 21:53:41.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1520171658156,"userId":82001,"momentId":15,"date":"2018-03-04 21:54:18.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1520171697409,"userId":82001,"momentId":15,"date":"2018-03-04 21:54:57.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1520171714260,"userId":82001,"momentId":15,"date":"2018-03-04 21:55:14.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"}}],"code":200,"msg":"success"}', '2018-03-04 14:31:19.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520173881709, 82001, 1511796208670, '{"code":408,"msg":"验证码已过期！"}', '2018-03-04 14:31:21.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520173883243, 82001, 1511689914599, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":26834.4},"code":200,"msg":"success"}', '2018-03-04 14:31:23.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520173889466, 82001, 1, '{"User":{"id":82001,"sex":0,"name":"测试改名","tag":"APIJSON User","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[82025,70793,82034,93793,82021,82033],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"code":200,"msg":"success"}', '2018-03-04 14:31:29.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520173922657, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":27235},"code":200,"msg":"success"}', '2018-03-04 14:32:02.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520173935008, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":27435.3},"code":200,"msg":"success"}', '2018-03-04 14:32:15.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520174017925, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":29939.05},"code":200,"msg":"success"}', '2018-03-04 14:33:37.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520174362871, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":30039.2},"code":200,"msg":"success"}', '2018-03-04 14:39:22.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520176947082, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":28699.05},"code":200,"msg":"success"}', '2018-03-04 15:22:27.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520177104344, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":28709.2},"code":200,"msg":"success"}', '2018-03-04 15:25:04.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520177328250, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":28809.35},"code":200,"msg":"success"}', '2018-03-04 15:28:48.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520177426424, 82001, 1520177221844, '{"[]":[{"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":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[82025,70793,82034,93793,82021,82033,93794],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"}},{"User":{"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"}},{"User":{"id":82009,"sex":0,"name":"God","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82012,"sex":0,"name":"Steve","tag":"FEWE","head":"http://static.oschina.net/uploads/user/1/3064_50.jpg?t=1449566001000","contactIdList":[82004,82002,93793],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82020,"sex":0,"name":"ORANGE","head":"http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82022,"sex":0,"name":"Internet","head":"http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82023,"sex":0,"name":"No1","head":"http://static.oschina.net/uploads/user/1385/2770216_50.jpg?t=1464405516000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82024,"sex":0,"name":"Lemon","head":"http://static.oschina.net/uploads/user/427/855532_50.jpg?t=1435030876000","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":82029,"sex":0,"name":"GASG","head":"http://common.cnblogs.com/images/wechat.png","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82031,"sex":0,"name":"Lemon","head":"http://static.oschina.net/uploads/user/48/96331_50.jpg","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82032,"sex":0,"name":"Stack","tag":"fasdg","head":"http://static.oschina.net/uploads/user/1385/2770216_50.jpg?t=1464405516000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82036,"sex":0,"name":"SAG","head":"http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82037,"sex":0,"name":"Test","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":82038,"sex":0,"name":"Battle","head":"http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":82041,"sex":0,"name":"Holo","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[38710,82001],"pictureList":[],"date":"2017-03-04 17:59:34.0"}},{"User":{"id":82043,"sex":0,"name":"Holiday","head":"http://static.oschina.net/uploads/user/998/1997902_50.jpg?t=1407806577000","contactIdList":[70793,82006],"pictureList":[],"date":"2017-03-04 18:05:04.0"}},{"User":{"id":82045,"sex":0,"name":"Green","head":"http://common.cnblogs.com/images/wechat.png","contactIdList":[82001,82002,82003,1485246481130],"pictureList":[],"date":"2017-03-04 18:22:39.0"}},{"User":{"id":82046,"sex":0,"name":"Team","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[38710,82002,1485246481130],"pictureList":[],"date":"2017-03-04 23:11:17.0"}},{"User":{"id":82047,"sex":0,"name":"Tesla","head":"http://common.cnblogs.com/images/wechat.png","contactIdList":[],"pictureList":[],"date":"2017-03-05 00:02:05.0"}},{"User":{"id":82048,"sex":0,"name":"Moto","head":"http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000","contactIdList":[],"pictureList":[],"date":"2017-03-05 00:04:02.0"}},{"User":{"id":82049,"sex":0,"name":"ITMan","head":"http://static.oschina.net/uploads/user/629/1258821_50.jpg?t=1378063141000","contactIdList":[],"pictureList":[],"date":"2017-03-05 17:51:51.0"}},{"User":{"id":82050,"sex":0,"name":"Parl","head":"http://static.oschina.net/uploads/user/998/1997902_50.jpg?t=1407806577000","contactIdList":[],"pictureList":[],"date":"2017-03-05 17:52:52.0"}},{"User":{"id":82051,"sex":0,"name":"Girl","head":"http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000","contactIdList":[],"pictureList":[],"date":"2017-03-05 17:53:37.0"}},{"User":{"id":82052,"sex":0,"name":"Unbrella","head":"http://static.oschina.net/uploads/user/1385/2770216_50.jpg?t=1464405516000","contactIdList":[],"pictureList":[],"date":"2017-03-05 17:57:54.0"}},{"User":{"id":82053,"sex":0,"name":"Alice","head":"http://common.cnblogs.com/images/wechat.png","contactIdList":[],"pictureList":[],"date":"2017-03-05 23:25:42.0"}},{"User":{"id":82054,"sex":0,"name":"Harvey","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[],"pictureList":[],"date":"2017-03-06 20:29:03.0"}},{"User":{"id":82057,"sex":0,"name":"NullPointerExeption","head":"http://static.oschina.net/uploads/user/1385/2770216_50.jpg?t=1464405516000","contactIdList":[],"pictureList":[],"date":"2017-03-12 14:01:23.0"}},{"User":{"id":82058,"sex":0,"name":"StupidBird","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[82001,82002],"pictureList":[],"date":"2017-03-12 19:23:04.0"}},{"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"}},{"User":{"id":93793,"sex":0,"name":"Mike","tag":"GES","head":"http://static.oschina.net/uploads/user/48/96331_50.jpg","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":93794,"sex":0,"name":"Lemon","head":"http://static.oschina.net/uploads/user/48/97721_50.jpg?t=1451544779000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"}},{"User":{"id":1490109845208,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-03-21 23:24:05.0"}},{"User":{"id":1490427139175,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[38710,70793],"pictureList":[],"date":"2017-03-25 15:32:19.0"}},{"User":{"id":1490427577823,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-03-25 15:39:37.0"}},{"User":{"id":1490584952968,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-03-27 11:22:32.0"}},{"User":{"id":1492936169722,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-04-23 16:29:29.0"}},{"User":{"id":1493480142628,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-04-29 23:35:42.0"}},{"User":{"id":1493747512860,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-03 01:51:52.0"}},{"User":{"id":1493747777770,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-03 01:56:17.0"}},{"User":{"id":1493748594003,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-03 02:09:54.0"}},{"User":{"id":1493748615711,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-03 02:10:15.0"}},{"User":{"id":1493749090643,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-03 02:18:10.0"}},{"User":{"id":1493836043151,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-04 02:27:23.0"}},{"User":{"id":1493883110132,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-04 15:31:50.0"}},{"User":{"id":1493890214167,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-04 17:30:14.0"}},{"User":{"id":1493890303473,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-04 17:31:43.0"}},{"User":{"id":1493890303474,"sex":0,"name":"Test Post","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-06-12 23:50:44.0"}},{"User":{"id":1493890303475,"sex":0,"name":"Test Post","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-06-12 23:51:23.0"}},{"User":{"id":1497792972314,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-06-18 21:36:12.0"}},{"User":{"id":1497792972315,"sex":0,"name":"一二三","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-06-25 18:42:33.0"}},{"User":{"id":1499057230629,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-07-03 12:47:10.0"}},{"User":{"id":1500825221910,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-07-23 23:53:41.0"}},{"User":{"id":1502638023483,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-08-13 23:27:03.0"}},{"User":{"id":1502639062900,"sex":0,"name":"TESLA","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-08-13 23:44:22.0"}},{"User":{"id":1502639424119,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-08-13 23:50:24.0"}},{"User":{"id":1507220582167,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-10-06 00:23:02.0"}},{"User":{"id":1508072071492,"sex":0,"name":"赵钱孙李","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-10-15 20:54:31.0"}},{"User":{"id":1508072160401,"sex":0,"name":"四五六","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-10-15 20:56:00.0"}},{"User":{"id":1508072202871,"sex":0,"name":"七八九十","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-10-15 20:56:42.0"}},{"User":{"id":1510495628760,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-11-12 22:07:08.0"}},{"User":{"id":1511407581570,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[82002,82003,82005,82006,82021,82023,82036,82033],"pictureList":[],"date":"2017-11-23 11:26:21.0"}},{"User":{"id":1511761906715,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-11-27 13:51:46.0"}},{"User":{"id":1511965911349,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-11-29 22:31:51.0"}},{"User":{"id":1512387063078,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-12-04 19:31:03.0"}},{"User":{"id":1512531601485,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[82001],"pictureList":[],"date":"2017-12-06 11:40:01.0"}},{"User":{"id":1514623064133,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","date":"2017-12-30 16:37:44.0"}},{"User":{"id":1514625918255,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[82002,93793],"date":"2017-12-30 17:25:18.0"}},{"User":{"id":1514626163032,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","date":"2017-12-30 17:29:23.0"}},{"User":{"id":1514858422969,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[93793,82056],"date":"2018-01-02 10:00:22.0"}},{"User":{"id":1515565976140,"sex":0,"name":"APIJSONUser","head":"傻","contactIdList":[82003,82021],"date":"2018-01-10 14:32:56.0"}},{"User":{"id":1518218350585,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","date":"2018-02-10 07:19:10.0"}},{"User":{"id":1519778917280,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","date":"2018-02-28 08:48:37.0"}}],"code":200,"msg":"success"}', '2018-03-04 15:30:26.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520680590422, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":28709.2},"code":200,"msg":"success"}', '2018-03-10 11:16:30.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520681233526, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":28809.35},"code":200,"msg":"success"}', '2018-03-10 11:27:13.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520681278572, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":28809.35,"test":"gda"},"code":200,"msg":"success"}', '2018-03-10 11:27:58.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520681315261, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":28809.35},"code":200,"msg":"success"}', '2018-03-10 11:28:35.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520681361520, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":28809.35,"test":"sfgr"},"code":200,"msg":"success"}', '2018-03-10 11:29:21.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520681493656, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":28809.35},"code":200,"msg":"success"}', '2018-03-10 11:31:33.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520681641244, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":28809},"code":200,"msg":"success"}', '2018-03-10 11:34:01.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520681770042, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":28808.5},"code":200,"msg":"success"}', '2018-03-10 11:36:10.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520682056396, 82001, 1520680656479, '{"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":"测试改名2","tag":"APIJSON User","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[82025,70793,82034,93793,82021,82033,93794],"pictureList":["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":82009,"sex":0,"name":"God","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"id":82012,"sex":0,"name":"Steve","tag":"FEWE","head":"http://static.oschina.net/uploads/user/1/3064_50.jpg?t=1449566001000","contactIdList":[82004,82002,93793],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"id":82020,"sex":0,"name":"ORANGE","head":"http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"id":82022,"sex":0,"name":"Internet","head":"http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"id":82023,"sex":0,"name":"No1","head":"http://static.oschina.net/uploads/user/1385/2770216_50.jpg?t=1464405516000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"id":82024,"sex":0,"name":"Lemon","head":"http://static.oschina.net/uploads/user/427/855532_50.jpg?t=1435030876000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"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"},{"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"},{"id":82029,"sex":0,"name":"GASG","head":"http://common.cnblogs.com/images/wechat.png","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"id":82031,"sex":0,"name":"Lemon","head":"http://static.oschina.net/uploads/user/48/96331_50.jpg","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"id":82032,"sex":0,"name":"Stack","tag":"fasdg","head":"http://static.oschina.net/uploads/user/1385/2770216_50.jpg?t=1464405516000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"id":82036,"sex":0,"name":"SAG","head":"http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"id":82037,"sex":0,"name":"Test","head":"http://static.oschina.net/uploads/user/1200/2400261_50.png?t=1439638750000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"id":82038,"sex":0,"name":"Battle","head":"http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"id":82041,"sex":0,"name":"Holo","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[38710,82001],"pictureList":[],"date":"2017-03-04 17:59:34.0"},{"id":82043,"sex":0,"name":"Holiday","head":"http://static.oschina.net/uploads/user/998/1997902_50.jpg?t=1407806577000","contactIdList":[70793,82006],"pictureList":[],"date":"2017-03-04 18:05:04.0"},{"id":82045,"sex":0,"name":"Green","head":"http://common.cnblogs.com/images/wechat.png","contactIdList":[82001,82002,82003,1485246481130],"pictureList":[],"date":"2017-03-04 18:22:39.0"},{"id":82046,"sex":0,"name":"Team","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[38710,82002,1485246481130],"pictureList":[],"date":"2017-03-04 23:11:17.0"},{"id":82047,"sex":0,"name":"Tesla","head":"http://common.cnblogs.com/images/wechat.png","contactIdList":[],"pictureList":[],"date":"2017-03-05 00:02:05.0"},{"id":82048,"sex":0,"name":"Moto","head":"http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000","contactIdList":[],"pictureList":[],"date":"2017-03-05 00:04:02.0"},{"id":82049,"sex":0,"name":"ITMan","head":"http://static.oschina.net/uploads/user/629/1258821_50.jpg?t=1378063141000","contactIdList":[],"pictureList":[],"date":"2017-03-05 17:51:51.0"},{"id":82050,"sex":0,"name":"Parl","head":"http://static.oschina.net/uploads/user/998/1997902_50.jpg?t=1407806577000","contactIdList":[],"pictureList":[],"date":"2017-03-05 17:52:52.0"},{"id":82051,"sex":0,"name":"Girl","head":"http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000","contactIdList":[],"pictureList":[],"date":"2017-03-05 17:53:37.0"},{"id":82052,"sex":0,"name":"Unbrella","head":"http://static.oschina.net/uploads/user/1385/2770216_50.jpg?t=1464405516000","contactIdList":[],"pictureList":[],"date":"2017-03-05 17:57:54.0"},{"id":82053,"sex":0,"name":"Alice","head":"http://common.cnblogs.com/images/wechat.png","contactIdList":[],"pictureList":[],"date":"2017-03-05 23:25:42.0"},{"id":82054,"sex":0,"name":"Harvey","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[],"pictureList":[],"date":"2017-03-06 20:29:03.0"},{"id":82057,"sex":0,"name":"NullPointerExeption","head":"http://static.oschina.net/uploads/user/1385/2770216_50.jpg?t=1464405516000","contactIdList":[],"pictureList":[],"date":"2017-03-12 14:01:23.0"},{"id":82058,"sex":0,"name":"StupidBird","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[82001,82002],"pictureList":[],"date":"2017-03-12 19:23:04.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"},{"id":93793,"sex":0,"name":"Mike","tag":"GES","head":"http://static.oschina.net/uploads/user/48/96331_50.jpg","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"id":93794,"sex":0,"name":"Lemon","head":"http://static.oschina.net/uploads/user/48/97721_50.jpg?t=1451544779000","contactIdList":[],"pictureList":[],"date":"2017-02-01 19:21:50.0"},{"id":1490109845208,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-03-21 23:24:05.0"},{"id":1490427139175,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[38710,70793],"pictureList":[],"date":"2017-03-25 15:32:19.0"},{"id":1490427577823,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-03-25 15:39:37.0"},{"id":1490584952968,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-03-27 11:22:32.0"},{"id":1492936169722,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-04-23 16:29:29.0"},{"id":1493480142628,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-04-29 23:35:42.0"},{"id":1493747512860,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-03 01:51:52.0"},{"id":1493747777770,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-03 01:56:17.0"},{"id":1493748594003,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-03 02:09:54.0"},{"id":1493748615711,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-03 02:10:15.0"},{"id":1493749090643,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-03 02:18:10.0"},{"id":1493836043151,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-04 02:27:23.0"},{"id":1493883110132,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-04 15:31:50.0"},{"id":1493890214167,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-04 17:30:14.0"},{"id":1493890303473,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-05-04 17:31:43.0"},{"id":1493890303474,"sex":0,"name":"Test Post","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-06-12 23:50:44.0"},{"id":1493890303475,"sex":0,"name":"Test Post","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-06-12 23:51:23.0"},{"id":1497792972314,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-06-18 21:36:12.0"},{"id":1497792972315,"sex":0,"name":"一二三","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-06-25 18:42:33.0"},{"id":1499057230629,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-07-03 12:47:10.0"},{"id":1500825221910,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-07-23 23:53:41.0"},{"id":1502638023483,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-08-13 23:27:03.0"},{"id":1502639062900,"sex":0,"name":"TESLA","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-08-13 23:44:22.0"},{"id":1502639424119,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-08-13 23:50:24.0"},{"id":1507220582167,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-10-06 00:23:02.0"},{"id":1508072071492,"sex":0,"name":"赵钱孙李","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-10-15 20:54:31.0"},{"id":1508072160401,"sex":0,"name":"四五六","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-10-15 20:56:00.0"},{"id":1508072202871,"sex":0,"name":"七八九十","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-10-15 20:56:42.0"},{"id":1510495628760,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-11-12 22:07:08.0"},{"id":1511407581570,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[82002,82003,82005,82006,82021,82023,82036,82033],"pictureList":[],"date":"2017-11-23 11:26:21.0"},{"id":1511761906715,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-11-27 13:51:46.0"},{"id":1511965911349,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-11-29 22:31:51.0"},{"id":1512387063078,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[],"pictureList":[],"date":"2017-12-04 19:31:03.0"},{"id":1512531601485,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[82001],"pictureList":[],"date":"2017-12-06 11:40:01.0"},{"id":1514623064133,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","date":"2017-12-30 16:37:44.0"},{"id":1514625918255,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[82002,93793],"date":"2017-12-30 17:25:18.0"},{"id":1514626163032,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","date":"2017-12-30 17:29:23.0"},{"id":1514858422969,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","contactIdList":[93793,82056],"date":"2018-01-02 10:00:22.0"},{"id":1515565976140,"sex":0,"name":"APIJSONUser","head":"傻","contactIdList":[82003,82021],"date":"2018-01-10 14:32:56.0"},{"id":1518218350585,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","date":"2018-02-10 07:19:10.0"},{"id":1519778917280,"sex":0,"name":"APIJSONUser","head":"http://my.oschina.net/img/portrait.gif?t=1451961935000","date":"2018-02-28 08:48:37.0"}],"code":200,"msg":"success"}', '2018-03-10 11:40:56.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520682589957, 82001, 1520682468690, '{"Moment":{"id":1520086403692,"userId":82001,"date":"2018-03-03 22:13:23.0","content":"测试新增动态","praiseUserIdList":[],"pictureList":["http://static.oschina.net/uploads/user/48/96331_50.jpg"]},"User":{"id":82001,"name":"测试改名","head":"http://static.oschina.net/uploads/user/19/39085_50.jpg"},"code":200,"msg":"success"}', '2018-03-10 11:49:49.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1520682742215, 82001, 1519526273822, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":28808},"code":200,"msg":"success"}', '2018-03-10 11:52:22.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1532879615717, 82001, 1521907333048, '{"User-id[]":[82002,82003,82005,82041,82045,82058,1512531601485,1528254173621],"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"]}],"code":200,"msg":"success"}', '2018-07-29 15:53:35.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1532879625816, 82001, 1521907333047, '{"[]":[{"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],"pictureList":["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg"]},"Comment":{"id":45,"momentId":301,"content":"This is a Content...-45"},"join":"&/User/id@,</Comment/momentId@"},{"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"]},"Comment":{"id":13,"momentId":58,"content":"This is a Content...-13"},"join":"&/User/id@,</Comment/momentId@"},{"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":68,"momentId":371,"content":"This is a Content...-68"},"join":"&/User/id@,</Comment/momentId@"},{"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":44,"momentId":170,"content":"This is a Content...-44"},"join":"&/User/id@,</Comment/momentId@"},{"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"},"Comment":{"id":4,"momentId":470,"content":"This is a Content...-4"},"join":"&/User/id@,</Comment/momentId@"},{"Moment":{"id":12,"userId":70793,"date":"2017-02-08 16:06:11.0","content":"1111534034","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,"momentId":12,"content":"This is a Content...-162"},"join":"&/User/id@,</Comment/momentId@"},{"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"},"Comment":{"id":176,"momentId":15,"content":"thank you"},"join":"&/User/id@,</Comment/momentId@"},{"Moment":{"id":543,"userId":93793,"date":"2017-02-08 16:06:11.0","praiseUserIdList":[82001],"pictureList":["https://camo.githubusercontent.com/5f5c4e0c4dc539c34e8eae8ac0cbc6dccdfee5d3/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343533333831362d323032373434343231382e6a7067","https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067","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_eGDi.jpg"]},"Comment":{"id":1490777905437,"momentId":543,"content":"rr"},"join":"&/User/id@,</Comment/momentId@"},{"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,"name":"Happy~","head":"http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000"},"Comment":{"id":1512035117021,"momentId":32,"content":"图片看不了啊"},"join":"&/User/id@,</Comment/momentId@"},{"Moment":{"id":551,"userId":70793,"date":"2017-02-08 16:06:11.0","content":"test","praiseUserIdList":[82001],"pictureList":["http://static.oschina.net/uploads/img/201604/22172507_Pz9Y.png"]},"User":{"id":70793,"name":"Strong","head":"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000"},"Comment":{"id":1490864039264,"momentId":551,"content":"Wonderful!"},"join":"&/User/id@,</Comment/momentId@"}],"code":200,"msg":"success"}', '2018-07-29 15:53:45.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140211536, 82001, 1521907303540, '{"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":[1520242280259,82030,82025,82003,93793,82002,1531969715979,82006,82005],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"}],"code":200,"msg":"success"}', '2018-08-01 16:16:51.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140331684, 82001, 1521905895591, '{"Moment":{"code":200,"msg":"success","count":11},"code":200,"msg":"success"}', '2018-08-01 16:18:51.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140553624, 82001, 1521903828410, '{"User":{"code":200,"msg":"success","count":70},"code":200,"msg":"success"}', '2018-08-01 16:22:33.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140565380, 82001, 1511796208670, '{"Verify":{"code":200,"msg":"success","count":1},"code":200,"msg":"success"}', '2018-08-01 16:22:45.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140569777, 82001, 1511796155277, '{"Verify":{"id":1533140566615,"type":0,"phone":13000082001,"verify":10867,"date":"2018-08-02 00:22:46.0"},"tag":"Verify","code":200,"msg":"success"}', '2018-08-01 16:22:49.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140576601, 82001, 1511796155277, '{"Verify":{"id":1533140571205,"type":0,"phone":13000082001,"verify":2383,"date":"2018-08-02 00:22:51.0"},"tag":"Verify","code":200,"msg":"success"}', '2018-08-01 16:22:56.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140600338, 82001, 1511967853340, '{"[]":[{"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],"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":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"}', '2018-08-01 16:23:20.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140607459, 82001, 1511964176689, '{"[]":[{"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":1520332892486,"userId":82001,"momentId":15,"date":"2018-03-06 18:41:32.0","content":"测试新增评论"},"User":{"id":82001,"name":"测试改名","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg"}},{"Comment":{"id":1525933236313,"userId":82001,"momentId":15,"date":"2018-05-10 14:20:36.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"}}],"code":200,"msg":"success"}', '2018-08-01 16:23:27.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140610051, 82001, 1511969630372, '{"Comment":{"code":200,"msg":"success","id":1533140601544,"count":1},"code":200,"msg":"success"}', '2018-08-01 16:23:30.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140615913, 82001, 1521905895591, '{"Moment":{"code":200,"msg":"success","count":19},"code":200,"msg":"success"}', '2018-08-01 16:23:35.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140617466, 82001, 1521905868719, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":9832.86},"code":200,"msg":"success"}', '2018-08-01 16:23:37.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140619001, 82001, 1521905680680, '{"Moment":{"code":200,"msg":"success","id":1533140610656,"count":1},"code":200,"msg":"success"}', '2018-08-01 16:23:39.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140623032, 82001, 1521904756674, '{"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":[1520242280259,82030,82025,82003,93793,82002,1531969715979,82006,82005],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"}],"code":200,"msg":"success"}', '2018-08-01 16:23:43.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140626067, 82001, 1521904653622, '{"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],"pictureList":[],"date":"2017-02-01 19:21:50.0"}],"code":200,"msg":"success"}', '2018-08-01 16:23:46.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140629710, 82001, 1521903761689, '{"User":{"code":200,"msg":"success","count":117},"code":200,"msg":"success"}', '2018-08-01 16:23:49.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140633031, 82001, 1521902110680, '{"[]":[{"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":[1520242280259,82030,82025,82003,93793,82002,1531969715979,82006,82005],"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"}', '2018-08-01 16:23:53.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140636466, 82001, 1521902033332, '{"[]":[{"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":[1520242280259,82030,82025,82003,93793,82002,1531969715979,82006,82005],"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":119,"code":200,"msg":"success"}', '2018-08-01 16:23:56.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140640270, 82001, 1521901682846, '{"[]":[{"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":1533140171134}}],"code":200,"msg":"success"}', '2018-08-01 16:24:00.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140662591, 82001, 1511970009072, '{"Moment":{"code":200,"msg":"success","id":1533140610716,"count":1},"code":200,"msg":"success"}', '2018-08-01 16:24:22.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140664191, 82001, 1511969630372, '{"Comment":{"code":200,"msg":"success","id":1533140610714,"count":1},"code":200,"msg":"success"}', '2018-08-01 16:24:24.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140666518, 82001, 1511963677325, '{"User":{"id":82001,"sex":0,"name":"测试改名","tag":"APIJSON User","head":"https://static.oschina.net/uploads/user/19/39085_50.jpg","contactIdList":[1520242280259,82030,82025,82003,93793,82002,1531969715979,82006,82005],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"code":200,"msg":"success"}', '2018-08-01 16:24:26.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140668867, 82001, 1511689914599, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":9833.01},"code":200,"msg":"success"}', '2018-08-01 16:24:28.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140694117, 82001, 1511963990072, '{"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,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"},"User[]":[{"id":38710,"name":"TommyLemon"},{"id":82001,"name":"测试改名"},{"id":82002,"name":"Happy~"},{"id":82055,"name":"Solid"}],"code":200,"msg":"success"}', '2018-08-01 16:24:54.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533140697885, 82001, 1511963990072, '{"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"}', '2018-08-01 16:24:57.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533396720929, 82001, 1511796155277, '{"Verify":{"id":1533396718012,"type":0,"phone":13000082001,"verify":4995,"date":"2018-08-04 23:31:58.0"},"tag":"Verify","code":200,"msg":"success"}', '2018-08-04 15:32:00.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533396731930, 82001, 1521901682846, '{"[]":[{"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":1533395051809}}],"code":200,"msg":"success"}', '2018-08-04 15:32:11.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533396739099, 82001, 1511689914599, '{"Privacy":{"id":82001,"certified":1,"phone":13000082001,"balance":9835.11},"code":200,"msg":"success"}', '2018-08-04 15:32:19.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1533396867840, 82001, 1511964176689, '{"[]":[{"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"}', '2018-08-04 15:34:27.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1534152309932, 82001, 1521905895591, '{"Moment":{"code":200,"msg":"success","count":9},"code":200,"msg":"success"}', '2018-08-13 09:25:09.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1534152344226, 82001, 1521903828410, '{"User":{"code":200,"msg":"success","count":71},"code":200,"msg":"success"}', '2018-08-13 09:25:44.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1534152350031, 82001, 1521903761689, '{"User":{"code":200,"msg":"success","count":118},"code":200,"msg":"success"}', '2018-08-13 09:25:50.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1534152388437, 82001, 1521905895591, '{"Moment":{"code":200,"msg":"success","count":10},"code":200,"msg":"success"}', '2018-08-13 09:26:28.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1534152406351, 82001, 1521902033332, '{"[]":[{"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":[82030,82025,82003,93793,82006,82002,1520242280259,82005,1531969715979,1532188114543,82024],"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":120,"code":200,"msg":"success"}', '2018-08-13 09:26:46.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1534152424378, 82001, 1521901682846, '{"[]":[{"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":1534152251941}}],"code":200,"msg":"success"}', '2018-08-13 09:27:04.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1534241166066, 82001, 1521901682846, '{"[]":[{"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":1534241152403}}],"code":200,"msg":"success"}', '2018-08-14 10:06:06.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1534477342518, 82001, 1521907303540, '{"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":[82030,82025,82003,93793,82006,82002,1520242280259,82005,1531969715979,82024],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"}],"code":200,"msg":"success"}', '2018-08-17 03:42:22.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1534776475640, 82001, 1521901610784, '{"[]":[{"Moment":{"userId":38710,"maxId":1534776429151}},{"Moment":{"userId":70793,"maxId":551}},{"Moment":{"userId":82001,"maxId":1534776370291}},{"Moment":{"userId":82002,"maxId":1531062713966}},{"Moment":{"userId":82003,"maxId":1508053762227}},{"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"}', '2018-08-20 14:47:55.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1534780207036, 82001, 1521907333047, '{"[]":[{"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"},"Comment":{"id":47,"momentId":470,"content":"This is a Content...-47"}},{"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"},"Comment":{"id":47,"momentId":470,"content":"This is a Content...-47"}},{"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":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"},"Comment":{"id":47,"momentId":470,"content":"This is a Content...-47"}},{"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":115,"momentId":371,"content":"This is a Content...-115"}},{"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":115,"momentId":371,"content":"This is a Content...-115"}},{"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":115,"momentId":371,"content":"This is a Content...-115"}},{"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":115,"momentId":371,"content":"This is a Content...-115"}}],"code":200,"msg":"success"}', '2018-08-20 15:50:07.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1536484351109, 82001, 1511963677325, '{"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,82034,82021,82006,82005,82030,82035],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"code":200,"msg":"success"}', '2018-09-09 09:12:31.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1536484428955, 82001, 1511963677325, '{"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,82034,82021,82006,82005,82030,82035],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"},"code":200,"msg":"success"}', '2018-09-09 09:13:48.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1537025782935, 82001, 1521901746809, '{"[]":[{"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"}', '2018-09-15 15:36:22.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1537025788659, 82001, 1521901682846, '{"[]":[{"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"}', '2018-09-15 15:36:28.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1537025791504, 82001, 1521901610784, '{"[]":[{"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"}', '2018-09-15 15:36:31.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1537025795194, 82001, 1521902033332, '{"[]":[{"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"}', '2018-09-15 15:36:35.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1537025798273, 82001, 1521903828410, '{"User":{"code":200,"msg":"success","count":72},"code":200,"msg":"success"}', '2018-09-15 15:36:38.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1537025799810, 82001, 1521903761689, '{"User":{"code":200,"msg":"success","count":119},"code":200,"msg":"success"}', '2018-09-15 15:36:39.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1537025801244, 82001, 1521902110680, '{"[]":[{"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"}', '2018-09-15 15:36:41.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1537025812404, 82001, 1521904653622, '{"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"}', '2018-09-15 15:36:52.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1537025813024, 82001, 1521904617127, '{"Moment":{"userId":93793,"praiseUserIdList":[38710,93793,82003,82005,82040,82055,82002,82001],"isPraised":true},"code":200,"msg":"success"}', '2018-09-15 15:36:53.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1537025814838, 82001, 1521904756674, '{"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,82012,82028,82021,82006,82030,82035],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"}],"code":200,"msg":"success"}', '2018-09-15 15:36:54.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1537025828828, 82001, 1521907303540, '{"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,82012,82028,82021,82006,82030,82035],"pictureList":["http://common.cnblogs.com/images/icon_weibo_24.png"],"date":"2017-02-01 19:21:50.0"}],"code":200,"msg":"success"}', '2018-09-15 15:37:08.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1537025834254, 82001, 1521907333048, '{"User-id[]":[82002,82003,82005,82041,82045,82058,1512531601485,1528254173621],"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],"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"]}],"code":200,"msg":"success"}', '2018-09-15 15:37:14.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1537025841443, 82001, 1511967853340, '{"[]":[{"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"}', '2018-09-15 15:37:21.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1537025843337, 82001, 1511963677325, '{"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"},"code":200,"msg":"success"}', '2018-09-15 15:37:23.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1538112293306, 82001, 1521907303540, '{"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"}', '2018-09-28 05:24:53.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1538112310565, 82001, 1521905680680, '{"Moment":{"code":200,"msg":"success","id":1538112282445,"count":1},"code":200,"msg":"success"}', '2018-09-28 05:25:10.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1538112311450, 82001, 1521904756674, '{"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"}', '2018-09-28 05:25:11.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1538731040138, 82001, 1511963677325, '{"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"}', '2018-10-05 09:17:20.000000', null, null);
INSERT INTO sys."TestRecord" (id, "userId", "documentId", response, date, compare, standard) VALUES (1538731046687, 82001, 1521907570452, '{"Moment":{"id":12,"userId":70793,"date":"2017-02-08 16:06:11.0","content":"1111534034","praiseUserIdList":[70793,93793,82044,82040,82055,90814,38710,82002,82006,1508072105320],"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"}', '2018-10-05 09:17:27.000000', null, null);