Struct Window 

pub struct Window {
    pub partition_by: Vec<String>,
    pub order_by: Vec<String>,
    pub frame: Option<Frame>,
}

Available on crate feature database and non-WebAssembly only.

Window specification

Fields

partition_by: Vec<String>

The partition by.

order_by: Vec<String>

The order by.

frame: Option<Frame>

The frame.

Implementations

impl Window

pub fn new() -> Window

Create a new empty window specification

Examples

use reinhardt_db::orm::window::Window;

let window = Window::new();
assert_eq!(window.to_sql(), "");

pub fn partition_by(self, field: impl Into<String>) -> Window

Add a PARTITION BY clause

Examples

use reinhardt_db::orm::window::Window;

let window = Window::new().partition_by("department");
assert_eq!(window.to_sql(), "PARTITION BY department");

pub fn order_by(self, field: impl Into<String>) -> Window

Add an ORDER BY clause

Examples

use reinhardt_db::orm::window::Window;

let window = Window::new().order_by("salary DESC");
assert_eq!(window.to_sql(), "ORDER BY salary DESC");

pub fn frame(self, frame: Frame) -> Window

Add a frame specification

Examples

use reinhardt_db::orm::window::{Window, Frame, FrameBoundary};

let frame = Frame::rows(
    FrameBoundary::UnboundedPreceding,
    Some(FrameBoundary::CurrentRow)
);
let window = Window::new().order_by("date").frame(frame);
assert_eq!(window.to_sql(), "ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW");

pub fn to_sql(&self) -> String

Convert window specification to SQL

Examples

use reinhardt_db::orm::window::Window;

let window = Window::new()
    .partition_by("department")
    .order_by("salary DESC");
assert_eq!(window.to_sql(), "PARTITION BY department ORDER BY salary DESC");

Trait Implementations

impl Clone for Window

fn clone(&self) -> Window

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Window

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

Formats the value using the given formatter.

impl Default for Window

fn default() -> Window

Returns the “default value” for a type.

impl<'de> Deserialize<'de> for Window

fn deserialize<__D>( __deserializer: __D, ) -> Result<Window, <__D as Deserializer<'de>>::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Serialize for Window

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

where __S: Serializer,

Serialize this value into the given Serde serializer.