Gorm Raw Argument Unsupported Error

发表于2022-09-03|更新于2025-09-27|DevelopmentBackend

|浏览量:

Problem: Raw second arg must be non-empty and fields referenced in SQL.

sql := "SELECT * FROM test WHERE @Placeholder "
var sqlParam struct { Applyno string; Status *int; Placeholder int }
sqlParam.Placeholder = 1
if info.Applyno != "" { sql += " AND applyno = @Applyno "; sqlParam.Applyno = info.Applyno }
db.Raw(sql, sqlParam).Scan(&dataList)

文章作者: Harry

文章链接: https://harrywork.com/blog/p/26189/

版权声明: 本博客所有文章除特别声明外，均采用 CC BY-NC-SA 4.0 许可协议。转载请注明来源 👋Harry Blog！

Thanks

Paypal
Wechat

相关推荐

go goroutine chan 并发/通道异步处理微信订单分账

最近在开发微信服务商,申请分账需要对每个订单单独发起,于是用到了golang的协程 ch := make(chan int, runtime.NumCPU())for i := 0; i < len(wechatOrderList); i++ { go modifyWxOrderProfit(&wechatOrderList[i], ch) ch <- i}close(ch)// 处理分账订单func modifyWxOrderProfit(wechatOrder *order.WechatOrder, ch chan int){ // 发起微信订单分账请求 // client.POST()... for v := range ch { fmt.Println("当前异步处理的是第",v,"个订单") }}

go ioutil包1.16起弃用使用io包代替

20 年 10 月份，Go 掌舵人 Russ Cox 已经有废弃 ioutil 包的提案[1]，废弃原因是:io/ioutil, like most things with util in the name, has turned out to be a poorly defined and hard to understand collection of things. 后续的几次代码提交也证实了这一点，从 Go 1.16 开始会废弃 io/ioutil 包，相关的功能会挪到 io 包或 os 包相关连接 https://github.com/go-critic/go-critic/issues/1019 例如 ioutil.NopCloser方法, 改为io.NopCloser方法即可

go sha256withRSA签名 base64

生成密钥文件GenerateRSAKey(2048)//模拟发送方//要发送的消息msg := []byte("hello world")//生成签名sign := GetSign(msg, "private.pem")fmt.Println("signlen lenlen", string(sign))//模拟接收方//接受到的消息acceptmsg := []byte("hello world")//接受到的签名acceptsign := sign//验证签名result := VerifySign(acceptmsg, acceptsign, "public.pem")fmt.Println("验证结果：", result)

Go Struct Field Reordering Optimization

Improve performance and reduce memory usage by reordering struct fields for better alignment.

Go Gin API Sign Middleware

Simple request signature verification middleware for Gin.

Go Hot Upgrade via Nginx Proxy

Achieve zero-downtime upgrade by switching backend port in nginx and reloading.

评论

数据加载中