Struct lumus_sql_builder::sqlite::Where

pub struct Where { /* private fields */ }

Represents a WHERE clause builder for SQL queries.

Implementations

impl Where

pub fn new() -> Self

Creates a new Where instance with an empty statement.

pub fn from(statement: &str) -> Self

Creates a new Where instance with a specified initial statement.

pub fn equal_to(&mut self, field: &str, value: &str) -> &mut Self

Adds an equality condition (field = value) to the WHERE clause.

pub fn not_equal_to(&mut self, field: &str, value: &str) -> &mut Self

Adds a not equal condition (field != value) to the WHERE clause.

pub fn greater_than(&mut self, field: &str, value: &str) -> &mut Self

Adds a greater than condition (field > value) to the WHERE clause.

pub fn greater_than_equal(&mut self, field: &str, value: &str) -> &mut Self

Adds a greater than or equal condition (field >= value) to the WHERE clause.

pub fn less_than(&mut self, field: &str, value: &str) -> &mut Self

Adds a less than condition (field < value) to the WHERE clause.

pub fn less_than_equal( &mut self, field: &str, value: &str, ) -> Result<&mut Self, SqlBuilderError>

Adds a less than or equal condition (field <= value) to the WHERE clause.

pub fn is_null(&mut self, field: &str) -> &mut Self

Adds a IS NULL condition (field IS NULL) to the WHERE clause.

pub fn is_not_null(&mut self, field: &str) -> &mut Self

Adds a IS NOT NULL condition (field IS NOT NULL) to the WHERE clause.

pub fn inside(&mut self, field: &str, values: Vec<&str>) -> &mut Self

Adds an IN condition (field IN (values)) to the WHERE clause.

pub fn not_inside(&mut self, field: &str, values: Vec<&str>) -> &mut Self

Adds a NOT IN condition (field NOT IN (values)) to the WHERE clause.

pub fn like(&mut self, field: &str, value: &str) -> &mut Self

Adds a LIKE condition (field LIKE value) to the WHERE clause.

pub fn not_like(&mut self, field: &str, value: &str) -> &mut Self

Adds a NOT LIKE condition (field NOT LIKE value) to the WHERE clause.

pub fn and(&mut self) -> &mut Self

Appends AND to the current statement in the WHERE clause.

pub fn or(&mut self) -> &mut Self

Appends OR to the current statement in the WHERE clause.

pub fn nest(&mut self) -> &mut Self

Appends a left parenthesis ( to the current statement in the WHERE clause.

pub fn unnest(&mut self) -> &mut Self

Appends a right parenthesis ) to the current statement in the WHERE clause.

pub fn build(&self) -> String

Constructs and returns the final SQL statement represented by the WHERE clause.

Trait Implementations

impl Display for Where

Implementation of the Display trait for Where, allowing it to be printed.

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

Formats the value using the given formatter.