Skip to content
The Chat Archive
o4-mini-2025-04-16· OpenAI LMArena Human Preference 140K

how about help me write code for software

  1. User

    how about help me write code for software

  2. Assistant

    下面给出一个基于 Python FastAPI + SQLite 的简易「货运调度数据管理」后端示例。它提供了货源(Loads)、司机(Drivers)、车辆(Vehicles)的增删改查 API,你可以在此基础上扩展更多功能(如用户验证、文档管理、报表等)。


    1. 环境准备

    # 建议用虚拟环境
    python3 -m venv venv
    source venv/bin/activate
    
    # 安装依赖
    pip install fastapi uvicorn sqlmodel
    

    2. 数据模型与数据库

    新建 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…)。

    以上代码只是一个起点,欢迎根据你们的业务场景不断完善!如果有任何疑问或需要更深入的功能示例,随时告诉我 😊

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.