From 3660486153a16760d2b980e546bbbd29408fb8d4 Mon Sep 17 00:00:00 2001 From: Peter Stone Date: Sun, 16 Aug 2026 00:03:51 +0000 Subject: Replace Google Tasks service-account auth with real OAuth Service-account auth structurally cannot see a regular user's personal task lists (no equivalent of Calendar's per-item sharing model) -- confirmed via GetTaskLists returning exactly the service account's own empty "My Tasks" list, never the real user's three lists. Zero rows were ever cached in production as a result. Adds a standard 3-legged OAuth flow: /settings/google-tasks/connect redirects to Google's consent screen (AccessTypeOffline+ApprovalForce so a refresh_token is always issued), /callback exchanges the code and persists the token (new oauth_tokens table), /disconnect clears it. GoogleTasksClient now takes an option.ClientOption instead of a credentials file path; NewGoogleTasksOAuthClient wraps it with a dbTokenSource that reloads/refreshes from the DB on each access-token expiry and re-persists -- carefully preserving the original refresh_token when Google's refresh response omits one (it usually does), which would otherwise silently and permanently break future refreshes. Settings page shows connection status and a Connect/Disconnect button. Calendar keeps using service-account auth (that one actually works). Requires a one-time manual step: create an OAuth 2.0 Client ID in Google Cloud Console and set GOOGLE_OAUTH_CLIENT_ID/SECRET in .env -- documented in .env.example. --- internal/config/config_test.go | 12 +++++++----- 1 file changed, 7 insertions(+), 5 deletions(-) (limited to 'internal/config/config_test.go') diff --git a/internal/config/config_test.go b/internal/config/config_test.go index b436e93..60277f4 100644 --- a/internal/config/config_test.go +++ b/internal/config/config_test.go @@ -48,11 +48,13 @@ func TestConfigValidate(t *testing.T) { func TestConfigHasMethods(t *testing.T) { cfg := Config{ - PlanToEatAPIKey: "pte-key", - TrelloAPIKey: "trello-key", - TrelloToken: "trello-token", - GoogleCredentialsFile: "/path/to/creds.json", - GoogleTasksListID: "@default", + PlanToEatAPIKey: "pte-key", + TrelloAPIKey: "trello-key", + TrelloToken: "trello-token", + GoogleCredentialsFile: "/path/to/creds.json", + GoogleTasksListID: "@default", + GoogleOAuthClientID: "client-id", + GoogleOAuthClientSecret: "client-secret", } if !cfg.HasPlanToEat() { -- cgit v1.2.3