[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_190":191,"_192":193},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_145":-5,"_20":146,"_22":147,"_148":149,"_150":151,"_26":152,"_24":153,"_154":-5,"_155":-5,"_156":52,"_157":158,"_159":43,"_160":-5,"_161":-5,"_162":163},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","neverstew","name","spotifyOauthServer","branchName","main","version","path","db","project",{"_33":91,"_13":14,"_44":92,"_93":-5,"_94":52,"_95":96,"_97":96,"_98":-5,"_99":-5,"_100":101,"_102":61,"_103":52,"_104":-5,"_105":-5,"_106":107,"_108":109,"_110":-5,"_111":-5,"_112":-5,"_113":-5,"_114":115,"_116":115,"_117":118,"_119":118,"_120":118,"_121":115,"_122":115,"_123":124,"_125":126,"_127":128,"_129":52},"tree",[55,56,57,58],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_18":54},"contents",[],"upstream","pull","ahead","behind","envVars","id","c4d4c0f2-e342-11ef-ac12-e6cdfca9ef9f","fileId","fda971c0-e33d-11ef-b257-e6cdfca9ef9f","parentId","branchId","55e401a8-e33d-11ef-baf2-e6cdfca9ef9f","branchVersion",24,"latest",true,"createdAt",["D",1738706138130],7,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite?v=4\";\nimport { eq, sql, and, isNotNull } from \"npm:drizzle-orm\";\nimport { drizzle } from \"npm:drizzle-orm/libsql\";\nimport { sqliteTable, text } from \"npm:drizzle-orm/sqlite-core\";\n\nawait sqlite.execute(\"CREATE TABLE IF NOT EXISTS spotify_auth (id text primary_key, data text, refresh_token text)\")\n\nexport const db = drizzle(sqlite as any);\nexport const table = sqliteTable(\"spotify_auth\", {\n id: text(\"id\").primaryKey(),\n data: text(\"data\"),\n refresh_token: text(\"refresh_token\"),\n});\n\nexport const insertPendingCallback = (id: string) =>\n db.insert(table).values([{ id }]);\n\nexport const getRow = async (id: string) => {\n const [row] = await db.select().from(table).where(eq(table.id, id)).limit(1);\n return row\n}\nexport const getLatestRefreshRow = async (id: string) => {\n const [row] = await db.select().from(table).where(and(eq(table.id, id), isNotNull(table.refresh_token))).limit(1);\n return row;\n}\n\nexport const updateRow = async (id: string, data: Partial<{ data: object, refresh_token: string }>) => {\n if (data.data) {\n data.data.now = Date.now()\n data.data = JSON.stringify(data.data);\n }\n await db.update(table).set(...data).where(eq(table.id, id));\n}","deleted",false,"label",[19],{"_33":82,"_13":83,"_35":84,"_37":-5,"_38":39,"_40":85,"_42":43,"_44":86,"_17":87,"_47":24,"_49":88,"_51":52,"_53":-5,"_67":89,"_18":90},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":79,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_67":80,"_18":81},{"_33":70,"_13":71,"_35":72,"_37":-5,"_38":39,"_40":73,"_42":43,"_44":74,"_17":75,"_47":48,"_49":76,"_51":52,"_53":-5,"_67":77,"_18":78},{"_33":59,"_13":60,"_35":61,"_37":-5,"_38":39,"_40":62,"_42":43,"_44":63,"_17":64,"_47":65,"_49":66,"_51":52,"_53":-5,"_67":68,"_18":69},"7ce692ce-e343-11ef-9e1b-e6cdfca9ef9f","server","5e762206-e33d-11ef-a9ea-e6cdfca9ef9f",26,["D",1738706446949],14,"http","/** @jsxImportSource https://esm.sh/hono@3.9.2/jsx **/\nimport { scopes } from \"https://esm.town/v/stevekrouse/spotifyScopes\";\nimport { generateRandomString } from \"https://esm.town/v/greg0r/generateRandomString?v=1\";\nimport { spotifyRefreshToken } from \"https://esm.town/v/neverstew/spotifyRefreshToken\";\nimport { spotifyRequestToken } from \"https://esm.town/v/stevekrouse/spotifyRequestToken\";\nimport { home, scopesRoute } from \"https://esm.town/v/stevekrouse/spotify_helpers\";\nimport { getCookie, setCookie } from \"npm:hono/cookie\";\nimport { Hono } from \"npm:hono@3\";\nimport { insertPendingCallback, getRow, updateRow } from \"./db\";\nimport { getSpotifyToken } from \"./getSpotifyToken\";\n\n// CHANGE ME\nconst thisURL = \"https://neverstew--5e762206e33d11efa9eae6cdfca9ef9f.web.val.run\";\nconst redirect_uri = thisURL + \"/callback\";\n\nconst app = new Hono()\n .use(\"*\", async (c, next) => {\n const state = getCookie(c, \"state\") ?? generateRandomString(16);\n c.set(\"state\", state);\n await next();\n setCookie(c, \"state\", state);\n})\n .get(\"/\", c =>\n c.html(\n

