StringExpressionOperators extension Null safety
Defines methods that operate on a column storing String values.
- on
Properties
-
length
→ Expression<
int> -
Calls the sqlite function
LENGTH
onthis
string, which counts the number of characters in this string. Note that, in most sqlite installations, length may not support all unicode rules.read-only
Methods
-
collate(
Collate collate) → Expression< String> - Uses the given collate sequence when comparing this column to other values.
-
contains(
String substring) → Expression< bool> -
Whether this expression contains
substring
. -
like(
String regex) → Expression< bool> - Whether this column matches the given pattern. For details on what patters are valid and how they are interpreted, check out this tutorial.
-
likeExp(
Expression< String> regex) → Expression<bool> - Whether this column matches the given expression. For details on what patters are valid and how they are interpreted, check out this tutorial.
-
lower(
) → Expression< String> -
Calls the sqlite function
LOWER
onthis
string. Please note that, in most sqlite installations, this only affects ascii chars. -
regexp(
String regex, {bool multiLine = false, bool caseSensitive = true, bool unicode = false, bool dotAll = false}) → Expression< bool> -
Matches this string against the regular expression in
regex
. -
trim(
) → Expression< String> - Removes spaces from both ends of this string.
-
trimLeft(
) → Expression< String> - Removes spaces from the beginning of this string.
-
trimRight(
) → Expression< String> - Removes spaces from the end of this string.
-
upper(
) → Expression< String> -
Calls the sqlite function
UPPER
onthis
string. Please note that, in most sqlite installations, this only affects ascii chars.
Operators
-
operator +(
Expression< String> other) → Expression<String> -
Performs a string concatenation in sql by appending
other
tothis
.