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