Interface CaseWhenInterface<DB, TB, W, O>

when

• when<
      RE extends
          | string
          | Expression<any>
          | DynamicReferenceBuilder<any>
          | SelectQueryBuilderExpression<Record<string, any>>
          | OperandExpressionFactory<DB, TB, any>,
      VE extends any,
  >(
      lhs: unknown extends W
          ? RE
          : KyselyTypeError<
              "when(lhs, op, rhs) is not supported when using case(value)",
          >,
      op: ComparisonOperatorExpression,
      rhs: VE,
  ): CaseThenBuilder<DB, TB, W, O>

  Adds a when clause to the case statement.

  A when call must be followed by a CaseThenBuilder.then call.

  Type Parameters

  • RE extends
        | string
        | Expression<any>
        | DynamicReferenceBuilder<any>
        | SelectQueryBuilderExpression<Record<string, any>>
        | OperandExpressionFactory<DB, TB, any>
  • VE extends any

  Parameters

  • lhs: unknown extends W
        ? RE
        : KyselyTypeError<
            "when(lhs, op, rhs) is not supported when using case(value)",
        >
  • op: ComparisonOperatorExpression
  • rhs: VE

  Returns CaseThenBuilder<DB, TB, W, O>

• when(expression: Expression<W>): CaseThenBuilder<DB, TB, W, O>

  Parameters

  • expression: Expression<W>

  Returns CaseThenBuilder<DB, TB, W, O>

• when(
      value: unknown extends W
          ? KyselyTypeError<
              "when(value) is only supported when using case(value)",
          >
          : W,
  ): CaseThenBuilder<DB, TB, W, O>

  Parameters

  • value: unknown extends W
        ? KyselyTypeError<
            "when(value) is only supported when using case(value)",
        >
        : W

  Returns CaseThenBuilder<DB, TB, W, O>