Struct QB 

pub struct QB<T: Debug> {
    pub base: TableInfo,
    pub eager: Vec<JoinSpec>,
    pub batch: Vec<JoinSpec>,
    pub filters: Vec<Condition>,
    /* private fields */
}

Query builder for composing SELECT statements with optional joins and filters.

Fields

base: TableInfo

Base table information and selected columns.

eager: Vec<JoinSpec>

Eager joins that project columns from related tables.

batch: Vec<JoinSpec>

Batch joins for has-many relations.

filters: Vec<Condition>

WHERE clause conditions combined with AND.

Implementations

impl<T: Debug> QB<T>

pub fn new(base: TableInfo) -> QB<T>

pub fn join_eager(self, spec: JoinSpec) -> Self

pub fn join_batch(self, spec: JoinSpec) -> Self

pub fn select<'a, Out: Debug + FromRow<'a, Row>>( self, cols: Vec<&'static str>, ) -> QB<Out>

pub fn filter(self, cond: Condition) -> Self

pub fn build_query(&self) -> QueryBuilder<'static, Driver>

pub fn to_sql(&self) -> String

Trait Implementations

impl<T: Debug + Debug> Debug for QB<T>

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

Formats the value using the given formatter.

impl<T> Executor<T> for QB<T>

where T: for<'r> FromRow<'r, Row> + Send + Unpin + Debug,

fn fetch_one_as<'life0, 'async_trait>( self, pool: &'life0 Pool, ) -> Pin<Box<dyn Future<Output = Result<T>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

Executes the query and returns a single row mapped as T.

fn fetch_all_as<'life0, 'async_trait>( self, pool: &'life0 Pool, ) -> Pin<Box<dyn Future<Output = Result<Vec<T>>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

Executes the query and returns all rows mapped as T.