[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_235":236,"_237":238},"routes/_app.x.$handle.$name",{"_105":104,"_38":50,"_114":95,"_33":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_26":-5,"_126":-5,"_127":-5,"_128":54,"_129":130,"_131":31,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_38":50,"_43":51,"_52":-5,"_53":54,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":31,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":54},"version",47,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","85f07e0d-f02f-4927-9b94-6558ef12733c","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",true,"deletedHere","path","test.js","latestPath","fileId","1862c610-9b70-11f1-ade9-1607ee4eb77e","name","fileType","script","content","// Test Now buttons: run a task immediately and show the outcome on its row,\n// without consuming the task (status/run_at are left untouched by the server).\ndocument.addEventListener(\"DOMContentLoaded\", () => {\n // The form page is behind APP_SECRET (passed as ?secret=...), so reuse it\n // on the test requests made from this page.\n const secret = new URLSearchParams(window.location.search).get(\"secret\") || \"\";\n\n for (const btn of document.querySelectorAll(\"button.test\")) {\n btn.addEventListener(\"click\", async () => {\n const id = btn.dataset.id;\n const out = document.getElementById(\"test-result-\" + id);\n if (!out) return;\n\n btn.disabled = true;\n const label = btn.textContent;\n btn.textContent = \"Testing…\";\n out.className = \"test-result\";\n out.textContent = \"Running…\";\n\n const qs = secret ? \"?secret=\" + encodeURIComponent(secret) : \"\";\n try {\n const resp = await fetch(\"/test/\" + id + qs, { method: \"POST\" });\n const data = await resp.json().catch(() => ({}));\n if (resp.ok && data.url) {\n out.className = \"test-result\";\n out.innerHTML =\n 'Open result page ↗';\n } else if (resp.ok && data.error) {\n out.className = \"test-result res-error\";\n out.textContent = \"Error: \" + data.error;\n } else if (resp.ok) {\n out.className = \"test-result res-ok\";\n out.textContent = \"Sent — check your email.\";\n } else {\n out.className = \"test-result res-error\";\n out.textContent = (data && data.error) ? data.error : \"Test failed (\" + resp.status + \").\";\n }\n } catch (e) {\n out.className = \"test-result res-error\";\n out.textContent = \"Error: \" + e.message;\n } finally {\n btn.disabled = false;\n btn.textContent = label;\n }\n });\n }\n});\n","createdAt",["D",1789474242045],"branchVersion","branchId","7cc41e5b-7347-409f-bdd2-d6cabae85cc2","id","b6c508ed-5367-4c80-adf4-89148338dcf2","scheduler",["D",1787102792105],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","Aylık takvim todo + mail bildirimleri | SQLite, cron, nodemailer","imageUrl","36451bfa-e5dd-4ea2-8063-aefa91faa516","pinnedFileId","02883800-9b6d-11f1-8f0e-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0178b-157e-745d-828e-eb11a1cff70a","tursoName","b6c508ed53674c80adf489148338dcf2","tursoHostname","b6c508ed53674c80adf489148338dcf2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789534231467],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_113":109},"org",{"_105":104,"_106":107,"_108":109,"_19":61,"_110":111,"_112":54},"branch",{"_13":94,"_38":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"isOwned",78,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","user9823475","handle","displayName","okan akar","avatar","https://lh3.googleusercontent.com/a/ACg8ocKVv87Cs_fECuMIhkwYWxOb1IWIAtks8lzjYrrflQ1fhtYr6A=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_38":50,"_43":230,"_52":-5,"_53":54,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":31,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":231,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":232,"_89":233,"_91":234,"_93":54},"tree",[205,206,207,208,209,210],"files",[205,206,207,208,209,210],"counts",{"_194":68,"_195":191,"_196":68,"_197":198,"_199":200},"contents",[136,137,138,139,140,141],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":186,"_38":187,"_36":188,"_145":-5,"_46":47,"_45":189,"_147":54,"_43":190,"_13":191,"_39":26,"_41":192,"_30":54,"_151":-5,"_33":193},{"_48":177,"_38":178,"_36":179,"_145":-5,"_46":47,"_45":180,"_147":54,"_43":181,"_13":182,"_39":183,"_41":184,"_30":54,"_151":-5,"_33":185},{"_48":170,"_38":171,"_36":172,"_145":-5,"_46":47,"_45":173,"_147":54,"_43":174,"_13":158,"_39":40,"_41":175,"_30":54,"_151":-5,"_33":176},{"_48":161,"_38":162,"_36":63,"_145":-5,"_46":47,"_45":163,"_147":54,"_43":164,"_13":165,"_39":166,"_41":167,"_30":54,"_151":168,"_33":169},{"_48":153,"_38":154,"_36":155,"_145":-5,"_46":47,"_45":156,"_147":54,"_43":157,"_13":158,"_39":26,"_41":159,"_30":54,"_151":-5,"_33":160},{"_48":142,"_38":143,"_36":144,"_145":-5,"_46":47,"_45":146,"_147":54,"_43":148,"_13":149,"_39":40,"_41":150,"_30":54,"_151":-5,"_33":152},"ffbdb019-06ce-4ef1-bca0-e95b68650f4c","run.ts","c25bf25a-9b6f-11f1-b373-1607ee4eb77e","parentId",45,"latest",["D",1787106112197],10,"import nodemailer from \"npm:nodemailer\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { httpEndpoint } from \"https://esm.town/v/std/utils/index.ts\";\nimport { generateMailContent, generatePageCards } from \"./llm.ts\";\nimport type { Task } from \"./db.ts\";\n\n/** Recipient for all scheduled-task output (page links, reminders, failures). */\nexport const TO = \"akarokan.97@gmail.com\";\n\nconst transporter = nodemailer.createTransport({\n service: \"gmail\",\n auth: {\n user: Deno.env.get(\"GMAIL_USER\"),\n pass: Deno.env.get(\"GMAIL_PASS\"),\n },\n});\n\n/** Send an email via Gmail SMTP to the recipient in `TO`. */\nexport async function sendMail(\n opts: { subject: string; text: string; html?: string },\n): Promise {\n await transporter.sendMail({\n from: Deno.env.get(\"GMAIL_USER\"),\n to: TO,\n subject: opts.subject,\n text: opts.text,\n html: opts.html,\n });\n}\n\nfunction escHtml(s: string): string {\n return s.replace(/[&<>\"']/g, (ch) =>\n ({ \"&\": \"&\", \"<\": \"<\", \">\": \">\", '\"': \""\", \"'\": \"'\" })[ch]!\n );\n}\n\ninterface MailHtml {\n headline: string;\n body?: string;\n request?: string;\n actionUrl?: string;\n actionText?: string;\n fallbackUrl?: string;\n adminUrl?: string | null;\n}\n\n/** The scheduler's own admin (management) page, signed with the app secret. */\nasync function adminUrl(): Promise {\n const secret = Deno.env.get(\"APP_SECRET\");\n if (!secret) return null;\n const base = (await httpEndpoint(\"/main.ts\")).replace(/\\/+$/, \"\");\n return `${base}/?secret=${encodeURIComponent(secret)}`;\n}\n\n/**\n * Build a self-contained HTML email (inline styles for mail clients):\n * a headline, an explanation of the original request, the body copy, a\n * prominent button for the main link, and a faded-out admin link at the\n * bottom so the management page stays handy without shouting.\n */\nfunction renderMailHtml(o: MailHtml): string {\n const request = o.request\n ? `

