[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_267":268,"_269":270},"routes/_app.x.$handle.$name",{"_123":122,"_34":69,"_132":113,"_29":133,"_13":14,"_134":-5,"_11":135,"_136":137,"_138":139,"_140":141,"_142":143,"_23":-5,"_144":-5,"_145":-5,"_146":27,"_147":148,"_149":82,"_150":-5,"_151":-5,"_152":153},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_67":68,"_34":69,"_39":70,"_71":-5,"_72":27,"_73":74,"_75":74,"_76":77,"_78":-5,"_18":79,"_80":47,"_81":82,"_83":-5,"_84":-5,"_85":86,"_87":88,"_89":90,"_91":92,"_93":94,"_95":-5,"_96":97,"_98":97,"_99":100,"_101":100,"_102":100,"_103":97,"_104":97,"_105":106,"_107":108,"_109":110,"_111":27},"version",7,"changes",[19,20,21,22],"aiChatInfo","userId",{"_23":59,"_25":60,"_26":27,"_28":27,"_29":61,"_31":61},{"_23":52,"_25":53,"_26":27,"_28":27,"_29":54,"_31":54},{"_23":44,"_25":45,"_26":27,"_28":27,"_29":46,"_31":46},{"_23":24,"_25":-7,"_26":27,"_28":27,"_29":30,"_31":30},"file",{"_32":33,"_34":30,"_35":36,"_37":38,"_39":40,"_41":14,"_42":43,"_26":27},"previous","deleted",false,"deletedHere","path","v02_selftest.ts","latestPath","fileId","d2abba1e-aa33-11f1-bbbe-1607ee4eb77e","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst CID = \"v02_selftest_fixture\";\nconst CPID = \"v02_selftest_checkpoint\";\n\nasync function cleanup() {\n await sqlite.batch([\n { sql: \"DELETE FROM vault_messages_fts WHERE conversation_id = ?\", args: [CID] },\n { sql: \"DELETE FROM vault_messages WHERE conversation_id = ?\", args: [CID] },\n { sql: \"DELETE FROM conversations WHERE id = ?\", args: [CID] },\n { sql: \"DELETE FROM vault_checkpoints_fts WHERE checkpoint_id = ?\", args: [CPID] },\n { sql: \"DELETE FROM vault_checkpoints WHERE id = ?\", args: [CPID] },\n ]);\n}\n\nasync function writeFixture() {\n const now = new Date().toISOString();\n await sqlite.batch([\n { sql: `INSERT INTO conversations(id,title,create_time,update_time,message_count,char_count,content_bytes,content_text,truncated,source_file,imported_at)\n VALUES(?,?,?,?,?,?,?,?,?,?,?)\n ON CONFLICT(id) DO UPDATE SET title=excluded.title, message_count=excluded.message_count, content_text=excluded.content_text, imported_at=excluded.imported_at`,\n args: [CID, \"Fixture V0.2\", 1, 2, 2, 64, 64, \"[USER]\\nalpha kernel\\n\\n[ASSISTANT]\\nbeta timeout\", 0, \"selftest\", now] },\n { sql: \"DELETE FROM vault_messages_fts WHERE conversation_id = ?\", args: [CID] },\n { sql: \"DELETE FROM vault_messages WHERE conversation_id = ?\", args: [CID] },\n { sql: \"INSERT INTO vault_messages(id,conversation_id,seq,role,create_time,content_text,char_count,content_bytes,imported_at) VALUES(?,?,?,?,?,?,?,?,?)\", args: [`${CID}_m1`, CID, 0, \"user\", 1, \"alpha kernel\", 12, 12, now] },\n { sql: \"INSERT INTO vault_messages_fts(message_id,conversation_id,title,role,content) VALUES(?,?,?,?,?)\", args: [`${CID}_m1`, CID, \"Fixture V0.2\", \"user\", \"alpha kernel\"] },\n { sql: \"INSERT INTO vault_messages(id,conversation_id,seq,role,create_time,content_text,char_count,content_bytes,imported_at) VALUES(?,?,?,?,?,?,?,?,?)\", args: [`${CID}_m2`, CID, 1, \"assistant\", 2, \"beta timeout\", 12, 12, now] },\n { sql: \"INSERT INTO vault_messages_fts(message_id,conversation_id,title,role,content) VALUES(?,?,?,?,?)\", args: [`${CID}_m2`, CID, \"Fixture V0.2\", \"assistant\", \"beta timeout\"] },\n { sql: `INSERT INTO vault_checkpoints(id,project,title,summary,decisions,open_gaps,next_action,source_conversation_id,evidence_state,created_at,updated_at)\n VALUES(?,?,?,?,?,?,?,?,?,?,?)\n ON CONFLICT(id) DO UPDATE SET summary=excluded.summary, updated_at=excluded.updated_at`,\n args: [CPID, \"SELFTEST\", \"Checkpoint fixture\", \"checkpoint alpha beta\", \"\", \"\", \"next gamma\", CID, \"SYNTHETIC\", now, now] },\n { sql: \"DELETE FROM vault_checkpoints_fts WHERE checkpoint_id = ?\", args: [CPID] },\n { sql: \"INSERT INTO vault_checkpoints_fts(checkpoint_id,project,title,summary,decisions,open_gaps,next_action) VALUES(?,?,?,?,?,?,?)\", args: [CPID, \"SELFTEST\", \"Checkpoint fixture\", \"checkpoint alpha beta\", \"\", \"\", \"next gamma\"] },\n ]);\n}\n\nlet result: Record = {};\ntry {\n await cleanup();\n await writeFixture();\n await writeFixture(); // idempotency/reindex replay\n\n const counts = await sqlite.execute({ sql: \"SELECT COUNT(*) AS c FROM vault_messages WHERE conversation_id = ?\", args: [CID] });\n const ftsCounts = await sqlite.execute({ sql: \"SELECT COUNT(*) AS c FROM vault_messages_fts WHERE conversation_id = ?\", args: [CID] });\n const hit = await sqlite.execute({ sql: \"SELECT DISTINCT conversation_id FROM vault_messages_fts WHERE vault_messages_fts MATCH ? AND conversation_id = ?\", args: ['\"kernel\"*', CID] });\n const negative = await sqlite.execute({ sql: \"SELECT COUNT(*) AS c FROM vault_messages_fts WHERE vault_messages_fts MATCH ?\", args: ['\"notpresent987\"*'] });\n const cp = await sqlite.execute({ sql: \"SELECT checkpoint_id FROM vault_checkpoints_fts WHERE vault_checkpoints_fts MATCH ?\", args: ['\"gamma\"*'] });\n\n result = {\n pass: Number((counts.rows[0] as any)?.c) === 2\n && Number((ftsCounts.rows[0] as any)?.c) === 2\n && (hit.rows[0] as any)?.conversation_id === CID\n && Number((negative.rows[0] as any)?.c) === 0\n && (cp.rows[0] as any)?.checkpoint_id === CPID,\n messagesAfterReplay: Number((counts.rows[0] as any)?.c ?? -1),\n ftsRowsAfterReplay: Number((ftsCounts.rows[0] as any)?.c ?? -1),\n positiveSearch: hit.rows,\n negativeHits: Number((negative.rows[0] as any)?.c ?? -1),\n checkpointSearch: cp.rows,\n };\n} finally {\n await cleanup();\n}\n\nconsole.log(JSON.stringify(result));\nexport default result;\n","createdAt",["D",1788727497920],"branchVersion","branchId","bb539edb-15fc-48c6-a690-7d3728033cd0",{"_32":47,"_34":46,"_35":48,"_37":50,"_39":51,"_41":14,"_42":43,"_26":27},{"_32":47,"_34":46,"_35":48,"_37":49},"index.ts","01a077cd-4980-75c9-8c9f-12270a3b1d2b","http","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { getOAuthUserData, oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { Hono } from \"npm:hono@4\";\nimport { Root } from \"./frontend/root.tsx\";\n\nconst OWNER = \"cleitoncosta\";\nconst APP_VERSION = \"0.1.0\";\nconst VAULT_BUDGET_BYTES = 8_000_000;\nconst MAX_CONVERSATION_CHARS = 600_000;\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\nlet schemaReady = false;\nasync function ensureSchema() {\n if (schemaReady) return;\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS conversations (\n id TEXT PRIMARY KEY,\n title TEXT NOT NULL,\n create_time REAL,\n update_time REAL,\n message_count INTEGER NOT NULL DEFAULT 0,\n char_count INTEGER NOT NULL DEFAULT 0,\n content_bytes INTEGER NOT NULL DEFAULT 0,\n content_text TEXT NOT NULL,\n truncated INTEGER NOT NULL DEFAULT 0,\n source_file TEXT,\n imported_at TEXT NOT NULL\n )`);\n await sqlite.execute(\"CREATE INDEX IF NOT EXISTS idx_conversations_updated ON conversations(update_time DESC)\");\n schemaReady = true;\n}\n\nasync function sessionFor(req: Request) {\n return await getOAuthUserData(req);\n}\n\nasync function isOwner(req: Request) {\n const session = await sessionFor(req);\n return session?.user?.username === OWNER ? session : null;\n}\n\nasync function requireOwner(c: any) {\n const session = await isOwner(c.req.raw);\n if (!session) return c.json({ error: \"unauthorized\", login: \"/auth/login\" }, 401);\n return null;\n}\n\nfunction safeId(value: unknown) {\n return typeof value === \"string\" && /^[A-Za-z0-9_-]{1,160}$/.test(value);\n}\n\nfunction num(value: unknown) {\n return typeof value === \"number\" && Number.isFinite(value) ? value : null;\n}\n\nfunction int(value: unknown, fallback = 0) {\n return typeof value === \"number\" && Number.isFinite(value) ? Math.max(0, Math.trunc(value)) : fallback;\n}\n\nfunction snippet(text: string, needle: string) {\n const normalized = text.toLocaleLowerCase(\"pt-BR\");\n const hit = normalized.indexOf(needle.toLocaleLowerCase(\"pt-BR\"));\n const start = hit >= 0 ? Math.max(0, hit - 180) : 0;\n const chunk = text.slice(start, start + 620).replace(/\\s+/g, \" \").trim();\n return `${start > 0 ? \"…\" : \"\"}${chunk}${start + 620 < text.length ? \"…\" : \"\"}`;\n}\n\napp.get(\"/\", async (c) => {\n const session = await sessionFor(c.req.raw);\n if (!session?.user) return c.redirect(\"/auth/login\");\n if (session.user.username !== OWNER) return c.text(\"Acesso negado. Este cofre pertence a outro usuário.\", 403);\n return c.html(Root());\n});\n\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.get(\"/api/me\", async (c) => {\n const denied = await requireOwner(c);\n if (denied) return denied;\n const session = await sessionFor(c.req.raw);\n return c.json({\n owner: OWNER,\n username: session?.user?.username,\n version: APP_VERSION,\n openaiApiUsed: false,\n storage: \"Val Town project-scoped SQLite\",\n budgetBytes: VAULT_BUDGET_BYTES,\n maxConversationChars: MAX_CONVERSATION_CHARS,\n });\n});\n\napp.get(\"/api/stats\", async (c) => {\n const denied = await requireOwner(c);\n if (denied) return denied;\n await ensureSchema();\n const result = await sqlite.execute(`SELECT\n COUNT(*) AS conversations,\n COALESCE(SUM(message_count), 0) AS messages,\n COALESCE(SUM(char_count), 0) AS chars,\n COALESCE(SUM(content_bytes), 0) AS bytes,\n MIN(create_time) AS earliest,\n MAX(update_time) AS latest,\n COALESCE(SUM(CASE WHEN truncated = 1 THEN 1 ELSE 0 END), 0) AS truncated\n FROM conversations`);\n const row = result.rows[0] ?? {};\n return c.json({ ...row, budgetBytes: VAULT_BUDGET_BYTES });\n});\n\napp.get(\"/api/search\", async (c) => {\n const denied = await requireOwner(c);\n if (denied) return denied;\n await ensureSchema();\n const q = (c.req.query(\"q\") ?? \"\").trim().slice(0, 160);\n if (q.length < 2) return c.json({ query: q, results: [] });\n\n const terms = q.split(/\\s+/).filter(Boolean).slice(0, 6);\n const clauses = terms.map(() => \"(title LIKE ? OR content_text LIKE ?)\");\n const args: string[] = [];\n for (const term of terms) {\n const pattern = `%${term}%`;\n args.push(pattern, pattern);\n }\n\n const result = await sqlite.execute({\n sql: `SELECT id, title, create_time, update_time, message_count, char_count, content_bytes, truncated, content_text\n FROM conversations\n WHERE ${clauses.join(\" AND \")}\n ORDER BY update_time DESC\n LIMIT 25`,\n args,\n });\n\n const results = result.rows.map((row: any) => ({\n id: row.id,\n title: row.title,\n createTime: row.create_time,\n updateTime: row.update_time,\n messageCount: row.message_count,\n charCount: row.char_count,\n contentBytes: row.content_bytes,\n truncated: Boolean(row.truncated),\n snippet: snippet(String(row.content_text ?? \"\"), terms[0]),\n }));\n return c.json({ query: q, terms, results });\n});\n\napp.get(\"/api/conversations/:id\", async (c) => {\n const denied = await requireOwner(c);\n if (denied) return denied;\n await ensureSchema();\n const id = c.req.param(\"id\");\n if (!safeId(id)) return c.json({ error: \"invalid_id\" }, 400);\n const result = await sqlite.execute({\n sql: `SELECT id, title, create_time, update_time, message_count, char_count, content_bytes,\n content_text, truncated, source_file, imported_at\n FROM conversations WHERE id = ? LIMIT 1`,\n args: [id],\n });\n if (!result.rows.length) return c.json({ error: \"not_found\" }, 404);\n return c.json(result.rows[0]);\n});\n\napp.put(\"/api/conversations/:id\", async (c) => {\n const denied = await requireOwner(c);\n if (denied) return denied;\n await ensureSchema();\n const id = c.req.param(\"id\");\n if (!safeId(id)) return c.json({ error: \"invalid_id\" }, 400);\n\n let body: any;\n try {\n body = await c.req.json();\n } catch {\n return c.json({ error: \"invalid_json\" }, 400);\n }\n\n const title = typeof body.title === \"string\" ? body.title.trim().slice(0, 300) : \"Sem título\";\n const contentText = typeof body.contentText === \"string\" ? body.contentText : \"\";\n if (!contentText.trim()) return c.json({ error: \"empty_conversation\" }, 400);\n if (contentText.length > MAX_CONVERSATION_CHARS) {\n return c.json({ error: \"conversation_too_large\", maxChars: MAX_CONVERSATION_CHARS }, 413);\n }\n\n const contentBytes = new TextEncoder().encode(contentText).length;\n const current = await sqlite.execute({\n sql: \"SELECT content_bytes FROM conversations WHERE id = ? LIMIT 1\",\n args: [id],\n });\n const currentBytes = Number((current.rows[0] as any)?.content_bytes ?? 0);\n const totals = await sqlite.execute(\"SELECT COALESCE(SUM(content_bytes), 0) AS bytes FROM conversations\");\n const usedBytes = Number((totals.rows[0] as any)?.bytes ?? 0);\n const projected = usedBytes - currentBytes + contentBytes;\n if (projected > VAULT_BUDGET_BYTES) {\n return c.json({\n error: \"vault_budget_exceeded\",\n usedBytes,\n projectedBytes: projected,\n budgetBytes: VAULT_BUDGET_BYTES,\n }, 507);\n }\n\n await sqlite.execute({\n sql: `INSERT INTO conversations (\n id, title, create_time, update_time, message_count, char_count, content_bytes,\n content_text, truncated, source_file, imported_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(id) DO UPDATE SET\n title = excluded.title,\n create_time = excluded.create_time,\n update_time = excluded.update_time,\n message_count = excluded.message_count,\n char_count = excluded.char_count,\n content_bytes = excluded.content_bytes,\n content_text = excluded.content_text,\n truncated = excluded.truncated,\n source_file = excluded.source_file,\n imported_at = excluded.imported_at`,\n args: [\n id,\n title || \"Sem título\",\n num(body.createTime),\n num(body.updateTime),\n int(body.messageCount),\n contentText.length,\n contentBytes,\n contentText,\n body.truncated ? 1 : 0,\n typeof body.sourceFile === \"string\" ? body.sourceFile.slice(0, 180) : \"conversations.json\",\n new Date().toISOString(),\n ],\n });\n\n return c.json({ ok: true, id, contentBytes, projectedBytes: projected });\n});\n\napp.delete(\"/api/conversations/:id\", async (c) => {\n const denied = await requireOwner(c);\n if (denied) return denied;\n await ensureSchema();\n const id = c.req.param(\"id\");\n if (!safeId(id)) return c.json({ error: \"invalid_id\" }, 400);\n const result = await sqlite.execute({ sql: \"DELETE FROM conversations WHERE id = ?\", args: [id] });\n return c.json({ ok: true, rowsAffected: result.rowsAffected });\n});\n\nexport default oauthMiddleware(app.fetch);\n","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { getOAuthUserData, oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { Hono } from \"npm:hono@4\";\nimport { Root } from \"./frontend/root.tsx\";\n\nconst OWNER = \"cleitoncosta\";\nconst APP_VERSION = \"0.2.0\";\nconst VAULT_BUDGET_BYTES = 8_000_000;\nconst MAX_CONVERSATION_CHARS = 600_000;\nconst MAX_MESSAGE_CHARS = 180_000;\nconst MAX_MESSAGES_PER_CONVERSATION = 5000;\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\nlet schemaReady = false;\nasync function ensureSchema() {\n if (schemaReady) return;\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS conversations (\n id TEXT PRIMARY KEY,\n title TEXT NOT NULL,\n create_time REAL,\n update_time REAL,\n message_count INTEGER NOT NULL DEFAULT 0,\n char_count INTEGER NOT NULL DEFAULT 0,\n content_bytes INTEGER NOT NULL DEFAULT 0,\n content_text TEXT NOT NULL,\n truncated INTEGER NOT NULL DEFAULT 0,\n source_file TEXT,\n imported_at TEXT NOT NULL\n )`);\n await sqlite.execute(\"CREATE INDEX IF NOT EXISTS idx_conversations_updated ON conversations(update_time DESC)\");\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS vault_messages (\n id TEXT PRIMARY KEY,\n conversation_id TEXT NOT NULL,\n seq INTEGER NOT NULL,\n role TEXT NOT NULL,\n create_time REAL,\n content_text TEXT NOT NULL,\n char_count INTEGER NOT NULL DEFAULT 0,\n content_bytes INTEGER NOT NULL DEFAULT 0,\n imported_at TEXT NOT NULL\n )`);\n await sqlite.execute(\"CREATE INDEX IF NOT EXISTS idx_vault_messages_conversation_seq ON vault_messages(conversation_id, seq)\");\n await sqlite.execute(\"CREATE INDEX IF NOT EXISTS idx_vault_messages_create_time ON vault_messages(create_time)\");\n await sqlite.execute(`CREATE VIRTUAL TABLE IF NOT EXISTS vault_messages_fts USING fts5(\n message_id UNINDEXED,\n conversation_id UNINDEXED,\n title,\n role UNINDEXED,\n content,\n tokenize='unicode61 remove_diacritics 2'\n )`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS vault_checkpoints (\n id TEXT PRIMARY KEY,\n project TEXT NOT NULL,\n title TEXT NOT NULL,\n summary TEXT NOT NULL,\n decisions TEXT NOT NULL DEFAULT '',\n open_gaps TEXT NOT NULL DEFAULT '',\n next_action TEXT NOT NULL DEFAULT '',\n source_conversation_id TEXT,\n evidence_state TEXT NOT NULL DEFAULT 'CHECKPOINT',\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`);\n await sqlite.execute(\"CREATE INDEX IF NOT EXISTS idx_vault_checkpoints_project_updated ON vault_checkpoints(project, updated_at DESC)\");\n await sqlite.execute(`CREATE VIRTUAL TABLE IF NOT EXISTS vault_checkpoints_fts USING fts5(\n checkpoint_id UNINDEXED,\n project,\n title,\n summary,\n decisions,\n open_gaps,\n next_action,\n tokenize='unicode61 remove_diacritics 2'\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS vault_meta (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`);\n await sqlite.execute({\n sql: \"INSERT INTO vault_meta(key,value,updated_at) VALUES ('schema_version', ?, datetime('now')) ON CONFLICT(key) DO UPDATE SET value=excluded.value, updated_at=excluded.updated_at\",\n args: [APP_VERSION],\n });\n schemaReady = true;\n}\n\nasync function sessionFor(req: Request) {\n return await getOAuthUserData(req);\n}\n\nasync function isOwner(req: Request) {\n const session = await sessionFor(req);\n return session?.user?.username === OWNER ? session : null;\n}\n\nasync function requireOwner(c: any) {\n const session = await isOwner(c.req.raw);\n if (!session) return c.json({ error: \"unauthorized\", login: \"/auth/login\" }, 401);\n return null;\n}\n\nfunction safeId(value: unknown) {\n return typeof value === \"string\" && /^[A-Za-z0-9_-]{1,160}$/.test(value);\n}\n\nfunction safeProject(value: unknown) {\n return typeof value === \"string\" && value.trim().length >= 1 && value.trim().length <= 120;\n}\n\nfunction num(value: unknown) {\n return typeof value === \"number\" && Number.isFinite(value) ? value : null;\n}\n\nfunction int(value: unknown, fallback = 0) {\n return typeof value === \"number\" && Number.isFinite(value) ? Math.max(0, Math.trunc(value)) : fallback;\n}\n\nfunction ftsQuery(input: string) {\n const tokens = input.normalize(\"NFKC\").match(/[\\p{L}\\p{N}_]+/gu)?.slice(0, 8) ?? [];\n return tokens.map((token) => `\"${token.replaceAll('\"', '\"\"')}\"*`).join(\" AND \");\n}\n\nfunction legacySnippet(text: string, needle: string) {\n const normalized = text.toLocaleLowerCase(\"pt-BR\");\n const hit = normalized.indexOf(needle.toLocaleLowerCase(\"pt-BR\"));\n const start = hit >= 0 ? Math.max(0, hit - 180) : 0;\n const chunk = text.slice(start, start + 620).replace(/\\s+/g, \" \").trim();\n return `${start > 0 ? \"…\" : \"\"}${chunk}${start + 620 < text.length ? \"…\" : \"\"}`;\n}\n\nasync function searchCheckpointIndex(match: string) {\n if (!match) return [];\n const result = await sqlite.execute({\n sql: `SELECT\n checkpoint_id AS id,\n project,\n title,\n snippet(vault_checkpoints_fts, 3, '', '', ' … ', 42) AS snippet,\n bm25(vault_checkpoints_fts, 0.0, 3.0, 5.0, 2.0, 2.0, 1.5, 1.5) AS rank\n FROM vault_checkpoints_fts\n WHERE vault_checkpoints_fts MATCH ?\n ORDER BY rank\n LIMIT 12`,\n args: [match],\n });\n return result.rows;\n}\n\napp.get(\"/\", async (c) => {\n const session = await sessionFor(c.req.raw);\n if (!session?.user) return c.redirect(\"/auth/login\");\n if (session.user.username !== OWNER) return c.text(\"Acesso negado. Este cofre pertence a outro usuário.\", 403);\n return c.html(Root());\n});\n\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.get(\"/api/me\", async (c) => {\n const denied = await requireOwner(c);\n if (denied) return denied;\n await ensureSchema();\n const session = await sessionFor(c.req.raw);\n return c.json({\n owner: OWNER,\n username: session?.user?.username,\n version: APP_VERSION,\n openaiApiUsed: false,\n storage: \"Val Town project-scoped SQLite + FTS5\",\n searchEngine: \"SQLite FTS5/BM25\",\n budgetBytes: VAULT_BUDGET_BYTES,\n maxConversationChars: MAX_CONVERSATION_CHARS,\n });\n});\n\napp.get(\"/api/stats\", async (c) => {\n const denied = await requireOwner(c);\n if (denied) return denied;\n await ensureSchema();\n const [conversations, indexed, checkpoints] = await Promise.all([\n sqlite.execute(`SELECT\n COUNT(*) AS conversations,\n COALESCE(SUM(message_count), 0) AS messages,\n COALESCE(SUM(char_count), 0) AS chars,\n COALESCE(SUM(content_bytes), 0) AS bytes,\n MIN(create_time) AS earliest,\n MAX(update_time) AS latest,\n COALESCE(SUM(CASE WHEN truncated = 1 THEN 1 ELSE 0 END), 0) AS truncated\n FROM conversations`),\n sqlite.execute(\"SELECT COUNT(*) AS indexed_messages FROM vault_messages\"),\n sqlite.execute(\"SELECT COUNT(*) AS checkpoints FROM vault_checkpoints\"),\n ]);\n return c.json({\n ...(conversations.rows[0] ?? {}),\n indexedMessages: Number((indexed.rows[0] as any)?.indexed_messages ?? 0),\n checkpoints: Number((checkpoints.rows[0] as any)?.checkpoints ?? 0),\n budgetBytes: VAULT_BUDGET_BYTES,\n });\n});\n\napp.get(\"/api/search\", async (c) => {\n const denied = await requireOwner(c);\n if (denied) return denied;\n await ensureSchema();\n const q = (c.req.query(\"q\") ?? \"\").trim().slice(0, 160);\n if (q.length < 2) return c.json({ query: q, engine: \"none\", results: [] });\n\n const match = ftsQuery(q);\n const indexedCount = await sqlite.execute(\"SELECT COUNT(*) AS count FROM vault_messages\");\n const hasMessageIndex = Number((indexedCount.rows[0] as any)?.count ?? 0) > 0;\n\n if (match && hasMessageIndex) {\n const result = await sqlite.execute({\n sql: `WITH hits AS (\n SELECT\n conversation_id,\n message_id,\n role,\n snippet(vault_messages_fts, 4, '', '', ' … ', 42) AS hit_snippet,\n bm25(vault_messages_fts, 6.0, 0.0, 2.5, 0.0, 1.0) AS rank\n FROM vault_messages_fts\n WHERE vault_messages_fts MATCH ?\n ORDER BY rank\n LIMIT 150\n ), best AS (\n SELECT *, ROW_NUMBER() OVER (PARTITION BY conversation_id ORDER BY rank) AS rn\n FROM hits\n )\n SELECT\n c.id, c.title, c.create_time, c.update_time, c.message_count, c.char_count,\n c.content_bytes, c.truncated, b.message_id, b.role, b.hit_snippet, b.rank\n FROM best b\n JOIN conversations c ON c.id = b.conversation_id\n WHERE b.rn = 1\n ORDER BY b.rank, c.update_time DESC\n LIMIT 25`,\n args: [match],\n });\n return c.json({\n query: q,\n engine: \"fts5_bm25\",\n match,\n checkpoints: await searchCheckpointIndex(match),\n results: result.rows.map((row: any) => ({\n id: row.id,\n title: row.title,\n createTime: row.create_time,\n updateTime: row.update_time,\n messageCount: row.message_count,\n charCount: row.char_count,\n contentBytes: row.content_bytes,\n truncated: Boolean(row.truncated),\n messageId: row.message_id,\n role: row.role,\n rank: row.rank,\n snippet: String(row.hit_snippet ?? \"\").replace(/\\s+/g, \" \").trim(),\n })),\n });\n }\n\n const terms = q.split(/\\s+/).filter(Boolean).slice(0, 6);\n const clauses = terms.map(() => \"(title LIKE ? OR content_text LIKE ?)\");\n const args: string[] = [];\n for (const term of terms) {\n const pattern = `%${term}%`;\n args.push(pattern, pattern);\n }\n const result = await sqlite.execute({\n sql: `SELECT id, title, create_time, update_time, message_count, char_count, content_bytes, truncated, content_text\n FROM conversations\n WHERE ${clauses.join(\" AND \")}\n ORDER BY update_time DESC\n LIMIT 25`,\n args,\n });\n return c.json({\n query: q,\n engine: \"legacy_like_fallback\",\n checkpoints: await searchCheckpointIndex(match),\n results: result.rows.map((row: any) => ({\n id: row.id,\n title: row.title,\n createTime: row.create_time,\n updateTime: row.update_time,\n messageCount: row.message_count,\n charCount: row.char_count,\n contentBytes: row.content_bytes,\n truncated: Boolean(row.truncated),\n snippet: legacySnippet(String(row.content_text ?? \"\"), terms[0] ?? q),\n })),\n });\n});\n\napp.get(\"/api/conversations/:id\", async (c) => {\n const denied = await requireOwner(c);\n if (denied) return denied;\n await ensureSchema();\n const id = c.req.param(\"id\");\n if (!safeId(id)) return c.json({ error: \"invalid_id\" }, 400);\n const [conversation, messages] = await Promise.all([\n sqlite.execute({\n sql: `SELECT id, title, create_time, update_time, message_count, char_count, content_bytes,\n content_text, truncated, source_file, imported_at\n FROM conversations WHERE id = ? LIMIT 1`,\n args: [id],\n }),\n sqlite.execute({\n sql: `SELECT id, seq, role, create_time, content_text, char_count, content_bytes\n FROM vault_messages WHERE conversation_id = ? ORDER BY seq ASC`,\n args: [id],\n }),\n ]);\n if (!conversation.rows.length) return c.json({ error: \"not_found\" }, 404);\n return c.json({ ...(conversation.rows[0] as any), indexed_messages: messages.rows });\n});\n\napp.put(\"/api/conversations/:id\", async (c) => {\n const denied = await requireOwner(c);\n if (denied) return denied;\n await ensureSchema();\n const id = c.req.param(\"id\");\n if (!safeId(id)) return c.json({ error: \"invalid_id\" }, 400);\n\n let body: any;\n try {\n body = await c.req.json();\n } catch {\n return c.json({ error: \"invalid_json\" }, 400);\n }\n\n const title = typeof body.title === \"string\" ? body.title.trim().slice(0, 300) : \"Sem título\";\n const contentText = typeof body.contentText === \"string\" ? body.contentText : \"\";\n if (!contentText.trim()) return c.json({ error: \"empty_conversation\" }, 400);\n if (contentText.length > MAX_CONVERSATION_CHARS) {\n return c.json({ error: \"conversation_too_large\", maxChars: MAX_CONVERSATION_CHARS }, 413);\n }\n\n const rawMessages = Array.isArray(body.messages) ? body.messages.slice(0, MAX_MESSAGES_PER_CONVERSATION) : [];\n const normalizedMessages = rawMessages.flatMap((message: any, index: number) => {\n const text = typeof message?.contentText === \"string\" ? message.contentText.trim() : \"\";\n if (!text) return [];\n const clipped = text.slice(0, MAX_MESSAGE_CHARS);\n let messageId = typeof message?.id === \"string\" ? message.id.trim() : \"\";\n if (!safeId(messageId)) messageId = `${id}_m_${index + 1}`.slice(0, 160);\n return [{\n id: messageId,\n seq: index,\n role: typeof message?.role === \"string\" ? message.role.toLowerCase().slice(0, 40) : \"unknown\",\n createTime: typeof message?.createTime === \"number\" && Number.isFinite(message.createTime) ? message.createTime : null,\n contentText: clipped,\n charCount: clipped.length,\n contentBytes: new TextEncoder().encode(clipped).length,\n }];\n });\n\n const contentBytes = new TextEncoder().encode(contentText).length;\n const current = await sqlite.execute({ sql: \"SELECT content_bytes FROM conversations WHERE id = ? LIMIT 1\", args: [id] });\n const currentBytes = Number((current.rows[0] as any)?.content_bytes ?? 0);\n const totals = await sqlite.execute(\"SELECT COALESCE(SUM(content_bytes), 0) AS bytes FROM conversations\");\n const usedBytes = Number((totals.rows[0] as any)?.bytes ?? 0);\n const projected = usedBytes - currentBytes + contentBytes;\n if (projected > VAULT_BUDGET_BYTES) {\n return c.json({ error: \"vault_budget_exceeded\", usedBytes, projectedBytes: projected, budgetBytes: VAULT_BUDGET_BYTES }, 507);\n }\n\n const importedAt = new Date().toISOString();\n const statements: Array<{ sql: string; args?: Array }> = [\n {\n sql: `INSERT INTO conversations (\n id, title, create_time, update_time, message_count, char_count, content_bytes,\n content_text, truncated, source_file, imported_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(id) DO UPDATE SET\n title = excluded.title,\n create_time = excluded.create_time,\n update_time = excluded.update_time,\n message_count = excluded.message_count,\n char_count = excluded.char_count,\n content_bytes = excluded.content_bytes,\n content_text = excluded.content_text,\n truncated = excluded.truncated,\n source_file = excluded.source_file,\n imported_at = excluded.imported_at`,\n args: [\n id,\n title || \"Sem título\",\n num(body.createTime),\n num(body.updateTime),\n normalizedMessages.length || int(body.messageCount),\n contentText.length,\n contentBytes,\n contentText,\n body.truncated ? 1 : 0,\n typeof body.sourceFile === \"string\" ? body.sourceFile.slice(0, 180) : \"conversations.json\",\n importedAt,\n ],\n },\n { sql: \"DELETE FROM vault_messages WHERE conversation_id = ?\", args: [id] },\n { sql: \"DELETE FROM vault_messages_fts WHERE conversation_id = ?\", args: [id] },\n ];\n\n for (const message of normalizedMessages) {\n statements.push({\n sql: `INSERT INTO vault_messages (\n id, conversation_id, seq, role, create_time, content_text, char_count, content_bytes, imported_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [message.id, id, message.seq, message.role, message.createTime, message.contentText, message.charCount, message.contentBytes, importedAt],\n });\n statements.push({\n sql: \"INSERT INTO vault_messages_fts(message_id, conversation_id, title, role, content) VALUES (?, ?, ?, ?, ?)\",\n args: [message.id, id, title || \"Sem título\", message.role, message.contentText],\n });\n }\n\n await sqlite.batch(statements);\n return c.json({\n ok: true,\n id,\n contentBytes,\n projectedBytes: projected,\n indexedMessages: normalizedMessages.length,\n searchEngine: normalizedMessages.length ? \"fts5_bm25\" : \"legacy_like_fallback\",\n });\n});\n\napp.delete(\"/api/conversations/:id\", async (c) => {\n const denied = await requireOwner(c);\n if (denied) return denied;\n await ensureSchema();\n const id = c.req.param(\"id\");\n if (!safeId(id)) return c.json({ error: \"invalid_id\" }, 400);\n const results = await sqlite.batch([\n { sql: \"DELETE FROM vault_messages_fts WHERE conversation_id = ?\", args: [id] },\n { sql: \"DELETE FROM vault_messages WHERE conversation_id = ?\", args: [id] },\n { sql: \"DELETE FROM conversations WHERE id = ?\", args: [id] },\n ]);\n return c.json({ ok: true, rowsAffected: results[2]?.rowsAffected ?? 0 });\n});\n\napp.get(\"/api/checkpoints\", async (c) => {\n const denied = await requireOwner(c);\n if (denied) return denied;\n await ensureSchema();\n const limit = Math.min(25, Math.max(1, Number(c.req.query(\"limit\") ?? 8) || 8));\n const project = (c.req.query(\"project\") ?? \"\").trim().slice(0, 120);\n const result = project\n ? await sqlite.execute({\n sql: `SELECT id, project, title, summary, decisions, open_gaps, next_action, source_conversation_id, evidence_state, created_at, updated_at\n FROM vault_checkpoints WHERE project = ? ORDER BY updated_at DESC LIMIT ?`,\n args: [project, limit],\n })\n : await sqlite.execute({\n sql: `SELECT id, project, title, summary, decisions, open_gaps, next_action, source_conversation_id, evidence_state, created_at, updated_at\n FROM vault_checkpoints ORDER BY updated_at DESC LIMIT ?`,\n args: [limit],\n });\n return c.json({ project: project || null, checkpoints: result.rows });\n});\n\napp.post(\"/api/checkpoints\", async (c) => {\n const denied = await requireOwner(c);\n if (denied) return denied;\n await ensureSchema();\n let body: any;\n try {\n body = await c.req.json();\n } catch {\n return c.json({ error: \"invalid_json\" }, 400);\n }\n const project = typeof body.project === \"string\" ? body.project.trim().slice(0, 120) : \"\";\n const title = typeof body.title === \"string\" ? body.title.trim().slice(0, 240) : \"\";\n const summary = typeof body.summary === \"string\" ? body.summary.trim().slice(0, 12000) : \"\";\n if (!safeProject(project) || !title || !summary) return c.json({ error: \"project_title_summary_required\" }, 400);\n let id = typeof body.id === \"string\" ? body.id.trim() : \"\";\n if (!safeId(id)) id = `cp_${Date.now()}_${Math.random().toString(36).slice(2, 8)}`;\n const decisions = typeof body.decisions === \"string\" ? body.decisions.trim().slice(0, 12000) : \"\";\n const openGaps = typeof body.openGaps === \"string\" ? body.openGaps.trim().slice(0, 12000) : \"\";\n const nextAction = typeof body.nextAction === \"string\" ? body.nextAction.trim().slice(0, 12000) : \"\";\n const sourceConversationId = safeId(body.sourceConversationId) ? body.sourceConversationId : null;\n const evidenceState = typeof body.evidenceState === \"string\" ? body.evidenceState.trim().slice(0, 80) : \"CHECKPOINT\";\n const now = new Date().toISOString();\n\n await sqlite.batch([\n {\n sql: `INSERT INTO vault_checkpoints (\n id, project, title, summary, decisions, open_gaps, next_action, source_conversation_id, evidence_state, created_at, updated_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(id) DO UPDATE SET\n project=excluded.project, title=excluded.title, summary=excluded.summary,\n decisions=excluded.decisions, open_gaps=excluded.open_gaps, next_action=excluded.next_action,\n source_conversation_id=excluded.source_conversation_id, evidence_state=excluded.evidence_state,\n updated_at=excluded.updated_at`,\n args: [id, project, title, summary, decisions, openGaps, nextAction, sourceConversationId, evidenceState, now, now],\n },\n { sql: \"DELETE FROM vault_checkpoints_fts WHERE checkpoint_id = ?\", args: [id] },\n {\n sql: `INSERT INTO vault_checkpoints_fts(checkpoint_id, project, title, summary, decisions, open_gaps, next_action)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [id, project, title, summary, decisions, openGaps, nextAction],\n },\n ]);\n return c.json({ ok: true, id, project, title, evidenceState, updatedAt: now });\n});\n\napp.get(\"/api/checkpoint-search\", async (c) => {\n const denied = await requireOwner(c);\n if (denied) return denied;\n await ensureSchema();\n const q = (c.req.query(\"q\") ?? \"\").trim().slice(0, 160);\n const match = ftsQuery(q);\n if (!match) return c.json({ query: q, results: [] });\n const result = await sqlite.execute({\n sql: `SELECT\n checkpoint_id,\n project,\n title,\n snippet(vault_checkpoints_fts, 3, '', '', ' … ', 42) AS hit_snippet,\n bm25(vault_checkpoints_fts, 0.0, 3.0, 5.0, 2.0, 2.0, 1.5, 1.5) AS rank\n FROM vault_checkpoints_fts\n WHERE vault_checkpoints_fts MATCH ?\n ORDER BY rank\n LIMIT 25`,\n args: [match],\n });\n return c.json({ query: q, engine: \"fts5_bm25\", results: result.rows });\n});\n\nexport default oauthMiddleware(app.fetch);\n",["D",1788727497920],{"_32":55,"_34":54,"_35":23,"_37":57,"_39":58,"_41":14,"_42":43,"_26":27},{"_32":55,"_34":54,"_35":23,"_37":56},"README.md","01a077cd-4980-75c9-8c9f-0e80a101c1e0","# GUH Knowledge Vault — V0.1.0\n\nPrimeira versão funcional de um cofre pessoal pesquisável para exports oficiais do ChatGPT, sem usar a API da OpenAI.\n\n## Objetivo\n\nPermitir que o proprietário `cleitoncosta`:\n\n1. faça login com a própria conta Val Town;\n2. selecione `conversations.json` (ou arquivos numerados de export);\n3. importe as 25, 50 ou 100 conversas mais recentes;\n4. pesquise por título e conteúdo;\n5. abra a conversa normalizada encontrada;\n6. mantenha o estado em SQLite escopado a este val.\n\n## Segurança V0.1\n\n- Código é público por restrição do workspace Free.\n- Conteúdo não é exposto publicamente.\n- Rotas com dados exigem sessão OAuth Val Town.\n- Apenas `username === cleitoncosta` é aceito.\n- O arquivo JSON bruto é lido primeiro no navegador; apenas conversas selecionadas/normalizadas são enviadas ao backend.\n- Nenhuma OpenAI API key é usada.\n- Nenhuma automação faz login ou raspa `chatgpt.com`.\n\n## Limites deliberados desta versão\n\n- SQLite Free é pequeno; o app usa orçamento próprio de 8 MB para manter margem.\n- Importação oferece 25/50/100 conversas recentes.\n- Conversas acima de ~590 mil caracteres preservam início e final e são marcadas como parciais.\n- Busca V0.1 é textual (`LIKE`), não semântica.\n- Arquivos e imagens do export não são ingeridos como blobs nesta versão.\n- O fluxo de login real no iPhone precisa ser validado pelo proprietário em navegador real.\n\n## Evidência já obtida\n\nPASS:\n- projeto criado no Val Town;\n- endpoint HTTP publicado;\n- visitante sem sessão é redirecionado para login Val Town;\n- schema SQLite criado;\n- INSERT sintético;\n- busca AND por `Kernel` + `timeout` encontrou o controle esperado;\n- controle sintético removido;\n- banco final voltou a 0 conversas / 0 bytes;\n- `frontend/components/App.tsx` transpila/executa no runtime;\n- nenhuma env var/API OpenAI é necessária.\n\nEVIDÊNCIA REAL NO IPHONE — 2026-09-06:\n- PASS: proprietário abriu o app em sessão real no iPhone;\n- PASS: autenticação permitiu acesso ao cofre como `cleitoncosta`;\n- PASS: arquivo JSON compatível com o export foi importado pelo Safari/iPhone;\n- PASS: 3 conversas / 10 mensagens / 970 B persistidos no SQLite;\n- PASS: busca `Kernel timeout` retornou exatamente a conversa esperada;\n- PASS: busca `NR-12` retornou exatamente a conversa esperada;\n- PASS: busca `Reconciliação` retornou resultados coerentes em mais de uma conversa;\n- PASS: resultado aberto mostrou título, metadados, mensagens USER/ASSISTANT e origem corretos;\n- PASS: valores visuais do app foram cruzados com consulta direta ao SQLite e coincidiram.\n\nEstado V0.1: **OPERATIONAL para o escopo de teste sintético compatível com export**.\n\nAinda UNVERIFIED:\n- parsing de um export oficial real da conta do proprietário;\n- importação de 25/50/100 conversas reais;\n- comportamento com export grande no Safari/iPhone;\n- cobertura de conteúdos multimodais/anexos;\n- busca semântica.\n\n## Próxima promoção\n\nO próximo marco é importar um **export oficial real do ChatGPT** e repetir os mesmos controles com uma conversa sabidamente existente. Somente depois disso o parser deve ser promovido de `SYNTHETIC_COMPATIBLE` para `REAL_EXPORT_VERIFIED`.\n\nDepois, V0.2 pode atacar arquivo completo, busca semântica local/externa sem OpenAI API, checkpoints automáticos e integração com outros agentes.\n","# GUH Knowledge Vault — V0.2.0\n\nCofre pessoal pesquisável para histórico exportado do ChatGPT + checkpoints do trabalho corrente, sem usar a API da OpenAI.\n\n## Runtime\n\n`iPhone/browser -> OAuth Val Town -> Hono -> SQLite/FTS5 -> resultados`\n\nO código é público por restrição do workspace Free, mas as rotas de dados exigem login Val Town e aceitam apenas `username === cleitoncosta`.\n\n## O que a V0.2 adiciona\n\n- mensagens persistidas individualmente em `vault_messages`;\n- índice `vault_messages_fts` com SQLite FTS5;\n- ranking BM25;\n- tokenização Unicode com remoção de diacríticos;\n- busca multi-termo com AND + prefix matching;\n- fallback para a busca V0.1 quando não houver mensagens indexadas;\n- checkpoints persistentes em `vault_checkpoints`;\n- índice FTS dos checkpoints;\n- busca universal capaz de retornar conversas + checkpoints;\n- detalhe da conversa renderizado mensagem por mensagem quando o índice existe;\n- reimportação/reindexação idempotente para uma mesma conversa;\n- `vault_meta.schema_version = 0.2.0`;\n- self-test stateful com limpeza de fixture.\n\n## Duas rotas de memória\n\n### Histórico antigo\n\n`export oficial -> conversations.json -> importador no navegador -> conversa + mensagens -> FTS5`\n\n### Conhecimento novo\n\n`ChatGPT/conector Val Town -> checkpoint estruturado -> vault_checkpoints -> FTS5`\n\nIsso evita depender exclusivamente de novos exports para preservar decisões e estado de projetos daqui para frente.\n\n## Estado persistido no fechamento da V0.2\n\n- 3 conversas sintéticas compatíveis com export;\n- 10 mensagens de origem;\n- 10 mensagens individualmente indexadas;\n- 10 linhas no índice FTS das mensagens;\n- 970 B de conteúdo legado de conversa;\n- 1 checkpoint real sobre a prova da V0.1 no iPhone;\n- 0 fixtures de self-test restantes.\n\n## Evidência\n\n### PASS\n\n- V0.1 real no iPhone: login, importação, persistência, busca e abertura de conversa;\n- FTS5 disponível no SQLite do Val Town;\n- `Kernel timeout` -> conversa correta;\n- `NR-12` -> conversa correta;\n- `reconciliação` -> duas conversas relacionadas;\n- checkpoint encontrado por `export + oficial`;\n- controle negativo inexistente -> 0 hits;\n- reindex replay -> 2 mensagens continuam 2, sem duplicação;\n- replay FTS -> 2 linhas continuam 2;\n- self-test final -> `pass=true`;\n- self-test remove as próprias fixtures;\n- `index.ts` compila no runtime;\n- `frontend/components/App.tsx` compila no runtime;\n- visitante sem sessão continua redirecionado para autenticação.\n\n### Falha útil encontrada\n\nO primeiro self-test assumia incorretamente que uma busca por `kernel` retornaria somente a fixture. Como já havia uma conversa real de teste com esse termo, o self-test marcou FAIL apesar do sistema estar correto.\n\nCorreção: o validador passou a testar a presença da fixture dentro do escopo correto, sem assumir exclusividade global.\n\nLesson learned: **um teste pode falhar por hipótese inválida do próprio validador; negative controls e escopo explícito são obrigatórios.**\n\n### Ainda UNVERIFIED\n\n- parser contra export oficial real desta conta;\n- importação real de 25/50/100 conversas;\n- comportamento com um export muito grande no Safari/iPhone;\n- assets, imagens, PDFs, ZIPs e outros anexos do export;\n- busca semântica por embeddings/conceitos;\n- camada de armazenamento maior para histórico completo;\n- sincronização automática do histórico interno do ChatGPT.\n\n## Limites deliberados\n\nA V0.2 ainda preserva `conversations.content_text` por compatibilidade com a V0.1 e também mantém mensagens individualizadas + índice. Isso duplica parte do conteúdo e não é a arquitetura final para milhares de conversas.\n\nAntes da importação massiva, deve ser criada uma camada de armazenamento maior e o orçamento deve considerar tamanho físico real, não apenas `content_bytes` da tabela legada.\n\n## Próximos marcos\n\n1. Testar um export oficial real.\n2. Medir tamanho/quantidade real de chats e assets.\n3. Escolher storage gratuito maior para o histórico completo.\n4. Migrar o corpo das mensagens para arquitetura sem duplicação desnecessária.\n5. Adicionar projetos, entidades, relações e artefatos.\n6. Evoluir de full-text para busca híbrida/semântica sem depender da API da OpenAI.\n7. Criar interface/tool para outros agentes consultarem o Vault.\n8. Automatizar checkpoints quando o usuário solicitar `salve checkpoint`.\n",["D",1788727497920],{"_32":62,"_34":63,"_35":36,"_37":65,"_39":66,"_41":14,"_42":43,"_26":27},{"_32":62,"_34":63,"_35":36,"_37":64},"frontend/components/App.tsx","01a077cd-497f-73ff-be91-adfc3e9c0cec","App.tsx","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useMemo, useState } from \"https://esm.sh/react@18.2.0\";\n\ntype Stats = {\n conversations: number;\n messages: number;\n chars: number;\n bytes: number;\n earliest: number | null;\n latest: number | null;\n truncated: number;\n budgetBytes: number;\n};\n\ntype SearchResult = {\n id: string;\n title: string;\n createTime: number | null;\n updateTime: number | null;\n messageCount: number;\n charCount: number;\n contentBytes: number;\n truncated: boolean;\n snippet: string;\n};\n\ntype Detail = {\n id: string;\n title: string;\n create_time: number | null;\n update_time: number | null;\n message_count: number;\n char_count: number;\n content_bytes: number;\n content_text: string;\n truncated: number;\n source_file: string;\n imported_at: string;\n};\n\nconst EMPTY_STATS: Stats = {\n conversations: 0,\n messages: 0,\n chars: 0,\n bytes: 0,\n earliest: null,\n latest: null,\n truncated: 0,\n budgetBytes: 8_000_000,\n};\n\nfunction fmtNumber(value: unknown) {\n return new Intl.NumberFormat(\"pt-BR\").format(Number(value ?? 0));\n}\n\nfunction fmtBytes(value: unknown) {\n const n = Number(value ?? 0);\n if (n < 1024) return `${n} B`;\n if (n < 1024 * 1024) return `${(n / 1024).toFixed(1)} KB`;\n return `${(n / 1024 / 1024).toFixed(2)} MB`;\n}\n\nfunction fmtDate(epoch: unknown) {\n const n = Number(epoch ?? 0);\n if (!n) return \"data desconhecida\";\n return new Intl.DateTimeFormat(\"pt-BR\", { dateStyle: \"medium\", timeStyle: \"short\" }).format(new Date(n * 1000));\n}\n\nfunction partText(part: any): string {\n if (typeof part === \"string\") return part;\n if (!part || typeof part !== \"object\") return \"\";\n if (typeof part.text === \"string\") return part.text;\n if (typeof part.content === \"string\") return part.content;\n if (part.asset_pointer) return `[mídia: ${String(part.asset_pointer).slice(0, 80)}]`;\n return \"\";\n}\n\nfunction messageText(message: any): string {\n const content = message?.content;\n if (!content) return \"\";\n if (Array.isArray(content.parts)) return content.parts.map(partText).filter(Boolean).join(\"\\n\");\n if (typeof content.text === \"string\") return content.text;\n return \"\";\n}\n\nfunction activeNodes(conv: any): any[] {\n const mapping = conv?.mapping && typeof conv.mapping === \"object\" ? conv.mapping : {};\n const current = conv?.current_node;\n if (current && mapping[current]) {\n const nodes: any[] = [];\n const seen = new Set();\n let id: string | null = current;\n while (id && mapping[id] && !seen.has(id)) {\n seen.add(id);\n nodes.push(mapping[id]);\n id = mapping[id]?.parent ?? null;\n }\n return nodes.reverse();\n }\n return Object.values(mapping).sort((a: any, b: any) => {\n const at = Number(a?.message?.create_time ?? 0);\n const bt = Number(b?.message?.create_time ?? 0);\n return at - bt;\n });\n}\n\nfunction normalizeConversation(conv: any, sourceFile: string) {\n const messages = activeNodes(conv)\n .map((node: any) => node?.message)\n .filter(Boolean)\n .map((message: any) => {\n const text = messageText(message).trim();\n if (!text) return null;\n const role = String(message?.author?.role ?? \"unknown\").toUpperCase();\n return `[${role}]\\n${text}`;\n })\n .filter(Boolean) as string[];\n\n let contentText = messages.join(\"\\n\\n\");\n let truncated = false;\n const HARD_LIMIT = 590_000;\n if (contentText.length > HARD_LIMIT) {\n const half = 294_000;\n contentText = `${contentText.slice(0, half)}\\n\\n[... TRECHO CENTRAL OMITIDO NA V0.1 ...]\\n\\n${contentText.slice(-half)}`;\n truncated = true;\n }\n\n let id = String(conv?.id ?? conv?.conversation_id ?? \"\").trim();\n if (!/^[A-Za-z0-9_-]{1,160}$/.test(id)) {\n id = `fallback_${Math.abs(hashString(`${conv?.title ?? \"\"}|${conv?.create_time ?? \"\"}|${sourceFile}`))}`;\n }\n\n return {\n id,\n title: String(conv?.title ?? \"Sem título\").slice(0, 300),\n createTime: Number.isFinite(Number(conv?.create_time)) ? Number(conv.create_time) : null,\n updateTime: Number.isFinite(Number(conv?.update_time)) ? Number(conv.update_time) : null,\n messageCount: messages.length,\n contentText,\n truncated,\n sourceFile,\n };\n}\n\nfunction hashString(input: string) {\n let hash = 0;\n for (let i = 0; i < input.length; i++) hash = ((hash << 5) - hash + input.charCodeAt(i)) | 0;\n return hash;\n}\n\nasync function jsonFetch(url: string, init?: RequestInit) {\n const res = await fetch(url, init);\n const data = await res.json().catch(() => ({}));\n if (!res.ok) {\n const error: any = new Error(data?.error ?? `HTTP ${res.status}`);\n error.status = res.status;\n error.data = data;\n throw error;\n }\n return data;\n}\n\nexport function App() {\n const [stats, setStats] = useState(EMPTY_STATS);\n const [me, setMe] = useState(null);\n const [query, setQuery] = useState(\"\");\n const [results, setResults] = useState([]);\n const [searching, setSearching] = useState(false);\n const [searched, setSearched] = useState(false);\n const [detail, setDetail] = useState(null);\n const [detailLoading, setDetailLoading] = useState(false);\n const [importLimit, setImportLimit] = useState(25);\n const [importing, setImporting] = useState(false);\n const [importProgress, setImportProgress] = useState({ done: 0, total: 0 });\n const [notice, setNotice] = useState(\"\");\n\n const usedPct = useMemo(() => {\n if (!stats.budgetBytes) return 0;\n return Math.min(100, (Number(stats.bytes) / Number(stats.budgetBytes)) * 100);\n }, [stats]);\n\n async function refresh() {\n const [meData, statsData] = await Promise.all([jsonFetch(\"/api/me\"), jsonFetch(\"/api/stats\")]);\n setMe(meData);\n setStats({ ...EMPTY_STATS, ...statsData });\n }\n\n useEffect(() => {\n refresh().catch((err) => setNotice(`Falha ao carregar o cofre: ${err.message}`));\n }, []);\n\n async function search() {\n const q = query.trim();\n if (q.length < 2) {\n setNotice(\"Digite pelo menos 2 caracteres para pesquisar.\");\n return;\n }\n setSearching(true);\n setNotice(\"\");\n try {\n const data = await jsonFetch(`/api/search?q=${encodeURIComponent(q)}`);\n setResults(data.results ?? []);\n setSearched(true);\n } catch (err: any) {\n setNotice(`Pesquisa falhou: ${err.message}`);\n } finally {\n setSearching(false);\n }\n }\n\n async function openConversation(id: string) {\n setDetailLoading(true);\n try {\n const data = await jsonFetch(`/api/conversations/${encodeURIComponent(id)}`);\n setDetail(data);\n } catch (err: any) {\n setNotice(`Não consegui abrir a conversa: ${err.message}`);\n } finally {\n setDetailLoading(false);\n }\n }\n\n async function importFiles(fileList: FileList | null) {\n if (!fileList?.length || importing) return;\n setImporting(true);\n setNotice(\"Lendo o export localmente no seu navegador…\");\n setImportProgress({ done: 0, total: 0 });\n\n try {\n const candidates: Array<{ conv: any; sourceFile: string }> = [];\n for (const file of Array.from(fileList)) {\n const text = await file.text();\n let parsed: any;\n try {\n parsed = JSON.parse(text);\n } catch {\n throw new Error(`${file.name} não é um JSON válido.`);\n }\n const conversations = Array.isArray(parsed)\n ? parsed\n : Array.isArray(parsed?.conversations)\n ? parsed.conversations\n : [];\n for (const conv of conversations) {\n if (conv && (conv.mapping || conv.title)) candidates.push({ conv, sourceFile: file.name });\n }\n }\n\n if (!candidates.length) throw new Error(\"Não encontrei conversas reconhecíveis nesses arquivos.\");\n\n candidates.sort((a, b) => Number(b.conv?.update_time ?? 0) - Number(a.conv?.update_time ?? 0));\n const selected = candidates.slice(0, importLimit);\n setImportProgress({ done: 0, total: selected.length });\n\n let imported = 0;\n let truncated = 0;\n let stoppedByBudget = false;\n let skipped = 0;\n\n for (let i = 0; i < selected.length; i++) {\n const normalized = normalizeConversation(selected[i].conv, selected[i].sourceFile);\n if (!normalized.contentText.trim()) {\n skipped++;\n setImportProgress({ done: i + 1, total: selected.length });\n continue;\n }\n try {\n await jsonFetch(`/api/conversations/${encodeURIComponent(normalized.id)}`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(normalized),\n });\n imported++;\n if (normalized.truncated) truncated++;\n } catch (err: any) {\n if (err?.data?.error === \"vault_budget_exceeded\") {\n stoppedByBudget = true;\n setImportProgress({ done: i, total: selected.length });\n break;\n }\n skipped++;\n }\n setImportProgress({ done: i + 1, total: selected.length });\n }\n\n await refresh();\n const pieces = [`${imported} conversa(s) importada(s)`];\n if (truncated) pieces.push(`${truncated} longa(s) resumida(s) nas extremidades pela V0.1`);\n if (skipped) pieces.push(`${skipped} ignorada(s)`);\n if (stoppedByBudget) pieces.push(\"importação interrompida antes do limite seguro de armazenamento\");\n setNotice(pieces.join(\" • \"));\n } catch (err: any) {\n setNotice(`Importação falhou: ${err.message}`);\n } finally {\n setImporting(false);\n }\n }\n\n async function logout() {\n await fetch(\"/auth/logout\", { method: \"POST\" }).catch(() => {});\n location.href = \"/\";\n }\n\n return (\n

