Authorization failed: ${error || \"No code received\"}

\n \n \n `, { headers: { \"Content-Type\": \"text/html\" } });\n }\n\n try {\n // Exchange code for tokens\n const tokenRes = await fetch(\"https://oauth2.googleapis.com/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n code,\n client_id: CLIENT_ID,\n client_secret: CLIENT_SECRET,\n redirect_uri: REDIRECT_URI,\n grant_type: \"authorization_code\",\n }),\n });\n\n const tokens = await tokenRes.json();\n\n if (!tokenRes.ok || tokens.error) {\n throw new Error(tokens.error_description || \"Token exchange failed\");\n }\n\n await ensureTable();\n\n const expiresAt = Date.now() + (tokens.expires_in * 1000);\n await sqlite.execute({\n sql: `INSERT OR REPLACE INTO google_tokens (id, access_token, refresh_token, expires_at) VALUES (?, ?, ?, ?)`,\n args: [\"default\", tokens.access_token, tokens.refresh_token || null, expiresAt]\n });\n\n return new Response(`\n \n

✅ Authorization successful! You can close this window.

\n \n \n `, { headers: { \"Content-Type\": \"text/html\" } });\n\n } catch (err) {\n return new Response(`\n \n

Error: ${err.message}

\n \n \n `, { headers: { \"Content-Type\": \"text/html\" } });\n }\n}\n\nasync function handleStatus() {\n try {\n await ensureTable();\n const result = await sqlite.execute(`SELECT expires_at FROM google_tokens WHERE id = 'default'`);\n \n if (result.rows.length === 0) {\n return Response.json({ authenticated: false });\n }\n\n const expiresAt = result.rows[0][0] as number;\n const isExpired = expiresAt < Date.now();\n\n return Response.json({ authenticated: !isExpired, expiresAt });\n } catch {\n return Response.json({ authenticated: false });\n }\n}\n\nasync function handleLogout() {\n try {\n await ensureTable();\n await sqlite.execute(`DELETE FROM google_tokens WHERE id = 'default'`);\n return Response.json({ success: true });\n } catch (err) {\n return Response.json({ error: err.message }, { status: 500 });\n }\n}\n\n/**\n * Helper exported for use by add-to-calendar.ts\n * Returns a valid access token, refreshing if needed\n */\nexport async function getValidAccessToken(): Promise {\n await ensureTable();\n const result = await sqlite.execute(`SELECT access_token, refresh_token, expires_at FROM google_tokens WHERE id = 'default'`);\n \n if (result.rows.length === 0) return null;\n\n const [accessToken, refreshToken, expiresAt] = result.rows[0] as [string, string, number];\n\n // Token still valid (with 60s buffer)\n if (expiresAt > Date.now() + 60000) {\n return accessToken;\n }\n\n // Refresh the token\n if (!refreshToken) return null;\n\n const res = await fetch(\"https://oauth2.googleapis.com/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n client_id: CLIENT_ID,\n client_secret: CLIENT_SECRET,\n refresh_token: refreshToken,\n grant_type: \"refresh_token\",\n }),\n });\n\n const tokens = await res.json();\n if (!res.ok || tokens.error) return null;\n\n const newExpiresAt = Date.now() + (tokens.expires_in * 1000);\n await sqlite.execute({\n sql: `UPDATE google_tokens SET access_token = ?, expires_at = ? WHERE id = 'default'`,\n args: [tokens.access_token, newExpiresAt]\n });\n\n return tokens.access_token;\n}\n","deleted","label",[181,7,162],"api","permalink","https://www.val.town/x/wohara010/SportCalApp/code/api/auth/google.ts","extension","actionData","errors"]