Word of the day signup

\n \n

\n \n ",[],[150,170],[150],{"_102":181,"_95":182,"_151":183,"_153":-5,"_154":136,"_155":184,"_157":158,"_104":185,"_99":160,"_161":175,"_163":186,"_164":22,"_165":-5,"_166":187,"_98":188},"cf9205a2-ed26-11ef-8aaa-e6cdfca9ef9f","README.md","bb7d4b94-ed26-11ef-8f24-e6cdfca9ef9f",2,["D",1739793641872],"# Word of the Day\n\nSign up and get an email every day with the word of the day in your preferred language.",[],[182],{"_102":190,"_95":191,"_151":192,"_153":-5,"_154":136,"_155":135,"_157":158,"_104":193,"_99":194,"_161":195,"_163":196,"_164":22,"_165":-5,"_166":197,"_98":198},"e070f9c2-ed45-11ef-b388-e6cdfca9ef9f","index","6b00f888-ed43-11ef-a2b7-e6cdfca9ef9f",["D",1739806984574],30,"http","/** @jsxImportSource npm:hono/jsx */\nimport { Hono } from \"npm:hono\";\nimport { type FC } from \"npm:hono/jsx\";\n\nconst app = new Hono();\n\nconst Layout: FC = ({ children }) => {\n return (\n \n \n Word of the day\n \n \n \n

\n {children}\n

