Enum sea_query::expr::SimpleExpr

pub enum SimpleExpr {
    Column(ColumnRef),
    Tuple(Vec<SimpleExpr>),
    Unary(UnOper, Box<SimpleExpr>),
    FunctionCall(FunctionCall),
    Binary(Box<SimpleExpr>, BinOper, Box<SimpleExpr>),
    SubQuery(Option<SubQueryOper>, Box<SubQueryStatement>),
    Value(Value),
    Values(Vec<Value>),
    Custom(String),
    CustomWithExpr(String, Vec<SimpleExpr>),
    Keyword(Keyword),
    AsEnum(DynIden, Box<SimpleExpr>),
    Case(Box<CaseStatement>),
    Constant(Value),
}

Represents a Simple Expression in SQL.

SimpleExpr is a node in the expression tree and can represent identifiers, function calls, various operators and sub-queries.

Variants

Column(ColumnRef)

Tuple(Vec<SimpleExpr>)

Unary(UnOper, Box<SimpleExpr>)

FunctionCall(FunctionCall)

Binary(Box<SimpleExpr>, BinOper, Box<SimpleExpr>)

SubQuery(Option<SubQueryOper>, Box<SubQueryStatement>)

Value(Value)

Values(Vec<Value>)

Custom(String)

CustomWithExpr(String, Vec<SimpleExpr>)

Keyword(Keyword)

AsEnum(DynIden, Box<SimpleExpr>)

Case(Box<CaseStatement>)

Constant(Value)

Implementations

impl SimpleExpr

pub fn not(self) -> SimpleExpr

Negates an expression with NOT.

Examples

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

let query = Query::select()
    .column(Char::SizeW)
    .from(Char::Table)
    .and_where(Expr::col(Char::SizeW).eq(1).not())
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"SELECT `size_w` FROM `character` WHERE NOT `size_w` = 1"#
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT "size_w" FROM "character" WHERE NOT "size_w" = 1"#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"SELECT "size_w" FROM "character" WHERE NOT "size_w" = 1"#
);

pub fn and(self, right: SimpleExpr) -> Self

Express a logical AND operation.

Examples

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

let query = Query::select()
    .columns([Char::Character, Char::SizeW, Char::SizeH])
    .from(Char::Table)
    .cond_where(any![
        Expr::col(Char::SizeW).eq(1).and(Expr::col(Char::SizeH).eq(2)),
        Expr::col(Char::SizeW).eq(3).and(Expr::col(Char::SizeH).eq(4)),
    ])
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"SELECT `character`, `size_w`, `size_h` FROM `character` WHERE ((`size_w` = 1) AND (`size_h` = 2)) OR ((`size_w` = 3) AND (`size_h` = 4))"#
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT "character", "size_w", "size_h" FROM "character" WHERE (("size_w" = 1) AND ("size_h" = 2)) OR (("size_w" = 3) AND ("size_h" = 4))"#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"SELECT "character", "size_w", "size_h" FROM "character" WHERE (("size_w" = 1) AND ("size_h" = 2)) OR (("size_w" = 3) AND ("size_h" = 4))"#
);

pub fn or(self, right: SimpleExpr) -> Self

Express a logical OR operation.

Examples

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

let query = Query::select()
    .columns([Char::Character, Char::SizeW, Char::SizeH])
    .from(Char::Table)
    .and_where(Expr::col(Char::SizeW).eq(1).or(Expr::col(Char::SizeH).eq(2)))
    .and_where(Expr::col(Char::SizeW).eq(3).or(Expr::col(Char::SizeH).eq(4)))
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"SELECT `character`, `size_w`, `size_h` FROM `character` WHERE ((`size_w` = 1) OR (`size_h` = 2)) AND ((`size_w` = 3) OR (`size_h` = 4))"#
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT "character", "size_w", "size_h" FROM "character" WHERE (("size_w" = 1) OR ("size_h" = 2)) AND (("size_w" = 3) OR ("size_h" = 4))"#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"SELECT "character", "size_w", "size_h" FROM "character" WHERE (("size_w" = 1) OR ("size_h" = 2)) AND (("size_w" = 3) OR ("size_h" = 4))"#
);

pub fn eq<V>(self, v: V) -> SimpleExprwhere V: Into<SimpleExpr>,

Express an equal (=) expression.

Examples

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

