doqdcks3948 2018-04-02 22:25
浏览 702
已采纳

Go的sql.NullString的值是否可以预测为空?

After using db.Query and rows.Scan to populate a sql.NullString with a NULL value such that its .Valid field is false, is it guaranteed that its .String will hold the empty string ""?

I ask because it would be snazzy if I could use this:

res := ns.String

Instead of this:

var res string
if ns.Valid {
    res = ns.String
}

https://golang.org/pkg/database/sql/#NullString

  • 写回答

1条回答 默认 最新

  • dota220141003 2018-04-02 22:34
    关注

    In the current implementation yes, but the docs explicitly say to check Valid before using String. Ignore the docs at your own risk.

    If you want to be safe, simply copy the type into your own package; then you know it's not going to change with the next Go release.

    If you don't do that, I strongly suggest to write a test:

    func TestEmptyNullString(t *testing.T) {
        var x sql.NullString
        x.String = "foo"
        x.Scan(nil)
        if x.String != "" {
            t.Error("string not empty after Scan")
        }
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 STM32无法向设备写入固件
  • ¥15 使用ESP8266连接阿里云出现问题
  • ¥15 BP神经网络控制倒立摆
  • ¥20 要这个数学建模编程的代码 并且能完整允许出来结果 完整的过程和数据的结果
  • ¥15 html5+css和javascript有人可以帮吗?图片要怎么插入代码里面啊
  • ¥30 Unity接入微信SDK 无法开启摄像头
  • ¥20 有偿 写代码 要用特定的软件anaconda 里的jvpyter 用python3写
  • ¥20 cad图纸,chx-3六轴码垛机器人
  • ¥15 移动摄像头专网需要解vlan
  • ¥20 access多表提取相同字段数据并合并