\n \n \n );\n};\n\nconst SignUpForm = () => {\n return (\n <>\n

Word of the day signup

\n \n \n )\n}\n\napp.get(\"/\", async (c) =>\n c.html(\n \n \n ,\n ));\n\napp.post(\"/signup\", async (c) => {\n const formdata = await c.req.formData();\n if (!formdata.get(\"email\")) {\n return c.html(

Missing email

, { status: 400 });\n }\n if (!formdata.get(\"name\")) {\n return c.html(

Missing name

, { status: 400 });\n }\n\n const email = formdata.get(\"email\") as string;\n const name = formdata.get(\"name\") as string;\n const lang = formdata.get(\"lang\") ?? \"en\" as string;\n\n return c.html(\n \n

Thanks for signing up, {name} ({email})

\n \n );\n});\n\nexport default app.fetch;",[],[191],{"_102":200,"_95":201,"_151":202,"_153":-5,"_154":136,"_155":203,"_157":158,"_104":204,"_99":205,"_161":206,"_163":207,"_164":22,"_165":-5,"_166":208,"_98":209},"c327167a-ed41-11ef-ab4a-e6cdfca9ef9f","init-db","da7ce310-ed26-11ef-b913-e6cdfca9ef9f",39,["D",1739805217451],9,"script","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// await sqlite.execute(`drop table emails`);\nawait sqlite.execute(`CREATE TABLE subscribers (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT NOT NULL UNIQUE,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n)`);\n\nawait sqlite.execute(`CREATE TABLE languages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE,\n code TEXT NOT NULL UNIQUE\n)`);\n\nawait sqlite.execute(`CREATE TABLE subscriptions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n subscriber_id INTEGER NOT NULL,\n language_id INTEGER NOT NULL,\n subscribed_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (subscriber_id) REFERENCES subscribers(id) ON DELETE CASCADE,\n FOREIGN KEY (language_id) REFERENCES languages(id) ON DELETE CASCADE,\n UNIQUE (subscriber_id, language_id) -- Prevent duplicate subscriptions\n)`);\n\n// await sqlite.execute(`insert into emails(key, name, lang) values('wilhelmberggren@gmail.com', 'Wilhelm', 'sv')`);",[],[201],{"_102":211,"_95":212,"_151":213,"_153":-5,"_154":136,"_155":214,"_157":158,"_104":215,"_99":216,"_161":195,"_163":217,"_164":22,"_165":-5,"_166":218,"_98":219},"777dd92e-ed42-11ef-aa52-e6cdfca9ef9f","sign-up","7a818258-ed27-11ef-a41d-e6cdfca9ef9f",44,["D",1739805519999],21,"import nunjucks from \"npm:nunjucks\";\n\nasync function servePublicFile(path: string): Promise {\n const url = new URL(\"./public/\" + path, import.meta.url);\n const text = await (await fetch(url, {\n headers: {\n \"User-Agent\": \"\", // to transpile TS to JS\n },\n })).text();\n const contentType = path.endsWith(\".html\") ? \"text/html\" : \"text/javascript\";\n return new Response(text, {\n headers: {\n \"Content-Type\": contentType,\n },\n });\n}\n\nexport default async function(req: Request): Promise {\n if (req.method === \"POST\") {\n const formdata = await req.formData();\n if (!formdata.get(\"email\")) {\n return new Response(\"Missing email\", { status: 400 });\n }\n if (!formdata.get(\"name\")) {\n return new Response(\"Missing name\", { status: 400 });\n }\n\n const email = formdata.get(\"email\") as string;\n const name = formdata.get(\"name\") as string;\n\n return new Response(`Thanks for signing up, ${name} (${email})`, { status: 200 });\n }\n\n const url = new URL(\"./templates/index.html\", import.meta.url);\n const text = await (await fetch(url, {\n headers: {\n \"User-Agent\": \"\", // to transpile TS to JS\n },\n })).text();\n return new Response(nunjucks.renderString(text, {}), {\n headers: {\n \"Content-Type\": \"text/html\",\n },\n });\n}",[],[212],"files",[148,168,180,189,199,210],"counts",{"_224":32,"_225":160,"_226":32,"_227":228},"pulls","branches","forks","envVars",{"_229":32,"_230":32},"count","emptyCount","contents",[233,236,239,242,245],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":156,"_157":158,"_104":234,"_99":160,"_161":162,"_163":-5,"_164":22,"_165":-5,"_98":235},["D",1739805444077],[150],{"_102":181,"_95":182,"_151":183,"_153":-5,"_154":136,"_155":184,"_157":158,"_104":237,"_99":160,"_161":175,"_163":186,"_164":22,"_165":-5,"_98":238},["D",1739793641872],[182],{"_102":190,"_95":191,"_151":192,"_153":-5,"_154":136,"_155":135,"_157":158,"_104":240,"_99":194,"_161":195,"_163":196,"_164":22,"_165":-5,"_98":241},["D",1739806984574],[191],{"_102":200,"_95":201,"_151":202,"_153":-5,"_154":136,"_155":203,"_157":158,"_104":243,"_99":205,"_161":206,"_163":207,"_164":22,"_165":-5,"_98":244},["D",1739805217451],[201],{"_102":211,"_95":212,"_151":213,"_153":-5,"_154":136,"_155":214,"_157":158,"_104":246,"_99":216,"_161":195,"_163":217,"_164":22,"_165":-5,"_98":247},["D",1739805519999],[212],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name._index",{"_93":94,"_95":96,"_97":-7,"_99":-7,"_100":256,"_231":261,"_272":273,"_276":-5,"_277":-5,"_220":278,"_297":298,"_299":-5,"_300":-5},{"_102":103,"_95":96,"_104":257,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":-5,"_114":22,"_115":-5,"_116":32,"_16":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":258,"_130":259,"_133":260,"_145":22},["D",1739793605539],{"_93":94,"_128":129},{"_93":94,"_132":129},{"_99":135,"_95":43,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},[262,264,266,268,270],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":156,"_157":158,"_104":234,"_99":160,"_161":162,"_163":-5,"_164":22,"_165":-5,"_98":263},[150],{"_102":181,"_95":182,"_151":183,"_153":-5,"_154":136,"_155":184,"_157":158,"_104":237,"_99":160,"_161":175,"_163":186,"_164":22,"_165":-5,"_98":265},[182],{"_102":190,"_95":191,"_151":192,"_153":-5,"_154":136,"_155":135,"_157":158,"_104":240,"_99":194,"_161":195,"_163":196,"_164":22,"_165":-5,"_98":267},[191],{"_102":200,"_95":201,"_151":202,"_153":-5,"_154":136,"_155":203,"_157":158,"_104":243,"_99":205,"_161":206,"_163":207,"_164":22,"_165":-5,"_98":269},[201],{"_102":211,"_95":212,"_151":213,"_153":-5,"_154":136,"_155":214,"_157":158,"_104":246,"_99":216,"_161":195,"_163":217,"_164":22,"_165":-5,"_98":271},[212],"readme",{"_102":181,"_95":182,"_151":183,"_153":-5,"_154":136,"_155":184,"_157":158,"_104":274,"_99":160,"_161":175,"_163":186,"_164":22,"_165":-5,"_98":275},["D",1739793641872],[182],"upstream","pull",[279,281,285,288,291,294],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":156,"_157":158,"_104":159,"_99":160,"_161":162,"_163":-5,"_164":22,"_165":-5,"_166":280,"_98":284},[281],{"_102":169,"_95":170,"_151":171,"_153":152,"_154":136,"_155":172,"_157":158,"_104":173,"_99":174,"_161":175,"_163":176,"_164":22,"_165":-5,"_166":282,"_98":283},[],[150,170],[150],{"_102":181,"_95":182,"_151":183,"_153":-5,"_154":136,"_155":184,"_157":158,"_104":185,"_99":160,"_161":175,"_163":186,"_164":22,"_165":-5,"_166":286,"_98":287},[],[182],{"_102":190,"_95":191,"_151":192,"_153":-5,"_154":136,"_155":135,"_157":158,"_104":193,"_99":194,"_161":195,"_163":196,"_164":22,"_165":-5,"_166":289,"_98":290},[],[191],{"_102":200,"_95":201,"_151":202,"_153":-5,"_154":136,"_155":203,"_157":158,"_104":204,"_99":205,"_161":206,"_163":207,"_164":22,"_165":-5,"_166":292,"_98":293},[],[201],{"_102":211,"_95":212,"_151":213,"_153":-5,"_154":136,"_155":214,"_157":158,"_104":215,"_99":216,"_161":195,"_163":217,"_164":22,"_165":-5,"_166":295,"_98":296},[],[212],"previews",[288,294],"ahead","behind","actionData","errors"]

wilhelm

wotd

Word of the Day