doido-model 0.0.15

SeaORM re-exports plus connection pooling and model testing helpers for Doido apps.
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

use doido_model::scope::Scoped;
use doido_model::sea_orm::{ColumnTrait, DbBackend, EntityTrait, QueryFilter, QueryTrait, Select};

mod widget {
    use doido_model::sea_orm::entity::prelude::*;

    #[derive(Clone, Debug, PartialEq, DeriveEntityModel)]
    #[sea_orm(table_name = "widgets")]
    pub struct Model {
        #[sea_orm(primary_key)]
        pub id: i32,
        pub published: bool,
        pub priority: i32,
    }

    #[derive(Copy, Clone, Debug, EnumIter, DeriveRelation)]
    pub enum Relation {}

    impl ActiveModelBehavior for ActiveModel {}
}

// A named scope is just a query transformation.
fn published(q: Select<widget::Entity>) -> Select<widget::Entity> {
    q.filter(widget::Column::Published.eq(true))
}

#[test]
fn named_scopes_compose_into_one_query() {
    let sql = widget::Entity::find()
        .scope(published)
        .scope(|q| q.filter(widget::Column::Priority.gt(5)))
        .build(DbBackend::Sqlite)
        .to_string();
    // Both scopes contribute a WHERE condition, joined with AND.
    assert!(sql.contains("WHERE"), "a scope added a filter: {sql}");
    assert!(sql.contains(" AND "), "both scopes applied: {sql}");
    assert!(sql.contains("> 5"), "priority scope applied: {sql}");
}

#[test]
fn scope_if_applies_conditionally() {
    let with = widget::Entity::find()
        .scope_if(true, published)
        .build(DbBackend::Sqlite)
        .to_string();
    let without = widget::Entity::find()
        .scope_if(false, published)
        .build(DbBackend::Sqlite)
        .to_string();
    assert!(with.contains("WHERE"), "scope_if(true) filtered: {with}");
    assert!(
        !without.contains("WHERE"),
        "scope_if(false) added no filter: {without}"
    );
}