sqlb 0.4.0

Simple, expressive, and progressive SQL Builder for Rust.
Documentation 
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

/// Escape table name.
/// - Surround with `"` if simple table name.
/// - If the text contains a . symbol, ensure to surround each part.
///
/// TODO: needs to handle the . notation (i.e., quote each side of the dot)
pub(crate) fn x_table_name(name: &str) -> String {
	if name.contains('.') {
		name.split('.')
			.map(|part| format!("\"{}\"", part))
			.collect::<Vec<String>>()
			.join(".")
	} else {
		format!("\"{}\"", name)
	}
}

/// Escape column name.
/// - Surround with `"` if simple column name.
/// - Leave column name as is if special character `(` (might need to add more)
///   (this allows function call like `count(*)`)
/// - If the text contains a . symbol, ensure to surround each part.
///
pub(crate) fn x_column_name(name: &str) -> String {
	if name.contains('(') {
		name.to_string()
	} else if name.contains('.') {
		name.split('.')
			.map(|part| format!("\"{}\"", part))
			.collect::<Vec<String>>()
			.join(".")
	} else {
		format!("\"{}\"", name)
	}
}