Module org.jooq

Package org.jooq.impl

Interface QOM.JSONValue<T>

All Superinterfaces:

Field<T>, FieldOrConstraint, FieldOrRow, FieldOrRowOrSelect, GroupField, Named, OrderField<T>, QueryPart, SelectField<T>, SelectFieldOrAsterisk, Serializable, TableElement, Typed<T>

Enclosing class:

QOM

public static interface QOM.JSONValue<T>
extends Field<T>

The JSON VALUE function.

Method Summary

Modifier and Type	Method	Description
DataType<T>	$arg1()
default QOM.JSONValue<T>	$arg1(DataType<T> newArg1)
Field<T>	$arg2()
default QOM.JSONValue<T>	$arg2(Field<T> newArg2)
Field<String>	$arg3()
default QOM.JSONValue<T>	$arg3(Field<String> newArg3)
QOM.JSONValueBehavior	$arg4()
default QOM.JSONValue<T>	$arg4(QOM.JSONValueBehavior newArg4)
QOM.JSONValueBehavior	$arg5()
default QOM.JSONValue<T>	$arg5(QOM.JSONValueBehavior newArg5)
Field<?>	$arg6()
default QOM.JSONValue<T>	$arg6(Field<?> newArg6)
Field<?>	$arg7()
default QOM.JSONValue<T>	$arg7(Field<?> newArg7)
DataType<?>	$arg8()
default QOM.JSONValue<T>	$arg8(DataType<?> newArg8)
default @NotNull List<?>	$args()
@NotNull Function8<? super DataType<T>,? super Field<T>,? super Field<String>,? super QOM.JSONValueBehavior,? super QOM.JSONValueBehavior,? super Field<?>,? super Field<?>,? super DataType<?>,? extends QOM.JSONValue<T>>	$constructor()
default @NotNull Field<T>	$json()
default @NotNull QOM.JSONValue<T>	$json(Field<T> newJson)
default @Nullable QOM.JSONValueBehavior	$onEmpty()
default @NotNull QOM.JSONValue<T>	$onEmpty(QOM.JSONValueBehavior newOnEmpty)
default @Nullable Field<?>	$onEmptyDefault()
default @NotNull QOM.JSONValue<T>	$onEmptyDefault(Field<?> newOnEmptyDefault)
default @Nullable QOM.JSONValueBehavior	$onError()
default @NotNull QOM.JSONValue<T>	$onError(QOM.JSONValueBehavior newOnError)
default @Nullable Field<?>	$onErrorDefault()
default @NotNull QOM.JSONValue<T>	$onErrorDefault(Field<?> newOnErrorDefault)
default @NotNull Field<String>	$path()
default @NotNull QOM.JSONValue<T>	$path(Field<String> newPath)
default QueryPart	$replace(Replacer replacer)	Traverse a QueryPart hierarchy and recursively replace its elements by alternatives.
default @Nullable DataType<?>	$returning()
default @NotNull QOM.JSONValue<T>	$returning(DataType<?> newReturning)
default <T> T	$traverse(Traverser<?,T> traverser)	Traverser this QueryPart expression tree using a composable Traverser, producing a result.
default @NotNull DataType<T>	$type()
default @NotNull QOM.JSONValue<T>	$type(DataType<T> newType)

Methods inherited from interface org.jooq.Field

abs, acos, add, add, as, as, as, as, asc, ascii, asin, atan, atan2, atan2, avg, avgOver, between, between, between, between, betweenSymmetric, betweenSymmetric, betweenSymmetric, betweenSymmetric, binaryLike, binaryLike, binaryLike, bitAnd, bitAnd, bitLength, bitNand, bitNand, bitNor, bitNor, bitNot, bitOr, bitOr, bitXNor, bitXNor, bitXor, bitXor, cast, cast, cast, ceil, changed, charLength, coalesce, coalesce, coerce, coerce, coerce, collate, collate, collate, comment, comment, compare, compare, compare, compare, concat, concat, concat, contains, contains, containsIgnoreCase, containsIgnoreCase, convert, convert, convert, convertFrom, convertFrom, convertTo, convertTo, cos, cosh, cot, coth, count, countDistinct, countOver, decode, decode, decode, decode, deg, desc, div, div, divide, divide, endsWith, endsWith, endsWithIgnoreCase, endsWithIgnoreCase, eq, eq, eq, eq, equal, equal, equal, equal, equalIgnoreCase, equalIgnoreCase, equals, exp, extract, field, firstValue, floor, from, ge, ge, ge, ge, get, getComment, getName, getValue, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterThan, greaterThan, greaterThan, greaterThan, greatest, greatest, gt, gt, gt, gt, in, in, in, in, in, isDistinctFrom, isDistinctFrom, isDistinctFrom, isDocument, isFalse, isJson, isNotDistinctFrom, isNotDistinctFrom, isNotDistinctFrom, isNotDocument, isNotJson, isNotNull, isNull, isTrue, lag, lag, lag, lag, lastValue, le, le, le, le, lead, lead, lead, lead, least, least, length, lessOrEqual, lessOrEqual, lessOrEqual, lessOrEqual, lessThan, lessThan, lessThan, lessThan, like, like, like, like, like, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeRegex, likeRegex, ln, log, lower, lpad, lpad, lpad, lpad, lt, lt, lt, lt, ltrim, max, maxOver, median, min, minOver, minus, minus, mod, mod, modulo, modulo, mul, mul, multiply, multiply, ne, ne, ne, ne, neg, notBetween, notBetween, notBetween, notBetween, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notBinaryLike, notBinaryLike, notBinaryLike, notContains, notContains, notContainsIgnoreCase, notContainsIgnoreCase, notEqual, notEqual, notEqual, notEqual, notEqualIgnoreCase, notEqualIgnoreCase, notIn, notIn, notIn, notIn, notIn, notLike, notLike, notLike, notLike, notLike, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeRegex, notLikeRegex, notSimilarTo, notSimilarTo, notSimilarTo, notSimilarTo, notSimilarTo, nullif, nullif, nullsFirst, nullsLast, nvl, nvl, nvl2, nvl2, octetLength, original, plus, plus, plus, position, position, pow, pow, power, power, rad, rem, rem, repeat, repeat, replace, replace, replace, replace, reset, round, round, rpad, rpad, rpad, rpad, rtrim, shl, shl, shr, shr, sign, similarTo, similarTo, similarTo, similarTo, similarTo, sin, sinh, sort, sort, sortAsc, sortAsc, sortDefault, sortDesc, sortDesc, sqrt, startsWith, startsWith, startsWithIgnoreCase, startsWithIgnoreCase, stddevPop, stddevPopOver, stddevSamp, stddevSampOver, sub, sub, substring, substring, substring, substring, subtract, subtract, sum, sumOver, tan, tanh, times, times, touched, trim, unaryMinus, unaryPlus, upper, varPop, varPopOver, varSamp, varSampOver

Methods inherited from interface org.jooq.Named

$name, getCommentPart, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart

$replace, $traverse, hashCode, toString

Methods inherited from interface org.jooq.Typed

$dataType, getBinding, getConverter, getDataType, getDataType, getType

Method Details

$type

@NotNull
default @NotNull DataType<T> $type()

$type

@CheckReturnValue
@NotNull
default @NotNull QOM.JSONValue<T> $type(DataType<T> newType)

$json

@NotNull
default @NotNull Field<T> $json()

$json

@CheckReturnValue
@NotNull
default @NotNull QOM.JSONValue<T> $json(Field<T> newJson)

$path

@NotNull
default @NotNull Field<String> $path()

$path

@CheckReturnValue
@NotNull
default @NotNull QOM.JSONValue<T> $path(Field<String> newPath)

$onEmpty

@Nullable
default @Nullable QOM.JSONValueBehavior $onEmpty()

$onEmpty

@CheckReturnValue
@NotNull
default @NotNull QOM.JSONValue<T> $onEmpty(QOM.JSONValueBehavior newOnEmpty)

$onError

@Nullable
default @Nullable QOM.JSONValueBehavior $onError()

$onError

@CheckReturnValue
@NotNull
default @NotNull QOM.JSONValue<T> $onError(QOM.JSONValueBehavior newOnError)

$onEmptyDefault

@Nullable
default @Nullable Field<?> $onEmptyDefault()

