Struct JoinOn 

pub struct JoinOn { /* private fields */ }

SQL joins on two tables.

Examples

use crate::model::{Project, ProjectColumn, Task, TaskColumn};
use zino_core::Map;
use zino_orm::{JoinOn, QueryBuilder, Schema};

let query = QueryBuilder::new()
    .fields([TaskColumn::Id, TaskColumn::Name, TaskColumn::ProjectId])
    .and_eq(TaskColumn::Status, "Completed")
    .and(
        QueryBuilder::new()
            .alias(ProjectColumn::Name, "project_name")
            .fields([ProjectColumn::StartDate, ProjectColumn::EndDate])
            .and_overlaps(
                (ProjectColumn::StartDate, ProjectColumn::EndDate),
                ("2023-10-01", "2023-10-07"),
            ),
    )
    .order_desc(TaskColumn::UpdatedAt)
    .build();
let join_on = JoinOn::new::<Project>()
    .eq(TaskColumn::ProjectId, ProjectColumn::Id);
let entries = Task::lookup::<Project, Map>(&query, &[join_on]).await?;

Implementations

impl JoinOn

pub fn new<M: Schema>() -> Self

Creates a new instance with the default join type.

pub fn inner_join<M: Schema>() -> Self

Constructs an instance with the INNER JOIN type.

pub fn left_join<M: Schema>() -> Self

Constructs an instance with the LEFT (OUTER) JOIN type.

pub fn right_join<M: Schema>() -> Self

Constructs an instance with the RIGHT (OUTER) JOIN type.

pub fn full_join<M: Schema>() -> Self

Constructs an instance with the FULL (OUTER) JOIN type.

pub fn cross_join<M: Schema>() -> Self

Constructs an instance with the CROSS JOIN type.

pub fn eq<E1, E2, C1, C2>(self, left_col: C1, right_col: C2) -> Self

where E1: Entity, E2: Entity, C1: ModelColumn<E1>, C2: ModelColumn<E2>,

Specifies a relation for which the left column is equal to the right column.

pub fn ne<E1, E2, C1, C2>(self, left_col: C1, right_col: C2) -> Self

where E1: Entity, E2: Entity, C1: ModelColumn<E1>, C2: ModelColumn<E2>,

Specifies a relation for which the left column is not equal to the right column.

pub fn lt<E1, E2, C1, C2>(self, left_col: C1, right_col: C2) -> Self

where E1: Entity, E2: Entity, C1: ModelColumn<E1>, C2: ModelColumn<E2>,

Specifies a relation for which the left column is less than the right column.

pub fn le<E1, E2, C1, C2>(self, left_col: C1, right_col: C2) -> Self

where E1: Entity, E2: Entity, C1: ModelColumn<E1>, C2: ModelColumn<E2>,

Specifies a relation for which the left column is not greater than the right column.

pub fn gt<E1, E2, C1, C2>(self, left_col: C1, right_col: C2) -> Self

where E1: Entity, E2: Entity, C1: ModelColumn<E1>, C2: ModelColumn<E2>,

Specifies a relation for which the left column is greater than the right column.

pub fn ge<E1, E2, C1, C2>(self, left_col: C1, right_col: C2) -> Self

where E1: Entity, E2: Entity, C1: ModelColumn<E1>, C2: ModelColumn<E2>,

Specifies a relation for which the left column is not less than the right column.

Trait Implementations

impl Clone for JoinOn

fn clone(&self) -> JoinOn

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for JoinOn

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

Formats the value using the given formatter.