You asked: “${escHtml(o.request)}”

`\n : \"\";\n\n const body = o.body\n ? o.body\n .split(/\\n\\s*\\n+/)\n .map(\n (p) =>\n `

${escHtml(p).replace(/\\n/g, \"
\")}

`,\n )\n .join(\"\")\n : \"\";\n\n const button = o.actionUrl\n ? `

\n ${escHtml(o.actionText ?? \"Open\")}\n

`\n : \"\";\n\n const fallback = o.fallbackUrl\n ? `

If the button doesn’t open, paste this address in your browser:
${escHtml(o.fallbackUrl)}

`\n : \"\";\n\n const admin = o.adminUrl\n ? `

Admin · view and manage your scheduled tasks:
${escHtml(o.adminUrl)}

`\n : \"\";\n\n return `\n

\n \n \n \n

${escHtml(o.headline)}

\n ${request}${body}${button}${fallback}${admin}\n

Sent by your Task Scheduler

`;\n}\n\n/**\n * Outcome of running a task via `executeTask`.\n * `url` is set only for page-output tasks that produced a viewable page.\n * `error` is set only when the run failed.\n */\nexport interface TaskResult {\n ok: boolean;\n url?: string;\n error?: string;\n}\n\n/**\n * Run a single task through the same generation path the cron uses\n * (mail or page via the LLM, then email / blob store + email).\n *\n * IMPORTANT: this is a pure execution — it does NOT consume the task.\n * It leaves `status` and `run_at` untouched, so the scheduled run still\n * fires normally and recurrence is not advanced. Callers decide whether\n * to mark the task done/error and reschedule.\n */\nexport async function executeTask(task: Task): Promise {\n try {\n if (task.output === \"mail\") {\n const { subject, content } = await generateMailContent(\n task.task,\n task.repeat,\n task.run_at,\n );\n await sendMail({\n subject,\n text: content,\n html: renderMailHtml({\n headline: subject,\n request: task.task,\n body: content,\n adminUrl: await adminUrl(),\n }),\n });\n return { ok: true };\n }\n // page output\n const { subject, cards } = await generatePageCards(\n task.task,\n task.repeat,\n task.run_at,\n );\n const key = crypto.randomUUID().replaceAll(\"-\", \"\");\n await blob.setJSON(key, cards);\n const base = (await httpEndpoint(\"/main.ts\")).replace(/\\/+$/, \"\");\n const url = `${base}/s/${key}`;\n await sendMail({\n subject,\n text: `Your page is ready. View it here:\\n\\n${url}`,\n html: renderMailHtml({\n headline: subject,\n request: task.task,\n body:\n \"Here's the page you scheduled — an easy-to-read summary, ready when you are.\",\n actionUrl: url,\n actionText: \"View page →\",\n fallbackUrl: url,\n adminUrl: await adminUrl(),\n }),\n });\n return { ok: true, url };\n } catch (err) {\n return {\n ok: false,\n error: err instanceof Error ? err.message : String(err),\n };\n }\n}","label",[143],"ebdffb2c-a0f0-4159-9c89-c52714c1cf12","page.html","36b394bc-9b6d-11f1-aee4-1607ee4eb77e",21,["D",1787103496712],2,"\n\n\n\n\nYour Page\n\n\n\n

Your scheduled page

\n\n\n\n",[154],"89f0e357-f351-4ce2-a59e-973c29c1667f","main.ts",38,["D",1787105568062],14,"http","import { Hono } from \"npm:hono\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { parseTask } from \"./llm.ts\";\nimport { insertTask, listTasks, getTask, deleteTask, type Task } from \"./db.ts\";\nimport { executeTask } from \"./run.ts\";\n\nconst SECRET = Deno.env.get(\"APP_SECRET\");\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\nconst CSS = `\n * { box-sizing: border-box; }\n body { margin:0; font-family:system-ui,-apple-system,\"Segoe UI\",Roboto,sans-serif; background:#f5f6f8; color:#1c1e21; }\n .wrap { max-width:720px; margin:0 auto; padding:24px 16px 64px; }\n h1 { font-size:24px; margin:0 0 4px; }\n .sub { color:#6b7280; margin:0 0 20px; }\n form.schedule { display:flex; flex-direction:column; gap:10px; margin-bottom:24px; }\n textarea { width:100%; min-height:120px; padding:14px; font-size:16px; border:1px solid #d1d5db; border-radius:10px; resize:vertical; font-family:inherit; }\n textarea:focus { outline:2px solid #2563eb; outline-offset:-1px; }\n button { border:none; border-radius:10px; padding:12px 18px; font-size:16px; font-weight:600; cursor:pointer; }\n button[type=submit] { background:#2563eb; color:#fff; }\n button[type=submit]:hover { background:#1d4ed8; }\n .confirm { background:#ecfdf5; border:1px solid #a7f3d0; color:#065f46; padding:14px 16px; border-radius:10px; margin-bottom:24px; }\n .confirm code { background:#d1fae5; padding:1px 6px; border-radius:6px; }\n h2 { font-size:18px; margin:28px 0 12px; }\n .empty { color:#6b7280; }\n .table { width:100%; border-collapse:collapse; background:#fff; border:1px solid #e5e7eb; border-radius:10px; overflow:hidden; }\n .table th, .table td { text-align:left; padding:10px 12px; border-bottom:1px solid #eef0f3; vertical-align:top; }\n .table th { background:#f9fafb; font-size:12px; text-transform:uppercase; letter-spacing:.04em; color:#6b7280; }\n .table tr:last-child td { border-bottom:none; }\n .table .task { font-weight:500; }\n .badge { display:inline-block; padding:2px 8px; border-radius:999px; font-size:12px; font-weight:600; white-space:nowrap; }\n .b-page { background:#eef2ff; color:#4338ca; }\n .b-mail { background:#fef3c7; color:#92400e; }\n .b-pending { background:#f3f4f6; color:#374151; }\n .b-done { background:#ecfdf5; color:#065f46; }\n .b-error { background:#fee2e2; color:#991b1b; }\n .actions { display:flex; gap:8px; align-items:center; flex-wrap:wrap; }\n button.test { background:#eef2ff; color:#4338ca; padding:6px 10px; font-size:13px; border-radius:8px; }\n button.test:hover { background:#e0e7ff; }\n button.test:disabled { opacity:.6; cursor:progress; }\n .del { background:#fee2e2; color:#b91c1c; padding:6px 10px; font-size:13px; border-radius:8px; }\n .del:hover { background:#fecaca; }\n .test-result { margin-top:6px; font-size:12px; line-height:1.4; }\n .test-result.res-error { color:#b91c1c; }\n .test-result.res-ok { color:#065f46; }\n a.res-link { color:#2563eb; font-weight:600; word-break:break-all; }\n .nowrap { white-space:nowrap; }\n .right { text-align:right; }\n @media (max-width:560px){\n .table thead { display:none; }\n .table, .table tbody, .table tr, .table td { display:block; width:100%; }\n .table tr { border:1px solid #e5e7eb; border-radius:10px; margin-bottom:10px; padding:8px 12px; }\n .table td { border:none; padding:4px 0; }\n .table td::before { content:attr(data-label); display:block; font-size:11px; text-transform:uppercase; letter-spacing:.04em; color:#6b7280; margin-bottom:2px; }\n }\n`;\n\nfunction badge(cls: string, label: string): string {\n return `${label}`;\n}\n\n/**\n * The form page and task-managing routes are protected by a shared APP_SECRET,\n * passed as the `secret` query parameter. When the secret is unset on the\n * server, access is denied by default (fail closed).\n */\nfunction authorized(secretQuery: string | null): boolean {\n if (!SECRET) return false;\n if (!secretQuery || secretQuery.length !== SECRET.length) return false;\n // constant-time comparison\n let diff = 0;\n for (let i = 0; i < SECRET.length; i++) diff |= secretQuery.charCodeAt(i) ^ SECRET.charCodeAt(i);\n return diff === 0;\n}\n\nasync function renderPage(confirmHtml: string, secret: string | null): Promise {\n const qs = secret ? `?secret=${encodeURIComponent(secret)}` : \"\";\n return `\n\n\nTask Scheduler\n\n

Task Scheduler

Describe a task in plain language — when, how often, and what to do.

\n${confirmHtml}\n\n

Scheduled tasks

\n${await tasksTable(qs)}\n

`;\n}\n\nasync function tasksTable(qs: string): Promise {\n const tasks = await listTasks();\n if (tasks.length === 0) {\n return `

No tasks yet. Schedule one above.

`;\n }\n const rows = tasks.map((t) => {\n const out = t.output === \"page\"\n ? badge(\"b-page\", \"page\")\n : badge(\"b-mail\", \"mail\");\n const status = t.status === \"done\"\n ? badge(\"b-done\", \"done\")\n : t.status === \"error\"\n ? badge(\"b-error\", \"error\")\n : badge(\"b-pending\", \"pending\");\n return `\n ${esc(fmt(t.run_at))}\n ${esc(t.task)}\n ${out}\n ${status}\n \n

\n \n \n

\n \n `;\n }).join(\"\");\n return `\n \n ${rows}

Run at	Task	Output	Status

`;\n}\n\nfunction fmt(iso: string): string {\n const d = new Date(iso);\n if (isNaN(d.getTime())) return iso;\n return d.toLocaleString(undefined, {\n month: \"short\", day: \"numeric\", hour: \"numeric\", minute: \"2-digit\",\n });\n}\n\napp.get(\"/\", async (c) => {\n const secret = c.req.query(\"secret\");\n if (!authorized(secret)) return c.text(\"Unauthorized\", 401);\n const added = Number(c.req.query(\"added\"));\n let confirmHtml = \"\";\n if (added) {\n const t = await getTask(added);\n if (t) {\n confirmHtml =\n `

Task scheduled ✓
` +\n `Run at ${esc(fmt(t.run_at))} · ` +\n `${esc(t.task)} · output: ${esc(t.output)}

`;\n }\n }\n return c.html(await renderPage(confirmHtml, secret));\n});\n\napp.post(\"/\", async (c) => {\n const secret = c.req.query(\"secret\");\n if (!authorized(secret)) return c.text(\"Unauthorized\", 401);\n const body = await c.req.parseBody();\n const t = String(body.t ?? \"\").trim();\n if (!t) return c.redirect(`/?secret=${encodeURIComponent(secret ?? \"\")}`);\n const parsed = await parseTask(t, new Date());\n const id = await insertTask(parsed);\n return c.redirect(`/?added=${id}&secret=${encodeURIComponent(secret ?? \"\")}`);\n});\n\napp.post(\"/delete/:id\", async (c) => {\n const secret = c.req.query(\"secret\");\n if (!authorized(secret)) return c.text(\"Unauthorized\", 401);\n const id = Number(c.req.param(\"id\"));\n if (id) await deleteTask(id);\n return c.redirect(`/?secret=${encodeURIComponent(secret ?? \"\")}`);\n});\n\n// Test Now: run a task immediately via the same path the cron uses.\n// This does NOT consume the task — status/run_at/recurrence are untouched,\n// so the task still fires normally at its scheduled time.\napp.post(\"/test/:id\", async (c) => {\n const secret = c.req.query(\"secret\");\n if (!authorized(secret)) return c.json({ error: \"Unauthorized\" }, 401);\n const id = Number(c.req.param(\"id\"));\n if (!id) return c.json({ error: \"Invalid task id\" }, 400);\n const task = await getTask(id);\n if (!task) return c.json({ error: \"Task not found\" }, 404);\n const result = await executeTask(task);\n if (result.ok) return c.json({ url: result.url ?? null });\n return c.json({ error: result.error ?? \"Failed\" });\n});\n\n// Static client script wiring the Test buttons.\napp.get(\"/test.js\", async () => {\n const js = await readFile(\"/test.js\");\n return new Response(js, {\n headers: { \"content-type\": \"text/javascript; charset=utf-8\" },\n });\n});\n\n// Generated pages stay public so links shared via email open without the secret.\napp.get(\"/s/:key\", async (c) => {\n const key = c.req.param(\"key\");\n try {\n const cards: unknown = await blob.getJSON(key);\n const template = await readFile(\"/page.html\");\n const html = template.replace(\"__CARDS_JSON__\", JSON.stringify(cards));\n return c.html(html);\n } catch {\n return c.text(\"Page not found\", 404);\n }\n});\n\nfunction esc(s: string): string {\n return s.replace(/[&<>\"']/g, (ch) =>\n ({ \"&\": \"&\", \"<\": \"<\", \">\": \">\", '\"': \""\", \"'\": \"'\" })[ch]!\n );\n}\n\nexport default app.fetch;\n","task-scheduler",[162],"e56b47fa-a982-4da2-814b-02f9ba547b19","db.ts","36a8cd0c-9b6d-11f1-aee4-1607ee4eb77e",16,["D",1787103477998],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface Task {\n id: number;\n run_at: string;\n repeat: \"none\" | \"daily\" | \"weekly\";\n task: string;\n output: \"mail\" | \"page\";\n status: \"pending\" | \"done\" | \"error\";\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS tasks (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n run_at TEXT NOT NULL,\n repeat TEXT NOT NULL DEFAULT 'none',\n task TEXT NOT NULL,\n output TEXT NOT NULL DEFAULT 'mail',\n status TEXT NOT NULL DEFAULT 'pending'\n)`);\n\nexport async function insertTask(t: {\n run_at: string;\n repeat: string;\n task: string;\n output: string;\n}): Promise {\n const res = await sqlite.execute({\n sql: \"INSERT INTO tasks (run_at, repeat, task, output, status) VALUES (?, ?, ?, ?, 'pending')\",\n args: [t.run_at, t.repeat, t.task, t.output],\n });\n return Number(res.lastInsertRowid);\n}\n\n/** All pending tasks whose run_at has passed. */\nexport async function getDueTasks(): Promise {\n const res = await sqlite.execute({\n sql: \"SELECT * FROM tasks WHERE status = 'pending' AND run_at <= ?\",\n args: [new Date().toISOString()],\n });\n return res.rows as Task[];\n}\n\nexport async function updateTask(\n id: number,\n status: \"pending\" | \"done\" | \"error\",\n runAt: string,\n): Promise {\n await sqlite.execute({\n sql: \"UPDATE tasks SET status = ?, run_at = ? WHERE id = ?\",\n args: [status, runAt, id],\n });\n}\n\n/** All tasks, ordered by when they fire, earliest first. */\nexport async function listTasks(): Promise {\n const res = await sqlite.execute(\"SELECT * FROM tasks ORDER BY run_at ASC\");\n return res.rows as Task[];\n}\n\nexport async function getTask(id: number): Promise {\n const res = await sqlite.execute({\n sql: \"SELECT * FROM tasks WHERE id = ?\",\n args: [id],\n });\n return (res.rows as Task[])[0];\n}\n\nexport async function deleteTask(id: number): Promise {\n await sqlite.execute({ sql: \"DELETE FROM tasks WHERE id = ?\", args: [id] });\n}\n",[171],"29b913f9-bedc-4ff5-b36e-a6e3b4dcfeca","cron.ts","36ba2304-9b6d-11f1-aee4-1607ee4eb77e",34,["D",1787105129031],6,"interval","import { getDueTasks, updateTask } from \"./db.ts\";\nimport { executeTask, sendMail } from \"./run.ts\";\n\nconst DAY = 24 * 60 * 60 * 1000;\n\n/** Compute the next run_at for a repeating task, or null if it's a one-off. */\nexport function nextRunAt(repeat: string, now: Date): string | null {\n if (repeat === \"daily\") return new Date(now.getTime() + DAY).toISOString();\n if (repeat === \"weekly\") return new Date(now.getTime() + 7 * DAY).toISOString();\n return null;\n}\n\nexport default async function (interval: Interval) {\n const due = await getDueTasks();\n for (const row of due) {\n const now = new Date();\n const result = await executeTask(row);\n if (result.ok) {\n const next = nextRunAt(row.repeat, now);\n await updateTask(row.id, next ? \"pending\" : \"done\", next ?? row.run_at);\n } else {\n console.error(\"Task failed:\", row.id, result.error);\n await updateTask(row.id, \"error\", row.run_at);\n try {\n await sendMail({\n subject: \"Scheduled task failed\",\n text:\n `Scheduled task #${row.id} (\"${row.task}\") failed:\\n\\n` +\n result.error,\n });\n } catch (emailErr) {\n console.error(\"Failed to send failure email:\", emailErr);\n }\n }\n }\n}\n",[178],"f7f640a0-5b11-4b6c-8cf0-607f55b94c93","README.md","6ba67bc6-9b6d-11f1-acc3-1607ee4eb77e",26,["D",1787103600307],1,"# Task Scheduler\n\nAn LLM-powered task scheduler on Val Town. Type a plain-language instruction; it's parsed by OpenAI into a scheduled task, stored in SQLite, and executed by a every-minute cron that delivers the result by email or as a hosted page.\n\nLive at **https://task-scheduler.val.run/**\n\n## How it works\n\n```\n/?t=... ──► LLM parses into {\"run_at\",\"repeat\",\"task\",\"output\"} ──► SQLite `tasks`\n ──► cron (every minute)\n ├─ mail → generate text → std/email\n └─ page → cards JSON → blob → email link → /s/{key}\n```\n\n### 1. Database (`db.ts`)\nSQLite table `tasks`:\n`id`, `run_at` (ISO timestamp), `repeat` (`none`/`daily`/`weekly`), `task`, `output` (`mail`/`page`), `status` (`pending`/`done`/`error`).\n\n### 2. HTTP endpoint (`main.ts`)\n- `GET /?t=` — parses the instruction with OpenAI (`std/openai`, model `gpt-5.4-nano`, using `max_completion_tokens`). The current UTC time is passed into the prompt so \"in 5 minutes\" / \"tomorrow at 8am\" resolve correctly. `output` is `page` when the instruction mentions a site/page/link (or is visual), else `mail`. Inserts the task and returns a confirmation page.\n- `GET /s/{key}` — serves a saved page.\n\n### 3. Cron (`cron.ts`)\nRuns every minute (`* * * * *` UTC). Finds `status = pending AND run_at <= now`. For each:\n- `mail` → generate content with OpenAI, send via `std/email`.\n- `page` → generate `{\"cards\":[{title,type:\"list\"|\"text\",content:[...]}]}`, embed into the self-contained page template, store under a random blob key, email only the `/s/{key}` link.\n- Then mark `done`, or compute the next `run_at` if it repeats daily/weekly.\n- On any failure: mark `error` and email the message.\n- Email subjects are LLM-generated as three pipe-separated parts, e.g. `To do list | Scheduled for 19.08 03:36 | Val` — the LLM phrases the middle schedule note per task (date/time for one-offs, \"Daily at 8am\" / \"Every Monday\" for recurring).\n\n## Page design (`page.html`)\nVertical list of cards. Clicking a card expands/collapses it. `list` cards render one checkbox per item — checked items show strikethrough, persisted in `localStorage` per card. Clicking anywhere on a checklist row toggles that item's checkbox; checkboxes are custom-styled to match the dark theme (accent fill + white check when checked).\n\n## Files\n| File | Type | Purpose |\n| --- | --- | --- |\n| `main.ts` | http | Title/parse endpoint + `/s/{key}` page server |\n| `db.ts` | script | SQLite helpers |\n| `llm.ts` | script | OpenAI helpers (parse task, generate mail/page content) |\n| `cron.ts` | interval | Every-minute scheduler |\n| `page.html` | file | Card page template |\n| `README.md` | file | This doc |\n\n## Usage\n```text\n/?t=remind me in 5 minutes to drink water\n/?t=daily at 8am send me a weather summary\n/?t=every week make a page with a checklist for my project kickoff\n```\n\n## Setup\nNo environment variables required — `std/openai` and `std/email` use Val Town's built-in credentials (the `valtown` token is injected automatically). Just remix or deploy the val.\n",[187],"pulls","branches","forks","envVars",{"_201":203,"_204":68},"connections",{"_201":68,"_202":68},"count","unfilledCount",3,"emptyCount",{"_48":186,"_38":187,"_36":188,"_145":-5,"_46":47,"_45":189,"_147":54,"_43":227,"_13":191,"_39":26,"_41":192,"_30":54,"_151":-5,"_212":228,"_33":229},{"_48":177,"_38":178,"_36":179,"_145":-5,"_46":47,"_45":180,"_147":54,"_43":224,"_13":182,"_39":183,"_41":184,"_30":54,"_151":-5,"_212":225,"_33":226},{"_48":170,"_38":171,"_36":172,"_145":-5,"_46":47,"_45":173,"_147":54,"_43":221,"_13":158,"_39":40,"_41":175,"_30":54,"_151":-5,"_212":222,"_33":223},{"_48":161,"_38":162,"_36":63,"_145":-5,"_46":47,"_45":163,"_147":54,"_43":218,"_13":165,"_39":166,"_41":167,"_30":54,"_151":168,"_212":219,"_33":220},{"_48":153,"_38":154,"_36":155,"_145":-5,"_46":47,"_45":156,"_147":54,"_43":215,"_13":158,"_39":26,"_41":159,"_30":54,"_151":-5,"_212":216,"_33":217},{"_48":142,"_38":143,"_36":144,"_145":-5,"_46":47,"_45":146,"_147":54,"_43":211,"_13":149,"_39":40,"_41":150,"_30":54,"_151":-5,"_212":213,"_33":214},["D",1787106112197],"children",[],[143],["D",1787103496712],[],[154],["D",1787105568062],[],[162],["D",1787103477998],[],[171],["D",1787105129031],[],[178],["D",1787103600307],[],[187],["D",1787102792105],["D",1789534231467],{"_105":104,"_113":109},{"_105":104,"_106":107,"_108":109,"_19":61,"_110":111,"_112":54},{"_13":94,"_38":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"ctx",{"_87":-5,"_133":268,"_269":270,"_271":272,"_273":54,"_274":54,"_275":54,"_276":31,"_277":-5,"_278":-7,"_279":-7,"_280":68,"_281":54,"_282":54,"_283":-5,"_284":54,"_285":54,"_286":54,"_287":-5},"ENV",{"_239":240,"_241":242,"_243":95,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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"]

Diff · v47