批量调取接口_批量请求接口脚本

应用场景：本文以批量请求获取用户时长等级接口为例

接口文档：

代码思路：

1.使用Python连接数据库

2.获取account表符合条件的uid

3.将获取的uid作为参数请求接口

代码如下：

# coding = utf - 8

# 批量请求接口脚本

import requests

import pymysql

# 创建数据库连接

db = pymysql.connect(user="root", password="nswqSA@@$S113dd(()", port=3306, db="xchat2", host="47.91.110.137",

charset="utf8")

# 获取游标

cur = db.cursor()

# 使用xchat2数据库

cur.execute('use xchat2')

# 查询并打印数据

sql = "SELECT uid FROM account WHERE phone LIKE '852-944%';"

cur.execute(sql)

# result为元组

result = cur.fetchall()

# 将元组数据存进列表中

uid = []

for x in result:

uid.append(x[0])

url = "http://apibeta.allolike.com/userLevel/getOnline"

querystring = {"uid": 70005497}

headers = {

"User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36",

'Host': "apibeta.allolike.com",

}

i = 0

l = len(uid)

while i < l:

# 遍历SQL语句查询的uid值

querystring["uid"] = uid[i]

# print(querystring)

# 发送post请求

response = requests.post(url, headers=headers, params=querystring)

print(response.text)

i += 1

# 关闭游标

cur.close()

# 关闭数据库

db.close()