1use crate::{PawanError, Result};
10use rusqlite::{params, Connection};
11use serde::{Deserialize, Serialize};
12use std::path::PathBuf;
13
14#[derive(Debug, Clone, PartialEq, Eq, Hash, Serialize, Deserialize)]
20pub struct BeadId(pub String);
21
22impl BeadId {
23 pub fn generate(title: &str, created_at: &str) -> Self {
32 use std::collections::hash_map::DefaultHasher;
33 use std::hash::{Hash, Hasher};
34 let mut hasher = DefaultHasher::new();
35 title.hash(&mut hasher);
36 created_at.hash(&mut hasher);
37 let hash = hasher.finish();
38 Self(format!("{:08x}", hash & 0xFFFFFFFF))
39 }
40
41 pub fn display(&self) -> String {
46 format!("bd-{}", self.0)
47 }
48
49 pub fn parse(s: &str) -> Self {
59 Self(s.strip_prefix("bd-").unwrap_or(s).to_string())
60 }
61}
62
63impl std::fmt::Display for BeadId {
64 fn fmt(&self, f: &mut std::fmt::Formatter<'_>) -> std::fmt::Result {
65 write!(f, "bd-{}", self.0)
66 }
67}
68
69#[derive(Debug, Clone, PartialEq, Serialize, Deserialize)]
76#[serde(rename_all = "snake_case")]
77pub enum BeadStatus {
78 Open,
79 InProgress,
80 Closed,
81}
82
83impl BeadStatus {
84 pub fn to_str(&self) -> &'static str {
89 match self {
90 Self::Open => "open",
91 Self::InProgress => "in_progress",
92 Self::Closed => "closed",
93 }
94 }
95
96}
97
98impl std::str::FromStr for BeadStatus {
99 type Err = std::convert::Infallible;
100
101 fn from_str(s: &str) -> std::result::Result<Self, Self::Err> {
102 Ok(match s {
103 "in_progress" => Self::InProgress,
104 "closed" => Self::Closed,
105 _ => Self::Open,
106 })
107 }
108}
109
110#[derive(Debug, Clone, Serialize, Deserialize)]
123pub struct Bead {
124 pub id: BeadId,
125 pub title: String,
126 pub description: Option<String>,
127 pub status: BeadStatus,
128 pub priority: u8,
130 pub created_at: String,
131 pub updated_at: String,
132 pub closed_at: Option<String>,
133 pub closed_reason: Option<String>,
134}
135
136pub struct BeadStore {
151 conn: Connection,
152}
153
154impl BeadStore {
155 pub fn open() -> Result<Self> {
157 let path = Self::db_path()?;
158 if let Some(parent) = path.parent() {
159 std::fs::create_dir_all(parent)
160 .map_err(|e| PawanError::Config(format!("Create dir: {}", e)))?;
161 }
162 let conn = Connection::open(&path)
163 .map_err(|e| PawanError::Config(format!("Open DB: {}", e)))?;
164 let store = Self { conn };
165 store.init_schema()?;
166 Ok(store)
167 }
168
169 pub fn with_conn(conn: Connection) -> Result<Self> {
171 let store = Self { conn };
172 store.init_schema()?;
173 Ok(store)
174 }
175
176 fn db_path() -> Result<PathBuf> {
177 let home = std::env::var("HOME").unwrap_or_else(|_| "/root".into());
178 Ok(PathBuf::from(home).join(".pawan").join("beads.db"))
179 }
180
181 fn init_schema(&self) -> Result<()> {
182 self.conn
183 .execute_batch(
184 "CREATE TABLE IF NOT EXISTS beads (
185 id TEXT PRIMARY KEY,
186 title TEXT NOT NULL,
187 description TEXT,
188 status TEXT NOT NULL DEFAULT 'open',
189 priority INTEGER NOT NULL DEFAULT 2,
190 created_at TEXT NOT NULL,
191 updated_at TEXT NOT NULL,
192 closed_at TEXT,
193 closed_reason TEXT
194 );
195 CREATE TABLE IF NOT EXISTS deps (
196 bead_id TEXT NOT NULL,
197 depends_on TEXT NOT NULL,
198 PRIMARY KEY (bead_id, depends_on),
199 FOREIGN KEY (bead_id) REFERENCES beads(id),
200 FOREIGN KEY (depends_on) REFERENCES beads(id)
201 );
202 CREATE TABLE IF NOT EXISTS archives (
203 id INTEGER PRIMARY KEY AUTOINCREMENT,
204 summary TEXT NOT NULL,
205 bead_count INTEGER NOT NULL,
206 archived_at TEXT NOT NULL
207 );",
208 )
209 .map_err(|e| PawanError::Config(format!("Schema: {}", e)))?;
210 Ok(())
211 }
212
213 pub fn create(&self, title: &str, description: Option<&str>, priority: u8) -> Result<Bead> {
215 let now = chrono::Utc::now().to_rfc3339();
216 let id = BeadId::generate(title, &now);
217
218 self.conn
219 .execute(
220 "INSERT INTO beads (id, title, description, status, priority, created_at, updated_at)
221 VALUES (?1, ?2, ?3, 'open', ?4, ?5, ?6)",
222 params![id.0, title, description, priority, now, now],
223 )
224 .map_err(|e| PawanError::Config(format!("Insert: {}", e)))?;
225
226 Ok(Bead {
227 id,
228 title: title.into(),
229 description: description.map(String::from),
230 status: BeadStatus::Open,
231 priority,
232 created_at: now.clone(),
233 updated_at: now,
234 closed_at: None,
235 closed_reason: None,
236 })
237 }
238
239 pub fn get(&self, id: &BeadId) -> Result<Bead> {
241 self.conn
242 .query_row(
243 "SELECT id, title, description, status, priority, created_at, updated_at, closed_at, closed_reason
244 FROM beads WHERE id = ?1",
245 params![id.0],
246 |row| {
247 Ok(Bead {
248 id: BeadId(row.get::<_, String>(0)?),
249 title: row.get(1)?,
250 description: row.get(2)?,
251 status: row.get::<_, String>(3)?.parse().unwrap_or(BeadStatus::Open),
252 priority: row.get(4)?,
253 created_at: row.get(5)?,
254 updated_at: row.get(6)?,
255 closed_at: row.get(7)?,
256 closed_reason: row.get(8)?,
257 })
258 },
259 )
260 .map_err(|e| PawanError::NotFound(format!("Bead {}: {}", id, e)))
261 }
262
263 pub fn update(
265 &self,
266 id: &BeadId,
267 title: Option<&str>,
268 status: Option<BeadStatus>,
269 priority: Option<u8>,
270 ) -> Result<()> {
271 let now = chrono::Utc::now().to_rfc3339();
272
273 if let Some(t) = title {
274 self.conn
275 .execute(
276 "UPDATE beads SET title = ?1, updated_at = ?2 WHERE id = ?3",
277 params![t, now, id.0],
278 )
279 .map_err(|e| PawanError::Config(format!("Update title: {}", e)))?;
280 }
281 if let Some(s) = status {
282 self.conn
283 .execute(
284 "UPDATE beads SET status = ?1, updated_at = ?2 WHERE id = ?3",
285 params![s.to_str(), now, id.0],
286 )
287 .map_err(|e| PawanError::Config(format!("Update status: {}", e)))?;
288 }
289 if let Some(p) = priority {
290 self.conn
291 .execute(
292 "UPDATE beads SET priority = ?1, updated_at = ?2 WHERE id = ?3",
293 params![p, now, id.0],
294 )
295 .map_err(|e| PawanError::Config(format!("Update priority: {}", e)))?;
296 }
297 Ok(())
298 }
299
300 pub fn close(&self, id: &BeadId, reason: Option<&str>) -> Result<()> {
302 let now = chrono::Utc::now().to_rfc3339();
303 self.conn
304 .execute(
305 "UPDATE beads SET status = 'closed', closed_at = ?1, closed_reason = ?2, updated_at = ?3 WHERE id = ?4",
306 params![now, reason, now, id.0],
307 )
308 .map_err(|e| PawanError::Config(format!("Close: {}", e)))?;
309 Ok(())
310 }
311
312 pub fn delete(&self, id: &BeadId) -> Result<()> {
314 self.conn
315 .execute("DELETE FROM deps WHERE bead_id = ?1 OR depends_on = ?1", params![id.0])
316 .map_err(|e| PawanError::Config(format!("Delete deps: {}", e)))?;
317 self.conn
318 .execute("DELETE FROM beads WHERE id = ?1", params![id.0])
319 .map_err(|e| PawanError::Config(format!("Delete: {}", e)))?;
320 Ok(())
321 }
322
323 pub fn list(
325 &self,
326 status: Option<&str>,
327 max_priority: Option<u8>,
328 ) -> Result<Vec<Bead>> {
329 let mut sql = "SELECT id, title, description, status, priority, created_at, updated_at, closed_at, closed_reason FROM beads WHERE 1=1".to_string();
330 let mut bind_vals: Vec<Box<dyn rusqlite::types::ToSql>> = Vec::new();
331
332 if let Some(s) = status {
333 sql.push_str(&format!(" AND status = ?{}", bind_vals.len() + 1));
334 bind_vals.push(Box::new(s.to_string()));
335 }
336 if let Some(p) = max_priority {
337 sql.push_str(&format!(" AND priority <= ?{}", bind_vals.len() + 1));
338 bind_vals.push(Box::new(p));
339 }
340 sql.push_str(" ORDER BY priority ASC, updated_at DESC");
341
342 let params_refs: Vec<&dyn rusqlite::types::ToSql> = bind_vals.iter().map(|b| b.as_ref()).collect();
343
344 let mut stmt = self.conn.prepare(&sql)
345 .map_err(|e| PawanError::Config(format!("Prepare: {}", e)))?;
346
347 let beads = stmt
348 .query_map(params_refs.as_slice(), |row| {
349 Ok(Bead {
350 id: BeadId(row.get::<_, String>(0)?),
351 title: row.get(1)?,
352 description: row.get(2)?,
353 status: row.get::<_, String>(3)?.parse().unwrap_or(BeadStatus::Open),
354 priority: row.get(4)?,
355 created_at: row.get(5)?,
356 updated_at: row.get(6)?,
357 closed_at: row.get(7)?,
358 closed_reason: row.get(8)?,
359 })
360 })
361 .map_err(|e| PawanError::Config(format!("Query: {}", e)))?
362 .filter_map(|r| r.ok())
363 .collect();
364
365 Ok(beads)
366 }
367
368 pub fn dep_add(&self, bead_id: &BeadId, depends_on: &BeadId) -> Result<()> {
370 self.conn
371 .execute(
372 "INSERT OR IGNORE INTO deps (bead_id, depends_on) VALUES (?1, ?2)",
373 params![bead_id.0, depends_on.0],
374 )
375 .map_err(|e| PawanError::Config(format!("Dep add: {}", e)))?;
376 Ok(())
377 }
378
379 pub fn dep_remove(&self, bead_id: &BeadId, depends_on: &BeadId) -> Result<()> {
381 self.conn
382 .execute(
383 "DELETE FROM deps WHERE bead_id = ?1 AND depends_on = ?2",
384 params![bead_id.0, depends_on.0],
385 )
386 .map_err(|e| PawanError::Config(format!("Dep rm: {}", e)))?;
387 Ok(())
388 }
389
390 pub fn deps(&self, bead_id: &BeadId) -> Result<Vec<BeadId>> {
392 let mut stmt = self.conn
393 .prepare("SELECT depends_on FROM deps WHERE bead_id = ?1")
394 .map_err(|e| PawanError::Config(format!("Prepare: {}", e)))?;
395
396 let ids = stmt
397 .query_map(params![bead_id.0], |row| {
398 Ok(BeadId(row.get::<_, String>(0)?))
399 })
400 .map_err(|e| PawanError::Config(format!("Query: {}", e)))?
401 .filter_map(|r| r.ok())
402 .collect();
403
404 Ok(ids)
405 }
406
407 pub fn ready(&self) -> Result<Vec<Bead>> {
409 let all_open = self.list(Some("open"), None)?;
410 let mut ready = Vec::new();
411
412 for bead in all_open {
413 let deps = self.deps(&bead.id)?;
414 let all_closed = deps.iter().all(|dep_id| {
415 self.get(dep_id)
416 .map(|b| b.status == BeadStatus::Closed)
417 .unwrap_or(true) });
419 if all_closed {
420 ready.push(bead);
421 }
422 }
423
424 Ok(ready)
425 }
426
427 pub fn memory_decay(&self, max_age_days: u64) -> Result<usize> {
429 let cutoff = chrono::Utc::now() - chrono::Duration::days(max_age_days as i64);
430 let cutoff_str = cutoff.to_rfc3339();
431
432 let mut stmt = self.conn
434 .prepare(
435 "SELECT id, title, closed_reason FROM beads
436 WHERE status = 'closed' AND closed_at < ?1
437 ORDER BY closed_at ASC",
438 )
439 .map_err(|e| PawanError::Config(format!("Prepare: {}", e)))?;
440
441 let old_beads: Vec<(String, String, Option<String>)> = stmt
442 .query_map(params![cutoff_str], |row| {
443 Ok((
444 row.get::<_, String>(0)?,
445 row.get::<_, String>(1)?,
446 row.get::<_, Option<String>>(2)?,
447 ))
448 })
449 .map_err(|e| PawanError::Config(format!("Query: {}", e)))?
450 .filter_map(|r| r.ok())
451 .collect();
452
453 if old_beads.is_empty() {
454 return Ok(0);
455 }
456
457 let count = old_beads.len();
458
459 let summary_lines: Vec<String> = old_beads
461 .iter()
462 .map(|(id, title, reason)| {
463 let r = reason.as_deref().unwrap_or("done");
464 format!("- bd-{}: {} ({})", id, title, r)
465 })
466 .collect();
467 let summary = format!(
468 "Archived {} beads (before {}):\n{}",
469 count,
470 cutoff_str,
471 summary_lines.join("\n")
472 );
473
474 let now = chrono::Utc::now().to_rfc3339();
475 self.conn
476 .execute(
477 "INSERT INTO archives (summary, bead_count, archived_at) VALUES (?1, ?2, ?3)",
478 params![summary, count, now],
479 )
480 .map_err(|e| PawanError::Config(format!("Archive: {}", e)))?;
481
482 for (id, _, _) in &old_beads {
484 self.conn
485 .execute("DELETE FROM deps WHERE bead_id = ?1 OR depends_on = ?1", params![id])
486 .ok();
487 self.conn
488 .execute("DELETE FROM beads WHERE id = ?1", params![id])
489 .ok();
490 }
491
492 Ok(count)
493 }
494}
495
496#[cfg(test)]
497mod tests {
498 use super::*;
499
500 fn test_store() -> BeadStore {
501 let conn = Connection::open_in_memory().unwrap();
502 BeadStore::with_conn(conn).unwrap()
503 }
504
505 #[test]
506 fn create_and_get() {
507 let store = test_store();
508 let bead = store.create("Fix bug", Some("It's broken"), 1).unwrap();
509 assert!(bead.id.0.len() == 8);
510 assert_eq!(bead.title, "Fix bug");
511 assert_eq!(bead.priority, 1);
512
513 let loaded = store.get(&bead.id).unwrap();
514 assert_eq!(loaded.title, "Fix bug");
515 }
516
517 #[test]
518 fn list_filters() {
519 let store = test_store();
520 store.create("A", None, 0).unwrap();
521 store.create("B", None, 2).unwrap();
522 let c = store.create("C", None, 4).unwrap();
523 store.close(&c.id, Some("done")).unwrap();
524
525 let all = store.list(None, None).unwrap();
526 assert_eq!(all.len(), 3);
527
528 let open = store.list(Some("open"), None).unwrap();
529 assert_eq!(open.len(), 2);
530
531 let critical = store.list(None, Some(1)).unwrap();
532 assert_eq!(critical.len(), 1);
533 assert_eq!(critical[0].title, "A");
534 }
535
536 #[test]
537 fn deps_and_ready() {
538 let store = test_store();
539 let a = store.create("Task A", None, 1).unwrap();
540 let b = store.create("Task B", None, 1).unwrap();
541 let c = store.create("Task C", None, 1).unwrap();
542
543 store.dep_add(&c.id, &a.id).unwrap();
545 store.dep_add(&c.id, &b.id).unwrap();
546
547 let ready = store.ready().unwrap();
549 assert_eq!(ready.len(), 2);
550 let ready_ids: Vec<&str> = ready.iter().map(|b| b.id.0.as_str()).collect();
551 assert!(!ready_ids.contains(&c.id.0.as_str()));
552
553 store.close(&a.id, None).unwrap();
555 let ready = store.ready().unwrap();
556 assert_eq!(ready.len(), 1); assert_eq!(ready[0].id, b.id);
558
559 store.close(&b.id, None).unwrap();
561 let ready = store.ready().unwrap();
562 assert_eq!(ready.len(), 1);
563 assert_eq!(ready[0].id, c.id);
564 }
565
566 #[test]
567 fn close_and_delete() {
568 let store = test_store();
569 let bead = store.create("Temp", None, 3).unwrap();
570
571 store.close(&bead.id, Some("no longer needed")).unwrap();
572 let loaded = store.get(&bead.id).unwrap();
573 assert_eq!(loaded.status, BeadStatus::Closed);
574 assert_eq!(loaded.closed_reason.as_deref(), Some("no longer needed"));
575
576 store.delete(&bead.id).unwrap();
577 assert!(store.get(&bead.id).is_err());
578 }
579
580 #[test]
581 fn memory_decay_archives() {
582 let store = test_store();
583
584 let bead = store.create("Old task", None, 2).unwrap();
586 let old_time = (chrono::Utc::now() - chrono::Duration::days(60)).to_rfc3339();
587 store.conn
588 .execute(
589 "UPDATE beads SET status = 'closed', closed_at = ?1 WHERE id = ?2",
590 params![old_time, bead.id.0],
591 )
592 .unwrap();
593
594 let recent = store.create("Recent task", None, 2).unwrap();
596 store.close(&recent.id, Some("just done")).unwrap();
597
598 let count = store.memory_decay(30).unwrap();
600 assert_eq!(count, 1);
601
602 assert!(store.get(&bead.id).is_err());
604 assert!(store.get(&recent.id).is_ok());
606
607 let summary: String = store.conn
609 .query_row("SELECT summary FROM archives ORDER BY id DESC LIMIT 1", [], |r| r.get(0))
610 .unwrap();
611 assert!(summary.contains("Old task"));
612 }
613}