sqlhelpers

README

SQL Helpers

This package provides some utilities for database/sql.

JSON

The functions JSONValue and JSONScan provide helpers that store a type as JSON in a string column.

type MyType map[string]string

// Value encodes a sql value
func (m MyType) Value() (driver.Value, error) {
	return sqlhelpers.JSONValue(m)
}

// Scan decodes a sql value
func (m *MyType) Scan(value interface{}) error {
	return sqlhelpers.JSONScan(m, value)
}

Documentation

Index

• func JSONScan(i, value interface{}) error
• func JSONValue(i interface{}) (driver.Value, error)

Functions

func JSONScan

func JSONScan(i, value interface{}) error

JSONScan decodes a JSON as an SQL value

func JSONValue

func JSONValue(i interface{}) (driver.Value, error)

JSONValue encodes a SQL value as JSON