[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_215":216,"_217":218},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_164":-5,"_20":165,"_22":166,"_167":168,"_169":170,"_26":171,"_24":172,"_173":-5,"_174":-5,"_175":52,"_176":177,"_178":43,"_179":-5,"_180":-5,"_181":182},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","wilhelm","name","wotd","branchName","main","version","path","init-db","project",{"_33":110,"_13":14,"_44":111,"_112":-5,"_113":52,"_114":115,"_116":115,"_117":-5,"_118":-5,"_119":120,"_121":76,"_122":43,"_123":43,"_124":-5,"_125":126,"_127":128,"_129":-5,"_130":-5,"_131":-5,"_132":-5,"_133":134,"_135":134,"_136":137,"_138":137,"_139":137,"_140":134,"_141":134,"_142":143,"_144":145,"_146":147,"_148":52},"tree",[55,56,57,58,59],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_18":54},"contents",[],"upstream","pull","ahead","behind","envVars","id","c327167a-ed41-11ef-ab4a-e6cdfca9ef9f","fileId","da7ce310-ed26-11ef-b913-e6cdfca9ef9f","parentId","branchId","b9e9e846-ed26-11ef-b7ed-e6cdfca9ef9f","branchVersion",39,"latest",true,"createdAt",["D",1739805217451],9,"fileType","script","content","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')`);","deleted",false,"label",[19],{"_33":92,"_13":93,"_35":94,"_37":-5,"_38":39,"_40":95,"_42":43,"_44":96,"_17":88,"_47":97,"_49":-5,"_51":52,"_53":-5,"_68":98,"_18":99},{"_33":83,"_13":84,"_35":85,"_37":-5,"_38":39,"_40":86,"_42":43,"_44":87,"_17":88,"_47":24,"_49":89,"_51":52,"_53":-5,"_68":90,"_18":91},{"_33":74,"_13":75,"_35":76,"_37":-5,"_38":39,"_40":77,"_42":43,"_44":78,"_17":79,"_47":66,"_49":80,"_51":52,"_53":-5,"_68":81,"_18":82},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":71,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_68":72,"_18":73},{"_33":60,"_13":61,"_35":62,"_37":-5,"_38":39,"_40":63,"_42":43,"_44":64,"_17":65,"_47":66,"_49":67,"_51":52,"_53":-5,"_68":69,"_18":70},"777dd92e-ed42-11ef-aa52-e6cdfca9ef9f","sign-up","7a818258-ed27-11ef-a41d-e6cdfca9ef9f",44,["D",1739805519999],21,"http","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}","children",[],[61],["D",1739805217451],[],[19],"e070f9c2-ed45-11ef-b388-e6cdfca9ef9f","index","6b00f888-ed43-11ef-a2b7-e6cdfca9ef9f",81,["D",1739806984574],30,"/** @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;",[],[75],"cf9205a2-ed26-11ef-8aaa-e6cdfca9ef9f","README.md","bb7d4b94-ed26-11ef-8f24-e6cdfca9ef9f",2,["D",1739793641872],1,"# Word of the Day\n\nSign up and get an email every day with the word of the day in your preferred language.",[],[84],"4a3c52a6-ed42-11ef-8d29-e6cdfca9ef9f","templates","4638623a-ed42-11ef-8ad2-e6cdfca9ef9f",41,["D",1739805444077],"directory",[100],[93],{"_33":101,"_13":102,"_35":103,"_37":94,"_38":39,"_40":104,"_42":43,"_44":105,"_17":106,"_47":24,"_49":107,"_51":52,"_53":-5,"_68":108,"_18":109},"4bd7c9ba-ed42-11ef-85aa-e6cdfca9ef9f","index.html","04c13dba-ed36-11ef-a8f3-e6cdfca9ef9f",42,["D",1739805446774],4,"\n \n Word of the day\n \n \n \n

Word of the day signup

\n \n

\n \n ",[],[93,102],"b9e9a4c6-ed26-11ef-b7ed-e6cdfca9ef9f",["D",1739793605539],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","ecbce1e5-343d-483e-99fe-bc35afe6b93a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","a22192bb-4fed-4a1b-9182-d6c09e531cf8","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_163":159},"org",{"_11":12,"_157":-5,"_158":159,"_119":120,"_160":161,"_162":52},"branch",{"_17":77,"_13":16,"_33":39,"_149":110,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":-5,"_155":14,"_156":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJwUXQza21ONmFtMEtyWFAxa3gzV3dTbGdXTSJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":110,"_13":14,"_44":211,"_112":-5,"_113":52,"_114":115,"_116":115,"_117":-5,"_118":-5,"_119":120,"_121":76,"_122":43,"_123":43,"_124":-5,"_125":126,"_127":128,"_129":-5,"_130":-5,"_131":-5,"_132":-5,"_133":134,"_135":134,"_136":137,"_138":137,"_139":137,"_140":134,"_141":134,"_142":212,"_144":213,"_146":214,"_148":52},[193,195,196,197,198],"files",[193,194,195,196,197,198],"counts",{"_184":126,"_185":88,"_186":126,"_32":187,"_188":189},[],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_18":183},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],"pulls","branches","forks",{"_190":126,"_192":126},"connections",{"_190":126,"_191":126},"count","unfilledCount","emptyCount",{"_33":92,"_13":93,"_35":94,"_37":-5,"_38":39,"_40":95,"_42":43,"_44":96,"_17":88,"_47":97,"_49":-5,"_51":52,"_53":-5,"_68":209,"_18":210},{"_33":101,"_13":102,"_35":103,"_37":94,"_38":39,"_40":104,"_42":43,"_44":105,"_17":106,"_47":24,"_49":107,"_51":52,"_53":-5,"_68":207,"_18":208},{"_33":83,"_13":84,"_35":85,"_37":-5,"_38":39,"_40":86,"_42":43,"_44":87,"_17":88,"_47":24,"_49":89,"_51":52,"_53":-5,"_68":205,"_18":206},{"_33":74,"_13":75,"_35":76,"_37":-5,"_38":39,"_40":77,"_42":43,"_44":78,"_17":79,"_47":66,"_49":80,"_51":52,"_53":-5,"_68":203,"_18":204},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":71,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_68":201,"_18":202},{"_33":60,"_13":61,"_35":62,"_37":-5,"_38":39,"_40":63,"_42":43,"_44":64,"_17":65,"_47":66,"_49":67,"_51":52,"_53":-5,"_68":199,"_18":200},[],[61],[],[19],[],[75],[],[84],[],[93,102],[194],[93],["D",1739793605539],{"_11":12,"_163":159},{"_11":12,"_157":-5,"_158":159,"_119":120,"_160":161,"_162":52},{"_17":77,"_13":16,"_33":39,"_149":110,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":-5,"_155":14,"_156":12},"ctx",{"_142":-5,"_180":248,"_249":250,"_251":252,"_253":52,"_254":52,"_255":52,"_256":43,"_257":-5,"_258":-7,"_259":-7,"_260":126,"_261":52,"_262":52,"_263":-5,"_264":52,"_265":52,"_266":52,"_267":-5},"ENV",{"_219":220,"_221":222,"_223":16,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247},"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"]