TRMNL Last.fm

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_729":730,"_731":732},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_536":-5,"_20":537,"_22":538,"_539":540,"_541":542,"_26":543,"_24":544,"_545":-5,"_546":-5,"_547":62,"_548":549,"_550":54,"_551":-5,"_552":-5,"_553":554},"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","sitnik","name","trmnl-lastfm","branchName","main","version","path","frontend","project",{"_42":481,"_13":14,"_55":482,"_483":-5,"_484":62,"_485":486,"_487":486,"_488":489,"_490":-5,"_491":492,"_493":139,"_494":54,"_495":54,"_496":-5,"_497":57,"_498":499,"_500":-5,"_501":-5,"_502":-5,"_503":-5,"_504":505,"_506":505,"_507":508,"_509":508,"_510":508,"_511":505,"_512":505,"_513":514,"_515":516,"_517":518,"_519":62},"tree",[131,132,133,134,135,136],"file",{"_42":127,"_13":19,"_45":48,"_47":-5,"_49":50,"_51":70,"_53":54,"_55":128,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_18":130},"contents",[33,34,35,36,37,38,39,40,41],"upstream","pull","ahead","behind","envVars",{"_42":119,"_13":120,"_45":121,"_47":48,"_49":50,"_51":122,"_53":54,"_55":123,"_17":124,"_58":71,"_59":125,"_61":62,"_63":-5,"_18":126},{"_42":111,"_13":112,"_45":113,"_47":48,"_49":50,"_51":114,"_53":54,"_55":115,"_17":116,"_58":71,"_59":117,"_61":62,"_63":-5,"_18":118},{"_42":104,"_13":105,"_45":106,"_47":48,"_49":50,"_51":107,"_53":54,"_55":108,"_17":57,"_58":71,"_59":109,"_61":62,"_63":-5,"_18":110},{"_42":97,"_13":98,"_45":99,"_47":48,"_49":50,"_51":100,"_53":54,"_55":101,"_17":57,"_58":24,"_59":102,"_61":62,"_63":-5,"_18":103},{"_42":89,"_13":90,"_45":91,"_47":48,"_49":50,"_51":92,"_53":54,"_55":93,"_17":94,"_58":24,"_59":95,"_61":62,"_63":-5,"_18":96},{"_42":81,"_13":82,"_45":83,"_47":48,"_49":50,"_51":84,"_53":54,"_55":85,"_17":86,"_58":24,"_59":87,"_61":62,"_63":-5,"_18":88},{"_42":74,"_13":75,"_45":76,"_47":48,"_49":50,"_51":77,"_53":54,"_55":78,"_17":70,"_58":24,"_59":79,"_61":62,"_63":-5,"_18":80},{"_42":65,"_13":66,"_45":67,"_47":48,"_49":50,"_51":68,"_53":54,"_55":69,"_17":70,"_58":71,"_59":72,"_61":62,"_63":-5,"_18":73},{"_42":43,"_13":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_17":57,"_58":24,"_59":60,"_61":62,"_63":-5,"_18":64},"id","671c3034-cc72-11f0-88b9-42dde27851f2","trmnl-logo.svg","fileId","671c3138-cc72-11f0-88b9-42dde27851f2","parentId","65c54d60-cc72-11f0-88b9-42dde27851f2","branchId","650a9eac-cc72-11f0-88b9-42dde27851f2","branchVersion",13,"latest",true,"createdAt",["D",1764345217591],0,"fileType","content","\n \n \n \n \n \n \n \n","deleted",false,"label",[19,44],"fe6e8ae4-cc87-11f0-8994-42dde27851f2","settings.tsx","673dc640-cc72-11f0-bc7f-42dde27851f2",70,["D",1764354490970],1,"script","/** @jsxImportSource https://esm.sh/react@19.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@19.2.0/client\";\nimport { App } from \"./App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ndeclare global {\n interface Window {\n __INITIAL_DATA__: {\n uuid: string;\n firstName: string;\n pluginId: number;\n isConnected: boolean;\n lastfmClientId: string;\n preferences: object;\n };\n }\n}\n\ncreateRoot(root).render();",[19,66],"76df3abc-cc85-11f0-b68e-42dde27851f2","settings.html","6732efa4-cc72-11f0-99f5-42dde27851f2",60,["D",1764353404536],"\n\n \n \n \n TRMNL Last.fm\n \n \n \n \n \n \n \n

\n \n \n

Loading...

\n \n \n \n \n \n \n",[19,75],"01027f9a-cc83-11f0-891d-42dde27851f2","lastfm-logo.svg","ddc5a034-cc82-11f0-a6b5-42dde27851f2",54,["D",1764352347812],4,"",[19,82],"8c1892b2-cc98-11f0-9649-42dde27851f2","index.html","67144950-cc72-11f0-82b4-42dde27851f2",94,["D",1764361600591],5,"\n\n \n \n \n TRMNL Last.fm\n \n \n \n \n \n \n \n

\n \n

\n TRMNL Last.fm Plugin\n

\n \n

+

\n Hey, welcome! 👋\n

\n Bring your listening habits to life on your TRMNL! Track what you’ve been listening to, discover\n your top artists and songs, and enjoy a personal snapshot of\n your Last.fm throughout the day.\n

\n \n \n Click to Install this Plugin on TRMNL!\n \n \n

\n Preview\n \n \n \n

\n \n \n \n \n \n",[19,90],"6737e676-cc72-11f0-ad23-42dde27851f2","favicon.svg","6737e856-cc72-11f0-ad23-42dde27851f2",16,["D",1764345217849],"",[19,98],"674f3196-cc72-11f0-ad23-42dde27851f2","TrmnlSettings.tsx","674f324a-cc72-11f0-ad23-42dde27851f2",19,["D",1764345218002],"/** @jsxImportSource https://esm.sh/react@19.2.0 */\nimport { useState } from \"https://esm.sh/react@19.2.0\";\n\nexport function TrmnlSettings(\n { uuid, firstName, pluginId, preferences }: {\n uuid: string;\n firstName: string;\n pluginId: number;\n preferences: { displayType: string; timeRange: string };\n },\n) {\n const [loading, setLoading] = useState(false);\n const [display, setDisplay] = useState(\n preferences.displayType || \"recent_tracks\",\n );\n const [time, setTime] = useState(preferences.timeRange || \"short_term\");\n const [notification, setNotification] = useState({\n visible: false,\n type: \"success\",\n message: \"\",\n });\n\n const savePrefs = async function () {\n setLoading(true);\n\n const resp = await fetch(\"/api/prefs\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n uuid,\n prefs: {\n displayType: display,\n timeRange: time,\n },\n }),\n });\n\n setLoading(false);\n\n if (resp.status === 200) {\n setNotification({\n visible: true,\n type: \"success\",\n message: \"Preferences saved!\",\n });\n } else {\n setNotification({\n visible: true,\n type: \"danger\",\n message: `Failed to save preferences: ${resp.statusText}`,\n });\n }\n\n setTimeout(\n () => setNotification({ ...notification, visible: false }),\n 5000,\n );\n };\n\n return (\n

\n Hello, {firstName}!\n

\n Use the options below to configure what should be displayed on your TRMNL. Don't forget to hit the Save Preferences button!\n

