kasl-cli 1.0.0

kasl is a comprehensive command-line utility 🛠️ designed to streamline the tracking of work activities 📊, including start times ⏰, pauses ⏸, and task completion
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

//! Local catalog of Jira workflow statuses (id → name).
//!
//! Populated from issue sync so inbox rows can store `status_id` and resolve
//! the display name via join.

use crate::db::db::Db;
use anyhow::Result;
use rusqlite::params;

/// Database operations for the `jira_statuses` table.
pub struct JiraStatuses {
    db: Db,
}

impl JiraStatuses {
    pub fn new() -> Result<Self> {
        Ok(Self { db: Db::new()? })
    }

    /// Inserts or updates a status name for the given Jira status id.
    pub fn upsert(&self, id: &str, name: &str) -> Result<()> {
        if id.is_empty() {
            return Ok(());
        }
        self.db.conn.execute(
            "INSERT INTO jira_statuses (id, name) VALUES (?1, ?2)
             ON CONFLICT(id) DO UPDATE SET name = excluded.name",
            params![id, name],
        )?;
        Ok(())
    }
}