from fastapi import APIRouter, HTTPException

from app.db import fetch_view
from app.schemas.content import BlogPost

router = APIRouter(prefix="/api", tags=["blog"])
VIEW = "vw_blog_posts_public"


@router.get("/blog-posts", response_model=list[BlogPost])
def list_blog_posts() -> list[dict]:
    return fetch_view(VIEW)


@router.get("/blog-posts/{slug}", response_model=BlogPost)
def get_blog_post(slug: str) -> dict:
    rows = fetch_view(VIEW, "slug = :slug", {"slug": slug})
    if not rows:
        raise HTTPException(status_code=404, detail="Blog post not found")
    return rows[0]