[{"_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","7e4da0b3abe5ad2bdee80bc3595ad310bbb5fa49","path","e2e/database.ts","oid","c9e76813f8b150a0dcb9404da7ea84e39ecc59ee","size",3327,"commit","mounts",[],"source","plain",{"_13":14,"_15":16},"kind","text","import { createHash } from \"node:crypto\";\nimport { SQL } from \"bun\";\nimport { storedDocument } 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};\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 createChannel(port: number, id: string): Promise {\n\tawait sql(port, async database => {\n\t\tlet now = new Date();\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_state (channel_id, sidecar) VALUES (${id}, 'null'::jsonb)\n\t\t\t`;\n\t\t});\n\t});\n}\n\nexport async function seedChannel(\n\tport: number,\n\tid: string,\n\tsource: string,\n\tstate: SeedState = {},\n): Promise {\n\tlet document = await storedDocument(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\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",1794438720546,"sidebar","expanded"]