microrm 0.6.3

Lightweight ORM using sqlite as a backend
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

use microrm::prelude::*;
use test_log::test;

mod common;

#[derive(Clone, Entity, PartialEq)]
struct Container {
    value: usize,
}

#[derive(Schema)]
struct Schema {
    containers: microrm::IDMap<Container>,
}

fn simple_test_data(txn: &mut microrm::Transaction, db: &Schema) {
    db.containers.insert(txn, Container { value: 5 }).unwrap();
    db.containers.insert(txn, Container { value: 4 }).unwrap();
    db.containers.insert(txn, Container { value: 9 }).unwrap();
    db.containers.insert(txn, Container { value: 7 }).unwrap();
}

#[test]
fn repeated_limit() {
    let (pool, db): (_, Schema) = common::open_test_db!();
    let mut txn = pool.start().unwrap();
    let Err(microrm::Error::LogicError(msg)) = db.containers.limit(1).limit(1).count(&mut txn)
    else {
        panic!("should have failed")
    };
    assert_eq!(msg, "repeated limit on query");
}

#[test]
fn simple_limit() {
    let (pool, db): (_, Schema) = common::open_test_db!();

    {
        let mut txn = pool.start().unwrap();
        simple_test_data(&mut txn, &db);
        txn.commit().unwrap();
    }

    {
        let mut txn = pool.start().unwrap();

        assert_eq!(db.containers.limit(2).get(&mut txn).unwrap().len(), 2);
        assert_eq!(db.containers.limit(5).get(&mut txn).unwrap().len(), 4);
    }
}

#[test]
fn limit_count_interaction() {
    let (pool, db): (_, Schema) = common::open_test_db!();

    {
        let mut txn = pool.start().unwrap();
        simple_test_data(&mut txn, &db);
        txn.commit().unwrap();
    }

    {
        let mut txn = pool.start().unwrap();

        assert_eq!(db.containers.limit(2).count(&mut txn).unwrap(), 4);
        assert_eq!(db.containers.limit(5).count(&mut txn).unwrap(), 4);
    }
}