org.apache.calcite.runtime

Class JsonFunctions

java.lang.Object

org.apache.calcite.runtime.JsonFunctions

public class JsonFunctions
extends Object

A collection of functions used in JSON processing.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	JsonFunctions.JsonPathContext Returned path context of JsonApiCommonSyntax, public for testing.
static class	JsonFunctions.JsonValueContext The Java output of SqlJsonValueExpressionOperator.
static class	JsonFunctions.PathMode Path spec has two different modes: lax mode and strict mode.

Method Summary

Modifier and Type	Method and Description
static Object	dejsonize(String input)
static boolean	isJsonArray(String input)
static boolean	isJsonObject(String input)
static boolean	isJsonScalar(String input)
static boolean	isJsonValue(String input)
static JsonFunctions.JsonPathContext	jsonApiCommonSyntax(JsonFunctions.JsonValueContext input)
static JsonFunctions.JsonPathContext	jsonApiCommonSyntax(JsonFunctions.JsonValueContext input, String pathSpec)
static JsonFunctions.JsonPathContext	jsonApiCommonSyntax(String input)
static JsonFunctions.JsonPathContext	jsonApiCommonSyntax(String input, String pathSpec)
static String	jsonArray(SqlJsonConstructorNullClause nullClause, Object... elements)
static void	jsonArrayAggAdd(List list, Object element, SqlJsonConstructorNullClause nullClause)
static Integer	jsonDepth(JsonFunctions.JsonValueContext input)
static Integer	jsonDepth(String input)
static Boolean	jsonExists(JsonFunctions.JsonPathContext context)
static Boolean	jsonExists(JsonFunctions.JsonPathContext context, SqlJsonExistsErrorBehavior errorBehavior)
static Boolean	jsonExists(JsonFunctions.JsonValueContext input, String pathSpec)
static Boolean	jsonExists(JsonFunctions.JsonValueContext input, String pathSpec, SqlJsonExistsErrorBehavior errorBehavior)
static Boolean	jsonExists(String input, String pathSpec)
static Boolean	jsonExists(String input, String pathSpec, SqlJsonExistsErrorBehavior errorBehavior)
static String	jsonize(Object input)
static String	jsonKeys(JsonFunctions.JsonPathContext context)
static String	jsonKeys(JsonFunctions.JsonValueContext input)
static String	jsonKeys(JsonFunctions.JsonValueContext input, String pathSpec)
static String	jsonKeys(String input)
static String	jsonKeys(String input, String pathSpec)
static Integer	jsonLength(JsonFunctions.JsonPathContext context)
static Integer	jsonLength(JsonFunctions.JsonValueContext input)
static Integer	jsonLength(JsonFunctions.JsonValueContext input, String pathSpec)
static Integer	jsonLength(String input)
static Integer	jsonLength(String input, String pathSpec)
static String	jsonObject(SqlJsonConstructorNullClause nullClause, Object... kvs)
static void	jsonObjectAggAdd(Map map, String k, Object v, SqlJsonConstructorNullClause nullClause)
static String	jsonPretty(JsonFunctions.JsonValueContext input)
static String	jsonPretty(String input)
static String	jsonQuery(JsonFunctions.JsonPathContext context, SqlJsonQueryWrapperBehavior wrapperBehavior, SqlJsonQueryEmptyOrErrorBehavior emptyBehavior, SqlJsonQueryEmptyOrErrorBehavior errorBehavior)
static String	jsonQuery(JsonFunctions.JsonValueContext input, String pathSpec, SqlJsonQueryWrapperBehavior wrapperBehavior, SqlJsonQueryEmptyOrErrorBehavior emptyBehavior, SqlJsonQueryEmptyOrErrorBehavior errorBehavior)
static String	jsonQuery(String input, String pathSpec, SqlJsonQueryWrapperBehavior wrapperBehavior, SqlJsonQueryEmptyOrErrorBehavior emptyBehavior, SqlJsonQueryEmptyOrErrorBehavior errorBehavior)
static String	jsonRemove(JsonFunctions.JsonValueContext input, String... pathSpecs)
static String	jsonRemove(String input, String... pathSpecs)
static Integer	jsonStorageSize(JsonFunctions.JsonValueContext input)
static Integer	jsonStorageSize(String input)
static String	jsonType(JsonFunctions.JsonValueContext input)
static String	jsonType(String input)
static Object	jsonValue(JsonFunctions.JsonPathContext context, SqlJsonValueEmptyOrErrorBehavior emptyBehavior, Object defaultValueOnEmpty, SqlJsonValueEmptyOrErrorBehavior errorBehavior, Object defaultValueOnError)
static Object	jsonValue(JsonFunctions.JsonValueContext input, String pathSpec, SqlJsonValueEmptyOrErrorBehavior emptyBehavior, Object defaultValueOnEmpty, SqlJsonValueEmptyOrErrorBehavior errorBehavior, Object defaultValueOnError)
static Object	jsonValue(String input, String pathSpec, SqlJsonValueEmptyOrErrorBehavior emptyBehavior, Object defaultValueOnEmpty, SqlJsonValueEmptyOrErrorBehavior errorBehavior, Object defaultValueOnError)
static JsonFunctions.JsonValueContext	jsonValueExpression(String input)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

jsonize

public static String jsonize(Object input)

dejsonize

public static Object dejsonize(String input)

jsonValueExpression

public static JsonFunctions.JsonValueContext jsonValueExpression(String input)

jsonApiCommonSyntax

public static JsonFunctions.JsonPathContext jsonApiCommonSyntax(String input)

jsonApiCommonSyntax

