Spotify Playlist Search

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_227":228,"_229":230},"routes/_app.x.$handle.$name",{"_106":105,"_38":51,"_114":96,"_33":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_26":-5,"_126":-5,"_127":-5,"_128":31,"_129":130,"_131":65,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":77,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":89,"_90":91,"_92":93,"_94":31},"version",18,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","853ec40f-1946-4c95-96ca-380bb701fbaf","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","spotify.ts","latestPath","fileId","3443b7d2-8170-11f1-b0aa-1607ee4eb77e","name","fileType","script","content","import { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nconst SPOTIFY_AUTH = \"https://accounts.spotify.com/authorize\";\nconst SPOTIFY_TOKEN = \"https://accounts.spotify.com/api/token\";\nconst SPOTIFY_API = \"https://api.spotify.com/v1\";\n\nconst SCOPES = \"playlist-read-private playlist-read-collaborative\";\nconst TOKEN_KEY = \"spotify_tokens\";\n\ninterface TokenData {\n access_token: string;\n refresh_token: string;\n expires_at: number; // unix ms\n}\n\n/** Build the Spotify OAuth authorize URL */\nexport function getAuthorizeURL(redirectUri: string, state: string): string {\n const params = new URLSearchParams({\n client_id: Deno.env.get(\"SPOTIFY_CLIENT_ID\")!,\n response_type: \"code\",\n redirect_uri: redirectUri,\n scope: SCOPES,\n state,\n });\n return `${SPOTIFY_AUTH}?${params}`;\n}\n\n/** Exchange authorization code for access + refresh tokens */\nexport async function exchangeCode(code: string, redirectUri: string): Promise {\n const res = await fetch(SPOTIFY_TOKEN, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n 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 if (!res.ok) {\n const body = await res.text();\n throw new Error(`Spotify token exchange failed: ${res.status} ${body}`);\n }\n const data = await res.json();\n const tokens: TokenData = {\n access_token: data.access_token,\n refresh_token: data.refresh_token,\n expires_at: Date.now() + data.expires_in * 1000,\n };\n await blob.setJSON(TOKEN_KEY, tokens);\n return tokens;\n}\n\n/** Refresh an expired access token using the refresh token */\nasync function refreshToken(refreshToken: string): Promise {\n const res = await fetch(SPOTIFY_TOKEN, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n grant_type: \"refresh_token\",\n refresh_token: refreshToken,\n client_id: Deno.env.get(\"SPOTIFY_CLIENT_ID\")!,\n client_secret: Deno.env.get(\"SPOTIFY_CLIENT_SECRET\")!,\n }),\n });\n if (!res.ok) {\n const body = await res.text();\n throw new Error(`Spotify token refresh failed: ${res.status} ${body}`);\n }\n const data = await res.json();\n const tokens: TokenData = {\n access_token: data.access_token,\n refresh_token: data.refresh_token ?? refreshToken, // Spotify may issue a new one\n expires_at: Date.now() + data.expires_in * 1000,\n };\n await blob.setJSON(TOKEN_KEY, tokens);\n return tokens;\n}\n\n/** Get a valid access token, refreshing if necessary */\nexport async function getAccessToken(): Promise {\n const tokens = await blob.getJSON(TOKEN_KEY);\n if (!tokens) throw new Error(\"Not authenticated with Spotify\");\n // Refresh if token expires in the next 5 minutes\n if (Date.now() > tokens.expires_at - 5 * 60 * 1000) {\n const refreshed = await refreshToken(tokens.refresh_token);\n return refreshed.access_token;\n }\n return tokens.access_token;\n}\n\n/** Check if user has stored Spotify tokens */\nexport async function isAuthenticated(): Promise {\n const tokens = await blob.getJSON(TOKEN_KEY);\n return !!tokens;\n}\n\nexport interface Playlist {\n id: string;\n name: string;\n description: string;\n uri: string;\n image: string | null;\n tracksHref: string;\n trackCount: number;\n}\n\nexport interface Track {\n name: string;\n artist: string;\n album: string;\n uri: string;\n playlistName: string;\n playlistUri: string;\n playlistImage: string | null;\n addedAt: string;\n}\n\n/** Fetch all playlists for the authenticated user (paginated) */\nexport async function fetchAllPlaylists(): Promise {\n const accessToken = await getAccessToken();\n const playlists: Playlist[] = [];\n let url: string | null =\n `${SPOTIFY_API}/me/playlists?limit=50&offset=0`;\n\n while (url) {\n const res = await fetch(url, {\n headers: { Authorization: `Bearer ${accessToken}` },\n });\n if (!res.ok) {\n const body = await res.text();\n throw new Error(`Spotify playlists fetch failed: ${res.status} ${body}`);\n }\n const data = await res.json();\n for (const p of data.items) {\n playlists.push({\n id: p.id,\n name: p.name,\n description: p.description ?? \"\",\n uri: p.uri,\n image: p.images?.[0]?.url ?? null,\n tracksHref: p.tracks?.href ?? \"\",\n trackCount: p.tracks?.total ?? 0,\n });\n }\n url = data.next;\n }\n return playlists;\n}\n\n/** Fetch all tracks for a single playlist (paginated) */\nexport async function fetchPlaylistTracks(\n playlist: Playlist,\n onProgress?: (fetched: number, total: number) => void,\n): Promise {\n const accessToken = await getAccessToken();\n const tracks: Track[] = [];\n const params = new URLSearchParams({\n limit: \"50\",\n offset: \"0\",\n additional_types: \"track\",\n });\n let url: string | null =\n `${SPOTIFY_API}/playlists/${playlist.id}/items?${params}`;\n\n while (url) {\n const res = await fetch(url, {\n headers: { Authorization: `Bearer ${accessToken}` },\n });\n if (!res.ok) {\n const body = await res.text();\n throw new Error(`Spotify tracks fetch failed: ${res.status} ${body}`);\n }\n const data = await res.json();\n for (const item of data.items) {\n // Skip null tracks (e.g., local files that Spotify can't resolve)\n if (!item?.track?.name) continue;\n tracks.push({\n name: item.track.name,\n artist: item.track.artists.map((a: { name: string }) => a.name).join(\", \"),\n album: item.track.album?.name ?? \"\",\n uri: item.track.uri,\n playlistName: playlist.name,\n playlistUri: playlist.uri,\n playlistImage: playlist.image,\n addedAt: item.added_at ?? \"\",\n });\n }\n onProgress?.(tracks.length, data.total ?? playlist.trackCount);\n url = data.next;\n }\n return tracks;\n}\n","import { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nconst SPOTIFY_AUTH = \"https://accounts.spotify.com/authorize\";\nconst SPOTIFY_TOKEN = \"https://accounts.spotify.com/api/token\";\nconst SPOTIFY_API = \"https://api.spotify.com/v1\";\n\nconst SCOPES = \"playlist-read-private playlist-read-collaborative\";\nconst TOKEN_KEY = \"spotify_tokens\";\n\ninterface TokenData {\n access_token: string;\n refresh_token: string;\n expires_at: number; // unix ms\n}\n\n/** Build the Spotify OAuth authorize URL */\nexport function getAuthorizeURL(redirectUri: string, state: string): string {\n const params = new URLSearchParams({\n client_id: Deno.env.get(\"SPOTIFY_CLIENT_ID\")!,\n response_type: \"code\",\n redirect_uri: redirectUri,\n scope: SCOPES,\n state,\n });\n return `${SPOTIFY_AUTH}?${params}`;\n}\n\n/** Exchange authorization code for access + refresh tokens */\nexport async function exchangeCode(code: string, redirectUri: string): Promise {\n const res = await fetch(SPOTIFY_TOKEN, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n 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 if (!res.ok) {\n const body = await res.text();\n throw new Error(`Spotify token exchange failed: ${res.status} ${body}`);\n }\n const data = await res.json();\n const tokens: TokenData = {\n access_token: data.access_token,\n refresh_token: data.refresh_token,\n expires_at: Date.now() + data.expires_in * 1000,\n };\n await blob.setJSON(TOKEN_KEY, tokens);\n return tokens;\n}\n\n/** Refresh an expired access token using the refresh token */\nasync function refreshToken(refreshToken: string): Promise {\n const res = await fetch(SPOTIFY_TOKEN, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n grant_type: \"refresh_token\",\n refresh_token: refreshToken,\n client_id: Deno.env.get(\"SPOTIFY_CLIENT_ID\")!,\n client_secret: Deno.env.get(\"SPOTIFY_CLIENT_SECRET\")!,\n }),\n });\n if (!res.ok) {\n const body = await res.text();\n throw new Error(`Spotify token refresh failed: ${res.status} ${body}`);\n }\n const data = await res.json();\n const tokens: TokenData = {\n access_token: data.access_token,\n refresh_token: data.refresh_token ?? refreshToken, // Spotify may issue a new one\n expires_at: Date.now() + data.expires_in * 1000,\n };\n await blob.setJSON(TOKEN_KEY, tokens);\n return tokens;\n}\n\n/** Get a valid access token, refreshing if necessary */\nexport async function getAccessToken(): Promise {\n const tokens = await blob.getJSON(TOKEN_KEY);\n if (!tokens) throw new Error(\"Not authenticated with Spotify\");\n // Refresh if token expires in the next 5 minutes\n if (Date.now() > tokens.expires_at - 5 * 60 * 1000) {\n const refreshed = await refreshToken(tokens.refresh_token);\n return refreshed.access_token;\n }\n return tokens.access_token;\n}\n\n/** Check if user has stored Spotify tokens */\nexport async function isAuthenticated(): Promise {\n const tokens = await blob.getJSON(TOKEN_KEY);\n return !!tokens;\n}\n\nexport interface Playlist {\n id: string;\n name: string;\n description: string;\n uri: string;\n image: string | null;\n tracksHref: string;\n trackCount: number;\n}\n\nexport interface Track {\n name: string;\n artist: string;\n album: string;\n uri: string;\n playlistName: string;\n playlistUri: string;\n playlistImage: string | null;\n addedAt: string;\n}\n\n/** Fetch all playlists for the authenticated user (paginated) */\nexport async function fetchAllPlaylists(): Promise {\n const accessToken = await getAccessToken();\n const playlists: Playlist[] = [];\n let url: string | null =\n `${SPOTIFY_API}/me/playlists?limit=50&offset=0`;\n\n while (url) {\n const res = await fetch(url, {\n headers: { Authorization: `Bearer ${accessToken}` },\n });\n if (!res.ok) {\n const body = await res.text();\n throw new Error(`Spotify playlists fetch failed: ${res.status} ${body}`);\n }\n const data = await res.json();\n for (const p of data.items) {\n playlists.push({\n id: p.id,\n name: p.name,\n description: p.description ?? \"\",\n uri: p.uri,\n image: p.images?.[0]?.url ?? null,\n tracksHref: p.tracks?.href ?? \"\",\n trackCount: p.tracks?.total ?? 0,\n });\n }\n url = data.next;\n }\n return playlists;\n}\n\n/** Fetch all tracks for a single playlist (paginated) */\nexport async function fetchPlaylistTracks(\n playlist: Playlist,\n onProgress?: (fetched: number, total: number) => void,\n): Promise {\n const accessToken = await getAccessToken();\n const tracks: Track[] = [];\n const params = new URLSearchParams({\n limit: \"50\",\n offset: \"0\",\n additional_types: \"track\",\n fields: \"items(added_at,track(name,uri,artists(name),album(name))),next,total\",\n });\n let url: string | null =\n `${SPOTIFY_API}/playlists/${playlist.id}/items?${params}`;\n\n while (url) {\n const res = await fetch(url, {\n headers: { Authorization: `Bearer ${accessToken}` },\n });\n if (!res.ok) {\n const body = await res.text();\n throw new Error(`Spotify tracks fetch failed: ${res.status} ${body}`);\n }\n const data = await res.json();\n for (const item of data.items) {\n // Skip null tracks (e.g., local files that Spotify can't resolve)\n if (!item?.track?.name) continue;\n tracks.push({\n name: item.track.name,\n artist: item.track.artists.map((a: { name: string }) => a.name).join(\", \"),\n album: item.track.album?.name ?? \"\",\n uri: item.track.uri,\n playlistName: playlist.name,\n playlistUri: playlist.uri,\n playlistImage: playlist.image,\n addedAt: item.added_at ?? \"\",\n });\n }\n onProgress?.(tracks.length, data.total ?? playlist.trackCount);\n url = data.next;\n }\n return tracks;\n}\n","createdAt",["D",1784246422251],"branchVersion","branchId","8f73afca-9b8b-4154-8dea-7e96834ce4f8","id","62af4618-56c9-46d3-91f0-9f34eee0a526","spotify-playlist-search",["D",1784245417983],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Full-text search across all your Spotify playlists","imageUrl","666a7e32-624c-44a1-9017-c098238b910d","pinnedFileId","6a42df98-8170-11f1-8580-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","3bbc0830-e929-4c19-b058-a1674c911b22","tursoName","62af461856c946d391f09f34eee0a526","tursoHostname","62af461856c946d391f09f34eee0a526-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789489305251],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_106":105,"_113":109},"org",{"_106":105,"_107":-5,"_108":109,"_19":61,"_110":111,"_112":31},"branch",{"_13":95,"_38":96,"_49":48,"_97":50,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":51,"_104":105},"isOwned",22,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","tod","handle","displayName","avatar","https://secure.gravatar.com/avatar/8effe5d6ffbba460f8a5617306c9ba5b&d=identicon","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_38":51,"_44":222,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":223,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":224,"_90":225,"_92":226,"_94":31},"tree",[197,198,199,200,201,202],"files",[197,198,199,200,201,202],"counts",{"_187":69,"_188":149,"_189":69,"_190":191,"_192":193},"contents",[136,137,138,139,140,141],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":180,"_38":181,"_36":182,"_145":-5,"_47":48,"_46":183,"_147":65,"_44":184,"_13":176,"_39":26,"_41":185,"_30":31,"_151":-5,"_33":186},{"_49":173,"_38":174,"_36":175,"_145":-5,"_47":48,"_46":176,"_147":65,"_44":177,"_13":69,"_39":40,"_41":178,"_30":31,"_151":-5,"_33":179},{"_49":165,"_38":166,"_36":167,"_145":-5,"_47":48,"_46":168,"_147":65,"_44":169,"_13":170,"_39":26,"_41":171,"_30":31,"_151":-5,"_33":172},{"_49":157,"_38":158,"_36":63,"_145":-5,"_47":48,"_46":159,"_147":65,"_44":160,"_13":69,"_39":161,"_41":162,"_30":31,"_151":163,"_33":164},{"_49":153,"_38":34,"_36":37,"_145":-5,"_47":48,"_46":14,"_147":31,"_44":154,"_13":155,"_39":40,"_41":43,"_30":31,"_151":-5,"_33":156},{"_49":142,"_38":143,"_36":144,"_145":-5,"_47":48,"_46":146,"_147":31,"_44":148,"_13":149,"_39":40,"_41":150,"_30":31,"_151":-5,"_33":152},"266de5d4-9c97-455a-bcaa-5132832295b2","sync.ts","3ff57e62-8170-11f1-88a5-1607ee4eb77e","parentId",14,"latest",["D",1784246197888],1,"import { fetchAllPlaylists, fetchPlaylistTracks } from \"./spotify.ts\";\nimport { initDB, reindexTracks } from \"./db.ts\";\n\nexport interface SyncProgress {\n playlistsTotal: number;\n playlistsDone: number;\n tracksTotal: number;\n tracksDone: number;\n currentPlaylist: string;\n done: boolean;\n error?: string;\n}\n\n/**\n * Sync all playlists and tracks from Spotify into the FTS index.\n * Returns a summary of what was synced.\n */\nexport async function syncAll(): Promise<{\n playlists: number;\n tracks: number;\n skipped: string[];\n}> {\n await initDB();\n\n // 1. Fetch all playlists\n const playlists = await fetchAllPlaylists();\n\n // 2. Fetch tracks for each playlist, collecting into one array\n const allTracks = [];\n const skipped: string[] = [];\n for (const playlist of playlists) {\n try {\n const tracks = await fetchPlaylistTracks(playlist);\n allTracks.push(...tracks);\n } catch (e) {\n // Skip playlists that Spotify refuses to serve (403/404) —\n // e.g. Discover Weekly, other restricted Spotify-created playlists\n skipped.push(playlist.name);\n console.log(`Skipped playlist \"${playlist.name}\": ${e.message}`);\n }\n }\n\n // 3. Re-index everything\n await reindexTracks(allTracks);\n\n return {\n playlists: playlists.length - skipped.length,\n tracks: allTracks.length,\n skipped,\n };\n}\n","label",[143],"9d72c9b7-8f63-47ed-b06b-314306dd6fc6",["D",1784246422251],4,[34],"4379b76c-496c-4adf-a393-098360b74704","main.ts",5,["D",1784245524420],"http","import { Hono } from \"npm:hono\";\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nimport {\n getAuthorizeURL,\n exchangeCode,\n isAuthenticated,\n} from \"./spotify.ts\";\nimport { initDB, searchTracks, getTrackCount } from \"./db.ts\";\nimport { syncAll } from \"./sync.ts\";\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\nlet dbReady = false;\nasync function ensureDB() {\n if (!dbReady) {\n await initDB();\n dbReady = true;\n }\n}\n\napp.get(\"/\", async (c) => {\n return await serveFile(\"index.html\");\n});\n\napp.get(\"/auth/login\", (c) => {\n const url = new URL(c.req.url);\n const redirectUri = `${url.origin}/auth/callback`;\n const state = crypto.randomUUID();\n blob.setJSON(\"oauth_state\", { state, redirectUri });\n return c.redirect(getAuthorizeURL(redirectUri, state));\n});\n\napp.get(\"/auth/callback\", async (c) => {\n const code = c.req.query(\"code\");\n const state = c.req.query(\"state\");\n const error = c.req.query(\"error\");\n\n if (error) {\n return c.html(\n `

Authorization failed

Spotify error: ${error}

Try again`,\n );\n }\n if (!code || !state) {\n return c.html('

Missing authorization code

Try again');\n }\n\n const stored = await blob.getJSON<{ state: string; redirectUri: string }>(\n \"oauth_state\",\n );\n if (!stored || stored.state !== state) {\n return c.html(\n '

Invalid state parameter

OAuth state mismatch. Please try again.

Try again',\n );\n }\n\n try {\n await exchangeCode(code, stored.redirectUri);\n await blob.delete(\"oauth_state\");\n return c.redirect(\"/\");\n } catch (e) {\n return c.html(\n `

Token exchange failed

${e.message}

Try again`,\n );\n }\n});\n\napp.get(\"/api/status\", async (c) => {\n await ensureDB();\n const authed = await isAuthenticated();\n const trackCount = authed ? await getTrackCount() : 0;\n return c.json({ authenticated: authed, trackCount });\n});\n\napp.get(\"/api/search\", async (c) => {\n await ensureDB();\n const q = c.req.query(\"q\");\n if (!q?.trim()) return c.json({ results: [] });\n try {\n const results = await searchTracks(q.trim());\n return c.json({ results });\n } catch (e) {\n return c.json({ results: [], error: e.message }, 500);\n }\n});\n\napp.post(\"/api/sync\", async (c) => {\n await ensureDB();\n try {\n const result = await syncAll();\n return c.json(result);\n } catch (e) {\n return c.json({ error: e.message }, 500);\n }\n});\n\nexport default app.fetch;\n","spotify-search",[158],"165249e5-b190-430b-9623-c099bdaa4422","index.html","5b28a984-8170-11f1-96c7-1607ee4eb77e",15,["D",1784246200395],3,"\n\n\n \n \n Spotify Playlist Search\n \n\n\n

\n \n\n\n",[166],"45aa685c-b05d-4f90-b386-28b752569aaf","db.ts","3c917014-8170-11f1-8990-1607ee4eb77e",2,["D",1784245447761],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Track } from \"./spotify.ts\";\n\n/** Create the FTS5 table if it doesn't exist */\nexport async function initDB() {\n await sqlite.execute(`\n CREATE VIRTUAL TABLE IF NOT EXISTS tracks_fts USING fts5(\n track_name,\n artist_name,\n album_name,\n playlist_name,\n track_uri UNINDEXED,\n playlist_uri UNINDEXED,\n playlist_image UNINDEXED,\n added_at UNINDEXED\n )\n `);\n}\n\n/** Wipe and re-index all tracks */\nexport async function reindexTracks(tracks: Track[]) {\n await sqlite.execute(`DELETE FROM tracks_fts`);\n\n // Insert in batches of 100 for efficiency\n const BATCH_SIZE = 100;\n for (let i = 0; i < tracks.length; i += BATCH_SIZE) {\n const batch = tracks.slice(i, i + BATCH_SIZE);\n const statements = batch.map((t) => ({\n sql: `INSERT INTO tracks_fts\n (track_name, artist_name, album_name, playlist_name, track_uri, playlist_uri, playlist_image, added_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n t.name,\n t.artist,\n t.album,\n t.playlistName,\n t.uri,\n t.playlistUri,\n t.playlistImage,\n t.addedAt,\n ],\n }));\n await sqlite.batch(statements);\n }\n}\n\nexport interface SearchResult {\n track_name: string;\n artist_name: string;\n album_name: string;\n playlist_name: string;\n track_uri: string;\n playlist_uri: string;\n playlist_image: string | null;\n added_at: string;\n rank: number;\n}\n\n/** Full-text search across all indexed tracks */\nexport async function searchTracks(query: string, limit = 50): Promise {\n // Escape double quotes in the query to prevent FTS5 syntax errors\n const escaped = query.replace(/\"/g, '\"\"');\n const ftsQuery = `\"${escaped}\" *`; // prefix match on last term\n\n const result = await sqlite.execute({\n sql: `SELECT track_name, artist_name, album_name, playlist_name,\n track_uri, playlist_uri, playlist_image, added_at,\n bm25(tracks_fts) as rank\n FROM tracks_fts\n WHERE tracks_fts MATCH ?\n ORDER BY rank\n LIMIT ?`,\n args: [ftsQuery, limit],\n });\n\n return result.rows as unknown as SearchResult[];\n}\n\n/** Count total indexed tracks */\nexport async function getTrackCount(): Promise {\n const result = await sqlite.execute(`SELECT count(*) as count FROM tracks_fts`);\n const row = result.rows[0] as { count: number };\n return row.count;\n}\n",[174],"ad5a64d9-a5d1-4d56-8c7d-b1c8fa85bda2","README.md","862f7de2-8170-11f1-8eb5-1607ee4eb77e",11,["D",1784245577759],"# Spotify Playlist Search\n\nFull-text search across all your Spotify playlists. Search by track name, artist, album, or playlist name.\n\n## Setup\n\n### 1. Create a Spotify App\n\n1. Go to the [Spotify Developer Dashboard](https://developer.spotify.com/dashboard)\n2. Click **Create app**\n3. Fill in any name/description\n4. Set the **Redirect URI** to:\n ```\n https://spotify-search.val.run/auth/callback\n ```\n5. Accept the terms and create\n6. Open the app settings and copy your **Client ID** and **Client Secret**\n\n### 2. Add Environment Variables\n\n👉 Add SPOTIFY_CLIENT_ID here: https://www.val.town/x/tod/spotify-playlist-search/environment-variables?key=SPOTIFY_CLIENT_ID\n\n👉 Add SPOTIFY_CLIENT_SECRET here: https://www.val.town/x/tod/spotify-playlist-search/environment-variables?key=SPOTIFY_CLIENT_SECRET\n\n### 3. Use It\n\n1. Visit [spotify-search.val.run](https://spotify-search.val.run)\n2. Click **Connect Spotify** and authorize\n3. Click **Sync** to fetch all your playlists\n4. Search across all your tracks!\n\n## How It Works\n\n- **Spotify OAuth** — Authorization Code flow with `playlist-read-private` and `playlist-read-collaborative` scopes\n- **SQLite FTS5** — Full-text search index across track name, artist, album, and playlist name\n- **Sync** — Fetches all playlists and tracks from Spotify, indexes them in SQLite with BM25 ranking\n- **Tokens** — Refresh token stored in blob storage; access tokens auto-refresh when expired\n\n## Architecture\n\n```\nspotify.ts → Spotify API client (OAuth, pagination, token refresh)\ndb.ts → SQLite FTS5 schema + search with BM25 ranking\nsync.ts → Orchestration: fetch all playlists → fetch all tracks → reindex\nmain.ts → Hono HTTP server (routes for auth, sync, search, UI)\nindex.html → Search UI (dark Spotify-themed, debounced live search)\n```\n",[181],"pulls","branches","forks","envVars",{"_194":176,"_196":69},"connections",{"_194":69,"_195":69},"count","unfilledCount","emptyCount",{"_49":180,"_38":181,"_36":182,"_145":-5,"_47":48,"_46":183,"_147":65,"_44":219,"_13":176,"_39":26,"_41":185,"_30":31,"_151":-5,"_204":220,"_33":221},{"_49":173,"_38":174,"_36":175,"_145":-5,"_47":48,"_46":176,"_147":65,"_44":216,"_13":69,"_39":40,"_41":178,"_30":31,"_151":-5,"_204":217,"_33":218},{"_49":165,"_38":166,"_36":167,"_145":-5,"_47":48,"_46":168,"_147":65,"_44":213,"_13":170,"_39":26,"_41":171,"_30":31,"_151":-5,"_204":214,"_33":215},{"_49":157,"_38":158,"_36":63,"_145":-5,"_47":48,"_46":159,"_147":65,"_44":210,"_13":69,"_39":161,"_41":162,"_30":31,"_151":163,"_204":211,"_33":212},{"_49":153,"_38":34,"_36":37,"_145":-5,"_47":48,"_46":14,"_147":31,"_44":207,"_13":155,"_39":40,"_41":43,"_30":31,"_151":-5,"_204":208,"_33":209},{"_49":142,"_38":143,"_36":144,"_145":-5,"_47":48,"_46":146,"_147":31,"_44":203,"_13":149,"_39":40,"_41":150,"_30":31,"_151":-5,"_204":205,"_33":206},["D",1784246197888],"children",[],[143],["D",1784246422251],[],[34],["D",1784245524420],[],[158],["D",1784246200395],[],[166],["D",1784245447761],[],[174],["D",1784245577759],[],[181],["D",1784245417983],["D",1789489305251],{"_106":105,"_113":109},{"_106":105,"_107":-5,"_108":109,"_19":61,"_110":111,"_112":31},{"_13":95,"_38":96,"_49":48,"_97":50,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":51,"_104":105},"ctx",{"_88":-5,"_133":260,"_261":262,"_263":264,"_265":31,"_266":31,"_267":31,"_268":65,"_269":-5,"_270":-7,"_271":-7,"_272":69,"_273":31,"_274":31,"_275":-5,"_276":31,"_277":31,"_278":31,"_279":-5},"ENV",{"_231":232,"_233":234,"_235":96,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259},"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"]

Diff · v18