PostgrestFilterBuilder class
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
-
containedBy(String column, dynamic value)
→ PostgrestFilterBuilder
-
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
-
Finds all rows whose json, array, or range value on the stated
column
contains the values specified in value
.
-
csv()
→ PostgrestTransformBuilder
-
Retrieves the response as CSV.
This will skip object parsing.
inherited
-
eq(String column, dynamic value)
→ PostgrestFilterBuilder
-
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 Future.
catch any error and returns with status 500
inherited
-
filter(String column, String operator, dynamic value)
→ PostgrestFilterBuilder
-
Finds all rows whose
column
satisfies the filter.
-
fts(String column, String query, {String? config})
→ PostgrestFilterBuilder
-
Finds all rows whose tsvector value on the stated
column
matches to_tsquery(query
).
-
gt(String column, dynamic value)
→ PostgrestFilterBuilder
-
Finds all rows whose value on the stated
column
is greater than the specified value
.
-
gte(String column, dynamic value)
→ PostgrestFilterBuilder
-
Finds all rows whose value on the stated
column
is greater than or equal to the specified value
.
-
ilike(String column, String pattern)
→ PostgrestFilterBuilder
-
Finds all rows whose value in the stated
column
matches the supplied pattern
(case insensitive).
-
in_(String column, List values)
→ PostgrestFilterBuilder
-
Finds all rows whose value on the stated
column
is found on the specified values
.
-
is_(String column, dynamic value)
→ PostgrestFilterBuilder
-
A check for exact equality (null, true, false)
-
like(String column, String pattern)
→ PostgrestFilterBuilder
-
Finds all rows whose value in the stated
column
matches the supplied pattern
(case sensitive).
-
limit(int count, {String? foreignTable})
→ PostgrestTransformBuilder
-
Limits the result with the specified
count
.
inherited
-
lt(String column, dynamic value)
→ PostgrestFilterBuilder
-
Finds all rows whose value on the stated
column
is less than the specified value
.
-
lte(String column, dynamic value)
→ PostgrestFilterBuilder
-
Finds all rows whose value on the stated
column
is less than or equal to the specified value
.
-
match(Map query)
→ PostgrestFilterBuilder
-
Finds all rows whose columns match the specified
query
object.
-
maybeSingle()
→ PostgrestTransformBuilder
-
Retrieves at most one row from the result.
inherited
-
neq(String column, dynamic value)
→ PostgrestFilterBuilder
-
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
-
Finds all rows which doesn't satisfy the filter.
-
or(String filters, {String? foreignTable})
→ PostgrestFilterBuilder
-
Finds all rows satisfying at least one of the filters.
-
order(String column, {bool ascending = false, bool nullsFirst = false, String? foreignTable})
→ PostgrestTransformBuilder
-
Orders the result with the specified
column
.
inherited
-
overlaps(String column, dynamic value)
→ PostgrestFilterBuilder
-
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
-
phfts(String column, String query, {String? config})
→ PostgrestFilterBuilder
-
Finds all rows whose tsvector value on the stated
column
matches phraseto_tsquery(query
).
-
plfts(String column, String query, {String? config})
→ PostgrestFilterBuilder
-
Finds all rows whose tsvector value on the stated
column
matches plainto_tsquery(query
).
-
range(int from, int to, {String? foreignTable})
→ PostgrestTransformBuilder
-
Limits the result to rows within the specified range, inclusive.
inherited
-
rangeAdjacent(String column, String range)
→ PostgrestFilterBuilder
-
Finds all rows whose range value on the stated
column
is adjacent to the specified range
.
-
rangeGt(String column, String range)
→ PostgrestFilterBuilder
-
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
-
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
-
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
-
Finds all rows whose range value on the stated
column
does not extend to the right of the specified range
.
-
select([String columns = '*'])
→ PostgrestTransformBuilder
-
Performs horizontal filtering with SELECT.
inherited
-
single()
→ PostgrestTransformBuilder
-
Retrieves only one row from the result.
inherited
-
textSearch(String column, String query, {String? config, TextSearchType? type})
→ PostgrestFilterBuilder
-
Finds all rows whose text or tsvector value on the stated
column
matches the tsquery in query
.
-
toString()
→ String
-
A string representation of this object.
inherited
-
wfts(String column, String query, {String? config})
→ PostgrestFilterBuilder
-
Finds all rows whose tsvector value on the stated
column
matches websearch_to_tsquery(query
).
-
withConverter<S>(PostgrestConverter<S> converter)
→ PostgrestBuilder<S>
-
Converts any response that comes from the server into a type-safe response.
inherited