sntl 0.1.0

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

use sntl::Model;
use sntl::core::model::Model as ModelTrait;

#[derive(Model)]
#[sentinel(table = "posts")]
pub struct Post {
    #[sentinel(primary_key)]
    pub id: i64,

    pub title: String,

    pub body: String,

    #[sentinel(default = "false")]
    pub published: bool,
}

#[test]
fn column_constant_id() {
    let expr = Post::ID.eq(42i64);
    assert_eq!(expr.to_sql(1), "\"posts\".\"id\" = $1");
}

#[test]
fn column_constant_title() {
    let expr = Post::TITLE.eq("Hello");
    assert_eq!(expr.to_sql(1), "\"posts\".\"title\" = $1");
}

#[test]
fn column_constant_published() {
    let expr = Post::PUBLISHED.eq(true);
    assert_eq!(expr.to_sql(1), "\"posts\".\"published\" = $1");
}

#[test]
fn column_constants_compose() {
    let expr = Post::TITLE.like("%rust%").and(Post::PUBLISHED.eq(true));
    let sql = expr.to_sql(1);
    assert!(sql.contains("$1"));
    assert!(sql.contains("$2"));
}

#[test]
fn column_constants_in_select() {
    let q = Post::find().where_(Post::PUBLISHED.eq(true));
    let (sql, binds) = q.build();
    assert_eq!(
        sql,
        "SELECT \"posts\".* FROM \"posts\" WHERE \"posts\".\"published\" = $1"
    );
    assert_eq!(binds.len(), 1);
}