32 lines
1.1 KiB
Python
32 lines
1.1 KiB
Python
#这是学生就业系统的子路由
|
|
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
|
|
|
|
|
|
|
|
|