StringExpressionOperators extension - drift library

Properties

length → Expression<int>: Available on Expression<String>, provided by the StringExpressionOperators extension
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.
no setter

Methods

collate(Collate collate) → Expression<String>: Available on Expression<String>, provided by the StringExpressionOperators extension
Uses the given collate sequence when comparing this column to other values.
contains(String substring) → Expression<bool>: Available on Expression<String>, provided by the StringExpressionOperators extension
Whether this expression contains substring.
like(String regex) → Expression<bool>: Available on Expression<String>, provided by the StringExpressionOperators extension
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>: Available on Expression<String>, provided by the StringExpressionOperators extension
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>: Available on Expression<String>, provided by the StringExpressionOperators extension
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>: Available on Expression<String>, provided by the StringExpressionOperators extension
Matches this string against the regular expression in regex.
substr(int start, [int? length]) → Expression<String>: Available on Expression<String>, provided by the StringExpressionOperators extension
Calls the substr function on this string.
substrExpr(Expression<int> start, [Expression<int>? length]) → Expression<String>: Available on Expression<String>, provided by the StringExpressionOperators extension
Calls the substr function with arbitrary expressions as arguments.
trim() → Expression<String>: Available on Expression<String>, provided by the StringExpressionOperators extension
Removes spaces from both ends of this string.
trimLeft() → Expression<String>: Available on Expression<String>, provided by the StringExpressionOperators extension
Removes spaces from the beginning of this string.
trimRight() → Expression<String>: Available on Expression<String>, provided by the StringExpressionOperators extension
Removes spaces from the end of this string.
upper() → Expression<String>: Available on Expression<String>, provided by the StringExpressionOperators extension
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>: Available on Expression<String>, provided by the StringExpressionOperators extension
Performs a string concatenation in sql by appending other to this.