訪問調理システムのGo言語開発：注文状況追跡機能を実装するには？

CREATE TABLE orders (
  id INT PRIMARY KEY AUTO_INCREMENT,
  user_id INT,
  dish_name VARCHAR(255),
  status VARCHAR(20),
  courier_id INT,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

package main

import (
  "github.com/gin-gonic/gin"
  "gorm.io/driver/mysql"
  "gorm.io/gorm"
)

type Order struct {
  ID        int
  UserID    int
  DishName  string
  Status    string
  CourierID int
  CreatedAt time.Time
}

func main() {
  // 连接数据库
  dsn := "<username>:<password>@tcp(<host>:<port>)/<database>?charset=utf8mb4&parseTime=True&loc=Local"
  db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
  if err != nil {
    panic("数据库连接失败")
  }

  // 创建订单表
  db.AutoMigrate(&Order{})

  // 创建gin实例
  r := gin.Default()

  // 创建订单接口
  r.POST("/orders", func(c *gin.Context) {
    var order Order
    c.BindJSON(&order)

    // 将订单信息保存到数据库
    result := db.Create(&order)
    if result.Error != nil {
      c.JSON(500, gin.H{"error": "保存订单失败"})
    } else {
      c.JSON(200, order)
    }
  })

  // 更新订单状态接口
  r.PUT("/orders/:id/status", func(c *gin.Context) {
    id := c.Param("id")
    status := c.Query("status")

    // 更新订单状态
    result := db.Model(&Order{}).Where("id = ?", id).Update("status", status)
    if result.RowsAffected == 0 {
      c.JSON(404, gin.H{"error": "订单不存在"})
    } else {
      c.JSON(200, gin.H{"status": "订单状态更新成功"})
    }
  })

  // 启动服务
  r.Run(":8080")
}

curl -X POST -H "Content-Type: application/json" -d '{"user_id": 1, "dish_name": "宫保鸡丁"}' http://localhost:8080/orders

curl -X PUT "http://localhost:8080/orders/1/status?status=已接单"