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

25 KiB
Raw Permalink Blame History

In [3]:
from requests import get,post
import time
ip = "http://192.168.0.205:8101"
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 [4]:
get(f"{ip}/dorm/home/attendList",params={'teamId':106},headers=header).json()
Out [4]:
{'success': True, 'msg': '操作成功', 'code': 0, 'data': []}
In [6]:
get(f"{ip}/dorm/home/preList",params={'teamId':106},headers=header).json()
Out [6]:
{'success': True,
 'msg': '操作成功',
 'code': 0,
 'data': {'已满': 0, '维修中': 0, '空闲': 16, '未满': 0}}
In [18]:
a =  [
            {
                "id": 126,
                "dormId": 29,
                "stuId": None,
                "areaName": "达州校区",
                "dongName": "3栋",
                "tierName": "1层",
                "regionName": "全区域",
                "majorName": None,
                "departmentName": None,
                "dormName": "9009",
                "sex": None,
                "stuNo": None,
                "stuName": None,
                "gradeName": None,
                "className": None,
                "dormSex": 1,
                "intoState": None,
                "intoTime": None,
                "status": None,
                "stuState": None
            },
            {
                "id": 127,
                "dormId": 29,
                "stuId": 9131,
                "areaName": "达州校区",
                "dongName": "3栋",
                "tierName": "1层",
                "regionName": "全区域",
                "majorName": "汽车维修",
                "departmentName": "工程系3",
                "dormName": "9009",
                "sex": 2,
                "stuNo": "20250014",
                "stuName": "曾奕璟",
                "gradeName": "2025级",
                "className": "导师6班",
                "dormSex": 1,
                "intoState": None,
                "intoTime": None,
                "status": None,
                "stuState": None
            },
            {
                "id": 128,
                "dormId": 29,
                "stuId": None,
                "areaName": "达州校区",
                "dongName": "3栋",
                "tierName": "1层",
                "regionName": "全区域",
                "majorName": None,
                "departmentName": None,
                "dormName": "9009",
                "sex": None,
                "stuNo": None,
                "stuName": None,
                "gradeName": None,
                "className": None,
                "dormSex": 1,
                "intoState": None,
                "intoTime": None,
                "status": None,
                "stuState": None
            },
            {
                "id": 129,
                "dormId": 29,
                "stuId": None,
                "areaName": "达州校区",
                "dongName": "3栋",
                "tierName": "1层",
                "regionName": "全区域",
                "majorName": None,
                "departmentName": None,
                "dormName": "9009",
                "sex": None,
                "stuNo": None,
                "stuName": None,
                "gradeName": None,
                "className": None,
                "dormSex": 1,
                "intoState": None,
                "intoTime": None,
                "status": None,
                "stuState": None
            },
            {
                "id": 188,
                "dormId": 44,
                "stuId": None,
                "areaName": "达州校区",
                "dongName": "3栋",
                "tierName": "1层",
                "regionName": "全区域",
                "majorName": None,
                "departmentName": None,
                "dormName": "2334",
                "sex": None,
                "stuNo": None,
                "stuName": None,
                "gradeName": None,
                "className": None,
                "dormSex": 2,
                "intoState": None,
                "intoTime": None,
                "status": None,
                "stuState": None
            },
            {
                "id": 189,
                "dormId": 44,
                "stuId": None,
                "areaName": "达州校区",
                "dongName": "3栋",
                "tierName": "1层",
                "regionName": "全区域",
                "majorName": None,
                "departmentName": None,
                "dormName": "2334",
                "sex": None,
                "stuNo": None,
                "stuName": None,
                "gradeName": None,
                "className": None,
                "dormSex": 2,
                "intoState": None,
                "intoTime": None,
                "status": None,
                "stuState": None
            },
            {
                "id": 190,
                "dormId": 44,
                "stuId": 9135,
                "areaName": "达州校区",
                "dongName": "3栋",
                "tierName": "1层",
                "regionName": "全区域",
                "majorName": "汽车维修",
                "departmentName": "工程系3",
                "dormName": "2334",
                "sex": 1,
                "stuNo": "20250115",
                "stuName": "龚奕成",
                "gradeName": "2025级",
                "className": "导师6班",
                "dormSex": 2,
                "intoState": None,
                "intoTime": None,
                "status": None,
                "stuState": None
            },
            {
                "id": 191,
                "dormId": 44,
                "stuId": None,
                "areaName": "达州校区",
                "dongName": "3栋",
                "tierName": "1层",
                "regionName": "全区域",
                "majorName": None,
                "departmentName": None,
                "dormName": "2334",
                "sex": None,
                "stuNo": None,
                "stuName": None,
                "gradeName": None,
                "className": None,
                "dormSex": 2,
                "intoState": None,
                "intoTime": None,
                "status": None,
                "stuState": None
            },
            {
                "id": 196,
                "dormId": 46,
                "stuId": None,
                "areaName": "食堂",
                "dongName": "一食堂",
                "tierName": "1楼",
                "regionName": "东门区域",
                "majorName": None,
                "departmentName": None,
                "dormName": "34567",
                "sex": None,
                "stuNo": None,
                "stuName": None,
                "gradeName": None,
                "className": None,
                "dormSex": 2,
                "intoState": None,
                "intoTime": None,
                "status": None,
                "stuState": None
            },
            {
                "id": 197,
                "dormId": 46,
                "stuId": None,
                "areaName": "食堂",
                "dongName": "一食堂",
                "tierName": "1楼",
                "regionName": "东门区域",
                "majorName": None,
                "departmentName": None,
                "dormName": "34567",
                "sex": None,
                "stuNo": None,
                "stuName": None,
                "gradeName": None,
                "className": None,
                "dormSex": 2,
                "intoState": None,
                "intoTime": None,
                "status": None,
                "stuState": None
            },
            {
                "id": 198,
                "dormId": 46,
                "stuId": 9139,
                "areaName": "食堂",
                "dongName": "一食堂",
                "tierName": "1楼",
                "regionName": "东门区域",
                "majorName": "汽车维修",
                "departmentName": "工程系3",
                "dormName": "34567",
                "sex": 1,
                "stuNo": "20250286",
                "stuName": "刘坤鹏",
                "gradeName": "2025级",
                "className": "导师6班",
                "dormSex": 2,
                "intoState": None,
                "intoTime": None,
                "status": None,
                "stuState": None
            },
            {
                "id": 199,
                "dormId": 46,
                "stuId": 9140,
                "areaName": "食堂",
                "dongName": "一食堂",
                "tierName": "1楼",
                "regionName": "东门区域",
                "majorName": "汽车维修",
                "departmentName": "工程系3",
                "dormName": "34567",
                "sex": 1,
                "stuNo": "20250291",
                "stuName": "刘书豪",
                "gradeName": "2025级",
                "className": "导师6班",
                "dormSex": 2,
                "intoState": None,
                "intoTime": None,
                "status": None,
                "stuState": None
            },
            {
                "id": 216,
                "dormId": 51,
                "stuId": 9141,
                "areaName": "达州校区",
                "dongName": "3栋",
                "tierName": "1层",
                "regionName": "全区域",
                "majorName": "汽车维修",
                "departmentName": "工程系3",
                "dormName": "31",
                "sex": 1,
                "stuNo": "20250324",
                "stuName": "卢林",
                "gradeName": "2025级",
                "className": "导师6班",
                "dormSex": 2,
                "intoState": None,
                "intoTime": None,
                "status": None,
                "stuState": None
            },
            {
                "id": 217,
                "dormId": 51,
                "stuId": 9142,
                "areaName": "达州校区",
                "dongName": "3栋",
                "tierName": "1层",
                "regionName": "全区域",
                "majorName": "汽车维修",
                "departmentName": "工程系3",
                "dormName": "31",
                "sex": 1,
                "stuNo": "20250342",
                "stuName": "骆晨博",
                "gradeName": "2025级",
                "className": "导师6班",
                "dormSex": 2,
                "intoState": None,
                "intoTime": None,
                "status": None,
                "stuState": None
            },
            {
                "id": 218,
                "dormId": 51,
                "stuId": 9151,
                "areaName": "达州校区",
                "dongName": "3栋",
                "tierName": "1层",
                "regionName": "全区域",
                "majorName": "汽车维修",
                "departmentName": "工程系3",
                "dormName": "31",
                "sex": 1,
                "stuNo": "20250553",
                "stuName": "熊启豪",
                "gradeName": "2025级",
                "className": "导师6班",
                "dormSex": 2,
                "intoState": None,
                "intoTime": None,
                "status": None,
                "stuState": None
            }
        ]
