org.teiid.json

Class JsonPathFunctionMethods

java.lang.Object

org.teiid.json.JsonPathFunctionMethods

@TeiidFunctions(category="JSON")
public class JsonPathFunctionMethods
extends Object

Constructor Summary

Constructors

Constructor and Description
JsonPathFunctionMethods()

Method Summary

Modifier and Type	Method and Description
static String	jsonPathValue(Clob clob, String jsonPath)
static String	jsonPathValue(Clob clob, String jsonPath, boolean nullLeaf)
static JsonType	jsonQuery(Clob clob, String jsonPath)
static JsonType	jsonQuery(Clob clob, String jsonPath, boolean nullLeaf)
static Object[]	jsonToArray(Clob clob, String jsonPath, boolean nullLeaf, String... colpaths)

Methods inherited from class java.lang.Object

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

Constructor Detail

JsonPathFunctionMethods

public JsonPathFunctionMethods()

Method Detail

jsonPathValue

@TeiidFunction(name="jsonpathvalue",
               pushdown=CAN_PUSHDOWN,
               nullOnNull=true)
public static String jsonPathValue(Clob clob,
                                                                                                                                              String jsonPath,
                                                                                                                                              boolean nullLeaf)
                                                                                                                                       throws IOException,
                                                                                                                                              SQLException

Throws:

IOException

SQLException

jsonPathValue

@TeiidFunction(name="jsonpathvalue",
               pushdown=CAN_PUSHDOWN,
               nullOnNull=true)
public static String jsonPathValue(Clob clob,
                                                                                                                                              String jsonPath)
                                                                                                                                       throws IOException,
                                                                                                                                              SQLException

Throws:

IOException

SQLException

jsonQuery

@TeiidFunction(name="jsonquery",
               pushdown=CAN_PUSHDOWN,
               nullOnNull=true)
public static JsonType jsonQuery(Clob clob,
                                                                                                                                        String jsonPath,
                                                                                                                                        boolean nullLeaf)
                                                                                                                                 throws IOException,
                                                                                                                                        SQLException

Throws:

IOException

SQLException

jsonQuery

@TeiidFunction(name="jsonquery",
               pushdown=CAN_PUSHDOWN,
               nullOnNull=true)
public static JsonType jsonQuery(Clob clob,
                                                                                                                                        String jsonPath)
                                                                                                                                 throws IOException,
                                                                                                                                        SQLException

Throws:

IOException

SQLException

jsonToArray

@TeiidFunction(name="jsontoarray",
               pushdown=CAN_PUSHDOWN,
               nullOnNull=true)
public static Object[] jsonToArray(Clob clob,
                                                                                                                                            String jsonPath,
                                                                                                                                            boolean nullLeaf,
                                                                                                                                            String... colpaths)
                                                                                                                                     throws IOException,
                                                                                                                                            SQLException,
                                                                                                                                            FunctionExecutionException

Throws:

IOException

SQLException

FunctionExecutionException