"""火箭发射事件查询接口。""" from datetime import datetime, timezone from typing import Annotated from fastapi import APIRouter, Depends, HTTPException, Query, status from pydantic import BaseModel, ConfigDict, Field from sqlalchemy import func, select from sqlalchemy.ext.asyncio import AsyncSession from sqlalchemy.orm import selectinload from app.database import get_db from app.models.db import RocketConfig, RocketEvent router = APIRouter(prefix="/rocket-events", tags=["rocket-events"]) RocketCodeFilter = Annotated[str | None, Query(description="按本地型号 code 过滤,例如 falcon-9")] class RocketBrief(BaseModel): code: str name: str name_zh: str | None = None model_config = ConfigDict(from_attributes=True) class RocketEventResponse(BaseModel): id: int source: str source_id: str name: str mission_name: str | None = None mission_description: str | None = None mission_type: str | None = None rocket_name: str | None = None provider: str | None = None orbit: str | None = None launch_site_name: str | None = None location_name: str | None = None latitude: float | None = None longitude: float | None = None net: datetime status: str image_url: str | None = None source_url: str | None = None rocket: RocketBrief | None = None model_config = ConfigDict(from_attributes=True) class RocketEventPage(BaseModel): events: list[RocketEventResponse] total: int = Field(description="符合过滤条件的总条数") @router.get("", response_model=RocketEventPage) async def list_rocket_events( db: AsyncSession = Depends(get_db), rocket_code: RocketCodeFilter = None, upcoming: Annotated[bool | None, Query(description="true 只看未发射(按时间升序);false 只看已飞完;不传为全部")] = None, start: Annotated[datetime | None, Query(description="发射时间下界(UTC)")] = None, end: Annotated[datetime | None, Query(description="发射时间上界(UTC)")] = None, search: Annotated[str | None, Query(description="按任务名 / 型号 / 发射场模糊搜索")] = None, limit: int = Query(20, ge=1, le=100), offset: int = Query(0, ge=0), ): now = datetime.now(timezone.utc).replace(tzinfo=None) # net 存的是无时区 UTC,带时区的入参先转 UTC 再去掉时区,否则与 net 比较会报错 start = start.astimezone(timezone.utc).replace(tzinfo=None) if start and start.tzinfo else start end = end.astimezone(timezone.utc).replace(tzinfo=None) if end and end.tzinfo else end filters = [] if upcoming is True: filters.append(RocketEvent.net >= now) elif upcoming is False: filters.append(RocketEvent.net < now) if start: filters.append(RocketEvent.net >= start) if end: filters.append(RocketEvent.net < end) if rocket_code: filters.append(RocketConfig.code == rocket_code.lower()) if search: keyword = f"%{search.strip()}%" filters.append( RocketEvent.name.ilike(keyword) | RocketEvent.mission_name.ilike(keyword) | RocketEvent.rocket_name.ilike(keyword) | RocketEvent.location_name.ilike(keyword) ) total = await db.scalar( select(func.count(RocketEvent.id)) .join(RocketConfig, RocketConfig.id == RocketEvent.rocket_config_id, isouter=True) .where(*filters) ) order = RocketEvent.net.asc() if upcoming is True else RocketEvent.net.desc() result = await db.execute( select(RocketEvent) .options(selectinload(RocketEvent.rocket)) .join(RocketConfig, RocketConfig.id == RocketEvent.rocket_config_id, isouter=True) .where(*filters) .order_by(order, RocketEvent.id) .offset(offset) .limit(limit) ) return RocketEventPage( events=[RocketEventResponse.model_validate(item) for item in result.scalars().all()], total=total or 0, ) @router.get("/stats", response_model=dict) async def rocket_event_stats(db: AsyncSession = Depends(get_db)): """总量、未发射数量、数据源最近一次同步时间。""" now = datetime.now(timezone.utc).replace(tzinfo=None) total = await db.scalar(select(func.count(RocketEvent.id))) upcoming_count = await db.scalar( select(func.count(RocketEvent.id)).where(RocketEvent.net >= now) ) last_synced = await db.scalar(select(func.max(RocketEvent.updated_at))) return { "total": total or 0, "upcoming": upcoming_count or 0, "last_synced_at": last_synced, } @router.get("/{event_id}", response_model=RocketEventResponse) async def get_rocket_event(event_id: int, db: AsyncSession = Depends(get_db)): event = (await db.execute( select(RocketEvent).options(selectinload(RocketEvent.rocket)).where(RocketEvent.id == event_id) )).scalar_one_or_none() if not event: raise HTTPException(status_code=status.HTTP_404_NOT_FOUND, detail="Rocket event not found") return event