juniper-eager-loading 0.5.1

Eliminate N+1 query bugs when using Juniper
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

#[macro_use]
extern crate diesel;

use static_assertions::assert_impl_all;
use diesel::prelude::*;
use juniper_eager_loading::{LoadFrom, impl_load_from_for_diesel_mysql};

table! {
    users (id) {
        id -> Integer,
    }
}

table! {
    companies (id) {
        id -> Integer,
    }
}

table! {
    employments (id) {
        id -> Integer,
        user_id -> Integer,
        company_id -> Integer,
    }
}

#[derive(Queryable)]
struct User {
    id: i32,
}

#[derive(Queryable)]
struct Company {
    id: i32,
}

#[derive(Queryable)]
struct Employment {
    id: i32,
    user_id: i32,
    company_id: i32,
}

struct Context {
    db: SqliteConnection,
}

impl Context {
    fn db(&self) -> &SqliteConnection {
        &self.db
    }
}

impl_load_from_for_diesel_mysql! {
    (
        error = diesel::result::Error,
        context = Context,
    ) => {
        i32 -> (users, User),
        i32 -> (companies, Company),
        i32 -> (employments, Employment),
        User.id -> (employments.user_id, Employment),
        Company.id -> (employments.company_id, Employment),
        Employment.company_id -> (companies.id, Company),
        Employment.user_id -> (users.id, User),
    }
}

assert_impl_all!(User: LoadFrom<i32>, LoadFrom<Employment>, LoadFrom<Employment>);
assert_impl_all!(Company: LoadFrom<i32>);
assert_impl_all!(Employment: LoadFrom<i32>, LoadFrom<User>, LoadFrom<Company>);

fn main() {}