cosmo/backend/app/api/rocket_event.py

138 lines
5.0 KiB
Python
Raw Permalink Blame History

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

"""火箭发射事件查询接口。"""
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