PostgrestFilterBuilder class

Inheritance

• Object
• PostgrestBuilder
• PostgrestTransformBuilder
• PostgrestFilterBuilder

Constructors

PostgrestFilterBuilder(PostgrestBuilder builder)

Properties

adj → PostgrestFilterBuilder Function(String, String)

no setter

body ↔ dynamic

getter/setter pair, inherited

cd → PostgrestFilterBuilder Function(String, dynamic)

no setter

cs → PostgrestFilterBuilder Function(String, dynamic)

no setter

hashCode → int

The hash code for this object.

no setter, inherited

headers → Map<String, String>

final, inherited

httpClient → Client?

final, inherited

maybeEmpty ↔ bool

getter/setter pair, inherited

method ↔ String?

getter/setter pair, inherited

nxl → PostgrestFilterBuilder Function(String, String)

no setter

nxr → PostgrestFilterBuilder Function(String, String)

no setter

ov → PostgrestFilterBuilder Function(String, String)

no setter

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

schema → String?

final, inherited

sl → PostgrestFilterBuilder Function(String, String)

no setter

sr → PostgrestFilterBuilder Function(String, String)

no setter

url ↔ Uri

getter/setter pair, inherited

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

Operators

operator ==(Object other) → bool

The equality operator.

inherited