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
use crate::DriverType;
pub trait SqlRule {
fn make_where(&self, where_sql: &str) -> String {
let sql = where_sql.trim_start();
if sql.is_empty() {
return String::new();
}
if sql.starts_with(crate::sql::TEMPLATE.order_by.right_space)
|| sql.starts_with(crate::sql::TEMPLATE.group_by.right_space)
|| sql.starts_with(crate::sql::TEMPLATE.limit.right_space)
{
sql.to_string()
} else {
format!(
" {} {} ",
crate::sql::TEMPLATE.r#where.value,
sql.trim_start_matches(crate::sql::TEMPLATE.r#where.right_space)
.trim_start_matches(crate::sql::TEMPLATE.and.right_space)
.trim_start_matches(crate::sql::TEMPLATE.or.right_space)
)
}
}
fn make_left_insert_where(&self, insert_sql: &str, where_sql: &str) -> String {
let sql = where_sql
.trim()
.trim_start_matches(crate::sql::TEMPLATE.r#where.right_space)
.trim_start_matches(crate::sql::TEMPLATE.and.right_space);
if sql.is_empty() {
return insert_sql.to_string();
}
if sql.starts_with(crate::sql::TEMPLATE.order_by.right_space)
|| sql.starts_with(crate::sql::TEMPLATE.group_by.right_space)
|| sql.starts_with(crate::sql::TEMPLATE.limit.right_space)
{
format!(
" {} {} {}",
crate::sql::TEMPLATE.r#where.value,
insert_sql
.trim()
.trim_end_matches(crate::sql::TEMPLATE.and.left_space),
sql
)
} else {
format!(
" {} {} {} {}",
crate::sql::TEMPLATE.r#where.value,
insert_sql
.trim()
.trim_end_matches(crate::sql::TEMPLATE.and.left_space),
crate::sql::TEMPLATE.and.value,
sql
)
}
}
}
impl SqlRule for DriverType {}