Versions in this module Expand all Collapse all v1 v1.0.1 Jul 31, 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") + var InvalidJsonArgument = errors.NewKind(...) + func GetJSONFromWrapperOrCoercibleString(js interface{}) (jsonData interface{}, err error) + 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(arg sql.Expression) sql.Expression + func NewJSONQuote(json sql.Expression) sql.Expression + 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 JSONMergePatch struct + JSONs []sql.Expression + func (j *JSONMergePatch) Children() []sql.Expression + func (j *JSONMergePatch) Description() string + func (j *JSONMergePatch) Eval(ctx *sql.Context, row sql.Row) (interface{}, error) + func (j *JSONMergePatch) FunctionName() string + 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 struct + JSONs []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 + Left sql.Expression + Right sql.Expression + func (j *JSONOverlaps) Children() []sql.Expression + func (j *JSONOverlaps) Description() string + func (j *JSONOverlaps) Eval(ctx *sql.Context, row sql.Row) (interface{}, error) + func (j *JSONOverlaps) FunctionName() string + 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 struct + func (j *JSONPretty) Description() string + func (j *JSONPretty) Eval(ctx *sql.Context, row sql.Row) (interface{}, error) + func (j *JSONPretty) FunctionName() string + func (j *JSONPretty) String() string + func (j *JSONPretty) Type() sql.Type + func (j *JSONPretty) WithChildren(children ...sql.Expression) (sql.Expression, error) + type JSONQuote struct + func (*JSONQuote) CollationCoercibility(ctx *sql.Context) (collation sql.CollationID, coercibility byte) + func (*JSONQuote) Type() sql.Type + func (js *JSONQuote) Description() string + func (js *JSONQuote) Eval(ctx *sql.Context, row sql.Row) (interface{}, error) + func (js *JSONQuote) FunctionName() string + func (js *JSONQuote) String() string + func (js *JSONQuote) WithChildren(children ...sql.Expression) (sql.Expression, error) + 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 + 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) Description() string + func (j *JSONSearch) Eval(ctx *sql.Context, row sql.Row) (interface{}, error) + func (j *JSONSearch) FunctionName() string + 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 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) + 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 + JSON sql.Expression + func (j JSONType) Children() []sql.Expression + func (j JSONType) Description() string + func (j JSONType) Eval(ctx *sql.Context, row sql.Row) (interface{}, error) + func (j JSONType) FunctionName() string + 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) + 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)