Coffee Shop Reviewer

\n setSearchTerm(e.target.value)}\n placeholder=\"Search for coffee shops\"\n />\n \n

Search Results

setSelectedShop(shop)}>\n {shop.name} - {shop.address}, {shop.city}\n

\n {selectedShop && (\n

Add Review for {selectedShop.name}

\n \n

\n )}\n

Coffee Shop Reviews

\n
{review.name}
\n
Address: {review.address}, {review.city}
\n
Coffee Machine: {review.coffeeMachineBrand}
\n
Latte Art Consistency: {review.latteArtConsistency}/10
\n
Roasts Own Beans: {review.roastOwnBeans ? \"Yes\" : \"No\"}
\n
Additional Notes: {review.additionalNotes}
\n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nasync function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const url = new URL(request.url);\n const KEY = \"hungryWhiteLeopon\";\n const SCHEMA_VERSION = 2; // Increment this when changing the schema\n\n console.log(\"Received request for:\", url.pathname);\n\n try {\n // Create table if it doesn't exist\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_coffee_reviews_${SCHEMA_VERSION} (\n id TEXT PRIMARY KEY,\n name TEXT,\n address TEXT,\n city TEXT,\n coffeeMachineBrand TEXT,\n latteArtConsistency INTEGER,\n roastOwnBeans INTEGER,\n additionalNotes TEXT\n )\n `);\n console.log(\"Table checked/created successfully\");\n\n if (url.pathname === \"/api/coffee-shops\") {\n const searchTerm = url.searchParams.get(\"search\") || \"\";\n // Fetch coffee shops from OpenStreetMap Nominatim API\n const nominatimUrl = `https://nominatim.openstreetmap.org/search?q=coffee+${\n encodeURIComponent(searchTerm)\n }&format=json&addressdetails=1`;\n const nominatimResponse = await fetch(nominatimUrl, {\n headers: {\n \"User-Agent\": \"CoffeeShopReviewer/1.0\",\n },\n });\n if (!nominatimResponse.ok) {\n throw new Error(`Nominatim API error! status: ${nominatimResponse.status}`);\n }\n const nominatimData = await nominatimResponse.json();\n if (!Array.isArray(nominatimData)) {\n throw new Error(\"Invalid data received from Nominatim API\");\n }\n const coffeeShops = nominatimData.map((shop: any) => ({\n id: shop.place_id.toString(),\n name: shop.name || \"Unnamed Coffee Shop\",\n address: shop.address?.road || shop.display_name,\n city: shop.address?.city || shop.address?.town || shop.address?.village || \"\",\n }));\n return new Response(JSON.stringify(coffeeShops), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (url.pathname === \"/api/reviews\") {\n if (request.method === \"GET\") {\n const reviews = await sqlite.execute(`SELECT * FROM ${KEY}_coffee_reviews_${SCHEMA_VERSION}`);\n console.log(\"Fetched reviews:\", reviews.rows);\n return new Response(JSON.stringify(reviews.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } else if (request.method === \"POST\") {\n const review = await request.json();\n console.log(\"Received review:\", review);\n\n if (!review.id || !review.name || !review.address || !review.city) {\n throw new Error(\"Missing required fields in review data\");\n }\n\n const result = await sqlite.execute(\n `\n INSERT OR REPLACE INTO ${KEY}_coffee_reviews_${SCHEMA_VERSION}\n (id, name, address, city, coffeeMachineBrand, latteArtConsistency, roastOwnBeans, additionalNotes)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n `,\n [\n review.id,\n review.name,\n review.address,\n review.city,\n review.coffeeMachineBrand || null,\n review.latteArtConsistency || null,\n review.roastOwnBeans ? 1 : 0,\n review.additionalNotes || null,\n ],\n );\n\n console.log(\"Insert result:\", result);\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n\n // Serve HTML for all other routes\n return new Response(\n `\n \n \n \n \n \n Coffee Shop Reviewer\n \n \n \n

\n \n \n \n `,\n {\n headers: {\n \"content-type\": \"text/html\",\n },\n },\n );\n } catch (error) {\n console.error(\"Server error:\", error);\n return new Response(\n JSON.stringify({\n error: \"Internal Server Error\",\n message: error.message,\n stack: error.stack,\n }),\n {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n}\n\nconst css = `\n body {\n font-family: Arial, sans-serif;\n line-height: 1.6;\n margin: 0;\n padding: 20px;\n background-color: #f4f4f4;\n }\n .container {\n max-width: 800px;\n margin: 0 auto;\n background-color: #fff;\n padding: 20px;\n border-radius: 5px;\n box-shadow: 0 0 10px rgba(0,0,0,0.1);\n }\n h1, h2 {\n color: #333;\n }\n input[type=\"text\"], input[type=\"number\"], textarea {\n width: 100%;\n padding: 8px;\n margin-bottom: 10px;\n border: 1px solid #ddd;\n border-radius: 4px;\n }\n button {\n background-color: #5cb85c;\n color: white;\n border: none;\n padding: 10px 15px;\n cursor: pointer;\n border-radius: 4px;\n }\n button:hover {\n background-color: #4cae4c;\n }\n ul {\n list-style-type: none;\n padding: 0;\n }\n li {\n background-color: #f9f9f9;\n margin-bottom: 10px;\n padding: 10px;\n border-radius: 4px;\n }\n .search-section, .results-section, .review-form, .reviews-section {\n margin-bottom: 20px;\n }\n`;\n\nexport default server;","deleted","label",[98],"permalink","https://www.val.town/x/gr8gatsby/hungryWhiteLeopon/code/main.tsx","extension","actionData","errors"]

Coffee Shop Reviewer

Search Results

Add Review for {selectedShop.name}

Coffee Shop Reviews

{review.name}