\n {notification.visible\n ? (\n

{notification.message}

\n )\n : \"\"}\n

\n Display\n

\n \n

\n \n \n \n

\n Choose what Spotify data you want to show on your TRMNL Device\n

\n {display === \"top_artists\" || display === \"top_tracks\"\n ? (\n

\n Time Range\n

\n \n

\n \n \n \n

\n )\n : \"\"}\n

\n \n \n \n \n Save Preferences!\n \n

\n Preview\n \n {display === \"recent_tracks\" && $\"\"$ }\n {display === \"top_artists\" && $\"\"$ }\n {display === \"top_tracks\" && $\"\"$ }\n \n

\n The preview does not use your actual data.\n

\n \n

\n );\n}",[19,105],"106d8208-cc93-11f0-8cad-42dde27851f2","ConnectLastfm.tsx","6741b462-cc72-11f0-ad23-42dde27851f2",87,["D",1764359245627],12,"/** @jsxImportSource https://esm.sh/react@19.2.0 */\n\nexport function ConnectLastfm(\n { uuid, firstName, pluginId, lastfmClientId }: {\n uuid: string;\n firstName: string;\n pluginId: number;\n lastfmClientId: string;\n },\n) {\n return (\n

\n Hello, {firstName}!\n

\n \n

\n Connect Your Last.fm Account\n

\n Connect your Last.fm account to display your music data on your TRMNL\n Device\n

\n {\n globalThis.location.href =\n `http://www.last.fm/api/auth/?api_key=${lastfmClientId}&cb=https://trmnl-lastfm.val.run/lastfm/callback?state=${uuid}`;\n }}\n >\n Connect with Last.fm\n \n

\n You'll be redirected to Last.fm to authorize this connection.\n

\n \n

\n );\n}",[19,112],"238f0b32-cc92-11f0-9d8a-42dde27851f2","App.tsx","670c6a50-cc72-11f0-82b4-42dde27851f2",77,["D",1764358848227],3,"/** @jsxImportSource https://esm.sh/react@19.2.0 */\nimport { ConnectLastfm } from \"./ConnectLastfm.tsx\";\nimport { TrmnlSettings } from \"./TrmnlSettings.tsx\";\n\nexport function App(\n {\n uuid,\n firstName,\n pluginId,\n isConnected = false,\n lastfmClientId,\n preferences,\n }: {\n uuid: string;\n firstName: string;\n pluginId: number;\n isConnected: boolean;\n lastfmClientId: string;\n preferences: object;\n },\n) {\n return (\n

\n \n \n \n \n \n \n \n \n \n \n

\n TRMNL Last.fm Plugin\n

\n {isConnected\n ? (\n \n )\n : (\n \n )}\n

\n \n

\n );\n}",[19,120],"65c54c98-cc72-11f0-88b9-42dde27851f2",["D",1764345215398],"directory",[19],{"_42":466,"_13":467,"_45":468,"_47":-5,"_49":50,"_51":124,"_53":54,"_55":469,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":470,"_18":471},{"_42":127,"_13":19,"_45":48,"_47":-5,"_49":50,"_51":70,"_53":54,"_55":427,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":428,"_18":429},{"_42":358,"_13":359,"_45":360,"_47":-5,"_49":50,"_51":94,"_53":54,"_55":361,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":362,"_18":363},{"_42":181,"_13":182,"_45":183,"_47":-5,"_49":50,"_51":86,"_53":54,"_55":184,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":185,"_18":186},{"_42":147,"_13":148,"_45":149,"_47":-5,"_49":50,"_51":150,"_53":54,"_55":151,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":152,"_18":153},{"_42":137,"_13":138,"_45":139,"_47":-5,"_49":50,"_51":140,"_53":54,"_55":141,"_17":86,"_58":142,"_59":143,"_61":62,"_63":14,"_144":145,"_18":146},"6782ee4e-cc92-11f0-a946-42dde27851f2","main.ts","67103518-cc72-11f0-ad23-42dde27851f2",83,["D",1764358962231],"http","import { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono@4\";\nimport { bearerAuth } from \"npm:hono@4/bearer-auth\";\nimport {\n install,\n lastfmCallback,\n markup,\n postInstall,\n savePreferences,\n settings,\n uninstall,\n} from \"./routes/index.ts\";\n\n// create app\nconst app = new Hono();\n\n// root route\napp.get(\"/\", (c) => serveFile(\"/frontend/index.html\"));\n\n// serve frontend files\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// setup trmnl routes token protection (only on hooks and markup)\napp.use(\n \"/trmnl/{(hooks\\/(install|uninstall)|markup)}\",\n bearerAuth({\n verifyToken: (token, c) => {\n return true;\n },\n }),\n);\n\n// installation route\napp.get(\"/trmnl/install\", install);\n\n// post installation webhook\napp.post(\"/trmnl/hooks/install\", postInstall);\n\n// markup route\napp.post(\"/trmnl/markup\", markup);\n\n// uninstallation route\napp.post(\"/trmnl/hooks/uninstall\", uninstall);\n\n// configuration route\napp.get(\"/trmnl/settings\", settings);\n\n// spotify callback route\napp.get(\"/lastfm/callback\", lastfmCallback);\n\n// save user preferences\napp.post(\"/api/prefs\", savePreferences);\n\nexport default app.fetch;","children",[],[138],"65f0820a-cc72-11f0-8cd7-42dde27851f2","utils","65f082d2-cc72-11f0-8cd7-42dde27851f2",2,["D",1764345215701],[154,155,156],[148],{"_42":173,"_13":174,"_45":175,"_47":149,"_49":50,"_51":176,"_53":54,"_55":177,"_17":150,"_58":71,"_59":178,"_61":62,"_63":-5,"_144":179,"_18":180},{"_42":165,"_13":166,"_45":167,"_47":149,"_49":50,"_51":168,"_53":54,"_55":169,"_17":57,"_58":71,"_59":170,"_61":62,"_63":-5,"_144":171,"_18":172},{"_42":157,"_13":158,"_45":159,"_47":149,"_49":50,"_51":160,"_53":54,"_55":161,"_17":57,"_58":71,"_59":162,"_61":62,"_63":-5,"_144":163,"_18":164},"6752d742-cc72-11f0-9641-42dde27851f2","spotifyService.ts","6752d800-cc72-11f0-9641-42dde27851f2",20,["D",1764345218024],"import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport process from \"node:process\";\nimport { Buffer } from \"node:buffer\";\n\nconst { SPOTIFY_CLIENT_ID, SPOTIFY_CLIENT_SECRET } = process.env;\n\nexport async function refreshToken(uuid: string, refreshToken: string) {\n const params = new URLSearchParams();\n params.append(\"grant_type\", \"refresh_token\");\n params.append(\"refresh_token\", refreshToken);\n\n const authHeader = Buffer.from(`${SPOTIFY_CLIENT_ID}:${SPOTIFY_CLIENT_SECRET}`).toString(\"base64\");\n\n const resp = await fetch(\"https://accounts.spotify.com/api/token\", {\n method: \"post\",\n headers: {\n 'Content-Type': 'application/x-www-form-urlencoded',\n authorization: `Basic ${authHeader}`,\n },\n body: params,\n });\n\n // TODO: better error handling here (throw and catch on caller, then render error template)\n if (!resp.ok) {\n console.error(`Failed to refresh Spotify access token: ${await resp.text()}`);\n }\n\n const data = await resp.json();\n\n // calculate token expiration time\n const now = Math.floor(Date.now() / 1000);\n const expiresAt = now + data.expires_in;\n\n // update database\n await sqlite.execute({\n sql: \"update tokens set access_token = :access_token, refresh_token = :refresh_token, expires_at = :expires_at where uuid = :uuid\",\n args: {\n access_token: data.access_token,\n refresh_token: data.refresh_token ?? refreshToken, // use the same if not returned as per the Spotify docs\n expires_at: expiresAt,\n uuid: uuid,\n }\n });\n\n // return refreshed token\n return data.access_token;\n}\n\nexport async function getRecentTracks(accessToken: string, limit: number) {\n const resp = await fetch(`https://api.spotify.com/v1/me/player/recently-played?limit=${limit}`, {\n headers: {\n authorization: `Bearer ${accessToken}`\n }\n });\n\n return await resp.json();\n}\n\nexport async function getTopTracks(accessToken: string, timeRange: string, limit: number) {\n const resp = await fetch(`https://api.spotify.com/v1/me/top/tracks?time_range=${timeRange}&limit=${limit}`, {\n headers: {\n authorization: `Bearer ${accessToken}`\n }\n });\n \n return await resp.json();\n}\n\nexport async function getTopArtists(accessToken: string, timeRange: string, limit: number) {\n const resp = await fetch(`https://api.spotify.com/v1/me/top/artists?time_range=${timeRange}&limit=${limit}`, {\n headers: {\n authorization: `Bearer ${accessToken}`\n }\n });\n \n return await resp.json();\n}",[],[148,158],"6759e5be-cc72-11f0-ad23-42dde27851f2","renderer.ts","6759e686-cc72-11f0-ad23-42dde27851f2",21,["D",1764345218072],"import { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Liquid } from 'npm:liquidjs@10.24.0';\n\nexport async function render(template: string, data: object) {\n const engine = new Liquid();\n\n // read all templates\n const fullTpl = await readFile(`/templates/${template}/full.liquid`);\n const hhTpl = await readFile(`/templates/${template}/hh.liquid`);\n const hvTpl = await readFile(`/templates/${template}/hv.liquid`);\n const quadTpl = await readFile(`/templates/${template}/quad.liquid`);\n const sharedTpl = await readFile(`/templates/${template}/shared.liquid`);\n\n // parse all\n const fullParsed = engine.parse(fullTpl);\n const hhParsed = engine.parse(hhTpl);\n const hvParsed = engine.parse(hvTpl);\n const quadParsed = engine.parse(quadTpl);\n const sharedParsed = engine.parse(sharedTpl);\n\n // generate all\n const full = await engine.render(fullParsed, data);\n const hh = await engine.render(hhParsed, data);\n const hv = await engine.render(hvParsed, data);\n const quad = await engine.render(quadParsed, data);\n const shared = await engine.render(sharedParsed, data);\n \n return {\n markup: full,\n markup_half_horizontal: hh,\n markup_half_vertical: hv,\n markup_quadrant: quad,\n shared: shared\n };\n}",[],[148,166],"ea39b3ca-cc99-11f0-b37f-42dde27851f2","lastfmService.ts","d1ea941a-cc99-11f0-956e-42dde27851f2",100,["D",1764362187998],"import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport process from \"node:process\";\nimport { Buffer } from \"node:buffer\";\n\nconst { LASTFM_CLIENT_ID, LASTFM_CLIENT_SECRET } = process.env;\n\nexport async function getRecentTracks(accessToken: string, limit: number) {\n const resp = await fetch(\n `https://api.spotify.com/v1/me/player/recently-played?limit=${limit}`,\n {\n headers: {\n authorization: `Bearer ${accessToken}`,\n },\n },\n );\n\n return await resp.json();\n}\n\nexport async function getTopTracks(\n accessToken: string,\n timeRange: string,\n limit: number,\n) {\n const resp = await fetch(\n `https://api.spotify.com/v1/me/top/tracks?time_range=${timeRange}&limit=${limit}`,\n {\n headers: {\n authorization: `Bearer ${accessToken}`,\n },\n },\n );\n\n return await resp.json();\n}\n\nexport async function getTopArtists(\n accessToken: string,\n timeRange: string,\n limit: number,\n) {\n const resp = await fetch(\n `https://api.spotify.com/v1/me/top/artists?time_range=${timeRange}&limit=${limit}`,\n {\n headers: {\n authorization: `Bearer ${accessToken}`,\n },\n },\n );\n\n return await resp.json();\n}",[],[148,174],"663f8d0a-cc72-11f0-88b9-42dde27851f2","templates","663f8daa-cc72-11f0-88b9-42dde27851f2",["D",1764345216220],[187,188,189,190],[182],{"_42":319,"_13":320,"_45":321,"_47":183,"_49":50,"_51":322,"_53":54,"_55":323,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":324,"_18":325},{"_42":271,"_13":272,"_45":273,"_47":183,"_49":50,"_51":274,"_53":54,"_55":275,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":276,"_18":277},{"_42":232,"_13":233,"_45":234,"_47":183,"_49":50,"_51":235,"_53":54,"_55":236,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":237,"_18":238},{"_42":191,"_13":192,"_45":193,"_47":183,"_49":50,"_51":194,"_53":54,"_55":195,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":196,"_18":197},"66c7c68e-cc72-11f0-9724-42dde27851f2","welcome","66c7c738-cc72-11f0-9724-42dde27851f2",8,["D",1764345217110],[198,199,200,201],[182,192],{"_42":225,"_13":226,"_45":227,"_47":193,"_49":50,"_51":228,"_53":54,"_55":229,"_17":57,"_58":24,"_59":215,"_61":62,"_63":-5,"_144":230,"_18":231},{"_42":218,"_13":219,"_45":220,"_47":193,"_49":50,"_51":221,"_53":54,"_55":222,"_17":57,"_58":24,"_59":215,"_61":62,"_63":-5,"_144":223,"_18":224},{"_42":210,"_13":211,"_45":212,"_47":193,"_49":50,"_51":213,"_53":54,"_55":214,"_17":57,"_58":24,"_59":215,"_61":62,"_63":-5,"_144":216,"_18":217},{"_42":202,"_13":203,"_45":204,"_47":193,"_49":50,"_51":205,"_53":54,"_55":206,"_17":57,"_58":24,"_59":207,"_61":62,"_63":-5,"_144":208,"_18":209},"67aa3b90-cc72-11f0-a741-42dde27851f2","quad.liquid","67aa3c30-cc72-11f0-a741-42dde27851f2",32,["D",1764345218598],"

