Skip to main content

Expr

Enum Expr 

Source
pub enum Expr {
Show 16 variants Eq(AnyColumn, Value), Ne(AnyColumn, Value), Gt(AnyColumn, Value), Gte(AnyColumn, Value), Lt(AnyColumn, Value), Lte(AnyColumn, Value), Between(AnyColumn, Value, Value), InList(AnyColumn, Vec<Value>), NotIn(AnyColumn, Vec<Value>), Like(AnyColumn, Value), ILike(AnyColumn, Value), IsNull(AnyColumn), IsNotNull(AnyColumn), And(Box<Expr>, Box<Expr>), Or(Box<Expr>, Box<Expr>), Not(Box<Expr>),
}
Expand description

A composable SQL expression node.

Built via Column<T> methods, composed via .and(), .or(), .not(). Rendered to SQL + params via to_sql().

Variants§

§

Eq(AnyColumn, Value)

column = $N

§

Ne(AnyColumn, Value)

column != $N

§

Gt(AnyColumn, Value)

column > $N

§

Gte(AnyColumn, Value)

column >= $N

§

Lt(AnyColumn, Value)

column < $N

§

Lte(AnyColumn, Value)

column <= $N

§

Between(AnyColumn, Value, Value)

column BETWEEN $N AND $M

§

InList(AnyColumn, Vec<Value>)

column IN ($N, $M, ...) — empty list renders as 1=0

§

NotIn(AnyColumn, Vec<Value>)

column NOT IN ($N, $M, ...) — empty list renders as 1=1

§

Like(AnyColumn, Value)

column LIKE $N

§

ILike(AnyColumn, Value)

column ILIKE $N (case-insensitive, PostgreSQL)

§

IsNull(AnyColumn)

column IS NULL

§

IsNotNull(AnyColumn)

column IS NOT NULL

§

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

(left AND right)

§

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

(left OR right)

§

Not(Box<Expr>)

NOT (expr)

Implementations§

Source§

impl Expr

Source

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

Combine with AND: self AND other

Source

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

Combine with OR: self OR other

Source

pub fn not(self) -> Expr

Negate: NOT self

Source

pub fn to_sql(&self, sql: &mut String, params: &mut Vec<Value>, idx: &mut usize)

Render this expression to a SQL string fragment, pushing parameters into params and incrementing idx for each $N placeholder.

The idx counter is shared across the entire query so parameter numbers are globally unique (e.g., a WHERE clause with 3 params followed by a HAVING clause continues from $4).

Source

pub fn render(&self) -> (String, Vec<Value>)

Convenience: render to a standalone (sql, params) tuple. Starts parameter numbering from $1.

Trait Implementations§

Source§

impl Clone for Expr

Source§

fn clone(&self) -> Expr

Returns a duplicate of the value. Read more
1.0.0 (const: unstable) · Source§

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

Performs copy-assignment from source. Read more
Source§

impl Debug for Expr

Source§

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

Formats the value using the given formatter. Read more

Auto Trait Implementations§

§

impl Freeze for Expr

§

impl RefUnwindSafe for Expr

§

impl Send for Expr

§

impl Sync for Expr

§

impl Unpin for Expr

§

impl UnsafeUnpin for Expr

§

impl UnwindSafe for Expr

Blanket Implementations§

Source§

impl<T> Any for T
where T: 'static + ?Sized,

Source§

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more
Source§

impl<T> Borrow<T> for T
where T: ?Sized,

Source§

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more
Source§

impl<T> BorrowMut<T> for T
where T: ?Sized,

Source§

fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more
Source§

impl<T> CloneToUninit for T
where T: Clone,

Source§

unsafe fn clone_to_uninit(&self, dest: *mut u8)

🔬This is a nightly-only experimental API. (clone_to_uninit)
Performs copy-assignment from self to dest. Read more
Source§

impl<T> FlozRowBound for T

Source§

impl<T> From<T> for T

Source§

fn from(t: T) -> T

Returns the argument unchanged.

Source§

impl<T> Instrument for T

Source§

fn instrument(self, span: Span) -> Instrumented<Self>

Instruments this type with the provided Span, returning an Instrumented wrapper. Read more
Source§

fn in_current_span(self) -> Instrumented<Self>

Instruments this type with the current Span, returning an Instrumented wrapper. Read more
Source§

impl<T, U> Into<U> for T
where U: From<T>,

Source§

fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

Source§

impl<T> IntoEither for T

Source§

fn into_either(self, into_left: bool) -> Either<Self, Self>

Converts self into a Left variant of Either<Self, Self> if into_left is true. Converts self into a Right variant of Either<Self, Self> otherwise. Read more
Source§

fn into_either_with<F>(self, into_left: F) -> Either<Self, Self>
where F: FnOnce(&Self) -> bool,

Converts self into a Left variant of Either<Self, Self> if into_left(&self) returns true. Converts self into a Right variant of Either<Self, Self> otherwise. Read more
Source§

impl<T> Same for T

Source§

type Output = T

Should always be Self
Source§

impl<T> ToOwned for T
where T: Clone,

Source§

type Owned = T

The resulting type after obtaining ownership.
Source§

fn to_owned(&self) -> T

Creates owned data from borrowed data, usually by cloning. Read more
Source§

fn clone_into(&self, target: &mut T)

Uses borrowed data to replace owned data, usually by cloning. Read more
Source§

impl<T, U> TryFrom<U> for T
where U: Into<T>,

Source§

type Error = Infallible

The type returned in the event of a conversion error.
Source§

fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>

Performs the conversion.
Source§

impl<T, U> TryInto<U> for T
where U: TryFrom<T>,

Source§

type Error = <U as TryFrom<T>>::Error

The type returned in the event of a conversion error.
Source§

fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>

Performs the conversion.
Source§

impl<T> WithSubscriber for T

Source§

fn with_subscriber<S>(self, subscriber: S) -> WithDispatch<Self>
where S: Into<Dispatch>,

Attaches the provided Subscriber to this type, returning a WithDispatch wrapper. Read more
Source§

fn with_current_subscriber(self) -> WithDispatch<Self>

Attaches the current default Subscriber to this type, returning a WithDispatch wrapper. Read more