let query = Query::select()
    .columns([Char::Character, Char::SizeW, Char::SizeH])
    .from(Char::Table)
    .and_where(Expr::value("What!").eq("Nothing"))
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"SELECT `character`, `size_w`, `size_h` FROM `character` WHERE 'What!' = 'Nothing'"#
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT "character", "size_w", "size_h" FROM "character" WHERE 'What!' = 'Nothing'"#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"SELECT "character", "size_w", "size_h" FROM "character" WHERE 'What!' = 'Nothing'"#
);

pub fn ne<V>(self, v: V) -> SimpleExprwhere V: Into<SimpleExpr>,

Express a not equal (<>) expression.

Examples

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

let query = Query::select()
    .columns([Char::Character, Char::SizeW, Char::SizeH])
    .from(Char::Table)
    .and_where(Expr::value("Morning").ne("Good"))
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"SELECT `character`, `size_w`, `size_h` FROM `character` WHERE 'Morning' <> 'Good'"#
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT "character", "size_w", "size_h" FROM "character" WHERE 'Morning' <> 'Good'"#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"SELECT "character", "size_w", "size_h" FROM "character" WHERE 'Morning' <> 'Good'"#
);

pub fn equals<T>(self, right: T) -> Selfwhere T: Into<SimpleExpr>,

👎Deprecated since 0.28.0: Please use the [SimpleExpr::eq]

pub fn not_equals<T>(self, right: T) -> Selfwhere T: Into<SimpleExpr>,

👎Deprecated since 0.28.0: Please use the [SimpleExpr::ne]

pub fn add<T>(self, right: T) -> Selfwhere T: Into<SimpleExpr>,

Perform addition with another SimpleExpr.

Examples

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

let query = Query::select()
    .expr(
        Expr::col(Char::SizeW)
            .max()
            .add(Expr::col(Char::SizeH).max()),
    )
    .from(Char::Table)
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"SELECT MAX(`size_w`) + MAX(`size_h`) FROM `character`"#
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT MAX("size_w") + MAX("size_h") FROM "character""#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"SELECT MAX("size_w") + MAX("size_h") FROM "character""#
);

pub fn mul<T>(self, right: T) -> Selfwhere T: Into<SimpleExpr>,

Perform multiplication with another SimpleExpr.

Examples

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

let query = Query::select()
    .expr(
        Expr::col(Char::SizeW)
            .max()
            .mul(Expr::col(Char::SizeH).max()),
    )
    .from(Char::Table)
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"SELECT MAX(`size_w`) * MAX(`size_h`) FROM `character`"#
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT MAX("size_w") * MAX("size_h") FROM "character""#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"SELECT MAX("size_w") * MAX("size_h") FROM "character""#
);

pub fn div<T>(self, right: T) -> Selfwhere T: Into<SimpleExpr>,

Perform division with another SimpleExpr.

Examples

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

let query = Query::select()
    .expr(
        Expr::col(Char::SizeW)
            .max()
            .div(Expr::col(Char::SizeH).max()),
    )
    .from(Char::Table)
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"SELECT MAX(`size_w`) / MAX(`size_h`) FROM `character`"#
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT MAX("size_w") / MAX("size_h") FROM "character""#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"SELECT MAX("size_w") / MAX("size_h") FROM "character""#
);

pub fn sub<T>(self, right: T) -> Selfwhere T: Into<SimpleExpr>,

Perform subtraction with another SimpleExpr.

Examples

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

let query = Query::select()
    .expr(
        Expr::col(Char::SizeW)
            .max()
            .sub(Expr::col(Char::SizeW).min()),
    )
    .from(Char::Table)
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"SELECT MAX(`size_w`) - MIN(`size_w`) FROM `character`"#
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT MAX("size_w") - MIN("size_w") FROM "character""#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"SELECT MAX("size_w") - MIN("size_w") FROM "character""#
);

pub fn cast_as<T>(self, type_name: T) -> Selfwhere T: IntoIden,

Express a CAST AS expression.

Examples

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

let query = Query::select()
    .expr(Expr::value("1").cast_as(Alias::new("integer")))
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"SELECT CAST('1' AS integer)"#
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT CAST('1' AS integer)"#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"SELECT CAST('1' AS integer)"#
);

pub fn binary<O, T>(self, op: O, right: T) -> Selfwhere O: Into<BinOper>, T: Into<SimpleExpr>,

Create any binary operation

Examples

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

