The open-source app everyone uses to manage agents at work
TypeScript acpxagent-orchestrationagent-skillsagentic-aiai-agentsai-engineeringai-governanceai-toolsautonomous-agentsclaudeclaude-codeclaude-skillscodexhermesllmmcpmulti-agentopenclawproject-managementworkflow-automation
import { createHash } from "node:crypto";
import { and, desc, eq, inArray } from "drizzle-orm";
import { chatConversations, chatDeliveries, chatEndpoints, chatMessageLinks, type Db } from "@paperclipai/db";
import { githubReviewConfigurationPrompt } from "../../chat-github-review-policy.js";
import type { GitHubReviewPolicy } from "@paperclipai/shared";
/** Only processed, task-bound deliveries can supply review instructions. */
export async function resolveGitHubReviewInstructions(input: {
db: Db; companyId: string; agentId: string; issueId: string; commentIds: string[];
}): Promise<Array<{ key: string; instructions: string }>> {
const rows = await input.db.select({ endpointId: chatEndpoints.id, conversationId: chatConversations.id,
commentId: chatMessageLinks.commentId, event: chatDeliveries.normalizedEvent })
.from(chatMessageLinks)
.innerJoin(chatDeliveries, and(
eq(chatDeliveries.companyId, chatMessageLinks.companyId),
eq(chatDeliveries.endpointId, chatMessageLinks.endpointId),
eq(chatDeliveries.conversationId, chatMessageLinks.conversationId),
eq(chatDeliveries.id, chatMessageLinks.deliveryId),
))
.innerJoin(chatConversations, and(
eq(chatConversations.companyId, chatMessageLinks.companyId),
eq(chatConversations.endpointId, chatMessageLinks.endpointId),
eq(chatConversations.id, chatMessageLinks.conversationId),
))
.innerJoin(chatEndpoints, and(eq(chatEndpoints.companyId, chatConversations.companyId), eq(chatEndpoints.id, chatConversations.endpointId)))
.where(and(
eq(chatMessageLinks.companyId, input.companyId), eq(chatMessageLinks.direction, "inbound"),
eq(chatConversations.issueId, input.issueId), eq(chatEndpoints.assignedAgentId, input.agentId),
eq(chatEndpoints.provider, "github"), eq(chatDeliveries.state, "processed"),
...(input.commentIds.length ? [inArray(chatMessageLinks.commentId, input.commentIds)] : []),
))
.orderBy(desc(chatDeliveries.createdAt), desc(chatDeliveries.id))
.limit(input.commentIds.length || 1);
// A coalesced run is bound to its latest accepted request. Earlier messages
// remain history; do not append their policies after the current policy.
const row = input.commentIds.length
? rows.sort((a, b) => input.commentIds.indexOf(b.commentId!) - input.commentIds.indexOf(a.commentId!))[0]
: rows[0];
if (row) {
const admitted = (row.event.githubAutomatic ?? row.event.githubManual) as {
policy?: GitHubReviewPolicy; revision?: number;
} | undefined;
if (admitted?.policy && Number.isInteger(admitted.revision)) {
const instructions = githubReviewConfigurationPrompt(admitted.policy, admitted.revision!);
const key = createHash("sha256").update(JSON.stringify([row.endpointId, row.conversationId, admitted.revision, instructions])).digest("hex");
return [{ key, instructions }];
}
}
return [];
}