\n {q.rows.map((i) => (\n \n

\n {i[0]}\n

{i[1]}

\n ))}\n \n \n ),\n }),\n );\n});\n\n// --- 2. THE WORKER (/api/manifest) ---\napp.get(\"/api/manifest\", async (c) => {\n const path = c.req.query(\"path\");\n const nodeRes = await sqlite.execute({\n sql:\n `SELECT s.name, s.idea, s.id FROM ${TABLES.SITES} s JOIN ${TABLES.PAGES} p ON s.id = p.site_id WHERE p.path = ?`,\n args: [path],\n });\n if (!nodeRes.rows[0]) return c.json({ error: \"State_Not_Found\" }, 404);\n const site = nodeRes.rows[0];\n\n const system = `2026 Architect. Site: ${site[0]}. Context: ${\n site[1]\n }. Output Raw content only.`;\n const prompt = path.endsWith(\".html\")\n ? `Write HTML for ${path}`\n : `JSON Array of 8 sub-nodes for ${site[0]}`;\n\n const result = await AI.synthesize(system, prompt);\n\n // Update the node state in the vault\n await sqlite.execute({\n sql: `UPDATE ${TABLES.PAGES} SET html = ?, generated = 1 WHERE path = ?`,\n args: [result.data, path],\n });\n\n return c.json({\n success: result.success,\n model: result.model,\n prompt: result.prompt_sent,\n error: result.error || null,\n });\n});\n\n// --- 3. THE RESOLVER ---\napp.get(\"/s/:slug/:node?\", async (c) => {\n const { slug } = c.req.param();\n const path = c.req.path.replace(/\\/+$/, \"\");\n const user = await Auth.getSession(c);\n\n const siteRes = await sqlite.execute({\n sql: `SELECT id, name FROM ${TABLES.SITES} WHERE slug = ?`,\n args: [slug],\n });\n if (!siteRes.rows[0]) return c.redirect(\"/\");\n const site = siteRes.rows[0];\n\n const nodeRes = await sqlite.execute({\n sql: `SELECT generated, html FROM ${TABLES.PAGES} WHERE path = ?`,\n args: [path],\n });\n const cached = nodeRes.rows[0];\n\n if (cached && cached[0] === 1) {\n return c.html(\n await UI.Layout({\n title: site[1],\n user,\n children: (\n \n ),\n }),\n );\n }\n\n // Pre-seed the node if it doesn't exist so the worker has something to update\n if (!cached) {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO ${TABLES.PAGES} (path, site_id, generated) VALUES (?, ?, 0)`,\n args: [path, site[0]],\n });\n }\n\n // Serve the Non-Blocking Terminal Sync Screen\n return c.html();\n});\n\nexport default app.fetch;","deleted","label",[99],"permalink","https://www.val.town/x/ziggyware/Save-to-db-working/code/main11.ts","extension","actionData","errors"]