Mixcloud Live Status Checker

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const url = new URL(request.url);\n\n // Dynamic import of sqlite\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n // Use val's unique URL path as a key for table versioning\n const KEY = \"checkMixcloudIsLive\";\n const SCHEMA_VERSION = 1;\n\n // Create table for storing live status results\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_mixcloud_live_status_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n channel_name TEXT NOT NULL,\n is_live BOOLEAN NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n if (url.pathname === \"/check-live-status\") {\n const channelName = url.searchParams.get(\"channel\");\n if (!channelName) throw \"Missing channel Name\";\n\n const isLive = await checkMixcloudLiveStatus(channelName, sqlite, KEY, SCHEMA_VERSION);\n return new Response(JSON.stringify({ isLive }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // New route to get latest status\n if (url.pathname === \"/get-latest-status\") {\n const channelName = url.searchParams.get(\"channel\");\n if (!channelName) {\n return new Response(JSON.stringify({ \n error: \"Missing channel parameter\" \n }), { \n status: 400, \n headers: { \"Content-Type\": \"application/json\" } \n });\n }\n\n const lowercaseChannelName = channelName.toLowerCase();\n \n // Query to get the latest entry for the specific channel\n const result = await sqlite.execute(`\n SELECT is_live, timestamp \n FROM ${KEY}_mixcloud_live_status_${SCHEMA_VERSION}\n WHERE channel_name = ?\n ORDER BY timestamp DESC\n LIMIT 1\n `, [lowercaseChannelName]);\n\n // Determine status based on query result\n let status: 'LIVE' | 'NOT_LIVE' | 'UNKNOWN';\n let dateChecked: string | null = null;\n\n if (result.rows.length > 0) {\n const row = result.rows[0];\n status = row.is_live ? 'LIVE' : 'NOT_LIVE';\n dateChecked = row.timestamp;\n } else {\n status = 'UNKNOWN';\n }\n\n return new Response(JSON.stringify({\n date_checked: dateChecked,\n channel_name: lowercaseChannelName,\n status\n }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n\n return new Response(\n `\n \n \n Mixcloud Live Status\n \n \n \n \n

\n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}\n\nasync function checkMixcloudLiveStatus(\n channelName: string,\n sqlite?: any,\n key?: string,\n schemaVersion?: number,\n): Promise {\n try {\n const browserlessToken = Deno.env.get(\"browserless\");\n if (!browserlessToken) {\n console.error(\"Browserless token not found\");\n return false;\n }\n\n const res = await fetch(\n `https://chrome.browserless.io/scrape?token=${browserlessToken}`,\n {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n \"url\": `https://www.mixcloud.com/${channelName}`,\n \"elements\": [\n {\n // Selector to find element with href containing /live/channelName\n \"selector\": `a[href*=\"/live/${channelName}\"]`,\n },\n ],\n }),\n },\n );\n\n // Check if the response is ok\n if (!res.ok) {\n console.error(`Browserless request failed with status: ${res.status}`);\n return false;\n }\n\n // Parse the response\n const data = await res.json();\n\n // Log the raw response for debugging\n console.log(\"Browserless response:\", data);\n\n // Check if the first item exists and has results\n const firstItem = data.data[0];\n\n // Determine live status\n const isLive = firstItem.results.length > 0;\n\n // Store result in SQLite if sqlite connection is provided\n if (sqlite && key && schemaVersion !== undefined) {\n await sqlite.execute(\n `\n INSERT INTO ${key}_mixcloud_live_status_${schemaVersion} \n (channel_name, is_live) \n VALUES (?, ?)\n `,\n [channelName.toLowerCase(), isLive],\n );\n }\n\n // Return true if any matching elements found\n return isLive;\n } catch (error) {\n console.error(\"Comprehensive error checking Mixcloud live status:\", error);\n return false;\n }\n}\n\nconst css = `\nbody { \n font-family: Arial, sans-serif; \n text-align: center; \n max-width: 600px; \n margin: 0 auto; \n padding: 20px;\n}\na { \n text-decoration: none; \n color: #666; \n}\ninput, button {\n font-size: 16px;\n}\n`;",[],[174],"files",[153,172],"counts",{"_185":32,"_186":121,"_187":32,"_188":189},"pulls","branches","forks","envVars",{"_190":32,"_191":32},"count","emptyCount","contents",[194,197],{"_103":154,"_96":155,"_156":157,"_158":-5,"_159":141,"_160":121,"_161":109,"_105":195,"_100":32,"_163":164,"_165":166,"_167":22,"_168":-5,"_99":196},["D",1738531975920],[155],{"_103":173,"_96":174,"_156":116,"_158":-5,"_159":141,"_160":140,"_161":109,"_105":198,"_100":176,"_163":177,"_165":178,"_167":22,"_168":-5,"_99":199},["D",1738833909688],[174],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name._index",{"_94":95,"_96":97,"_98":-7,"_100":-7,"_101":208,"_192":213,"_218":219,"_222":-5,"_223":-5,"_181":224,"_231":228,"_232":-5,"_233":-5,"_234":22,"_235":22},{"_103":104,"_96":97,"_105":209,"_107":-5,"_108":109,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":116,"_117":109,"_118":-5,"_119":-5,"_120":121,"_16":122,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_23":210,"_135":211,"_138":212,"_150":22},["D",1746139462872],{"_94":95,"_133":134},{"_94":95,"_137":134,"_14":114},{"_100":140,"_96":44,"_103":141,"_142":104,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":-5,"_148":97,"_149":95},[214,216],{"_103":154,"_96":155,"_156":157,"_158":-5,"_159":141,"_160":121,"_161":109,"_105":195,"_100":32,"_163":164,"_165":166,"_167":22,"_168":-5,"_99":215},[155],{"_103":173,"_96":174,"_156":116,"_158":-5,"_159":141,"_160":140,"_161":109,"_105":198,"_100":176,"_163":177,"_165":178,"_167":22,"_168":-5,"_99":217},[174],"readme",{"_103":154,"_96":155,"_156":157,"_158":-5,"_159":141,"_160":121,"_161":109,"_105":220,"_100":32,"_163":164,"_165":166,"_167":22,"_168":-5,"_99":221},["D",1738531975920],[155],"upstream","pull",[225,228],{"_103":154,"_96":155,"_156":157,"_158":-5,"_159":141,"_160":121,"_161":109,"_105":162,"_100":32,"_163":164,"_165":166,"_167":22,"_168":-5,"_169":226,"_99":227},[],[155],{"_103":173,"_96":174,"_156":116,"_158":-5,"_159":141,"_160":140,"_161":109,"_105":175,"_100":176,"_163":177,"_165":178,"_167":22,"_168":-5,"_169":229,"_99":230},[],[174],"preview","ahead","behind","showHomeCustomizationHint","showHTTPPreviewSettingsHint","actionData","errors"]

Mixcloud Live Status Checker

Channel: {submittedChannel}

kailhus

checkMixcloudIsLive