StringExpressionOperators extension Null safety

Defines methods that operate on a column storing String values.

on

Properties

length Expression<int?>
Calls the sqlite function LENGTH on this 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.
lower() Expression<String>
Calls the sqlite function LOWER on this 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 on this 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 to this.