import prisma from "@super/db" import { NOVA_CONTRACT_VERSION, type AgentSessionSummary, type SyncCursor, } from "@super/nova" import { ensureUserOrganization } from "@/modules/integrations/lib/org" import { localAttachmentsFromMetadata, toLocalAttachmentMeta, type LocalAttachment, type LocalAttachmentMeta, } from "@/modules/nova/attachments/contracts" import { referencesFromMetadata, type NovaReference } from "@/modules/nova/references/contracts" const DEFAULT_SYNC_LIMIT = 100 const MAX_SYNC_LIMIT = 500 export type NovaSurfaceProvider = "desktop" | "web" function serializeSurface(surface: { id: string provider: string externalSurfaceId: string externalContainerId: string | null externalUrl: string | null status: string }) { return { id: surface.id, provider: surface.provider as "desktop" | "web" | "slack" | "linear" | "github", externalSurfaceId: surface.externalSurfaceId, externalContainerId: surface.externalContainerId, externalUrl: surface.externalUrl, status: surface.status as "active" | "muted" | "archived", } } function serializeSession(session: { parentSessionId?: string | null agentId?: string | null id: string objective: string mode: string status: string activeRunId: string | null nextSequence: number updatedAt: Date createdAt?: Date localProject?: { id: string; displayName: string } | null initiatorMembership?: { user: { id: string; name: string; image?: string | null } } | null automationRun?: { id: string } | null surfaces: Array<{ id: string provider: string externalSurfaceId: string externalContainerId: string | null externalUrl: string | null status: string }> }): AgentSessionSummary { return { contractVersion: NOVA_CONTRACT_VERSION, id: session.id, agentId: session.agentId ?? null, parentSessionId: session.parentSessionId ?? null, createdAt: session.createdAt?.toISOString(), project: session.localProject ? { id: session.localProject.id, name: session.localProject.displayName } : null, creator: session.initiatorMembership?.user ?? null, origin: session.automationRun ? "automation" : session.surfaces[0]?.provider as AgentSessionSummary["origin"], objective: session.objective, mode: session.mode, status: session.status as AgentSessionSummary["status"], activeRunId: session.activeRunId, latestSequence: Math.max(0, session.nextSequence - 1), surfaces: session.surfaces.map(serializeSurface), updatedAt: session.updatedAt.toISOString(), } } async function membershipForUser(userId: string, organizationId: string) { const membership = await prisma.organizationMembership.findUnique({ where: { organizationId_userId: { organizationId, userId } }, }) if (!membership || membership.status !== "active") { throw new Error("Active organization membership required") } return membership } export async function listAgentSessions(userId: string, parentSessionId: string | null = null, agentId: string | null = null): Promise { const organizationId = await ensureUserOrganization(userId) await membershipForUser(userId, organizationId) if (parentSessionId) { const parent = await prisma.agentSession.findFirst({ where: { id: parentSessionId, organizationId }, select: { id: true } }) if (!parent) throw new Error("Parent thread not found") } const sessions = await prisma.agentSession.findMany({ where: { organizationId, parentSessionId, agentId: agentId ?? null }, include: { surfaces: { where: { status: { not: "archived" } }, orderBy: { createdAt: "asc" } }, localProject: { select: { id: true, displayName: true } }, initiatorMembership: { select: { user: { select: { id: true, name: true, image: true } } } }, automationRun: { select: { id: true } }, }, orderBy: { updatedAt: "desc" }, take: 100, }) const messages = await prisma.agentSessionMessage.findMany({ where: { agentSessionId: { in: sessions.map((session) => session.id) }, senderType: "member", senderId: { not: null } }, select: { agentSessionId: true, senderId: true }, distinct: ["agentSessionId", "senderId"], }) const memberships = await prisma.organizationMembership.findMany({ where: { organizationId, id: { in: messages.flatMap((message) => message.senderId ? [message.senderId] : []) } }, select: { id: true, user: { select: { id: true, name: true, image: true } } }, }) const members = new Map(memberships.map((member) => [member.id, member.user])) const participants = new Map>() for (const message of messages) { const user = message.senderId ? members.get(message.senderId) : null if (!user) continue const group = participants.get(message.agentSessionId) ?? new Map() group.set(user.id, user) participants.set(message.agentSessionId, group) } return sessions.map((session) => { const summary = serializeSession(session) const group = participants.get(session.id) ?? new Map() if (summary.creator) group.set(summary.creator.id, summary.creator) return { ...summary, participants: [...group.values()] } }) } export async function getAgentSession(userId: string, sessionId: string) { const organizationId = await ensureUserOrganization(userId) await membershipForUser(userId, organizationId) const session = await prisma.agentSession.findFirst({ where: { id: sessionId, organizationId }, include: { surfaces: true, runs: { orderBy: { createdAt: "desc" }, take: 10 }, localProject: true, }, }) if (!session) return null return { ...serializeSession(session), localProjectId: session.localProjectId, localProject: session.localProject ? { id: session.localProject.id, displayName: session.localProject.displayName, rootName: session.localProject.rootName, fileCount: session.localProject.fileCount, truncated: session.localProject.truncated, repositoryFullName: session.localProject.repositoryFullName, status: session.localProject.status, lastUsedAt: session.localProject.lastUsedAt?.toISOString() ?? null, updatedAt: session.localProject.updatedAt.toISOString(), paths: Array.isArray(session.localProject.pathIndex) ? session.localProject.pathIndex.filter((item): item is string => typeof item === "string") : [], } : null, runs: session.runs.map((run) => ({ id: run.id, status: run.status, executionTarget: run.executionTarget, desktopDeviceId: run.desktopDeviceId, createdAt: run.createdAt.toISOString(), updatedAt: run.updatedAt.toISOString(), })), } } export async function createAgentSession(input: { userId: string objective: string mode?: string surface?: NovaSurfaceProvider parentSessionId?: string localProjectId?: string | null agentId?: string | null }): Promise { const organizationId = await ensureUserOrganization(input.userId) const membership = await membershipForUser(input.userId, organizationId) const objective = input.objective.trim() if (!objective) throw new Error("Session objective is required") const surfaceProvider = input.surface === "desktop" ? "desktop" : "web" return prisma.$transaction(async (tx) => { const parent = input.parentSessionId ? await tx.agentSession.findFirst({ where: { id: input.parentSessionId, organizationId }, select: { id: true, parentSessionId: true, localProjectId: true, agentId: true, localWorkspaceBinding: true } }) : null if (input.parentSessionId && !parent) throw new Error("Parent thread not found") if (parent?.parentSessionId) throw new Error("Create side threads from the main thread") if (parent?.localWorkspaceBinding) throw new Error("Start a separate worktree thread for parallel local Git work; side conversations are not supported for local worktree threads yet") const requestedAgentId = parent?.agentId ?? input.agentId ?? null if (requestedAgentId) { const agent = await tx.novaAgent.findFirst({ where: { id: requestedAgentId, organizationId, ownerUserId: input.userId, status: "active" }, select: { id: true } }) if (!agent) throw new Error("Agent not found") } const requestedProjectId = parent ? parent.localProjectId : input.localProjectId let localProjectId: string | null = null if (requestedProjectId) { const project = await tx.webLocalProject.findFirst({ where: { id: requestedProjectId, userId: input.userId, organizationId, status: "active", }, select: { id: true }, }) localProjectId = project?.id ?? null } const session = await tx.agentSession.create({ data: { organizationId, initiatorMembershipId: membership.id, objective, mode: input.mode?.trim() || "agent", nextSequence: 2, parentSessionId: parent?.id ?? null, agentId: requestedAgentId, localProjectId, }, }) if (localProjectId) { await tx.webLocalProject.update({ where: { id: localProjectId }, data: { lastUsedAt: new Date() }, }) } const surface = await tx.sessionSurface.create({ data: { agentSessionId: session.id, provider: surfaceProvider, surfaceKey: `${organizationId}:${surfaceProvider}:${session.id}`, externalSurfaceId: session.id, status: "active", }, }) await tx.agentActivity.create({ data: { agentSessionId: session.id, surfaceId: surface.id, sequence: 1, type: "acknowledgement", status: "created", title: "Nova session created", body: objective, }, }) await tx.novaAuditEvent.create({ data: { organizationId, agentSessionId: session.id, actorType: "membership", actorId: membership.id, action: "nova.session.create", resourceType: "agent_session", resourceId: session.id, decision: "allowed", }, }) const complete = await tx.agentSession.findUniqueOrThrow({ where: { id: session.id }, include: { surfaces: true }, }) return serializeSession(complete) }) } export async function ensureSessionSurface(input: { userId: string sessionId: string provider: NovaSurfaceProvider }) { const organizationId = await ensureUserOrganization(input.userId) await membershipForUser(input.userId, organizationId) const session = await prisma.agentSession.findFirst({ where: { id: input.sessionId, organizationId }, select: { id: true }, }) if (!session) return null const surfaceKey = `${organizationId}:${input.provider}:${session.id}` const existing = await prisma.sessionSurface.findUnique({ where: { surfaceKey } }) if (existing) { if (existing.status === "archived") { return prisma.sessionSurface.update({ where: { id: existing.id }, data: { status: "active" }, }) } return existing } try { return await prisma.sessionSurface.create({ data: { agentSessionId: session.id, provider: input.provider, surfaceKey, externalSurfaceId: session.id, status: "active", }, }) } catch (error) { if (error && typeof error === "object" && "code" in error && error.code === "P2002") { return prisma.sessionSurface.findUniqueOrThrow({ where: { surfaceKey } }) } throw error } } export type PostedSessionMessage = { message: { id: string sessionId: string surfaceId: string | null sequence: number role: "user" content: string senderType: "member" senderId: string createdAt: string references?: NovaReference[] localAttachments?: LocalAttachmentMeta[] } runId: string surfaceId: string latestSequence: number replayed?: boolean } export async function postSessionMessage(input: { userId: string sessionId: string content: string clientMessageId?: string surface?: NovaSurfaceProvider references?: NovaReference[] localAttachments?: LocalAttachment[] }): Promise { const content = input.content.trim() if (!content) throw new Error("Message content is required") if (content.length > 20_000) throw new Error("Message is too long") const organizationId = await ensureUserOrganization(input.userId) const membership = await membershipForUser(input.userId, organizationId) const surfaceProvider = input.surface === "desktop" ? "desktop" : "web" const surface = await ensureSessionSurface({ userId: input.userId, sessionId: input.sessionId, provider: surfaceProvider, }) if (!surface) return null const clientMessageId = input.clientMessageId?.trim() || null const localAttachmentMeta = (input.localAttachments ?? []).map(toLocalAttachmentMeta) return prisma.$transaction(async (tx) => { await tx.$queryRaw`SELECT id FROM agent_session WHERE id = ${input.sessionId} AND "organizationId" = ${organizationId} FOR UPDATE` if (clientMessageId) { const existing = await tx.agentSessionMessage.findFirst({ where: { agentSessionId: input.sessionId, surfaceId: surface.id, externalId: clientMessageId, }, select: { id: true, sequence: true, content: true, createdAt: true, agentSession: { select: { nextSequence: true, activeRunId: true } }, metadata: true, }, }) if (existing) { return { message: { id: existing.id, sessionId: input.sessionId, surfaceId: surface.id, sequence: existing.sequence, role: "user", content: existing.content, senderType: "member", senderId: membership.id, createdAt: existing.createdAt.toISOString(), references: referencesFromMetadata(existing.metadata), localAttachments: localAttachmentsFromMetadata(existing.metadata), }, runId: existing.metadata && typeof existing.metadata === "object" && !Array.isArray(existing.metadata) && typeof existing.metadata.runId === "string" ? existing.metadata.runId : "", replayed: true, surfaceId: surface.id, latestSequence: Math.max(0, existing.agentSession.nextSequence - 1), } } } const locked = await tx.agentSession.findFirst({ where: { id: input.sessionId, organizationId }, select: { id: true, status: true }, }) if (!locked) return null const messageSeq = await tx.agentSession.update({ where: { id: locked.id }, data: { nextSequence: { increment: 1 }, status: locked.status === "sleeping" ? "active" : locked.status, updatedAt: new Date(), }, select: { nextSequence: true }, }) const message = await tx.agentSessionMessage.create({ data: { agentSessionId: locked.id, surfaceId: surface.id, sequence: messageSeq.nextSequence - 1, role: "user", content, senderType: "member", senderId: membership.id, externalId: clientMessageId, metadata: { provider: surfaceProvider, clientMessageId, references: input.references ?? [], localAttachments: localAttachmentMeta, }, }, select: { id: true, sequence: true, content: true, createdAt: true }, }) await tx.sessionSurface.update({ where: { id: surface.id }, data: { lastInboundAt: new Date() }, }) const run = await tx.agentRun.create({ data: { agentSessionId: locked.id, status: "queued", executionTarget: "none", policySnapshot: { mode: "web_engineer", toolsAllowed: true, mutationsAllowed: false, requiresApproval: false, surface: surfaceProvider, }, startedAt: new Date(), }, select: { id: true }, }) await tx.agentSession.update({ where: { id: locked.id }, data: { activeRunId: run.id }, }) await tx.agentSessionMessage.update({ where: { id: message.id }, data: { metadata: { provider: surfaceProvider, clientMessageId, runId: run.id, references: input.references ?? [], localAttachments: localAttachmentMeta } }, }) const activitySeq = await tx.agentSession.update({ where: { id: locked.id }, data: { nextSequence: { increment: 1 } }, select: { nextSequence: true }, }) await tx.agentActivity.create({ data: { agentSessionId: locked.id, surfaceId: surface.id, runId: run.id, sequence: activitySeq.nextSequence - 1, type: "acknowledgement", status: "working", title: "Nova is working", body: "Gathering context and planning the next step.", data: { phase: "accepted" }, }, }) const latest = await tx.agentSession.findUniqueOrThrow({ where: { id: locked.id }, select: { nextSequence: true }, }) return { message: { id: message.id, sessionId: locked.id, surfaceId: surface.id, sequence: message.sequence, role: "user" as const, content: message.content, senderType: "member" as const, senderId: membership.id, createdAt: message.createdAt.toISOString(), references: input.references ?? [], localAttachments: localAttachmentMeta, }, runId: run.id, surfaceId: surface.id, latestSequence: Math.max(0, latest.nextSequence - 1), } }) } export async function syncAgentSession(input: { userId: string sessionId: string afterSequence: number limit?: number }): Promise { const organizationId = await ensureUserOrganization(input.userId) await membershipForUser(input.userId, organizationId) const session = await prisma.agentSession.findFirst({ where: { id: input.sessionId, organizationId }, select: { id: true, nextSequence: true }, }) if (!session) return null const limit = Math.min(Math.max(input.limit ?? DEFAULT_SYNC_LIMIT, 1), MAX_SYNC_LIMIT) const [messages, activities] = await Promise.all([ prisma.agentSessionMessage.findMany({ where: { agentSessionId: session.id, sequence: { gt: input.afterSequence } }, orderBy: { sequence: "asc" }, take: limit + 1, }), prisma.agentActivity.findMany({ where: { agentSessionId: session.id, sequence: { gt: input.afterSequence } }, orderBy: { sequence: "asc" }, take: limit + 1, }), ]) const selected = [ ...messages.map((value) => ({ kind: "message" as const, sequence: value.sequence, value })), ...activities.map((value) => ({ kind: "activity" as const, sequence: value.sequence, value })), ].sort((a, b) => a.sequence - b.sequence).slice(0, limit) const selectedSequences = new Set(selected.map((item) => item.sequence)) const nextSequence = selected.at(-1)?.sequence ?? input.afterSequence const availableLatest = Math.max(0, session.nextSequence - 1) return { contractVersion: NOVA_CONTRACT_VERSION, sessionId: session.id, afterSequence: input.afterSequence, messages: messages.filter((message) => selectedSequences.has(message.sequence)).map((message) => ({ id: message.id, sessionId: message.agentSessionId, surfaceId: message.surfaceId, sequence: message.sequence, role: message.role as "user" | "assistant" | "system" | "tool", content: message.content, senderType: message.senderType as "member" | "external_user" | "nova" | "system" | null, senderId: message.senderId, createdAt: message.createdAt.toISOString(), references: referencesFromMetadata(message.metadata), localAttachments: localAttachmentsFromMetadata(message.metadata), })), activities: activities.filter((activity) => selectedSequences.has(activity.sequence)).map((activity) => ({ id: activity.id, sessionId: activity.agentSessionId, runId: activity.runId, sequence: activity.sequence, type: activity.type as "acknowledgement" | "plan" | "action" | "approval_request" | "response" | "error" | "result", status: activity.status, title: activity.title, body: activity.body, data: activity.data && typeof activity.data === "object" && !Array.isArray(activity.data) ? activity.data as Record : null, createdAt: activity.createdAt.toISOString(), })), nextSequence, hasMore: nextSequence < availableLatest, } }