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

use crate::util::*;
testcase!(test);
fn test(_glue: multisql::Glue) {
	/* TODO: Redo this test */
	use {multisql::Value::*, sqlparser::ast::DataType::*};

	macro_rules! cast {
		($input: expr => $data_type: expr, $expected: expr) => {
			let found = $input.cast_datatype(&$data_type).unwrap();

			match ($expected, found) {
				(Null, Null) => {}
				(expected, found) => {
					assert_eq!(expected, found);
				}
			}
		};
	}

	assert_ne!(Null, Null);
	assert_eq!(Bool(true), Bool(true));
	assert_eq!(I64(1), I64(1));
	assert_eq!(F64(6.11), F64(6.11));
	assert_eq!(Str("Glue".to_owned()), Str("Glue".to_owned()));

	// Same as
	cast!(Bool(true)            => Boolean      , Bool(true));
	cast!(Str("a".to_owned())   => Text         , Str("a".to_owned()));
	cast!(I64(1)                => Int(None)    , I64(1));
	cast!(F64(1.0)              => Float(None)  , F64(1.0));

	// Boolean
	cast!(Str("true".to_owned())    => Boolean, Bool(true));
	cast!(Str("false".to_owned())   => Boolean, Bool(false));
	cast!(I64(1)                    => Boolean, Bool(true));
	cast!(I64(0)                    => Boolean, Bool(false));
	cast!(F64(1.0)                  => Boolean, Bool(true));
	cast!(F64(0.0)                  => Boolean, Bool(false));
	cast!(Null                      => Boolean, Null);

	// Integer
	cast!(Bool(true)            => Int(None), I64(1));
	cast!(Bool(false)           => Int(None), I64(0));
	cast!(F64(1.1)              => Int(None), I64(1));
	cast!(Str("11".to_owned())  => Int(None), I64(11));
	cast!(Null                  => Int(None), Null);

	/*// Time // TODO
	cast!(Str("11:00".to_owned())  => Time, I64(11*60*60));
	cast!(Str("1:00PM".to_owned())  => Time, I64((12+1)*60*60));
	cast!(Str("23:35".to_owned())  => Time, I64((23*60*60) + 35*60));
	*/

	// Float
	cast!(Bool(true)            => Float(None), F64(1.0));
	cast!(Bool(false)           => Float(None), F64(0.0));
	cast!(I64(1)                => Float(None), F64(1.0));
	cast!(Str("11".to_owned())  => Float(None), F64(11.0));
	cast!(Null                  => Float(None), Null);

	// Text
	cast!(Bool(true)    => Text, Str("true".to_owned()));
	cast!(Bool(false)   => Text, Str("false".to_owned()));
	cast!(I64(11)       => Text, Str("11".to_owned()));
	cast!(F64(1.0)      => Text, Str("1.0".to_owned()));
	cast!(Null          => Text, Null);
}