PostgrestFilterBuilder<T> class
- Inheritance
-
- Available Extensions
Properties
-
hashCode
→ int
-
The hash code for this object.
no setterinherited
-
runtimeType
→ Type
-
A representation of the runtime type of the object.
no setterinherited
Methods
-
appendSearchParams(String key, String value)
→ void
-
Update Uri queryParameters with new key:value
Use lists to allow multiple values for the same key
inherited
-
asStream()
→ Stream<T>
-
Creates a Stream containing the result of this future.
inherited
-
catchError(Function onError, {bool test(Object error)?})
→ Future<T>
-
Handles errors emitted by this Future.
inherited
-
containedBy(String column, dynamic value)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose json, array, or range value on the stated
column
is contained by the specified value
.
-
contains(String column, dynamic value)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose json, array, or range value on the stated
column
contains the values specified in value
.
-
csv()
→ PostgrestTransformBuilder<T>
-
Retrieves the response as CSV.
This will skip object parsing.
inherited
-
eq(String column, dynamic value)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose value on the stated
column
exactly matches the specified value
.
-
execute({bool head = false, CountOption? count})
→ Future<PostgrestResponse>
-
Sends the request and returns a PostgrestResponse
inherited
-
filter(String column, String operator, dynamic value)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose
column
satisfies the filter.
-
gt(String column, dynamic value)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose value on the stated
column
is greater than the specified value
.
-
gte(String column, dynamic value)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose value on the stated
column
is greater than or equal to the specified value
.
-
ilike(String column, String pattern)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose value in the stated
column
matches the supplied pattern
(case insensitive).
-
ilikeAllOf(String column, List<String> patterns)
→ PostgrestFilterBuilder
-
Match only rows where
column
matches all of patterns
case-insensitively.
-
ilikeAnyOf(String column, List<String> patterns)
→ PostgrestFilterBuilder
-
Match only rows where
column
matches any of patterns
case-insensitively.
-
in_(String column, List values)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose value on the stated
column
is found on the specified values
.
-
is_(String column, dynamic value)
→ PostgrestFilterBuilder<T>
-
A check for exact equality (null, true, false)
-
like(String column, String pattern)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose value in the stated
column
matches the supplied pattern
(case sensitive).
-
likeAllOf(String column, List<String> patterns)
→ PostgrestFilterBuilder
-
Match only rows where
column
matches all of patterns
case-sensitively.
-
likeAnyOf(String column, List<String> patterns)
→ PostgrestFilterBuilder
-
Match only rows where
column
matches any of patterns
case-sensitively.
-
limit(int count, {String? foreignTable})
→ PostgrestTransformBuilder<T>
-
Limits the result with the specified
count
.
inherited
-
lt(String column, dynamic value)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose value on the stated
column
is less than the specified value
.
-
lte(String column, dynamic value)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose value on the stated
column
is less than or equal to the specified value
.
-
match(Map query)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose columns match the specified
query
object.
-
maybeSingle()
→ PostgrestTransformBuilder<T>
-
Retrieves at most one row from the result.
inherited
-
neq(String column, dynamic value)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose value on the stated
column
doesn't match the specified value
.
-
noSuchMethod(Invocation invocation)
→ dynamic
-
Invoked when a nonexistent method or property is accessed.
inherited
-
not(String column, String operator, dynamic value)
→ PostgrestFilterBuilder<T>
-
Finds all rows which doesn't satisfy the filter.
-
or(String filters, {String? foreignTable})
→ PostgrestFilterBuilder<T>
-
Finds all rows satisfying at least one of the filters.
-
order(String column, {bool ascending = false, bool nullsFirst = false, String? foreignTable})
→ PostgrestTransformBuilder<T>
-
Orders the result with the specified
column
.
inherited
-
overlaps(String column, dynamic value)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose array or range value on the stated
column
overlaps (has a value in common) with the specified value
.
-
overrideSearchParams(String key, String value)
→ void
-
Overrides Uri queryParameters with new key:value
inherited
-
range(int from, int to, {String? foreignTable})
→ PostgrestTransformBuilder<T>
-
Limits the result to rows within the specified range, inclusive.
inherited
-
rangeAdjacent(String column, String range)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose range value on the stated
column
is adjacent to the specified range
.
-
rangeGt(String column, String range)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose range value on the stated
column
is strictly to the right of the specified range
.
-
rangeGte(String column, String range)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose range value on the stated
column
does not extend to the left of the specified range
.
-
rangeLt(String column, String range)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose range value on the stated
column
is strictly to the left of the specified range
.
-
rangeLte(String column, String range)
→ PostgrestFilterBuilder<T>
-
Finds all rows whose range value on the stated
column
does not extend to the right of the specified range
.
-
select<R>([String columns = '*'])
→ PostgrestTransformBuilder<R>
-
Performs horizontal filtering with SELECT.
inherited
-
single()
→ PostgrestTransformBuilder<T>
-
Retrieves only one row from the result.
inherited
-
textSearch(String column, String query, {String? config, TextSearchType? type})
→ PostgrestFilterBuilder<T>
-
Finds all rows whose text or tsvector value on the stated
column
matches the tsquery in query
.
-
then<R>(FutureOr<R> onValue(T value), {Function? onError})
→ Future<R>
-
Register callbacks to be called when this future completes.
inherited
-
timeout(Duration timeLimit, {FutureOr<T> onTimeout()?})
→ Future<T>
-
Stop waiting for this future after
timeLimit
has passed.
inherited
-
toString()
→ String
-
A string representation of this object.
inherited
-
whenComplete(FutureOr<void> action())
→ Future<T>
-
Registers a function to be called when this future completes.
inherited
-
withConverter<R>(PostgrestConverter<R, T> converter)
→ PostgrestBuilder<R, T>
-
Converts any response that comes from the server into a type-safe response.
inherited