Struct Window 

pub struct Window<T: Debug + Display + Clone> { /* private fields */ }

SQL window specification for window functions.

Examples

let win = Window::new()
    .partition_by(ident("department_id").dot_of("u"))
    .order_by(ident("salary").dot_of("u"), Order::Desc);

// Inline: SUM(u.salary) OVER (PARTITION BY ... ORDER BY ... DESC)
win.apply(Fx::new("sum", [ident("salary").dot_of("u").expr()]))

// Named reference: ROW_NUMBER() OVER win
Window::named("win").apply(Fx::new("row_number", []))

Implementations

impl<T: Debug + Display + Clone> Window<T>

pub fn new() -> Self

pub fn named(name: impl Into<String>) -> Self

Reference a named window defined in WINDOW clause.

pub fn partition_by(self, expr: impl Expressive<T>) -> Self

pub fn order_by(self, expr: impl Expressive<T>, order: Order) -> Self

pub fn rows(self, from: &str, to: &str) -> Self

pub fn range(self, from: &str, to: &str) -> Self

pub fn apply(&self, func: impl Expressive<T>) -> Expression<T>

Apply a function over this window: expr OVER (spec) or expr OVER name.

pub fn definition(&self) -> Expression<T>

Render just the definition part (for WINDOW clause): (PARTITION BY ... ORDER BY ...)

Trait Implementations

impl<T: Clone + Debug + Display + Clone> Clone for Window<T>

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

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl<T: Debug + Debug + Display + Clone> Debug for Window<T>

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

Formats the value using the given formatter.

impl<T: Debug + Display + Clone> Default for Window<T>

fn default() -> Self

Returns the “default value” for a type.