DB JSON type

json.go

package model

import (
	"database/sql/driver"
	"encoding/json"
	"errors"
)

type JSON []byte

func (j JSON) Value() (driver.Value, error) {
	return []byte(j), nil
}

func (j *JSON) Scan(value interface{}) error {
	if value == nil {
		*j = nil
		return nil
	}
	b, ok := value.([]byte)
	if !ok {
		return errors.New("type assertion to []byte failed")
	}
	*j = b
	return nil
}

func (j JSON) Unmarshal(value interface{}) error {
	if j == nil {
		return nil
	}
	return json.Unmarshal(j, value)
}

func Marshal(value interface{}) (JSON, error) {
	if value == nil {
		return nil, nil
	}
	return json.Marshal(value)
}