CaseWhenExpression<R extends Object> class
A CASE WHEN
expression without a base expression in sqlite.
This expression evaluates to the first value in BaseCaseWhenExpression.orderedCases
for which CaseWhen.when evaluates to true
.
 Inheritance

 Object
 Expression<
R>  CaseWhenExpression
 Available Extensions
Constructors

CaseWhenExpression({required List<
CaseWhen< cases, Expression<bool, R> >R> ? orElse}) 
Creates a
CASE WHEN
expression from the independent components.
Properties

base
→ Expression<
bool> ? 
The optional base expression.
finalinherited

driftSqlType
→ DriftSqlType<
R> 
The supported DriftSqlType backing this expression.
readonlyinherited
 hashCode → int

The hash code for this object.
readonlyinherited
 isLiteral → bool

Whether this expression is a literal. Some usesites need to put
parentheses around nonliterals.
readonlyinherited

orderedCases
→ Iterable<
CaseWhen< bool, R> > 
The whenthen entries for this expression.
finalinherited

orElse
→ Expression<
R> ? 
The expression to use if no entry in orderedCases matched.
finalinherited
 precedence → Precedence

The precedence of this expression. This can be used to automatically put
parentheses around expressions as needed.
readonlyinherited
 runtimeType → Type

A representation of the runtime type of the object.
readonlyinherited
Methods

caseMatch<
T extends Object> ({required Map< Expression< when, Expression<R> , Expression<T> >T> ? orElse}) → Expression<T> 
A
CASE WHEN
construct using the current expression as a base.inherited 
cast<
D2 extends Object> () → Expression< D2> 
Generates a
CAST(expression AS TYPE)
expression.inherited 
dartCast<
D2 extends Object> () → Expression< D2> 
Casts this expression to an expression of
D
.inherited 
equals(
R compare) → Expression< bool> 
Whether this column is equal to the given value, which must have a fitting
type. The
compare
value will be written as a variable using prepared statements, so there is no risk of an SQLinjection.inherited 
equalsExp(
Expression< R> compare) → Expression<bool> 
Whether this expression is equal to the given expression.
inherited

equalsNullable(
R? compare) → Expression< bool> 
Compares the value of this column to
compare
ornull
.inherited 
iif<
T extends Object> (Expression< bool> predicate, Expression<T> ifFalse) → Expression<T> 
Evaluates to
this
ifpredicate
is true, otherwise evaluates toifFalse
.inherited 
isExp(
Expression< R> other) → Expression<bool> 
Generates an
IS
expression in SQL, comparing this expression with theother
expression.inherited 
isIn(
Iterable< R> values) → Expression<bool> 
An expression that is true if
this
resolves to any of the values invalues
.inherited 
isInExp(
List< Expression< expressions) → Expression<R> >bool> 
An expression that evaluates to
true
if this expression resolves to a value that one of theexpressions
resolve to as well.inherited 
isInQuery(
BaseSelectStatement select) → Expression< bool> 
An expression checking whether
this
is included in any row of the providedselect
statement.inherited 
isNotExp(
Expression< R> other) → Expression<bool> 
Generates an
IS NOT
expression in SQL, comparing this expression with theother
expression.inherited 
isNotIn(
Iterable< R> values) → Expression<bool> 
An expression that is true if
this
does not resolve to any of the values invalues
.inherited 
isNotInExp(
List< Expression< expressions) → Expression<R> >bool> 
An expression that evaluates to
true
if this expression does not resolve to any value that theexpressions
resolve to.inherited 
isNotInQuery(
BaseSelectStatement select) → Expression< bool> 
An expression checking whether
this
is not included in any row of the providedselect
statement.inherited 
isNotNull(
) → Expression< bool> 
Expression that is true if the inner expression resolves to a nonnull
value.
inherited

isNotValue(
R value) → Expression< bool> 
Generates an
IS NOT
expression in SQL, comparing this expression with the Dartvalue
.inherited 
isNull(
) → Expression< bool> 
Expression that is true if the inner expression resolves to a null value.
inherited

isValue(
R value) → Expression< bool> 
Generates an
IS
expression in SQL, comparing this expression with the Dartvalue
.inherited 
noSuchMethod(
Invocation invocation) → dynamic 
Invoked when a nonexistent method or property is accessed.
inherited

nullIf(
Expression< R> matcher) → Expression<R> 
Returns
null
ifmatcher
is equal to this expression,this
otherwise.inherited 
toString(
) → String 
A string representation of this object.
inherited

writeAroundPrecedence(
GenerationContext context, Precedence precedence) → void 
Writes this expression into the GenerationContext, assuming that there's
an outer expression with
precedence
. If the Expression.precedence ofthis
expression is lower, it will be wrap}ped ininherited 
writeInner(
GenerationContext ctx, Expression< Object> inner) → void 
If this Expression wraps an
inner
expression, this utility method can be used inside writeInto to write that inner expression while wrapping it in parentheses if necessary.inherited 
writeInto(
GenerationContext context) → void 
Writes this component into the
context
by writing to its GenerationContext.buffer or by introducing bound variables. When writing into the buffer, no whitespace around the this component should be introduced. When a component consists of multiple composed component, it's responsible for introducing whitespace between its child components.inherited
Operators

operator ==(
Object other) → bool 
The equality operator.
inherited