json

package

Go to main page

Versions in this module

v0

v0.20.0

May 13, 2025

v0.19.0

Dec 19, 2024

Changes in this version

+ var ErrBadEscape = fmt.Errorf("incorrect arguments to ESCAPE")

+ var ErrOneOrAll = fmt.Errorf("the oneOrAll argument to json_search may take these values: 'one' or 'all'")

+ func MutableJsonDoc(ctx context.Context, wrapper sql.JSONWrapper) (types.MutableJSON, error)

+ func TypeOfJsonValue(val interface{}) string

v0.18.1

Apr 9, 2024

Changes in this version

+ var InvalidJsonArgument = errors.NewKind(...)

+ func GetJSONFromWrapperOrCoercibleString(js interface{}) (jsonData interface{}, err error)

type JSONMergePatch

+ JSONs []sql.Expression

+ func (j *JSONMergePatch) Children() []sql.Expression

+ func (j *JSONMergePatch) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j *JSONMergePatch) IsNullable() bool

+ func (j *JSONMergePatch) Resolved() bool

+ func (j *JSONMergePatch) String() string

+ func (j *JSONMergePatch) Type() sql.Type

+ func (j *JSONMergePatch) WithChildren(children ...sql.Expression) (sql.Expression, error)

type JSONMergePreserve

+ JSONs []sql.Expression

type JSONOverlaps

+ Left sql.Expression

+ Right sql.Expression

+ func (j *JSONOverlaps) Children() []sql.Expression

+ func (j *JSONOverlaps) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j *JSONOverlaps) IsNullable() bool

+ func (j *JSONOverlaps) Resolved() bool

+ func (j *JSONOverlaps) String() string

+ func (j *JSONOverlaps) Type() sql.Type

+ func (j *JSONOverlaps) WithChildren(children ...sql.Expression) (sql.Expression, error)

type JSONPretty

+ func (j *JSONPretty) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j *JSONPretty) String() string

+ func (j *JSONPretty) Type() sql.Type

+ func (j *JSONPretty) WithChildren(children ...sql.Expression) (sql.Expression, error)

type JSONQuote

+ func (*JSONQuote) CollationCoercibility(ctx *sql.Context) (collation sql.CollationID, coercibility byte)

+ func (*JSONQuote) Type() sql.Type

+ func (js *JSONQuote) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (js *JSONQuote) String() string

+ func (js *JSONQuote) WithChildren(children ...sql.Expression) (sql.Expression, error)

type JSONSearch

+ Escape sql.Expression

+ JSON sql.Expression

+ OneOrAll sql.Expression

+ Paths []sql.Expression

+ Search sql.Expression

+ func (j *JSONSearch) Children() []sql.Expression

+ func (j *JSONSearch) CollationCoercibility(ctx *sql.Context) (sql.CollationID, byte)

+ func (j *JSONSearch) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j *JSONSearch) IsNullable() bool

+ func (j *JSONSearch) Resolved() bool

+ func (j *JSONSearch) String() string

+ func (j *JSONSearch) Type() sql.Type

+ func (j *JSONSearch) WithChildren(children ...sql.Expression) (sql.Expression, error)

type JSONType

+ JSON sql.Expression

+ func (j JSONType) Children() []sql.Expression

+ func (j JSONType) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j JSONType) IsNullable() bool

+ func (j JSONType) Resolved() bool

+ func (j JSONType) String() string

+ func (j JSONType) Type() sql.Type

+ func (j JSONType) WithChildren(children ...sql.Expression) (sql.Expression, error)

v0.18.0

Feb 28, 2024

Changes in this version

+ var ErrInvalidPath = fmt.Errorf("Invalid JSON path expression")

+ var ErrPathWildcard = fmt.Errorf("Path expressions may not contain the * and ** tokens")

+ var ErrUnsupportedJSONFunction = errors.NewKind("unsupported JSON function: %s")

