👗 Fashion Outfit Rater 👠

\n\n \n setOutfitName(e.target.value)}\n style={{ width: \"100%\", padding: \"10px\" }}\n />\n\n \n\n {image && (\n \n )}\n\n

\n Rating: {rating}/5\n setRating(Number(e.target.value))}\n style={{ width: \"100%\" }}\n />\n

\n\n \n Submit Outfit\n \n\n {submitMessage && (\n

\n {submitMessage}\n

\n )}\n \n\n

Previous Outfits

\n \n {outfits.map((outfit, index) => (\n \n \n

{outfit.name}

⭐ Rating: {outfit.rating}/5

\n \n ))}\n \n\n \n View Source\n \n \n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"NEW\";\n const SCHEMA_VERSION = 1;\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_outfits_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n image TEXT NOT NULL,\n rating INTEGER NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Handle outfit retrieval\n if (request.method === \"GET\" && new URL(request.url).pathname.endsWith(\"outfits\")) {\n const outfits = await sqlite.execute(\n `SELECT name, image, rating FROM ${KEY}_outfits_${SCHEMA_VERSION} ORDER BY timestamp DESC LIMIT 10`,\n );\n\n return new Response(JSON.stringify(outfits.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Handle outfit submission\n if (request.method === \"POST\") {\n try {\n const { image, outfitName, rating } = await request.json();\n\n await sqlite.execute(\n `INSERT INTO ${KEY}_outfits_${SCHEMA_VERSION} (name, image, rating) VALUES (?, ?, ?)`,\n [outfitName, image, rating],\n );\n\n return new Response(\"Outfit successfully submitted! 🎉\", { status: 200 });\n } catch (error) {\n return new Response(`Error: ${error.message}`, { status: 500 });\n }\n }\n\n return new Response(\n `\n \n \n Fashion Outfit Rater\n \n \n \n

\n \n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}","deleted","label",[99],"permalink","https://www.val.town/x/meedarhh/NEW/code/main.tsx","extension","actionData","errors"]