${\n site[0]\n }

` +\n nodes.map((n: any) =>\n `${n.title}`\n ).join(\"\") + `

`;\n }\n\n // SUCCESS: Uses OR REPLACE to prevent unique constraint errors on primary key 'path'\n await sqlite.execute({\n sql: `UPDATE ${TABLES.PAGES} SET html = ?, generated = 1 WHERE path = ?`,\n args: [html, path],\n });\n return c.json({ success: true, model: \"gemini-3-pro\" });\n } catch (e) {\n return c.json({ success: false, error: \"VOID_TIMEOUT\" }, 500);\n }\n});\n\n// --- 2. NEXUS ---\napp.get(\"/\", async (c) => {\n await DB.init();\n const user = await Auth.getSession(c);\n let q = await sqlite.execute(\n `SELECT name, idea FROM ${TABLES.QUEUE} WHERE manifested = 0 LIMIT 10`,\n );\n\n if (q.rows.length === 0) {\n const raw = await AI.synthesize(\n \"JSON ARRAY ONLY\",\n \"10 side-hustles for 2026.\",\n );\n const ideas = DB.parseArray(raw);\n for (const i of ideas) {\n // Use INSERT OR IGNORE to prevent slug collision crashes\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO ${TABLES.QUEUE} (name, slug, idea) VALUES (?, ?, ?)`,\n args: [i.title, i.slug, i.idea],\n });\n }\n q = await sqlite.execute(\n `SELECT name, idea FROM ${TABLES.QUEUE} WHERE manifested = 0 LIMIT 10`,\n );\n }\n\n return c.html(\n await UI.Layout({\n title: \"Nexus\",\n user,\n children: (\n

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

\n {i[0]}\n

{i[1]}

\n ))}\n

\n \n \n ),\n }),\n );\n});\n\n// --- 3. CREATE ---\napp.post(\"/create\", async (c) => {\n const user = await Auth.getSession(c);\n const { idea } = await c.req.parseBody();\n const raw = await AI.synthesize(\n 'JSON: {\"name\":\"\",\"slug\":\"\"}',\n `Metadata for: ${idea}`,\n );\n const meta = JSON.parse(raw.replace(/```[a-z]*|\\n```/gi, \"\") || \"{}\");\n\n // FIXED: Appends entropy salt to guarantee uniqueness in SITES table\n const slug = DB.formatSlug(meta.slug || meta.name || idea, true);\n\n // Use OR IGNORE just in case of astronomical salt collision\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO ${TABLES.SITES} (name, slug, idea, creator_id) VALUES (?, ?, ?, ?)`,\n args: [meta.name || \"New Reality\", slug, idea, user ? user[0] : null],\n });\n\n return c.redirect(`/s/${slug}`);\n});\n\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\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: slug,\n user,\n children: (\n \n ),\n }),\n );\n }\n\n // Use INSERT OR IGNORE to prevent unique path collision during multi-click\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, siteRes.rows[0][0]],\n });\n }\n\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/main19.ts","extension","actionData","errors"]