gen-table 0.1.5

gen-table for mysql table convert to rust struct code
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

use once_cell::{self, sync::Lazy};
use std::collections::HashMap;

/// mysql type => rust type
static MYSQL_TYPES: Lazy<HashMap<&str, &str>> = Lazy::new(|| {
    let mut m = HashMap::new();
    let types: Vec<(&str, &str)> = vec![
        ("int", "i64"),
        ("integer", "i64"),
        ("tinyint", "i64"),
        ("smallint", "i64"),
        ("mediumint", "i64"),
        ("bigint", "i64"),
        ("int unsigned", "i64"),
        ("integer unsigned", "i64"),
        ("tinyint unsigned", "i64"),
        ("smallint unsigned", "i64"),
        ("mediumint unsigned", "i64"),
        ("bigint unsigned", "i64"),
        ("bit", "i64"),
        ("bool", "bool"),
        ("enum", "String"),
        ("set", "String"),
        ("varchar", "String"),
        ("char", "String"),
        ("tinytext", "String"),
        ("mediumtext", "String"),
        ("text", "String"),
        ("longtext", "String"),
        ("blob", "String"),
        ("tinyblob", "String"),
        ("mediumblob", "String"),
        ("longblob", "String"),
        ("date", "Duration"),
        ("datetime", "Duration"),
        ("timestamp", "Duration"),
        ("time", "Duration"),
        ("float", "f64"),
        ("double", "f64"),
        ("decimal", "f64"),
        ("binary", "String"),
        ("varbinary", "String"),
        ("json", "String"),
    ];

    for (key, val) in types {
        m.insert(key, val);
    }

    m
});

/// get rust type by mysql type
pub fn get_type(t: &str) -> String {
    let val = MYSQL_TYPES
        .get(t)
        .expect(format!("not found mysql type:{}", t).as_str());

    val.to_string()
}

#[test]
fn test_sql_type() {
    println!("mysql bigint for rust type:{}", get_type("bigint"));
}