OXYGENHUB
◆ v0.9.5 oxygenhub / crates / hub / tests / issues.rs
81.7 KiB · Rust · last changed Boards keep the last fortnight of finished work (refs #293) 10 days ago source blame history raw
1
//! Milestone 0.4 end to end: issues with labels, assignees and
2
//! milestones, cross references, closing keywords on landing, the inbox,
3
//! watching, mentions and search.
4
5
use axum::body::Body;
6
use axum::http::{header, Request, StatusCode};
7
use http_body_util::BodyExt;
8
use oxy_core::repo::Repo;
9
use oxygenhub::config::Config;
10
use oxygenhub::db;
11
use oxygenhub::repos::RepoName;
12
use oxygenhub::Shared;
13
use std::path::Path;
14
use tower::ServiceExt;
15
16
fn hermetic() {
17
    static ONCE: std::sync::Once = std::sync::Once::new();
18
    static DIR: std::sync::OnceLock<tempfile::TempDir> = std::sync::OnceLock::new();
19
    ONCE.call_once(|| {
20
        let d = tempfile::tempdir().unwrap();
21
        std::env::set_var("OXY_HOME", d.path());
22
        DIR.set(d).ok();
23
    });
24
}
25
26
fn write(root: &Path, rel: &str, content: &[u8]) {
27
    let p = root.join(rel);
28
    std::fs::create_dir_all(p.parent().unwrap()).unwrap();
29
    std::fs::write(p, content).unwrap();
30
}
31
32
struct Hub {
33
    app: Shared,
34
    base: String,
35
    _dir: tempfile::TempDir,
36
}
37
38
async fn hub() -> Hub {
39
    hermetic();
40
    let dir = tempfile::tempdir().unwrap();
41
    let mut config = Config::load(dir.path()).unwrap();
42
    // The first account's setup code (oxygenhub#245).
43
    config.registration.setup_code = "test-setup".into();
44
    config.auth.push_tokens = vec!["site".into()];
45
    config.registration.mode = "open".into();
46
    let listener = tokio::net::TcpListener::bind("127.0.0.1:0").await.unwrap();
47
    let port = listener.local_addr().unwrap().port();
48
    config.server.base_url = format!("http://127.0.0.1:{port}");
49
    let app = oxygenhub::build(config).await.unwrap();
50
    let router = oxygenhub::router(app.clone());
51
    tokio::spawn(async move { axum::serve(listener, router).await.unwrap() });
52
    Hub { app, base: format!("http://127.0.0.1:{port}"), _dir: dir }
53
}
54
55
struct Res {
56
    status: StatusCode,
57
    body: String,
58
    cookie: Option<String>,
59
    location: Option<String>,
60
}
61
62
async fn send(app: &Shared, method: &str, path: &str, cookie: Option<&str>, form: Option<&str>) -> Res {
63
    let mut req = Request::builder().method(method).uri(path);
64
    if let Some(c) = cookie {
65
        req = req.header(header::COOKIE, format!("oxyhub={c}"));
66
    }
67
    let body = match form {
68
        Some(f) => {
69
            req = req.header(header::CONTENT_TYPE, "application/x-www-form-urlencoded");
70
            Body::from(f.to_string())
71
        }
72
        None => Body::empty(),
73
    };
74
    let res = oxygenhub::router(app.clone()).oneshot(req.body(body).unwrap()).await.unwrap();
75
    let status = res.status();
76
    let cookie = res
77
        .headers()
78
        .get(header::SET_COOKIE)
79
        .and_then(|v| v.to_str().ok())
80
        .and_then(|v| v.split(';').next())
81
        .and_then(|kv| kv.split_once('='))
82
        .map(|(_, v)| v.to_string());
83
    let location = res.headers().get(header::LOCATION).and_then(|v| v.to_str().ok()).map(String::from);
84
    let bytes = res.into_body().collect().await.unwrap().to_bytes();
85
    Res { status, body: String::from_utf8_lossy(&bytes).into_owned(), cookie, location }
86
}
87
88
async fn get(app: &Shared, path: &str, cookie: Option<&str>) -> Res {
89
    send(app, "GET", path, cookie, None).await
90
}
91
92
async fn post(app: &Shared, path: &str, cookie: Option<&str>, form: &str) -> Res {
93
    send(app, "POST", path, cookie, Some(form)).await
94
}
95
96
async fn register(app: &Shared, user: &str) -> String {
97
    let r = post(
98
        app,
99
        "/register",
100
        None,
101
        &format!("username={user}&email={user}%40example.com&password=correct-horse-battery&setup=test-setup"),
102
    )
103
    .await;
104
    assert_eq!(r.status, StatusCode::SEE_OTHER, "{}", r.body);
105
    r.cookie.unwrap()
106
}
107
108
/// A repository settings form's answer (#278): a redirect to the page that
109
/// holds the form, followed.
110
async fn settled(app: &Shared, r: Res, cookie: Option<&str>, page: &str) -> Res {
111
    assert_eq!(r.status, StatusCode::SEE_OTHER, "{}", r.body);
112
    let to = r.location.expect("a redirect");
113
    assert!(to.starts_with(&format!("{page}?")), "{to} is not {page}");
114
    get(app, &to, cookie).await
115
}
116
117
fn csrf_of(page: &str) -> String {
118
    let i = page.find("name=\"_csrf\" value=\"").expect("csrf field") + "name=\"_csrf\" value=\"".len();
119
    page[i..].split('"').next().unwrap().to_string()
120
}
121
122
#[tokio::test(flavor = "multi_thread")]
123
async fn issues_notifications_and_search() {
124
    let h = hub().await;
125
    let app = &h.app;
126
    let andy = register(app, "andy").await;
127
    let bob = register(app, "bob").await;
128
    let repo = RepoName::parse("andy/demo").unwrap();
129
    app.repos.create(&repo, None).unwrap();
130
    db::repos::create(&app.db, "andy", "demo", "", hub_api::Visibility::Public).await.unwrap();
131
132
    // Labels and a milestone, by the owner.
133
    let labels_page = get(app, "/andy/demo/labels", Some(&andy)).await;
134
    let csrf_a = csrf_of(&labels_page.body);
135
    assert!(post(app, "/andy/demo/labels", Some(&andy), &format!("_csrf={csrf_a}&name=bug&colour=%23ff0000&description=Something+broke"))
136
        .await
137
        .body
138
        .contains("Saved bug"));
139
    assert!(post(app, "/andy/demo/milestones", Some(&andy), &format!("_csrf={csrf_a}&title=v1&description=First&due=2027-01-01"))
140
        .await
141
        .body
142
        .contains("v1"));
143
    assert_eq!(get(app, "/andy/demo/labels", Some(&bob)).await.status, StatusCode::OK, "readers see labels");
144
    assert!(!get(app, "/andy/demo/labels", Some(&bob)).await.body.contains("Add or change"), "but cannot edit them");
145
146
    // Bob watches the repository, then Andy opens an issue mentioning @bob: Bob is told twice at most once.
147
    let overview = get(app, "/andy/demo", Some(&bob)).await;
148
    let csrf_b = csrf_of(&overview.body);
149
    assert_eq!(post(app, "/andy/demo/watch", Some(&bob), &format!("_csrf={csrf_b}")).await.status, StatusCode::SEE_OTHER);
150
    assert!(get(app, "/andy/demo", Some(&bob)).await.body.contains("UNWATCH"));
151
    let new_page = get(app, "/andy/demo/issues/new", Some(&andy)).await;
152
    let csrf_a = csrf_of(&new_page.body);
153
    let r = post(
154
        app,
155
        "/andy/demo/issues/new",
156
        Some(&andy),
157
        &format!("_csrf={csrf_a}&title=Crash+on+start&body=cc+%40bob+see+%23999+and+deadbeefcafe1234"),
158
    )
159
    .await;
160
    assert_eq!(r.status, StatusCode::SEE_OTHER, "{}", r.body);
161
    assert_eq!(r.location.as_deref(), Some("/andy/demo/issue/1"));
162
    let page = get(app, "/andy/demo/issue/1", Some(&bob)).await;
163
    assert!(page.body.contains("Crash on start"));
164
    assert!(page.body.contains("href=\"/bob\""), "mention linked: {}", page.body);
165
    assert!(page.body.contains("/andy/demo/change/deadbeefcafe1234"), "hash linked: {}", page.body);
166
    assert!(page.body.contains("#999") && !page.body.contains("issue/999"), "unknown numbers are not linked");
167
    let unread = db::notify::unread(&app.db, db::accounts::account_by_name(&app.db, "bob").await.unwrap().unwrap().id).await.unwrap();
168
    assert_eq!(unread, 1, "one notification, not one per reason");
169
    // The inbox's thread counts it unread (the SQL is portable now:
170
    // oxygenhub#211).
171
    let bob_id = db::accounts::account_by_name(&app.db, "bob").await.unwrap().unwrap().id;
172
    let filter = db::notify::Filter { done: false, unread_only: false, reason: None, kind: None, repo_id: None };
173
    let t = db::notify::threads(&app.db, bob_id, &filter, 10).await.unwrap();
174
    assert_eq!((t[0].count, t[0].unread), (1, 1));
175
    let unread_only = db::notify::Filter { unread_only: true, ..filter.clone() };
176
    assert_eq!(db::notify::threads(&app.db, bob_id, &unread_only, 10).await.unwrap().len(), 1);
177
    let inbox = get(app, "/notifications", Some(&bob)).await;
178
    assert!(inbox.body.contains("andy/demo#1: Crash on start"), "{}", inbox.body);
179
    assert!(get(app, "/andy/demo", Some(&bob)).await.body.contains("class=\"count\">1<"), "bell shows the count");
180
181
    // Triage: labels, assignee, milestone, pin, lock.
182
    let page = get(app, "/andy/demo/issue/1", Some(&andy)).await;
183
    let csrf_a = csrf_of(&page.body);
184
    let label_id: i64 = sqlx::query_scalar("SELECT id FROM labels WHERE name = 'bug'").fetch_one(&app.db).await.unwrap();
185
    let r = post(app, "/andy/demo/issue/1/labels", Some(&andy), &format!("_csrf={csrf_a}&label={label_id}")).await;
186
    assert!(r.body.contains(">bug<"), "{}", r.body);
187
    let r = post(app, "/andy/demo/issue/1/assign", Some(&andy), &format!("_csrf={csrf_a}&username=bob&action=add")).await;
188
    assert!(r.body.contains("<li><a href=\"/bob\"><img class=\"avatar xs\""), "{}", r.body);
189
    // oxygenhub#82: the sidebar's menu sets the whole list at once.
190
    assert!(r.body.contains("Assign people to this issue") && r.body.contains("data-menu-filter"), "the assignees menu");
191
    let r = post(app, "/andy/demo/issue/1/assign", Some(&andy), &format!("_csrf={csrf_a}&action=set&username=andy&username=bob")).await;
192
    let assigned = |db: oxygenhub::db::Pool| async move {
193
        let id: i64 = sqlx::query_scalar("SELECT id FROM issues WHERE number = 1").fetch_one(&db).await.unwrap();
194
        let mut a = db::issues::assignees(&db, id).await.unwrap();
195
        a.sort();
196
        a
197
    };
198
    assert_eq!(assigned(app.db.clone()).await, ["andy", "bob"], "{}", r.status);
199
    post(app, "/andy/demo/issue/1/assign", Some(&andy), &format!("_csrf={csrf_a}&action=set&username=bob")).await;
200
    assert_eq!(assigned(app.db.clone()).await, ["bob"], "set takes off who is not listed");
201
    let ms_id: i64 = sqlx::query_scalar("SELECT id FROM milestones WHERE title = 'v1'").fetch_one(&app.db).await.unwrap();
202
    let r = post(app, "/andy/demo/issue/1/milestone", Some(&andy), &format!("_csrf={csrf_a}&milestone={ms_id}")).await;
203
    assert!(r.body.contains(">v1<"), "{}", r.body);
204
    assert!(post(app, "/andy/demo/issue/1/state", Some(&andy), &format!("_csrf={csrf_a}&action=pin")).await.body.contains("Unpin issue"));
205
    assert_eq!(
206
        post(
207
            app,
208
            "/andy/demo/issue/1/state",
209
            Some(&bob),
210
            &format!("_csrf={}&action=lock", csrf_of(&get(app, "/andy/demo/issue/1", Some(&bob)).await.body))
211
        )
212
        .await
213
        .status,
214
        StatusCode::NOT_FOUND,
215
        "bob cannot lock"
216
    );
217
    // Filters on the list.
218
    let list = get(app, "/andy/demo/issues?q=label:bug+assignee:bob+milestone:v1", None).await;
219
    assert!(list.body.contains("Crash on start"), "{}", list.body);
220
    assert!(!get(app, "/andy/demo/issues?q=label:feature", None).await.body.contains("Crash on start"));
221
    assert!(get(app, "/andy/demo/milestones", None).await.body.contains("1 open, 0 closed"));
222
223
    // Bob comments and closes; the author is told; search finds the comment.
224
    let csrf_b = csrf_of(&get(app, "/andy/demo/issue/1", Some(&bob)).await.body);
225
    let r = post(app, "/andy/demo/issue/1/comment", Some(&bob), &format!("_csrf={csrf_b}&body=Reproduced+with+the+flux+capacitor")).await;
226
    assert!(r.body.contains("flux capacitor"), "{}", r.body);
227
    assert!(get(app, "/notifications", Some(&andy)).await.body.contains("andy/demo#1"));
228
    let s = get(app, "/search?q=capacitor", None).await;
229
    assert!(s.body.contains("Crash on start") && s.body.contains("<mark>capacitor</mark>"), "{}", s.body);
230
    let s = get(app, "/search?q=demo", None).await;
231
    assert!(s.body.contains("/andy/demo\""), "repository hit: {}", s.body);
232
    // Bob is not triage, but as an assignee of an open issue he can comment-and-close? No: only the author or triage.
233
    let r = post(app, "/andy/demo/issue/1/comment", Some(&bob), &format!("_csrf={csrf_b}&body=closing&close=completed")).await;
234
    assert!(r.body.contains(">open<") || r.body.contains("head\">open"), "still open: {}", r.body);
235
    let r = post(app, "/andy/demo/issue/1/comment", Some(&andy), &format!("_csrf={csrf_a}&body=fixed&close=completed")).await;
236
    assert!(r.body.contains("closed"), "{}", r.body);
237
    assert!(get(app, "/andy/demo/issues?state=closed", None).await.body.contains("Crash on start"));
238
239
    // A second issue closed by a change message pushed to the default bookmark.
240
    let csrf_a = csrf_of(&get(app, "/andy/demo/issues/new", Some(&andy)).await.body);
241
    assert_eq!(
242
        post(app, "/andy/demo/issues/new", Some(&andy), &format!("_csrf={csrf_a}&title=Typo&body=")).await.location.as_deref(),
243
        Some("/andy/demo/issue/2")
244
    );
245
    let work = tempfile::tempdir().unwrap();
246
    let mut client = Repo::init(work.path()).unwrap();
247
    client.config.set("remote.origin.url", &format!("{}/andy/demo", h.base)).unwrap();
248
    client.config.set("remote.origin.token", "site").unwrap();
249
    client.save_config().unwrap();
250
    write(work.path(), "a.txt", b"a\n");
251
    client.snapshot("t").unwrap();
252
    client.commit("Fix the typo\n\nCloses #2", &[]).unwrap();
253
    assert!(client.push("origin", false).unwrap().iter().all(|r| r.ok));
254
    // The push hook closes it after the push answers: wait, up to ten seconds (#121).
255
    let repo_id = db::repos::get(&app.db, "andy", "demo").await.unwrap().unwrap().id;
256
    let mut issue2 = db::issues::get(&app.db, repo_id, 2).await.unwrap().unwrap();
257
    for _ in 0..200 {
258
        if issue2.state == "closed" {
259
            break;
260
        }
261
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
262
        issue2 = db::issues::get(&app.db, repo_id, 2).await.unwrap().unwrap();
263
    }
264
    assert_eq!(issue2.state, "closed", "closed by the landed change");
265
    assert!(get(app, "/andy/demo/issue/2", None).await.body.contains("closed by change"));
266
267
    // Numbers are shared: the next proposal is #3, and /issue/3 redirects to it.
268
    client.bookmark_create("feat", None).unwrap();
269
    client.bookmark_switch("feat", false).unwrap();
270
    write(work.path(), "b.txt", b"b\n");
271
    client.snapshot("t").unwrap();
272
    client.commit("feat", &[]).unwrap();
273
    assert!(client.push_bookmark("origin", "feat", false).unwrap().iter().all(|r| r.ok));
274
    let csrf_a = csrf_of(&get(app, "/andy/demo/proposals/new?source=feat&target=main", Some(&andy)).await.body);
275
    let r = post(app, "/andy/demo/proposals/new", Some(&andy), &format!("_csrf={csrf_a}&title=Feat&target=main&source=feat")).await;
276
    assert_eq!(r.location.as_deref(), Some("/andy/demo/proposal/3"), "{}", r.body);
277
    assert_eq!(get(app, "/andy/demo/issue/3", None).await.location.as_deref(), Some("/andy/demo/proposal/3"));
278
    // A comment on the issue referencing #3 links to the proposal.
279
    let r = post(app, "/andy/demo/issue/2/comment", Some(&andy), &format!("_csrf={csrf_a}&body=see+%233")).await;
280
    assert!(r.body.contains("href=\"/andy/demo/proposal/3\""), "{}", r.body);
281
    // `#N` in a pushed change's message lands on those timelines (hub spec §8).
282
    client.bookmark_switch("main", false).unwrap();
283
    write(work.path(), "c.txt", b"c\n");
284
    client.snapshot("t").unwrap();
285
    let r = client.commit("Tidy up (refs #1, see #3)", &[]).unwrap();
286
    assert!(client.push("origin", false).unwrap().iter().all(|r| r.ok));
287
    let short = &r.to_hex()[..12];
288
    // The push hook records the references after the push answers: wait, up
289
    // to ten seconds (#121).
290
    let mut one = get(app, "/andy/demo/issue/1", None).await.body;
291
    for _ in 0..200 {
292
        if one.contains("referenced by change") {
293
            break;
294
        }
295
        tokio::time::sleep(std::time::Duration::from_millis(50)).await;
296
        one = get(app, "/andy/demo/issue/1", None).await.body;
297
    }
298
    assert!(
299
        one.contains("referenced by change") && one.contains(&format!("href=\"/andy/demo/change/{short}\"")) && one.contains(" on main"),
300
        "{one}"
301
    );
302
    let three = get(app, "/andy/demo/proposal/3", Some(&andy)).await.body;
303
    assert!(three.contains("referenced by change") && three.contains(short), "proposals too");
304
    assert!(!get(app, "/andy/demo/issue/2", None).await.body.contains("referenced by change"), "a closing change records only that");
305
    // #318: the same change pushed on another bookmark is no new reference.
306
    client.bookmark_create("again", None).unwrap();
307
    assert!(client.push_bookmark("origin", "again", false).unwrap().iter().all(|r| r.ok));
308
    tokio::time::sleep(std::time::Duration::from_millis(1500)).await;
309
    let recorded: i64 = sqlx::query_scalar("SELECT COUNT(*) FROM issue_events WHERE event = 'referenced by change' AND detail LIKE $1")
310
        .bind(format!("{short} %"))
311
        .fetch_one(&app.db)
312
        .await
313
        .unwrap();
314
    assert_eq!(recorded, 1, "once per change, whichever bookmarks it is on");
315
316
    // #292: many references on one day are one box, wrapping, the newest
317
    // day's open; a lone one stays a line.
318
    let issue1 = db::issues::get(&app.db, repo_id, 1).await.unwrap().unwrap();
319
    let day = 1_792_540_800_000i64; // 21 Oct 2026, 00:00 UTC
320
    for (i, at) in [day + 1_000, day + 2_000, day + 3_000, day - 86_400_000].into_iter().enumerate() {
321
        sqlx::query("INSERT INTO issue_events (issue_id, at_ms, actor, event, detail) VALUES ($1, $2, 'andy', 'referenced by change', $3)")
322
            .bind(issue1.id)
323
            .bind(at)
324
            .bind(format!("{:012x} on main", 0xabc000 + i))
325
            .execute(&app.db)
326
            .await
327
            .unwrap();
328
    }
329
    // One recorded again for another bookmark before #318: shown once.
330
    sqlx::query("INSERT INTO issue_events (issue_id, at_ms, actor, event, detail) VALUES ($1, $2, 'andy', 'referenced by change', $3)")
331
        .bind(issue1.id)
332
        .bind(day + 4_000)
333
        .bind(format!("{:012x} on develop", 0xabc000))
334
        .execute(&app.db)
335
        .await
336
        .unwrap();
337
    let one = get(app, "/andy/demo/issue/1", None).await.body;
338
    assert!(one.contains("referenced by 3 changes on 21 Oct 2026"), "{one}");
339
    assert_eq!(one.matches(&format!("change/{:012x}\"", 0xabc000)).count(), 1, "each change once");
340
    assert!(!one.contains("mute timeline"), "the events have no rule of their own (#318)");
341
    assert!(one.contains("refs-day\" open><summary>referenced by 3 changes"), "the newest box is open: {one}");
342
    assert!(!one.contains("changes on 20 Oct 2026"), "a lone reference is a line");
343
    assert!(one.contains(&format!("href=\"/andy/demo/change/{short}\"")), "today's own stays");
344
345
    // Bob takes part in #1 (mentioned, assigned, commented) and only watches #3.
346
    let part = get(app, "/notifications?reason=participating", Some(&bob)).await.body;
347
    assert!(part.contains("andy/demo#1") && !part.contains("andy/demo#3: Feat"), "{part}");
348
    let watch = get(app, "/notifications?reason=watching", Some(&bob)).await.body;
349
    assert!(watch.contains("andy/demo#3: Feat") && !watch.contains("Crash on start"), "{watch}");
350
    let props = get(app, "/notifications?kind=proposal", Some(&bob)).await.body;
351
    assert!(props.contains("andy/demo#3: Feat") && !props.contains("andy/demo#1"), "kind filter");
352
    assert!(get(app, "/notifications?repo=andy/demo", Some(&bob)).await.body.contains("andy/demo#3: Feat"));
353
    assert!(get(app, "/notifications?repo=nobody/none", Some(&bob)).await.body.contains("Nothing matches these filters"));
354
    // One row per thread, however many events it had.
355
    let inbox = get(app, "/notifications", Some(&bob)).await.body;
356
    assert_eq!(inbox.matches("data-row-thread=\"/andy/demo/issue/1\"").count(), 1, "{inbox}");
357
    assert!(inbox.contains(" updates"), "the count of a busy thread");
358
    // Opening a thread marks it read and goes there.
359
    let bob_id = db::accounts::account_by_name(&app.db, "bob").await.unwrap().unwrap().id;
360
    let newest: i64 = sqlx::query_scalar(
361
        "SELECT id FROM notifications WHERE account_id = $1 AND thread = '/andy/demo/proposal/3' ORDER BY id DESC LIMIT 1",
362
    )
363
    .bind(bob_id)
364
    .fetch_one(&app.db)
365
    .await
366
    .unwrap();
367
    let before = db::notify::unread(&app.db, bob_id).await.unwrap();
368
    let r = get(app, &format!("/notifications/open/{newest}"), Some(&bob)).await;
369
    assert_eq!(r.location.as_deref(), Some("/andy/demo/proposal/3"));
370
    assert!(db::notify::unread(&app.db, bob_id).await.unwrap() < before);
371
    assert_eq!(get(app, &format!("/notifications/open/{newest}"), Some(&andy)).await.status, StatusCode::NOT_FOUND, "only your own");
372
    // Done sets a thread aside until something new happens in it.
373
    let csrf_b = csrf_of(&get(app, "/notifications", Some(&bob)).await.body);
374
    let r = post(
375
        app,
376
        "/notifications/thread",
377
        Some(&bob),
378
        &format!("_csrf={csrf_b}&thread=%2Fandy%2Fdemo%2Fissue%2F1&action=done&back=%2Fnotifications"),
379
    )
380
    .await;
381
    assert_eq!(r.location.as_deref(), Some("/notifications"));
382
    assert!(!get(app, "/notifications", Some(&bob)).await.body.contains("Crash on start"));
383
    assert!(get(app, "/notifications?view=done", Some(&bob)).await.body.contains("Crash on start"));
384
    post(app, "/andy/demo/issue/1/comment", Some(&andy), &format!("_csrf={csrf_a}&body=one+more+thing")).await;
385
    assert!(get(app, "/notifications", Some(&bob)).await.body.contains("Crash on start"), "back with the new comment");
386
    let r = post(
387
        app,
388
        "/notifications/thread",
389
        Some(&bob),
390
        &format!("_csrf={csrf_b}&thread=%2Fandy%2Fdemo%2Fissue%2F1&action=read&back=https%3A%2F%2Fevil.example"),
391
    )
392
    .await;
393
    assert_eq!(r.location.as_deref(), Some("/notifications"), "only back to the inbox");
394
395
    // Bob (watcher) heard about the proposal; the inbox marks all read.
396
    assert!(get(app, "/notifications", Some(&bob)).await.body.contains("andy/demo#3: Feat"));
397
    let csrf_b = csrf_of(&get(app, "/notifications", Some(&bob)).await.body);
398
    let r = post(app, "/notifications/read", Some(&bob), &format!("_csrf={csrf_b}")).await;
399
    assert!(r.body.contains("0 unread"), "{}", r.body);
400
    // Email preference and the unsubscribe link.
401
    let r = post(app, "/settings/notifications", Some(&bob), &format!("_csrf={csrf_b}&email=1")).await;
402
    assert!(r.body.contains("Email notifications are on"));
403
    let key: String = sqlx::query_scalar("SELECT unsubscribe_key FROM accounts WHERE username = 'bob'").fetch_one(&app.db).await.unwrap();
404
    assert_eq!(get(app, &format!("/settings/notifications?unsubscribe={key}"), None).await.status, StatusCode::OK);
405
    let on: bool = sqlx::query_scalar("SELECT email_notifications FROM accounts WHERE username = 'bob'").fetch_one(&app.db).await.unwrap();
406
    assert!(!on);
407
}
408
409
#[tokio::test(flavor = "multi_thread")]
410
async fn dashboard_shows_what_needs_the_viewer() {
411
    let h = hub().await;
412
    let app = &h.app;
413
    let andy = register(app, "andy").await;
414
    let bob = register(app, "bob").await;
415
    for (name, vis) in [("demo", hub_api::Visibility::Public), ("secret", hub_api::Visibility::Private)] {
416
        app.repos.create(&RepoName::parse(&format!("andy/{name}")).unwrap(), None).unwrap();
417
        db::repos::create(&app.db, "andy", name, "", vis).await.unwrap();
418
    }
419
    let demo = db::repos::get(&app.db, "andy", "demo").await.unwrap().unwrap();
420
    let secret = db::repos::get(&app.db, "andy", "secret").await.unwrap().unwrap();
421
    let bob_id = db::accounts::account_by_name(&app.db, "bob").await.unwrap().unwrap().id;
422
    for (repo, title) in [(demo.id, "Faster startup"), (secret.id, "Hidden work")] {
423
        let p = db::proposals::create(
424
            &app.db,
425
            db::proposals::NewProposal {
426
                repo_id: repo,
427
                title,
428
                body: "",
429
                author_id: Some(bob_id),
430
                author: "bob",
431
                draft: false,
432
                target: "main",
433
                source_kind: "bookmark",
434
                source_repo_id: Some(repo),
435
                source_bookmark: "fast",
436
                source_changes: "",
437
            },
438
        )
439
        .await
440
        .unwrap();
441
        db::proposals::add_event(&app.db, p.id, "bob", "opened", "").await.unwrap();
442
    }
443
444
    // Signed out, `/` is still the repository list.
445
    let anon = get(app, "/", None).await;
446
    assert!(anon.body.contains("andy /") && !anon.body.contains("Dashboard <small>"), "{}", anon.body);
447
448
    // Andy owns both repositories: both proposals wait for his review.
449
    let page = get(app, "/", Some(&andy)).await;
450
    assert_eq!(page.status, StatusCode::OK);
451
    assert!(page.body.contains("Waiting for your review</h2><span class=\"count-chip\">2</span>"), "{}", page.body);
452
    assert!(page.body.contains("/andy/demo/proposal/1") && page.body.contains("/andy/secret/proposal/1"));
453
    assert!(page.body.contains("Your repositories"));
454
    assert!(page.body.contains("opened proposal"), "activity feed: {}", page.body);
455
456
    // Your sky (#157, docs/backgrounds.md §5): the canvas, and its data from
457
    // the database: his repositories and their events, safe in a script.
458
    assert!(page.body.contains(r#"<canvas id="backdrop" aria-hidden="true">"#));
459
    let start = page.body.find(r#"id="backdrop-data">"#).unwrap() + r#"id="backdrop-data">"#.len();
460
    let data: serde_json::Value = serde_json::from_str(&page.body[start..start + page.body[start..].find("</script>").unwrap()]).unwrap();
461
    let repos: Vec<&str> = data["repos"].as_array().unwrap().iter().filter_map(|r| r.as_str()).collect();
462
    assert!(repos.contains(&"andy/demo") && repos.contains(&"andy/secret"), "{data}");
463
    let events = data["events"].as_array().unwrap();
464
    assert!(events.iter().any(|e| e[1] == 1), "the proposals opened are marks: {data}");
465
    assert!(events.iter().all(|e| e[0].as_u64().unwrap() < repos.len() as u64));
466
    // His page is his alone: no shared cache may keep it (#157).
467
    let res = oxygenhub::router(app.clone())
468
        .oneshot(Request::builder().uri("/").header(header::COOKIE, format!("oxyhub={andy}")).body(Body::empty()).unwrap())
469
        .await
470
        .unwrap();
471
    assert_eq!(res.headers()[header::CACHE_CONTROL], "private, no-store");
472
    // The mark on sign in; adrift on a page not found, not on a refusal.
473
    assert!(get(app, "/login", None)
474
        .await
475
        .body
476
        .contains(r#"<script type="application/json" id="backdrop-data">{"scene":"mark"}</script>"#));
477
    let lost = get(app, "/no/such/page/here", None).await;
478
    assert_eq!(lost.status, StatusCode::NOT_FOUND);
479
    assert!(lost.body.contains(r#"{"scene":"adrift"}"#));
480
    // Signed out, `/` has the hub's sky (#165): public repositories only.
481
    let sky_of = |body: &str| {
482
        let start = body.find(r#"id="backdrop-data">"#).unwrap() + r#"id="backdrop-data">"#.len();
483
        body[start..start + body[start..].find("</script>").unwrap()].to_string()
484
    };
485
    let hub_sky = sky_of(&anon.body);
486
    assert!(hub_sky.contains("andy/demo") && !hub_sky.contains("andy/secret"), "{hub_sky}");
487
    // Explore's sky is the hub's, public only, even for the owner of a
488
    // private repository; an owner's listing has none.
489
    let explore = get(app, "/explore", Some(&andy)).await;
490
    assert!(explore.body.contains("andy/secret"), "the list shows him his private repository");
491
    let hub_sky = sky_of(&explore.body);
492
    assert!(hub_sky.contains("andy/demo") && !hub_sky.contains("andy/secret"), "{hub_sky}");
493
    assert!(!get(app, "/andy", None).await.body.contains("backdrop-data"));
494
    // The engine is served as WebAssembly.
495
    let res = oxygenhub::router(app.clone())
496
        .oneshot(Request::builder().uri("/static/backdrop/backdrop_bg.wasm").body(Body::empty()).unwrap())
497
        .await
498
        .unwrap();
499
    assert_eq!(res.headers()[header::CONTENT_TYPE], "application/wasm");
500
    assert!(res.into_body().collect().await.unwrap().to_bytes().starts_with(b"\0asm"));
501
    // Live arrivals (#172): what happened since, by the sky's own rule.
502
    assert!(sky_of(&page.body).contains(r#""live":"mine""#) && hub_sky.contains(r#""live":"hub""#));
503
    let since = db::now_ms() - 3_600_000;
504
    let arrivals = |res: Res| -> Vec<String> {
505
        assert_eq!(res.status, StatusCode::OK, "{}", res.body);
506
        let v: serde_json::Value = serde_json::from_str(&res.body).unwrap();
507
        v["events"].as_array().unwrap().iter().map(|e| e[0].as_str().unwrap().to_string()).collect()
508
    };
509
    let mine = arrivals(get(app, &format!("/sky/arrivals?scene=mine&since={since}"), Some(&andy)).await);
510
    assert!(mine.iter().any(|r| r == "andy/demo") && mine.iter().any(|r| r == "andy/secret"), "{mine:?}");
511
    let hub = arrivals(get(app, &format!("/sky/arrivals?scene=hub&since={since}"), Some(&andy)).await);
512
    assert!(hub.iter().any(|r| r == "andy/demo") && !hub.iter().any(|r| r == "andy/secret"), "the hub's sky is public only: {hub:?}");
513
    let anon_hub = arrivals(get(app, &format!("/sky/arrivals?scene=hub&since={since}"), None).await);
514
    assert!(!anon_hub.iter().any(|r| r == "andy/secret"), "{anon_hub:?}");
515
    assert!(arrivals(get(app, &format!("/sky/arrivals?scene=mine&since={since}"), None).await).is_empty(), "signed out has no `mine`");
516
    assert!(
517
        arrivals(get(app, &format!("/sky/arrivals?scene=mine&since={since}"), Some(&bob)).await).is_empty(),
518
        "Bob's sky has none of Andy's"
519
    );
520
    assert!(
521
        arrivals(get(app, &format!("/sky/arrivals?scene=mine&since={}", db::now_ms()), Some(&andy)).await).is_empty(),
522
        "nothing since now"
523
    );
524
525
    // Once he reviews one, it leaves his queue.
526
    let andy_id = db::accounts::account_by_name(&app.db, "andy").await.unwrap().unwrap().id;
527
    let p = db::proposals::get(&app.db, demo.id, 1).await.unwrap().unwrap();
528
    db::proposals::add_review(&app.db, p.id, andy_id, "andy", "approve", "").await.unwrap();
529
    assert!(get(app, "/", Some(&andy)).await.body.contains("Waiting for your review</h2><span class=\"count-chip\">1</span>"));
530
531
    // Bob sees his own proposal on the public repository, never the private one's.
532
    let page = get(app, "/", Some(&bob)).await;
533
    // His sky holds only his own repositories: never Andy's, public or
534
    // private, and nothing of the private one (#157).
535
    let start = page.body.find(r#"id="backdrop-data">"#).unwrap() + r#"id="backdrop-data">"#.len();
536
    let sky = &page.body[start..start + page.body[start..].find("</script>").unwrap()];
537
    assert!(!sky.contains("andy/secret") && !sky.contains("andy/demo"), "{sky}");
538
    assert!(page.body.contains("Your proposals</h2><span class=\"count-chip\">1</span>"), "{}", page.body);
539
    assert!(!page.body.contains("Hidden work"));
540
    assert!(page.body.contains("Waiting for your review</h2><span class=\"count-chip\">0</span>"));
541
    assert!(page.body.contains("Faster startup"));
542
    let feed = &page.body[page.body.find("Recent activity").unwrap()..];
543
    assert!(!feed.contains("andy/secret"), "private activity leaked: {feed}");
544
545
    // Explore still lists every visible repository.
546
    assert!(get(app, "/explore", Some(&bob)).await.body.contains("andy /"));
547
}
548
549
#[tokio::test(flavor = "multi_thread")]
550
async fn empty_repository_shows_a_quickstart() {
551
    let h = hub().await;
552
    let app = &h.app;
553
    let andy = register(app, "andy").await;
554
    let bob = register(app, "bob").await;
555
    app.repos.create(&RepoName::parse("andy/fresh").unwrap(), None).unwrap();
556
    db::repos::create(&app.db, "andy", "fresh", "", hub_api::Visibility::Public).await.unwrap();
557
558
    let page = get(app, "/andy/fresh", Some(&andy)).await;
559
    assert!(page.body.contains("This repository is empty"), "{}", page.body);
560
    let clone_url = format!("{}/andy/fresh", h.base);
561
    assert!(page.body.contains(&format!("oxy remote add hub {clone_url}")), "{}", page.body);
562
    assert!(page.body.contains("oxy config remote.hub.token YOUR-TOKEN"));
563
    assert!(page.body.contains("oxy push hub"));
564
    assert!(
565
        page.body.contains("mkdir fresh &amp;&amp; cd fresh") || page.body.contains("mkdir fresh &#38;&#38; cd fresh"),
566
        "{}",
567
        page.body
568
    );
569
    assert!(page.body.contains("oxy git import --branch main"));
570
    assert!(!page.body.contains("oxyhub-ca.pem"), "no certificate step without a self-signed certificate");
571
572
    // A reader without write access is not told to push.
573
    let page = get(app, "/andy/fresh", Some(&bob)).await;
574
    assert!(page.body.contains("Nothing has been pushed yet") && !page.body.contains("oxy push hub"), "{}", page.body);
575
576
    // After a first push the quickstart gives way to the tree.
577
    let work = tempfile::tempdir().unwrap();
578
    let mut client = Repo::init(work.path()).unwrap();
579
    client.config.set("remote.hub.url", &clone_url).unwrap();
580
    client.config.set("remote.hub.token", "site").unwrap();
581
    client.save_config().unwrap();
582
    write(work.path(), "README.md", b"# fresh\n");
583
    client.commit("First change", &[]).unwrap();
584
    assert!(client.push("hub", false).unwrap().iter().all(|r| r.ok));
585
    let page = get(app, "/andy/fresh", Some(&andy)).await;
586
    assert!(!page.body.contains("This repository is empty") && page.body.contains("README.md"), "{}", page.body);
587
}
588
589
#[tokio::test(flavor = "multi_thread")]
590
async fn theme_is_chosen_in_settings_and_remembered_in_a_cookie() {
591
    let h = hub().await;
592
    let app = &h.app;
593
    let andy = register(app, "andy").await;
594
    let page = get(app, "/settings", Some(&andy)).await;
595
    assert!(page.body.contains("Appearance"));
596
    assert!(page.body.contains(r#"value="light" checked"#), "light by default: {}", page.body);
597
    assert!(page.body.contains("data-theme-toggle"), "the header has the switch");
598
    let csrf = csrf_of(&page.body);
599
    let r = post(app, "/settings/appearance", Some(&andy), &format!("_csrf={csrf}&theme=dark")).await;
600
    assert_eq!(r.status, StatusCode::SEE_OTHER);
601
    assert_eq!(r.cookie.as_deref(), Some("dark"));
602
    assert_eq!(r.location.as_deref(), Some("/settings"));
603
    let page = send_with_theme(app, &andy, "dark").await;
604
    assert!(page.contains(r#"value="dark" checked"#), "the form shows the cookie's theme");
605
    assert_eq!(post(app, "/settings/appearance", Some(&andy), &format!("_csrf={csrf}&theme=purple")).await.status, StatusCode::BAD_REQUEST);
606
607
    // The background (docs/backgrounds.md §7): moving by default, kept in
608
    // its own cookie beside the theme.
609
    assert!(get(app, "/settings", Some(&andy)).await.body.contains(r#"name="backdrop" value="moving" checked"#));
610
    let res = oxygenhub::router(app.clone())
611
        .oneshot(
612
            Request::builder()
613
                .method("POST")
614
                .uri("/settings/appearance")
615
                .header(header::COOKIE, format!("oxyhub={andy}"))
616
                .header(header::CONTENT_TYPE, "application/x-www-form-urlencoded")
617
                .body(Body::from(format!("_csrf={csrf}&theme=light&backdrop=still")))
618
                .unwrap(),
619
        )
620
        .await
621
        .unwrap();
622
    let cookies: Vec<&str> = res.headers().get_all(header::SET_COOKIE).iter().filter_map(|v| v.to_str().ok()).collect();
623
    assert!(
624
        cookies.iter().any(|c| c.starts_with("theme=light;")) && cookies.iter().any(|c| c.starts_with("backdrop=still;")),
625
        "{cookies:?}"
626
    );
627
    assert_eq!(
628
        post(app, "/settings/appearance", Some(&andy), &format!("_csrf={csrf}&theme=light&backdrop=wild")).await.status,
629
        StatusCode::BAD_REQUEST
630
    );
631
    assert_eq!(post(app, "/settings/appearance", Some(&andy), "_csrf=nope&theme=light").await.status, StatusCode::BAD_REQUEST);
632
}
633
634
async fn send_with_theme(app: &Shared, session: &str, theme: &str) -> String {
635
    let req =
636
        Request::builder().uri("/settings").header(header::COOKIE, format!("oxyhub={session}; theme={theme}")).body(Body::empty()).unwrap();
637
    let res = oxygenhub::router(app.clone()).oneshot(req).await.unwrap();
638
    String::from_utf8_lossy(&res.into_body().collect().await.unwrap().to_bytes()).into_owned()
639
}
640
641
#[tokio::test(flavor = "multi_thread")]
642
async fn profile_and_organisation_pages() {
643
    let h = hub().await;
644
    let app = &h.app;
645
    let andy = register(app, "andy").await;
646
    let bob = register(app, "bob").await;
647
    let andy_id = db::accounts::account_by_name(&app.db, "andy").await.unwrap().unwrap().id;
648
    let bob_id = db::accounts::account_by_name(&app.db, "bob").await.unwrap().unwrap().id;
649
    app.repos.create(&RepoName::parse("andy/demo").unwrap(), None).unwrap();
650
    db::repos::create(&app.db, "andy", "demo", "A demo", hub_api::Visibility::Public).await.unwrap();
651
    app.repos.create(&RepoName::parse("andy/hidden").unwrap(), None).unwrap();
652
    db::repos::create(&app.db, "andy", "hidden", "", hub_api::Visibility::Private).await.unwrap();
653
654
    // Andy fills in his profile; a script URL and markup are refused or escaped.
655
    let csrf = csrf_of(&get(app, "/settings", Some(&andy)).await.body);
656
    let r = post(app, "/settings", Some(&andy), &format!("_csrf={csrf}&display_name=Andy+McCall&email=a%40example.com&bio=Builds+%3Cb%3Eoxy%3C%2Fb%3E&website=javascript%3Aalert(1)&location=Earth")).await;
657
    assert!(r.body.contains("must be an http"), "{}", r.body);
658
    let r = post(app, "/settings", Some(&andy), &format!("_csrf={csrf}&display_name=Andy+McCall&email=a%40example.com&bio=Builds+%3Cb%3Eoxy%3C%2Fb%3E&website=https%3A%2F%2Fexample.org&location=Earth")).await;
659
    assert!(r.body.contains("Profile saved"), "{}", r.body);
660
661
    let org = db::accounts::create_org(&app.db, "retro", "Retro Club", andy_id).await.unwrap();
662
    db::accounts::set_org_member(&app.db, org.id, bob_id, "member").await.unwrap();
663
    let team = db::accounts::create_team(&app.db, org.id, "core").await.unwrap();
664
    db::accounts::add_team_member(&app.db, team.id, bob_id).await.unwrap();
665
666
    let page = get(app, "/andy", Some(&bob)).await;
667
    assert_eq!(page.status, StatusCode::OK);
668
    for want in ["Andy McCall", "Earth", r#"href="https://example.org""#, "/avatar/andy", "Signing keys", "/retro", "demo"] {
669
        assert!(page.body.contains(want), "profile lacks {want}: {}", page.body);
670
    }
671
    assert!(!page.body.contains("<b>oxy</b>"), "the bio is escaped");
672
    assert!(!page.body.contains("[email protected]"), "the email stays private");
673
    assert!(!page.body.contains("/andy/hidden"), "bob cannot see the private repository");
674
    assert!(!page.body.contains("edit profile"), "only the owner gets the edit link");
675
    assert!(get(app, "/andy", Some(&andy)).await.body.contains("/andy/hidden"), "andy sees his own private repository");
676
677
    let page = get(app, "/retro", Some(&bob)).await;
678
    assert_eq!(page.status, StatusCode::OK);
679
    for want in ["Retro Club", "organisation", r#"Members <span class="count-chip">2</span>"#, "core", "1 member"] {
680
        assert!(page.body.contains(want), "org page lacks {want}: {}", page.body);
681
    }
682
    assert!(!page.body.contains("/orgs/retro/settings"), "bob is not an owner");
683
    assert!(get(app, "/retro", Some(&andy)).await.body.contains("/orgs/retro/settings"));
684
685
    let svg = get(app, "/avatar/andy", None).await;
686
    assert_eq!(svg.status, StatusCode::OK);
687
    assert!(svg.body.starts_with("<svg"));
688
    assert_eq!(svg.body, get(app, "/avatar/ANDY", None).await.body);
689
    assert_eq!(get(app, "/nobody-here", None).await.status, StatusCode::NOT_FOUND);
690
}
691
692
#[tokio::test(flavor = "multi_thread")]
693
async fn diffs_mark_words_hide_whitespace_and_collapse() {
694
    let h = hub().await;
695
    let app = &h.app;
696
    let andy = register(app, "andy").await;
697
    app.repos.create(&RepoName::parse("andy/demo").unwrap(), None).unwrap();
698
    db::repos::create(&app.db, "andy", "demo", "", hub_api::Visibility::Public).await.unwrap();
699
    let work = tempfile::tempdir().unwrap();
700
    let mut client = Repo::init(work.path()).unwrap();
701
    client.config.set("remote.hub.url", &format!("{}/andy/demo", h.base)).unwrap();
702
    client.config.set("remote.hub.token", "site").unwrap();
703
    client.save_config().unwrap();
704
    write(work.path(), "main.rs", b"fn main() {\n  setup();\n  let answer = 42;\n}\n");
705
    client.commit("first", &[]).unwrap();
706
    write(work.path(), "main.rs", b"fn main() {\n    setup();\n  let answer = 43;\n}\n");
707
    let second = client.commit("reindent and change the answer", &[]).unwrap();
708
    assert!(client.push("hub", false).unwrap().iter().all(|r| r.ok));
709
710
    let url = format!("/andy/demo/change/{}", second.to_hex());
711
    let page = get(app, &url, Some(&andy)).await;
712
    assert_eq!(page.status, StatusCode::OK);
713
    assert!(page.body.contains(r#"<details class="file-diff""#), "files collapse: {}", page.body);
714
    assert!(page.body.contains(r#"<span class="wx">43</span>"#), "the changed word is marked: {}", page.body);
715
    assert!(page.body.contains("hide whitespace changes"));
716
    assert!(page.body.contains("data-diff-mode=\"split\""));
717
    let adds = |b: &str| b.matches(r#"<tr class="add">"#).count();
718
    assert_eq!(adds(&page.body), 2, "re-indent and answer both changed");
719
720
    let quiet = get(app, &format!("{url}?w=1"), Some(&andy)).await;
721
    assert_eq!(adds(&quiet.body), 1, "only the answer changed ignoring whitespace: {}", quiet.body);
722
    assert!(quiet.body.contains("show whitespace changes"));
723
724
    assert!(quiet.body.contains("?w=0"), "the toggle leads back");
725
}
726
727
#[tokio::test(flavor = "multi_thread")]
728
async fn fork_and_propose_upstream() {
729
    let h = hub().await;
730
    let app = &h.app;
731
    let andy = register(app, "andy").await;
732
    let bob = register(app, "bob").await;
733
    app.repos.create(&RepoName::parse("andy/demo").unwrap(), None).unwrap();
734
    db::repos::create(&app.db, "andy", "demo", "The demo", hub_api::Visibility::Public).await.unwrap();
735
    let work = tempfile::tempdir().unwrap();
736
    let mut client = Repo::init(work.path()).unwrap();
737
    client.config.set("remote.hub.url", &format!("{}/andy/demo", h.base)).unwrap();
738
    client.config.set("remote.hub.token", "site").unwrap();
739
    client.save_config().unwrap();
740
    write(work.path(), "README.md", b"# demo\n");
741
    client.commit("first", &[]).unwrap();
742
    assert!(client.push("hub", false).unwrap().iter().all(|r| r.ok));
743
744
    // Bob forks it; he cannot fork into Andy's name.
745
    let page = get(app, "/andy/demo", Some(&bob)).await;
746
    assert!(page.body.contains("/andy/demo/fork"), "a fork button: {}", page.body);
747
    let csrf = csrf_of(&get(app, "/andy/demo/fork", Some(&bob)).await.body);
748
    let r = post(app, "/andy/demo/fork", Some(&bob), &format!("_csrf={csrf}&owner=andy&name=other")).await;
749
    assert!(r.body.contains("cannot create repositories under that owner"), "{}", r.body);
750
    let r = post(app, "/andy/demo/fork", Some(&bob), &format!("_csrf={csrf}&owner=bob&name=demo")).await;
751
    assert_eq!(r.status, StatusCode::SEE_OTHER, "{}", r.body);
752
    assert_eq!(r.location.as_deref(), Some("/bob/demo"));
753
    let forked = get(app, "/bob/demo", Some(&bob)).await;
754
    assert!(forked.body.contains("README.md") && forked.body.contains("forked from"), "{}", forked.body);
755
    assert!(forked.body.contains("propose to andy/demo"));
756
    assert!(get(app, "/andy/demo", None).await.body.contains("1 fork"));
757
    assert!(get(app, "/andy/demo/forks", None).await.body.contains("/bob/demo"));
758
    let fork_row = db::repos::get(&app.db, "bob", "demo").await.unwrap().unwrap();
759
    let up_row = db::repos::get(&app.db, "andy", "demo").await.unwrap().unwrap();
760
    assert_eq!(fork_row.forked_from, Some(up_row.id));
761
    assert_eq!(fork_row.description, "The demo");
762
    let fork_repo = app.repos.open(&RepoName::parse("bob/demo").unwrap()).unwrap();
763
    let up_repo = app.repos.open(&RepoName::parse("andy/demo").unwrap()).unwrap();
764
    assert_ne!(fork_repo.id().unwrap(), up_repo.id().unwrap(), "a fork is a repository of its own");
765
    assert_eq!(fork_repo.bookmark_heads().unwrap(), up_repo.bookmark_heads().unwrap());
766
    assert_eq!(fork_repo.fsck().unwrap().errors(), 0);
767
768
    // Bob works in a clone of his fork, pushes a bookmark, and proposes it upstream.
769
    let bw = tempfile::tempdir().unwrap();
770
    let mut mine = Repo::clone(&format!("{}/bob/demo", h.base), &bw.path().join("c")).unwrap();
771
    mine.config.set("remote.origin.token", "site").unwrap();
772
    mine.save_config().unwrap();
773
    mine.bookmark_create("feat", None).unwrap();
774
    mine.bookmark_switch("feat", false).unwrap();
775
    write(&bw.path().join("c"), "feature.txt", b"new\n");
776
    mine.commit("Add a feature", &[]).unwrap();
777
    assert!(mine.push_bookmark("origin", "feat", false).unwrap().iter().all(|r| r.ok));
778
    let csrf = csrf_of(&get(app, "/andy/demo/proposals/new?source=bob/demo:feat", Some(&bob)).await.body);
779
    let r =
780
        post(app, "/andy/demo/proposals/new", Some(&bob), &format!("_csrf={csrf}&title=From+my+fork&target=main&source=bob%2Fdemo%3Afeat"))
781
            .await;
782
    assert_eq!(r.status, StatusCode::SEE_OTHER, "{}", r.body);
783
    let p = get(app, &r.location.unwrap(), Some(&andy)).await;
784
    assert!(p.body.contains("From my fork") && p.body.contains("fork bob/demo"), "{}", p.body);
785
    let files = get(app, "/andy/demo/proposal/1?tab=files", Some(&andy)).await;
786
    assert!(files.body.contains("feature.txt"), "{}", files.body);
787
}
788
789
#[tokio::test(flavor = "multi_thread")]
790
async fn stars_topics_and_explore() {
791
    let h = hub().await;
792
    let app = &h.app;
793
    let andy = register(app, "andy").await;
794
    let bob = register(app, "bob").await;
795
    for (name, desc) in [("alpha", "An emulator"), ("beta", "A compiler"), ("gamma", "Retro games")] {
796
        app.repos.create(&RepoName::parse(&format!("andy/{name}")).unwrap(), None).unwrap();
797
        db::repos::create(&app.db, "andy", name, desc, hub_api::Visibility::Public).await.unwrap();
798
    }
799
800
    // Topics through settings; bad ones are refused.
801
    let csrf = csrf_of(&get(app, "/andy/gamma/settings", Some(&andy)).await.body);
802
    let r = post(
803
        app,
804
        "/andy/gamma/settings",
805
        Some(&andy),
806
        &format!("_csrf={csrf}&description=Retro+games&default_bookmark=main&visibility=public&topics=c%2B%2B"),
807
    )
808
    .await;
809
    let r = settled(app, r, Some(&andy), "/andy/gamma/settings/general").await;
810
    assert!(r.body.contains("is not a topic"), "{}", r.body);
811
    let r = post(
812
        app,
813
        "/andy/gamma/settings",
814
        Some(&andy),
815
        &format!("_csrf={csrf}&description=Retro+games&default_bookmark=main&visibility=public&topics=Retro%2C+6502"),
816
    )
817
    .await;
818
    let r = settled(app, r, Some(&andy), "/andy/gamma/settings/general").await;
819
    assert!(r.body.contains("Saved"), "{}", r.body);
820
    assert_eq!(db::repos::get(&app.db, "andy", "gamma").await.unwrap().unwrap().topics, "retro 6502");
821
    let page = get(app, "/andy/gamma", None).await;
822
    assert!(page.body.contains(r#"href="/explore?topic=retro""#), "{}", page.body);
823
824
    // Stars: bob stars beta and gamma, andy stars gamma; toggling unstars.
825
    for (who, repo) in [(&bob, "beta"), (&bob, "gamma"), (&andy, "gamma"), (&andy, "alpha")] {
826
        let csrf = csrf_of(&get(app, &format!("/andy/{repo}"), Some(who)).await.body);
827
        assert_eq!(post(app, &format!("/andy/{repo}/star"), Some(who), &format!("_csrf={csrf}")).await.status, StatusCode::SEE_OTHER);
828
    }
829
    let csrf = csrf_of(&get(app, "/andy/alpha", Some(&andy)).await.body);
830
    post(app, "/andy/alpha/star", Some(&andy), &format!("_csrf={csrf}")).await;
831
    assert!(get(app, "/andy/gamma", Some(&bob)).await.body.contains("★ UNSTAR"));
832
    assert!(get(app, "/andy/gamma", None).await.body.contains(r#"title="2 stars">"#));
833
    assert!(get(app, "/andy/alpha", None).await.body.contains(r#"title="0 stars">"#), "unstarred again");
834
835
    // Explore: sort by stars, by name, filter by text and by topic.
836
    let order = |b: &str| {
837
        ["alpha", "beta", "gamma"]
838
            .into_iter()
839
            .map(|n| (b.find(&format!("/andy/{n}\"")).unwrap_or(usize::MAX), n))
840
            .collect::<std::collections::BTreeMap<_, _>>()
841
            .into_values()
842
            .collect::<Vec<_>>()
843
    };
844
    assert_eq!(order(&get(app, "/explore?sort=stars", None).await.body)[..2], ["gamma", "beta"]);
845
    assert_eq!(order(&get(app, "/explore?sort=name", None).await.body), ["alpha", "beta", "gamma"]);
846
    let filtered = get(app, "/explore?q=compiler", None).await.body;
847
    assert!(filtered.contains("/andy/beta\"") && !filtered.contains("/andy/alpha\""), "{filtered}");
848
    let by_topic = get(app, "/explore?topic=6502", None).await.body;
849
    assert!(by_topic.contains("/andy/gamma\"") && !by_topic.contains("/andy/beta\""), "{by_topic}");
850
}
851
852
#[tokio::test(flavor = "multi_thread")]
853
async fn lists_filter_sort_page_and_count() {
854
    let h = hub().await;
855
    let app = &h.app;
856
    let andy = register(app, "andy").await;
857
    let _bob = register(app, "bob").await;
858
    app.repos.create(&RepoName::parse("andy/demo").unwrap(), None).unwrap();
859
    let repo = db::repos::create(&app.db, "andy", "demo", "", hub_api::Visibility::Public).await.unwrap();
860
    for n in 0..30 {
861
        let author = if n % 3 == 0 { "bob" } else { "andy" };
862
        db::issues::create(
863
            &app.db,
864
            db::issues::NewIssue { repo_id: repo.id, title: &format!("Issue number {n}"), body: "", author_id: None, author },
865
        )
866
        .await
867
        .unwrap();
868
    }
869
    let ui = db::issues::upsert_label(&app.db, repo.id, "ui", "#00f0ff", "").await.unwrap();
870
    for (title, author, target) in [("Faster menus", "bob", "main"), ("New theme", "andy", "main"), ("Release prep", "andy", "stable")] {
871
        let p = db::proposals::create(
872
            &app.db,
873
            db::proposals::NewProposal {
874
                repo_id: repo.id,
875
                title,
876
                body: "",
877
                author_id: None,
878
                author,
879
                draft: false,
880
                target,
881
                source_kind: "changes",
882
                source_repo_id: None,
883
                source_bookmark: "",
884
                source_changes: "",
885
            },
886
        )
887
        .await
888
        .unwrap();
889
        if title == "New theme" {
890
            db::issues::set_proposal_label(&app.db, p.id, ui.id, true).await.unwrap();
891
        }
892
    }
893
894
    // The tabs count what is open.
895
    let page = get(app, "/andy/demo/issues", Some(&andy)).await;
896
    assert!(page.body.contains(r#"Issues <span class="count-chip">30</span>"#), "{}", page.body);
897
    assert!(page.body.contains(r#"Proposals <span class="count-chip">3</span>"#));
898
899
    // Pages of 25, newest first; the second page holds the rest.
900
    let rows = |b: &str| b.matches("/andy/demo/issue/").count();
901
    assert_eq!(rows(&page.body), 25);
902
    assert!(page.body.contains("page 1 of 2") && page.body.contains("page=2"), "a pager");
903
    let second = get(app, "/andy/demo/issues?page=2", Some(&andy)).await;
904
    assert_eq!(rows(&second.body), 5);
905
    assert!(second.body.contains("Issue number 0<"), "the oldest are last");
906
    let oldest = get(app, "/andy/demo/issues?sort=oldest", Some(&andy)).await;
907
    assert!(oldest.body.find("Issue number 0<").unwrap() < oldest.body.find("Issue number 1<").unwrap());
908
    let bobs = get(app, "/andy/demo/issues?q=author:bob", Some(&andy)).await;
909
    assert_eq!(rows(&bobs.body), 10, "{}", bobs.body);
910
911
    // Proposals: by author, label and target.
912
    let by_bob = get(app, "/andy/demo/proposals?q=author:bob", Some(&andy)).await.body;
913
    assert!(by_bob.contains("Faster menus") && !by_bob.contains("New theme"));
914
    let ui_only = get(app, "/andy/demo/proposals?q=label:ui", Some(&andy)).await.body;
915
    assert!(ui_only.contains("New theme") && !ui_only.contains("Faster menus") && ui_only.contains(r#"class="label""#));
916
    let stable = get(app, "/andy/demo/proposals?q=target:stable", Some(&andy)).await.body;
917
    assert!(stable.contains("Release prep") && !stable.contains("New theme"));
918
}
919
920
#[tokio::test(flavor = "multi_thread")]
921
async fn project_boards() {
922
    let h = hub().await;
923
    let app = &h.app;
924
    let andy = register(app, "andy").await;
925
    let bob = register(app, "bob").await;
926
    for (name, vis) in [("demo", hub_api::Visibility::Public), ("secret", hub_api::Visibility::Private)] {
927
        app.repos.create(&RepoName::parse(&format!("andy/{name}")).unwrap(), None).unwrap();
928
        let row = db::repos::create(&app.db, "andy", name, "", vis).await.unwrap();
929
        db::issues::create(
930
            &app.db,
931
            db::issues::NewIssue { repo_id: row.id, title: &format!("{name} issue"), body: "", author_id: None, author: "andy" },
932
        )
933
        .await
934
        .unwrap();
935
    }
936
    // Found from anywhere (#119): the site bar and the owner's profile (no
937
    // longer the repository's tabs, #254), and a New project button on the
938
    // list; a stranger is told who can make one.
939
    let home = get(app, "/andy/demo", Some(&andy)).await.body;
940
    assert!(home.contains("href=\"/projects/andy\"><svg class=\"ic\""), "site bar");
941
    assert!(!home.contains("project boards\">Projects</a>"), "not a repository tab");
942
    assert!(get(app, "/andy", Some(&bob)).await.body.contains("href=\"/projects/andy\">Projects</a>"), "the owner's profile");
943
    let list = get(app, "/projects/andy", Some(&andy)).await.body;
944
    assert!(list.contains("href=\"#new\">+ NEW PROJECT</a>") && list.contains("id=\"new\""), "the button and the form");
945
    assert!(get(app, "/projects/andy", Some(&bob)).await.body.contains("Only andy"), "who can make one");
946
    let csrf = csrf_of(&list);
947
    let r = post(app, "/projects/andy", Some(&andy), &format!("_csrf={csrf}&title=Roadmap&description=Next+steps")).await;
948
    assert_eq!(r.location.as_deref(), Some("/projects/andy/1"), "{}", r.body);
949
    // The list (#124): a row per project, counted under Open, and a filter.
950
    let list = get(app, "/projects/andy", Some(&andy)).await.body;
951
    assert!(
952
        list.contains(">Roadmap</a>") && list.contains("Next steps") && list.contains("Open <span class=\"count-chip\">1</span>"),
953
        "{list}"
954
    );
955
    let filtered = get(app, "/projects/andy?q=roadm", Some(&andy)).await.body;
956
    assert!(filtered.contains(">Roadmap</a>"), "a filter matches part of the title, any case");
957
    let none = get(app, "/projects/andy?q=nothing+like+it", Some(&andy)).await.body;
958
    assert!(none.contains("No open project matches") && !none.contains(">Roadmap</a>"), "{none}");
959
    let closed = get(app, "/projects/andy?state=closed", Some(&andy)).await.body;
960
    assert!(closed.contains("No closed projects.") && closed.contains("Closed <span class=\"count-chip\">0</span>"), "{closed}");
961
    let board = get(app, "/projects/andy/1", Some(&andy)).await.body;
962
    for col in ["Backlog", "Doing", "Done"] {
963
        assert!(board.contains(&format!(">{col} <span")), "{col}");
964
    }
965
    let cols: Vec<i64> = sqlx::query_scalar("SELECT id FROM project_columns ORDER BY position").fetch_all(&app.db).await.unwrap();
966
    let act = |form: String| {
967
        let andy = andy.clone();
968
        async move { post(app, "/projects/andy/1", Some(&andy), &form).await }
969
    };
970
    // Cards: by reference, by repository and number, a note; duplicates and strangers refused.
971
    assert_eq!(
972
        act(format!("_csrf={csrf}&action=add&column={}&reference=demo%231", cols[0])).await.location.as_deref(),
973
        Some("/projects/andy/1")
974
    );
975
    act(format!("_csrf={csrf}&action=add&column={}&repo=secret&reference=%231", cols[0])).await;
976
    act(format!("_csrf={csrf}&action=add&column={}&note=Write+the+docs", cols[1])).await;
977
    assert!(act(format!("_csrf={csrf}&action=add&column={}&reference=demo%231", cols[1])).await.body.contains("already on this project"));
978
    assert!(act(format!("_csrf={csrf}&action=add&column={}&reference=demo%2399", cols[0])).await.body.contains("no issue or proposal #99"));
979
    assert!(act(format!("_csrf={csrf}&action=add&column={}&reference=nothere%231", cols[0])).await.body.contains("no repository nothere"));
980
    // Move demo#1 to Done.
981
    let demo_card: i64 =
982
        sqlx::query_scalar("SELECT c.id FROM project_cards c JOIN repositories r ON r.id = c.repo_id WHERE r.name = 'demo'")
983
            .fetch_one(&app.db)
984
            .await
985
            .unwrap();
986
    act(format!("_csrf={csrf}&action=move&card={demo_card}&column={}", cols[2])).await;
987
    let issue = get(app, "/andy/demo/issue/1", None).await.body;
988
    assert!(issue.contains("href=\"/projects/andy/1\">Roadmap</a> <span class=\"mute\">· Done"), "the issue shows where it is");
989
990
    // Readers see public cards, never those of repositories they cannot read.
991
    let anon = get(app, "/projects/andy/1", None).await.body;
992
    assert!(anon.contains("demo issue") && anon.contains("Write the docs") && !anon.contains("secret issue"), "{anon}");
993
    assert!(!anon.contains("name=\"action\""), "and cannot change anything");
994
    assert!(get(app, "/projects/andy/1", Some(&andy)).await.body.contains("secret issue"));
995
    // Only the owner changes it; a private project is invisible to others.
996
    let csrf_b = csrf_of(&get(app, "/settings", Some(&bob)).await.body);
997
    assert_eq!(
998
        post(app, "/projects/andy/1", Some(&bob), &format!("_csrf={csrf_b}&action=remove&card={demo_card}")).await.status,
999
        StatusCode::NOT_FOUND
1000
    );
1001
    act(format!("_csrf={csrf}&action=settings&title=Roadmap&description=&private=1")).await;
1002
    assert_eq!(get(app, "/projects/andy/1", Some(&bob)).await.status, StatusCode::NOT_FOUND);
1003
    assert!(!get(app, "/projects/andy", None).await.body.contains("Roadmap"), "not even listed");
1004
    assert!(!get(app, "/andy/demo/issue/1", None).await.body.contains("Roadmap"), "nor on the issue");
1005
1006
    // Columns: removing one moves its cards to the first column; the last one stays.
1007
    act(format!("_csrf={csrf}&action=remove_column&column={}", cols[1])).await;
1008
    let note_col: i64 = sqlx::query_scalar("SELECT column_id FROM project_cards WHERE kind = 'note'").fetch_one(&app.db).await.unwrap();
1009
    assert_eq!(note_col, cols[0]);
1010
    act(format!("_csrf={csrf}&action=remove_column&column={}", cols[2])).await;
1011
    assert!(act(format!("_csrf={csrf}&action=remove_column&column={}", cols[0])).await.body.contains("at least one column"));
1012
    // Closed projects are read-only until reopened; then deleted, the issues remain.
1013
    act(format!("_csrf={csrf}&action=settings&title=Roadmap&closed=1")).await;
1014
    assert!(act(format!("_csrf={csrf}&action=add&column={}&note=late", cols[0])).await.body.contains("This project is closed"));
1015
    let r = act(format!("_csrf={csrf}&action=delete")).await;
1016
    assert_eq!(r.location.as_deref(), Some("/projects/andy"));
1017
    assert_eq!(get(app, "/projects/andy/1", Some(&andy)).await.status, StatusCode::NOT_FOUND);
1018
    assert_eq!(get(app, "/andy/demo/issue/1", None).await.status, StatusCode::OK);
1019
    assert_eq!(get(app, "/projects/nobody", None).await.status, StatusCode::NOT_FOUND);
1020
}
1021
1022
/// #293: a long column shows its newest cards, says how many older ones it
1023
/// leaves out and links to them all; a filter finds cards in any column.
1024
#[tokio::test(flavor = "multi_thread")]
1025
async fn a_long_column_shows_its_newest_cards() {
1026
    let h = hub().await;
1027
    let app = &h.app;
1028
    let andy = register(app, "andy").await;
1029
    let csrf = csrf_of(&get(app, "/projects/andy", Some(&andy)).await.body);
1030
    post(app, "/projects/andy", Some(&andy), &format!("_csrf={csrf}&title=Roadmap")).await;
1031
    let (project, done): (i64, i64) =
1032
        sqlx::query_as("SELECT p.id, c.id FROM projects p JOIN project_columns c ON c.project_id = p.id WHERE c.name = 'Done'")
1033
            .fetch_one(&app.db)
1034
            .await
1035
            .unwrap();
1036
    for i in 1..=35 {
1037
        sqlx::query(
1038
            "INSERT INTO project_cards (project_id, column_id, position, kind, note, created_ms) VALUES ($1, $2, $3, 'note', $4, 0)",
1039
        )
1040
        .bind(project)
1041
        .bind(done)
1042
        .bind(i)
1043
        .bind(format!("card-{i:03}"))
1044
        .execute(&app.db)
1045
        .await
1046
        .unwrap();
1047
    }
1048
    let board = get(app, "/projects/andy/1", Some(&andy)).await.body;
1049
    assert!(board.contains("5 older cards not shown") && board.contains(&format!("?all={done}#col-{done}\">show all 35</a>")), "{board}");
1050
    assert!(board.contains("card-006") && board.contains("card-035") && !board.contains("card-005"), "the newest 30");
1051
    assert!(board.contains(">35</span></h2>"), "the count is the column's");
1052
    let all = get(app, &format!("/projects/andy/1?all={done}"), Some(&andy)).await.body;
1053
    assert!(all.contains("card-001") && !all.contains("older cards not shown"), "show all");
1054
    let found = get(app, "/projects/andy/1?q=CARD-002", Some(&andy)).await.body;
1055
    assert!(found.contains("card-002") && !found.contains("card-030") && found.contains("1 of 35"), "{found}");
1056
    assert!(found.contains(">clear</a>"));
1057
    let open = get(app, "/projects/andy/1?state=open", Some(&andy)).await.body;
1058
    assert!(!open.contains("card-0"), "notes have no state");
1059
}
1060
1061
/// #293: a card shows its issue's labels and assignees, each a link to
1062
/// the board filtered by it, and the filter takes `label:`, `assignee:`
1063
/// and `state:` with words, every term holding.
1064
#[tokio::test(flavor = "multi_thread")]
1065
async fn a_board_filters_by_label_and_assignee() {
1066
    let h = hub().await;
1067
    let app = &h.app;
1068
    let andy = register(app, "andy").await;
1069
    let csrf = csrf_of(&get(app, "/projects/andy", Some(&andy)).await.body);
1070
    post(app, "/projects/andy", Some(&andy), &format!("_csrf={csrf}&title=Roadmap")).await;
1071
    app.repos.create(&RepoName::parse("andy/game").unwrap(), None).unwrap();
1072
    let row = db::repos::create(&app.db, "andy", "game", "", hub_api::Visibility::Public).await.unwrap();
1073
    let mut ids = Vec::new();
1074
    for title in ["Sound crackles", "Jump is floaty", "Title screen"] {
1075
        let i = db::issues::create(&app.db, db::issues::NewIssue { repo_id: row.id, title, body: "", author_id: None, author: "andy" })
1076
            .await
1077
            .unwrap();
1078
        ids.push(i.id);
1079
    }
1080
    let bug = db::issues::upsert_label(&app.db, row.id, "bug", "#d73a4a", "Something is wrong").await.unwrap();
1081
    let feel = db::issues::upsert_label(&app.db, row.id, "feel", "#0e8a16", "").await.unwrap();
1082
    db::issues::set_issue_label(&app.db, ids[0], bug.id, true).await.unwrap();
1083
    db::issues::set_issue_label(&app.db, ids[1], bug.id, true).await.unwrap();
1084
    db::issues::set_issue_label(&app.db, ids[1], feel.id, true).await.unwrap();
1085
    let (andy_id,): (i64,) = sqlx::query_as("SELECT id FROM accounts WHERE username = 'andy'").fetch_one(&app.db).await.unwrap();
1086
    db::issues::set_assignee(&app.db, ids[1], andy_id, true).await.unwrap();
1087
    let (project, todo): (i64, i64) =
1088
        sqlx::query_as("SELECT p.id, c.id FROM projects p JOIN project_columns c ON c.project_id = p.id ORDER BY c.position LIMIT 1")
1089
            .fetch_one(&app.db)
1090
            .await
1091
            .unwrap();
1092
    for n in 1..=3i64 {
1093
        sqlx::query(
1094
            "INSERT INTO project_cards (project_id, column_id, position, kind, repo_id, number, note, created_ms) VALUES ($1, $2, $3, 'issue', $4, $5, '', 0)",
1095
        )
1096
        .bind(project)
1097
        .bind(todo)
1098
        .bind(n)
1099
        .bind(row.id)
1100
        .bind(n)
1101
        .execute(&app.db)
1102
        .await
1103
        .unwrap();
1104
    }
1105
    let board = get(app, "/projects/andy/1", Some(&andy)).await.body;
1106
    assert!(board.contains("href=\"/projects/andy/1?q=label:bug\""), "{board}");
1107
    assert!(board.contains("title=\"Something is wrong\">bug</a>"), "a label's description is its title");
1108
    assert!(board.contains(">@andy</a>"), "{board}");
1109
    let bugs = get(app, "/projects/andy/1?q=label:bug", Some(&andy)).await.body;
1110
    assert!(bugs.contains("Sound crackles") && bugs.contains("Jump is floaty") && !bugs.contains("Title screen"), "{bugs}");
1111
    assert!(bugs.contains("2 of 3"));
1112
    let both = get(app, "/projects/andy/1?q=label:BUG+label:feel", Some(&andy)).await.body;
1113
    assert!(!both.contains("Sound crackles") && both.contains("Jump is floaty"), "every label must hold");
1114
    let mine = get(app, "/projects/andy/1?q=assignee:%40andy", Some(&andy)).await.body;
1115
    assert!(mine.contains("Jump is floaty") && !mine.contains("Sound crackles"), "{mine}");
1116
    let words = get(app, "/projects/andy/1?q=label:bug+sound", Some(&andy)).await.body;
1117
    assert!(words.contains("Sound crackles") && !words.contains("Jump is floaty"));
1118
    let closed = get(app, "/projects/andy/1?q=state:closed", Some(&andy)).await.body;
1119
    assert!(closed.contains("0 of 3"), "{closed}");
1120
}
1121
1122
/// #293: a card is archived off the board, kept and found on the archive
1123
/// view, and restored; a column archives its cards older than some days
1124
/// at once, or on its own once set to; an issue's page says its card is
1125
/// archived.
1126
#[tokio::test(flavor = "multi_thread")]
1127
async fn board_cards_are_archived_and_restored() {
1128
    let h = hub().await;
1129
    let app = &h.app;
1130
    let andy = register(app, "andy").await;
1131
    let csrf = csrf_of(&get(app, "/projects/andy", Some(&andy)).await.body);
1132
    post(app, "/projects/andy", Some(&andy), &format!("_csrf={csrf}&title=Roadmap")).await;
1133
    let (project, done): (i64, i64) =
1134
        sqlx::query_as("SELECT p.id, c.id FROM projects p JOIN project_columns c ON c.project_id = p.id WHERE c.name = 'Done'")
1135
            .fetch_one(&app.db)
1136
            .await
1137
            .unwrap();
1138
    let day = 86_400_000i64;
1139
    let now = db::now_ms();
1140
    for (i, age) in [40, 20, 10, 1].iter().enumerate() {
1141
        sqlx::query(
1142
            "INSERT INTO project_cards (project_id, column_id, position, kind, note, created_ms, moved_ms) VALUES ($1, $2, $3, 'note', $4, 0, $5)",
1143
        )
1144
        .bind(project)
1145
        .bind(done)
1146
        .bind(i as i64)
1147
        .bind(format!("aged-{age}"))
1148
        .bind(now - age * day)
1149
        .execute(&app.db)
1150
        .await
1151
        .unwrap();
1152
    }
1153
    let id_of = |note: &'static str| async move {
1154
        sqlx::query_scalar::<_, i64>("SELECT id FROM project_cards WHERE note = $1").bind(note).fetch_one(&app.db).await.unwrap()
1155
    };
1156
    let board = "/projects/andy/1";
1157
    let (who, token) = (&andy, &csrf);
1158
    let act = |body: String| async move { post(app, board, Some(who), &format!("_csrf={token}&{body}")).await };
1159
1160
    // One card by hand: off the board, on the archive view, restorable.
1161
    let forty = id_of("aged-40").await;
1162
    act(format!("action=archive&card={forty}")).await;
1163
    let page = get(app, board, Some(&andy)).await.body;
1164
    assert!(!page.contains("aged-40") && page.contains("aged-20"), "{page}");
1165
    assert!(page.contains("?archived=1\">1 archived card</a>"), "{page}");
1166
    let archived = get(app, &format!("{board}?archived=1"), Some(&andy)).await.body;
1167
    assert!(archived.contains("aged-40") && !archived.contains("aged-20"), "{archived}");
1168
    assert!(archived.contains("value=\"restore\"") && archived.contains("Back to the board"));
1169
    assert!(!archived.contains("add a card"), "the archive view adds nothing");
1170
    let found = get(app, &format!("{board}?archived=1&q=aged-40"), Some(&andy)).await.body;
1171
    assert!(found.contains("1 of 1") && found.contains("name=\"archived\" value=\"1\""), "{found}");
1172
    act(format!("action=restore&card={forty}")).await;
1173
    assert!(get(app, board, Some(&andy)).await.body.contains("aged-40"));
1174
1175
    // The column's cards there more than 15 days, at once: 40 (just
1176
    // restored, so it joined again now) stays, 20 goes.
1177
    let r = act(format!("action=archive_older&column={done}&days=15")).await;
1178
    assert!(r.body.contains("Archived 1 card from Done."), "{}", r.body);
1179
    let page = get(app, board, Some(&andy)).await.body;
1180
    assert!(page.contains("aged-40") && !page.contains("aged-20") && page.contains("aged-10"));
1181
    let r = act(format!("action=archive_older&column={done}&days=soon")).await;
1182
    assert!(r.body.contains("Give a number of days"), "{}", r.body);
1183
1184
    // On its own: Done after 5 days; the hourly pass takes aged-10 only.
1185
    let r = act(format!("action=archive_after&column={done}&days=5")).await;
1186
    assert!(r.body.contains("Done archives its cards 5 days after they reach it."), "{}", r.body);
1187
    assert!(get(app, board, Some(&andy)).await.body.contains("archives cards 5 days after they reach it"));
1188
    assert_eq!(db::projects::archive_due(&app.db, db::now_ms()).await.unwrap(), 1);
1189
    let page = get(app, board, Some(&andy)).await.body;
1190
    assert!(page.contains("aged-40") && !page.contains("aged-10") && page.contains("aged-1<"), "{page}");
1191
    assert!(page.contains("2 archived cards"));
1192
    let r = act(format!("action=archive_after&column={done}&mode=never")).await;
1193
    assert!(r.body.contains("Done keeps its cards until you archive them."));
1194
    assert_eq!(db::projects::archive_due(&app.db, db::now_ms() + 100 * day).await.unwrap(), 0, "never, now");
1195
1196
    // The default (#293, Andy 2026-10-25): finished work, a closed issue,
1197
    // goes a fortnight after it reached its column; open work and notes stay.
1198
    let r = act(format!("action=archive_after&column={done}&mode=finished")).await;
1199
    assert!(r.body.contains("Done archives finished cards 14 days after they reach it."), "{}", r.body);
1200
    db::repos::create(&app.db, "andy", "demo", "", hub_api::Visibility::Public).await.unwrap();
1201
    let repo = db::repos::get(&app.db, "andy", "demo").await.unwrap().unwrap();
1202
    let mut cards = vec![];
1203
    for title in ["shipped", "still open"] {
1204
        let i = db::issues::create(&app.db, db::issues::NewIssue { repo_id: repo.id, title, body: "", author_id: None, author: "andy" })
1205
            .await
1206
            .unwrap();
1207
        if title == "shipped" {
1208
            db::issues::set_state(&app.db, i.id, "closed", "completed").await.unwrap();
1209
        }
1210
        let id: i64 = sqlx::query_scalar(
1211
            "INSERT INTO project_cards (project_id, column_id, position, kind, repo_id, number, note, created_ms, moved_ms) \
1212
             VALUES ($1, $2, 10, 'issue', $3, $4, '', 0, $5) RETURNING id",
1213
        )
1214
        .bind(project)
1215
        .bind(done)
1216
        .bind(repo.id)
1217
        .bind(i.number)
1218
        .bind(now - 20 * day)
1219
        .fetch_one(&app.db)
1220
        .await
1221
        .unwrap();
1222
        cards.push(id);
1223
    }
1224
    assert_eq!(db::projects::archive_due(&app.db, db::now_ms()).await.unwrap(), 1, "the closed issue only");
1225
    let archived_ms = |id: i64| async move {
1226
        sqlx::query_scalar::<_, Option<i64>>("SELECT archived_ms FROM project_cards WHERE id = $1")
1227
            .bind(id)
1228
            .fetch_one(&app.db)
1229
            .await
1230
            .unwrap()
1231
    };
1232
    assert!(archived_ms(cards[0]).await.is_some() && archived_ms(cards[1]).await.is_none());
1233
    let page = get(app, board, Some(&andy)).await.body;
1234
    assert!(page.contains("value=\"finished\" selected"), "the column says so");
1235
}
1236
1237
#[tokio::test(flavor = "multi_thread")]
1238
async fn issue_markdown_follows_the_default_bookmark() {
1239
    let h = hub().await;
1240
    let app = &h.app;
1241
    register(app, "andy").await;
1242
    app.repos.create(&RepoName::parse("andy/trunky").unwrap(), None).unwrap();
1243
    let row = db::repos::create(&app.db, "andy", "trunky", "", hub_api::Visibility::Public).await.unwrap();
1244
    sqlx::query("UPDATE repositories SET default_bookmark = 'trunk' WHERE id = $1").bind(row.id).execute(&app.db).await.unwrap();
1245
    db::issues::create(
1246
        &app.db,
1247
        db::issues::NewIssue {
1248
            repo_id: row.id,
1249
            title: "Docs",
1250
            body: "See [the guide](docs/guide.md) and ![shot](img/a.png).",
1251
            author_id: None,
1252
            author: "andy",
1253
        },
1254
    )
1255
    .await
1256
    .unwrap();
1257
    let page = get(app, "/andy/trunky/issue/1", None).await.body;
1258
    assert!(page.contains("href=\"/andy/trunky/file/trunk/docs/guide.md\""), "{page}");
1259
    assert!(page.contains("src=\"/andy/trunky/raw/trunk/img/a.png\""));
1260
    assert!(!page.contains("/file/main/"));
1261
}
1262
1263
/// #125: a board moves to an owner its user may make boards under, takes the
1264
/// next number there with its cards, and its old address redirects to it; a
1265
/// new board at the old address takes it over.
1266
#[tokio::test(flavor = "multi_thread")]
1267
async fn a_project_transfers_to_an_organisation() {
1268
    let h = hub().await;
1269
    let app = &h.app;
1270
    // The first account is the site's administrator, who may make boards
1271
    // anywhere: Andy is an ordinary user here.
1272
    let _first = register(app, "ada").await;
1273
    let andy = register(app, "andy").await;
1274
    let _bob = register(app, "bob").await;
1275
    let andy_id = db::accounts::account_by_name(&app.db, "andy").await.unwrap().unwrap().id;
1276
    let bob_id = db::accounts::account_by_name(&app.db, "bob").await.unwrap().unwrap().id;
1277
    db::accounts::create_org(&app.db, "retro", "Retro Club", andy_id).await.unwrap();
1278
    db::accounts::create_org(&app.db, "other", "Someone else's", bob_id).await.unwrap();
1279
    let list = get(app, "/projects/andy", Some(&andy)).await.body;
1280
    let csrf = csrf_of(&list);
1281
    let r = post(app, "/projects/andy", Some(&andy), &format!("_csrf={csrf}&title=Roadmap")).await;
1282
    assert_eq!(r.location.as_deref(), Some("/projects/andy/1"));
1283
    post(app, "/projects/andy/1", Some(&andy), &format!("_csrf={csrf}&action=add&note=Keep+me")).await;
1284
1285
    // Settings offer the organisations Andy belongs to, not other people's.
1286
    let board = get(app, "/projects/andy/1", Some(&andy)).await.body;
1287
    assert!(board.contains("<option value=\"retro\">retro</option>") && !board.contains("value=\"other\""), "{board}");
1288
    let refused = post(app, "/projects/andy/1", Some(&andy), &format!("_csrf={csrf}&action=transfer&to=other")).await;
1289
    assert!(refused.body.contains("You cannot make projects under other"), "{}", refused.body);
1290
1291
    let r = post(app, "/projects/andy/1", Some(&andy), &format!("_csrf={csrf}&action=transfer&to=retro")).await;
1292
    assert_eq!(r.location.as_deref(), Some("/projects/retro/1"), "{}", r.body);
1293
    let moved = get(app, "/projects/retro/1", Some(&andy)).await.body;
1294
    assert!(moved.contains("Roadmap") && moved.contains("Keep me"), "the cards come too");
1295
    let old = get(app, "/projects/andy/1", Some(&andy)).await;
1296
    assert_eq!(old.status, StatusCode::PERMANENT_REDIRECT);
1297
    assert_eq!(old.location.as_deref(), Some("/projects/retro/1"));
1298
1299
    // A new board of Andy's takes number 1 again, and its own address back.
1300
    let r = post(app, "/projects/andy", Some(&andy), &format!("_csrf={csrf}&title=Fresh")).await;
1301
    assert_eq!(r.location.as_deref(), Some("/projects/andy/1"));
1302
    let fresh = get(app, "/projects/andy/1", Some(&andy)).await;
1303
    assert_eq!(fresh.status, StatusCode::OK);
1304
    assert!(fresh.body.contains("Fresh"));
1305
}
1306
1307
/// Backups' settings (#169): a user's page, its checks, and an
1308
/// organisation's page for its owners only.
1309
#[tokio::test(flavor = "multi_thread")]
1310
async fn backups_are_set_up_in_settings() {
1311
    let h = hub().await;
1312
    let app = &h.app;
1313
    let andy = register(app, "andy").await;
1314
    let page = get(app, "/settings/backups", Some(&andy)).await;
1315
    assert_eq!(page.status, StatusCode::OK);
1316
    assert!(page.body.contains("href=\"/settings/backups\" class=\"on\"") && page.body.contains("No runs yet."), "{}", page.body);
1317
    let csrf = csrf_of(&page.body);
1318
    // This hub allows no directory: only a bucket, and a real provider name.
1319
    let bad = post(
1320
        app,
1321
        "/settings/backups",
1322
        Some(&andy),
1323
        &format!("_csrf={csrf}&every=hourly&destination=gcs&bucket=andy-backup&provider=nope&keep_days=30"),
1324
    )
1325
    .await;
1326
    assert!(bad.body.contains("workload identity provider"), "{}", bad.body);
1327
    let dir =
1328
        post(app, "/settings/backups", Some(&andy), &format!("_csrf={csrf}&every=hourly&destination=dir&dir=%2Ftmp&keep_days=30")).await;
1329
    assert!(dir.body.contains("Pick one of the directories this hub allows."));
1330
    let provider =
1331
        "%2F%2Fiam.googleapis.com%2Fprojects%2F1%2Flocations%2Fglobal%2FworkloadIdentityPools%2Foxygenhub%2Fproviders%2Foxygenhub-io";
1332
    let ok = post(
1333
        app,
1334
        "/settings/backups",
1335
        Some(&andy),
1336
        &format!("_csrf={csrf}&every=hourly&destination=gcs&bucket=gs%3A%2F%2Fandy-backup&provider={provider}&keep_days=7"),
1337
    )
1338
    .await;
1339
    assert!(ok.body.contains("Saved."), "{}", ok.body);
1340
    let s = oxygenhub::backups::setting(&app.db, "andy").await.unwrap().unwrap();
1341
    assert_eq!((s.target.as_str(), s.keep_days, s.every.as_str()), ("andy-backup", 7, "hourly"));
1342
    // An S3 bucket (BP4): its region and the role the hub assumes.
1343
    let bad = post(
1344
        app,
1345
        "/settings/backups",
1346
        Some(&andy),
1347
        &format!("_csrf={csrf}&every=hourly&destination=s3&s3_bucket=andy-backup&s3_region=eu-west-2&s3_role=admin&keep_days=30"),
1348
    )
1349
    .await;
1350
    assert!(bad.body.contains("the IAM role"), "{}", bad.body);
1351
    let role = "arn%3Aaws%3Aiam%3A%3A123456789012%3Arole%2Foxygenhub-backup";
1352
    let ok = post(
1353
        app,
1354
        "/settings/backups",
1355
        Some(&andy),
1356
        &format!(
1357
            "_csrf={csrf}&every=daily&destination=s3&s3_bucket=s3%3A%2F%2Fandy-backup&s3_region=eu-west-2&s3_role={role}&keep_days=30"
1358
        ),
1359
    )
1360
    .await;
1361
    assert!(ok.body.contains("Saved.") && ok.body.contains(r#"value="s3" checked"#), "{}", ok.body);
1362
    let s = oxygenhub::backups::setting(&app.db, "andy").await.unwrap().unwrap();
1363
    assert_eq!((s.destination.as_str(), s.target.as_str(), s.region.as_str()), ("s3", "andy-backup", "eu-west-2"));
1364
    assert_eq!(s.provider, "arn:aws:iam::123456789012:role/oxygenhub-backup");
1365
    // Back to GCS for what follows.
1366
    let ok = post(
1367
        app,
1368
        "/settings/backups",
1369
        Some(&andy),
1370
        &format!("_csrf={csrf}&every=hourly&destination=gcs&bucket=gs%3A%2F%2Fandy-backup&provider={provider}&keep_days=7"),
1371
    )
1372
    .await;
1373
    assert!(ok.body.contains("Saved."));
1374
    // An organisation's backups are its owners' business only.
1375
    let bob = register(app, "bob").await;
1376
    let andy_id = db::accounts::account_by_name(&app.db, "andy").await.unwrap().unwrap().id;
1377
    db::accounts::create_org(&app.db, "club", "Club", andy_id).await.unwrap();
1378
    assert_eq!(get(app, "/orgs/club/settings/backups", Some(&bob)).await.status, StatusCode::NOT_FOUND);
1379
    let club = get(app, "/orgs/club/settings/backups", Some(&andy)).await;
1380
    assert!(club.body.contains("club</a>'s repositories"), "{}", club.body);
1381
    assert!(get(app, "/orgs/club/settings", Some(&andy)).await.body.contains("/orgs/club/settings/backups"));
1382
1383
    // Admin › Backups (docs/backups.md §5): whether each ran, and who has
1384
    // none; administrators only.
1385
    sqlx::query("UPDATE accounts SET is_admin = (username = 'andy')").execute(&app.db).await.unwrap();
1386
    app.repos.create(&oxygenhub::repos::RepoName::parse("bob/game").unwrap(), None).unwrap();
1387
    db::repos::create(&app.db, "bob", "game", "", hub_api::Visibility::Public).await.unwrap();
1388
    assert_eq!(get(app, "/admin/backups", Some(&bob)).await.status, StatusCode::NOT_FOUND);
1389
    let admin = get(app, "/admin/backups", Some(&andy)).await;
1390
    assert_eq!(admin.status, StatusCode::OK);
1391
    assert!(admin.body.contains("gs://andy-backup") && admin.body.contains("hourly") && admin.body.contains("never"), "{}", admin.body);
1392
    let missing = &admin.body[admin.body.find("Not backed up").unwrap()..];
1393
    assert!(missing.contains("href=\"/bob\"") && missing.contains("1 repository"), "{missing}");
1394
    assert!(get(app, "/admin", Some(&andy)).await.body.contains("/admin/backups"));
1395
    // A repository chooses its own (BP3): its owners decide.
1396
    let game = get(app, "/bob/game/settings/backup", Some(&bob)).await;
1397
    assert!(game.body.contains("bob has no backup set up yet") && game.body.contains(r#"name="backup" value="" checked"#), "{}", game.body);
1398
    let csrf = csrf_of(&game.body);
1399
    let saved = post(app, "/bob/game/settings/backup", Some(&bob), &format!("_csrf={csrf}&backup=off")).await;
1400
    let saved = settled(app, saved, Some(&bob), "/bob/game/settings/backup").await;
1401
    assert!(saved.body.contains("left out of its owner"), "{}", saved.body);
1402
    assert_eq!(db::repos::get(&app.db, "bob", "game").await.unwrap().unwrap().backup, "off");
1403
    let bad = post(app, "/bob/game/settings/backup", Some(&bob), &format!("_csrf={csrf}&backup=weekly")).await;
1404
    let bad = settled(app, bad, Some(&bob), "/bob/game/settings/backup").await;
1405
    assert!(bad.body.contains("Pick how this repository is backed up."));
1406
}
1407
1408
/// oxygenhub#183: an owner hears about their repository by default, until
1409
/// they mute it; what an agent does with a token its owner marked is told
1410
/// to that owner; the administrators hear of each new account.
1411
#[tokio::test(flavor = "multi_thread")]
1412
async fn owners_hear_by_default_and_agents_tell_their_owner() {
1413
    let h = hub().await;
1414
    let app = &h.app;
1415
    let andy = register(app, "andy").await;
1416
    let bob = register(app, "bob").await;
1417
    let andy_id = db::accounts::account_by_name(&app.db, "andy").await.unwrap().unwrap().id;
1418
    let kinds = |id: i64| {
1419
        let db = app.db.clone();
1420
        async move { db::notify::inbox(&db, id, 50).await.unwrap().into_iter().map(|n| (n.kind, n.title, n.actor)).collect::<Vec<_>>() }
1421
    };
1422
    assert!(kinds(andy_id).await.iter().any(|(k, t, _)| k == "account.registered" && t.contains("bob")), "the administrator hears of bob");
1423
    let repo = RepoName::parse("andy/demo").unwrap();
1424
    app.repos.create(&repo, None).unwrap();
1425
    db::repos::create(&app.db, "andy", "demo", "", hub_api::Visibility::Public).await.unwrap();
1426
    let open = |who: &'static str, title: &'static str| {
1427
        let (app, cookie) = (app.clone(), if who == "bob" { bob.clone() } else { andy.clone() });
1428
        async move {
1429
            let csrf = csrf_of(&get(&app, "/andy/demo/issues/new", Some(&cookie)).await.body);
1430
            post(&app, "/andy/demo/issues/new", Some(&cookie), &format!("_csrf={csrf}&title={title}&body=x")).await
1431
        }
1432
    };
1433
    // Andy never pressed Watch, but owns it: he hears of bob's issue.
1434
    assert!(get(app, "/andy/demo", Some(&andy)).await.body.contains("UNWATCH"), "an owner watches by default");
1435
    open("bob", "First").await;
1436
    assert!(kinds(andy_id).await.iter().any(|(k, t, _)| k == "issue.opened" && t.contains("First")));
1437
    // Muted, he does not.
1438
    let csrf = csrf_of(&get(app, "/andy/demo", Some(&andy)).await.body);
1439
    post(app, "/andy/demo/watch", Some(&andy), &format!("_csrf={csrf}")).await;
1440
    assert!(get(app, "/andy/demo", Some(&andy)).await.body.contains(">WATCH<"), "muted");
1441
    open("bob", "Second").await;
1442
    assert!(!kinds(andy_id).await.iter().any(|(_, t, _)| t.contains("Second")));
1443
    post(app, "/andy/demo/watch", Some(&andy), &format!("_csrf={csrf}")).await;
1444
1445
    // His own doing is not told to him; his agent's is.
1446
    let token = |agent: bool| {
1447
        let db = app.db.clone();
1448
        async move {
1449
            let (t, hash) = oxygenhub::auth::new_token();
1450
            db::accounts::create_token(&db, andy_id, if agent { "Claude" } else { "laptop" }, &hash, "repo:read,repo:write", "", None)
1451
                .await
1452
                .unwrap();
1453
            if agent {
1454
                let id = db::accounts::token_by_hash(&db, &hash).await.unwrap().unwrap().id;
1455
                db::accounts::set_token_agent(&db, andy_id, id, true).await.unwrap();
1456
            }
1457
            t
1458
        }
1459
    };
1460
    let api_issue = |t: String, title: &'static str| {
1461
        let app = app.clone();
1462
        async move {
1463
            use tower::ServiceExt;
1464
            let req = axum::http::Request::post("/api/v1/repos/andy/demo/issues")
1465
                .header("authorization", format!("Bearer {t}"))
1466
                .header("content-type", "application/json")
1467
                .body(axum::body::Body::from(serde_json::json!({ "title": title, "body": "" }).to_string()))
1468
                .unwrap();
1469
            oxygenhub::router(app).oneshot(req).await.unwrap().status()
1470
        }
1471
    };
1472
    assert_eq!(api_issue(token(false).await, "By hand").await, StatusCode::CREATED);
1473
    assert!(!kinds(andy_id).await.iter().any(|(_, t, _)| t.contains("By hand")), "his own doing");
1474
    assert_eq!(api_issue(token(true).await, "By the agent").await, StatusCode::CREATED);
1475
    let told = kinds(andy_id).await;
1476
    let agent = told.iter().find(|(_, t, _)| t.contains("By the agent")).expect("told of his agent's issue");
1477
    assert_eq!(agent.2, "andy (agent token Claude)");
1478
    // The tokens page marks and unmarks one.
1479
    let page = get(app, "/settings/tokens", Some(&andy)).await;
1480
    assert!(page.body.contains("Not an agent") && page.body.contains("Mark as agent"), "{}", page.body);
1481
    assert!(page.body.contains(r#"<span class="pill agent-pill""#), "the agent's token says so");
1482
}