Struct QueryBuilder 

pub struct QueryBuilder { /* private fields */ }

Builder for SQL queries.

Implementations

impl QueryBuilder

pub fn new() -> Self

Create a new query builder.

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

Start a SELECT query.

pub fn insert_into(self, table: &str) -> Self

Start an INSERT query.

pub fn update(self, table: &str) -> Self

Start an UPDATE query.

pub fn delete_from(self, table: &str) -> Self

Start a DELETE query.

pub fn from(self, table: &str) -> Self

Set the table for SELECT.

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

Set columns for INSERT.

pub fn values(self, values: Vec<Value>) -> Self

Add values for INSERT.

pub fn where_eq(self, column: &str, value: impl Into<Value>) -> Self

Add a WHERE condition.

pub fn where_ne(self, column: &str, value: impl Into<Value>) -> Self

Add a WHERE != condition.

pub fn where_gt(self, column: &str, value: impl Into<Value>) -> Self

Add a WHERE > condition.

pub fn where_gte(self, column: &str, value: impl Into<Value>) -> Self

Add a WHERE >= condition.

pub fn where_lt(self, column: &str, value: impl Into<Value>) -> Self

Add a WHERE < condition.

pub fn where_lte(self, column: &str, value: impl Into<Value>) -> Self

Add a WHERE <= condition.

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

Add a WHERE LIKE condition.

pub fn where_in(self, column: &str, values: Vec<Value>) -> Self

Add a WHERE IN condition.

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

Add a WHERE IS NULL condition.

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

Add a WHERE IS NOT NULL condition.

pub fn join(self, table: &str, on: &str) -> Self

Add a JOIN clause.

pub fn left_join(self, table: &str, on: &str) -> Self

Add a LEFT JOIN clause.

pub fn right_join(self, table: &str, on: &str) -> Self

Add a RIGHT JOIN clause.

pub fn full_join(self, table: &str, on: &str) -> Self

Add a FULL OUTER JOIN clause.

pub fn order_by(self, column: &str, direction: OrderDirection) -> Self

Add an ORDER BY clause.

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

Add ascending ORDER BY.

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

Add descending ORDER BY.

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

Add a GROUP BY clause.

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

Add a HAVING condition.

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

Set the LIMIT.

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

Set the OFFSET.

pub fn set(self, column: &str, value: impl Into<Value>) -> Self

Set values for UPDATE.

pub fn build(self) -> Query

Build the query.

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.

impl Default for QueryBuilder

fn default() -> QueryBuilder

Returns the “default value” for a type.