From 59227d33d6e7c01fbb1ebf96ea616c5f296df7b1 Mon Sep 17 00:00:00 2001 From: Peter Stone Date: Mon, 19 Jan 2026 10:22:49 -1000 Subject: Fix stale Todoist tasks persisting after refresh Clear tasks table before inserting fresh API data, matching the fix applied to SaveBoards. This ensures completed/updated/deleted tasks are properly removed from the cache. Co-Authored-By: Claude Opus 4.5 --- internal/store/sqlite.go | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'internal/store/sqlite.go') diff --git a/internal/store/sqlite.go b/internal/store/sqlite.go index 5f58fd4..a078748 100644 --- a/internal/store/sqlite.go +++ b/internal/store/sqlite.go @@ -96,6 +96,11 @@ func (s *Store) SaveTasks(tasks []models.Task) error { } defer tx.Rollback() + // Clear existing tasks first to remove stale data + if _, err := tx.Exec(`DELETE FROM tasks`); err != nil { + return err + } + stmt, err := tx.Prepare(` INSERT OR REPLACE INTO tasks (id, content, description, project_id, project_name, due_date, priority, completed, labels, url, created_at, updated_at) -- cgit v1.2.3