multisql 0.4.3

MultiSQL
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
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

use {
	super::Glue,
	crate::{
		recipe::{Recipe, RecipeUtilities},
		Payload, Result, Value,
	},
	futures::executor::block_on,
};

pub trait ParameterValue {
	fn into_recipe(self) -> Recipe;
}

#[macro_export]
macro_rules! INSERT {
	{$glue:expr, INTO $database:ident.$table:ident ($($column:ident),+) VALUES $(($($value:expr),+)),+} => {
		$glue.insert(Some(stringify!($database)), stringify!($table), &[$(stringify!($column)),+], vec![$(vec![$($value.into()),+]),+])
	};
	{$glue:expr, INTO $table:ident ($($column:ident),+) VALUES $(($($value:expr),+)),+} => {
		$glue.insert(None, stringify!($table), &[$(stringify!($column)),+], vec![$(vec![$($value.into()),+]),+])
	};
}

/// ## Insert (`INSERT`)
impl Glue {
	pub fn insert(
		&mut self,
		database: Option<&str>,
		table: &str,
		columns: &[&str],
		recipes: Vec<Vec<Recipe>>,
	) -> Result<Payload> {
		let values = recipes
			.into_iter()
			.map(|recipes| {
				recipes
					.into_iter()
					.map(|recipe| recipe.simplify_by_basic()?.confirm())
					.collect::<Result<Vec<Value>>>()
			})
			.collect::<Result<Vec<Vec<Value>>>>()?;
		block_on(self.true_insert(
			&database.map(|db| db.to_string()),
			table,
			columns,
			values,
			None,
			false,
		))
	}
}

#[test]
fn test() {
	use crate::{Connection, Glue};
	let db = Connection::Memory.try_into().unwrap();
	let mut glue = Glue::new(String::from("test"), db);
	glue.execute("CREATE TABLE basic (a INT)").unwrap();
	glue.insert(None, "basic", &["a"], vec![vec![2.into()]])
		.unwrap();
	INSERT! {glue, INTO basic (a) VALUES (2)}.unwrap();
}