\n setTitle(e.target.value)}\n required\n />\n setDescription(e.target.value)}\n />\n setFile(e.target.files[0])}\n required\n />\n \n \n );\n}\n\nfunction ArtGallery() {\n const [artworks, setArtworks] = useState([]);\n\n const fetchArtworks = async () => {\n try {\n const response = await fetch(\"/gallery\");\n if (response.ok) {\n const data = await response.json();\n setArtworks(data);\n }\n } catch (error) {\n console.error(\"Failed to fetch artworks:\", error);\n }\n };\n\n useEffect(() => {\n fetchArtworks();\n }, []);\n\n return (\n

Community Artworks 🖼️

\n {artworks.map((artwork) => (\n

\n \n

{artwork.title}

{artwork.description}

\n ))}\n

\n );\n}\n\nfunction App() {\n const [refreshGallery, setRefreshGallery] = useState(0);\n\n return (\n

ArtShare 🎨

\n setRefreshGallery(prev => prev + 1)}\n />\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 = \"artShareApp\";\n const SCHEMA_VERSION = 1;\n\n // Ensure table exists\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_artworks_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT,\n image_path TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Handle file upload\n if (request.method === \"POST\" && new URL(request.url).pathname === \"/upload\") {\n try {\n const formData = await request.formData();\n const title = formData.get(\"title\") as string;\n const description = formData.get(\"description\") as string;\n const file = formData.get(\"artwork\") as File;\n\n if (!file) {\n return new Response(\"No file uploaded\", { status: 400 });\n }\n\n // Generate a unique filename\n const filename = `artwork_${Date.now()}_${file.name}`;\n const filePath = `/tmp/${filename}`;\n\n // Write file to temporary storage\n const arrayBuffer = await file.arrayBuffer();\n await Deno.writeFile(filePath, new Uint8Array(arrayBuffer));\n\n // Save artwork metadata to SQLite\n await sqlite.execute(\n `INSERT INTO ${KEY}_artworks_${SCHEMA_VERSION} \n (title, description, image_path) VALUES (?, ?, ?)`,\n [title, description, filePath],\n );\n\n return new Response(\"Upload successful\", { status: 200 });\n } catch (error) {\n console.error(\"Upload error:\", error);\n return new Response(\"Upload failed\", { status: 500 });\n }\n }\n\n // Fetch gallery\n if (request.method === \"GET\" && new URL(request.url).pathname === \"/gallery\") {\n try {\n const result = await sqlite.execute(\n `SELECT id, title, description, image_path \n FROM ${KEY}_artworks_${SCHEMA_VERSION} \n ORDER BY created_at DESC LIMIT 50`,\n );\n\n // Convert image paths to base64 for client\n const artworks = await Promise.all(result.rows.map(async (row) => {\n const imageBuffer = await Deno.readFile(row.image_path);\n const base64Image = btoa(\n String.fromCharCode.apply(null, new Uint8Array(imageBuffer)),\n );\n\n return {\n id: row.id,\n title: row.title,\n description: row.description,\n imageUrl: `data:image/jpeg;base64,${base64Image}`,\n };\n }));\n\n return new Response(JSON.stringify(artworks), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (error) {\n console.error(\"Gallery fetch error:\", error);\n return new Response(\"Failed to fetch gallery\", { status: 500 });\n }\n }\n\n // Serve HTML\n return new Response(\n `\n \n \n ArtShare\n \n \n \n

\n \n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}\n\nconst css = `\nbody {\n font-family: 'Arial', sans-serif;\n max-width: 800px;\n margin: 0 auto;\n padding: 20px;\n background-color: #f4f4f4;\n}\n\n.art-share-app {\n background: white;\n padding: 20px;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n}\n\n.art-upload-form {\n display: flex;\n flex-direction: column;\n gap: 10px;\n margin-bottom: 20px;\n}\n\n.art-upload-form input, \n.art-upload-form textarea {\n padding: 10px;\n border: 1px solid #ddd;\n border-radius: 4px;\n}\n\n.gallery-grid {\n display: grid;\n grid-template-columns: repeat(auto-fill, minmax(200px, 1fr));\n gap: 15px;\n}\n\n.artwork-card {\n background: #f9f9f9;\n border-radius: 8px;\n overflow: hidden;\n box-shadow: 0 2px 4px rgba(0,0,0,0.1);\n}\n\n.artwork-card img {\n width: 100%;\n height: 250px;\n object-fit: cover;\n}\n\n.artwork-details {\n padding: 10px;\n}\n\nbutton {\n background-color: #4CAF50;\n color: white;\n border: none;\n padding: 10px 15px;\n border-radius: 4px;\n cursor: pointer;\n transition: background-color 0.3s;\n}\n\nbutton:hover {\n background-color: #45a049;\n}\n`;","deleted","label",[99],"permalink","https://www.val.town/x/Omar1163/artShareApp/code/main.tsx","extension","actionData","errors"]