V2EX saleacy 的所有回复第 1 页 / 共 3 页

@rrfeng 很强！

r.GET("/fp", utils.AuthMiddleware, func(c *gin.Context) {
username := c.MustGet("username").(string)

var products []struct {
Age string `gorm:"column:a"`
TaobaoID string `gorm:"column:b"`
MinPrice float64 `gorm:"column:c"`
TPrice int `gorm:"column:d"`
}

if err := db.Raw(`select products.age as a,products.min_price as b,products.taobao_id as c from products join users where users.username = ?`, username).Scan(&products).Error; err != nil {
c.JSON( http.StatusInternalServerError, gin.H{"error": "Could not retrieve user products"})
return
}

c.JSON( http.StatusOK, products)
})

[root@ctos0 routes]# curl -X GET http://localhost:8080/fp -H "Authorization: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE3MzI2ODg1OTQsImlzcyI6ImFhYSJ9.CRiAl3SG509O2XkB-a_aXtnNcgFORZsbP_7M-580HBg"
[GIN] 2024/11/26 - 11:26:53 | 200 | 821.97s | ::1 | GET "/fp"
[{"p.age":"333","p.taobao_id":"033","p.min_price":129,"pr.t_price":79},{"p.age":"222","p.taobao_id":"022","p.min_price":129,"pr.t_price":79}]

349 天前

回复了 saleacy 创建的主题 Go 编程语言为什么 GORM 的 db.raw 在 sql 中用 mysql as 别名查询会赋空值

@rrfeng 没怎么用过

2023-12-26 11:28:34 +08:00

回复了 saleacy 创建的主题 NGINX Linux -Nginx 遇到一个玄学问题！

@zuotun 感谢分享帮助问题已解决

2023-12-13 10:05:08 +08:00

回复了 saleacy 创建的主题 NGINX Linux -Nginx 遇到一个玄学问题！

确实是/etc/nginx/mime.types 的问题感谢各位的帮助

2023-12-13 10:04:46 +08:00

回复了 saleacy 创建的主题 NGINX Linux -Nginx 遇到一个玄学问题！

@NessajCN 哥