clt-rs 0.8.2

File-backed task manager with a TUI Kanban board and multi-project Codex agent registry
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117

use anyhow::{Context, Result};
use clt_database::turso::params;

use crate::{
    agent::{TursoAgentStore, row_text},
    runner::agent_timestamp,
    supervisor::{SupervisorReview, SupervisorSettings},
};

impl TursoAgentStore {
    pub(crate) fn supervisor_settings_blocking(&self) -> Result<SupervisorSettings> {
        if self
            .pending_migration_version()
            .is_some_and(|version| version <= 20)
        {
            return Ok(SupervisorSettings::default());
        }
        self.blocking.block_on(async {
            let conn = self.repositories.projects_models.connect().await?;
            let mut rows = conn
                .query(
                    "SELECT supervisor_settings FROM agent_settings WHERE id = 1",
                    (),
                )
                .await?;
            let Some(row) = rows.next().await? else {
                return Ok(SupervisorSettings::default());
            };
            let settings = crate::agent::row_optional_text(&row, 0, "supervisor_settings")?;
            settings
                .map(|text| serde_json::from_str(&text).context("Invalid supervisor settings"))
                .unwrap_or_else(|| Ok(SupervisorSettings::default()))
        })
    }

    pub(crate) fn set_supervisor_settings_blocking(
        &self,
        settings: &SupervisorSettings,
    ) -> Result<()> {
        anyhow::ensure!(
            self.pending_migration_version().is_none(),
            "Supervisor upgrade is waiting for older workers to finish"
        );
        let json = serde_json::to_string(settings)?;
        self.blocking.block_on_persist(async {
            let conn = self.repositories.projects_models.connect().await?;
            conn.execute(
                "UPDATE agent_settings SET supervisor_settings = ?1, updated_at = ?2 WHERE id = 1",
                params![json, agent_timestamp()],
            )
            .await?;
            Ok(())
        })
    }

    pub(crate) fn supervisor_review_blocking(
        &self,
        project_id: i64,
    ) -> Result<Option<SupervisorReview>> {
        if self
            .pending_migration_version()
            .is_some_and(|version| version <= 20)
        {
            return Ok(None);
        }
        self.blocking.block_on(async {
            let conn = self.repositories.projects_models.connect().await?;
            let mut rows = conn
                .query(
                    "SELECT record FROM supervisor_reviews WHERE project_id = ?1",
                    [project_id],
                )
                .await?;
            rows.next()
                .await?
                .map(|row| {
                    serde_json::from_str(&row_text(&row, 0, "record")?)
                        .context("Invalid supervisor review")
                })
                .transpose()
        })
    }

    pub(crate) fn save_supervisor_review_blocking(
        &self,
        project_id: i64,
        review: &SupervisorReview,
    ) -> Result<()> {
        let json = serde_json::to_string(review)?;
        self.blocking.block_on_persist(async {
            let conn = self.repositories.projects_models.connect().await?;
            conn.execute("INSERT INTO supervisor_reviews (project_id, evidence, record, updated_at)
                VALUES (?1, ?2, ?3, ?4) ON CONFLICT(project_id) DO UPDATE SET
                evidence = excluded.evidence, record = excluded.record, updated_at = excluded.updated_at",
                params![project_id, review.evidence.as_str(), json, agent_timestamp()]).await?;
            Ok(())
        })
    }

    pub(crate) fn clear_supervisor_review_blocking(&self, project_id: i64) -> Result<()> {
        if self
            .pending_migration_version()
            .is_some_and(|version| version <= 20)
        {
            return Ok(());
        }
        self.blocking.block_on_persist(async {
            let conn = self.repositories.projects_models.connect().await?;
            conn.execute(
                "DELETE FROM supervisor_reviews WHERE project_id = ?1",
                [project_id],
            )
            .await?;
            Ok(())
        })
    }
}