from fastapi import APIRouter, HTTPException, Depends from typing import List from sqlalchemy.orm import Session from app.schemas.product import ProductResponse, ProductCreate, ProductUpdate from app.services.product_service import product_service from app.database.connection import get_db router = APIRouter() @router.get("/", response_model=List[ProductResponse]) async def get_products(db: Session = Depends(get_db)): """获取所有商品列表""" products = product_service.get_all_products(db) return products @router.get("/{product_id}", response_model=ProductResponse) async def get_product(product_id: int, db: Session = Depends(get_db)): """根据ID获取单个商品""" product = product_service.get_product_by_id(db, product_id) if not product: raise HTTPException(status_code=404, detail="Product not found") return product @router.post("/", response_model=ProductResponse, status_code=201) async def create_product(product: ProductCreate, db: Session = Depends(get_db)): """创建新产品""" return product_service.create_product(db, product) @router.put("/{product_id}", response_model=ProductResponse) async def update_product(product_id: int, product: ProductUpdate, db: Session = Depends(get_db)): """更新产品信息""" updated_product = product_service.update_product(db, product_id, product) if not updated_product: raise HTTPException(status_code=404, detail="Product not found") return updated_product @router.delete("/{product_id}", status_code=204) async def delete_product(product_id: int, db: Session = Depends(get_db)): """删除产品""" deleted = product_service.delete_product(db, product_id) if not deleted: raise HTTPException(status_code=404, detail="Product not found")