logo

Trait sea_orm::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), Global>
    ) -> &mut Self
    where
        T: ToString,
    { ... }

    fn order_by_columns<T>(
        &mut self, 
        cols: Vec<(T, Order), Global>
    ) -> &mut Self
    where
        T: IntoColumnRef,
    { ... }

    fn order_by_table_columns<T, C>(
        &mut self, 
        cols: Vec<(T, C, Order), Global>
    ) -> &mut Self
    where
        T: IntoIden,
        C: IntoIden,
    { ... }
}

Provided methods

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"#
);
👎 Deprecated since 0.9.0:

Please use the [OrderedStatement::order_by] with a tuple as [ColumnRef]

Order by SimpleExpr.

Order by custom string.

Order by vector of columns.

👎 Deprecated since 0.9.0:

Please use the [OrderedStatement::order_by_columns] with a tuple as [ColumnRef]

Implementations on Foreign Types

Implementors