Spaces:
Sleeping
Sleeping
File size: 2,262 Bytes
7190fd0 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 | from fastapi import APIRouter, Depends, HTTPException
from sqlalchemy import select
from sqlalchemy.ext.asyncio import AsyncSession
from app.database import get_db
from app.models.user import User
from app.models.project import Project
from app.models.episode import Episode
from app.schemas.episode import EpisodeCreate, EpisodeResponse
from app.services.auth import get_current_user
router = APIRouter(prefix="/api/projects/{project_id}/episodes", tags=["episodes"])
async def _get_user_project(project_id: int, user: User, db: AsyncSession) -> Project:
result = await db.execute(
select(Project).where(Project.id == project_id, Project.user_id == user.id)
)
project = result.scalar_one_or_none()
if not project:
raise HTTPException(status_code=404, detail="Project not found")
return project
@router.get("", response_model=list[EpisodeResponse])
async def list_episodes(
project_id: int,
user: User = Depends(get_current_user),
db: AsyncSession = Depends(get_db),
):
await _get_user_project(project_id, user, db)
result = await db.execute(
select(Episode)
.where(Episode.project_id == project_id)
.order_by(Episode.episode_number)
)
return list(result.scalars().all())
@router.post("", response_model=EpisodeResponse, status_code=201)
async def create_episode(
project_id: int,
data: EpisodeCreate,
user: User = Depends(get_current_user),
db: AsyncSession = Depends(get_db),
):
await _get_user_project(project_id, user, db)
episode = Episode(project_id=project_id, **data.model_dump(exclude_none=True))
db.add(episode)
await db.commit()
await db.refresh(episode)
return episode
@router.get("/{episode_id}", response_model=EpisodeResponse)
async def get_episode(
project_id: int,
episode_id: int,
user: User = Depends(get_current_user),
db: AsyncSession = Depends(get_db),
):
await _get_user_project(project_id, user, db)
result = await db.execute(
select(Episode).where(Episode.id == episode_id, Episode.project_id == project_id)
)
episode = result.scalar_one_or_none()
if not episode:
raise HTTPException(status_code=404, detail="Episode not found")
return episode
|