⚡ Project management that doesn't become the project. Boards, Gantt charts, and GitHub integration. Self-host it or use Kaneo Cloud.
TypeScript honoissue-managementissue-trackerjira-alternativekanbanlinear-alternativemcpproject-managementreactself-hostedtypescript
import { and, eq, inArray } from "drizzle-orm";
import db from "../../../database";
import { externalLinkTable, taskTable } from "../../../database/schema";
import type { GitHubConfig } from "../config";
import { extractTaskNumber } from "../utils/branch-matcher";
import { extractIssueReferences } from "../utils/issue-references";
import { findTaskByLink } from "./task-service";
export async function resolvePullRequestTask({
integrationId,
projectId,
projectSlug,
config,
repositoryUrl,
pullRequest,
database = db,
}: {
database?: Pick<typeof db, "selectDistinct" | "query">;
integrationId: string;
projectId: string;
projectSlug: string;
config: Pick<GitHubConfig, "branchPattern" | "customBranchRegex">;
repositoryUrl: string;
pullRequest: {
number: number;
title: string;
body: string | null;
head: { ref: string };
};
}) {
const taskNumber = extractTaskNumber(
pullRequest.head.ref,
pullRequest.title,
pullRequest.body ?? undefined,
config,
projectSlug,
);
const numberedTask =
taskNumber === null
? undefined
: await database.query.taskTable.findFirst({
where: and(
eq(taskTable.projectId, projectId),
eq(taskTable.number, taskNumber),
),
});
if (numberedTask) return numberedTask;
const issueNumbers = extractIssueReferences(
pullRequest.title,
pullRequest.body,
repositoryUrl,
);
const matches =
issueNumbers.length === 0
? []
: await database
.selectDistinct({ task: taskTable })
.from(externalLinkTable)
.innerJoin(taskTable, eq(taskTable.id, externalLinkTable.taskId))
.where(
and(
eq(externalLinkTable.integrationId, integrationId),
eq(externalLinkTable.resourceType, "issue"),
inArray(externalLinkTable.externalId, issueNumbers),
eq(taskTable.projectId, projectId),
),
)
.limit(2);
if (matches.length > 0) {
return matches.length === 1 ? matches[0]?.task : undefined;
}
return findTaskByLink(
projectId,
[pullRequest.title, pullRequest.body],
database,
);
}