[{"_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","b770bd2d73e574dc736bd75d303b0f0feb4d8564","path","apps/server/src/storage/postgres/navigation.ts","oid","1d9f07fe4022767d04aba632d85e06008f837fc5","size",6144,"commit","mounts",[],"source","plain",{"_13":14,"_15":16},"kind","text","import { corrupt, missing } from \"../errors\";\n\nimport type { SQL, TransactionSQL } from \"bun\";\nimport type {\n\tAddUserProject,\n\tAddUserProjectResult,\n\tRecordNavigationVisit,\n\tUserNavigation,\n\tUserProject,\n} from \"../model\";\nimport type { NavigationStore } from \"../port\";\n\ntype Timestamp = Date | string;\ntype Integer = bigint | number | string;\n\ntype ProjectRow = {\n\tuserId: string;\n\trepositoryId: string;\n\trepositoryOwner: string;\n\trepositoryName: string;\n\tposition: Integer;\n\taddedAt: Timestamp;\n};\n\ntype NavigationRow = {\n\tuserId: string;\n\tlastDocumentId: string | null;\n\tupdatedAt: Timestamp;\n};\n\ntype Run = (action: string, execute: () => Promise) => Promise;\n\nconst PROJECT_COLUMNS = `\n\tuser_id AS \"userId\",\n\trepository_id AS \"repositoryId\",\n\trepository_owner AS \"repositoryOwner\",\n\trepository_name AS \"repositoryName\",\n\tposition,\n\tadded_at AS \"addedAt\"\n`;\n\nconst NAVIGATION_COLUMNS = `\n\tuser_id AS \"userId\",\n\tlast_document_id AS \"lastDocumentId\",\n\tupdated_at AS \"updatedAt\"\n`;\n\nfunction date(value: Timestamp, field: string): Date {\n\tlet parsed = value instanceof Date ? new Date(value) : new Date(value);\n\tif (Number.isNaN(parsed.getTime())) throw corrupt(`storage returned an invalid ${field}`);\n\treturn parsed;\n}\n\nfunction integer(value: Integer, field: string): number {\n\tlet parsed = typeof value === \"number\" ? value : Number(value);\n\tif (!Number.isSafeInteger(parsed) || parsed < 0) {\n\t\tthrow corrupt(`storage returned an invalid ${field}`);\n\t}\n\treturn parsed;\n}\n\nfunction project(row: ProjectRow): UserProject {\n\treturn {\n\t\t...row,\n\t\tposition: integer(row.position, \"project position\"),\n\t\taddedAt: date(row.addedAt, \"project added time\"),\n\t};\n}\n\nfunction navigation(row: NavigationRow): UserNavigation {\n\treturn {\n\t\t...row,\n\t\tlastDocumentId: row.lastDocumentId ?? undefined,\n\t\tupdatedAt: date(row.updatedAt, \"navigation update time\"),\n\t};\n}\n\n/** Per-user navigation queries, kept apart from the channel persistence engine. */\nexport class PostgresNavigationStore implements NavigationStore {\n\treadonly #sql: SQL;\n\treadonly #run: Run;\n\n\tconstructor(sql: SQL, run: Run) {\n\t\tthis.#sql = sql;\n\t\tthis.#run = run;\n\t}\n\n\treadonly projects = (userId: string): Promise =>\n\t\tthis.#run(\"list projects\", async () => {\n\t\t\tawait this.#requireUser(userId);\n\t\t\tlet rows = await this.#sql`\n\t\t\t\tSELECT ${this.#sql.unsafe(PROJECT_COLUMNS)}\n\t\t\t\tFROM user_projects\n\t\t\t\tWHERE user_id = ${userId}\n\t\t\t\tORDER BY position ASC\n\t\t\t`;\n\t\t\treturn rows.map(project);\n\t\t});\n\n\treadonly addProject = (input: AddUserProject): Promise =>\n\t\tthis.#run(\n\t\t\t\"add project\",\n\t\t\t() => this.#sql.begin(transaction => this.#addProject(transaction, input)),\n\t\t);\n\n\treadonly get = (userId: string): Promise =>\n\t\tthis.#run(\"read navigation\", async () => {\n\t\t\tawait this.#requireUser(userId);\n\t\t\tlet [found] = await this.#sql`\n\t\t\t\tSELECT ${this.#sql.unsafe(NAVIGATION_COLUMNS)}\n\t\t\t\tFROM user_navigation WHERE user_id = ${userId}\n\t\t\t`;\n\t\t\treturn found ? navigation(found) : undefined;\n\t\t});\n\n\treadonly setLastDocument = (\n\t\tuserId: string,\n\t\tdocumentId: string | undefined,\n\t\tnow: Date,\n\t): Promise =>\n\t\tthis.#run(\"save navigation\", () => this.#saveNavigation(this.#sql, userId, documentId, now));\n\n\treadonly recordVisit = (input: RecordNavigationVisit): Promise =>\n\t\tthis.#run(\"record navigation visit\", () =>\n\t\t\tthis.#sql.begin(async transaction => {\n\t\t\t\tawait this.#requireDocument(transaction, input.documentId, input.repositoryId);\n\t\t\t\tawait this.#addProject(transaction, input);\n\t\t\t\treturn this.#saveNavigation(transaction, input.userId, input.documentId, input.now);\n\t\t\t}));\n\n\tasync #addProject(\n\t\ttransaction: TransactionSQL,\n\t\tinput: AddUserProject,\n\t): Promise {\n\t\tawait this.#lockUser(transaction, input.userId);\n\t\tlet [existing] = await transaction`\n\t\t\tSELECT ${transaction.unsafe(PROJECT_COLUMNS)}\n\t\t\tFROM user_projects\n\t\t\tWHERE user_id = ${input.userId} AND repository_id = ${input.repositoryId}\n\t\t`;\n\t\tif (existing) return { project: project(existing), added: false };\n\t\tlet [saved] = await transaction`\n\t\t\tINSERT INTO user_projects (\n\t\t\t\tuser_id, repository_id, repository_owner, repository_name, position, added_at\n\t\t\t)\n\t\t\tSELECT\n\t\t\t\t${input.userId}, ${input.repositoryId}, ${input.repositoryOwner},\n\t\t\t\t${input.repositoryName}, COALESCE(MAX(position) + 1, 0), ${input.now}\n\t\t\tFROM user_projects\n\t\t\tWHERE user_id = ${input.userId}\n\t\t\tRETURNING ${transaction.unsafe(PROJECT_COLUMNS)}\n\t\t`;\n\t\tif (!saved) throw corrupt(\"adding a project returned no record\");\n\t\treturn { project: project(saved), added: true };\n\t}\n\n\tasync #saveNavigation(\n\t\tsql: SQL | TransactionSQL,\n\t\tuserId: string,\n\t\tdocumentId: string | undefined,\n\t\tnow: Date,\n\t): Promise {\n\t\tlet [saved] = await sql`\n\t\t\tINSERT INTO user_navigation (user_id, last_document_id, updated_at)\n\t\t\tVALUES (${userId}, ${documentId ?? null}, ${now})\n\t\t\tON CONFLICT (user_id) DO UPDATE SET\n\t\t\t\tlast_document_id = EXCLUDED.last_document_id,\n\t\t\t\tupdated_at = EXCLUDED.updated_at\n\t\t\tRETURNING ${sql.unsafe(NAVIGATION_COLUMNS)}\n\t\t`;\n\t\tif (!saved) throw corrupt(\"saving navigation returned no record\");\n\t\treturn navigation(saved);\n\t}\n\n\tasync #requireUser(userId: string): Promise {\n\t\tlet [found] = await this.#sql<{ id: string }[]>`\n\t\t\tSELECT id FROM users WHERE id = ${userId}\n\t\t`;\n\t\tif (!found) throw missing(`user ${userId} does not exist`);\n\t}\n\n\tasync #lockUser(transaction: TransactionSQL, userId: string): Promise {\n\t\tlet [found] = await transaction<{ id: string }[]>`\n\t\t\tSELECT id FROM users WHERE id = ${userId} FOR UPDATE\n\t\t`;\n\t\tif (!found) throw missing(`user ${userId} does not exist`);\n\t}\n\n\tasync #requireDocument(\n\t\ttransaction: TransactionSQL,\n\t\tdocumentId: string,\n\t\trepositoryId: string,\n\t): Promise {\n\t\tlet [found] = await transaction<{ id: string }[]>`\n\t\t\tSELECT id FROM channels\n\t\t\tWHERE id = ${documentId} AND repository_id = ${repositoryId}\n\t\t\tFOR KEY SHARE\n\t\t`;\n\t\tif (!found) throw missing(`channel ${documentId} does not exist in repository ${repositoryId}`);\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",1794439173740,"sidebar","expanded"]