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
99
100
101
102
103
104
105
106
use {QuerySource, Table};
use query_builder::*;
use expression::SelectableExpression;
use types::Nullable;
#[derive(Debug, Clone, Copy)]
#[doc(hidden)]
pub struct InnerJoinSource<Left, Right> {
left: Left,
right: Right,
}
impl<Left, Right> InnerJoinSource<Left, Right> {
pub fn new(left: Left, right: Right) -> Self {
InnerJoinSource {
left: left,
right: right,
}
}
}
impl<Left, Right> QuerySource for InnerJoinSource<Left, Right> where
Left: Table + JoinTo<Right>,
Right: Table,
{
fn from_clause(&self, out: &mut QueryBuilder) -> BuildQueryResult {
try!(self.left.from_clause(out));
out.push_sql(" INNER JOIN ");
self.left.join_sql(out)
}
}
impl<Left, Right> AsQuery for InnerJoinSource<Left, Right> where
Left: Table + JoinTo<Right>,
Right: Table,
(Left::AllColumns, Right::AllColumns): SelectableExpression<
InnerJoinSource<Left, Right>,
(Left::SqlType, Right::SqlType),
>,
{
type SqlType = (Left::SqlType, Right::SqlType);
type Query = SelectStatement<
(Left::SqlType, Right::SqlType),
(Left::AllColumns, Right::AllColumns),
Self,
>;
fn as_query(self) -> Self::Query {
SelectStatement::simple((Left::all_columns(), Right::all_columns()), self)
}
}
#[derive(Debug, Clone, Copy)]
#[doc(hidden)]
pub struct LeftOuterJoinSource<Left, Right> {
left: Left,
right: Right,
}
impl<Left, Right> LeftOuterJoinSource<Left, Right> {
pub fn new(left: Left, right: Right) -> Self {
LeftOuterJoinSource {
left: left,
right: right,
}
}
}
impl<Left, Right> QuerySource for LeftOuterJoinSource<Left, Right> where
Left: Table + JoinTo<Right>,
Right: Table,
{
fn from_clause(&self, out: &mut QueryBuilder) -> BuildQueryResult {
try!(self.left.from_clause(out));
out.push_sql(" LEFT OUTER JOIN ");
self.left.join_sql(out)
}
}
impl<Left, Right> AsQuery for LeftOuterJoinSource<Left, Right> where
Left: Table + JoinTo<Right>,
Right: Table,
(Left::AllColumns, Right::AllColumns): SelectableExpression<
LeftOuterJoinSource<Left, Right>,
(Left::SqlType, Nullable<Right::SqlType>),
>,
{
type SqlType = (Left::SqlType, Nullable<Right::SqlType>);
type Query = SelectStatement<
(Left::SqlType, Nullable<Right::SqlType>),
(Left::AllColumns, Right::AllColumns),
Self,
>;
fn as_query(self) -> Self::Query {
SelectStatement::simple((Left::all_columns(), Right::all_columns()), self)
}
}
pub trait JoinTo<T: Table>: Table {
#[doc(hidden)]
fn join_sql(&self, out: &mut QueryBuilder) -> BuildQueryResult;
}