MssqlComparison class
A binary comparison between an expression and an operand.
- Inheritance
-
- Object
- MssqlExpression
- MssqlCondition
- MssqlComparison
- Available extensions
- Annotations
-
- @immutable
Constructors
- MssqlComparison(MssqlExpression left, String operator, MssqlExpression right)
Properties
- hashCode → int
-
The hash code for this object.
no setterinherited
- left → MssqlExpression
-
final
- operator → String
-
final
- right → MssqlExpression
-
final
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
Methods
-
as(
String alias) → MssqlAliased -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Gives this expression a result alias. -
asc(
{MssqlNulls? nulls}) → MssqlOrder -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Orders by this expression, ascending. -
between(
Object? lower, Object? upper) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
betweenColumns(
String lower, String upper) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
BETWEENtwo other columns rather than two values. -
compile(
MssqlParameterAllocator parameters, MssqlDialect dialect) → String -
Writes this expression's SQL, binding any values through
parameters.override -
desc(
{MssqlNulls? nulls}) → MssqlOrder -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Orders by this expression, descending. -
eq(
Object? value) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
eqCol(
String identifier) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Compares this expression to another column rather than to a value. -
eqExpr(
MssqlExpression other) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Compares this expression to another expression. -
gt(
Object? value) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
gte(
Object? value) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
inList(
Iterable< Object?> values) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
inQuery(
MssqlSelectQuery query) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlSubqueryExpressionOperators extension
-
isNotNull(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
isNull(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
lt(
Object? value) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
lte(
Object? value) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
ne(
Object? value) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
notBetween(
Object? lower, Object? upper) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
notBetweenColumns(
String lower, String upper) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
notInList(
Iterable< Object?> values) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
notInQuery(
MssqlSelectQuery query) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlSubqueryExpressionOperators extension
-
toString(
) → String -
A string representation of this object.
inherited
-
whereAfterToday(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
whereBeforeToday(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
whereDate(
Object? value, [MssqlOperator operator = MssqlOperator.eq]) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Compares the date alone, so the whole day matches rather than midnight. -
whereDay(
int value, [MssqlOperator operator = MssqlOperator.eq]) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
whereFuture(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
whereMonth(
int value, [MssqlOperator operator = MssqlOperator.eq]) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
whereNowOrFuture(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
whereNowOrPast(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
wherePast(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Strictly earlier than now, again by the server's clock. -
whereTime(
Object? value, [MssqlOperator operator = MssqlOperator.eq]) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Compares the time of day, with the date discarded. -
whereToday(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
The date part equals today, as the server reckons it. -
whereTodayOrAfter(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
whereTodayOrBefore(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
whereYear(
int value, [MssqlOperator operator = MssqlOperator.eq]) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Operators
-
operator &(
MssqlCondition other) → MssqlCondition -
(this AND other).inherited -
operator ==(
Object other) → bool -
The equality operator.
inherited
-
operator |(
MssqlCondition other) → MssqlCondition -
(this OR other).inherited