from typing import List from fastapi import APIRouter, Depends, HTTPException from sqlalchemy.orm import Session from app.database.session import get_db from app.models.models import Class, Student from app.schemas.schemas import ClassCreate, ClassUpdate, ClassOut, StudentOut from app.core.security import get_current_user_token router = APIRouter(prefix="/classes", tags=["Classes"]) @router.get("", response_model=List[ClassOut]) def get_classes(db: Session = Depends(get_db), token: dict = Depends(get_current_user_token)): classes = db.query(Class).all() results = [] for c in classes: student_count = db.query(Student).filter(Student.class_id == c.id, Student.active == True).count() c_out = ClassOut.model_validate(c) c_out.student_count = student_count results.append(c_out) return results @router.post("", response_model=ClassOut) def create_class(req: ClassCreate, db: Session = Depends(get_db), token: dict = Depends(get_current_user_token)): cls = Class( name=req.name, section=req.section, academic_year=req.academic_year ) db.add(cls) db.commit() db.refresh(cls) cls_out = ClassOut.model_validate(cls) cls_out.student_count = 0 return cls_out @router.get("/{class_id}/students", response_model=List[StudentOut]) def get_class_students(class_id: int, db: Session = Depends(get_db), token: dict = Depends(get_current_user_token)): students = db.query(Student).filter(Student.class_id == class_id, Student.active == True).all() results = [] for s in students: s_out = StudentOut.model_validate(s) s_out.face_count = len(s.embeddings) results.append(s_out) return results @router.put("/{class_id}", response_model=ClassOut) @router.patch("/{class_id}", response_model=ClassOut) def update_class( class_id: int, req: ClassUpdate, db: Session = Depends(get_db), token: dict = Depends(get_current_user_token) ): cls = db.query(Class).filter(Class.id == class_id).first() if not cls: raise HTTPException(status_code=404, detail="Class not found") if req.name is not None: cls.name = req.name if req.section is not None: cls.section = req.section if req.academic_year is not None: cls.academic_year = req.academic_year db.commit() db.refresh(cls) student_count = db.query(Student).filter(Student.class_id == cls.id, Student.active == True).count() cls_out = ClassOut.model_validate(cls) cls_out.student_count = student_count return cls_out @router.delete("/{class_id}") def delete_class(class_id: int, db: Session = Depends(get_db), token: dict = Depends(get_current_user_token)): cls = db.query(Class).filter(Class.id == class_id).first() if not cls: raise HTTPException(status_code=404, detail="Class not found") db.delete(cls) db.commit() return {"message": f"Class '{cls.name}' successfully deleted."}