let query = Query::select()
    .columns([Char::Character, Char::SizeW, Char::SizeH])
    .from(Char::Table)
    .cond_where(all![
        Expr::value(10).binary(BinOper::SmallerThan, Expr::col(Char::SizeW)),
        Expr::value(20).binary(BinOper::GreaterThan, Expr::col(Char::SizeH))
    ])
    .to_owned();
assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"SELECT `character`, `size_w`, `size_h` FROM `character` WHERE 10 < `size_w` AND 20 > `size_h`"#
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT "character", "size_w", "size_h" FROM "character" WHERE 10 < "size_w" AND 20 > "size_h""#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"SELECT "character", "size_w", "size_h" FROM "character" WHERE 10 < "size_w" AND 20 > "size_h""#
);

pub fn like<L: IntoLikeExpr>(self, like: L) -> Self

Express a LIKE expression.

Examples

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

let query = Query::select()
    .columns([Char::Character, Char::SizeW, Char::SizeH])
    .from(Char::Table)
    .and_where(Expr::col((Char::Table, Char::FontId)).cast_as(Alias::new("TEXT")).like("a%"))
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"SELECT `character`, `size_w`, `size_h` FROM `character` WHERE CAST(`character`.`font_id` AS TEXT) LIKE 'a%'"#
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT "character", "size_w", "size_h" FROM "character" WHERE CAST("character"."font_id" AS TEXT) LIKE 'a%'"#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"SELECT "character", "size_w", "size_h" FROM "character" WHERE CAST("character"."font_id" AS TEXT) LIKE 'a%'"#
);

pub fn not_like<L: IntoLikeExpr>(self, like: L) -> Self

Express a NOT LIKE expression

Trait Implementations

impl Clone for SimpleExpr

fn clone(&self) -> SimpleExpr

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for SimpleExpr

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

Formats the value using the given formatter.

impl From<ColumnRef> for SimpleExpr

fn from(col: ColumnRef) -> Self

Converts to this type from the input type.

impl From<Expr> for SimpleExpr

fn from(src: Expr) -> Self

Convert into SimpleExpr

impl From<FunctionCall> for SimpleExpr

fn from(func: FunctionCall) -> Self

Converts to this type from the input type.

impl From<Keyword> for SimpleExpr

fn from(k: Keyword) -> Self

Converts to this type from the input type.

impl From<SimpleExpr> for ConditionExpression

fn from(condition: SimpleExpr) -> Self

Converts to this type from the input type.

impl<T> From<T> for SimpleExprwhere T: Into<Value>,

fn from(v: T) -> Self

Converts to this type from the input type.

impl Into<SimpleExpr> for CaseStatement

fn into(self) -> SimpleExpr

Converts this type into the (usually inferred) input type.

impl IntoCondition for SimpleExpr

fn into_condition(self) -> Condition

impl PgExpr for SimpleExpr

Available on crate feature backend-postgres only.

fn concatenate<T>(self, right: T) -> SimpleExprwhere T: Into<SimpleExpr>,

Express an postgres concatenate (||) expression.

fn concat<T>(self, right: T) -> SimpleExprwhere T: Into<SimpleExpr>,

Alias of PgExpr::concatenate

fn matches<T>(self, expr: T) -> SimpleExprwhere T: Into<SimpleExpr>,

Express an postgres fulltext search matches (@@) expression.

fn contains<T>(self, expr: T) -> SimpleExprwhere T: Into<SimpleExpr>,

Express an postgres fulltext search contains (@>) expression.

fn contained<T>(self, expr: T) -> SimpleExprwhere T: Into<SimpleExpr>,

Express an postgres fulltext search contained (<@) expression.

fn ilike<L>(self, like: L) -> SimpleExprwhere L: IntoLikeExpr,

Express a LIKE expression.

fn not_ilike<L>(self, like: L) -> SimpleExprwhere L: IntoLikeExpr,

Express a NOT ILIKE expression

impl SqliteExpr for SimpleExpr

Available on crate feature backend-sqlite only.

fn matches<T>(self, right: T) -> SimpleExprwhere T: Into<SimpleExpr>,

Express an sqlite MATCH operator.

fn get_json_field<T>(self, right: T) -> SimpleExprwhere T: Into<SimpleExpr>,

Express an sqlite retrieves JSON field as JSON value (->).

fn cast_json_field<T>(self, right: T) -> SimpleExprwhere T: Into<SimpleExpr>,

Express an sqlite retrieves JSON field and casts it to an appropriate SQL type (->>).