Query

pub fn select(self, columns: &str) -> Query

Columns (PostgREST syntax, including embedded relations: "id,title,author(name)").

pub fn eq(self, column: &str, value: &str) -> Query

Rows where column equals value.

pub fn neq(self, column: &str, value: &str) -> Query

Rows where column isn't value.

pub fn gt(self, column: &str, value: &str) -> Query

Rows where column is greater than value.

pub fn gte(self, column: &str, value: &str) -> Query

Rows where column is at least value.

pub fn lt(self, column: &str, value: &str) -> Query

Rows where column is less than value.

pub fn lte(self, column: &str, value: &str) -> Query

Rows where column is at most value.

pub fn like(self, column: &str, pattern: &str) -> Query

SQL LIKE; % may be written as *.

pub fn ilike(self, column: &str, pattern: &str) -> Query

Case-insensitive LIKE.

pub fn is(self, column: &str, value: &str) -> Query

IS NULL / IS TRUE / IS FALSE.

pub fn in_list(self, column: &str, values: &[&str]) -> Query

Rows where column is one of values.

pub fn search(self, column: &str, query: &str) -> Query

Full-text search (websearch_to_tsquery).

pub fn raw(self, key: &str, value: &str) -> Query

Any filter, in PostgREST syntax: .raw("or", "(a.eq.1,b.eq.2)").

pub fn order(self, column: &str, ascending: bool) -> Query

Order by column, ascending or descending.

pub fn limit(self, n: usize) -> Query

At most n rows.

pub fn offset(self, n: usize) -> Query

Skip the first n rows.

pub fn count(self) -> Query

Ask for the total row count too (read it with total_count).

pub fn get(&self) -> Request

Read the matching rows.

pub fn insert(&self, rows: &Json) -> Request

Insert a row (an object) or rows (an array); returns them.

pub fn upsert(&self, rows: &Json) -> Request

Insert, or update rows whose primary key already exists.

pub fn update(&self, changes: &Json) -> Request

Update the matching rows (add a filter first!); returns them.

pub fn delete(&self) -> Request

Delete the matching rows (add a filter first!); returns them.