Struct migration::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_tbl<T, C>(&mut self, table: T, col: C, order: Order) -> &mut Selfwhere
T: IntoIden,
C: IntoIden,
fn order_by_tbl<T, C>(&mut self, table: T, col: C, order: Order) -> &mut Selfwhere T: IntoIden, C: IntoIden,
👎Deprecated since 0.9.0: Please use the [
OrderedStatement::order_by
] with a tuple as [ColumnRef
]§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<T>(&mut self, cols: Vec<(T, Order), Global>) -> &mut Selfwhere
T: ToString,
fn order_by_customs<T>(&mut self, cols: Vec<(T, Order), Global>) -> &mut Selfwhere T: ToString,
Order by custom string.
§fn order_by_columns<T>(&mut self, cols: Vec<(T, Order), Global>) -> &mut Selfwhere
T: IntoColumnRef,
fn order_by_columns<T>(&mut self, cols: Vec<(T, Order), Global>) -> &mut Selfwhere T: IntoColumnRef,
Order by vector of columns.
§fn order_by_table_columns<T, C>(
&mut self,
cols: Vec<(T, C, Order), Global>
) -> &mut Selfwhere
T: IntoIden,
C: IntoIden,
fn order_by_table_columns<T, C>( &mut self, cols: Vec<(T, C, Order), Global> ) -> &mut Selfwhere T: IntoIden, C: IntoIden,
👎Deprecated since 0.9.0: Please use the [
OrderedStatement::order_by_columns
] with a tuple as [ColumnRef
]§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<T>(
&mut self,
cols: Vec<(T, Order, NullOrdering), Global>
) -> &mut Selfwhere
T: ToString,
fn order_by_customs_with_nulls<T>( &mut self, cols: Vec<(T, Order, NullOrdering), Global> ) -> &mut Selfwhere T: ToString,
Order by custom string with nulls order option.
§fn order_by_columns_with_nulls<T>(
&mut self,
cols: Vec<(T, Order, NullOrdering), Global>
) -> &mut Selfwhere
T: IntoColumnRef,
fn order_by_columns_with_nulls<T>( &mut self, cols: Vec<(T, Order, NullOrdering), Global> ) -> &mut Selfwhere T: IntoColumnRef,
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<T>(&mut self, cols: Vec<T, Global>) -> &mut Selfwhere
T: ToString,
fn partition_by_customs<T>(&mut self, cols: Vec<T, Global>) -> &mut Selfwhere T: ToString,
Partition by custom string.
§fn partition_by_columns<T>(&mut self, cols: Vec<T, Global>) -> &mut Selfwhere
T: IntoColumnRef,
fn partition_by_columns<T>(&mut self, cols: Vec<T, Global>) -> &mut Selfwhere T: IntoColumnRef,
Partition by vector of columns.