Struct SelectTwo 

pub struct SelectTwo<E: EntityTrait, R: EntityTrait> { /* private fields */ }

A SELECT of an entity together with an optional related row.

Implementations

impl<E: EntityTrait, R: EntityTrait> SelectTwo<E, R>

pub fn filter(self, cond: impl IntoCondition) -> Self

Adds a WHERE condition, ANDed with the previous ones.

pub fn order_by(self, column: E::Column, order: Order) -> Self

Adds ORDER BY a column of E in the given direction.

pub fn order_by_related(self, column: R::Column, order: Order) -> Self

Adds ORDER BY a column of R in the given direction.

The column is qualified by R’s table name, which is right unless R was joined under an alias; then use order_by_expr with Expr::col((alias, column)).

pub fn order_by_expr(self, expr: Expr, order: Order) -> Self

Adds ORDER BY expr in the given direction.

pub fn limit(self, limit: u64) -> Self

Sets LIMIT.

pub fn offset(self, offset: u64) -> Self

Sets OFFSET.

pub fn query_mut(&mut self) -> &mut Select

Mutable access to the underlying SQL builder, for clauses this API does not expose.

pub fn build(&self) -> Statement

Renders the statement.

pub async fn one<C: ConnectionTrait>( self, db: &C, ) -> Result<Option<(E::Model, Option<R::Model>)>>

Fetches the first pair, adding LIMIT 1.

Errors

Returns DbErr::Driver when the query fails or the row cannot be decoded.

pub async fn all<C: ConnectionTrait>( self, db: &C, ) -> Result<Vec<(E::Model, Option<R::Model>)>>

Fetches every pair.

Errors

Returns DbErr::Driver when the query fails or a row cannot be decoded.

Trait Implementations

impl<E: Clone + EntityTrait, R: Clone + EntityTrait> Clone for SelectTwo<E, R>

fn clone(&self) -> Self

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl<E: Debug + EntityTrait, R: Debug + EntityTrait> Debug for SelectTwo<E, R>

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.