sqlint 0.2.2

An abstraction layer for SQL databases.
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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149

use crate::tests::test_api::*;

#[cfg(feature = "bigdecimal")]
use std::str::FromStr;

#[cfg(feature = "bigdecimal")]
use crate::bigdecimal::BigDecimal;

test_type!(tinyint(mysql, "tinyint(4)", Value::Int32(None), Value::int32(i8::MIN), Value::int32(i8::MAX)));

test_type!(tinyint1(mysql, "tinyint(1)", Value::int32(-1), Value::int32(1), Value::int32(0)));

test_type!(tinyint_unsigned(mysql, "tinyint(4) unsigned", Value::Int32(None), Value::int32(0), Value::int32(255)));

test_type!(year(mysql, "year", Value::Int32(None), Value::int32(1984), Value::int32(2049)));

test_type!(smallint(mysql, "smallint", Value::Int32(None), Value::int32(i16::MIN), Value::int32(i16::MAX)));

test_type!(smallint_unsigned(mysql, "smallint unsigned", Value::Int32(None), Value::int32(0), Value::int32(65535)));

test_type!(mediumint(mysql, "mediumint", Value::Int32(None), Value::int32(-8388608), Value::int32(8388607)));

test_type!(mediumint_unsigned(
    mysql,
    "mediumint unsigned",
    Value::Int64(None),
    Value::int64(0),
    Value::int64(16777215)
));

test_type!(int(mysql, "int", Value::Int32(None), Value::int32(i32::MIN), Value::int32(i32::MAX)));

test_type!(int_unsigned(
    mysql,
    "int unsigned",
    Value::Int64(None),
    Value::int64(0),
    Value::int64(2173158296i64),
    Value::int64(4294967295i64)
));

test_type!(int_unsigned_not_null(
    mysql,
    "int unsigned not null",
    Value::int64(0),
    Value::int64(2173158296i64),
    Value::int64(4294967295i64)
));

test_type!(bigint(mysql, "bigint", Value::Int64(None), Value::int64(i64::MIN), Value::int64(i64::MAX)));

#[cfg(feature = "bigdecimal")]
test_type!(decimal(
    mysql,
    "decimal(10,2)",
    Value::Numeric(None),
    Value::numeric(bigdecimal::BigDecimal::from_str("3.14").unwrap())
));

// Highest mantissa on MySQL
#[cfg(feature = "bigdecimal")]
test_type!(decimal_65_6(
    mysql,
    "decimal(65, 6)",
    Value::numeric(BigDecimal::from_str("93431006223456789876545678909876545678903434334567834369999.345678")?),
));

#[cfg(feature = "bigdecimal")]
test_type!(float_decimal(
    mysql,
    "float",
    (Value::Numeric(None), Value::Float(None)),
    (Value::numeric(bigdecimal::BigDecimal::from_str("3.14").unwrap()), Value::float(3.14))
));

#[cfg(feature = "bigdecimal")]
test_type!(double_decimal(
    mysql,
    "double",
    (Value::Numeric(None), Value::Double(None)),
    (Value::numeric(bigdecimal::BigDecimal::from_str("3.14").unwrap()), Value::double(3.14))
));

test_type!(bit1(
    mysql,
    "bit(1)",
    (Value::Bytes(None), Value::Boolean(None)),
    (Value::integer(0), Value::boolean(false)),
    (Value::integer(1), Value::boolean(true)),
));

test_type!(bit64(mysql, "bit(64)", Value::Bytes(None), Value::bytes(vec![0, 0, 0, 0, 0, 6, 107, 58])));

test_type!(char(mysql, "char(255)", Value::Text(None), Value::text("foobar")));
test_type!(float(mysql, "float", Value::Float(None), Value::float(1.12345),));
test_type!(double(mysql, "double", Value::Double(None), Value::double(1.12314124)));
test_type!(varchar(mysql, "varchar(255)", Value::Text(None), Value::text("foobar")));
test_type!(tinytext(mysql, "tinytext", Value::Text(None), Value::text("foobar")));
test_type!(text(mysql, "text", Value::Text(None), Value::text("foobar")));
test_type!(longtext(mysql, "longtext", Value::Text(None), Value::text("foobar")));
test_type!(binary(mysql, "binary(5)", Value::bytes(vec![1, 2, 3, 0, 0])));
test_type!(varbinary(mysql, "varbinary(255)", Value::bytes(vec![1, 2, 3])));

test_type!(mediumtext(mysql, "mediumtext", Value::Text(None), Value::text("foobar")));

test_type!(tinyblob(mysql, "tinyblob", Value::Bytes(None), Value::bytes(vec![1, 2, 3])));

test_type!(mediumblob(mysql, "mediumblob", Value::Bytes(None), Value::bytes(vec![1, 2, 3])));

test_type!(longblob(mysql, "longblob", Value::Bytes(None), Value::bytes(vec![1, 2, 3])));

test_type!(blob(mysql, "blob", Value::Bytes(None), Value::bytes(vec![1, 2, 3])));

test_type!(enum(
    mysql,
    "enum('pollicle_dogs','jellicle_cats')",
    Value::Enum(None),
    Value::enum_variant("jellicle_cats"),
    Value::enum_variant("pollicle_dogs")
));

#[cfg(feature = "json")]
test_type!(json(
    mysql,
    "json",
    Value::Json(None),
    Value::json(serde_json::json!({"this": "is", "a": "json", "number": 2}))
));

#[cfg(feature = "chrono")]
test_type!(date(mysql, "date", Value::Date(None), {
    let dt = chrono::DateTime::parse_from_rfc3339("2020-04-20T00:00:00Z").unwrap();
    Value::datetime(dt.with_timezone(&chrono::Utc))
}));

#[cfg(feature = "chrono")]
test_type!(time(mysql, "time", Value::Time(None), Value::time(chrono::NaiveTime::from_hms_opt(16, 20, 00).unwrap())));

#[cfg(feature = "chrono")]
test_type!(datetime(mysql, "datetime", Value::DateTime(None), {
    let dt = chrono::DateTime::parse_from_rfc3339("2020-02-27T19:10:22Z").unwrap();
    Value::datetime(dt.with_timezone(&chrono::Utc))
}));

#[cfg(feature = "chrono")]
test_type!(timestamp(mysql, "timestamp", {
    let dt = chrono::DateTime::parse_from_rfc3339("2020-02-27T19:10:22Z").unwrap();
    Value::datetime(dt.with_timezone(&chrono::Utc))
}));