Here's a quick snippet you can use to create a custom type that maps an UUID to a Binary(16) representation in MySQL.
I assume this is not present in gofrs/uuid since it's database specific, but having NullUUID available is an easy 'inspiration' opportunity ;).
import (
"database/sql/driver"
"github.com/gofrs/uuid/v5"
)
type NullBinaryUUID struct {
UUID uuid.UUID
Valid bool // Valid is true if UUID is not NULL
}
// Value implements the driver.Valuer interface.
func (u NullBinaryUUID) Value() (driver.Value, error) {
if !u.Valid {
return nil, nil
}
// Delegate to UUID Value function
return u.UUID.Bytes(), nil
}
// Scan implements the sql.Scanner interface.
func (u *NullBinaryUUID) Scan(src interface{}) error {
if src == nil {
u.UUID, u.Valid = uuid.UUID{}, false
return nil
}
// Delegate to UUID Scan function
u.Valid = true
return u.UUID.Scan(src)
}
Top comments (0)