PRINTFILM: AI short-video marketing and AI short-drama creation platform
# Admin template CRUD
from fastapi import APIRouter, Depends, HTTPException, Query
from sqlalchemy import cast, func, or_, select
from sqlalchemy.dialects.postgresql import JSONB
from sqlalchemy.ext.asyncio import AsyncSession
from app.database import get_db
from app.deps import get_current_admin
from app.models import Project, Template, User
from app.schemas import (
AdminTemplateCreate,
AdminTemplateListOut,
AdminTemplateOut,
AdminTemplatePatch,
PageMeta,
)
router = APIRouter()
@router.get("/templates/meta",
summary="获取模板分类选项",
description="管理员读取全库模板的分类标签,返回去重并排序后的 categories,用于管理端筛选。",
response_description="操作成功,返回结果详见响应结构",
)
async def templates_meta(
_admin: User = Depends(get_current_admin),
db: AsyncSession = Depends(get_db),
) -> dict:
# 汇总全库分类标签(用于管理端筛选)
result = await db.execute(select(Template.category))
categories: set[str] = set()
for (cat_list,) in result.all():
if not isinstance(cat_list, list):
continue
for item in cat_list:
if isinstance(item, str) and item.strip():
categories.add(item.strip())
return {"categories": sorted(categories)}
@router.get("/templates", response_model=AdminTemplateListOut,
summary="分页查询全部模板",
description="管理员查询模板,包含未启用模板;支持编号、名称、描述关键词、启用状态及分类筛选,按排序值和模板编号排列。",
response_description="操作成功,返回结果详见响应结构",
)
async def list_templates(
page: int = Query(1, ge=1),
page_size: int = Query(50, ge=1, le=100),
q: str | None = None,
is_active: bool | None = None,
category: str | None = None,
_admin: User = Depends(get_current_admin),
db: AsyncSession = Depends(get_db),
) -> AdminTemplateListOut:
# All templates including inactive
stmt = select(Template)
count_stmt = select(func.count()).select_from(Template)
if q and q.strip():
like = f"%{q.strip()}%"
filt = or_(Template.id.ilike(like), Template.name.ilike(like), Template.description.ilike(like))
stmt = stmt.where(filt)
count_stmt = count_stmt.where(filt)
if is_active is not None:
stmt = stmt.where(Template.is_active == is_active)
count_stmt = count_stmt.where(Template.is_active == is_active)
if category and category.strip():
cat = category.strip()
cat_filter = cast(Template.category, JSONB).contains([cat])
stmt = stmt.where(cat_filter)
count_stmt = count_stmt.where(cat_filter)
total = int((await db.execute(count_stmt)).scalar_one() or 0)
result = await db.execute(
stmt.order_by(Template.sort_order, Template.id)
.offset((page - 1) * page_size)
.limit(page_size)
)
items = [AdminTemplateOut.model_validate(t) for t in result.scalars().all()]
return AdminTemplateListOut(
items=items, meta=PageMeta(page=page, page_size=page_size, total=total)
)
@router.get("/templates/{template_id}", response_model=AdminTemplateOut,
summary="查看模板管理详情",
description="管理员按模板编号读取完整模板配置。模板不存在时返回 404。",
response_description="操作成功,返回结果详见响应结构",
)
async def get_template(
template_id: str,
_admin: User = Depends(get_current_admin),
db: AsyncSession = Depends(get_db),
) -> AdminTemplateOut:
tpl = await db.get(Template, template_id)
if not tpl:
raise HTTPException(status_code=404, detail="模板不存在")
return AdminTemplateOut.model_validate(tpl)
@router.post("/templates", response_model=AdminTemplateOut,
summary="创建创作模板",
description="管理员创建模板并返回保存后的配置。模板编号已存在时返回 400。",
response_description="操作成功,返回结果详见响应结构",
)
async def create_template(
body: AdminTemplateCreate,
_admin: User = Depends(get_current_admin),
db: AsyncSession = Depends(get_db),
) -> AdminTemplateOut:
# Create a new template row
existing = await db.get(Template, body.id)
if existing:
raise HTTPException(status_code=400, detail="模板 ID 已存在")
tpl = Template(**body.model_dump())
db.add(tpl)
await db.commit()
await db.refresh(tpl)
return AdminTemplateOut.model_validate(tpl)
@router.patch("/templates/{template_id}", response_model=AdminTemplateOut,
summary="局部更新创作模板",
description="管理员仅更新请求中显式提供的模板字段,包括启用状态和付费标记。模板不存在时返回 404。",
response_description="操作成功,返回结果详见响应结构",
)
async def patch_template(
template_id: str,
body: AdminTemplatePatch,
_admin: User = Depends(get_current_admin),
db: AsyncSession = Depends(get_db),
) -> AdminTemplateOut:
# Partial update including is_active / is_premium
tpl = await db.get(Template, template_id)
if not tpl:
raise HTTPException(status_code=404, detail="模板不存在")
data = body.model_dump(exclude_unset=True)
for key, value in data.items():
setattr(tpl, key, value)
await db.commit()
await db.refresh(tpl)
return AdminTemplateOut.model_validate(tpl)
@router.delete("/templates/{template_id}",
summary="删除未被引用的模板",
description="管理员删除指定模板,成功返回 {\"ok\": true}。模板不存在时返回 404;仍被科普项目引用时返回 400。",
response_description="操作成功,返回结果详见响应结构",
)
async def delete_template(
template_id: str,
_admin: User = Depends(get_current_admin),
db: AsyncSession = Depends(get_db),
) -> dict:
# Refuse delete when projects still reference the template
tpl = await db.get(Template, template_id)
if not tpl:
raise HTTPException(status_code=404, detail="模板不存在")
used = int(
(
await db.execute(
select(func.count()).select_from(Project).where(Project.template_id == template_id)
)
).scalar_one()
or 0
)
if used > 0:
raise HTTPException(status_code=400, detail=f"模板仍被 {used} 个项目引用,无法删除")
await db.delete(tpl)
await db.commit()
return {"ok": True}