[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_179":180,"_181":182},"routes/_app.x.$handle.$name",{"_96":95,"_32":45,"_104":86,"_27":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":58,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",15,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","db.ts","latestPath","fileId","a75e333c-7163-11f0-918b-0224a6c84d84","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst TABLE_NAME = 'form_submissions_v3';\n\nexport async function initDB() {\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 created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\nexport async function saveSubmission(name: string, email: string) {\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE_NAME} (name, email) VALUES (?, ?)`,\n args: [name, email]\n });\n}","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst TABLE_NAME = 'form_submissions';\n\nexport async function initDB() {\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 created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\nexport async function saveSubmission(name: string, email: string) {\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE_NAME} (name, email) VALUES (?, ?)`,\n args: [name, email]\n });\n}","createdAt",["D",1754336162851],"branchVersion","branchId","63bb8364-7163-11f0-920d-0224a6c84d84","id","63bb32a6-7163-11f0-920d-0224a6c84d84","simple-form",["D",1754333213736],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","c156eb0e-8b9d-4104-a055-502e9a0eb441","pinnedFileId","acd1ac7c-7163-11f0-b43e-0224a6c84d84","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","2019e55b-c541-4c51-bef0-008eef10ef88","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":25},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"isOwned",16,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","charmaine","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4cFpFME5pSXNZamJNd296dlZSYVJ0OVF1RSJ9","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":175,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":176,"_80":177,"_82":178,"_84":25},"tree",[162,163,164],"files",[162,163,164],"counts",{"_151":62,"_152":153,"_154":153,"_155":156,"_157":158},"contents",[126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":144,"_32":145,"_30":146,"_131":-5,"_41":42,"_40":147,"_133":25,"_38":148,"_13":62,"_33":20,"_35":149,"_24":25,"_138":-5,"_27":150},{"_43":140,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_133":58,"_38":141,"_13":142,"_33":34,"_35":37,"_24":25,"_138":-5,"_27":143},{"_43":129,"_32":130,"_30":56,"_131":-5,"_41":42,"_40":132,"_133":58,"_38":134,"_13":135,"_33":136,"_35":137,"_24":25,"_138":-5,"_27":139},"3d06ce9e-7164-11f0-851c-0224a6c84d84","main.ts","parentId",11,"latest",["D",1754333578289],4,"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { initDB, saveSubmission } from \"./db.ts\";\n\nconst app = new Hono();\n\nawait initDB();\n\napp.get(\"/\", (c) => {\n return c.html(`\n \n \n \n Simple Form\n \n \n \n

Submit Your Info

\n \n \n \n `);\n});\n\napp.post(\"/\", async (c) => {\n const formData = await c.req.formData();\n const name = formData.get(\"name\") as string;\n const email = formData.get(\"email\") as string;\n \n if (!name || !email) {\n return c.text(\"Name and email are required\", 400);\n }\n \n await saveSubmission(name, email);\n \n return c.html(`\n \n \n \n Success\n \n \n \n

Thank You!

Your submission has been saved successfully.

\n Submit another\n \n \n `);\n});\n\nexport default app.fetch;","label",[130],"418c03fc-716a-11f0-9cc3-0224a6c84d84",["D",1754336162851],8,[28],"3600cc8e-716a-11f0-a146-0224a6c84d84","README.md","3600cd38-716a-11f0-a146-0224a6c84d84",14,["D",1754336143489],"# Simple Form with SQLite\n\nA minimal form that collects user data and stores it in SQLite.\n\n## Files\n\n- `main.ts` - HTTP val with form and submission handling\n- `db.ts` - SQLite database operations\n\n## Usage\n\nVisit the HTTP endpoint to see the form. Submit name and email to store in database.\n\n## Database\n\nData is stored in `form_submissions_v3` table with columns:\n- `id` (auto-increment)\n- `name` \n- `email`\n- `created_at` (timestamp)",[145],"pulls","branches",1,"forks","envVars",{"_159":62,"_161":62},"connections",{"_159":62,"_160":62},"count","unfilledCount","emptyCount",{"_43":144,"_32":145,"_30":146,"_131":-5,"_41":42,"_40":147,"_133":25,"_38":172,"_13":62,"_33":20,"_35":149,"_24":25,"_138":-5,"_166":173,"_27":174},{"_43":140,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_133":58,"_38":169,"_13":142,"_33":34,"_35":37,"_24":25,"_138":-5,"_166":170,"_27":171},{"_43":129,"_32":130,"_30":56,"_131":-5,"_41":42,"_40":132,"_133":58,"_38":165,"_13":135,"_33":136,"_35":137,"_24":25,"_138":-5,"_166":167,"_27":168},["D",1754333578289],"children",[],[130],["D",1754336162851],[],[28],["D",1754336143489],[],[145],["D",1754333213736],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":25},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"ctx",{"_78":-5,"_123":212,"_213":214,"_215":216,"_217":25,"_218":25,"_219":25,"_220":58,"_221":-5,"_222":-7,"_223":-7,"_224":62,"_225":25,"_226":25,"_227":-5,"_228":25,"_229":25,"_230":25,"_231":-5},"ENV",{"_183":184,"_185":186,"_187":86,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211},"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 · v15