GUH Knowledge Vault

V0.1 • sem API da OpenAI

\n \n

\n\n

\n \n Cofre autenticado: @{me?.username ?? \"…\"}\n

\n Pesquise seu próprio histórico do ChatGPT como uma base sua.\n

\n O arquivo é lido primeiro no seu navegador. Nesta versão de teste, apenas as conversas selecionadas e normalizadas são enviadas ao SQLite do seu Val Town.\n

\n\n

\n \n \n \n \n

\n\n

Busca universal

Título + conteúdo das mensagens importadas

até 25 resultados

\n setQuery((e.target as HTMLInputElement).value)}\n onKeyDown={(e) => e.key === \"Enter\" && search()}\n placeholder=\"Ex.: Kernel, NR12, hepatite, timeout…\"\n className=\"min-w-0 flex-1 rounded-2xl bg-black/25 border border-white/10 px-4 py-4 outline-none focus:border-emerald-300/50 placeholder:text-slate-600\"\n />\n \n

\n\n {notice && (\n

{notice}

\n )}\n\n {searched && (\n

Resultados

\n {results.length} encontrado(s)\n

\n {results.map((item) => (\n \n ))}\n {!results.length &&

Nada encontrado nas conversas importadas.

}\n

\n )}\n\n

Importar export do ChatGPT

Escolha conversations.json ou arquivos numerados do export.

local → cofre

\n\n

\n \n \n {importing ? `Importando ${importProgress.done}/${importProgress.total || \"…\"}` : \"Selecionar arquivo(s) JSON\"}\n importFiles((e.target as HTMLInputElement).files)} />\n \n

\n\n

\n SQLite usado\n {usedPct.toFixed(1)}%\n

\n\n

\n V0.1 reserva ~8 MB para conteúdo dentro do SQLite Free. Conversas acima de ~590 mil caracteres preservam o início e o final e são marcadas como parciais. A versão seguinte pode mover o arquivo histórico completo para armazenamento maior.\n

\n\n

\n \n \n \n

\n\n \n

\n\n {(detail || detailLoading) && (\n

!detailLoading && setDetail(null)}>\n

e.stopPropagation()}>\n {detailLoading && !detail ? (\n

Abrindo conversa…

\n ) : detail ? (\n <>\n

{detail.title}

{fmtDate(detail.update_time)} • {fmtNumber(detail.message_count)} mensagens • {fmtBytes(detail.content_bytes)}

\n \n

\n {Boolean(detail.truncated) &&

Esta conversa excedeu o limite individual da V0.1; o início e o final foram preservados, mas o trecho central não foi armazenado.

}\n

{detail.content_text}

Origem: {detail.source_file} • importado em {detail.imported_at}

\n \n ) : null}\n

\n )}\n

