Struct WindowSpec 

pub struct WindowSpec {
    pub window_name: Option<String>,
    pub partition_by: Vec<String>,
    pub order_by: Vec<OrderSpec>,
    pub frame: Option<FrameClause>,
}

Window specification (OVER clause).

Fields

window_name: Option<String>

Reference to a named window.

partition_by: Vec<String>

PARTITION BY columns.

order_by: Vec<OrderSpec>

ORDER BY specifications.

frame: Option<FrameClause>

Frame clause.

Implementations

impl WindowSpec

pub fn new() -> Self

Create a new empty window specification.

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

Reference a named window.

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

where I: IntoIterator<Item = S>, S: Into<String>,

Add PARTITION BY columns.

pub fn order_by(self, column: impl Into<String>, direction: SortOrder) -> Self

Add an ORDER BY column (ascending).

pub fn order_by_nulls( self, column: impl Into<String>, direction: SortOrder, nulls: NullsPosition, ) -> Self

Add an ORDER BY column with NULLS position.

pub fn rows(self, start: FrameBound, end: Option<FrameBound>) -> Self

Set ROWS frame.

pub fn range(self, start: FrameBound, end: Option<FrameBound>) -> Self

Set RANGE frame.

pub fn groups(self, start: FrameBound, end: Option<FrameBound>) -> Self

Set GROUPS frame (PostgreSQL).

pub fn rows_unbounded_preceding(self) -> Self

Common frame: ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW.

pub fn rows_unbounded_following(self) -> Self

Common frame: ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING.

pub fn rows_around(self, n: u32) -> Self

Common frame: ROWS BETWEEN n PRECEDING AND n FOLLOWING.

pub fn range_unbounded_preceding(self) -> Self

Common frame: RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW.

pub fn to_sql(&self, db_type: DatabaseType) -> String

Generate the OVER clause SQL.

Trait Implementations

impl Clone for WindowSpec

fn clone(&self) -> WindowSpec

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for WindowSpec

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

Formats the value using the given formatter.

impl Default for WindowSpec

fn default() -> WindowSpec

Returns the “default value” for a type.

impl<'de> Deserialize<'de> for WindowSpec

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for WindowSpec

fn eq(&self, other: &WindowSpec) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl Serialize for WindowSpec

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Eq for WindowSpec

impl StructuralPartialEq for WindowSpec