xtl/python----
6
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
python----/智慧校园/本部/生成单个学生课表.ipynb
T
admin 2d8c1ea8f9 chore: 批量新增各类工具脚本与配置文件 
1. 新增音频录制、下载、上传相关脚本
2. 新增数据库操作、API调用工具
3. 新增Excel数据处理脚本
4. 新增弱密码检测脚本
2026-06-14 17:47:15 +08:00

17 KiB
Raw Permalink Blame History

In [ ]:
In [ ]:
'{"success":true,"msg":"操作成功","code":0,"data":null}'
In [ ]:
In [2]:
grade_id = [110,120,124, 126,127,128,  114,119,129]
sql = f'''
select 
  mm.id,
  mm.stu_no,
  mm.stu_name,
  bb.student_id,
  mm.plan_id  -- 这里直接显示 plan_id
from (
  select 
    s.id,
    s.stu_no,
    s.stu_name,
    a.plan_id  -- 子查询把 plan_id 带出来
  from student s 
  inner join class_attend_stu a on s.id = a.student_id
  where s.grade_id in ({",".join(map(str,grade_id))}) 
  and a.plan_id=41
  group by s.id, s.stu_no, s.stu_name, a.plan_id
) mm 
left join (
  select DISTINCT c.student_id 
  from class_attend c 
  where c.attend_date BETWEEN '2026-05-25' and '2026-05-31' 
  and c.student_id in (
    select DISTINCT a.student_id 
    from class_attend_stu a 
    where a.plan_id=41
  )
) bb on mm.id = bb.student_id 
WHERE bb.student_id is null
'''
cursor.execute(sql)
result = cursor.fetchall()
data = create_table(cursor,result)
print(data)
[]
In [11]:
for item in data:
    res = post(f"{ip}/classAttendStu/createThisWeekStu",headers=header,params={"stuId":item["id"],"planId":item["plan_id"]},timeout=600).text
    print(res)

{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
{"success":true,"msg":"操作成功","code":0,"data":null}
Reference in New Issue View Git Blame Copy Permalink