Hi

\",\n});\n```\n\n## Val Town Utility Functions\n\nVal Town provides several utility functions to help with common project tasks.\n\n### Importing Utilities\n\nAlways import utilities with version pins to avoid breaking changes:\n\n```ts\nimport {\n parseProject,\n readFile,\n serveFile,\n} from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n### Available Utilities\n\n#### **serveFile** - Serve project files with proper content types\n\nFor example, in Hono:\n\n```ts\n// serve all files in frontend/ and shared/\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n```\n\n#### **readFile** - Read files from within the project:\n\n```ts\n// Read a file from the project\nconst fileContent = await readFile(\"/frontend/index.html\", import.meta.url);\n```\n\n#### **listFiles** - List all files in the project\n\n```ts\nconst files = await listFiles(import.meta.url);\n```\n\n#### **parseProject** - Extract information about the current project from import.meta.url\n\nThis is useful for including info for linking back to a val, ie in \"view source\"\nurls:\n\n```ts\nconst projectVal = parseProject(import.meta.url);\nconsole.log(projectVal.username); // Owner of the project\nconsole.log(projectVal.name); // Project name\nconsole.log(projectVal.version); // Version number\nconsole.log(projectVal.branch); // Branch name\nconsole.log(projectVal.links.self.project); // URL to the project page\n```\n\nHowever, it's _extremely importing_ to note that `parseProject` and other\nStandard Library utilities ONLY RUN ON THE SERVER. If you need access to this\ndata on the client, run it in the server and pass it to the client by splicing\nit into the HTML page or by making an API request for it.\n\n## Val Town Platform Specifics\n\n- **Redirects:** Use\n `return new Response(null, { status: 302, headers: { Location: \"/place/to/redirect\" }})`\n instead of `Response.redirect` which is broken\n- **Images:** Avoid external images or base64 images. Use emojis, unicode\n symbols, or icon fonts/libraries instead\n- **AI Image:** To inline generate an AI image use:\n `

