${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 const secret = c.req.query(\"secret\");\n\n if (secret !== Deno.env.get(\"MODERATOR_SECRET\")) {\n return c.json({ error: \"Not authorized to approve\" }, 401);\n }\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 const secret = c.req.query(\"secret\");\n\n if (secret !== Deno.env.get(\"MODERATOR_SECRET\")) {\n return c.json({ error: \"Not authorized to reject\" }, 401);\n }\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;",[],[175],{"_103":185,"_95":186,"_154":187,"_156":-5,"_157":139,"_158":100,"_160":22,"_105":188,"_99":32,"_164":189,"_166":72,"_168":22,"_169":-5,"_170":190,"_98":191},"93aa209c-a540-11f0-9ef3-0224a6c84d84","new-file-1994.ts","93aa2178-a540-11f0-9ef3-0224a6c84d84",["D",1760035722222],"script",[],[186],{"_103":193,"_95":194,"_154":195,"_156":-5,"_157":139,"_158":196,"_160":161,"_105":197,"_99":198,"_164":189,"_166":199,"_168":22,"_169":-5,"_170":200,"_98":201},"89fb87b6-a13a-11f0-87bc-0224a6c84d84","sqlite.ts","8e80064c-a124-11f0-a83f-0224a6c84d84",62,["D",1759593324349],21,"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;`));",[],[194],"files",[151,173,184,192],"counts",{"_206":32,"_207":208,"_209":32,"_210":211},"pulls","branches",1,"forks","envVars",{"_212":208,"_213":32},"count","emptyCount","contents",[216,219,222,225],{"_103":152,"_95":153,"_154":155,"_156":-5,"_157":139,"_158":159,"_160":161,"_105":217,"_99":163,"_164":165,"_166":167,"_168":22,"_169":-5,"_98":218},["D",1759598413750],[153],{"_103":174,"_95":175,"_154":176,"_156":-5,"_157":139,"_158":177,"_160":161,"_105":220,"_99":179,"_164":180,"_166":181,"_168":22,"_169":96,"_98":221},["D",1759603153407],[175],{"_103":185,"_95":186,"_154":187,"_156":-5,"_157":139,"_158":100,"_160":22,"_105":223,"_99":32,"_164":189,"_166":72,"_168":22,"_169":-5,"_98":224},["D",1760035722222],[186],{"_103":193,"_95":194,"_154":195,"_156":-5,"_157":139,"_158":196,"_160":161,"_105":226,"_99":198,"_164":189,"_166":199,"_168":22,"_169":-5,"_98":227},["D",1759593324349],[194],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_101":236,"_99":100,"_241":242},{"_103":104,"_95":96,"_105":237,"_107":-5,"_108":22,"_109":110,"_111":112,"_113":114,"_14":115,"_116":-5,"_117":22,"_118":-5,"_119":32,"_16":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":238,"_133":239,"_136":240,"_148":22},["D",1759582153490],{"_93":94,"_131":132},{"_93":94,"_135":132,"_14":115},{"_99":138,"_95":43,"_103":139,"_140":104,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},"changes",[243],{"_165":244,"_246":-7,"_168":161,"_98":186,"_247":248},{"_154":187,"_95":186,"_164":189,"_166":72,"_105":245,"_158":100,"_157":139},["D",1760035722222],"previous","latestPath","test.ts","actionData","errors"]

petermillspaugh

tld-wiki