OXYGENHUB
# dc59d1b56c3d oxygenhub / crates / hub / tests / flow.rs
240.9 KiB · Rust · last changed Approvers are told; oh run approve and oh run reject 20 days ago source blame history raw
1
//! OxygenFlow on the hub (hub spec §13.2), end to end: a real `oxy` push
2
//! starts a run, a runner claims jobs through the API in dependency order,
3
//! job tokens read only their repository, results become checks and pages.
4
5
use axum::body::Body;
6
use axum::http::{header, Request, StatusCode};
7
use http_body_util::BodyExt;
8
use oxy_core::protocol::{open_remote, RemoteOptions};
9
use oxy_core::repo::Repo;
10
use oxygenhub::config::Config;
11
use oxygenhub::repos::RepoName;
12
use oxygenhub::{db, Shared};
13
use std::path::Path;
14
use tower::ServiceExt;
15
16
const ROOTFS: &str = "36fc4e3238044e424219a2b9002bf61bbe1805fec14d52cf37e17fae77c9ff16";
17
18
fn hermetic() {
19
    static ONCE: std::sync::Once = std::sync::Once::new();
20
    static DIR: std::sync::OnceLock<tempfile::TempDir> = std::sync::OnceLock::new();
21
    ONCE.call_once(|| {
22
        let d = tempfile::tempdir().unwrap();
23
        std::env::set_var("OXY_HOME", d.path());
24
        DIR.set(d).ok();
25
    });
26
}
27
28
fn write(root: &Path, rel: &str, content: &str) {
29
    let p = root.join(rel);
30
    std::fs::create_dir_all(p.parent().unwrap()).unwrap();
31
    std::fs::write(p, content).unwrap();
32
}
33
34
struct Hub {
35
    app: Shared,
36
    base: String,
37
    _dir: tempfile::TempDir,
38
}
39
40
async fn hub() -> Hub {
41
    hermetic();
42
    let dir = tempfile::tempdir().unwrap();
43
    let mut config = Config::load(dir.path()).unwrap();
44
    config.auth.push_tokens = vec!["site".into()];
45
    config.flow.runner_tokens = vec!["runner-secret".into(), "runner-two".into(), "runner-three".into()];
46
    config.flow.repos = vec!["andy/*".into()];
47
    config.registration.mode = "open".into();
48
    let listener = tokio::net::TcpListener::bind("127.0.0.1:0").await.unwrap();
49
    let port = listener.local_addr().unwrap().port();
50
    config.server.base_url = format!("http://127.0.0.1:{port}");
51
    let app = oxygenhub::build(config).await.unwrap();
52
    let router = oxygenhub::router(app.clone());
53
    tokio::spawn(async move { axum::serve(listener, router).await.unwrap() });
54
    Hub { app, base: format!("http://127.0.0.1:{port}"), _dir: dir }
55
}
56
57
async fn call(app: &Shared, method: &str, path: &str, bearer: Option<&str>, json: Option<String>) -> (StatusCode, String) {
58
    let mut req = Request::builder().method(method).uri(path);
59
    if let Some(b) = bearer {
60
        req = req.header(header::AUTHORIZATION, format!("Bearer {b}"));
61
    }
62
    let body = match json {
63
        Some(j) => {
64
            req = req.header(header::CONTENT_TYPE, "application/json");
65
            Body::from(j)
66
        }
67
        None => Body::empty(),
68
    };
69
    let res = oxygenhub::router(app.clone()).oneshot(req.body(body).unwrap()).await.unwrap();
70
    let status = res.status();
71
    let bytes = res.into_body().collect().await.unwrap().to_bytes();
72
    (status, String::from_utf8_lossy(&bytes).into_owned())
73
}
74
75
/// A GET's status, `Location` and `Content-Type`.
76
async fn head(app: &Shared, path: &str) -> (StatusCode, String, String) {
77
    let res = oxygenhub::router(app.clone()).oneshot(Request::get(path).body(Body::empty()).unwrap()).await.unwrap();
78
    let h = |k: header::HeaderName| res.headers().get(k).and_then(|v| v.to_str().ok()).unwrap_or("").to_string();
79
    (res.status(), h(header::LOCATION), h(header::CONTENT_TYPE))
80
}
81
82
async fn claim(app: &Shared) -> Option<serde_json::Value> {
83
    let (st, body) =
84
        call(app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(r#"{"runner":"test-1","runtimes":["microvm"]}"#.into())).await;
85
    match st {
86
        StatusCode::NO_CONTENT => None,
87
        StatusCode::OK => Some(serde_json::from_str(&body).unwrap()),
88
        other => panic!("claim: {other} {body}"),
89
    }
90
}
91
92
fn receipt(job: &str, pipeline_hash: &str, exit: u32) -> serde_json::Value {
93
    serde_json::json!({
94
        "job_name": job, "pipeline_hash": pipeline_hash, "scope_tree_hash": "11".repeat(32),
95
        "inputs": [], "environment": "22".repeat(32), "outputs": [], "exit_code": exit, "duration_ms": 640
96
    })
97
}
98
99
async fn finish(app: &Shared, id: i64, body: serde_json::Value) -> StatusCode {
100
    call(app, "POST", &format!("/api/v1/flow/jobs/{id}/finish"), Some("runner-secret"), Some(body.to_string())).await.0
101
}
102
103
async fn create(app: &Shared, owner: &str, name: &str) {
104
    app.repos.create(&RepoName::parse(&format!("{owner}/{name}")).unwrap(), None).unwrap();
105
    db::repos::create(&app.db, owner, name, "", hub_api::Visibility::Public).await.unwrap();
106
}
107
108
fn client(url: &str, work: &Path) -> Repo {
109
    let mut c = Repo::init(work).unwrap();
110
    c.config.set("remote.origin.url", url).unwrap();
111
    c.config.set("remote.origin.token", "site").unwrap();
112
    c.save_config().unwrap();
113
    c
114
}
115
116
fn pipeline(extra: &str) -> String {
117
    format!(
118
        "schema-version 1\nsandbox \"alpine\" {{\n    rootfs \"cas://blob/{ROOTFS}\"\n}}\njob \"build\" {{\n    sandbox \"alpine\"\n    exec \"make\"\n}}\njob \"test\" {{\n    sandbox \"alpine\"\n    depends-on \"build\"\n    exec \"sh\" \"-eu\" \"test.sh\"\n}}\njob \"lint\" {{\n    sandbox \"alpine\"\n    exec \"true\"\n}}\n{extra}"
119
    )
120
}
121
122
async fn runs_of(app: &Shared, owner: &str, name: &str) -> Vec<db::flow::Run> {
123
    let row = db::repos::get(&app.db, owner, name).await.unwrap().unwrap();
124
    for _ in 0..100 {
125
        let r = db::flow::runs(&app.db, row.id, 10, None).await.unwrap();
126
        if !r.is_empty() {
127
            return r;
128
        }
129
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
130
    }
131
    vec![]
132
}
133
134
/// The checks on a state once there are `n` of them (they follow the run).
135
async fn checks_when(app: &Shared, repo_id: i64, state: &str, n: usize) -> Vec<db::hooks::Check> {
136
    for _ in 0..100 {
137
        let c = db::hooks::checks_for_state(&app.db, repo_id, state).await.unwrap();
138
        if c.len() >= n {
139
            return c;
140
        }
141
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
142
    }
143
    db::hooks::checks_for_state(&app.db, repo_id, state).await.unwrap()
144
}
145
146
#[tokio::test(flavor = "multi_thread")]
147
async fn a_push_runs_the_pipeline_through_a_runner() {
148
    let h = hub().await;
149
    create(&h.app, "andy", "demo").await;
150
    create(&h.app, "andy", "secret").await;
151
    create(&h.app, "other", "plain").await;
152
    let url = format!("{}/andy/demo", h.base);
153
    let work = tempfile::tempdir().unwrap();
154
    let mut c = client(&url, work.path());
155
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
156
    write(work.path(), "test.sh", "echo ok\n");
157
    c.snapshot("test").unwrap();
158
    c.commit("Add a pipeline", &[]).unwrap();
159
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
160
161
    // The push started a run with three queued jobs, and checks for them.
162
    let runs = runs_of(&h.app, "andy", "demo").await;
163
    assert_eq!(runs.len(), 1);
164
    let run = &runs[0];
165
    assert_eq!((run.bookmark.as_str(), run.status.as_str(), run.actor.as_str()), ("main", "queued", "site token"));
166
    assert_eq!(run.pipeline_hash.len(), 64);
167
    let jobs = db::flow::jobs(&h.app.db, run.id).await.unwrap();
168
    assert_eq!(jobs.iter().map(|j| (j.name.as_str(), j.depth)).collect::<Vec<_>>(), [("build", 0), ("lint", 0), ("test", 1)]);
169
    // The checks are reported just after the run is recorded.
170
    let checks = checks_when(&h.app, run.repo_id, &run.state, 3).await;
171
    assert_eq!(
172
        checks.iter().map(|c| (c.name.as_str(), c.status.as_str())).collect::<Vec<_>>(),
173
        [("flow/build", "queued"), ("flow/lint", "queued"), ("flow/test", "queued")]
174
    );
175
176
    // Runners need a runner token.
177
    assert_eq!(
178
        call(&h.app, "POST", "/api/v1/flow/claim", Some("site"), Some(r#"{"runner":"x","runtimes":["microvm"]}"#.into())).await.0,
179
        StatusCode::UNAUTHORIZED
180
    );
181
    assert_eq!(
182
        call(&h.app, "POST", "/api/v1/flow/claim", None, Some(r#"{"runner":"x","runtimes":["microvm"]}"#.into())).await.0,
183
        StatusCode::UNAUTHORIZED
184
    );
185
    // A runner without the tier gets nothing.
186
    let (st, _) =
187
        call(&h.app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(r#"{"runner":"x","runtimes":["wasm"]}"#.into())).await;
188
    assert_eq!(st, StatusCode::NO_CONTENT);
189
190
    // Claims come in dependency order; `test` waits for `build`.
191
    let a = claim(&h.app).await.unwrap();
192
    let b = claim(&h.app).await.unwrap();
193
    assert_eq!((a["job"]["name"].as_str(), b["job"]["name"].as_str()), (Some("build"), Some("lint")));
194
    assert!(claim(&h.app).await.is_none(), "test waits for build");
195
    assert_eq!(a["repo"], "andy/demo");
196
    assert_eq!(a["clone_url"], url.as_str());
197
    assert_eq!(a["sandbox"]["rootfs"], ROOTFS);
198
    assert_eq!(a["job"]["exec"], serde_json::json!(["make"]));
199
    assert_eq!(a["timeout_s"], 3600);
200
    // The job is told what it builds (FLOW_STATE, FLOW_BOOKMARK, FLOW_RUN).
201
    assert_eq!(
202
        (a["state"].as_str(), a["bookmark"].as_str(), a["run_number"].as_i64()),
203
        (Some(run.state.as_str()), Some("main"), Some(run.number))
204
    );
205
    let heads: Vec<String> = a["heads"].as_array().unwrap().iter().map(|v| v.as_str().unwrap().to_string()).collect();
206
    assert_eq!(heads.join("+"), run.heads);
207
    let checks = db::hooks::checks_for_state(&h.app.db, run.repo_id, &run.state).await.unwrap();
208
    assert_eq!(checks.iter().find(|c| c.name == "flow/build").unwrap().status, "running");
209
210
    // The job token reads this repository over the wire, and nothing else.
211
    let token = a["token"].as_str().unwrap().to_string();
212
    assert!(token.starts_with("flowjob_"));
213
    let opts = RemoteOptions { token: Some(token.clone()), ..Default::default() };
214
    open_remote(&url, &opts).unwrap().refs().unwrap();
215
    assert!(open_remote(&format!("{}/andy/secret", h.base), &opts).unwrap().refs().is_err(), "another repository");
216
    let bad = RemoteOptions { token: Some("flowjob_00".into()), ..Default::default() };
217
    assert!(open_remote(&url, &bad).unwrap().refs().is_err(), "an unknown job token");
218
    // … and cannot push.
219
    c.config.set("remote.origin.token", &token).unwrap();
220
    c.save_config().unwrap();
221
    write(work.path(), "more.txt", "x\n");
222
    c.snapshot("test").unwrap();
223
    c.commit("More", &[]).unwrap();
224
    let pushed = c.push("origin", false);
225
    assert!(pushed.is_err() || pushed.unwrap().iter().all(|r| !r.ok), "a job token cannot push");
226
    c.config.set("remote.origin.token", "site").unwrap();
227
    c.save_config().unwrap();
228
229
    // Logs, then results with receipts.
230
    let a_id = a["job_id"].as_i64().unwrap();
231
    let b_id = b["job_id"].as_i64().unwrap();
232
    let log = serde_json::json!({ "records": [
233
        { "t": 5, "stream": "flow", "text": "booting" },
234
        { "t": 120, "stream": "out", "text": "cc -o demo demo.c" },
235
        { "t": 130, "stream": "weird", "text": "x".repeat(20_000) },
236
    ]});
237
    assert_eq!(
238
        call(&h.app, "POST", &format!("/api/v1/flow/jobs/{a_id}/log"), Some("runner-secret"), Some(log.to_string())).await.0,
239
        StatusCode::NO_CONTENT
240
    );
241
    let lines = db::flow::log(&h.app.db, a_id, 0, 100).await.unwrap();
242
    assert_eq!(lines.len(), 3);
243
    assert_eq!((lines[2].stream.as_str(), lines[2].text.len()), ("console", 16 * 1024), "streams are known ones, text is capped");
244
    let ph = a["pipeline_hash"].as_str().unwrap();
245
    assert_eq!(
246
        finish(&h.app, a_id, serde_json::json!({ "exit_code": 0, "duration_ms": 700, "receipt": receipt("lint", ph, 0) })).await,
247
        StatusCode::BAD_REQUEST,
248
        "a receipt for another job"
249
    );
250
    assert_eq!(
251
        finish(&h.app, a_id, serde_json::json!({ "exit_code": 0, "duration_ms": 700, "receipt": receipt("build", ph, 0) })).await,
252
        StatusCode::NO_CONTENT
253
    );
254
    assert_eq!(finish(&h.app, a_id, serde_json::json!({ "exit_code": 0, "duration_ms": 700 })).await, StatusCode::CONFLICT, "only once");
255
    assert!(open_remote(&url, &opts).unwrap().refs().is_err(), "the token ends with its job");
256
    assert_eq!(
257
        finish(&h.app, b_id, serde_json::json!({ "exit_code": 0, "duration_ms": 300, "receipt": receipt("lint", ph, 0) })).await,
258
        StatusCode::NO_CONTENT
259
    );
260
    let t = claim(&h.app).await.unwrap();
261
    assert_eq!(t["job"]["name"], "test");
262
    let t_id = t["job_id"].as_i64().unwrap();
263
    assert_eq!(
264
        finish(&h.app, t_id, serde_json::json!({ "exit_code": 3, "duration_ms": 500, "receipt": receipt("test", ph, 3) })).await,
265
        StatusCode::NO_CONTENT
266
    );
267
268
    let run = db::flow::run_by_id(&h.app.db, run.id).await.unwrap().unwrap();
269
    assert_eq!(run.status, "failed");
270
    let jobs = db::flow::jobs(&h.app.db, run.id).await.unwrap();
271
    let build = jobs.iter().find(|j| j.name == "build").unwrap();
272
    assert_eq!((build.status.as_str(), build.exit_code, build.receipt_hash.len()), ("passed", Some(0), 64));
273
    assert_eq!(jobs.iter().find(|j| j.name == "test").unwrap().status, "failed");
274
    let checks = db::hooks::checks_for_state(&h.app.db, run.repo_id, &run.state).await.unwrap();
275
    assert_eq!(
276
        checks.iter().map(|c| (c.name.as_str(), c.status.as_str())).collect::<Vec<_>>(),
277
        [("flow/build", "passed"), ("flow/lint", "passed"), ("flow/test", "failed")]
278
    );
279
    assert!(checks[2].summary.contains("exit 3") && checks[2].url.ends_with(&format!("/andy/demo/flow/{}", run.number)));
280
281
    // Pages: the list, the run with its graph and logs, and the live view.
282
    let (st, list) = call(&h.app, "GET", "/andy/demo/flow", None, None).await;
283
    assert_eq!(st, StatusCode::OK);
284
    assert!(list.contains(&format!("/andy/demo/flow/{}", run.number)) && list.contains("st-failed"), "{list}");
285
    let (st, page) = call(&h.app, "GET", &format!("/andy/demo/flow/{}", run.number), None, None).await;
286
    assert_eq!(st, StatusCode::OK);
287
    assert!(page.contains("<svg class=\"flow-graph\""), "graph");
288
    assert_eq!(page.matches("data-job-node=").count(), 3);
289
    assert_eq!(page.matches("<path class=\"edge").count(), 1, "one dependency edge");
290
    assert!(page.contains("cc -o demo demo.c"), "log shown");
291
    assert!(!page.contains("data-flow-live"), "a finished run does not poll");
292
    let (st, live) = call(&h.app, "GET", &format!("/andy/demo/flow/{}/live?after={a_id}:1", run.number), None, None).await;
293
    assert_eq!(st, StatusCode::OK);
294
    let live: serde_json::Value = serde_json::from_str(&live).unwrap();
295
    assert_eq!(live["status"], "failed");
296
    let build_live = live["jobs"].as_array().unwrap().iter().find(|j| j["name"] == "build").unwrap().clone();
297
    assert_eq!(build_live["lines"].as_array().unwrap().len(), 2, "lines after seq 1");
298
    assert_eq!(call(&h.app, "GET", "/andy/demo/flow/999", None, None).await.0, StatusCode::NOT_FOUND);
299
300
    // A failed dependency skips what follows; an unrun job is an error.
301
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
302
    write(work.path(), "test.sh", "echo changed\n");
303
    c.snapshot("test").unwrap();
304
    c.commit("Change the test", &[]).unwrap();
305
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
306
    let mut second = None;
307
    for _ in 0..100 {
308
        let r = runs_of(&h.app, "andy", "demo").await;
309
        if r.len() == 2 {
310
            second = Some(r[0].clone());
311
            break;
312
        }
313
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
314
    }
315
    let second = second.expect("a second run");
316
    let x = claim(&h.app).await.unwrap();
317
    let y = claim(&h.app).await.unwrap();
318
    let (build_id, lint_id) = if x["job"]["name"] == "build" {
319
        (x["job_id"].as_i64().unwrap(), y["job_id"].as_i64().unwrap())
320
    } else {
321
        (y["job_id"].as_i64().unwrap(), x["job_id"].as_i64().unwrap())
322
    };
323
    assert_eq!(
324
        finish(&h.app, build_id, serde_json::json!({ "exit_code": null, "duration_ms": 10, "error": "rootfs is not on this runner" }))
325
            .await,
326
        StatusCode::NO_CONTENT
327
    );
328
    assert_eq!(finish(&h.app, lint_id, serde_json::json!({ "exit_code": 0, "duration_ms": 10 })).await, StatusCode::NO_CONTENT);
329
    assert!(claim(&h.app).await.is_none(), "test was skipped");
330
    let jobs = db::flow::jobs(&h.app.db, second.id).await.unwrap();
331
    assert_eq!(
332
        jobs.iter().map(|j| (j.name.as_str(), j.status.as_str())).collect::<Vec<_>>(),
333
        [("build", "error"), ("lint", "passed"), ("test", "skipped")]
334
    );
335
    assert_eq!(db::flow::run_by_id(&h.app.db, second.id).await.unwrap().unwrap().status, "failed");
336
337
    // An invalid pipeline is a run in error with the line.
338
    write(work.path(), ".flow/pipeline.kdl", &pipeline("job \"broken\" {\n    sandbox \"missing\"\n    exec \"x\"\n}\n"));
339
    c.snapshot("test").unwrap();
340
    c.commit("Break the pipeline", &[]).unwrap();
341
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
342
    let mut third = None;
343
    for _ in 0..100 {
344
        let r = runs_of(&h.app, "andy", "demo").await;
345
        if r.len() == 3 {
346
            third = Some(r[0].clone());
347
            break;
348
        }
349
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
350
    }
351
    let third = third.expect("a third run");
352
    assert_eq!(third.status, "error");
353
    assert!(third.error.contains("line 18") && third.error.contains("\"missing\""), "{}", third.error);
354
    let (_, page) = call(&h.app, "GET", &format!("/andy/demo/flow/{}", third.number), None, None).await;
355
    assert!(page.contains("The pipeline is not valid"));
356
357
    // State stamps (hub spec §13.2) and images in READMEs.
358
    write(work.path(), "README.md", "# Demo\n\n[![flow](.flow/stamp)](.flow/run)\n\n![logo](img/logo.png)\n");
359
    std::fs::create_dir_all(work.path().join("img")).unwrap();
360
    std::fs::write(work.path().join("img/logo.png"), b"\x89PNG\r\n\x1a\n\0\0\0\rIHDR\0\0\0\x01\0\0\0\x01\x08\x06\0\0\0\x1f\x15\xc4\x89")
361
        .unwrap();
362
    c.snapshot("test").unwrap();
363
    c.commit("A README with a stamp", &[]).unwrap();
364
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
365
    let mut fourth = None;
366
    for _ in 0..100 {
367
        let r = runs_of(&h.app, "andy", "demo").await;
368
        if r.len() == 4 {
369
            fourth = Some(r[0].clone());
370
            break;
371
        }
372
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
373
    }
374
    let fourth = fourth.expect("a fourth run");
375
    let (_, overview) = call(&h.app, "GET", "/andy/demo", None, None).await;
376
    assert!(overview.contains("src=\"/andy/demo/raw/main/.flow/stamp\""), "{overview}");
377
    assert!(overview.contains("href=\"/andy/demo/file/main/.flow/run\""));
378
    assert!(overview.contains("src=\"/andy/demo/raw/main/img/logo.png\""), "images use the raw route");
379
    let (st, _, ct) = head(&h.app, "/andy/demo/raw/main/img/logo.png").await;
380
    assert_eq!((st, ct.as_str()), (StatusCode::OK, "image/png"));
381
    let (st, loc, _) = head(&h.app, "/andy/demo/raw/main/.flow/stamp").await;
382
    assert!(st.is_redirection() && loc == "/andy/demo/flow/stamp/main", "{st} {loc}");
383
    let (st, loc, _) = head(&h.app, "/andy/demo/flow/stamp/main").await;
384
    assert!(st.is_redirection() && loc == format!("/andy/demo/flow/stamp/{}", fourth.heads), "a bookmark's stamp names its state: {loc}");
385
    let (st, _, ct) = head(&h.app, &loc).await;
386
    assert_eq!((st, ct.as_str()), (StatusCode::OK, "image/svg+xml; charset=utf-8"));
387
    let (_, svg) = call(&h.app, "GET", &loc, None, None).await;
388
    assert!(svg.starts_with("<svg") && svg.contains("error ·") && svg.contains(&fourth.heads[..12]), "{svg}");
389
    let (_, svg1) = call(&h.app, "GET", &format!("/andy/demo/flow/stamp/{}", run.heads), None, None).await;
390
    assert!(svg1.contains("failed ·") && svg1.contains(&format!("run #{} failed", run.id)), "an older state keeps its own result: {svg1}");
391
    assert!(svg1.contains(&build.receipt_hash), "receipt hashes in the metadata");
392
    assert_eq!(svg1.matches("text-anchor=\"middle\"").count(), 3, "one glyph per job");
393
    let (st, loc, _) = head(&h.app, "/andy/demo/file/main/.flow/run").await;
394
    assert!(st.is_redirection() && loc == "/andy/demo/flow/at/main", "{loc}");
395
    let (st, loc, _) = head(&h.app, "/andy/demo/flow/at/main").await;
396
    assert!(st.is_redirection() && loc == format!("/andy/demo/flow/{}", fourth.id), "{loc}");
397
398
    // A repository outside [flow] repos starts nothing.
399
    let work2 = tempfile::tempdir().unwrap();
400
    let c2 = client(&format!("{}/other/plain", h.base), work2.path());
401
    write(work2.path(), ".flow/pipeline.kdl", &pipeline(""));
402
    c2.snapshot("test").unwrap();
403
    c2.commit("Pipeline", &[]).unwrap();
404
    assert!(c2.push("origin", false).unwrap().iter().all(|r| r.ok));
405
    tokio::time::sleep(std::time::Duration::from_millis(500)).await;
406
    let row = db::repos::get(&h.app.db, "other", "plain").await.unwrap().unwrap();
407
    assert!(db::flow::runs(&h.app.db, row.id, 10, None).await.unwrap().is_empty());
408
    let (_, page) = call(&h.app, "GET", "/other/plain/flow", None, None).await;
409
    assert!(page.contains("not enabled for this repository"));
410
    let (_, loc, _) = head(&h.app, "/other/plain/flow/stamp/main").await;
411
    let (_, svg) = call(&h.app, "GET", &loc, None, None).await;
412
    assert!(svg.contains("no run ·"), "{svg}");
413
    let (_, loc, _) = head(&h.app, "/other/plain/flow/at/main").await;
414
    assert_eq!(loc, "/other/plain/flow");
415
}
416
417
#[tokio::test(flavor = "multi_thread")]
418
async fn claims_carry_pinned_subrepos_and_the_job_token_reads_only_those() {
419
    let h = hub().await;
420
    for n in ["base", "lib", "vault", "other", "app"] {
421
        create(&h.app, "andy", n).await;
422
    }
423
    let push = |name: &str, file: &str| {
424
        let work = tempfile::tempdir().unwrap();
425
        let c = client(&format!("{}/andy/{name}", h.base), work.path());
426
        write(work.path(), file, "x\n");
427
        c.snapshot("t").unwrap();
428
        c.commit("first", &[]).unwrap();
429
        assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
430
        let heads = c.bookmark_heads().unwrap();
431
        (work, heads)
432
    };
433
    let (_b, base_heads) = push("base", "base.rs");
434
    // lib pins base in turn: a subrepo of a subrepo.
435
    let lib_work = tempfile::tempdir().unwrap();
436
    let lib = client(&format!("{}/andy/lib", h.base), lib_work.path());
437
    lib.submodule_add(&format!("{}/andy/base", h.base), "deps/base", Some("main")).unwrap();
438
    write(lib_work.path(), "lib.rs", "x\n");
439
    lib.snapshot("t").unwrap();
440
    lib.commit("lib on base", &[]).unwrap();
441
    assert!(lib.push("origin", false).unwrap().iter().all(|r| r.ok));
442
    let lib_heads = lib.bookmark_heads().unwrap();
443
    let (_v, _) = push("vault", "secret.rs");
444
    let (_o, _) = push("other", "o.rs");
445
446
    // The app pins lib and vault as subrepos and pushes as the site token.
447
    let work = tempfile::tempdir().unwrap();
448
    let app = client(&format!("{}/andy/app", h.base), work.path());
449
    app.submodule_add(&format!("{}/andy/lib", h.base), "deps/lib", Some("main")).unwrap();
450
    // Vault is private: a checkout with no token for this hub cannot add
451
    // it, but the app's remote on the same hub lends its token (oxygen#32).
452
    // The subrepo keeps no copy: its own fetches find the parent's (oxygen#47).
453
    sqlx::query("UPDATE repositories SET visibility = 'private' WHERE name = 'vault'").execute(&h.app.db).await.unwrap();
454
    let bare_work = tempfile::tempdir().unwrap();
455
    let mut bare = Repo::init(bare_work.path()).unwrap();
456
    bare.config.set("remote.origin.url", &format!("{}/andy/bare", h.base)).unwrap();
457
    bare.save_config().unwrap();
458
    assert!(bare.submodule_add(&format!("{}/andy/vault", h.base), "deps/vault", Some("main")).is_err(), "not without a token");
459
    app.submodule_add(&format!("{}/andy/vault", h.base), "deps/vault", Some("main")).unwrap();
460
    let nested = Repo::open(&work.path().join("deps/vault")).unwrap();
461
    assert!(nested.config.remote_tokens.is_empty(), "no token is copied into a subrepo");
462
    nested.fetch("origin").unwrap();
463
    // The pusher below is the site token, which has no account: it cannot read vault.
464
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
465
    write(work.path(), "Makefile", "all:\n");
466
    app.snapshot("t").unwrap();
467
    app.commit("app with deps", &[]).unwrap();
468
    assert!(app.push("origin", false).unwrap().iter().all(|r| r.ok));
469
    assert!(!runs_of(&h.app, "andy", "app").await.is_empty());
470
471
    let job = claim(&h.app).await.unwrap();
472
    let subs = job["subrepos"].as_array().cloned().unwrap_or_default();
473
    assert_eq!(subs.len(), 2, "lib and what lib pins; vault is private and the pusher has no account: {subs:?}");
474
    assert_eq!(subs[1]["path"], "deps/lib/deps/base", "nested under its parent, after it");
475
    assert_eq!(subs[1]["heads"], serde_json::json!(base_heads.iter().map(|h| h.to_hex()).collect::<Vec<_>>()));
476
    let _ = std::fs::remove_dir_all(work.path().join("deps/vault2"));
477
    assert_eq!(subs[0]["path"], "deps/lib");
478
    assert_eq!(subs[0]["repo"], "andy/lib");
479
    assert_eq!(subs[0]["heads"], serde_json::json!(lib_heads.iter().map(|h| h.to_hex()).collect::<Vec<_>>()));
480
    assert!(subs[0]["clone_url"].as_str().unwrap().ends_with("/andy/lib"));
481
    // The job's log says vault was left out, and why (oxygenhub#56).
482
    let job_id = job["job_id"].as_i64().unwrap();
483
    let lines = db::flow::log(&h.app.db, job_id, 0, 100).await.unwrap();
484
    assert!(
485
        lines.iter().any(|l| l.stream == "flow" && l.text.contains("subrepo deps/vault (andy/vault) is left out")),
486
        "{:?}",
487
        lines.iter().map(|l| &l.text).collect::<Vec<_>>()
488
    );
489
490
    // The job token reads its repository and the pinned lib, nothing else.
491
    let token = job["token"].as_str().unwrap().to_string();
492
    let read = |name: &str| {
493
        let opts = RemoteOptions { token: Some(token.clone()), ..Default::default() };
494
        open_remote(&format!("{}/andy/{name}", h.base), &opts).and_then(|r| r.refs()).is_ok()
495
    };
496
    assert!(read("app") && read("lib") && read("base"));
497
    assert!(!read("vault"), "not pinned for this pusher");
498
    assert!(!read("other"), "public, but not the job's to read");
499
}
500
501
#[tokio::test(flavor = "multi_thread", worker_threads = 8)]
502
async fn concurrent_log_appends_never_fail_on_a_locked_database() {
503
    let h = hub().await;
504
    create(&h.app, "andy", "demo").await;
505
    let work = tempfile::tempdir().unwrap();
506
    let c = client(&format!("{}/andy/demo", h.base), work.path());
507
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
508
    write(work.path(), "Makefile", "all:\n");
509
    c.snapshot("t").unwrap();
510
    c.commit("pipeline", &[]).unwrap();
511
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
512
    let run = runs_of(&h.app, "andy", "demo").await.remove(0);
513
    let job = db::flow::jobs(&h.app.db, run.id).await.unwrap().remove(0);
514
    // Many writers at once, each reading the count and then inserting: a
515
    // deferred transaction would fail with "database is locked".
516
    let mut tasks = Vec::new();
517
    for w in 0..16 {
518
        let pool = h.app.db.clone();
519
        tasks.push(tokio::spawn(async move {
520
            let records: Vec<flow_core::api::Record> =
521
                (0..20).map(|i| flow_core::api::Record { t: i, stream: "out".into(), text: format!("writer {w} line {i}") }).collect();
522
            db::flow::append_log(&pool, job.id, &records, 100_000).await
523
        }));
524
    }
525
    for t in tasks {
526
        assert_eq!(t.await.unwrap().unwrap(), 20, "every append succeeds");
527
    }
528
    let lines = db::flow::log(&h.app.db, job.id, 0, 1_000).await.unwrap();
529
    assert_eq!(lines.len(), 320);
530
    let seqs: std::collections::BTreeSet<i64> = lines.iter().map(|l| l.seq).collect();
531
    assert_eq!(seqs.len(), 320, "sequence numbers are unique");
532
}
533
534
/// A repository's own Flow setting overrides hub.toml either way.
535
#[tokio::test(flavor = "multi_thread")]
536
async fn a_repository_setting_turns_flow_on_or_off() {
537
    let h = hub().await;
538
    create(&h.app, "other", "plain").await;
539
    create(&h.app, "andy", "quiet").await;
540
    // A run elsewhere first, so hub-wide ids and per-repository numbers differ.
541
    create(&h.app, "andy", "first").await;
542
    {
543
        let work = tempfile::tempdir().unwrap();
544
        let c = client(&format!("{}/andy/first", h.base), work.path());
545
        write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
546
        write(work.path(), "test.sh", "echo ok\n");
547
        c.commit("Add a pipeline", &[]).unwrap();
548
        assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
549
        assert_eq!(runs_of(&h.app, "andy", "first").await.len(), 1);
550
    }
551
    let row = db::repos::get(&h.app.db, "other", "plain").await.unwrap().unwrap();
552
    db::repos::set_flow(&h.app.db, row.id, "on").await.unwrap();
553
    let quiet = db::repos::get(&h.app.db, "andy", "quiet").await.unwrap().unwrap();
554
    db::repos::set_flow(&h.app.db, quiet.id, "off").await.unwrap();
555
    for (owner, name) in [("other", "plain"), ("andy", "quiet")] {
556
        let work = tempfile::tempdir().unwrap();
557
        let c = client(&format!("{}/{owner}/{name}", h.base), work.path());
558
        write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
559
        write(work.path(), "test.sh", "echo ok\n");
560
        c.commit("Add a pipeline", &[]).unwrap();
561
        assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
562
    }
563
    let plain = runs_of(&h.app, "other", "plain").await;
564
    assert_eq!(plain.len(), 1, "turned on");
565
    // With andy/first's jobs ahead, plain's run says where it stands.
566
    let a = claim(&h.app).await.unwrap();
567
    assert_eq!(a["repo"], "andy/first");
568
    let (_, page) = call(&h.app, "GET", "/other/plain/flow/1", None, None).await;
569
    assert!(page.contains("Waiting for a runner: 3rd in line") && page.contains("Running now: andy/first #1"), "{page}");
570
    let (_, body) = call(&h.app, "GET", "/api/v1/repos/other/plain/flow/runs/1", None, None).await;
571
    assert_eq!(serde_json::from_str::<serde_json::Value>(&body).unwrap()["queue_position"], 3);
572
    let (_, list) = call(&h.app, "GET", "/other/plain/flow", None, None).await;
573
    assert!(list.contains("queued, 3rd in line"), "{list}");
574
    // Runs are numbered per repository: this is plain's first, whatever
575
    // other repositories ran before.
576
    assert_eq!(plain[0].number, 1);
577
    let checks = checks_when(&h.app, row.id, &plain[0].state, 3).await;
578
    assert!(checks.iter().all(|c| c.url.ends_with("/other/plain/flow/1")), "{checks:?}");
579
    let (st, page) = call(&h.app, "GET", "/other/plain/flow/1", None, None).await;
580
    assert!(st == StatusCode::OK && page.contains("Run #1"), "{st}");
581
    assert!(runs_of(&h.app, "andy", "quiet").await.is_empty(), "turned off despite andy/*");
582
}
583
584
/// "Run pipeline" and "Re-run" (hub spec §13.2): runs that move no
585
/// bookmark, through the API and the pages.
586
#[tokio::test(flavor = "multi_thread")]
587
async fn runs_start_without_a_push_and_finished_runs_re_run() {
588
    let h = hub().await;
589
    // The site token acts as the first site administrator.
590
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
591
    create(&h.app, "andy", "demo").await;
592
    let url = format!("{}/andy/demo", h.base);
593
    let work = tempfile::tempdir().unwrap();
594
    let c = client(&url, work.path());
595
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
596
    write(work.path(), "test.sh", "echo ok\n");
597
    c.commit("Add a pipeline", &[]).unwrap();
598
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
599
    let first = runs_of(&h.app, "andy", "demo").await;
600
    assert_eq!((first.len(), first[0].trigger.as_str()), (1, "push"));
601
602
    // Run pipeline on the default bookmark: a new run of the same state.
603
    let (st, body) = call(&h.app, "POST", "/api/v1/repos/andy/demo/flow/runs", Some("site"), Some("{}".into())).await;
604
    assert_eq!(st, StatusCode::CREATED, "{body}");
605
    let v: serde_json::Value = serde_json::from_str(&body).unwrap();
606
    assert_eq!(v["number"], 2);
607
    assert!(v["url"].as_str().unwrap().ends_with("/andy/demo/flow/2"));
608
    let second = db::flow::run(&h.app.db, first[0].repo_id, 2).await.unwrap().unwrap();
609
    assert_eq!((second.trigger.as_str(), second.actor.as_str(), second.state.as_str()), ("manual", "andy", first[0].state.as_str()));
610
    assert_eq!(db::flow::jobs(&h.app.db, second.id).await.unwrap().len(), 3);
611
    let (_, page) = call(&h.app, "GET", "/andy/demo/flow/2", None, None).await;
612
    assert!(page.contains("started by andy"), "the run page says what started it");
613
614
    // Run pipeline on one change: its state, with no bookmark.
615
    let head = first[0].head_list()[0].to_string();
616
    let (st, body) =
617
        call(&h.app, "POST", "/api/v1/repos/andy/demo/flow/runs", Some("site"), Some(format!(r#"{{"change":"{head}"}}"#))).await;
618
    assert_eq!(st, StatusCode::CREATED, "{body}");
619
    let on_change = db::flow::run(&h.app.db, first[0].repo_id, 3).await.unwrap().unwrap();
620
    assert_eq!(
621
        (on_change.bookmark.as_str(), on_change.heads.as_str(), on_change.state.as_str()),
622
        ("", head.as_str(), first[0].state.as_str())
623
    );
624
    let (_, page) = call(&h.app, "GET", "/andy/demo/flow/3", None, None).await;
625
    assert!(page.contains("title=\"Run on one change, not a bookmark\">change</span>"), "run page");
626
    let (st, body) =
627
        call(&h.app, "POST", "/api/v1/repos/andy/demo/flow/runs", Some("site"), Some(format!(r#"{{"change":"{}"}}"#, "ab".repeat(32))))
628
            .await;
629
    assert!(st == StatusCode::CONFLICT && body.contains("no change"), "{st} {body}");
630
    // Viewers who cannot start runs are told why, and get no button.
631
    let (_, page) = call(&h.app, "GET", "/andy/demo/flow", None, None).await;
632
    assert!(page.contains("Sign in with write access to run the pipeline.") && !page.contains("primary-btn"));
633
    let (_, page) = call(&h.app, "GET", "/andy/demo/bookmarks", None, None).await;
634
    assert!(!page.contains("/flow/start"), "no run buttons for anonymous viewers");
635
636
    // A live run is not re-run; unknown bookmarks and runs are refused.
637
    let (st, body) = call(&h.app, "POST", "/api/v1/repos/andy/demo/flow/runs/1/rerun", Some("site"), None).await;
638
    assert!(st == StatusCode::CONFLICT && body.contains("still queued"), "{st} {body}");
639
    let (st, _) = call(&h.app, "POST", "/api/v1/repos/andy/demo/flow/runs", Some("site"), Some(r#"{"bookmark":"nope"}"#.into())).await;
640
    assert_eq!(st, StatusCode::CONFLICT);
641
    let (st, _) = call(&h.app, "POST", "/api/v1/repos/andy/demo/flow/runs/99/rerun", Some("site"), None).await;
642
    assert_eq!(st, StatusCode::NOT_FOUND);
643
    // Anonymous callers cannot start runs.
644
    let (st, _) = call(&h.app, "POST", "/api/v1/repos/andy/demo/flow/runs", None, Some("{}".into())).await;
645
    assert_ne!(st, StatusCode::CREATED);
646
647
    // A finished run re-runs as a new run of the same state.
648
    let row = db::repos::get(&h.app.db, "andy", "demo").await.unwrap().unwrap();
649
    for r in [&first[0], &second] {
650
        for j in db::flow::jobs(&h.app.db, r.id).await.unwrap() {
651
            sqlx::query("UPDATE flow_jobs SET status = 'passed' WHERE id = ?").bind(j.id).execute(&h.app.db).await.unwrap();
652
        }
653
        sqlx::query("UPDATE flow_runs SET status = 'passed', finished_ms = 1 WHERE id = ?").bind(r.id).execute(&h.app.db).await.unwrap();
654
    }
655
    let (st, body) = call(&h.app, "POST", "/api/v1/repos/andy/demo/flow/runs/1/rerun", Some("site"), None).await;
656
    assert_eq!(st, StatusCode::CREATED, "{body}");
657
    let third = db::flow::run(&h.app.db, row.id, 4).await.unwrap().unwrap();
658
    assert_eq!(
659
        (third.trigger_label().as_str(), third.status.as_str(), third.state.as_str()),
660
        ("rerun:1", "queued", first[0].state.as_str())
661
    );
662
    assert_eq!(third.trigger, "rerun:1:push", "a rerun keeps the event it repeats");
663
    let checks = db::hooks::checks_for_state(&h.app.db, row.id, &third.state).await.unwrap();
664
    assert!(
665
        checks.iter().all(|c| c.status == "queued" && c.url.ends_with("/flow/4")),
666
        "the re-run's checks replace the old ones: {checks:?}"
667
    );
668
    let (_, page) = call(&h.app, "GET", "/andy/demo/flow/4", None, None).await;
669
    assert!(page.contains("re-run of #1 by andy"));
670
    assert!(!page.contains("RE-RUN"), "anonymous viewers get no button");
671
672
    // oxygenhub#130: one job, with what it depends on; an unknown one is
673
    // refused, naming the jobs a manual run can start.
674
    let (st, body) = call(&h.app, "POST", "/api/v1/repos/andy/demo/flow/runs", Some("site"), Some(r#"{"jobs":["test"]}"#.into())).await;
675
    assert_eq!(st, StatusCode::CREATED, "{body}");
676
    let n = serde_json::from_str::<serde_json::Value>(&body).unwrap()["number"].as_i64().unwrap();
677
    let only = db::flow::run(&h.app.db, first[0].repo_id, n).await.unwrap().unwrap();
678
    let mut names: Vec<String> = db::flow::jobs(&h.app.db, only.id).await.unwrap().into_iter().map(|j| j.name).collect();
679
    names.sort();
680
    assert_eq!(names, ["build", "test"], "test and the job it depends on, not lint");
681
    let (st, body) = call(&h.app, "POST", "/api/v1/repos/andy/demo/flow/runs", Some("site"), Some(r#"{"jobs":["deploy"]}"#.into())).await;
682
    assert!(st == StatusCode::CONFLICT && body.contains("not in the pipeline") && body.contains("build, lint, test"), "{st} {body}");
683
684
    // With Flow off, nothing starts.
685
    db::repos::set_flow(&h.app.db, row.id, "off").await.unwrap();
686
    let (st, body) = call(&h.app, "POST", "/api/v1/repos/andy/demo/flow/runs", Some("site"), Some("{}".into())).await;
687
    assert!(st == StatusCode::CONFLICT && body.contains("not enabled"), "{body}");
688
    let (_, page) = call(&h.app, "GET", "/andy/demo/flow", None, None).await;
689
    assert!(page.contains("Flow is off for this repository"), "and the Flow tab says so");
690
}
691
692
/// The Flow API (hub spec §13.2): runs, a run with its jobs, a job's log,
693
/// checks by the heads a client has, and JSON for unknown API routes.
694
#[tokio::test(flavor = "multi_thread")]
695
async fn runs_jobs_and_logs_are_in_the_api() {
696
    let h = hub().await;
697
    create(&h.app, "andy", "demo").await;
698
    let url = format!("{}/andy/demo", h.base);
699
    let work = tempfile::tempdir().unwrap();
700
    let c = client(&url, work.path());
701
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
702
    write(work.path(), "test.sh", "echo ok\n");
703
    let head = c.commit("Add a pipeline", &[]).unwrap();
704
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
705
    let run = runs_of(&h.app, "andy", "demo").await.remove(0);
706
707
    // A job runs and logs.
708
    let a = claim(&h.app).await.unwrap();
709
    let id = a["job_id"].as_i64().unwrap();
710
    let recs =
711
        serde_json::json!({ "records": [{ "t": 1, "stream": "stdout", "text": "one" }, { "t": 3, "stream": "stderr", "text": "three" }] });
712
    let (st, _) = call(&h.app, "POST", &format!("/api/v1/flow/jobs/{id}/log"), Some("runner-secret"), Some(recs.to_string())).await;
713
    assert!(st.is_success(), "{st}");
714
715
    let (st, body) = call(&h.app, "GET", "/api/v1/repos/andy/demo/flow/runs", None, None).await;
716
    assert_eq!(st, StatusCode::OK, "{body}");
717
    let runs: Vec<hub_api::FlowRun> = serde_json::from_str(&body).unwrap();
718
    assert_eq!(runs.len(), 1);
719
    assert_eq!((runs[0].number, runs[0].state.as_str(), runs[0].trigger.as_str()), (1, run.state.as_str(), "push"));
720
    assert!(runs[0].url.ends_with("/andy/demo/flow/1") && runs[0].jobs.is_empty());
721
722
    let (_, body) = call(&h.app, "GET", "/api/v1/repos/andy/demo/flow/runs/1", None, None).await;
723
    let one: hub_api::FlowRun = serde_json::from_str(&body).unwrap();
724
    let names: Vec<(&str, &str)> = one.jobs.iter().map(|j| (j.name.as_str(), j.status.as_str())).collect();
725
    assert_eq!(names.len(), 3);
726
    let running = one.jobs.iter().find(|j| j.status == "running").unwrap();
727
    assert_eq!(running.name, a["job"]["name"].as_str().unwrap());
728
    assert!(one.jobs.iter().any(|j| j.name == "test" && j.depends_on == ["build"]));
729
730
    let job = running.name.clone();
731
    let (st, body) = call(&h.app, "GET", &format!("/api/v1/repos/andy/demo/flow/runs/1/jobs/{job}/log"), None, None).await;
732
    assert_eq!(st, StatusCode::OK, "{body}");
733
    let lines: Vec<hub_api::FlowLogLine> = serde_json::from_str(&body).unwrap();
734
    assert!(lines.iter().any(|l| l.text == "three"), "{body}");
735
    let last = lines.last().unwrap().seq;
736
    let (_, body) = call(&h.app, "GET", &format!("/api/v1/repos/andy/demo/flow/runs/1/jobs/{job}/log?after={last}"), None, None).await;
737
    assert_eq!(body, "[]", "nothing after the last line");
738
    assert_eq!(call(&h.app, "GET", "/api/v1/repos/andy/demo/flow/runs/9", None, None).await.0, StatusCode::NOT_FOUND);
739
    assert_eq!(call(&h.app, "GET", "/api/v1/repos/andy/demo/flow/runs/1/jobs/nope/log", None, None).await.0, StatusCode::NOT_FOUND);
740
741
    // Checks by the state hash, by the head `oxy log` shows, and by bookmark.
742
    let by = |key: String| {
743
        let app = h.app.clone();
744
        async move {
745
            let (st, body) = call(&app, "GET", &format!("/api/v1/repos/andy/demo/checks/{key}"), None, None).await;
746
            assert_eq!(st, StatusCode::OK, "{key}: {body}");
747
            serde_json::from_str::<Vec<hub_api::Check>>(&body).unwrap().len()
748
        }
749
    };
750
    checks_when(&h.app, run.repo_id, &run.state, 3).await;
751
    assert_eq!(by(run.state.clone()).await, 3);
752
    assert_eq!(by(head.to_hex()).await, 3, "a single head names its state");
753
    assert_eq!(by("main".into()).await, 3);
754
    let (st, _) = call(&h.app, "GET", "/api/v1/repos/andy/demo/checks/no-such-bookmark", None, None).await;
755
    assert_eq!(st, StatusCode::NOT_FOUND);
756
757
    // An unknown API route answers with a problem document.
758
    let (st, body) = call(&h.app, "GET", "/api/v1/users/andy/repos", None, None).await;
759
    assert_eq!(st, StatusCode::NOT_FOUND);
760
    let v: serde_json::Value = serde_json::from_str(&body).unwrap();
761
    assert_eq!(v["status"], 404, "{body}");
762
}
763
764
async fn get_bytes(app: &Shared, path: &str) -> (StatusCode, Vec<u8>) {
765
    let res = oxygenhub::router(app.clone()).oneshot(Request::get(path).body(Body::empty()).unwrap()).await.unwrap();
766
    let status = res.status();
767
    (status, res.into_body().collect().await.unwrap().to_bytes().to_vec())
768
}
769
770
#[tokio::test(flavor = "multi_thread")]
771
async fn signed_receipts_are_checked_kept_and_shown() {
772
    use oxy_core::hash::{hash_object, ChangeHash, ObjectRef, ObjectType};
773
    use oxy_core::identity::SecretKey;
774
    use oxy_core::objects::StateObject;
775
    use oxy_core::receipt::SignedReceipt;
776
    let h = hub().await;
777
    create(&h.app, "andy", "demo").await;
778
    let url = format!("{}/andy/demo", h.base);
779
    let work = tempfile::tempdir().unwrap();
780
    let c = client(&url, work.path());
781
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
782
    c.snapshot("test").unwrap();
783
    c.commit("Add a pipeline", &[]).unwrap();
784
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
785
    let run = runs_of(&h.app, "andy", "demo").await.remove(0);
786
    let heads: Vec<ChangeHash> = run.head_list().into_iter().filter_map(ChangeHash::from_hex).collect();
787
    let state = hash_object(ObjectType::State, &StateObject::new(heads.clone()).encode());
788
    let repo_id = h.app.repos.open(&RepoName::parse("andy/demo").unwrap()).unwrap().id().unwrap();
789
    let sk = SecretKey::generate();
790
    let runner = sk.identity("test-1 (OxygenFlow runner)", "", 1);
791
    let sign = |r: &serde_json::Value, state: ObjectRef, sk: &SecretKey, id: &oxy_core::identity::Identity| {
792
        let r: flow_core::Receipt = serde_json::from_value(r.clone()).unwrap();
793
        let run_url = format!("{url}/flow/{}", run.number);
794
        hex::encode(SignedReceipt::sign(r.to_oxy(), repo_id, state, &run_url, id, sk).encode())
795
    };
796
797
    let a = claim(&h.app).await.unwrap();
798
    let b = claim(&h.app).await.unwrap();
799
    let ph = a["pipeline_hash"].as_str().unwrap().to_string();
800
    let (a_id, b_id) = (a["job_id"].as_i64().unwrap(), b["job_id"].as_i64().unwrap());
801
    // The first signed receipt binds the runner token to its key, and is kept.
802
    let rb = receipt("build", &ph, 0);
803
    let body = serde_json::json!({ "exit_code": 0, "duration_ms": 700, "receipt": rb, "signed_receipt": sign(&rb, state, &sk, &runner) });
804
    assert_eq!(finish(&h.app, a_id, body).await, StatusCode::NO_CONTENT);
805
    // Another key under the same token: the result counts, the receipt is not kept.
806
    let other = SecretKey::generate();
807
    let rl = receipt("lint", &ph, 0);
808
    let body = serde_json::json!({ "exit_code": 0, "duration_ms": 300, "receipt": rl,
809
        "signed_receipt": sign(&rl, state, &other, &other.identity("mallory", "", 1)) });
810
    assert_eq!(finish(&h.app, b_id, body).await, StatusCode::NO_CONTENT);
811
    // The right key, but for another state.
812
    let t = claim(&h.app).await.unwrap();
813
    let rt = receipt("test", &ph, 0);
814
    let body = serde_json::json!({ "exit_code": 0, "duration_ms": 500, "receipt": rt,
815
        "signed_receipt": sign(&rt, ObjectRef([9; 32]), &sk, &runner) });
816
    assert_eq!(finish(&h.app, t["job_id"].as_i64().unwrap(), body).await, StatusCode::NO_CONTENT);
817
818
    let jobs = db::flow::jobs(&h.app.db, run.id).await.unwrap();
819
    let job = |n: &str| jobs.iter().find(|j| j.name == n).unwrap().clone();
820
    assert_eq!(job("build").status, "passed");
821
    assert_eq!((job("build").receipt_attest.len(), job("build").receipt_signer.as_str()), (64, "test-1 (OxygenFlow runner)"));
822
    assert_eq!(job("lint").status, "passed", "the job's result stands");
823
    assert!(job("lint").receipt_attest.is_empty());
824
    assert!(job("lint").receipt_note.contains("not the key this runner signs with"), "{}", job("lint").receipt_note);
825
    assert!(job("test").receipt_note.contains("another state"), "{}", job("test").receipt_note);
826
827
    // The repository keeps it, and anyone who can read the repository can
828
    // download it and check it on their own.
829
    let kept = h.app.repos.open(&RepoName::parse("andy/demo").unwrap()).unwrap().receipts(&heads).unwrap();
830
    assert_eq!(kept.len(), 1);
831
    let attest = job("build").receipt_attest;
832
    let (st, bytes) = get_bytes(&h.app, &format!("/andy/demo/receipts/{attest}")).await;
833
    assert_eq!(st, StatusCode::OK);
834
    let sr = SignedReceipt::decode(&bytes).unwrap();
835
    sr.verify().unwrap();
836
    assert_eq!((sr.state(), sr.receipt.job_name.as_str()), (state, "build"));
837
    assert_eq!(get_bytes(&h.app, &format!("/andy/demo/receipts/{}", "0".repeat(64))).await.0, StatusCode::NOT_FOUND);
838
839
    // Pages: the run names the signer or why a receipt was not kept; the
840
    // change whose state it is lists it.
841
    let (_, page) = call(&h.app, "GET", &format!("/andy/demo/flow/{}", run.number), None, None).await;
842
    assert!(page.contains("signed receipt</a> by test-1"), "run page");
843
    assert!(page.contains("receipt not kept"), "run page");
844
    let (_, page) = call(&h.app, "GET", &format!("/andy/demo/change/{}", heads[0].to_hex()), None, None).await;
845
    assert!(page.contains("<dt>Receipts</dt>") && page.contains(&format!("/andy/demo/receipts/{attest}")), "change page");
846
}
847
848
async fn upload(app: &Shared, job: i64, name: &str, bytes: &[u8]) -> (StatusCode, String) {
849
    let req = Request::post(format!("/api/v1/flow/jobs/{job}/artifacts/{name}"))
850
        .header(header::AUTHORIZATION, "Bearer runner-secret")
851
        .header(header::CONTENT_TYPE, "application/octet-stream")
852
        .body(Body::from(bytes.to_vec()))
853
        .unwrap();
854
    let res = oxygenhub::router(app.clone()).oneshot(req).await.unwrap();
855
    let status = res.status();
856
    (status, String::from_utf8_lossy(&res.into_body().collect().await.unwrap().to_bytes()).into_owned())
857
}
858
859
#[tokio::test(flavor = "multi_thread")]
860
async fn artifacts_are_kept_named_by_the_receipt_and_served() {
861
    let h = hub().await;
862
    create(&h.app, "andy", "demo").await;
863
    let url = format!("{}/andy/demo", h.base);
864
    let work = tempfile::tempdir().unwrap();
865
    let c = client(&url, work.path());
866
    write(
867
        work.path(),
868
        ".flow/pipeline.kdl",
869
        &format!(
870
            "schema-version 1\nsandbox \"alpine\" {{\n    rootfs \"cas://blob/{ROOTFS}\"\n}}\njob \"build\" {{\n    sandbox \"alpine\"\n    exec \"make\"\n    output {{\n        artifact \"tool\" {{\n            path \"/src/out/tool\"\n        }}\n    }}\n}}\n"
871
        ),
872
    );
873
    c.snapshot("test").unwrap();
874
    c.commit("Build a tool", &[]).unwrap();
875
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
876
    let run = runs_of(&h.app, "andy", "demo").await.remove(0);
877
    let a = claim(&h.app).await.unwrap();
878
    assert_eq!(a["job"]["outputs"], serde_json::json!([{ "name": "tool", "path": "/src/out/tool" }]), "the runner is told");
879
    let id = a["job_id"].as_i64().unwrap();
880
881
    let body: Vec<u8> = (0..300_000u32).map(|i| (i % 253) as u8).collect();
882
    let (st, text) = upload(&h.app, id, "other", &body).await;
883
    assert_eq!(st, StatusCode::BAD_REQUEST, "an undeclared artifact: {text}");
884
    let (st, text) = upload(&h.app, id, "tool", &body).await;
885
    assert_eq!(st, StatusCode::OK, "{text}");
886
    let blob = serde_json::from_str::<serde_json::Value>(&text).unwrap()["blob"].as_str().unwrap().to_string();
887
    assert_eq!(blob, oxy_core::repo::Repo::blob_ref(&body).to_hex(), "the same blob the runner computes");
888
889
    // The receipt must name exactly the uploaded artifacts.
890
    let mut r = receipt("build", a["pipeline_hash"].as_str().unwrap(), 0);
891
    assert_eq!(
892
        finish(&h.app, id, serde_json::json!({ "exit_code": 0, "duration_ms": 700, "receipt": r.clone() })).await,
893
        StatusCode::BAD_REQUEST
894
    );
895
    r["outputs"] = serde_json::json!([blob]);
896
    assert_eq!(finish(&h.app, id, serde_json::json!({ "exit_code": 0, "duration_ms": 700, "receipt": r })).await, StatusCode::NO_CONTENT);
897
898
    // The run page lists it; anyone who can read the repository downloads it.
899
    let (_, page) = call(&h.app, "GET", &format!("/andy/demo/flow/{}", run.number), None, None).await;
900
    let link = format!("/andy/demo/flow/{}/artifacts/build/tool", run.number);
901
    assert!(page.contains(&link), "run page lists the artifact");
902
    let (st, got) = get_bytes(&h.app, &link).await;
903
    assert_eq!((st, got == body), (StatusCode::OK, true));
904
    assert_eq!(get_bytes(&h.app, &format!("/andy/demo/flow/{}/artifacts/build/none", run.number)).await.0, StatusCode::NOT_FOUND);
905
906
    // The nightly gc keeps it (#126): only the database names it, so with
907
    // no grace period a gc that did not root it would prune it at once.
908
    {
909
        let name = RepoName::parse("andy/demo").unwrap();
910
        let mut hosted = oxy_core::repo::Repo::open(&h.app.repos.dir(&name)).unwrap();
911
        hosted.config.set("core.gc-grace", "0").unwrap();
912
        hosted.save_config().unwrap();
913
    }
914
    let done = oxygenhub::maintenance::gc_all(&h.app).await;
915
    assert!(done.iter().all(|d| !d.failed), "{done:?}");
916
    let (st, got) = get_bytes(&h.app, &link).await;
917
    assert_eq!((st, got == body), (StatusCode::OK, true), "the artifact survives gc");
918
919
    // A writer attaches the artifact to a release from the run page; the
920
    // release then names the run and job that built it, as does the API.
921
    let form = |f: String| {
922
        Request::post("/register").header(header::CONTENT_TYPE, "application/x-www-form-urlencoded").body(Body::from(f)).unwrap()
923
    };
924
    let res = oxygenhub::router(h.app.clone())
925
        .oneshot(form("username=andy&email=a%40example.com&password=correct-horse-battery".into()))
926
        .await
927
        .unwrap();
928
    let cookie = res.headers().get(header::SET_COOKIE).unwrap().to_str().unwrap().split(';').next().unwrap().to_string();
929
    let with_cookie = |method: &str, path: &str, body: Option<String>| {
930
        let mut req = Request::builder().method(method).uri(path).header(header::COOKIE, cookie.clone());
931
        if body.is_some() {
932
            req = req.header(header::CONTENT_TYPE, "application/x-www-form-urlencoded");
933
        }
934
        req.body(body.map(Body::from).unwrap_or_else(Body::empty)).unwrap()
935
    };
936
    let row = db::repos::get(&h.app.db, "andy", "demo").await.unwrap().unwrap();
937
    db::releases::create(&h.app.db, row.id, "v1", "One", "", false, None).await.unwrap();
938
    let res = oxygenhub::router(h.app.clone()).oneshot(with_cookie("GET", &format!("/andy/demo/flow/{}", run.number), None)).await.unwrap();
939
    let page = String::from_utf8_lossy(&res.into_body().collect().await.unwrap().to_bytes()).into_owned();
940
    let attach = format!("/andy/demo/flow/{}/artifacts/build/tool/attach", run.number);
941
    assert!(page.contains(&attach), "a writer is offered the release");
942
    let i = page.find("name=\"_csrf\" value=\"").unwrap() + "name=\"_csrf\" value=\"".len();
943
    let csrf = page[i..].split('"').next().unwrap().to_string();
944
    let release_id = db::releases::list(&h.app.db, row.id).await.unwrap()[0].id;
945
    let res = oxygenhub::router(h.app.clone())
946
        .oneshot(with_cookie("POST", &attach, Some(format!("_csrf={csrf}&release={release_id}"))))
947
        .await
948
        .unwrap();
949
    assert_eq!(res.status(), StatusCode::SEE_OTHER);
950
    let (_, page) = call(&h.app, "GET", "/andy/demo/releases/tag/v1", None, None).await;
951
    assert!(
952
        page.contains(">tool</a>") && page.contains(&format!("built by <a href=\"/andy/demo/flow/{0}\">run #{0}</a> build", run.number)),
953
        "{page}"
954
    );
955
    let (_, api) = call(&h.app, "GET", "/api/v1/repos/andy/demo/releases", None, None).await;
956
    let api: serde_json::Value = serde_json::from_str(&api).unwrap();
957
    let asset = &api[0]["assets"][0];
958
    assert_eq!(
959
        (asset["name"].as_str(), asset["built_by"]["run"].as_i64(), asset["built_by"]["job"].as_str()),
960
        (Some("tool"), Some(run.number), Some("build"))
961
    );
962
    assert!(asset["built_by"]["receipt"].is_null(), "that receipt was not signed");
963
}
964
965
/// oxygenflow#37: a failing job keeps a `when "always"` artifact; its
966
/// receipt names none, and the run page says the file is outside it.
967
async fn upload_report_file(app: &Shared, job: i64, name: &str, path: &str, bytes: &[u8]) -> (StatusCode, String) {
968
    let req = Request::post(format!("/api/v1/flow/jobs/{job}/reports/{name}/files"))
969
        .header(header::AUTHORIZATION, "Bearer runner-secret")
970
        .header(header::CONTENT_TYPE, "application/octet-stream")
971
        .header("X-Flow-Report-Path", path)
972
        .body(Body::from(bytes.to_vec()))
973
        .unwrap();
974
    let res = oxygenhub::router(app.clone()).oneshot(req).await.unwrap();
975
    let status = res.status();
976
    (status, String::from_utf8_lossy(&res.into_body().collect().await.unwrap().to_bytes()).into_owned())
977
}
978
979
/// #127: a report's files arrive one by one, then its manifest as the
980
/// report's artifact; the hub indexes the declaration, metrics and files,
981
/// and gc keeps every file.
982
#[tokio::test(flavor = "multi_thread")]
983
async fn reports_are_kept_file_by_file_and_indexed() {
984
    let h = hub().await;
985
    create(&h.app, "andy", "demo").await;
986
    let url = format!("{}/andy/demo", h.base);
987
    let work = tempfile::tempdir().unwrap();
988
    let c = client(&url, work.path());
989
    write(
990
        work.path(),
991
        ".flow/pipeline.kdl",
992
        &format!(
993
            "schema-version 1\nsandbox \"alpine\" {{\n    rootfs \"cas://blob/{ROOTFS}\"\n}}\njob \"perf\" {{\n    sandbox \"alpine\"\n    exec \"make\"\n    output {{\n        artifact \"tool\" {{\n            path \"/src/out/tool\"\n        }}\n        report \"frame-timing\" {{\n            path \"/src/out/report\"\n            when \"always\"\n        }}\n    }}\n}}\n"
994
        ),
995
    );
996
    c.snapshot("test").unwrap();
997
    c.commit("Measure frames", &[]).unwrap();
998
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
999
    let run = runs_of(&h.app, "andy", "demo").await.remove(0);
1000
    let a = claim(&h.app).await.unwrap();
1001
    let id = a["job_id"].as_i64().unwrap();
1002
1003
    let toml = b"kind = \"performance\"\ntitle = \"Frame timing\"\nsummary = \"Median 16.4 ms\"\n\n[metrics]\nmedian_ms = { value = 16.4, unit = \"ms\", better = \"lower\", fail_above = 20 }\n\n[context]\ntarget_fps = 30\n";
1004
    let page = b"<p>frames</p>".to_vec();
1005
    let data: Vec<u8> = (0..100_000u32).map(|i| (i % 241) as u8).collect();
1006
    let (page_bytes, data_bytes) = (page.clone(), data.clone());
1007
    let files: [(&str, &[u8]); 3] = [("data/frames.csv", &data), ("index.html", &page), ("report.toml", toml)];
1008
1009
    assert_eq!(upload_report_file(&h.app, id, "tool", "report.toml", toml).await.0, StatusCode::BAD_REQUEST, "not a report");
1010
    assert_eq!(upload_report_file(&h.app, id, "frame-timing", "../x", toml).await.0, StatusCode::BAD_REQUEST, "not a clean path");
1011
    let mut listed = vec![];
1012
    for (path, bytes) in files {
1013
        let (st, text) = upload_report_file(&h.app, id, "frame-timing", path, bytes).await;
1014
        assert_eq!(st, StatusCode::OK, "{text}");
1015
        let blob = serde_json::from_str::<serde_json::Value>(&text).unwrap()["blob"].as_str().unwrap().to_string();
1016
        assert_eq!(blob, oxy_core::repo::Repo::blob_ref(bytes).to_hex());
1017
        listed.push(serde_json::json!({ "path": path, "blob": blob, "size": bytes.len() }));
1018
    }
1019
    let mut missing = listed.clone();
1020
    missing.push(serde_json::json!({ "path": "assets/x.js", "blob": "ab".repeat(32), "size": 1 }));
1021
    let (st, text) =
1022
        upload(&h.app, id, "frame-timing", &serde_json::to_vec(&serde_json::json!({ "version": 1, "files": missing })).unwrap()).await;
1023
    assert_eq!(st, StatusCode::BAD_REQUEST, "a file never uploaded: {text}");
1024
    assert!(text.contains("assets/x.js"), "{text}");
1025
    let manifest = serde_json::to_vec(&serde_json::json!({ "version": 1, "files": listed })).unwrap();
1026
    let (st, text) = upload(&h.app, id, "frame-timing", &manifest).await;
1027
    assert_eq!(st, StatusCode::OK, "{text}");
1028
1029
    let (kind, title, summary, files_n, bytes): (String, String, String, i64, i64) =
1030
        sqlx::query_as("SELECT kind, title, summary, files, bytes FROM reports WHERE job_id = ? AND name = 'frame-timing'")
1031
            .bind(id)
1032
            .fetch_one(&h.app.db)
1033
            .await
1034
            .unwrap();
1035
    assert_eq!((kind.as_str(), title.as_str(), summary.as_str()), ("performance", "Frame timing", "Median 16.4 ms"));
1036
    assert_eq!((files_n, bytes), (3, (data.len() + page.len() + toml.len()) as i64));
1037
    let rid: i64 = sqlx::query_scalar("SELECT id FROM reports WHERE job_id = ?").bind(id).fetch_one(&h.app.db).await.unwrap();
1038
    let m = oxygenhub::reports::metrics(&h.app.db, rid).await.unwrap();
1039
    assert_eq!((m[0].key.as_str(), m[0].value, m[0].fail_above), ("median_ms", 16.4, Some(20.0)));
1040
    let log = db::flow::log(&h.app.db, id, 0, 1000).await.unwrap();
1041
    assert!(log.iter().any(|r| r.text.contains("report frame-timing: performance \"Frame timing\", 1 metric")), "{log:?}");
1042
1043
    // The threshold is a check on the run's state, passing at 16.4.
1044
    let checks = db::hooks::checks_for_state(&h.app.db, run.repo_id, &run.state).await.unwrap();
1045
    let c = checks.iter().find(|c| c.name == "report/frame-timing/median_ms").expect("a check per threshold");
1046
    assert_eq!(c.status, "passed", "{c:?}");
1047
    assert!(c.summary.contains("16.4 ms") && c.url.contains("/reports/frame-timing?id="), "{c:?}");
1048
1049
    // The Reports tab, the report's page, and its own page in a sandbox.
1050
    let (_, page) = call(&h.app, "GET", "/andy/demo", None, None).await;
1051
    assert!(page.contains(">Reports</a>"), "the tab");
1052
    let (st, page) = call(&h.app, "GET", "/andy/demo/reports", None, None).await;
1053
    assert!(st == StatusCode::OK && page.contains("Frame timing") && page.contains("median_ms"), "{st}");
1054
    let (st, page) = call(&h.app, "GET", "/andy/demo/reports/frame-timing", None, None).await;
1055
    assert!(st == StatusCode::OK && page.contains("fails above 20") && page.contains("sandbox=\"allow-scripts\""), "{st}");
1056
    let src = page.split("class=\"rep-frame\" src=\"").nth(1).unwrap().split('"').next().unwrap().to_string();
1057
    assert!(src.ends_with("/index.html"), "{src}");
1058
    let res = oxygenhub::router(h.app.clone()).oneshot(Request::get(&src).body(Body::empty()).unwrap()).await.unwrap();
1059
    assert_eq!(res.status(), StatusCode::OK);
1060
    let csp = res.headers()[header::CONTENT_SECURITY_POLICY].to_str().unwrap().to_string();
1061
    assert!(csp.starts_with("sandbox allow-scripts;") && csp.contains("default-src 'none'"), "{csp}");
1062
    assert_eq!(res.headers()[header::ACCESS_CONTROL_ALLOW_ORIGIN], "*");
1063
    // The page as kept, with the frame script that sizes the frame added.
1064
    let served = res.into_body().collect().await.unwrap().to_bytes().to_vec();
1065
    assert!(served.starts_with(&page_bytes), "the report's page");
1066
    assert!(String::from_utf8_lossy(&served).contains("/static/report-frame.js"), "with the frame script");
1067
    let (st, _) = get_bytes(&h.app, "/static/report.css").await;
1068
    assert_eq!(st, StatusCode::OK, "the stylesheet a report may link");
1069
    let data = src.replace("/index.html", "/data/frames.csv");
1070
    assert_eq!(get_bytes(&h.app, &data).await, (StatusCode::OK, data_bytes.clone()));
1071
    // A link with another report's MAC, or a file it lacks, finds nothing.
1072
    // A second run of the report: the timeline has two stops, and the
1073
    // first can be compared with it (RP4).
1074
    let first: i64 = sqlx::query_scalar("SELECT id FROM reports WHERE name = 'frame-timing'").fetch_one(&h.app.db).await.unwrap();
1075
    let second: i64 = sqlx::query_scalar(
1076
        "INSERT INTO reports (repo_id, name, kind, title, summary, context, run_id, job_id, run_number, job, bookmark, state, manifest, files, bytes, created_ms) \
1077
         SELECT repo_id, name, kind, title, 'Median 18.0 ms', context, run_id, NULL, 2, job, bookmark, state, manifest, files, bytes, created_ms + 1000 FROM reports WHERE id = ? RETURNING id",
1078
    )
1079
    .bind(first)
1080
    .fetch_one(&h.app.db)
1081
    .await
1082
    .unwrap();
1083
    sqlx::query(
1084
        "INSERT INTO report_metrics (report_id, key, value, unit, better, fail_above) VALUES (?, 'median_ms', 18.0, 'ms', 'lower', 20)",
1085
    )
1086
    .bind(second)
1087
    .execute(&h.app.db)
1088
    .await
1089
    .unwrap();
1090
    let (_, page) = call(&h.app, "GET", "/andy/demo/reports/frame-timing", None, None).await;
1091
    assert_eq!(page.matches("data-tl-stop").count(), 2, "a stop per run");
1092
    assert!(page.contains("Median 18.0 ms"), "the newest run is shown");
1093
    let (_, page) = call(&h.app, "GET", &format!("/andy/demo/reports/frame-timing?id={first}&compare={second}&play=3"), None, None).await;
1094
    assert!(page.contains("This run against run #2") && page.contains("-1.6"), "every metric against the other run");
1095
    let stop = page.split("data-tl-stop").next().unwrap_or("").rsplit("href=").next().unwrap_or("").to_string();
1096
    assert!(page.contains("data-play=\"3\""), "playing");
1097
    assert!(stop.contains("play") && stop.contains('3'), "playing carries on from stop to stop: {stop}");
1098
    assert!(page.contains("data-report-runs="), "the frame interface knows the runs");
1099
    let forged = src.replacen("/files/", "/files/9", 1);
1100
    assert_eq!(get_bytes(&h.app, &forged).await.0, StatusCode::NOT_FOUND);
1101
    assert_eq!(get_bytes(&h.app, &src.replace("/index.html", "/secret.txt")).await.0, StatusCode::NOT_FOUND);
1102
    let _ = run;
1103
1104
    // gc keeps every file: only the database names them.
1105
    {
1106
        let name = RepoName::parse("andy/demo").unwrap();
1107
        let mut hosted = oxy_core::repo::Repo::open(&h.app.repos.dir(&name)).unwrap();
1108
        hosted.config.set("core.gc-grace", "0").unwrap();
1109
        hosted.save_config().unwrap();
1110
    }
1111
    let done = oxygenhub::maintenance::gc_all(&h.app).await;
1112
    assert!(done.iter().all(|d| !d.failed), "{done:?}");
1113
    let hosted = h.app.repos.open(&RepoName::parse("andy/demo").unwrap()).unwrap();
1114
    for (path, bytes) in files {
1115
        assert_eq!(hosted.read_blob(&oxy_core::repo::Repo::blob_ref(bytes)).unwrap(), bytes, "{path} survives gc");
1116
    }
1117
}
1118
1119
#[tokio::test(flavor = "multi_thread")]
1120
async fn a_failing_job_keeps_an_artifact_outside_its_receipt() {
1121
    let h = hub().await;
1122
    create(&h.app, "andy", "demo").await;
1123
    let url = format!("{}/andy/demo", h.base);
1124
    let work = tempfile::tempdir().unwrap();
1125
    let c = client(&url, work.path());
1126
    write(
1127
        work.path(),
1128
        ".flow/pipeline.kdl",
1129
        &format!(
1130
            "schema-version 1\nsandbox \"alpine\" {{\n    rootfs \"cas://blob/{ROOTFS}\"\n}}\njob \"test\" {{\n    sandbox \"alpine\"\n    exec \"make\" \"test\"\n    output {{\n        artifact \"junit\" {{\n            path \"/src/out/junit.xml\"\n            when \"always\"\n        }}\n    }}\n}}\n"
1131
        ),
1132
    );
1133
    c.snapshot("test").unwrap();
1134
    c.commit("Test", &[]).unwrap();
1135
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1136
    let run = runs_of(&h.app, "andy", "demo").await.remove(0);
1137
    let a = claim(&h.app).await.unwrap();
1138
    assert_eq!(a["job"]["outputs"][0]["always"], true, "the runner is told to keep it from a failing job");
1139
    let id = a["job_id"].as_i64().unwrap();
1140
    // A JUnit report (#114): parsed on upload, counted, failures listed.
1141
    let xml = br#"<testsuites><testsuite name="pytest"><testcase classname="tests.test_io" name="test_read" time="0.5"/><testcase classname="tests.test_io" name="test_write" time="1.5"><failure message="disk full">E   OSError: disk full</failure></testcase></testsuite></testsuites>"#;
1142
    let (st, text) = upload(&h.app, id, "junit", xml).await;
1143
    assert_eq!(st, StatusCode::OK, "{text}");
1144
    let blob = serde_json::from_str::<serde_json::Value>(&text).unwrap()["blob"].as_str().unwrap().to_string();
1145
    let mut r = receipt("test", a["pipeline_hash"].as_str().unwrap(), 1);
1146
    r["outputs"] = serde_json::json!([blob]);
1147
    assert_eq!(
1148
        finish(&h.app, id, serde_json::json!({ "exit_code": 1, "duration_ms": 700, "receipt": r.clone() })).await,
1149
        StatusCode::BAD_REQUEST,
1150
        "a failing receipt names no outputs"
1151
    );
1152
    r["outputs"] = serde_json::json!([]);
1153
    assert_eq!(finish(&h.app, id, serde_json::json!({ "exit_code": 1, "duration_ms": 700, "receipt": r })).await, StatusCode::NO_CONTENT);
1154
    let (_, page) = call(&h.app, "GET", &format!("/andy/demo/flow/{}", run.number), None, None).await;
1155
    assert!(page.contains(&format!("/andy/demo/flow/{}/artifacts/test/junit", run.number)), "listed");
1156
    assert!(page.contains("not in its receipt"), "marked");
1157
    assert!(page.contains("2 tests: 1 failed"), "counts beside the job");
1158
    assert!(page.contains("tests.test_io::test_write") && page.contains("disk full") && page.contains("OSError"), "the failure");
1159
    assert!(page.contains("tests: 2 tests: 1 failed in 2.0 s"), "said in the job's log");
1160
}
1161
1162
/// A release's trust report (hub spec §9.1): a signed tag, an asset built
1163
/// by a job with a signed receipt from the tagged state, and one uploaded
1164
/// by hand; the page, its JSON export and the API.
1165
#[tokio::test(flavor = "multi_thread")]
1166
async fn a_release_is_audited_from_authors_to_receipts() {
1167
    use oxy_core::hash::{hash_object, ChangeHash, ObjectType};
1168
    use oxy_core::identity::SecretKey;
1169
    use oxy_core::objects::StateObject;
1170
    use oxy_core::receipt::SignedReceipt;
1171
    let h = hub().await;
1172
    create(&h.app, "andy", "demo").await;
1173
    let url = format!("{}/andy/demo", h.base);
1174
    let work = tempfile::tempdir().unwrap();
1175
    let mut c = client(&url, work.path());
1176
    c.create_identity("Andy", "[email protected]", oxy_core::repo::IdentityScope::Repo).unwrap();
1177
    write(
1178
        work.path(),
1179
        ".flow/pipeline.kdl",
1180
        &format!(
1181
            "schema-version 1\nsandbox \"alpine\" {{\n    rootfs \"cas://blob/{ROOTFS}\"\n}}\njob \"build\" {{\n    sandbox \"alpine\"\n    exec \"make\"\n    output {{\n        artifact \"tool\" {{\n            path \"/src/out/tool\"\n        }}\n    }}\n}}\n"
1182
        ),
1183
    );
1184
    c.snapshot("test").unwrap();
1185
    c.commit("Build a tool", &[]).unwrap();
1186
    let heads = c.bookmark_heads().unwrap();
1187
    c.tag_create("v1", &heads, "first").unwrap();
1188
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1189
1190
    // The runner builds, uploads the artifact and signs its receipt.
1191
    let run = runs_of(&h.app, "andy", "demo").await.remove(0);
1192
    let a = claim(&h.app).await.unwrap();
1193
    let id = a["job_id"].as_i64().unwrap();
1194
    let body: Vec<u8> = b"#!/bin/sh\necho tool\n".to_vec();
1195
    let (_, text) = upload(&h.app, id, "tool", &body).await;
1196
    let blob = serde_json::from_str::<serde_json::Value>(&text).unwrap()["blob"].as_str().unwrap().to_string();
1197
    let mut r = receipt("build", a["pipeline_hash"].as_str().unwrap(), 0);
1198
    r["outputs"] = serde_json::json!([blob]);
1199
    let heads_run: Vec<ChangeHash> = run.head_list().into_iter().filter_map(ChangeHash::from_hex).collect();
1200
    let state = hash_object(ObjectType::State, &StateObject::new(heads_run).encode());
1201
    let repo_id = h.app.repos.open(&RepoName::parse("andy/demo").unwrap()).unwrap().id().unwrap();
1202
    let sk = SecretKey::generate();
1203
    let runner = sk.identity("test-1 (OxygenFlow runner)", "", 1);
1204
    let fr: flow_core::Receipt = serde_json::from_value(r.clone()).unwrap();
1205
    let signed = hex::encode(SignedReceipt::sign(fr.to_oxy(), repo_id, state, &format!("{url}/flow/1"), &runner, &sk).encode());
1206
    let done = serde_json::json!({ "exit_code": 0, "duration_ms": 900, "receipt": r, "signed_receipt": signed });
1207
    assert_eq!(finish(&h.app, id, done).await, StatusCode::NO_CONTENT);
1208
1209
    // A release with the built asset and a file uploaded by hand.
1210
    let row = db::repos::get(&h.app.db, "andy", "demo").await.unwrap().unwrap();
1211
    let rel = db::releases::create(&h.app.db, row.id, "v1", "One", "", false, None).await.unwrap();
1212
    oxygenhub::web::releases::store_asset(&h.app, rel.id, "tool", "", &body).await.unwrap();
1213
    oxygenhub::web::releases::store_asset(&h.app, rel.id, "notes.txt", "", b"by hand\n").await.unwrap();
1214
1215
    let (st, page) = call(&h.app, "GET", "/andy/demo/releases/trust/v1", None, None).await;
1216
    assert_eq!(st, StatusCode::OK);
1217
    for want in [
1218
        "Tag v1 is signed",
1219
        "The one change in the release is authenticated",
1220
        "tool: signed receipt from run #1 build",
1221
        "a runner key of this hub",
1222
        "tool: built from the tagged state",
1223
        "tool: pinned environment",
1224
        "notes.txt: no build found",
1225
        "<svg class=\"trust-graph\"",
1226
        // oxygenhub#79: a summary of badges, badges in the graph, and the
1227
        // graph drawn at its own size rather than stretched to the page.
1228
        "Tag signed by",
1229
        "1 of 1 changes signed or sealed",
1230
        "1 of 2 assets built and attested by OxygenFlow",
1231
        "attested build",
1232
        "uploaded by hand",
1233
        "receipt verified",
1234
        "class=\"shackle\"",
1235
        "<title>notes.txt:",
1236
    ] {
1237
        assert!(page.contains(want), "missing {want:?}");
1238
    }
1239
    let svg = &page[page.find("<svg class=\"trust-graph\"").unwrap()..];
1240
    assert!(svg[..200].contains(" width=\"") && svg[..200].contains(" height=\""), "the graph has its own size: {}", &svg[..200]);
1241
    let (_, releases) = call(&h.app, "GET", "/andy/demo/releases", None, None).await;
1242
    assert!(releases.contains("/andy/demo/releases/trust/v1"), "the release links its audit");
1243
1244
    // The export carries the signed receipt, which checks on its own.
1245
    let (st, json) = call(&h.app, "GET", "/andy/demo/releases/trust/v1?format=json", None, None).await;
1246
    assert_eq!(st, StatusCode::OK);
1247
    let t: serde_json::Value = serde_json::from_str(&json).unwrap();
1248
    assert_eq!((t["tag"].as_str(), t["tag_signature"].as_str(), t["changes"].as_i64()), (Some("v1"), Some("valid"), Some(1)));
1249
    assert_eq!(t["authors"][0]["who"]["name"], "Andy");
1250
    let tool = t["assets"].as_array().unwrap().iter().find(|a| a["name"] == "tool").unwrap();
1251
    let hex_receipt = tool["build"]["signed_receipt"].as_str().unwrap();
1252
    let sr = SignedReceipt::decode(&hex::decode(hex_receipt).unwrap()).unwrap();
1253
    sr.verify().unwrap();
1254
    assert_eq!(sr.receipt.outputs[0].to_hex(), blob);
1255
    let audit = t["audit"].as_array().unwrap();
1256
    assert!(audit.iter().any(|c| c["verdict"] == "warn" && c["title"].as_str().unwrap().starts_with("notes.txt")));
1257
    assert!(!audit.iter().any(|c| c["verdict"] == "fail"), "{audit:?}");
1258
    // The API gives the same report; an unknown release is a 404.
1259
    let (st, api) = call(&h.app, "GET", "/api/v1/repos/andy/demo/releases/trust/v1", None, None).await;
1260
    assert_eq!(st, StatusCode::OK);
1261
    assert_eq!(serde_json::from_str::<serde_json::Value>(&api).unwrap()["assets"].as_array().unwrap().len(), 2);
1262
    assert_eq!(call(&h.app, "GET", "/api/v1/repos/andy/demo/releases/trust/v9", None, None).await.0, StatusCode::NOT_FOUND);
1263
    assert_eq!(call(&h.app, "GET", "/andy/demo/releases/trust/v9", None, None).await.0, StatusCode::NOT_FOUND);
1264
}
1265
1266
/// Runners (hub spec §13.2): an administrator makes a registration token,
1267
/// a runner registers with it (binding its key), claims, shows on Admin →
1268
/// Runners with its history, and is drained, disabled and removed.
1269
#[tokio::test(flavor = "multi_thread")]
1270
async fn runners_register_show_their_history_and_are_drained_and_removed() {
1271
    use oxy_core::identity::SecretKey;
1272
    let h = hub().await;
1273
    create(&h.app, "andy", "demo").await;
1274
    // A signed-in site administrator.
1275
    let res = oxygenhub::router(h.app.clone())
1276
        .oneshot(
1277
            Request::post("/register")
1278
                .header(header::CONTENT_TYPE, "application/x-www-form-urlencoded")
1279
                .body(Body::from("username=carol&email=carol%40example.com&password=correct-horse-battery"))
1280
                .unwrap(),
1281
        )
1282
        .await
1283
        .unwrap();
1284
    let cookie = res.headers().get(header::SET_COOKIE).unwrap().to_str().unwrap().split(';').next().unwrap().to_string();
1285
    let admin = db::accounts::account_by_name(&h.app.db, "carol").await.unwrap().unwrap();
1286
    db::accounts::set_admin(&h.app.db, admin.id, true).await.unwrap();
1287
    let web = |method: &'static str, path: String, body: Option<String>| {
1288
        let (app, cookie) = (h.app.clone(), cookie.clone());
1289
        async move {
1290
            let mut req = Request::builder().method(method).uri(path).header(header::COOKIE, cookie);
1291
            if body.is_some() {
1292
                req = req.header(header::CONTENT_TYPE, "application/x-www-form-urlencoded");
1293
            }
1294
            let res = oxygenhub::router(app).oneshot(req.body(body.map(Body::from).unwrap_or_else(Body::empty)).unwrap()).await.unwrap();
1295
            let st = res.status();
1296
            (st, String::from_utf8_lossy(&res.into_body().collect().await.unwrap().to_bytes()).into_owned())
1297
        }
1298
    };
1299
    let csrf_of = |page: &str| {
1300
        let i = page.find("name=\"_csrf\" value=\"").unwrap() + "name=\"_csrf\" value=\"".len();
1301
        page[i..].split('"').next().unwrap().to_string()
1302
    };
1303
    let (st, page) = web("GET", "/admin/runners".into(), None).await;
1304
    assert_eq!(st, StatusCode::OK);
1305
    assert!(page.contains("No runners yet"));
1306
    assert_eq!(call(&h.app, "GET", "/admin/runners", None, None).await.0, StatusCode::NOT_FOUND, "administrators only");
1307
1308
    // A one-time registration token, shown once with the command.
1309
    let (_, page) = web("POST", "/admin/runners/token".into(), Some(format!("_csrf={}", csrf_of(&page)))).await;
1310
    let i = page.find("--token ").unwrap() + "--token ".len();
1311
    let token: String = page[i..].chars().take_while(|c| !c.is_whitespace()).collect();
1312
    assert!(token.starts_with("flowreg_"), "{token}");
1313
1314
    // The runner registers, binding its key; the token then is spent.
1315
    let sk = SecretKey::generate();
1316
    let identity = sk.identity("plex (OxygenFlow runner)", "", 1);
1317
    let info = serde_json::json!({ "arch": "x86_64", "os": "linux", "version": "0.1.0", "labels": ["big-disk"], "max_jobs": 2, "memory_mib": 16384, "cpus": 4 });
1318
    let reg = serde_json::json!({ "token": token, "name": "plex", "identity": hex::encode(identity.encode()), "info": info });
1319
    let (st, body) = call(&h.app, "POST", "/api/v1/flow/runners/register", None, Some(reg.to_string())).await;
1320
    assert_eq!(st, StatusCode::OK, "{body}");
1321
    let credential = serde_json::from_str::<serde_json::Value>(&body).unwrap()["credential"].as_str().unwrap().to_string();
1322
    assert!(credential.starts_with("flowrunner_"));
1323
    assert_eq!(
1324
        call(&h.app, "POST", "/api/v1/flow/runners/register", None, Some(reg.to_string())).await.0,
1325
        StatusCode::FORBIDDEN,
1326
        "used once"
1327
    );
1328
1329
    // It claims with its credential; the hub.toml runner shows too.
1330
    let claim_as = |who: String| {
1331
        let app = h.app.clone();
1332
        let info = info.clone();
1333
        async move {
1334
            let body = serde_json::json!({ "runner": "ignored", "runtimes": ["microvm"], "info": info }).to_string();
1335
            call(&app, "POST", "/api/v1/flow/claim", Some(&who), Some(body)).await
1336
        }
1337
    };
1338
    assert_eq!(claim_as(credential.clone()).await.0, StatusCode::NO_CONTENT, "nothing queued");
1339
    assert_eq!(claim(&h.app).await, None);
1340
    let (_, page) = web("GET", "/admin/runners".into(), None).await;
1341
    assert!(
1342
        page.contains(">plex</strong>") && page.contains("st-online") && page.contains("x86_64 · linux") && page.contains("big-disk"),
1343
        "{page}"
1344
    );
1345
    assert!(page.contains(">test-1</strong>") && page.contains("hub.toml"), "the configured runner, by its claimed name");
1346
    let plex = db::runners::list(&h.app.db).await.unwrap().into_iter().find(|r| r.name == "plex").unwrap();
1347
    assert_eq!(plex.key, identity.hash().to_hex(), "bound at registration");
1348
1349
    // A run: plex takes a job, and its history shows it.
1350
    let url = format!("{}/andy/demo", h.base);
1351
    let work = tempfile::tempdir().unwrap();
1352
    let c = client(&url, work.path());
1353
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
1354
    c.snapshot("test").unwrap();
1355
    c.commit("Add a pipeline", &[]).unwrap();
1356
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1357
    runs_of(&h.app, "andy", "demo").await;
1358
    let (st, body) = claim_as(credential.clone()).await;
1359
    assert_eq!(st, StatusCode::OK, "{body}");
1360
    let job: serde_json::Value = serde_json::from_str(&body).unwrap();
1361
    let (_, page) = web("GET", format!("/admin/runners/{}", plex.id), None).await;
1362
    assert!(
1363
        page.contains("andy/demo") && page.contains(job["job"]["name"].as_str().unwrap()) && page.contains("Running now</dt><dd>1 job"),
1364
        "{page}"
1365
    );
1366
    // The queue on Admin → Runners and through the API (#41, part 4).
1367
    let (_, page) = web("GET", "/admin/runners".into(), None).await;
1368
    assert!(page.contains("<h2>Queue</h2>") && page.contains("<td>plex</td>"), "{page}");
1369
    let (_, tokens) = web("GET", "/settings/tokens".into(), None).await;
1370
    let (_, made) = web("POST", "/settings/tokens".into(), Some(format!("_csrf={}&name=admin&scopes=user%3Aread", csrf_of(&tokens)))).await;
1371
    let i = made.find("oxyhub_").unwrap();
1372
    let admin_token: String = made[i..].chars().take_while(|c| c.is_ascii_alphanumeric() || *c == '_').collect();
1373
    let (st, body) = call(&h.app, "GET", "/api/v1/runners", Some(&admin_token), None).await;
1374
    assert_eq!(st, StatusCode::OK, "{body}");
1375
    let listed: serde_json::Value = serde_json::from_str(&body).unwrap();
1376
    let plex_row = listed.as_array().unwrap().iter().find(|r| r["name"] == "plex").unwrap();
1377
    assert_eq!((plex_row["running"].as_i64(), plex_row["arch"].as_str()), (Some(1), Some("x86_64")));
1378
    // A runner's own labels and time limit from its page (#98).
1379
    let (_, page) = web("GET", format!("/admin/runners/{}", plex.id), None).await;
1380
    let (st, _) = web(
1381
        "POST",
1382
        format!("/admin/runners/{}/limits", plex.id),
1383
        Some(format!("_csrf={}&labels=gpu%2C+plex&timeout_minutes=5", csrf_of(&page))),
1384
    )
1385
    .await;
1386
    assert_eq!(st, StatusCode::SEE_OTHER);
1387
    let (_, page) = web("GET", format!("/admin/runners/{}", plex.id), None).await;
1388
    assert!(page.contains(">gpu<") && page.contains("5 min for its jobs"), "{page}");
1389
    let (_, body) = call(&h.app, "GET", "/api/v1/runners", Some(&admin_token), None).await;
1390
    let listed: serde_json::Value = serde_json::from_str(&body).unwrap();
1391
    let plex_row = listed.as_array().unwrap().iter().find(|r| r["name"] == "plex").unwrap();
1392
    assert!(plex_row["labels"].as_array().unwrap().iter().any(|l| l == "gpu"), "{plex_row}");
1393
    let (st, _) = web(
1394
        "POST",
1395
        format!("/admin/runners/{}/limits", plex.id),
1396
        Some(format!("_csrf={}&labels=bad%20label%21&timeout_minutes=", csrf_of(&page))),
1397
    )
1398
    .await;
1399
    assert_eq!(st, StatusCode::BAD_REQUEST, "a label with a space or punctuation is refused");
1400
    let (_, body) = call(&h.app, "GET", "/api/v1/runners/queue", Some(&admin_token), None).await;
1401
    let queue: serde_json::Value = serde_json::from_str(&body).unwrap();
1402
    assert!(queue.as_array().unwrap().iter().any(|q| q["status"] == "running" && q["runner"] == "plex"), "{queue}");
1403
    let (_, body) = call(&h.app, "GET", &format!("/api/v1/runners/{}/jobs", plex.id), Some(&admin_token), None).await;
1404
    let jobs: serde_json::Value = serde_json::from_str(&body).unwrap();
1405
    assert_eq!(jobs[0]["repo"], "andy/demo", "{jobs}");
1406
    assert_eq!(call(&h.app, "GET", "/api/v1/runners", None, None).await.0, StatusCode::NOT_FOUND, "administrators only");
1407
1408
    // Draining: no new work; removing while busy is refused.
1409
    let (_, page) = web("GET", "/admin/runners".into(), None).await;
1410
    let csrf = csrf_of(&page);
1411
    web("POST", format!("/admin/runners/{}/state", plex.id), Some(format!("_csrf={csrf}&state=draining"))).await;
1412
    assert_eq!(claim_as(credential.clone()).await.0, StatusCode::NO_CONTENT, "a draining runner takes nothing");
1413
    let (_, page) = web("POST", format!("/admin/runners/{}/remove", plex.id), Some(format!("_csrf={csrf}"))).await;
1414
    assert!(page.contains("is running jobs: drain it first"), "{page}");
1415
    // Its job finishes; disabled, it is refused; removed, its credential is dead.
1416
    let id = job["job_id"].as_i64().unwrap();
1417
    let done = call(
1418
        &h.app,
1419
        "POST",
1420
        &format!("/api/v1/flow/jobs/{id}/finish"),
1421
        Some(&credential),
1422
        Some(r#"{"exit_code":0,"duration_ms":5}"#.into()),
1423
    )
1424
    .await;
1425
    assert_eq!(done.0, StatusCode::NO_CONTENT);
1426
    web("POST", format!("/admin/runners/{}/state", plex.id), Some(format!("_csrf={csrf}&state=disabled"))).await;
1427
    assert_eq!(claim_as(credential.clone()).await.0, StatusCode::FORBIDDEN);
1428
    let (_, page) = web("POST", format!("/admin/runners/{}/remove", plex.id), Some(format!("_csrf={csrf}"))).await;
1429
    assert!(page.contains("Removed plex."), "{page}");
1430
    assert_eq!(claim_as(credential).await.0, StatusCode::UNAUTHORIZED);
1431
}
1432
1433
/// Runner scopes (oxygenhub#41): a runner registered for one repository, or
1434
/// one owner, takes only those jobs; a site runner takes any.
1435
#[tokio::test(flavor = "multi_thread")]
1436
async fn scoped_runners_take_only_their_scope() {
1437
    use oxy_core::identity::SecretKey;
1438
    let h = hub().await;
1439
    create(&h.app, "andy", "demo").await;
1440
    create(&h.app, "andy", "other").await;
1441
    let register = |scope: db::runners::Scope, name: &'static str| {
1442
        let app = h.app.clone();
1443
        async move {
1444
            let token = format!("flowreg_{name}");
1445
            db::runners::add_registration(&app.db, &blake3::hash(token.as_bytes()).to_hex(), "admin", &scope).await.unwrap();
1446
            let identity = SecretKey::generate().identity(name, "", 1);
1447
            let info = serde_json::json!({ "arch": "x86_64", "os": "linux", "version": "0.1.0", "labels": [], "max_jobs": 1 });
1448
            let reg = serde_json::json!({ "token": token, "name": name, "identity": hex::encode(identity.encode()), "info": info });
1449
            let (st, body) = call(&app, "POST", "/api/v1/flow/runners/register", None, Some(reg.to_string())).await;
1450
            assert_eq!(st, StatusCode::OK, "{body}");
1451
            serde_json::from_str::<serde_json::Value>(&body).unwrap()["credential"].as_str().unwrap().to_string()
1452
        }
1453
    };
1454
    let demo = db::repos::get(&h.app.db, "andy", "demo").await.unwrap().unwrap();
1455
    let only_demo = register(db::runners::Scope { owner: "andy".into(), repo_id: Some(demo.id) }, "demo-runner").await;
1456
    let carols = register(db::runners::Scope { owner: "carol".into(), repo_id: None }, "carol-runner").await;
1457
    let andys = register(db::runners::Scope { owner: "andy".into(), repo_id: None }, "andy-runner").await;
1458
    let claim_as = |who: String| {
1459
        let app = h.app.clone();
1460
        async move {
1461
            let body = serde_json::json!({ "runner": "x", "runtimes": ["microvm"] }).to_string();
1462
            let (st, body) = call(&app, "POST", "/api/v1/flow/claim", Some(&who), Some(body)).await;
1463
            (st == StatusCode::OK).then(|| serde_json::from_str::<serde_json::Value>(&body).unwrap()["repo"].as_str().unwrap().to_string())
1464
        }
1465
    };
1466
    // Jobs queued in andy/other only.
1467
    let work = tempfile::tempdir().unwrap();
1468
    let c = client(&format!("{}/andy/other", h.base), work.path());
1469
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
1470
    c.snapshot("t").unwrap();
1471
    c.commit("pipeline", &[]).unwrap();
1472
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1473
    assert!(!runs_of(&h.app, "andy", "other").await.is_empty());
1474
    assert_eq!(claim_as(only_demo.clone()).await, None, "nothing of andy/demo is queued");
1475
    assert_eq!(claim_as(carols).await, None, "nothing of carol's");
1476
    assert_eq!(claim_as(andys).await.as_deref(), Some("andy/other"), "the owner's runner takes its repositories' jobs");
1477
    // The site runner (hub.toml) takes any.
1478
    assert_eq!(claim(&h.app).await.unwrap()["repo"], "andy/other");
1479
    assert_eq!(claim_as(only_demo).await, None, "still nothing of its own");
1480
}
1481
1482
/// Settings → Runners (oxygenhub#41, part 2b): a repository's admin adds a
1483
/// runner for that repository alone, sees which runners serve it, and
1484
/// removes only its own.
1485
#[tokio::test(flavor = "multi_thread")]
1486
async fn repository_admins_add_and_remove_their_own_runners() {
1487
    use oxy_core::identity::SecretKey;
1488
    let h = hub().await;
1489
    let res = oxygenhub::router(h.app.clone())
1490
        .oneshot(
1491
            Request::post("/register")
1492
                .header(header::CONTENT_TYPE, "application/x-www-form-urlencoded")
1493
                .body(Body::from("username=andy&email=andy%40example.com&password=correct-horse-battery"))
1494
                .unwrap(),
1495
        )
1496
        .await
1497
        .unwrap();
1498
    let cookie = res.headers().get(header::SET_COOKIE).unwrap().to_str().unwrap().split(';').next().unwrap().to_string();
1499
    create(&h.app, "andy", "demo").await;
1500
    let demo = db::repos::get(&h.app.db, "andy", "demo").await.unwrap().unwrap();
1501
    let web = |method: &'static str, path: String, body: Option<String>| {
1502
        let (app, cookie) = (h.app.clone(), cookie.clone());
1503
        async move {
1504
            let mut req = Request::builder().method(method).uri(path).header(header::COOKIE, cookie);
1505
            if body.is_some() {
1506
                req = req.header(header::CONTENT_TYPE, "application/x-www-form-urlencoded");
1507
            }
1508
            let res = oxygenhub::router(app).oneshot(req.body(body.map(Body::from).unwrap_or_else(Body::empty)).unwrap()).await.unwrap();
1509
            let st = res.status();
1510
            (st, String::from_utf8_lossy(&res.into_body().collect().await.unwrap().to_bytes()).into_owned())
1511
        }
1512
    };
1513
    let csrf_of = |page: &str| {
1514
        let i = page.find("name=\"_csrf\" value=\"").unwrap() + "name=\"_csrf\" value=\"".len();
1515
        page[i..].split('"').next().unwrap().to_string()
1516
    };
1517
    let (st, page) = web("GET", "/andy/demo/settings".into(), None).await;
1518
    assert_eq!(st, StatusCode::OK);
1519
    assert!(page.contains("<h2>Runners</h2>"), "the owner sees the section");
1520
    let (_, page) = web("POST", "/andy/demo/settings/runners/token".into(), Some(format!("_csrf={}", csrf_of(&page)))).await;
1521
    let i = page.find("--token ").unwrap() + "--token ".len();
1522
    let token: String = page[i..].chars().take_while(|c| !c.is_whitespace()).collect();
1523
    let identity = SecretKey::generate().identity("mine", "", 1);
1524
    let info = serde_json::json!({ "arch": "x86_64", "os": "linux", "version": "0.1.0", "labels": [], "max_jobs": 1 });
1525
    let reg = serde_json::json!({ "token": token, "name": "mine", "identity": hex::encode(identity.encode()), "info": info });
1526
    let (st, body) = call(&h.app, "POST", "/api/v1/flow/runners/register", None, Some(reg.to_string())).await;
1527
    assert_eq!(st, StatusCode::OK, "{body}");
1528
    let mine = db::runners::list(&h.app.db).await.unwrap().into_iter().find(|r| r.name == "mine").unwrap();
1529
    assert_eq!(mine.scope(), db::runners::Scope { owner: "andy".into(), repo_id: Some(demo.id) });
1530
    // The site's runner (hub.toml, from its first claim) serves it too, but is not the owner's to remove.
1531
    claim(&h.app).await;
1532
    let site = db::runners::list(&h.app.db).await.unwrap().into_iter().find(|r| r.name == "test-1").unwrap();
1533
    let (_, page) = web("GET", "/andy/demo/settings".into(), None).await;
1534
    assert!(page.contains("<strong>mine</strong>") && page.contains("this repository"), "{page}");
1535
    assert!(page.contains("<strong>test-1</strong>") && page.contains("the whole site"), "{page}");
1536
    let csrf = csrf_of(&page);
1537
    let (st, _) = web("POST", format!("/andy/demo/settings/runners/{}/remove", site.id), Some(format!("_csrf={csrf}"))).await;
1538
    assert_eq!(st, StatusCode::NOT_FOUND, "not the repository's own");
1539
    let (_, page) = web("POST", format!("/andy/demo/settings/runners/{}/remove", mine.id), Some(format!("_csrf={csrf}"))).await;
1540
    assert!(page.contains("mine removed"), "{page}");
1541
    assert!(db::runners::get(&h.app.db, mine.id).await.unwrap().is_none());
1542
1543
    // The same for an organisation's owner.
1544
    let (_, page) = web("GET", "/orgs/new".into(), None).await;
1545
    web("POST", "/orgs/new".into(), Some(format!("_csrf={}&name=acme&display_name=Acme", csrf_of(&page)))).await;
1546
    let (st, page) = web("GET", "/orgs/acme/settings".into(), None).await;
1547
    assert_eq!(st, StatusCode::OK);
1548
    let (_, page) = web("POST", "/orgs/acme/settings/runners/token".into(), Some(format!("_csrf={}", csrf_of(&page)))).await;
1549
    let i = page.find("--token ").unwrap() + "--token ".len();
1550
    let token: String = page[i..].chars().take_while(|c| !c.is_whitespace()).collect();
1551
    let identity = SecretKey::generate().identity("acme-runner", "", 1);
1552
    let reg = serde_json::json!({ "token": token, "name": "acme-runner", "identity": hex::encode(identity.encode()), "info": info });
1553
    assert_eq!(call(&h.app, "POST", "/api/v1/flow/runners/register", None, Some(reg.to_string())).await.0, StatusCode::OK);
1554
    let acme = db::runners::list(&h.app.db).await.unwrap().into_iter().find(|r| r.name == "acme-runner").unwrap();
1555
    assert_eq!(acme.scope(), db::runners::Scope { owner: "acme".into(), repo_id: None });
1556
    let (_, page) = web("GET", "/orgs/acme/settings".into(), None).await;
1557
    assert!(page.contains("<strong>acme-runner</strong>") && page.contains("the organisation's repositories"), "{page}");
1558
    let (_, page) = web("POST", format!("/orgs/acme/settings/runners/{}/remove", acme.id), Some(format!("_csrf={}", csrf_of(&page)))).await;
1559
    assert!(page.contains("acme-runner removed"), "{page}");
1560
}
1561
1562
/// runs-on (oxygenhub#41, part 3): a job that asks for a label goes only to
1563
/// a runner that has it, and waits for one otherwise.
1564
#[tokio::test(flavor = "multi_thread")]
1565
async fn jobs_that_ask_for_labels_wait_for_a_runner_with_them() {
1566
    use oxy_core::identity::SecretKey;
1567
    let h = hub().await;
1568
    create(&h.app, "andy", "demo").await;
1569
    let work = tempfile::tempdir().unwrap();
1570
    let c = client(&format!("{}/andy/demo", h.base), work.path());
1571
    let cross = "job \"cross\" {\n    sandbox \"alpine\"\n    runs-on \"riscv64\"\n    exec \"true\"\n}\n";
1572
    write(work.path(), ".flow/pipeline.kdl", &pipeline(cross));
1573
    c.snapshot("t").unwrap();
1574
    c.commit("pipeline", &[]).unwrap();
1575
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1576
    assert!(!runs_of(&h.app, "andy", "demo").await.is_empty());
1577
    // The site runner has no labels: it takes the others, never cross.
1578
    let mut taken = Vec::new();
1579
    while let Some(j) = claim(&h.app).await {
1580
        taken.push(j["job"]["name"].as_str().unwrap().to_string());
1581
    }
1582
    assert!(!taken.contains(&"cross".to_string()) && taken.contains(&"lint".to_string()), "{taken:?}");
1583
    let queue = db::flow::queue(&h.app.db).await.unwrap();
1584
    let waiting = queue.iter().find(|q| q.job == "cross").unwrap();
1585
    assert_eq!((waiting.status.as_str(), waiting.needs()), ("queued", vec!["riscv64".to_string()]));
1586
    // A runner registered with the label takes it.
1587
    let token = "flowreg_riscv";
1588
    db::runners::add_registration(&h.app.db, &blake3::hash(token.as_bytes()).to_hex(), "admin", &Default::default()).await.unwrap();
1589
    let identity = SecretKey::generate().identity("visionfive", "", 1);
1590
    let info = serde_json::json!({ "arch": "riscv64", "os": "linux", "version": "0.1.0", "labels": ["riscv64"], "max_jobs": 1 });
1591
    let reg = serde_json::json!({ "token": token, "name": "visionfive", "identity": hex::encode(identity.encode()), "info": info });
1592
    let (st, body) = call(&h.app, "POST", "/api/v1/flow/runners/register", None, Some(reg.to_string())).await;
1593
    assert_eq!(st, StatusCode::OK, "{body}");
1594
    let credential = serde_json::from_str::<serde_json::Value>(&body).unwrap()["credential"].as_str().unwrap().to_string();
1595
    let claim_body = serde_json::json!({ "runner": "x", "runtimes": ["microvm"], "info": info }).to_string();
1596
    let (st, body) = call(&h.app, "POST", "/api/v1/flow/claim", Some(&credential), Some(claim_body)).await;
1597
    assert_eq!(st, StatusCode::OK, "{body}");
1598
    assert_eq!(serde_json::from_str::<serde_json::Value>(&body).unwrap()["job"]["name"], "cross");
1599
}
1600
1601
/// oxygenhub#71: a job its runner stopped reporting (restarted, or lost
1602
/// the hub as the job ended) is ended once it has run past the time limit
1603
/// and a grace: an error with the reason, its dependents skipped and its
1604
/// run settled, as if the runner had reported the error.
1605
#[tokio::test(flavor = "multi_thread")]
1606
async fn a_job_no_runner_reports_is_ended_after_the_time_limit() {
1607
    let h = hub().await;
1608
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
1609
    create(&h.app, "andy", "lost").await;
1610
    let url = format!("{}/andy/lost", h.base);
1611
    let work = tempfile::tempdir().unwrap();
1612
    let c = client(&url, work.path());
1613
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
1614
    write(work.path(), "test.sh", "echo ok\n");
1615
    c.commit("Add a pipeline", &[]).unwrap();
1616
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1617
    assert_eq!(runs_of(&h.app, "andy", "lost").await.len(), 1);
1618
    let job = claim(&h.app).await.expect("a job to claim");
1619
    let id = job["job_id"].as_i64().unwrap();
1620
1621
    // Running, but well within the limit: left alone.
1622
    assert_eq!(oxygenhub::flow::reap_lost_jobs(&h.app).await.unwrap(), 0);
1623
    // Started long ago and never reported: ended.
1624
    let old = db::now_ms() - 24 * 3600 * 1000;
1625
    sqlx::query("UPDATE flow_jobs SET started_ms = ? WHERE id = ?").bind(old).bind(id).execute(&h.app.db).await.unwrap();
1626
    assert_eq!(oxygenhub::flow::reap_lost_jobs(&h.app).await.unwrap(), 1);
1627
    let j = db::flow::job(&h.app.db, id).await.unwrap().unwrap();
1628
    assert_eq!(j.status, "error");
1629
    assert!(j.error.starts_with("lost:"), "{}", j.error);
1630
    let run = &runs_of(&h.app, "andy", "lost").await[0];
1631
    let jobs = db::flow::jobs(&h.app.db, run.id).await.unwrap();
1632
    assert!(jobs.iter().all(|j| j.status != "running"), "nothing left running");
1633
    // A late report, should one come, does not overwrite the ending.
1634
    assert_ne!(finish(&h.app, id, serde_json::json!({ "exit_code": 0 })).await, StatusCode::NO_CONTENT);
1635
    assert_eq!(db::flow::job(&h.app.db, id).await.unwrap().unwrap().status, "error");
1636
}
1637
1638
/// oxygenhub#73: a runner that lists the images it holds is offered only
1639
/// the jobs whose rootfs is among them; one that does not say gets any.
1640
#[tokio::test(flavor = "multi_thread")]
1641
async fn a_runner_is_offered_only_jobs_whose_image_it_holds() {
1642
    let h = hub().await;
1643
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
1644
    create(&h.app, "andy", "images").await;
1645
    let url = format!("{}/andy/images", h.base);
1646
    let work = tempfile::tempdir().unwrap();
1647
    let c = client(&url, work.path());
1648
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
1649
    write(work.path(), "test.sh", "echo ok\n");
1650
    c.commit("Add a pipeline", &[]).unwrap();
1651
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1652
    assert_eq!(runs_of(&h.app, "andy", "images").await.len(), 1);
1653
    let claim_with = |images: Vec<String>| {
1654
        let body = serde_json::json!({ "runner": "test-1", "runtimes": ["microvm"], "images": images }).to_string();
1655
        let app = h.app.clone();
1656
        async move {
1657
            let (st, body) = call(&app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(body)).await;
1658
            (st, body)
1659
        }
1660
    };
1661
    let (st, _) = claim_with(vec!["ab".repeat(32)]).await;
1662
    assert_eq!(st, StatusCode::NO_CONTENT, "no job for a runner without the image");
1663
    let jobs = db::flow::jobs(&h.app.db, runs_of(&h.app, "andy", "images").await[0].id).await.unwrap();
1664
    let rootfs: serde_json::Value = serde_json::from_str(&jobs[0].sandbox).unwrap();
1665
    let rootfs = rootfs["rootfs"].as_str().unwrap().to_string();
1666
    let (st, body) = claim_with(vec!["ab".repeat(32), rootfs]).await;
1667
    assert_eq!(st, StatusCode::OK, "{body}");
1668
}
1669
1670
/// oxygenhub#71: a runner that lists the jobs it holds has the others it
1671
/// was given ended at once (it restarted, or never received them), not at
1672
/// the time limit; a held job is left alone.
1673
#[tokio::test(flavor = "multi_thread")]
1674
async fn a_job_its_runner_no_longer_holds_is_ended_at_its_next_claim() {
1675
    let h = hub().await;
1676
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
1677
    create(&h.app, "andy", "held").await;
1678
    let url = format!("{}/andy/held", h.base);
1679
    let work = tempfile::tempdir().unwrap();
1680
    let c = client(&url, work.path());
1681
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
1682
    write(work.path(), "test.sh", "echo ok\n");
1683
    c.commit("Add a pipeline", &[]).unwrap();
1684
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1685
    assert_eq!(runs_of(&h.app, "andy", "held").await.len(), 1);
1686
    let id = claim(&h.app).await.expect("a job to claim")["job_id"].as_i64().unwrap();
1687
    let claim_holding = |holding: Vec<i64>| {
1688
        let body = serde_json::json!({ "runner": "test-1", "runtimes": ["microvm"], "holding": holding }).to_string();
1689
        let app = h.app.clone();
1690
        async move { call(&app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(body)).await.0 }
1691
    };
1692
    claim_holding(vec![id]).await;
1693
    assert_eq!(db::flow::job(&h.app.db, id).await.unwrap().unwrap().status, "running", "a held job stays");
1694
    claim_holding(vec![]).await;
1695
    let j = db::flow::job(&h.app.db, id).await.unwrap().unwrap();
1696
    assert_eq!(j.status, "error");
1697
    assert!(j.error.starts_with("lost:") && j.error.contains("no longer holds"), "{}", j.error);
1698
    let run = &runs_of(&h.app, "andy", "held").await[0];
1699
    assert!(db::flow::jobs(&h.app.db, run.id).await.unwrap().iter().all(|j| j.status != "running"), "the run settles");
1700
}
1701
1702
/// oxygen#59: a job with a `scope` runs on a push only when the push's
1703
/// changes touch a path it names (a release job, when Cargo.toml's version
1704
/// moves); a bookmark's first run and manual runs have every job.
1705
#[tokio::test(flavor = "multi_thread")]
1706
async fn a_scoped_job_runs_only_when_a_push_touches_its_paths() {
1707
    let h = hub().await;
1708
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
1709
    create(&h.app, "andy", "scoped").await;
1710
    let url = format!("{}/andy/scoped", h.base);
1711
    let work = tempfile::tempdir().unwrap();
1712
    let c = client(&url, work.path());
1713
    let extra = "job \"dist\" {\n    sandbox \"alpine\"\n    scope \"Cargo.toml\" \"packaging/**\"\n    exec \"true\"\n}\n";
1714
    write(work.path(), ".flow/pipeline.kdl", &pipeline(extra));
1715
    write(work.path(), "test.sh", "echo ok\n");
1716
    write(work.path(), "Cargo.toml", "version = \"0.1.0\"\n");
1717
    c.commit("Start", &[]).unwrap();
1718
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1719
    let names = |app: Shared, n: usize| async move {
1720
        let mut runs = Vec::new();
1721
        for _ in 0..100 {
1722
            runs = runs_of(&app, "andy", "scoped").await;
1723
            if runs.len() >= n {
1724
                break;
1725
            }
1726
            tokio::time::sleep(std::time::Duration::from_millis(50)).await;
1727
        }
1728
        assert_eq!(runs.len(), n, "runs");
1729
        let mut j: Vec<String> = db::flow::jobs(&app.db, runs[0].id).await.unwrap().into_iter().map(|j| j.name).collect();
1730
        j.sort();
1731
        // Passed, so the next push is scoped against it, not superseding it.
1732
        sqlx::query("UPDATE flow_runs SET status = 'passed' WHERE id = ?").bind(runs[0].id).execute(&app.db).await.unwrap();
1733
        j
1734
    };
1735
    assert_eq!(names(h.app.clone(), 1).await, ["build", "dist", "lint", "test"], "the first run has every job");
1736
    write(work.path(), "test.sh", "echo still ok\n");
1737
    c.commit("Edit the test", &[]).unwrap();
1738
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1739
    assert_eq!(names(h.app.clone(), 2).await, ["build", "lint", "test"], "dist is out of scope");
1740
    write(work.path(), "Cargo.toml", "version = \"0.1.1\"\n");
1741
    c.commit("Release 0.1.1", &[]).unwrap();
1742
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1743
    assert_eq!(names(h.app.clone(), 3).await, ["build", "dist", "lint", "test"], "a version bump runs dist");
1744
}
1745
1746
/// oxygenflow#32: a run still going is cancelled from the API, the web or
1747
/// by a newer push to its bookmark; its runner is refused from then on,
1748
/// and the next push is scoped past the cancelled run.
1749
#[tokio::test(flavor = "multi_thread")]
1750
async fn runs_are_cancelled_by_hand_or_by_a_newer_push() {
1751
    let h = hub().await;
1752
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
1753
    create(&h.app, "andy", "stop").await;
1754
    let url = format!("{}/andy/stop", h.base);
1755
    let work = tempfile::tempdir().unwrap();
1756
    let c = client(&url, work.path());
1757
    let extra = "job \"dist\" {\n    sandbox \"alpine\"\n    scope \"Cargo.toml\"\n    exec \"true\"\n}\n";
1758
    write(work.path(), ".flow/pipeline.kdl", &pipeline(extra));
1759
    write(work.path(), "test.sh", "echo ok\n");
1760
    write(work.path(), "Cargo.toml", "version = \"0.1.0\"\n");
1761
    c.commit("Start", &[]).unwrap();
1762
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1763
    let wait_runs = |app: Shared, n: usize| async move {
1764
        for _ in 0..100 {
1765
            let runs = runs_of(&app, "andy", "stop").await;
1766
            if runs.len() >= n {
1767
                return runs;
1768
            }
1769
            tokio::time::sleep(std::time::Duration::from_millis(50)).await;
1770
        }
1771
        panic!("no run {n}");
1772
    };
1773
    let first = wait_runs(h.app.clone(), 1).await;
1774
    sqlx::query("UPDATE flow_runs SET status = 'passed' WHERE id = ?").bind(first[0].id).execute(&h.app.db).await.unwrap();
1775
    sqlx::query("UPDATE flow_jobs SET status = 'passed' WHERE run_id = ?").bind(first[0].id).execute(&h.app.db).await.unwrap();
1776
1777
    // Run 2 (a version bump) has a job running when run 3 is pushed.
1778
    write(work.path(), "Cargo.toml", "version = \"0.1.1\"\n");
1779
    c.commit("Release 0.1.1", &[]).unwrap();
1780
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1781
    wait_runs(h.app.clone(), 2).await;
1782
    let job = claim(&h.app).await.expect("a job of run 2");
1783
    let id = job["job_id"].as_i64().unwrap();
1784
    write(work.path(), "test.sh", "echo still ok\n");
1785
    c.commit("Edit the test", &[]).unwrap();
1786
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1787
    let runs = wait_runs(h.app.clone(), 3).await;
1788
    let third = &runs[0];
1789
    let mut second = runs[1].clone();
1790
    for _ in 0..100 {
1791
        second = db::flow::run_by_id(&h.app.db, runs[1].id).await.unwrap().unwrap();
1792
        if !second.live() {
1793
            break;
1794
        }
1795
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
1796
    }
1797
    assert_eq!(second.status, "cancelled", "a newer push supersedes a run still going");
1798
    let jobs = db::flow::jobs(&h.app.db, second.id).await.unwrap();
1799
    assert!(jobs.iter().all(|j| j.status == "cancelled" && j.error == "superseded by run #3"), "{jobs:?}");
1800
    let mut names: Vec<String> = db::flow::jobs(&h.app.db, third.id).await.unwrap().into_iter().map(|j| j.name).collect();
1801
    names.sort();
1802
    assert_eq!(names, ["build", "dist", "lint", "test"], "run 3 also checks what run 2 would have: the version bump");
1803
    let mut checks = vec![];
1804
    for _ in 0..100 {
1805
        checks = db::hooks::checks_for_state(&h.app.db, second.repo_id, &second.state).await.unwrap();
1806
        if checks.iter().all(|c| c.status == "cancelled") {
1807
            break;
1808
        }
1809
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
1810
    }
1811
    assert!(checks.iter().all(|c| c.status == "cancelled"), "{checks:?}");
1812
    // The runner of the cancelled job is refused, so it stops the job.
1813
    let (st, _) =
1814
        call(&h.app, "POST", &format!("/api/v1/flow/jobs/{id}/log"), Some("runner-secret"), Some(r#"{"records":[]}"#.into())).await;
1815
    assert_eq!(st, StatusCode::CONFLICT);
1816
1817
    // By hand: the API, then a run already ended is refused.
1818
    let (st, body) = call(&h.app, "POST", "/api/v1/repos/andy/stop/flow/runs/3/cancel", Some("site"), None).await;
1819
    assert_eq!(st, StatusCode::OK, "{body}");
1820
    let third = db::flow::run_by_id(&h.app.db, third.id).await.unwrap().unwrap();
1821
    assert_eq!(third.status, "cancelled");
1822
    assert!(db::flow::jobs(&h.app.db, third.id).await.unwrap().iter().all(|j| j.error == "cancelled by andy"));
1823
    let (st, body) = call(&h.app, "POST", "/api/v1/repos/andy/stop/flow/runs/3/cancel", Some("site"), None).await;
1824
    assert!(st == StatusCode::CONFLICT && body.contains("already cancelled"), "{st} {body}");
1825
    let (st, _) = call(&h.app, "POST", "/api/v1/repos/andy/stop/flow/runs/3/cancel", None, None).await;
1826
    assert_ne!(st, StatusCode::OK, "anonymous callers cannot cancel");
1827
    let (_, page) = call(&h.app, "GET", "/andy/stop/flow/3", None, None).await;
1828
    assert!(page.contains("⊘") && !page.contains("CANCEL</button>"), "a cancelled run shows so, with no button");
1829
}
1830
1831
/// oxygenflow#23 and oxygenhub#89: a job runs under its pipeline's
1832
/// timeout, capped at the site's maximum, else the site's default; and the
1833
/// hub gives a job up only past its own limit.
1834
#[tokio::test(flavor = "multi_thread")]
1835
async fn a_job_runs_under_its_own_time_limit_within_the_sites() {
1836
    let h = hub().await;
1837
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
1838
    db::accounts::set_setting(&h.app.db, oxygenhub::flow::SETTING_DEFAULT, "30").await.unwrap();
1839
    db::accounts::set_setting(&h.app.db, oxygenhub::flow::SETTING_MAX, "120").await.unwrap();
1840
    create(&h.app, "andy", "limits").await;
1841
    let url = format!("{}/andy/limits", h.base);
1842
    let work = tempfile::tempdir().unwrap();
1843
    let c = client(&url, work.path());
1844
    let extra = "job \"slow\" {\n    sandbox \"alpine\"\n    timeout \"90m\"\n    exec \"true\"\n}\njob \"huge\" {\n    sandbox \"alpine\"\n    timeout \"5h\"\n    exec \"true\"\n}\n";
1845
    write(work.path(), ".flow/pipeline.kdl", &pipeline(extra));
1846
    write(work.path(), "test.sh", "echo ok\n");
1847
    c.commit("Add a pipeline", &[]).unwrap();
1848
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1849
    assert_eq!(runs_of(&h.app, "andy", "limits").await.len(), 1);
1850
    let mut limits = std::collections::HashMap::new();
1851
    let mut ids = std::collections::HashMap::new();
1852
    while let Some(j) = claim(&h.app).await {
1853
        let name = j["job"]["name"].as_str().unwrap().to_string();
1854
        limits.insert(name.clone(), j["timeout_s"].as_u64().unwrap());
1855
        ids.insert(name, j["job_id"].as_i64().unwrap());
1856
    }
1857
    assert_eq!(limits["slow"], 5400, "its own");
1858
    assert_eq!(limits["huge"], 7200, "cut to the site's maximum");
1859
    assert_eq!(limits["build"], 1800, "the site's default");
1860
    // 40 minutes in: past the default and its grace, within slow's limit.
1861
    let started = db::now_ms() - 40 * 60 * 1000;
1862
    sqlx::query("UPDATE flow_jobs SET started_ms = ?").bind(started).execute(&h.app.db).await.unwrap();
1863
    oxygenhub::flow::reap_lost_jobs(&h.app).await.unwrap();
1864
    let status = |id: i64| {
1865
        let app = h.app.clone();
1866
        async move { db::flow::job(&app.db, id).await.unwrap().unwrap().status }
1867
    };
1868
    assert_eq!(status(ids["build"]).await, "error", "past its 30 minutes");
1869
    assert_eq!(status(ids["slow"]).await, "running", "within its 90");
1870
    assert_eq!(status(ids["huge"]).await, "running", "within its 120");
1871
}
1872
1873
/// oxygenflow#24: a job's `on` decides which events start it: a pushed
1874
/// tag runs only the jobs that name it; a push to a bookmark the pipeline
1875
/// does not name starts no run; a rerun repeats its run's event.
1876
#[tokio::test(flavor = "multi_thread")]
1877
async fn on_decides_which_events_start_a_job() {
1878
    let h = hub().await;
1879
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
1880
    create(&h.app, "andy", "events").await;
1881
    let url = format!("{}/andy/events", h.base);
1882
    let work = tempfile::tempdir().unwrap();
1883
    let c = client(&url, work.path());
1884
    let text = format!(
1885
        "on {{\n    push \"main\"\n    manual\n}}\n{}job \"dist\" {{\n    sandbox \"alpine\"\n    on {{\n        tag \"v*\"\n    }}\n    exec \"true\"\n}}\n",
1886
        pipeline("")
1887
    );
1888
    // `on` must come after schema-version; pipeline() starts with it.
1889
    let text = text.replacen(
1890
        "on {\n    push \"main\"\n    manual\n}\nschema-version 1\n",
1891
        "schema-version 1\non {\n    push \"main\"\n    manual\n}\n",
1892
        1,
1893
    );
1894
    write(work.path(), ".flow/pipeline.kdl", &text);
1895
    write(work.path(), "test.sh", "echo ok\n");
1896
    c.commit("Start", &[]).unwrap();
1897
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1898
    let jobs_of_latest = |app: Shared, n: usize| async move {
1899
        let mut runs = Vec::new();
1900
        for _ in 0..100 {
1901
            runs = runs_of(&app, "andy", "events").await;
1902
            if runs.len() >= n {
1903
                break;
1904
            }
1905
            tokio::time::sleep(std::time::Duration::from_millis(50)).await;
1906
        }
1907
        assert_eq!(runs.len(), n, "runs");
1908
        let mut j: Vec<String> = db::flow::jobs(&app.db, runs[0].id).await.unwrap().into_iter().map(|j| j.name).collect();
1909
        j.sort();
1910
        (runs[0].clone(), j)
1911
    };
1912
    let (_, j) = jobs_of_latest(h.app.clone(), 1).await;
1913
    assert_eq!(j, ["build", "lint", "test"], "a push to main: no dist");
1914
    // A tag: only dist.
1915
    let heads = c.bookmark_heads().unwrap();
1916
    c.tag_create("v1.0.0", &heads, "first").unwrap();
1917
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1918
    let (run, j) = jobs_of_latest(h.app.clone(), 2).await;
1919
    assert_eq!(j, ["dist"], "a tag runs only what names it");
1920
    assert_eq!(run.trigger, "tag:v1.0.0");
1921
    // A rerun repeats the tag's event.
1922
    let row = db::repos::get(&h.app.db, "andy", "events").await.unwrap().unwrap();
1923
    db::flow::finish(
1924
        &h.app.db,
1925
        db::flow::jobs(&h.app.db, run.id).await.unwrap()[0].id,
1926
        db::flow::Outcome { status: "passed", exit_code: Some(0), error: "", receipt: "", receipt_hash: "" },
1927
    )
1928
    .await
1929
    .unwrap();
1930
    let run = db::flow::run_by_id(&h.app.db, run.id).await.unwrap().unwrap();
1931
    oxygenhub::flow::rerun(&h.app, &row, &run, "andy").await.unwrap();
1932
    let (_, j) = jobs_of_latest(h.app.clone(), 3).await;
1933
    assert_eq!(j, ["dist"], "the rerun is the tag's run again");
1934
    // A bookmark the pipeline does not name starts nothing.
1935
    c.bookmark_create("develop", None).unwrap();
1936
    assert!(c.push_bookmark("origin", "develop", false).unwrap().iter().all(|r| r.ok));
1937
    tokio::time::sleep(std::time::Duration::from_millis(300)).await;
1938
    assert_eq!(runs_of(&h.app, "andy", "events").await.len(), 3, "no run for develop");
1939
}
1940
1941
/// oxygenflow#24: a job with a `schedule` line runs on the default
1942
/// bookmark when the line comes due, and only then; other jobs stay out.
1943
#[tokio::test(flavor = "multi_thread")]
1944
async fn scheduled_jobs_run_when_due() {
1945
    let h = hub().await;
1946
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
1947
    create(&h.app, "andy", "nightly").await;
1948
    let url = format!("{}/andy/nightly", h.base);
1949
    let work = tempfile::tempdir().unwrap();
1950
    let c = client(&url, work.path());
1951
    // An odd minute, so the hub's own ticker cannot fire it during the test.
1952
    let extra = "job \"nightly\" {\n    sandbox \"alpine\"\n    on {\n        schedule \"17 4 29 2 *\"\n    }\n    exec \"true\"\n}\n";
1953
    write(work.path(), ".flow/pipeline.kdl", &pipeline(extra));
1954
    write(work.path(), "test.sh", "echo ok\n");
1955
    c.commit("Start", &[]).unwrap();
1956
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
1957
    assert_eq!(runs_of(&h.app, "andy", "nightly").await.len(), 1);
1958
    let first = runs_of(&h.app, "andy", "nightly").await;
1959
    let names: Vec<String> = db::flow::jobs(&h.app.db, first[0].id).await.unwrap().into_iter().map(|j| j.name).collect();
1960
    assert!(!names.contains(&"nightly".to_string()), "a push does not run a scheduled job");
1961
    use flow_core::pipeline::When;
1962
    let not_yet = When { minute: 16, hour: 4, day: 29, month: 2, weekday: 4 };
1963
    assert_eq!(oxygenhub::flow::run_due(&h.app, not_yet).await, 0);
1964
    let due = When { minute: 17, ..not_yet };
1965
    assert_eq!(oxygenhub::flow::run_due(&h.app, due).await, 1);
1966
    let runs = runs_of(&h.app, "andy", "nightly").await;
1967
    assert_eq!(runs.len(), 2);
1968
    assert_eq!(runs[0].trigger, "schedule");
1969
    let names: Vec<String> = db::flow::jobs(&h.app.db, runs[0].id).await.unwrap().into_iter().map(|j| j.name).collect();
1970
    assert_eq!(names, ["nightly"]);
1971
    assert_eq!(runs[0].bookmark, "main", "on the default bookmark");
1972
}
1973
1974
#[tokio::test(flavor = "multi_thread")]
1975
async fn variables_from_three_levels_reach_a_job_inner_overriding_outer() {
1976
    use oxygenhub::levels::Scope;
1977
    use oxygenhub::variables;
1978
    let h = hub().await;
1979
    let app = &h.app;
1980
    // Andy, the site's administrator, owns the acme organisation.
1981
    let res = oxygenhub::router(app.clone())
1982
        .oneshot(
1983
            Request::post("/register")
1984
                .header(header::CONTENT_TYPE, "application/x-www-form-urlencoded")
1985
                .body(Body::from("username=andy&email=a%40example.com&password=correct-horse-battery"))
1986
                .unwrap(),
1987
        )
1988
        .await
1989
        .unwrap();
1990
    let cookie = res.headers().get(header::SET_COOKIE).unwrap().to_str().unwrap().split(';').next().unwrap().to_string();
1991
    let andy = db::accounts::account_by_name(&app.db, "andy").await.unwrap().unwrap();
1992
    db::accounts::create_org(&app.db, "acme", "Acme", andy.id).await.unwrap();
1993
    create(app, "acme", "app").await;
1994
    let page = |path: &str, form: Option<String>| {
1995
        let mut req =
1996
            Request::builder().method(if form.is_some() { "POST" } else { "GET" }).uri(path).header(header::COOKIE, cookie.clone());
1997
        if form.is_some() {
1998
            req = req.header(header::CONTENT_TYPE, "application/x-www-form-urlencoded");
1999
        }
2000
        let req = req.body(Body::from(form.unwrap_or_default())).unwrap();
2001
        let app = app.clone();
2002
        async move {
2003
            let res = oxygenhub::router(app).oneshot(req).await.unwrap();
2004
            let status = res.status();
2005
            let body = String::from_utf8(res.into_body().collect().await.unwrap().to_bytes().to_vec()).unwrap();
2006
            (status, body)
2007
        }
2008
    };
2009
    let csrf_of = |page: &str| {
2010
        let i = page.find("name=\"_csrf\" value=\"").expect("csrf field") + "name=\"_csrf\" value=\"".len();
2011
        page[i..].split('"').next().unwrap().to_string()
2012
    };
2013
2014
    // The site sets CC and LANG, the organisation its own CC, the
2015
    // repository RUST_LOG from its settings page.
2016
    variables::set(&app.db, Scope::Site, "CC", "gcc").await.unwrap();
2017
    variables::set(&app.db, Scope::Site, "LANG", "C").await.unwrap();
2018
    let org = db::accounts::org_by_name(&app.db, "acme").await.unwrap().unwrap();
2019
    variables::set(&app.db, Scope::Org(org.id), "CC", "clang").await.unwrap();
2020
    let (st, settings) = page("/acme/app/settings", None).await;
2021
    assert_eq!(st, StatusCode::OK, "{settings}");
2022
    assert!(settings.contains("Inherited") && settings.contains("the acme organisation") && settings.contains("overridden"), "{settings}");
2023
    let csrf = csrf_of(&settings);
2024
    let (_, body) = page("/acme/app/settings/variables", Some(format!("_csrf={csrf}&action=set&name=RUST_LOG&value=debug"))).await;
2025
    assert!(body.contains("RUST_LOG set.") && body.contains("<code>debug</code>"), "{body}");
2026
    let (_, body) = page("/acme/app/settings/variables", Some(format!("_csrf={csrf}&action=set&name=FLOW_REPO&value=x"))).await;
2027
    assert!(body.contains("not FLOW_"), "{body}");
2028
    let repo = db::repos::get(&app.db, "acme", "app").await.unwrap().unwrap();
2029
    db::repos::set_flow(&app.db, repo.id, "on").await.unwrap();
2030
    let env = variables::env_for_repo(&app.db, &repo).await.unwrap();
2031
    assert_eq!(
2032
        env.iter().map(|(k, v)| (k.as_str(), v.as_str())).collect::<Vec<_>>(),
2033
        [("CC", "clang"), ("LANG", "C"), ("RUST_LOG", "debug")],
2034
        "the organisation's CC wins over the site's"
2035
    );
2036
2037
    // A claim carries them.
2038
    let url = format!("{}/acme/app", h.base);
2039
    let work = tempfile::tempdir().unwrap();
2040
    let c = client(&url, work.path());
2041
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
2042
    write(work.path(), "test.sh", "echo ok\n");
2043
    c.snapshot("test").unwrap();
2044
    c.commit("Add a pipeline", &[]).unwrap();
2045
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
2046
    let runs = runs_of(app, "acme", "app").await;
2047
    assert_eq!(runs.len(), 1, "{runs:?}");
2048
    let got = claim(app).await.unwrap_or_else(|| panic!("a job: {:?}", runs[0]));
2049
    assert_eq!(got["env"], serde_json::json!({ "CC": "clang", "LANG": "C", "RUST_LOG": "debug" }), "{got}");
2050
2051
    // Removing a site variable from the admin page takes effect at the next claim.
2052
    let (_, admin) = page("/admin", None).await;
2053
    assert!(admin.contains("Variables") && admin.contains("<code>gcc</code>"), "{admin}");
2054
    let (_, body) = page("/admin/variables", Some(format!("_csrf={}&action=delete&name=LANG", csrf_of(&admin)))).await;
2055
    assert!(body.contains("LANG removed."), "{body}");
2056
    let got = claim(app).await.expect("another job");
2057
    assert_eq!(got["env"], serde_json::json!({ "CC": "clang", "RUST_LOG": "debug" }), "{got}");
2058
}
2059
2060
#[tokio::test(flavor = "multi_thread")]
2061
async fn secrets_a_job_declares_come_with_the_claim_and_never_reach_the_log() {
2062
    let h = hub().await;
2063
    let app = &h.app;
2064
    let res = oxygenhub::router(app.clone())
2065
        .oneshot(
2066
            Request::post("/register")
2067
                .header(header::CONTENT_TYPE, "application/x-www-form-urlencoded")
2068
                .body(Body::from("username=andy&email=a%40example.com&password=correct-horse-battery"))
2069
                .unwrap(),
2070
        )
2071
        .await
2072
        .unwrap();
2073
    let cookie = res.headers().get(header::SET_COOKIE).unwrap().to_str().unwrap().split(';').next().unwrap().to_string();
2074
    let page = |path: &str, form: Option<String>| {
2075
        let mut req =
2076
            Request::builder().method(if form.is_some() { "POST" } else { "GET" }).uri(path).header(header::COOKIE, cookie.clone());
2077
        if form.is_some() {
2078
            req = req.header(header::CONTENT_TYPE, "application/x-www-form-urlencoded");
2079
        }
2080
        let req = req.body(Body::from(form.unwrap_or_default())).unwrap();
2081
        let app = app.clone();
2082
        async move {
2083
            let res = oxygenhub::router(app).oneshot(req).await.unwrap();
2084
            let status = res.status();
2085
            let body = String::from_utf8(res.into_body().collect().await.unwrap().to_bytes().to_vec()).unwrap();
2086
            (status, body)
2087
        }
2088
    };
2089
    let csrf_of = |page: &str| {
2090
        let i = page.find("name=\"_csrf\" value=\"").expect("csrf field") + "name=\"_csrf\" value=\"".len();
2091
        page[i..].split('"').next().unwrap().to_string()
2092
    };
2093
    create(app, "andy", "demo").await;
2094
    // The site sets deploy-token; the repository overrides it. Neither
2095
    // page shows a value, only that it is set.
2096
    let (_, admin) = page("/admin", None).await;
2097
    let csrf = csrf_of(&admin);
2098
    let (_, body) = page("/admin/secrets", Some(format!("_csrf={csrf}&action=set&name=deploy-token&value=site-level-value"))).await;
2099
    assert!(body.contains("deploy-token set.") && !body.contains("site-level-value"), "{body}");
2100
    let (_, body) = page("/admin/secrets", Some(format!("_csrf={csrf}&action=set&name=bad+name&value=x"))).await;
2101
    assert!(body.contains("name is 1 to 64 of"), "{body}");
2102
    let (_, settings) = page("/andy/demo/settings", None).await;
2103
    assert!(
2104
        settings.contains("Secrets") && settings.contains("<code>deploy-token</code>") && settings.contains("the site</td>"),
2105
        "{settings}"
2106
    );
2107
    let csrf_r = csrf_of(&settings);
2108
    let (_, body) =
2109
        page("/andy/demo/settings/secrets", Some(format!("_csrf={csrf_r}&action=set&name=deploy-token&value=hunter22-repo-value"))).await;
2110
    assert!(body.contains("deploy-token set.") && body.contains("overridden") && !body.contains("hunter22"), "{body}");
2111
    let repo = db::repos::get(&app.db, "andy", "demo").await.unwrap().unwrap();
2112
    assert!(
2113
        !String::from_utf8_lossy(&oxygenhub::secrets::list(&app.db, oxygenhub::levels::Scope::Repo(repo.id)).await.unwrap()[0].value)
2114
            .contains("hunter22"),
2115
        "sealed at rest"
2116
    );
2117
2118
    // A job that declares the secret, and one the levels do not hold.
2119
    let url = format!("{}/andy/demo", h.base);
2120
    let work = tempfile::tempdir().unwrap();
2121
    let c = client(&url, work.path());
2122
    write(
2123
        work.path(),
2124
        ".flow/pipeline.kdl",
2125
        &pipeline("job \"deploy\" {\n    sandbox \"alpine\"\n    secret \"deploy-token\" {\n        mount-path \"/run/secrets/token\"\n    }\n    secret \"missing\" {\n        mount-path \"/run/secrets/missing\"\n    }\n    exec \"deploy\"\n}\n"),
2126
    );
2127
    write(work.path(), "test.sh", "echo ok\n");
2128
    c.snapshot("test").unwrap();
2129
    c.commit("Add a pipeline", &[]).unwrap();
2130
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
2131
    let runs = runs_of(app, "andy", "demo").await;
2132
    let jobs = match runs.first() {
2133
        Some(r) => db::flow::jobs(&app.db, r.id).await.unwrap().iter().map(|j| format!("{}:{}", j.name, j.status)).collect::<Vec<_>>(),
2134
        None => vec![],
2135
    };
2136
    let mut deploy = None;
2137
    for _ in 0..50 {
2138
        let Some(got) = claim(app).await else {
2139
            tokio::time::sleep(std::time::Duration::from_millis(100)).await;
2140
            continue;
2141
        };
2142
        if got["job"]["name"] == "deploy" {
2143
            deploy = Some(got);
2144
            break;
2145
        }
2146
        assert_eq!(got["secrets"], serde_json::Value::Null, "{got}");
2147
    }
2148
    let got = deploy.unwrap_or_else(|| panic!("the deploy job: runs {runs:?} jobs {jobs:?}"));
2149
    assert_eq!(
2150
        got["secrets"],
2151
        serde_json::json!([{ "name": "deploy-token", "path": "/run/secrets/token", "value": "hunter22-repo-value" }]),
2152
        "the repository's value, the missing one left out: {got}"
2153
    );
2154
    let id = got["job_id"].as_i64().unwrap();
2155
    let log = db::flow::log(&app.db, id, 0, 100).await.unwrap();
2156
    assert!(log.iter().any(|l| l.stream == "flow" && l.text.contains("secret \"missing\" is not set")), "{log:?}");
2157
2158
    // The value never reaches the stored log, plain or base64.
2159
    let records = serde_json::json!({ "records": [
2160
        { "t": 1, "stream": "out", "text": "token=hunter22-repo-value" },
2161
        { "t": 2, "stream": "err", "text": "b64 aHVudGVyMjItcmVwby12YWx1ZQ== end" },
2162
    ] });
2163
    let (st, _) = call(app, "POST", &format!("/api/v1/flow/jobs/{id}/log"), Some("runner-secret"), Some(records.to_string())).await;
2164
    assert_eq!(st, StatusCode::NO_CONTENT);
2165
    let log = db::flow::log(&app.db, id, 0, 100).await.unwrap();
2166
    let texts: Vec<&str> = log.iter().map(|l| l.text.as_str()).collect();
2167
    assert!(texts.contains(&"token=***") && texts.contains(&"b64 *** end"), "{texts:?}");
2168
    assert!(!texts.iter().any(|t| t.contains("hunter22")), "{texts:?}");
2169
}
2170
2171
#[tokio::test(flavor = "multi_thread")]
2172
async fn a_job_s_identity_is_a_signed_token_the_discovery_document_lets_anyone_verify() {
2173
    let h = hub().await;
2174
    let app = &h.app;
2175
    let (st, disc) = call(app, "GET", "/.well-known/openid-configuration", None, None).await;
2176
    assert_eq!(st, StatusCode::OK, "{disc}");
2177
    let disc: serde_json::Value = serde_json::from_str(&disc).unwrap();
2178
    assert_eq!(disc["issuer"], h.base.as_str());
2179
    assert_eq!(disc["jwks_uri"], format!("{}/.well-known/jwks.json", h.base));
2180
    let (st, jwks) = call(app, "GET", "/.well-known/jwks.json", None, None).await;
2181
    assert_eq!(st, StatusCode::OK, "{jwks}");
2182
    let jwks: serde_json::Value = serde_json::from_str(&jwks).unwrap();
2183
    assert_eq!(jwks["keys"][0]["alg"], "RS256");
2184
    let kid = jwks["keys"][0]["kid"].as_str().unwrap().to_string();
2185
2186
    create(app, "andy", "demo").await;
2187
    let url = format!("{}/andy/demo", h.base);
2188
    let work = tempfile::tempdir().unwrap();
2189
    let c = client(&url, work.path());
2190
    write(
2191
        work.path(),
2192
        ".flow/pipeline.kdl",
2193
        &pipeline("job \"deploy\" {\n    sandbox \"alpine\"\n    identity \"sts.amazonaws.com\" {\n        mount-path \"/run/secrets/aws-token\"\n    }\n    exec \"deploy\"\n}\n"),
2194
    );
2195
    write(work.path(), "test.sh", "echo ok\n");
2196
    c.snapshot("test").unwrap();
2197
    c.commit("Add a pipeline", &[]).unwrap();
2198
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
2199
    let mut deploy = None;
2200
    for _ in 0..50 {
2201
        let Some(got) = claim(app).await else {
2202
            tokio::time::sleep(std::time::Duration::from_millis(100)).await;
2203
            continue;
2204
        };
2205
        if got["job"]["name"] == "deploy" {
2206
            deploy = Some(got);
2207
            break;
2208
        }
2209
    }
2210
    let got = deploy.expect("the deploy job");
2211
    let secrets = got["secrets"].as_array().expect("secrets");
2212
    assert_eq!(secrets.len(), 1);
2213
    assert_eq!(
2214
        (secrets[0]["name"].as_str(), secrets[0]["path"].as_str()),
2215
        (Some("identity:sts.amazonaws.com"), Some("/run/secrets/aws-token"))
2216
    );
2217
    let token = secrets[0]["value"].as_str().unwrap().to_string();
2218
    let issuer = app.oidc().await.unwrap();
2219
    assert_eq!(issuer.kid, kid, "the key the JWKS publishes signed it");
2220
    let claims = issuer.verify(&token, "sts.amazonaws.com", db::now_ms()).expect("verifies");
2221
    assert_eq!(claims["sub"], "repo:andy/demo:bookmark:main");
2222
    assert_eq!(claims["repository"], "andy/demo");
2223
    assert_eq!(claims["job"], "deploy");
2224
    assert_eq!(claims["run_number"], 1);
2225
    assert_eq!(claims["runner"], "test-1");
2226
    assert_eq!(claims["iss"], h.base.as_str());
2227
    assert!(claims["state"].as_str().unwrap().len() == 64);
2228
    // A job that prints its token leaves *** in the log.
2229
    let id = got["job_id"].as_i64().unwrap();
2230
    let records = serde_json::json!({ "records": [{ "t": 1, "stream": "out", "text": format!("TOKEN={token} end") }] });
2231
    let (st, _) = call(app, "POST", &format!("/api/v1/flow/jobs/{id}/log"), Some("runner-secret"), Some(records.to_string())).await;
2232
    assert_eq!(st, StatusCode::NO_CONTENT);
2233
    let log = db::flow::log(&app.db, id, 0, 100).await.unwrap();
2234
    assert!(log.iter().any(|l| l.text == "TOKEN=*** end"), "{log:?}");
2235
}
2236
2237
#[tokio::test(flavor = "multi_thread")]
2238
async fn jobs_are_offered_only_to_runners_of_their_architecture() {
2239
    let h = hub().await;
2240
    let app = &h.app;
2241
    create(app, "andy", "demo").await;
2242
    let url = format!("{}/andy/demo", h.base);
2243
    let work = tempfile::tempdir().unwrap();
2244
    let c = client(&url, work.path());
2245
    write(work.path(), ".flow/pipeline.kdl", &pipeline("sandbox \"board\" {\n    rootfs \"cas://blob/{ROOTFS}\"\n    arch \"riscv64\"\n}\njob \"flash\" {\n    sandbox \"board\"\n    exec \"flash\"\n}\n").replace("{ROOTFS}", &"ab".repeat(32)));
2246
    write(work.path(), "test.sh", "echo ok\n");
2247
    c.snapshot("test").unwrap();
2248
    c.commit("Add a pipeline", &[]).unwrap();
2249
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
2250
    let claim_as = |arch: &'static str, archs: serde_json::Value| {
2251
        let app = app.clone();
2252
        async move {
2253
            let body = serde_json::json!({
2254
                "runner": format!("{arch}-1"), "runtimes": ["microvm"],
2255
                "info": { "arch": arch, "os": "linux", "version": "t", "labels": [], "max_jobs": 1 },
2256
                "image_archs": archs,
2257
            });
2258
            let (st, body) = call(&app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(body.to_string())).await;
2259
            match st {
2260
                StatusCode::NO_CONTENT => None,
2261
                StatusCode::OK => {
2262
                    Some(serde_json::from_str::<serde_json::Value>(&body).unwrap()["job"]["name"].as_str().unwrap().to_string())
2263
                }
2264
                other => panic!("claim: {other} {body}"),
2265
            }
2266
        }
2267
    };
2268
    // An x86_64 runner that says the alpine image is x86_64: it takes the
2269
    // alpine jobs, never the one that asks for riscv64.
2270
    let rootfs = pipeline("").split("cas://blob/").nth(1).unwrap()[..64].to_string();
2271
    for _ in 0..50 {
2272
        if !runs_of(app, "andy", "demo").await.is_empty() {
2273
            break;
2274
        }
2275
        tokio::time::sleep(std::time::Duration::from_millis(100)).await;
2276
    }
2277
    let runs = runs_of(app, "andy", "demo").await;
2278
    assert_eq!(runs.len(), 1, "{runs:?}");
2279
    let mut taken = vec![];
2280
    while let Some(j) = claim_as("x86_64", serde_json::json!({ rootfs.clone(): "x86_64" })).await {
2281
        taken.push(j);
2282
    }
2283
    assert_eq!(taken, ["build", "lint"], "test waits for build; flash is for riscv64");
2284
    // A riscv64 runner: the alpine image is known to be x86_64, so only flash.
2285
    assert_eq!(claim_as("riscv64", serde_json::json!({})).await.as_deref(), Some("flash"));
2286
    assert_eq!(claim_as("riscv64", serde_json::json!({})).await, None);
2287
    let (_, queue) = call(app, "GET", "/admin/runners", None, None).await;
2288
    let _ = queue;
2289
}
2290
2291
/// OxygenFlow spec §11.5: a runner hands back a job it cannot run. The
2292
/// job is queued again and not offered to that runner again, the decline
2293
/// shows on the run's page and is kept for the runner's, and once three
2294
/// runners have declined it the job ends as unplaceable with their reasons.
2295
#[tokio::test(flavor = "multi_thread")]
2296
async fn a_declined_job_goes_to_another_runner_or_ends_unplaceable() {
2297
    let h = hub().await;
2298
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
2299
    create(&h.app, "andy", "declines").await;
2300
    let url = format!("{}/andy/declines", h.base);
2301
    let work = tempfile::tempdir().unwrap();
2302
    let c = client(&url, work.path());
2303
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
2304
    write(work.path(), "test.sh", "echo ok\n");
2305
    c.commit("Add a pipeline", &[]).unwrap();
2306
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
2307
    let run = runs_of(&h.app, "andy", "declines").await[0].clone();
2308
    let claim_as = |token: &'static str, name: &'static str| {
2309
        let app = h.app.clone();
2310
        async move {
2311
            let body = serde_json::json!({ "runner": name, "runtimes": ["microvm"] }).to_string();
2312
            let (st, body) = call(&app, "POST", "/api/v1/flow/claim", Some(token), Some(body)).await;
2313
            (st == StatusCode::OK).then(|| serde_json::from_str::<serde_json::Value>(&body).unwrap()["job_id"].as_i64().unwrap())
2314
        }
2315
    };
2316
    let decline = |token: &'static str, id: i64, reason: &'static str| {
2317
        let app = h.app.clone();
2318
        async move {
2319
            let body = serde_json::json!({ "reason": reason }).to_string();
2320
            call(&app, "POST", &format!("/api/v1/flow/jobs/{id}/decline"), Some(token), Some(body)).await.0
2321
        }
2322
    };
2323
    let job = claim_as("runner-secret", "earth-1").await.expect("a job");
2324
    // The other runners are known to the hub before they decline anything.
2325
    assert_eq!(decline("runner-two", job, "not mine").await, StatusCode::CONFLICT, "only the runner it runs on may decline it");
2326
    assert_eq!(decline("runner-secret", job, "the MicroVM tier needs /dev/kvm").await, StatusCode::NO_CONTENT);
2327
    let j = db::flow::job(&h.app.db, job).await.unwrap().unwrap();
2328
    assert_eq!((j.status.as_str(), j.runner.as_str()), ("queued", ""));
2329
    assert_eq!(j.waiting, "declined by earth-1: the MicroVM tier needs /dev/kvm; waiting for another runner");
2330
    // earth-1 is offered the other ready job, not this one, while it stays the same.
2331
    let next = claim_as("runner-secret", "earth-1").await.expect("the other ready job");
2332
    assert_ne!(next, job);
2333
    let page = call(&h.app, "GET", &format!("/andy/declines/flow/{}", run.number), None, None).await.1;
2334
    assert!(page.contains("Waiting: declined by earth-1: the MicroVM tier needs /dev/kvm"), "{page}");
2335
    assert_eq!(claim_as("runner-two", "plex-1").await, Some(job), "another runner takes it");
2336
    assert_eq!(decline("runner-two", job, "rootfs 36fc4e323804 is not on this runner").await, StatusCode::NO_CONTENT);
2337
    assert_eq!(claim_as("runner-three", "narvi").await, Some(job));
2338
    assert_eq!(decline("runner-three", job, "rootfs 36fc4e323804 is for x86_64; this runner is riscv64").await, StatusCode::NO_CONTENT);
2339
    let j = db::flow::job(&h.app.db, job).await.unwrap().unwrap();
2340
    assert_eq!(j.status, "error");
2341
    assert_eq!(
2342
        j.error,
2343
        "unplaceable: declined by 3 runners: earth-1: the MicroVM tier needs /dev/kvm; plex-1: rootfs 36fc4e323804 is not on this runner; narvi: rootfs 36fc4e323804 is for x86_64; this runner is riscv64"
2344
    );
2345
    let r = db::runners::list(&h.app.db).await.unwrap().into_iter().find(|r| r.name == "plex-1").unwrap();
2346
    let declined = db::flow::declines_of_runner(&h.app.db, r.id, 10).await.unwrap();
2347
    assert_eq!(declined.len(), 1);
2348
    assert_eq!((declined[0].job_id, declined[0].reason.as_str()), (job, "rootfs 36fc4e323804 is not on this runner"));
2349
    assert_eq!(r.tier_list(), vec!["microvm"]);
2350
}
2351
2352
/// oxygenhub#113: a job's artifact named `coverage` (LCOV) is read when
2353
/// it is uploaded. The job's log says what it found; the Coverage tab,
2354
/// the file view, the badge and the run page show it.
2355
#[tokio::test(flavor = "multi_thread")]
2356
async fn a_coverage_artifact_becomes_a_coverage_report() {
2357
    let h = hub().await;
2358
    create(&h.app, "andy", "cov").await;
2359
    let url = format!("{}/andy/cov", h.base);
2360
    let work = tempfile::tempdir().unwrap();
2361
    let c = client(&url, work.path());
2362
    write(
2363
        work.path(),
2364
        ".flow/pipeline.kdl",
2365
        &format!(
2366
            "schema-version 1\nsandbox \"alpine\" {{\n    rootfs \"cas://blob/{ROOTFS}\"\n}}\njob \"coverage\" {{\n    sandbox \"alpine\"\n    exec \"make\" \"coverage\"\n    output {{\n        artifact \"coverage\" {{\n            path \"/src/lcov.info\"\n        }}\n    }}\n}}\n"
2367
        ),
2368
    );
2369
    write(work.path(), "src/lib.rs", "pub fn add(a: u32, b: u32) -> u32 {\n    a + b\n}\n\npub fn unused() {\n    todo!()\n}\n");
2370
    c.snapshot("test").unwrap();
2371
    c.commit("Code and coverage", &[]).unwrap();
2372
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
2373
    let run = runs_of(&h.app, "andy", "cov").await.remove(0);
2374
    assert!(!call(&h.app, "GET", "/andy/cov", None, None).await.1.contains(">Reports</a>"), "no tab before a report");
2375
    let id = claim(&h.app).await.unwrap()["job_id"].as_i64().unwrap();
2376
2377
    let (st, text) = upload(&h.app, id, "coverage", b"this is not a report").await;
2378
    assert_eq!(st, StatusCode::OK, "a bad report never fails the upload: {text}");
2379
    let lcov = "TN:\nSF:/src/src/lib.rs\nFN:1,add\nFN:5,unused\nFNDA:3,add\nFNDA:0,unused\nDA:1,3\nDA:2,3\nDA:5,0\nDA:6,0\nend_of_record\n\
2380
SF:/src/src/gone.rs\nDA:1,1\nend_of_record\nSF:/usr/lib/rustlib/x.rs\nDA:1,1\nend_of_record\n";
2381
    let (st, text) = upload(&h.app, id, "coverage", lcov.as_bytes()).await;
2382
    assert_eq!(st, StatusCode::OK, "{text}");
2383
    let log: Vec<String> = db::flow::log(&h.app.db, id, 0, 50).await.unwrap().into_iter().map(|l| l.text).collect();
2384
    assert!(log.iter().any(|l| l.contains("coverage: this is not an LCOV report")), "{log:?}");
2385
    assert!(
2386
        log.iter().any(|l| l == "coverage: 50.0% of lines (2 of 4) in 1 files (2 named files are not in this state and were left out)"),
2387
        "{log:?}"
2388
    );
2389
2390
    let (st, page) = call(&h.app, "GET", "/andy/cov/coverage", None, None).await;
2391
    assert_eq!(st, StatusCode::OK);
2392
    assert!(
2393
        page.contains(">Reports</a>")
2394
            && page.contains("50.0%")
2395
            && page.contains("<strong>2</strong> of <strong>4</strong> relevant lines covered"),
2396
        "{page}"
2397
    );
2398
    assert!(page.contains("1 of 2") && page.contains("/andy/cov/coverage/") && page.contains("/file/src/lib.rs"), "{page}");
2399
    let report = crate_report(&h.app, run.id).await;
2400
    let (st, file) = call(&h.app, "GET", &format!("/andy/cov/coverage/{report}/file/src/lib.rs"), None, None).await;
2401
    assert_eq!(st, StatusCode::OK, "{file}");
2402
    assert_eq!(file.matches("class=\"cov-hit\"").count(), 2, "{file}");
2403
    assert_eq!(file.matches("class=\"cov-miss\"").count(), 2, "{file}");
2404
    assert!(file.contains("3×"), "{file}");
2405
    assert_eq!(call(&h.app, "GET", &format!("/andy/cov/coverage/{report}/file/src/gone.rs"), None, None).await.0, StatusCode::NOT_FOUND);
2406
    let (_, badge) = call(&h.app, "GET", "/andy/cov/coverage/badge.svg", None, None).await;
2407
    assert!(badge.contains("coverage: 50.0%"), "{badge}");
2408
    let (_, run_page) = call(&h.app, "GET", &format!("/andy/cov/flow/{}", run.number), None, None).await;
2409
    assert!(run_page.contains("coverage 50.0%"), "{run_page}");
2410
    // The API (#113).
2411
    let (_, list) = call(&h.app, "GET", "/api/v1/repos/andy/cov/coverage", None, None).await;
2412
    let list: serde_json::Value = serde_json::from_str(&list).unwrap();
2413
    assert_eq!((list[0]["percent"].as_f64(), list[0]["format"].as_str()), (Some(50.0), Some("lcov")), "{list}");
2414
    let (_, one) = call(&h.app, "GET", &format!("/api/v1/repos/andy/cov/coverage/{report}"), None, None).await;
2415
    let one: serde_json::Value = serde_json::from_str(&one).unwrap();
2416
    assert_eq!((one["files"][0]["path"].as_str(), one["files"][0]["lines_hit"].as_i64()), (Some("src/lib.rs"), Some(2)), "{one}");
2417
2418
    // The `coverage` check on the run's state: it reports, and with a
2419
    // minimum the repository sets, it fails below it.
2420
    let row = db::repos::get(&h.app.db, "andy", "cov").await.unwrap().unwrap();
2421
    let check = |checks: Vec<db::hooks::Check>| checks.into_iter().find(|c| c.name == "coverage").expect("a coverage check");
2422
    let c = check(db::hooks::checks_for_state(&h.app.db, row.id, &run.state).await.unwrap());
2423
    assert_eq!((c.status.as_str(), c.summary.as_str()), ("passed", "50.0%"));
2424
    assert!(c.url.ends_with(&format!("/andy/cov/coverage?report={report}")), "{}", c.url);
2425
    oxygenhub::coverage::set_rules(&h.app.db, row.id, oxygenhub::coverage::Rules { min: Some(60.0), max_drop: None }).await.unwrap();
2426
    assert_eq!(upload(&h.app, id, "coverage", lcov.as_bytes()).await.0, StatusCode::OK);
2427
    let c = check(db::hooks::checks_for_state(&h.app.db, row.id, &run.state).await.unwrap());
2428
    assert_eq!((c.status.as_str(), c.summary.as_str()), ("failed", "50.0%: below the minimum of 60%"));
2429
}
2430
2431
async fn crate_report(app: &Shared, run_id: i64) -> i64 {
2432
    oxygenhub::coverage::for_run(&app.db, run_id).await.unwrap()[0].id
2433
}
2434
2435
/// The Tests tab (#114): three runs' JUnit reports on a bookmark; a test
2436
/// breaks in the second and is fixed in the third.
2437
#[tokio::test(flavor = "multi_thread")]
2438
async fn junit_reports_make_a_tests_tab() {
2439
    let h = hub().await;
2440
    create(&h.app, "andy", "t").await;
2441
    let url = format!("{}/andy/t", h.base);
2442
    let work = tempfile::tempdir().unwrap();
2443
    let c = client(&url, work.path());
2444
    write(
2445
        work.path(),
2446
        ".flow/pipeline.kdl",
2447
        &format!(
2448
            "schema-version 1\nsandbox \"alpine\" {{\n    rootfs \"cas://blob/{ROOTFS}\"\n}}\njob \"test\" {{\n    sandbox \"alpine\"\n    exec \"make\" \"test\"\n    output {{\n        artifact \"junit\" {{\n            path \"/src/junit.xml\"\n        }}\n    }}\n}}\n"
2449
        ),
2450
    );
2451
    assert!(!call(&h.app, "GET", "/andy/t", None, None).await.1.contains(">Reports</a>"));
2452
    let case = |name: &str, ok: bool, secs: &str| {
2453
        if ok {
2454
            format!(r#"<testcase classname="t.suite" name="{name}" time="{secs}"/>"#)
2455
        } else {
2456
            format!(
2457
                r#"<testcase classname="t.suite" name="{name}" time="{secs}"><failure message="{name} broke">AssertionError</failure></testcase>"#
2458
            )
2459
        }
2460
    };
2461
    let runs = [
2462
        vec![case("a", true, "0.1"), case("b", true, "2.5"), case("c", true, "0.2")],
2463
        vec![case("a", true, "0.1"), case("b", false, "2.6"), case("c", true, "0.2"), case("d", true, "0.3")],
2464
        vec![case("a", true, "0.1"), case("b", true, "2.4"), case("c", true, "0.2"), case("d", true, "0.3")],
2465
    ];
2466
    for (i, cases) in runs.iter().enumerate() {
2467
        write(work.path(), "n.txt", &i.to_string());
2468
        c.snapshot("test").unwrap();
2469
        c.commit(&format!("Run {i}"), &[]).unwrap();
2470
        assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
2471
        // The run is made after the push answers.
2472
        let mut a = None;
2473
        for _ in 0..100 {
2474
            a = claim(&h.app).await;
2475
            if a.is_some() {
2476
                break;
2477
            }
2478
            tokio::time::sleep(std::time::Duration::from_millis(50)).await;
2479
        }
2480
        let a = a.expect("a job to claim");
2481
        let id = a["job_id"].as_i64().unwrap();
2482
        let xml = format!("<testsuites><testsuite name=\"t\">{}</testsuite></testsuites>", cases.concat());
2483
        assert_eq!(upload(&h.app, id, "junit", xml.as_bytes()).await.0, StatusCode::OK);
2484
        let failed = cases.iter().any(|c| c.contains("<failure"));
2485
        let mut r = receipt("test", a["pipeline_hash"].as_str().unwrap(), failed as u32);
2486
        if !failed {
2487
            r["outputs"] = serde_json::json!([oxy_core::repo::Repo::blob_ref(xml.as_bytes()).to_hex()]);
2488
        }
2489
        let code = failed as i32;
2490
        assert_eq!(
2491
            finish(&h.app, id, serde_json::json!({ "exit_code": code, "duration_ms": 700, "receipt": r })).await,
2492
            StatusCode::NO_CONTENT
2493
        );
2494
    }
2495
    let (st, page) = call(&h.app, "GET", "/andy/t/tests", None, None).await;
2496
    assert_eq!(st, StatusCode::OK, "{page}");
2497
    if let Some(out) = std::env::var_os("OXYHUB_DUMP_TESTS_PAGE") {
2498
        std::fs::write(out, &page).unwrap();
2499
    }
2500
    assert!(page.contains(">Reports</a>"), "the tab");
2501
    assert!(page.contains("100%") && page.contains("of 4 tests passed"), "the latest run passes");
2502
    assert!(page.contains("1 fixed") && page.contains("t.suite::b"), "b fixed against the run before");
2503
    assert!(page.contains("1 ✕") && page.contains("2 ✓"), "b is flaky: {page}");
2504
    assert!(page.contains("<svg class=\"cov-chart\""), "charts");
2505
    // The slowest first.
2506
    let slow = page.find("Slowest tests").unwrap();
2507
    assert!(page[slow..].find("t.suite::b").unwrap() < page[slow..].find("t.suite::d").unwrap());
2508
    // The second run, picked: b newly failing, its failure listed.
2509
    let row = db::repos::get(&h.app.db, "andy", "t").await.unwrap().unwrap();
2510
    let second = oxygenhub::junit::on_bookmark(&h.app.db, row.id, "main", 10).await.unwrap()[1].id;
2511
    let (_, page) = call(&h.app, "GET", &format!("/andy/t/tests?report={second}"), None, None).await;
2512
    assert!(page.contains("1 failing") && page.contains("Newly failing") && page.contains("b broke"), "{page}");
2513
    assert!(page.contains("1 new tests"), "d is new");
2514
2515
    // The API (#114): the bookmark's reports newest first, and one with
2516
    // its failed cases.
2517
    let (st, list) = call(&h.app, "GET", "/api/v1/repos/andy/t/tests", None, None).await;
2518
    assert_eq!(st, StatusCode::OK, "{list}");
2519
    let list: serde_json::Value = serde_json::from_str(&list).unwrap();
2520
    assert_eq!(list.as_array().unwrap().len(), 3);
2521
    assert_eq!((list[0]["tests"].as_i64(), list[1]["failed"].as_i64()), (Some(4), Some(1)));
2522
    let (_, one) = call(&h.app, "GET", &format!("/api/v1/repos/andy/t/tests/{second}?status=failed"), None, None).await;
2523
    let one: serde_json::Value = serde_json::from_str(&one).unwrap();
2524
    assert_eq!(one["cases"].as_array().unwrap().len(), 1);
2525
    assert_eq!((one["cases"][0]["name"].as_str(), one["cases"][0]["message"].as_str()), (Some("b"), Some("b broke")));
2526
    let (_, all) = call(&h.app, "GET", &format!("/api/v1/repos/andy/t/tests/{second}"), None, None).await;
2527
    assert_eq!(serde_json::from_str::<serde_json::Value>(&all).unwrap()["cases"].as_array().unwrap().len(), 4);
2528
    assert_eq!(call(&h.app, "GET", "/api/v1/repos/andy/t/tests/99999", None, None).await.0, StatusCode::NOT_FOUND);
2529
2530
    // The `tests` check names what broke against main.
2531
    let reports = oxygenhub::junit::on_bookmark(&h.app.db, row.id, "main", 10).await.unwrap();
2532
    let check = |state: String| {
2533
        let app = h.app.clone();
2534
        async move { db::hooks::checks_for_state(&app.db, row.id, &state).await.unwrap().into_iter().find(|c| c.name == "tests").unwrap() }
2535
    };
2536
    let c = check(reports[1].state.clone()).await;
2537
    assert_eq!((c.status.as_str(), c.summary.as_str()), ("failed", "1 failing; 1 new against main: t.suite::b"));
2538
    let c = check(reports[0].state.clone()).await;
2539
    assert_eq!((c.status.as_str(), c.summary.as_str()), ("passed", "4 passed"));
2540
2541
    // One test's history: b passed, failed, passed.
2542
    let (_, tab) = call(&h.app, "GET", "/andy/t/tests", None, None).await;
2543
    assert!(
2544
        tab.contains("/andy/t/tests/case?classname=t.suite&amp;name=b") || tab.contains("/andy/t/tests/case?classname=t.suite&name=b"),
2545
        "linked"
2546
    );
2547
    let (st, hist) = call(&h.app, "GET", "/andy/t/tests/case?classname=t.suite&name=b", None, None).await;
2548
    assert_eq!(st, StatusCode::OK, "{hist}");
2549
    assert!(hist.contains("2 passed") && hist.contains("1 failed") && hist.contains("b broke"), "{hist}");
2550
    assert_eq!(call(&h.app, "GET", "/andy/t/tests/case?classname=t.suite&name=nope", None, None).await.0, StatusCode::NOT_FOUND);
2551
}
2552
2553
/// oxygenhub#28: a queued job no runner can take says why, in the API, on
2554
/// the run page (its panel open) and in its check.
2555
#[tokio::test(flavor = "multi_thread")]
2556
async fn a_job_no_runner_can_take_says_why() {
2557
    let h = hub().await;
2558
    create(&h.app, "andy", "demo").await;
2559
    let url = format!("{}/andy/demo", h.base);
2560
    let work = tempfile::tempdir().unwrap();
2561
    let c = client(&url, work.path());
2562
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
2563
    write(work.path(), "test.sh", "echo ok\n");
2564
    c.commit("Add a pipeline", &[]).unwrap();
2565
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
2566
    let run = runs_of(&h.app, "andy", "demo").await.remove(0);
2567
2568
    // One runner, online, holding another image only.
2569
    let r = db::runners::configured(&h.app.db, &blake3::hash(b"elsewhere").to_hex(), "earth-9").await.unwrap();
2570
    db::runners::seen(&h.app.db, r.id, None, None).await.unwrap();
2571
    let other = "ab".repeat(32);
2572
    db::runners::set_offer(&h.app.db, r.id, &["microvm".to_string()], Some(&[other]), false, "p").await.unwrap();
2573
    oxygenhub::flow::explain_waits(&h.app).await.unwrap();
2574
2575
    let (_, body) = call(&h.app, "GET", "/api/v1/repos/andy/demo/flow/runs/1", Some("site"), None).await;
2576
    let v: serde_json::Value = serde_json::from_str(&body).unwrap();
2577
    let build = v["jobs"].as_array().unwrap().iter().find(|j| j["name"] == "build").unwrap().clone();
2578
    let why = build["waiting"].as_str().unwrap_or_default().to_string();
2579
    assert!(why.contains("earth-9 does not hold image") && why.contains(&ROOTFS[..12]), "{body}");
2580
    let (_, page) = call(&h.app, "GET", "/andy/demo/flow/1", None, None).await;
2581
    assert!(page.contains("data-waiting") && page.contains("does not hold image"), "the run page says it");
2582
    let checks = db::hooks::checks_for_state(&h.app.db, run.repo_id, &run.state).await.unwrap();
2583
    let check = checks.iter().find(|c| c.name == "flow/build").unwrap();
2584
    assert!(check.summary.contains("does not hold image"), "{check:?}");
2585
}
2586
2587
async fn put_bytes(app: &Shared, path: &str, bearer: &str, bytes: Vec<u8>) -> (StatusCode, String) {
2588
    let req = Request::put(path)
2589
        .header(header::AUTHORIZATION, format!("Bearer {bearer}"))
2590
        .header(header::CONTENT_TYPE, "application/octet-stream")
2591
        .body(Body::from(bytes))
2592
        .unwrap();
2593
    let res = oxygenhub::router(app.clone()).oneshot(req).await.unwrap();
2594
    let st = res.status();
2595
    (st, String::from_utf8_lossy(&res.into_body().collect().await.unwrap().to_bytes()).into_owned())
2596
}
2597
2598
/// oxygenflow#39: an image is sent as the chunks the hub lacks and then its
2599
/// manifest, checked against its hash; runners fetch it; and a job whose
2600
/// image only the hub holds is offered to a runner that fetches, not to one
2601
/// that does not.
2602
#[tokio::test(flavor = "multi_thread")]
2603
async fn images_are_sent_by_chunk_and_offered_to_runners_that_fetch() {
2604
    let h = hub().await;
2605
    // The site token acts as the first site administrator.
2606
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
2607
    // An image: bytes, a run of zeros, more bytes.
2608
    let mut image: Vec<u8> = (0..400_000u32).map(|i| (i % 251) as u8).collect();
2609
    image.extend(std::iter::repeat_n(0u8, 2 << 20));
2610
    image.extend((0..100_000u32).map(|i| (i % 239) as u8));
2611
    let mut chunks = std::collections::HashMap::new();
2612
    let m = jet::images::scan(&image[..], Some("x86_64".into()), |c, b| {
2613
        chunks.insert(c.hash().to_string(), b.to_vec());
2614
        Ok(())
2615
    })
2616
    .unwrap();
2617
    let hash = m.hash.clone();
2618
2619
    // Which chunks the hub lacks: every one but zeros; a manifest before them is refused.
2620
    let ask = serde_json::json!({ "chunks": m.needed() }).to_string();
2621
    let (st, body) = call(&h.app, "POST", "/api/v1/flow/images/missing", Some("site"), Some(ask.clone())).await;
2622
    assert_eq!(st, StatusCode::OK, "{body}");
2623
    let missing: Vec<String> = serde_json::from_str::<serde_json::Value>(&body).unwrap()["missing"]
2624
        .as_array()
2625
        .unwrap()
2626
        .iter()
2627
        .map(|v| v.as_str().unwrap().to_string())
2628
        .collect();
2629
    assert_eq!(missing.len(), m.needed().len());
2630
    let manifest = serde_json::to_string(&m).unwrap();
2631
    let (st, body) = call(&h.app, "PUT", &format!("/api/v1/flow/images/{hash}"), Some("site"), Some(manifest.clone())).await;
2632
    assert!(st == StatusCode::CONFLICT && body.contains("was not sent"), "{st} {body}");
2633
    // A chunk is checked against its name; a runner token may not send.
2634
    let first = &missing[0];
2635
    assert_eq!(put_bytes(&h.app, &format!("/api/v1/flow/images/chunks/{first}"), "site", vec![1, 2, 3]).await.0, StatusCode::BAD_REQUEST);
2636
    assert_ne!(
2637
        put_bytes(&h.app, &format!("/api/v1/flow/images/chunks/{first}"), "runner-secret", chunks[first].clone()).await.0,
2638
        StatusCode::NO_CONTENT
2639
    );
2640
    for c in &missing {
2641
        let (st, body) = put_bytes(&h.app, &format!("/api/v1/flow/images/chunks/{c}"), "site", chunks[c].clone()).await;
2642
        assert_eq!(st, StatusCode::NO_CONTENT, "{body}");
2643
    }
2644
    let (_, body) = call(&h.app, "POST", "/api/v1/flow/images/missing", Some("site"), Some(ask)).await;
2645
    assert!(body.contains("\"missing\":[]"), "{body}");
2646
    // A manifest naming another hash is refused; the right one is kept.
2647
    let mut wrong = m.clone();
2648
    wrong.hash = "ab".repeat(32);
2649
    let (st, _) =
2650
        call(&h.app, "PUT", &format!("/api/v1/flow/images/{}", wrong.hash), Some("site"), Some(serde_json::to_string(&wrong).unwrap()))
2651
            .await;
2652
    assert_eq!(st, StatusCode::CONFLICT, "chunks that make another image");
2653
    let (st, body) = call(&h.app, "PUT", &format!("/api/v1/flow/images/{hash}"), Some("site"), Some(manifest)).await;
2654
    assert_eq!(st, StatusCode::CREATED, "{body}");
2655
2656
    // A runner fetches the manifest and the chunks, and the image comes back whole.
2657
    let (st, body) = call(&h.app, "GET", &format!("/api/v1/flow/images/{hash}"), Some("runner-secret"), None).await;
2658
    assert_eq!(st, StatusCode::OK, "{body}");
2659
    let got: jet::images::Manifest = serde_json::from_str(&body).unwrap();
2660
    assert_eq!(got, m);
2661
    let dir = tempfile::tempdir().unwrap();
2662
    let out = dir.path().join("img.ext4");
2663
    let mut fetched = Vec::new();
2664
    for c in got.needed() {
2665
        let req = Request::get(format!("/api/v1/flow/images/chunks/{c}"))
2666
            .header(header::AUTHORIZATION, "Bearer runner-secret")
2667
            .body(Body::empty())
2668
            .unwrap();
2669
        let res = oxygenhub::router(h.app.clone()).oneshot(req).await.unwrap();
2670
        assert_eq!(res.status(), StatusCode::OK);
2671
        let bytes = res.into_body().collect().await.unwrap().to_bytes().to_vec();
2672
        fetched.push((c.to_string(), bytes));
2673
    }
2674
    jet::images::assemble(&got, &out, |c| Ok(fetched.iter().find(|(h, _)| h == c.hash()).unwrap().1.clone())).unwrap();
2675
    assert_eq!(std::fs::read(&out).unwrap(), image);
2676
    assert_eq!(
2677
        call(&h.app, "GET", &format!("/api/v1/flow/images/{}", "cd".repeat(32)), Some("runner-secret"), None).await.0,
2678
        StatusCode::NOT_FOUND
2679
    );
2680
    assert_ne!(call(&h.app, "GET", &format!("/api/v1/flow/images/{hash}"), None, None).await.0, StatusCode::OK, "not anonymous");
2681
2682
    // A job on that image: a runner holding no images and not fetching
2683
    // is offered nothing; one that fetches is offered it.
2684
    create(&h.app, "andy", "demo").await;
2685
    let url = format!("{}/andy/demo", h.base);
2686
    let work = tempfile::tempdir().unwrap();
2687
    let c = client(&url, work.path());
2688
    write(
2689
        work.path(),
2690
        ".flow/pipeline.kdl",
2691
        &format!("schema-version 1\nsandbox \"img\" {{\n    rootfs \"cas://blob/{hash}\"\n}}\njob \"build\" {{\n    sandbox \"img\"\n    exec \"make\"\n}}\n"),
2692
    );
2693
    c.commit("Build on the image", &[]).unwrap();
2694
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
2695
    runs_of(&h.app, "andy", "demo").await;
2696
    // #137: the run's images are held (by the hub), so no images check.
2697
    let row = db::repos::get(&h.app.db, "andy", "demo").await.unwrap().unwrap();
2698
    let run1 = db::flow::run(&h.app.db, row.id, 1).await.unwrap().unwrap();
2699
    let checks = checks_when(&h.app, row.id, &run1.state, 1).await;
2700
    assert!(checks.iter().all(|c| c.name != "pipeline/images"), "{checks:?}");
2701
    let ask = |fetches: bool| format!(r#"{{"runner":"test-1","runtimes":["microvm"],"images":[],"fetches_images":{fetches}}}"#);
2702
    let (st, _) = call(&h.app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(ask(false))).await;
2703
    assert_eq!(st, StatusCode::NO_CONTENT, "it lacks the image and does not fetch");
2704
    oxygenhub::flow::explain_waits(&h.app).await.unwrap();
2705
    let (_, body) = call(&h.app, "GET", "/api/v1/repos/andy/demo/flow/runs/1", Some("site"), None).await;
2706
    assert!(body.contains("does not hold image"), "{body}");
2707
    let (st, body) = call(&h.app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(ask(true))).await;
2708
    assert_eq!(st, StatusCode::OK, "it fetches, and the hub holds the image: {body}");
2709
}
2710
2711
/// oxygenhub#136: coverage measured on a workstation is uploaded for a
2712
/// bookmark's state, kept as uploaded by its account, shown so, and sets
2713
/// no check.
2714
#[tokio::test(flavor = "multi_thread")]
2715
async fn coverage_uploaded_from_a_workstation_says_so() {
2716
    let h = hub().await;
2717
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
2718
    create(&h.app, "andy", "vk").await;
2719
    let url = format!("{}/andy/vk", h.base);
2720
    let work = tempfile::tempdir().unwrap();
2721
    let c = client(&url, work.path());
2722
    write(work.path(), "src/game.c", "int a;\nint b;\nint c;\nint d;\n");
2723
    c.commit("Game", &[]).unwrap();
2724
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
2725
2726
    let lcov = "SF:src/game.c\nDA:1,3\nDA:2,1\nDA:3,0\nDA:4,5\nend_of_record\nSF:reference/rom.asm\nDA:1,1\nend_of_record\n";
2727
    let body = serde_json::json!({ "bookmark": "main", "content": lcov }).to_string();
2728
    let (st, out) = call(&h.app, "POST", "/api/v1/repos/andy/vk/coverage", Some("site"), Some(body)).await;
2729
    assert_eq!(st, StatusCode::CREATED, "{out}");
2730
    let v: serde_json::Value = serde_json::from_str(&out).unwrap();
2731
    assert_eq!((v["uploaded_by"].as_str(), v["lines_hit"].as_i64(), v["lines_found"].as_i64()), (Some("andy"), Some(3), Some(4)));
2732
    assert_eq!(v["dropped"], 1, "a file outside the state is left out");
2733
    assert_eq!(v["bookmark"], "main");
2734
2735
    let (_, page) = call(&h.app, "GET", "/andy/vk/coverage", None, None).await;
2736
    assert!(page.contains("uploaded by andy") && page.contains("75.0%"), "the Coverage page says where it came from");
2737
    let (_, page) = call(&h.app, "GET", "/andy/vk/reports", None, None).await;
2738
    assert!(page.contains("uploaded by andy"), "and the Reports card");
2739
    let row = db::repos::get(&h.app.db, "andy", "vk").await.unwrap().unwrap();
2740
    let state = v["state"].as_str().unwrap();
2741
    let checks = db::hooks::checks_for_state(&h.app.db, row.id, state).await.unwrap();
2742
    assert!(checks.iter().all(|c| c.name != "coverage"), "an upload sets no check: {checks:?}");
2743
2744
    // Readers cannot upload; bad reports and bookmarks are refused.
2745
    let (st, _) = call(&h.app, "POST", "/api/v1/repos/andy/vk/coverage", None, Some(r#"{"content":"x"}"#.into())).await;
2746
    assert_ne!(st, StatusCode::CREATED);
2747
    let (st, _) = call(
2748
        &h.app,
2749
        "POST",
2750
        "/api/v1/repos/andy/vk/coverage",
2751
        Some("site"),
2752
        Some(r#"{"bookmark":"nope","content":"SF:a\nend_of_record\n"}"#.into()),
2753
    )
2754
    .await;
2755
    assert_eq!(st, StatusCode::BAD_REQUEST);
2756
}
2757
2758
/// oxygenflow#40: what a runner measured at its claim is kept and shown.
2759
#[tokio::test(flavor = "multi_thread")]
2760
async fn a_runners_facts_are_kept_from_its_claim() {
2761
    let h = hub().await;
2762
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
2763
    let body = r#"{"runner":"test-1","runtimes":["microvm"],"facts":{"free_disk_mib":42000,"load_x100":112,"speed":100,"speed_class":3,"kernel":"7.0.0"}}"#;
2764
    let (st, _) = call(&h.app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(body.into())).await;
2765
    assert_eq!(st, StatusCode::NO_CONTENT, "nothing to run, but the facts are kept");
2766
    let (st, out) = call(&h.app, "GET", "/api/v1/runners", Some("site"), None).await;
2767
    assert_eq!(st, StatusCode::OK, "{out}");
2768
    let v: serde_json::Value = serde_json::from_str(&out).unwrap();
2769
    let r = &v[0];
2770
    assert_eq!(
2771
        (r["speed"].as_i64(), r["speed_class"].as_i64(), r["free_disk_mib"].as_i64(), r["load_x100"].as_i64()),
2772
        (Some(100), Some(3), Some(42000), Some(112))
2773
    );
2774
    let row = db::runners::list(&h.app.db).await.unwrap().remove(0);
2775
    assert_eq!(row.facts_line(), "speed 100 (class 3) · load 1.12 · 41 GiB free");
2776
}
2777
2778
/// oxygenflow#41: a job's peaks set what its next run needs; a runner
2779
/// without that much free disk is not offered it, and the reason says so.
2780
#[tokio::test(flavor = "multi_thread")]
2781
async fn a_jobs_next_run_needs_the_disk_its_last_took() {
2782
    let h = hub().await;
2783
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
2784
    create(&h.app, "andy", "demo").await;
2785
    let url = format!("{}/andy/demo", h.base);
2786
    let work = tempfile::tempdir().unwrap();
2787
    let c = client(&url, work.path());
2788
    write(
2789
        work.path(),
2790
        ".flow/pipeline.kdl",
2791
        &format!("schema-version 1\nsandbox \"alpine\" {{\n    rootfs \"cas://blob/{ROOTFS}\"\n}}\njob \"build\" {{\n    sandbox \"alpine\"\n    exec \"make\"\n}}\n"),
2792
    );
2793
    c.commit("Build", &[]).unwrap();
2794
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
2795
    runs_of(&h.app, "andy", "demo").await;
2796
    let claim_with = |free: u64| format!(r#"{{"runner":"test-1","runtimes":["microvm"],"facts":{{"free_disk_mib":{free}}}}}"#);
2797
2798
    // The first run has nothing to learn from: any runner takes it.
2799
    let (st, body) = call(&h.app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(claim_with(500))).await;
2800
    assert_eq!(st, StatusCode::OK, "{body}");
2801
    let id = serde_json::from_str::<serde_json::Value>(&body).unwrap()["job_id"].as_i64().unwrap();
2802
    let done = serde_json::json!({ "exit_code": 0, "duration_ms": 10, "peak_disk_mib": 8000, "peak_memory_mib": 900 });
2803
    assert_eq!(finish(&h.app, id, done).await, StatusCode::NO_CONTENT);
2804
    let job = db::flow::job(&h.app.db, id).await.unwrap().unwrap();
2805
    assert_eq!((job.peak_disk_mib, job.peak_memory_mib), (Some(8000), Some(900)));
2806
2807
    // The next run needs 8000 MiB and a quarter more.
2808
    let (st, _) = call(&h.app, "POST", "/api/v1/repos/andy/demo/flow/runs", Some("site"), Some("{}".into())).await;
2809
    assert_eq!(st, StatusCode::CREATED);
2810
    let repo = db::repos::get(&h.app.db, "andy", "demo").await.unwrap().unwrap();
2811
    let run2 = db::flow::run(&h.app.db, repo.id, 2).await.unwrap().unwrap();
2812
    let next = db::flow::jobs(&h.app.db, run2.id).await.unwrap().remove(0);
2813
    assert_eq!(next.need_disk_mib, Some(8000 + 2000 + 64));
2814
    let (st, _) = call(&h.app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(claim_with(9000))).await;
2815
    assert_eq!(st, StatusCode::NO_CONTENT, "9000 MiB free is not enough");
2816
    oxygenhub::flow::explain_waits(&h.app).await.unwrap();
2817
    let waiting = db::flow::job(&h.app.db, next.id).await.unwrap().unwrap().waiting;
2818
    assert!(waiting.contains("8.8 GiB free; the job needs ~9.8 GiB"), "{waiting}");
2819
    let (st, body) = call(&h.app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(claim_with(20_000))).await;
2820
    assert_eq!(st, StatusCode::OK, "a roomier runner takes it: {body}");
2821
}
2822
2823
/// oxygenflow#42: a job another free runner would do better (it holds the
2824
/// image) is held from a runner that would fetch it, the better runner
2825
/// takes it, and the job says why it ran there.
2826
#[tokio::test(flavor = "multi_thread")]
2827
async fn a_job_waits_briefly_for_a_runner_that_holds_its_image() {
2828
    let h = hub().await;
2829
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
2830
    // A second runner, with a token of its own.
2831
    db::runners::configured(&h.app.db, &blake3::hash(b"other-secret").to_hex(), "earth-9").await.unwrap();
2832
    let ask = |images: &str| {
2833
        format!(
2834
            r#"{{"runner":"r","runtimes":["microvm"],"images":[{images}],"fetches_images":true,"facts":{{"speed":100,"speed_class":3,"free_disk_mib":50000}}}}"#
2835
        )
2836
    };
2837
    let holder = ask(&format!("\"{ROOTFS}\""));
2838
    // earth-9 holds the image and is polling; nothing is queued yet.
2839
    let (st, _) = call(&h.app, "POST", "/api/v1/flow/claim", Some("other-secret"), Some(holder.clone())).await;
2840
    assert_eq!(st, StatusCode::NO_CONTENT);
2841
    // The hub holds the image too, so test-1 could fetch it.
2842
    sqlx::query("INSERT INTO jet_images (hash, size, arch, chunks, uploader, created_ms) VALUES (?, 1, 'x86_64', 1, 'andy', 0)")
2843
        .bind(ROOTFS)
2844
        .execute(&h.app.db)
2845
        .await
2846
        .unwrap();
2847
2848
    create(&h.app, "andy", "demo").await;
2849
    let url = format!("{}/andy/demo", h.base);
2850
    let work = tempfile::tempdir().unwrap();
2851
    let c = client(&url, work.path());
2852
    write(
2853
        work.path(),
2854
        ".flow/pipeline.kdl",
2855
        &format!("schema-version 1\nsandbox \"alpine\" {{\n    rootfs \"cas://blob/{ROOTFS}\"\n}}\njob \"build\" {{\n    sandbox \"alpine\"\n    exec \"make\"\n}}\n"),
2856
    );
2857
    c.commit("Build", &[]).unwrap();
2858
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
2859
    runs_of(&h.app, "andy", "demo").await;
2860
2861
    let (st, _) = call(&h.app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(ask(""))).await;
2862
    assert_eq!(st, StatusCode::NO_CONTENT, "held for the runner that holds the image");
2863
    let (st, body) = call(&h.app, "POST", "/api/v1/flow/claim", Some("other-secret"), Some(holder)).await;
2864
    assert_eq!(st, StatusCode::OK, "{body}");
2865
    let id = serde_json::from_str::<serde_json::Value>(&body).unwrap()["job_id"].as_i64().unwrap();
2866
    let placed = db::flow::job(&h.app.db, id).await.unwrap().unwrap().placed;
2867
    assert!(placed.starts_with("holds the image, idle, speed 100 (class 3)"), "{placed}");
2868
    assert!(placed.contains("held for a better runner"), "{placed}");
2869
    let (_, body) = call(&h.app, "GET", "/api/v1/repos/andy/demo/flow/runs/1", Some("site"), None).await;
2870
    assert!(body.contains("\"placed\":\"holds the image"), "{body}");
2871
}
2872
2873
/// oxygenflow#51: a job waits briefly for the runner holding its build
2874
/// cache, even when the other one holds its image too.
2875
#[tokio::test(flavor = "multi_thread")]
2876
async fn a_job_waits_briefly_for_the_runner_holding_its_build_cache() {
2877
    let h = hub().await;
2878
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
2879
    db::runners::configured(&h.app.db, &blake3::hash(b"other-secret").to_hex(), "earth-9").await.unwrap();
2880
    let slot = flow_core::api::cache_slot("andy/demo", "build");
2881
    let ask = |caches: &str| {
2882
        format!(
2883
            r#"{{"runner":"r","runtimes":["microvm"],"images":["{ROOTFS}"],"fetches_images":true,"caches":[{caches}],"facts":{{"speed":100,"speed_class":3,"free_disk_mib":50000}}}}"#
2884
        )
2885
    };
2886
    let holder = ask(&format!("\"{slot}\""));
2887
    let (st, _) = call(&h.app, "POST", "/api/v1/flow/claim", Some("other-secret"), Some(holder.clone())).await;
2888
    assert_eq!(st, StatusCode::NO_CONTENT);
2889
2890
    create(&h.app, "andy", "demo").await;
2891
    let url = format!("{}/andy/demo", h.base);
2892
    let work = tempfile::tempdir().unwrap();
2893
    let c = client(&url, work.path());
2894
    write(
2895
        work.path(),
2896
        ".flow/pipeline.kdl",
2897
        &format!("schema-version 1\nsandbox \"alpine\" {{\n    rootfs \"cas://blob/{ROOTFS}\"\n}}\njob \"build\" {{\n    sandbox \"alpine\"\n    exec \"make\"\n}}\n"),
2898
    );
2899
    c.commit("Build", &[]).unwrap();
2900
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
2901
    runs_of(&h.app, "andy", "demo").await;
2902
2903
    let (st, _) = call(&h.app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(ask(""))).await;
2904
    assert_eq!(st, StatusCode::NO_CONTENT, "held for the runner holding the build cache");
2905
    let (st, body) = call(&h.app, "POST", "/api/v1/flow/claim", Some("other-secret"), Some(holder)).await;
2906
    assert_eq!(st, StatusCode::OK, "{body}");
2907
    let id = serde_json::from_str::<serde_json::Value>(&body).unwrap()["job_id"].as_i64().unwrap();
2908
    let placed = db::flow::job(&h.app.db, id).await.unwrap().unwrap().placed;
2909
    assert!(placed.starts_with("holds its build cache, holds the image"), "{placed}");
2910
}
2911
2912
/// oxygenflow#54: when both runners hold a job's build cache, the job waits
2913
/// briefly for the one whose copy is fresher.
2914
#[tokio::test(flavor = "multi_thread")]
2915
async fn a_job_waits_briefly_for_the_fresher_build_cache() {
2916
    let h = hub().await;
2917
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
2918
    db::runners::configured(&h.app.db, &blake3::hash(b"other-secret").to_hex(), "earth-9").await.unwrap();
2919
    let slot = flow_core::api::cache_slot("andy/demo", "build");
2920
    let now = db::now_ms();
2921
    let ask = |kept: i64| {
2922
        format!(
2923
            r#"{{"runner":"r","runtimes":["microvm"],"images":["{ROOTFS}"],"fetches_images":true,"caches":["{slot}"],"cache_times":{{"{slot}":{kept}}},"facts":{{"speed":100,"speed_class":3,"free_disk_mib":50000}}}}"#
2924
        )
2925
    };
2926
    // earth-9 kept its copy a minute ago; the other runner's is a day old.
2927
    let fresh = ask(now - 60_000);
2928
    let (st, _) = call(&h.app, "POST", "/api/v1/flow/claim", Some("other-secret"), Some(fresh.clone())).await;
2929
    assert_eq!(st, StatusCode::NO_CONTENT);
2930
2931
    create(&h.app, "andy", "demo").await;
2932
    let url = format!("{}/andy/demo", h.base);
2933
    let work = tempfile::tempdir().unwrap();
2934
    let c = client(&url, work.path());
2935
    write(
2936
        work.path(),
2937
        ".flow/pipeline.kdl",
2938
        &format!("schema-version 1\nsandbox \"alpine\" {{\n    rootfs \"cas://blob/{ROOTFS}\"\n}}\njob \"build\" {{\n    sandbox \"alpine\"\n    exec \"make\"\n}}\n"),
2939
    );
2940
    c.commit("Build", &[]).unwrap();
2941
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
2942
    runs_of(&h.app, "andy", "demo").await;
2943
2944
    let (st, _) = call(&h.app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(ask(now - 86_400_000))).await;
2945
    assert_eq!(st, StatusCode::NO_CONTENT, "held for the fresher copy");
2946
    let (st, body) = call(&h.app, "POST", "/api/v1/flow/claim", Some("other-secret"), Some(fresh)).await;
2947
    assert_eq!(st, StatusCode::OK, "{body}");
2948
    let id = serde_json::from_str::<serde_json::Value>(&body).unwrap()["job_id"].as_i64().unwrap();
2949
    let placed = db::flow::job(&h.app.db, id).await.unwrap().unwrap().placed;
2950
    assert!(placed.starts_with("holds its build cache (kept 1 min ago), holds the image"), "{placed}");
2951
}
2952
2953
/// oxygenhub#127 §3.3: report files expire beyond the newest 50 runs of a
2954
/// report on a bookmark other than the default; the default keeps all,
2955
/// and an expired report keeps its metrics.
2956
#[tokio::test(flavor = "multi_thread")]
2957
async fn report_files_expire_under_retention() {
2958
    let h = hub().await;
2959
    create(&h.app, "andy", "demo").await;
2960
    let repo = db::repos::get(&h.app.db, "andy", "demo").await.unwrap().unwrap();
2961
    let add = |bookmark: &'static str, at: i64| {
2962
        let db = h.app.db.clone();
2963
        async move {
2964
            let id: i64 = sqlx::query_scalar(
2965
                "INSERT INTO reports (repo_id, name, kind, title, summary, context, job, bookmark, state, files, bytes, created_ms) \
2966
                 VALUES (?, 'perf', 'performance', 'Perf', '', '{}', 'perf', ?, 's', 1, 1, ?) RETURNING id",
2967
            )
2968
            .bind(repo.id)
2969
            .bind(bookmark)
2970
            .bind(at)
2971
            .fetch_one(&db)
2972
            .await
2973
            .unwrap();
2974
            sqlx::query("INSERT INTO report_files (report_id, path, blob, size) VALUES (?, 'report.toml', ?, 1)")
2975
                .bind(id)
2976
                .bind(format!("{:064x}", id))
2977
                .execute(&db)
2978
                .await
2979
                .unwrap();
2980
            sqlx::query("INSERT INTO report_metrics (report_id, key, value, unit, better) VALUES (?, 'ms', 1, '', '')")
2981
                .bind(id)
2982
                .execute(&db)
2983
                .await
2984
                .unwrap();
2985
            id
2986
        }
2987
    };
2988
    let main_old = add("main", 1).await;
2989
    add("main", 2).await;
2990
    let mut feature = Vec::new();
2991
    for at in 0..52 {
2992
        feature.push(add("feature", 10 + at).await);
2993
    }
2994
    assert_eq!(oxygenhub::reports::expire(&h.app.db).await.unwrap(), 2, "the two oldest feature runs");
2995
    let files = |id: i64| {
2996
        let db = h.app.db.clone();
2997
        async move {
2998
            sqlx::query_scalar::<_, i64>("SELECT COUNT(*) FROM report_files WHERE report_id = ?").bind(id).fetch_one(&db).await.unwrap()
2999
        }
3000
    };
3001
    assert_eq!((files(feature[0]).await, files(feature[1]).await, files(feature[2]).await), (0, 0, 1));
3002
    assert_eq!(files(main_old).await, 1, "the default bookmark keeps every run");
3003
    assert_eq!(oxygenhub::reports::metrics(&h.app.db, feature[0]).await.unwrap().len(), 1, "metrics are kept");
3004
    assert_eq!(oxygenhub::reports::expire(&h.app.db).await.unwrap(), 0, "once");
3005
    let (_, page) = call(&h.app, "GET", &format!("/andy/demo/reports/perf?id={}", feature[0]), None, None).await;
3006
    assert!(page.contains("files have expired"), "the page says so");
3007
}
3008
3009
/// #137: a run pinning an image neither the hub nor any runner holds sets a
3010
/// failing `pipeline/images` check saying how to send it; once it is held,
3011
/// a run of the same state turns the check to passed.
3012
#[tokio::test(flavor = "multi_thread")]
3013
async fn a_pipeline_pinning_an_image_nobody_holds_fails_a_check() {
3014
    let h = hub().await;
3015
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
3016
    // The one runner reports holding no images.
3017
    let none = r#"{"runner":"test-1","runtimes":["microvm"],"images":[]}"#;
3018
    let (st, _) = call(&h.app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(none.into())).await;
3019
    assert_eq!(st, StatusCode::NO_CONTENT);
3020
    create(&h.app, "andy", "demo").await;
3021
    let url = format!("{}/andy/demo", h.base);
3022
    let work = tempfile::tempdir().unwrap();
3023
    let c = client(&url, work.path());
3024
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
3025
    write(work.path(), "test.sh", "echo ok\n");
3026
    c.commit("Add a pipeline", &[]).unwrap();
3027
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
3028
    let run = runs_of(&h.app, "andy", "demo").await.remove(0);
3029
    let checks = checks_when(&h.app, run.repo_id, &run.state, 4).await;
3030
    let check = checks.iter().find(|c| c.name == "pipeline/images").expect("an images check");
3031
    assert!(check.status == "failed" && check.summary.contains(&ROOTFS[..12]) && check.summary.contains("flow rootfs push"), "{check:?}");
3032
    // Once a runner holds it, a run of the state passes the check.
3033
    let holds = format!(r#"{{"runner":"test-1","runtimes":["microvm"],"images":["{ROOTFS}"]}}"#);
3034
    call(&h.app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(holds)).await;
3035
    let (st, _) = call(&h.app, "POST", "/api/v1/repos/andy/demo/flow/runs", Some("site"), Some("{}".into())).await;
3036
    assert_eq!(st, StatusCode::CREATED);
3037
    let checks = db::hooks::checks_for_state(&h.app.db, run.repo_id, &run.state).await.unwrap();
3038
    let check = checks.iter().find(|c| c.name == "pipeline/images").unwrap();
3039
    assert_eq!(check.status, "passed", "{check:?}");
3040
}
3041
3042
/// The swarm's tracker (#144): a fetching runner is given the peers in its
3043
/// site that hold the image or are fetching it, and a ticket signed with
3044
/// the hub key; a runner not in a swarm is told how to join one.
3045
#[tokio::test(flavor = "multi_thread")]
3046
async fn the_tracker_names_peers_in_the_same_site_and_signs_a_ticket() {
3047
    let h = hub().await;
3048
    let app = &h.app;
3049
    let image = "ab".repeat(32);
3050
    let claim_as = |token: &'static str, name: &'static str, body: serde_json::Value| async move {
3051
        let mut b = serde_json::json!({ "runner": name, "runtimes": ["microvm"] });
3052
        b.as_object_mut().unwrap().extend(body.as_object().unwrap().clone());
3053
        let (st, out) = call(app, "POST", "/api/v1/flow/claim", Some(token), Some(b.to_string())).await;
3054
        assert_eq!(st, StatusCode::NO_CONTENT, "{out}");
3055
    };
3056
    let announce = |token: &'static str, state: &'static str| {
3057
        let body = serde_json::json!({ "image": image, "state": state }).to_string();
3058
        async move { call(app, "POST", "/api/v1/flow/swarm/announce", Some(token), Some(body)).await }
3059
    };
3060
    // A holds the image; B and C hold nothing; all three are in site "lab".
3061
    claim_as(
3062
        "runner-secret",
3063
        "a",
3064
        serde_json::json!({ "images": [image], "swarm": { "addr": "10.0.0.1:7401", "site": "lab", "cert": "11".repeat(32) } }),
3065
    )
3066
    .await;
3067
    claim_as(
3068
        "runner-two",
3069
        "b",
3070
        serde_json::json!({ "images": [], "swarm": { "addr": "10.0.0.2:7401", "site": "lab", "cert": "22".repeat(32) } }),
3071
    )
3072
    .await;
3073
    claim_as(
3074
        "runner-three",
3075
        "c",
3076
        serde_json::json!({ "images": [], "swarm": { "addr": "10.0.0.3:7401", "site": "lab", "cert": "33".repeat(32) } }),
3077
    )
3078
    .await;
3079
3080
    let (st, body) = announce("runner-two", "fetching").await;
3081
    assert_eq!(st, StatusCode::OK, "{body}");
3082
    let a: flow_core::api::Announced = serde_json::from_str(&body).unwrap();
3083
    let names: Vec<(&str, bool)> = a.peers.iter().map(|p| (p.addr.as_str(), p.complete)).collect();
3084
    assert_eq!(names, vec![("10.0.0.1:7401", true)], "only A holds it so far");
3085
    assert_eq!(a.peers[0].cert, "11".repeat(32), "with the fingerprint peers check it by");
3086
    let t = jet::swarm::Ticket::open(&a.ticket, &app.hub_key.identity, oxygenhub::db::now_ms() as u64).unwrap();
3087
    assert_eq!((t.name.as_str(), t.site.as_str()), ("b", "lab"));
3088
3089
    // C, fetching too, is told of A (whole) and B (fetching).
3090
    let (_, body) = announce("runner-three", "fetching").await;
3091
    let a: flow_core::api::Announced = serde_json::from_str(&body).unwrap();
3092
    let mut peers: Vec<(&str, bool)> = a.peers.iter().map(|p| (p.addr.as_str(), p.complete)).collect();
3093
    peers.sort();
3094
    assert_eq!(peers, vec![("10.0.0.1:7401", true), ("10.0.0.2:7401", false)]);
3095
3096
    // B is done: no longer offered as fetching. C moves site: no peers.
3097
    announce("runner-two", "done").await;
3098
    claim_as(
3099
        "runner-three",
3100
        "c",
3101
        serde_json::json!({ "images": [], "swarm": { "addr": "10.0.0.3:7401", "site": "elsewhere", "cert": "33".repeat(32) } }),
3102
    )
3103
    .await;
3104
    let (_, body) = announce("runner-three", "fetching").await;
3105
    let a: flow_core::api::Announced = serde_json::from_str(&body).unwrap();
3106
    assert!(a.peers.is_empty(), "{:?}", a.peers);
3107
3108
    // A runner without a certificate (an older flow) is not in the swarm.
3109
    claim_as("runner-secret", "a", serde_json::json!({ "images": [image], "swarm": { "addr": "10.0.0.1:7401", "site": "elsewhere" } }))
3110
        .await;
3111
    let (st, _) = announce("runner-secret", "fetching").await;
3112
    assert_eq!(st, StatusCode::CONFLICT);
3113
3114
    // A runner that left the swarm is told how to join; nonsense is refused.
3115
    claim_as("runner-two", "b", serde_json::json!({ "images": [] })).await;
3116
    let (st, body) = announce("runner-two", "fetching").await;
3117
    assert_eq!(st, StatusCode::CONFLICT);
3118
    assert!(body.contains("[runner.swarm]"), "{body}");
3119
    let (st, _) =
3120
        call(app, "POST", "/api/v1/flow/swarm/announce", Some("runner-secret"), Some(r#"{"image":"nope","state":"fetching"}"#.into()))
3121
            .await;
3122
    assert_eq!(st, StatusCode::BAD_REQUEST);
3123
    let (st, _) = call(
3124
        app,
3125
        "POST",
3126
        "/api/v1/flow/swarm/announce",
3127
        None,
3128
        Some(serde_json::json!({ "image": image, "state": "fetching" }).to_string()),
3129
    )
3130
    .await;
3131
    assert_eq!(st, StatusCode::UNAUTHORIZED);
3132
}
3133
3134
/// Admin › Runners › Images (C0): each image, where it is and what uses it.
3135
#[tokio::test(flavor = "multi_thread")]
3136
async fn the_images_page_says_where_each_image_is_and_what_uses_it() {
3137
    let h = hub().await;
3138
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
3139
    create(&h.app, "andy", "demo").await;
3140
    let work = tempfile::tempdir().unwrap();
3141
    let c = client(&format!("{}/andy/demo", h.base), work.path());
3142
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
3143
    write(work.path(), "test.sh", "echo ok\n");
3144
    c.commit("Add a pipeline", &[]).unwrap();
3145
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
3146
    // A runner holds another image and shares it; the hub keeps a third.
3147
    let held = "cd".repeat(32);
3148
    let kept = "ef".repeat(32);
3149
    let body = serde_json::json!({ "runner": "earth-1", "runtimes": ["wasm"], "images": [held], "swarm": { "addr": "10.0.0.1:7401", "site": "home", "cert": "11".repeat(32) } });
3150
    let (st, out) = call(&h.app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(body.to_string())).await;
3151
    assert!(st == StatusCode::NO_CONTENT || st == StatusCode::OK, "{st} {out}");
3152
    sqlx::query("INSERT INTO jet_images (hash, size, arch, chunks, uploader, created_ms) VALUES (?, 1048576, 'x86_64', 9, 'andy', 1)")
3153
        .bind(&kept)
3154
        .execute(&h.app.db)
3155
        .await
3156
        .unwrap();
3157
3158
    let res = oxygenhub::router(h.app.clone())
3159
        .oneshot(
3160
            Request::post("/register")
3161
                .header(header::CONTENT_TYPE, "application/x-www-form-urlencoded")
3162
                .body(Body::from("username=carol&email=carol%40example.com&password=correct-horse-battery"))
3163
                .unwrap(),
3164
        )
3165
        .await
3166
        .unwrap();
3167
    let cookie = res.headers().get(header::SET_COOKIE).unwrap().to_str().unwrap().split(';').next().unwrap().to_string();
3168
    let carol = db::accounts::account_by_name(&h.app.db, "carol").await.unwrap().unwrap();
3169
    db::accounts::set_admin(&h.app.db, carol.id, true).await.unwrap();
3170
    let res = oxygenhub::router(h.app.clone())
3171
        .oneshot(Request::get("/admin/runners/images").header(header::COOKIE, cookie).body(Body::empty()).unwrap())
3172
        .await
3173
        .unwrap();
3174
    assert_eq!(res.status(), StatusCode::OK);
3175
    let page = String::from_utf8_lossy(&res.into_body().collect().await.unwrap().to_bytes()).into_owned();
3176
    let row = |hash: &str| {
3177
        let at = page.find(&format!("title=\"{hash}\"")).unwrap_or_else(|| panic!("{hash} is not on the page"));
3178
        let end = page[at..].find("</tr>").unwrap();
3179
        page[at..at + end].to_string()
3180
    };
3181
    let pinned = row(ROOTFS);
3182
    assert!(pinned.contains("nowhere") && pinned.contains("andy/demo") && pinned.contains("3 jobs"), "{pinned}");
3183
    let on_runner = row(&held);
3184
    assert!(on_runner.contains("img-holds") && on_runner.contains("earth-1") && !on_runner.contains("nowhere"), "{on_runner}");
3185
    let on_hub = row(&kept);
3186
    assert!(on_hub.contains("img-hub") && on_hub.contains("1.0 MiB") && on_hub.contains("x86_64"), "{on_hub}");
3187
    assert!(page.contains("earth-1 (home)"), "the swarm is named");
3188
    assert_eq!(call(&h.app, "GET", "/admin/runners/images", None, None).await.0, StatusCode::NOT_FOUND, "administrators only");
3189
}
3190
3191
/// Diffusion D1 (#148): the reverse pin index. A repository that pins
3192
/// another as a subrepo is a consumer of it; the upstream's API and page
3193
/// say who, at which state, and how far behind its default bookmark.
3194
#[tokio::test(flavor = "multi_thread")]
3195
async fn consumers_of_a_subrepo_are_indexed_with_how_far_behind_they_are() {
3196
    let h = hub().await;
3197
    // The site token acts as the first site administrator.
3198
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
3199
    create(&h.app, "andy", "api").await;
3200
    create(&h.app, "andy", "game").await;
3201
    let api_work = tempfile::tempdir().unwrap();
3202
    let api = client(&format!("{}/andy/api", h.base), api_work.path());
3203
    write(api_work.path(), "api.h", "v1\n");
3204
    api.snapshot("t").unwrap();
3205
    api.commit("api v1", &[]).unwrap();
3206
    assert!(api.push("origin", false).unwrap().iter().all(|r| r.ok));
3207
3208
    let game_work = tempfile::tempdir().unwrap();
3209
    let game = client(&format!("{}/andy/game", h.base), game_work.path());
3210
    game.submodule_add(&format!("{}/andy/api", h.base), "deps/api", Some("main")).unwrap();
3211
    write(game_work.path(), "game.c", "int main;\n");
3212
    game.snapshot("t").unwrap();
3213
    game.commit("game on api v1", &[]).unwrap();
3214
    assert!(game.push("origin", false).unwrap().iter().all(|r| r.ok));
3215
3216
    let consumers = || async {
3217
        let (st, body) = call(&h.app, "GET", "/api/v1/repos/andy/api/consumers", Some("site"), None).await;
3218
        assert_eq!(st, StatusCode::OK, "{body}");
3219
        serde_json::from_str::<Vec<serde_json::Value>>(&body).unwrap()
3220
    };
3221
    // The index is written by the push's after-work, a moment after the
3222
    // client hears the push succeeded.
3223
    let settle = |want: &'static (dyn Fn(&[serde_json::Value]) -> bool + Sync)| {
3224
        let consumers = &consumers;
3225
        async move {
3226
            for _ in 0..100 {
3227
                let list = consumers().await;
3228
                if want(&list) {
3229
                    return list;
3230
                }
3231
                tokio::time::sleep(std::time::Duration::from_millis(50)).await;
3232
            }
3233
            consumers().await
3234
        }
3235
    };
3236
    let list = settle(&|l| !l.is_empty()).await;
3237
    assert_eq!(list.len(), 1, "{list:?}");
3238
    assert_eq!(
3239
        (list[0]["name"].as_str(), list[0]["path"].as_str(), list[0]["bookmark"].as_str()),
3240
        (Some("game"), Some("deps/api"), Some("main"))
3241
    );
3242
    assert_eq!(list[0]["behind"], 0);
3243
3244
    // The upstream moves on: the consumer is one change behind.
3245
    write(api_work.path(), "api.c", "v2\n");
3246
    api.snapshot("t").unwrap();
3247
    api.commit("api v2", &[]).unwrap();
3248
    assert!(api.push("origin", false).unwrap().iter().all(|r| r.ok));
3249
    assert_eq!(settle(&|l| l.first().is_some_and(|c| c["behind"] == 1)).await[0]["behind"], 1);
3250
    let (_, page) = call(&h.app, "GET", "/andy/api", None, None).await;
3251
    assert!(page.contains("Diffuses to") && page.contains("andy/game") && page.contains("1 behind"), "the page shows it");
3252
3253
    // A private consumer is not shown to someone who cannot read it.
3254
    sqlx::query("UPDATE repositories SET visibility = 'private' WHERE name = 'game'").execute(&h.app.db).await.unwrap();
3255
    let (_, body) = call(&h.app, "GET", "/api/v1/repos/andy/api/consumers", None, None).await;
3256
    assert_eq!(body.trim(), "[]");
3257
    let (_, page) = call(&h.app, "GET", "/andy/api", None, None).await;
3258
    assert!(!page.contains("andy/game"));
3259
    sqlx::query("UPDATE repositories SET visibility = 'public' WHERE name = 'game'").execute(&h.app.db).await.unwrap();
3260
3261
    // A bump (DF3): one signed change on the target moving only the pin, on
3262
    // `diffusion/deps/api`; again with the same state, nothing new.
3263
    let game_row = db::repos::get(&h.app.db, "andy", "game").await.unwrap().unwrap();
3264
    let api_row = db::repos::get(&h.app.db, "andy", "api").await.unwrap().unwrap();
3265
    let api_heads = api.bookmark_heads().unwrap();
3266
    let bumped = oxygenhub::diffusion::bump(&h.app, &game_row, "main", "deps/api", &api_row, api_heads.clone()).await.unwrap();
3267
    let oxygenhub::diffusion::Bumped::Moved { bookmark, heads, .. } = bumped else { panic!("{bumped:?}") };
3268
    assert_eq!(bookmark, "diffusion/deps/api");
3269
    game.fetch("origin").unwrap();
3270
    let bump_state = game.load_state(&heads).unwrap().materialize();
3271
    let pin = match &bump_state.files["deps/api"].content {
3272
        oxy_core::state::FileContent::Opaque { blobs } => oxy_core::subrepo::Pin::decode(&game.read_blob(&blobs[0]).unwrap()).unwrap(),
3273
        other => panic!("{other:?}"),
3274
    };
3275
    assert!(
3276
        matches!(&pin, oxy_core::subrepo::Pin::Oxy { heads, .. } if { let mut a = heads.clone(); a.sort(); let mut b = api_heads.clone(); b.sort(); a == b }),
3277
        "{pin:?}"
3278
    );
3279
    assert!(bump_state.files.contains_key("game.c"), "the rest of the game is as it was");
3280
    assert!(matches!(
3281
        oxygenhub::diffusion::bump(&h.app, &game_row, "main", "deps/api", &api_row, api_heads.clone()).await.unwrap(),
3282
        oxygenhub::diffusion::Bumped::Already { .. }
3283
    ));
3284
    // A state lacking changes the pin has (as when the consumer pinned an
3285
    // upstream proposal not landed yet) is combined with the pin, never
3286
    // dropping what it relies on.
3287
    write(api_work.path(), "other.c", "v3\n");
3288
    api.snapshot("t").unwrap();
3289
    let v3 = api.commit("api v3, on its own", &[]).unwrap();
3290
    assert!(api.push("origin", false).unwrap().iter().all(|r| r.ok));
3291
    let only_v3 = api.load_state(&[v3]).unwrap().heads().to_vec();
3292
    let combined = oxygenhub::diffusion::bump(&h.app, &game_row, "main", "deps/api", &api_row, only_v3).await.unwrap();
3293
    let oxygenhub::diffusion::Bumped::Moved { heads: ch, .. } = combined else { panic!("{combined:?}") };
3294
    game.fetch("origin").unwrap();
3295
    let st = game.load_state(&ch).unwrap().materialize();
3296
    let pin = match &st.files["deps/api"].content {
3297
        oxy_core::state::FileContent::Opaque { blobs } => oxy_core::subrepo::Pin::decode(&game.read_blob(&blobs[0]).unwrap()).unwrap(),
3298
        other => panic!("{other:?}"),
3299
    };
3300
    let oxy_core::subrepo::Pin::Oxy { heads: pinned, .. } = pin else { panic!() };
3301
    let all = api.load_state(&pinned).unwrap();
3302
    // The game's main still pins v1 alone; combined with v3, it is both.
3303
    assert!(all.contains(&v3) && all.len() == 2, "v1 and v3, {} changes", all.len());
3304
    // The upstream moves again: the same bookmark moves.
3305
    let newer = api.bookmark_heads().unwrap();
3306
    let again = oxygenhub::diffusion::bump(&h.app, &game_row, "main", "deps/api", &api_row, newer).await.unwrap();
3307
    assert!(matches!(again, oxygenhub::diffusion::Bumped::Moved { ref bookmark, .. } if bookmark == "diffusion/deps/api"), "{again:?}");
3308
3309
    // Following is off by default; owners turn it on (DF2).
3310
    let put =
3311
        |body: &'static str, who: Option<&'static str>| call(&h.app, "PUT", "/api/v1/repos/andy/game/diffusion", who, Some(body.into()));
3312
    let (st, body) = put(r#"{"follow":"green"}"#, Some("site")).await;
3313
    assert_eq!(st, StatusCode::OK, "{body}");
3314
    assert!(body.contains("\"follow\":\"green\"") && body.contains("\"from\":\"setting\""), "{body}");
3315
    assert_eq!(put(r#"{"follow":"sometimes"}"#, Some("site")).await.0, StatusCode::BAD_REQUEST);
3316
    assert_ne!(put(r#"{"follow":"any"}"#, None).await.0, StatusCode::OK, "not without a token");
3317
    let (_, body) = put(r#"{"follow":"default"}"#, Some("site")).await;
3318
    assert!(body.contains("\"follow\":\"off\"") && body.contains("\"from\":\"site\""), "{body}");
3319
3320
    // Dropping the subrepo drops the consumer.
3321
    game.submodule_remove("deps/api").unwrap();
3322
    std::fs::remove_dir_all(game_work.path().join("deps/api")).unwrap();
3323
    game.snapshot("t").unwrap();
3324
    game.commit("game without api", &[]).unwrap();
3325
    assert!(game.push("origin", false).unwrap().iter().all(|r| r.ok));
3326
    let left = settle(&|l| l.is_empty()).await;
3327
    assert!(left.is_empty(), "{left:?}");
3328
}
3329
3330
/// Diffusion D1 end to end (#148): a consumer that follows every move gets
3331
/// a bump proposal on a push; one that follows green gets it when the
3332
/// upstream's run passes. One proposal, kept up to date.
3333
#[tokio::test(flavor = "multi_thread")]
3334
async fn diffusion_proposes_a_bump_when_the_upstream_moves() {
3335
    let h = hub().await;
3336
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
3337
    create(&h.app, "andy", "api").await;
3338
    create(&h.app, "andy", "game").await;
3339
    // Run every job of the upstream's newest run to a pass, keeping each claim.
3340
    let seen: std::sync::Mutex<Vec<serde_json::Value>> = std::sync::Mutex::new(Vec::new());
3341
    let seen = &seen;
3342
    let hub_app = &h.app;
3343
    let pass_all = move || async move {
3344
        let h_app = hub_app;
3345
        for _ in 0..20 {
3346
            let Some(a) = claim(h_app).await else {
3347
                tokio::time::sleep(std::time::Duration::from_millis(30)).await;
3348
                if !jobs_left(h_app).await {
3349
                    break;
3350
                }
3351
                continue;
3352
            };
3353
            seen.lock().unwrap().push(a.clone());
3354
            let id = a["job_id"].as_i64().unwrap();
3355
            let (name, ph) = (a["job"]["name"].as_str().unwrap().to_string(), a["pipeline_hash"].as_str().unwrap().to_string());
3356
            assert_eq!(
3357
                finish(h_app, id, serde_json::json!({ "exit_code": 0, "duration_ms": 10, "receipt": receipt(&name, &ph, 0) })).await,
3358
                StatusCode::NO_CONTENT
3359
            );
3360
        }
3361
    };
3362
    let api_work = tempfile::tempdir().unwrap();
3363
    let api = client(&format!("{}/andy/api", h.base), api_work.path());
3364
    write(api_work.path(), ".flow/pipeline.kdl", &pipeline(""));
3365
    write(api_work.path(), "test.sh", "echo ok\n");
3366
    write(api_work.path(), "api.h", "v1\n");
3367
    api.snapshot("t").unwrap();
3368
    api.commit("api v1", &[]).unwrap();
3369
    assert!(api.push("origin", false).unwrap().iter().all(|r| r.ok));
3370
    pass_all().await;
3371
3372
    let game_work = tempfile::tempdir().unwrap();
3373
    let game = client(&format!("{}/andy/game", h.base), game_work.path());
3374
    game.submodule_add(&format!("{}/andy/api", h.base), "deps/api", Some("main")).unwrap();
3375
    write(game_work.path(), "game.c", "int main;\n");
3376
    write(game_work.path(), ".flow/pipeline.kdl", &pipeline(""));
3377
    write(game_work.path(), "test.sh", "echo ok\n");
3378
    game.snapshot("t").unwrap();
3379
    game.commit("game on api v1", &[]).unwrap();
3380
    assert!(game.push("origin", false).unwrap().iter().all(|r| r.ok));
3381
    let game_row = db::repos::get(&h.app.db, "andy", "game").await.unwrap().unwrap();
3382
    let bump = || async {
3383
        for _ in 0..100 {
3384
            let open = db::proposals::list(&h.app.db, game_row.id, &["open"]).await.unwrap();
3385
            if let Some(p) = open.into_iter().find(|p| p.source_bookmark == "diffusion/deps/api") {
3386
                return Some(p);
3387
            }
3388
            tokio::time::sleep(std::time::Duration::from_millis(50)).await;
3389
        }
3390
        None
3391
    };
3392
3393
    // Off by default: an upstream move proposes nothing.
3394
    write(api_work.path(), "a2.c", "v2\n");
3395
    api.snapshot("t").unwrap();
3396
    api.commit("api v2: faster sprites", &[]).unwrap();
3397
    assert!(api.push("origin", false).unwrap().iter().all(|r| r.ok));
3398
    pass_all().await;
3399
    tokio::time::sleep(std::time::Duration::from_millis(300)).await;
3400
    assert!(db::proposals::list(&h.app.db, game_row.id, &[]).await.unwrap().is_empty(), "off proposes nothing");
3401
3402
    // Turned on to follow every move: bumped at once to where the upstream
3403
    // is (v2), by the diffusion account; the next push updates it.
3404
    let put = |body: &'static str| call(&h.app, "PUT", "/api/v1/repos/andy/game/diffusion", Some("site"), Some(body.into()));
3405
    assert_eq!(put(r#"{"follow":"any"}"#).await.0, StatusCode::OK);
3406
    let first = bump().await.expect("caught up when turned on");
3407
    assert!(first.title.contains("1 change") && first.body.contains("api v2: faster sprites"), "{:?}", first.title);
3408
    // The bump's pipeline runs, as a push of it would, so the proposal is tested.
3409
    let mut ran = false;
3410
    for _ in 0..100 {
3411
        if runs_of(&h.app, "andy", "game").await.iter().any(|r| r.bookmark == "diffusion/deps/api") {
3412
            ran = true;
3413
            break;
3414
        }
3415
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
3416
    }
3417
    assert!(ran, "a run of the bump");
3418
    pass_all().await;
3419
    write(api_work.path(), "a3.c", "v3\n");
3420
    api.snapshot("t").unwrap();
3421
    api.commit("api v3: save slots past ten", &[]).unwrap();
3422
    assert!(api.push("origin", false).unwrap().iter().all(|r| r.ok));
3423
    let mut p = first.clone();
3424
    for _ in 0..100 {
3425
        p = bump().await.unwrap();
3426
        if p.body.contains("api v3") {
3427
            break;
3428
        }
3429
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
3430
    }
3431
    assert_eq!(p.number, first.number, "the same proposal");
3432
    assert_eq!((p.author.as_str(), p.target.as_str()), ("diffusion", "main"));
3433
    assert!(p.title.contains("deps/api") && p.title.contains("andy/api") && p.title.contains("2 changes"), "{}", p.title);
3434
    assert!(p.body.contains("api v2: faster sprites") && p.body.contains("api v3: save slots past ten"), "{}", p.body);
3435
    let labels = db::issues::proposal_labels(&h.app.db, p.id).await.unwrap();
3436
    assert!(labels.iter().any(|l| l.name == "dependencies"));
3437
    pass_all().await;
3438
3439
    // Following green: a push alone does not move it; the passing run does,
3440
    // and the same proposal is brought up to date.
3441
    assert_eq!(put(r#"{"follow":"green"}"#).await.0, StatusCode::OK);
3442
    write(api_work.path(), "a4.c", "v4\n");
3443
    api.snapshot("t").unwrap();
3444
    api.commit("api v4: rsm_set cheaper", &[]).unwrap();
3445
    assert!(api.push("origin", false).unwrap().iter().all(|r| r.ok));
3446
    tokio::time::sleep(std::time::Duration::from_millis(300)).await;
3447
    assert!(!bump().await.unwrap().body.contains("api v4"), "not before its run passes");
3448
    pass_all().await;
3449
    let mut updated = None;
3450
    for _ in 0..100 {
3451
        let p2 = bump().await.unwrap();
3452
        if p2.body.contains("api v4") {
3453
            updated = Some(p2);
3454
            break;
3455
        }
3456
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
3457
    }
3458
    let p2 = updated.expect("brought up to date once the run passed");
3459
    assert_eq!(p2.number, p.number, "the same proposal");
3460
    assert!(p2.title.contains("3 changes"), "{}", p2.title);
3461
    assert_eq!(db::proposals::list(&h.app.db, game_row.id, &[]).await.unwrap().len(), 1, "never a pile of bumps");
3462
3463
    // The views (#150): the upstream's Diffusion tab lists the game with its
3464
    // status; the game's tab and overview say what it follows.
3465
    pass_all().await;
3466
    let (st, page) = call(&h.app, "GET", "/andy/api/diffusion", None, None).await;
3467
    assert_eq!(st, StatusCode::OK);
3468
    assert!(page.contains("Diffuses to") && page.contains("andy/game") && page.contains(&format!("#{}", p2.number)), "the bump is listed");
3469
    assert!(page.contains("df-green"), "a passing run of a checked upstream is green");
3470
    let (_, page) = call(&h.app, "GET", "/andy/game/diffusion", None, None).await;
3471
    assert!(page.contains("Takes from") && page.contains("andy/api"));
3472
    let (_, overview) = call(&h.app, "GET", "/andy/game", None, None).await;
3473
    assert!(overview.contains("Takes from") && overview.contains(">Diffusion</a>"), "the tab and the panel");
3474
    // Both directions through the API (#153), as the extension reads them.
3475
    let (st, body) = call(&h.app, "GET", "/api/v1/repos/andy/game/diffusion", Some("site"), None).await;
3476
    assert_eq!(st, StatusCode::OK, "{body}");
3477
    let d: hub_api::Diffusion = serde_json::from_str(&body).unwrap();
3478
    assert!(d.diffuses_to.is_empty(), "nothing pins the game");
3479
    let pin = d.takes_from.first().expect("the game takes from the api");
3480
    assert_eq!((pin.upstream.as_str(), pin.consumer.as_str()), ("andy/api", "andy/game"));
3481
    assert_eq!(pin.bump, Some(p2.number));
3482
    assert_eq!(pin.upstream_state.tone, "green", "{body}");
3483
    let (_, body) = call(&h.app, "GET", "/api/v1/repos/andy/api/diffusion", Some("site"), None).await;
3484
    let d: hub_api::Diffusion = serde_json::from_str(&body).unwrap();
3485
    assert!(d.takes_from.is_empty() && d.diffuses_to.iter().any(|p| p.consumer == "andy/game"), "{body}");
3486
    let (st, _) = call(&h.app, "GET", "/admin/diffusion", None, None).await;
3487
    assert_eq!(st, StatusCode::NOT_FOUND, "administrators only");
3488
3489
    // Landing the bump on the hub moves the game's pin as a push would:
3490
    // the index follows, so it is no longer behind.
3491
    let (st, body) =
3492
        call(&h.app, "POST", &format!("/api/v1/repos/andy/game/proposals/{}/land", p2.number), Some("site"), Some("{}".into())).await;
3493
    assert_eq!(st, StatusCode::OK, "{body}");
3494
    let mut behind = serde_json::Value::Null;
3495
    for _ in 0..100 {
3496
        let (_, list) = call(&h.app, "GET", "/api/v1/repos/andy/api/consumers", Some("site"), None).await;
3497
        let list: Vec<serde_json::Value> = serde_json::from_str(&list).unwrap();
3498
        behind = list.iter().find(|c| c["name"] == "game").map(|c| c["behind"].clone()).unwrap_or_default();
3499
        if behind == 0 {
3500
            break;
3501
        }
3502
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
3503
    }
3504
    assert_eq!(behind, 0, "the index followed the landing");
3505
3506
    // A private upstream: the bump's run (started by the diffusion account,
3507
    // which cannot read it) still gets the subrepo it bumps.
3508
    sqlx::query("UPDATE repositories SET visibility = 'private' WHERE name = 'api'").execute(&h.app.db).await.unwrap();
3509
    seen.lock().unwrap().clear();
3510
    write(api_work.path(), "a6.c", "v6\n");
3511
    api.snapshot("t").unwrap();
3512
    api.commit("api v6", &[]).unwrap();
3513
    assert!(api.push("origin", false).unwrap().iter().all(|r| r.ok));
3514
    // The bump's run starts in the background: wait for its job, under a
3515
    // loaded test run as well as alone.
3516
    let mut bump_job = None;
3517
    for _ in 0..100 {
3518
        pass_all().await;
3519
        bump_job = seen.lock().unwrap().iter().find(|c| c["repo"] == "andy/game" && c["bookmark"] == "diffusion/deps/api").cloned();
3520
        if bump_job.is_some() {
3521
            break;
3522
        }
3523
        tokio::time::sleep(std::time::Duration::from_millis(100)).await;
3524
    }
3525
    let bump_job = bump_job.expect("the bump's job ran");
3526
    let subs: Vec<&str> = bump_job["subrepos"].as_array().unwrap().iter().filter_map(|s| s["path"].as_str()).collect();
3527
    assert_eq!(subs, vec!["deps/api"], "{bump_job}");
3528
3529
    // A consumer turning Diffusion on is bumped at once to the upstream's
3530
    // newest passing state, without waiting for it to move again.
3531
    create(&h.app, "andy", "game2").await;
3532
    let g2_work = tempfile::tempdir().unwrap();
3533
    let g2 = client(&format!("{}/andy/game2", h.base), g2_work.path());
3534
    g2.submodule_add(&format!("{}/andy/api", h.base), "deps/api", Some("main")).unwrap();
3535
    g2.snapshot("t").unwrap();
3536
    g2.commit("game2 on api", &[]).unwrap();
3537
    assert!(g2.push("origin", false).unwrap().iter().all(|r| r.ok));
3538
    // Its pin is api's newest state already: move api on, pass the run.
3539
    write(api_work.path(), "a5.c", "v5\n");
3540
    api.snapshot("t").unwrap();
3541
    api.commit("api v5", &[]).unwrap();
3542
    assert!(api.push("origin", false).unwrap().iter().all(|r| r.ok));
3543
    pass_all().await;
3544
    let g2_row = db::repos::get(&h.app.db, "andy", "game2").await.unwrap().unwrap();
3545
    for _ in 0..100 {
3546
        if sqlx::query_scalar::<_, i64>("SELECT COUNT(*) FROM diffusion_pins WHERE consumer_id = ?")
3547
            .bind(g2_row.id)
3548
            .fetch_one(&h.app.db)
3549
            .await
3550
            .unwrap()
3551
            > 0
3552
        {
3553
            break;
3554
        }
3555
        tokio::time::sleep(std::time::Duration::from_millis(30)).await;
3556
    }
3557
    assert!(db::proposals::list(&h.app.db, g2_row.id, &[]).await.unwrap().is_empty(), "off until turned on");
3558
    let (st, _) = call(&h.app, "PUT", "/api/v1/repos/andy/game2/diffusion", Some("site"), Some(r#"{"follow":"green"}"#.into())).await;
3559
    assert_eq!(st, StatusCode::OK);
3560
    let mut caught = None;
3561
    for _ in 0..100 {
3562
        if let Some(p) = db::proposals::list(&h.app.db, g2_row.id, &["open"]).await.unwrap().into_iter().next() {
3563
            caught = Some(p);
3564
            break;
3565
        }
3566
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
3567
    }
3568
    let caught = caught.expect("bumped as soon as it was turned on");
3569
    assert!(caught.body.contains("api v5") && caught.title.contains("1 change"), "{:?} {:?}", caught.title, caught.body);
3570
}
3571
3572
/// Whether any job is queued or running.
3573
async fn jobs_left(app: &Shared) -> bool {
3574
    sqlx::query_scalar::<_, i64>("SELECT COUNT(*) FROM flow_jobs WHERE status IN ('queued', 'running')")
3575
        .fetch_one(&app.db)
3576
        .await
3577
        .unwrap_or(0)
3578
        > 0
3579
}
3580
3581
/// An upstream with no checks never turns green: a consumer following green
3582
/// still gets its bumps, marked amber, `upstream unverified` (#148).
3583
#[tokio::test(flavor = "multi_thread")]
3584
async fn bumps_from_an_upstream_without_checks_are_marked_unverified() {
3585
    let h = hub().await;
3586
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
3587
    create(&h.app, "andy", "lib").await;
3588
    create(&h.app, "andy", "app").await;
3589
    let lib_work = tempfile::tempdir().unwrap();
3590
    let lib = client(&format!("{}/andy/lib", h.base), lib_work.path());
3591
    write(lib_work.path(), "lib.h", "v1\n");
3592
    lib.snapshot("t").unwrap();
3593
    lib.commit("lib v1", &[]).unwrap();
3594
    assert!(lib.push("origin", false).unwrap().iter().all(|r| r.ok));
3595
    let app_work = tempfile::tempdir().unwrap();
3596
    let app = client(&format!("{}/andy/app", h.base), app_work.path());
3597
    app.submodule_add(&format!("{}/andy/lib", h.base), "deps/lib", Some("main")).unwrap();
3598
    // It watches lib.c: upstream changes touching it are flagged.
3599
    let modules = std::fs::read_to_string(app_work.path().join(".oxymodules")).unwrap();
3600
    write(app_work.path(), ".oxymodules", &format!("{modules}watch = lib.c\n"));
3601
    app.snapshot("t").unwrap();
3602
    app.commit("app on lib", &[]).unwrap();
3603
    assert!(app.push("origin", false).unwrap().iter().all(|r| r.ok));
3604
    let app_row = db::repos::get(&h.app.db, "andy", "app").await.unwrap().unwrap();
3605
    for _ in 0..100 {
3606
        if sqlx::query_scalar::<_, i64>("SELECT COUNT(*) FROM diffusion_pins WHERE consumer_id = ?")
3607
            .bind(app_row.id)
3608
            .fetch_one(&h.app.db)
3609
            .await
3610
            .unwrap()
3611
            > 0
3612
        {
3613
            break;
3614
        }
3615
        tokio::time::sleep(std::time::Duration::from_millis(30)).await;
3616
    }
3617
    let (st, _) = call(&h.app, "PUT", "/api/v1/repos/andy/app/diffusion", Some("site"), Some(r#"{"follow":"green"}"#.into())).await;
3618
    assert_eq!(st, StatusCode::OK);
3619
    write(lib_work.path(), "lib.c", "v2\n");
3620
    lib.snapshot("t").unwrap();
3621
    lib.commit("lib v2", &[]).unwrap();
3622
    assert!(lib.push("origin", false).unwrap().iter().all(|r| r.ok));
3623
    let mut found = None;
3624
    for _ in 0..100 {
3625
        if let Some(p) = db::proposals::list(&h.app.db, app_row.id, &["open"]).await.unwrap().into_iter().next() {
3626
            found = Some(p);
3627
            break;
3628
        }
3629
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
3630
    }
3631
    let p = found.expect("a bump although the upstream never goes green");
3632
    assert!(p.body.contains("Upstream unverified"), "{}", p.body);
3633
    assert!(p.body.contains("Touches what you watch") && p.body.contains("touches `lib.c`") && p.body.contains("⚑"), "{}", p.body);
3634
    let mut labels = Vec::new();
3635
    for _ in 0..100 {
3636
        labels = db::issues::proposal_labels(&h.app.db, p.id).await.unwrap().into_iter().map(|l| l.name).collect::<Vec<String>>();
3637
        if labels.len() == 2 {
3638
            break;
3639
        }
3640
        tokio::time::sleep(std::time::Duration::from_millis(30)).await;
3641
    }
3642
    assert!(labels.contains(&"upstream unverified".to_string()) && labels.contains(&"dependencies".to_string()), "{labels:?}");
3643
}
3644
3645
/// #134: when a proposal's target moves, its projected state is new; the
3646
/// hub runs the pipeline on it, so its checks are never for an older one.
3647
#[tokio::test(flavor = "multi_thread")]
3648
async fn a_moved_target_runs_its_open_proposals_again() {
3649
    let h = hub().await;
3650
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
3651
    create(&h.app, "andy", "demo").await;
3652
    let work = tempfile::tempdir().unwrap();
3653
    let mut c = client(&format!("{}/andy/demo", h.base), work.path());
3654
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
3655
    write(work.path(), "test.sh", "echo ok\n");
3656
    c.snapshot("t").unwrap();
3657
    let base = c.commit("base", &[]).unwrap();
3658
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
3659
    // Two proposals, each main plus one change.
3660
    for (b, file) in [("fix-a", "a.txt"), ("fix-b", "b.txt")] {
3661
        c.bookmark_create(b, Some(&[base])).unwrap();
3662
        c.bookmark_switch(b, true).unwrap();
3663
        write(work.path(), file, "x\n");
3664
        c.snapshot("t").unwrap();
3665
        c.commit(&format!("add {file}"), &[]).unwrap();
3666
        assert!(c.push_bookmark("origin", b, false).unwrap().iter().all(|r| r.ok));
3667
        let body = serde_json::json!({ "title": b, "target": "main", "source": b }).to_string();
3668
        let (st, out) = call(&h.app, "POST", "/api/v1/repos/andy/demo/proposals", Some("site"), Some(body)).await;
3669
        assert_eq!(st, StatusCode::CREATED, "{out}");
3670
    }
3671
    let row = db::repos::get(&h.app.db, "andy", "demo").await.unwrap().unwrap();
3672
    let props = db::proposals::list(&h.app.db, row.id, &["open"]).await.unwrap();
3673
    let a = props.iter().find(|p| p.source_bookmark == "fix-a").unwrap().number;
3674
    let b = props.iter().find(|p| p.source_bookmark == "fix-b").unwrap().number;
3675
    // Landing fix-a moves main: fix-b's projected state gets a run.
3676
    let (st, out) = call(&h.app, "POST", &format!("/api/v1/repos/andy/demo/proposals/{a}/land"), Some("site"), Some("{}".into())).await;
3677
    assert_eq!(st, StatusCode::OK, "{out}");
3678
    let label = format!("proposal/{b}");
3679
    let mut found = None;
3680
    for _ in 0..100 {
3681
        if let Some(r) = runs_of(&h.app, "andy", "demo").await.into_iter().find(|r| r.bookmark == label) {
3682
            found = Some(r);
3683
            break;
3684
        }
3685
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
3686
    }
3687
    let run = found.expect("a run of fix-b's new projected state");
3688
    let projected = db::proposals::get(&h.app.db, row.id, b).await.unwrap().unwrap();
3689
    assert_eq!((run.trigger.as_str(), run.state.as_str()), ("proposal", projected.projected_state.as_str()), "on its projected state");
3690
    // Moving main again by a push does it once more; the same state is not run twice.
3691
    let before = runs_of(&h.app, "andy", "demo").await.len();
3692
    oxygenhub::web::proposals::settle_after_push(&h.app, &row, "main", "andy").await;
3693
    assert_eq!(runs_of(&h.app, "andy", "demo").await.len(), before, "not again for the same state");
3694
}
3695
3696
/// Send image bytes to the hub as their chunks and then a manifest that
3697
/// names no architecture; the manifest as the hub answers it.
3698
async fn send_image(app: &Shared, image: &[u8]) -> (String, serde_json::Value) {
3699
    let mut chunks = std::collections::HashMap::new();
3700
    let m = jet::images::scan(image, None, |c, b| {
3701
        chunks.insert(c.hash().to_string(), b.to_vec());
3702
        Ok(())
3703
    })
3704
    .unwrap();
3705
    for c in m.needed() {
3706
        let (st, body) = put_bytes(app, &format!("/api/v1/flow/images/chunks/{c}"), "site", chunks[c].clone()).await;
3707
        assert_eq!(st, StatusCode::NO_CONTENT, "{body}");
3708
    }
3709
    let (st, body) =
3710
        call(app, "PUT", &format!("/api/v1/flow/images/{}", m.hash), Some("site"), Some(serde_json::to_string(&m).unwrap())).await;
3711
    assert_eq!(st, StatusCode::CREATED, "{body}");
3712
    (m.hash.clone(), serde_json::from_str(&body).unwrap())
3713
}
3714
3715
/// oxygenhub#173 (OxygenFlow spec §11.2, Andy's "detect and learn"): an
3716
/// image sent with no architecture is read from its own files, so a
3717
/// riscv64 runner is never offered an x86_64 image's jobs; an image
3718
/// nobody can read takes the architecture its first pass ran on.
3719
#[tokio::test(flavor = "multi_thread")]
3720
async fn an_image_names_its_own_architecture_and_a_pass_teaches_the_rest() {
3721
    use oxy_core::identity::SecretKey;
3722
    let h = hub().await;
3723
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
3724
    // An ext4 image whose shell is x86_64, as `flow rootfs import` makes one.
3725
    let dir = tempfile::tempdir().unwrap();
3726
    let tree = dir.path().join("tree");
3727
    std::fs::create_dir_all(tree.join("bin")).unwrap();
3728
    let mut elf = vec![0u8; 64];
3729
    elf[..7].copy_from_slice(b"\x7fELF\x02\x01\x01");
3730
    elf[18..20].copy_from_slice(&0x3Eu16.to_le_bytes());
3731
    std::fs::write(tree.join("bin/sh"), &elf).unwrap();
3732
    let img = dir.path().join("rootfs.ext4");
3733
    let made = std::process::Command::new("mkfs.ext4").args(["-q", "-F", "-d"]).arg(&tree).arg(&img).arg("8M").status();
3734
    if !made.is_ok_and(|s| s.success()) {
3735
        eprintln!("mkfs.ext4 not found: skipped");
3736
        return;
3737
    }
3738
    let (x86, answer) = send_image(&h.app, &std::fs::read(&img).unwrap()).await;
3739
    assert_eq!(answer["arch"], "x86_64", "read from its shell: {answer}");
3740
    let (_, body) = call(&h.app, "GET", &format!("/api/v1/flow/images/{x86}"), Some("runner-secret"), None).await;
3741
    assert_eq!(serde_json::from_str::<jet::images::Manifest>(&body).unwrap().arch.as_deref(), Some("x86_64"), "runners fetch it named");
3742
    // One nobody can read: no ext4, no shell.
3743
    let blob: Vec<u8> = (0..300_000u32).map(|i| (i % 241) as u8).collect();
3744
    let (unread, answer) = send_image(&h.app, &blob).await;
3745
    assert!(answer["arch"].is_null(), "{answer}");
3746
    let archs = db::flow::image_archs(&h.app.db).await.unwrap();
3747
    assert_eq!((archs.get(&x86).map(String::as_str), archs.get(&unread)), (Some("x86_64"), None));
3748
    // Kept images with none are read once at start.
3749
    sqlx::query("UPDATE jet_images SET arch = ''").execute(&h.app.db).await.unwrap();
3750
    sqlx::query("DELETE FROM flow_images").execute(&h.app.db).await.unwrap();
3751
    assert_eq!(oxygenhub::images::learn_archs(&h.app).await.unwrap(), 1);
3752
    assert_eq!(db::flow::image_archs(&h.app.db).await.unwrap().get(&x86).map(String::as_str), Some("x86_64"));
3753
3754
    // A job on each image.
3755
    create(&h.app, "andy", "arch").await;
3756
    let work = tempfile::tempdir().unwrap();
3757
    let c = client(&format!("{}/andy/arch", h.base), work.path());
3758
    let kdl = format!(
3759
        "schema-version 1\nsandbox \"unread\" {{\n    rootfs \"cas://blob/{unread}\"\n}}\nsandbox \"x86\" {{\n    rootfs \"cas://blob/{x86}\"\n}}\n\
3760
         job \"first\" {{\n    sandbox \"unread\"\n    exec \"make\"\n}}\njob \"second\" {{\n    sandbox \"x86\"\n    exec \"make\"\n    depends-on \"first\"\n}}\n\
3761
         job \"third\" {{\n    sandbox \"unread\"\n    exec \"make\"\n    depends-on \"first\"\n}}\n"
3762
    );
3763
    write(work.path(), ".flow/pipeline.kdl", &kdl);
3764
    c.commit("Jobs on two images", &[]).unwrap();
3765
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
3766
    runs_of(&h.app, "andy", "arch").await;
3767
3768
    // The x86_64 runner passes the first job: its image is x86_64 now.
3769
    let x86_info = serde_json::json!({ "arch": "x86_64", "os": "linux", "version": "0.1.0", "labels": [], "max_jobs": 1 });
3770
    let x86_claim =
3771
        serde_json::json!({ "runner": "earth", "runtimes": ["microvm"], "images": [], "fetches_images": true, "info": x86_info });
3772
    let (st, body) = call(&h.app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(x86_claim.to_string())).await;
3773
    assert_eq!(st, StatusCode::OK, "{body}");
3774
    let first: serde_json::Value = serde_json::from_str(&body).unwrap();
3775
    assert_eq!(first["job"]["name"], "first");
3776
    let ph = first["pipeline_hash"].as_str().unwrap();
3777
    let id = first["job_id"].as_i64().unwrap();
3778
    assert_eq!(
3779
        finish(&h.app, id, serde_json::json!({ "exit_code": 0, "duration_ms": 700, "receipt": receipt("first", ph, 0) })).await,
3780
        StatusCode::NO_CONTENT
3781
    );
3782
    assert_eq!(db::flow::image_archs(&h.app.db).await.unwrap().get(&unread).map(String::as_str), Some("x86_64"), "learned");
3783
3784
    // A riscv64 runner is offered neither: one read, one learned.
3785
    let token = "flowreg_narvi";
3786
    db::runners::add_registration(&h.app.db, &blake3::hash(token.as_bytes()).to_hex(), "admin", &Default::default()).await.unwrap();
3787
    let identity = SecretKey::generate().identity("narvi", "", 1);
3788
    let info = serde_json::json!({ "arch": "riscv64", "os": "linux", "version": "0.1.0", "labels": [], "max_jobs": 1 });
3789
    let reg = serde_json::json!({ "token": token, "name": "narvi", "identity": hex::encode(identity.encode()), "info": info });
3790
    let (st, body) = call(&h.app, "POST", "/api/v1/flow/runners/register", None, Some(reg.to_string())).await;
3791
    assert_eq!(st, StatusCode::OK, "{body}");
3792
    let credential = serde_json::from_str::<serde_json::Value>(&body).unwrap()["credential"].as_str().unwrap().to_string();
3793
    let narvi =
3794
        serde_json::json!({ "runner": "narvi", "runtimes": ["microvm"], "images": [], "fetches_images": true, "info": info }).to_string();
3795
    let (st, body) = call(&h.app, "POST", "/api/v1/flow/claim", Some(&credential), Some(narvi)).await;
3796
    assert_eq!(st, StatusCode::NO_CONTENT, "the second job's image is x86_64 and the third's learned so: {body}");
3797
    for _ in 0..2 {
3798
        let (st, body) = call(&h.app, "POST", "/api/v1/flow/claim", Some("runner-secret"), Some(x86_claim.to_string())).await;
3799
        assert_eq!(st, StatusCode::OK, "both go to x86_64: {body}");
3800
    }
3801
}
3802
3803
/// Diffusion auto-land (docs/diffusion.md §4.2; Andy chose "opt-in, per
3804
/// repository", 2026-10-13): a consumer that chose `land = auto` has a bump
3805
/// landed by itself, as the diffusion account, once both halves are green;
3806
/// a bump from an upstream with no checks (amber) always waits.
3807
#[tokio::test(flavor = "multi_thread")]
3808
async fn a_consumer_that_chose_auto_lands_green_bumps_itself() {
3809
    let h = hub().await;
3810
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
3811
    create(&h.app, "andy", "api").await;
3812
    create(&h.app, "andy", "game").await;
3813
    let hub_app = &h.app;
3814
    // Run every queued job to a pass.
3815
    let pass_all = move || async move {
3816
        for _ in 0..20 {
3817
            let Some(a) = claim(hub_app).await else {
3818
                tokio::time::sleep(std::time::Duration::from_millis(30)).await;
3819
                if !jobs_left(hub_app).await {
3820
                    break;
3821
                }
3822
                continue;
3823
            };
3824
            let id = a["job_id"].as_i64().unwrap();
3825
            let (name, ph) = (a["job"]["name"].as_str().unwrap().to_string(), a["pipeline_hash"].as_str().unwrap().to_string());
3826
            assert_eq!(
3827
                finish(hub_app, id, serde_json::json!({ "exit_code": 0, "duration_ms": 10, "receipt": receipt(&name, &ph, 0) })).await,
3828
                StatusCode::NO_CONTENT
3829
            );
3830
        }
3831
    };
3832
    let api_work = tempfile::tempdir().unwrap();
3833
    let api = client(&format!("{}/andy/api", h.base), api_work.path());
3834
    write(api_work.path(), ".flow/pipeline.kdl", &pipeline(""));
3835
    write(api_work.path(), "test.sh", "echo ok\n");
3836
    api.snapshot("t").unwrap();
3837
    api.commit("api v1", &[]).unwrap();
3838
    assert!(api.push("origin", false).unwrap().iter().all(|r| r.ok));
3839
    pass_all().await;
3840
    let game_work = tempfile::tempdir().unwrap();
3841
    let game = client(&format!("{}/andy/game", h.base), game_work.path());
3842
    game.submodule_add(&format!("{}/andy/api", h.base), "deps/api", Some("main")).unwrap();
3843
    write(game_work.path(), ".flow/pipeline.kdl", &pipeline(""));
3844
    write(game_work.path(), "test.sh", "echo ok\n");
3845
    game.snapshot("t").unwrap();
3846
    game.commit("game on api v1", &[]).unwrap();
3847
    assert!(game.push("origin", false).unwrap().iter().all(|r| r.ok));
3848
    pass_all().await;
3849
    let game_row = db::repos::get(&h.app.db, "andy", "game").await.unwrap().unwrap();
3850
    for _ in 0..100 {
3851
        let n: i64 = sqlx::query_scalar("SELECT COUNT(*) FROM diffusion_pins WHERE consumer_id = ?")
3852
            .bind(game_row.id)
3853
            .fetch_one(&h.app.db)
3854
            .await
3855
            .unwrap();
3856
        if n > 0 {
3857
            break;
3858
        }
3859
        tokio::time::sleep(std::time::Duration::from_millis(30)).await;
3860
    }
3861
    let (st, body) =
3862
        call(&h.app, "PUT", "/api/v1/repos/andy/game/diffusion", Some("site"), Some(r#"{"follow":"green","land":"auto"}"#.into())).await;
3863
    assert_eq!(st, StatusCode::OK, "{body}");
3864
    assert!(body.contains(r#""land":"auto""#), "{body}");
3865
    let (st, _) =
3866
        call(&h.app, "PUT", "/api/v1/repos/andy/game/diffusion", Some("site"), Some(r#"{"follow":"green","land":"soon"}"#.into())).await;
3867
    assert_eq!(st, StatusCode::BAD_REQUEST);
3868
3869
    // The upstream moves and passes: the bump is proposed, its run passes,
3870
    // and it lands by itself.
3871
    write(api_work.path(), "a2.c", "v2\n");
3872
    api.snapshot("t").unwrap();
3873
    api.commit("api v2: faster sprites", &[]).unwrap();
3874
    assert!(api.push("origin", false).unwrap().iter().all(|r| r.ok));
3875
    let mut landed = None;
3876
    for _ in 0..100 {
3877
        pass_all().await;
3878
        let all = db::proposals::list(&h.app.db, game_row.id, &[]).await.unwrap();
3879
        if let Some(p) = all.into_iter().find(|p| p.source_bookmark == "diffusion/deps/api" && p.state == "landed") {
3880
            landed = Some(p);
3881
            break;
3882
        }
3883
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
3884
    }
3885
    let p = landed.expect("landed by itself once both halves were green");
3886
    assert!(p.body.contains("lands its bumps itself"), "{}", p.body);
3887
    let events = db::proposals::events(&h.app.db, p.id).await.unwrap();
3888
    let landing = events.iter().find(|e| e.event == "landed").expect("a landing on the timeline");
3889
    assert_eq!(landing.actor, "diffusion");
3890
    assert!(landing.detail.contains("Diffusion, both halves green"), "{}", landing.detail);
3891
    // The game's main now pins api v2.
3892
    let mut behind = serde_json::Value::Null;
3893
    for _ in 0..100 {
3894
        let (_, list) = call(&h.app, "GET", "/api/v1/repos/andy/api/consumers", Some("site"), None).await;
3895
        let list: Vec<serde_json::Value> = serde_json::from_str(&list).unwrap();
3896
        behind = list.iter().find(|c| c["name"] == "game").map(|c| c["behind"].clone()).unwrap_or_default();
3897
        if behind == 0 {
3898
            break;
3899
        }
3900
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
3901
    }
3902
    assert_eq!(behind, 0, "main moved to the bump");
3903
3904
    // An upstream with no checks: its bump passes in the consumer, but
3905
    // amber never lands by itself, whatever the setting.
3906
    create(&h.app, "andy", "lib").await;
3907
    create(&h.app, "andy", "app").await;
3908
    let lib_work = tempfile::tempdir().unwrap();
3909
    let lib = client(&format!("{}/andy/lib", h.base), lib_work.path());
3910
    write(lib_work.path(), "lib.h", "v1\n");
3911
    lib.snapshot("t").unwrap();
3912
    lib.commit("lib v1", &[]).unwrap();
3913
    assert!(lib.push("origin", false).unwrap().iter().all(|r| r.ok));
3914
    let app_work = tempfile::tempdir().unwrap();
3915
    let app = client(&format!("{}/andy/app", h.base), app_work.path());
3916
    app.submodule_add(&format!("{}/andy/lib", h.base), "deps/lib", Some("main")).unwrap();
3917
    let modules = std::fs::read_to_string(app_work.path().join(".oxymodules")).unwrap();
3918
    write(app_work.path(), ".oxymodules", &format!("{modules}follow = green\nland = auto\n"));
3919
    write(app_work.path(), ".flow/pipeline.kdl", &pipeline(""));
3920
    write(app_work.path(), "test.sh", "echo ok\n");
3921
    app.snapshot("t").unwrap();
3922
    app.commit("app on lib", &[]).unwrap();
3923
    assert!(app.push("origin", false).unwrap().iter().all(|r| r.ok));
3924
    pass_all().await;
3925
    let app_row = db::repos::get(&h.app.db, "andy", "app").await.unwrap().unwrap();
3926
    for _ in 0..100 {
3927
        let n: i64 = sqlx::query_scalar("SELECT COUNT(*) FROM diffusion_pins WHERE consumer_id = ?")
3928
            .bind(app_row.id)
3929
            .fetch_one(&h.app.db)
3930
            .await
3931
            .unwrap();
3932
        if n > 0 {
3933
            break;
3934
        }
3935
        tokio::time::sleep(std::time::Duration::from_millis(30)).await;
3936
    }
3937
    write(lib_work.path(), "lib.c", "v2\n");
3938
    lib.snapshot("t").unwrap();
3939
    lib.commit("lib v2", &[]).unwrap();
3940
    assert!(lib.push("origin", false).unwrap().iter().all(|r| r.ok));
3941
    let mut passed = false;
3942
    for _ in 0..100 {
3943
        pass_all().await;
3944
        let s: Option<String> = sqlx::query_scalar(
3945
            "SELECT status FROM flow_runs WHERE repo_id = ? AND bookmark = 'diffusion/deps/lib' ORDER BY id DESC LIMIT 1",
3946
        )
3947
        .bind(app_row.id)
3948
        .fetch_optional(&h.app.db)
3949
        .await
3950
        .unwrap();
3951
        if s.as_deref() == Some("passed") {
3952
            passed = true;
3953
            break;
3954
        }
3955
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
3956
    }
3957
    assert!(passed, "the app's run on the bump passed");
3958
    assert_eq!(oxygenhub::diffusion::auto_land(&h.app, &app_row, "deps/lib").await, Err(oxygenhub::diffusion::Held::Unverified));
3959
    let open = db::proposals::list(&h.app.db, app_row.id, &["open"]).await.unwrap();
3960
    assert!(open.iter().any(|p| p.source_bookmark == "diffusion/deps/lib"), "amber waits for a person");
3961
}
3962
3963
/// oxygenflow#31: one finished job runs again in the same run, with the
3964
/// jobs that depend on it; what it depends on keeps its result, so a flaky
3965
/// test reruns without its build. Not while the run is live, and only a
3966
/// job the run has.
3967
#[tokio::test(flavor = "multi_thread")]
3968
async fn one_job_reruns_with_what_depends_on_it() {
3969
    let h = hub().await;
3970
    db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
3971
    create(&h.app, "andy", "flaky").await;
3972
    let work = tempfile::tempdir().unwrap();
3973
    let c = client(&format!("{}/andy/flaky", h.base), work.path());
3974
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
3975
    write(work.path(), "test.sh", "echo ok\n");
3976
    c.commit("Add a pipeline", &[]).unwrap();
3977
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
3978
    let run = runs_of(&h.app, "andy", "flaky").await[0].clone();
3979
    // build and lint pass; test fails, as a flaky one does.
3980
    let (st, _) =
3981
        call(&h.app, "POST", &format!("/api/v1/repos/andy/flaky/flow/runs/{}/jobs/test/rerun", run.number), Some("site"), None).await;
3982
    assert_eq!(st, StatusCode::CONFLICT, "not while the run is live");
3983
    while let Some(j) = claim(&h.app).await {
3984
        let id = j["job_id"].as_i64().unwrap();
3985
        let (name, ph) = (j["job"]["name"].as_str().unwrap().to_string(), j["pipeline_hash"].as_str().unwrap().to_string());
3986
        let exit = if name == "test" { 1 } else { 0 };
3987
        let log = serde_json::json!({ "records": [{ "t": 1, "stream": "out", "text": format!("{name} ran") }] });
3988
        call(&h.app, "POST", &format!("/api/v1/flow/jobs/{id}/log"), Some("runner-secret"), Some(log.to_string())).await;
3989
        assert_eq!(
3990
            finish(&h.app, id, serde_json::json!({ "exit_code": exit, "duration_ms": 10, "receipt": receipt(&name, &ph, exit as u32) }))
3991
                .await,
3992
            StatusCode::NO_CONTENT
3993
        );
3994
    }
3995
    let status = |n: &'static str| {
3996
        let (app, run_id) = (h.app.clone(), run.id);
3997
        async move { db::flow::jobs(&app.db, run_id).await.unwrap().into_iter().find(|j| j.name == n).unwrap() }
3998
    };
3999
    assert_eq!(db::flow::run_by_id(&h.app.db, run.id).await.unwrap().unwrap().status, "failed");
4000
    let failed_test = status("test").await;
4001
4002
    // The test again: build and lint keep their results.
4003
    let (st, body) =
4004
        call(&h.app, "POST", &format!("/api/v1/repos/andy/flaky/flow/runs/{}/jobs/test/rerun", run.number), Some("site"), None).await;
4005
    assert_eq!(st, StatusCode::OK, "{body}");
4006
    assert!(body.contains(r#""queued":1"#), "{body}");
4007
    assert_eq!(
4008
        (status("build").await.status, status("lint").await.status, status("test").await.status),
4009
        ("passed".into(), "passed".into(), "queued".into())
4010
    );
4011
    assert!(db::flow::log(&h.app.db, failed_test.id, 0, 100).await.unwrap().is_empty(), "its old log is gone");
4012
    assert!(db::flow::run_by_id(&h.app.db, run.id).await.unwrap().unwrap().live());
4013
    let checks = checks_when(&h.app, run.repo_id, &run.state, 3).await;
4014
    assert_eq!(checks.iter().find(|c| c.name == "flow/test").map(|c| c.status.as_str()), Some("queued"));
4015
    let j = claim(&h.app).await.expect("the test, queued again");
4016
    assert_eq!(j["job"]["name"], "test");
4017
    let ph = j["pipeline_hash"].as_str().unwrap().to_string();
4018
    let id = j["job_id"].as_i64().unwrap();
4019
    assert_eq!(
4020
        finish(&h.app, id, serde_json::json!({ "exit_code": 0, "duration_ms": 10, "receipt": receipt("test", &ph, 0) })).await,
4021
        StatusCode::NO_CONTENT
4022
    );
4023
    assert_eq!(db::flow::run_by_id(&h.app.db, run.id).await.unwrap().unwrap().status, "passed", "the run is whole again");
4024
4025
    // The build again brings the test that depends on it; lint stays.
4026
    let (_, body) =
4027
        call(&h.app, "POST", &format!("/api/v1/repos/andy/flaky/flow/runs/{}/jobs/build/rerun", run.number), Some("site"), None).await;
4028
    assert!(body.contains(r#""queued":2"#), "{body}");
4029
    assert_eq!(
4030
        (status("build").await.status, status("lint").await.status, status("test").await.status),
4031
        ("queued".into(), "passed".into(), "queued".into())
4032
    );
4033
    let (st, _) =
4034
        call(&h.app, "POST", &format!("/api/v1/repos/andy/flaky/flow/runs/{}/jobs/deploy/rerun", run.number), Some("site"), None).await;
4035
    assert_eq!(st, StatusCode::CONFLICT, "live again, and no such job either way");
4036
}
4037
4038
/// oxygenflow#30: a failed run tells its pusher and the repository's
4039
/// watchers; a runner whose last five jobs ended in infrastructure errors
4040
/// is drained and the administrators told, counting only since an
4041
/// administrator last made it active.
4042
#[tokio::test(flavor = "multi_thread")]
4043
async fn failed_runs_are_told_and_an_erroring_runner_is_drained() {
4044
    let h = hub().await;
4045
    let andy = db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
4046
    let bob = db::accounts::create_account(&h.app.db, "bob", "[email protected]", "x", "salt", false).await.unwrap();
4047
    create(&h.app, "andy", "alerts").await;
4048
    let row = db::repos::get(&h.app.db, "andy", "alerts").await.unwrap().unwrap();
4049
    db::notify::set_watch(&h.app.db, bob.id, row.id, true).await.unwrap();
4050
    let work = tempfile::tempdir().unwrap();
4051
    let c = client(&format!("{}/andy/alerts", h.base), work.path());
4052
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
4053
    write(work.path(), "test.sh", "exit 1\n");
4054
    c.commit("Add a pipeline", &[]).unwrap();
4055
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
4056
    let run = runs_of(&h.app, "andy", "alerts").await[0].clone();
4057
    sqlx::query("UPDATE flow_runs SET actor = 'andy' WHERE id = ?").bind(run.id).execute(&h.app.db).await.unwrap();
4058
    while let Some(j) = claim(&h.app).await {
4059
        let id = j["job_id"].as_i64().unwrap();
4060
        let (name, ph) = (j["job"]["name"].as_str().unwrap().to_string(), j["pipeline_hash"].as_str().unwrap().to_string());
4061
        let exit = if name == "test" { 1 } else { 0 };
4062
        finish(&h.app, id, serde_json::json!({ "exit_code": exit, "duration_ms": 10, "receipt": receipt(&name, &ph, exit as u32) })).await;
4063
    }
4064
    let told = |id: i64| {
4065
        let db = h.app.db.clone();
4066
        async move { db::notify::inbox(&db, id, 20).await.unwrap().into_iter().filter(|n| n.kind == "flow.failed").collect::<Vec<_>>() }
4067
    };
4068
    let (for_andy, for_bob) = (told(andy.id).await, told(bob.id).await);
4069
    assert_eq!((for_andy.len(), for_bob.len()), (1, 1), "the pusher and a watcher");
4070
    assert!(for_andy[0].title.contains(&format!("run #{} on main failed (test)", run.number)), "{}", for_andy[0].title);
4071
    assert_eq!(for_andy[0].url, format!("/andy/alerts/flow/{}", run.number));
4072
4073
    // Five infrastructure errors in a row drain the runner.
4074
    let runner_id = || {
4075
        let db = h.app.db.clone();
4076
        async move { sqlx::query_scalar::<_, i64>("SELECT id FROM flow_runners WHERE name = 'test-1'").fetch_one(&db).await.unwrap() }
4077
    };
4078
    let mut errors = 0;
4079
    while errors < 5 {
4080
        let (st, _) = call(&h.app, "POST", "/api/v1/repos/andy/alerts/flow/runs", Some("site"), Some("{}".into())).await;
4081
        assert_eq!(st, StatusCode::CREATED);
4082
        while let Some(j) = claim(&h.app).await {
4083
            let id = j["job_id"].as_i64().unwrap();
4084
            let st = finish(
4085
                &h.app,
4086
                id,
4087
                serde_json::json!({ "exit_code": null, "duration_ms": 10, "error": "the microVM did not start: /dev/kvm busy" }),
4088
            )
4089
            .await;
4090
            assert_eq!(st, StatusCode::NO_CONTENT);
4091
            errors += 1;
4092
            if errors == 5 {
4093
                break;
4094
            }
4095
        }
4096
    }
4097
    let state = |id: i64| {
4098
        let db = h.app.db.clone();
4099
        async move { db::runners::get(&db, id).await.unwrap().unwrap().state }
4100
    };
4101
    let id = runner_id().await;
4102
    assert_eq!(state(id).await, "draining");
4103
    let drained: Vec<_> =
4104
        db::notify::inbox(&h.app.db, andy.id, 50).await.unwrap().into_iter().filter(|n| n.kind == "flow.runner_drained").collect();
4105
    assert_eq!(drained.len(), 1, "the administrator is told");
4106
    assert!(drained[0].title.contains("/dev/kvm busy"), "{}", drained[0].title);
4107
    assert!(
4108
        !told(bob.id).await.is_empty()
4109
            && db::notify::inbox(&h.app.db, bob.id, 50).await.unwrap().iter().all(|n| n.kind != "flow.runner_drained")
4110
    );
4111
    // Made active again, past errors no longer count.
4112
    db::runners::set_state(&h.app.db, id, "active").await.unwrap();
4113
    assert_eq!(db::runners::erroring(&h.app.db, id, 5).await.unwrap(), None);
4114
}
4115
4116
/// #225: an ordinary user turns Flow on for their repository on their own
4117
/// runner, and the site's runners never take its jobs.
4118
#[tokio::test(flavor = "multi_thread")]
4119
async fn owners_run_flow_on_their_own_runners_only() {
4120
    use oxy_core::identity::SecretKey;
4121
    let h = hub().await;
4122
    let register = |name: &'static str| {
4123
        let app = h.app.clone();
4124
        async move {
4125
            let body = format!("username={name}&email={name}%40example.com&password=correct-horse-battery");
4126
            let res = oxygenhub::router(app)
4127
                .oneshot(
4128
                    Request::post("/register")
4129
                        .header(header::CONTENT_TYPE, "application/x-www-form-urlencoded")
4130
                        .body(Body::from(body))
4131
                        .unwrap(),
4132
                )
4133
                .await
4134
                .unwrap();
4135
            res.headers().get(header::SET_COOKIE).unwrap().to_str().unwrap().split(';').next().unwrap().to_string()
4136
        }
4137
    };
4138
    register("andy").await; // the first account: the site's administrator
4139
    let bob = register("bob").await;
4140
    create(&h.app, "bob", "game").await;
4141
    let web = |method: &'static str, path: &str, body: Option<String>| {
4142
        let (app, cookie, path) = (h.app.clone(), bob.clone(), path.to_string());
4143
        async move {
4144
            let mut req = Request::builder().method(method).uri(path).header(header::COOKIE, cookie);
4145
            if body.is_some() {
4146
                req = req.header(header::CONTENT_TYPE, "application/x-www-form-urlencoded");
4147
            }
4148
            let res = oxygenhub::router(app).oneshot(req.body(body.map(Body::from).unwrap_or_else(Body::empty)).unwrap()).await.unwrap();
4149
            String::from_utf8_lossy(&res.into_body().collect().await.unwrap().to_bytes()).into_owned()
4150
        }
4151
    };
4152
    let csrf_of = |page: &str| {
4153
        let i = page.find("name=\"_csrf\" value=\"").unwrap() + "name=\"_csrf\" value=\"".len();
4154
        page[i..].split('"').next().unwrap().to_string()
4155
    };
4156
    // No runner of his own yet: he is told how, and cannot switch it on.
4157
    let page = web("GET", "/bob/game/settings", None).await;
4158
    assert!(page.contains("register a runner for this repository") && !page.contains("value=\"own\""), "{page}");
4159
    let page = web("POST", "/bob/game/settings/flow", Some(format!("_csrf={}&flow=own", csrf_of(&page)))).await;
4160
    assert!(page.contains("Register a runner for this repository"), "{page}");
4161
    // He registers one.
4162
    let page = web("GET", "/bob/game/settings", None).await;
4163
    let page = web("POST", "/bob/game/settings/runners/token", Some(format!("_csrf={}", csrf_of(&page)))).await;
4164
    let i = page.find("--token ").unwrap() + "--token ".len();
4165
    let token: String = page[i..].chars().take_while(|c| !c.is_whitespace()).collect();
4166
    let info = serde_json::json!({ "arch": "x86_64", "os": "linux", "version": "0.1.0", "labels": [], "max_jobs": 1 });
4167
    let identity = SecretKey::generate().identity("bobs", "", 1);
4168
    let reg = serde_json::json!({ "token": token, "name": "bobs", "identity": hex::encode(identity.encode()), "info": info });
4169
    let (st, body) = call(&h.app, "POST", "/api/v1/flow/runners/register", None, Some(reg.to_string())).await;
4170
    assert_eq!(st, StatusCode::OK, "{body}");
4171
    let credential = serde_json::from_str::<serde_json::Value>(&body).unwrap()["credential"].as_str().unwrap().to_string();
4172
    // The site's runners stay a site administrator's to grant; his own he may choose.
4173
    let page = web("GET", "/bob/game/settings", None).await;
4174
    assert!(page.contains("value=\"own\"") && !page.contains("value=\"on\""), "{page}");
4175
    let page = web("POST", "/bob/game/settings/flow", Some(format!("_csrf={}&flow=on", csrf_of(&page)))).await;
4176
    assert!(page.contains("Only site administrators let the site's runners"), "{page}");
4177
    let page = web("POST", "/bob/game/settings/flow", Some(format!("_csrf={}&flow=own", csrf_of(&page)))).await;
4178
    assert!(page.contains("value=\"own\" checked") && page.contains("start runs"), "{page}");
4179
    assert_eq!(db::repos::get(&h.app.db, "bob", "game").await.unwrap().unwrap().flow, "own");
4180
    // A push starts a run; the site's runner is not offered it, his is.
4181
    let work = tempfile::tempdir().unwrap();
4182
    let c = client(&format!("{}/bob/game", h.base), work.path());
4183
    write(work.path(), ".flow/pipeline.kdl", &pipeline(""));
4184
    write(work.path(), "test.sh", "echo ok\n");
4185
    c.snapshot("t").unwrap();
4186
    c.commit("A pipeline", &[]).unwrap();
4187
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
4188
    assert_eq!(runs_of(&h.app, "bob", "game").await.len(), 1, "a run started");
4189
    assert!(claim(&h.app).await.is_none(), "the site's runner is not offered it");
4190
    let body = serde_json::json!({ "runner": "ignored", "runtimes": ["microvm"], "info": info }).to_string();
4191
    let (st, job) = call(&h.app, "POST", "/api/v1/flow/claim", Some(&credential), Some(body)).await;
4192
    assert_eq!(st, StatusCode::OK, "{job}");
4193
    assert_eq!(serde_json::from_str::<serde_json::Value>(&job).unwrap()["repo"], "bob/game");
4194
}
4195
4196
#[tokio::test(flavor = "multi_thread")]
4197
async fn a_job_takes_the_artifact_its_producer_kept() {
4198
    let h = hub().await;
4199
    create(&h.app, "andy", "demo").await;
4200
    let url = format!("{}/andy/demo", h.base);
4201
    let work = tempfile::tempdir().unwrap();
4202
    let c = client(&url, work.path());
4203
    write(
4204
        work.path(),
4205
        ".flow/pipeline.kdl",
4206
        &format!(
4207
            "schema-version 1\nsandbox \"alpine\" {{\n    rootfs \"cas://blob/{ROOTFS}\"\n}}\njob \"plan\" {{\n    sandbox \"alpine\"\n    exec \"plan\"\n    output {{\n        artifact \"tfplan\" {{\n            path \"/src/out/tfplan\"\n        }}\n    }}\n}}\njob \"apply\" {{\n    sandbox \"alpine\"\n    depends-on \"plan\"\n    input {{\n        artifact \"tfplan\" from \"plan\"\n        path \"/src/tfplan\"\n    }}\n    exec \"apply\"\n}}\n"
4208
        ),
4209
    );
4210
    c.snapshot("test").unwrap();
4211
    c.commit("Plan, then apply that plan", &[]).unwrap();
4212
    assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
4213
4214
    // The plan job runs and keeps its plan, named by its receipt.
4215
    let runs = runs_of(&h.app, "andy", "demo").await;
4216
    assert_eq!(runs.len(), 1, "a run");
4217
    let jobs = db::flow::jobs(&h.app.db, runs[0].id).await.unwrap();
4218
    assert!(!jobs.is_empty(), "jobs: {:?}", runs[0]);
4219
    let p = claim(&h.app)
4220
        .await
4221
        .unwrap_or_else(|| panic!("nothing to claim: {:?}", jobs.iter().map(|j| (&j.name, &j.status, &j.error)).collect::<Vec<_>>()));
4222
    assert_eq!(p["job"]["name"], "plan");
4223
    let plan_id = p["job_id"].as_i64().unwrap();
4224
    let plan = b"the reviewed plan".to_vec();
4225
    let (st, text) = upload(&h.app, plan_id, "tfplan", &plan).await;
4226
    assert_eq!(st, StatusCode::OK, "{text}");
4227
    let blob = oxy_core::repo::Repo::blob_ref(&plan).to_hex();
4228
    let mut r = receipt("plan", p["pipeline_hash"].as_str().unwrap(), 0);
4229
    r["outputs"] = serde_json::json!([blob]);
4230
    assert_eq!(
4231
        finish(&h.app, plan_id, serde_json::json!({ "exit_code": 0, "duration_ms": 700, "receipt": r })).await,
4232
        StatusCode::NO_CONTENT
4233
    );
4234
4235
    // The apply job is told what to take and the blob to expect, and the
4236
    // runner fetches exactly those bytes.
4237
    let a = claim(&h.app).await.unwrap();
4238
    assert_eq!(a["job"]["name"], "apply");
4239
    let apply_id = a["job_id"].as_i64().unwrap();
4240
    assert_eq!(
4241
        a["inputs"],
4242
        serde_json::json!([{ "artifact": "tfplan", "from": "plan", "path": "/src/tfplan", "blob": blob }]),
4243
        "the claim names the producer's blob"
4244
    );
4245
    let req = Request::get(format!("/api/v1/flow/jobs/{apply_id}/inputs/0")).header(header::AUTHORIZATION, "Bearer runner-secret");
4246
    let res = oxygenhub::router(h.app.clone()).oneshot(req.body(Body::empty()).unwrap()).await.unwrap();
4247
    assert_eq!(res.status(), StatusCode::OK);
4248
    assert_eq!(res.into_body().collect().await.unwrap().to_bytes().to_vec(), plan);
4249
    let (st, _) = call(&h.app, "GET", &format!("/api/v1/flow/jobs/{apply_id}/inputs/1"), Some("runner-secret"), None).await;
4250
    assert_eq!(st, StatusCode::NOT_FOUND, "no second input");
4251
    let (st, _) = call(&h.app, "GET", &format!("/api/v1/flow/jobs/{apply_id}/inputs/0"), None, None).await;
4252
    assert_eq!(st, StatusCode::UNAUTHORIZED, "runners only");
4253
    let (st, _) = call(&h.app, "GET", &format!("/api/v1/flow/jobs/{plan_id}/inputs/0"), Some("runner-secret"), None).await;
4254
    assert_eq!(st, StatusCode::CONFLICT, "only a running job's");
4255
}
4256
4257
#[tokio::test(flavor = "multi_thread")]
4258
async fn a_job_waits_for_approval_and_is_approved_rejected_or_expires() {
4259
    let h = hub().await;
4260
    let andy = db::accounts::create_account(&h.app.db, "andy", "[email protected]", "x", "salt", true).await.unwrap();
4261
    let bob = db::accounts::create_account(&h.app.db, "bob", "[email protected]", "x", "salt", false).await.unwrap();
4262
    let carol = db::accounts::create_account(&h.app.db, "carol", "[email protected]", "x", "salt", true).await.unwrap();
4263
    create(&h.app, "andy", "gated").await;
4264
    let row = db::repos::get(&h.app.db, "andy", "gated").await.unwrap().unwrap();
4265
    let work = tempfile::tempdir().unwrap();
4266
    let c = client(&format!("{}/andy/gated", h.base), work.path());
4267
    write(
4268
        work.path(),
4269
        ".flow/pipeline.kdl",
4270
        &format!(
4271
            "schema-version 1\nsandbox \"alpine\" {{\n    rootfs \"cas://blob/{ROOTFS}\"\n}}\njob \"plan\" {{\n    sandbox \"alpine\"\n    exec \"plan\"\n}}\njob \"apply\" {{\n    sandbox \"alpine\"\n    depends-on \"plan\"\n    approval {{\n        by \"maintain\"\n        others-only #true\n    }}\n    exec \"apply\"\n}}\n"
4272
        ),
4273
    );
4274
    let mut n = 0;
4275
    let mut push = || {
4276
        n += 1;
4277
        write(work.path(), "n.txt", &format!("{n}\n"));
4278
        c.snapshot("test").unwrap();
4279
        c.commit(&format!("Push {n}"), &[]).unwrap();
4280
        assert!(c.push("origin", false).unwrap().iter().all(|r| r.ok));
4281
    };
4282
    // Runs `plan` to a pass; returns the run, its actor set to andy.
4283
    let plan_passes = |number: i64| {
4284
        let app = h.app.clone();
4285
        let row = row.clone();
4286
        async move {
4287
            let mut run = None;
4288
            for _ in 0..100 {
4289
                if let Some(r) = db::flow::run(&app.db, row.id, number).await.unwrap() {
4290
                    run = Some(r);
4291
                    break;
4292
                }
4293
                tokio::time::sleep(std::time::Duration::from_millis(30)).await;
4294
            }
4295
            let run = run.expect("the run");
4296
            sqlx::query("UPDATE flow_runs SET actor = 'andy' WHERE id = ?").bind(run.id).execute(&app.db).await.unwrap();
4297
            let j = claim(&app).await.expect("plan is claimed");
4298
            assert_eq!(j["job"]["name"], "plan");
4299
            let (id, ph) = (j["job_id"].as_i64().unwrap(), j["pipeline_hash"].as_str().unwrap().to_string());
4300
            finish(&app, id, serde_json::json!({ "exit_code": 0, "duration_ms": 10, "receipt": receipt("plan", &ph, 0) })).await;
4301
            db::flow::run(&app.db, row.id, number).await.unwrap().unwrap()
4302
        }
4303
    };
4304
4305
    // Run 1: apply waits; only someone with the role, other than the pusher, approves it.
4306
    push();
4307
    let run = runs_of(&h.app, "andy", "gated").await[0].clone();
4308
    sqlx::query("UPDATE flow_runs SET actor = 'andy' WHERE id = ?").bind(run.id).execute(&h.app.db).await.unwrap();
4309
    let early = oxygenhub::flow::decide(&h.app, &row, &run, "apply", &carol, true).await.unwrap_err();
4310
    assert!(early.contains("waits for plan first"), "{early}");
4311
    let run = plan_passes(run.number).await;
4312
    assert!(claim(&h.app).await.is_none(), "apply waits for a person, so no runner gets it");
4313
    // Those who may approve are told, once; the pusher (others-only) and
4314
    // someone without the role are not.
4315
    let told = |id: i64| {
4316
        let db = h.app.db.clone();
4317
        async move { db::notify::inbox(&db, id, 20).await.unwrap().into_iter().filter(|n| n.kind == "flow.approval").count() }
4318
    };
4319
    assert_eq!((told(carol.id).await, told(andy.id).await, told(bob.id).await), (1, 0, 0));
4320
    let (_, page) = call(&h.app, "GET", &format!("/andy/gated/flow/{}", run.number), None, None).await;
4321
    assert!(page.contains("waits for approval by someone with the <em>maintain</em> role, other than andy"), "the run page says so");
4322
    let own = oxygenhub::flow::decide(&h.app, &row, &run, "apply", &andy, true).await.unwrap_err();
4323
    assert!(own.contains("someone other than andy"), "{own}");
4324
    let no_role = oxygenhub::flow::decide(&h.app, &row, &run, "apply", &bob, true).await.unwrap_err();
4325
    assert!(no_role.contains("takes the maintain role"), "{no_role}");
4326
    assert_eq!(oxygenhub::flow::decide(&h.app, &row, &run, "apply", &carol, true).await.unwrap(), "apply: approved by carol");
4327
    assert_eq!(told(carol.id).await, 1, "told once");
4328
    let j = claim(&h.app).await.expect("approved, it runs");
4329
    assert_eq!(j["job"]["name"], "apply");
4330
    let (id, ph) = (j["job_id"].as_i64().unwrap(), j["pipeline_hash"].as_str().unwrap().to_string());
4331
    finish(&h.app, id, serde_json::json!({ "exit_code": 0, "duration_ms": 10, "receipt": receipt("apply", &ph, 0) })).await;
4332
    let audit = db::accounts::audit_rows(&h.app.db, 50).await.unwrap();
4333
    assert!(audit.iter().any(|r| r.action == "flow.approved" && r.actor == "carol" && r.target.ends_with("#1 apply")), "audited");
4334
    let (_, page) = call(&h.app, "GET", &format!("/andy/gated/flow/{}", run.number), None, None).await;
4335
    assert!(page.contains("approved by carol"), "the run says who");
4336
4337
    // Run 2: rejected through the API's rules: the job ends cancelled, the run ends.
4338
    push();
4339
    let run = plan_passes(2).await;
4340
    assert_eq!(oxygenhub::flow::decide(&h.app, &row, &run, "apply", &carol, false).await.unwrap(), "apply: rejected by carol");
4341
    let jobs = db::flow::jobs(&h.app.db, run.id).await.unwrap();
4342
    let apply = jobs.iter().find(|j| j.name == "apply").unwrap();
4343
    assert_eq!((apply.status.as_str(), apply.error.as_str()), ("cancelled", "rejected by carol"));
4344
    assert!(claim(&h.app).await.is_none());
4345
4346
    // Run 3: nobody decides in time.
4347
    push();
4348
    let run = plan_passes(3).await;
4349
    assert_eq!(oxygenhub::flow::expire_approvals(&h.app, db::now_ms() + 3_600_000).await.unwrap(), 0, "not yet");
4350
    assert_eq!(oxygenhub::flow::expire_approvals(&h.app, db::now_ms() + 25 * 3_600_000).await.unwrap(), 1);
4351
    let jobs = db::flow::jobs(&h.app.db, run.id).await.unwrap();
4352
    let apply = jobs.iter().find(|j| j.name == "apply").unwrap();
4353
    assert_eq!((apply.status.as_str(), apply.error.as_str()), ("cancelled", "no approval within 24h"));
4354
}