Struct JoinChain 

pub struct JoinChain { /* private fields */ }

A join under construction.

ON and USING are alternatives and NATURAL excludes both; nothing enforces that here, because the caller picks one method and the grammar is what says so.

Implementations

impl JoinChain

pub fn as_(self, alias: impl Into<Cow<'static, str>>) -> JoinChain

AS \alias`` on the joined table.

pub fn columns( self, columns: impl IntoIterator<Item = impl Into<Cow<'static, str>>>, ) -> JoinChain

Column aliases on the joined derived table.

pub fn lateral(self) -> JoinChain

LATERAL on the joined item — what lets a joined derived table see the columns of the item it is joined to.

Only grammatical in front of a derived table; on a bare table or CTE name this records a build() error instead, because JOIN LATERAL `posts` is a syntax error with nothing to mean.

pub fn partition( self, partitions: impl IntoIterator<Item = impl Into<Cow<'static, str>>>, ) -> JoinChain

PARTITION (…) on the joined table.

pub fn use_index( self, indexes: impl IntoIterator<Item = impl Into<Cow<'static, str>>>, ) -> JoinChain

USE INDEX (…) on the joined table.

pub fn ignore_index( self, indexes: impl IntoIterator<Item = impl Into<Cow<'static, str>>>, ) -> JoinChain

IGNORE INDEX (…) on the joined table.

pub fn force_index( self, indexes: impl IntoIterator<Item = impl Into<Cow<'static, str>>>, ) -> JoinChain

FORCE INDEX (…) on the joined table.

pub fn for_join(self) -> JoinChain

FOR JOIN on the hint just added.

pub fn for_order_by(self) -> JoinChain

FOR ORDER BY on the hint just added.

pub fn for_group_by(self) -> JoinChain

FOR GROUP BY on the hint just added.

pub fn natural(self) -> JoinChain

NATURAL <kind> JOIN — derive the join columns from the two items’ names.

pub fn on(self, condition: impl IntoExpr) -> JoinChain

ON condition. Several conditions are AND-joined.

pub fn on_eq(self, a: impl IntoExpr, b: impl IntoExpr) -> JoinChain

ON (a = b), the overwhelmingly common shape.

pub fn using( self, columns: impl IntoIterator<Item = impl Into<Cow<'static, str>>>, ) -> JoinChain

USING (\a`, `b`)` — join on equally named columns, merging them.

Trait Implementations

impl Clone for JoinChain

fn clone(&self) -> JoinChain

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for JoinChain

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

Formats the value using the given formatter.

impl From<JoinChain> for Join

fn from(chain: JoinChain) -> Join

Converts to this type from the input type.

impl<Q: HasJoins> Mod<Q> for JoinChain

fn apply(self, q: &mut Q)

Apply this modification to q.