/** @jsxImportSource npm:hono@3/jsx */ import { getSpotifyTrackUrl } from "https://esm.town/v/dthyresson/getSpotifyTrackUrl"; import { perform as refreshTracks, refreshTrackFromBlobKey } from "https://esm.town/v/dthyresson/processTrackBlobsJob"; import processTrackBlobsJob from "https://esm.town/v/dthyresson/processTrackBlobsJob"; import { sqlite } from "https://esm.town/v/std/sqlite"; import tailwindURL from "https://esm.town/v/stevekrouse/tailwindURL?v=2"; import { asc, desc, not, sql } from "npm:drizzle-orm"; import { drizzle } from "npm:drizzle-orm/libsql"; import { integer, sqliteTable, text } from "npm:drizzle-orm/sqlite-core"; import { Hono } from "npm:hono"; type Track = { id: number | null; artist: string; title: string; track_id: string | null; icon_url: string | null; url: string | null; is_hidden: number | null; }; const db = drizzle(sqlite as any); const tracks = sqliteTable("tracks", { id: integer("id").primaryKey(), track_id: text("track_id").notNull(), artist: text("artist"), title: text("title"), url: text("url"), image_url: text("image_url"), thumbnail_url: text("thumbnail_url"), icon_url: text("icon_url"), duration_ms: text("duration_ms"), duration: text("duration"), is_hidden: integer("is_hidden", { mode: "boolean" }), }); const favoriteSongSearches = sqliteTable("favorite_song_searches", { id: integer("id").primaryKey(), track_id: text("track_id").notNull(), artist: text("artist"), title: text("title"), is_hidden: integer("is_hidden", { mode: "boolean" }), }); async function getSongCatalog() { return await db.select().from(tracks).where(not(tracks.is_hidden)).orderBy(tracks.artist, tracks.title); } async function getRecentSearches() { return await db.select().from(favoriteSongSearches).where(not(favoriteSongSearches.is_hidden)).orderBy( desc(favoriteSongSearches.id), ); } async function getArtists() { return await db.selectDistinct({ artist: tracks.artist }).from(tracks).where(not(tracks.is_hidden)).orderBy( asc(tracks.artist), ); } const app = new Hono(); app.get("/refresh", (c) => { refreshTracks(); return c.redirect("/"); }); app.get("/about", (c) => { return c.redirect("https://www.val.town/v/dthyresson/playMeASong"); }); app.get("/", async (c) => { let errorMessage = ""; const artist = c.req.query("artist") && c.req.query("artist").trim(); const title = c.req.query("title") && c.req.query("title").trim(); if (artist && title) { try { const spotifyInfo = await getSpotifyTrackUrl(artist, title, { format: "web" }); if (spotifyInfo) { const { trackUrl, id, artists, name } = spotifyInfo; if (trackUrl) { const t = { artist: artists[0].name, title: name, track_id: id, is_hidden: 0 } as Track; await db.insert(favoriteSongSearches) .values(t) .onConflictDoNothing(); const key = `spotify_track_id:${id}`; await refreshTrackFromBlobKey(key); return c.redirect(trackUrl); } } errorMessage = `Could not get track for ${artist} and ${title}`; } catch (e) { errorMessage = `Could not get track. Might be a 429. ${e.message}`; console.error(errorMessage, e); } } const recent = await getRecentSearches(); const recentWithUrls = await Promise.all(recent.map(async (track) => { const { trackUrl } = await getSpotifyTrackUrl(track.artist, track.title, { format: "web" }); return { ...track, trackUrl }; })); const songs = await getSongCatalog(); const artists = await getArtists(); const jsx = ( Play me a song in Spotify

🎶 Play me a song in Spotify...

{errorMessage &&

{errorMessage}

}

⏱️ Recent Searches

🔊 {track.artist} - {track.title}

Note: Resets daily

🗃️ Songs List

{songs.map((track) => (

{track.artist} - {track.title}

))}

🎤 Play Random from a Band

{artists.map((band) => (

🔀 {band.artist}

))}

🔀 Refresh

); return c.html( jsx.toString(), { headers: { "Content-Type": "text/html", }, }, ); }); export default app.fetch;