\n AMA\n

\n Ask me ({name}) anything.\n

\n {content}\n

\n \n \n \n);\n\n// TODO: include updated too?\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ama (question TEXT, answer TEXT, secret TEXT, created_at TEXT, id TEXT)`,\n);\n\n/**\n * Serve all /frontend files. There is just one.\n */\napp.get(\"/static/**/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n/**\n * The main page, where you can see questions other people have asked and\n * ask a new question if you want to.\n */\napp.get(\"/\", async (c) => {\n const questions = await sqlite.execute(\n `SELECT * from ama WHERE answer IS NOT NULL ORDER BY created_at DESC;`,\n );\n\n const d = new Intl.DateTimeFormat(\"en-US\");\n\n return c.html(\n layout(\n <>\n \n\n {questions.rows.map((question) => (\n

Question: {question.question}

\n Answer: {question.answer}\n
\n \n {d.format(new Date(question.created_at as string))}\n \n \n ♥\n \n

\n ))}\n ,\n ),\n );\n});\n\n/**\n * This is for the 'admin' of the AMA - you get a link to this page in your email,\n * and it contains a ?secret= query parameter that lets you view and answer\n * a specific AMA. That secret is how the whole thing works with no 'authentication'.\n */\napp.get(\"/answer\", async (c) => {\n const secret = c.req.query(\"secret\");\n if (!secret) return c.html(

No secret provided

);\n const questions = await sqlite.execute({\n sql: `SELECT * from ama WHERE secret = ?;`,\n args: [secret],\n });\n const question = questions.rows.at(0);\n if (!question) return c.html(

No question found

);\n return c.html(\n layout(\n <>\n Question: {question.question}\n\n \n ,\n ),\n );\n});\n\n/**\n * This is just here for helping you test the layout, it's a development thing,\n * you can ignore it.\n */\napp.get(\"/test-banner\", async (c) => {\n return c.html(\n layout(

Test banner

),\n );\n});\n\n/**\n * When the 'admin' submits a new answer, this is the URL it is submitted to.\n * Like the previous page, this uses the ?secret= value as a way to do authentication\n * without much fuss.\n */\napp.post(\"/answer\", async (c) => {\n const body: FormData = await c\n .req\n .formData();\n\n const answer = String(body.get(\"answer\"));\n const secret = String(body.get(\"secret\"));\n if (!secret) return c.html(

No secret provided

);\n await sqlite.execute({\n sql: `UPDATE ama SET answer = ? WHERE secret = ?;`,\n args: [answer, secret],\n });\n return c.html(\n layout(

Answer recorded!

),\n );\n});\n\n/**\n * When someone submits a new AMA, this is the URL it is submitted to.\n *\n * This sends the email, too!\n */\napp.post(\"/\", async (c) => {\n const body: FormData = await c\n .req\n .formData();\n const url = new URL(c.req.url);\n url.pathname = \"/answer\";\n const userAgent = c.req.header(\"User-Agent\");\n const question = String(body.get(\"question\"));\n\n const secret = crypto.randomUUID();\n\n url.searchParams.set(\"secret\", secret);\n\n await sqlite.execute({\n sql:\n \"INSERT INTO ama (question, secret, created_at, id) VALUES (?, ?, ?, ?)\",\n args: [question, secret, new Date().toISOString(), crypto.randomUUID()],\n });\n\n const blockBg = \"#eee\";\n\n let html =\n `

Someone asked an AMA question on Val Town! Do you want to answer it? this val on Val Town.

`;\n\n html += `\n

${question}

\n Want to answer it?\n\n
\n User agent: ${userAgent}\n `;\n\n html += \"\";\n\n await email(\n {\n subject: `A new AMA question!`,\n html,\n },\n );\n return c.html(\n layout(

Question asked!

),\n );\n});\n\nexport default app.fetch;","deleted","label","tmcw-ama",[98],"permalink","https://www.val.town/x/tmcw/AMA/code/ama.tsx","extension","actionData","errors"]