Contact Form

\n \n \n

\n Success! Your message has been submitted successfully.\n

\n\n \n

\n Error! \n

\n\n \n \n\n \n

Recent Submissions

Loading submissions...

\n\n \n\n",[],[197,189],"frontend","2c1b6eee-7170-11f0-ace2-0224a6c84d84",["D",1754338703865],[177],[197],"35690ce0-7170-11f0-9221-0224a6c84d84","index.ts",["D",1754338719472],1,"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { initializeDatabase } from \"./database/migrations.ts\";\nimport submissionsRouter from \"./routes/submissions.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err) => Promise.reject(err));\n\n// Initialize database on startup\nawait initializeDatabase();\n\n// API routes\napp.route(\"/api/submissions\", submissionsRouter);\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main page\napp.get(\"/\", async (c) => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[152,203],["D",1754338672141],[],[152,72,64],["D",1754338672141],[174],[152,72],"14a21d08-7170-11f0-8696-0224a6c84d84","queries.ts","14a21d9e-7170-11f0-8696-0224a6c84d84","0f1a919d-c928-4f3a-9f31-c60694ee8127",["D",1754338664485],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME, FormSubmission } from \"./migrations.ts\";\n\nexport async function createSubmission(submission: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (name, email, message) VALUES (?, ?, ?) RETURNING *`,\n [submission.name, submission.email, submission.message]\n );\n \n return result.rows[0] as FormSubmission;\n}\n\nexport async function getAllSubmissions(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC`);\n return result.rows as FormSubmission[];\n}\n\nexport async function getSubmissionById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [id]);\n return result.rows[0] as FormSubmission || null;\n}",[],[152,224,217],"database","1139a7e4-7170-11f0-afe7-0224a6c84d84","migrations.ts","1139a8c0-7170-11f0-afe7-0224a6c84d84",["D",1754338658766],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport const TABLE_NAME = 'form_submissions_1';\n\nexport interface FormSubmission {\n id?: number;\n name: string;\n email: string;\n message: string;\n created_at?: string;\n}\n\nexport async function initializeDatabase() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n}",[],[152,224,226],"1139b8d8-7170-11f0-afe7-0224a6c84d84",["D",1754338658766],[171,172],[152,224],"1139b626-7170-11f0-afe7-0224a6c84d84",["D",1754338658766],[170,173,175],[152],["D",1754338628214],{"_11":12,"_122":70},{"_11":12,"_118":-5,"_69":70,"_31":68,"_119":120,"_121":30},{"_39":109,"_13":16,"_33":36,"_110":75,"_111":-5,"_112":-5,"_113":-5,"_114":-5,"_115":-5,"_116":14,"_117":12},"ctx",{"_52":-5,"_141":277,"_278":279,"_280":281,"_282":30,"_283":30,"_284":30,"_285":24,"_286":-5,"_287":-7,"_288":-7,"_289":26,"_290":30,"_291":30,"_292":-5,"_293":30,"_294":30,"_295":30,"_296":-5},"ENV",{"_248":249,"_250":251,"_252":16,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5a709144666c9e69e88140f015c586412f0fd8d3","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"]

History · routes