[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_175":176,"_177":178},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_132":-5,"_20":133,"_22":134,"_135":136,"_137":138,"_25":139,"_24":-5,"_140":-5,"_141":-5,"_142":54,"_143":144,"_145":45,"_146":-5,"_147":-5,"_148":149},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","harpery","name","cron-agent","branchName","main","version","path","","project",{"_34":74,"_13":14,"_46":75,"_76":-5,"_77":54,"_78":79,"_80":79,"_81":82,"_83":-5,"_84":85,"_86":38,"_87":45,"_88":-5,"_89":-5,"_90":48,"_91":92,"_93":94,"_95":96,"_97":98,"_99":-5,"_100":101,"_102":101,"_103":104,"_105":104,"_106":104,"_107":101,"_108":101,"_109":110,"_111":112,"_113":114,"_115":54},"tree",[65,66],"file","contents",[32,33],"upstream","pull","ahead","behind","envVars",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":43,"_49":62,"_51":63,"_53":54,"_55":-5,"_18":64},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":56},"id","f6bf33ac-4ac2-11f1-bc51-ee650bb23af1","dashboard.ts","fileId","f6bf346a-4ac2-11f1-bc51-ee650bb23af1","parentId","branchId","e22ea954-4ac2-11f1-a044-ee650bb23af1","branchVersion",2,"latest",true,"createdAt",["D",1778233664895],0,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\n// Create table if it doesn't exist yet\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\nexport default async function (req: Request): Promise {\n const runs = await sqlite.execute(\n \"SELECT * FROM agent_runs ORDER BY id DESC LIMIT 20\"\n );\n\n const rows = runs.rows as { id: number; ran_at: string; topic: string; summary: string }[];\n\n const rowsHtml = rows.length === 0\n ? `\n No runs yet — the cron agent will populate this on its next run!
\n You can also trigger it manually from the agent.ts file.\n `\n : rows.map(r => `\n \n ${r.id}\n ${new Date(r.ran_at).toLocaleString()}\n ${r.topic}\n ${r.summary}\n `).join(\"\");\n\n const html = `\n\n\n 🤖 Cron Agent Dashboard\n \n \n\n\n

🤖 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","deleted",false,"label",[36],"57e126a0-4ac7-11f1-bd66-ee650bb23af1","agent.ts","ef60a46a-4ac2-11f1-9589-ee650bb23af1",4,["D",1778235545837],"script","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",[58],{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":71,"_17":43,"_49":62,"_51":63,"_53":54,"_55":-5,"_68":72,"_18":73},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":67,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_68":69,"_18":70},["D",1778233664895],"children",[],[36],["D",1778235545837],[],[58],"e22dee92-4ac2-11f1-a044-ee650bb23af1",["D",1778233630396],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","AI agent triggered by a cron job","imageUrl","userId","aee2eb96-f654-4fa2-ad09-b191a053f83f","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019e06fa-6ccb-725d-b235-fda95c7b7c99","tursoName","e22dee924ac211f1a044ee650bb23af1","tursoHostname","e22dee924ac211f1a044ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789665082245],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_131":127},"org",{"_11":12,"_124":125,"_126":127,"_84":85,"_128":129,"_130":54},"branch",{"_17":60,"_13":16,"_34":41,"_116":74,"_117":-5,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":14,"_123":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Harper Yeh","avatar","https://lh3.googleusercontent.com/a/ACg8ocI3PG5k4CAmd6tpbFgagZ2m4ejIgrWrc3T6S-bVDDMIBHAbtkpF=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":74,"_13":14,"_46":170,"_76":-5,"_77":54,"_78":79,"_80":79,"_81":82,"_83":-5,"_84":85,"_86":38,"_87":45,"_88":-5,"_89":-5,"_90":48,"_91":92,"_93":94,"_95":96,"_97":171,"_99":-5,"_100":101,"_102":101,"_103":104,"_105":104,"_106":104,"_107":101,"_108":101,"_109":172,"_111":173,"_113":174,"_115":54},[164,165],"files",[164,165],"counts",{"_154":48,"_155":156,"_157":48,"_31":158,"_159":160},[150,151],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":43,"_49":62,"_51":63,"_53":54,"_55":-5,"_18":153},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":152},[36],[58],"pulls","branches",1,"forks",{"_161":48,"_163":48},"connections",{"_161":48,"_162":48},"count","unfilledCount","emptyCount",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":71,"_17":43,"_49":62,"_51":63,"_53":54,"_55":-5,"_68":168,"_18":169},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":67,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_68":166,"_18":167},[],[36],[],[58],["D",1778233630396],["D",1789665082245],{"_11":12,"_131":127},{"_11":12,"_124":125,"_126":127,"_84":85,"_128":129,"_130":54},{"_17":60,"_13":16,"_34":41,"_116":74,"_117":-5,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":14,"_123":12},"ctx",{"_109":-5,"_147":208,"_209":210,"_211":212,"_213":54,"_214":54,"_215":54,"_216":45,"_217":-5,"_218":-7,"_219":-7,"_220":48,"_221":54,"_222":54,"_223":-5,"_224":54,"_225":54,"_226":54,"_227":-5},"ENV",{"_179":180,"_181":182,"_183":16,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]

Code