from fastapi import APIRouter, Depends
from sqlalchemy.orm import Session
from app.api.private_lablling import schema
from app.api.private_lablling.service import PrivateLabllingService
from app.database.main.mysql import get_db
from app.dependency.authantication import JWTPayloadSchema, get_current_student

private_lablling_router = APIRouter()

@private_lablling_router.post("/create_private_lablling", response_model_exclude_none=True)
async def create_private_lablling(request:schema.PrivateLabllingCreate, db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await PrivateLabllingService(db,token).create_private_lablling(request)

@private_lablling_router.get("/get_private_lablling", response_model_exclude_none=True)
async def get_private_lablling(private_get_id:int, db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await PrivateLabllingService(db,token).get_private_lablling(private_get_id)

@private_lablling_router.get("/get_group_private_lablling", response_model_exclude_none=True)
async def get_group_private_lablling(group_id:int, db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await PrivateLabllingService(db,token).get_group_private_lablling(group_id)

@private_lablling_router.get("/get_excel", response_model_exclude_none=True)
async def get_excel(group_id:int, db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await PrivateLabllingService(db,token).get_excel_data_category_name(group_id)

@private_lablling_router.put("/update_private_lablling", response_model_exclude_none=True)
async def update_private_lablling(request:schema.PrivateLabllingUpdate, db:Session =  Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await PrivateLabllingService(db,token).update_private_lablling(request)

@private_lablling_router.delete("/delete_private_lablling", response_model_exclude_none=True)
async def delete_private_lablling(group_id:int ,db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await PrivateLabllingService(db,token).delete_private_lablling(group_id)