+ func NewJSONArray(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONArrayAppend(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONArrayInsert(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONContains(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONContainsPath(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONDepth(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONExtract(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONInsert(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONKeys(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONMergePatch(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONMergePreserve(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONObject(exprs ...sql.Expression) (sql.Expression, error)

+ func NewJSONOverlaps(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONPretty(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONQuote(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONRemove(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONReplace(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONSchemaValid(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONSchemaValidationReport(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONSearch(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONSet(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONStorageFree(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONStorageSize(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONTable(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONType(args ...sql.Expression) (sql.Expression, error)

+ func NewJSONUnquote(json sql.Expression) sql.Expression

+ func NewJSONValid(args ...sql.Expression) (sql.Expression, error)

+ func NewJsonLength(args ...sql.Expression) (sql.Expression, error)

+ func NewJsonValue(args ...sql.Expression) (sql.Expression, error)

+ type JSONArray struct

+ func (JSONArray) CollationCoercibility(ctx *sql.Context) (collation sql.CollationID, coercibility byte)

+ func (j *JSONArray) Children() []sql.Expression

+ func (j *JSONArray) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j *JSONArray) IsNullable() bool

+ func (j *JSONArray) Resolved() bool

+ func (j *JSONArray) String() string

+ func (j *JSONArray) Type() sql.Type

+ func (j *JSONArray) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ func (j JSONArray) Description() string

+ func (j JSONArray) FunctionName() string

+ func (j JSONArray) IsUnsupported() bool

+ type JSONArrayAppend struct

+ func (j JSONArrayAppend) Children() []sql.Expression

+ func (j JSONArrayAppend) Description() string

+ func (j JSONArrayAppend) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j JSONArrayAppend) FunctionName() string

+ func (j JSONArrayAppend) IsNullable() bool

+ func (j JSONArrayAppend) IsUnsupported() bool

+ func (j JSONArrayAppend) Resolved() bool

+ func (j JSONArrayAppend) String() string

+ func (j JSONArrayAppend) Type() sql.Type

+ func (j JSONArrayAppend) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ type JSONArrayInsert struct

+ func (j JSONArrayInsert) Children() []sql.Expression

+ func (j JSONArrayInsert) Description() string

+ func (j JSONArrayInsert) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j JSONArrayInsert) FunctionName() string

+ func (j JSONArrayInsert) IsNullable() bool

+ func (j JSONArrayInsert) IsUnsupported() bool

+ func (j JSONArrayInsert) Resolved() bool

+ func (j JSONArrayInsert) String() string

+ func (j JSONArrayInsert) Type() sql.Type

+ func (j JSONArrayInsert) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ type JSONContains struct

+ JSONCandidate sql.Expression

+ JSONTarget sql.Expression

+ Path sql.Expression

+ func (*JSONContains) CollationCoercibility(ctx *sql.Context) (collation sql.CollationID, coercibility byte)

+ func (j *JSONContains) Children() []sql.Expression

+ func (j *JSONContains) Description() string

+ func (j *JSONContains) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j *JSONContains) FunctionName() string

+ func (j *JSONContains) IsNullable() bool

+ func (j *JSONContains) Resolved() bool

+ func (j *JSONContains) String() string

+ func (j *JSONContains) Type() sql.Type

+ func (j *JSONContains) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ func (j JSONContains) IsUnsupported() bool

+ type JSONContainsPath struct

+ func (j JSONContainsPath) Children() []sql.Expression

+ func (j JSONContainsPath) Description() string

+ func (j JSONContainsPath) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j JSONContainsPath) FunctionName() string

+ func (j JSONContainsPath) IsNullable() bool

+ func (j JSONContainsPath) IsUnsupported() bool

+ func (j JSONContainsPath) Resolved() bool

+ func (j JSONContainsPath) String() string

+ func (j JSONContainsPath) Type() sql.Type

+ func (j JSONContainsPath) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ type JSONDepth struct

+ JSON sql.Expression

+ func (j JSONDepth) Children() []sql.Expression

+ func (j JSONDepth) Description() string

+ func (j JSONDepth) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j JSONDepth) FunctionName() string

+ func (j JSONDepth) IsNullable() bool

+ func (j JSONDepth) Resolved() bool

+ func (j JSONDepth) String() string

+ func (j JSONDepth) Type() sql.Type

+ func (j JSONDepth) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ type JSONExtract struct

+ JSON sql.Expression

+ Paths []sql.Expression

+ func (*JSONExtract) CollationCoercibility(ctx *sql.Context) (collation sql.CollationID, coercibility byte)

+ func (j *JSONExtract) Children() []sql.Expression

+ func (j *JSONExtract) Description() string

+ func (j *JSONExtract) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j *JSONExtract) FunctionName() string

+ func (j *JSONExtract) IsNullable() bool

+ func (j *JSONExtract) Resolved() bool

+ func (j *JSONExtract) String() string

+ func (j *JSONExtract) Type() sql.Type

+ func (j *JSONExtract) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ func (j JSONExtract) IsUnsupported() bool

+ type JSONInsert struct

+ func (j JSONInsert) Children() []sql.Expression

+ func (j JSONInsert) Description() string

+ func (j JSONInsert) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j JSONInsert) FunctionName() string

+ func (j JSONInsert) IsNullable() bool

+ func (j JSONInsert) IsUnsupported() bool

+ func (j JSONInsert) Resolved() bool

+ func (j JSONInsert) String() string

+ func (j JSONInsert) Type() sql.Type

+ func (j JSONInsert) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ type JSONKeys struct

+ JSON sql.Expression

+ Path sql.Expression

+ func (j *JSONKeys) Children() []sql.Expression

+ func (j *JSONKeys) Description() string

+ func (j *JSONKeys) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j *JSONKeys) FunctionName() string

+ func (j *JSONKeys) IsNullable() bool

+ func (j *JSONKeys) Resolved() bool

+ func (j *JSONKeys) String() string

+ func (j *JSONKeys) Type() sql.Type

+ func (j *JSONKeys) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ type JSONMerge struct

+ type JSONMergePatch struct

+ func (j JSONMergePatch) Description() string

+ func (j JSONMergePatch) FunctionName() string

+ func (j JSONMergePatch) IsUnsupported() bool

+ type JSONMergePreserve struct

+ JSONDocs []sql.Expression

+ func (*JSONMergePreserve) CollationCoercibility(ctx *sql.Context) (collation sql.CollationID, coercibility byte)

+ func (j *JSONMergePreserve) Children() []sql.Expression

+ func (j *JSONMergePreserve) Description() string

+ func (j *JSONMergePreserve) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j *JSONMergePreserve) FunctionName() string

+ func (j *JSONMergePreserve) IsNullable() bool

+ func (j *JSONMergePreserve) Resolved() bool

+ func (j *JSONMergePreserve) String() string

+ func (j *JSONMergePreserve) Type() sql.Type

+ func (j *JSONMergePreserve) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ func (j JSONMergePreserve) IsUnsupported() bool

+ type JSONObject struct

+ func (JSONObject) CollationCoercibility(ctx *sql.Context) (collation sql.CollationID, coercibility byte)

+ func (j JSONObject) Children() []sql.Expression

+ func (j JSONObject) Description() string

+ func (j JSONObject) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j JSONObject) FunctionName() string

+ func (j JSONObject) IsNullable() bool

+ func (j JSONObject) IsUnsupported() bool

+ func (j JSONObject) Resolved() bool

+ func (j JSONObject) String() string

+ func (j JSONObject) Type() sql.Type

+ func (j JSONObject) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ type JSONOverlaps struct

+ func (j JSONOverlaps) Description() string

+ func (j JSONOverlaps) FunctionName() string

+ func (j JSONOverlaps) IsUnsupported() bool

+ type JSONPretty struct

+ func (j JSONPretty) Description() string

+ func (j JSONPretty) FunctionName() string

+ func (j JSONPretty) IsUnsupported() bool

+ type JSONQuote struct

+ func (j JSONQuote) Description() string

+ func (j JSONQuote) FunctionName() string

+ func (j JSONQuote) IsUnsupported() bool

+ type JSONRemove struct

+ func (j JSONRemove) Children() []sql.Expression

+ func (j JSONRemove) Description() string

+ func (j JSONRemove) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j JSONRemove) FunctionName() string

+ func (j JSONRemove) IsNullable() bool

+ func (j JSONRemove) IsUnsupported() bool

+ func (j JSONRemove) Resolved() bool

+ func (j JSONRemove) String() string

+ func (j JSONRemove) Type() sql.Type

+ func (j JSONRemove) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ type JSONReplace struct

+ func (j JSONReplace) Children() []sql.Expression

+ func (j JSONReplace) Description() string

+ func (j JSONReplace) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j JSONReplace) FunctionName() string

+ func (j JSONReplace) IsNullable() bool

+ func (j JSONReplace) IsUnsupported() bool

+ func (j JSONReplace) Resolved() bool

+ func (j JSONReplace) String() string

+ func (j JSONReplace) Type() sql.Type

+ func (j JSONReplace) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ type JSONSchemaValid struct

+ func (j JSONSchemaValid) Description() string

+ func (j JSONSchemaValid) FunctionName() string

+ func (j JSONSchemaValid) IsUnsupported() bool

+ type JSONSchemaValidationReport struct

+ func (j JSONSchemaValidationReport) Description() string

+ func (j JSONSchemaValidationReport) FunctionName() string

+ func (j JSONSchemaValidationReport) IsUnsupported() bool

+ type JSONSearch struct

+ func (j JSONSearch) Description() string

+ func (j JSONSearch) FunctionName() string

+ func (j JSONSearch) IsUnsupported() bool

+ type JSONSet struct

+ JSONDoc sql.Expression

+ PathAndVals []sql.Expression

+ func (j *JSONSet) Children() []sql.Expression

+ func (j *JSONSet) Description() string

+ func (j *JSONSet) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j *JSONSet) FunctionName() string

+ func (j *JSONSet) IsNullable() bool

+ func (j *JSONSet) Resolved() bool

+ func (j *JSONSet) String() string

+ func (j *JSONSet) Type() sql.Type

+ func (j *JSONSet) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ func (j JSONSet) IsUnsupported() bool

+ type JSONStorageFree struct

+ func (j JSONStorageFree) Description() string

+ func (j JSONStorageFree) FunctionName() string

+ func (j JSONStorageFree) IsUnsupported() bool

+ type JSONStorageSize struct

+ func (j JSONStorageSize) Description() string

+ func (j JSONStorageSize) FunctionName() string

+ func (j JSONStorageSize) IsUnsupported() bool

+ type JSONTable struct

+ func (j JSONTable) Description() string

+ func (j JSONTable) FunctionName() string

+ func (j JSONTable) IsUnsupported() bool

+ type JSONType struct

+ func (j JSONType) Description() string

+ func (j JSONType) FunctionName() string

+ func (j JSONType) IsUnsupported() bool

+ type JSONUnquote struct

+ func (*JSONUnquote) CollationCoercibility(ctx *sql.Context) (collation sql.CollationID, coercibility byte)

+ func (*JSONUnquote) Type() sql.Type

+ func (js *JSONUnquote) Description() string

+ func (js *JSONUnquote) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (js *JSONUnquote) FunctionName() string

+ func (js *JSONUnquote) IsUnsupported() bool

+ func (js *JSONUnquote) String() string

+ func (js *JSONUnquote) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ type JSONValid struct

+ JSON sql.Expression

+ func (j JSONValid) Children() []sql.Expression

+ func (j JSONValid) Description() string

+ func (j JSONValid) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j JSONValid) FunctionName() string

+ func (j JSONValid) IsNullable() bool

+ func (j JSONValid) IsUnsupported() bool

+ func (j JSONValid) Resolved() bool

+ func (j JSONValid) String() string

+ func (j JSONValid) Type() sql.Type

+ func (j JSONValid) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ type JsonLength struct

+ JSON sql.Expression

+ Path sql.Expression

+ func (*JsonLength) CollationCoercibility(ctx *sql.Context) (collation sql.CollationID, coercibility byte)

+ func (j *JsonLength) Children() []sql.Expression

+ func (j *JsonLength) Description() string

+ func (j *JsonLength) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j *JsonLength) FunctionName() string

+ func (j *JsonLength) IsNullable() bool

+ func (j *JsonLength) Resolved() bool

+ func (j *JsonLength) String() string

+ func (j *JsonLength) Type() sql.Type

+ func (j *JsonLength) WithChildren(children ...sql.Expression) (sql.Expression, error)

+ type JsonValue struct

+ JSON sql.Expression

+ Path sql.Expression

+ Typ sql.Type

+ func (*JsonValue) CollationCoercibility(ctx *sql.Context) (collation sql.CollationID, coercibility byte)

+ func (j *JsonValue) Children() []sql.Expression

+ func (j *JsonValue) Description() string

+ func (j *JsonValue) Eval(ctx *sql.Context, row sql.Row) (interface{}, error)

+ func (j *JsonValue) FunctionName() string

+ func (j *JsonValue) IsNullable() bool

+ func (j *JsonValue) Resolved() bool

+ func (j *JsonValue) String() string

+ func (j *JsonValue) Type() sql.Type

+ func (j *JsonValue) WithChildren(children ...sql.Expression) (sql.Expression, error)

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL