Spotify Playlist Search

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",[142],"165249e5-b190-430b-9623-c099bdaa4422","index.html","5b28a984-8170-11f1-96c7-1607ee4eb77e",15,["D",1784246200395],"\n\n\n \n \n Spotify Playlist Search\n \n\n\n

\n \n\n\n",[150],"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",[157],"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",[164],"pulls","branches",1,"forks","envVars",{"_178":159,"_180":42},"connections",{"_178":42,"_179":42},"count","unfilledCount","emptyCount",{"_18":163,"_20":164,"_118":165,"_120":-5,"_121":71,"_122":166,"_124":38,"_22":203,"_68":159,"_127":99,"_129":168,"_131":26,"_132":-5,"_188":204,"_88":205},{"_18":156,"_20":157,"_118":158,"_120":-5,"_121":71,"_122":159,"_124":38,"_22":200,"_68":42,"_127":128,"_129":161,"_131":26,"_132":-5,"_188":201,"_88":202},{"_18":149,"_20":150,"_118":151,"_120":-5,"_121":71,"_122":152,"_124":38,"_22":197,"_68":126,"_127":99,"_129":154,"_131":26,"_132":-5,"_188":198,"_88":199},{"_18":141,"_20":142,"_118":36,"_120":-5,"_121":71,"_122":143,"_124":38,"_22":194,"_68":42,"_127":145,"_129":146,"_131":26,"_132":147,"_188":195,"_88":196},{"_18":134,"_20":135,"_118":136,"_120":-5,"_121":71,"_122":69,"_124":38,"_22":191,"_68":138,"_127":128,"_129":139,"_131":26,"_132":-5,"_188":192,"_88":193},{"_18":116,"_20":117,"_118":119,"_120":-5,"_121":71,"_122":123,"_124":38,"_22":187,"_68":126,"_127":128,"_129":130,"_131":26,"_132":-5,"_188":189,"_88":190},["D",1784246436698],"children",[],[117],["D",1784246466026],[],[135],["D",1784245524420],[],[142],["D",1784246200395],[],[150],["D",1784245447761],[],[157],["D",1784245577759],[],[164],["D",1784245417983],["D",1789489305251],{"_16":17,"_86":82},{"_16":17,"_80":-5,"_81":82,"_33":34,"_83":84,"_85":26},{"_68":69,"_20":70,"_18":71,"_72":19,"_73":-5,"_74":-5,"_75":-5,"_76":-5,"_77":-5,"_78":21,"_79":17},"ctx",{"_61":-5,"_107":244,"_245":246,"_247":248,"_249":26,"_250":26,"_251":26,"_252":38,"_253":-5,"_254":-7,"_255":-7,"_256":42,"_257":26,"_258":26,"_259":-5,"_260":26,"_261":26,"_262":26,"_263":-5},"ENV",{"_215":216,"_217":218,"_219":70,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243},"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"]