keepsake-sqlx 1.0.0

SQLx adapter for keepsake lifecycle storage
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
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117

use super::support::*;
use keepsake::ExpiryPolicy;

#[tokio::test]
async fn sqlite_increment_counter_projection_is_atomic_and_returns_value() -> TestResult<()> {
    use keepsake::{ActorRef, ApplyKeepsake, CommandContext, SubjectRef};

    let (repo, _pool) = SqliteHarness::repo().await?;
    let relation = upsert_relation::<SqliteHarness>(&repo, ExpiryPolicy::ManualOnly).await?;
    let subject = SubjectRef::new("account", "sqlite_acct_increment")?;
    let applied = repo
        .apply(&ApplyKeepsake::new(
            subject,
            relation.id,
            backend_cases::ts("2026-01-01T00:01:00Z")?,
            CommandContext::new(ActorRef::new("test", "worker")?),
        ))
        .await?;
    let keepsake_id = applied.keepsake.id();

    let first = repo
        .increment_counter_projection(
            keepsake_id,
            "steps",
            2,
            backend_cases::ts("2026-01-01T00:02:00Z")?,
        )
        .await?;
    assert_eq!(first, 2);
    let second = repo
        .increment_counter_projection(
            keepsake_id,
            "steps",
            3,
            backend_cases::ts("2026-01-01T00:03:00Z")?,
        )
        .await?;
    assert_eq!(second, 5);

    let snapshot = repo.fulfillment_snapshot(keepsake_id).await?;
    assert_eq!(snapshot.counters.get("steps").copied(), Some(5));
    Ok(())
}

#[tokio::test]
async fn sqlite_checklist_fulfillment_persists_and_expires() -> TestResult<()> {
    use keepsake::{ActorRef, ApplyKeepsake, CommandContext, FulfillmentPolicy, SubjectRef};

    let (repo, _pool) = SqliteHarness::repo().await?;
    let relation = upsert_relation::<SqliteHarness>(
        &repo,
        ExpiryPolicy::WhenFulfilled {
            policy: FulfillmentPolicy::ChecklistComplete {
                list_key: "onboarding.".to_owned(),
            },
        },
    )
    .await?;
    let subject = SubjectRef::new("account", "sqlite_acct_checklist")?;
    let applied = repo
        .apply(&ApplyKeepsake::new(
            subject,
            relation.id,
            backend_cases::ts("2026-01-01T00:01:00Z")?,
            CommandContext::new(ActorRef::new("test", "worker")?),
        ))
        .await?;
    let keepsake_id = applied.keepsake.id();

    repo.upsert_checklist_projection(
        keepsake_id,
        "onboarding.profile",
        true,
        backend_cases::ts("2026-01-01T00:02:00Z")?,
    )
    .await?;
    repo.upsert_checklist_projection(
        keepsake_id,
        "onboarding.payment",
        false,
        backend_cases::ts("2026-01-01T00:02:00Z")?,
    )
    .await?;

    let snapshot = repo.fulfillment_snapshot(keepsake_id).await?;
    assert_eq!(
        snapshot.checklist.get("onboarding.profile").copied(),
        Some(true)
    );
    assert_eq!(
        snapshot.checklist.get("onboarding.payment").copied(),
        Some(false)
    );

    // Not all items complete: nothing expires.
    assert_eq!(
        repo.expire_due_fulfilled(backend_cases::ts("2026-01-01T00:03:00Z")?, 10)
            .await?,
        0
    );

    repo.upsert_checklist_projection(
        keepsake_id,
        "onboarding.payment",
        true,
        backend_cases::ts("2026-01-01T00:04:00Z")?,
    )
    .await?;

    // All items complete: the keepsake is expired by the fulfillment sweep.
    assert_eq!(
        repo.expire_due_fulfilled(backend_cases::ts("2026-01-01T00:05:00Z")?, 10)
            .await?,
        1
    );
    Ok(())
}