1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
use crate::{expr::*, types::*};
pub trait OrderedStatement {
#[doc(hidden)]
// Implementation for the trait.
fn add_order_by(&mut self, order: OrderExpr) -> &mut Self;
/// 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<T>(&mut self, col: T, order: Order) -> &mut Self
where
T: IntoColumnRef,
{
self.add_order_by(OrderExpr {
expr: SimpleExpr::Column(col.into_column_ref()),
order,
})
}
#[deprecated(
since = "0.9.0",
note = "Please use the [`OrderedStatement::order_by`] with a tuple as [`ColumnRef`]"
)]
fn order_by_tbl<T, C>(&mut self, table: T, col: C, order: Order) -> &mut Self
where
T: IntoIden,
C: IntoIden,
{
self.order_by((table.into_iden(), col.into_iden()), order)
}
/// Order by [`SimpleExpr`].
fn order_by_expr(&mut self, expr: SimpleExpr, order: Order) -> &mut Self {
self.add_order_by(OrderExpr { expr, order })
}
/// Order by custom string.
fn order_by_customs<T>(&mut self, cols: Vec<(T, Order)>) -> &mut Self
where
T: ToString,
{
cols.into_iter().for_each(|(c, order)| {
self.add_order_by(OrderExpr {
expr: SimpleExpr::Custom(c.to_string()),
order,
});
});
self
}
/// Order by vector of columns.
fn order_by_columns<T>(&mut self, cols: Vec<(T, Order)>) -> &mut Self
where
T: IntoColumnRef,
{
cols.into_iter().for_each(|(c, order)| {
self.add_order_by(OrderExpr {
expr: SimpleExpr::Column(c.into_column_ref()),
order,
});
});
self
}
#[deprecated(
since = "0.9.0",
note = "Please use the [`OrderedStatement::order_by_columns`] with a tuple as [`ColumnRef`]"
)]
fn order_by_table_columns<T, C>(&mut self, cols: Vec<(T, C, Order)>) -> &mut Self
where
T: IntoIden,
C: IntoIden,
{
self.order_by_columns(
cols.into_iter()
.map(|(t, c, o)| ((t.into_iden(), c.into_iden()), o))
.collect(),
)
}
}