import "github.com/guregu/null/v5"
null is a library with reasonable options for dealing with nullable SQL and JSON values
There are two packages: null
and its subpackage zero
.
Types in null
will only be considered null on null input, and will JSON encode to null
. If you need zero and null be considered separate values, use these.
Types in zero
are treated like zero values in Go: blank string input will produce a null zero.String
, and null Strings will JSON encode to ""
. Zero values of these types will be considered null to SQL. If you need zero and null treated the same, use these.
- All types implement
sql.Scanner
anddriver.Valuer
, so you can use this library in place ofsql.NullXXX
. - All types also implement
json.Marshaler
andjson.Unmarshaler
, so you can marshal them to their native JSON representation. - All non-generic types implement
encoding.TextMarshaler
,encoding.TextUnmarshaler
. A null object'sMarshalText
will return a blank string.
import "github.com/guregu/null/v5"
Nullable string.
Marshals to JSON null if SQL source data is null. Zero (blank) input will not produce a null String.
Nullable int64/int32/int16/byte.
Marshals to JSON null if SQL source data is null. Zero input will not produce a null Int.
Nullable float64.
Marshals to JSON null if SQL source data is null. Zero input will not produce a null Float.
Nullable bool.
Marshals to JSON null if SQL source data is null. False input will not produce a null Bool.
Marshals to JSON null if SQL source data is null. Zero input will not produce a null Time.
Generic nullable value.
Will marshal to JSON null if SQL source data is null. Does not implement encoding.TextMarshaler
.
import "github.com/guregu/null/v5/zero"
Nullable string.
Will marshal to a blank string if null. Blank string input produces a null String. Null values and zero values are considered equivalent.
Nullable int64/int32/int16/byte.
Will marshal to 0 if null. 0 produces a null Int. Null values and zero values are considered equivalent.
Nullable float64.
Will marshal to 0.0 if null. 0.0 produces a null Float. Null values and zero values are considered equivalent.
Nullable bool.
Will marshal to false if null. false
produces a null Float. Null values and zero values are considered equivalent.
Nullable time.
Will marshal to the zero time if null. Uses time.Time
's marshaler.
Generic nullable value.
Will marshal to zero value if null. T
is required to be a comparable type. Does not implement encoding.TextMarshaler
.
This package is intentionally limited in scope. It will only support the types that driver.Value
supports. Feel free to fork this and add more types if you want.
This package isn't intended to be a catch-all data-wrangling package. It is essentially finished. If you have an idea for a new feature, feel free to open an issue to talk about it or fork this package, but don't expect this to do everything.
- Now a Go module under the path
github.com/guregu/null/v5
- Added missing types from
database/sql
:Int32, Int16, Byte
- Added generic
Value[T]
embeddingsql.Null[T]
- Available at
gopkg.in/guregu/null.v4
- Unmarshaling from JSON
sql.NullXXX
JSON objects (e.g.{"Int64": 123, "Valid": true}
) is no longer supported. It's unlikely many people used this, but if you need it, use v3.
json
's ",omitempty"
struct tag does not work correctly right now. It will never omit a null or empty String. This might be fixed eventually.
BSD