klickhouse 0.15.2

Klickhouse is a pure Rust SDK for working with Clickhouse with the native protocol in async environments with minimal boilerplate and maximal performance.
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

#[derive(klickhouse::Row, Debug, Default, PartialEq, Clone)]
pub struct Nest {
    nest_string: String,
    nest_u64: Option<u64>,
    nest_null_string: Option<String>,
    nest_i16: i16,
}

#[derive(klickhouse::Row, Debug, Default, PartialEq, Clone)]
pub struct TestSerializeNested {
    #[klickhouse(nested)]
    nest: Vec<Nest>,
}

// used to test compilation with multiple nested entries
#[allow(unused)]
#[derive(klickhouse::Row, Debug, Default)]
struct TestSerializeNested2 {
    #[klickhouse(nested)]
    nest: Vec<Nest>,
    #[klickhouse(nested)]
    nest2: Vec<Nest>,
}

#[tokio::test]
async fn test_client() {
    let _ = env_logger::builder()
        .filter_level(log::LevelFilter::Info)
        .try_init();
    let client = super::get_client().await;

    super::prepare_table(
        "test_nested",
        r"
        nest Nested
        (
            nest_string String,
            nest_u64 Nullable(UInt64),
            nest_null_string Nullable(String),
            nest_i16 Int16
        ),
    ",
        &client,
    )
    .await;

    let items = vec![
        TestSerializeNested {
            nest: vec![
                Nest {
                    nest_string: "nest1".to_string(),
                    nest_u64: Some(1),
                    nest_null_string: None,
                    nest_i16: 32,
                },
                Nest {
                    nest_string: "nest2".to_string(),
                    nest_u64: Some(2),
                    nest_null_string: None,
                    nest_i16: 64,
                },
            ],
        },
        TestSerializeNested::default(),
    ];

    client
        .insert_native_block("INSERT INTO test_nested FORMAT Native", items.clone())
        .await
        .unwrap();

    let items2= client
        .query_collect::<TestSerializeNested>("SELECT nest.nest_string, nest.nest_u64, nest.nest_null_string, nest.nest_i16 FROM test_nested")
        .await
        .unwrap();
    assert_eq!(items, items2);
}