Skip to content

armgit / kaneo

Public Imported from GitHub
0

⚡ Project management that doesn't become the project. Boards, Gantt charts, and GitHub integration. Self-host it or use Kaneo Cloud.

2.2 KB
Raw Blame
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,
  );
}