o4-mini-2025-04-16· OpenAI LMArena Human Preference 140K
how about help me write code for software
- User
how about help me write code for software
- Assistant
下面给出一个基于 Python FastAPI + SQLite 的简易「货运调度数据管理」后端示例。它提供了货源(Loads)、司机(Drivers)、车辆(Vehicles)的增删改查 API,你可以在此基础上扩展更多功能(如用户验证、文档管理、报表等)。
1. 环境准备
# 建议用虚拟环境 python3 -m venv venv source venv/bin/activate # 安装依赖 pip install fastapi uvicorn sqlmodel2. 数据模型与数据库
新建
models.py,使用 SQLModel(结合了 Pydantic & SQLAlchemy)来定义:# models.py from typing import Optional from sqlmodel import SQLModel, Field, Relationship from datetime import date class Driver(SQLModel, table=True): id: Optional[int] = Field(default=None, primary_key=True) name: str phone: str # Relationship(可选演示) loads: list["Load"] = Relationship(back_populates="driver") class Vehicle(SQLModel, table=True): id: Optional[int] = Field(default=None, primary_key=True) plate_no: str capacity_tons: float loads: list["Load"] = Relationship(back_populates="vehicle") class Load(SQLModel, table=True): id: Optional[int] = Field(default=None, primary_key=True) pickup: str delivery: str weight_tons: float pickup_date: date delivery_date: date driver_id: Optional[int] = Field(default=None, foreign_key="driver.id") vehicle_id: Optional[int] = Field(default=None, foreign_key="vehicle.id") driver: Optional[Driver] = Relationship(back_populates="loads") vehicle: Optional[Vehicle] = Relationship(back_populates="loads")3. 主应用:CRUD 接口
新建
main.py:# main.py from fastapi import FastAPI, HTTPException, Depends from sqlmodel import Session, select, create_engine, SQLModel from typing import List import models DATABASE_URL = "sqlite:///./dispatch.db" engine = create_engine(DATABASE_URL, echo=True) app = FastAPI(title="Trucking Dispatch API") # 初始化数据库 def init_db(): SQLModel.metadata.create_all(engine) @app.on_event("startup") def on_startup(): init_db() # 依赖:获取 DB session def get_session(): with Session(engine) as session: yield session # —— Driver CRUD —— @app.post("/drivers/", response_model=models.Driver) def create_driver(d: models.Driver, session: Session = Depends(get_session)): session.add(d) session.commit() session.refresh(d) return d @app.get("/drivers/", response_model=List[models.Driver]) def list_drivers(session: Session = Depends(get_session)): return session.exec(select(models.Driver)).all() @app.get("/drivers/{driver_id}", response_model=models.Driver) def get_driver(driver_id: int, session: Session = Depends(get_session)): d = session.get(models.Driver, driver_id) if not d: raise HTTPException(404, "Driver not found") return d @app.put("/drivers/{driver_id}", response_model=models.Driver) def update_driver(driver_id: int, drv: models.Driver, session: Session = Depends(get_session)): existing = session.get(models.Driver, driver_id) if not existing: raise HTTPException(404, "Driver not found") drv.id = driver_id session.merge(drv) session.commit() return session.get(models.Driver, driver_id) @app.delete("/drivers/{driver_id}") def delete_driver(driver_id: int, session: Session = Depends(get_session)): d = session.get(models.Driver, driver_id) if not d: raise HTTPException(404, "Driver not found") session.delete(d) session.commit() return {"ok": True} # —— Vehicle CRUD 同理 —— # @app.post("/vehicles/", response_model=models.Vehicle) def create_vehicle(v: models.Vehicle, session: Session = Depends(get_session)): session.add(v); session.commit(); session.refresh(v); return v @app.get("/vehicles/", response_model=List[models.Vehicle]) def list_vehicles(session: Session = Depends(get_session)): return session.exec(select(models.Vehicle)).all() # —— Load CRUD —— # @app.post("/loads/", response_model=models.Load) def create_load(l: models.Load, session: Session = Depends(get_session)): session.add(l); session.commit(); session.refresh(l); return l @app.get("/loads/", response_model=List[models.Load]) def list_loads(session: Session = Depends(get_session)): return session.exec(select(models.Load)).all()4. 启动与测试
uvicorn main:app --reload浏览器打开 http://127.0.0.1:8000/docs 即可看到自动生成的交互式 API 文档,直接做增删改查测试。
后续可扩展
- 加入用户认证(OAuth2 / JWT)。
- 增加更多字段(如费用、状态跟踪、GPS 轨迹)。
- 前端页面:用 React / Vue / Angular 调用这些接口。
- 部署:Docker + 云数据库(PostgreSQL/MySQL/MongoDB…)。
以上代码只是一个起点,欢迎根据你们的业务场景不断完善!如果有任何疑问或需要更深入的功能示例,随时告诉我 😊
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.