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",[],[230,222],"frontend","2c1b6eee-7170-11f0-ace2-0224a6c84d84",["D",1754338703865],[210],[230],["D",1754338719472],[],[18,91],"1933748e-7170-11f0-b3c3-0224a6c84d84","submissions.ts","1933756a-7170-11f0-b3c3-0224a6c84d84",["D",1754338672141],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { createSubmission, getAllSubmissions } from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Get all submissions\napp.get(\"/\", async (c) => {\n try {\n const submissions = await getAllSubmissions();\n return c.json(submissions);\n } catch (error) {\n console.error(\"Error fetching submissions:\", error);\n return c.json({ error: \"Failed to fetch submissions\" }, 500);\n }\n});\n\n// Create new submission\napp.post(\"/\", async (c) => {\n try {\n const body = await c.req.json();\n \n // Validate required fields\n if (!body.name || !body.email || !body.message) {\n return c.json({ error: \"Name, email, and message are required\" }, 400);\n }\n\n // Basic email validation\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(body.email)) {\n return c.json({ error: \"Invalid email format\" }, 400);\n }\n\n const submission = await createSubmission({\n name: body.name.trim(),\n email: body.email.trim().toLowerCase(),\n message: body.message.trim()\n });\n\n return c.json(submission, 201);\n } catch (error) {\n console.error(\"Error creating submission:\", error);\n return c.json({ error: \"Failed to create submission\" }, 500);\n }\n});\n\nexport default app;",[],[18,82,239],["D",1754338672141],[207],[18,82],"14a21d08-7170-11f0-8696-0224a6c84d84","queries.ts","14a21d9e-7170-11f0-8696-0224a6c84d84",["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}",[],[18,66,249],"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}",[],[18,66,256],["D",1754338658766],[204,205],[18,66],["D",1754338658766],[203,206,208],[18],["D",1754338628214],{"_11":12,"_149":72},{"_11":12,"_145":-5,"_71":72,"_31":70,"_146":147,"_148":30},{"_42":95,"_13":16,"_36":39,"_137":104,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":14,"_144":12},"ctx",{"_54":-5,"_168":305,"_306":307,"_308":309,"_310":30,"_311":30,"_312":30,"_313":24,"_314":-5,"_315":-7,"_316":-7,"_317":26,"_318":30,"_319":30,"_320":-5,"_321":30,"_322":30,"_323":30,"_324":-5},"ENV",{"_276":277,"_278":279,"_280":16,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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 · backend