[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_159":160,"_161":162},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_107":88,"_27":53,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":124,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",37,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","66806b0c-5c8e-11f1-bd8b-1607ee4eb77e","name","fileType","http","content","import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\nexport default async function handler(req: Request) {\n const url = new URL(req.url);\n const path = url.pathname;\n\n const redirectUri =\n \"https://piss--66806b0c5c8e11f1bd8b1607ee4eb77e.web.val.run/callback\";\n\n // ---------------- INIT DB ----------------\n await sqlite.execute(`\n create table if not exists spotify_tokens (\n user_id text primary key,\n token text\n )\n `);\n\n // ---------------- HOME PAGE ----------------\n if (path === \"/\") {\n return new Response(\n `\n

Spotify API

Routes:

/login?id=USERID
/u/USERID

Spotify Auth API

Use:

/login?id=alice
/u/alice

\n `,\n { headers: { \"Content-Type\": \"text/html\" } },\n );\n }\n\n // ---------------- LOGIN ----------------\n if (path === \"/login\") {\n const clientId = Deno.env.get(\"SPOTIFY_CLIENT_ID\")!;\n const userId = url.searchParams.get(\"id\");\n\n if (!userId) {\n return new Response(\"Missing ?id\", { status: 400 });\n }\n\n const params = new URLSearchParams({\n response_type: \"code\",\n client_id: clientId,\n scope: \"user-read-email user-read-private\",\n redirect_uri: redirectUri,\n state: userId,\n });\n\n return Response.redirect(\n `https://accounts.spotify.com/authorize?${params.toString()}`,\n );\n }\n\n // ---------------- CALLBACK ----------------\n if (path === \"/callback\") {\n const code = url.searchParams.get(\"code\");\n const userId = url.searchParams.get(\"state\");\n\n if (!code || !userId) {\n return new Response(\"Missing code or state\", { status: 400 });\n }\n\n const body = new URLSearchParams({\n grant_type: \"authorization_code\",\n code,\n redirect_uri: redirectUri,\n client_id: Deno.env.get(\"SPOTIFY_CLIENT_ID\")!,\n client_secret: Deno.env.get(\"SPOTIFY_CLIENT_SECRET\")!,\n });\n\n const tokenRes = await fetch(\"https://accounts.spotify.com/api/token\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/x-www-form-urlencoded\",\n },\n body,\n });\n\n const tokenData = await tokenRes.json();\n\n if (!tokenData.access_token) {\n return new Response(JSON.stringify(tokenData), { status: 500 });\n }\n\n // 🔴 IMPORTANT: ensure DB write completes\n await sqlite.execute({\n sql: `\n insert or replace into spotify_tokens (user_id, token)\n values (?, ?)\n `,\n args: [userId, JSON.stringify(tokenData)],\n });\n\n // optional verification log\n const check = await sqlite.execute({\n sql: `select user_id from spotify_tokens where user_id = ?`,\n args: [userId],\n });\n\n console.log(\"STORED USER:\", check.rows);\n\n return Response.redirect(`${BASE_URL}/u/${userId}`);\n }\n\n // ---------------- USER PAGE ----------------\n if (path.startsWith(\"/u/\")) {\n const userId = path.split(\"/u/\")[1];\n\n const result = await sqlite.execute({\n sql: `select token from spotify_tokens where user_id = ?`,\n args: [userId],\n });\n\n const tokenData = result.rows[0]?.token\n ? JSON.parse(result.rows[0].token)\n : null;\n\n if (!tokenData?.access_token) {\n return new Response(\"User not logged in\", { status: 404 });\n }\n\n const meRes = await fetch(\"https://api.spotify.com/v1/me\", {\n headers: {\n Authorization: `Bearer ${tokenData.access_token}`,\n },\n });\n\n return Response.json(await meRes.json());\n }\n\n // ---------------- FALLBACK ----------------\n return Response.redirect(BASE_URL);\n}","createdAt",["D",1780194109529],"branchVersion","branchId","667d2906-5c8e-11f1-bd8b-1607ee4eb77e","id","667c051c-5c8e-11f1-bd8b-1607ee4eb77e","unnamed",["D",1780190209970],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","6ac692ab-f968-426c-bf3d-c4aad36ee8d8","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e7b97-ba69-754c-ac74-19d340170053","tursoName","667c051c5c8e11f1bd8b1607ee4eb77e","tursoHostname","667c051c5c8e11f1bd8b1607ee4eb77e-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789515657103],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",68,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","piss","handle","displayName","pee","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/b828c3f0-02b0-404b-e1bb-62f4c517d300/square512?exp=1789587666&sig=eabfd3f084b2005bfa774e3330436064297557102225695422c88af22c8e1af6","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":154,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":155,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":156,"_82":157,"_84":158,"_86":25},"tree",[149],"files",[149],"counts",{"_137":61,"_138":139,"_140":61,"_141":142,"_143":144},"contents",[129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":133,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_27":136},"7acf0a10-5c97-11f1-9866-1607ee4eb77e","parentId","latest",["D",1780194109529],36,"label",[28],"pulls","branches",1,"forks","envVars",{"_145":147,"_148":61},"connections",{"_145":61,"_146":61},"count","unfilledCount",4,"emptyCount",{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":150,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_151":152,"_27":153},["D",1780194109529],"children",[],[28],["D",1780190209970],["D",1789515657103],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_126":192,"_193":194,"_195":196,"_197":25,"_198":25,"_199":25,"_200":124,"_201":-5,"_202":-7,"_203":-7,"_204":61,"_205":25,"_206":25,"_207":-5,"_208":25,"_209":25,"_210":25,"_211":-5},"ENV",{"_163":164,"_165":166,"_167":88,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v37