diff options
| author | Peter Stone <thepeterstone@gmail.com> | 2026-03-23 08:13:02 +0000 |
|---|---|---|
| committer | Peter Stone <thepeterstone@gmail.com> | 2026-03-23 08:13:02 +0000 |
| commit | b2d8fc460be3105ac383098e7cdc92171e5026ec (patch) | |
| tree | cd5ba3f3008e6b3310680d785880f1f32ed090c5 /migrations | |
| parent | b0688c8819da1b7fcb4a97b6ec1fa58050e4841e (diff) | |
feat: unify Google Tasks with main system via caching and integrated UI
- Implement SQLite caching layer for Google Tasks
- Integrate Google Tasks into unified Atoms loop (showing in Tasks tab)
- Update Planning tab to include cached Google Tasks
- Enhance Quick Add form with Todoist project selector
- Remove orphaned HandleTasksTab/HandleRefreshTab methods
- Update tests to reflect new BuildTimeline signature and data structures
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/019_add_google_tasks.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/migrations/019_add_google_tasks.sql b/migrations/019_add_google_tasks.sql new file mode 100644 index 0000000..70f5980 --- /dev/null +++ b/migrations/019_add_google_tasks.sql @@ -0,0 +1,15 @@ +-- Google Tasks cache table +CREATE TABLE IF NOT EXISTS google_tasks ( + id TEXT PRIMARY KEY, + title TEXT NOT NULL, + notes TEXT, + status TEXT NOT NULL, + completed BOOLEAN NOT NULL DEFAULT 0, + due_date TEXT, + updated_at TEXT, + list_id TEXT NOT NULL, + url TEXT +); + +CREATE INDEX IF NOT EXISTS idx_google_tasks_due_date ON google_tasks(due_date); +CREATE INDEX IF NOT EXISTS idx_google_tasks_list_id ON google_tasks(list_id); |
