[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_174":175,"_176":177},"routes/_app.x.$handle.$name",{"_102":101,"_32":45,"_111":92,"_27":112,"_13":14,"_113":-5,"_11":114,"_115":116,"_117":118,"_119":120,"_121":122,"_20":-5,"_123":-5,"_124":-5,"_125":25,"_126":127,"_128":60,"_129":-5,"_130":-5,"_131":132},"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":53,"_54":55,"_18":56,"_57":58,"_59":60,"_61":60,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",62,"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","sqlite.ts","latestPath","fileId","8e80064c-a124-11f0-a83f-0224a6c84d84","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// await sqlite.execute(`\n// CREATE TABLE IF NOT EXISTS tld_wiki (\n// id INTEGER PRIMARY KEY AUTOINCREMENT,\n// tld TEXT NOT NULL,\n// email TEXT NOT NULL,\n// name TEXT NOT NULL,\n// entry TEXT NOT NULL,\n// submitted_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n// approved_at TIMESTAMP,\n// status TEXT DEFAULT 'pending' CHECK (status IN ('pending', 'approved', 'rejected'))\n// );\n// `);\n\nawait sqlite.execute({\n sql:\n `UPDATE tld_wiki SET approved_at = CURRENT_TIMESTAMP, status = 'approved' WHERE id = ?;`,\n args: [5],\n});\n\nconsole.log(await sqlite.execute(`SELECT * FROM tld_wiki;`));","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// await sqlite.execute(`\n// CREATE TABLE IF NOT EXISTS tld_wiki (\n// id INTEGER PRIMARY KEY AUTOINCREMENT,\n// tld TEXT NOT NULL,\n// email TEXT NOT NULL,\n// name TEXT NOT NULL,\n// entry TEXT NOT NULL,\n// submitted_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n// approved_at TIMESTAMP,\n// status TEXT DEFAULT 'pending' CHECK (status IN ('pending', 'approved', 'rejected'))\n// );\n// `);\n\nconsole.log(await sqlite.execute(`SELECT * FROM tld_wiki;`));","createdAt",["D",1759593324349],"branchVersion","branchId","87a0c02c-a120-11f0-9e52-0224a6c84d84","id","87a065c8-a120-11f0-9e52-0224a6c84d84","tld-wiki",["D",1759582153490],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","dotcom.press/tld-wiki","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/81019705-4b87-440e-b1a1-c202e2b41100/square512?exp=1789577999&sig=7056ec673e9288da93db82a9f8c16882d8a2f30247d53afaee8d34717bf26ffc","6906d0a1-0165-46b9-8717-60dfd935316a","pinnedFileId","87a356f2-a120-11f0-9e52-0224a6c84d84","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"orgId","631c5cff-7089-4994-8427-c7580df789cd","tursoName","87a065c8a12011f09e520224a6c84d84","tursoHostname","87a065c8a12011f09e520224a6c84d84-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789536037138],"pinned",0,"userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_110":106},"org",{"_102":101,"_103":104,"_105":106,"_18":56,"_107":108,"_109":25},"branch",{"_13":91,"_32":92,"_43":42,"_93":44,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":45,"_100":101},"isOwned",125,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","pmillspaugh","handle","displayName","Pete Millspaugh","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/c3c0aadf-86a9-4c2e-ef01-fb649d6fb000/square512?exp=1789577999&sig=3927c0e321408bea96baab0e45026aeb9713898f5b433aef2217dbb0caa42bf2","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":169,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":55,"_18":56,"_57":58,"_59":60,"_61":60,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":170,"_73":74,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":171,"_86":172,"_88":173,"_90":25},"tree",[160,161],"files",[160,161],"counts",{"_150":74,"_151":64,"_152":74,"_153":154,"_155":156},"contents",[133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":142,"_32":143,"_30":58,"_136":-5,"_41":42,"_40":144,"_137":25,"_38":145,"_13":146,"_33":147,"_35":148,"_24":25,"_140":45,"_27":149},{"_43":135,"_32":28,"_30":31,"_136":-5,"_41":42,"_40":14,"_137":25,"_38":138,"_13":139,"_33":34,"_35":37,"_24":25,"_140":-5,"_27":141},"89fb87b6-a13a-11f0-87bc-0224a6c84d84","parentId","latest",["D",1759593324349],21,"label",[28],"ff4fade8-a136-11f0-9cbf-0224a6c84d84","main.ts",60,["D",1759591803209],39,"http","import { Context, Hono } from \"npm:hono@3\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { email as sendEmail } from \"https://esm.town/v/std/email\";\n\nconst app = new Hono();\n\n// TODO: update src to https://dotcom.press/tld-wiki\napp.get(\"/\", (c: Context) => {\n return c.html(\n `,`,\n );\n});\n\napp.post(\"/submit\", async (c: Context) => {\n try {\n const formData = await c.req.formData();\n const tld = formData.get(\"tld\") as string;\n const email = formData.get(\"email\") as string;\n const name = formData.get(\"name\") as string;\n const entry = formData.get(\"entry\") as string;\n\n console.log(\"Received wiki entry:\", {\n tld,\n entry,\n name,\n email,\n submittedAt: new Date().toISOString(),\n });\n\n // There's also client-side validation, but just in case...\n if (!entry || !name || !email || !tld) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(email)) {\n return c.json({ error: \"Invalid email format\" }, 400);\n }\n\n const result = await sqlite.execute({\n sql:\n `INSERT INTO tld_wiki (tld, email, name, entry) VALUES (?, ?, ?, ?);`,\n args: [tld, email, name, entry],\n });\n\n const id = result.lastInsertRowid;\n\n await sendEmail({\n subject: `TLD wiki submission for ${tld} from ${email}`,\n html: `\n

${name}

${entry}

\n APPROVE\n REJECT\n `,\n });\n\n return c.json({\n success: true,\n message: \"Entry submitted successfully\",\n });\n } catch (error) {\n console.error(\"Error processing form submission:\", error);\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\napp.get(\"/tld/:tld\", async (c: Context) => {\n try {\n const tld = c.req.param(\"tld\");\n\n const { rows } = await sqlite.execute({\n sql: `\n SELECT id, name, entry, submitted_at \n FROM tld_wiki \n WHERE tld = ? AND status = 'approved'\n ORDER BY submitted_at DESC\n `,\n args: [tld],\n });\n\n const entries = rows.map((row: any[]) => ({\n name: row[1],\n entry: row[2],\n submitted_at: row[3],\n }));\n\n return c.json(entries);\n } catch (error) {\n console.error(\"Error fetching entries:\", error);\n return c.json({ error: \"Failed to fetch entries\" }, 500);\n }\n});\n\napp.get(\"/approve/:id\", async (c: Context) => {\n try {\n const id = c.req.param(\"id\");\n\n await sqlite.execute({\n sql: `\n UPDATE tld_wiki\n SET status = 'approved', approved_at = CURRENT_TIMESTAMP\n WHERE id = ?;\n `,\n args: [id],\n });\n\n return c.json({\n success: true,\n message: \"Entry approved successfully\",\n });\n } catch (error) {\n console.error(\"Error fetching entries:\", error);\n return c.json({ error: \"Failed to approve entry\" }, 500);\n }\n});\n\napp.get(\"/reject/:id\", async (c: Context) => {\n try {\n const id = c.req.param(\"id\");\n\n await sqlite.execute({\n sql: `\n UPDATE tld_wiki\n SET status = 'rejected'\n WHERE id = ?;\n `,\n args: [id],\n });\n\n return c.json({\n success: true,\n message: \"Entry rejected successfully\",\n });\n } catch (error) {\n console.error(\"Error fetching entries:\", error);\n return c.json({ error: \"Failed to reject entry\" }, 500);\n }\n});\n\nexport default app.fetch;",[143],"pulls","branches","forks","envVars",{"_157":64,"_159":74},"connections",{"_157":74,"_158":74},"count","unfilledCount","emptyCount",{"_43":142,"_32":143,"_30":58,"_136":-5,"_41":42,"_40":144,"_137":25,"_38":166,"_13":146,"_33":147,"_35":148,"_24":25,"_140":45,"_163":167,"_27":168},{"_43":135,"_32":28,"_30":31,"_136":-5,"_41":42,"_40":14,"_137":25,"_38":162,"_13":139,"_33":34,"_35":37,"_24":25,"_140":-5,"_163":164,"_27":165},["D",1759593324349],"children",[],[28],["D",1759591803209],[],[143],["D",1759582153490],["D",1789536037138],{"_102":101,"_110":106},{"_102":101,"_103":104,"_105":106,"_18":56,"_107":108,"_109":25},{"_13":91,"_32":92,"_43":42,"_93":44,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":45,"_100":101},"ctx",{"_84":-5,"_130":207,"_208":209,"_210":211,"_212":25,"_213":25,"_214":25,"_215":60,"_216":-5,"_217":-7,"_218":-7,"_219":74,"_220":25,"_221":25,"_222":-5,"_223":25,"_224":25,"_225":25,"_226":-5},"ENV",{"_178":179,"_180":181,"_182":92,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206},"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 · v62