MssqlStringColumn class

A character column.

The one family that carries the text predicates. They are here rather than on every expression so that a numeric or temporal column simply does not have them.

Inheritance

• Object
• MssqlExpression
• MssqlColumnBase
• MssqlTypedColumn<String>
• MssqlStringColumn

Mixed-in types

• MssqlTextExpression

Available extensions

• MssqlExpressionOperators
• MssqlSubqueryExpressionOperators
• MssqlTextOperators

Constructors

MssqlStringColumn(String quoted, String name, {MssqlColumnType? columnType})

A column written out in full, for a hand-written schema.

MssqlStringColumn.of({required MssqlSourceRef source, required String name, required String quotedName, required MssqlColumnType columnType})

Properties

codec → MssqlTypeCodec<Object?>?

The codec for this column, built once.

late, final, inherited

columnType → MssqlColumnType?

What the column is in SQL, or null for a hand-written column that never said.

final, inherited

hashCode → int

The hash code for this object.

no setter, inherited

isNullable → bool

Whether SQL says this column can be null.

no setter, inherited

name → String

The column's own name, without any qualifier.

final, inherited

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

source → MssqlSourceRef?

The source this column belongs to, or null when it was written in full.

final, inherited

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.

at(MssqlSourceRef source) → MssqlTypedColumn<String>

This column, seen through another source.

inherited

between(String lower, String upper) → MssqlCondition

inherited

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.

inherited

contains(String term) → MssqlCondition

Available on MssqlTextExpression, provided by the MssqlTextOperators extension

LIKE '%term%', with term escaped.

desc({MssqlNulls? nulls}) → MssqlOrder

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

Orders by this expression, descending.

endsWith(String term) → MssqlCondition

Available on MssqlTextExpression, provided by the MssqlTextOperators extension

LIKE '%term', with term escaped.

eq(String value) → MssqlCondition

Typed comparisons. The untyped versions on MssqlExpression stay available for untyped columns; these shadow them with a narrower operand.

inherited

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(String value) → MssqlCondition

inherited

gt(Object? value) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

gte(String value) → MssqlCondition

inherited

gte(Object? value) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

inList(Iterable<String> values, {MssqlEmptyIn? onEmpty}) → MssqlCondition

inherited

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

like(String pattern) → MssqlCondition

Available on MssqlTextExpression, provided by the MssqlTextOperators extension

LIKE, with %, _ and [ in pattern treated as literal text.

likeRaw(String pattern) → MssqlCondition

Available on MssqlTextExpression, provided by the MssqlTextOperators extension

LIKE with pattern passed through unescaped, wildcards and all.

lt(Object? value) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

lt(String value) → MssqlCondition

inherited

lte(String value) → MssqlCondition

inherited

lte(Object? value) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

ne(Object? value) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

ne(String value) → MssqlCondition

inherited

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

notContains(String term) → MssqlCondition

Available on MssqlTextExpression, provided by the MssqlTextOperators extension

notInList(Iterable<Object?> values) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

notInList(Iterable<String> values, {MssqlEmptyIn? onEmpty}) → MssqlCondition

inherited

notInQuery(MssqlSelectQuery query) → MssqlCondition

Available on MssqlExpression, provided by the MssqlSubqueryExpressionOperators extension

notLike(String pattern) → MssqlCondition

Available on MssqlTextExpression, provided by the MssqlTextOperators extension

notLikeRaw(String pattern) → MssqlCondition

Available on MssqlTextExpression, provided by the MssqlTextOperators extension

operand(String value, String method) → MssqlExpression

Binds value with this column's SQL type.

inherited

startsWith(String term) → MssqlCondition

Available on MssqlTextExpression, provided by the MssqlTextOperators extension

LIKE 'term%', with term escaped.

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 ==(Object other) → bool

The equality operator.

inherited