Module org.jooq
Package org.jooq

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:
  • 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