In [19]:
a[0]
Out [19]:
{'id': 126,
 'dormId': 29,
 'stuId': None,
 'areaName': '达州校区',
 'dongName': '3栋',
 'tierName': '1层',
 'regionName': '全区域',
 'majorName': None,
 'departmentName': None,
 'dormName': '9009',
 'sex': None,
 'stuNo': None,
 'stuName': None,
 'gradeName': None,
 'className': None,
 'dormSex': 1,
 'intoState': None,
 'intoTime': None,
 'status': None,
 'stuState': None}
In [22]:
ids = []
for item in a:
    print(item)
    if item['stuId']:
        ids.append(item['stuId'])
{'id': 126, 'dormId': 29, 'stuId': None, 'areaName': '达州校区', 'dongName': '3栋', 'tierName': '1层', 'regionName': '全区域', 'majorName': None, 'departmentName': None, 'dormName': '9009', 'sex': None, 'stuNo': None, 'stuName': None, 'gradeName': None, 'className': None, 'dormSex': 1, 'intoState': None, 'intoTime': None, 'status': None, 'stuState': None}
{'id': 127, 'dormId': 29, 'stuId': 9131, 'areaName': '达州校区', 'dongName': '3栋', 'tierName': '1层', 'regionName': '全区域', 'majorName': '汽车维修', 'departmentName': '工程系3', 'dormName': '9009', 'sex': 2, 'stuNo': '20250014', 'stuName': '曾奕璟', 'gradeName': '2025级', 'className': '导师6班', 'dormSex': 1, 'intoState': None, 'intoTime': None, 'status': None, 'stuState': None}
{'id': 128, 'dormId': 29, 'stuId': None, 'areaName': '达州校区', 'dongName': '3栋', 'tierName': '1层', 'regionName': '全区域', 'majorName': None, 'departmentName': None, 'dormName': '9009', 'sex': None, 'stuNo': None, 'stuName': None, 'gradeName': None, 'className': None, 'dormSex': 1, 'intoState': None, 'intoTime': None, 'status': None, 'stuState': None}
{'id': 129, 'dormId': 29, 'stuId': None, 'areaName': '达州校区', 'dongName': '3栋', 'tierName': '1层', 'regionName': '全区域', 'majorName': None, 'departmentName': None, 'dormName': '9009', 'sex': None, 'stuNo': None, 'stuName': None, 'gradeName': None, 'className': None, 'dormSex': 1, 'intoState': None, 'intoTime': None, 'status': None, 'stuState': None}
{'id': 188, 'dormId': 44, 'stuId': None, 'areaName': '达州校区', 'dongName': '3栋', 'tierName': '1层', 'regionName': '全区域', 'majorName': None, 'departmentName': None, 'dormName': '2334', 'sex': None, 'stuNo': None, 'stuName': None, 'gradeName': None, 'className': None, 'dormSex': 2, 'intoState': None, 'intoTime': None, 'status': None, 'stuState': None}
{'id': 189, 'dormId': 44, 'stuId': None, 'areaName': '达州校区', 'dongName': '3栋', 'tierName': '1层', 'regionName': '全区域', 'majorName': None, 'departmentName': None, 'dormName': '2334', 'sex': None, 'stuNo': None, 'stuName': None, 'gradeName': None, 'className': None, 'dormSex': 2, 'intoState': None, 'intoTime': None, 'status': None, 'stuState': None}
{'id': 190, 'dormId': 44, 'stuId': 9135, 'areaName': '达州校区', 'dongName': '3栋', 'tierName': '1层', 'regionName': '全区域', 'majorName': '汽车维修', 'departmentName': '工程系3', 'dormName': '2334', 'sex': 1, 'stuNo': '20250115', 'stuName': '龚奕成', 'gradeName': '2025级', 'className': '导师6班', 'dormSex': 2, 'intoState': None, 'intoTime': None, 'status': None, 'stuState': None}
{'id': 191, 'dormId': 44, 'stuId': None, 'areaName': '达州校区', 'dongName': '3栋', 'tierName': '1层', 'regionName': '全区域', 'majorName': None, 'departmentName': None, 'dormName': '2334', 'sex': None, 'stuNo': None, 'stuName': None, 'gradeName': None, 'className': None, 'dormSex': 2, 'intoState': None, 'intoTime': None, 'status': None, 'stuState': None}
{'id': 196, 'dormId': 46, 'stuId': None, 'areaName': '食堂', 'dongName': '一食堂', 'tierName': '1楼', 'regionName': '东门区域', 'majorName': None, 'departmentName': None, 'dormName': '34567', 'sex': None, 'stuNo': None, 'stuName': None, 'gradeName': None, 'className': None, 'dormSex': 2, 'intoState': None, 'intoTime': None, 'status': None, 'stuState': None}
{'id': 197, 'dormId': 46, 'stuId': None, 'areaName': '食堂', 'dongName': '一食堂', 'tierName': '1楼', 'regionName': '东门区域', 'majorName': None, 'departmentName': None, 'dormName': '34567', 'sex': None, 'stuNo': None, 'stuName': None, 'gradeName': None, 'className': None, 'dormSex': 2, 'intoState': None, 'intoTime': None, 'status': None, 'stuState': None}
{'id': 198, 'dormId': 46, 'stuId': 9139, 'areaName': '食堂', 'dongName': '一食堂', 'tierName': '1楼', 'regionName': '东门区域', 'majorName': '汽车维修', 'departmentName': '工程系3', 'dormName': '34567', 'sex': 1, 'stuNo': '20250286', 'stuName': '刘坤鹏', 'gradeName': '2025级', 'className': '导师6班', 'dormSex': 2, 'intoState': None, 'intoTime': None, 'status': None, 'stuState': None}
{'id': 199, 'dormId': 46, 'stuId': 9140, 'areaName': '食堂', 'dongName': '一食堂', 'tierName': '1楼', 'regionName': '东门区域', 'majorName': '汽车维修', 'departmentName': '工程系3', 'dormName': '34567', 'sex': 1, 'stuNo': '20250291', 'stuName': '刘书豪', 'gradeName': '2025级', 'className': '导师6班', 'dormSex': 2, 'intoState': None, 'intoTime': None, 'status': None, 'stuState': None}
{'id': 216, 'dormId': 51, 'stuId': 9141, 'areaName': '达州校区', 'dongName': '3栋', 'tierName': '1层', 'regionName': '全区域', 'majorName': '汽车维修', 'departmentName': '工程系3', 'dormName': '31', 'sex': 1, 'stuNo': '20250324', 'stuName': '卢林', 'gradeName': '2025级', 'className': '导师6班', 'dormSex': 2, 'intoState': None, 'intoTime': None, 'status': None, 'stuState': None}
{'id': 217, 'dormId': 51, 'stuId': 9142, 'areaName': '达州校区', 'dongName': '3栋', 'tierName': '1层', 'regionName': '全区域', 'majorName': '汽车维修', 'departmentName': '工程系3', 'dormName': '31', 'sex': 1, 'stuNo': '20250342', 'stuName': '骆晨博', 'gradeName': '2025级', 'className': '导师6班', 'dormSex': 2, 'intoState': None, 'intoTime': None, 'status': None, 'stuState': None}
{'id': 218, 'dormId': 51, 'stuId': 9151, 'areaName': '达州校区', 'dongName': '3栋', 'tierName': '1层', 'regionName': '全区域', 'majorName': '汽车维修', 'departmentName': '工程系3', 'dormName': '31', 'sex': 1, 'stuNo': '20250553', 'stuName': '熊启豪', 'gradeName': '2025级', 'className': '导师6班', 'dormSex': 2, 'intoState': None, 'intoTime': None, 'status': None, 'stuState': None}
In [ ]:
get(f"{ip}/dorm/home/attendWeek", params={"teamId": 106}, headers=header).json()
{'success': True,
 'msg': '操作成功',
 'code': 0,
 'data': [{'date': '10-13', 'female': 0, 'male': 0},
  {'date': '10-14', 'female': 0, 'male': 0},
  {'date': '10-15', 'female': 0, 'male': 0},
  {'date': '10-16', 'female': 0, 'male': 0},
  {'date': '10-17', 'female': 1, 'male': 3},
  {'date': '10-18', 'female': 0, 'male': 0},
  {'date': '10-19', 'female': 0, 'male': 0}]}
在当前单元格或上一个单元格中执行代码时 Kernel 崩溃。

请查看单元格中的代码，以确定故障的可能原因。

单击<a href='https://aka.ms/vscodeJupyterKernelCrash'>此处</a>了解详细信息。

有关更多详细信息，请查看 Jupyter <a href='command:jupyter.viewOutput'>log</a>。
In [ ]:
Reference in New Issue View Git Blame Copy Permalink