sntl 0.1.1

Compile-time guarded ORM for PostgreSQL — your data's guardian from compile to production
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

use sntl::core::Column;
use sntl::core::query::IncludeQuery;
use sntl::core::relation::*;

struct User;
struct UserPosts;

impl sntl::core::Model for User {
    const TABLE: &'static str = "users";
    const PRIMARY_KEY: &'static str = "id";
    fn columns() -> &'static [sntl::core::ModelColumn] {
        &[]
    }
    fn from_row(_row: &sntl::core::Row) -> sntl::driver::Result<Self> {
        Ok(User)
    }
    fn primary_key_value(&self) -> sntl::core::Value {
        sntl::core::Value::from(0i32)
    }
}

// Transition: including posts flips position 0
impl<B> IncludeTransition<User, (Unloaded, B), UserPosts> for () {
    type Next = (Loaded, B);
}

#[test]
fn include_query_tracks_specs() {
    let spec = RelationSpec::new("posts", "user_id", "posts", RelationKind::HasMany);
    let q: IncludeQuery<User, (Unloaded, Unloaded)> = IncludeQuery::from_table("users");
    let q2 = q.include_rel::<UserPosts>(spec);
    let (sql, _params) = q2.Build();
    assert!(sql.contains("users"));
    assert_eq!(q2.included_specs().len(), 1);
}

#[test]
fn include_query_chains_where() {
    let q: IncludeQuery<User, (Unloaded,)> = IncludeQuery::from_table("users");
    let q = q.Where(Column::new("users", "active").eq(true));
    let (sql, _) = q.Build();
    assert!(sql.contains("active"));
}

#[test]
fn include_query_chains_order_limit() {
    let q: IncludeQuery<User, (Unloaded,)> = IncludeQuery::from_table("users");
    let q = q.OrderBy(Column::new("users", "name").asc()).Limit(10);
    let (sql, _) = q.Build();
    assert!(sql.contains("ORDER BY"));
    assert!(sql.contains("LIMIT 10"));
}

// Manual ModelRelations impl (macro generates in production)
impl sntl::core::relation::ModelRelations for User {
    type BareState = (Unloaded, Unloaded);
}

#[test]
fn model_query_include_transitions_to_include_query() {
    use sntl::core::query::ModelQuery;

    let spec = RelationSpec::new("posts", "user_id", "posts", RelationKind::HasMany);
    let inc = RelationInclude::<User, UserPosts>::new(spec);

    let q: ModelQuery<User> = ModelQuery::from_table("users");
    let q2 = q.Include(inc);
    assert_eq!(q2.included_specs().len(), 1);
}