Trait sea_query::query::OrderedStatement [−][src]
pub trait OrderedStatement { fn order_by<T>(&mut self, col: T, order: Order) -> &mut Self
where
T: IntoColumnRef, { ... } fn order_by_tbl<T, C>(
&mut self,
table: T,
col: C,
order: Order
) -> &mut Self
where
T: IntoIden,
C: IntoIden, { ... } fn order_by_expr(&mut self, expr: SimpleExpr, order: Order) -> &mut Self { ... } fn order_by_customs<T>(&mut self, cols: Vec<(T, Order)>) -> &mut Self
where
T: ToString, { ... } fn order_by_columns<T>(&mut self, cols: Vec<(T, Order)>) -> &mut Self
where
T: IntoColumnRef, { ... } fn order_by_table_columns<T, C>(
&mut self,
cols: Vec<(T, C, Order)>
) -> &mut Self
where
T: IntoIden,
C: IntoIden, { ... } }
Provided methods
fn order_by<T>(&mut self, col: T, order: Order) -> &mut Self where
T: IntoColumnRef,
[src]
fn order_by<T>(&mut self, col: T, order: Order) -> &mut Self where
T: IntoColumnRef,
[src]Order by column.
Examples
use sea_query::{*, tests_cfg::*}; let query = Query::select() .column(Glyph::Aspect) .from(Glyph::Table) .and_where(Expr::expr(Expr::col(Glyph::Aspect).if_null(0)).gt(2)) .order_by(Glyph::Image, Order::Desc) .order_by((Glyph::Table, Glyph::Aspect), Order::Asc) .to_owned(); assert_eq!( query.to_string(MysqlQueryBuilder), r#"SELECT `aspect` FROM `glyph` WHERE IFNULL(`aspect`, 0) > 2 ORDER BY `image` DESC, `glyph`.`aspect` ASC"# );
fn order_by_tbl<T, C>(&mut self, table: T, col: C, order: Order) -> &mut Self where
T: IntoIden,
C: IntoIden,
[src]
fn order_by_tbl<T, C>(&mut self, table: T, col: C, order: Order) -> &mut Self where
T: IntoIden,
C: IntoIden,
[src]π 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
[src]
fn order_by_expr(&mut self, expr: SimpleExpr, order: Order) -> &mut Self
[src]Order by SimpleExpr
.
fn order_by_customs<T>(&mut self, cols: Vec<(T, Order)>) -> &mut Self where
T: ToString,
[src]
fn order_by_customs<T>(&mut self, cols: Vec<(T, Order)>) -> &mut Self where
T: ToString,
[src]Order by custom string.
fn order_by_columns<T>(&mut self, cols: Vec<(T, Order)>) -> &mut Self where
T: IntoColumnRef,
[src]
fn order_by_columns<T>(&mut self, cols: Vec<(T, Order)>) -> &mut Self where
T: IntoColumnRef,
[src]Order by vector of columns.
Implementors
impl OrderedStatement for DeleteStatement
[src]
impl OrderedStatement for DeleteStatement
[src]fn add_order_by(&mut self, order: OrderExpr) -> &mut Self
[src]
impl OrderedStatement for SelectStatement
[src]
impl OrderedStatement for SelectStatement
[src]fn add_order_by(&mut self, order: OrderExpr) -> &mut Self
[src]
impl OrderedStatement for UpdateStatement
[src]
impl OrderedStatement for UpdateStatement
[src]