Struct WindowSpec 

pub struct WindowSpec<'a, V: SQLParam> { /* private fields */ }

Builder for a window specification (the content inside OVER (...)).

Example

window()
    .partition_by([users.dept])
    .order_by([asc(users.salary)])
    .rows_between(FrameBound::UnboundedPreceding, FrameBound::CurrentRow)

Implementations

impl<'a, V: SQLParam + 'a> WindowSpec<'a, V>

pub fn partition_by<I>(self, exprs: I) -> Self

where I: IntoIterator, I::Item: ToSQL<'a, V>,

Set the PARTITION BY clause.

pub fn order_by<T: ToSQL<'a, V>>(self, exprs: T) -> Self

Set the ORDER BY clause.

pub fn rows_between(self, start: FrameBound, end: FrameBound) -> Self

Set a ROWS frame specification.

pub fn range_between(self, start: FrameBound, end: FrameBound) -> Self

Set a RANGE frame specification.

Trait Implementations

impl<'a, V: Clone + SQLParam> Clone for WindowSpec<'a, V>

fn clone(&self) -> WindowSpec<'a, V>

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl<'a, V: Debug + SQLParam> Debug for WindowSpec<'a, V>

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

Formats the value using the given formatter.