Struct GroupByOperation 

pub struct GroupByOperation<M: Model, E: QueryEngine> { /* private fields */ }

Group by operation builder.

Implementations

impl<M: Model, E: QueryEngine> GroupByOperation<M, E>

pub fn new(columns: Vec<String>) -> Self

Create a new group by operation.

pub fn count(self) -> Self

Add a count aggregate.

pub fn sum(self, column: impl Into<String>) -> Self

Add sum of a column.

pub fn avg(self, column: impl Into<String>) -> Self

Add average of a column.

pub fn min(self, column: impl Into<String>) -> Self

Add minimum of a column.

pub fn max(self, column: impl Into<String>) -> Self

Add maximum of a column.

pub fn where(self, filter: impl Into<Filter>) -> Self

Add a filter condition.

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

Add a having condition.

pub fn order_by(self, order: impl Into<OrderByField>) -> Self

Add ordering.

pub fn skip(self, count: usize) -> Self

Set skip count.

pub fn take(self, count: usize) -> Self

Set take count.

pub fn build_sql(&self) -> (String, Vec<FilterValue>)

Build the SQL for this operation.

pub async fn exec(self, _engine: &E) -> QueryResult<Vec<GroupByResult>>

Execute the group by operation.

Trait Implementations

impl<M: Debug + Model, E: Debug + QueryEngine> Debug for GroupByOperation<M, E>

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

Formats the value using the given formatter.