#这是学生就业系统的子路由
from fastapi import APIRouter, Depends, HTTPException, Query
from sqlalchemy.orm import Session
from dao.work_dao import WorkDao
from database import get_db
from scheme.works import StudentWorkCreate,StudentWorkCreate1,StudentWorks
router = APIRouter()
#这是添加学生就业信息接口
@router.post("/create")
def create_student(student: StudentWorkCreate,db:Session=Depends(get_db)):
    u1 = WorkDao.add_s_w(db,student)
    return u1
#这是获取学生就业信息接口
@router.post("/post")
def get_student(student1: StudentWorkCreate1,db:Session=Depends(get_db)):
    u2 = WorkDao.get_s_w(db,student1)
    return u2
#这是更新学生就业信息接口
@router.put("/put")
def put_student(student2: StudentWorks,db:Session=Depends(get_db)):
    u3 = WorkDao.update_s_w(db,student2)
    return u3
#这是删除学生就业信息接口
@router.delete("/delete")
def delete_student(user_id:int=Query(...,ge=1,le=10000,description="填入合法学生编号"),db:Session=Depends(get_db)):
    u4 = WorkDao.delete_s_w(db,user_id)
    return u4