ARTIFACT // SUPREME

')`,\n });\n}\n\n// --- API LAYER ---\napp.get(\"/api/feed\", async (c) => {\n await boot();\n const res = await sqlite.execute(\n `SELECT * FROM ${SCHEMA}_posts ORDER BY ts DESC LIMIT 30`,\n );\n return c.json(res.rows.map((r) => ({\n id: r.id,\n title: r.title,\n content: r.content,\n ts: Number(r.ts),\n spark: Number(r.spark),\n glitch: Number(r.glitch),\n })));\n});\n\napp.get(\"/api/fixes\", async (c) => {\n const res = await sqlite.execute(`SELECT * FROM ${SCHEMA}_fixes`);\n return c.json(res.rows);\n});\n\napp.post(\"/api/publish\", async (c) => {\n const { title, content } = await c.req.json();\n await sqlite.execute({\n sql:\n `INSERT INTO ${SCHEMA}_posts (id, title, content, ts) VALUES (?, ?, ?, ?)`,\n args: [\n crypto.randomUUID(),\n title || \"PROTOCOL_UNDEFINED\",\n content,\n Date.now(),\n ],\n });\n return c.json({ ok: true });\n});\n\napp.post(\"/api/vote\", async (c) => {\n const { id, type } = await c.req.json();\n const col = type === \"spark\" ? \"spark\" : \"glitch\";\n await sqlite.execute({\n sql: `UPDATE ${SCHEMA}_posts SET ${col} = ${col} + 1 WHERE id = ?`,\n args: [id],\n });\n return c.json({ ok: true });\n});\n\n// --- INTERFACE LAYER ---\napp.get(\"/\", (c) => {\n return c.html(`\n\n\n \n \n ARTIFACT // SUPREME\n \n \n \n \n \n\n\n

\n\n \n\n`);\n});\n\nexport default async (req: Request): Promise => {\n return await app.fetch(req);\n};","deleted","label",[99],"permalink","https://www.val.town/x/ziggyware/untitled-9015/code/main.ts","extension","actionData","errors"]