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
63
64
65
66
67
68
69
70

use crate::util::*;
testcase!(test);
fn test(mut glue: multisql::Glue) {
	execute!(
		glue,
		"
			CREATE TABLE Test (
				id INTEGER DEFAULT 1,
				num INTEGER,
				flag BOOLEAN NULL DEFAULT false
			)
		"
	);

	execute!(
		glue,
		"
			INSERT INTO Test
			VALUES (
				8, 80, true
			);
		"
	);
	execute!(
		glue,
		"
			INSERT INTO Test (
				num
			) VALUES (
				10
			);
		"
	);
	execute!(
		glue,
		"
			INSERT INTO Test (
				num,
				id
			) VALUES (
				20,
				2
			);
		"
	);
	execute!(
		glue,
		"
			INSERT INTO Test (
				num,
				flag
			) VALUES (
				30,
				NULL
			), (
				40,
				true
			);
		"
	);

	assert_select!(glue, r#"
			SELECT
				*
			FROM
				Test
			WHERE
				flag IS NOT NULL
		"# => id = I64, num = I64, flag = Bool: (8, 80, true), (1, 10, false), (2, 20, false), /*(1, 30, NULL),*/ (1, 40, true));
}