toasty-driver-integration-suite 0.5.0

Integration test suite for Toasty database drivers
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

use crate::prelude::*;

#[driver_test(id(ID), requires(sql), scenario(crate::scenarios::two_models))]
pub async fn batch_two_models(t: &mut Test) -> Result<()> {
    let mut db = setup(t).await;

    User::create().name("Alice").exec(&mut db).await?;
    User::create().name("Bob").exec(&mut db).await?;
    Post::create().title("Hello").exec(&mut db).await?;

    let (users, posts): (Vec<User>, Vec<Post>) = toasty::batch((
        User::filter_by_name("Alice"),
        Post::filter_by_title("Hello"),
    ))
    .exec(&mut db)
    .await?;

    assert_struct!(users, [{ name: "Alice" }]);
    assert_struct!(posts, [{ title: "Hello" }]);

    Ok(())
}

#[driver_test(id(ID), requires(sql), scenario(crate::scenarios::two_models))]
pub async fn batch_one_empty(t: &mut Test) -> Result<()> {
    let mut db = setup(t).await;

    User::create().name("Alice").exec(&mut db).await?;

    let (users, posts): (Vec<User>, Vec<Post>) = toasty::batch((
        User::filter_by_name("Alice"),
        Post::filter_by_title("nonexistent"),
    ))
    .exec(&mut db)
    .await?;

    assert_struct!(users, [{ name: "Alice" }]);
    assert!(posts.is_empty());

    Ok(())
}

#[driver_test(id(ID), requires(sql), scenario(crate::scenarios::two_models))]
pub async fn batch_same_model(t: &mut Test) -> Result<()> {
    let mut db = setup(t).await;

    User::create().name("Alice").exec(&mut db).await?;
    User::create().name("Bob").exec(&mut db).await?;
    User::create().name("Carol").exec(&mut db).await?;

    let (alices, bobs): (Vec<User>, Vec<User>) =
        toasty::batch((User::filter_by_name("Alice"), User::filter_by_name("Bob")))
            .exec(&mut db)
            .await?;

    assert_struct!(alices, [{ name: "Alice" }]);
    assert_struct!(bobs, [{ name: "Bob" }]);

    Ok(())
}

#[driver_test(id(ID), requires(sql), scenario(crate::scenarios::two_models))]
pub async fn batch_three_queries(t: &mut Test) -> Result<()> {
    let mut db = setup(t).await;

    User::create().name("Alice").exec(&mut db).await?;
    User::create().name("Bob").exec(&mut db).await?;
    User::create().name("Carol").exec(&mut db).await?;

    let (alices, bobs, carols): (Vec<User>, Vec<User>, Vec<User>) = toasty::batch((
        User::filter_by_name("Alice"),
        User::filter_by_name("Bob"),
        User::filter_by_name("Carol"),
    ))
    .exec(&mut db)
    .await?;

    assert_struct!(alices, [{ name: "Alice" }]);
    assert_struct!(bobs, [{ name: "Bob" }]);
    assert_struct!(carols, [{ name: "Carol" }]);

    Ok(())
}

#[driver_test(id(ID), requires(sql), scenario(crate::scenarios::two_models))]
pub async fn batch_both_empty(t: &mut Test) -> Result<()> {
    let mut db = setup(t).await;

    let (users, posts): (Vec<User>, Vec<Post>) = toasty::batch((
        User::filter_by_name("nobody"),
        Post::filter_by_title("nothing"),
    ))
    .exec(&mut db)
    .await?;

    assert!(users.is_empty());
    assert!(posts.is_empty());

    Ok(())
}

#[driver_test(id(ID), requires(sql), scenario(crate::scenarios::two_models))]
pub async fn batch_select_and_create(t: &mut Test) -> Result<()> {
    let mut db = setup(t).await;

    User::create().name("Alice").exec(&mut db).await?;

    let (users, created): (Vec<User>, User) =
        toasty::batch((User::filter_by_name("Alice"), User::create().name("Bob")))
            .exec(&mut db)
            .await?;

    assert_struct!(users, [{ name: "Alice" }]);
    assert_eq!(created.name, "Bob");

    // Verify Bob was actually persisted
    let res = User::filter_by_name("Bob").exec(&mut db).await?;
    assert_struct!(res, [{ name: "Bob" }]);

    Ok(())
}