from fastapi import APIRouter

from app.db import fetch_view
from app.schemas.content import AboutStat, CoreValue, JobOpening, Testimonial

router = APIRouter(prefix="/api", tags=["collections"])


@router.get("/testimonials", response_model=list[Testimonial])
def list_testimonials() -> list[dict]:
    return fetch_view("vw_testimonials_public")


@router.get("/core-values", response_model=list[CoreValue])
def list_core_values() -> list[dict]:
    return fetch_view("vw_core_values_public")


@router.get("/about-stats", response_model=list[AboutStat])
def list_about_stats() -> list[dict]:
    return fetch_view("vw_about_stats_public")


@router.get("/job-openings", response_model=list[JobOpening])
def list_job_openings() -> list[dict]:
    return fetch_view("vw_job_openings_public")