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

use crate::util::*;
testcase!(test);
fn test(mut glue: multisql::Glue) {
	execute!(glue, "CREATE TABLE TableA (id INTEGER);");
	execute!(glue, "INSERT INTO TableA (id) VALUES (1);");

	assert_error!(glue, "COMMIT;", multisql::ExecuteError::QueryNotSupported);
	assert_error!(
		glue,
		"INSERT INTO Nothing VALUES (1);",
		multisql::ExecuteError::TableNotExists
	);
	assert_error!(
		glue,
		"UPDATE Nothing SET a = 1;",
		multisql::ExecuteError::TableNotExists
	);
	assert_error!(
		glue,
		"SELECT * FROM Nothing;",
		multisql::FetchError::TableNotFound(String::from("Nothing"))
	);
	assert_error!(
		glue,
		"SELECT * FROM TableA JOIN (SELECT * FROM TableB) as TableC ON 1 = 1",
		multisql::JoinError::UnimplementedTableType
	);
	assert_error!(
		glue,
		"SELECT * FROM TableA WHERE id = (SELECT id FROM TableA WHERE id = 2);",
		multisql::ManualError::UnimplementedSubquery
	);
	assert_error!(
		glue,
		"SELECT * FROM TableA WHERE noname = 1;",
		multisql::RecipeError::MissingColumn(vec![String::from("noname")])
	);
	assert_error!(
		glue,
		"INSERT INTO TableA (id2) VALUES (1);",
		multisql::ValidateError::ColumnNotFound(String::from("id2"))
	);
	assert_error!(
		glue,
		"INSERT INTO TableA (id2, id) VALUES (100);",
		multisql::ValidateError::ColumnNotFound(String::from("id2"))
	);
	assert_error!(
		glue,
		"INSERT INTO TableA VALUES (100), (100, 200);",
		multisql::ValidateError::WrongNumberOfValues
	);
	assert_error!(
		glue,
		"SELECT * FROM TableA Where id = X'123';",
		multisql::ValueError::UnimplementedLiteralType
	);
}