{props.children}

\n \n \n );\n};\n\nconst Top: FC<{}> = async () => {\n const publicWishes = await sqlite.execute(\n \"SELECT wish, created_at FROM wishes WHERE is_public = 1 ORDER BY created_at DESC LIMIT 50\"\n );\n \n return (\n \n

🌙

Wish Upon the Stars

Cast your dreams into the cosmos

\n \n \n

\n \n

🌟

Your wish has been received

\n If you'd like to receive one magical email from us when wishes come true, \n leave your contact below\n

\n \n \n

\n \n {publicWishes.rows.length > 0 && (\n

Wishes from Around the World

\n {publicWishes.rows.map((row) => (\n

{row.wish}

\n {new Date(row.created_at).toLocaleDateString('en-US', { \n month: 'long', \n day: 'numeric', \n year: 'numeric' \n })}\n

\n ))}\n

\n )}\n \n {publicWishes.rows.length === 0 && (\n

🌠

No wishes yet. Be the first to cast yours into the night sky.

\n )}\n \n );\n};\n\napp.get(\"/\", (c) => {\n return c.html();\n});\n\napp.post(\"/wish\", async (c) => {\n const body = await c.req.formData();\n const wish = String(body.get(\"wish\") ?? \"\").trim();\n const email = String(body.get(\"email\") ?? \"\").trim();\n const isPublic = body.get(\"is_public\") === \"1\" ? 1 : 0;\n \n if (!wish || !email) return c.text(\"Missing required fields\", 400);\n if (wish.length > 1000) return c.text(\"Wish exceeds maximum length\", 400);\n if (!/^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/.test(email)) return c.text(\"Invalid email format\", 400);\n \n await sqlite.execute(\n \"INSERT INTO wishes (wish, email, is_public) VALUES (?, ?, ?)\",\n [wish, email, isPublic]\n );\n \n return c.redirect(\"/\");\n});\n\nexport default app.fetch;","deleted","label",[99],"permalink","https://www.val.town/x/MadeiInGermany/Submit-A-Wish/code/main.tsx","extension","actionData","errors"]