Struct Window

pub struct Window<E: Entity> { /* private fields */ }

SQL window functions.

Examples

use crate::model::{User, UserColumn::*};
use zino_orm::{QueryBuilder, Schema, Window};

let rank_window = Window::rank(CurrentLoginIp).order_desc(LoginCount);
let query = QueryBuilder::<User>::new()
    .fields([Id, Name, CurrentLoginIp, LoginCount])
    .window(rank_window, Some("login_count_rank"))
    .and_not_in(Status, ["Deleted", "Locked"])
    .order_desc(UpdatedAt)
    .limit(10)
    .build();
let users: Vec<Map> = User::find(&query).await?;

Implementations

impl<E: Entity> Window<E>

pub fn count(col: E::Column, partition: E::Column) -> Self

Constructs an instance for the window function COUNT.

pub fn sum(col: E::Column, partition: E::Column) -> Self

Constructs an instance for the window function SUM.

pub fn avg(col: E::Column, partition: E::Column) -> Self

Constructs an instance for the window function AVG.

pub fn min(col: E::Column, partition: E::Column) -> Self

Constructs an instance for the window function MIN.

pub fn max(col: E::Column, partition: E::Column) -> Self

Constructs an instance for the window function MAX.

pub fn row_number(partition: E::Column) -> Self

Constructs an instance for the window function DENSE_RANK.

pub fn rank(partition: E::Column) -> Self

Constructs an instance for the window function RANK.

pub fn dense_rank(partition: E::Column) -> Self

Constructs an instance for the window function DENSE_RANK.

pub fn percent_rank(partition: E::Column) -> Self

Constructs an instance for the window function PERCENT_RANK.

pub fn cume_dist(partition: E::Column) -> Self

Constructs an instance for the window function CUME_DIST.

pub fn ntile(num_buckets: usize, partition: E::Column) -> Self

Constructs an instance for the window function NTILE.

pub fn lag(col: E::Column, offset: usize, partition: E::Column) -> Self

Constructs an instance for the window function LAG.

pub fn lead(col: E::Column, offset: usize, partition: E::Column) -> Self

Constructs an instance for the window function LEAD.

pub fn first_value(col: E::Column, partition: E::Column) -> Self

Constructs an instance for the window function FIRST_VALUE.

pub fn last_value(col: E::Column, partition: E::Column) -> Self

Constructs an instance for the window function LAST_VALUE.

pub fn nth_value(col: E::Column, n: usize, partition: E::Column) -> Self

Constructs an instance for the window function NTH_VALUE.

pub fn order_by(self, col: E::Column, descending: bool) -> Self

Sets the sort order.

pub fn order_asc(self, col: E::Column) -> Self

Sets the sort order with an ascending order.

pub fn order_desc(self, col: E::Column) -> Self

Sets the sort order with an descending order.

Trait Implementations

impl<E: Clone + Entity> Clone for Window<E>

where E::Column: Clone,

fn clone(&self) -> Window<E>

Returns a copy of the value.

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

Performs copy-assignment from source.

impl<E: Debug + Entity> Debug for Window<E>

where E::Column: Debug,

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

Formats the value using the given formatter.

impl<E: Copy + Entity> Copy for Window<E>

where E::Column: Copy,