sqlrender-impl 0.1.0

Internal implementation details for SqlRender.
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
35
36

use super::Table;
use quote::quote_spanned;

/// INSERT INTO tablename (name1, name2...) VALUES (?1, ?2...)
pub(super) fn insert(table: &Table) -> proc_macro2::TokenStream {
	let sql = makesql_insert(table);

	quote_spanned! { table.span =>
		fn insert_sql(&self) -> Result<String, ::sqlrender::Error> {
			assert!(self.id.is_none());
			let statement = #sql;
			Ok(statement.to_string())
		}
	}
}

fn makesql_insert(table: &Table) -> String {
	format!(
		r#"INSERT INTO `{}` ({}) VALUES ({})"#,
		table.name,
		table
			.columns
			.iter()
			.filter(|c| c.name != "id" && c.name != "deleted_at")
			.map(|c| format!("`{}`", c.name))
			.collect::<Vec<_>>()
			.join(", "),
		table
			.columns
			.iter()
			.filter(|c| c.name != "id" && c.name != "deleted_at")
			.map(|_| "?")
			.collect::<Vec<_>>()
			.join(", ")
	)
}