Trait sea_orm::query::QueryOrder

source ·

pub trait QueryOrder: Sized {
    type QueryStatement: OrderedStatement;

    // Required method
    fn query(&mut self) -> &mut SelectStatement;

    // Provided methods
    fn order_by<C>(self, col: C, ord: Order) -> Self
       where C: IntoSimpleExpr { ... }
    fn order_by_asc<C>(self, col: C) -> Self
       where C: IntoSimpleExpr { ... }
    fn order_by_desc<C>(self, col: C) -> Self
       where C: IntoSimpleExpr { ... }
}

Expand description

Performs ORDER BY operations

Required Associated Types§

source

type QueryStatement: OrderedStatement

Required Methods§

source

fn query(&mut self) -> &mut SelectStatement

Add the query to perform an ORDER BY operation

Provided Methods§

source

fn order_by<C>(self, col: C, ord: Order) -> Self
where C: IntoSimpleExpr,

Add an order_by expression

use sea_orm::{entity::*, query::*, tests_cfg::cake, DbBackend};

assert_eq!(
    cake::Entity::find()
        .order_by(cake::Column::Id, Order::Asc)
        .order_by(cake::Column::Name, Order::Desc)
        .build(DbBackend::MySql)
        .to_string(),
    "SELECT `cake`.`id`, `cake`.`name` FROM `cake` ORDER BY `cake`.`id` ASC, `cake`.`name` DESC"
);

source

fn order_by_asc<C>(self, col: C) -> Self
where C: IntoSimpleExpr,

Add an order_by expression (ascending)

use sea_orm::{entity::*, query::*, tests_cfg::cake, DbBackend};

assert_eq!(
    cake::Entity::find()
        .order_by_asc(cake::Column::Id)
        .build(DbBackend::MySql)
        .to_string(),
    "SELECT `cake`.`id`, `cake`.`name` FROM `cake` ORDER BY `cake`.`id` ASC"
);

source

fn order_by_desc<C>(self, col: C) -> Self
where C: IntoSimpleExpr,

Add an order_by expression (descending)

use sea_orm::{entity::*, query::*, tests_cfg::cake, DbBackend};

assert_eq!(
    cake::Entity::find()
        .order_by_desc(cake::Column::Id)
        .build(DbBackend::MySql)
        .to_string(),
    "SELECT `cake`.`id`, `cake`.`name` FROM `cake` ORDER BY `cake`.`id` DESC"
);