\n );\n}\n\nfunction Stat({ label, value }: { label: string; value: string }) {\n return (\n

{label}

{value}

\n );\n}\n\nfunction Mini({ label, text }: { label: string; text: string }) {\n return (\n

{label}

{text}

\n );\n}\n","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useMemo, useState } from \"https://esm.sh/react@18.2.0\";\n\ntype Stats = {\n conversations: number;\n messages: number;\n indexedMessages: number;\n checkpoints: number;\n chars: number;\n bytes: number;\n earliest: number | null;\n latest: number | null;\n truncated: number;\n budgetBytes: number;\n};\n\ntype SearchResult = {\n id: string;\n title: string;\n createTime: number | null;\n updateTime: number | null;\n messageCount: number;\n charCount: number;\n contentBytes: number;\n truncated: boolean;\n snippet: string;\n role?: string;\n messageId?: string;\n rank?: number;\n};\n\ntype IndexedMessage = {\n id: string;\n seq: number;\n role: string;\n create_time: number | null;\n content_text: string;\n char_count: number;\n content_bytes: number;\n};\n\ntype Detail = {\n id: string;\n title: string;\n create_time: number | null;\n update_time: number | null;\n message_count: number;\n char_count: number;\n content_bytes: number;\n content_text: string;\n truncated: number;\n source_file: string;\n imported_at: string;\n indexed_messages?: IndexedMessage[];\n};\n\ntype Checkpoint = {\n id: string;\n project: string;\n title: string;\n summary: string;\n decisions: string;\n open_gaps: string;\n next_action: string;\n evidence_state: string;\n created_at: string;\n updated_at: string;\n};\n\ntype CheckpointHit = {\n id: string;\n project: string;\n title: string;\n snippet: string;\n rank?: number;\n};\n\nconst EMPTY_STATS: Stats = {\n conversations: 0,\n messages: 0,\n indexedMessages: 0,\n checkpoints: 0,\n chars: 0,\n bytes: 0,\n earliest: null,\n latest: null,\n truncated: 0,\n budgetBytes: 8_000_000,\n};\n\nfunction fmtNumber(value: unknown) {\n return new Intl.NumberFormat(\"pt-BR\").format(Number(value ?? 0));\n}\n\nfunction fmtBytes(value: unknown) {\n const n = Number(value ?? 0);\n if (n < 1024) return `${n} B`;\n if (n < 1024 * 1024) return `${(n / 1024).toFixed(1)} KB`;\n return `${(n / 1024 / 1024).toFixed(2)} MB`;\n}\n\nfunction fmtDate(epoch: unknown) {\n const n = Number(epoch ?? 0);\n if (!n) return \"data desconhecida\";\n return new Intl.DateTimeFormat(\"pt-BR\", { dateStyle: \"medium\", timeStyle: \"short\" }).format(new Date(n * 1000));\n}\n\nfunction fmtIso(value: string) {\n const d = new Date(value);\n return Number.isNaN(d.getTime()) ? value : new Intl.DateTimeFormat(\"pt-BR\", { dateStyle: \"medium\", timeStyle: \"short\" }).format(d);\n}\n\nfunction partText(part: any): string {\n if (typeof part === \"string\") return part;\n if (!part || typeof part !== \"object\") return \"\";\n if (typeof part.text === \"string\") return part.text;\n if (typeof part.content === \"string\") return part.content;\n if (part.asset_pointer) return `[mídia: ${String(part.asset_pointer).slice(0, 80)}]`;\n return \"\";\n}\n\nfunction messageText(message: any): string {\n const content = message?.content;\n if (!content) return \"\";\n if (Array.isArray(content.parts)) return content.parts.map(partText).filter(Boolean).join(\"\\n\");\n if (typeof content.text === \"string\") return content.text;\n return \"\";\n}\n\nfunction activeNodes(conv: any): any[] {\n const mapping = conv?.mapping && typeof conv.mapping === \"object\" ? conv.mapping : {};\n const current = conv?.current_node;\n if (current && mapping[current]) {\n const nodes: any[] = [];\n const seen = new Set();\n let id: string | null = current;\n while (id && mapping[id] && !seen.has(id)) {\n seen.add(id);\n nodes.push(mapping[id]);\n id = mapping[id]?.parent ?? null;\n }\n return nodes.reverse();\n }\n return Object.values(mapping).sort((a: any, b: any) => {\n const at = Number(a?.message?.create_time ?? 0);\n const bt = Number(b?.message?.create_time ?? 0);\n return at - bt;\n });\n}\n\nfunction hashString(input: string) {\n let hash = 0;\n for (let i = 0; i < input.length; i++) hash = ((hash << 5) - hash + input.charCodeAt(i)) | 0;\n return hash;\n}\n\nfunction normalizeConversation(conv: any, sourceFile: string) {\n let id = String(conv?.id ?? conv?.conversation_id ?? \"\").trim();\n if (!/^[A-Za-z0-9_-]{1,160}$/.test(id)) {\n id = `fallback_${Math.abs(hashString(`${conv?.title ?? \"\"}|${conv?.create_time ?? \"\"}|${sourceFile}`))}`;\n }\n\n const messages = activeNodes(conv)\n .map((node: any) => node?.message)\n .filter(Boolean)\n .map((message: any, index: number) => {\n const text = messageText(message).trim();\n if (!text) return null;\n let messageId = String(message?.id ?? \"\").trim();\n if (!/^[A-Za-z0-9_-]{1,160}$/.test(messageId)) messageId = `${id}_m_${index + 1}`.slice(0, 160);\n return {\n id: messageId,\n role: String(message?.author?.role ?? \"unknown\").toLowerCase().slice(0, 40),\n createTime: Number.isFinite(Number(message?.create_time)) ? Number(message.create_time) : null,\n contentText: text,\n };\n })\n .filter(Boolean) as Array<{ id: string; role: string; createTime: number | null; contentText: string }>;\n\n let contentText = messages.map((message) => `[${message.role.toUpperCase()}]\\n${message.contentText}`).join(\"\\n\\n\");\n let truncated = false;\n const HARD_LIMIT = 590_000;\n if (contentText.length > HARD_LIMIT) {\n const half = 294_000;\n contentText = `${contentText.slice(0, half)}\\n\\n[... TRECHO CENTRAL OMITIDO NO BLOCO LEGADO ...]\\n\\n${contentText.slice(-half)}`;\n truncated = true;\n }\n\n return {\n id,\n title: String(conv?.title ?? \"Sem título\").slice(0, 300),\n createTime: Number.isFinite(Number(conv?.create_time)) ? Number(conv.create_time) : null,\n updateTime: Number.isFinite(Number(conv?.update_time)) ? Number(conv.update_time) : null,\n messageCount: messages.length,\n contentText,\n messages,\n truncated,\n sourceFile,\n };\n}\n\nasync function jsonFetch(url: string, init?: RequestInit) {\n const res = await fetch(url, init);\n const data = await res.json().catch(() => ({}));\n if (!res.ok) {\n const error: any = new Error(data?.error ?? `HTTP ${res.status}`);\n error.status = res.status;\n error.data = data;\n throw error;\n }\n return data;\n}\n\nexport function App() {\n const [stats, setStats] = useState(EMPTY_STATS);\n const [me, setMe] = useState(null);\n const [query, setQuery] = useState(\"\");\n const [results, setResults] = useState([]);\n const [checkpointHits, setCheckpointHits] = useState([]);\n const [searchEngine, setSearchEngine] = useState(\"\");\n const [searching, setSearching] = useState(false);\n const [searched, setSearched] = useState(false);\n const [detail, setDetail] = useState(null);\n const [detailLoading, setDetailLoading] = useState(false);\n const [importLimit, setImportLimit] = useState(25);\n const [importing, setImporting] = useState(false);\n const [importProgress, setImportProgress] = useState({ done: 0, total: 0 });\n const [notice, setNotice] = useState(\"\");\n const [checkpoints, setCheckpoints] = useState([]);\n\n const usedPct = useMemo(() => {\n if (!stats.budgetBytes) return 0;\n return Math.min(100, (Number(stats.bytes) / Number(stats.budgetBytes)) * 100);\n }, [stats]);\n\n async function refresh() {\n const [meData, statsData, checkpointData] = await Promise.all([\n jsonFetch(\"/api/me\"),\n jsonFetch(\"/api/stats\"),\n jsonFetch(\"/api/checkpoints?limit=5\"),\n ]);\n setMe(meData);\n setStats({ ...EMPTY_STATS, ...statsData });\n setCheckpoints(checkpointData.checkpoints ?? []);\n }\n\n useEffect(() => {\n refresh().catch((err) => setNotice(`Falha ao carregar o cofre: ${err.message}`));\n }, []);\n\n async function search() {\n const q = query.trim();\n if (q.length < 2) {\n setNotice(\"Digite pelo menos 2 caracteres para pesquisar.\");\n return;\n }\n setSearching(true);\n setNotice(\"\");\n try {\n const data = await jsonFetch(`/api/search?q=${encodeURIComponent(q)}`);\n setResults(data.results ?? []);\n setCheckpointHits(data.checkpoints ?? []);\n setSearchEngine(data.engine ?? \"\");\n setSearched(true);\n } catch (err: any) {\n setNotice(`Pesquisa falhou: ${err.message}`);\n } finally {\n setSearching(false);\n }\n }\n\n async function openConversation(id: string) {\n setDetailLoading(true);\n setDetail(null);\n try {\n const data = await jsonFetch(`/api/conversations/${encodeURIComponent(id)}`);\n setDetail(data);\n } catch (err: any) {\n setNotice(`Não consegui abrir a conversa: ${err.message}`);\n } finally {\n setDetailLoading(false);\n }\n }\n\n async function importFiles(fileList: FileList | null) {\n if (!fileList?.length || importing) return;\n setImporting(true);\n setNotice(\"Lendo o export localmente no seu navegador…\");\n setImportProgress({ done: 0, total: 0 });\n\n try {\n const candidates: Array<{ conv: any; sourceFile: string }> = [];\n for (const file of Array.from(fileList)) {\n const text = await file.text();\n let parsed: any;\n try {\n parsed = JSON.parse(text);\n } catch {\n throw new Error(`${file.name} não é um JSON válido.`);\n }\n const conversations = Array.isArray(parsed)\n ? parsed\n : Array.isArray(parsed?.conversations)\n ? parsed.conversations\n : [];\n for (const conv of conversations) {\n if (conv && (conv.mapping || conv.title)) candidates.push({ conv, sourceFile: file.name });\n }\n }\n\n if (!candidates.length) throw new Error(\"Não encontrei conversas reconhecíveis nesses arquivos.\");\n\n candidates.sort((a, b) => Number(b.conv?.update_time ?? 0) - Number(a.conv?.update_time ?? 0));\n const selected = candidates.slice(0, importLimit);\n setImportProgress({ done: 0, total: selected.length });\n\n let imported = 0;\n let indexedMessages = 0;\n let truncated = 0;\n let stoppedByBudget = false;\n let skipped = 0;\n\n for (let i = 0; i < selected.length; i++) {\n const normalized = normalizeConversation(selected[i].conv, selected[i].sourceFile);\n if (!normalized.contentText.trim()) {\n skipped++;\n setImportProgress({ done: i + 1, total: selected.length });\n continue;\n }\n try {\n const outcome = await jsonFetch(`/api/conversations/${encodeURIComponent(normalized.id)}`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(normalized),\n });\n imported++;\n indexedMessages += Number(outcome.indexedMessages ?? 0);\n if (normalized.truncated) truncated++;\n } catch (err: any) {\n if (err?.data?.error === \"vault_budget_exceeded\") {\n stoppedByBudget = true;\n setImportProgress({ done: i, total: selected.length });\n break;\n }\n skipped++;\n }\n setImportProgress({ done: i + 1, total: selected.length });\n }\n\n await refresh();\n const pieces = [`${imported} conversa(s) importada(s)`, `${indexedMessages} mensagem(ns) indexada(s)`];\n if (truncated) pieces.push(`${truncated} longa(s) com bloco legado parcial`);\n if (skipped) pieces.push(`${skipped} ignorada(s)`);\n if (stoppedByBudget) pieces.push(\"importação interrompida antes do limite seguro de armazenamento\");\n setNotice(pieces.join(\" • \"));\n } catch (err: any) {\n setNotice(`Importação falhou: ${err.message}`);\n } finally {\n setImporting(false);\n }\n }\n\n async function logout() {\n await fetch(\"/auth/logout\", { method: \"POST\" }).catch(() => {});\n location.href = \"/\";\n }\n\n return (\n

