njord 0.1.0

A lightweight ORM framework for Rust with strong-typed SQL DSL and sequence APIs.
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

// integrations tests for sqlite

use njord::sqlite;
use njord::sqlite::init::init;
use njord::sqlite::insert::insert;
use njord::table::Table;
use njord_derive::Table;
use serial_test::serial;

mod common;

#[test]
#[serial]
fn open_db() {
    let result = sqlite::open("test_database.db");
    assert!(result.is_ok());
}

#[test]
#[serial]
fn init_tables() {
    let conn = sqlite::open("test_database.db");

    #[derive(Table, Debug, Default)]
    struct TableA {
        title: String,
        description: String,
        amount: u32,
    }

    #[derive(Table, Debug, Default)]
    struct TableB {
        name: String,
        age: u32,
        email: String,
    }

    #[derive(Table, Debug, Default)]
    struct TableC {
        product_id: i64,
        product_name: String,
        price: f64,
        in_stock: bool,
    }

    let table_a = Box::new(TableA::default());
    let table_b = Box::new(TableB::default());
    let table_c = Box::new(TableC::default());

    let mut tables: Vec<Box<dyn Table>> = Vec::new();
    tables.push(table_a);
    tables.push(table_b);
    tables.push(table_c);

    let result = sqlite::init(conn.unwrap(), tables);

    assert!(result.is_ok());
}

#[test]
#[serial]
fn insert_row() {
    let conn = sqlite::open("test_database.db");

    #[derive(Table, Debug, Default)]
    struct TableA {
        title: String,
        description: String,
        amount: u32,
    }

    let table_row: TableA = TableA {
        title: "Table A".to_string(),
        description: "Some description for Table A".to_string(),
        amount: 0,
    };

    let result = sqlite::insert(conn.unwrap(), &table_row);

    assert!(result.is_ok());
}