| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132 |
- from __future__ import annotations
- from fastapi import APIRouter, Depends, HTTPException, Query, status
- from sqlalchemy import func
- from sqlmodel import select
- from sqlmodel.ext.asyncio.session import AsyncSession
- from app.db.session import get_async_session
- from app.models.master_data import Vehicle
- from app.schemas.master_data import (
- VehicleCreate,
- VehicleRead,
- VehicleUpdate,
- )
- router = APIRouter(prefix="/master-data/vehicles", tags=["vehicles"])
- def _base_query():
- return select(Vehicle).where(Vehicle.is_deleted == 0)
- @router.get("/", response_model=list[VehicleRead])
- async def list_vehicles(
- q: str | None = Query(default=None, description="模糊搜索车牌号"),
- session: AsyncSession = Depends(get_async_session),
- ) -> list[Vehicle]:
- query = _base_query().order_by(Vehicle.created_at.desc())
- if q:
- query = query.where(func.lower(Vehicle.vehicle_no).contains(q.lower()))
- result = await session.exec(query)
- return result.all()
- @router.get("/{vehicle_id}", response_model=VehicleRead)
- async def get_vehicle(
- vehicle_id: int,
- session: AsyncSession = Depends(get_async_session),
- ) -> Vehicle:
- vehicle = await _get_vehicle(vehicle_id, session)
- return vehicle
- @router.post("/", response_model=VehicleRead, status_code=status.HTTP_201_CREATED)
- async def create_vehicle(
- payload: VehicleCreate,
- session: AsyncSession = Depends(get_async_session),
- ) -> Vehicle:
- from datetime import datetime
- await _ensure_unique_vehicle_no(payload.vehicle_no, session)
- vehicle = Vehicle(
- vehicle_no=payload.vehicle_no.strip(),
- remarks=payload.remarks,
- created_at=datetime.now().isoformat(),
- )
- session.add(vehicle)
- await session.commit()
- await session.refresh(vehicle)
- return vehicle
- @router.put("/{vehicle_id}", response_model=VehicleRead)
- async def update_vehicle(
- vehicle_id: int,
- payload: VehicleUpdate,
- session: AsyncSession = Depends(get_async_session),
- ) -> Vehicle:
- vehicle = await _get_vehicle(vehicle_id, session)
- if payload.vehicle_no and payload.vehicle_no.strip().lower() != vehicle.vehicle_no.lower():
- await _ensure_unique_vehicle_no(payload.vehicle_no, session)
- vehicle.vehicle_no = payload.vehicle_no.strip()
- if payload.remarks is not None:
- vehicle.remarks = payload.remarks
- await session.commit()
- await session.refresh(vehicle)
- return vehicle
- @router.patch("/{vehicle_id}", response_model=VehicleRead)
- async def patch_vehicle(
- vehicle_id: int,
- payload: VehicleUpdate,
- session: AsyncSession = Depends(get_async_session),
- ) -> Vehicle:
- vehicle = await _get_vehicle(vehicle_id, session)
- if payload.vehicle_no and payload.vehicle_no.strip().lower() != vehicle.vehicle_no.lower():
- await _ensure_unique_vehicle_no(payload.vehicle_no, session)
- vehicle.vehicle_no = payload.vehicle_no.strip()
- if payload.remarks is not None:
- vehicle.remarks = payload.remarks
- await session.commit()
- await session.refresh(vehicle)
- return vehicle
- @router.delete(
- "/{vehicle_id}",
- status_code=status.HTTP_204_NO_CONTENT,
- )
- async def delete_vehicle(
- vehicle_id: int,
- session: AsyncSession = Depends(get_async_session),
- ) -> None:
- vehicle = await _get_vehicle(vehicle_id, session)
- vehicle.is_deleted = 1
- await session.commit()
- async def _get_vehicle(vehicle_id: int, session: AsyncSession) -> Vehicle:
- result = await session.exec(
- _base_query().where(Vehicle.id == vehicle_id),
- )
- vehicle = result.one_or_none()
- if vehicle is None:
- raise HTTPException(
- status_code=status.HTTP_404_NOT_FOUND,
- detail=f"Vehicle {vehicle_id} not found",
- )
- return vehicle
- async def _ensure_unique_vehicle_no(vehicle_no: str, session: AsyncSession) -> None:
- normalized = vehicle_no.strip().lower()
- result = await session.exec(
- _base_query().where(func.lower(Vehicle.vehicle_no) == normalized),
- )
- if result.first():
- raise HTTPException(
- status_code=status.HTTP_409_CONFLICT,
- detail="Vehicle number already exists",
- )
|