Struct Select

pub struct Select<'a, T = Vec<Row>> { /* private fields */ }

A struct which holds the information needed to build a SELECT query.

Implementations

impl<'a, T> Select<'a, T>

pub fn where_(self, where_: Where<'a>) -> Select<'a, T>

Add a WHERE clause to your query.

If used multiple time, the conditions are joined using AND.

pub fn where_raw( self, statement: impl Into<String>, params: Vec<&'a (dyn ToSql + Sync)>, ) -> Select<'a, T>

Add a raw WHERE clause to your query.

You can reference the params by using the ? placeholder in your statement.

Note: you need to pass the exact types Postgres is expecting. Failure to do so will result in (sometimes confusing) runtime errors.

Otherwise this behaves exactly like where_.

Example

Book::select()
    .where_(Book::id.neq(&3))
    .where_raw("complex_function(book.title, ?, ?)", vec![&true, &"Foobar"])
    .await?;

pub fn limit(self, limit: u64) -> Select<'a, T>

Add a LIMIT to your query.

pub fn offset(self, offset: u64) -> Select<'a, T>

Add an OFFSET to your query.

Trait Implementations

impl<'a, T: Sync + Send + 'a> IntoFuture for Select<'a, T>

where Select<'a, T>: ToQuery<'a, T>, Query<'a, T>: Executable<Output = T>,

type IntoFuture = Pin<Box<dyn Future<Output = <Select<'a, T> as IntoFuture>::Output> + 'a>>

Which kind of future are we turning this into?

type Output = Result<T, Error>

The output that the future will produce on completion.

fn into_future(self) -> Self::IntoFuture

Creates a future from a value.

impl<'a, T> ToQuery<'a, T> for Select<'a, T>

fn to_query(&mut self) -> Query<'a, T>

A default implementation for building a query which can then be executed.