🤖 Cron Agent Dashboard

\n This agent runs on a schedule, picks a random topic, and logs a fun fact.\n Each run is saved to SQLite and displayed below.\n

\n\n

\n \n \n \n \n \n \n \n \n \n \n ${rowsHtml}\n \n

#	Time	Topic	Fact

\n\n

\n view source\n •\n Refreshes on page load — cron runs every hour by default\n

\n\n`;\n\n if (new URL(req.url).pathname === \"/source\") {\n return new Response(null, {\n status: 302,\n headers: { Location: parseVal().links.self.val },\n });\n }\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n}\n","label",[77],"57e126a0-4ac7-11f1-bd66-ee650bb23af1",["D",1778235545837],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport OpenAI from \"npm:openai\";\n\nconst openai = new OpenAI();\n\n// Create table to store agent runs\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS agent_runs (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n ran_at TEXT NOT NULL,\n topic TEXT NOT NULL,\n summary TEXT NOT NULL\n)`);\n\n// Fun topics the agent \"researches\" each run\nconst topics = [\n \"space exploration news\",\n \"interesting animal facts\",\n \"cool science discoveries\",\n \"weird history events\",\n \"fun math puzzles\",\n \"ocean mysteries\",\n \"unusual weather phenomena\",\n \"quirky inventions\",\n];\n\nfunction pickRandom(arr: T[]): T {\n return arr[Math.floor(Math.random() * arr.length)];\n}\n\nasync function generateFact(topic: string): Promise {\n const response = await openai.chat.completions.create({\n model: \"gpt-4o-mini\",\n messages: [\n {\n role: \"system\",\n content:\n \"You are a fun facts agent. Given a topic, share one surprising, little-known, and accurate fact. Keep it to 1-2 sentences. Be concise and delightful.\",\n },\n {\n role: \"user\",\n content: `Tell me a surprising fact about: ${topic}`,\n },\n ],\n max_tokens: 150,\n });\n\n return response.choices[0]?.message?.content?.trim() ?? \"No fact generated.\";\n}\n\nexport default async function (interval: Interval) {\n const topic = pickRandom(topics);\n const summary = await generateFact(topic);\n const now = new Date().toISOString();\n\n // Save the run to SQLite\n await sqlite.execute({\n sql: \"INSERT INTO agent_runs (ran_at, topic, summary) VALUES (?, ?, ?)\",\n args: [now, topic, summary],\n });\n\n console.log(`🤖 Agent ran at ${now}`);\n console.log(`📚 Topic: ${topic}`);\n console.log(`💡 Fact: ${summary}`);\n}\n",[62],"pulls","branches","forks","envVars",{"_190":20,"_192":20},"connections",{"_190":20,"_191":20},"count","unfilledCount","emptyCount",{"_30":179,"_13":62,"_60":61,"_40":-5,"_32":33,"_172":89,"_173":107,"_34":199,"_36":71,"_63":94,"_175":181,"_65":24,"_177":-5,"_196":200,"_147":201},{"_30":171,"_13":77,"_60":76,"_40":-5,"_32":33,"_172":71,"_173":107,"_34":195,"_36":20,"_63":78,"_175":176,"_65":24,"_177":-5,"_196":197,"_147":198},["D",1778233664895],"children",[],[77],["D",1778235545837],[],[62],["D",1778233630396],["D",1789665082245],{"_11":12,"_146":68},{"_11":12,"_141":142,"_67":68,"_25":66,"_143":144,"_145":24},{"_36":89,"_13":16,"_30":33,"_133":95,"_134":-5,"_135":-5,"_136":-5,"_137":-5,"_138":-5,"_139":14,"_140":12},"ctx",{"_49":-5,"_166":240,"_241":242,"_243":244,"_245":24,"_246":24,"_247":24,"_248":107,"_249":-5,"_250":-7,"_251":-7,"_252":20,"_253":24,"_254":24,"_255":-5,"_256":24,"_257":24,"_258":24,"_259":-5},"ENV",{"_211":212,"_213":214,"_215":16,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","a3e067d4463eea85f6334f8e583e8516ae58c4f6","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"]

History