[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10,"_11":12},"actionData","errors","root",{"_228":-5,"_231":232,"_233":234},"routes/shell",{"_40":41,"_227":-5,"_228":-5,"_229":230},"routes/repo",{"_33":-7,"_34":35,"_36":37,"_38":39,"_40":41,"_42":31,"_43":31,"_44":31,"_45":31,"_46":31,"_47":31,"_48":49,"_50":49,"_51":31,"_52":-7,"_53":-7,"_54":55,"_56":57,"_58":59,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68},"routes/repo.blob",{"_13":14,"_15":16,"_17":18,"_19":20,"_21":14,"_22":23,"_24":-5,"_25":26,"_27":28,"_28":29,"_30":31,"_32":14},"ref","3c052d73d885df4a739c79d5b3cdfc83868fe17b","path","e2e/research-recovery-database.ts","oid","9ee508fd6a592cd1e9acdfbc8e379ddf8a9dceee","size",11021,"commit","mounts",[],"source","plain",{"_13":14,"_15":16},"kind","text","import { SQL } from \"bun\";\nimport { ulid } from \"../packages/dialect/src/ulid\";\nimport { testChannelPath } from \"./database\";\n\nconst DEFAULT_DATABASES: Record = {\n\t8788: \"postgresql://chopin:chopin@127.0.0.1:5433/chopin?sslmode=disable\",\n\t8789: \"postgresql://chopin:chopin@127.0.0.1:5434/chopin?sslmode=disable\",\n};\n\nfunction url(port: number): string {\n\tlet index = port === 8789 ? 1 : 0;\n\treturn process.env[`E2E_DATABASE_URL_${index}`] || DEFAULT_DATABASES[port]!;\n}\n\nasync function sql(port: number, action: (database: SQL) => Promise): Promise {\n\tlet database = new SQL(url(port));\n\ttry {\n\t\treturn await action(database);\n\t} finally {\n\t\tawait database.close();\n\t}\n}\n\nexport async function seedPendingInlineResearchRequest(\n\tport: number,\n\tchannelId: string,\n\tquestion: string,\n\trequestId: string,\n\tcreatedBy = \"U_e2e\",\n\tplannerOriginMessageId?: string,\n): Promise<{ jobId: string; workspaceId: string }> {\n\tlet workspaceId = ulid();\n\tlet turnId = ulid();\n\tlet messageId = ulid();\n\tlet jobId = ulid();\n\tlet targetKey = `research-evidence:workspace:${workspaceId}:turn:${turnId}:evidence`;\n\tlet now = new Date();\n\tlet availableAt = new Date(now.getTime() + 24 * 60 * 60 * 1000);\n\tawait sql(port, async database => {\n\t\tawait database.begin(async transaction => {\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO background_job_channels (channel_id, revision)\n\t\t\t\tVALUES (${channelId}, 1)\n\t\t\t\tON CONFLICT (channel_id) DO UPDATE\n\t\t\t\tSET revision = background_job_channels.revision + 1\n\t\t\t`;\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO background_job_targets (channel_id, target_key, generation)\n\t\t\t\tVALUES (${channelId}, ${targetKey}, 1)\n\t\t\t`;\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO background_jobs (\n\t\t\t\t\tid, channel_id, type, version, origin, target_key, target_generation,\n\t\t\t\t\tidempotency_key, fingerprint, input, state, revision, attempts, failures,\n\t\t\t\t\tclaim_generation, available_at, created_at, updated_at\n\t\t\t\t) VALUES (\n\t\t\t\t\t${jobId}, ${channelId}, 'research-evidence', 1, 'user', ${targetKey}, 1,\n\t\t\t\t\t${`research-evidence:${turnId}`}, ${`fingerprint-${jobId}`},\n\t\t\t\t\t${JSON.stringify({ workspaceId, turnId, query: question })}::jsonb,\n\t\t\t\t\t'pending', 1, 0, 0, 0, ${availableAt}, ${now}, ${now}\n\t\t\t\t)\n\t\t\t`;\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO research_workspaces (\n\t\t\t\t\tid, channel_id, title, proposed_question, confirmed_query, origin,\n\t\t\t\t\torigin_message_id, inline_reference,\n\t\t\t\t\tcreated_by, confirmed_by, revision, next_turn_ordinal, next_message_sequence,\n\t\t\t\t\tidempotency_key, fingerprint, created_at, updated_at\n\t\t\t\t) VALUES (\n\t\t\t\t\t${workspaceId}, ${channelId}, ${question}, ${question}, ${question},\n\t\t\t\t\t${plannerOriginMessageId ? \"planner\" : \"inline\"},\n\t\t\t\t\t${plannerOriginMessageId ?? null}, ${plannerOriginMessageId ? \"placed\" : null},\n\t\t\t\t\t${createdBy}, ${createdBy}, 0, 2, 2, ${`e2e-inline-${workspaceId}`},\n\t\t\t\t\t${`fingerprint-${workspaceId}`}, ${now}, ${now}\n\t\t\t\t)\n\t\t\t`;\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO research_turns (\n\t\t\t\t\tid, workspace_id, ordinal, kind, request_id, fingerprint, question,\n\t\t\t\t\trequested_by, evidence_job_id, created_at, updated_at\n\t\t\t\t) VALUES (\n\t\t\t\t\t${turnId}, ${workspaceId}, 1, 'initial', ${requestId},\n\t\t\t\t\t${`fingerprint-${turnId}`}, ${question}, ${createdBy}, ${jobId}, ${now}, ${now}\n\t\t\t\t)\n\t\t\t`;\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO research_messages (\n\t\t\t\t\tid, workspace_id, sequence, turn_id, author_kind, user_id, user_handle,\n\t\t\t\t\ttext, created_at\n\t\t\t\t) VALUES (\n\t\t\t\t\t${messageId}, ${workspaceId}, 1, ${turnId}, 'member', ${createdBy}, 'e2e',\n\t\t\t\t\t${question}, ${now}\n\t\t\t\t)\n\t\t\t`;\n\t\t});\n\t});\n\treturn { jobId, workspaceId };\n}\n\nexport async function updateResearchJobState(\n\tport: number,\n\tchannelId: string,\n\tjobId: string,\n\tstate: \"pending\" | \"completed\" | \"failed\" | \"cancelled\",\n): Promise {\n\tawait sql(port, async database => {\n\t\tlet [updated] = await database<{ id: string }[]>`\n\t\t\tUPDATE background_jobs\n\t\t\tSET state = ${state},\n\t\t\t\trevision = revision + 1,\n\t\t\t\treason = NULL,\n\t\t\t\tavailable_at = ${new Date(Date.now() + 24 * 60 * 60 * 1000)},\n\t\t\t\tupdated_at = ${new Date()}\n\t\t\tWHERE id = ${jobId} AND channel_id = ${channelId}\n\t\t\tRETURNING id\n\t\t`;\n\t\tif (!updated) throw new Error(`missing scripted research job ${jobId}`);\n\t});\n}\n\nexport async function markResearchPublished(\n\tport: number,\n\tchannelId: string,\n\tworkspaceId: string,\n\tchildChannelId: string,\n): Promise {\n\tawait sql(port, async database => {\n\t\tlet [updated] = await database<{ id: string }[]>`\n\t\t\tUPDATE research_workspaces\n\t\t\tSET published_channel_id = ${childChannelId},\n\t\t\t\tupdated_at = ${new Date()}\n\t\t\tWHERE id = ${workspaceId} AND channel_id = ${channelId}\n\t\t\tRETURNING id\n\t\t`;\n\t\tif (!updated) throw new Error(`missing scripted research workspace ${workspaceId}`);\n\t});\n}\n\nexport async function seedCompletedResearchWorkspace(\n\tport: number,\n\tchannelId: string,\n\tfixture: {\n\t\tworkspaceId?: string;\n\t\tanswerJobId?: string;\n\t\tplannerOriginMessageId?: string;\n\t\tquestion: string;\n\t\treport: {\n\t\t\ttitle: string;\n\t\t\tsummary: string;\n\t\t\tfinding: string;\n\t\t\tcaveat: string;\n\t\t\tsource: { title: string; url: string };\n\t\t};\n\t},\n): Promise<{ workspaceId: string; path: string }> {\n\tlet workspaceId = fixture.workspaceId ?? `workspace-${crypto.randomUUID()}`;\n\tlet turnId = `turn-${crypto.randomUUID()}`;\n\tlet evidenceJobId = `job-${crypto.randomUUID()}`;\n\tlet answerJobId = fixture.answerJobId ?? `job-${crypto.randomUUID()}`;\n\tlet evidenceTarget = `research-evidence:workspace:${workspaceId}:turn:${turnId}:evidence`;\n\tlet answerTarget = `research-answer:workspace:${workspaceId}:turn:${turnId}:answer`;\n\tlet createdAt = new Date();\n\tlet confirmedAt = new Date(createdAt.getTime() + 1);\n\tlet evidenceCreatedAt = new Date(createdAt.getTime() + 2);\n\tlet evidenceCompletedAt = new Date(createdAt.getTime() + 3);\n\tlet answerCreatedAt = new Date(createdAt.getTime() + 4);\n\tlet answerCompletedAt = new Date(createdAt.getTime() + 5);\n\tlet completedAt = new Date(createdAt.getTime() + 6);\n\n\tawait sql(port, async database => {\n\t\tlet [document] = await database<\n\t\t\t{\n\t\t\t\trevision: bigint | number | string;\n\t\t\t\tsource: string;\n\t\t\t\tsourceHash: string;\n\t\t\t}[]\n\t\t>`\n\t\t\tSELECT revision, source, source_hash AS \"sourceHash\"\n\t\t\tFROM channel_snapshots\n\t\t\tWHERE channel_id = ${channelId}\n\t\t`;\n\t\tif (!document) throw new Error(`missing checkpoint for ${channelId}`);\n\t\tlet documentRevision = Number(document.revision);\n\t\tlet evidence = {\n\t\t\tworkspaceId,\n\t\t\tturnId,\n\t\t\tquery: fixture.question,\n\t\t\tfindings: [fixture.report.finding],\n\t\t\tsources: [fixture.report.source],\n\t\t\tmodel: \"e2e-research-model\",\n\t\t};\n\t\tlet answerInput = {\n\t\t\tworkspaceId,\n\t\t\tturnId,\n\t\t\tkind: \"initial\",\n\t\t\tquestion: fixture.question,\n\t\t\tdocument: {\n\t\t\t\tsource: document.source,\n\t\t\t\trevision: documentRevision,\n\t\t\t\tsourceHash: document.sourceHash,\n\t\t\t},\n\t\t\tevidence: [{\n\t\t\t\tfindings: [fixture.report.finding],\n\t\t\t\tsources: [fixture.report.source],\n\t\t\t}],\n\t\t\thistory: [{ author: \"member\", text: fixture.question }],\n\t\t};\n\t\tlet answerArtifact = {\n\t\t\tworkspaceId,\n\t\t\tturnId,\n\t\t\tkind: \"initial\",\n\t\t\tdocumentRevision,\n\t\t\tdocumentSourceHash: document.sourceHash,\n\t\t\tmodel: \"e2e-research-model\",\n\t\t\treport: {\n\t\t\t\ttitle: fixture.report.title,\n\t\t\t\tsummary: fixture.report.summary,\n\t\t\t\tfindings: [{\n\t\t\t\t\ttext: fixture.report.finding,\n\t\t\t\t\tsourceUrls: [fixture.report.source.url],\n\t\t\t\t}],\n\t\t\t\tcaveats: [fixture.report.caveat],\n\t\t\t},\n\t\t\tsources: [fixture.report.source],\n\t\t\tpublicFindings: [fixture.report.finding],\n\t\t\tprivateFindings: [\"The private parent document supplied additional context.\"],\n\t\t};\n\n\t\t// Workspace and job revisions mirror their minimal durable production lifecycles.\n\t\tawait database.begin(async transaction => {\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO background_job_channels (channel_id, revision)\n\t\t\t\tVALUES (${channelId}, 6)\n\t\t\t`;\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO background_job_targets (channel_id, target_key, generation)\n\t\t\t\tVALUES\n\t\t\t\t\t(${channelId}, ${evidenceTarget}, 1),\n\t\t\t\t\t(${channelId}, ${answerTarget}, 1)\n\t\t\t`;\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO background_jobs (\n\t\t\t\t\tid, channel_id, type, version, origin, target_key, target_generation,\n\t\t\t\t\tidempotency_key, fingerprint, input, state, revision, attempts, failures,\n\t\t\t\t\tclaim_generation, available_at, created_at, updated_at\n\t\t\t\t) VALUES (\n\t\t\t\t\t${evidenceJobId}, ${channelId}, 'research-evidence', 1, 'user',\n\t\t\t\t\t${evidenceTarget}, 1, ${`research-evidence:${turnId}`},\n\t\t\t\t\t${`fingerprint-${evidenceJobId}`},\n\t\t\t\t\t${JSON.stringify({ workspaceId, turnId, query: fixture.question })}::jsonb,\n\t\t\t\t\t'completed', 3, 1, 0, 1, ${evidenceCreatedAt}, ${evidenceCreatedAt},\n\t\t\t\t\t${evidenceCompletedAt}\n\t\t\t\t), (\n\t\t\t\t\t${answerJobId}, ${channelId}, 'research-answer', 1, 'user',\n\t\t\t\t\t${answerTarget}, 1, ${`research-answer:${turnId}`},\n\t\t\t\t\t${`fingerprint-${answerJobId}`}, ${JSON.stringify(answerInput)}::jsonb,\n\t\t\t\t\t'completed', 6, 1, 0, 1, ${answerCreatedAt}, ${answerCreatedAt},\n\t\t\t\t\t${answerCompletedAt}\n\t\t\t\t)\n\t\t\t`;\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO background_job_artifacts (job_id, revision, value, created_at)\n\t\t\t\tVALUES\n\t\t\t\t\t(${evidenceJobId}, 3, ${JSON.stringify(evidence)}::jsonb, ${evidenceCompletedAt}),\n\t\t\t\t\t(${answerJobId}, 6, ${JSON.stringify(answerArtifact)}::jsonb, ${answerCompletedAt})\n\t\t\t`;\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO research_workspaces (\n\t\t\t\t\tid, channel_id, title, proposed_question, confirmed_query, origin,\n\t\t\t\t\torigin_message_id, inline_reference,\n\t\t\t\t\tcreated_by, confirmed_by, revision, next_turn_ordinal, next_message_sequence,\n\t\t\t\t\tidempotency_key, fingerprint, created_at, updated_at\n\t\t\t\t) VALUES (\n\t\t\t\t\t${workspaceId}, ${channelId}, ${fixture.question}, ${fixture.question},\n\t\t\t\t\t${fixture.question}, ${fixture.plannerOriginMessageId ? \"planner\" : \"sidebar\"},\n\t\t\t\t\t${fixture.plannerOriginMessageId ?? null},\n\t\t\t\t\t${fixture.plannerOriginMessageId ? \"placed\" : null},\n\t\t\t\t\t'U_e2e', 'U_e2e', 4, 2, 3,\n\t\t\t\t\t${`e2e-workspace-${workspaceId}`}, ${`fingerprint-${workspaceId}`},\n\t\t\t\t\t${createdAt}, ${completedAt}\n\t\t\t\t)\n\t\t\t`;\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO research_turns (\n\t\t\t\t\tid, workspace_id, ordinal, kind, request_id, fingerprint, question,\n\t\t\t\t\trequested_by, evidence_job_id, answer_job_id, created_at, updated_at\n\t\t\t\t) VALUES (\n\t\t\t\t\t${turnId}, ${workspaceId}, 1, 'initial', ${crypto.randomUUID()},\n\t\t\t\t\t${`fingerprint-${turnId}`}, ${fixture.question}, 'U_e2e', ${evidenceJobId},\n\t\t\t\t\t${answerJobId}, ${confirmedAt}, ${answerCreatedAt}\n\t\t\t\t)\n\t\t\t`;\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO research_messages (\n\t\t\t\t\tid, workspace_id, sequence, turn_id, author_kind, user_id, user_handle,\n\t\t\t\t\ttext, source_job_id, created_at\n\t\t\t\t) VALUES (\n\t\t\t\t\t${`message-${crypto.randomUUID()}`}, ${workspaceId}, 1, ${turnId}, 'member',\n\t\t\t\t\t'U_e2e', 'e2e', ${fixture.question}, NULL, ${confirmedAt}\n\t\t\t\t), (\n\t\t\t\t\t${`message-${crypto.randomUUID()}`}, ${workspaceId}, 2, ${turnId}, 'agent',\n\t\t\t\t\tNULL, NULL, ${fixture.report.summary}, ${answerJobId}, ${completedAt}\n\t\t\t\t)\n\t\t\t`;\n\t\t});\n\t});\n\n\treturn {\n\t\tworkspaceId,\n\t\tpath: `${testChannelPath(channelId)}/research/${encodeURIComponent(workspaceId)}`,\n\t};\n}\n","editable",false,"branch","documentNavigation","repo","githubnext/chopin","repoId","7d1a8ac3-35b0-4dea-85d4-06a980f3bada","ownerId","org:89615882","site","nexthub","private","admin","settings","maintainer","triage","starred","stars",0,"watchers","watching","pinned","notify","views",[183,184,185,186,187,188,189,190,191,192,193,194,195],"navigation",{"_54":55,"_139":140,"_141":142,"_143":144,"_145":146,"_147":148,"_149":150},"sources",[],"viewer","meta",{"_131":132,"_133":134,"_135":136,"_42":31,"_137":126,"_138":31,"_48":49,"_50":49},"branches",[73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130],"tags",[69,70,71,72],"cloneUrl","https://git.nexthub.sh/githubnext/chopin.git","color-controls-slice-1","color-controls-slice-2","color-controls-slice-3","color-controls-slice-4","Krzysztof-Cieslak-patch-1","Krzysztof-Cieslak-patch-2","Maggie/app-preview-toolkit","Maggie/ci-playwright-install-timeout","Maggie/collaborative-visual-decision","Maggie/design-audit","Maggie/generic-visual-decision-runtime","Maggie/impeccable-chopin-metadata","Maggie/jev-chat-product","Maggie/jev-composed-assessment","Maggie/native-document-layouts","Maggie/openui-composition-product","Maggie/openui-composition-trial","Maggie/planner-visual-authoring","Maggie/planner-visual-requests","Maggie/visual-selection-eval","artifacts/pr-419-live-preview-20261009","automation/pr-maintenance-state","automation/use-effect/callout-disabled-picker-8cf9e49ba5c09471","automation/use-effect/collaboration-options-ref-4e3a5a08a879a5ae","automation/use-effect/room-workspace-effective-access-a57d40866c71bed0","chore/bun-1.4.2","color-controls","color-controls-plan","comments","design-pr-assets","design/archived-decisions-badge","design/channel-route-remount","design/chat-decision-entry","design/conversation-analysis-markers","design/decision-evidence","design/settled-line-icon","dev/integration","diagram-step-controls","feat/liveapp-frontend-pilot","feat/local-experiments","feat/local-launcher-tracer","fix/autolink-mdx-crash","github-pills/2-pills","github-pills/3-hover-card","maggie/app-preview-toolkit","maggie/ci-playwright-install-timeout","maggie/collaborative-visual-decision","maggie/design-audit","maggie/generic-visual-decision-runtime","maggie/impeccable-chopin-metadata","maggie/jev-composed-assessment","maggie/native-document-layouts","maggie/openui-composition-product","maggie/openui-composition-trial","maggie/planner-visual-authoring","maggie/planner-visual-requests","maggie/visual-selection-eval","main","plain-text-fence-chrome","tokens/09-copy","wireframes/2-renderer","wireframes/3-planner","description","Let's compose rich plans together","owner","githubnext","section","","head","empty","pins",[165,166,167],"documents",{"_160":161,"_162":163},"code",{"_156":157,"_158":159},"automations",{"_153":154,"_155":-5},"delivery",{"_151":49,"_152":-5},"tag","04zvKQ8QOrDUF8TO1Ovz0Zy8_TT","releases","applications","workflows",3,"deployments","commits",1000,"changes",13,"counts",{"_164":163},"total",11,"issue",{"_168":158,"_170":181,"_15":158,"_172":182,"_52":174,"_175":31,"_176":174,"_177":159},{"_168":178,"_170":179,"_15":178,"_172":180,"_52":174,"_175":31,"_176":174,"_177":49},{"_168":169,"_170":171,"_15":169,"_172":173,"_52":174,"_175":31,"_176":174,"_177":163},"id","issues","name","Issues","filters",{},true,"saved","pinnable","count","tasks","Tasks",{},"Changes",{},{"_168":158,"_170":181,"_15":158,"_172":226,"_52":174,"_175":31,"_176":174},{"_168":178,"_170":179,"_15":178,"_172":225,"_52":174,"_175":31,"_176":174},{"_168":169,"_170":171,"_15":169,"_172":224,"_52":174,"_175":31,"_176":174},{"_168":221,"_170":222,"_15":221,"_172":223,"_52":31,"_175":31,"_176":174},{"_168":218,"_170":219,"_15":218,"_172":220,"_52":31,"_175":31,"_176":174},{"_168":153,"_170":216,"_15":145,"_172":217,"_52":31,"_175":31,"_176":174},{"_168":155,"_170":213,"_15":214,"_172":215,"_52":31,"_175":31,"_176":174},{"_168":151,"_170":211,"_15":151,"_172":212,"_52":31,"_175":31,"_176":174},{"_168":207,"_170":208,"_15":209,"_172":210,"_52":31,"_175":31,"_176":174},{"_168":141,"_170":205,"_15":141,"_172":206,"_52":31,"_175":31,"_176":31},{"_168":202,"_170":203,"_15":202,"_172":204,"_52":31,"_175":31,"_176":31},{"_168":199,"_170":200,"_15":199,"_172":201,"_52":31,"_175":31,"_176":31},{"_168":196,"_170":197,"_15":196,"_172":198,"_52":31,"_175":31,"_176":31},"decisions","Decisions",{},"changelog","Changelog",{},"roadmap","Roadmap",{},"Documents",{},"activity","Activity","insights",{},"Releases",{},"Deployments","automations/deployments",{},"Workflows",{},"discussions","Discussions",{},"goals","Goals",{},{},{},{},"groups","user","agents",[],"now",1794578215426,"sidebar","expanded"]