Struct QueryBuilder 

pub struct QueryBuilder { /* private fields */ }

SQL query builder for SELECT statements

Implementations

impl QueryBuilder

pub fn new(table: &str) -> Self

Create a new query builder for the specified table

Example

use oxify_storage::query_builder::QueryBuilder;

let builder = QueryBuilder::new("users");

pub fn select(self, columns: &[&str]) -> Self

Specify columns to select

Example

use oxify_storage::query_builder::QueryBuilder;

let builder = QueryBuilder::new("users")
    .select(&["id", "name", "email"]);

pub fn distinct(self) -> Self

Add SELECT DISTINCT

pub fn where_condition(self, condition: Condition) -> Self

Add a WHERE condition

Example

use oxify_storage::query_builder::{QueryBuilder, Condition};

let builder = QueryBuilder::new("users")
    .where_condition(Condition::Eq("status".to_string()));

pub fn where_if(self, predicate: bool, condition: Condition) -> Self

Add a WHERE condition only if the predicate is true

This is useful for optional filters

pub fn join(self, join_type: JoinType, table: &str, on_condition: &str) -> Self

Add a JOIN clause

pub fn order_by(self, column: &str, order: SortOrder) -> Self

Add an ORDER BY clause

Example

use oxify_storage::query_builder::{QueryBuilder, SortOrder};

let builder = QueryBuilder::new("users")
    .order_by("created_at", SortOrder::Desc);

pub fn group_by(self, column: &str) -> Self

Add a GROUP BY clause

pub fn having(self, condition: Condition) -> Self

Add a HAVING condition (requires GROUP BY)

pub fn limit(self, limit: i64) -> Self

Set LIMIT

Example

use oxify_storage::query_builder::QueryBuilder;

let builder = QueryBuilder::new("users").limit(10);

pub fn offset(self, offset: i64) -> Self

Set OFFSET

pub fn build(&mut self) -> (String, usize)

Build the final SQL query and return the query string and total parameter count

Returns a tuple of (SQL string, number of parameters expected)

Example

use oxify_storage::query_builder::{QueryBuilder, Condition};

let mut builder = QueryBuilder::new("users")
    .select(&["id", "name"])
    .where_condition(Condition::Eq("status".to_string()));

let (sql, param_count) = builder.build();
assert_eq!(param_count, 1);

pub fn build_count(&mut self) -> (String, usize)

Build a COUNT query from this builder

This creates a COUNT(*) query using the same WHERE conditions

Trait Implementations

impl Clone for QueryBuilder

fn clone(&self) -> QueryBuilder

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for QueryBuilder

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

Formats the value using the given formatter.