[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_94":93,"_32":44,"_102":84,"_27":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":25,"_117":118,"_119":56,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":31,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":25},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","6aac1dfe-543b-11f0-97c6-f69ea79377d9","name","fileType","http","content","// @ts-ignore\nimport { blob } from \"https://esm.town/v/std/blob?v=11\";\nimport { OpenAI } from \"https://esm.town/v/std/openai?v=11\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite?v=4\";\nimport { Hono } from \"npm:hono@4.4.12\";\nimport { cors } from \"npm:hono@4.4.12/cors\";\n\n// --- DATABASE INITIALIZATION & SCHEMA ---\nconst DB_SETUP = `\nCREATE TABLE IF NOT EXISTS todos (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT NOT NULL,\n first_steps TEXT,\n votes INTEGER NOT NULL DEFAULT 1,\n status TEXT NOT NULL DEFAULT 'active',\n embedding BLOB NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n);`;\n\nlet isInitialized = false;\n\nasync function initialize() {\n if (isInitialized) return;\n await sqlite.execute(DB_SETUP);\n isInitialized = true;\n}\n\n// --- RESILIENT JSON PARSING HELPER ---\nfunction extractJson(text: string): any {\n try {\n const startIndex = text.indexOf(\"{\");\n const endIndex = text.lastIndexOf(\"}\");\n if (startIndex === -1 || endIndex === -1 || endIndex < startIndex) {\n throw new Error(\"No valid JSON object found in the provided text.\");\n }\n const jsonString = text.substring(startIndex, endIndex + 1);\n return JSON.parse(jsonString);\n } catch (e) {\n console.error(\"Original text from AI that failed parsing:\", text);\n throw new Error(`Failed to extract or parse JSON from AI response: ${e.message}`);\n }\n}\n\n// --- AI BEHAVIORAL GUIDELINES & PROMPTS ---\nconst GENERATION_STYLE_GUIDE =\n \"Adopt the persona of a highly-structured, analytical strategist. Your language must be precise, professional, and devoid of embellishment. Focus on clarity, actionability, and objective framing. The goal is to transform raw ideas into well-defined project briefs that inspire confidence and methodical execution, not emotional excitement. Your output should reflect the structured thinking of a seasoned project manager.\";\n\nconst TASK_REFINEMENT_PROMPT = `\nYou are a task analysis and refinement system. Analyze the following user-submitted to-do item.\n1. **Validation**: Determine if it is a valid, actionable goal or if it is spam, nonsense, or offensive.\n2. **Refinement**: If valid, rewrite the title to be a clear, concise, and professional call to action.\n3. **Summarization**: Generate a brief, one-sentence description of the task's core objective.\n4. **Decomposition**: Break the task down into 2-4 concrete, achievable first steps.\n\nRespond ONLY with a single, minified JSON object.\n- If invalid, respond with: \\`{\"valid\": false}\\`.\n- If valid, use this structure: \\`{\"valid\": true, \"title\": \"...\", \"description\": \"...\", \"first_steps\": [...]}\\`.\n${GENERATION_STYLE_GUIDE}\n`;\n\nconst DUPLICATE_ANALYSIS_PROMPT = `\nYou are a task consolidation analyst. A user submitted a task ('New Task') that is semantically similar to an existing one ('Existing Task').\nYour sole function is to determine if these two tasks are fundamentally aiming for the same outcome, even if worded differently.\nDo not compare for superficial similarities; analyze the core intent.\nRespond ONLY with a single, minified JSON object: \\`{\"is_duplicate\": boolean, \"reason\": \"A brief, clinical explanation for the consolidation.\"}\\`.\n${GENERATION_STYLE_GUIDE}\n`;\n\n// --- CORE AI & DATABASE LOGIC ---\nconst openai = new OpenAI();\nfunction cosineSimilarity(vecA, vecB) {\n let dotProduct = 0.0;\n let normA = 0.0;\n let normB = 0.0;\n for (let i = 0; i < vecA.length; i++) {\n dotProduct += vecA[i] * vecB[i];\n normA += vecA[i] * vecA[i];\n normB += vecB[i] * vecB[i];\n }\n return dotProduct / (Math.sqrt(normA) * Math.sqrt(normB));\n}\nasync function getTodos() {\n const { columns, rows } = await sqlite.execute(\n \"SELECT id, title, description, first_steps, votes FROM todos WHERE status = 'active' ORDER BY votes DESC, created_at DESC\",\n );\n return rows.map(row => {\n const todo = {};\n for (const [i, col] of columns.entries()) { todo[col] = row[i]; }\n return todo;\n });\n}\nasync function addTodo(rawTitle: string) {\n const refinementCompletion = await openai.chat.completions.create({\n model: \"gpt-4o\",\n messages: [{ role: \"system\", content: TASK_REFINEMENT_PROMPT }, {\n role: \"user\",\n content: `User Submission: \"${rawTitle}\"`,\n }],\n response_format: { type: \"json_object\" },\n });\n const refinedTask = extractJson(refinementCompletion.choices[0].message.content);\n\n if (!refinedTask.valid) { throw new Error(\"Submission was determined to be invalid by AI moderation.\"); }\n\n const embeddingResponse = await openai.embeddings.create({\n model: \"text-embedding-3-small\",\n input: refinedTask.title,\n });\n const newEmbedding = embeddingResponse.data[0].embedding;\n\n const existingTodos = await sqlite.execute(\"SELECT id, title, votes, embedding FROM todos WHERE status = 'active'\");\n let mostSimilarTodo = null;\n let highestSimilarity = 0;\n for (const row of existingTodos.rows) {\n const existingEmbedding = JSON.parse(new TextDecoder().decode(row[3]));\n const similarity = cosineSimilarity(newEmbedding, existingEmbedding);\n if (similarity > highestSimilarity) {\n highestSimilarity = similarity;\n mostSimilarTodo = { id: row[0], title: row[1], votes: row[2] };\n }\n }\n\n if (highestSimilarity > 0.92) {\n const duplicateCheck = await openai.chat.completions.create({\n model: \"gpt-4o\",\n messages: [{ role: \"system\", content: DUPLICATE_ANALYSIS_PROMPT }, {\n role: \"user\",\n content: `New Task: \"${refinedTask.title}\"\\nExisting Task: \"${mostSimilarTodo.title}\"`,\n }],\n response_format: { type: \"json_object\" },\n });\n const { is_duplicate, reason } = extractJson(duplicateCheck.choices[0].message.content);\n\n if (is_duplicate) {\n await sqlite.execute({\n sql: \"UPDATE todos SET votes = votes + 1 WHERE id = :id\",\n args: { id: mostSimilarTodo.id },\n });\n return {\n merged: true,\n message: `Consolidated with existing goal: \"${mostSimilarTodo.title}\". Your vote has been added!`,\n reason,\n };\n }\n }\n\n await sqlite.execute({\n sql:\n `INSERT INTO todos (title, description, first_steps, embedding) VALUES (:title, :description, :first_steps, :embedding)`,\n args: {\n title: refinedTask.title,\n description: refinedTask.description,\n first_steps: JSON.stringify(refinedTask.first_steps),\n embedding: new TextEncoder().encode(JSON.stringify(newEmbedding)),\n },\n });\n return { merged: false, message: \"A new objective has been successfully added to the Global Ledger.\" };\n}\nasync function voteForTodo(id: number, ip: string) {\n const VOTE_LOCK_KEY = `vote_lock:${ip}:${id}`;\n const hasVoted = await blob.getJSON(VOTE_LOCK_KEY);\n if (hasVoted) { throw new Error(\"You have already voted for this item recently.\"); }\n const result = await sqlite.execute({ sql: \"UPDATE todos SET votes = votes + 1 WHERE id = :id\", args: { id } });\n if (result.rowsAffected === 1) {\n await blob.setJSON(VOTE_LOCK_KEY, { votedAt: Date.now() }, { expires: new Date(Date.now() + 24 * 60 * 60 * 1000) });\n return { success: true };\n }\n throw new Error(\"Task not found or unable to update.\");\n}\n\n// --- HTML & FRONTEND ---\nfunction generateHtml(sourceUrl: string) {\n return `\n\n\n \n \n The Global Ledger\n \n \n \n \n\n\n