GUH Knowledge Vault

V0.2 • FTS5/BM25 • sem API OpenAI

\n \n

\n\n

\n \n Cofre autenticado: @{me?.username ?? \"…\"}\n

\n Sua memória começa a virar infraestrutura para agentes.\n

\n Histórico importado por mensagens + checkpoints gravados durante o trabalho. A busca agora usa índice full-text e ranking local, sem chamada de IA.\n

\n\n

\n \n \n \n \n \n \n

\n\n

Busca universal

Mensagens individualizadas • FTS5/BM25 com fallback legado

até 25 resultados

\n setQuery((e.target as HTMLInputElement).value)}\n onKeyDown={(e) => e.key === \"Enter\" && search()}\n placeholder=\"Ex.: Kernel timeout, NR-12, reconciliação…\"\n className=\"min-w-0 flex-1 rounded-2xl bg-black/25 border border-white/10 px-4 py-4 outline-none focus:border-emerald-300/50 placeholder:text-slate-600\"\n />\n \n

\n\n {notice && (\n

{notice}

\n )}\n\n {searched && (\n

Conversas

\n {results.length} • {searchEngine || \"—\"}\n

\n {results.map((item) => (\n \n ))}\n {!results.length &&

Nenhuma conversa encontrada.

}\n

\n\n

Checkpoints relacionados

\n {checkpointHits.length}\n

\n {checkpointHits.map((hit) => (\n

\n {hit.project}\n memória viva\n

{hit.title}

{hit.snippet}

\n ))}\n {!checkpointHits.length &&

Nenhum checkpoint relacionado.

}\n

\n )}\n\n

Checkpoints do trabalho

Conhecimento novo pode entrar no Vault sem esperar outro export.

ChatGPT → Vault

\n {checkpoints.map((cp) => (\n

\n {cp.project}\n {cp.evidence_state}\n

{cp.title}

{cp.summary}

\n {cp.next_action &&

Próxima ação: {cp.next_action}

}\n

{fmtIso(cp.updated_at)}

\n ))}\n {!checkpoints.length &&

Nenhum checkpoint ainda.

}\n

\n\n

Importar export do ChatGPT

Escolha conversations.json ou arquivos numerados do export.

local → mensagens → índice

\n\n

\n \n \n {importing ? `Importando ${importProgress.done}/${importProgress.total || \"…\"}` : \"Selecionar arquivo(s) JSON\"}\n importFiles((e.target as HTMLInputElement).files)} />\n \n

\n\n

\n Conteúdo legado usado\n {usedPct.toFixed(1)}%\n

\n\n

\n A V0.2 ainda preserva o bloco de conversa da V0.1 por compatibilidade, mas também cria uma linha por mensagem e um índice FTS5. O próximo salto de armazenamento deve mover o histórico completo para uma camada maior antes de importar milhares de conversas.\n

\n\n

\n \n \n \n

\n\n \n

\n\n {(detail || detailLoading) && (\n

!detailLoading && setDetail(null)}>\n

e.stopPropagation()}>\n {detailLoading && !detail ? (\n

Abrindo conversa…

\n ) : detail ? (\n <>\n

{detail.title}

\n {fmtDate(detail.update_time)} • {fmtNumber(detail.message_count)} mensagens • {fmtBytes(detail.content_bytes)}\n {detail.indexed_messages?.length ? ` • ${detail.indexed_messages.length} indexadas` : \"\"}\n

\n \n

\n {Boolean(detail.truncated) &&

O bloco legado desta conversa foi truncado, mas mensagens individualizadas podem preservar mais contexto conforme os limites por mensagem.

}\n {detail.indexed_messages?.length ? (\n

\n {detail.indexed_messages.map((message) => (\n

{message.role}

{message.content_text}

\n ))}\n

\n ) : (\n

{detail.content_text}

\n )}\n

Origem: {detail.source_file} • importado em {detail.imported_at}

\n \n ) : null}\n

\n )}\n

\n );\n}\n\nfunction Stat({ label, value }: { label: string; value: string }) {\n return (\n

{label}

{value}

\n );\n}\n\nfunction Mini({ label, text }: { label: string; text: string }) {\n return (\n

{label}

{text}

\n );\n}\n",["D",1788727497920],"id","348a33bb-f2d9-4c7a-b6a6-b2762cf9a17f","guh-knowledge-vault",["D",1788716337448],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Private searchable mirror of ChatGPT exports","imageUrl","6cc24525-830b-4db3-9c9c-fd19fb50e91f","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0773d-9d6b-7580-a53a-683363c351c8","tursoName","348a33bbf2d94c7ab6a6b2762cf9a17f","tursoHostname","348a33bbf2d94c7ab6a6b2762cf9a17f-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789499469860],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_123":122,"_131":127},"org",{"_123":122,"_124":125,"_126":127,"_18":79,"_128":129,"_130":27},"branch",{"_13":112,"_34":113,"_67":43,"_114":68,"_115":-5,"_116":-5,"_117":-5,"_118":-5,"_119":-5,"_120":69,"_121":122},"isOwned",38,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","cleitoncosta","handle","displayName","Cleiton Costa","avatar","https://lh3.googleusercontent.com/a/ACg8ocIgWisWQiXts_2fy5iRiRgl8A6c7Ef94eqE3ur-4mlyUrpCBmQ=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_67":68,"_34":69,"_39":262,"_71":-5,"_72":27,"_73":74,"_75":74,"_76":77,"_78":-5,"_18":79,"_80":47,"_81":82,"_83":-5,"_84":-5,"_85":86,"_87":88,"_89":90,"_91":92,"_93":263,"_95":-5,"_96":97,"_98":97,"_99":100,"_101":100,"_102":100,"_103":97,"_104":97,"_105":264,"_107":265,"_109":266,"_111":27},"tree",[197,204,205,206,207],"files",[197,198,199,200,201,202,203,204,205,206,207],"counts",{"_186":86,"_187":188,"_189":86,"_190":191,"_192":193},"contents",[154,155,156,157,158],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_67":180,"_34":181,"_32":182,"_160":-5,"_42":43,"_41":176,"_161":82,"_39":183,"_13":86,"_35":184,"_37":-5,"_26":27,"_163":-5,"_29":185},{"_67":173,"_34":174,"_32":175,"_160":-5,"_42":43,"_41":176,"_161":27,"_39":177,"_13":86,"_35":23,"_37":178,"_26":27,"_163":-5,"_29":179},{"_67":169,"_34":54,"_32":55,"_160":-5,"_42":43,"_41":14,"_161":27,"_39":170,"_13":171,"_35":23,"_37":57,"_26":27,"_163":-5,"_29":172},{"_67":165,"_34":46,"_32":47,"_160":-5,"_42":43,"_41":14,"_161":27,"_39":166,"_13":167,"_35":48,"_37":50,"_26":27,"_163":69,"_29":168},{"_67":159,"_34":30,"_32":33,"_160":-5,"_42":43,"_41":14,"_161":82,"_39":162,"_13":86,"_35":36,"_37":38,"_26":27,"_163":-5,"_29":164},"c37a2581-a3ad-472c-b2e4-05d1860472b5","parentId","latest",["D",1788727497920],"label",[30],"f518dfc7-7991-43a5-943c-4865794fe089",["D",1788727497920],2,[46],"e25482ca-0ff6-4542-8a13-92b9f5c5f764",["D",1788727497920],3,[54],"e78a54fa-2796-4dae-b788-65daebb56fb8","CHANGELOG.md","01a077cd-4980-75c9-8c9f-08b802212cc9",1,["D",1788716337448],"# Changelog\n\n## 2026-07-30 — Immutable asset caching\n\nFrontend files are now served at version-addressed URLs\n(`/__immutable/45/frontend/index.tsx`) with\n`Cache-Control: public, max-age=31536000, immutable`, so repeat visits load the\nwhole client graph from the browser cache — roughly 3× faster (~665ms → ~157ms\nmeasured). Publishing your val bumps its version, which changes every URL, so\ncaches invalidate automatically. Old-version URLs return 404 after a publish\n(like Next.js build assets); a reload picks up the new version.\n\nWhat changed in the template:\n\n- `frontend/index.html` → [`frontend/root.tsx`](/frontend/root.tsx): the HTML\n shell is now JSX and stamps asset URLs with `immutableFileUrl()`\n- [`index.ts`](/index.ts): serves `Root()` at `/`, and one\n `app.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path))` route\n serves all frontend files\n\n### Upgrading an existing remix\n\nYour copy of this template doesn't update automatically. Two options:\n\n**Minimal (most of the benefit):** point both routes at `serveImmutableFile` —\nyour existing bare URLs redirect into versioned space, the new route serves\nthem, and the whole module graph gets cached (costs one redirect per page view):\n\n```ts\nimport { serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\n\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/frontend/**/*\", (c) => serveImmutableFile(c.req.path)); // was serveFile\n```\n\n**Full upgrade (also removes the redirect):** three self-contained steps —\nno other files needed. Adjust the ``, favicon, and body of `Root()` to\nmatch your app's existing `index.html`, and stamp anything else your shell\nreferences directly (images, css) with `immutableFileUrl()`.\n\n1. Create `frontend/root.tsx`:\n\n```tsx\n/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The HTML shell for the app. It is never cached, so immutableFileUrl can stamp\n// the current val version into each asset URL — the browser caches those\n// immutably, and publishing the val changes the URLs, refetching exactly once.\nexport function Root() {\n return (\n <>\n {raw(\"<!DOCTYPE html>\")}\n <html lang=\"en\">\n <head>\n <meta charSet=\"UTF-8\" />\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n <title>React Hono Val Town Starter\n

Diff · v7