Struct sea_orm_migration::prelude::query::WindowStatement
pub struct WindowStatement { /* private fields */ }
Expand description
Implementations§
§impl WindowStatement
impl WindowStatement
pub fn new() -> WindowStatement
pub fn new() -> WindowStatement
Construct a new WindowStatement
pub fn take(&mut self) -> WindowStatement
pub fn partition_by<T>(col: T) -> WindowStatementwhere
T: IntoColumnRef,
pub fn partition_by<T>(col: T) -> WindowStatementwhere T: IntoColumnRef,
Construct a new WindowStatement
with PARTITION BY column
pub fn partition_by_custom<T>(col: T) -> WindowStatementwhere
T: ToString,
pub fn partition_by_custom<T>(col: T) -> WindowStatementwhere T: ToString,
Construct a new WindowStatement
with PARTITION BY custom
pub fn order_by<T>(col: T, order: Order) -> WindowStatementwhere
T: IntoColumnRef,
pub fn order_by<T>(col: T, order: Order) -> WindowStatementwhere T: IntoColumnRef,
Construct a new WindowStatement
with ORDER BY column
pub fn order_by_custom<T>(col: T, order: Order) -> WindowStatementwhere
T: ToString,
pub fn order_by_custom<T>(col: T, order: Order) -> WindowStatementwhere T: ToString,
Construct a new WindowStatement
with ORDER BY custom
pub fn frame_start(
&mut self,
type: FrameType,
start: Frame
) -> &mut WindowStatement
pub fn frame_start( &mut self, type: FrameType, start: Frame ) -> &mut WindowStatement
frame clause for frame_start
Examples:
use sea_query::{tests_cfg::*, *};
let query = Query::select()
.from(Char::Table)
.expr_window_as(
Expr::col(Char::Character),
WindowStatement::partition_by(Char::FontSize)
.frame_start(FrameType::Rows, Frame::UnboundedPreceding)
.take(),
Alias::new("C"))
.to_owned();
assert_eq!(
query.to_string(MysqlQueryBuilder),
r#"SELECT `character` OVER ( PARTITION BY `font_size` ROWS UNBOUNDED PRECEDING ) AS `C` FROM `character`"#
);
assert_eq!(
query.to_string(PostgresQueryBuilder),
r#"SELECT "character" OVER ( PARTITION BY "font_size" ROWS UNBOUNDED PRECEDING ) AS "C" FROM "character""#
);
assert_eq!(
query.to_string(SqliteQueryBuilder),
r#"SELECT "character" OVER ( PARTITION BY "font_size" ROWS UNBOUNDED PRECEDING ) AS "C" FROM "character""#
);
pub fn frame_between(
&mut self,
type: FrameType,
start: Frame,
end: Frame
) -> &mut WindowStatement
pub fn frame_between( &mut self, type: FrameType, start: Frame, end: Frame ) -> &mut WindowStatement
frame clause for BETWEEN frame_start AND frame_end
Examples:
use sea_query::{tests_cfg::*, *};
let query = Query::select()
.from(Char::Table)
.expr_window_as(
Expr::col(Char::Character),
WindowStatement::partition_by(Char::FontSize)
.frame_between(FrameType::Rows, Frame::UnboundedPreceding, Frame::UnboundedFollowing)
.take(),
Alias::new("C"))
.to_owned();
assert_eq!(
query.to_string(MysqlQueryBuilder),
r#"SELECT `character` OVER ( PARTITION BY `font_size` ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS `C` FROM `character`"#
);
assert_eq!(
query.to_string(PostgresQueryBuilder),
r#"SELECT "character" OVER ( PARTITION BY "font_size" ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS "C" FROM "character""#
);
assert_eq!(
query.to_string(SqliteQueryBuilder),
r#"SELECT "character" OVER ( PARTITION BY "font_size" ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS "C" FROM "character""#
);
Trait Implementations§
§impl Clone for WindowStatement
impl Clone for WindowStatement
§fn clone(&self) -> WindowStatement
fn clone(&self) -> WindowStatement
Returns a copy of the value. Read more
1.0.0 · source§fn clone_from(&mut self, source: &Self)
fn clone_from(&mut self, source: &Self)
Performs copy-assignment from
source
. Read more§impl Debug for WindowStatement
impl Debug for WindowStatement
§impl Default for WindowStatement
impl Default for WindowStatement
§fn default() -> WindowStatement
fn default() -> WindowStatement
Returns the “default value” for a type. Read more
§impl OrderedStatement for WindowStatement
impl OrderedStatement for WindowStatement
§fn clear_order_by(&mut self) -> &mut WindowStatement
fn clear_order_by(&mut self) -> &mut WindowStatement
Clear order expressions
§fn order_by<T>(&mut self, col: T, order: Order) -> &mut Selfwhere
T: IntoColumnRef,
fn order_by<T>(&mut self, col: T, order: Order) -> &mut Selfwhere T: IntoColumnRef,
Order by column. Read more
§fn order_by_expr(&mut self, expr: SimpleExpr, order: Order) -> &mut Self
fn order_by_expr(&mut self, expr: SimpleExpr, order: Order) -> &mut Self
Order by
SimpleExpr
.§fn order_by_customs<I, T>(&mut self, cols: I) -> &mut Selfwhere
T: ToString,
I: IntoIterator<Item = (T, Order)>,
fn order_by_customs<I, T>(&mut self, cols: I) -> &mut Selfwhere T: ToString, I: IntoIterator<Item = (T, Order)>,
Order by custom string.
§fn order_by_columns<I, T>(&mut self, cols: I) -> &mut Selfwhere
T: IntoColumnRef,
I: IntoIterator<Item = (T, Order)>,
fn order_by_columns<I, T>(&mut self, cols: I) -> &mut Selfwhere T: IntoColumnRef, I: IntoIterator<Item = (T, Order)>,
Order by vector of columns.
§fn order_by_with_nulls<T>(
&mut self,
col: T,
order: Order,
nulls: NullOrdering
) -> &mut Selfwhere
T: IntoColumnRef,
fn order_by_with_nulls<T>( &mut self, col: T, order: Order, nulls: NullOrdering ) -> &mut Selfwhere T: IntoColumnRef,
Order by column with nulls order option. Read more
§fn order_by_expr_with_nulls(
&mut self,
expr: SimpleExpr,
order: Order,
nulls: NullOrdering
) -> &mut Self
fn order_by_expr_with_nulls( &mut self, expr: SimpleExpr, order: Order, nulls: NullOrdering ) -> &mut Self
Order by
SimpleExpr
with nulls order option.§fn order_by_customs_with_nulls<I, T>(&mut self, cols: I) -> &mut Selfwhere
T: ToString,
I: IntoIterator<Item = (T, Order, NullOrdering)>,
fn order_by_customs_with_nulls<I, T>(&mut self, cols: I) -> &mut Selfwhere T: ToString, I: IntoIterator<Item = (T, Order, NullOrdering)>,
Order by custom string with nulls order option.
§fn order_by_columns_with_nulls<I, T>(&mut self, cols: I) -> &mut Selfwhere
T: IntoColumnRef,
I: IntoIterator<Item = (T, Order, NullOrdering)>,
fn order_by_columns_with_nulls<I, T>(&mut self, cols: I) -> &mut Selfwhere T: IntoColumnRef, I: IntoIterator<Item = (T, Order, NullOrdering)>,
Order by vector of columns with nulls order option.
§impl OverStatement for WindowStatement
impl OverStatement for WindowStatement
§fn partition_by<T>(&mut self, col: T) -> &mut Selfwhere
T: IntoColumnRef,
fn partition_by<T>(&mut self, col: T) -> &mut Selfwhere T: IntoColumnRef,
Partition by column.
§fn partition_by_customs<I, T>(&mut self, cols: I) -> &mut Selfwhere
T: ToString,
I: IntoIterator<Item = T>,
fn partition_by_customs<I, T>(&mut self, cols: I) -> &mut Selfwhere T: ToString, I: IntoIterator<Item = T>,
Partition by custom string.
§fn partition_by_columns<I, T>(&mut self, cols: I) -> &mut Selfwhere
T: IntoColumnRef,
I: IntoIterator<Item = T>,
fn partition_by_columns<I, T>(&mut self, cols: I) -> &mut Selfwhere T: IntoColumnRef, I: IntoIterator<Item = T>,
Partition by vector of columns.
Auto Trait Implementations§
impl !RefUnwindSafe for WindowStatement
impl Send for WindowStatement
impl Sync for WindowStatement
impl Unpin for WindowStatement
impl !UnwindSafe for WindowStatement
Blanket Implementations§
source§impl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere T: ?Sized,
source§fn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more