[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_230":231,"_232":233},"routes/_app.x.$handle.$name",{"_106":105,"_38":51,"_115":96,"_33":116,"_13":14,"_117":-5,"_11":118,"_119":120,"_121":122,"_123":124,"_125":126,"_26":-5,"_127":-5,"_128":-5,"_129":31,"_130":131,"_132":65,"_133":-5,"_134":-5,"_135":136},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":77,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":89,"_90":91,"_92":93,"_94":31},"version",24,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","45853ce0-e0bf-4649-988f-976c685caed0","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","cron.ts","latestPath","fileId","36ba2304-9b6d-11f1-aee4-1607ee4eb77e","name","fileType","interval","content","import { email } from \"https://esm.town/v/std/email\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { httpEndpoint } from \"https://esm.town/v/std/utils/index.ts\";\nimport { getDueTasks, updateTask, type Task } from \"./db.ts\";\nimport { generateMailContent, generatePageCards } from \"./llm.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: Task[] = await getDueTasks();\n for (const row of due) {\n const now = new Date();\n try {\n if (row.output === \"mail\") {\n const { subject, content } = await generateMailContent(\n row.task,\n row.repeat,\n row.run_at,\n );\n await email({ subject, text: content });\n } else {\n const { subject, cards } = await generatePageCards(\n row.task,\n row.repeat,\n row.run_at,\n );\n const key = crypto.randomUUID().replaceAll(\"-\", \"\");\n await blob.setJSON(key, cards);\n const base = await httpEndpoint(\"/main.ts\");\n const url = `${base}/s/${key}`;\n await email({ subject, text: `Your page is ready. View it here:\\n\\n${url}` });\n }\n const next = nextRunAt(row.repeat, now);\n await updateTask(row.id, next ? \"pending\" : \"done\", next ?? row.run_at);\n } catch (err) {\n console.error(\"Task failed:\", row.id, err);\n await updateTask(row.id, \"error\", row.run_at);\n try {\n await email({\n subject: \"Scheduled task failed\",\n text:\n `Scheduled task #${row.id} (\"${row.task}\") failed:\\n\\n` +\n (err instanceof Error ? err.message : String(err)),\n });\n } catch (emailErr) {\n console.error(\"Failed to send failure email:\", emailErr);\n }\n }\n }\n}\n","import { email } from \"https://esm.town/v/std/email\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { httpEndpoint } from \"https://esm.town/v/std/utils/index.ts\";\nimport { getDueTasks, updateTask, type Task } from \"./db.ts\";\nimport { generateMailContent, generatePageCards } from \"./llm.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: Task[] = await getDueTasks();\n for (const row of due) {\n const now = new Date();\n try {\n if (row.output === \"mail\") {\n const { subject, content } = await generateMailContent(\n row.task,\n row.repeat,\n row.run_at,\n );\n console.log(\"DEBUG subject:\", subject);\n await email({ subject, text: content });\n } else {\n const { subject, cards } = await generatePageCards(\n row.task,\n row.repeat,\n row.run_at,\n );\n const key = crypto.randomUUID().replaceAll(\"-\", \"\");\n await blob.setJSON(key, cards);\n const base = await httpEndpoint(\"/main.ts\");\n const url = `${base}/s/${key}`;\n await email({ subject, text: `Your page is ready. View it here:\\n\\n${url}` });\n }\n const next = nextRunAt(row.repeat, now);\n await updateTask(row.id, next ? \"pending\" : \"done\", next ?? row.run_at);\n } catch (err) {\n console.error(\"Task failed:\", row.id, err);\n await updateTask(row.id, \"error\", row.run_at);\n try {\n await email({\n subject: \"Scheduled task failed\",\n text:\n `Scheduled task #${row.id} (\"${row.task}\") failed:\\n\\n` +\n (err instanceof Error ? err.message : String(err)),\n });\n } catch (emailErr) {\n console.error(\"Failed to send failure email:\", emailErr);\n }\n }\n }\n}\n","createdAt",["D",1787103548314],"branchVersion","branchId","7cc41e5b-7347-409f-bdd2-d6cabae85cc2","id","b6c508ed-5367-4c80-adf4-89148338dcf2","scheduler",["D",1787102792105],"deletedAt","legacyEnvVars","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",true,"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",{"_106":105,"_114":110},"org",{"_106":105,"_107":108,"_109":110,"_19":61,"_111":112,"_113":31},"branch",{"_13":95,"_38":96,"_49":48,"_97":50,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":51,"_104":105},"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",{"_49":50,"_38":51,"_44":225,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":226,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":227,"_90":228,"_92":229,"_94":31},"tree",[200,201,202,203,204,205],"files",[200,201,202,203,204,205],"counts",{"_188":69,"_189":190,"_191":69,"_192":193,"_194":195},"contents",[137,138,139,140,141,142],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":181,"_38":182,"_36":183,"_146":-5,"_47":48,"_46":184,"_148":31,"_44":185,"_13":69,"_39":26,"_41":186,"_30":31,"_152":-5,"_33":187},{"_49":178,"_38":34,"_36":37,"_146":-5,"_47":48,"_46":14,"_148":31,"_44":179,"_13":150,"_39":40,"_41":43,"_30":31,"_152":-5,"_33":180},{"_49":171,"_38":172,"_36":173,"_146":-5,"_47":48,"_46":174,"_148":31,"_44":175,"_13":150,"_39":168,"_41":176,"_30":31,"_152":-5,"_33":177},{"_49":163,"_38":164,"_36":165,"_146":-5,"_47":48,"_46":166,"_148":31,"_44":167,"_13":150,"_39":168,"_41":169,"_30":31,"_152":-5,"_33":170},{"_49":154,"_38":155,"_36":63,"_146":-5,"_47":48,"_46":156,"_148":31,"_44":157,"_13":158,"_39":159,"_41":160,"_30":31,"_152":161,"_33":162},{"_49":143,"_38":144,"_36":145,"_146":-5,"_47":48,"_46":147,"_148":31,"_44":149,"_13":150,"_39":26,"_41":151,"_30":31,"_152":-5,"_33":153},"ebdffb2c-a0f0-4159-9c89-c52714c1cf12","page.html","36b394bc-9b6d-11f1-aee4-1607ee4eb77e","parentId",21,"latest",["D",1787103496712],2,"\n\n\n\n\nYour Page\n\n\n\n

Your scheduled page

\n\n\n\n","label",[144],"bbdd6738-2617-4d7d-8501-c1e084d87c8b","main.ts",19,["D",1787103484612],10,"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\";\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 .del { background:#fee2e2; color:#b91c1c; padding:6px 10px; font-size:13px; border-radius:8px; }\n .del:hover { background:#fecaca; }\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\nasync function renderPage(confirmHtml: string): Promise {\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()}\n

`;\n}\n\nasync function tasksTable(): 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 }).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 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));\n});\n\napp.post(\"/\", async (c) => {\n const body = await c.req.parseBody();\n const t = String(body.t ?? \"\").trim();\n if (!t) return c.redirect(\"/\");\n const parsed = await parseTask(t, new Date());\n const id = await insertTask(parsed);\n return c.redirect(`/?added=${id}`);\n});\n\napp.post(\"/delete/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n if (id) await deleteTask(id);\n return c.redirect(\"/\");\n});\n\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",[155],"dd4f966e-ade4-45ad-a370-123ec1aa4836","llm.ts","36ae7afe-9b6d-11f1-aee4-1607ee4eb77e",22,["D",1787103506894],"script","import { OpenAI } from \"https://esm.town/v/std/openai/main.ts\";\n\nconst openai = new OpenAI();\nconst MODEL = \"gpt-5.4-nano\";\n\nexport interface ParsedTask {\n run_at: string;\n repeat: \"none\" | \"daily\" | \"weekly\";\n task: string;\n output: \"mail\" | \"page\";\n}\n\nexport interface Card {\n title: string;\n type: \"list\" | \"text\";\n content: string[];\n}\n\n/**\n * Turn a plain-language instruction into a scheduled task.\n * Relative times are resolved against `now` (passed into the prompt).\n */\nexport async function parseTask(instruction: string, now: Date): Promise {\n const completion = await openai.chat.completions.create({\n model: MODEL,\n max_completion_tokens: 200,\n messages: [\n {\n role: \"system\",\n content:\n \"You convert a plain-language instruction into a scheduled task.\\n\" +\n `Current time: ${now.toISOString()} (ISO 8601 UTC). ` +\n \"Resolve relative times (e.g. \\\"in 5 minutes\\\", \\\"tomorrow at 8am\\\") into that UTC ISO timestamp.\\n\" +\n 'Answer with ONLY valid JSON matching: {\"run_at\":\"\",\"repeat\":\"none|daily|weekly\",\"task\":\"\",\"output\":\"mail|page\"}\\n' +\n 'Set \"repeat\" to \"daily\" for every day, \"weekly\" for every week, otherwise \"none\".\\n' +\n 'Set \"output\" to \"page\" if the instruction mentions a site, page, or link, or asks to create/show/see anything visual (report, checklist, board, list of links, graph). ' +\n 'Be aggressive about choosing \"page\" when words like \"page\", \"site\", \"link\", \"URL\", \"checklist\", or \"report\" appear. ' +\n 'Only set \"output\" to \"mail\" for simple text reminders, pings, or notifications.',\n },\n { role: \"user\", content: instruction },\n ],\n });\n const text = completion.choices[0].message.content ?? \"\";\n return JSON.parse(text) as ParsedTask;\n}\n\n/** Shared schedule context used to phrase email subjects. */\nfunction scheduleContext(task: string, repeat: string, runAt: string): string {\n return `Task: \"${task}\"\\nRepeat: ${repeat}\\nScheduled for: ${runAt} (ISO UTC)`;\n}\n\n/**\n * Normalize a subject from the LLM into \"Title | Schedule note | Val\".\n * Trims, drops empties, and guarantees the \"Val\" suffix.\n */\nexport function normalizeSubject(raw: string): string {\n const parts = raw\n .split(\"|\")\n .map((s) => s.trim())\n .filter((s) => s.length > 0);\n if (parts.length === 0) return `Task | Val`;\n if (parts[parts.length - 1].toLowerCase() !== \"val\") parts.push(\"Val\");\n return parts.slice(0, 3).join(\" | \");\n}\n\n/** Generate the subject + plain text body for a mail-output task. */\nexport async function generateMailContent(\n task: string,\n repeat: string,\n runAt: string,\n): Promise<{ subject: string; content: string }> {\n const completion = await openai.chat.completions.create({\n model: MODEL,\n max_completion_tokens: 600,\n messages: [\n {\n role: \"system\",\n content:\n \"You generate an email for a scheduled task.\\n\" +\n `${scheduleContext(task, repeat, runAt)}\\n` +\n 'Answer with ONLY valid JSON matching: {\"subject\":\"Title | Schedule note | Val\",\"content\":\"the email body\"}\\n' +\n '\"subject\" has exactly three parts separated by \" | \", ending with \"Val\". ' +\n 'Part 1 is a short name for the thing itself (e.g. \"To do list\"). ' +\n \"Part 2 is a human-readable schedule note phrased for THIS schedule: for a one-off use a date/time like \\\"Scheduled for 19.08 03:36\\\"; \" +\n 'for a recurring task use something like \"Daily at 8am\", \"Every Monday\", or \"Weekly\".\\n' +\n '\"content\" is the full body as plain text. If it is a checklist, use \"- item\" lines.',\n },\n { role: \"user\", content: task },\n ],\n });\n const text = completion.choices[0].message.content ?? \"\";\n const parsed = JSON.parse(text) as { subject?: string; content?: string };\n return {\n subject: normalizeSubject(parsed.subject ?? \"\"),\n content: parsed.content ?? \"\",\n };\n}\n\n/** Generate the subject + structured cards for a page-output task. */\nexport async function generatePageCards(\n task: string,\n repeat: string,\n runAt: string,\n): Promise<{ subject: string; cards: Card[] }> {\n const completion = await openai.chat.completions.create({\n model: MODEL,\n max_completion_tokens: 1000,\n messages: [\n {\n role: \"system\",\n content:\n \"You generate a page for a scheduled task.\\n\" +\n `${scheduleContext(task, repeat, runAt)}\\n` +\n 'Answer with ONLY valid JSON matching: {\"subject\":\"Title | Schedule note | Val\",\"cards\":[{\"title\":\"...\",\"type\":\"list|text\",\"content\":[\"...\"]}]}\\n' +\n '\"subject\" has exactly three parts separated by \" | \", ending with \"Val\". ' +\n 'Part 1 is a short name for the thing itself. ' +\n 'Part 2 is a human-readable schedule note phrased for THIS schedule (date/time for a one-off, \"Daily\"/\"Every Monday\" etc. for recurring).\\n' +\n 'Use \"type\":\"list\" for checklists and put each item as a separate string in \"content\". ' +\n 'Use \"type\":\"text\" for prose and put each paragraph as a separate string in \"content\".',\n },\n { role: \"user\", content: task },\n ],\n });\n const text = completion.choices[0].message.content ?? \"\";\n const parsed = JSON.parse(text) as { subject?: string; cards?: Card[] };\n return {\n subject: normalizeSubject(parsed.subject ?? \"\"),\n cards: parsed.cards ?? [],\n };\n}\n",[164],"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",[172],"c43b0601-4cf4-485b-bc32-ed3dca7d10f3",["D",1787103548314],[34],"7cf31206-2a22-43c3-aa50-caed4ee81ecd","README.md","6ba67bc6-9b6d-11f1-acc3-1607ee4eb77e",12,["D",1787102968493],"# 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\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.\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",[182],"pulls","branches",1,"forks","envVars",{"_196":198,"_199":69},"connections",{"_196":69,"_197":69},"count","unfilledCount",3,"emptyCount",{"_49":181,"_38":182,"_36":183,"_146":-5,"_47":48,"_46":184,"_148":31,"_44":222,"_13":69,"_39":26,"_41":186,"_30":31,"_152":-5,"_207":223,"_33":224},{"_49":178,"_38":34,"_36":37,"_146":-5,"_47":48,"_46":14,"_148":31,"_44":219,"_13":150,"_39":40,"_41":43,"_30":31,"_152":-5,"_207":220,"_33":221},{"_49":171,"_38":172,"_36":173,"_146":-5,"_47":48,"_46":174,"_148":31,"_44":216,"_13":150,"_39":168,"_41":176,"_30":31,"_152":-5,"_207":217,"_33":218},{"_49":163,"_38":164,"_36":165,"_146":-5,"_47":48,"_46":166,"_148":31,"_44":213,"_13":150,"_39":168,"_41":169,"_30":31,"_152":-5,"_207":214,"_33":215},{"_49":154,"_38":155,"_36":63,"_146":-5,"_47":48,"_46":156,"_148":31,"_44":210,"_13":158,"_39":159,"_41":160,"_30":31,"_152":161,"_207":211,"_33":212},{"_49":143,"_38":144,"_36":145,"_146":-5,"_47":48,"_46":147,"_148":31,"_44":206,"_13":150,"_39":26,"_41":151,"_30":31,"_152":-5,"_207":208,"_33":209},["D",1787103496712],"children",[],[144],["D",1787103484612],[],[155],["D",1787103506894],[],[164],["D",1787103477998],[],[172],["D",1787103548314],[],[34],["D",1787102968493],[],[182],["D",1787102792105],["D",1789534231467],{"_106":105,"_114":110},{"_106":105,"_107":108,"_109":110,"_19":61,"_111":112,"_113":31},{"_13":95,"_38":96,"_49":48,"_97":50,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":51,"_104":105},"ctx",{"_88":-5,"_134":263,"_264":265,"_266":267,"_268":31,"_269":31,"_270":31,"_271":65,"_272":-5,"_273":-7,"_274":-7,"_275":69,"_276":31,"_277":31,"_278":-5,"_279":31,"_280":31,"_281":31,"_282":-5},"ENV",{"_234":235,"_236":237,"_238":96,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262},"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 · v24