Top Description Methods
org.jooq

public Interface CaseValueStep<V>

Known Direct Implementers
org.jooq.impl.CaseSimpleValueStep
Type Parameters
<V>
The type of values being compared in this case statement
Imports
java.util.Map, org.jetbrains.annotations.NotNull

An intermediary 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 TypeMethod and Description
public <T> @NotNull CaseWhenStep<V, T>
mapFields(Map<? extends Field<V>, ? extends Field<T>> fields)

Deprecated as a consequence of CaseWhenStep being deprecated.
Create WHEN … THEN expressions from a Map.
public <T> @NotNull CaseWhenStep<V, T>
mapValues(Map<V, T> values)

Deprecated as a consequence of CaseWhenStep being deprecated.
Create WHEN … THEN expressions from a Map.
public <
The generic result field type parameter
T
>
@NotNull CaseWhenStep<V, T>

Returns:

An intermediary step for case statement construction
when
(V
The value to compare with the already constructed case statement
compareValue
,
T
The result value if values are equal
result
)

Deprecated as a consequence of CaseWhenStep being deprecated.
Compare a value to the already constructed case statement, return result if values are equal.
public <
The generic result field type parameter
T
>
@NotNull CaseWhenStep<V, T>

Returns:

An intermediary step for case statement construction
when
(V
The value to compare with the already constructed case statement
compareValue
,
Field<T>
The result value if values are equal
result
)

Deprecated as a consequence of Field and CaseWhenStep being deprecated.
Compare a value to the already constructed case statement, return result if values are equal.
public <
The generic result field type parameter
T
>
@NotNull CaseWhenStep<V, T>

Returns:

An intermediary step for case statement construction
when
(V
The value to compare with the already constructed case statement
compareValue
,
Select<? extends Record1<T>>
The result value if values are equal
result
)

Deprecated as a consequence of CaseWhenStep being deprecated.
Compare a value to the already constructed case statement, return result if values are equal.
public <
The generic result field type parameter
T
>
@NotNull CaseWhenStep<V, T>

Returns:

An intermediary step for case statement construction
when
(Field<V>
The value to compare with the already constructed case statement
compareValue
,
T
The result value if values are equal
result
)

Deprecated as a consequence of Field and CaseWhenStep being deprecated.
Compare a value to the already constructed case statement, return result if values are equal.
public <
The generic result field type parameter
T
>
@NotNull CaseWhenStep<V, T>

Returns:

An intermediary step for case statement construction
when
(Field<V>
The value to compare with the already constructed case statement
compareValue
,
Field<T>
The result value if values are equal
result
)

Deprecated as a consequence of Field and CaseWhenStep being deprecated.
Compare a value to the already constructed case statement, return result if values are equal.
public <
The generic result field type parameter
T
>
@NotNull CaseWhenStep<V, T>

Returns:

An intermediary step for case statement construction
when
(Field<V>
The value to compare with the already constructed case statement
compareValue
,
Select<? extends Record1<T>>
The result value if values are equal
result
)

Deprecated as a consequence of Field and CaseWhenStep being deprecated.
Compare a value to the already constructed case statement, return result if values are equal.

Method Detail

mapFieldsback to summary
public <T> @NotNull CaseWhenStep<V, T> mapFields(Map<? extends Field<V>, ? extends Field<T>> fields)

Deprecated

as a consequence of CaseWhenStep being deprecated. See corresponding docs for further information.

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.

Annotations
@NotNull
@Support
mapValuesback to summary
public <T> @NotNull CaseWhenStep<V, T> mapValues(Map<V, T> values)

Deprecated

as a consequence of CaseWhenStep being deprecated. See corresponding docs for further information.

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.

Annotations
@NotNull
@Support
whenback to summary
public <T> @NotNull CaseWhenStep<V, T> when(V compareValue, T result)

Deprecated

as a consequence of CaseWhenStep being deprecated. See corresponding docs for further information.

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

Parameters
<T>
The generic result field type parameter
compareValue:V

The value to compare with the already constructed case statement

result:T

The result value if values are equal

Returns:@NotNull CaseWhenStep<V, T>

An intermediary step for case statement construction

Annotations
@NotNull
@Support
whenback to summary
public <T> @NotNull CaseWhenStep<V, T> when(V compareValue, Field<T> result)

Deprecated

as a consequence of Field and CaseWhenStep being deprecated. See corresponding docs for further information.

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

Parameters
<T>
The generic result field type parameter
compareValue:V

The value to compare with the already constructed case statement

result:Field<T>

The result value if values are equal

Returns:@NotNull CaseWhenStep<V, T>

An intermediary step for case statement construction

Annotations
@NotNull
@Support
whenback to summary
public <T> @NotNull CaseWhenStep<V, T> when(V compareValue, Select<? extends Record1<T>> result)

Deprecated

as a consequence of CaseWhenStep being deprecated. See corresponding docs for further information.

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

Parameters
<T>
The generic result field type parameter
compareValue:V

The value to compare with the already constructed case statement

result:Select<? extends Record1<T>>

The result value if values are equal

Returns:@NotNull CaseWhenStep<V, T>

An intermediary step for case statement construction

Annotations
@NotNull
@Support
whenback to summary
public <T> @NotNull CaseWhenStep<V, T> when(Field<V> compareValue, T result)

Deprecated

as a consequence of Field and CaseWhenStep being deprecated. See corresponding docs for further information.

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

Parameters
<T>
The generic result field type parameter
compareValue:Field<V>

The value to compare with the already constructed case statement

result:T

The result value if values are equal

Returns:@NotNull CaseWhenStep<V, T>

An intermediary step for case statement construction

Annotations
@NotNull
@Support
whenback to summary
public <T> @NotNull CaseWhenStep<V, T> when(Field<V> compareValue, Field<T> result)

Deprecated

as a consequence of Field and CaseWhenStep being deprecated. See corresponding docs for further information.

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

Parameters
<T>
The generic result field type parameter
compareValue:Field<V>

The value to compare with the already constructed case statement

result:Field<T>

The result value if values are equal

Returns:@NotNull CaseWhenStep<V, T>

An intermediary step for case statement construction

Annotations
@NotNull
@Support
whenback to summary
public <T> @NotNull CaseWhenStep<V, T> when(Field<V> compareValue, Select<? extends Record1<T>> result)

Deprecated

as a consequence of Field and CaseWhenStep being deprecated. See corresponding docs for further information.

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

Parameters
<T>
The generic result field type parameter
compareValue:Field<V>

The value to compare with the already constructed case statement

result:Select<? extends Record1<T>>

The result value if values are equal

Returns:@NotNull CaseWhenStep<V, T>

An intermediary step for case statement construction

Annotations
@NotNull
@Support