Enum FilterExpr 

pub enum FilterExpr {
    Comparison {
        column: String,
        operator: String,
        value: Value,
    },
    ColumnComparison {
        left_column: String,
        operator: String,
        right_column: String,
    },
    In {
        column: String,
        values: Vec<Value>,
    },
    NotIn {
        column: String,
        values: Vec<Value>,
    },
    InSubquery {
        column: String,
        subquery_sql: String,
        subquery_params: Vec<Value>,
    },
    NotInSubquery {
        column: String,
        subquery_sql: String,
        subquery_params: Vec<Value>,
    },
    And(Box<FilterExpr>, Box<FilterExpr>),
    Or(Box<FilterExpr>, Box<FilterExpr>),
    IsNull {
        column: String,
    },
    IsNotNull {
        column: String,
    },
    Between {
        column: String,
        min: Value,
        max: Value,
    },
    Exists {
        subquery_sql: String,
        subquery_params: Vec<Value>,
    },
    NotExists {
        subquery_sql: String,
        subquery_params: Vec<Value>,
    },
}

过滤表达式

Variants

Comparison

简单比较:column operator value

Fields

column: String

operator: String

value: Value

ColumnComparison

列-列比较:column1 operator column2

Fields

left_column: String

operator: String

right_column: String

In

IN 语句:column IN (value1, value2, …)

Fields

column: String

values: Vec<Value>

NotIn

NOT IN 语句:column NOT IN (value1, value2, …)

Fields

column: String

values: Vec<Value>

InSubquery

子查询 IN: column IN (subquery)

Fields

column: String

subquery_sql: String

subquery_params: Vec<Value>

NotInSubquery

子查询 NOT IN: column NOT IN (subquery)

Fields

column: String

subquery_sql: String

subquery_params: Vec<Value>

And(Box<FilterExpr>, Box<FilterExpr>)

AND 连接

Or(Box<FilterExpr>, Box<FilterExpr>)

OR 连接

IsNull

IS NULL

Fields

column: String

IsNotNull

IS NOT NULL

Fields

column: String

Between

BETWEEN min AND max

Fields

column: String

min: Value

max: Value

Exists

EXISTS 子查询: EXISTS (SELECT 1 FROM … WHERE …)

Fields

subquery_sql: String

subquery_params: Vec<Value>

NotExists

NOT EXISTS 子查询: NOT EXISTS (SELECT 1 FROM … WHERE …)

Fields

subquery_sql: String

subquery_params: Vec<Value>

Implementations

impl FilterExpr

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

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

Trait Implementations

impl Clone for FilterExpr

fn clone(&self) -> FilterExpr

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for FilterExpr

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

Formats the value using the given formatter.

impl From<WhereExpr> for FilterExpr

fn from(expr: WhereExpr) -> Self

Converts to this type from the input type.