Struct QueryBuilder 

pub struct QueryBuilder { /* private fields */ }

Database query builder

Implementations

impl QueryBuilder

pub fn select(table: impl Into<String>) -> Self

Create a SELECT query

pub fn insert(table: impl Into<String>) -> Self

Create an INSERT query

pub fn columns(self, columns: Vec<impl Into<String>>) -> Self

Specify columns

pub fn where_clause(self, condition: impl Into<String>) -> Self

Add WHERE condition

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

Add values for INSERT

pub fn order_by(self, column: impl Into<String>, desc: bool) -> Self

Set ORDER BY

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

Set LIMIT

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

Set OFFSET

pub fn build_sql(&self) -> String

Build SQL query string

pub fn build_mongo(&self) -> Value

Build MongoDB query