Generate Spotify Access Tokens

\n This app uses{\" \"}\n \n Authorization Code Flow\n {\" \"}\n to authenticate users:\n

\n This project sets the CLIENT_ID and CLIENT_SECRET environment variables for the relevant Spotify App.\n
\n We generate a unique code that you will use to authenticate to us: {c.get(\"state\")}\n
You can pick which scopes to authorize.
We construct a URL to redirect you to, which will ask you to authorize the app on Spotify.
You are redirected back here, with a code in the URL.
We exchange the code for an access token and refresh token, which we save.
\n You can request your access token at{\" \"}\n \n https://{new URL(c.req.url).hostname}/token?state={c.get(\"state\")}\n \n
If your access token expires, we use the refresh token to get a new one.
Use your access token to make requests to the Spotify API by importing `getSpotifyToken` in your other vals.

\n\n

\n Get started\n

\n\n

\n

\n If you get in a broken state, you can always{\" \"}\n \n remove access to this app from your Spotify account\n or clear your cookies and begin the token generation process again.\n

\n ))\n .get(\"/scopes\", c =>\n c.html(\n

Choose your Spotify Scopes

\n \n

\n ))\n .get(\"/login\", async (c) => {\n const state = c.get(\"state\");\n const scopes = c.req.queries(\"scopes[]\").join(\" \");\n\n await insertPendingCallback({ id: state });\n const params = new URLSearchParams({\n response_type: 'code',\n client_id: Deno.env.get(\"CLIENT_ID\"),\n scope: scopes,\n redirect_uri,\n state,\n })\n return c.redirect(\n `https://accounts.spotify.com/authorize?${params}`);\n}).get(\"/callback\", async (c) => {\n const code = c.req.query(\"code\");\n const state = c.req.query(\"state\") as string;\n\n if (state !== c.get(\"state\")) {\n return c.html(\"State mismatch 1\");\n }\n\n const rowInitial = getRow(state)\n if (!rowInitial) {\n return c.html(\"State mismatch 2\");\n }\n if (rowInitial.data) {\n return c.html(\"Already authenticated for that state\");\n }\n\n const data = await spotifyRequestToken({\n code,\n client_id: Deno.env.get(\"CLIENT_ID\"),\n client_secret: Deno.env.get(\"CLIENT_SECRET\"),\n redirect_uri,\n });\n\n if (data.error) return c.json(data.error);\n if (!data.access_token) return c.json(\"No access token\");\n await updateRow(state, { data })\n if (data.refresh_token) await updateRow(state, { refresh_token });\n\n return c.redirect(\"/token?state=\" + state);\n})\n .get(\"/token\", async (c) => {\n const state = c.req.query(\"state\") as string;\n try {\n const token = await getSpotifyToken(state);\n return c.json(token);\n } catch (e) {\n if (e === \"NO_DATA\") return c.json(\"No auth data found for supplied state\");\n if (e === \"NO_TOKEN\") return c.json(\"No refresh access token\");\n if (e.startsWith(\"REFRESH_ERROR: \")) return c.json(\"Refresh error: \" + e.split(\" : \")[1]);\n throw e;\n }\n});\n\nexport default app.fetch;","children",[],[60],"ba3303de-e342-11ef-8ff1-e6cdfca9ef9f","getSpotifyToken","726e71c8-e342-11ef-9c89-e6cdfca9ef9f",23,["D",1738706120298],2,"import { getRow, getLatestRefreshRow, updateRow } from\"./db\";\n\nexport async function getSpotifyToken(state: string) {\n const authData = await getRow(state);\n if (!authData) throw \"NO_DATA\";\n\n const data = JSON.parse(authData.data);\n let expiresAt = data.now + (data.expires_in * 1000);\n if (expiresAt > Date.now()) {\n return data.access_token;\n }\n const refreshData = await getLatestRefreshRow(state);\n if (!refreshData) throw \"NO_DATA\";\n let refresh = await spotifyRefreshToken({\n refresh_token: refreshData.refresh_token,\n client_id: Deno.env.get(\"CLIENT_ID\"),\n client_secret: Deno.env.get(\"CLIENT_SECRET\"),\n });\n if (refresh.error) {\n console.error(refresh.error, refresh.error_description);\n throw \"REFRESH_ERROR: \" + refresh.error;\n }\n if (!refresh.access_token) throw \"NO_TOKEN\";\n await updateRow(state, { data: refresh })\n if (refresh.refresh_token) await updateRow(state, { refresh_token: refresh.refresh_token });\n return refresh.access_token\n}",[],[71],["D",1738706138130],[],[19],"ed58e7dc-e343-11ef-8a44-e6cdfca9ef9f","README.md","bd4e58c4-e343-11ef-9bbe-e6cdfca9ef9f",28,["D",1738706635603],1,"# spotifyOauthServer\n\nInstantly handle Spotify access with this server!\n\nHandles the token generation and refreshing as required.\n\nMake sure to set the CLIENT_ID and CLIENT_SECRET environment variables, as well as the URL of the server in the code.",[],[83],"55dbb4f8-e33d-11ef-baf2-e6cdfca9ef9f",["D",1738703804472],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","8acb974a-4b91-4d4a-b000-6f28827b7e16","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","b74060f0-0f1d-44f1-bee2-bdb9c9cf72e4","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_144":140},"org",{"_11":12,"_138":-5,"_139":140,"_100":101,"_141":142,"_143":52},"branch",{"_17":85,"_13":16,"_33":39,"_130":91,"_131":-5,"_132":-5,"_133":-5,"_134":-5,"_135":-5,"_136":14,"_137":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://secure.gravatar.com/avatar/109fa713caf4e083c57622b7c6dad365.jpg?s=200&d=identicon","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":91,"_13":14,"_44":186,"_93":-5,"_94":52,"_95":96,"_97":96,"_98":-5,"_99":-5,"_100":101,"_102":61,"_103":52,"_104":-5,"_105":-5,"_106":107,"_108":109,"_110":-5,"_111":-5,"_112":-5,"_113":-5,"_114":115,"_116":115,"_117":118,"_119":118,"_120":118,"_121":115,"_122":115,"_123":187,"_125":188,"_127":189,"_129":52},[174,175,176,177],"files",[174,175,176,177],"counts",{"_165":107,"_166":87,"_167":87,"_32":168,"_169":170},[],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_18":164},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],"pulls","branches","forks",{"_171":107,"_173":107},"connections",{"_171":107,"_172":107},"count","unfilledCount","emptyCount",{"_33":82,"_13":83,"_35":84,"_37":-5,"_38":39,"_40":85,"_42":43,"_44":86,"_17":87,"_47":24,"_49":88,"_51":52,"_53":-5,"_67":184,"_18":185},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":79,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_67":182,"_18":183},{"_33":70,"_13":71,"_35":72,"_37":-5,"_38":39,"_40":73,"_42":43,"_44":74,"_17":75,"_47":48,"_49":76,"_51":52,"_53":-5,"_67":180,"_18":181},{"_33":59,"_13":60,"_35":61,"_37":-5,"_38":39,"_40":62,"_42":43,"_44":63,"_17":64,"_47":65,"_49":66,"_51":52,"_53":-5,"_67":178,"_18":179},[],[60],[],[71],[],[19],[],[83],["D",1738703804472],{"_11":12,"_144":140},{"_11":12,"_138":-5,"_139":140,"_100":101,"_141":142,"_143":52},{"_17":85,"_13":16,"_33":39,"_130":91,"_131":-5,"_132":-5,"_133":-5,"_134":-5,"_135":-5,"_136":14,"_137":12},"ctx",{"_123":-5,"_161":223,"_224":225,"_226":227,"_228":52,"_229":52,"_230":52,"_231":43,"_232":-5,"_233":-7,"_234":-7,"_235":107,"_236":52,"_237":52,"_238":-5,"_239":52,"_240":52,"_241":52,"_242":-5},"ENV",{"_194":195,"_196":197,"_198":16,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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"]