Trait sea_orm::query::QueryOrder

source · [−]

pub trait QueryOrder: Sized {
    type QueryStatement: OrderedStatement;

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

    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"
);