115 lines
4.3 KiB
Python
115 lines
4.3 KiB
Python
from typing import Annotated
|
|
|
|
from fastapi import APIRouter, File, HTTPException, Query, UploadFile, status
|
|
from sqlalchemy import select
|
|
|
|
from app.core.deps import AnyAdmin, DbSession
|
|
from app.models import Service
|
|
from app.schemas.content import ServiceAdmin, ServiceCreate, ServicePublic, ServiceUpdate
|
|
from app.routes.single_image import image_files, remove_image, replace_image
|
|
from app.services.image_processing import delete_media_files
|
|
from app.utils.helpers import unique_slug
|
|
|
|
public_router = APIRouter(prefix="/services", tags=["Services"])
|
|
admin_router = APIRouter(prefix="/admin/services", tags=["Admin: services"])
|
|
|
|
_ORDER = (Service.sort_order, Service.id)
|
|
|
|
|
|
async def _get(db, service_id: int) -> Service:
|
|
service = await db.get(Service, service_id)
|
|
if not service:
|
|
raise HTTPException(status.HTTP_404_NOT_FOUND, "Service not found")
|
|
return service
|
|
|
|
|
|
@public_router.get("", response_model=list[ServicePublic], summary="Published services")
|
|
async def list_services(db: DbSession):
|
|
rows = await db.scalars(select(Service).where(Service.is_published.is_(True)).order_by(*_ORDER))
|
|
return [ServicePublic.build(s) for s in rows]
|
|
|
|
|
|
@public_router.get("/{id_or_slug}", response_model=ServicePublic)
|
|
async def get_service(id_or_slug: str, db: DbSession):
|
|
cond = Service.id == int(id_or_slug) if id_or_slug.isdigit() else Service.slug == id_or_slug
|
|
service = await db.scalar(select(Service).where(cond, Service.is_published.is_(True)))
|
|
if not service:
|
|
raise HTTPException(status.HTTP_404_NOT_FOUND, "Service not found")
|
|
return ServicePublic.build(service)
|
|
|
|
|
|
@admin_router.get("", response_model=list[ServiceAdmin])
|
|
async def admin_list_services(
|
|
_: AnyAdmin, db: DbSession, is_published: Annotated[bool | None, Query()] = None
|
|
):
|
|
stmt = select(Service).order_by(*_ORDER)
|
|
if is_published is not None:
|
|
stmt = stmt.where(Service.is_published.is_(is_published))
|
|
return [ServiceAdmin.build(s) for s in await db.scalars(stmt)]
|
|
|
|
|
|
@admin_router.get("/{service_id}", response_model=ServiceAdmin)
|
|
async def admin_get_service(service_id: int, _: AnyAdmin, db: DbSession):
|
|
return ServiceAdmin.build(await _get(db, service_id))
|
|
|
|
|
|
@admin_router.post("", response_model=ServiceAdmin, status_code=status.HTTP_201_CREATED)
|
|
async def create_service(body: ServiceCreate, _: AnyAdmin, db: DbSession):
|
|
data = body.model_dump()
|
|
data["slug"] = await unique_slug(db, Service, data["slug"] or data["title"])
|
|
service = Service(**data)
|
|
db.add(service)
|
|
await db.commit()
|
|
await db.refresh(service)
|
|
return ServiceAdmin.build(service)
|
|
|
|
|
|
@admin_router.put("/{service_id}", response_model=ServiceAdmin)
|
|
async def update_service(service_id: int, body: ServiceUpdate, _: AnyAdmin, db: DbSession):
|
|
service = await _get(db, service_id)
|
|
data = body.model_dump(exclude_unset=True)
|
|
for required in ("title", "sort_order", "is_published"):
|
|
if required in data and data[required] is None:
|
|
raise HTTPException(status.HTTP_422_UNPROCESSABLE_CONTENT, f"'{required}' cannot be null")
|
|
if data.get("slug"):
|
|
data["slug"] = await unique_slug(db, Service, data["slug"], exclude_id=service.id)
|
|
else:
|
|
data.pop("slug", None)
|
|
for key, value in data.items():
|
|
setattr(service, key, value)
|
|
await db.commit()
|
|
await db.refresh(service)
|
|
return ServiceAdmin.build(service)
|
|
|
|
|
|
@admin_router.delete("/{service_id}", status_code=status.HTTP_204_NO_CONTENT)
|
|
async def delete_service(service_id: int, _: AnyAdmin, db: DbSession):
|
|
service = await _get(db, service_id)
|
|
files = image_files(service)
|
|
await db.delete(service)
|
|
await db.commit()
|
|
delete_media_files(*files)
|
|
|
|
|
|
@admin_router.post(
|
|
"/{service_id}/image",
|
|
response_model=ServiceAdmin,
|
|
summary="Upload/replace the service image (auto-watermarked)",
|
|
)
|
|
async def upload_service_image(
|
|
service_id: int,
|
|
_: AnyAdmin,
|
|
db: DbSession,
|
|
file: Annotated[UploadFile, File(description="JPG/JPEG/PNG/WEBP image")],
|
|
):
|
|
service = await _get(db, service_id)
|
|
await replace_image(db, service, file)
|
|
return ServiceAdmin.build(service)
|
|
|
|
|
|
@admin_router.delete("/{service_id}/image", response_model=ServiceAdmin)
|
|
async def delete_service_image(service_id: int, _: AnyAdmin, db: DbSession):
|
|
service = await _get(db, service_id)
|
|
await remove_image(db, service)
|
|
return ServiceAdmin.build(service)
|