xtl/python----
6
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
python----/北川/demo.ipynb
T
admin aac9f5934d feat: 添加多个功能模块和工具脚本 
- 新增websocket客户端和服务端实现
- 添加图片压缩工具和快速压缩脚本
- 实现学生信息处理相关API
- 添加MQTT客户端和消息处理功能
- 更新.gitignore忽略更多文件类型
- 添加数据库操作工具和示例
- 实现多个测试脚本和工具类
2026-04-13 14:47:50 +08:00

593 lines
17 KiB
Plaintext
Raw Permalink Blame History

{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"id": "c9588f47",
"metadata": {},
"outputs": [],
"source": [
"from requests import get,post\n",
"import pandas as pd\n",
"import time\n",
"teamId = 106\n",
"ip = \"http://192.168.0.244:8100\"\n",
"# ip = 'http://10.143.25.3:8090'\n",
"param = {\n",
" \"username\": \"tangchao\",\n",
" \"password\": \"123456a\",\n",
" \"client_id\": \"client\",\n",
" \"grant_type\": \"password\",\n",
" \"client_secret\": \"123456\",\n",
"}\n",
"data = get(url=f\"{ip}/oauth/token\",params=param).json()\n",
"token = data[\"access_token\"]\n",
"header = {\n",
" \"content-type\": \"application/json\",\n",
" \"authorization\": f\"Bearer {token}\",\n",
"}"
]
},
{
"cell_type": "code",
"execution_count": 8,
"id": "2d1236e0",
"metadata": {},
"outputs": [],
"source": [
"data = get(\"http://192.168.0.209:8105/classAndRoom/nolist?teamId=106&access_token=2682259d-279c-425a-a260-daa57b94ed98\").json()"
]
},
{
"cell_type": "code",
"execution_count": 9,
"id": "b183905b",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"{'success': True,\n",
" 'msg': '操作成功',\n",
" 'code': 0,\n",
" 'data': [{'id': None,\n",
" 'classId': None,\n",
" 'roomId': 245,\n",
" 'className': None,\n",
" 'roomName': '1-202',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 246,\n",
" 'className': None,\n",
" 'roomName': '1-203',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 247,\n",
" 'className': None,\n",
" 'roomName': '1-204',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 248,\n",
" 'className': None,\n",
" 'roomName': '1-205',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 249,\n",
" 'className': None,\n",
" 'roomName': '1-206',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 250,\n",
" 'className': None,\n",
" 'roomName': '1-207',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 251,\n",
" 'className': None,\n",
" 'roomName': '1-301',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 252,\n",
" 'className': None,\n",
" 'roomName': '1-302',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 253,\n",
" 'className': None,\n",
" 'roomName': '1-303',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 254,\n",
" 'className': None,\n",
" 'roomName': '1-304',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 255,\n",
" 'className': None,\n",
" 'roomName': '1-305',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 256,\n",
" 'className': None,\n",
" 'roomName': '1-306',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 257,\n",
" 'className': None,\n",
" 'roomName': '1-307',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 258,\n",
" 'className': None,\n",
" 'roomName': '1-310',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 259,\n",
" 'className': None,\n",
" 'roomName': '1-402',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 261,\n",
" 'className': None,\n",
" 'roomName': '1-403',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 262,\n",
" 'className': None,\n",
" 'roomName': '1-404',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 263,\n",
" 'className': None,\n",
" 'roomName': '1-405',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 264,\n",
" 'className': None,\n",
" 'roomName': '1-406',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 265,\n",
" 'className': None,\n",
" 'roomName': '1-407',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 266,\n",
" 'className': None,\n",
" 'roomName': '1-410',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 267,\n",
" 'className': None,\n",
" 'roomName': '2-202',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 268,\n",
" 'className': None,\n",
" 'roomName': '2-203',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 269,\n",
" 'className': None,\n",
" 'roomName': '2-204',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 270,\n",
" 'className': None,\n",
" 'roomName': '2-205',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 271,\n",
" 'className': None,\n",
" 'roomName': '2-206',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 272,\n",
" 'className': None,\n",
" 'roomName': '2-207',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 273,\n",
" 'className': None,\n",
" 'roomName': '2-208',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 274,\n",
" 'className': None,\n",
" 'roomName': '2-209',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 284,\n",
" 'className': None,\n",
" 'roomName': '2-402',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 285,\n",
" 'className': None,\n",
" 'roomName': '2-403',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 286,\n",
" 'className': None,\n",
" 'roomName': '2-404',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 287,\n",
" 'className': None,\n",
" 'roomName': '2-405',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 288,\n",
" 'className': None,\n",
" 'roomName': '2-406',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 289,\n",
" 'className': None,\n",
" 'roomName': '2-407',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 290,\n",
" 'className': None,\n",
" 'roomName': '2-408',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 291,\n",
" 'className': None,\n",
" 'roomName': '2-409',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 292,\n",
" 'className': None,\n",
" 'roomName': '2-301',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 293,\n",
" 'className': None,\n",
" 'roomName': '2-302',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 294,\n",
" 'className': None,\n",
" 'roomName': '2-303',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 295,\n",
" 'className': None,\n",
" 'roomName': '2-304',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 296,\n",
" 'className': None,\n",
" 'roomName': '2-305',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 297,\n",
" 'className': None,\n",
" 'roomName': '2-306',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 298,\n",
" 'className': None,\n",
" 'roomName': '2-307',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 299,\n",
" 'className': None,\n",
" 'roomName': '2-308',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 300,\n",
" 'className': None,\n",
" 'roomName': '2-309',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 301,\n",
" 'className': None,\n",
" 'roomName': '1-210',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106},\n",
" {'id': None,\n",
" 'classId': None,\n",
" 'roomId': 302,\n",
" 'className': None,\n",
" 'roomName': '9-308',\n",
" 'gradeName': None,\n",
" 'gradeId': None,\n",
" 'classIds': None,\n",
" 'teamId': 106}]}"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data"
]
},
{
"cell_type": "code",
"execution_count": 8,
"id": "6d60192d",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"10.143.25.7\n",
"10.143.25.10\n",
"10.143.25.13\n",
"10.143.25.16\n",
"10.143.25.19\n",
"10.143.25.22\n",
"10.143.25.25\n",
"10.143.25.28\n",
"10.143.25.31\n",
"10.143.25.34\n",
"10.143.25.37\n",
"10.143.25.40\n",
"10.143.25.43\n",
"10.143.25.46\n",
"10.143.25.49\n",
"10.143.25.52\n",
"10.143.25.79\n",
"10.143.25.55\n",
"10.143.25.58\n",
"10.143.25.61\n",
"10.143.25.64\n",
"10.143.25.67\n",
"10.143.25.70\n",
"10.143.25.73\n",
"10.143.25.76\n",
"10.143.25.82\n",
"10.143.25.85\n",
"10.143.25.88\n",
"10.143.25.91\n",
"10.143.25.94\n",
"10.143.25.97\n",
"10.143.25.100\n",
"10.143.25.106\n",
"10.143.25.109\n",
"10.143.25.112\n",
"10.143.25.115\n",
"10.143.25.118\n",
"10.143.25.121\n",
"10.143.25.124\n",
"10.143.25.127\n",
"10.143.25.130\n",
"10.143.25.133\n",
"10.143.25.136\n",
"10.143.25.139\n",
"10.143.25.142\n",
"10.143.25.145\n",
"10.143.25.148\n",
"10.143.25.103\n"
]
}
],
"source": [
"for item in data[\"data\"][\"records\"]:\n",
" print(item[\"ip\"])"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "cb48d4bf",
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "base",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.12.4"
}
},
"nbformat": 4,
"nbformat_minor": 5
}
Reference in New Issue View Git Blame Copy Permalink