The Global Ledger

\n \n \n

\n\n\n`;\n}\n\n// --- API ROUTER (Hono) ---\nconst app = new Hono();\napp.use(\"*\", async (c, next) => {\n if (!isInitialized) {\n await initialize();\n }\n await next();\n});\napp.use(\"*\", cors());\napp.get(\"/\", (c) => c.html(generateHtml(c.req.url)));\napp.get(\"/todos\", async (c) => {\n try {\n const todos = await getTodos();\n return c.json(todos);\n } catch (e) {\n return c.json({ error: e.message }, 500);\n }\n});\napp.post(\"/todos\", async (c) => {\n try {\n const { title } = await c.req.json();\n if (!title || typeof title !== \"string\" || title.trim().length < 5) {\n return c.json({ error: \"Submission must be a descriptive string.\" }, 400);\n }\n const result = await addTodo(title);\n return c.json(result);\n } catch (e) {\n return c.json({ error: e.message }, 500);\n }\n});\napp.post(\"/todos/:id/vote\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const ip = c.req.header(\"x-forwarded-for\")?.split(\",\")[0].trim() || \"unknown\";\n await voteForTodo(id, ip);\n return c.json({ success: true });\n } catch (e) {\n return c.json({ error: e.message }, 400);\n }\n});\nexport default app.fetch;","createdAt",["D",1751128372241],"branchVersion","branchId","6aa9f222-543b-11f0-97c6-f69ea79377d9","id","6aa99476-543b-11f0-97c6-f69ea79377d9","globalledger",["D",1751127461776],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","7fd1ce80-4154-11f0-9b42-fd2544d0e4c2","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","fab05645-eef5-482d-8a04-ff855841fbcd","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":53,"_98":99,"_100":25},"branch",{"_13":83,"_32":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"isOwned",23,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","legal","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ5MzJ1NExRM2FoMk1YMUozekw4eDMyaVhrWCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_32":44,"_37":148,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":31,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":149,"_78":150,"_80":151,"_82":25},"tree",[143],"files",[143],"counts",{"_132":60,"_133":134,"_135":60,"_136":137,"_138":139},"contents",[124],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":125,"_32":28,"_30":31,"_126":-5,"_40":41,"_39":14,"_127":25,"_37":128,"_13":129,"_33":34,"_35":36,"_24":25,"_130":-5,"_27":131},"895916f6-543d-11f0-8b6d-f69ea79377d9","parentId","latest",["D",1751128372241],12,"label",[28],"pulls","branches",1,"forks","envVars",{"_140":60,"_142":60},"connections",{"_140":60,"_141":60},"count","unfilledCount","emptyCount",{"_42":125,"_32":28,"_30":31,"_126":-5,"_40":41,"_39":14,"_127":25,"_37":144,"_13":129,"_33":34,"_35":36,"_24":25,"_130":-5,"_145":146,"_27":147},["D",1751128372241],"children",[],[28],["D",1751127461776],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":53,"_98":99,"_100":25},{"_13":83,"_32":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"ctx",{"_76":-5,"_121":185,"_186":187,"_188":189,"_190":25,"_191":25,"_192":25,"_193":56,"_194":-5,"_195":-7,"_196":-7,"_197":60,"_198":25,"_199":25,"_200":-5,"_201":25,"_202":25,"_203":25,"_204":-5},"ENV",{"_156":157,"_158":159,"_160":84,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v13