查询聊天消息

[TOC]

简要描述

• 查询聊天消息

请求URL

• http://localhost:30001/QueryDB

请求方式

• POST

参数

参数名	类型	说明
dbname	string	数据库文件名(注意区分大小写)
sql	string	查询语句

发送示例

{
    "dbname":"MSG0.db",
    "sql":"select * from MSG where StrTalker = '25350948040@chatroom'"
}

返回示例

{
    "data": [
        {
            "localId": "35",
            "TalkerId": "10",
            "MsgSvrID": "2587501163508675819",
            "Type": "1",
            "SubType": "0",
            "IsSender": "0",
            "CreateTime": "1658807627",
            "Sequence": "1658807627000",
            "StatusEx": "0",
            "FlagEx": "0",
            "Status": "2",
            "MsgServerSeq": "1",
            "MsgSequence": "763738230",
            "StrTalker": "25350948040@chatroom",
            "StrContent": "[炸弹]酒泉、武威等多个地市确定27号开始资格复审，8月6日面试，面试时间紧张，省市县乡面试有啥区别？？老师正在讲，快来听课，听课入口：https://i.offcn.com/c/1095614?mis=lht74958\n\n[嘴唇]成绩排名还没发布，大家可以扫码查，出排名前报名面试班，交200抢占2000，最高优惠15000元，课程私聊即可咨询！！",
            "Reserved0": "0",
            "BytesExtra":"\n\b"
        },
        {
            "localId": "36",
            "TalkerId": "10",
            "MsgSvrID": "5705531825961494711",
            "Type": "3",
            "SubType": "0",
            "IsSender": "0",
            "CreateTime": "1658807627",
            "Sequence": "1658807627001",
            "StatusEx": "0",
            "FlagEx": "0",
            "Status": "2",
            "MsgServerSeq": "1",
            "MsgSequence": "763738231",
            "StrTalker": "25350948040@chatroom",
            "StrContent": "<?xml version=\"1.0\"?>\n<msg>\n\t<img aeskey=\"e03658d85f4d491db938ec9919bccdb9\" encryver=\"0\" cdnthumbaeskey=\"\" cdnthumburl=\"\" cdnthumblength=\"0\" cdnthumbheight=\"0\" cdnthumbwidth=\"0\" cdnmidheight=\"0\" cdnmidwidth=\"0\" cdnhdheight=\"0\" cdnhdwidth=\"0\" cdnmidimgurl=\"\" length=\"0\" tpthumburl=\"https://wwfile.work.weixin.qq.com/cgi-bin/download?f=3081900201020481883081850201000204235c386202030f55cb0204ae8e1e6f020462df6540044934376237373464332d383736302d346335622d623238632d3136353962633361363439385f66363262666335312d363563352d343666322d623138352d34343965393434663933313302010002030c97e0041060d10a04e0bf98459a62819a160c3ddb0201010201000400&t=69A9B890E8BE6A01CF7417D090DA1AC5EA0BCEA3537DB9AFD1589D5CB060C9D73598628E7BE920F8BE4A27198520AB610CFFB26FEE6AE57CCED0F9E165C4DB4BBF04B71F08D079319A70FAEAA17138E2486E295F5718C84307F4922AB98BA9473657592C607BF5A1B61A2C2385B9EE8C5E426620DE83DBA6C5C62D9788FC73A231410EC6CBA8CB0F5BC6080A7706932D6BDD203850311C159A764637AC56E78FFD7BC1E0F4D5D6907A55E4D295EA4B986BAE5D54D604F4A05F988E5618A720E04D1A69E7C56BA077532DD0E59CDAD3AC8525252682DCB3BB5A0BB50099D72F8A775AEA3D2306566C7F56FAAA9181C468CB6996546F7329D43C3F622BBD8AD96F785B32852D5D7BE1300BDD0B9396BAF3DF266188A20913A4708B2546A43D5F9B04AF454F4A0951C787FF1FECED3D55BF95B368914DE3D42C7444D8E368EDE32A85668692FA4FB98859506EE7FCF298A08F1850FBB929FA83B80090A57C336328&p=3\" tpthumblength=\"158989\" tpthumbheight=\"0\" tpthumbwidth=\"0\" tpthumbaeskey=\"e03658d85f4d491db938ec9919bccdb9\" tpurl=\"https://wwfile.work.weixin.qq.com/cgi-bin/download?f=3081900201020481883081850201000204235c386202030f55cb0204ae8e1e6f020462df6540044934376237373464332d383736302d346335622d623238632d3136353962633361363439385f66363262666335312d363563352d343666322d623138352d34343965393434663933313302010002030c97e0041060d10a04e0bf98459a62819a160c3ddb0201010201000400&t=69A9B890E8BE6A01CF7417D090DA1AC5EA0BCEA3537DB9AFD1589D5CB060C9D73598628E7BE920F8BE4A27198520AB610CFFB26FEE6AE57CCED0F9E165C4DB4BBF04B71F08D079319A70FAEAA17138E2486E295F5718C84307F4922AB98BA9473657592C607BF5A1B61A2C2385B9EE8C5E426620DE83DBA6C5C62D9788FC73A231410EC6CBA8CB0F5BC6080A7706932D6BDD203850311C159A764637AC56E78FFD7BC1E0F4D5D6907A55E4D295EA4B986BAE5D54D604F4A05F988E5618A720E04D1A69E7C56BA077532DD0E59CDAD3AC8525252682DCB3BB5A0BB50099D72F8A775AEA3D2306566C7F56FAAA9181C468CB6996546F7329D43C3F622BBD8AD96F785B32852D5D7BE1300BDD0B9396BAF3DF266188A20913A4708B2546A43D5F9B04AF454F4A0951C787FF1FECED3D55BF95B368914DE3D42C7444D8E368EDE32A85668692FA4FB98859506EE7FCF298A08F1850FBB929FA83B80090A57C336328&p=2\" tplength=\"173494\" tpheight=\"2160\" tpwidth=\"2160\" tpauthkey=\"0A2B6F4E2D4D77415141414141436A6E4B576975452D756D687A67457A3348354A646E40696D2E7778776F726B10E083DCE706\" tphdurl=\"https://wwfile.work.weixin.qq.com/cgi-bin/download?f=3081900201020481883081850201000204235c386202030f55cb0204ae8e1e6f020462df6540044934376237373464332d383736302d346335622d623238632d3136353962633361363439385f66363262666335312d363563352d343666322d623138352d34343965393434663933313302010002030c97e0041060d10a04e0bf98459a62819a160c3ddb0201010201000400&t=69A9B890E8BE6A01CF7417D090DA1AC5EA0BCEA3537DB9AFD1589D5CB060C9D73598628E7BE920F8BE4A27198520AB610CFFB26FEE6AE57CCED0F9E165C4DB4BBF04B71F08D079319A70FAEAA17138E2486E295F5718C84307F4922AB98BA9473657592C607BF5A1B61A2C2385B9EE8C5E426620DE83DBA6C5C62D9788FC73A231410EC6CBA8CB0F5BC6080A7706932D6BDD203850311C159A764637AC56E78FFD7BC1E0F4D5D6907A55E4D295EA4B986BAE5D54D604F4A05F988E5618A720E04D1A69E7C56BA077532DD0E59CDAD3AC8525252682DCB3BB5A0BB50099D72F8A775AEA3D2306566C7F56FAAA9181C468CB6996546F7329D43C3F622BBD8AD96F785B32852D5D7BE1300BDD0B9396BAF3DF266188A20913A4708B2546A43D5F9B04AF454F4A0951C787FF1FECED3D55BF95B368914DE3D42C7444D8E368EDE32A85668692FA4FB98859506EE7FCF298A08F1850FBB929FA83B80090A57C336328&p=1\" tphdlength=\"825300\" />\n</msg>\n",
            "Reserved0": "0",
            "BytesExtra":"\n\b"
        }
    ]
}

返回参数说明

参数名	类型	说明
data	string	查询到的数据

备注

• 更多返回错误代码请看首页的错误代码描述