PostgrestQueryBuilder class

The query builder class provides a convenient interface to creating request queries.

Allows the user to stack the filter functions before they call any of

  • select() - "get"
  • insert() - "post"
  • update() - "patch"
  • delete() - "delete" Once any of these are called the filters are passed down to the Request.
Inheritance
Implementers

Constructors

PostgrestQueryBuilder(String url, {Map<String, String>? headers, String? schema, Client? httpClient})

Properties

body ↔ dynamic
getter/setter pairinherited
hashCode → int
The hash code for this object.
no setterinherited
headers → Map<String, String>
finalinherited
httpClient → Client?
finalinherited
maybeEmpty ↔ bool
getter/setter pairinherited
method ↔ String?
getter/setter pairinherited
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
schema → String?
finalinherited
url ↔ Uri
getter/setter pairinherited

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
delete({ReturningOption returning = ReturningOption.representation}) → PostgrestFilterBuilder
Performs a DELETE on the table.
execute({bool head = false, CountOption? count}) → Future<PostgrestResponse>
Sends the request and returns a Future. catch any error and returns with status 500
inherited
insert(dynamic values, {ReturningOption returning = ReturningOption.representation, bool upsert = false, String? onConflict}) → PostgrestBuilder
Performs an INSERT into the table.
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
overrideSearchParams(String key, String value) → void
Overrides Uri queryParameters with new key:value
inherited
select([String columns = '*']) → PostgrestFilterBuilder
Performs horizontal filtering with SELECT.
toString() → String
A string representation of this object.
inherited
update(Map values, {ReturningOption returning = ReturningOption.representation}) → PostgrestFilterBuilder
Performs an UPDATE on the table.
upsert(dynamic values, {ReturningOption returning = ReturningOption.representation, String? onConflict, bool ignoreDuplicates = false}) → PostgrestBuilder
Performs an UPSERT into the table.
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