Struct ExprBuilder 

pub struct ExprBuilder { /* private fields */ }

A type-safe expression builder.

Implementations

impl ExprBuilder

pub fn raw(sql: impl Into<String>) -> Self

Creates a new expression from raw SQL.

Warning: Only use this for SQL fragments that don’t contain user input.

pub fn column(name: &str) -> Self

Creates a column reference expression.

This is used internally by typed column accessors.

pub fn value<T: ToSqlValue>(value: T) -> Self

Creates an expression from a value (parameterized).

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

Creates an AND expression.

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

Creates an OR expression.

pub fn paren(self) -> Self

Wraps the expression in parentheses.

pub fn not(self) -> Self

Negates the expression with NOT.

pub fn eq<T: ToSqlValue>(self, value: T) -> Self

Creates an equality expression.

pub fn not_eq<T: ToSqlValue>(self, value: T) -> Self

Creates an inequality expression.

pub fn lt<T: ToSqlValue>(self, value: T) -> Self

Creates a less-than expression.

pub fn lt_eq<T: ToSqlValue>(self, value: T) -> Self

Creates a less-than-or-equal expression.

pub fn gt<T: ToSqlValue>(self, value: T) -> Self

Creates a greater-than expression.

pub fn gt_eq<T: ToSqlValue>(self, value: T) -> Self

Creates a greater-than-or-equal expression.

pub fn is_null(self) -> Self

Creates an IS NULL expression.

pub fn is_not_null(self) -> Self

Creates an IS NOT NULL expression.

pub fn like<T: ToSqlValue>(self, pattern: T) -> Self

Creates a LIKE expression.

pub fn in_list<T: ToSqlValue>(self, values: Vec<T>) -> Self

Creates an IN expression.

pub fn not_in_list<T: ToSqlValue>(self, values: Vec<T>) -> Self

Creates a NOT IN expression.

pub fn sql(&self) -> &str

Returns the SQL string.

pub fn params(&self) -> &[SqlValue]

Returns the parameters.

pub fn build(self) -> (String, Vec<SqlValue>)

Consumes the builder and returns the SQL and parameters.

Trait Implementations

impl Clone for ExprBuilder

fn clone(&self) -> ExprBuilder

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for ExprBuilder

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

Formats the value using the given formatter.

impl From<ColumnRef> for ExprBuilder

fn from(col: ColumnRef) -> Self

Converts to this type from the input type.

impl From<SqlValue> for ExprBuilder

fn from(value: SqlValue) -> Self

Converts to this type from the input type.