`\n- **Storage:** DO NOT use the Deno KV module for storage\n- **Browser APIs:** DO NOT use the `alert()`, `prompt()`, or `confirm()` methods\n- **Weather Data:** Use open-meteo for weather data (doesn't require API keys)\n unless otherwise specified\n- **View Source:** Add a view source link by importing & using\n `import.meta.url.replace(\"ems.sh\", \"val.town)\"` (or passing this data to the\n client) and include `target=\"_top\"` attribute\n- **Error Debugging:** Add\n `` to HTML to capture\n client-side errors\n- **Error Handling:** Only use try...catch when there's a clear local\n resolution; Avoid catches that merely log or return 500s. Let errors bubble up\n with full context\n- **Environment Variables:** Use `Deno.env.get('keyname')` when you need to, but\n generally prefer APIs that don't require keys\n- **Imports:** Use `https://esm.sh` for npm and Deno dependencies to ensure\n compatibility on server and browser\n- **Storage Strategy:** Only use backend storage if explicitly required; prefer\n simple static client-side sites\n- **React Configuration:** When using React libraries, pin versions with\n `?deps=react@18.2.0,react-dom@18.2.0` and start the file with\n `/** @jsxImportSource https://esm.sh/react@18.2.0 */`\n- Ensure all React dependencies and sub-dependencies are pinned to the same\n version\n- **Styling:** Default to using TailwindCSS via\n `` unless otherwise\n specified\n\n## Project Structure and Design Patterns\n\n### Recommended Directory Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ │ └── README.md\n│ └── routes/ # Route modules\n│ ├── [route].ts\n│ └── static.ts # Static file serving\n│ ├── index.ts # Main entry point\n│ └── README.md\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ └── [Component].tsx\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend JS entry point\n│ ├── README.md\n│ └── style.css\n├── README.md\n└── shared/\n ├── README.md\n └── utils.ts # Shared types and functions\n```\n\n### Backend (Hono) Best Practices\n\n- Hono is the recommended API framework\n- Main entry point should be `backend/index.ts`\n- **Static asset serving:** Use the utility functions to read and serve project\n files:\n\n ```ts\n import {\n readFile,\n serveFile,\n } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\n // serve all files in frontend/ and shared/\n app.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\n app.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n // For index.html, often you'll want to bootstrap with initial data\n app.get(\"/\", async (c) => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Inject data to avoid extra round-trips\n const initialData = await fetchInitialData();\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n });\n ```\n\n- Create RESTful API routes for CRUD operations\n- Always include this snippet at the top-level Hono app to re-throwing errors to\n see full stack traces:\n ```ts\n // Unwrap Hono errors to see original error details\n app.onError((err, c) => {\n throw err;\n });\n ```\n\n### Database Patterns\n\n- Run migrations on startup or comment out for performance\n- Change table names when modifying schemas rather than altering\n- Export clear query functions with proper TypeScript typing\n\n## Common Gotchas and Solutions\n\n1. **Environment Limitations:**\n\n - Val Town runs on Deno in a serverless context, not Node.js\n - Code in `shared/` must work in both frontend and backend environments\n - Cannot use `Deno` keyword in shared code\n - Use `https://esm.sh` for imports that work in both environments\n\n2. **SQLite Peculiarities:**\n\n - Limited support for ALTER TABLE operations\n - Create new tables with updated schemas and copy data when needed\n - Always run table creation before querying\n\n3. **React Configuration:**\n\n - All React dependencies must be pinned to 18.2.0\n - Always include `@jsxImportSource https://esm.sh/react@18.2.0` at the top of\n React files\n - Rendering issues often come from mismatched React versions\n\n4. **File Handling:**\n\n - Val Town only supports text files, not binary\n - Use the provided utilities to read files across branches and forks\n - For files in the project, use `readFile` helpers\n\n5. **API Design:**\n - `fetch` handler is the entry point for HTTP vals\n - Run the Hono app with\n `export default app.fetch // This is the entry point for HTTP vals`\n",[],[173],{"_103":182,"_95":183,"_153":184,"_155":-5,"_156":138,"_157":185,"_159":22,"_105":186,"_99":187,"_162":163,"_164":188,"_166":22,"_167":-5,"_168":189,"_98":190},"0f58a68c-c8d2-11f0-a0ff-42dde27851f2","QUICKSTART.md","955f6422-c8ce-11f0-9c36-42dde27851f2",27,["D",1763946497450],2,"# Quick Start Guide\n\nYour lightweight queue system is set up and ready to use!\n\n## 🎯 What's Been Created\n\nA complete SQLite-based queue system with:\n\n- ✅ Database schema initialized\n- ✅ Priority-based task processing\n- ✅ Delayed/scheduled execution\n- ✅ Automatic retries with dead letter queue\n- ✅ Worker running every minute\n- ✅ Built-in monitoring\n\n## 🚀 Quick Start\n\n### 1. View Your Val\n\nVisit: https://www.val.town/x/nbbaier/lightweightQueue\n\n### 2. Enqueue Your First Task\n\n```bash\ncurl -X POST https://nbbaier--c5bd3e20c8cc11f0a88c42dde27851f2.web.val.run \\\n -H \"Content-Type: application/json\" \\\n -d '{\n \"task_type\": \"log_message\",\n \"payload\": {\n \"message\": \"Hello from my queue!\",\n \"level\": \"info\"\n }\n }'\n```\n\n### 3. Monitor Queue Status\n\nVisit: https://lightweightqueue-monitor.val.run/\n\n## 📊 Key Endpoints\n\n| Endpoint | Purpose | URL |\n| ----------- | ---------------------------- | ------------------------------------------------------------- |\n| **Enqueue** | Add tasks to queue | https://lightweightqueue-enqueue.val.run/ |\n| **Monitor** | View queue stats | https://lightweightqueue-monitor.val.run/ |\n| **Schema** | Initialize DB (already done) | https://nbbaier--ba92dd0cc8cc11f0979842dde27851f2.web.val.run |\n\n## 🎮 Built-in Task Types\n\n1. **log_message** - Log a message\n2. **send_email** - Send an email via Val Town\n3. **webhook** - Call an external webhook\n4. **http_request** - Make HTTP requests\n\n## 💡 Examples\n\n### High Priority Task\n\n```json\n{\n \"task_type\": \"log_message\",\n \"payload\": { \"message\": \"Important task!\" },\n \"priority\": 10\n}\n```\n\n### Scheduled Task (1 hour from now)\n\n```json\n{\n \"task_type\": \"log_message\",\n \"payload\": { \"message\": \"Future task!\" },\n \"scheduled_for\": 1732406400\n}\n```\n\n### Send Email Task\n\n```json\n{\n \"task_type\": \"send_email\",\n \"payload\": {\n \"to\": \"user@example.com\",\n \"subject\": \"Test\",\n \"text\": \"Hello from the queue!\"\n }\n}\n```\n\n## 🔧 Customization\n\n### Add Your Own Task Types\n\nEdit `processors.ts` and add a new processor:\n\n```typescript\ncase \"my_custom_task\":\n await processMyCustomTask(payload);\n break;\n```\n\n## 📁 File Structure\n\n- `schema.ts` - Database initialization\n- `enqueue.ts` - API to add tasks\n- `worker.ts` - Processes tasks every minute\n- `processors.ts` - Task processing logic\n- `monitor.ts` - Queue statistics API\n- `test.ts` - Example test cases\n- `README.md` - Full documentation\n\n## 🔍 Next Steps\n\n1. Run the test file to see it in action\n2. Check the monitor endpoint to see queue stats\n3. Add your own custom task processors\n4. Adjust worker interval if needed (currently 1 minute)\n\n## 📖 Full Documentation\n\nSee `README.md` for complete documentation including:\n\n- All task type examples\n- API reference\n- Architecture details\n- Error handling\n- Best practices\n\n---\n\n**Note:** The worker processes up to 10 tasks per minute. Failed tasks are\nautomatically retried up to 3 times before moving to the dead letter queue.\n",[],[183],{"_103":192,"_95":193,"_153":194,"_155":-5,"_156":138,"_157":195,"_159":22,"_105":196,"_99":197,"_162":163,"_164":198,"_166":22,"_167":-5,"_168":199,"_98":200},"f4615082-c8d0-11f0-8873-42dde27851f2","README.md","41df3cf6-c8cd-11f0-83d5-42dde27851f2",21,["D",1763946022715],4,"# Lightweight Queue System\n\nA SQLite-based queue system for Val Town with support for priorities, delayed\nexecution, retries, and dead letter queue.\n\n## Setup\n\n1. **Initialize the database schema** (run once):\n\n```bash\n# Visit the schema.ts val and run it\nhttps://www.val.town/v/nbbaier/lightweightQueue/schema.ts\n```\n\n2. **The worker will automatically run every minute** to process queued tasks\n\n## Usage\n\n### Enqueue a Task\n\nPOST to the `enqueue.ts` endpoint:\n\n```bash\ncurl -X POST https://lightweightqueue-enqueue.val.run/ \\\n -H \"Content-Type: application/json\" \\\n -d '{\n \"task_type\": \"log_message\",\n \"payload\": {\n \"message\": \"Hello from the queue!\",\n \"level\": \"info\"\n }\n }'\n```\n\n### Task Options\n\n- `task_type` (required): Type of task to run\n- `payload` (required): Data for the task\n- `priority` (optional, default: 0): Higher numbers = higher priority\n- `max_attempts` (optional, default: 3): Max retry attempts\n- `scheduled_for` (optional): Unix timestamp for delayed execution\n\n### Available Task Types\n\nBuilt-in task types in `processors.ts`:\n\n1. **send_email**\n\n```json\n{\n \"task_type\": \"send_email\",\n \"payload\": {\n \"to\": \"user@example.com\",\n \"subject\": \"Test Email\",\n \"text\": \"This is a test\"\n }\n}\n```\n\n2. **webhook**\n\n```json\n{\n \"task_type\": \"webhook\",\n \"payload\": {\n \"url\": \"https://example.com/webhook\",\n \"method\": \"POST\",\n \"body\": { \"data\": \"value\" },\n \"headers\": { \"Authorization\": \"Bearer token\" }\n }\n}\n```\n\n3. **log_message**\n\n```json\n{\n \"task_type\": \"log_message\",\n \"payload\": {\n \"message\": \"Something happened\",\n \"level\": \"info\"\n }\n}\n```\n\n4. **http_request**\n\n```json\n{\n \"task_type\": \"http_request\",\n \"payload\": {\n \"url\": \"https://api.example.com/data\",\n \"method\": \"GET\"\n }\n}\n```\n\n### Priority Example\n\n```bash\ncurl -X POST https://lightweightqueue-enqueue.val.run/ \\\n -H \"Content-Type: application/json\" \\\n -d '{\n \"task_type\": \"log_message\",\n \"payload\": { \"message\": \"High priority task!\" },\n \"priority\": 10\n }'\n```\n\n### Delayed Execution Example\n\n```bash\n# Schedule task for 1 hour from now\nSCHEDULED_TIME=$(($(date +%s) + 3600))\n\ncurl -X POST https://lightweightqueue-enqueue.val.run/\n\n\n\n\n\\\n -H \"Content-Type: application/json\" \\\n -d \"{\n \\\"task_type\\\": \\\"log_message\\\",\n \\\"payload\\\": { \\\"message\\\": \\\"This is delayed!\\\" },\n \\\"scheduled_for\\\": $SCHEDULED_TIME\n }\"\n```\n\n### Monitor the Queue\n\nVisit the monitoring endpoint:\n\n```\nhttps://lightweightqueue-monitor.val.run/\n```\n\nThis shows:\n\n- Task counts by status\n- Average processing duration\n- Task type breakdown\n- Dead letter queue count\n- Recent failures\n- Upcoming scheduled tasks\n\n## Adding Custom Task Types\n\nEdit `processors.ts` and add a new case to the `processTask` function:\n\n```typescript\ncase \"my_custom_task\":\n await processMyCustomTask(payload);\n break;\n```\n\nThen implement your processor function:\n\n```typescript\nasync function processMyCustomTask(payload: any) {\n // Your custom logic here\n console.log(\"Processing custom task:\", payload);\n}\n```\n\n## Architecture\n\n- **schema.ts**: Database initialization\n- **enqueue.ts**: HTTP endpoint to add tasks\n- **worker.ts**: Interval val that processes tasks every minute\n- **processors.ts**: Task processing logic\n- **monitor.ts**: HTTP endpoint for queue statistics\n\n## Features\n\n- ✅ Priority-based processing\n- ✅ Delayed/scheduled execution\n- ✅ Automatic retries with configurable max attempts\n- ✅ Dead letter queue for failed tasks\n- ✅ Task status tracking (pending, processing, completed, failed)\n- ✅ Built-in monitoring endpoint\n- ✅ Processing duration tracking\n- ✅ Extensible task processors\n\n## Notes\n\n- Worker processes up to 10 tasks per minute\n- Failed tasks are retried up to `max_attempts` times\n- Tasks exceeding max attempts move to dead letter queue\n- SQLite provides ACID guarantees for queue operations",[],[193],{"_103":202,"_95":203,"_153":204,"_155":-5,"_156":138,"_157":205,"_159":160,"_105":206,"_99":32,"_162":163,"_164":207,"_166":22,"_167":-5,"_168":208,"_98":209},"f6ddc4b6-c8d1-11f0-91f3-42dde27851f2","biome.json","f6ddc588-c8d1-11f0-91f3-42dde27851f2",26,["D",1763946456231],"{\n\t\"$schema\": \"https://biomejs.dev/schemas/2.3.7/schema.json\",\n\t\"vcs\": {\n\t\t\"enabled\": false,\n\t\t\"clientKind\": \"git\",\n\t\t\"useIgnoreFile\": false\n\t},\n\t\"files\": {\n\t\t\"ignoreUnknown\": false\n\t},\n\t\"formatter\": {\n\t\t\"enabled\": true,\n\t\t\"indentStyle\": \"tab\"\n\t},\n\t\"linter\": {\n\t\t\"enabled\": true,\n\t\t\"rules\": {\n\t\t\t\"recommended\": true\n\t\t}\n\t},\n\t\"javascript\": {\n\t\t\"formatter\": {\n\t\t\t\"quoteStyle\": \"double\"\n\t\t}\n\t},\n\t\"assist\": {\n\t\t\"enabled\": true,\n\t\t\"actions\": {\n\t\t\t\"source\": {\n\t\t\t\t\"organizeImports\": \"on\"\n\t\t\t}\n\t\t}\n\t}\n}\n",[],[203],{"_103":211,"_95":212,"_153":213,"_155":-5,"_156":138,"_157":214,"_159":22,"_105":215,"_99":177,"_162":163,"_164":216,"_166":22,"_167":-5,"_168":217,"_98":218},"1503e6aa-c8d2-11f0-b747-42dde27851f2","deno.json","f6c357b6-c8d1-11f0-99b0-42dde27851f2",33,["D",1763946506648],"{\n\t\"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n\t\"compilerOptions\": {\n\t\t\"lib\": [\n\t\t\t\"dom\",\n\t\t\t\"dom.iterable\",\n\t\t\t\"dom.asynciterable\",\n\t\t\t\"deno.ns\",\n\t\t\t\"deno.unstable\"\n\t\t],\n\t\t\"noImplicitAny\": false,\n\t\t\"strict\": false,\n\t\t\"types\": [\"https://www.val.town/types/valtown.d.ts\"]\n\t},\n\t\"experimental\": {\n\t\t\"unstable-node-globals\": true,\n\t\t\"unstable-sloppy-imports\": true,\n\t\t\"unstable-temporal\": true,\n\t\t\"unstable-worker-options\": true\n\t},\n\t\"imports\": {\n\t\t\"@biomejs/biome\": \"npm:@biomejs/biome@^2.3.7\"\n\t},\n\t\"lint\": {\n\t\t\"files\": {\n\t\t\t\"include\": [\"deno:/https/esm.town/**/*\"]\n\t\t},\n\t\t\"rules\": {\n\t\t\t\"exclude\": [\"no-explicit-any\", \"no-import-prefix\"]\n\t\t}\n\t},\n\t\"lock\": false,\n\t\"nodeModulesDir\": \"auto\"\n}\n",[],[212],{"_103":220,"_95":221,"_153":222,"_155":-5,"_156":138,"_157":223,"_159":22,"_105":224,"_99":225,"_162":226,"_164":227,"_166":22,"_167":-5,"_168":228,"_98":229},"14e9c4be-c8d2-11f0-9f0b-42dde27851f2","enqueue.ts","c5bd3e20-c8cc-11f0-a88c-42dde27851f2",32,["D",1763946506795],3,"http","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n/**\n * HTTP endpoint to enqueue tasks\n *\n * POST /enqueue\n * Body: {\n * task_type: string,\n * payload: any,\n * priority?: number (default: 0, higher = more important),\n * max_attempts?: number (default: 3),\n * scheduled_for?: number (unix timestamp, optional - for delayed execution)\n * }\n */\nexport default async function (req: Request): Promise {\n\tif (req.method !== \"POST\") {\n\t\treturn Response.json(\n\t\t\t{ error: \"Method not allowed. Use POST.\" },\n\t\t\t{ status: 405 },\n\t\t);\n\t}\n\n\ttry {\n\t\tconst body = await req.json();\n\t\tconst {\n\t\t\ttask_type,\n\t\t\tpayload,\n\t\t\tpriority = 0,\n\t\t\tmax_attempts = 3,\n\t\t\tscheduled_for = null,\n\t\t} = body;\n\n\t\t// Validate required fields\n\t\tif (!task_type) {\n\t\t\treturn Response.json({ error: \"task_type is required\" }, { status: 400 });\n\t\t}\n\n\t\t// Validate task type\n\t\tconst VALID_TASK_TYPES = [\n\t\t\t\"send_email\",\n\t\t\t\"webhook\",\n\t\t\t\"log_message\",\n\t\t\t\"http_request\",\n\t\t];\n\t\tif (!VALID_TASK_TYPES.includes(task_type)) {\n\t\t\treturn Response.json(\n\t\t\t\t{\n\t\t\t\t\terror: `Invalid task_type. Must be one of: ${VALID_TASK_TYPES.join(\", \")}`,\n\t\t\t\t\tvalid_types: VALID_TASK_TYPES,\n\t\t\t\t},\n\t\t\t\t{ status: 400 },\n\t\t\t);\n\t\t}\n\n\t\tif (payload === undefined) {\n\t\t\treturn Response.json({ error: \"payload is required\" }, { status: 400 });\n\t\t}\n\n\t\t// Insert task into queue\n\t\tconst result = await sqlite.execute({\n\t\t\tsql: `INSERT INTO queue (task_type, payload, priority, max_attempts, scheduled_for)\n VALUES (?, ?, ?, ?, ?)`,\n\t\t\targs: [\n\t\t\t\ttask_type,\n\t\t\t\tJSON.stringify(payload),\n\t\t\t\tpriority,\n\t\t\t\tmax_attempts,\n\t\t\t\tscheduled_for,\n\t\t\t],\n\t\t});\n\n\t\treturn Response.json({\n\t\t\tsuccess: true,\n\t\t\ttask_id: result.lastInsertRowid?.toString(),\n\t\t\tstatus: scheduled_for ? \"scheduled\" : \"queued\",\n\t\t\tscheduled_for: scheduled_for\n\t\t\t\t? new Date(scheduled_for * 1000).toISOString()\n\t\t\t\t: null,\n\t\t});\n\t} catch (error) {\n\t\tconsole.error(\"Error enqueueing task:\", error);\n\t\treturn Response.json({ error: error.message }, { status: 500 });\n\t}\n}\n",[],[221],{"_103":231,"_95":232,"_153":233,"_155":-5,"_156":138,"_157":234,"_159":22,"_105":235,"_99":187,"_162":226,"_164":236,"_166":22,"_167":-5,"_168":237,"_98":238},"14d19a4c-c8d2-11f0-906c-42dde27851f2","monitor.ts","20366bc4-c8cd-11f0-ba6f-42dde27851f2",29,["D",1763946506636],"import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n/**\n * Monitoring endpoint for queue statistics\n * GET /monitor\n */\nexport default async function (_req: Request): Promise {\n\ttry {\n\t\t// Get overall stats\n\t\tconst statsResult = await sqlite.execute(`\n SELECT \n status,\n COUNT(*) as count,\n AVG(CASE \n WHEN completed_at IS NOT NULL AND started_at IS NOT NULL \n THEN completed_at - started_at \n ELSE NULL \n END) as avg_duration_seconds\n FROM queue\n GROUP BY status\n `);\n\n\t\tconst stats: Record = {};\n\t\tfor (const row of statsResult.rows) {\n\t\t\tstats[String(row[0])] = {\n\t\t\t\tcount: Number(row[1]),\n\t\t\t\tavg_duration_seconds: row[2]\n\t\t\t\t\t? Math.round(Number(row[2]) * 100) / 100\n\t\t\t\t\t: null,\n\t\t\t};\n\t\t}\n\n\t\t// Get task type breakdown\n\t\tconst taskTypesResult = await sqlite.execute(`\n SELECT task_type, COUNT(*) as count\n FROM queue\n GROUP BY task_type\n ORDER BY count DESC\n `);\n\n\t\tconst taskTypes = taskTypesResult.rows.map((row) => ({\n\t\t\ttype: String(row[0]),\n\t\t\tcount: Number(row[1]),\n\t\t}));\n\n\t\t// Get dead letter queue count\n\t\tconst dlqResult = await sqlite.execute(\n\t\t\t`SELECT COUNT(*) as count FROM dead_letter_queue`,\n\t\t);\n\t\tconst dlqCount = Number(dlqResult.rows[0][0]);\n\n\t\t// Get recent failed tasks\n\t\tconst recentFailedResult = await sqlite.execute(`\n SELECT id, task_type, error, attempts, created_at\n FROM dead_letter_queue\n ORDER BY moved_to_dlq_at DESC\n LIMIT 5\n `);\n\n\t\tconst recentFailed = recentFailedResult.rows.map((row) => ({\n\t\t\tid: Number(row[0]),\n\t\t\ttask_type: String(row[1]),\n\t\t\terror: String(row[2] || \"\"),\n\t\t\tattempts: Number(row[3]),\n\t\t\tcreated_at: row[4] ? new Date(Number(row[4]) * 1000).toISOString() : null,\n\t\t}));\n\n\t\t// Get upcoming scheduled tasks\n\t\tconst scheduledResult = await sqlite.execute(`\n SELECT id, task_type, scheduled_for, priority\n FROM queue\n WHERE scheduled_for IS NOT NULL AND status = 'pending'\n ORDER BY scheduled_for ASC\n LIMIT 10\n `);\n\n\t\tconst scheduled = scheduledResult.rows.map((row) => ({\n\t\t\tid: Number(row[0]),\n\t\t\ttask_type: String(row[1]),\n\t\t\tscheduled_for: row[2]\n\t\t\t\t? new Date(Number(row[2]) * 1000).toISOString()\n\t\t\t\t: null,\n\t\t\tpriority: Number(row[3]),\n\t\t}));\n\n\t\treturn Response.json(\n\t\t\t{\n\t\t\t\ttimestamp: new Date().toISOString(),\n\t\t\t\tstats,\n\t\t\t\ttask_types: taskTypes,\n\t\t\t\tdead_letter_queue: {\n\t\t\t\t\tcount: dlqCount,\n\t\t\t\t\trecent: recentFailed,\n\t\t\t\t},\n\t\t\t\tscheduled_tasks: scheduled,\n\t\t\t},\n\t\t\t{\n\t\t\t\theaders: {\n\t\t\t\t\t\"Content-Type\": \"application/json\",\n\t\t\t\t},\n\t\t\t},\n\t\t);\n\t} catch (error) {\n\t\tconsole.error(\"Error fetching monitor data:\", error);\n\t\treturn Response.json({ error: error.message }, { status: 500 });\n\t}\n}\n",[],[232],{"_103":240,"_95":241,"_153":242,"_155":-5,"_156":138,"_157":100,"_159":22,"_105":243,"_99":32,"_162":244,"_164":72,"_166":22,"_167":-5,"_168":245,"_98":246},"2bdff75c-c8d6-11f0-a694-42dde27851f2","new-file-6927.ts","2bdff806-c8d6-11f0-a694-42dde27851f2",["D",1763948263308],"script",[],[241],{"_103":248,"_95":249,"_153":250,"_155":-5,"_156":138,"_157":251,"_159":22,"_105":252,"_99":177,"_162":244,"_164":253,"_166":22,"_167":-5,"_168":254,"_98":255},"14de1506-c8d2-11f0-a369-42dde27851f2","processors.ts","f6681cde-c8cc-11f0-979e-42dde27851f2",31,["D",1763946506644],"import { email } from \"https://esm.town/v/std/email\";\n\n/**\n * Task processors for different task types\n * Add your own task processors here\n */\n\nexport interface Task {\n\tid: number;\n\ttask_type: string;\n\tpayload: any;\n\tstatus: string;\n\tattempts: number;\n\tmax_attempts: number;\n}\n\nexport async function processTask(task: Task): Promise {\n\tconst { task_type, payload } = task;\n\n\tconsole.log(`Processing task ${task.id} of type: ${task_type}`);\n\n\tswitch (task_type) {\n\t\tcase \"send_email\":\n\t\t\tawait processSendEmail(payload);\n\t\t\tbreak;\n\n\t\tcase \"webhook\":\n\t\t\tawait processWebhook(payload);\n\t\t\tbreak;\n\n\t\tcase \"log_message\":\n\t\t\tawait processLogMessage(payload);\n\t\t\tbreak;\n\n\t\tcase \"http_request\":\n\t\t\tawait processHttpRequest(payload);\n\t\t\tbreak;\n\n\t\tdefault:\n\t\t\tthrow new Error(`Unknown task type: ${task_type}`);\n\t}\n}\n\nasync function processSendEmail(payload: any) {\n\tconst { to, subject, text } = payload;\n\n\tif (!to || !subject || !text) {\n\t\tthrow new Error(\"Email requires: to, subject, text\");\n\t}\n\n\tawait email.send({\n\t\tto,\n\t\tsubject,\n\t\ttext,\n\t});\n\n\tconsole.log(`Email sent to ${to}`);\n}\n\nasync function processWebhook(payload: any) {\n\tconst { url, method = \"POST\", body, headers = {} } = payload;\n\n\tif (!url) {\n\t\tthrow new Error(\"Webhook requires url\");\n\t}\n\n\tconst response = await fetch(url, {\n\t\tmethod,\n\t\theaders: {\n\t\t\t\"Content-Type\": \"application/json\",\n\t\t\t...headers,\n\t\t},\n\t\tbody: body ? JSON.stringify(body) : undefined,\n\t});\n\n\tif (!response.ok) {\n\t\tthrow new Error(\n\t\t\t`Webhook failed: ${response.status} ${response.statusText}`,\n\t\t);\n\t}\n\n\tconsole.log(`Webhook sent to ${url}`);\n}\n\nasync function processLogMessage(payload: any) {\n\tconst { message, level = \"info\" } = payload;\n\tconsole.log(`[${level.toUpperCase()}] ${message}`);\n}\n\nasync function processHttpRequest(payload: any) {\n\tconst { url, method = \"GET\", body, headers = {} } = payload;\n\n\tif (!url) {\n\t\tthrow new Error(\"HTTP request requires url\");\n\t}\n\n\tconst response = await fetch(url, {\n\t\tmethod,\n\t\theaders,\n\t\tbody: body ? JSON.stringify(body) : undefined,\n\t});\n\n\tif (!response.ok) {\n\t\tthrow new Error(\n\t\t\t`HTTP request failed: ${response.status} ${response.statusText}`,\n\t\t);\n\t}\n\n\tconsole.log(`HTTP ${method} request to ${url} completed`);\n}\n",[],[249],{"_103":257,"_95":258,"_153":259,"_155":-5,"_156":138,"_157":260,"_159":22,"_105":261,"_99":197,"_162":226,"_164":262,"_166":22,"_167":-5,"_168":263,"_98":264},"14d48a68-c8d2-11f0-9f0b-42dde27851f2","schema.ts","ba92dd0c-c8cc-11f0-9798-42dde27851f2",30,["D",1763946506645],"import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n/**\n * Initialize the queue database schema\n * Visit this endpoint to set up your queue tables\n */\nexport default async function (_req: Request): Promise {\n\ttry {\n\t\t// Create the main queue table\n\t\tawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS queue (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n task_type TEXT NOT NULL,\n payload TEXT NOT NULL,\n status TEXT DEFAULT 'pending',\n created_at INTEGER DEFAULT (unixepoch()),\n started_at INTEGER,\n completed_at INTEGER,\n scheduled_for INTEGER,\n attempts INTEGER DEFAULT 0,\n max_attempts INTEGER DEFAULT 3,\n priority INTEGER DEFAULT 0,\n error TEXT\n )\n `);\n\n\t\t// Create indexes for efficient queries\n\t\tawait sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_status_priority \n ON queue(status, priority DESC, created_at)\n `);\n\n\t\tawait sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_scheduled \n ON queue(scheduled_for) \n WHERE scheduled_for IS NOT NULL\n `);\n\n\t\t// Create dead letter queue table\n\t\tawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS dead_letter_queue (\n id INTEGER PRIMARY KEY,\n task_type TEXT NOT NULL,\n payload TEXT NOT NULL,\n status TEXT,\n created_at INTEGER,\n started_at INTEGER,\n completed_at INTEGER,\n attempts INTEGER,\n max_attempts INTEGER,\n priority INTEGER,\n error TEXT,\n moved_to_dlq_at INTEGER DEFAULT (unixepoch())\n )\n `);\n\n\t\tconsole.log(\"Queue schema initialized successfully!\");\n\n\t\treturn Response.json({\n\t\t\tsuccess: true,\n\t\t\tmessage: \"Queue schema initialized successfully!\",\n\t\t\ttables: [\"queue\", \"dead_letter_queue\"],\n\t\t});\n\t} catch (error) {\n\t\tconsole.error(\"Schema initialization error:\", error);\n\t\treturn Response.json(\n\t\t\t{ success: false, error: error.message },\n\t\t\t{ status: 500 },\n\t\t);\n\t}\n}\n",[],[258],{"_103":266,"_95":267,"_153":268,"_155":-5,"_156":138,"_157":269,"_159":160,"_105":270,"_99":187,"_162":244,"_164":271,"_166":22,"_167":-5,"_168":272,"_98":273},"f6d50934-c8d1-11f0-aefb-42dde27851f2","test.ts","3871c642-c8ce-11f0-a873-42dde27851f2",25,["D",1763946456294],"/**\n * Test the queue system by enqueueing a few tasks\n */\nexport default async function () {\n\tconst enqueueUrl =\n\t\t\"https://nbbaier--c5bd3e20c8cc11f0a88c42dde27851f2.web.val.run\";\n\n\t// Test 1: Simple log message\n\tconst test1 = await fetch(enqueueUrl, {\n\t\tmethod: \"POST\",\n\t\theaders: { \"Content-Type\": \"application/json\" },\n\t\tbody: JSON.stringify({\n\t\t\ttask_type: \"log_message\",\n\t\t\tpayload: {\n\t\t\t\tmessage: \"Testing the queue system!\",\n\t\t\t\tlevel: \"info\",\n\t\t\t},\n\t\t}),\n\t});\n\n\tconst result1 = await test1.json();\n\tconsole.log(\"Test 1 (log_message):\", result1);\n\n\t// Test 2: High priority task\n\tconst test2 = await fetch(enqueueUrl, {\n\t\tmethod: \"POST\",\n\t\theaders: { \"Content-Type\": \"application/json\" },\n\t\tbody: JSON.stringify({\n\t\t\ttask_type: \"log_message\",\n\t\t\tpayload: {\n\t\t\t\tmessage: \"High priority task!\",\n\t\t\t\tlevel: \"warn\",\n\t\t\t},\n\t\t\tpriority: 10,\n\t\t}),\n\t});\n\n\tconst result2 = await test2.json();\n\tconsole.log(\"Test 2 (high priority):\", result2);\n\n\t// Test 3: Scheduled task (30 seconds from now)\n\tconst scheduledTime = Math.floor(Date.now() / 1000) + 30;\n\tconst test3 = await fetch(enqueueUrl, {\n\t\tmethod: \"POST\",\n\t\theaders: { \"Content-Type\": \"application/json\" },\n\t\tbody: JSON.stringify({\n\t\t\ttask_type: \"log_message\",\n\t\t\tpayload: {\n\t\t\t\tmessage: \"This was scheduled for 30 seconds in the future!\",\n\t\t\t\tlevel: \"info\",\n\t\t\t},\n\t\t\tscheduled_for: scheduledTime,\n\t\t}),\n\t});\n\n\tconst result3 = await test3.json();\n\tconsole.log(\"Test 3 (scheduled):\", result3);\n\n\treturn {\n\t\ttest1: result1,\n\t\ttest2: result2,\n\t\ttest3: result3,\n\t\tmessage:\n\t\t\t\"All tests completed! Check the monitor endpoint to see queue status.\",\n\t};\n}\n",[],[267],{"_103":275,"_95":276,"_153":277,"_155":-5,"_156":138,"_157":278,"_159":160,"_105":279,"_99":187,"_162":280,"_164":281,"_166":22,"_167":-5,"_168":282,"_98":283},"1535c40e-c8d2-11f0-86fc-42dde27851f2","worker.ts","03b2afe4-c8cd-11f0-98d4-42dde27851f2",34,["D",1763946506656],"interval","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { processTask } from \"./processors.ts\";\n\n/**\n * Queue worker - runs every minute to process pending tasks\n * This is an interval val that automatically runs on a schedule\n */\nexport default async function () {\n\tconsole.log(\"Queue worker starting...\");\n\n\ttry {\n\t\t// Fetch pending tasks that are ready to process\n\t\tconst result = await sqlite.execute(`\n SELECT id, task_type, payload, status, attempts, max_attempts\n FROM queue \n WHERE status = 'pending' \n AND attempts < max_attempts\n AND (scheduled_for IS NULL OR scheduled_for <= unixepoch())\n ORDER BY priority DESC, created_at ASC \n LIMIT 10\n `);\n\n\t\tconst tasks = result.rows;\n\n\t\tif (tasks.length === 0) {\n\t\t\tconsole.log(\"No tasks to process\");\n\t\t\treturn { processed: 0, success: 0, failed: 0 };\n\t\t}\n\n\t\tconsole.log(`Found ${tasks.length} tasks to process`);\n\n\t\tlet successCount = 0;\n\t\tlet failCount = 0;\n\n\t\tfor (const row of tasks) {\n\t\t\tconst task = {\n\t\t\t\tid: Number(row[0]),\n\t\t\t\ttask_type: String(row[1]),\n\t\t\t\tpayload: JSON.parse(String(row[2])),\n\t\t\t\tstatus: String(row[3]),\n\t\t\t\tattempts: Number(row[4]),\n\t\t\t\tmax_attempts: Number(row[5]),\n\t\t\t};\n\n\t\t\t// Mark as processing\n\t\t\tawait sqlite.execute({\n\t\t\t\tsql: `UPDATE queue \n SET status = 'processing', \n started_at = unixepoch(), \n attempts = attempts + 1 \n WHERE id = ?`,\n\t\t\t\targs: [task.id],\n\t\t\t});\n\n\t\t\ttry {\n\t\t\t\t// Process the task\n\t\t\t\tawait processTask(task);\n\n\t\t\t\t// Mark as completed\n\t\t\t\tawait sqlite.execute({\n\t\t\t\t\tsql: `UPDATE queue \n SET status = 'completed', \n completed_at = unixepoch() \n WHERE id = ?`,\n\t\t\t\t\targs: [task.id],\n\t\t\t\t});\n\n\t\t\t\tconsole.log(`Task ${task.id} completed successfully`);\n\t\t\t\tsuccessCount++;\n\t\t\t} catch (error) {\n\t\t\t\tconsole.error(`Task ${task.id} failed:`, error.message);\n\n\t\t\t\t// Check if max attempts reached\n\t\t\t\tconst newAttempts = task.attempts + 1;\n\t\t\t\tconst maxReached = newAttempts >= task.max_attempts;\n\n\t\t\t\tif (maxReached) {\n\t\t\t\t\t// Move to dead letter queue\n\t\t\t\t\tawait sqlite.batch([\n\t\t\t\t\t\t{\n\t\t\t\t\t\t\tsql: `INSERT INTO dead_letter_queue \n SELECT id, task_type, payload, status, created_at, started_at, \n completed_at, attempts, max_attempts, priority, ?, unixepoch()\n FROM queue WHERE id = ?`,\n\t\t\t\t\t\t\targs: [error.message, task.id],\n\t\t\t\t\t\t},\n\t\t\t\t\t\t{\n\t\t\t\t\t\t\tsql: `DELETE FROM queue WHERE id = ?`,\n\t\t\t\t\t\t\targs: [task.id],\n\t\t\t\t\t\t},\n\t\t\t\t\t]);\n\n\t\t\t\t\tconsole.log(`Task ${task.id} moved to dead letter queue`);\n\t\t\t\t} else {\n\t\t\t\t\t// Mark as failed (will retry on next run)\n\t\t\t\t\tawait sqlite.execute({\n\t\t\t\t\t\tsql: `UPDATE queue \n SET status = 'pending', \n error = ? \n WHERE id = ?`,\n\t\t\t\t\t\targs: [error.message, task.id],\n\t\t\t\t\t});\n\t\t\t\t}\n\n\t\t\t\tfailCount++;\n\t\t\t}\n\t\t}\n\n\t\tconst summary = {\n\t\t\tprocessed: tasks.length,\n\t\t\tsuccess: successCount,\n\t\t\tfailed: failCount,\n\t\t};\n\n\t\tconsole.log(\"Worker completed:\", summary);\n\t\treturn summary;\n\t} catch (error) {\n\t\tconsole.error(\"Worker error:\", error);\n\t\tthrow error;\n\t}\n}\n",[],[276],"files",[150,171,181,191,201,210,219,230,239,247,256,265,274],"counts",{"_288":32,"_289":177,"_290":32,"_291":292},"pulls","branches","forks","envVars",{"_293":32,"_294":32},"count","emptyCount","contents",[297,300,303,306,309,312,315,318,321,324,327,330,333],{"_103":151,"_95":152,"_153":154,"_155":-5,"_156":138,"_157":158,"_159":160,"_105":298,"_99":32,"_162":163,"_164":165,"_166":22,"_167":-5,"_98":299},["D",1763946456246],[152],{"_103":172,"_95":173,"_153":174,"_155":-5,"_156":138,"_157":175,"_159":160,"_105":301,"_99":177,"_162":163,"_164":178,"_166":22,"_167":-5,"_98":302},["D",1763946497459],[173],{"_103":182,"_95":183,"_153":184,"_155":-5,"_156":138,"_157":185,"_159":22,"_105":304,"_99":187,"_162":163,"_164":188,"_166":22,"_167":-5,"_98":305},["D",1763946497450],[183],{"_103":192,"_95":193,"_153":194,"_155":-5,"_156":138,"_157":195,"_159":22,"_105":307,"_99":197,"_162":163,"_164":198,"_166":22,"_167":-5,"_98":308},["D",1763946022715],[193],{"_103":202,"_95":203,"_153":204,"_155":-5,"_156":138,"_157":205,"_159":160,"_105":310,"_99":32,"_162":163,"_164":207,"_166":22,"_167":-5,"_98":311},["D",1763946456231],[203],{"_103":211,"_95":212,"_153":213,"_155":-5,"_156":138,"_157":214,"_159":22,"_105":313,"_99":177,"_162":163,"_164":216,"_166":22,"_167":-5,"_98":314},["D",1763946506648],[212],{"_103":220,"_95":221,"_153":222,"_155":-5,"_156":138,"_157":223,"_159":22,"_105":316,"_99":225,"_162":226,"_164":227,"_166":22,"_167":-5,"_98":317},["D",1763946506795],[221],{"_103":231,"_95":232,"_153":233,"_155":-5,"_156":138,"_157":234,"_159":22,"_105":319,"_99":187,"_162":226,"_164":236,"_166":22,"_167":-5,"_98":320},["D",1763946506636],[232],{"_103":240,"_95":241,"_153":242,"_155":-5,"_156":138,"_157":100,"_159":22,"_105":322,"_99":32,"_162":244,"_164":72,"_166":22,"_167":-5,"_98":323},["D",1763948263308],[241],{"_103":248,"_95":249,"_153":250,"_155":-5,"_156":138,"_157":251,"_159":22,"_105":325,"_99":177,"_162":244,"_164":253,"_166":22,"_167":-5,"_98":326},["D",1763946506644],[249],{"_103":257,"_95":258,"_153":259,"_155":-5,"_156":138,"_157":260,"_159":22,"_105":328,"_99":197,"_162":226,"_164":262,"_166":22,"_167":-5,"_98":329},["D",1763946506645],[258],{"_103":266,"_95":267,"_153":268,"_155":-5,"_156":138,"_157":269,"_159":160,"_105":331,"_99":187,"_162":244,"_164":271,"_166":22,"_167":-5,"_98":332},["D",1763946456294],[267],{"_103":275,"_95":276,"_153":277,"_155":-5,"_156":138,"_157":278,"_159":160,"_105":334,"_99":187,"_162":280,"_164":281,"_166":22,"_167":-5,"_98":335},["D",1763946506656],[276],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_101":344,"_99":100,"_349":350},{"_103":104,"_95":96,"_105":345,"_107":-5,"_108":22,"_109":110,"_111":112,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":32,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":346,"_132":347,"_135":348,"_147":22},["D",1763944165015],{"_93":94,"_130":131},{"_93":94,"_134":131,"_14":114},{"_99":137,"_95":43,"_103":138,"_139":104,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},"changes",[351],{"_163":352,"_354":-7,"_166":160,"_98":241,"_355":241},{"_153":242,"_95":241,"_162":244,"_164":72,"_105":353,"_157":100,"_156":138},["D",1763948263308],"previous","latestPath","actionData","errors"]