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".

Implementors

impl WhereClauses for QueryBuilder