njord 0.5.0

A versatile, feature-rich Rust ORM.
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

use super::User;
use njord::column::Column;
use njord::condition::{Condition, Value};
use njord::keys::AutoIncrementPrimaryKey;
use njord::sqlite;
use std::path::Path;
use std::vec;

#[test]
fn insert_row() {
    let db_relative_path = "./db/insert.db";
    let db_path = Path::new(&db_relative_path);
    let mut conn = sqlite::open(db_path);

    let table_row: User = User {
        id: AutoIncrementPrimaryKey::default(),
        username: "mjovanc".to_string(),
        email: "mjovanc@icloud.com".to_string(),
        address: "Some Random Address 1".to_string(),
    };

    match conn {
        Ok(ref mut c) => {
            let result = sqlite::insert(c, vec![table_row]);
            assert!(result.is_ok());
        }
        Err(e) => {
            panic!("Failed to INSERT: {:?}", e);
        }
    }
}

#[test]
fn insert_with_sub_query() {
    let db_relative_path = "./db/insert.db";
    let db_path = Path::new(&db_relative_path);
    let mut conn = sqlite::open(db_path);

    match conn {
        Ok(ref mut c) => {
            let subquery = sqlite::select(
                vec![
                    Column::Text("username".to_string()),
                    Column::Text("email".to_string()),
                    Column::Text("address".to_string()),
                ],
            )
            .from(User::default())
            .where_clause(Condition::Eq(
                "username".to_string(),
                Value::Literal("mjovanc".to_string()),
            ));

            let result = sqlite::insert::into::<User>(
                c,
                vec![
                    "username".to_string(),
                    "email".to_string(),
                    "address".to_string(),
                ],
                Box::new(subquery),
            );
            assert!(result.is_ok());
        }
        Err(e) => {
            panic!("Failed to INSERT: {:?}", e);
        }
    }
}

#[test]
fn insert_row_with_single_quotes() {
    let db_relative_path = "./db/insert.db";
    let db_path = Path::new(&db_relative_path);
    let mut conn = sqlite::open(db_path);

    let table_row: User = User {
        id: AutoIncrementPrimaryKey::default(),
        username: "quote_user".to_string(),
        email: "quote_user@example.com".to_string(),
        address: "Some Random 'Address' 1".to_string(),
    };

    match conn {
        Ok(ref mut c) => {
            let result = sqlite::insert(c, vec![table_row]);
            assert!(result.is_ok());
        }
        Err(e) => {
            panic!("Failed to INSERT: {:?}", e);
        }
    }
}