BetweenExpression class final

A BETWEEN expression in SQL.

Created by ComparableExpr.isBetween and ComparableExpr.isBetweenValues.

Inheritance
Available extensions

Properties

hashCode → int
The hash code for this object.
no setteroverride
higher → Expression<Object>
The upper bound to compare target against.
final
lower → Expression<Object>
The lower bound to compare target against.
final
not → bool
Whether to negate this between expression
final
precedence → Precedence
The precedence of this expression. This can be used to automatically put parentheses around expressions as needed.
final
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
sqlType → SqlType<bool>
Resolves the SqlType implementation describing the type of this expression.
no setteroverride
target → Expression<Object>
The expression to be compared against lower and higher.
final

Methods

caseMatch<R extends Object>({required Map<Expression<bool>, Expression<R>> when, Expression<R>? orElse}) → Expression<R>
A CASE WHEN construct using the current expression as a base.
inherited
cast<T2 extends Object>([SqlType<T2>? type]) → Expression<T2>
Generates a CAST(expression AS TYPE) expression.
inherited
compileWith(StatementCompiler compiler) → void
Compiles this component with the given StatementCompiler by invoking the relevant add method on it.
override
dartCast<T2 extends Object>({SqlType<T2>? customType}) → Expression<T2>
Casts this expression to an expression of D.
inherited
equals(bool 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 SQL-injection.
inherited
equalsExp(Expression<bool> compare) → Expression<bool>
Whether this expression is equal to the given expression.
inherited
equalsNullable(bool? compare) → Expression<bool>
Compares the value of this column to compare or null.
inherited
iif(Expression<bool> predicate, Expression<bool> ifFalse) → Expression<bool>
Evaluates to this if predicate is true, otherwise evaluates to ifFalse.
inherited
isExp(Expression<bool> other) → Expression<bool>
Generates an IS expression in SQL, comparing this expression with the other expression.
inherited
isIn(Iterable<bool> values) → Expression<bool>
An expression that is true if this resolves to any of the values in values.
inherited
isInExp(List<Expression<bool>> expressions) → Expression<bool>
An expression that evaluates to true if this expression resolves to a value that one of the expressions resolve to as well.
inherited
isInQuery(BaseSelectStatement<BaseSelectStatement, dynamic> select) → Expression<bool>
An expression checking whether this is included in any row of the provided select statement.
inherited
isNotExp(Expression<bool> other) → Expression<bool>
Generates an IS NOT expression in SQL, comparing this expression with the other expression.
inherited
isNotIn(Iterable<bool> values) → Expression<bool>
An expression that is true if this does not resolve to any of the values in values.
inherited
isNotInExp(List<Expression<bool>> expressions) → Expression<bool>
An expression that evaluates to true if this expression does not resolve to any value that the expressions resolve to.
inherited
isNotInQuery(BaseSelectStatement<BaseSelectStatement, dynamic> select) → Expression<bool>
An expression checking whether this is not included in any row of the provided select statement.
inherited
isNotNull() → Expression<bool>
Expression that is true if the inner expression resolves to a non-null value.
inherited
isNotValue(bool value) → Expression<bool>
Generates an IS NOT expression in SQL, comparing this expression with the Dart value.
inherited
isNull() → Expression<bool>
Expression that is true if the inner expression resolves to a null value.
inherited
isValue(bool value) → Expression<bool>
Generates an IS expression in SQL, comparing this expression with the Dart value.
inherited
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
not() → Expression<bool>

Available on Expression<bool>, provided by the BooleanExpressionOperators extension

Negates this boolean expression. The returned expression is true if this is false, and vice versa.
nullIf(Expression<bool> matcher) → Expression<bool>
Returns null if matcher is equal to this expression, this otherwise.
inherited
toString() → String
A string representation of this object.
inherited
variable(bool? value) → Variable<bool>
Creates a variable that is guaranteed to have the same SqlType as this.
inherited

Operators

operator &(Expression<bool> other) → Expression<bool>

Available on Expression<bool>, provided by the BooleanExpressionOperators extension

Returns an expression that is true iff both this and other are true.
operator ==(Object other) → bool
The equality operator.
override
operator |(Expression<bool> other) → Expression<bool>

Available on Expression<bool>, provided by the BooleanExpressionOperators extension

Returns an expression that is true if this or other are true.