dousunle5801 2015-01-02 15:32
浏览 62
已采纳

我可以将gorilla模式与sql.NullString一起使用吗?

I am using gorilla schema to populate a struct based on a user's form submission. My struct contains sql.NullString and I am currently getting the following error:

schema: converter not found for sql.NullString

How can I use sql.NullString in a struct that I want to populate with gorilla schema?

  • 写回答

1条回答 默认 最新

  • duanjian7343 2015-01-02 15:32
    关注

    I created a gist ( https://gist.github.com/carbocation/51b55297702c7d30d3ef ) that shows one way to approach this. You need to create a schema.Converter for each of the four types: sql.NullString, sql.NullBool, sql.NullInt64, and sql.NullFloat64.

    An example for sql.NullString:

    import "database/sql"
    import "reflect"
    
    func ConvertSQLNullString(value string) reflect.Value {
        v := sql.NullString{}
        if err := v.Scan(value); err != nil {
            return reflect.Value{}
        }
    
        return reflect.ValueOf(v)
    }
    

    Then register this with your *schema.Decoder (usually a package global, in this case named d):

    import "database/sql"
    
    nullString := sql.NullString{}
    d.RegisterConverter(nullString, ConvertSQLNullString)
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 nrf52810-c三个a 程序
  • ¥15 lego-loam跑出来的roll误差很大
  • ¥50 求一个半透明没有锯齿的圆角窗体的实现例子
  • ¥15 STM32cubeMX里的FreeRTOS无法释放内存
  • ¥15 CATIA有些零件打开直接单机确定终止
  • ¥15 请问有会的吗,用MATLAB做
  • ¥15 phython如何实现以下功能?查找同一用户名的消费金额合并—
  • ¥15 孟德尔随机化怎样画共定位分析图
  • ¥18 模拟电路问题解答有偿速度
  • ¥15 CST仿真别人的模型结果仿真结果S参数完全不对