[{"_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","0026d951eaead48c8f3ffc8f3cd54d1ff2e0924c","path","e2e/database.ts","oid","221d61949a0aa08c626bf563ee50bd141054ab2f","size",18955,"commit","mounts",[],"source","plain",{"_13":14,"_15":16},"kind","text","import { createHash } from \"node:crypto\";\nimport { SQL } from \"bun\";\nimport { storedDocument, storedLegacyCallout } from \"../apps/server/src/testing/plan\";\n\nimport type { SeedState } from \"../apps/server/src/testing/plan\";\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\t8792: \"postgresql://chopin:chopin@127.0.0.1:5435/chopin?sslmode=disable\",\n};\n\nexport function testChannelSlug(id: string): string {\n\treturn `test-${id.slice(0, 8)}`;\n}\n\nexport function testChannelPath(id: string): string {\n\treturn `/documents/octo-org/score/${testChannelSlug(id)}`;\n}\n\nfunction url(port: number): string {\n\tlet index = port === 8792 ? 2 : 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 createChannel(port: number, id: string): Promise {\n\tawait sql(port, async database => {\n\t\tlet now = new Date();\n\t\tlet slug = testChannelSlug(id);\n\t\tawait database.begin(async transaction => {\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO users (id, login, avatar_url, created_at, updated_at)\n\t\t\t\tVALUES ('U_e2e', 'e2e', '', ${now}, ${now})\n\t\t\t\tON CONFLICT (id) DO NOTHING\n\t\t\t`;\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO channels (\n\t\t\t\t\tid, repository_id, repository_owner, repository_name, title,\n\t\t\t\t\tcreated_by, revision, next_sequence, created_at, updated_at\n\t\t\t\t) VALUES (\n\t\t\t\t\t${id}, 'R_score', 'octo-org', 'score', ${`Test ${id.slice(0, 8)}`},\n\t\t\t\t\t'U_e2e', 0, 1, ${now}, ${now}\n\t\t\t\t)\n\t\t\t`;\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO channel_slugs (\n\t\t\t\t\trepository_id, slug, channel_id, canonical, created_at\n\t\t\t\t) VALUES ('R_score', ${slug}, ${id}, true, ${now})\n\t\t\t`;\n\t\t\tawait transaction`\n\t\t\t\tINSERT INTO channel_state (channel_id, sidecar) VALUES (${id}, 'null'::jsonb)\n\t\t\t`;\n\t\t});\n\t});\n}\n\nexport async function seedChildChannel(\n\tport: number,\n\tparentId: string,\n\tid: string,\n\ttitle: string,\n\tsource: string,\n\tstate: SeedState = {},\n): Promise<{ id: string; path: string; slug: string }> {\n\tawait createChannel(port, id);\n\tlet slug = `child-${id.slice(0, 8)}`;\n\tawait sql(port, async database => {\n\t\tawait database.begin(async transaction => {\n\t\t\tawait transaction`\n\t\t\t\tUPDATE channels\n\t\t\t\tSET parent_channel_id = ${parentId}, title = ${title}, updated_at = ${new Date()}\n\t\t\t\tWHERE id = ${id}\n\t\t\t`;\n\t\t\tawait transaction`\n\t\t\t\tUPDATE channel_slugs SET slug = ${slug} WHERE channel_id = ${id} AND canonical = true\n\t\t\t`;\n\t\t});\n\t});\n\tawait seedChannel(port, id, source, state);\n\treturn { id, path: `${testChannelPath(parentId)}/children/${slug}`, slug };\n}\n\nexport async function countChildChannels(port: number, parentId: string): Promise {\n\treturn sql(port, async database => {\n\t\tlet [row] = await database<{ count: number }[]>`\n\t\t\tSELECT count(*)::int AS count FROM channels WHERE parent_channel_id = ${parentId}\n\t\t`;\n\t\treturn row?.count ?? 0;\n\t});\n}\n\nexport async function seedChannel(\n\tport: number,\n\tid: string,\n\tsource: string,\n\tstate: SeedState = {},\n): Promise {\n\treturn seed(port, id, source, state, storedDocument);\n}\n\nexport async function seedChannelDescription(\n\tport: number,\n\tid: string,\n\tdescription: string,\n): Promise {\n\tawait sql(port, async database => {\n\t\tawait database`\n\t\t\tUPDATE channels\n\t\t\tSET generated_description = ${description},\n\t\t\t\tgenerated_description_revision = 1,\n\t\t\t\tgenerated_description_plan_revision = 0,\n\t\t\t\tgenerated_description_source_hash = ${`sha256:${\"a\".repeat(64)}`},\n\t\t\t\tgenerated_description_generator_version = 1,\n\t\t\t\tgenerated_description_job_id = ${`e2e-description-${id}`},\n\t\t\t\tgenerated_description_updated_at = ${new Date()}\n\t\t\tWHERE id = ${id}\n\t\t`;\n\t});\n}\n\nexport async function seedLegacyCalloutChannel(\n\tport: number,\n\tid: string,\n\tsource: string,\n): Promise {\n\treturn seed(port, id, source, {}, storedLegacyCallout);\n}\n\nasync function seed(\n\tport: number,\n\tid: string,\n\tsource: string,\n\tstate: SeedState,\n\tencode: typeof storedDocument,\n): Promise {\n\tlet document = await encode(source);\n\tlet sidecar = {\n\t\tversion: 1,\n\t\trevision: state.revision ?? 0,\n\t\tdocumentSeq: 0,\n\t\tquestions: state.questions ?? [],\n\t\topenQuestions: state.openQuestions ?? [],\n\t\tthreads: state.threads ?? [],\n\t\ttranscript: state.transcript ?? [],\n\t};\n\tawait sql(port, async database => {\n\t\tawait database`\n\t\t\t\tINSERT INTO channel_snapshots (\n\t\t\t\t\tchannel_id, generation, revision, through_sequence, epoch, source,\n\t\t\t\t\tsource_hash, document, sidecar, created_at\n\t\t\t\t) VALUES (\n\t\t\t\t\t${id}, ${crypto.randomUUID()}, 0, 0, ${document.epoch}, ${document.source},\n\t\t\t\t\t${`sha256:${createHash(\"sha256\").update(document.source).digest(\"hex\")}`},\n\t\t\t\t\t${document.update}, ${JSON.stringify(sidecar)}::jsonb, ${new Date()}\n\t\t\t\t)\n\t\t\t`;\n\t});\n}\n\nexport async function readSource(port: number, id: string): Promise {\n\treturn sql(port, async database => {\n\t\tlet [row] = await database<{ source: string }[]>`\n\t\t\tSELECT source FROM channel_snapshots WHERE channel_id = ${id}\n\t\t`;\n\t\treturn row?.source ?? \"\";\n\t});\n}\n\nfunction researchAnswerFixture(question: string) {\n\tlet workspaceId = `workspace-${crypto.randomUUID()}`;\n\tlet turnId = `turn-${crypto.randomUUID()}`;\n\tlet documentSource = \"# Research parent\\n\";\n\tlet documentSourceHash = `sha256:${createHash(\"sha256\").update(documentSource).digest(\"hex\")}`;\n\treturn {\n\t\tworkspaceId,\n\t\tturnId,\n\t\ttargetKey: `research-answer:workspace:${workspaceId}:turn:${turnId}:answer`,\n\t\tinput: {\n\t\t\tworkspaceId,\n\t\t\tturnId,\n\t\t\tkind: \"initial\",\n\t\t\tquestion,\n\t\t\tdocument: {\n\t\t\t\tsource: documentSource,\n\t\t\t\trevision: 0,\n\t\t\t\tsourceHash: documentSourceHash,\n\t\t\t},\n\t\t\tevidence: [],\n\t\t\thistory: [],\n\t\t},\n\t\tartifact: {\n\t\t\tworkspaceId,\n\t\t\tturnId,\n\t\t\tkind: \"initial\",\n\t\t\tdocumentRevision: 0,\n\t\t\tdocumentSourceHash,\n\t\t\tmodel: \"e2e-model\",\n\t\t\treport: {\n\t\t\t\ttitle: \"Preview research report\",\n\t\t\t\tsummary: \"The preview report is visible outside Chat.\",\n\t\t\t\tfindings: [{ text: \"A cited finding\", sourceUrls: [\"https://example.com/source\"] }],\n\t\t\t\tcaveats: [\"Generated evidence should be reviewed.\"],\n\t\t\t},\n\t\t\tsources: [{ title: \"Example source\", url: \"https://example.com/source\" }],\n\t\t\tpublicFindings: [\"A cited finding\"],\n\t\t\tprivateFindings: [],\n\t\t},\n\t};\n}\n\nexport async function seedCompletedResearchAnswerJob(\n\tport: number,\n\tchannelId: string,\n\tquestion: string,\n): Promise {\n\tlet now = new Date();\n\tlet jobId = crypto.randomUUID();\n\tlet fixture = researchAnswerFixture(question);\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) VALUES (${channelId}, 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}, ${fixture.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-answer', 1, 'user', ${fixture.targetKey}, 1,\n\t\t\t\t\t${`e2e-${jobId}`}, ${`fingerprint-${jobId}`},\n\t\t\t\t\t${JSON.stringify(fixture.input)}::jsonb,\n\t\t\t\t\t'completed', 1, 1, 0, 1, ${now}, ${now}, ${now}\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${jobId}, 1,\n\t\t\t\t\t${JSON.stringify(fixture.artifact)}::jsonb,\n\t\t\t\t\t${now}\n\t\t\t\t)\n\t\t\t`;\n\t\t});\n\t});\n\treturn jobId;\n}\n\nexport async function seedRunningResearchAnswerJob(\n\tport: number,\n\tchannelId: string,\n\tquestion: string,\n): Promise {\n\tlet now = new Date();\n\tlet jobId = crypto.randomUUID();\n\tlet fixture = researchAnswerFixture(question);\n\tlet progress = [{\n\t\trevision: 2,\n\t\tattempt: 1,\n\t\tstage: \"private-document\",\n\t\tlabel: \"Private document analysis\",\n\t\tstate: \"started\",\n\t\tcreatedAt: now.toISOString(),\n\t}, {\n\t\trevision: 3,\n\t\tattempt: 1,\n\t\tstage: \"private-document\",\n\t\tlabel: \"Private document analysis\",\n\t\tstate: \"interrupted\",\n\t\treason: \"private-analysis-failed\",\n\t\tcreatedAt: new Date(now.getTime() + 1).toISOString(),\n\t}, {\n\t\trevision: 4,\n\t\tattempt: 2,\n\t\tstage: \"private-document\",\n\t\tlabel: \"Private document analysis\",\n\t\tstate: \"started\",\n\t\tcreatedAt: new Date(now.getTime() + 2).toISOString(),\n\t}, {\n\t\trevision: 5,\n\t\tattempt: 2,\n\t\tstage: \"private-document\",\n\t\tlabel: \"Private document analysis\",\n\t\tstate: \"completed\",\n\t\tcreatedAt: new Date(now.getTime() + 3).toISOString(),\n\t}, {\n\t\trevision: 6,\n\t\tattempt: 2,\n\t\tstage: \"report-synthesis\",\n\t\tlabel: \"Research report synthesis\",\n\t\tstate: \"started\",\n\t\tcreatedAt: new Date(now.getTime() + 4).toISOString(),\n\t}];\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) VALUES (${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 (${channelId}, ${fixture.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, claim_owner, claim_expires_at, available_at, progress,\n\t\t\t\t\tcreated_at, updated_at\n\t\t\t\t) VALUES (\n\t\t\t\t\t${jobId}, ${channelId}, 'research-answer', 1, 'user', ${fixture.targetKey}, 1,\n\t\t\t\t\t${`e2e-${jobId}`}, ${`fingerprint-${jobId}`},\n\t\t\t\t\t${JSON.stringify(fixture.input)}::jsonb,\n\t\t\t\t\t'running', 6, 2, 1, 2, 'e2e-worker', ${new Date(now.getTime() + 60_000)},\n\t\t\t\t\t${now}, ${JSON.stringify(progress)}::text::jsonb, ${now}, ${new Date(now.getTime() + 4)}\n\t\t\t\t)\n\t\t\t`;\n\t\t});\n\t});\n}\n\nexport async function seedPendingLegacyResearchWorkspace(\n\tport: number,\n\tchannelId: string,\n\ttitle: string,\n): Promise<{ path: string; title: string; workspaceId: string }> {\n\tlet workspaceId = `workspace-${crypto.randomUUID()}`;\n\tlet now = new Date();\n\tawait sql(port, async database => {\n\t\tawait database`\n\t\t\tINSERT INTO research_workspaces (\n\t\t\t\tid, channel_id, title, proposed_question, origin, created_by, revision,\n\t\t\t\tnext_turn_ordinal, next_message_sequence, idempotency_key, fingerprint,\n\t\t\t\tcreated_at, updated_at\n\t\t\t) VALUES (\n\t\t\t\t${workspaceId}, ${channelId}, ${title}, ${title}, 'sidebar', 'U_e2e', 0,\n\t\t\t\t1, 1, ${`e2e-pending-${workspaceId}`}, ${`fingerprint-${workspaceId}`},\n\t\t\t\t${now}, ${now}\n\t\t\t)\n\t\t`;\n\t});\n\treturn {\n\t\tpath: `${testChannelPath(channelId)}/research/${encodeURIComponent(workspaceId)}`,\n\t\ttitle,\n\t\tworkspaceId,\n\t};\n}\n\nexport async function seedCompletedResearchWorkspace(\n\tport: number,\n\tchannelId: string,\n\tfixture: {\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 = `workspace-${crypto.randomUUID()}`;\n\tlet turnId = `turn-${crypto.randomUUID()}`;\n\tlet evidenceJobId = `job-${crypto.randomUUID()}`;\n\tlet 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\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}, 'sidebar', '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\nexport async function readResearchWorkspaceState(\n\tport: number,\n\tchannelId: string,\n\tworkspaceId: string,\n): Promise<{\n\tconfirmed: boolean;\n\trevision: number;\n\tnextTurnOrdinal: number;\n\tnextMessageSequence: number;\n\tturns: number;\n\tmessages: number;\n\tjobs: number;\n}> {\n\treturn sql(port, async database => {\n\t\tlet [row] = await database<\n\t\t\t{\n\t\t\t\tconfirmedQuery: string | null;\n\t\t\t\trevision: bigint | number | string;\n\t\t\t\tnextTurnOrdinal: bigint | number | string;\n\t\t\t\tnextMessageSequence: bigint | number | string;\n\t\t\t\tturns: number;\n\t\t\t\tmessages: number;\n\t\t\t\tjobs: number;\n\t\t\t}[]\n\t\t>`\n\t\t\tSELECT\n\t\t\t\tconfirmed_query AS \"confirmedQuery\",\n\t\t\t\trevision,\n\t\t\t\tnext_turn_ordinal AS \"nextTurnOrdinal\",\n\t\t\t\tnext_message_sequence AS \"nextMessageSequence\",\n\t\t\t\t(SELECT count(*)::int FROM research_turns WHERE workspace_id = ${workspaceId}) AS turns,\n\t\t\t\t(SELECT count(*)::int FROM research_messages WHERE workspace_id = ${workspaceId}) AS messages,\n\t\t\t\t(\n\t\t\t\t\tSELECT count(*)::int FROM background_jobs\n\t\t\t\t\tWHERE channel_id = ${channelId} AND input ->> 'workspaceId' = ${workspaceId}\n\t\t\t\t) AS jobs\n\t\t\tFROM research_workspaces\n\t\t\tWHERE id = ${workspaceId} AND channel_id = ${channelId}\n\t\t`;\n\t\tif (!row) throw new Error(`missing research workspace ${workspaceId}`);\n\t\treturn {\n\t\t\tconfirmed: row.confirmedQuery !== null,\n\t\t\trevision: Number(row.revision),\n\t\t\tnextTurnOrdinal: Number(row.nextTurnOrdinal),\n\t\t\tnextMessageSequence: Number(row.nextMessageSequence),\n\t\t\tturns: row.turns,\n\t\t\tmessages: row.messages,\n\t\t\tjobs: row.jobs,\n\t\t};\n\t});\n}\n\n/** The checkpoint that `plan:open` starts from, for protocol-level browser fixtures. */\nexport async function readDocument(port: number, id: string): Promise<{\n\tepoch: string;\n\tsource: string;\n\tupdate: Uint8Array;\n}> {\n\treturn sql(port, async database => {\n\t\tlet [row] = await database<{ document: Uint8Array; epoch: string; source: string }[]>`\n\t\t\tSELECT epoch, source, document FROM channel_snapshots WHERE channel_id = ${id}\n\t\t`;\n\t\tif (!row) throw new Error(`missing checkpoint for ${id}`);\n\t\treturn { epoch: row.epoch, source: row.source, update: new Uint8Array(row.document) };\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",1794438386501,"sidebar","expanded"]