Trait WhereClauses

pub trait WhereClauses {
    // Required methods
    fn where_eq(&mut self, column: &str, value: Value);
    fn where_ne(&mut self, column: &str, value: Value);
    fn where_in(&mut self, column: &str, values: Vec<Value>);
    fn where_not_in(&mut self, column: &str, values: Vec<Value>);
    fn where_null(&mut self, column: &str);
    fn where_not_null(&mut self, column: &str);
    fn where_between(&mut self, column: &str, values: [Value; 2]);
    fn where_not_between(&mut self, column: &str, values: [Value; 2]);
    fn where_like(&mut self, column: &str, value: Value);
    fn where_not_like(&mut self, column: &str, value: Value);
    fn where_ilike(&mut self, column: &str, value: Value);
    fn where_gt(&mut self, column: &str, value: Value);
    fn where_gte(&mut self, column: &str, value: Value);
    fn where_lt(&mut self, column: &str, value: Value);
    fn where_lte(&mut self, column: &str, value: Value);
    fn where_column(&mut self, lhs: &str, operator: &str, rhs: &str);
    fn where_exists(&mut self, query: impl FnOnce(&mut ChainBuilder));
    fn where_not_exists(&mut self, query: impl FnOnce(&mut ChainBuilder));
    fn where_json_contains(&mut self, column: &str, value: Value);
    fn where_subquery(&mut self, query: impl FnOnce(&mut QueryBuilder));
    fn or(&mut self) -> &mut QueryBuilder;
    fn where_raw(&mut self, sql: &str, binds: Option<Vec<Value>>);
}

Trait for WHERE clause operations

Required Methods

fn where_eq(&mut self, column: &str, value: Value)

Add an equality condition

fn where_ne(&mut self, column: &str, value: Value)

Add a not equality condition

fn where_in(&mut self, column: &str, values: Vec<Value>)

Add an IN condition

fn where_not_in(&mut self, column: &str, values: Vec<Value>)

Add a NOT IN condition

fn where_null(&mut self, column: &str)

Add an IS NULL condition

fn where_not_null(&mut self, column: &str)

Add an IS NOT NULL condition

fn where_between(&mut self, column: &str, values: [Value; 2])

Add a BETWEEN condition

fn where_not_between(&mut self, column: &str, values: [Value; 2])

Add a NOT BETWEEN condition

fn where_like(&mut self, column: &str, value: Value)

Add a LIKE condition

fn where_not_like(&mut self, column: &str, value: Value)

Add a NOT LIKE condition

fn where_ilike(&mut self, column: &str, value: Value)

Add a case-insensitive LIKE condition (ILIKE for Postgres, LOWER() for MySQL)

fn where_gt(&mut self, column: &str, value: Value)

Add a greater than condition

fn where_gte(&mut self, column: &str, value: Value)

Add a greater than or equal condition

fn where_lt(&mut self, column: &str, value: Value)

Add a less than condition

fn where_lte(&mut self, column: &str, value: Value)

Add a less than or equal condition

fn where_column(&mut self, lhs: &str, operator: &str, rhs: &str)

Add a column-to-column comparison

fn where_exists(&mut self, query: impl FnOnce(&mut ChainBuilder))

Add an EXISTS condition

fn where_not_exists(&mut self, query: impl FnOnce(&mut ChainBuilder))

Add a NOT EXISTS condition

fn where_json_contains(&mut self, column: &str, value: Value)

Add a JSON contains condition (MySQL JSON_CONTAINS)

fn where_subquery(&mut self, query: impl FnOnce(&mut QueryBuilder))

Add a subquery condition

fn or(&mut self) -> &mut QueryBuilder

Add an OR condition

fn where_raw(&mut self, sql: &str, binds: Option<Vec<Value>>)

Add a raw WHERE condition

Dyn Compatibility

This trait is not dyn compatible.

In older versions of Rust, dyn compatibility was called "object safety", so this trait is not object safe.

Implementors

impl WhereClauses for QueryBuilder