Enum Expr

pub enum Expr {
    Comparison {
        column: String,
        operator: ComparisonOperator,
        value: Value,
    },
    And(Box<Expr>, Box<Expr>),
    Or(Box<Expr>, Box<Expr>),
    Not(Box<Expr>),
    IsNull(String),
    IsNotNull(String),
    In {
        column: String,
        values: Vec<Value>,
    },
    Between {
        column: String,
        low: Value,
        high: Value,
    },
}

Expression for WHERE clause

Variants

Comparison

Comparison: column op value

Fields

column: String

operator: ComparisonOperator

value: Value

And(Box<Expr>, Box<Expr>)

Logical AND

Or(Box<Expr>, Box<Expr>)

Logical OR

Not(Box<Expr>)

Logical NOT

IsNull(String)

IS NULL

IsNotNull(String)

IS NOT NULL

In

IN (list of values)

Fields

column: String

values: Vec<Value>

Between

BETWEEN (range check)

Fields

column: String

low: Value

high: Value

Implementations

impl Expr

pub fn eq(column: impl Into<String>, value: Value) -> Self

Create column = value comparison expression

pub fn ne(column: impl Into<String>, value: Value) -> Self

Create column != value comparison expression

pub fn lt(column: impl Into<String>, value: Value) -> Self

Create column < value comparison expression

pub fn le(column: impl Into<String>, value: Value) -> Self

Create column <= value comparison expression

pub fn gt(column: impl Into<String>, value: Value) -> Self

Create column > value comparison expression

pub fn ge(column: impl Into<String>, value: Value) -> Self

Create column >= value comparison expression

pub fn like(column: impl Into<String>, value: Value) -> Self

Create column LIKE value expression

pub fn is_null(column: impl Into<String>) -> Self

Create column IS NULL expression

pub fn is_not_null(column: impl Into<String>) -> Self

Create column IS NOT NULL expression

pub fn in_values(column: impl Into<String>, values: Vec<Value>) -> Self

Create column IN (values...) expression

pub fn between(column: impl Into<String>, low: Value, high: Value) -> Self

Create column BETWEEN low AND high expression

pub fn and(self, other: Expr) -> Self

Logical AND: self AND other

pub fn or(self, other: Expr) -> Self

Logical OR: self OR other

pub fn not(self) -> Self

Logical NOT: NOT self

Trait Implementations

impl Clone for Expr

fn clone(&self) -> Expr

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Expr

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

Formats the value using the given formatter.