TRMNL Last.fm

\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

",[],[165,175,186],"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

",[],[165,175,194],"67b44c3e-cc72-11f0-8d72-42dde27851f2","hh.liquid","67b44d10-cc72-11f0-8d72-42dde27851f2",33,["D",1764345218659],[],[165,175,202],"67a54e82-cc72-11f0-ad23-42dde27851f2","full.liquid","67a54f18-cc72-11f0-ad23-42dde27851f2",31,["D",1764345218566],[],[165,175,209],"66a51f94-cc72-11f0-82b4-42dde27851f2","top_tracks","66a52084-cc72-11f0-82b4-42dde27851f2",7,["D",1764345216887],[222,223,224,225],[165,216],{"_40":247,"_13":209,"_43":248,"_45":217,"_47":48,"_49":249,"_51":52,"_53":250,"_17":77,"_56":24,"_58":251,"_60":61,"_62":-5,"_128":252,"_18":253},{"_40":240,"_13":202,"_43":241,"_45":217,"_47":48,"_49":242,"_51":52,"_53":243,"_17":77,"_56":24,"_58":244,"_60":61,"_62":-5,"_128":245,"_18":246},{"_40":233,"_13":194,"_43":234,"_45":217,"_47":48,"_49":235,"_51":52,"_53":236,"_17":77,"_56":24,"_58":237,"_60":61,"_62":-5,"_128":238,"_18":239},{"_40":226,"_13":186,"_43":227,"_45":217,"_47":48,"_49":228,"_51":52,"_53":229,"_17":77,"_56":24,"_58":230,"_60":61,"_62":-5,"_128":231,"_18":232},"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

",[],[165,216,186],"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

",[],[165,216,194],"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

",[],[165,216,202],"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

",[],[165,216,209],"66ec5aa8-cc72-11f0-88b9-42dde27851f2","top_artists","66ec5b5c-cc72-11f0-88b9-42dde27851f2",9,["D",1764345217352],[261,262,263,264,265],[165,255],{"_40":295,"_13":209,"_43":296,"_45":256,"_47":48,"_49":297,"_51":52,"_53":298,"_17":77,"_56":24,"_58":299,"_60":61,"_62":-5,"_128":300,"_18":301},{"_40":288,"_13":202,"_43":289,"_45":256,"_47":48,"_49":290,"_51":52,"_53":291,"_17":77,"_56":24,"_58":292,"_60":61,"_62":-5,"_128":293,"_18":294},{"_40":281,"_13":194,"_43":282,"_45":256,"_47":48,"_49":283,"_51":52,"_53":284,"_17":77,"_56":24,"_58":285,"_60":61,"_62":-5,"_128":286,"_18":287},{"_40":274,"_13":186,"_43":275,"_45":256,"_47":48,"_49":276,"_51":52,"_53":277,"_17":77,"_56":24,"_58":278,"_60":61,"_62":-5,"_128":279,"_18":280},{"_40":266,"_13":267,"_43":268,"_45":256,"_47":48,"_49":269,"_51":52,"_53":270,"_17":77,"_56":24,"_58":271,"_60":61,"_62":-5,"_128":272,"_18":273},"67d32d5c-cc72-11f0-9cb6-42dde27851f2","shared.liquid","67d32e06-cc72-11f0-9cb6-42dde27851f2",36,["D",1764345218865],"",[],[165,255,267],"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

",[],[165,255,186],"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

",[],[165,255,194],"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

",[],[165,255,202],"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

",[],[165,255,209],"6684f7e6-cc72-11f0-9724-42dde27851f2","recent_tracks","6684f8cc-cc72-11f0-9724-42dde27851f2",6,["D",1764345216674],[309,310,311,312],[165,303],{"_40":334,"_13":209,"_43":335,"_45":304,"_47":48,"_49":336,"_51":52,"_53":337,"_17":77,"_56":24,"_58":338,"_60":61,"_62":-5,"_128":339,"_18":340},{"_40":327,"_13":202,"_43":328,"_45":304,"_47":48,"_49":329,"_51":52,"_53":330,"_17":77,"_56":24,"_58":331,"_60":61,"_62":-5,"_128":332,"_18":333},{"_40":320,"_13":194,"_43":321,"_45":304,"_47":48,"_49":322,"_51":52,"_53":323,"_17":77,"_56":24,"_58":324,"_60":61,"_62":-5,"_128":325,"_18":326},{"_40":313,"_13":186,"_43":314,"_45":304,"_47":48,"_49":315,"_51":52,"_53":316,"_17":77,"_56":24,"_58":317,"_60":61,"_62":-5,"_128":318,"_18":319},"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

