\n \n \n \n

\n ),\n }),\n );\n});\n\n// --- ROUTE: /s (PAGINATED DIRECTORY) ---\napp.get(\"/s\", async (c) => {\n const user = await Auth.getSession(c);\n const page = parseInt(c.req.query(\"page\") || \"0\");\n const limit = 10;\n\n const res = await sqlite.execute({\n sql: `SELECT s.*, u.username FROM ${TABLES.SITES} s \n LEFT JOIN ${TABLES.USERS} u ON s.creator_id = u.id \n ORDER BY s.ts DESC LIMIT ? OFFSET ?`,\n args: [limit, page * limit],\n });\n\n return c.html(\n await UI.Layout({\n title: \"Directory\",\n user,\n children: (\n

Realities.

\n {res.rows.map((s) => (\n \n \n AGENT: {s[5] || \"ANON_VOID\"}\n \n

\n {s[1]}\n

\n {new Date(s[4]).toLocaleDateString()} // SEQ_ID_{s[0]}\n

\n \n ))}\n

\n {page > 0 && (\n Prev_Batch\n )}\n Next_Batch\n

\n ),\n }),\n );\n});\n\n// --- ROUTE: /s/:sitename (RESOLVER) ---\napp.get(\"/s/:slug/:page?\", async (c) => {\n const { slug: rawSlug, page } = c.req.param();\n const path = c.req.path.replace(/\\/+$/, \"\");\n const user = await Auth.getSession(c);\n\n // Requirement: Format site name to match slug schema\n const slug = DB.formatSlug(rawSlug);\n\n const siteRes = await sqlite.execute({\n sql: `SELECT id, name, idea FROM ${TABLES.SITES} WHERE slug = ?`,\n args: [slug],\n });\n const site = siteRes.rows[0];\n if (!site) return c.redirect(\"/\");\n\n const nodeRes = await sqlite.execute({\n sql:\n `SELECT generating, generated, html FROM ${TABLES.PAGES} WHERE path = ?`,\n args: [path],\n });\n const node = nodeRes.rows[0];\n\n // If leaf requested (.html)\n const isLeaf = path.endsWith(\".html\");\n\n if (node && node[1] === 1) { // generated == 1\n return c.html(\n await UI.Layout({\n title: site[1],\n user,\n children: (\n

\n \n

\n Context: ${site[2]}\n \n Regen\n \n

\n ),\n }),\n );\n }\n\n // Handle Lock\n if (node && node[0] === 1) {\n const diff = (Date.now() - new Date(node[2] + \"Z\").getTime()) / 1000;\n if (diff < GENERATION_LOCK_SECONDS) {\n return c.text(\n `LOCKED: MANIFESTATION_IN_PROGRESS (${\n Math.round(GENERATION_LOCK_SECONDS - diff)\n }s)`,\n );\n }\n }\n\n if (!c.req.query(\"sync\")) {\n return c.html();\n }\n\n // SET LOCK\n await sqlite.execute({\n sql:\n `INSERT INTO ${TABLES.PAGES} (path, site_id, generating) VALUES (?, ?, 1) ON CONFLICT(path) DO UPDATE SET generating=1`,\n args: [path, site[0]],\n });\n\n const steering = c.req.query(\"intent\") || \"\";\n let html = \"\";\n\n if (isLeaf) {\n // Page Content Manifestation\n html = await AI.synthesize(\n `Sophisticated HTML Body`,\n `Write node ${path}. Site intent: ${site[2]}. Agent intent: ${steering}`,\n );\n } else {\n // Folder/Directory Manifestation\n const raw = await AI.synthesize(\n \"JSON ARRAY\",\n `8 sub-nodes for ${site[1]}. DNA: ${site[2]}. Steering: ${steering}`,\n );\n html =\n `

${\n site[1]\n }

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

`;\n }\n\n await sqlite.execute({\n sql:\n `UPDATE ${TABLES.PAGES} SET html = ?, generating = 0, generated = 1 WHERE path = ?`,\n args: [html, path],\n });\n return c.redirect(path);\n});\n\n// --- REMAINING HANDLERS (Auth, Create, Frames) ---\napp.get(\"/ideas-frame\", async (c) => {\n await DB.init();\n const q = await sqlite.execute(\n `SELECT * FROM ${TABLES.QUEUE} WHERE manifested = 0 LIMIT 10`,\n );\n return c.html(\n `\n ${\n q.rows.map((i) =>\n `

${\n i[1]\n }

${i[3]}

`\n ).join(\"\")\n }\n `,\n );\n});\n\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(\"JSON\", `Metadata for: ${idea}`);\n const meta = JSON.parse(raw.replace(/```[a-z]*|\\n```/gi, \"\"));\n const slug = DB.formatSlug(\n meta.name || meta.slug || \"flux-\" + Math.random().toString(36).substring(7),\n );\n await sqlite.execute({\n sql:\n `INSERT INTO ${TABLES.SITES} (name, slug, idea, creator_id) VALUES (?, ?, ?, ?)`,\n args: [meta.name || \"New Reality\", slug, idea, user ? user[0] : null],\n });\n return c.redirect(`/s/${slug}`);\n});\n\nexport default app.fetch;","deleted","label",[99],"permalink","https://www.val.town/x/ziggyware/Save-to-db-working/code/main5.ts","extension","actionData","errors"]