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

use crate::util::*;
testcase!(test);
fn test(mut glue: multisql::Glue) {
	use multisql::*;
	glue.execute("SET @variable = 1;").expect("SET variable");
	assert_eq!(
		glue.execute("VALUES (@variable)"),
		Ok(Payload::Select {
			labels: vec![String::from("unnamed_0")],
			rows: vec![Row(vec![Value::I64(1)])]
		})
	);
	make_basic_table!(glue);

	assert_eq!(
		glue.execute("SELECT a + @variable FROM basic"),
		Ok(Payload::Select {
			labels: vec![String::from("unnamed_0")],
			rows: vec![Row(vec![Value::I64(2)])]
		})
	);
	assert_eq!(
		glue.execute("SELECT a FROM basic WHERE @variable = 1"),
		Ok(Payload::Select {
			labels: vec![String::from("a")],
			rows: vec![Row(vec![Value::I64(1)])]
		})
	);
	assert_eq!(
		glue.execute("SELECT a FROM basic WHERE @variable = 0"),
		Ok(Payload::Select {
			labels: vec![String::from("a")],
			rows: vec![]
		})
	);
}