\n !Contact Form!\n

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

\n\n \n \n Error!! \n

\n\n \n

\n \n Name *\n \n \n

\n\n

\n \n Email *\n \n \n

\n\n

\n \n Message *\n \n \n

\n\n \n Submit Message\n \n \n\n \n

\n Recent Submissions\n

Loading submissions...

\n \n \n\n \n \n",[],[226,219],"frontend","f45d8878-7171-11f0-9222-0224a6c84d84",["D",1754339469336],[208],[226],["D",1754339469336],[],[18,76],"f45d7090-7171-11f0-9222-0224a6c84d84","submissions.ts","019876c7-e815-7412-b76f-75a7faf40699",["D",1754339469336],"script","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,88,235],["D",1754339469336],[205],[18,88],"f45d6c9e-7171-11f0-9222-0224a6c84d84","queries.ts","019876c7-e815-7412-b76f-6ecc7359b540",["D",1754339469336],"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,94,246],"f45d6794-7171-11f0-9222-0224a6c84d84","migrations.ts","019876c7-e815-7412-b76f-69cba1a8b182",["D",1754339469336],"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,94,253],["D",1754339469336],[202,203],[18,94],["D",1754339469336],[201,204,206],[18],["D",1754338628214],{"_11":12,"_142":82},{"_11":12,"_138":-5,"_81":82,"_31":80,"_139":140,"_141":30},{"_39":91,"_13":16,"_33":36,"_130":97,"_131":70,"_132":72,"_133":101,"_134":97,"_135":42,"_136":14,"_137":12},"ctx",{"_52":-5,"_162":302,"_303":304,"_305":306,"_307":30,"_308":30,"_309":30,"_310":24,"_311":-5,"_312":-7,"_313":-7,"_314":26,"_315":30,"_316":30,"_317":-5,"_318":30,"_319":30,"_320":30,"_321":-5},"ENV",{"_273":274,"_275":276,"_277":71,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301},"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