- 新增websocket客户端和服务端实现 - 添加图片压缩工具和快速压缩脚本 - 实现学生信息处理相关API - 添加MQTT客户端和消息处理功能 - 更新.gitignore忽略更多文件类型 - 添加数据库操作工具和示例 - 实现多个测试脚本和工具类
17 KiB
17 KiB
In [1]:
from requests import get,post
import pandas as pd
import time
teamId = 106
ip = "http://192.168.0.244:8100"
# ip = 'http://10.143.25.3:8090'
param = {
"username": "tangchao",
"password": "123456a",
"client_id": "client",
"grant_type": "password",
"client_secret": "123456",
}
data = get(url=f"{ip}/oauth/token",params=param).json()
token = data["access_token"]
header = {
"content-type": "application/json",
"authorization": f"Bearer {token}",
}In [8]:
data = get("http://192.168.0.209:8105/classAndRoom/nolist?teamId=106&access_token=2682259d-279c-425a-a260-daa57b94ed98").json()In [9]:
dataOut [9]:
{'success': True,
'msg': '操作成功',
'code': 0,
'data': [{'id': None,
'classId': None,
'roomId': 245,
'className': None,
'roomName': '1-202',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 246,
'className': None,
'roomName': '1-203',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 247,
'className': None,
'roomName': '1-204',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 248,
'className': None,
'roomName': '1-205',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 249,
'className': None,
'roomName': '1-206',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 250,
'className': None,
'roomName': '1-207',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 251,
'className': None,
'roomName': '1-301',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 252,
'className': None,
'roomName': '1-302',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 253,
'className': None,
'roomName': '1-303',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 254,
'className': None,
'roomName': '1-304',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 255,
'className': None,
'roomName': '1-305',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 256,
'className': None,
'roomName': '1-306',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 257,
'className': None,
'roomName': '1-307',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 258,
'className': None,
'roomName': '1-310',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 259,
'className': None,
'roomName': '1-402',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 261,
'className': None,
'roomName': '1-403',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 262,
'className': None,
'roomName': '1-404',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 263,
'className': None,
'roomName': '1-405',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 264,
'className': None,
'roomName': '1-406',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 265,
'className': None,
'roomName': '1-407',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 266,
'className': None,
'roomName': '1-410',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 267,
'className': None,
'roomName': '2-202',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 268,
'className': None,
'roomName': '2-203',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 269,
'className': None,
'roomName': '2-204',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 270,
'className': None,
'roomName': '2-205',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 271,
'className': None,
'roomName': '2-206',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 272,
'className': None,
'roomName': '2-207',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 273,
'className': None,
'roomName': '2-208',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 274,
'className': None,
'roomName': '2-209',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 284,
'className': None,
'roomName': '2-402',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 285,
'className': None,
'roomName': '2-403',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 286,
'className': None,
'roomName': '2-404',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 287,
'className': None,
'roomName': '2-405',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 288,
'className': None,
'roomName': '2-406',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 289,
'className': None,
'roomName': '2-407',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 290,
'className': None,
'roomName': '2-408',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 291,
'className': None,
'roomName': '2-409',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 292,
'className': None,
'roomName': '2-301',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 293,
'className': None,
'roomName': '2-302',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 294,
'className': None,
'roomName': '2-303',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 295,
'className': None,
'roomName': '2-304',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 296,
'className': None,
'roomName': '2-305',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 297,
'className': None,
'roomName': '2-306',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 298,
'className': None,
'roomName': '2-307',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 299,
'className': None,
'roomName': '2-308',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 300,
'className': None,
'roomName': '2-309',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 301,
'className': None,
'roomName': '1-210',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106},
{'id': None,
'classId': None,
'roomId': 302,
'className': None,
'roomName': '9-308',
'gradeName': None,
'gradeId': None,
'classIds': None,
'teamId': 106}]}In [8]:
for item in data["data"]["records"]:
print(item["ip"])10.143.25.7 10.143.25.10 10.143.25.13 10.143.25.16 10.143.25.19 10.143.25.22 10.143.25.25 10.143.25.28 10.143.25.31 10.143.25.34 10.143.25.37 10.143.25.40 10.143.25.43 10.143.25.46 10.143.25.49 10.143.25.52 10.143.25.79 10.143.25.55 10.143.25.58 10.143.25.61 10.143.25.64 10.143.25.67 10.143.25.70 10.143.25.73 10.143.25.76 10.143.25.82 10.143.25.85 10.143.25.88 10.143.25.91 10.143.25.94 10.143.25.97 10.143.25.100 10.143.25.106 10.143.25.109 10.143.25.112 10.143.25.115 10.143.25.118 10.143.25.121 10.143.25.124 10.143.25.127 10.143.25.130 10.143.25.133 10.143.25.136 10.143.25.139 10.143.25.142 10.143.25.145 10.143.25.148 10.143.25.103
In [ ]: