Interface CaseWhenStep<V,T>

Type Parameters:

V - The type of values being compared in this case statement

T - The type returned by this case statement

All Superinterfaces:

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

public interface CaseWhenStep<V,T>
extends Field<T>

The final step in creating a case statement of the type

CASE x WHEN 1 THEN 'one'
       WHEN 2 THEN 'two'
       ELSE        'three'
END

Author:

Lukas Eder

See Also:

• Case

Method Summary

Modifier and Type	Method	Description
@NotNull Field<T>	else_(Field<T> result)	Add an else clause to the already constructed case statement
@NotNull Field<T>	else_(T result)	Add an else clause to the already constructed case statement
@NotNull CaseWhenStep<V,T>	mapFields(Map<? extends Field<V>, ? extends Field<T>> fields)	Create WHEN … THEN expressions from a Map.
@NotNull CaseWhenStep<V,T>	mapValues(Map<V,T> values)	Create WHEN … THEN expressions from a Map.
@NotNull Field<T>	otherwise(Field<T> result)	Add an else clause to the already constructed case statement
@NotNull Field<T>	otherwise(T result)	Add an else clause to the already constructed case statement
@NotNull CaseWhenStep<V,T>	when(Field<V> compareValue, Field<T> result)	Compare a value to the already constructed case statement, return result if values are equal.
@NotNull CaseWhenStep<V,T>	when(Field<V> compareValue, T result)	Compare a value to the already constructed case statement, return result if values are equal.
@NotNull CaseWhenStep<V,T>	when(V compareValue, Field<T> result)	Compare a value to the already constructed case statement, return result if values are equal.
@NotNull CaseWhenStep<V,T>	when(V compareValue, T result)	Compare a value to the already constructed case statement, return result if values are equal.

Methods inherited from interface Field

add, add, as, as, as, as, asc, ascii, 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, 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, decode, decode, decode, decode, desc, div, div, divide, divide, endsWith, endsWith, endsWithIgnoreCase, endsWithIgnoreCase, eq, eq, eq, eq, equal, equal, equal, equal, equalIgnoreCase, equalIgnoreCase, equals, field, from, ge, ge, ge, ge, get, getComment, getName, getValue, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterThan, greaterThan, greaterThan, greaterThan, gt, gt, gt, gt, in, in, in, in, in, isDistinctFrom, isDistinctFrom, isDistinctFrom, isDocument, isFalse, isJson, isNotDistinctFrom, isNotDistinctFrom, isNotDistinctFrom, isNotDocument, isNotJson, isNotNull, isNull, isTrue, le, le, le, le, length, lessOrEqual, lessOrEqual, lessOrEqual, lessOrEqual, lessThan, lessThan, lessThan, lessThan, like, like, like, like, like, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeRegex, likeRegex, lower, lpad, lpad, lpad, lpad, lt, lt, lt, lt, ltrim, 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, rem, rem, repeat, repeat, replace, replace, replace, replace, reset, rpad, rpad, rpad, rpad, rtrim, shl, shl, shr, shr, similarTo, similarTo, similarTo, similarTo, similarTo, sort, sort, sortAsc, sortAsc, sortDefault, sortDesc, sortDesc, startsWith, startsWith, startsWithIgnoreCase, startsWithIgnoreCase, sub, sub, substring, substring, substring, substring, subtract, subtract, times, times, touched, trim, unaryMinus, unaryPlus, upper

Methods inherited from interface Named

$name, getCommentPart, getQualifiedName, getUnqualifiedName

Methods inherited from interface QueryPart

$replace, $replace, $traverse, $traverse, hashCode, toString

Methods inherited from interface Typed

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

Method Details

when

@NotNull
@Support
@NotNull CaseWhenStep<V,T> when(V compareValue,
 T result)

Compare a value to the already constructed case statement, return result if values are equal.

Parameters:

compareValue - The value to compare with the already constructed case statement

result - The result value if values are equal

Returns:

An intermediary step for case statement construction

when

@NotNull
@Support
@NotNull CaseWhenStep<V,T> when(V compareValue,
 Field<T> result)

Compare a value to the already constructed case statement, return result if values are equal.

Parameters:

compareValue - The value to compare with the already constructed case statement

result - The result value if values are equal

Returns:

An intermediary step for case statement construction

when

@NotNull
@Support
@NotNull CaseWhenStep<V,T> when(Field<V> compareValue,
 T result)

Compare a value to the already constructed case statement, return result if values are equal.

Parameters:

compareValue - The value to compare with the already constructed case statement

result - The result value if values are equal

Returns:

An intermediary step for case statement construction

when

@NotNull
@Support
@NotNull CaseWhenStep<V,T> when(Field<V> compareValue,
 Field<T> result)

Compare a value to the already constructed case statement, return result if values are equal.

Parameters:

compareValue - The value to compare with the already constructed case statement

result - The result value if values are equal

Returns:

An intermediary step for case statement construction

mapValues

@NotNull
@Support
@NotNull CaseWhenStep<V,T> mapValues(Map<V,T> values)

Create WHEN … THEN expressions from a Map.

This will iterate over the map's entries to create individual WHEN … THEN expressions for each map entry.

mapFields

@NotNull
@Support
@NotNull CaseWhenStep<V,T> mapFields(Map<? extends Field<V>, ? extends Field<T>> fields)

Create WHEN … THEN expressions from a Map.

This will iterate over the map's entries to create individual WHEN … THEN expressions for each map entry.

otherwise

@NotNull
@Support
@NotNull Field<T> otherwise(T result)

Add an else clause to the already constructed case statement

Parameters:

result - The result value if no other value matches the case

Returns:

The resulting field from case statement construction

otherwise

@NotNull
@Support
@NotNull Field<T> otherwise(Field<T> result)

Add an else clause to the already constructed case statement

Parameters:

result - The result value if no other value matches the case

Returns:

The resulting field from case statement construction

else_

@NotNull
@Support
@NotNull Field<T> else_(T result)

Add an else clause to the already constructed case statement

Parameters:

result - The result value if no other value matches the case

Returns:

The resulting field from case statement construction

else_

@NotNull
@Support
@NotNull Field<T> else_(Field<T> result)

Add an else clause to the already constructed case statement

Parameters:

result - The result value if no other value matches the case

Returns:

The resulting field from case statement construction