数据库/ SQL Go中的JSON封送可空类型值

Question

I am trying to figure out how one can properly marhsall nullable type (string, int, time) properly to JSON in Go. I know that database/sql provide sql.NullTime, sql.NullInt, etc but when you marshall these values, you get something like

{"first_name": {
  "Value": "",
  "Valid": false,
}}

What I really want is

{"first_name": null}

I understand that you can implement your own MarshalJSON to do this (I wrote about it here http://dennissuratna.com/marshalling-nullable-string-db-value-to-json-in-go/)

BUT I am wondering if anyone knows a better way to do this. I want to know other people know a less tedious way to do this.

Answer 1

Create a type that embeds (e.g.) sql.NullInt and implements the json.Marshaler interface.