Struct sea_query::query::Condition

pub struct Condition { /* fields omitted */ }

Represents the value of an Condition::any or Condition::all: a set of disjunctive or conjunctive conditions.

Implementations

impl Condition

pub fn add<C>(self, condition: C) -> Self where
    C: Into<ConditionExpression>, 

Add a condition to the set.

If it’s an Condition::any, it will be separated from the others by an " OR " in the query. If it’s an Condition::all, it will be separated by an " AND ".

pub fn any() -> Condition

Create a condition that is true if any of the conditions is true.

Examples

use sea_query::{*, tests_cfg::*};

let query = Query::select()
    .column(Glyph::Image)
    .from(Glyph::Table)
    .cond_where(
        Cond::any()
            .add(Expr::tbl(Glyph::Table, Glyph::Aspect).is_in(vec![3, 4]))
            .add(Expr::tbl(Glyph::Table, Glyph::Image).like("A%"))
    )
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"SELECT `image` FROM `glyph` WHERE `glyph`.`aspect` IN (3, 4) OR `glyph`.`image` LIKE 'A%'"#
);

pub fn all() -> Condition

Create a condition that is false if any of the conditions is false.

Examples

use sea_query::{*, tests_cfg::*};

let query = Query::select()
    .column(Glyph::Image)
    .from(Glyph::Table)
    .cond_where(
        Cond::all()
            .add(Expr::tbl(Glyph::Table, Glyph::Aspect).is_in(vec![3, 4]))
            .add(Expr::tbl(Glyph::Table, Glyph::Image).like("A%"))
    )
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"SELECT `image` FROM `glyph` WHERE `glyph`.`aspect` IN (3, 4) AND `glyph`.`image` LIKE 'A%'"#
);

Trait Implementations

impl Clone for Condition

fn clone(&self) -> Condition

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for Condition

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

Formats the value using the given formatter.

impl From<Condition> for ConditionExpression

fn from(condition: Condition) -> Self

Performs the conversion.

impl IntoCondition for Condition

fn into_condition(self) -> Condition