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
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
use postgres_types::ToSql;
pub enum Join {
Inner(String, String),
Left(String, String),
LeftOuter(String, String),
}
impl Join {
pub fn to_string(&self) -> String {
match self {
Join::Inner(table, constraint) => format!("INNER JOIN {} ON {}", table, constraint),
Join::Left(table, constraint) => format!("LEFT JOIN {} ON {}", table, constraint),
Join::LeftOuter(table, constraint) => {
format!("LEFT OUTER JOIN {} ON {}", table, constraint)
}
}
}
}
pub trait QueryBuilder {
fn add_param<T: 'static + ToSql + Sync + Clone>(&mut self, value: T) -> usize;
fn get_query(&self) -> String;
fn get_ref_params(self) -> Vec<&'static (dyn ToSql + Sync)>;
}
pub trait QueryBuilderWithWhere: QueryBuilder {
/// Add where condition to query
///
/// # Examples
///
/// ```
/// use postgres_querybuilder::SelectBuilder;
/// use postgres_querybuilder::prelude::QueryBuilder;
/// use postgres_querybuilder::prelude::QueryBuilderWithWhere;
///
/// let user_password = "password".to_string();
/// let mut builder = SelectBuilder::new("users");
/// let first = builder.add_param(18);
/// let second = builder.add_param(28);
/// let condition = format!("age = ${} OR age = ${}", first, second);
/// builder.where_condition(condition.as_str());
///
/// assert_eq!(builder.get_query(), "SELECT * FROM users WHERE age = $1 OR age = $2");
/// ```
fn where_condition(&mut self, raw: &str) -> &mut Self;
/// Add where equal condition to query
///
/// # Examples
///
/// ```
/// use postgres_querybuilder::SelectBuilder;
/// use postgres_querybuilder::prelude::QueryBuilder;
/// use postgres_querybuilder::prelude::QueryBuilderWithWhere;
///
/// let user_password = "password".to_string();
/// let mut builder = SelectBuilder::new("users");
/// builder.where_eq("id", 42);
///
/// assert_eq!(builder.get_query(), "SELECT * FROM users WHERE id = $1");
/// ```
fn where_eq<T: 'static + ToSql + Sync + Clone>(&mut self, field: &str, value: T) -> &mut Self {
let index = self.add_param(value);
let condition = format!("{} = ${}", field, index);
self.where_condition(condition.as_str());
self
}
/// Add where not equal condition to query
///
/// # Examples
///
/// ```
/// use postgres_querybuilder::SelectBuilder;
/// use postgres_querybuilder::prelude::QueryBuilder;
/// use postgres_querybuilder::prelude::QueryBuilderWithWhere;
///
/// let user_password = "password".to_string();
/// let mut builder = SelectBuilder::new("users");
/// builder.where_ne("id", 42);
///
/// assert_eq!(builder.get_query(), "SELECT * FROM users WHERE id <> $1");
/// ```
fn where_ne<T: 'static + ToSql + Sync + Clone>(&mut self, field: &str, value: T) -> &mut Self {
let index = self.add_param(value);
let condition = format!("{} <> ${}", field, index);
self.where_condition(condition.as_str());
self
}
}
pub trait QueryBuilderWithGroupBy {
fn group_by(&mut self, field: &str) -> &mut Self;
}
pub trait QueryBuilderWithLimit {
fn limit(&mut self, limit: i64) -> &mut Self;
}
pub trait QueryBuilderWithOffset {
fn offset(&mut self, offset: i64) -> &mut Self;
}
pub trait QueryBuilderWithJoin {
fn inner_join(&mut self, table_name: &str, relation: &str) -> &mut Self;
fn left_join(&mut self, table_name: &str, relation: &str) -> &mut Self;
fn left_outer_join(&mut self, table_name: &str, relation: &str) -> &mut Self;
}
pub trait QueryBuilderWithSet {
fn set<T: 'static + ToSql + Sync + Clone>(&mut self, field: &str, value: T) -> &mut Self;
fn set_computed(&mut self, field: &str, value: &str) -> &mut Self;
}
pub enum Order {
Asc(String),
Desc(String),
}
impl Order {
pub fn to_string(&self) -> String {
match self {
Order::Asc(column) => format!("{} ASC", column),
Order::Desc(column) => format!("{} DESC", column),
}
}
}
pub trait QueryBuilderWithOrder {
fn order_by(&mut self, field: Order);
}
pub trait QueryBuilderWithQueries {
fn with_query(&mut self, name: &str, query: &str) -> &mut Self;
}