sessionwiki 0.34.3

Find, search, and read every AI coding session you've ever had - across Claude Code, Codex, Gemini CLI, OpenCode, Cline, and more.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70

//! `projects` LAST is when a project was last worked in, the same clock the
//! session list sorts by (`COALESCE(ended, started)`), not when its newest
//! session happened to begin.

use rusqlite::{params, Connection};
use sessionwiki::index;

fn fresh() -> Connection {
    let dir = std::env::temp_dir().join("sessionwiki-test-projects-last-active");
    let _ = std::fs::remove_dir_all(&dir);
    std::fs::create_dir_all(&dir).unwrap();
    std::env::set_var("SESSIONWIKI_DATA", &dir);
    let conn = index::open().unwrap();
    conn.execute_batch("DELETE FROM files;").unwrap();
    conn
}

fn seed(conn: &Connection, id: &str, project: &str, started: &str, ended: Option<&str>) {
    conn.execute(
        "INSERT INTO files(path, mtime, size, session_id, tool, project, title, started, ended, msg_count, kind)
         VALUES (?1, 0, 0, ?2, 'claude-code', ?3, ?2, ?4, ?5, 1, 'main')",
        params![format!("/store/{id}.jsonl"), id, project, started, ended],
    )
    .unwrap();
}

#[test]
fn a_long_session_still_running_makes_its_project_the_latest() {
    let conn = fresh();
    // /proj/long: one session begun in May and worked in until yesterday.
    seed(
        &conn,
        "long",
        "/proj/long",
        "2026-05-01T09:00:00+00:00",
        Some("2026-10-01T18:00:00+00:00"),
    );
    // /proj/short: one short session in September.
    seed(
        &conn,
        "short",
        "/proj/short",
        "2026-09-20T09:00:00+00:00",
        Some("2026-09-20T10:00:00+00:00"),
    );
    // A session with no recorded end still counts by its start.
    seed(
        &conn,
        "open",
        "/proj/open",
        "2026-09-25T09:00:00+00:00",
        None,
    );

    let projects = index::projects(&conn).unwrap();
    let long = projects.iter().find(|p| p.project == "/proj/long").unwrap();
    assert_eq!(
        long.newest.as_deref(),
        Some("2026-10-01T18:00:00+00:00"),
        "LAST is when the project was last worked in"
    );
    let open = projects.iter().find(|p| p.project == "/proj/open").unwrap();
    assert_eq!(open.newest.as_deref(), Some("2026-09-25T09:00:00+00:00"));
    let order: Vec<&str> = projects.iter().map(|p| p.project.as_str()).collect();
    assert_eq!(
        order,
        ["/proj/long", "/proj/open", "/proj/short"],
        "equally busy projects are ordered by last activity"
    );
}