",[],[165,303,186],"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

",[],[165,303,194],"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

",[],[165,303,202],"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

",[],[165,303,209],["D",1764345216441],[344,345,346,347,348,349,350],[19],{"_40":102,"_13":103,"_43":104,"_45":46,"_47":48,"_49":105,"_51":52,"_53":369,"_17":55,"_56":57,"_58":107,"_60":61,"_62":-5,"_128":370,"_18":371},{"_40":95,"_13":96,"_43":97,"_45":46,"_47":48,"_49":98,"_51":52,"_53":366,"_17":69,"_56":57,"_58":100,"_60":61,"_62":-5,"_128":367,"_18":368},{"_40":87,"_13":88,"_43":89,"_45":46,"_47":48,"_49":90,"_51":52,"_53":363,"_17":92,"_56":57,"_58":93,"_60":61,"_62":-5,"_128":364,"_18":365},{"_40":80,"_13":81,"_43":82,"_45":46,"_47":48,"_49":83,"_51":52,"_53":360,"_17":77,"_56":57,"_58":85,"_60":61,"_62":-5,"_128":361,"_18":362},{"_40":72,"_13":73,"_43":74,"_45":46,"_47":48,"_49":75,"_51":52,"_53":357,"_17":77,"_56":57,"_58":78,"_60":61,"_62":-5,"_128":358,"_18":359},{"_40":64,"_13":65,"_43":66,"_45":46,"_47":48,"_49":67,"_51":52,"_53":354,"_17":69,"_56":57,"_58":70,"_60":61,"_62":-5,"_128":355,"_18":356},{"_40":41,"_13":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":351,"_17":55,"_56":57,"_58":59,"_60":61,"_62":-5,"_128":352,"_18":353},["D",1764354284688],[],[19,42],["D",1764358771012],[],[19,65],["D",1764345219280],[],[19,73],["D",1764345219236],[],[19,81],["D",1764362101889],[],[19,88],["D",1764358551450],[],[19,96],["D",1764358978150],[],[19,103],"65c54c98-cc72-11f0-88b9-42dde27851f2","frontend","65c54d60-cc72-11f0-88b9-42dde27851f2",["D",1764345215398],[378,379,380,381,382,383,384,385,386],[373],{"_40":451,"_13":452,"_43":453,"_45":374,"_47":48,"_49":454,"_51":52,"_53":455,"_17":456,"_56":57,"_58":457,"_60":61,"_62":-5,"_128":458,"_18":459},{"_40":443,"_13":444,"_43":445,"_45":374,"_47":48,"_49":446,"_51":52,"_53":447,"_17":92,"_56":57,"_58":448,"_60":61,"_62":-5,"_128":449,"_18":450},{"_40":435,"_13":436,"_43":437,"_45":374,"_47":48,"_49":438,"_51":52,"_53":439,"_17":77,"_56":57,"_58":440,"_60":61,"_62":-5,"_128":441,"_18":442},{"_40":427,"_13":428,"_43":429,"_45":374,"_47":48,"_49":430,"_51":52,"_53":431,"_17":77,"_56":24,"_58":432,"_60":61,"_62":-5,"_128":433,"_18":434},{"_40":419,"_13":420,"_43":421,"_45":374,"_47":48,"_49":422,"_51":52,"_53":423,"_17":110,"_56":24,"_58":424,"_60":61,"_62":-5,"_128":425,"_18":426},{"_40":411,"_13":412,"_43":413,"_45":374,"_47":48,"_49":414,"_51":52,"_53":415,"_17":125,"_56":24,"_58":416,"_60":61,"_62":-5,"_128":417,"_18":418},{"_40":403,"_13":404,"_43":405,"_45":374,"_47":48,"_49":406,"_51":52,"_53":407,"_17":55,"_56":24,"_58":408,"_60":61,"_62":-5,"_128":409,"_18":410},{"_40":395,"_13":396,"_43":397,"_45":374,"_47":48,"_49":398,"_51":52,"_53":399,"_17":55,"_56":57,"_58":400,"_60":61,"_62":-5,"_128":401,"_18":402},{"_40":387,"_13":388,"_43":389,"_45":374,"_47":48,"_49":390,"_51":52,"_53":391,"_17":77,"_56":24,"_58":392,"_60":61,"_62":-5,"_128":393,"_18":394},"671c3034-cc72-11f0-88b9-42dde27851f2","trmnl-logo.svg","671c3138-cc72-11f0-88b9-42dde27851f2",13,["D",1764345217591],"\n \n \n \n \n \n \n \n",[],[373,388],"fe6e8ae4-cc87-11f0-8994-42dde27851f2","settings.tsx","673dc640-cc72-11f0-bc7f-42dde27851f2",70,["D",1764354490970],"/** @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();",[],[373,396],"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",[],[373,404],"01027f9a-cc83-11f0-891d-42dde27851f2","lastfm-logo.svg","ddc5a034-cc82-11f0-a6b5-42dde27851f2",54,["D",1764352347812],"",[],[373,412],"8c1892b2-cc98-11f0-9649-42dde27851f2","index.html","67144950-cc72-11f0-82b4-42dde27851f2",94,["D",1764361600591],"\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",[],[373,420],"6737e676-cc72-11f0-ad23-42dde27851f2","favicon.svg","6737e856-cc72-11f0-ad23-42dde27851f2",16,["D",1764345217849],"",[],[373,428],"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}",[],[373,436],"106d8208-cc93-11f0-8cad-42dde27851f2","ConnectLastfm.tsx","6741b462-cc72-11f0-ad23-42dde27851f2",87,["D",1764359245627],"/** @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}",[],[373,444],"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}",[],[373,452],"661dc792-cc72-11f0-82b4-42dde27851f2","docs","661dc846-cc72-11f0-82b4-42dde27851f2",["D",1764345215999],[466],[461],{"_40":467,"_13":468,"_43":469,"_45":462,"_47":48,"_49":470,"_51":52,"_53":471,"_17":55,"_56":24,"_58":472,"_60":61,"_62":-5,"_128":473,"_18":474},"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```",[],[461,468],"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,"_529":525},"org",{"_11":12,"_522":523,"_524":525,"_485":486,"_526":527,"_528":61},"branch",{"_17":159,"_13":16,"_40":48,"_514":475,"_515":-5,"_516":-5,"_517":-5,"_518":-5,"_519":-5,"_520":14,"_521":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Daniel Sitnik","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJwelNteERmakxrMG5QTzF4S001cVdrYWhCUSJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_40":475,"_13":14,"_53":714,"_477":-5,"_478":61,"_479":480,"_481":480,"_482":483,"_484":-5,"_485":486,"_487":122,"_488":52,"_489":52,"_490":-5,"_491":77,"_492":493,"_494":-5,"_495":-5,"_496":-5,"_497":-5,"_498":499,"_500":499,"_501":502,"_503":502,"_504":502,"_505":499,"_506":499,"_507":715,"_509":716,"_511":717,"_513":61},[573,575,585,593,615,619],"files",[573,574,575,576,577,578,579,580,581,582,583,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],"counts",{"_564":77,"_565":55,"_566":77,"_32":567,"_568":569},[550,551,552,553,554,555,556],{"_40":109,"_13":19,"_43":46,"_45":-5,"_47":48,"_49":110,"_51":52,"_53":111,"_17":77,"_56":112,"_58":-5,"_60":61,"_62":-5,"_18":549},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_40":102,"_13":103,"_43":104,"_45":46,"_47":48,"_49":105,"_51":52,"_53":106,"_17":55,"_56":57,"_58":107,"_60":61,"_62":-5,"_18":563},{"_40":95,"_13":96,"_43":97,"_45":46,"_47":48,"_49":98,"_51":52,"_53":99,"_17":69,"_56":57,"_58":100,"_60":61,"_62":-5,"_18":562},{"_40":87,"_13":88,"_43":89,"_45":46,"_47":48,"_49":90,"_51":52,"_53":91,"_17":92,"_56":57,"_58":93,"_60":61,"_62":-5,"_18":561},{"_40":80,"_13":81,"_43":82,"_45":46,"_47":48,"_49":83,"_51":52,"_53":84,"_17":77,"_56":57,"_58":85,"_60":61,"_62":-5,"_18":560},{"_40":72,"_13":73,"_43":74,"_45":46,"_47":48,"_49":75,"_51":52,"_53":76,"_17":77,"_56":57,"_58":78,"_60":61,"_62":-5,"_18":559},{"_40":64,"_13":65,"_43":66,"_45":46,"_47":48,"_49":67,"_51":52,"_53":68,"_17":69,"_56":57,"_58":70,"_60":61,"_62":-5,"_18":558},{"_40":41,"_13":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_17":55,"_56":57,"_58":59,"_60":61,"_62":-5,"_18":557},[19,42],[19,65],[19,73],[19,81],[19,88],[19,96],[19,103],"pulls","branches","forks",{"_570":125,"_572":77},"connections",{"_570":77,"_571":77},"count","unfilledCount","emptyCount",{"_40":460,"_13":461,"_43":462,"_45":-5,"_47":48,"_49":456,"_51":52,"_53":463,"_17":77,"_56":112,"_58":-5,"_60":61,"_62":-5,"_128":712,"_18":713},{"_40":467,"_13":468,"_43":469,"_45":462,"_47":48,"_49":470,"_51":52,"_53":471,"_17":55,"_56":24,"_58":472,"_60":61,"_62":-5,"_128":710,"_18":711},{"_40":372,"_13":373,"_43":374,"_45":-5,"_47":48,"_49":55,"_51":52,"_53":375,"_17":77,"_56":112,"_58":-5,"_60":61,"_62":-5,"_128":708,"_18":709},{"_40":451,"_13":452,"_43":453,"_45":374,"_47":48,"_49":454,"_51":52,"_53":455,"_17":456,"_56":57,"_58":457,"_60":61,"_62":-5,"_128":706,"_18":707},{"_40":443,"_13":444,"_43":445,"_45":374,"_47":48,"_49":446,"_51":52,"_53":447,"_17":92,"_56":57,"_58":448,"_60":61,"_62":-5,"_128":704,"_18":705},{"_40":435,"_13":436,"_43":437,"_45":374,"_47":48,"_49":438,"_51":52,"_53":439,"_17":77,"_56":57,"_58":440,"_60":61,"_62":-5,"_128":702,"_18":703},{"_40":427,"_13":428,"_43":429,"_45":374,"_47":48,"_49":430,"_51":52,"_53":431,"_17":77,"_56":24,"_58":432,"_60":61,"_62":-5,"_128":700,"_18":701},{"_40":419,"_13":420,"_43":421,"_45":374,"_47":48,"_49":422,"_51":52,"_53":423,"_17":110,"_56":24,"_58":424,"_60":61,"_62":-5,"_128":698,"_18":699},{"_40":411,"_13":412,"_43":413,"_45":374,"_47":48,"_49":414,"_51":52,"_53":415,"_17":125,"_56":24,"_58":416,"_60":61,"_62":-5,"_128":696,"_18":697},{"_40":403,"_13":404,"_43":405,"_45":374,"_47":48,"_49":406,"_51":52,"_53":407,"_17":55,"_56":24,"_58":408,"_60":61,"_62":-5,"_128":694,"_18":695},{"_40":395,"_13":396,"_43":397,"_45":374,"_47":48,"_49":398,"_51":52,"_53":399,"_17":55,"_56":57,"_58":400,"_60":61,"_62":-5,"_128":692,"_18":693},{"_40":387,"_13":388,"_43":389,"_45":374,"_47":48,"_49":390,"_51":52,"_53":391,"_17":77,"_56":24,"_58":392,"_60":61,"_62":-5,"_128":690,"_18":691},{"_40":109,"_13":19,"_43":46,"_45":-5,"_47":48,"_49":110,"_51":52,"_53":341,"_17":77,"_56":112,"_58":-5,"_60":61,"_62":-5,"_128":688,"_18":689},{"_40":102,"_13":103,"_43":104,"_45":46,"_47":48,"_49":105,"_51":52,"_53":369,"_17":55,"_56":57,"_58":107,"_60":61,"_62":-5,"_128":686,"_18":687},{"_40":95,"_13":96,"_43":97,"_45":46,"_47":48,"_49":98,"_51":52,"_53":366,"_17":69,"_56":57,"_58":100,"_60":61,"_62":-5,"_128":684,"_18":685},{"_40":87,"_13":88,"_43":89,"_45":46,"_47":48,"_49":90,"_51":52,"_53":363,"_17":92,"_56":57,"_58":93,"_60":61,"_62":-5,"_128":682,"_18":683},{"_40":80,"_13":81,"_43":82,"_45":46,"_47":48,"_49":83,"_51":52,"_53":360,"_17":77,"_56":57,"_58":85,"_60":61,"_62":-5,"_128":680,"_18":681},{"_40":72,"_13":73,"_43":74,"_45":46,"_47":48,"_49":75,"_51":52,"_53":357,"_17":77,"_56":57,"_58":78,"_60":61,"_62":-5,"_128":678,"_18":679},{"_40":64,"_13":65,"_43":66,"_45":46,"_47":48,"_49":67,"_51":52,"_53":354,"_17":69,"_56":57,"_58":70,"_60":61,"_62":-5,"_128":676,"_18":677},{"_40":41,"_13":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":351,"_17":55,"_56":57,"_58":59,"_60":61,"_62":-5,"_128":674,"_18":675},{"_40":164,"_13":165,"_43":166,"_45":-5,"_47":48,"_49":125,"_51":52,"_53":167,"_17":77,"_56":112,"_58":-5,"_60":61,"_62":-5,"_128":672,"_18":673},{"_40":302,"_13":303,"_43":304,"_45":166,"_47":48,"_49":305,"_51":52,"_53":306,"_17":77,"_56":112,"_58":-5,"_60":61,"_62":-5,"_128":670,"_18":671},{"_40":334,"_13":209,"_43":335,"_45":304,"_47":48,"_49":336,"_51":52,"_53":337,"_17":77,"_56":24,"_58":338,"_60":61,"_62":-5,"_128":668,"_18":669},{"_40":327,"_13":202,"_43":328,"_45":304,"_47":48,"_49":329,"_51":52,"_53":330,"_17":77,"_56":24,"_58":331,"_60":61,"_62":-5,"_128":666,"_18":667},{"_40":320,"_13":194,"_43":321,"_45":304,"_47":48,"_49":322,"_51":52,"_53":323,"_17":77,"_56":24,"_58":324,"_60":61,"_62":-5,"_128":664,"_18":665},{"_40":313,"_13":186,"_43":314,"_45":304,"_47":48,"_49":315,"_51":52,"_53":316,"_17":77,"_56":24,"_58":317,"_60":61,"_62":-5,"_128":662,"_18":663},{"_40":254,"_13":255,"_43":256,"_45":166,"_47":48,"_49":257,"_51":52,"_53":258,"_17":77,"_56":112,"_58":-5,"_60":61,"_62":-5,"_128":660,"_18":661},{"_40":295,"_13":209,"_43":296,"_45":256,"_47":48,"_49":297,"_51":52,"_53":298,"_17":77,"_56":24,"_58":299,"_60":61,"_62":-5,"_128":658,"_18":659},{"_40":288,"_13":202,"_43":289,"_45":256,"_47":48,"_49":290,"_51":52,"_53":291,"_17":77,"_56":24,"_58":292,"_60":61,"_62":-5,"_128":656,"_18":657},{"_40":281,"_13":194,"_43":282,"_45":256,"_47":48,"_49":283,"_51":52,"_53":284,"_17":77,"_56":24,"_58":285,"_60":61,"_62":-5,"_128":654,"_18":655},{"_40":274,"_13":186,"_43":275,"_45":256,"_47":48,"_49":276,"_51":52,"_53":277,"_17":77,"_56":24,"_58":278,"_60":61,"_62":-5,"_128":652,"_18":653},{"_40":266,"_13":267,"_43":268,"_45":256,"_47":48,"_49":269,"_51":52,"_53":270,"_17":77,"_56":24,"_58":271,"_60":61,"_62":-5,"_128":650,"_18":651},{"_40":215,"_13":216,"_43":217,"_45":166,"_47":48,"_49":218,"_51":52,"_53":219,"_17":77,"_56":112,"_58":-5,"_60":61,"_62":-5,"_128":648,"_18":649},{"_40":247,"_13":209,"_43":248,"_45":217,"_47":48,"_49":249,"_51":52,"_53":250,"_17":77,"_56":24,"_58":251,"_60":61,"_62":-5,"_128":646,"_18":647},{"_40":240,"_13":202,"_43":241,"_45":217,"_47":48,"_49":242,"_51":52,"_53":243,"_17":77,"_56":24,"_58":244,"_60":61,"_62":-5,"_128":644,"_18":645},{"_40":233,"_13":194,"_43":234,"_45":217,"_47":48,"_49":235,"_51":52,"_53":236,"_17":77,"_56":24,"_58":237,"_60":61,"_62":-5,"_128":642,"_18":643},{"_40":226,"_13":186,"_43":227,"_45":217,"_47":48,"_49":228,"_51":52,"_53":229,"_17":77,"_56":24,"_58":230,"_60":61,"_62":-5,"_128":640,"_18":641},{"_40":174,"_13":175,"_43":176,"_45":166,"_47":48,"_49":177,"_51":52,"_53":178,"_17":77,"_56":112,"_58":-5,"_60":61,"_62":-5,"_128":638,"_18":639},{"_40":208,"_13":209,"_43":210,"_45":176,"_47":48,"_49":211,"_51":52,"_53":212,"_17":77,"_56":24,"_58":198,"_60":61,"_62":-5,"_128":636,"_18":637},{"_40":201,"_13":202,"_43":203,"_45":176,"_47":48,"_49":204,"_51":52,"_53":205,"_17":77,"_56":24,"_58":198,"_60":61,"_62":-5,"_128":634,"_18":635},{"_40":193,"_13":194,"_43":195,"_45":176,"_47":48,"_49":196,"_51":52,"_53":197,"_17":77,"_56":24,"_58":198,"_60":61,"_62":-5,"_128":632,"_18":633},{"_40":185,"_13":186,"_43":187,"_45":176,"_47":48,"_49":188,"_51":52,"_53":189,"_17":77,"_56":24,"_58":190,"_60":61,"_62":-5,"_128":630,"_18":631},{"_40":131,"_13":132,"_43":133,"_45":-5,"_47":48,"_49":69,"_51":52,"_53":134,"_17":77,"_56":112,"_58":-5,"_60":61,"_62":-5,"_128":628,"_18":629},{"_40":156,"_13":157,"_43":158,"_45":133,"_47":48,"_49":159,"_51":52,"_53":160,"_17":69,"_56":57,"_58":161,"_60":61,"_62":-5,"_128":626,"_18":627},{"_40":148,"_13":149,"_43":150,"_45":133,"_47":48,"_49":151,"_51":52,"_53":152,"_17":77,"_56":57,"_58":153,"_60":61,"_62":-5,"_128":624,"_18":625},{"_40":140,"_13":141,"_43":142,"_45":133,"_47":48,"_49":143,"_51":52,"_53":144,"_17":77,"_56":57,"_58":145,"_60":61,"_62":-5,"_128":622,"_18":623},{"_40":120,"_13":121,"_43":122,"_45":-5,"_47":48,"_49":123,"_51":52,"_53":124,"_17":125,"_56":126,"_58":127,"_60":61,"_62":14,"_128":620,"_18":621},[],[121],[],[132,141],[],[132,149],[],[132,157],[616,617,618],[132],[],[165,175,186],[],[165,175,194],[],[165,175,202],[],[165,175,209],[611,612,613,614],[165,175],[],[165,216,186],[],[165,216,194],[],[165,216,202],[],[165,216,209],[606,607,608,609],[165,216],[],[165,255,267],[],[165,255,186],[],[165,255,194],[],[165,255,202],[],[165,255,209],[600,601,602,603,604],[165,255],[],[165,303,186],[],[165,303,194],[],[165,303,202],[],[165,303,209],[595,596,597,598],[165,303],[594,599,605,610],[165],[],[19,42],[],[19,65],[],[19,73],[],[19,81],[],[19,88],[],[19,96],[],[19,103],[586,587,588,589,590,591,592],[19],[],[373,388],[],[373,396],[],[373,404],[],[373,412],[],[373,420],[],[373,428],[],[373,436],[],[373,444],[],[373,452],[576,577,578,579,580,581,582,583,584],[373],[],[461,468],[574],[461],["D",1764345214194],{"_11":12,"_529":525},{"_11":12,"_522":523,"_524":525,"_485":486,"_526":527,"_528":61},{"_17":159,"_13":16,"_40":48,"_514":475,"_515":-5,"_516":-5,"_517":-5,"_518":-5,"_519":-5,"_520":14,"_521":12},"ctx",{"_507":-5,"_546":751,"_752":753,"_754":755,"_756":61,"_757":61,"_758":61,"_759":52,"_760":-5,"_761":-7,"_762":-7,"_763":77,"_764":61,"_765":61,"_766":-5,"_767":61,"_768":61,"_769":61,"_770":-5},"ENV",{"_722":723,"_724":725,"_726":16,"_727":728,"_729":730,"_731":732,"_733":734,"_735":736,"_737":738,"_739":740,"_741":742,"_743":744,"_745":746,"_747":748,"_749":750},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]