[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_329":330,"_331":332},"routes/_app.x.$handle.$name",{"_97":96,"_32":46,"_106":87,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":59,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",502,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","scripts/setup.ts","latestPath","fileId","70ab4384-8f4a-11f0-8c11-0224a6c84d84","name","setup.ts","fileType","script","content","import { getRequiredEnv, requireCommandAccessToken } from \"../util/env.ts\";\n\nconst { APPLICATION_ID } = getRequiredEnv();\nconst COMMAND_ACCESS_TOKEN = requireCommandAccessToken();\n\n// Define the URL for registering Discord commands\nconst url = `https://discord.com/api/v10/applications/${APPLICATION_ID}/commands`;\n\n// Context type values for Discord slash commands\n// 0: GUILD - Can be used in servers\n// 1: BOT_DM - Can be used in DMs with the bot\n// 2: PRIVATE_CHANNEL - Can be used in group DMs and other private channels\n\n// Define the slash command data\nconst commandData = {\n name: \"timestamp\",\n description: \"Converts a human-readable string into a Discord timestamp\",\n contexts: [0, 1, 2], // 0: GUILD, 1: BOT_DM, 2: PRIVATE_CHANNEL\n options: [\n {\n name: \"at\",\n description:\n \"A human-readable date/time including timezone (e.g., tomorrow at 3pm EST, 2023-05-01 14:30 UTC)\",\n type: 3, // STRING\n required: true,\n },\n {\n name: \"format\",\n description: \"Timestamp display format\",\n type: 3, // STRING\n required: true,\n autocomplete: true,\n },\n ],\n};\n\n/**\n * Register a slash command with Discord's API\n */\nasync function registerCommand(commandData) {\n try {\n // Authorization headers using the imported token\n const headers = {\n Authorization: `Bearer ${COMMAND_ACCESS_TOKEN}`,\n \"Content-Type\": \"application/json\",\n };\n\n // Make the HTTP request to Discord's API\n const response = await fetch(url, {\n method: \"POST\",\n headers: headers,\n body: JSON.stringify(commandData),\n });\n\n if (!response.ok) {\n const errorData = await response.json();\n console.error(\"Failed to register command:\", errorData);\n throw new Error(`Discord API error: ${response.status}`);\n }\n\n const data = await response.json();\n console.log(\"Command registered successfully:\", data);\n return data;\n } catch (error) {\n console.error(\"Error registering command:\", error);\n throw error;\n }\n}\n\n// Main function to run the setup\nasync function main() {\n console.log(\"Registering Discord slash command for timestamp...\");\n try {\n await registerCommand(commandData);\n console.log(\"Command registration completed successfully!\");\n } catch (error) {\n console.error(\"Command registration failed:\", error.message);\n console.log(\n \"If the error is related to authentication, try running: deno run --allow-net --allow-env token_gen.ts\"\n );\n Deno.exit(1);\n }\n}\n\n// import.meta.main is not support on vt yet\n// if (import.meta.main) {\nawait main();\n// }\n","import { getRequiredEnv, requireCommandAccessToken } from \"../util/env.ts\";\n\nconst { APPLICATION_ID } = getRequiredEnv();\nconst COMMAND_ACCESS_TOKEN = requireCommandAccessToken();\n\nconst url = `https://discord.com/api/v10/applications/${APPLICATION_ID}/commands`;\n\n// Context type values for Discord slash commands\n// 0: GUILD - Can be used in servers\n// 1: BOT_DM - Can be used in DMs with the bot\n// 2: PRIVATE_CHANNEL - Can be used in group DMs and other private channels\n\n// Define the slash command data\nconst commandData = {\n name: \"timestamp\",\n description: \"Converts a human-readable string into a Discord timestamp\",\n contexts: [0, 1, 2], // 0: GUILD, 1: BOT_DM, 2: PRIVATE_CHANNEL\n options: [\n {\n name: \"at\",\n description:\n \"A human-readable date/time including timezone (e.g., tomorrow at 3pm EST, 2023-05-01 14:30 UTC)\",\n type: 3, // STRING\n required: true,\n },\n {\n name: \"format\",\n description: \"Timestamp display format\",\n type: 3, // STRING\n required: true,\n autocomplete: true,\n },\n ],\n};\n\n/**\n * Register a slash command with Discord's API\n */\nasync function registerCommand(commandData) {\n try {\n // Authorization headers using the imported token\n const headers = {\n Authorization: `Bearer ${COMMAND_ACCESS_TOKEN}`,\n \"Content-Type\": \"application/json\",\n };\n\n // Make the HTTP request to Discord's API\n const response = await fetch(url, {\n method: \"POST\",\n headers: headers,\n body: JSON.stringify(commandData),\n });\n\n if (!response.ok) {\n const errorData = await response.json();\n console.error(\"Failed to register command:\", errorData);\n throw new Error(`Discord API error: ${response.status}`);\n }\n\n const data = await response.json();\n console.log(\"Command registered successfully:\", data);\n return data;\n } catch (error) {\n console.error(\"Error registering command:\", error);\n throw error;\n }\n}\n\n// Main function to run the setup\nasync function main() {\n console.log(\"Registering Discord slash command for timestamp...\");\n try {\n await registerCommand(commandData);\n console.log(\"Command registration completed successfully!\");\n } catch (error) {\n console.error(\"Command registration failed:\", error.message);\n console.log(\n \"If the error is related to authentication, try running: deno run --allow-net --allow-env token_gen.ts\"\n );\n Deno.exit(1);\n }\n}\n\n// import.meta.main is not support on vt yet\n// if (import.meta.main) {\nawait main();\n// }\n","createdAt",["D",1757654215255],"branchVersion","branchId","60880212-8f45-11f0-9a9b-0224a6c84d84","id","6087a830-8f45-11f0-9a9b-0224a6c84d84","crone",["D",1757618858346],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","32f53dae-c440-4f1f-9e35-482384bf3e1f","pinnedFileId","608a23ee-8f45-11f0-9a9b-0224a6c84d84","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","cfc37693-eb92-4a95-a7dd-f5f2f9075890","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_105":101},"org",{"_97":96,"_98":99,"_100":101,"_18":55,"_102":103,"_104":25},"branch",{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"isOwned",911,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jrmann100","handle","displayName","Jordan Mann","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/ae2a2475-0cad-47ce-b146-1157b8ed4f00/square512?exp=1789574399&sig=88614385851f13af95fe6090b9768edbe6e64c7ae71fedab11f63071ac470354","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":325,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":326,"_81":327,"_83":328,"_85":25},"tree",[221,223,225,227,230,233,234,235,236,237],"files",[221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237],"counts",{"_209":63,"_210":211,"_212":63,"_213":214,"_215":216},"contents",[128,129,130,131,132,133,134,135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":203,"_32":204,"_30":205,"_140":-5,"_42":43,"_41":206,"_142":59,"_39":207,"_13":63,"_34":183,"_36":-5,"_24":25,"_147":-5,"_27":208},{"_44":197,"_32":198,"_30":199,"_140":-5,"_42":43,"_41":200,"_142":59,"_39":201,"_13":63,"_34":183,"_36":-5,"_24":25,"_147":-5,"_27":202},{"_44":191,"_32":192,"_30":193,"_140":-5,"_42":43,"_41":194,"_142":59,"_39":195,"_13":63,"_34":183,"_36":-5,"_24":25,"_147":-5,"_27":196},{"_44":185,"_32":186,"_30":187,"_140":-5,"_42":43,"_41":188,"_142":59,"_39":189,"_13":63,"_34":183,"_36":-5,"_24":25,"_147":-5,"_27":190},{"_44":178,"_32":179,"_30":180,"_140":-5,"_42":43,"_41":181,"_142":59,"_39":182,"_13":63,"_34":183,"_36":-5,"_24":25,"_147":-5,"_27":184},{"_44":171,"_32":172,"_30":173,"_140":-5,"_42":43,"_41":174,"_142":59,"_39":175,"_13":63,"_34":20,"_36":176,"_24":25,"_147":-5,"_27":177},{"_44":164,"_32":165,"_30":166,"_140":-5,"_42":43,"_41":167,"_142":59,"_39":168,"_13":63,"_34":20,"_36":169,"_24":25,"_147":-5,"_27":170},{"_44":156,"_32":157,"_30":158,"_140":-5,"_42":43,"_41":159,"_142":25,"_39":160,"_13":161,"_34":20,"_36":162,"_24":25,"_147":-5,"_27":163},{"_44":149,"_32":150,"_30":151,"_140":-5,"_42":43,"_41":152,"_142":59,"_39":153,"_13":63,"_34":20,"_36":154,"_24":25,"_147":-5,"_27":155},{"_44":138,"_32":139,"_30":57,"_140":-5,"_42":43,"_41":141,"_142":25,"_39":143,"_13":144,"_34":145,"_36":146,"_24":25,"_147":46,"_27":148},"9248d978-8f97-11f0-901b-0224a6c84d84","main.ts","parentId",494,"latest",["D",1757654160545],160,"http","import { Hono } from \"npm:hono\";\nimport verify from \"./middleware/verify.ts\";\n\n// TODO: / route should go to install\n// TODO: \"in 24 hours\" not forcing timezone\n// TODO: warn when using PST but it is not standard time and vice versa\n// TODO: handle ranges?\n\nimport { handleInteraction } from \"./routes/interaction-router.ts\";\n\nconst app = new Hono();\n\napp.post(\"/api/interactions\", verify, handleInteraction);\n\nexport default app.fetch;\n","label",[139],"ebaa6a98-8f49-11f0-a7ee-0224a6c84d84","deno.json","ebaa6b38-8f49-11f0-a7ee-0224a6c84d84",60,["D",1757620809760],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": false,\n \"types\": [\n \"https://www.val.town/types/valtown.d.ts\"\n ],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"files\": {\n \"include\": [\n \"deno:/https/esm.town/**/*\"\n ]\n },\n \"rules\": {\n \"exclude\": [\n \"no-explicit-any\"\n ]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}",[150],"042f5306-8f97-11f0-b81d-0224a6c84d84","README.md","ec0c8534-8f4e-11f0-8dda-0224a6c84d84",476,["D",1757653922141],3,"# Discord Timestamp Bot\n\nA Discord bot that converts human-readable dates and times into Discord timestamp formats with autocomplete.\n\n## Setup Instructions\n\n### 1. Environment Variables\n\nThis application requires the following environment variables:\n\n```bash\n# Required Discord API credentials\nCLIENT_ID=\"your_discord_client_id\"\nCLIENT_SECRET=\"your_discord_client_secret\"\nAPPLICATION_ID=\"your_discord_application_id\"\nAPPLICATION_PUBLIC_KEY=\"your_discord_public_key\"\n\n# Token for slash command registration (will be generated)\nCOMMAND_ACCESS_TOKEN=\"your_command_access_token\"\n```\n\n### 2. Generate Command Access Token\n\nBefore registering commands, you need to generate a Discord API access token:\n\n```bash\ndeno run --allow-net --allow-env token_gen.ts\n```\n\nThis will output a token and instructions to set it as an environment variable. The token is used for command registration and has an expiration date.\n\n### 3. Register Slash Commands\n\nAfter setting up your environment variables including the generated token:\n\n```bash\ndeno run --allow-net --allow-env scripts/setup.ts\n```\n\nThis will register the `/timestamp` slash command with Discord.\n\n### 4. Run the Bot\n\nStart the bot server:\n\n```bash\ndeno run --allow-net --allow-env main.ts\n```\n\n## Usage\n\nThe bot provides a `/timestamp` slash command with the following options:\n\n- `at`: (Required) A human-readable time string like \"tomorrow 2pm\" or \"next Friday at noon\"\n- `format`: (Optional) The Discord timestamp format to use, with autocomplete\n\nIf no format is selected, all available format options will be displayed.\n\nThe command is available in:\n- Servers (guilds)\n- Direct messages with the bot\n- Group DMs and private channels\n\nAll responses are ephemeral (only visible to the user who invoked the command).\n\n## Available Formats\n\n- `t`: Short Time (1:23 PM)\n- `T`: Long Time (1:23:45 PM)\n- `d`: Short Date (09/11/2025)\n- `D`: Long Date (September 11, 2025)\n- `f`: Short Date/Time (September 11, 2025 1:23 PM)\n- `F`: Long Date/Time (Thursday, September 11, 2025 1:23 PM)\n- `R`: Relative (in 2 days)\n",[157],"ebb67a4a-8f49-11f0-9d34-0224a6c84d84","AGENTS.md","ebb67b26-8f49-11f0-9d34-0224a6c84d84",61,["D",1757620809838],"You are an advanced assistant specialized in generating Val Town code.\n\n## Core Guidelines\n\n- Ask clarifying questions when requirements are ambiguous\n- Provide complete, functional solutions rather than skeleton implementations\n- Test your logic against edge cases before presenting the final solution\n- Ensure all code follows Val Town's specific platform requirements\n- If a section of code that you're working on is getting too complex, consider refactoring it into subcomponents\n\n## Code Standards\n\n- Generate code in TypeScript or TSX\n- Add appropriate TypeScript types and interfaces for all data structures\n- Prefer official SDKs or libraries than writing API calls directly\n- Ask the user to supply API or library documentation if you are at all unsure about it\n- **Never bake in secrets into the code** - always use environment variables\n- Include comments explaining complex logic (avoid commenting obvious operations)\n- Follow modern ES6+ conventions and functional programming practices if possible\n\n## Types of triggers\n\n### 1. HTTP Trigger\n\n- Create web APIs and endpoints\n- Handle HTTP requests and responses\n- Example structure:\n\n```ts\nexport default async function (req: Request) {\n return new Response(\"Hello World\");\n}\n```\n\nFiles that are HTTP triggers have http in their name like `foobar.http.tsx`\n\n### 2. Cron Triggers\n\n- Run on a schedule\n- Use cron expressions for timing\n- Example structure:\n\n```ts\nexport default async function () {\n // Scheduled task code\n}\n```\n\nFiles that are Cron triggers have cron in their name like `foobar.cron.tsx`\n\n### 3. Email Triggers\n\n- Process incoming emails\n- Handle email-based workflows\n- Example structure:\n\n```ts\nexport default async function (email: Email) {\n // Process email\n}\n```\n\nFiles that are Email triggers have email in their name like `foobar.email.tsx`\n\n\n## Val Town Standard Libraries\n\nVal Town provides several hosted services and utility functions.\n\n### Blob Storage\n\n```ts\nimport { blob } from \"https://esm.town/v/std/blob\";\nawait blob.setJSON(\"myKey\", { hello: \"world\" });\nlet blobDemo = await blob.getJSON(\"myKey\");\nlet appKeys = await blob.list(\"app_\");\nawait blob.delete(\"myKey\");\n```\n\n### SQLite\n\n```ts\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nconst TABLE_NAME = 'todo_app_users_2';\n// Create table - do this before usage and change table name when modifying schema\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL\n)`);\n// Query data\nconst result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [1]);\n```\n\nNote: When changing a SQLite table's schema, change the table's name (e.g., add _2 or _3) to create a fresh table.\n\n### OpenAI\n\n```ts\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nconst openai = new OpenAI();\nconst completion = await openai.chat.completions.create({\n messages: [\n { role: \"user\", content: \"Say hello in a creative way\" },\n ],\n model: \"gpt-4o-mini\",\n max_tokens: 30,\n});\n```\n\n### Email\n\n```ts\nimport { email } from \"https://esm.town/v/std/email\";\n// By default emails the owner of the val\nawait email({ \n subject: \"Hi\", \n text: \"Hi\", \n html: \"

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 { parseProject, readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n### Available Utilities\n\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\" urls:\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 Standard Library utilities ONLY RUN ON THE SERVER.\nIf you need access to this data on the client, run it in the server and pass it to the client by splicing it into the HTML page\nor by making an API request for it.\n\n## Val Town Platform Specifics\n\n- **Redirects:** Use `return new Response(null, { status: 302, headers: { Location: \"/place/to/redirect\" }})` instead of `Response.redirect` which is broken\n- **Images:** Avoid external images or base64 images. Use emojis, unicode symbols, or icon fonts/libraries instead\n- **AI Image:** To inline generate an AI image use: `

`\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) unless otherwise specified\n- **View Source:** Add a view source link by importing & using `import.meta.url.replace(\"ems.sh\", \"val.town)\"` (or passing this data to the client) and include `target=\"_top\"` attribute\n- **Error Debugging:** Add `` to HTML to capture client-side errors\n- **Error Handling:** Only use try...catch when there's a clear local resolution; Avoid catches that merely log or return 500s. Let errors bubble up with full context\n- **Environment Variables:** Use `Deno.env.get('keyname')` when you need to, but generally prefer APIs that don't require keys\n- **Imports:** Use `https://esm.sh` for npm and Deno dependencies to ensure compatibility on server and browser\n- **Storage Strategy:** Only use backend storage if explicitly required; prefer simple static client-side sites\n- **React Configuration:** When using React libraries, pin versions with `?deps=react@18.2.0,react-dom@18.2.0` and start the file with `/** @jsxImportSource https://esm.sh/react@18.2.0 */`\n- Ensure all React dependencies and sub-dependencies are pinned to the same version\n- **Styling:** Default to using TailwindCSS via `` unless otherwise specified\n\n## Project Structure and Design Patterns\n\n### Recommended Directory Structure\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 files:\n ```ts\n import { readFile, serveFile } 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- Create RESTful API routes for CRUD operations\n- Always include this snippet at the top-level Hono app to re-throwing errors to 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- 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 - 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 - 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 - 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 React files\n - Rendering issues often come from mismatched React versions\n\n4. **File Handling:**\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 `export default app.fetch // This is the entry point for HTTP vals`\n\n",[165],"ebc48f22-8f49-11f0-be11-0224a6c84d84",".vtignore","ebc48fd6-8f49-11f0-be11-0224a6c84d84",62,["D",1757620809932],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[172],"25020f6a-8f97-11f0-823b-0224a6c84d84","util","25021014-8f97-11f0-823b-0224a6c84d84",480,["D",1757653977203],"directory",[179],"fb83b8f0-8f96-11f0-81f7-0224a6c84d84","scripts","fb83b990-8f96-11f0-81f7-0224a6c84d84",473,["D",1757653907599],[186],"825ef0a8-8f8b-11f0-9403-0224a6c84d84","routes","825ef1c0-8f8b-11f0-9403-0224a6c84d84",267,["D",1757648979889],[192],"49c86f2e-8f97-11f0-8504-0224a6c84d84","middleware","49c86ff6-8f97-11f0-8504-0224a6c84d84",490,["D",1757654038899],[198],"7bb17848-8f8b-11f0-97e2-0224a6c84d84","handlers","7bb1796a-8f8b-11f0-97e2-0224a6c84d84",265,["D",1757648968676],[204],"pulls","branches",1,"forks","envVars",{"_217":219,"_220":63},"connections",{"_217":63,"_218":63},"count","unfilledCount",5,"emptyCount",{"_44":203,"_32":204,"_30":205,"_140":-5,"_42":43,"_41":206,"_142":59,"_39":322,"_13":63,"_34":183,"_36":-5,"_24":25,"_147":-5,"_239":323,"_27":324},{"_44":313,"_32":314,"_30":315,"_140":205,"_42":43,"_41":316,"_142":25,"_39":317,"_13":318,"_34":35,"_36":319,"_24":25,"_147":-5,"_239":320,"_27":321},{"_44":197,"_32":198,"_30":199,"_140":-5,"_42":43,"_41":200,"_142":59,"_39":310,"_13":63,"_34":183,"_36":-5,"_24":25,"_147":-5,"_239":311,"_27":312},{"_44":301,"_32":302,"_30":303,"_140":199,"_42":43,"_41":304,"_142":25,"_39":305,"_13":306,"_34":35,"_36":307,"_24":25,"_147":-5,"_239":308,"_27":309},{"_44":191,"_32":192,"_30":193,"_140":-5,"_42":43,"_41":194,"_142":59,"_39":298,"_13":63,"_34":183,"_36":-5,"_24":25,"_147":-5,"_239":299,"_27":300},{"_44":289,"_32":290,"_30":291,"_140":193,"_42":43,"_41":292,"_142":25,"_39":293,"_13":294,"_34":35,"_36":295,"_24":25,"_147":-5,"_239":296,"_27":297},{"_44":185,"_32":186,"_30":187,"_140":-5,"_42":43,"_41":188,"_142":59,"_39":286,"_13":63,"_34":183,"_36":-5,"_24":25,"_147":-5,"_239":287,"_27":288},{"_44":277,"_32":278,"_30":279,"_140":187,"_42":43,"_41":280,"_142":25,"_39":281,"_13":282,"_34":35,"_36":283,"_24":25,"_147":-5,"_239":284,"_27":285},{"_44":273,"_32":33,"_30":31,"_140":187,"_42":43,"_41":14,"_142":25,"_39":274,"_13":152,"_34":35,"_36":38,"_24":25,"_147":-5,"_239":275,"_27":276},{"_44":178,"_32":179,"_30":180,"_140":-5,"_42":43,"_41":181,"_142":59,"_39":270,"_13":63,"_34":183,"_36":-5,"_24":25,"_147":-5,"_239":271,"_27":272},{"_44":262,"_32":263,"_30":264,"_140":180,"_42":43,"_41":265,"_142":25,"_39":266,"_13":63,"_34":35,"_36":267,"_24":25,"_147":-5,"_239":268,"_27":269},{"_44":254,"_32":255,"_30":256,"_140":180,"_42":43,"_41":257,"_142":59,"_39":258,"_13":63,"_34":35,"_36":259,"_24":25,"_147":-5,"_239":260,"_27":261},{"_44":171,"_32":172,"_30":173,"_140":-5,"_42":43,"_41":174,"_142":59,"_39":251,"_13":63,"_34":20,"_36":176,"_24":25,"_147":-5,"_239":252,"_27":253},{"_44":164,"_32":165,"_30":166,"_140":-5,"_42":43,"_41":167,"_142":59,"_39":248,"_13":63,"_34":20,"_36":169,"_24":25,"_147":-5,"_239":249,"_27":250},{"_44":156,"_32":157,"_30":158,"_140":-5,"_42":43,"_41":159,"_142":25,"_39":245,"_13":161,"_34":20,"_36":162,"_24":25,"_147":-5,"_239":246,"_27":247},{"_44":149,"_32":150,"_30":151,"_140":-5,"_42":43,"_41":152,"_142":59,"_39":242,"_13":63,"_34":20,"_36":154,"_24":25,"_147":-5,"_239":243,"_27":244},{"_44":138,"_32":139,"_30":57,"_140":-5,"_42":43,"_41":141,"_142":25,"_39":238,"_13":144,"_34":145,"_36":146,"_24":25,"_147":46,"_239":240,"_27":241},["D",1757654160545],"children",[],[139],["D",1757620809760],[],[150],["D",1757653922141],[],[157],["D",1757620809838],[],[165],["D",1757620809932],[],[172],"29109ebe-8f97-11f0-b267-0224a6c84d84","env.ts","29109f7c-8f97-11f0-b267-0224a6c84d84",482,["D",1757653984019],"// env.ts - Centralized environment variable handling\n\n/**\n * Get required environment variables\n * Throws an error if any required variable is not set\n */\nexport function getRequiredEnv() {\n const CLIENT_SECRET = Deno.env.get(\"CLIENT_SECRET\");\n if (typeof CLIENT_SECRET !== \"string\") {\n throw new Error(\"CLIENT_SECRET is not set\");\n }\n\n const APPLICATION_ID = Deno.env.get(\"APPLICATION_ID\");\n if (typeof APPLICATION_ID !== \"string\") {\n throw new Error(\"APPLICATION_ID is not set\");\n }\n\n const CLIENT_ID = Deno.env.get(\"CLIENT_ID\");\n if (typeof CLIENT_ID !== \"string\") {\n throw new Error(\"CLIENT_ID is not set\");\n }\n\n const APPLICATION_PUBLIC_KEY = Deno.env.get(\"APPLICATION_PUBLIC_KEY\");\n if (typeof APPLICATION_PUBLIC_KEY !== \"string\") {\n throw new Error(\"APPLICATION_PUBLIC_KEY is not set\");\n }\n\n return {\n CLIENT_SECRET,\n APPLICATION_ID,\n CLIENT_ID,\n APPLICATION_PUBLIC_KEY,\n };\n}\n\n/**\n * Get the command access token from environment\n * Returns null if not set or empty\n */\nexport function getCommandAccessToken() {\n const token = Deno.env.get(\"COMMAND_ACCESS_TOKEN\");\n if (typeof token !== \"string\" || token.trim() === \"\") {\n return null;\n }\n return token;\n}\n\n/**\n * Checks if the command access token is set\n * Throws an error if not set, with instructions\n */\nexport function requireCommandAccessToken() {\n const token = getCommandAccessToken();\n if (!token) {\n throw new Error(\n \"COMMAND_ACCESS_TOKEN is not set. Run command_token_gen.ts to generate one.\"\n );\n }\n return token;\n}\n",[],[179,255],"29160e3a-8f97-11f0-9df5-0224a6c84d84","date-utils.ts","29160f48-8f97-11f0-9df5-0224a6c84d84",483,["D",1757653984021],"import { formatInTimeZone } from \"npm:date-fns-tz\";\nimport dayjs from \"npm:dayjs\";\nimport relativeTime from \"npm:dayjs/plugin/relativeTime.js\";\ndayjs.extend(relativeTime);\n\nexport const timezoneOffsetFromMinutes = (tzOffsetMinutes: number) => {\n const offsetHours = tzOffsetMinutes / 60;\n const sign = offsetHours < 0 ? \"-\" : \"+\";\n const hours = Math.abs(Math.floor(offsetHours));\n const minutes = Math.abs(Math.round((offsetHours % 1) * 60));\n\n return `${sign}${hours.toString().padStart(2, \"0\")}:${minutes\n .toString()\n .padStart(2, \"0\")}`;\n};\n\n// Generate timestamp format options with examples using the current date\nexport const generateFormatOptions = (\n date = new Date(),\n tzOffsetMinutes: number\n) => {\n const timezoneOffset = timezoneOffsetFromMinutes(tzOffsetMinutes);\n return {\n // Discord timestamp formats\n t: formatInTimeZone(date, timezoneOffset, \"h:mm a\"),\n T: formatInTimeZone(date, timezoneOffset, \"h:mm:ss a\"),\n d: formatInTimeZone(date, timezoneOffset, \"M/d/yyyy\"),\n D: formatInTimeZone(date, timezoneOffset, \"MMMM d, yyyy\"),\n f: formatInTimeZone(date, timezoneOffset, \"MMMM d, yyyy h:mm a\"),\n F: formatInTimeZone(date, timezoneOffset, \"EEEE, MMMM d, yyyy h:mm a\"),\n R: dayjs(date).fromNow(),\n };\n};\n\n// Format a date in a friendly, human-readable format with timezone included\nexport const formatHumanReadableDate = (date: Date, tzOffsetMinutes: number) =>\n formatInTimeZone(\n date,\n timezoneOffsetFromMinutes(tzOffsetMinutes),\n \"EEEE, MMMM d 'at' h:mm a O\"\n );\n",[],[179,263],["D",1757653977203],[231,232],[179],"b2e496d6-8f97-11f0-a6b7-0224a6c84d84",["D",1757654215255],[],[186,33],"adc2934c-8f97-11f0-98e7-0224a6c84d84","generate-setup-token.ts","ce6eef80-8f4e-11f0-a23b-0224a6c84d84",499,["D",1757654206606],10,"import { getRequiredEnv } from \"../util/env.ts\";\n\n// Get all required environment variables\nconst { CLIENT_ID, CLIENT_SECRET } = getRequiredEnv();\n\nconsole.log(\"Generating a new Discord API access token...\");\n\ntry {\n // Get an access token using client credentials\n const tokenResponse = await fetch(\n \"https://discord.com/api/v10/oauth2/token\",\n {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/x-www-form-urlencoded\",\n },\n body: new URLSearchParams({\n grant_type: \"client_credentials\",\n client_id: CLIENT_ID,\n client_secret: CLIENT_SECRET,\n scope: \"applications.commands.update\",\n }),\n }\n );\n\n if (!tokenResponse.ok) {\n const errorData = await tokenResponse.json();\n console.error(\"Failed to get token:\", errorData);\n throw new Error(`Discord OAuth2 error: ${tokenResponse.status}`);\n }\n\n const tokenData = await tokenResponse.json();\n const accessToken = tokenData.access_token;\n const expiresIn = tokenData.expires_in;\n\n // Calculate expiration date for user reference\n const expirationDate = new Date();\n expirationDate.setSeconds(expirationDate.getSeconds() + expiresIn);\n\n console.log(`COMMAND_ACCESS_TOKEN=\"${accessToken}\"`);\n console.log(`This token will expire on: ${expirationDate.toLocaleString()}`);\n\n // Also suggest adding it to a .env file if one exists\n console.log(\n \"You may also want to add it to your .env file if you're using one:\"\n );\n console.log(`COMMAND_ACCESS_TOKEN=\"${accessToken}\"`);\n} catch (error) {\n console.error(\"Error generating access token:\", error);\n Deno.exit(1);\n}\n",[],[186,278],["D",1757653907599],[228,229],[186],"52c6452c-8f94-11f0-aa81-0224a6c84d84","interaction-router.ts","827edbca-8f8b-11f0-b4e5-0224a6c84d84",430,["D",1757652765504],4,"import { Context } from \"npm:hono\";\nimport {\n InteractionResponseType,\n InteractionType,\n} from \"npm:discord-interactions\";\nimport {\n handleTimestampAutocomplete,\n handleTimestampCommand,\n} from \"../handlers/timestamp-handler.ts\";\n\n/**\n * Route the Discord interaction to the appropriate handler\n */\nexport async function handleInteraction(c: Context) {\n const req = await c.req.json();\n\n if (!(\"type\" in req)) {\n return c.json({ type: -1, error: \"no type\" }, { status: 400 });\n }\n\n // Handle ping interactions\n if (req.type === InteractionType.PING) {\n return c.json({ type: InteractionResponseType.PONG });\n }\n\n // Handle autocomplete interactions\n if (req.type === InteractionType.APPLICATION_COMMAND_AUTOCOMPLETE) {\n const { name, options } = req.data;\n\n if (\n name === \"timestamp\" &&\n options.find((opt) => opt.name === \"format\" && opt.focused)\n ) {\n const focusedValue =\n options.find((opt) => opt.focused)?.value?.toLowerCase() || \"\";\n return c.json(handleTimestampAutocomplete(options, focusedValue));\n }\n }\n\n // Handle application command interactions\n if (req.type === InteractionType.APPLICATION_COMMAND) {\n const { name, options } = req.data;\n\n if (name === \"timestamp\") {\n return c.json(handleTimestampCommand(options));\n }\n }\n\n // Fallback for unknown interaction types\n return c.json({ type: -1, error: \"unknown type\" });\n}\n",[],[192,290],["D",1757648979889],[226],[192],"5c132c8c-8f97-11f0-9ee5-0224a6c84d84","verify.ts","850b0a38-8f47-11f0-b3d7-0224a6c84d84",492,["D",1757654069594],32,"import { verifyKey } from \"npm:discord-interactions\";\nimport type { Context, HonoRequest, Next } from \"npm:hono\";\nimport { getRequiredEnv } from \"../util/env.ts\";\n\n// Get the public key from environment variables\nconst { APPLICATION_PUBLIC_KEY } = getRequiredEnv();\n\nconst verifyDiscordRequest = async (req: HonoRequest): Promise => {\n const signature = req.header(\"X-Signature-Ed25519\");\n const timestamp = req.header(\"X-Signature-Timestamp\");\n\n if (typeof signature !== \"string\" || typeof timestamp !== \"string\") {\n return false;\n }\n\n try {\n const body = await req.raw.clone().text();\n return verifyKey(body, signature, timestamp, APPLICATION_PUBLIC_KEY);\n } catch (error) {\n console.error(\"Discord request verification error:\", error);\n return false;\n }\n};\n\nexport default async (c: Context, next: Next) => {\n if (!(await verifyDiscordRequest(c.req))) {\n return c.json({ type: -1, error: \"invalid request signature\" }, 401);\n }\n await next();\n};\n",[],[198,302],["D",1757654038899],[224],[198],"2e03de04-8f97-11f0-9b06-0224a6c84d84","timestamp-handler.ts","7bc6cce8-8f8b-11f0-8fc0-0224a6c84d84",487,["D",1757653992318],119,"import * as chrono from \"npm:chrono-node\";\nimport {\n InteractionResponseFlags,\n InteractionResponseType,\n} from \"npm:discord-interactions\";\nimport {\n formatHumanReadableDate,\n generateFormatOptions,\n} from \"../util/date-utils.ts\";\n\nconst TICKS = \"```\";\n\nconst formatErrorAsDiff = (\n message: string,\n suggestion?: string\n) => `${TICKS}diff\n- ${message.replaceAll(\"\\n\", \"\\n- \")}${suggestion ? `\\n+ ${suggestion}` : \"\"}\n${TICKS}`;\n\n/**\n * Handle the timestamp command autocomplete interaction\n */\nexport function handleTimestampAutocomplete(\n options: any[],\n focusedValue: string\n) {\n const timeString = options.find((opt) => opt.name === \"at\")?.value;\n\n let date: Date | null = null,\n tzOffsetMinutes = 0;\n try {\n // Parse the provided time string\n const parsedResults = chrono.parse(timeString);\n if (parsedResults && parsedResults.length > 0) {\n const result = parsedResults[0].start;\n date = result.date();\n tzOffsetMinutes = result.get(\"timezoneOffset\") ?? 0;\n }\n } catch {\n date = new Date();\n }\n\n const formatOptions = generateFormatOptions(date, tzOffsetMinutes);\n\n // Filter format options based on input\n const filtered = Object.entries(formatOptions)\n .filter(\n ([key, value]) =>\n key.toLowerCase().includes(focusedValue) ||\n value.toLowerCase().includes(focusedValue)\n )\n .map(([key, value]) => ({\n name: value,\n value: key,\n }));\n\n return {\n type: InteractionResponseType.APPLICATION_COMMAND_AUTOCOMPLETE_RESULT,\n data: {\n choices: filtered.slice(0, 25), // Discord has a max of 25 autocomplete results\n },\n };\n}\n\n/**\n * Handle the timestamp command execution\n */\nexport function handleTimestampCommand(options: any[]) {\n try {\n // Extract the human-readable time string from options\n const timeString = options.find((opt) => opt.name === \"at\")?.value;\n if (timeString === undefined) {\n throw new Error(\"No time string was provided, but it is required.\");\n }\n\n // Get the format option if provided\n const formatOption = options.find((opt) => opt.name === \"format\")?.value;\n\n if (formatOption === undefined) {\n throw new Error(\"No format option was provided, but it is required.\");\n }\n\n // Parse the human-readable time string using chrono\n const parsedResults = chrono.parse(timeString);\n\n // Check if we have any results\n if (!parsedResults || parsedResults.length === 0) {\n return {\n type: InteractionResponseType.CHANNEL_MESSAGE_WITH_SOURCE,\n data: {\n content: formatErrorAsDiff(\n `Could not parse \"${timeString}\" into a valid date/time.`,\n \"Please provide a clear date/time format.\"\n ),\n flags: InteractionResponseFlags.EPHEMERAL,\n },\n };\n }\n\n // Get the first result\n const parsedResult = parsedResults[0];\n const parsedTime = parsedResult.start.date();\n\n // Extract timezone information (if any)\n const tzOffsetMinutes = parsedResult.start.get(\"timezoneOffset\");\n\n // Check if timezone information was included\n if (tzOffsetMinutes === null) {\n return {\n type: InteractionResponseType.CHANNEL_MESSAGE_WITH_SOURCE,\n data: {\n content: formatErrorAsDiff(\n \"Sorry, I can't infer your timezone.\",\n 'Please include a timezone like \"ET\" or \"UTC\"'\n ),\n flags: InteractionResponseFlags.EPHEMERAL,\n },\n };\n }\n\n // Apply timezone offset correctly to ensure the timestamp is accurate\n // parsedTime is in local timezone, but we need it in the specified timezone\n // tzOffset is in minutes, need to convert to milliseconds\n const userTimestamp = parsedTime.getTime();\n\n // Get Unix timestamp (in seconds), properly adjusted for timezone\n // We use the tzOffset from chrono parsing instead of the local timezone offset\n const unixTimestamp = Math.floor(userTimestamp / 1000);\n\n // Regenerate format options with the parsed time to ensure examples are accurate\n const formatOptions = generateFormatOptions(parsedTime, tzOffsetMinutes);\n\n // If a specific format was chosen, only show that one\n if (formatOption && formatOptions[formatOption]) {\n const format = formatOption;\n\n // Create human-readable date string with timezone\n const humanReadableDate = formatHumanReadableDate(\n parsedTime,\n tzOffsetMinutes\n );\n\n const discordTimestamp = ``;\n return {\n type: InteractionResponseType.CHANNEL_MESSAGE_WITH_SOURCE,\n data: {\n content: `${discordTimestamp}\n> I got _${humanReadableDate}_. Looks correct? Copy the text below:\n${TICKS}\n${discordTimestamp}\n${TICKS}`,\n flags: InteractionResponseFlags.EPHEMERAL,\n },\n };\n }\n } catch (error) {\n console.error(\"Error processing timestamp command:\", error);\n return {\n type: InteractionResponseType.CHANNEL_MESSAGE_WITH_SOURCE,\n data: {\n content: formatErrorAsDiff(\n \"An error occurred while processing your request.\"\n ),\n flags: InteractionResponseFlags.EPHEMERAL,\n },\n };\n }\n}\n",[],[204,314],["D",1757648968676],[222],[204],["D",1757618858346],{"_97":96,"_105":101},{"_97":96,"_98":99,"_100":101,"_18":55,"_102":103,"_104":25},{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"ctx",{"_79":-5,"_125":362,"_363":364,"_365":366,"_367":25,"_368":25,"_369":25,"_370":59,"_371":-5,"_372":-7,"_373":-7,"_374":63,"_375":25,"_376":25,"_377":-5,"_378":25,"_379":25,"_380":25,"_381":-5},"ENV",{"_333":334,"_335":336,"_337":87,"_338":339,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351,"_352":353,"_354":355,"_356":357,"_358":359,"_360":361},"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 · v502