from fastapi import APIRouter, Depends, Query, status
from sqlalchemy.orm import Session
from utils.utils import get_db
from . import handler
from .schema import SubmissionCreate, SubmissionUpdate, SubmissionResponse, PaginatedSubmissionResponse

router = APIRouter(prefix="/submissions", tags=["Submissions"])


@router.post(
    "/",
    response_model=SubmissionResponse,
    status_code=status.HTTP_201_CREATED,
    summary="Create New Submission",
    description="Creates a new submission record with name and email. Validates that name contains at least 2 characters and does not exceed 100 characters, and that email does not exceed 255 characters. Returns 400 if validation constraints are violated.",
)
def create_submission_route(data: SubmissionCreate, db: Session = Depends(get_db)):
    return handler.create_submission(db, data)


@router.get(
    "/",
    response_model=PaginatedSubmissionResponse,
    summary="List All Submissions",
    description="Returns a paginated list of all submissions ordered by creation date descending (newest first). Supports optional email filter and pagination via limit and offset parameters.",
)
def list_submissions_route(
    limit: int = Query(20, ge=1),
    offset: int = Query(0, ge=0),
    email: str | None = Query(None),
    db: Session = Depends(get_db),
):
    return handler.list_submissions(db, limit, offset, email=email)


@router.get(
    "/{submission_id}",
    response_model=SubmissionResponse,
    summary="Get Submission By ID",
    description="Retrieves a single submission by its unique identifier. Returns 404 if the submission does not exist.",
)
def get_submission_route(submission_id: str, db: Session = Depends(get_db)):
    return handler.get_submission(db, submission_id)


@router.patch(
    "/{submission_id}",
    response_model=SubmissionResponse,
    summary="Update Submission",
    description="Updates an existing submission record. Only provided fields are updated. Returns 404 if submission not found, 400 if validation constraints are violated.",
)
def update_submission_route(
    submission_id: str,
    data: SubmissionUpdate,
    db: Session = Depends(get_db),
):
    return handler.update_submission(db, submission_id, data)


@router.delete(
    "/{submission_id}",
    status_code=status.HTTP_204_NO_CONTENT,
    summary="Delete Submission",
    description="Deletes an existing submission record. Returns 404 if submission not found, 409 if deletion would violate referential integrity.",
)
def delete_submission_route(submission_id: str, db: Session = Depends(get_db)):
    handler.delete_submission(db, submission_id)