$onEmptyDefault

@CheckReturnValue
@NotNull
default @NotNull QOM.JSONValue<T> $onEmptyDefault(Field<?> newOnEmptyDefault)

$onErrorDefault

@Nullable
default @Nullable Field<?> $onErrorDefault()

$onErrorDefault

@CheckReturnValue
@NotNull
default @NotNull QOM.JSONValue<T> $onErrorDefault(Field<?> newOnErrorDefault)

$returning

@Nullable
default @Nullable DataType<?> $returning()

$returning

@CheckReturnValue
@NotNull
default @NotNull QOM.JSONValue<T> $returning(DataType<?> newReturning)

$arg1

DataType<T> $arg1()

$arg2

Field<T> $arg2()

$arg3

Field<String> $arg3()

$arg4

QOM.JSONValueBehavior $arg4()

$arg5

QOM.JSONValueBehavior $arg5()

$arg6

Field<?> $arg6()

$arg7

Field<?> $arg7()

$arg8

DataType<?> $arg8()

$arg1

@CheckReturnValue
@NotNull
default QOM.JSONValue<T> $arg1(DataType<T> newArg1)

$arg2

@CheckReturnValue
@NotNull
default QOM.JSONValue<T> $arg2(Field<T> newArg2)

$arg3

@CheckReturnValue
@NotNull
default QOM.JSONValue<T> $arg3(Field<String> newArg3)

$arg4

@CheckReturnValue
@NotNull
default QOM.JSONValue<T> $arg4(QOM.JSONValueBehavior newArg4)

$arg5

@CheckReturnValue
@NotNull
default QOM.JSONValue<T> $arg5(QOM.JSONValueBehavior newArg5)

$arg6

@CheckReturnValue
@NotNull
default QOM.JSONValue<T> $arg6(Field<?> newArg6)

$arg7

@CheckReturnValue
@NotNull
default QOM.JSONValue<T> $arg7(Field<?> newArg7)

$arg8

@CheckReturnValue
@NotNull
default QOM.JSONValue<T> $arg8(DataType<?> newArg8)

$constructor

@NotNull
@NotNull Function8<? super DataType<T>,? super Field<T>,? super Field<String>,? super QOM.JSONValueBehavior,? super QOM.JSONValueBehavior,? super Field<?>,? super Field<?>,? super DataType<?>,? extends QOM.JSONValue<T>> $constructor()

$args

@NotNull
default @NotNull List<?> $args()

$traverse

default <T> T $traverse(Traverser<?,T> traverser)

Description copied from interface: QueryPart

Traverser this QueryPart expression tree using a composable Traverser, producing a result.

This offers a generic way to traverse expression trees to translate the tree to arbitrary other data structures. The simplest traversal would just count all the tree elements:

 int count = CUSTOMER.NAME.eq(1).$traverse(0, (i, p) -> i + 1);
 

The same can be achieved by translating the JDK Collector API to the Traverser API using Traversers.collecting(Collector).

 CUSTOMER.NAME.eq(1).$traverse(Traversers.collecting(Collectors.counting()));
 

Unlike a Collector, a Traverser is optimised for tree traversal, not stream traversal:

• Is not designed for parallelism
• It can Traverser.abort() traversal early when the result can be produced early (e.g. when running Traversers.containing(QueryPart), and a result has been found).
• It can decide whether to Traverser.recurse() into a QueryPart subtree, or whether that is not necessary or even undesirable, e.g. to prevent entering new subquery scopes.
• Unlike a Collector, which can use its Collector.accumulator() to accumulate each element only once, in tree traversal, it's desirable to be able to distinguish between accumulating an item Traverser.before() or Traverser.after() recursing into it. This is useful e.g. to wrap each tree node in XML opening and closing tags.

This is a commercial jOOQ edition only feature.

Specified by:

$traverse in interface QueryPart

$replace

@NotNull
default QueryPart $replace(Replacer replacer)

Description copied from interface: QueryPart

Traverse a QueryPart hierarchy and recursively replace its elements by alternatives.

While replacing contents, this QueryPart isn't modified. Instead, a new object is returned.

This is a commercial jOOQ edition only feature.

Specified by:

$replace in interface QueryPart