MssqlNotBetween class

NOT BETWEEN.

Inheritance
Available extensions
Annotations
  • @immutable

Constructors

MssqlNotBetween(MssqlExpression operand, Object? lower, Object? upper)
const

Properties

hashCode int
The hash code for this object.
no setterinherited
lower Object?
final
operand MssqlExpression
final
runtimeType Type
A representation of the runtime type of the object.
no setterinherited
upper Object?
final

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

BETWEEN two 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