\n {{ trmnl.user.first_name }}, welcome to the TRMNL Spotify Plugin!\n

This plugin requires you to connect your Spotify account before usage.

Open the plugin page and click on the Configure Spotify button to begin!

\n Spotify\n Welcome!\n

",[],[182,192,203],"67e34f16-cc72-11f0-ade5-42dde27851f2","hv.liquid","67e35038-cc72-11f0-ade5-42dde27851f2",38,["D",1764345218960],"

\n {{ trmnl.user.first_name }}, welcome to the TRMNL Spotify Plugin!\n

This plugin requires you to connect your Spotify account before usage.

Open the plugin page and click on the Configure Spotify button to begin!

\n Spotify\n Welcome!\n

",[],[182,192,211],"67b44c3e-cc72-11f0-8d72-42dde27851f2","hh.liquid","67b44d10-cc72-11f0-8d72-42dde27851f2",33,["D",1764345218659],[],[182,192,219],"67a54e82-cc72-11f0-ad23-42dde27851f2","full.liquid","67a54f18-cc72-11f0-ad23-42dde27851f2",31,["D",1764345218566],[],[182,192,226],"66a51f94-cc72-11f0-82b4-42dde27851f2","top_tracks","66a52084-cc72-11f0-82b4-42dde27851f2",7,["D",1764345216887],[239,240,241,242],[182,233],{"_42":264,"_13":226,"_45":265,"_47":234,"_49":50,"_51":266,"_53":54,"_55":267,"_17":57,"_58":24,"_59":268,"_61":62,"_63":-5,"_144":269,"_18":270},{"_42":257,"_13":219,"_45":258,"_47":234,"_49":50,"_51":259,"_53":54,"_55":260,"_17":57,"_58":24,"_59":261,"_61":62,"_63":-5,"_144":262,"_18":263},{"_42":250,"_13":211,"_45":251,"_47":234,"_49":50,"_51":252,"_53":54,"_55":253,"_17":57,"_58":24,"_59":254,"_61":62,"_63":-5,"_144":255,"_18":256},{"_42":243,"_13":203,"_45":244,"_47":234,"_49":50,"_51":245,"_53":54,"_55":246,"_17":57,"_58":24,"_59":247,"_61":62,"_63":-5,"_144":248,"_18":249},"67913528-cc72-11f0-88b9-42dde27851f2","679135dc-cc72-11f0-88b9-42dde27851f2",28,["D",1764345218433],"{% assign top5 = items | slice: 0, 2 %}\n

\n {% for item in top5 %}\n

\n {{ forloop.index }}\n

\n {% assign cover = item.album.images | last %}\n

\n {{ item.name }}\n {{ item.album.name }}\n

\n {% for artist in item.artists %}\n {{ artist.name }}\n {% endfor %}\n

\n {% endfor %}\n

\n Spotify\n Top Tracks\n

",[],[182,233,203],"679f4d0c-cc72-11f0-9724-42dde27851f2","679f4dfc-cc72-11f0-9724-42dde27851f2",30,["D",1764345218523],"{% assign top5 = items | slice: 0, 5 %}\n

\n {% for item in top5 %}\n

\n {{ forloop.index }}\n

\n {% assign cover = item.album.images | last %}\n

\n {{ item.name }}\n {{ item.album.name }}\n

\n {% for artist in item.artists %}\n {{ artist.name }}\n {% endfor %}\n

\n {% endfor %}\n

\n Spotify\n Top Tracks\n

",[],[182,233,211],"67952be2-cc72-11f0-bc7f-42dde27851f2","67952c78-cc72-11f0-bc7f-42dde27851f2",29,["D",1764345218459],"{% assign top5 = items | slice: 0, 2 %}\n{% assign top10 = items | slice: 2, 2 %}\n

\n {% for item in top5 %}\n

