ruststream-sqlx 0.7.0

SQL databases for the RustStream messaging framework through sqlx: a transactional outbox over any RustStream broker and task queues in Postgres, MySQL/MariaDB and SQLite tables.
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

use ruststream_sqlx::Inbox;

// A row without an identity cannot be settled.
#[derive(Inbox)]
#[inbox(table = "jobs")]
struct NoId {
    #[field(payload)]
    payload: Vec<u8>,
}

#[derive(Inbox)]
#[inbox(table = "jobs")]
struct TwoIds {
    #[field(id)]
    job_id: i64,
    #[field(id)]
    id: i64,
}

#[derive(Inbox)]
#[inbox(table = "jobs")]
struct OneColumnTwice {
    #[field(id)]
    job_id: i64,
    #[sqlx(rename = "job_id")]
    legacy_id: i64,
}

#[derive(Inbox)]
#[inbox(table = "jobs", advisory_lock = "jobs-{job_id}")]
struct LeaseAndAdvisory {
    #[field(id)]
    job_id: i64,
    #[field(locked_until)]
    locked_until: Option<i64>,
}

// In the advisory lock form a group keeps its order through the lock key.
#[derive(Inbox)]
#[inbox(table = "ledger", advisory_lock = "ledger-{id}")]
struct FifoAndAdvisory {
    #[field(id)]
    id: i64,
    #[field(group, fifo = true)]
    account: String,
}

fn main() {}