python 使用POST传送列表的方法

最新推荐文章于 2023-06-19 09:30:00 发布

原始新人类

最新推荐文章于 2023-06-19 09:30:00 发布

阅读量709

点赞数

文章标签： html python

本文链接：https://blog.csdn.net/kdyangj/article/details/130515347

版权

发送端：调用服务端api接口

import requests
import json

url = "http://127.0.0.1:5000/getuserinfo"

postdata = json.dumps([{"userid":"123"}, {"userid":"124"}, {"userid":"789"}])

headers = {"Content-Type": "application/json"}

response = requests.request("POST", url, headers=headers, data=postdata)

print(response.text)

服务端：

import pymysql
from public import conn
import json
import datetime
from flask import Blueprint, request

# 获取user状态
@app.route('/getuserinfo', methods=['POST'])
def getuserinfo():
    jsdata = request.json
    print(jsdata)

    userids = ''
    for user in jsdata:
        userids += user['userid'] + ','

    # 去掉最后一个逗号
    userids= userids[0:-1]
    print(userids)

    # 查询数据库
    cur = conn.cursor(pymysql.cursors.DictCursor)

    sql = "SELECT a.id AS userid,a.`status` AS userstate,b.username\n" \
          "FROM t_user a\n"
          f"WHERE a.id IN ({userids})\n"

    print(sql)
    cur.execute(sql)
    content = cur.fetchall()
    rtndata = json.dumps({"code": 200, "msg": "success", "data": {'info': content}}, ensure_ascii=False)

    return rtndata