douwojiao5919 2017-04-29 23:09
浏览 514
已采纳

当我们用另一个结构包装时,Gorm golang sql.NullInt64无法正常工作

User can be deleted by another user. In that case,

type User struct {
    gorm.Model
    Email string `gorm:"type:varchar(100)"`
    DeletedBy     sql.NullInt64
}

DeletedBy will be null when we create a new user. So I used sql.NullInt64 instead of int64. But I cannot convert to JSON.

{ "Email": "xxxxx", "DeletedBy": {"Int64":2,"Valid":true} }

For that, I tried https://gist.github.com/smagch/bc34f861df65c8ea2e90 But Gorm send query condition value as "[{2, true}]"

  • 写回答

1条回答 默认 最新

  • dongseshu0698 2017-04-29 23:33
    关注

    In Go when you declare a type as an alias of another type, the new type does not get to keep the other type's methods. So here:

    type NullInt64 sql.NullInt64
    

    your new NullInt64 type has the same structure and memory layout as sql.NullInt64 but it does not have its methods, namely the Scan and Value methods required for it to work the way you want.

    Instead what you can do is to embed the sql.NullInt64 and you should be good to go.

    type NullInt64 struct {
        sql.NullInt64
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 BP神经网络控制倒立摆
  • ¥20 要这个数学建模编程的代码 并且能完整允许出来结果 完整的过程和数据的结果
  • ¥15 html5+css和javascript有人可以帮吗?图片要怎么插入代码里面啊
  • ¥30 Unity接入微信SDK 无法开启摄像头
  • ¥20 有偿 写代码 要用特定的软件anaconda 里的jvpyter 用python3写
  • ¥20 cad图纸,chx-3六轴码垛机器人
  • ¥15 移动摄像头专网需要解vlan
  • ¥20 access多表提取相同字段数据并合并
  • ¥20 基于MSP430f5529的MPU6050驱动,求出欧拉角
  • ¥20 Java-Oj-桌布的计算