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`;","deleted","label",[100],"permalink","https://www.val.town/x/kailhus/checkMixcloudIsLive/code/main.tsx","extension","actionData","errors"]

Mixcloud Live Status Checker

Channel: {submittedChannel}