Module org.jooq
Package org.jooq

Interface CaseValueStep<V>

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

public interface CaseValueStep<V>
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:
  • Method Summary

    Modifier and Type
    Method
    Description
    <T> @NotNull CaseWhenStep<V,T>
    mapFields(Map<? extends Field<V>,? extends Field<T>> fields)
    Create WHEN … THEN expressions from a Map.
    <T> @NotNull CaseWhenStep<V,T>
    mapValues(Map<V,T> values)
    Create WHEN … THEN expressions from a Map.
    <T> @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.
    <T> @NotNull CaseWhenStep<V,T>
    when(Field<V> compareValue, Select<? extends Record1<T>> result)
    Compare a value to the already constructed case statement, return result if values are equal.
    <T> @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.
    <T> @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.
    <T> @NotNull CaseWhenStep<V,T>
    when(V compareValue, Select<? extends Record1<T>> result)
    Compare a value to the already constructed case statement, return result if values are equal.
    <T> @NotNull CaseWhenStep<V,T>
    when(V compareValue, T result)
    Compare a value to the already constructed case statement, return result if values are equal.
  • Method Details

    • when

      @NotNull @Support <T> @NotNull CaseWhenStep<V,T> when(V compareValue, T result)
      Compare a value to the already constructed case statement, return result if values are equal.
      Type Parameters:
      T - The generic result field type parameter
      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 <T> @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.
      Type Parameters:
      T - The generic result field type parameter
      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 <T> @NotNull CaseWhenStep<V,T> when(V compareValue, Select<? extends Record1<T>> result)
      Compare a value to the already constructed case statement, return result if values are equal.
      Type Parameters:
      T - The generic result field type parameter
      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 <T> @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.
      Type Parameters:
      T - The generic result field type parameter
      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 <T> @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.
      Type Parameters:
      T - The generic result field type parameter
      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 <T> @NotNull CaseWhenStep<V,T> when(Field<V> compareValue, Select<? extends Record1<T>> result)
      Compare a value to the already constructed case statement, return result if values are equal.
      Type Parameters:
      T - The generic result field type parameter
      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 <T> @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 <T> @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.