Uses of Class
org.jooq.JSONB
Packages that use JSONB
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of JSONB in org.jooq
Modifier and TypeMethodDescriptionstatic final @NotNull JSONBCreate a newJSONBinstance from string data input.static final @Nullable JSONBJSONB.jsonbOrNull(String data) static final @NotNull JSONBCreate a newJSONBinstance from string data input.Modifier and TypeMethodDescription@NotNull SelectForJSONStep<Record1<JSONB>> SelectForStep.forJSONB()Add a SQL Server-styleFOR JSONclause. -
Uses of JSONB in org.jooq.impl
Fields in org.jooq.impl with type parameters of type JSONBMethods in org.jooq.impl that return types with arguments of type JSONBModifier and TypeMethodDescriptionQOM.JSONBArrayLength.$field()QOM.JSONBGetAttribute.$field()The JSONB documentQOM.JSONBGetAttributeAsText.$field()The JSONB documentQOM.JSONBGetElement.$field()The JSONB documentQOM.JSONBGetElementAsText.$field()The JSONB documentQOM.JSONBInsert.$field()QOM.JSONBKeys.$field()QOM.JSONBRemove.$field()QOM.JSONBReplace.$field()QOM.JSONBSet.$field()QOM.JSONBKeyExists.$json()The JSONB objectCreate a bind value that is always inlined.static @NotNull JSONArrayNullStep<JSONB> DSL.jsonbArray(Collection<? extends Field<?>> fields) TheJSONB_ARRAYfunction.static @NotNull JSONArrayNullStep<JSONB> DSL.jsonbArray(Field<?>... fields) TheJSONB_ARRAYfunction.static <T> @NotNull JSONArrayQueryNullStep<JSONB> DSL.jsonbArray(Select<? extends Record1<?>> select) TheJSONB_ARRAYfunction.static @NotNull JSONArrayAggOrderByStep<JSONB> DSL.jsonbArrayAgg(Field<?> value) The JSON array aggregate function.static @NotNull JSONArrayAggOrderByStep<JSONB> DSL.jsonbArrayAggDistinct(Field<?> value) The JSON array aggregate function.DSL.jsonbGetAttribute(Field<JSONB> field, String attribute) TheJSONB_GET_ATTRIBUTEfunction.DSL.jsonbGetAttribute(Field<JSONB> field, Field<String> attribute) TheJSONB_GET_ATTRIBUTEfunction.DSL.jsonbGetAttribute(JSONB field, String attribute) TheJSONB_GET_ATTRIBUTEfunction.DSL.jsonbGetAttribute(JSONB field, Field<String> attribute) TheJSONB_GET_ATTRIBUTEfunction.DSL.jsonbGetElement(Field<JSONB> field, int index) TheJSONB_GET_ELEMENTfunction.DSL.jsonbGetElement(Field<JSONB> field, Field<Integer> index) TheJSONB_GET_ELEMENTfunction.DSL.jsonbGetElement(JSONB field, int index) TheJSONB_GET_ELEMENTfunction.DSL.jsonbGetElement(JSONB field, Field<Integer> index) TheJSONB_GET_ELEMENTfunction.DSL.jsonbInsert(Field<JSONB> field, String path, Object value) TheJSONB_INSERTfunction.DSL.jsonbInsert(Field<JSONB> field, String path, Field<?> value) TheJSONB_INSERTfunction.TheJSONB_INSERTfunction.TheJSONB_INSERTfunction.TheJSONB_KEYSfunction.TheJSONB_KEYSfunction.static @NotNull JSONObjectNullStep<JSONB> DSL.jsonbObject()The JSON object constructor.static @NotNull JSONObjectNullStep<JSONB> DSL.jsonbObject(String key, Field<?> value) The JSON object constructor.static @NotNull JSONObjectNullStep<JSONB> DSL.jsonbObject(Collection<? extends JSONEntry<?>> entries) TheJSONB_OBJECTfunction.static @NotNull JSONObjectNullStep<JSONB> DSL.jsonbObject(Field<?>... entries) Deprecated, for removal: This API element is subject to removal in a future version.static @NotNull JSONObjectNullStep<JSONB> DSL.jsonbObject(Field<String> key, Field<?> value) The JSON object constructor.static @NotNull JSONObjectNullStep<JSONB> DSL.jsonbObject(Field<String> key, Select<? extends Record1<?>> value) The JSON object constructor.static @NotNull JSONObjectNullStep<JSONB> DSL.jsonbObject(JSONEntry<?>... entries) TheJSONB_OBJECTfunction.static @NotNull JSONObjectAggNullStep<JSONB> DSL.jsonbObjectAgg(String key, Field<?> value) The JSONB object aggregate function.static @NotNull JSONObjectAggNullStep<JSONB> DSL.jsonbObjectAgg(Field<?> field) The JSONB object aggregate function.static @NotNull JSONObjectAggNullStep<JSONB> DSL.jsonbObjectAgg(Field<String> key, Field<?> value) The JSONB object aggregate function.static @NotNull JSONObjectAggNullStep<JSONB> DSL.jsonbObjectAgg(JSONEntry<?> entry) The JSONB object aggregate function.static @NotNull JSONQueryOnStep<JSONB> DSL.jsonbQuery(Field<JSONB> json, String path) TheJSONB_QUERYfunction.static @NotNull JSONQueryOnStep<JSONB> DSL.jsonbQuery(Field<JSONB> json, Field<String> path) TheJSONB_QUERYfunction.DSL.jsonbRemove(Field<JSONB> field, String path) TheJSONB_REMOVEfunction.DSL.jsonbRemove(Field<JSONB> field, Field<String> path) TheJSONB_REMOVEfunction.DSL.jsonbReplace(Field<JSONB> field, String path, Object value) TheJSONB_REPLACEfunction.DSL.jsonbReplace(Field<JSONB> field, String path, Field<?> value) TheJSONB_REPLACEfunction.TheJSONB_REPLACEfunction.TheJSONB_REPLACEfunction.TheJSONB_SETfunction.TheJSONB_SETfunction.TheJSONB_SETfunction.TheJSONB_SETfunction.static @NotNull JSONValueOnStep<JSONB> DSL.jsonbValue(Field<JSONB> json, String path) TheJSONB_VALUEfunction.static @NotNull JSONValueOnStep<JSONB> DSL.jsonbValue(Field<JSONB> json, Field<String> path) TheJSONB_VALUEfunction.Get a bind value.A synonym forDSL.val(JSONB)to be used in Scala and Groovy, wherevalis a reserved keyword.Methods in org.jooq.impl with parameters of type JSONBModifier and TypeMethodDescriptionCreate a bind value that is always inlined.DSL.jsonbArrayLength(JSONB field) TheJSONB_ARRAY_LENGTHfunction.DSL.jsonbGetAttribute(JSONB field, String attribute) TheJSONB_GET_ATTRIBUTEfunction.DSL.jsonbGetAttribute(JSONB field, Field<String> attribute) TheJSONB_GET_ATTRIBUTEfunction.DSL.jsonbGetAttributeAsText(JSONB field, String attribute) TheJSONB_GET_ATTRIBUTE_AS_TEXTfunction.DSL.jsonbGetAttributeAsText(JSONB field, Field<String> attribute) TheJSONB_GET_ATTRIBUTE_AS_TEXTfunction.DSL.jsonbGetElement(JSONB field, int index) TheJSONB_GET_ELEMENTfunction.DSL.jsonbGetElement(JSONB field, Field<Integer> index) TheJSONB_GET_ELEMENTfunction.DSL.jsonbGetElementAsText(JSONB field, int index) TheJSONB_GET_ELEMENT_AS_TEXTfunction.DSL.jsonbGetElementAsText(JSONB field, Field<Integer> index) TheJSONB_GET_ELEMENT_AS_TEXTfunction.static @NotNull ConditionDSL.jsonbKeyExists(JSONB json, String key) TheJSONB_KEY_EXISTSfunction.static @NotNull ConditionDSL.jsonbKeyExists(JSONB json, Field<String> key) TheJSONB_KEY_EXISTSfunction.TheJSONB_KEYSfunction.static @NotNull JSONTableColumnsFirstStepDSL.jsonbTable(JSONB json, String path) The JSON table function.Get a bind value.A synonym forDSL.val(JSONB)to be used in Scala and Groovy, wherevalis a reserved keyword.Method parameters in org.jooq.impl with type arguments of type JSONBModifier and TypeMethodDescriptiondefault @NotNull QOM.JSONBArrayLengthdefault @NotNull QOM.JSONBGetAttributeThe JSONB documentdefault @NotNull QOM.JSONBGetAttributeAsTextThe JSONB documentdefault @NotNull QOM.JSONBGetElementThe JSONB documentdefault @NotNull QOM.JSONBGetElementAsTextThe JSONB documentdefault @NotNull QOM.JSONBInsertdefault @NotNull QOM.JSONBKeysdefault @NotNull QOM.JSONBRemovedefault @NotNull QOM.JSONBReplacedefault @NotNull QOM.JSONBSetdefault @NotNull QOM.JSONBKeyExistsThe JSONB objectDSL.jsonbArrayLength(Field<JSONB> field) TheJSONB_ARRAY_LENGTHfunction.static @NotNull JSONExistsOnStepDSL.jsonbExists(Field<JSONB> field, String path) The JSONB exists predicate.static @NotNull JSONExistsOnStepDSL.jsonbExists(Field<JSONB> field, Field<String> path) The JSONB exists predicate.DSL.jsonbGetAttribute(Field<JSONB> field, String attribute) TheJSONB_GET_ATTRIBUTEfunction.DSL.jsonbGetAttribute(Field<JSONB> field, Field<String> attribute) TheJSONB_GET_ATTRIBUTEfunction.DSL.jsonbGetAttributeAsText(Field<JSONB> field, String attribute) TheJSONB_GET_ATTRIBUTE_AS_TEXTfunction.DSL.jsonbGetAttributeAsText(Field<JSONB> field, Field<String> attribute) TheJSONB_GET_ATTRIBUTE_AS_TEXTfunction.DSL.jsonbGetElement(Field<JSONB> field, int index) TheJSONB_GET_ELEMENTfunction.DSL.jsonbGetElement(Field<JSONB> field, Field<Integer> index) TheJSONB_GET_ELEMENTfunction.DSL.jsonbGetElementAsText(Field<JSONB> field, int index) TheJSONB_GET_ELEMENT_AS_TEXTfunction.DSL.jsonbGetElementAsText(Field<JSONB> field, Field<Integer> index) TheJSONB_GET_ELEMENT_AS_TEXTfunction.DSL.jsonbInsert(Field<JSONB> field, String path, Object value) TheJSONB_INSERTfunction.DSL.jsonbInsert(Field<JSONB> field, String path, Field<?> value) TheJSONB_INSERTfunction.TheJSONB_INSERTfunction.TheJSONB_INSERTfunction.static @NotNull ConditionDSL.jsonbKeyExists(Field<JSONB> json, String key) TheJSONB_KEY_EXISTSfunction.static @NotNull ConditionDSL.jsonbKeyExists(Field<JSONB> json, Field<String> key) TheJSONB_KEY_EXISTSfunction.TheJSONB_KEYSfunction.static @NotNull JSONQueryOnStep<JSONB> DSL.jsonbQuery(Field<JSONB> json, String path) TheJSONB_QUERYfunction.static @NotNull JSONQueryOnStep<JSONB> DSL.jsonbQuery(Field<JSONB> json, Field<String> path) TheJSONB_QUERYfunction.DSL.jsonbRemove(Field<JSONB> field, String path) TheJSONB_REMOVEfunction.DSL.jsonbRemove(Field<JSONB> field, Field<String> path) TheJSONB_REMOVEfunction.DSL.jsonbReplace(Field<JSONB> field, String path, Object value) TheJSONB_REPLACEfunction.DSL.jsonbReplace(Field<JSONB> field, String path, Field<?> value) TheJSONB_REPLACEfunction.TheJSONB_REPLACEfunction.TheJSONB_REPLACEfunction.TheJSONB_SETfunction.TheJSONB_SETfunction.TheJSONB_SETfunction.TheJSONB_SETfunction.static @NotNull JSONTableColumnsFirstStepDSL.jsonbTable(Field<JSONB> json, Field<String> path) The JSON table function.static @NotNull JSONValueOnStep<JSONB> DSL.jsonbValue(Field<JSONB> json, String path) TheJSONB_VALUEfunction.static @NotNull JSONValueOnStep<JSONB> DSL.jsonbValue(Field<JSONB> json, Field<String> path) TheJSONB_VALUEfunction.
Fieldarguments in this method is inconsistent with that of other overloads, such asDSL.jsonbObject(Field, Field), which can lead to subtle bugs.