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
use serde_json::Value;
use sqlx::PgPool;
use uuid::Uuid;
#[derive(Clone)]
pub struct IngestDecisionsRepo {
pool: PgPool,
}
impl IngestDecisionsRepo {
pub fn new(pool: PgPool) -> Self {
Self { pool }
}
pub async fn record(
&self,
queue: &str,
decision: &str,
reason_code: &str,
details: Value,
) -> anyhow::Result<Uuid> {
let id = Uuid::new_v4();
sqlx::query(
r#"
INSERT INTO ingest_decisions (id, queue, decision, reason_code, details_json)
VALUES ($1, $2, $3, $4, $5)
"#,
)
.bind(id)
.bind(queue)
.bind(decision)
.bind(reason_code)
.bind(details)
.execute(&self.pool)
.await?;
Ok(id)
}
pub async fn list_recent(
&self,
queue: Option<&str>,
limit: i64,
) -> anyhow::Result<
Vec<(
Uuid,
String,
String,
String,
serde_json::Value,
chrono::DateTime<chrono::Utc>,
)>,
> {
let rows = match queue {
Some(q) => {
sqlx::query_as::<
_,
(
Uuid,
String,
String,
String,
serde_json::Value,
chrono::DateTime<chrono::Utc>,
),
>(
r#"
SELECT id, queue, decision, reason_code, details_json, created_at
FROM ingest_decisions
WHERE queue = $1
ORDER BY created_at DESC
LIMIT $2
"#,
)
.bind(q)
.bind(limit)
.fetch_all(&self.pool)
.await?
}
None => {
sqlx::query_as::<
_,
(
Uuid,
String,
String,
String,
serde_json::Value,
chrono::DateTime<chrono::Utc>,
),
>(
r#"
SELECT id, queue, decision, reason_code, details_json, created_at
FROM ingest_decisions
ORDER BY created_at DESC
LIMIT $1
"#,
)
.bind(limit)
.fetch_all(&self.pool)
.await?
}
};
Ok(rows)
}
}