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) {
	glue.execute(
		r#"
		CREATE TABLE basic (
			a INTEGER
		)
	"#,
	)
	.expect("CREATE TABLE basic");

	assert_success!(
		glue,
		"
			CREATE TABLE CreateTable1 (
				id INTEGER NULL,
				num INTEGER,
				name TEXT
			)"
	);
	assert_error!(
		glue,
		"
			CREATE TABLE CreateTable1 (
				id INTEGER NULL,
				num INTEGER,
				name TEXT
			)",
		multisql::AlterError::TableAlreadyExists("CreateTable1".to_owned())
	);
	assert_success!(
		glue,
		"
			CREATE TABLE IF NOT EXISTS CreateTable2 (
				id INTEGER NULL,
				num INTEGER,
				name TEXT
			)"
	);
	assert_success!(
		glue,
		"CREATE TABLE IF NOT EXISTS CreateTable2 (
				id2 INTEGER NULL,
				)"
	);
	assert_success!(glue, "INSERT INTO CreateTable2 VALUES (NULL, 1, '1');");
	assert_error!(
		glue,
		"CREATE TABLE Gluery (id SOMEWHAT);",
		multisql::AlterError::UnsupportedDataType("SOMEWHAT".to_owned())
	);
	assert_error!(
		glue,
		"CREATE TABLE Gluery (id INTEGER CHECK (true));",
		multisql::AlterError::UnsupportedColumnOption("CHECK (true)".to_owned())
	);
	assert_error!(
		glue,
		"
			CREATE TABLE CreateTable3 (
				id INTEGER,
				ratio FLOAT UNIQUE
			)",
		multisql::AlterError::UnsupportedDataTypeForUniqueColumn(
			"ratio".to_owned(),
			"FLOAT".to_owned(),
		)
	);
}