\n {{ forloop.index }}\n

\n {% assign cover = item.album.images | last %}\n

\n {{ item.name }}\n {{ item.album.name }}\n

\n {% for artist in item.artists %}\n {{ artist.name }}\n {% endfor %}\n

\n {% endfor %}\n

\n {% for item in top10 %}\n

\n {{ forloop.index | plus: 2 }}\n

\n {% assign cover = item.album.images | last %}\n

\n {{ item.name }}\n {{ item.album.name }}\n

\n {% for artist in item.artists %}\n {{ artist.name }}\n {% endfor %}\n

\n {% endfor %}\n

\n Spotify\n Top Tracks\n

",[],[182,233,219],"67873eec-cc72-11f0-88b9-42dde27851f2","678740d6-cc72-11f0-88b9-42dde27851f2",27,["D",1764345218368],"{% assign top5 = items | slice: 0, 5 %}\n{% assign top10 = items | slice: 5, 5 %}\n

\n {% for item in top5 %}\n

\n {{ forloop.index }}\n

\n {% assign cover = item.album.images | last %}\n

\n {{ item.name }}\n {{ item.album.name }}\n

\n {% for artist in item.artists %}\n {{ artist.name }}\n {% endfor %}\n

\n {% endfor %}\n

\n {% for item in top10 %}\n

\n {{ forloop.index | plus: 5 }}\n

\n {% assign cover = item.album.images | last %}\n

\n {{ item.name }}\n {{ item.album.name }}\n

\n {% for artist in item.artists %}\n {{ artist.name }}\n {% endfor %}\n

\n {% endfor %}\n

\n Spotify\n Top Tracks\n

",[],[182,233,226],"66ec5aa8-cc72-11f0-88b9-42dde27851f2","top_artists","66ec5b5c-cc72-11f0-88b9-42dde27851f2",9,["D",1764345217352],[278,279,280,281,282],[182,272],{"_42":312,"_13":226,"_45":313,"_47":273,"_49":50,"_51":314,"_53":54,"_55":315,"_17":57,"_58":24,"_59":316,"_61":62,"_63":-5,"_144":317,"_18":318},{"_42":305,"_13":219,"_45":306,"_47":273,"_49":50,"_51":307,"_53":54,"_55":308,"_17":57,"_58":24,"_59":309,"_61":62,"_63":-5,"_144":310,"_18":311},{"_42":298,"_13":211,"_45":299,"_47":273,"_49":50,"_51":300,"_53":54,"_55":301,"_17":57,"_58":24,"_59":302,"_61":62,"_63":-5,"_144":303,"_18":304},{"_42":291,"_13":203,"_45":292,"_47":273,"_49":50,"_51":293,"_53":54,"_55":294,"_17":57,"_58":24,"_59":295,"_61":62,"_63":-5,"_144":296,"_18":297},{"_42":283,"_13":284,"_45":285,"_47":273,"_49":50,"_51":286,"_53":54,"_55":287,"_17":57,"_58":24,"_59":288,"_61":62,"_63":-5,"_144":289,"_18":290},"67d32d5c-cc72-11f0-9cb6-42dde27851f2","shared.liquid","67d32e06-cc72-11f0-9cb6-42dde27851f2",36,["D",1764345218865],"",[],[182,272,284],"67c9f4f8-cc72-11f0-a04a-42dde27851f2","67c9f58e-cc72-11f0-a04a-42dde27851f2",35,["D",1764345218805],"

\n {% assign artists = items | slice: 0, 2 %}\n {% for artist in artists %}\n {% assign cover = artist.images | first %}\n

\n {% endfor %}\n {% for artist in artists %}\n {{ artist.name }}\n {% endfor %}\n

\n Spotify\n Top Artists\n

",[],[182,272,203],"67e96c66-cc72-11f0-9641-42dde27851f2","67e96d2e-cc72-11f0-9641-42dde27851f2",39,["D",1764345219012],"

\n {% assign artists = items | slice: 0, 2 %}\n {% for artist in artists %}\n {% assign cover = artist.images | first %}\n

\n {% endfor %}\n {% for artist in artists %}\n {{ artist.name }}\n {% endfor %}\n {% assign artists = items | slice: 2, 2 %}\n {% for artist in artists %}\n {% assign cover = artist.images | first %}\n

\n {% endfor %}\n {% for artist in artists %}\n {{ artist.name }}\n {% endfor %}\n

\n Spotify\n Top Artists\n

",[],[182,272,211],"67df672a-cc72-11f0-b3eb-42dde27851f2","67df682e-cc72-11f0-b3eb-42dde27851f2",37,["D",1764345218945],"

\n {% assign artists = items | slice: 0, 4 %}\n {% for artist in artists %}\n {% assign cover = artist.images | first %}\n

\n {% endfor %}\n {% for artist in artists %}\n {{ artist.name }}\n {% endfor %}\n

\n Spotify\n Top Artists\n

",[],[182,272,219],"67c5efc0-cc72-11f0-ab59-42dde27851f2","67c5f04c-cc72-11f0-ab59-42dde27851f2",34,["D",1764345218777],"\n

\n {% assign artists = items | slice: 0, 4 %}\n {% for artist in artists %}\n {% assign cover = artist.images | first %}\n

\n {% endfor %}\n {% for artist in artists %}\n {{ artist.name }}\n {% endfor %}\n {% assign artists = items | slice: 4, 4 %}\n {% for artist in artists %}\n {% assign cover = artist.images | first %}\n

\n {% endfor %}\n {% for artist in artists %}\n {{ artist.name }}\n {% endfor %}\n

\n Spotify\n Top Artists\n

",[],[182,272,226],"6684f7e6-cc72-11f0-9724-42dde27851f2","recent_tracks","6684f8cc-cc72-11f0-9724-42dde27851f2",6,["D",1764345216674],[326,327,328,329],[182,320],{"_42":351,"_13":226,"_45":352,"_47":321,"_49":50,"_51":353,"_53":54,"_55":354,"_17":57,"_58":24,"_59":355,"_61":62,"_63":-5,"_144":356,"_18":357},{"_42":344,"_13":219,"_45":345,"_47":321,"_49":50,"_51":346,"_53":54,"_55":347,"_17":57,"_58":24,"_59":348,"_61":62,"_63":-5,"_144":349,"_18":350},{"_42":337,"_13":211,"_45":338,"_47":321,"_49":50,"_51":339,"_53":54,"_55":340,"_17":57,"_58":24,"_59":341,"_61":62,"_63":-5,"_144":342,"_18":343},{"_42":330,"_13":203,"_45":331,"_47":321,"_49":50,"_51":332,"_53":54,"_55":333,"_17":57,"_58":24,"_59":334,"_61":62,"_63":-5,"_144":335,"_18":336},"67737074-cc72-11f0-bee9-42dde27851f2","67737150-cc72-11f0-bee9-42dde27851f2",24,["D",1764345218237],"{% assign top2 = items | slice: 0, 2 %}\n

\n {% for item in top2 %}\n

\n {{ forloop.index }}\n

\n {% assign cover = item.track.album.images | last %}\n