public static JsonFunctions.JsonPathContext jsonApiCommonSyntax(JsonFunctions.JsonValueContext input)

jsonApiCommonSyntax

public static JsonFunctions.JsonPathContext jsonApiCommonSyntax(String input,
                                                                String pathSpec)

jsonApiCommonSyntax

public static JsonFunctions.JsonPathContext jsonApiCommonSyntax(JsonFunctions.JsonValueContext input,
                                                                String pathSpec)

jsonExists

public static Boolean jsonExists(String input,
                                 String pathSpec)

jsonExists

public static Boolean jsonExists(String input,
                                 String pathSpec,
                                 SqlJsonExistsErrorBehavior errorBehavior)

jsonExists

public static Boolean jsonExists(JsonFunctions.JsonValueContext input,
                                 String pathSpec)

jsonExists

public static Boolean jsonExists(JsonFunctions.JsonValueContext input,
                                 String pathSpec,
                                 SqlJsonExistsErrorBehavior errorBehavior)

jsonExists

public static Boolean jsonExists(JsonFunctions.JsonPathContext context)

jsonExists

public static Boolean jsonExists(JsonFunctions.JsonPathContext context,
                                 SqlJsonExistsErrorBehavior errorBehavior)

jsonValue

public static Object jsonValue(String input,
                               String pathSpec,
                               SqlJsonValueEmptyOrErrorBehavior emptyBehavior,
                               Object defaultValueOnEmpty,
                               SqlJsonValueEmptyOrErrorBehavior errorBehavior,
                               Object defaultValueOnError)

jsonValue

public static Object jsonValue(JsonFunctions.JsonValueContext input,
                               String pathSpec,
                               SqlJsonValueEmptyOrErrorBehavior emptyBehavior,
                               Object defaultValueOnEmpty,
                               SqlJsonValueEmptyOrErrorBehavior errorBehavior,
                               Object defaultValueOnError)

jsonValue

public static Object jsonValue(JsonFunctions.JsonPathContext context,
                               SqlJsonValueEmptyOrErrorBehavior emptyBehavior,
                               Object defaultValueOnEmpty,
                               SqlJsonValueEmptyOrErrorBehavior errorBehavior,
                               Object defaultValueOnError)

jsonQuery

public static String jsonQuery(String input,
                               String pathSpec,
                               SqlJsonQueryWrapperBehavior wrapperBehavior,
                               SqlJsonQueryEmptyOrErrorBehavior emptyBehavior,
                               SqlJsonQueryEmptyOrErrorBehavior errorBehavior)

jsonQuery

public static String jsonQuery(JsonFunctions.JsonValueContext input,
                               String pathSpec,
                               SqlJsonQueryWrapperBehavior wrapperBehavior,
                               SqlJsonQueryEmptyOrErrorBehavior emptyBehavior,
                               SqlJsonQueryEmptyOrErrorBehavior errorBehavior)

jsonQuery

public static String jsonQuery(JsonFunctions.JsonPathContext context,
                               SqlJsonQueryWrapperBehavior wrapperBehavior,
                               SqlJsonQueryEmptyOrErrorBehavior emptyBehavior,
                               SqlJsonQueryEmptyOrErrorBehavior errorBehavior)

jsonObject

public static String jsonObject(SqlJsonConstructorNullClause nullClause,
                                Object... kvs)

jsonObjectAggAdd

public static void jsonObjectAggAdd(Map map,
                                    String k,
                                    Object v,
                                    SqlJsonConstructorNullClause nullClause)

jsonArray

public static String jsonArray(SqlJsonConstructorNullClause nullClause,
                               Object... elements)

jsonArrayAggAdd

public static void jsonArrayAggAdd(List list,
                                   Object element,
                                   SqlJsonConstructorNullClause nullClause)

jsonPretty

public static String jsonPretty(String input)

jsonPretty

public static String jsonPretty(JsonFunctions.JsonValueContext input)

jsonType

public static String jsonType(String input)

jsonType

public static String jsonType(JsonFunctions.JsonValueContext input)

jsonDepth

public static Integer jsonDepth(String input)

jsonDepth

public static Integer jsonDepth(JsonFunctions.JsonValueContext input)

jsonLength

public static Integer jsonLength(String input)

jsonLength

public static Integer jsonLength(JsonFunctions.JsonValueContext input)

jsonLength

public static Integer jsonLength(String input,
                                 String pathSpec)

jsonLength

public static Integer jsonLength(JsonFunctions.JsonValueContext input,
                                 String pathSpec)

jsonLength

public static Integer jsonLength(JsonFunctions.JsonPathContext context)

jsonKeys

public static String jsonKeys(String input)

jsonKeys

public static String jsonKeys(JsonFunctions.JsonValueContext input)

jsonKeys

public static String jsonKeys(String input,
                              String pathSpec)

jsonKeys

public static String jsonKeys(JsonFunctions.JsonValueContext input,
                              String pathSpec)

jsonKeys

public static String jsonKeys(JsonFunctions.JsonPathContext context)

jsonRemove

public static String jsonRemove(String input,
                                String... pathSpecs)

jsonRemove

public static String jsonRemove(JsonFunctions.JsonValueContext input,
                                String... pathSpecs)

jsonStorageSize

public static Integer jsonStorageSize(String input)

jsonStorageSize

public static Integer jsonStorageSize(JsonFunctions.JsonValueContext input)

isJsonValue

public static boolean isJsonValue(String input)

isJsonObject

public static boolean isJsonObject(String input)

isJsonArray

public static boolean isJsonArray(String input)

isJsonScalar

public static boolean isJsonScalar(String input)