diff options
| author | Peter Stone <thepeterstone@gmail.com> | 2026-01-19 10:22:49 -1000 |
|---|---|---|
| committer | Peter Stone <thepeterstone@gmail.com> | 2026-01-19 10:22:49 -1000 |
| commit | 59227d33d6e7c01fbb1ebf96ea616c5f296df7b1 (patch) | |
| tree | e92964c3f40ea153f1584bc5a951e6f6cafc19aa /internal/store/sqlite.go | |
| parent | a32f3fe5e1b921e574caf7419b90cd5a2f0730a1 (diff) | |
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 <noreply@anthropic.com>
Diffstat (limited to 'internal/store/sqlite.go')
| -rw-r--r-- | internal/store/sqlite.go | 5 |
1 files changed, 5 insertions, 0 deletions
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) |