vehicles.py 4.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132
  1. from __future__ import annotations
  2. from fastapi import APIRouter, Depends, HTTPException, Query, status
  3. from sqlalchemy import func
  4. from sqlmodel import select
  5. from sqlmodel.ext.asyncio.session import AsyncSession
  6. from app.db.session import get_async_session
  7. from app.models.master_data import Vehicle
  8. from app.schemas.master_data import (
  9. VehicleCreate,
  10. VehicleRead,
  11. VehicleUpdate,
  12. )
  13. router = APIRouter(prefix="/master-data/vehicles", tags=["vehicles"])
  14. def _base_query():
  15. return select(Vehicle).where(Vehicle.is_deleted == 0)
  16. @router.get("/", response_model=list[VehicleRead])
  17. async def list_vehicles(
  18. q: str | None = Query(default=None, description="模糊搜索车牌号"),
  19. session: AsyncSession = Depends(get_async_session),
  20. ) -> list[Vehicle]:
  21. query = _base_query().order_by(Vehicle.created_at.desc())
  22. if q:
  23. query = query.where(func.lower(Vehicle.vehicle_no).contains(q.lower()))
  24. result = await session.exec(query)
  25. return result.all()
  26. @router.get("/{vehicle_id}", response_model=VehicleRead)
  27. async def get_vehicle(
  28. vehicle_id: int,
  29. session: AsyncSession = Depends(get_async_session),
  30. ) -> Vehicle:
  31. vehicle = await _get_vehicle(vehicle_id, session)
  32. return vehicle
  33. @router.post("/", response_model=VehicleRead, status_code=status.HTTP_201_CREATED)
  34. async def create_vehicle(
  35. payload: VehicleCreate,
  36. session: AsyncSession = Depends(get_async_session),
  37. ) -> Vehicle:
  38. from datetime import datetime
  39. await _ensure_unique_vehicle_no(payload.vehicle_no, session)
  40. vehicle = Vehicle(
  41. vehicle_no=payload.vehicle_no.strip(),
  42. remarks=payload.remarks,
  43. created_at=datetime.now().isoformat(),
  44. )
  45. session.add(vehicle)
  46. await session.commit()
  47. await session.refresh(vehicle)
  48. return vehicle
  49. @router.put("/{vehicle_id}", response_model=VehicleRead)
  50. async def update_vehicle(
  51. vehicle_id: int,
  52. payload: VehicleUpdate,
  53. session: AsyncSession = Depends(get_async_session),
  54. ) -> Vehicle:
  55. vehicle = await _get_vehicle(vehicle_id, session)
  56. if payload.vehicle_no and payload.vehicle_no.strip().lower() != vehicle.vehicle_no.lower():
  57. await _ensure_unique_vehicle_no(payload.vehicle_no, session)
  58. vehicle.vehicle_no = payload.vehicle_no.strip()
  59. if payload.remarks is not None:
  60. vehicle.remarks = payload.remarks
  61. await session.commit()
  62. await session.refresh(vehicle)
  63. return vehicle
  64. @router.patch("/{vehicle_id}", response_model=VehicleRead)
  65. async def patch_vehicle(
  66. vehicle_id: int,
  67. payload: VehicleUpdate,
  68. session: AsyncSession = Depends(get_async_session),
  69. ) -> Vehicle:
  70. vehicle = await _get_vehicle(vehicle_id, session)
  71. if payload.vehicle_no and payload.vehicle_no.strip().lower() != vehicle.vehicle_no.lower():
  72. await _ensure_unique_vehicle_no(payload.vehicle_no, session)
  73. vehicle.vehicle_no = payload.vehicle_no.strip()
  74. if payload.remarks is not None:
  75. vehicle.remarks = payload.remarks
  76. await session.commit()
  77. await session.refresh(vehicle)
  78. return vehicle
  79. @router.delete(
  80. "/{vehicle_id}",
  81. status_code=status.HTTP_204_NO_CONTENT,
  82. )
  83. async def delete_vehicle(
  84. vehicle_id: int,
  85. session: AsyncSession = Depends(get_async_session),
  86. ) -> None:
  87. vehicle = await _get_vehicle(vehicle_id, session)
  88. vehicle.is_deleted = 1
  89. await session.commit()
  90. async def _get_vehicle(vehicle_id: int, session: AsyncSession) -> Vehicle:
  91. result = await session.exec(
  92. _base_query().where(Vehicle.id == vehicle_id),
  93. )
  94. vehicle = result.one_or_none()
  95. if vehicle is None:
  96. raise HTTPException(
  97. status_code=status.HTTP_404_NOT_FOUND,
  98. detail=f"Vehicle {vehicle_id} not found",
  99. )
  100. return vehicle
  101. async def _ensure_unique_vehicle_no(vehicle_no: str, session: AsyncSession) -> None:
  102. normalized = vehicle_no.strip().lower()
  103. result = await session.exec(
  104. _base_query().where(func.lower(Vehicle.vehicle_no) == normalized),
  105. )
  106. if result.first():
  107. raise HTTPException(
  108. status_code=status.HTTP_409_CONFLICT,
  109. detail="Vehicle number already exists",
  110. )