Enum Condition 

pub enum Condition {
    Eq(String),
    NotEq(String),
    Gt(String),
    Gte(String),
    Lt(String),
    Lte(String),
    Like(String),
    ILike(String),
    In(String, usize),
    NotIn(String, usize),
    Between(String),
    IsNull(String),
    IsNotNull(String),
    Raw(String),
}

SQL condition types for WHERE clauses

Variants

Eq(String)

column = $n

NotEq(String)

column != $n

Gt(String)

column > $n

Gte(String)

column >= $n

Lt(String)

column < $n

Lte(String)

column <= $n

Like(String)

column LIKE $n

ILike(String)

column ILIKE $n (case-insensitive)

In(String, usize)

column IN ($n, $n+1, …)

NotIn(String, usize)

column NOT IN ($n, $n+1, …)

Between(String)

column BETWEEN $n AND $n+1

IsNull(String)

column IS NULL

IsNotNull(String)

column IS NOT NULL

Raw(String)

Custom SQL condition (use with caution, ensure no injection)

Implementations

impl Condition

pub fn param_count(&self) -> usize

Get the number of parameters this condition requires

pub fn to_sql(&self, param_start: usize) -> String

Build the SQL fragment for this condition

Trait Implementations

impl Clone for Condition

fn clone(&self) -> Condition

Returns a duplicate 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.