/** @jsxImportSource https://esm.sh/react */ import { renderToString } from "https://esm.sh/react-dom@18.2.0/server"; import { sqlite } from "https://esm.town/v/std/sqlite?v=4"; import { html } from "https://esm.town/v/stevekrouse/html"; sqlite.execute(`CREATE TABLE IF NOT EXISTS feedback ( id INTEGER PRIMARY KEY AUTOINCREMENT, email TEXT NOT NULL, sentiment TEXT NOT NULL, job_title TEXT, primary_issue TEXT, feature_requests TEXT, target_demographic TEXT, benefits TEXT, discovery_source TEXT, additional_thoughts TEXT )`); async function addFeedback(req: Request) { const formData = await req.formData(); let data = Object.fromEntries(formData.entries()); console.log(JSON.stringify(data, null, 2)); const email = formData.get("email"); const sentiment = formData.get("sentiment"); const job_title = formData.get("job-title"); const primary_issue = formData.get("primary-issue"); const feature_requests = formData.get("feature-requests"); const target_demographic = formData.get("target-demographic"); const benefits = formData.get("benefits"); const discovery_source = formData.get("discovery-source"); const additional_thoughts = formData.get("additional-thoughts"); await sqlite.execute({ sql: `INSERT INTO feedback (email, sentiment, job_title, primary_issue, feature_requests, target_demographic, benefits, discovery_source, additional_thoughts) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`, args: [ email, sentiment, job_title, primary_issue, feature_requests, target_demographic, benefits, discovery_source, additional_thoughts, ], }); } export let feedback_form = async (req: Request): Promise => { if (req.method === "POST") { await addFeedback(req); return new Response("Thanks for your submission!"); } const formPage = ( Reflect Annual Review 2023

Reflect Annual Review 2023

{/* Email Field */}

{/* Sentiment Field */}

How would you feel if you could no longer use Reflect?

Very disappointed Somewhat disappointed Not disappointed

{/* Job Title Field */}

What's your job title?

{/* Primary Issue Field */}

What is your #1 must fix bug, annoyance, or issue?

{/* Feature Requests Field */}

What are your top three feature requests or improvements you think we should make?

{/* Target Demographic Field */}

What type of people do you think would most benefit from Reflect?

{/* Benefits Field */}

What is the main benefit you receive from Reflect?

{/* Discovery Source Field */}

If you can remember, where did you first hear about Reflect?

{/* Additional Thoughts Field */}

Any other thoughts?

{/* Submit Button */}

); return html(renderToString(formPage)); };

annual_feedback