Class CaseWhenBuilder<DB, TB, W, O>

Type Parameters

DB
TB extends keyof DB
W
O

Hierarchy

CaseWhenBuilder

Implements

Whenable<DB, TB, W, O>
Endable<DB, TB, O | null>

Index

Constructors

constructor

Methods

else end endCase when

Constructors

constructor

new CaseWhenBuilder<DB, TB, W, O>(props): CaseWhenBuilder<DB, TB, W, O>
Type Parameters
- DB
- TB extends string | number | symbol
- W
- O
Parameters
- props: CaseBuilderProps
Returns CaseWhenBuilder<DB, TB, W, O>
- Defined in kysely/src/query-builder/case-builder.ts:94

Methods

else

else<O2>(expression): CaseEndBuilder<DB, TB, O | O2>
Adds an else clause to the case statement.

An else call must be followed by an Endable.end or Endable.endCase call.
Type Parameters
- O2
Parameters
- expression: Expression<O2>
Returns CaseEndBuilder<DB, TB, O | O2>
- Defined in kysely/src/query-builder/case-builder.ts:129
else<V>(value): CaseEndBuilder<DB, TB, O | V>
Type Parameters
- V
Parameters
- value: V
Returns CaseEndBuilder<DB, TB, O | V>
- Defined in kysely/src/query-builder/case-builder.ts:131

end

end(): ExpressionWrapper<DB, TB, null | O>
Returns ExpressionWrapper<DB, TB, null | O>
Implementation of Endable.end
- Defined in kysely/src/query-builder/case-builder.ts:144

endCase

endCase(): ExpressionWrapper<DB, TB, null | O>
Returns ExpressionWrapper<DB, TB, null | O>
Implementation of Endable.endCase
- Defined in kysely/src/query-builder/case-builder.ts:150

when

when<RE>(lhs, op, rhs): CaseThenBuilder<DB, TB, W, O>
Type Parameters
- RE extends string | Expression<any> | DynamicReferenceBuilder<any> | SelectQueryBuilder<any, any, Record<string, any>> | OperandExpressionFactory<DB, TB, any>
Parameters
- lhs: unknown extends W
  ? RE
  : KyselyTypeError<"when(lhs, op, rhs) is not supported when using case(value)">
- op: ComparisonOperatorExpression
- rhs: OperandValueExpressionOrList<DB, TB, RE>
Returns CaseThenBuilder<DB, TB, W, O>
Implementation of Whenable.when
- Defined in kysely/src/query-builder/case-builder.ts:98
when(expression): CaseThenBuilder<DB, TB, W, O>
Parameters
- expression: Expression<W>
Returns CaseThenBuilder<DB, TB, W, O>
Implementation of Whenable.when
- Defined in kysely/src/query-builder/case-builder.ts:106
when(value): 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>
Implementation of Whenable.when
- Defined in kysely/src/query-builder/case-builder.ts:108

Class CaseWhenBuilder<DB, TB, W, O>

Type Parameters

DB

TB extends keyof DB

W

O

Hierarchy

Implements

Index

Constructors

Methods

Constructors

constructor

Type Parameters

DB

TB extends string | number | symbol

W

O

Parameters

props: CaseBuilderProps

Returns CaseWhenBuilder<DB, TB, W, O>

Methods

else

Type Parameters

O2

Parameters

expression: Expression<O2>

Returns CaseEndBuilder<DB, TB, O | O2>

Type Parameters

V

Parameters

value: V

Returns CaseEndBuilder<DB, TB, O | V>

end

Returns ExpressionWrapper<DB, TB, null | O>

endCase

Returns ExpressionWrapper<DB, TB, null | O>

when

Type Parameters

RE extends string | Expression<any> | DynamicReferenceBuilder<any> | SelectQueryBuilder<any, any, Record<string, any>> | OperandExpressionFactory<DB, TB, any>

Parameters

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

op: ComparisonOperatorExpression

rhs: OperandValueExpressionOrList<DB, TB, RE>

Returns CaseThenBuilder<DB, TB, W, O>

Parameters

expression: Expression<W>

Returns 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>

Settings

Member Visibility

Theme

On This Page

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

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