\n {{ item.track.name }}\n {{ item.track.album.name }}\n {%liquid\n # convert UTC date to UTC-3\n assign playedAt = item.played_at | date: \"%s\" | plus: trmnl.user.utc_offset | date: \"%b %e, %H:%M\"\n %}\n {{ playedAt }}\n

\n {% for artist in item.track.artists %}\n {{ artist.name }}\n {% endfor %}\n {%liquid\n # transform duration in milliseconds to mm:ss\n assign duration = item.track.duration_ms | divided_by: 1000.0 | divided_by: 60.0\n assign mins = duration | floor\n assign secs = duration | minus: mins | times: 60 | round: 0\n \n # transform to 2 digits (left pad with 0)\n assign mins = mins | prepend: '00' | slice: -2, 2\n assign secs = secs | prepend: '00' | slice: -2, 2\n %}\n

\n {% endfor %}\n

\n Spotify\n Recent Tracks\n

",[],[182,320,203],"677cb634-cc72-11f0-9641-42dde27851f2","677cb724-cc72-11f0-9641-42dde27851f2",26,["D",1764345218300],"{% assign top5 = items | slice: 0, 5 %}\n

\n {% for item in top5 %}\n

\n {{ forloop.index }}\n

\n {% assign cover = item.track.album.images | last %}\n

\n {% endfor %}\n

\n Spotify\n Recent Tracks\n

",[],[182,320,211],"67793554-cc72-11f0-ad23-42dde27851f2","67793770-cc72-11f0-ad23-42dde27851f2",25,["D",1764345218240],"{% assign top2 = items | slice: 0, 2 %}\n{% assign top4 = items | slice: 2, 2 %}\n

\n {% for item in top2 %}\n

\n {{ forloop.index }}\n

\n {% assign cover = item.track.album.images | last %}\n

\n {% endfor %}\n

\n {% for item in top4 %}\n

\n {{ forloop.index | plus: 2 }}\n

\n {% assign cover = item.track.album.images | last %}\n

\n {% endfor %}\n

\n Spotify\n Recent Tracks\n

",[],[182,320,219],"676b4ade-cc72-11f0-bc7f-42dde27851f2","676b4b92-cc72-11f0-bc7f-42dde27851f2",23,["D",1764345218136],"{% assign top5 = items | slice: 0, 5 %}\n{% assign top10 = items | slice: 5, 5 %}\n

\n {% for item in top5 %}\n

\n {{ forloop.index }}\n

\n {% assign cover = item.track.album.images | last %}\n

\n {{ item.track.name }}\n {{ item.track.album.name }}\n {%liquid\n # convert UTC date to UTC-3\n assign playedAt = item.played_at | date: \"%s\" | minus: 10800 | date: \"%b %e, %H:%M\"\n %}\n {{ playedAt }}\n

\n {% for artist in item.track.artists %}\n {{ artist.name }}\n {% endfor %}\n

\n {% endfor %}\n

\n {% for item in top10 %}\n

\n {{ forloop.index | plus: 5 }}\n

\n {% assign cover = item.track.album.images | last %}\n

\n {% for artist in item.track.artists %}\n {{ artist.name }}\n {% endfor %}\n

\n {% endfor %}\n

\n Spotify\n Recent Tracks\n

",[],[182,320,226],"66615f02-cc72-11f0-9641-42dde27851f2","routes","66616006-cc72-11f0-9641-42dde27851f2",["D",1764345216441],[364,365,366,367,368,369,370],[359],{"_42":419,"_13":420,"_45":421,"_47":360,"_49":50,"_51":422,"_53":54,"_55":423,"_17":70,"_58":71,"_59":424,"_61":62,"_63":-5,"_144":425,"_18":426},{"_42":411,"_13":412,"_45":413,"_47":360,"_49":50,"_51":414,"_53":54,"_55":415,"_17":150,"_58":71,"_59":416,"_61":62,"_63":-5,"_144":417,"_18":418},{"_42":403,"_13":404,"_45":405,"_47":360,"_49":50,"_51":406,"_53":54,"_55":407,"_17":116,"_58":71,"_59":408,"_61":62,"_63":-5,"_144":409,"_18":410},{"_42":395,"_13":396,"_45":397,"_47":360,"_49":50,"_51":398,"_53":54,"_55":399,"_17":57,"_58":71,"_59":400,"_61":62,"_63":-5,"_144":401,"_18":402},{"_42":387,"_13":388,"_45":389,"_47":360,"_49":50,"_51":390,"_53":54,"_55":391,"_17":57,"_58":71,"_59":392,"_61":62,"_63":-5,"_144":393,"_18":394},{"_42":379,"_13":380,"_45":381,"_47":360,"_49":50,"_51":382,"_53":54,"_55":383,"_17":150,"_58":71,"_59":384,"_61":62,"_63":-5,"_144":385,"_18":386},{"_42":371,"_13":372,"_45":373,"_47":360,"_49":50,"_51":374,"_53":54,"_55":375,"_17":70,"_58":71,"_59":376,"_61":62,"_63":-5,"_144":377,"_18":378},"837a4c60-cc87-11f0-b03c-42dde27851f2","uninstall.ts","680b3eae-cc72-11f0-b74c-42dde27851f2",68,["D",1764354284688],"import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { Context } from \"npm:hono@4\";\n\nexport async function uninstall(c: Context) {\n // extract uuid from request\n const data = await c.req.json();\n const uuid = data.user_uuid;\n\n // update database (soft delete)\n const sql =\n \"update lastfm_installations set active = 0, updated_at = CURRENT_TIMESTAMP, uninstalled_at = CURRENT_TIMESTAMP where uuid = :uuid\";\n\n await sqlite.execute({\n sql: sql,\n args: {\n uuid: uuid,\n },\n });\n\n return c.text(\"Uninstalled\");\n}",[],[359,372],"f588bada-cc91-11f0-8208-42dde27851f2","settings.ts","68035e0a-cc72-11f0-b3eb-42dde27851f2",76,["D",1764358771012],"import { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { Context } from \"npm:hono@4\";\nimport process from \"node:process\";\n\nconst LASTFM_CLIENT_ID = process.env.LASTFM_CLIENT_ID;\n\nexport async function settings(c: Context) {\n // extract uuid from request\n const uuid = c.req.query(\"uuid\");\n\n if (uuid === null || uuid === undefined) {\n c.status(400);\n return c.text(\"Missing 'uuid' query parameter\");\n }\n\n // get lastfm connection status, plugin setting id and preferences\n const result = await sqlite.execute({\n sql:\n \"select first_name, lastfm_connected, plugin_setting_id, preferences from lastfm_installations where uuid = :uuid\",\n args: {\n uuid: uuid,\n },\n });\n\n const firstName = result.rows[0][0];\n const lastfmConnected = result.rows[0][1];\n const pluginId = result.rows[0][2];\n const preferences = JSON.parse(result.rows[0][3]);\n\n // prepare index.html file\n let html = await readFile(\"/frontend/settings.html\");\n\n // inject the initial data as a global variable inside a script tag\n const dataScript = ``;\n\n // insert the script right before the closing tag\n html = html.replace(\"\", `${dataScript}`);\n\n return c.html(html);\n}",[],[359,380],"6813e43c-cc72-11f0-b74c-42dde27851f2","preferences.ts","6813e52c-cc72-11f0-b74c-42dde27851f2",45,["D",1764345219280],"import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { Context } from \"npm:hono@4\";\nexport async function savePreferences(c: Context) {\n const body = await c.req.json();\n\n // save to database\n await sqlite.execute({\n sql:\n \"update installations set preferences = :preferences where uuid = :uuid\",\n args: {\n uuid: body.uuid,\n preferences: JSON.stringify(body.prefs),\n },\n });\n\n return c.text(\"ok\");\n}",[],[359,388],"681088d2-cc72-11f0-b656-42dde27851f2","markup.ts","68108986-cc72-11f0-b656-42dde27851f2",44,["D",1764345219236],"import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { Context } from \"npm:hono@4\";\nimport qs from \"npm:qs@6.14.0\";\nimport {\n getRecentTracks,\n getTopArtists,\n getTopTracks,\n refreshToken,\n} from \"../utils/spotifyService.ts\";\nimport { render } from \"../utils/renderer.ts\";\n\nexport async function markup(c: Context) {\n const body = qs.parse(await c.req.text());\n const uuid = body.user_uuid;\n\n // grab installation and tokens from database\n const sql =\n \"SELECT i.spotify_connected, i.preferences, t.access_token, t.refresh_token, t.expires_at FROM installations i, tokens t WHERE i.uuid = :uuid AND t.uuid = :uuid\";\n const result = await sqlite.execute({\n sql: sql,\n args: {\n uuid: uuid as string,\n },\n });\n\n // if spotify is not yet connected, render welcome instructions\n if (result.rows.length === 0 || result.rows[0][0] === 0) {\n const rendered = await render(\"welcome\", { trmnl: body.trmnl });\n return c.json(rendered);\n }\n\n // check if spotify token is still valid\n const expiresAt = result.rows[0][4];\n const now = Math.floor(Date.now() / 1000);\n\n let accessToken = result.rows[0][2];\n if (now > expiresAt) {\n accessToken = await refreshToken(result.rows[0][0], result.rows[0][3]);\n }\n\n // get user preferences\n const prefs = JSON.parse(result.rows[0][1]);\n\n let rendered;\n switch (prefs.displayType) {\n case \"top_artists\": {\n const artists = await getTopArtists(accessToken, prefs.timeRange, 10);\n rendered = await render(\"top_artists\", { ...artists, trmnl: body.trmnl });\n break;\n }\n case \"top_tracks\": {\n const tracks = await getTopTracks(accessToken, prefs.timeRange, 10);\n rendered = await render(\"top_tracks\", { ...tracks, trmnl: body.trmnl });\n break;\n }\n default: {\n const tracks = await getRecentTracks(accessToken, 10);\n rendered = await render(\"recent_tracks\", {\n ...tracks,\n trmnl: body.trmnl,\n });\n }\n }\n\n return c.json(rendered);\n}",[],[359,396],"b6e55e34-cc99-11f0-b1aa-42dde27851f2","lastfmCallback.ts","67f08550-cc72-11f0-980e-42dde27851f2",97,["D",1764362101889],"import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { Context } from \"npm:hono@4\";\nimport process from \"node:process\";\nimport * as crypto from \"node:crypto\";\n\nconst LASTFM_CLIENT_ID = process.env.LASTFM_CLIENT_ID;\nconst LASTFM_CLIENT_SECRET = process.env.LASTFM_CLIENT_SECRET;\n\nexport async function lastfmCallback(c: Context) {\n // get token and state from request\n const token = c.req.query(\"token\");\n const state = c.req.query(\"state\");\n\n const params =\n `api_key${LASTFM_CLIENT_ID}methodauth.getSessiontoken${token}${LASTFM_CLIENT_SECRET}`;\n const signature = crypto.createHash(\"md5\").update(params).digest(\"hex\");\n\n // prepare query params\n const body = new URLSearchParams();\n body.append(\"method\", \"auth.getSession\");\n body.append(\"api_key\", LASTFM_CLIENT_ID);\n body.append(\"token\", token);\n body.append(\"format\", \"json\");\n body.append(\"api_sig\", signature);\n\n // request session\n const response = await fetch(\n `https://ws.audioscrobbler.com/2.0?${body.toString()}`,\n );\n const data = await response.json();\n console.log(data);\n\n // update installation to set lastfm as active and session key\n await sqlite.execute({\n sql:\n \"update lastfm_installations set lastfm_connected = 1, lastfm_session = :lastfm_session where uuid = :uuid\",\n args: {\n lastfm_session: data.session.key,\n uuid: state,\n },\n });\n\n // redirect back to settings page\n return c.redirect(`/trmnl/settings?uuid=${state}`);\n}",[],[359,404],"72aa4098-cc91-11f0-ba22-42dde27851f2","install.ts","67f4ae50-cc72-11f0-b74c-42dde27851f2",75,["D",1764358551450],"import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { Context } from \"npm:hono@4\";\nimport process from \"node:process\";\n\nexport async function install(c: Context) {\n // read env vars\n const TRMNL_CLIENT_ID = process.env.TRMNL_CLIENT_ID;\n const TRMNL_CLIENT_SECRET = process.env.TRMNL_CLIENT_SECRET;\n\n // read query params\n const code = c.req.query(\"code\");\n const callbackUrl = c.req.query(\"installation_callback_url\");\n\n // prepare TRMNL payload\n const payload = {\n code: code,\n client_id: TRMNL_CLIENT_ID,\n client_secret: TRMNL_CLIENT_SECRET,\n grant_type: \"authorization_code\",\n };\n\n // get access token from TRMNL\n const resp = await fetch(\"https://usetrmnl.com/oauth/token\", {\n method: \"post\",\n headers: {\n \"content-type\": \"application/json\",\n },\n body: JSON.stringify(payload),\n });\n\n if (!resp.ok) {\n const data = await resp.text();\n console.error(`Error ${resp.status}: ${data}`);\n c.status(500);\n return c.text(\"Error trying to get access token from TRMNL!\");\n }\n\n // success redirect back to TRMNL's callback url\n return c.redirect(callbackUrl);\n}\n\nexport async function postInstall(c: Context) {\n const authHeader = c.req.header(\"Authorization\");\n const accessToken = authHeader.split(\" \")[1];\n\n const body = await c.req.json();\n const user = body.user;\n\n // insert installation\n const sql =\n \"insert into lastfm_installations(uuid, active, lastfm_connected, name, first_name, last_name, email, locale, time_zone_iana, plugin_setting_id, trmnl_access_token, preferences) values (:uuid, :active, :lastfm_connected, :name, :first_name, :last_name, :email, :locale, :time_zone_iana, :plugin_setting_id, :trmnl_access_token, :preferences)\";\n\n // insert installation\n await sqlite.execute({\n sql: sql,\n args: {\n uuid: user.uuid,\n active: 1,\n lastfm_connected: 0,\n name: user.name,\n first_name: user.first_name,\n last_name: user.last_name,\n email: user.email,\n locale: user.locale,\n time_zone_iana: user.time_zone_iana,\n plugin_setting_id: user.plugin_setting_id,\n trmnl_access_token: accessToken,\n preferences: JSON.stringify({\n displayType: \"recent_tracks\",\n timeRange: \"short_term\",\n }),\n },\n });\n\n return c.text(\"OK\");\n}",[],[359,412],"70ffdfae-cc92-11f0-a97a-42dde27851f2","index.ts","681b2aa8-cc72-11f0-828d-42dde27851f2",84,["D",1764358978150],"export * from \"./install.ts\";\nexport * from \"./markup.ts\";\nexport * from \"./uninstall.ts\";\nexport * from \"./settings.ts\";\nexport * from \"./lastfmCallback.ts\";\nexport * from \"./preferences.ts\";",[],[359,420],["D",1764345215398],[430,431,432,433,434,435,436,437,438],[19],{"_42":119,"_13":120,"_45":121,"_47":48,"_49":50,"_51":122,"_53":54,"_55":463,"_17":124,"_58":71,"_59":125,"_61":62,"_63":-5,"_144":464,"_18":465},{"_42":111,"_13":112,"_45":113,"_47":48,"_49":50,"_51":114,"_53":54,"_55":460,"_17":116,"_58":71,"_59":117,"_61":62,"_63":-5,"_144":461,"_18":462},{"_42":104,"_13":105,"_45":106,"_47":48,"_49":50,"_51":107,"_53":54,"_55":457,"_17":57,"_58":71,"_59":109,"_61":62,"_63":-5,"_144":458,"_18":459},{"_42":97,"_13":98,"_45":99,"_47":48,"_49":50,"_51":100,"_53":54,"_55":454,"_17":57,"_58":24,"_59":102,"_61":62,"_63":-5,"_144":455,"_18":456},{"_42":89,"_13":90,"_45":91,"_47":48,"_49":50,"_51":92,"_53":54,"_55":451,"_17":94,"_58":24,"_59":95,"_61":62,"_63":-5,"_144":452,"_18":453},{"_42":81,"_13":82,"_45":83,"_47":48,"_49":50,"_51":84,"_53":54,"_55":448,"_17":86,"_58":24,"_59":87,"_61":62,"_63":-5,"_144":449,"_18":450},{"_42":74,"_13":75,"_45":76,"_47":48,"_49":50,"_51":77,"_53":54,"_55":445,"_17":70,"_58":24,"_59":79,"_61":62,"_63":-5,"_144":446,"_18":447},{"_42":65,"_13":66,"_45":67,"_47":48,"_49":50,"_51":68,"_53":54,"_55":442,"_17":70,"_58":71,"_59":72,"_61":62,"_63":-5,"_144":443,"_18":444},{"_42":43,"_13":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":439,"_17":57,"_58":24,"_59":60,"_61":62,"_63":-5,"_144":440,"_18":441},["D",1764345217591],[],[19,44],["D",1764354490970],[],[19,66],["D",1764353404536],[],[19,75],["D",1764352347812],[],[19,82],["D",1764361600591],[],[19,90],["D",1764345217849],[],[19,98],["D",1764345218002],[],[19,105],["D",1764359245627],[],[19,112],["D",1764358848227],[],[19,120],"661dc792-cc72-11f0-82b4-42dde27851f2","docs","661dc846-cc72-11f0-82b4-42dde27851f2",["D",1764345215999],[472],[467],{"_42":473,"_13":474,"_45":475,"_47":468,"_49":50,"_51":476,"_53":54,"_55":477,"_17":70,"_58":24,"_59":478,"_61":62,"_63":-5,"_144":479,"_18":480},"c427a588-cc72-11f0-96e3-42dde27851f2","dbqueries.md","6763721e-cc72-11f0-980e-42dde27851f2",48,["D",1764345373768],"# Database Queries\n\n## Create Installations Database\n\n```js\napp.get(\"/db/create\", async (c) => {\n await sqlite.execute(`create table if not exists lastfm_installations (\n uuid varchar(255) PRIMARY KEY not null,\n active boolean not null default 0,\n lastfm_connected boolean not null default 0,\n name varchar(255) null,\n first_name varchar(255) null,\n last_name varchar(255) null,\n email varchar(255) null,\n locale varchar(255) null,\n time_zone_iana varchar(255) null,\n plugin_setting_id INTEGER null,\n trmnl_access_token varchar(255) null,\n lastfm_session varchar(255) null,\n preferences text not null,\n uninstalled_at datetime null,\n created_at datetime not null default CURRENT_TIMESTAMP,\n updated_at datetime not null default CURRENT_TIMESTAMP\n)`);\n\n return c.text(\"ok\");\n});\n```",[],[467,474],"650a3f5c-cc72-11f0-88b9-42dde27851f2",["D",1764345214194],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Spotify public plugin for TRMNL","imageUrl","userId","587eaa49-1886-4260-b009-c97384ae146a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","9a93cd7d-2807-45bb-9668-71a9c9d52476","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_535":531},"org",{"_11":12,"_528":529,"_530":531,"_491":492,"_532":533,"_534":62},"branch",{"_17":176,"_13":16,"_42":50,"_520":481,"_521":-5,"_522":-5,"_523":-5,"_524":-5,"_525":-5,"_526":14,"_527":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Daniel Sitnik","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJwelNteERmakxrMG5QTzF4S001cVdrYWhCUSJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_42":481,"_13":14,"_55":725,"_483":-5,"_484":62,"_485":486,"_487":486,"_488":489,"_490":-5,"_491":492,"_493":139,"_494":54,"_495":54,"_496":-5,"_497":57,"_498":499,"_500":-5,"_501":-5,"_502":-5,"_503":-5,"_504":505,"_506":505,"_507":508,"_509":508,"_510":508,"_511":505,"_512":505,"_513":726,"_515":727,"_517":728,"_519":62},[584,586,596,604,626,630],"files",[584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630],"counts",{"_575":57,"_576":70,"_577":57,"_32":578,"_579":580},[557,558,559,560,561,562,563,564,565],{"_42":127,"_49":50,"_45":48,"_13":19,"_59":-5,"_58":129,"_17":57,"_47":-5,"_55":555,"_51":70,"_63":-5,"_18":556},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1764345215398],[19],{"_42":119,"_13":120,"_45":121,"_47":48,"_49":50,"_51":122,"_53":54,"_55":123,"_17":124,"_58":71,"_59":125,"_61":62,"_63":-5,"_18":574},{"_42":111,"_13":112,"_45":113,"_47":48,"_49":50,"_51":114,"_53":54,"_55":115,"_17":116,"_58":71,"_59":117,"_61":62,"_63":-5,"_18":573},{"_42":104,"_13":105,"_45":106,"_47":48,"_49":50,"_51":107,"_53":54,"_55":108,"_17":57,"_58":71,"_59":109,"_61":62,"_63":-5,"_18":572},{"_42":97,"_13":98,"_45":99,"_47":48,"_49":50,"_51":100,"_53":54,"_55":101,"_17":57,"_58":24,"_59":102,"_61":62,"_63":-5,"_18":571},{"_42":89,"_13":90,"_45":91,"_47":48,"_49":50,"_51":92,"_53":54,"_55":93,"_17":94,"_58":24,"_59":95,"_61":62,"_63":-5,"_18":570},{"_42":81,"_13":82,"_45":83,"_47":48,"_49":50,"_51":84,"_53":54,"_55":85,"_17":86,"_58":24,"_59":87,"_61":62,"_63":-5,"_18":569},{"_42":74,"_13":75,"_45":76,"_47":48,"_49":50,"_51":77,"_53":54,"_55":78,"_17":70,"_58":24,"_59":79,"_61":62,"_63":-5,"_18":568},{"_42":65,"_13":66,"_45":67,"_47":48,"_49":50,"_51":68,"_53":54,"_55":69,"_17":70,"_58":71,"_59":72,"_61":62,"_63":-5,"_18":567},{"_42":43,"_13":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_17":57,"_58":24,"_59":60,"_61":62,"_63":-5,"_18":566},[19,44],[19,66],[19,75],[19,82],[19,90],[19,98],[19,105],[19,112],[19,120],"pulls","branches","forks",{"_581":86,"_583":57},"connections",{"_581":57,"_582":57},"count","unfilledCount","emptyCount",{"_42":466,"_13":467,"_45":468,"_47":-5,"_49":50,"_51":124,"_53":54,"_55":469,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":723,"_18":724},{"_42":473,"_13":474,"_45":475,"_47":468,"_49":50,"_51":476,"_53":54,"_55":477,"_17":70,"_58":24,"_59":478,"_61":62,"_63":-5,"_144":721,"_18":722},{"_42":127,"_13":19,"_45":48,"_47":-5,"_49":50,"_51":70,"_53":54,"_55":427,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":719,"_18":720},{"_42":119,"_13":120,"_45":121,"_47":48,"_49":50,"_51":122,"_53":54,"_55":463,"_17":124,"_58":71,"_59":125,"_61":62,"_63":-5,"_144":717,"_18":718},{"_42":111,"_13":112,"_45":113,"_47":48,"_49":50,"_51":114,"_53":54,"_55":460,"_17":116,"_58":71,"_59":117,"_61":62,"_63":-5,"_144":715,"_18":716},{"_42":104,"_13":105,"_45":106,"_47":48,"_49":50,"_51":107,"_53":54,"_55":457,"_17":57,"_58":71,"_59":109,"_61":62,"_63":-5,"_144":713,"_18":714},{"_42":97,"_13":98,"_45":99,"_47":48,"_49":50,"_51":100,"_53":54,"_55":454,"_17":57,"_58":24,"_59":102,"_61":62,"_63":-5,"_144":711,"_18":712},{"_42":89,"_13":90,"_45":91,"_47":48,"_49":50,"_51":92,"_53":54,"_55":451,"_17":94,"_58":24,"_59":95,"_61":62,"_63":-5,"_144":709,"_18":710},{"_42":81,"_13":82,"_45":83,"_47":48,"_49":50,"_51":84,"_53":54,"_55":448,"_17":86,"_58":24,"_59":87,"_61":62,"_63":-5,"_144":707,"_18":708},{"_42":74,"_13":75,"_45":76,"_47":48,"_49":50,"_51":77,"_53":54,"_55":445,"_17":70,"_58":24,"_59":79,"_61":62,"_63":-5,"_144":705,"_18":706},{"_42":65,"_13":66,"_45":67,"_47":48,"_49":50,"_51":68,"_53":54,"_55":442,"_17":70,"_58":71,"_59":72,"_61":62,"_63":-5,"_144":703,"_18":704},{"_42":43,"_13":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":439,"_17":57,"_58":24,"_59":60,"_61":62,"_63":-5,"_144":701,"_18":702},{"_42":358,"_13":359,"_45":360,"_47":-5,"_49":50,"_51":94,"_53":54,"_55":361,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":699,"_18":700},{"_42":419,"_13":420,"_45":421,"_47":360,"_49":50,"_51":422,"_53":54,"_55":423,"_17":70,"_58":71,"_59":424,"_61":62,"_63":-5,"_144":697,"_18":698},{"_42":411,"_13":412,"_45":413,"_47":360,"_49":50,"_51":414,"_53":54,"_55":415,"_17":150,"_58":71,"_59":416,"_61":62,"_63":-5,"_144":695,"_18":696},{"_42":403,"_13":404,"_45":405,"_47":360,"_49":50,"_51":406,"_53":54,"_55":407,"_17":116,"_58":71,"_59":408,"_61":62,"_63":-5,"_144":693,"_18":694},{"_42":395,"_13":396,"_45":397,"_47":360,"_49":50,"_51":398,"_53":54,"_55":399,"_17":57,"_58":71,"_59":400,"_61":62,"_63":-5,"_144":691,"_18":692},{"_42":387,"_13":388,"_45":389,"_47":360,"_49":50,"_51":390,"_53":54,"_55":391,"_17":57,"_58":71,"_59":392,"_61":62,"_63":-5,"_144":689,"_18":690},{"_42":379,"_13":380,"_45":381,"_47":360,"_49":50,"_51":382,"_53":54,"_55":383,"_17":150,"_58":71,"_59":384,"_61":62,"_63":-5,"_144":687,"_18":688},{"_42":371,"_13":372,"_45":373,"_47":360,"_49":50,"_51":374,"_53":54,"_55":375,"_17":70,"_58":71,"_59":376,"_61":62,"_63":-5,"_144":685,"_18":686},{"_42":181,"_13":182,"_45":183,"_47":-5,"_49":50,"_51":86,"_53":54,"_55":184,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":683,"_18":684},{"_42":319,"_13":320,"_45":321,"_47":183,"_49":50,"_51":322,"_53":54,"_55":323,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":681,"_18":682},{"_42":351,"_13":226,"_45":352,"_47":321,"_49":50,"_51":353,"_53":54,"_55":354,"_17":57,"_58":24,"_59":355,"_61":62,"_63":-5,"_144":679,"_18":680},{"_42":344,"_13":219,"_45":345,"_47":321,"_49":50,"_51":346,"_53":54,"_55":347,"_17":57,"_58":24,"_59":348,"_61":62,"_63":-5,"_144":677,"_18":678},{"_42":337,"_13":211,"_45":338,"_47":321,"_49":50,"_51":339,"_53":54,"_55":340,"_17":57,"_58":24,"_59":341,"_61":62,"_63":-5,"_144":675,"_18":676},{"_42":330,"_13":203,"_45":331,"_47":321,"_49":50,"_51":332,"_53":54,"_55":333,"_17":57,"_58":24,"_59":334,"_61":62,"_63":-5,"_144":673,"_18":674},{"_42":271,"_13":272,"_45":273,"_47":183,"_49":50,"_51":274,"_53":54,"_55":275,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":671,"_18":672},{"_42":312,"_13":226,"_45":313,"_47":273,"_49":50,"_51":314,"_53":54,"_55":315,"_17":57,"_58":24,"_59":316,"_61":62,"_63":-5,"_144":669,"_18":670},{"_42":305,"_13":219,"_45":306,"_47":273,"_49":50,"_51":307,"_53":54,"_55":308,"_17":57,"_58":24,"_59":309,"_61":62,"_63":-5,"_144":667,"_18":668},{"_42":298,"_13":211,"_45":299,"_47":273,"_49":50,"_51":300,"_53":54,"_55":301,"_17":57,"_58":24,"_59":302,"_61":62,"_63":-5,"_144":665,"_18":666},{"_42":291,"_13":203,"_45":292,"_47":273,"_49":50,"_51":293,"_53":54,"_55":294,"_17":57,"_58":24,"_59":295,"_61":62,"_63":-5,"_144":663,"_18":664},{"_42":283,"_13":284,"_45":285,"_47":273,"_49":50,"_51":286,"_53":54,"_55":287,"_17":57,"_58":24,"_59":288,"_61":62,"_63":-5,"_144":661,"_18":662},{"_42":232,"_13":233,"_45":234,"_47":183,"_49":50,"_51":235,"_53":54,"_55":236,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":659,"_18":660},{"_42":264,"_13":226,"_45":265,"_47":234,"_49":50,"_51":266,"_53":54,"_55":267,"_17":57,"_58":24,"_59":268,"_61":62,"_63":-5,"_144":657,"_18":658},{"_42":257,"_13":219,"_45":258,"_47":234,"_49":50,"_51":259,"_53":54,"_55":260,"_17":57,"_58":24,"_59":261,"_61":62,"_63":-5,"_144":655,"_18":656},{"_42":250,"_13":211,"_45":251,"_47":234,"_49":50,"_51":252,"_53":54,"_55":253,"_17":57,"_58":24,"_59":254,"_61":62,"_63":-5,"_144":653,"_18":654},{"_42":243,"_13":203,"_45":244,"_47":234,"_49":50,"_51":245,"_53":54,"_55":246,"_17":57,"_58":24,"_59":247,"_61":62,"_63":-5,"_144":651,"_18":652},{"_42":191,"_13":192,"_45":193,"_47":183,"_49":50,"_51":194,"_53":54,"_55":195,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":649,"_18":650},{"_42":225,"_13":226,"_45":227,"_47":193,"_49":50,"_51":228,"_53":54,"_55":229,"_17":57,"_58":24,"_59":215,"_61":62,"_63":-5,"_144":647,"_18":648},{"_42":218,"_13":219,"_45":220,"_47":193,"_49":50,"_51":221,"_53":54,"_55":222,"_17":57,"_58":24,"_59":215,"_61":62,"_63":-5,"_144":645,"_18":646},{"_42":210,"_13":211,"_45":212,"_47":193,"_49":50,"_51":213,"_53":54,"_55":214,"_17":57,"_58":24,"_59":215,"_61":62,"_63":-5,"_144":643,"_18":644},{"_42":202,"_13":203,"_45":204,"_47":193,"_49":50,"_51":205,"_53":54,"_55":206,"_17":57,"_58":24,"_59":207,"_61":62,"_63":-5,"_144":641,"_18":642},{"_42":147,"_13":148,"_45":149,"_47":-5,"_49":50,"_51":150,"_53":54,"_55":151,"_17":57,"_58":129,"_59":-5,"_61":62,"_63":-5,"_144":639,"_18":640},{"_42":173,"_13":174,"_45":175,"_47":149,"_49":50,"_51":176,"_53":54,"_55":177,"_17":150,"_58":71,"_59":178,"_61":62,"_63":-5,"_144":637,"_18":638},{"_42":165,"_13":166,"_45":167,"_47":149,"_49":50,"_51":168,"_53":54,"_55":169,"_17":57,"_58":71,"_59":170,"_61":62,"_63":-5,"_144":635,"_18":636},{"_42":157,"_13":158,"_45":159,"_47":149,"_49":50,"_51":160,"_53":54,"_55":161,"_17":57,"_58":71,"_59":162,"_61":62,"_63":-5,"_144":633,"_18":634},{"_42":137,"_13":138,"_45":139,"_47":-5,"_49":50,"_51":140,"_53":54,"_55":141,"_17":86,"_58":142,"_59":143,"_61":62,"_63":14,"_144":631,"_18":632},[],[138],[],[148,158],[],[148,166],[],[148,174],[627,628,629],[148],[],[182,192,203],[],[182,192,211],[],[182,192,219],[],[182,192,226],[622,623,624,625],[182,192],[],[182,233,203],[],[182,233,211],[],[182,233,219],[],[182,233,226],[617,618,619,620],[182,233],[],[182,272,284],[],[182,272,203],[],[182,272,211],[],[182,272,219],[],[182,272,226],[611,612,613,614,615],[182,272],[],[182,320,203],[],[182,320,211],[],[182,320,219],[],[182,320,226],[606,607,608,609],[182,320],[605,610,616,621],[182],[],[359,372],[],[359,380],[],[359,388],[],[359,396],[],[359,404],[],[359,412],[],[359,420],[597,598,599,600,601,602,603],[359],[],[19,44],[],[19,66],[],[19,75],[],[19,82],[],[19,90],[],[19,98],[],[19,105],[],[19,112],[],[19,120],[587,588,589,590,591,592,593,594,595],[19],[],[467,474],[585],[467],["D",1764345214194],{"_11":12,"_535":531},{"_11":12,"_528":529,"_530":531,"_491":492,"_532":533,"_534":62},{"_17":176,"_13":16,"_42":50,"_520":481,"_521":-5,"_522":-5,"_523":-5,"_524":-5,"_525":-5,"_526":14,"_527":12},"ctx",{"_513":-5,"_552":762,"_763":764,"_765":766,"_767":62,"_768":62,"_769":62,"_770":54,"_771":-5,"_772":-7,"_773":-7,"_774":57,"_775":62,"_776":62,"_777":-5,"_778":62,"_779":62,"_780":62,"_781":-5},"ENV",{"_733":734,"_735":736,"_737":16,"_738":739,"_740":741,"_742":743,"_744":745,"_746":747,"_748":749,"_750":751,"_752":753,"_754":755,"_756":757,"_758":759,"_760":761},"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"]