From b2d8fc460be3105ac383098e7cdc92171e5026ec Mon Sep 17 00:00:00 2001 From: Peter Stone Date: Mon, 23 Mar 2026 08:13:02 +0000 Subject: 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 --- migrations/019_add_google_tasks.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 migrations/019_add_google_tasks.sql (limited to 'migrations') 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); -- cgit v1.2.3