Documentation
¶
Overview ¶
Package sqlutil provides some helpers for SQL databases.
Index ¶
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
type Bool ¶
type Bool bool
Bool converts various column types to a boolean.
Supported types:
bool int* and float* 0 or 1 []byte and string "1", "true", "0", "false" nil defaults to false
func (Bool) MarshalText ¶
MarshalText converts the data to a JSON-compatible human readable representation.
func (*Bool) Scan ¶
Scan converts the different types of representation of a boolean in the database into a bool type.
func (*Bool) UnmarshalText ¶
UnmarshalText parses text in to the Go data structure.
type FloatList ¶
type FloatList []float64
FloatList expands comma-separated values from a column to []float64, and stores []float64 as a comma-separated string.
This is safe for NULL values, in which case it will scan in to FloatList(nil).
func (FloatList) MarshalText ¶
MarshalText converts the data to a human readable representation.
func (*FloatList) UnmarshalText ¶
UnmarshalText parses text in to the Go data structure.
type HTML ¶
HTML is a string which indicates that the string has been HTML-escaped.
type IntList ¶
type IntList []int64
IntList expands comma-separated values from a column to []int64, and stores []int64 as a comma-separated string.
This is safe for NULL values, in which case it will scan in to IntList(nil).
func (IntList) MarshalText ¶
MarshalText converts the data to a human readable representation.
func (*IntList) UnmarshalText ¶
UnmarshalText parses text in to the Go data structure.
type StringList ¶
type StringList []string
StringList expands comma-separated values from a column to []string, and stores []string as a comma-separated string.
Note that this only works for simple strings (e.g. enums), we DO NOT escape commas in strings and you will run in to problems.
This is safe for NULL values, in which case it will scan in to StringList(nil).
func (StringList) MarshalText ¶
func (l StringList) MarshalText() ([]byte, error)
MarshalText converts the data to a human readable representation.
func (*StringList) Scan ¶
func (l *StringList) Scan(v interface{}) error
Scan converts the data returned from the DB into the struct.
func (StringList) String ¶ added in v1.3.1
func (l StringList) String() string
func (*StringList) UnmarshalText ¶
func (l *StringList) UnmarshalText(v []byte) error
UnmarshalText parses text in to the Go data structure.